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

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>?

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

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

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