[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: XML into a database
In fact, looking at the tool a bit it seems you may be able to do better than my suggestion if you get to know it a bit better. Still, there is the fallback available to ignore the warnings and edit the XSLT (or write the XSLT by hand in the first place of course). I agree though that such specific tool issues are best taken offlist. -- Stephen Green Partner SystML, http://www.systml.co.uk Tel: +44 (0) 117 9541606 http://www.biblegateway.com/passage/?search=matthew+22:37 .. and voice On 12/06/07, Stephen Green <stephengreenubl@g...> wrote: > Hi David > > What the tools allow is to create an XSLT version of the mapping. > This is handy because you can then hand-edit the XSLT and learn > some XSLT in the process. > > I don't have your database schema (and best to take such detail > off-list) but the XSLT I get looks like this when you just map the > instance to itself > > > ... > <xsl:for-each select="attributes"> > ... > <xsl:for-each select="attribute"> > ... > <xsl:for-each select="attribute-name"> > ... > > Without getting into detail it seems, superficially, you need to duplicate > the XSLT related to 'attribute' and then specialise the XPath of each to > refer in one case to the 'attribute' element with a child 'attribute-name' > equal to 'CountryName' and in the other case to the 'attribute' element > (how I hate this giving an element the name 'attribute :-) with a child > 'attribute-name' equal to 'CountryCode'. Hopefully that should do it but > it needs some care and there may be a few other things like this you'll > want to do too. > > By the way, I notice the tool warns you that changes like this will be > lost on regeneration of the XSLT but personally I'd just choose the > pragmatic approach and accept that you'll have to do the changes > again if you regenerate the XSLT (which maybe you won't have to do > once you learn to write it manually with the tool's help). > > All the best > > Stephen Green > > > Partner > SystML, http://www.systml.co.uk > Tel: +44 (0) 117 9541606 > > http://www.biblegateway.com/passage/?search=matthew+22:37 .. and voice >
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] |
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
|