Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Importing XML data via a HTTP request

Featured Replies

  • Newbies

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>

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.