| :: XML Schema :: (7) | Post a New Message | Post a Reply |
 XML Schema | Post a Reply |
from: East Coast, USA
<?xml version="1.0" encoding="ISO-8859-1" ?>
- <dataset>
- <datacolumns>
<datacolumn name="TDS" type="202" size="50" />
<datacolumn name="LastName" type="202" size="50" />
<datacolumn name="FirstName" type="202" size="50" />
<datacolumn name="ProgramEntered" type="202" size="50" />
<datacolumn name="AdmitDate" type="7" size="8" />
<datacolumn name="DischargeDate" type="7" size="8" />
<datacolumn name="RecdClosureSummary" type="202" size="50" />
</datacolumns>
Can I change 'datacolumn name' to 'element name'?
with no definition of the data field other than 'datacolumn name', which is useless to upload to our other systems.
Regards,
Ryan
 Re: XML Schema | Post a Reply |
from: Washington, DC
e.g.
objWiz.XslExportTemplate = "dataexport.xsl" -------------------------
Ghost
| Re: XML Schema | Post a Reply |
from: East Coast, USA
| Re: XML Schema | Post a Reply |
from: Laurel, MD
dataexport.xsl
---------------------------------------------------------------------------------------------------
<xsl:stylesheet version = '1.0' xmlns:xsl = 'http://www.w3.org/1999/XSL/Transform'>
<xsl:template match = '/'>
<xsl:apply-templates />
</xsl:template>
<xsl:template match = 'table'>
<dataset>
<xsl:if test = 'count(/table/theader/tr/th) > 0'>
<datacolumns>
<xsl:for-each select = 'theader/tr'>
<xsl:for-each select = 'th'>
<element name = '{.}' type = '{@type}' size = '{@size}' />
</xsl:for-each>
</xsl:for-each>
</datacolumns>
</xsl:if>
<datarows>
<xsl:for-each select = 'tbody/tr'>
<datarow>
<xsl:for-each select = 'td'>
<xsl:variable name = 'pos' select = 'position()' />
<datacolumn>
<xsl:if test = 'count(/table/theader/tr/th) > 0'>
<xsl:attribute name = 'name'>
<xsl:value-of select = 'ancestor::table/theader/tr/th[$pos]/text()' />
</xsl:attribute>
</xsl:if>
<xsl:value-of select = '.' />
</datacolumn>
</xsl:for-each>
</datarow>
</xsl:for-each>
</datarows>
</dataset>
</xsl:template>
</xsl:stylesheet>
<xsl:template match = '/'>
<xsl:apply-templates />
</xsl:template>
<xsl:template match = 'table'>
<dataset>
<xsl:if test = 'count(/table/theader/tr/th) > 0'>
<datacolumns>
<xsl:for-each select = 'theader/tr'>
<xsl:for-each select = 'th'>
<element name = '{.}' type = '{@type}' size = '{@size}' />
</xsl:for-each>
</xsl:for-each>
</datacolumns>
</xsl:if>
<datarows>
<xsl:for-each select = 'tbody/tr'>
<datarow>
<xsl:for-each select = 'td'>
<xsl:variable name = 'pos' select = 'position()' />
<datacolumn>
<xsl:if test = 'count(/table/theader/tr/th) > 0'>
<xsl:attribute name = 'name'>
<xsl:value-of select = 'ancestor::table/theader/tr/th[$pos]/text()' />
</xsl:attribute>
</xsl:if>
<xsl:value-of select = '.' />
</datacolumn>
</xsl:for-each>
</datarow>
</xsl:for-each>
</datarows>
</dataset>
</xsl:template>
</xsl:stylesheet>
-------------------------
Master of the Game
| Re: XML Schema | Post a Reply |
from: East Coast, USA
Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'XslExportTemplate'
I created the template as you mentioned in an earlier post, but I have the above error and the page will not display.
Thansk,
Ryan
| Re: XML Schema | Post a Reply |
from: Washington, DC
Do not repair - uninstall the previous version and install the new version.
I'm not sure but I think this is because repairing only fixes only what was on the original dll and will not add any new features.
-------------------------
Ghost
| Re: XML Schema | Post a Reply |
from: East Coast, USA
Thanks,
Ryan