Import ALL records from one FM database to another, NOT just found set

Posted on 2005-04-14
Last Modified: 2012-03-15
I've been tasked with updating a solution developed in FM5.5 (staying in 5.5 for now).

I have developed an installer program (not in FM Pro) the customers will use
to put the new solution on their computer.  Before installing the new FM files,
the installer makes a copy of all the database files to be imported into
their respective "new" files after the installation.

The problem I am having is when I call the Import script from the new database, it
only imports the current found set of the old database.  Obviously, the customer may
have had any number of records in the found set (even zero) when they last exited
their solution.

1) There is no script in the old database to "show all records".
2) The solution runs in kiosk mode, so I can't have the customer open
    each DB and hit <ctrl J> (nor would I want to burden them)

Any ideas?
Question by:andersen58
    LVL 19

    Accepted Solution

    Unfortunately, there's not an elegant solution to this problem. The usual procedure is to run a script to show all records before doing the import. The problem is, your existing files don't have such a script. The only option I can think of is to use the Recover command.

    If you know the filenames, you can script a Recover operation on each file, and then import your data from the recovered copy instead of the original file. The recovered copy will default to showing all records. This should be a one-time-only option though, it's really not appropriate as a permanent solution.

    You will want to add a script to each file to show all records so that future upgrades don't need to do this.

    Author Comment

    You, my friend, are a genius!  (As my palm hits my own forehead for not thinking of it!)

    I tried every sort of relationship link I could think of and did manage to script
    getting ALL the files to a zero found set using a weird "non" relationship.  I then called
    an existing script in the files that only had "Show Omitted"  (Why the previous author had
    a script with only "Show Omitted" in it, I'll never know... but it came in handy for me)

    However, I like your Recover idea better.  Not only do I get the data in a
    single found set, in theory, it will "clean up" any problems with the data before
    I import into the new files.  My installer is written in VB, so I can move the files
    around after the fact and rename, etc.

    Great work, thanks.
    LVL 19

    Expert Comment

    Glad I could help!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Suggested Solutions

    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now