Skip to Content

FTP to FIle Scenario in SAP PI

HI Experts,

I am having one simple scenario File to File ( FTP --> PI --> ECC ), I did pass through scenario, which was working fine.

Here the problem with file content which we are receiving in ECC from FTP server i.e , file content in FTP server looks like as mentioned below.

ex :

9780043012239,369

but when the file is placing in ECC system, every line is ending with # symbol, which causing problems to us,

ex :

9780043012239,369#

I tried file type formats in receiver file type "Text " with the format " ISO-8859-1" but no luck.

Can any one help me to solve this issue ??

Thanks in advance.

Best, Shiva

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Aug 10, 2017 at 04:32 PM

    There's nothing wrong with your file. That is how it get displayed in ECC AL11 Unix OS, you can see the same discussion here.

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Manoj ,

      Sorry for the delay in response.

      I tried to create structure in ESR as per input file records, then in ID level I tried to to use FCC on both sides with endseparator '0x0A'.

      Now file in application server looks fine.

      Thanks for your support .


      Best , Shiva


  • Aug 10, 2017 at 04:08 PM

    Hi Shiva,

    The end of line is different on Windows and Unix systems.

    1. Windows systems: CRLF (a carriage return - 13 / 0x0D, a line feed - 10 / 0x0A),

    2. Unix systems: LF (a line feed - 10 / 0x0A) .

    So if 'end of line' code is not converted, then you see strange additional characters at the end of each line.

    Do you have a content conversion? Do you use 'endSeparator' property with the proper value ('0x0D''0x0A' or '0x0A')?

    Best Regards,

    Andrzej

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 10, 2017 at 02:25 PM

    Hello shiva,

    Can you download the file from AL11 and check it locally.

    I believe this should probably display error in AL11 directory.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 10, 2017 at 02:48 PM

    Are you using ASCII mode for your FTP connection? If not, please try and see if that resolves your issue.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Patrick,

      I tried both side same option ASCII format but no luck, anyhow issue was solved by creating structure in ESR and tried the content conversion.

      Thanks .

      Best , Venkatesh