Handling Of CSV file in sap pi 7.4

[giridhar_vegi]

Dear Experts,

i have requirement where i am getting the data in .csv file i.e. data coming in excel sheet with several coloumns with extension as .csv . I am using the sftp adapter. How Can i handle this in Sap pi with 7.4 version.Please suggest me.

Regards

Giridhar.

[former_member182412]

Hi Giri,

I think file is comma separated, if you have latest SFTP adapter then it supports file content conversion, you can do the file content conversion like file adapter.

If you don't have latest SFTP adapter and it does not contain file content conversion then use message transform bean to convert from CSV to XML.

Regards,

Praveen.

[former_member186851]

Yes,you should be able to handle this Using FCC.

Try opening the file with notepad,you should get something like below

[giridhar_vegi]

Hi Praveen ,

As i mentioned the client is using the 7.4 version.does it come with fcc protocol.i am attaching the sample file.

capture2.jpg

the file name is flatfile.csv

we can handle this using fcc right.

Regards

Giridhar.