IWP/CWP XML batch import

[frier]

Hello,

Is there a possibility to batch import xml files in IWP or CWP (i.e. without using the filemaker client)?

Thanks!

frier

[Wim Decorte]

Not in IWP. With CWP you can push data into FMSA, but not a regular import like you're used to with FM Pro client.

FMSA has an XML and xDBC interface so you can use that to push data into FMSA...

Can you describe a bit more what you want to accomplish?

[frier]

I am trying to import records stored in XML files (data coming from another database and updated several times a day). I already created the XSLT file for that. The import has to be done automatically, either when a user logs on over IWP or just several times a day. The users only will have web-based access, so I can't run an import script (the Import script step is not web-compatible).

[Wim Decorte]

No you can't use the import script step. Do you have any programming skills that you could use to write something that would read your XML file sand push that data record by record into FMSA (through the XML or xDBC interface)?

Or you can set up a robot machine with regular FileMaker Pro on it to import the data.

[blueboy21]

Dear Wim,

Is there any article or example showing that ? It would be great! I just wanna see starting points.

Or can you write its steps about how to do that?

Thank you!