Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Need help to split flat file
- This topic has 1 reply, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
November 3, 2009 at 3:35 AM #23627
Hi All,
I have just realised that, I need to create a separate file for every message and transform and send through Send port to SAP .As SAP accepts one file as one idoc.
File comes like below:
Service Provider: OGVG.DK-BLUEWATERMARINE Invoice Number: TEST4 Invoice Date: 02-SEP-2009 Request For Invoice Number: RFI-562 Amount: 50 Amount Liable To VAT: 0 Amount Tax-free: 50 VAT Rate: Currency: NOK Plant: NOR01 Invoice Id: SERVPROV.20090902-0004 Due Date: 10-SEP-2009
Project: 123 Buy Shipment: OGVG.0110757 Buy Shipment Type: STANDARD Original Buy Shipment: Amount: 33.33
Project: 124 Buy Shipment: OGVG.0110757 Buy Shipment Type: STANDARD Original Buy Shipment: Amount: 16.67 —————-Messsage-1 should create 1 file
Service Provider: OGVG.DK-BLUEWATERMARINE Invoice Number: TEST5 Invoice Date: 02-SEP-2009 Request For Invoice Number: RFI-563 Amount: 150 Amount Liable To VAT: 18 Amount Tax-free: 132 VAT Rate: 25 Currency: EUR Plant: NOR01 Invoice Id: SERVPROV.20090902-0005 Due Date: 13-SEP-2009
Project: 123 Buy Shipment: OGVG.0110757 Buy Shipment Type: STANDARD Original Buy Shipment: Amount: 100
Project: 124 Buy Shipment: OGVG.0110757 Buy Shipment Type: STANDARD Original Buy Shipment: Amount: 50 —————–Messsage-2 should create 1 file
Service Provider: OGVG.KN Invoice Number: TEST-RFI-701 Invoice Date: 23-SEP-2009 Request For Invoice Number: RFI-701 Amount: 100 Amount Liable To VAT: 0 Amount Tax-free: 100 VAT Rate: Currency: EUR Plant: NOR01 Invoice Id: SERVPROV.20090923-0001 Due Date: 24-SEP-2009
Project: 12345 Buy Shipment: OGVG.0110800 Buy Shipment Type: STANDARD Original Buy Shipment: Amount: 100
Project: 12345 Buy Shipment: SERVPROV.0100033 Buy Shipment Type: SECONDARY CHARGE Original Buy Shipment: OGVG.0110800 Amount: 100——Messsage-3 should create 1 file
AND so on……………………..I need your help to split this file as many as Service Provider comes in input file.Please provide if some documentation/reference solution available with you or over web.
Thanks in advance for your gracious help.
Bhupal. -
November 3, 2009 at 9:24 AM #23631
Hi Bhupal,
I recommend that you read through the following articles written respectively by Jeff Lynch and Stephen Thomas, on different approaches to splitting files in BizTalk:
http://codebetter.com/blogs/jeff.lynch/articles/128664.aspx
http://geekswithblogs.net/sthomas/archive/2004/12/12/17373.aspx
Though these articles were written for BizTalk 2004, they are still relevant for version 2006. I hope these resources will help you in your project.
Good luck,
Daniel.
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.