Exporting XML Data

[iain]

Is it possible to use an external schema when exporting data from filemaker in xml type.

At the moment I use this command 'fmpro?-db=dbase.fp5&-format=-dso_xml_dtd&-find'

The data needs to be exported using a certain schema - is this possible?

TIA

[RM]

iain,

I'm working on a project that sounds similar to yours. I submit information to the FM db over the web using HTML forms. What I get back is XML. Now, take this next bit of advice with the warning that I'm learning this as I go. The XML response from the FM web companion server needs to be formatted with XSL or XSLT. To this point, I have been receiving the raw XML response and interpreting the error codes. I am just now getting down to teaching myself XSL/XSLT. But from what I've read, it seems the way to go. -RM

[gminder]

Hi,

Do you know a way to export data from FileMaker in order to create an XML file?

Many thanks, Guy

[spragueg]

My answer assumes you have a Schema or DTD from which you can create your header.

You can use FMP to Export XML.

1. You need to setup a header(see the DTD or schema to get the right format) in a global field and a footer in another.

2. Create a field to hold you data. Create 2 dummy records and paste the header in you data field of one and the footer in the data field of the other.

3. Set up a calc in each record that displays your data in XML format and put it in the data field

To display a field called idNumber:

"<idNumber>"&idNumber&"</idNumber>"

4. Sort your database so the header goes to the top and the footer goes to the bottom and then export as cvs.

It worked great for my database. Let me know if have not explained it clearly.

Thanks,

Graham

[ February 12, 2002, 07:18 AM: Message edited by: spragueg ]