Importing XML data via a HTTP request

[technojunkie]

I know there has been some previous discussion regarding importing a XML data - but I would be grateful if someone can please take a look at the XSLT & XML files and tell me what I'm doing wrong. I'm new to both XML/XSLT and FM.

The FM7 is residing on OS 9 and is sending the http request thru the network to a windows machine. I'm trying to import a xml data through a HTTP post. The URL is something to the effect of : http://10.0.... &databasename::fieldname

Can someone PLEASE take a look at this and tell me what is wrong... is it the XSLT or the url script request.

Thank you much for your time!

Source XML:

<?xml version="1.0" encoding="UTF-8"?><!--DOCTYPE RFIDRESULT SYSTEM

<RFIDRESULT xmlns="http://www.insync.com//edgeware">

<ERRORCODE>0</ERRORCODE>

<RESULTSET FOUND="1">

<DATA>

<TRANSACTION_ID>7</TRANSACTION_ID>

<TAG_DATA>ID=01.0000B74.00052C.0006000CF, PD=123457,QTY=2,000000000000000000000000::</TAG_DATA>

</DATA>

</RESULTSET>

</RFIDRESULT>

Import XSL:

<?xml version="1.0" encoding="utf-8"?>

<xsl:stylesheet xmlns:a="http://www.insync.com/edgeware" exclude-result-prefixes="c" version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:c="http://www.insync.com//edgeware" xmlns:b=" ">

<xsl:output method="xml"/>

<xsl:template match="/">

<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

<xsl:for-each select="a:RFIDRESULT/a:ERRORCODE">

<ERRORCODE>

<xsl:value-of select="."/>

</ERRORCODE>

</xsl:for-each>

<xsl:for-each select="b:RFIDRESULT/b:ERRORCODE">

<ERRORCODE>

<xsl:value-of select="."/>

</ERRORCODE>

</xsl:for-each>

<PRODUCT NAME="FileMaker Pro" BUILD="05-06-2004" VERSION="7.0v2"/>

<DATABASE TIMEFORMAT="h:mm:ss a" NAME="HPL_Inventory" LAYOUT="" DATEFORMAT="m/d/yyyy">

<xsl:attribute name="Records">

<xsl:value-of select="a:RFIDRESULT/a:RESULTSET/@FOUND"/>

<xsl:value-of select="b:RFIDRESULT/b:RESULTSET/@FOUND"/>

</xsl:attribute>

</DATABASE>

<METADATA>

<FIELD NAME="Serial Number" MAXREPEAT="1" EMPTYOK="YES" TYPE="TEXT"/>

<FIELD NAME="Model" MAXREPEAT="1" EMPTYOK="YES" TYPE="TEXT"/>

</METADATA>

<xsl:for-each select="c:RFIDRESULT/c:RESULTSET">

<RESULTSET>

<xsl:attribute name="FOUND">

<xsl:value-of select="a:RFIDRESULT/a:RESULTSET/@FOUND"/>

<xsl:value-of select="b:RFIDRESULT/b:RESULTSET/@FOUND"/>

</xsl:attribute>

<ROW MODID="11" RECORDID="9">

<COL>

<xsl:for-each select="a:RFIDRESULT/a:RESULTSET/a:DATA/a:TRANSACTION_ID">

<DATA>

<xsl:value-of select="."/>

</DATA>

</xsl:for-each>

<xsl:for-each select="a:RFIDRESULT/a:RESULTSET/a:DATA/a:TAG_DATA">

<DATA>

<xsl:value-of select="."/>

</DATA>

</xsl:for-each>

<xsl:for-each select="b:RFIDRESULT/b:RESULTSET/b:DATA/b:TRANSACTION_ID">

<DATA>

<xsl:value-of select="."/>

</DATA>

</xsl:for-each>

<xsl:for-each select="b:RFIDRESULT/b:RESULTSET/b:DATA/b:TAG_DATA">

<DATA>

<xsl:value-of select="."/>

</DATA>

</xsl:for-each>

<xsl:for-each select="c:DATA/c:TRANSACTION_ID">

<DATA>

<xsl:value-of select="."/>

</DATA>

</xsl:for-each>

<xsl:for-each select="c:DATA/c:TAG_DATA">

<DATA>

<xsl:value-of select="."/>

</DATA>

</xsl:for-each>

</COL>

</ROW>

</RESULTSET>

</xsl:for-each>

</FMPXMLRESULT>

</xsl:template>

</xsl:stylesheet><!-- Stylus Studio meta-information - ©1998-2003 Copyright Sonic Software Corporation. All rights reserved.

<metaInformation>

<scenarios ><scenario default="no" name="Scenario1" userelativepaths="yes" externalpreview="no" url="Bookings1RecordMAR22.xml" htmlbaseurl="" outputurl="" processortype="internal" commandline="" additionalpath="" additionalclasspath="" postprocessortype="none" postprocesscommandline="" postprocessadditionalpath="" postprocessgeneratedext=""/><scenario default="yes" name="Scenario2" userelativepaths="no" externalpreview="no" url="file://c:Documents and SettingsInSyncDesktopvalidateBookings1RecordMAR22.xml" htmlbaseurl="" outputurl="" processortype="internal" commandline="" additionalpath="" additionalclasspath="" postprocessortype="none" postprocesscommandline="" postprocessadditionalpath="" postprocessgeneratedext=""/></scenarios><MapperInfo srcSchemaPath="..Apple TestingInSync.xml" srcSchemaRoot="RFIDRESULT" srcSchemaPathIsRelative="yes" srcSchemaInterpretAsXML="no" destSchemaPath="Bookings1RecordMAR22.xml" destSchemaRoot="FMPXMLRESULT" destSchemaPathIsRelative="yes" destSchemaInterpretAsXML="no"/>

</metaInformation>

-->

Source XML:

<?xml version="1.0" encoding="UTF-8"?>

<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

<ERRORCODE>0</ERRORCODE>

<PRODUCT BUILD="05-06-2004" NAME="FileMaker Pro" VERSION="7.0v2"/>

<DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="HPL_Inventory" RECORDS="13179" TIMEFORMAT="h:mm:ss a"/>

<METADATA>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Model" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Code" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Checked Out To" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Status" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="City" TYPE="TEXT"/>

</METADATA>

<RESULTSET FOUND="1">

<ROW MODID="11" RECORDID="9">

<COL>

<DATA>RM345YX3P22</DATA>

</COL>

<COL>

<DATA>926</DATA>

</COL>

<COL>

<DATA>Bob</DATA>

</COL>

<COL>

<DATA>Doesn't work</DATA>

</COL>

<COL>

<DATA>XYZ</DATA>

</COL>

</ROW>

</RESULTSET>

</FMPXMLRESULT>