XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Craig BermanSubject: XSLT and MS Access 2007 Optional Tags
Author: Craig Berman
Date: 31 Dec 2008 01:25 PM
I'm sure I'm doing something wrong, or missing a keyword someplace, but here goes. I have something that normally looks like this:
<Trade>
<ID>12345</ID>
<MYNOTES>
<NOTES>
<INDEX>1</INDEX>
<XNOTE>THIS IS NOTE 1</XNOTE>
</NOTES>
<NOTES>
<INDEX>2</INDEX>
<XNOTE>THIS IS NOTE 2</XNOTE>
</NOTES>
</MYNOTES>
<CUSIP>123456789</CUSIP>
</Trade>

The XSL I have works fine, and handles the multiple notes in MYNOTES just fine too (i'm actually please with stylus for getting a novice like me through that). Now, every once in a while I get a XML record with NO MYNOTES at all. How do I change the XSL to declare that this may happen sometime. I presume there is something in the for-each select statement, but right now access gets "annoyed" at not having anything.

If I haven't given you enough information, i apologize, the actual piece of data is pretty big, as is the xsl. If needed, though, I can get it.
Many thanks.
Craig

Postnext
Alberto MassariSubject: XSLT and MS Access 2007 Optional Tags
Author: Alberto Massari
Date: 05 Jan 2009 08:40 AM
Hi Craig,
could you post at least the snippet of XSL that does the xsl:for-each? From your description it's not clear what is generated inside the for-each.

Thanks,
Alberto

Postnext
Craig BermanSubject: XSLT and MS Access 2007 Optional Tags
Author: Craig Berman
Date: 05 Jan 2009 08:51 AM
Okay, here goes:

<xsl:template match="/">
<TradeTable>
<ShortNoteData>
<xsl:for-each select="a:BatchFeed/a:TradeFeed/a:Common/a:ShortNotes/a:ShortNote">
<Trade_ShortNotes>
<Index>
<xsl:value-of select="a:Index"/>
</Index>
<Text>
<xsl:value-of select="a:Text"/>
</Text>
<TransactionNumber>
<xsl:value-of select="../../a:TransactionNumber"/>
</TransactionNumber>
<AsOfTradeDate>
<xsl:value-of select="../../a:AsOfTradeDate"/>
</AsOfTradeDate>
<TransactionType>
<xsl:value-of select="../../a:TransactionType"/>
</TransactionType>
</Trade_ShortNotes>
</xsl:for-each>
</ShortNoteData>

In access this creates a table called Trade_ShortNotes, which contains the fields above. The entire XSLT creates a bunch of tables. The problem occurs when I load a pile of XML, but none of the records contains the tag <ShortNotes>... if *any* record in a batch contains the shortnote tage then I'm fine, if NONE do, then it seems to want to create a blank root name table ie: TradeTable, and put nothing in it. This may be an access quirk, and I'll admit, this is a rarity based upon the data - but if there is a way to specify to XSL - "Hey, here's how to deal with this tag, but you might not see it at all", I'd like to do that.

Postnext
Craig BermanSubject: XSLT and MS Access 2007 Optional Tags
Author: Craig Berman
Date: 05 Jan 2009 08:55 AM
Here's some sample data, just in case:
<ShortNotes>
<ShortNote>
<Index>1
</Index>
<Text>AE= </Text>
</ShortNote>
<ShortNote>
<Index>2
</Index>
<Text>US17313UAA79
</Text>
</ShortNote>
<ShortNote>
<Index>4</Index>
<Text>D#0015 </Text>
</ShortNote>
</ShortNotes>

Posttop
Alberto MassariSubject: XSLT and MS Access 2007 Optional Tags
Author: Alberto Massari
Date: 05 Jan 2009 11:58 AM
Hi Craig,
you can try a block like this

<xsl:choose>
<xsl:when test="not(a:BatchFeed/a:TradeFeed/a:Common/a:ShortNotes/a:ShortNote)">
<Trade_ShortNotes>
<Index/>
<Text/>
<TransactionNumber/>
<AsOfTradeDate/>
<TransactionType/>
</Trade_ShortNotes>
</xsl:when>
<xsl:otherwise>
<xsl:for-each select="a:BatchFeed/a:TradeFeed/a:Common/a:ShortNotes/a:ShortNote">
....
</xsl:for-each>
</xsl:otherwise>
</xsl:choose>

I don't know what you need to put in the empty fields to force Access to still generate the correct column types, but at least it should get you started.

Hope this helps,
Alberto

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.