Skip to Content

polling files in order on FTP adapter

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Dec 11, 2012 at 12:20 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2012 at 12:26 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 11, 2012 at 12:31 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.