Import multiple dbf files at one time...

[formula99]

Greetings.

I have a source of data that delivers 8 daily dbf files which I have been importing into my filemaker database. If I get lazy and don't update daily, I can end up with a lot of files! Is there a script or shortcut so that I can 'batch import' a folder of dbf files into my current filemaker database?

I came across this thread

http://fmforums.com/forum/showtopic.php?tid/177446/post/208717

which seems to discuss what I am looking to do, but I am not sure how to implement it.

Could someone give me some step by step advice on how to get something like this to work?

Many thanks!

-Ryan

[Anuviel]

When you go to File and Import it should say:

Import: File or Folder

[sbg2]

yes, but thats only for Movie files or Text files or at least that was the limitation in FM7.

I have attached a brief example of how I originally did this. It worked for my needs but there may be better ways to do this with version 8 and up.

The files must be extracted to the C: root folder in order for the scripts and .vbs file to work (this zip file will create a folder named "~Temp" which hold all the files).

Opening the MyFile.fp7 file & pressing the "Import .dbf files" button will import each file from the folder "C:~TempNEED_Import" and then move the file to the "C:~TempDone" folder.

_Temp.zip

[Anuviel]

I knew that was too easy., I am actually on 7 advanced, never had to import multiple dbf files, waqs not aware of that, will look into it.

[formula99]

I'm going to check out that example, see if it makes sense and report back.

Thanks for you help!