Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Need help for mapping-BizTalk2006
- This topic has 4 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
November 11, 2009 at 6:51 AM #23729
Hi All,
I am trying to extract data from xml and post to SAP Idoc(FIDCCP02).
My issue is, I have header and Item records and from there i have to extract 4 lines of data for mapping to Idoc (1line for header+3 lines for line items).
Source file looks like:
<Header>
<Name/>
<Id/>
<Amount/>
<VAT Rate/>
<VAT Amount/>
<Address/>
</Header>
<Item>
<Item Id/>
<Item Desc/>
<Item delivary data/>
</Item>
Target Should look Like:
I have to convert this to map to Idoc like below
Line1 header data:– Name Id Address fields
Line2, Line1 Item data:- Item desc item id Amount(If VAT Rate is >0 then calculate VAT Amount and write the amount, i.e Amount=Amount-Vat Amount)
Line 3, Line2 item data:- Item desc itme id Amount(Just Calcutaled VAT)—Skip this line if VAT rate is not available in source/<=0
Line 4, Line3 item data:- Item desc itme id Amount(Original Amount)
And all of the above amount values i have to map to a single segment to write 3 line itmes.When i try to put loop and build diffrent scripting functiod and assign to that particular segment(WRBTR), I get error like: “error btm1048: Native serialization error: Cannot find definition for the input: WRBTR”
Please help me resolve this issue, I am 2 months experienced BizTalk developer.I did some googling but not much of use i found.
This is pending on me and people are waiting for my output to move further.
Thanks in advance for your kind help.
Bhupal.
-
November 12, 2009 at 1:07 AM #23743
Hi All,
Please help , this is critical for me.I can send screen shots of map, if that helps you to analyse my issue.
Invoking component…
C:\projects\OTMInvoiceInterface\Vetco_OTMInvoiceInterface\Vetco_OTMInvoiceInterface\Vetco_OTMMap.btm: warning btm1005: The destination node “WRBTR” has 3 data input(s). The maximum number of possible data inputs to this node is 2.
C:\projects\OTMInvoiceInterface\Vetco_OTMInvoiceInterface\Vetco_OTMInvoiceInterface\Vetco_OTMMap.btm: warning btm1005: The destination node “SGTXT” has 3 data input(s). The maximum number of possible data inputs to this node is 2.
C:\projects\OTMInvoiceInterface\Vetco_OTMInvoiceInterface\Vetco_OTMInvoiceInterface\Vetco_OTMMap.btm: warning btm1005: The destination node “WRBTR” has 3 data input(s). The maximum number of possible data inputs to this node is 2.
C:\projects\OTMInvoiceInterface\Vetco_OTMInvoiceInterface\Vetco_OTMInvoiceInterface\Vetco_OTMMap.btm: warning btm1005: The destination node “SGTXT” has 3 data input(s). The maximum number of possible data inputs to this node is 2.
Test Map used the following file: <file:///C:\projects\OTMInvoiceInterface\Sample File\Output\OutForIn.xml> as input to the map.
C:\Documents and Settings\genpact\Local Settings\Temp\1\Vetco_OTMMap_output.xml: error btm1048: Native serialization error: Cannot find definition for the input: WRBTR
Test Map failure for map file <file:///C:\projects\OTMInvoiceInterface\Vetco_OTMInvoiceInterface\Vetco_OTMInvoiceInterface\Vetco_OTMMap.btm>. The output is stored in the following file: <file:///C:\Documents and Settings\genpact\Local Settings\Temp\1\_MapData\Vetco_OTMMap_output.txt>
Component invocation succeeded.Thanks,
Bhupal.
-
November 12, 2009 at 1:49 AM #23745
Looks like the problem is in the serialization of the output into a flat file.
Does the map work if you set the Test Output property to Xml rather than Native?
-
November 12, 2009 at 2:44 AM #23746
Hi Greg,
It does work when i set Output Property to Xml, but with 4 line itmes(It shuould be 3) and with wrond WRBTR data.
Please help.
Thanks,
Bhupal.
-
November 13, 2009 at 8:18 AM #23770
Hello BizTalk Experts,
Need your help to solve my issue please.I am positively waiting for solution from one of you.I don’t even have option of raising a ticket to Microsoft for help 🙁 .
Thanks in advance for your kind help.
Regards,
Bhupal.
-
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.