Skip to Content
avatar image
Former Member

Handling Of CSV file in sap pi 7.4

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 04, 2016 at 09:03 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2016 at 09:21 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2016 at 09:42 AM

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

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

    Add comment
    10|10000 characters needed characters exceeded