Link to home
Create AccountLog in
Avatar of magento
magento

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
Avatar of Will Loving
Will Loving
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of magento
magento

ASKER

Sorry for the delayed response , i will revert quickly.

Thank you