How to sort the incoming files in date wise in sap pi

[Former Member]

Hi All,

Please help me,

Actually my Scenario is pick the file from FTP server and place these same file in SAP AL11 folder without name change. These can be done through by passthrouh scenario. for these am using sender side TP as FTP and target side TP as NFS.

What my question is "Is it possible to sort the source files based on date and time".if it possible then where can i maintain this one.

Thanks & Regards,

Nagendra

[iaki_vila]

Hi Nagendra,

PI FTP poll always takes the files in alphabetical order. I think the solutions that you have are:

1. Change the name of the file with OS command in the FTP sender channel.

2. Develop an own module bean to do this stuff.

Regards.

[former_member186851]

Hello Nagendra,

You wish to process the source files based on time?.

If your files are getting generated on time then there should not be any problem,else you can try as Per Inakis solution.

[Former Member]

Hi Inaki,

Thank you for giving valuable answer,

I have another doubt regarding this, suppose for example assume that today there is no files sender server due some server down etc.. then today's files will come tomorrow at some time, then that time i will pick the today's files first, is this possible,.. can you please suggest me

Thanks & Regards,

Nagendra.

[iaki_vila]

Hi Raghu,

I don't understand your suggestion, do you want to say if he sets a reduced poll time and the files are being deposited with a major difference time, he will not have any problem?, ore there is anyway to set the pick up By Time on the ftp sender?

Regards.

[former_member186851]

Yes Inaki,Thats what I suggested.

If the files are placed in order and if we give proper polling interval that shoule be sufficient right?

[vishnu_pallamreddy]

Hi Nagendra,

Please try like below.

try with process sequence in processing tab of your sender channel.

[Former Member]

Hi Vishnu,

when we r using FTP at sender Processsing sequence option is available in processing tab right.

[bhagya_nayanala]

Hi Nagendra

Yes it is in Processing tab, you can select Processing sequence as "By Date".

[vishnu_pallamreddy]

Hi,

I found it in SFTP and normal file adapter only.

[former_member186851]

its available in SFTP and NFS.

[vishnu_pallamreddy]

Please try with "source file  time stamp" in Advanced tab of FTP sender channel

[bhagya_nayanala]

Hi Nagendra

You can go through the below link, if you haven't already.

https://scn.sap.com/thread/2022388