BizTalk Server General - Sort the node in the mapping without xsl

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > October 2004 > Sort the node in the mapping without xsl





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Sort the node in the mapping without xsl
Denis D

2004-10-25, 5:49 pm


Hi,

I need to sort the node in my mapping but i can't do it wint the mapper of
Biztalk 2004.

I can do it with the external xslt but after i can't access on the my
database
with a script.

Do you know a solution about my problem ?

Thanks
Denis
Balaji Thiagarajan

2004-10-25, 5:49 pm

In the past, I used 2 maps inside the Construct Shape to overcome a similar
situation. The first map with external xslt and the 2nd map with BizTalk
Mapper. You can try a similar workaround.

--
Balaji Thiagarajan
MCP (BizTalk)
http://biztalkbits.blogspot.com
--

"Denis D" <Denis D@discussions.microsoft.com> wrote in message
news:441C6B01-BFC4-49C0-B1ED-24B19D1654AB@microsoft.com...
>
> Hi,
>
> I need to sort the node in my mapping but i can't do it wint the mapper

of
> Biztalk 2004.
>
> I can do it with the external xslt but after i can't access on the my
> database
> with a script.
>
> Do you know a solution about my problem ?
>
> Thanks
> Denis



Greg Forsythe

2004-10-25, 5:49 pm

You can call any script from an external XSLT just as you can from a Map
file.
The Biztalk Mapper generates an XSLT file that is used in the transform.
The Custom XSLT Path option allows you override the XSLT file that is used.

What I have done is create the map using the Biztalk Mapper, including all
scripts.
"Validate" the map - this will output the XSLT into a file.
Copy this file into the project directory and add to the project. Edit the
<xsl:for-each> loop to add the <xsl:sort> nodes.
Update the map to use the new XSLT file using the Custom XSLT Path.
If you are using .NET assemblies in the map you may also need to create a
Custom Extension Xml file.

Greg


"Denis D" <Denis D@discussions.microsoft.com> wrote in message
news:441C6B01-BFC4-49C0-B1ED-24B19D1654AB@microsoft.com...
>
> Hi,
>
> I need to sort the node in my mapping but i can't do it wint the mapper

of
> Biztalk 2004.
>
> I can do it with the external xslt but after i can't access on the my
> database
> with a script.
>
> Do you know a solution about my problem ?
>
> Thanks
> Denis



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com