cancel
Showing results for 
Search instead for 
Did you mean: 

polling files in order on FTP adapter

sandip_hole
Participant
0 Kudos

Hello Experts,

How can i poll the files from FTP server in the same sequence of the creation date(multiple files are on FTP server).

note- we have AEX java only environment, we need to do this on FTP adapter not NFS

Is the parameter QOS- EOIO will help to poll the files in order/sequence.

Please suggest.

Regards,

Sandip

Accepted Solutions (0)

Answers (3)

Answers (3)

JaySchwendemann
Active Contributor
0 Kudos

I suppose the sequence the files get processed matters. If so, I would however not delegate the job to ensure sequence to the file adapter. I would rather handle this in the backend. If you don't want or can go that way: FTP adapter always picks up files in ascending alphabetical order. See note 821267 for more details on that.

HTH

Cheers

Jens

Former Member
0 Kudos

Hi Sandip,

The PI FTP adapter isssues a LIST command when polling the FTP Server. The behaviour (i.e. the order of the listing) of this list command varies between different servers. There is also a 'Processing Sequence' 'by date' option that is only available for NFS & not FTP.

The EOIO could help but you need to establish the following...
- Test the FTP adapter to your FTP Server (without In Order) and check the sequence of the file processing in PI.
- If it's sorting ascending by date by default (usually alphabetical though) then you could also consider "In Order" option to make sure that they are processed in the same order.

EDIT: You could also consider an option whereby you first FTP the files across to your PI app server and use the NFS file adapter option to sort by date.

Regards, Trevor

robertot4s
Active Participant
0 Kudos

Hi Sandip,

I think you can't do this. From the help.sap.com for FTP Adapter: "Files are always processed in ascending alphabetical order."

http://help.sap.com/saphelp_nw73/helpdata/en/44/655453b48a4ddfe10000000a1553f7/frameset.htm

So, one solution could be create the files in the server side (I don't know if you can) with a timestamp as prefix:

20121211131900..._<file_name_1>.txt

20121211131901..._<file_name_2>.txt

Regards,

Roberto