Skip to Content
avatar image
Former Member

How to make data positioned text file by Hana Cloud Integration

My Requirement is to make a text file on SFTP.

It has to be data positioned, I don't see any feature of Fixed length file in XML to CSV convertor.

Add comment
10|10000 characters needed characters exceeded

  • Hi,

    We had created a report in HCI that is data positioned, but when viewing in Notepad the format is not followed? Viewing in Notepad++ displays the correct format. We need to view the report in Notepad only. Any ideas how to fix this? TIA

  • Get RSS Feed

4 Answers

  • Best Answer
    May 23, 2017 at 06:53 AM

    Hello Prabhat,

    Unfortunately there is no option or feature similar to FCC of SAP PI/PO in SAP HCI.

    You have to write the script and generate the data positioned txt file.

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 04, 2017 at 11:54 AM

    Hi Sriprasad Shivaram Bhat

    I have a requirement to parse the field fixed length text file in HCI.Could you please shed some light on this Groovy script?I never did this scripting.Attached is the file format which I wanted to parse and convert into XML and pass the data to two entities in EC.

    Thanks

    Pavan

    capture.jpg

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2017 at 11:19 AM

    Hi Prabhat,

    You can check on this below blog. This may help you.

    https://blogs.sap.com/2016/01/14/hci-xml-to-csv-conversion-in-hci/

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 01 at 06:33 PM

    Hi Sripasad,

    would it be possible to share the sample script here?

    Thanks!

    Raghu

    Add comment
    10|10000 characters needed characters exceeded