|
Home > Archive > BizTalk Server Tools > March 2004 > Confusing Mapping Problem
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 |
Confusing Mapping Problem
|
|
| Bradley H. Knowles 2004-03-23, 4:37 pm |
| I am having a terrible time trying to fix the following mapping error. I've
been unable to resolve this problem and have spent hours upon hours trying
to change my map, functoids, links, compiler properties, etc. Nothing seems
to work. A point in the right direction would be unbelievably helpful. I
can provide test files if someone would like to see the situation happen on
their own system.
Thanks in advance for all your help...if ya need any more details I'll be
happy to provide them.
--Brad
Background
----------
I'm Using BizTalk Server 2002 on a Windows 2000 server system. I'm mapping
an EDI 4030X12 850 to an XCBL <www.xcbl.org> Order. Database functoids
convert the ItemQuals in the source to the <ProductIdentifierQualifierCoded>
in the output. I have a Looping functoid with each ItemQual as an input
linked to the <ProductIdentifierCoded> loop. I use a single Logical
Existence for each ItemQual attribute. I have two Value Mapping functoids,
one for the result of the Database Value Extractor (ItemQuals) and one for
just the item number. The Logical Existence serves as inputs to the two
Value Mapping functoids, which are linked to the
<ProductIdentifierQualifierCoded> and <ProductIdentifier> elements. Both
schemas are unchangeable, they come from and import into applications that
require the shown format.
Problem
-------
When both PO1 tags have an equal number of attributes, everything works
flawlessly. The problem is when one PO1 loop has an extra pair of
attributes (see ItemQual_4 and ItemID_4 in 2nd source PO1 tag). The map
seems to omit the last Qualifier in the output, yet successfully outputs the
last item number (see 2nd <ItemDetail>, last <ProductIdentifierCoded> loop
in output).
Source
------
<LineItems>
<PO1 ItemQual_1="IN" ItemID_1="Item1-1" ItemQual_2="UP" ItemID_2="Item1-2"
ItemQual_3="VN"
ItemID_3="Item1-3"></PO1>
<PO1 ItemQual_1="IN" ItemID_1="Item2-1" ItemQual_2="UP" ItemID_2="Item2-2"
ItemQual_3="VN"
ItemID_3="Item2-3" ItemQual_4="BO" ItemID_4="COLOR"></PO1>
</LineItems>
Output
------
<LineItemSection>
<ItemDetail>
<ListOfProductIdentifierCoded>
<ProductIdentifierCoded>
<ProductIdentifierQualifierCoded>BuyersItemNumber</ProductIdentifierQualifie
rCoded>
<ProductIdentifier>Item1-1</ProductIdentifier>
</ProductIdentifierCoded>
<ProductIdentifierCoded>
<ProductIdentifierQualifierCoded>UPCConsumerPackageCode1-5-5-1</ProductIdent
ifierQualifierCoded>
<ProductIdentifier>Item1-2</ProductIdentifier>
</ProductIdentifierCoded>
<ProductIdentifierCoded>
<ProductIdentifierQualifierCoded>VendorsItemNumber</ProductIdentifierQualifi
erCoded>
<ProductIdentifier>Item1-3</ProductIdentifier>
</ProductIdentifierCoded>
</ListOfProductIdentifierCoded>
</ItemDetail>
<ItemDetail>
<ListOfProductIdentifierCoded>
<ProductIdentifierCoded>
<ProductIdentifierQualifierCoded>BuyersItemNumber</ProductIdentifierQualifie
rCoded>
<ProductIdentifier>Item2-1</ProductIdentifier>
</ProductIdentifierCoded>
<ProductIdentifierCoded>
<ProductIdentifierQualifierCoded>UPCConsumerPackageCode1-5-5-1</ProductIdent
ifierQualifierCoded>
<ProductIdentifier>Item2-2</ProductIdentifier>
</ProductIdentifierCoded>
<ProductIdentifierCoded>
<ProductIdentifierQualifierCoded>VendorsItemNumber</ProductIdentifierQualifi
erCoded>
<ProductIdentifier>Item2-3</ProductIdentifier>
</ProductIdentifierCoded>
<ProductIdentifierCoded>
<ProductIdentifierQualifierCoded></ProductIdentifierQualifierCoded>
<ProductIdentifier>COLOR</ProductIdentifier>
</ProductIdentifierCoded>
</ListOfProductIdentifierCoded>
</ItemDetail>
</LineItemSection>
| |
| Tan Bao Nguyen 2004-03-25, 6:52 pm |
| Brad,
Could you include your schemas, map, and input instances?
Regards,
Tan Nguyen
Microsoft BizTalk Server
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------[color=darkred]
16:02:56 -0500)[color=darkred]
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08
.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.ash.giganews.co
m!border1.nntp.ash.giganews.com!nntp.giganews.com!diablo.voicenet.com!209.24
2.86.15.MISMATCH!newsfeed.slurp.net!not-for-mail[color=darkred]
I've[color=darkred]
seems[color=darkred]
on[color=darkred]
mapping[color=darkred]
<ProductIdentifierQualifierCoded>[color=darkred]
functoids,[color=darkred]
the[color=darkred]
ItemID_2="Item1-2"[color=darkred]
ItemID_2="Item2-2"[color=darkred]
ie[color=darkred]
nt[color=darkred]
fi[color=darkred]
ie[color=darkred]
nt[color=darkred]
fi[color=darkred]
|
|
|
|
|