Skip to Content
0

Handling Of CSV file in sap pi 7.4

Nov 04, 2016 at 08:50 AM

87

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Praveen Gandepalli Nov 04, 2016 at 09:03 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Giridhar Vegi Nov 04, 2016 at 09:21 AM
0

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.


capture2.jpg (14.9 kB)
Share
10 |10000 characters needed characters left characters exceeded
Raghuraman S Nov 04, 2016 at 09:42 AM
0

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

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


capture.png (3.4 kB)
Share
10 |10000 characters needed characters left characters exceeded