Jump to content

import xml batch


NancyL
 Share

This topic is 5713 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 5713 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.