asked on

Filemaker xsl help please

Hi ,

When i do an export from filemaker , i am getting the below xml data.

<?xml version="1.0" encoding="UTF-8" ?><FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"><ERRORCODE>0</ERRORCODE><PRODUCT BUILD="01-09-2015" NAME="FileMaker" VERSION="Pro 13.0v5"/><DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="GunsAmmoCatalog-02.fmp12" RECORDS="9" TIMEFORMAT="h:mm:ss a"/><METADATA>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="_NetworkID" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="_SharedSecret" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="_deploymentMode" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="orderid" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="orderdate" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="_orderType" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shipaddress1" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shipaddress2" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shipcity" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shipfirstname" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shiplastname" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="OrderDetails_MTR::quantity" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="OrderDetails_MTR::productcode" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="OrderDetails_MTR::vendor_price" TYPE="TEXT"/>
</METADATA>
<RESULTSET FOUND="1"><ROW MODID="2" RECORDID="8">
<COL><DATA>85768</DATA></COL>
<COL><DATA>xxxx</DATA></COL>
<COL><DATA>test</DATA></COL>
<COL><DATA>8</DATA></COL>
<COL><DATA>3/24/2015 5:30:00 PM</DATA></COL>
<COL><DATA>NEW</DATA></COL>
<COL><DATA>953 Trents Mill Road</DATA></COL>
<COL><DATA></DATA></COL>
<COL><DATA>Cumberland</DATA></COL>
<COL><DATA>Barry</DATA></COL>
<COL><DATA>Rickert</DATA></COL>
<COL><DATA>1</DATA></COL>
<COL><DATA>10124S</DATA></COL>
<COL><DATA>447</DATA></COL>
</ROW>
</RESULTSET>
</FMPXMLRESULT>

Open in new window

I want them to create an html as below using an XSl file, please help on creating an XSL file which produce the below html format.Some fields are constants , i will add them later.

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<style type="text/css">body,table,td {font: 11px Verdana; color: #000000;}</style>
<body text="#000000">
<table width="650" border="1" cellspacing="0" cellpadding="20" bgcolor="#FFFFFF" bordercolor="#CCCCCC" align="center">
  <tr>
    <td>
      <table width="100%" border="0" cellspacing="1" cellpadding="5">
        <tr valign="top"> 
          <td><a href="../../Default.asp">$(CompanyLogo)</a></td>
		  <td align="right">CustomerID# $(CustomerID)</td>
		</tr>
	  </table>
	  <br>
      <br>
      Thank you for your order. Your order number is $(OrderNo), placed $(OrderDate)
      at $(OrderTime). <br>
      <br>
      <table width="100%" border="0" cellspacing="1" cellpadding="5">
        <tr valign="top"> 
          <td><b>Bill To:</b><br> <br>
            $(Bill_CompanyName) $(Bill_FirstName)&nbsp;$(Bill_LastName)<br>
            $(Bill_Address1)<br>
            $(Bill_Address2) $(Bill_City), $(Bill_State)&nbsp;$(Bill_PostalCode) 
            <br>
            $(Bill_Country) <br>
            $(Bill_PhoneNumber)<br>
			$(EmailAddress)<br>
			<br></td>
          <td><b>Ship To:</b><br> <br>
            $(Ship_CompanyName) $(Ship_FirstName)&nbsp;$(Ship_LastName)<br>
            $(Ship_Address1)<br>
            $(Ship_Address2) $(Ship_City), $(Ship_State)&nbsp;$(Ship_PostalCode) 
            <br>
            $(Ship_Country) <br>
            $(Ship_PhoneNumber) <br> </td>
        </tr>
        <tr valign="top"> 
          <td><b>Payment Info:</b> <br> <br>
            $(DisplayPaymentMethod)<br> <br> </td>
          <td><b>Shipping Method:</b><br> <br>
            $(ShippingMethod)<br> </td>
        </tr>
        <tr valign="top"> 
          <td colspan="2"><b>Order Details:</b><br> <br>
            $(OrderDetails) <br> </td>
        </tr>
      </table>

$(Order_Comments)
$(Custom_Fields)
      <br>
      Thank you for shopping at $(StoreName)!<br>
      Visit us again at <a href="$(HomeURL)">$(HomeURL)</a></td>
  </tr>
</table>
</body>
</html>

Open in new window

Thanks

SOLUTION