Skip to content

Instantly share code, notes, and snippets.

@dericed

dericed/transactions_2_dctvfm_order.xsl

Created June 15, 2012 19:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dericed/2938423 to your computer and use it in GitHub Desktop.
Save dericed/2938423 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
transactions_2_dctvfm_order.xsl
<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:str="http://exslt.org/strings" extension-element-prefixes="str" xmlns="http://www.filemaker.com/fmpxmlresult">
<xsl:output encoding="UTF-8" method="xml" version="1.0" indent="yes"/>
<xsl:template match="orders">
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
<ERRORCODE>0</ERRORCODE>
<PRODUCT BUILD="06-18-2009" NAME="FileMaker" VERSION="ProAdvanced 10.0v3"/>
<DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT="h:mm:ss a"/>
<METADATA>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="orderId" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="profileFirstName" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="profileLastName" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="profileOrganization" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="drupalUserID" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="memberId" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="paymentType" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="paymentReceived" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="paymentAmount" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shippingPrice" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="taxAmount" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="dateOfTransaction" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="billingAddress_firstName" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="billingAddress_lastName" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="billingAddress_Company" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="billingAddress_streetOne" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="billingAddress_streetTwo" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="billingAddress_city" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="billingAddress_zone" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="billingAddress_postalCode" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="billingAddress_country" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shippingAddress_firstName" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shippingAddress_lastName" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shippingAddress_Company" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shippingAddress_streetOne" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shippingAddress_streetTwo" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shippingAddress_city" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shippingAddress_zone" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shippingAddress_postalCode" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="shippingAddress_country" TYPE="TEXT"/>
</METADATA>
<RESULTSET FOUND="">
<xsl:for-each select='order'>
<ROW MODID="0" RECORDID="">
<COL><DATA><xsl:value-of select="100000 + number(orderId)"/></DATA></COL>
<COL><DATA><xsl:value-of select="profileFirstName"/></DATA></COL>
<COL><DATA><xsl:value-of select="profileLastName"/></DATA></COL>
<COL><DATA><xsl:value-of select="paymentOrganization"/></DATA></COL>
<COL><DATA><xsl:value-of select="drupalUserID"/></DATA></COL>
<COL><DATA><xsl:choose><xsl:when test="string-length(memberNumber)>0"><xsl:value-of select="memberNumber"/></xsl:when><xsl:otherwise><xsl:value-of select="100000 + number(drupalUserID)"/></xsl:otherwise></xsl:choose></DATA></COL>
<COL><DATA><xsl:value-of select="paymentType"/></DATA></COL>
<COL><DATA><xsl:value-of select="paymentReceived"/></DATA></COL>
<COL><DATA><xsl:value-of select="paymentAmount"/></DATA></COL>
<COL><DATA><xsl:value-of select="shippingPrice"/></DATA></COL>
<COL><DATA><xsl:value-of select="taxAmount"/></DATA></COL>
<COL><DATA><xsl:value-of select="dateOfTransaction"/></DATA></COL>
<COL><DATA><xsl:value-of select="billingAddress/billFirstName"/></DATA></COL>
<COL><DATA><xsl:value-of select="billingAddress/billLastName"/></DATA></COL>
<COL><DATA><xsl:value-of select="billingAddress/billCompany"/></DATA></COL>
<COL><DATA><xsl:value-of select="billingAddress/streetOne"/></DATA></COL>
<COL><DATA><xsl:value-of select="billingAddress/streetTwo"/></DATA></COL>
<COL><DATA><xsl:value-of select="billingAddress/city"/></DATA></COL>
<COL><DATA><xsl:value-of select="billingAddress/zone"/></DATA></COL>
<COL><DATA><xsl:value-of select="billingAddress/postalCode"/></DATA></COL>
<COL><DATA><xsl:value-of select="billingAddress/country"/></DATA></COL>
<COL><DATA><xsl:value-of select="shippingAddress/shipFirstName"/></DATA></COL>
<COL><DATA><xsl:value-of select="shippingAddress/shipLastName"/></DATA></COL>
<COL><DATA><xsl:value-of select="shippingAddress/shipCompany"/></DATA></COL>
<COL><DATA><xsl:value-of select="shippingAddress/streetOne"/></DATA></COL>
<COL><DATA><xsl:value-of select="shippingAddress/streetTwo"/></DATA></COL>
<COL><DATA><xsl:value-of select="shippingAddress/city"/></DATA></COL>
<COL><DATA><xsl:value-of select="shippingAddress/zone"/></DATA></COL>
<COL><DATA><xsl:value-of select="shippingAddress/postalCode"/></DATA></COL>
<COL><DATA><xsl:value-of select="shippingAddress/country"/></DATA></COL>
</ROW>
</xsl:for-each>
</RESULTSET>
</FMPXMLRESULT>
</xsl:template>
</xsl:stylesheet>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment