Passthrough Scenario(.CSV to .XML)

[Former Member]

Hi Experts,

My Scenario is pick the file from folder and send to Bank. This is Passthrough Scenario.

System : PI 7.31

Sender Channel: File

Receiver Channel: File

.CSV file Format:

H       CorpID        ABC00110

D        BuyerID     BuyerName-A     BuyerName-B     MailID

AC     ABC123     Buyer1area          Name                 ACC Name     Address

please explain me how to do the scenario.

Thanks and Regards

ravi

[vicky20691 · Accepted solution]

Hi Ravi,

You have no where mentioned the what format the bank is accepting? the same file needs to be sent to bank? or it needs to be converted to some other format.

If there is no conversion no need to do anything in ESR

In ID - create a sender file channel to pick the file from relevant folder and create a receiver file channel which will place the file in bank's folder.

Create an ICO and give some dummy name in SI and Namespace.

SAPTechnical.COM - File-to-File Scenario without creating Repository Objects

If there is some more requirements please post.

Regards,

Vikas

[Former Member]

Thanks Expert for your help.

[former_member186851]

Ravi please share the solution and close the thread.

[iaki_vila]

Hi Ravi,

As previous SCN members said your case is a typical case for file content conversion, check this page Converting Text Format in the Sender File/FTP Adapter to XML - Advanced Adapter Engine - SAP Library to know what you can do and the format that the target file can have.

If your target XML file is not hierarchical complex you can do it in one shoot.

Regards.

[former_member186851]

Hello Ravi,

Do a File content conversion at the Centre file adapter which will convert the file to XML and send it to receiver XML.

Guess it will work without mapping, Never tried like this though.

If you getting error, Just create one structure ,use the same for source and target interface, no need of any mapping program, which can be used to convert file to XML.

SAPTechnical.COM - File Content Conversionhttp://saptechnical.com/Tutorials/XI/Contentconversion/page1.htm