Can I do anything with just an XML file?

[CRoberts]

One of our systems outputs an XML formatted file.

I want to import this into FM Pro 9 and process it for my own needs.

Because the other system was developed by another party a while ago I don't know the XSLT... so can I do anything with just the XML file or is it possible to reverse engineer the XSLT?

Cheers

[Fenton]

An xslt file is built to transform the xml data you get into xml data that FileMaker can import. FileMaker has its own specific form it wants the data, so it can tell what's a record, what's a field, what kind of field, and what date goes in them.

So if you've got the xml, you can build the xslt. How easy that will be depends on how large and complex the xml file, and what your structure is in FileMaker (1 table? multiple related tables?).

Why don't you post the xml file. Please use the Manage Files functionality in the Preview of your post, zip and attach the file rather than just copy/paste into the post (which makes a mess of it).

[CRoberts]

Fenton

I have attached a file for your reference. Appreciate the help. If you need further information, please post.

Cheers

example.xml.zip