AnsweredAssumed Answered

XML Import NOT Working FMP11 - Help!!

Question asked by MikeGilbertson on Apr 29, 2013
Latest reply on Apr 27, 2016 by ggt667

Title

XML Import NOT Working FMP11 - Help!!

Post

     First...I am not a programmer. That said, I need to import Customer orders received via non-FMP XML. It's just not working and I can't find any documentation to help. What am I doing wrong?

     My XSL;

     <?xml version='1.0' encoding='UTF-8' ?>
     <xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/ XSL/Transform'>
           <xsl:output version='1.0' encoding='UTF-8' indent='no' method='xml' />
           <xsl:template match='/'>
     <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
     <ERRORCODE>0</ERRORCODE>
     <PRODUCT BUILD="01-25-2011" NAME="FileMaker" VERSION="ProAdvanced 11.0v3"/>
     <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="PartSimple Orders.fp7" RECORDS="2" TIMEFORMAT="h:mm:ss a"/>
     <METADATA>
     <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Backorderable" TYPE="TEXT"/>
     <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="BrandName" TYPE="TEXT"/>
     </METADATA>
        <RESULTSET FOUND="">
             <xsl:for-each select="/VendorOrderItems">
         <ROW>
             <COL><DATA><xsl:value-of select="/Backorderable"/></DATA></COL>
             <COL><DATA><xsl:value-of select="/BrandName"/></DATA></COL>
         </ROW>
             </xsl:for-each>
     </RESULTSET></FMPXMLRESULT>
           </xsl:template>
     </xsl:stylesheet>

     CUSTOMER XML

      

<VendorOrders>
<Transmission>
<TransmissionID>9890</TransmissionID>
<SenderID>PARTSIMPLE</SenderID>
<ReceiverID>RAPIDTECH</ReceiverID>
<DateCreated>2013-04-16 17:52:03</DateCreated>
</Transmission>
<VendorOrder>
<CustomerOrderNumber>100009927</CustomerOrderNumber>
<VendorOrderState>N</VendorOrderState>
<Region>USA</Region>
<Currency>USD</Currency>
<RequestedCarrier/>
<RequestedShipService>1</RequestedShipService>
<ShippingAcctNumber>11111</ShippingAcctNumber>
<MustShipComplete>N</MustShipComplete>
<ClientProgram>
<ClientProgramBrand>PartSimple.com</ClientProgramBrand>
<ClientProgramPhone>1-888-399-2787</ClientProgramPhone>
<ClientProgramEmail>help@PartSimple.com</ClientProgramEmail>
<ReturnMessage>Returns Message: All claims for product that is damaged in shipping or missing contents must be made within 5 days of receipt of goods. Returns must be authorized by going to PartSimple.com to obtain a Return Authorization Number. All returned products must be received by the warehouse within 30 days of original shipment</ReturnMessage>
</ClientProgram>
<ShipToAddress>
<ShipToName>Shafi A</ShipToName>
<ShipToCompany/>
<ShipToAddressLine1>216 NORTH MAIN</ShipToAddressLine1>
<ShipToAddressLine2/>
<ShipToCity>JEWETT</ShipToCity>
<ShipToProvince>TX</ShipToProvince>
<ShipToCountry>USA</ShipToCountry>
<ShipToPostalCode>75846</ShipToPostalCode>
<ShipToPhoneNumber>90362644111</ShipToPhoneNumber>
</ShipToAddress>
<VendorOrderItems>
<VendorOrderItem>
<CustomerOrderLineNumber>1</CustomerOrderLineNumber>
<VendorOrderItemState>N</VendorOrderItemState>
<OrderedVendorSKU>2061000</OrderedVendorSKU>
<BrandName>ADAPTEC</BrandName>
<ItemNumber>2061000</ItemNumber>
<ItemCondition>N</ItemCondition>
<Substitutable>Y</Substitutable>
<Backorderable>Y</Backorderable>
<Description>Adaptec 39320A-R RAID Ultra320 SCSI PCI-X 2CH 64bit 1-Pack 2061000</Description>
<Quantity>1</Quantity>
<UnitCost>40.00</UnitCost>
<MustShipComplete>Y</MustShipComplete>
</VendorOrderItem>
</VendorOrderItems>
</VendorOrder>
</VendorOrders>

      

Outcomes