Hi, I have about 100 seperate fp7 files in a folder and need to import
them all into a single filemaker db.
Is this possible

Thanks

On 6 Mar, 21:01, asimon... (AT) gmail (DOT) com wrote:
If they all have numerical sequence names, you can use a script
similar to the following:

Set Variable [$count; Value:1]
Set Variable [$total; Value:100]
Loop
Set Variable [$import,Value:"file:../Desktop/Test/Imp_" & $count &
".fp7"]
Import Records [No Dialog; "$import"; Add; Windows ANSI]
Set Variable [$count; value:$count + 1]
Exit Loop If [$cout = $total + 1]
End Loop
Show All Records
Show Custom Dialog ["Imported " & $total & " Records."]

It will import all files called Imp_1.fp7 to Imp_100.fp7 from a folder
called Test on the Desktop. Obviusly you can change the file path,
name and number.

Hope that works out for you.

Thanks, I may have to come up with another way to name these files
Right now the way it works is that since I couldn't get filemaker to
generate unique names for the export, I had filemaker call an external
script (VBS) that renames the file that filemaker exports to the
current date and time plus host name (dems311-3-4-2007-1-14-43AM.fp7)
to avoid the records from getting overwritten.

I could draw the name from a prepopulated list sequentially only
problem is I update this program a lot and it's on about 10 different
machines all coming into one DB


thanks