And what does the output file look like? A random record full FMPXMLRESULT will suffice.
Typically on a mac you would type the following in terminal "xsltproc purpose.xslt input.xml | nc termbin.com 9999' and give us the link that it outputs
Hello, brendan_mc. the "key" is to USE the namespace (as intended and do not try to pre-remove before import). see if this post (the correct answer) helps:
For your XSLT:
1. call and exclude
... xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
2. then use
... xsl:value-of select="proj:Project/ProjectID" />
I just want to get the XML into FMP so I can work with it. In the example I want to import the ProjectID from the XML file into a Text field called Group_ID in the FileMaker Table
Here is the XML output
<?xml version="1.0" encoding="UTF-8" ?>
<PRODUCT BUILD="01-22-2016" NAME="FileMaker" VERSION="ProAdvanced 14.0.5"/>
<DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="Test 7-4-2016.fmp12" RECORDS="59" TIMEFORMAT="k:mm:ss "/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Group_ID" TYPE="TEXT"/>
<ROW MODID="0" RECORDID="1402">
Perfect that works when I used
instead of just
Thanks for you help, much appreciated
yes, sorry, I neglected to push the namespace all the way out in the example
BTW, you could have named the 'shortcut' as p, pr, pt, or project. The point of namespaces is to make the element unique so that the XSLT processor can deal with them correctly. And you may have more than one namespace in source XML, so call each of them but exclude from output by separating with spaces;
"abc def proj zlm"