I'm using FMP 7. I have a folder of 180+ xml files, all with the identical xml format. I'd like to import all the records into my DB.

I have made a script that has the import command. It allows me to add all the file paths for my xml files in the file path box which I have done.

When I run the script, it only imports the first record. IF these were text files, I know I can use the batch import functionality.

Is there a way to either import this batch or somehow loop through and import each file?

The file path box is for storing multiple paths to the same file, not for multiple files.

The only way I see you could batch import is by using a VBscript that will:

- loop through each XML file in your folder

- rename it to a certain name

- tell FM to run the import script (import script set up to import that "certain" name)

- vbscript waits for FM to finish the script and proceeds to the next XML file

I am encountering the same issue. I am trying to import an xml file from a news feed. We were successful in creating a stlyesheet in order to parse the information but can only import one file at a time. At the risk of sounding ignorant, what is a VBscript?