XML Import

[iacon_tp]

We purchased some hardware in our office that comes with software that outputs data as XML. I have been trying to build an XLST style sheet to import it into a filemaker database but am struggling to get it going. I just cant get my head around the references in the data file, I got a basic style sheet creating the field names but no data comes into the database when created.

Some help and guidance with this would be great. I attached a sample data file that I am trying to import.

flow data.xml

[comment]

It would help knowing what data from the XML do you need to import. It looks like the entire XML document is a single record? Or perhaps multiple records describing different attributes of a single <something>?

[iacon_tp]

I'd be happy to get them as a single record.

[comment]

Try the attached as a starting point.

Note that many of the data elements give you a choice between 'AsTxt' and 'AsVal'. I presume there is a list somewhere to decipher the numerical values, e.g. for:

<FF_PipeOuterdiameter>

<AsTxt>

<UNIT>m</UNIT>

<NOM>0.106</NOM>

</AsTxt>

<AsVal>

<UNIT>2</UNIT>

<NOM>106</NOM>

</AsVal>

</FF_PipeOuterdiameter>

there should be a mapping of "2" to "mm". You will need this to construct your value lists, if you prefer to use the numerical values in your solution.

flowdata.zip

[iacon_tp]

Thanks for your help, this appears to be what I needed!