BizTalk Server Tools - Please HELP - Converting FLAT schema to Hirerachical Schema

Author

Please HELP - Converting FLAT schema to Hirerachical Schema

Bhavin Sanghvi

2004-06-20, 11:10 pm

How can I achive this using BizTalk 2004 mapper.

source schema:

<ORDER>
<ID/>
<DATE/>
<NAME/>
<ITEMNO/>
<ITEMNAME/>
<QTY/>
</ORDER>

DESTINATION Schema:

<ORDER>
<ID/>
<DATE/>
<NAME/>
<ORDERDETAIL>
<ITEMNO/>
<ITEMNAME/>
<QTY/>
</ORDERDETAIL>
</ORDER>

Condition is ... all the detail items with same header MUST come under one
HEADER ELEMENT... At the moment what I get is ...

If there are three record in source ... I get three header with one detail
in each. and what I want is ... if all the three records have same header
then output should have one header and three details..

I hope I have explained clearly... and I want to use BizTalk 2004 mapper to
achieve this.

Any help appriciated....

Thanks. Bhavin

Nikolai @ intergen.co.nz

2004-06-26, 10:53 am

You would probably want to look at using a custom dis assembler component.

The default output for SQL queries using FOR XML will create and output like this and I am pretty sure you can't use any of the mapping tools to sort it out.

Have a look at the SDK and Giles posts on writing custom pipeline components.

http://weblogs.asp.net/gzunino/arch.../13/154819.aspx
http://weblogs.asp.net/gzunino/arch.../14/155763.aspx
http://weblogs.asp.net/gzunino/arch.../14/155772.aspx

"Bhavin Sanghvi" wrote:

> How can I achive this using BizTalk 2004 mapper.
>
> source schema:
>
> <ORDER>
> <ID/>
> <DATE/>
> <NAME/>
> <ITEMNO/>
> <ITEMNAME/>
> <QTY/>
> </ORDER>
>
> DESTINATION Schema:
>
> <ORDER>
> <ID/>
> <DATE/>
> <NAME/>
> <ORDERDETAIL>
> <ITEMNO/>
> <ITEMNAME/>
> <QTY/>
> </ORDERDETAIL>
> </ORDER>
>
> Condition is ... all the detail items with same header MUST come under one
> HEADER ELEMENT... At the moment what I get is ...
>
> If there are three record in source ... I get three header with one detail
> in each. and what I want is ... if all the three records have same header
> then output should have one header and three details..
>
>
> I hope I have explained clearly... and I want to use BizTalk 2004 mapper to
> achieve this.
>
> Any help appriciated....
>
> Thanks. Bhavin
>
>
>
>

Tatyana Yakushev [MSFT]

2004-06-30, 5:54 pm

You have to use scripting functoid and write XSLT yourself.

Thanks,
Tatyana
--------------------
>From: "Bhavin Sanghvi" <sanghvibk@hotmail.com>
>References: <O5vCAKfVEHA.1152@TK2MSFTNGP09.phx.gbl>
>Subject: Please HELP - Converting FLAT schema to Hirerachical Schema
>Date: Sun, 20 Jun 2004 17:28:46 +0530
>Lines: 43
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
>Message-ID: <Omk#t3rVEHA.2544@TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.biztalk.framework,microsoft.public.biztalk.orchestration,microsoft.public.biztalk.sdk,microsoft.public.biztalk.tools
>NNTP-Posting-Host: 151-211-187-203.cable-client.iqara.net 203.187.211.151
>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.orchestration:6633 microsoft.public.biztalk.sdk:2336 microsoft.public.biztalk.tools:3790
microsoft.public.biztalk.framework:3006
>X-Tomcat-NG: microsoft.public.biztalk.tools
>
>How can I achive this using BizTalk 2004 mapper.
>
>source schema:
>
><ORDER>
> <ID/>
> <DATE/>
> <NAME/>
> <ITEMNO/>
> <ITEMNAME/>
> <QTY/>
></ORDER>
>
>DESTINATION Schema:
>
><ORDER>
> <ID/>
> <DATE/>
> <NAME/>
> <ORDERDETAIL>
> <ITEMNO/>
> <ITEMNAME/>
> <QTY/>
> </ORDERDETAIL>
></ORDER>
>
>Condition is ... all the detail items with same header MUST come under one
>HEADER ELEMENT... At the moment what I get is ...
>
>If there are three record in source ... I get three header with one detail
>in each. and what I want is ... if all the three records have same header
>then output should have one header and three details..
>
>
>I hope I have explained clearly... and I want to use BizTalk 2004 mapper to
>achieve this.
>
>Any help appriciated....
>
>Thanks. Bhavin
>
>
>
>

--

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.