Cart
|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] schema for translation of xml'ised spreadsheets
 i now need to map values (i suspect that this is a big xsl:choose of some sort). but i would like to generate the xslt programmatically depending on how the luser fills out an html form. in general, it looks like i am transforming one 2d matrix into another and wondered if this type of thing had been done before. it seems to me that i should invent a dtd or schema for a definition of the translation somewhat as follows: <transform default="copy"> <!-- might be delete? --> <rules> <rename oldColumnName="old" newColumnName="new"/> <copy columnName="columnToBeCopied"/> <delete columnName="columnToBeDeleted"/> <generateRecord triggerColumnName="special1"> <newColumn name="newColumName1" value1="field1Value"/> <newColumn name="newColumName2" value2="field2Value"/> <newColumn name="newColumName3" /> <!-- value not defined means copy the field? --> </generateRecord> <map columnName="columnToBeMapped> <pair in="inputValue1" out="outputValue1"> ... <pair in="inputValue42" out="outputValue42"> </map> </rules> </transform> it would seem then that i could read this with jdom and generate the appropriate xslt (like the one below). any pointers or advice will be appreciated. thanks <?xml version="1.0" encoding="UTF-8" ?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:strip-space elements="*"/> <xsl:output method="xml" indent="yes"/> <xsl:template match="/inputRows"> <outputRows><xsl:apply-templates/></outputRows> </xsl:template> <xsl:template match="/inputRows/inputRow"> <xsl:for-each select="child::*"> <xsl:if test="name()='special1' or name()='special2'"> <xsl:apply-templates select="."/> </xsl:if> </xsl:for-each> </xsl:template> <xsl:template match="/inputRows/inputRow/special1"> <xsl:call-template name="generateOutputRecord"> <xsl:with-param name="value1" select="'new1ValueFromSpecial1Name'"/> <xsl:with-param name="value2" select="'new2ValueFromSpecial1Name'"/> </xsl:call-template> </xsl:template> <xsl:template match="/inputRows/inputRow/special2"> <xsl:call-template name="generateOutputRecord"> <xsl:with-param name="value1" select="'new1ValueFromSpecial2Name'"/> <xsl:with-param name="value2" select="'new2ValueFromSpecial2Name'"/> </xsl:call-template> </xsl:template> <xsl:template name="generateOutputRecord"> <xsl:param name="value1" select="defaultValue1"/> <xsl:param name="value2" select="defaultValue2"/> <outputRow> <inputRecordSequenceNumber> <xsl:number count="inputRow"/> </inputRecordSequenceNumber> <xsl:for-each select="../*"> <xsl:call-template name="processField"/> </xsl:for-each> <xsl:call-template name="addNewFields"> <xsl:with-param name="value1" select="$value1"/> <xsl:with-param name="value2" select="$value2"/> </xsl:call-template> </outputRow><xsl:text/> </xsl:template> <xsl:template name="addNewFields"> <xsl:param name="value1" select="defaultValue1"/> <xsl:param name="value2" select="defaultValue2"/> <xsl:element name="new1"><xsl:value-of select="$value1"/></xsl:element> <xsl:element name="new2"><xsl:value-of select="$value2"/></xsl:element> <xsl:element name="new3"><xsl:value-of select="."/></xsl:element> </xsl:template> <xsl:template name="processField"> <xsl:choose> <xsl:when test="name()='special1'"></xsl:when> <xsl:when test="name()='special2'"></xsl:when> <xsl:when test="name()='remove1'"></xsl:when> <xsl:when test="name()='copy1'"> <xsl:element name="{name()}"> <xsl:value-of select="."/> </xsl:element> </xsl:when> <xsl:when test="name()='rename1'"> <xsl:element name="renamed1"> <xsl:value-of select="."/> </xsl:element> </xsl:when> </xsl:choose> </xsl:template> </xsl:stylesheet> --- ray tayek http://tayek.com/ actively seeking mentoring or telecommuting work vice chair orange county java users group http://www.ocjug.org/ hate spam? http://samspade.org/ssw/ XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list 
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! 
Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|
