Exporting as xml
Hello, I currently export a table out as an xml for use with another program. However, when I export the table, not only does the table information get output, but also my user information and app...
Forum Discussion
Thank you for the reply!
Unfortunately this is exactly the function I am using. I use the structured XML, but it still spits out all of my user information and app token. It is just in a structured format.
Unfortunately this is exactly the function I am using. I use the structured XML, but it still spits out all of my user information and app token. It is just in a structured format.
You have to create a XSLT stylesheet and save it in a code page.
They look like this:
However, I doubt there are many people that even know how to do this any more and the feature is rarely used or asked about.
They look like this:
<?xml version="1.0"?>Then you can associate the XSLT stylesheet with (1) a native query or (2) use the xsl parameter with API_DoQuery.
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
version="1.0">
<xsl:key name="LabelToField" match="/qdbif/table/fields/field/@id" use="../label"/>
<xsl:template match="/">
<xsl:apply-templates select="qdbif"/>
</xsl:template>
<xsl:template match="qdbif">
<xsl:apply-templates select="table"/>
</xsl:template>
<xsl:template match="table">
<xsl:apply-templates select="records"/>
</xsl:template>
<xsl:template match="records">
<table border="1">
<tr>
<th>Field1 Heading</th>
<th>Field2 Heading</th>
<th>Field3 Heading</th>
</tr>
<xsl:apply-templates select="record"/>
</table>
</xsl:template>
<xsl:template match="record">
<tr>
<td>
<xsl:value-of select="f[@id=key('LabelToField','Field1')]"/>
</td>
<td>
<xsl:value-of select="f[@id=key('LabelToField','Field2')]"/>
</td>
<td>
<xsl:value-of select="f[@id=key('LabelToField','Field3')]"/>
</td>
</tr>
</xsl:template>
</xsl:stylesheet>
However, I doubt there are many people that even know how to do this any more and the feature is rarely used or asked about.