on 12-11-2012 11:19 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.