I just got tasked with importing xml files into filemaker. Each file will is equal to one record in Filemaker that will need to be updated. The xml files will be updated every time something is changed on their end.
I am a total newbie at this but do know I have to create a XSLT Stylesheet to transform it. I created a new file to learn the basics on this with just 4 fields in it, Customer, JobDiscription, JobNumb and Printer. The first problem is several of the field seem to have multiple instances in the XML and I am not sure how to get the one I want.
This is a sample of the xml document with the 4 item I want to print highlighted in yellow. Both customer and printer are in different repetitions of CustomerInfo.
Here is the start of the code I have. Can someone help me out a little?
<?xml version='1.0' encoding='UTF-8'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<?xml version="1.0" encoding="UTF-8"?>
<FIELD NAME="Customer" TYPE="TEXT" MAXREPEAT="1" EMPTYOK="YES"/>
<FIELD NAME="JobDiscription" TYPE="TEXT" MAXREPEAT="1" EMPTYOK="YES"/>
<FIELD NAME="JobNumb" TYPE="NUMBER" MAXREPEAT="1" EMPTYOK="YES"/>
<FIELD NAME="Printer" TYPE="TEXT" MAXREPEAT="1" EMPTYOK="YES"/>