Recreating message template

[john booth]

I’m trying to recreate and customize a message template (based on 27 - create printed job ticket on new order creation). I noticed that there are fields asking for data that are not supplied by the message template sql.

For example, <xsl:for-each select=”//customizatiionValues/custValue”>,<xsl:for-each select=”//fulfillmentProperties/property”>.

How do I find the queries that generates the missing data? Or how do I see the xml so I’ll know what I need to create my own queries?

[west-digital.fr]

>> Or how do I see the xml so I’ll know what I need to create my own queries?

Based on my tests, this "Identity" stylesheet would return the same XML that it received:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:template match="@*|node()">
    <xsl:copy>
      <xsl:apply-templates select="@*|node()"/>
    </xsl:copy>
  </xsl:template>
</xsl:stylesheet>

Obviously, you want to make a safe backup of the original XSLT, before you overwrite it in uStore Admin :-)

Now, from the "Orders" tab in uStore Admin, clicking the "Download Job Ticket" would return you a so-called ".doc" file which actually contains XML, that could be displayed nicely with any tool like the "XML Tools" extension of Notepad++, per instance:

I must say, though, that I could not see any "CustomizationValue" or "FullfilmentProperties" elements, despite the related Product uses the Customization Wizard. Still some bit of mystery to be solved here...

Good luck and enjoy!

west-digital.fr

[john booth]

Thanks for the help out of the mud.