Can someone Please help me to get the row as the are in 0125.xml

 

//Marie

 

 

 

 

<?xml version="1.0"?>

<xsl:stylesheet version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

xmlns:FMP=http://www.filemaker.com/fmpdsoresult

xmlns:ns0=http://xxx.yyy.zzz_1_00

exclude-result-prefixes="FMP">

<xsl:output version="1.0"

method="xml"

omit-xml-declaration="no"/>

<xsl:template match="FMP:FMPDSORESULT">

<ns0:Orderrespons>

<ns0:OrderResposeHeader>

<ns0:OrderResposeNumber>

<xsl:value-of select='FMP:ROW/FMP:OrderResposeNumber'/>

</ns0:OrderResposeNumber>

</ns0:OrderResposeHeader>

<xsl:for-each select="FMP:ROW">

<ns0OrderResponseLine>

<ns0:LineNumber>

<xsl:value-of select='FMP:LineNumber'/>

</ns0:LineNumber>

<ns0:ProductID>

    <ns0:ProductIDType>

<xsl:value-of select='FMP:ProductIDType'/>

</ns0:ProductIDType>

<ns0:Identifier>

<xsl:value-of select='FMP:Identifier'/>

</ns0:Identifier>

    </ns0:ProductID>

     <ns0:Substitute>

<xsl:value-of select='FMP:Substitute'/>

</ns0:Substitute>

</ns0OrderResponseLine>

</xsl:for-each>

<ns0:OrderResponseTail>

         <ns0:NumberOfLines>

<xsl:value-of select='FMP:ROW/FMP:NumberOfLines'/>

</ns0:NumberOfLines>

     <ns0:UnitsShipping>

<xsl:value-of select='FMP:ROW/FMP:UnitsShipping'/>

</ns0:UnitsShipping>

</ns0:OrderResponseTail>

</ns0:Orderrespons>

</xsl:template>

</xsl:stylesheet>

0125.xml

Automatic message

This topic has been moved from "FileMaker Pro 11" to "Importing & Exporting".

Can someone Please help me to get the row as the are in 0125.xml

 

Your request is not clear. Are you trying to export from Filemaker and get a result that matches the format of the attached file?

 

Note that the attached file is not a valid XML file - for example, there is a <ns0:Substitute> element that isn't closed anywhere.

Hi again,

 

Thank You for moving me to export & import.

 

My problems are that i need to have only "<?xml version="1.0"?>" at the first line and

"<ns0:xxxx PurchaseOrderNumber="111" BuyerEAN="222" SupplierShortName="333" SupplierEAN="444"/> " at the third line.

 

The information on line 3 are picked up from the data.basePurchaseOrderNumber="111"

BuyerEAN="222".........

 

This is the result i get now:

<?xml version="1.0" encoding="UTF-8"?>
-<ns0:Orderrespons xmlns:ns0="http://xxx.yyy.zzz_1_00">

-<ns0:OrderResposeHeader>

<ns0:OrderResposeNumber>1</ns0:OrderResposeNumber>

</ns0:OrderResposeHeader>

-<ns0:OrderResponseLine>

<ns0:LineNumber>3</ns0:LineNumber>

-<ns0:ProductID>

<ns0:ProductIDType>kkk</ns0:ProductIDType>

<ns0:Identifier>1213</ns0:Identifier>

</ns0:ProductID>

</ns0:OrderResponseLine>

-<ns0:OrderResponseTail>

<ns0:NumberOfLines>1</ns0:NumberOfLines>

<ns0:UnitsShipping>4</ns0:UnitsShipping>

</ns0:OrderResponseTail>

</ns0:Orderrespons>

0125xmlresult.xml

0125.zip

database0125.zip

Please,

 

Can anyone give me an idea where i can read about how to solve my problem, Please!!