Re: [xml-dev] XML into a database

["Stephen Green" <stephengreenubl@gmail.com>]

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@gmail.com> 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
>