|
Home > Archive > BizTalk Server Tools > May 2004 > Positional Mapping Issue
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 |
Positional Mapping Issue
|
|
|
| Hi Group,
I am currently using BTS 2002 and I am mapping a positional file to an XML Spec.
The source (Pos file) can hold for example two sets of contact information i.e Firstname1, Lastname1, firstname2...etc
The destination spec (XML Schema) for example the Person_Details has only one lot of information for both incoming lots of data ie First name, Last name. I have tried to use a looping functoid with different combinations, but I am hesitant to waste anymo
re time if this is not possible. If someone out there can understand what I am meaning and has got around this before then any information would be much appreciated.
Thanks in Advance...
Baz.
| |
| Tatyana Yakushev[MSFT] 2004-05-11, 8:21 pm |
| You are going the right direction!
You have to use looping functoid to map flat structure to the repeating structure.
See the example attached (I'm attaching screenshot of the map and BTS2004 files. Sorry, I don't have BTS2002 installed.)
Tatyana
--------------------
>Thread-Topic: Positional Mapping Issue
>thread-index: AcQ0PzwlGrFmk0/+TzWyoQO9CLiM4Q==
>X-WN-Post: microsoft.public.biztalk.tools
>From: "=?Utf-8?B?QmFycnk=?=" <anonymous@discussions.microsoft.com>
>Subject: Positional Mapping Issue
>Date: Fri, 7 May 2004 07:26:07 -0700
>Lines: 11
>Message-ID: <574FA95A-E2CE-4CAF-A083-A90C1F4D1F8F@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.tools
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.tools:3634
>NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
>X-Tomcat-NG: microsoft.public.biztalk.tools
>
>Hi Group,
I am currently using BTS 2002 and I am mapping a positional file to an XML Spec.
The source (Pos file) can hold for example two sets of contact information i.e Firstname1, Lastname1, firstname2...etc
The destination spec (XML Schema) for example the Person_Details has only one lot of information for both incoming lots of data ie First
name, Last name. I have tried to use a looping functoid with different combinations, but I am hesitant to waste anymore time if this is not
possible. If someone out there can understand what I am meaning and has got around this before then any information would be much
appreciated.
Thanks in Advance...
Baz.
>
--
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.
| |
| Barry 2004-05-12, 12:08 pm |
| That attachment hasn't seemed to come through?
Baz,
| |
| Tatyana Yakushev [MSFT] 2004-05-12, 1:19 pm |
| Here is what map should have:
Source schema looks like this
Root
|-FirstName1
|-LastName1
|-FirstName2
'-LastName2
Target schema looks like this
Root
'-Names (has max occurence set to unbounded)
|-FirstName
'-LastName
The map has 5 functoids
1 - Looping functoid connected to the FirstName1 and FirstName2 at the source and connected to the Names at the target
2 - Logical existance functoid connected to the FirstName1 at the source and going to the functoid #3
3 - Value mapping functoid that takes 1st input from functoid #2 and second input from LastName1 and connected to the LastName at the
target
4 - Logical existance functoid connected to the FirstName2 at the source and going to the functoid #5
5 - Value mapping functoid that takes 1st input from functoid #4 and second input from LastName2 and connected to the LastName at the
target
Additionally there are 2 links going from FirstName1 to the FirstName and from FirstName2 to the FirstName.
Tatyana
--------------------
>Thread-Topic: Positional Mapping Issue
>thread-index: AcQ4MUEGq1+o4p3gTUWvq5ReYjgjyw==
>X-WN-Post: microsoft.public.biztalk.tools
>From: "=?Utf-8?B?QmFycnk=?=" <anonymous@discussions.microsoft.com>
>References: <574FA95A-E2CE-4CAF-A083-A90C1F4D1F8F@microsoft.com> <yhxczb5NEHA.304@cpmsftngxa10.phx.gbl>
>Subject: RE: Positional Mapping Issue
>Date: Wed, 12 May 2004 07:56:06 -0700
>Lines: 3
>Message-ID: <BFC08DCA-977F-4956-84F5-3D855F163A09@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.tools
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.tools:3658
>NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
>X-Tomcat-NG: microsoft.public.biztalk.tools
>
>That attachment hasn't seemed to come through?
Baz,
>
--
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.
| |
| Barry 2004-05-14, 12:56 pm |
| Great stuff thanks heaps
Baz
| |
| Barry 2004-05-14, 12:56 pm |
| Sorry but more questions....
That solution works for lastname and firstname, but what about if I have other fields like DOB, DOB2, Sex, Sex2...
Cheers
Baz
| |
| Tatyana Yakushev [MSFT] 2004-05-14, 8:37 pm |
| You will have to add logical existance functoid and value mapping functoid for every additional field you need to copy.
Regards,
Tatyana
--------------------
>
>Sorry but more questions....
That solution works for lastname and firstname, but what about if I have other fields like DOB, DOB2, Sex, Sex2...
Cheers
Baz
>
--
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.
|
|
|
|
|