Jump to content

XML Import


iacon_tp
 Share

This topic is 4343 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 4343 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.