Processing files by date option not available for FTP

[Former Member]

Dear all,

I am trying to process the files by date option when connected to FTP site.

This option is not available for FTP, available only for NFS case.

Is there any way to process the files by date when connected to FTP??

Regards

[Former Member · Accepted solution]

Hi Bhavana,

I am not sure exactly what is your req ???

Maybe u can try the advanced parameters tab in FTP .

There is an option which comes up once choose "Adapter Specific Message Attributes" ---> Source File TimeStamp.

I think you will need to write an udf for that.

OR

I think you can use the option of "Availability time planning" in Runtime Workbench.

Regards,

Rohit

[Former Member · Accepted solution]

Rohit Thnx for replying.

>>I am not sure exactly what is your req ???

I want to process files by its date and timestamp.

Ex: i have 10 files on FTP site with date and time stamp, i have to process the old files first according to it's date & time.

We have an option called "Processing sequence = date " But this option is available for NFS only, not there for FTP

Let me know

Regards

[Former Member · Accepted solution]

Hi Bhavana,

In FTP :-

Maybe u can try the advanced parameters tab in FTP .

There is an option which comes up once choose "Adapter Specific Message Attributes" ---> Source File TimeStamp.

I think you will need to write an udf for that.

For the Transport Protocol "File Transfer Protocol (FTP)" files are always processed in ascending alphabetical order

We do not have these options for FTP (as it is required in this question).

Applying EOIO is another solution that I can think of.

You can also go for Prioritized Message Processing ,it might work for ur req.,

chk the below link:-

http://help.sap.com/saphelp_nw2004s/helpdata/en/3c/499240ed38ce62e10000000a155106/frameset.htm

Regards,

Rohit

[Former Member]

Hi Bhavna,

Yes, you are correct the processing sequence doesnt come with FTP protocol option.

I think you can achieve this in a couple of ways:

1. Create a simple File to File scenario (without design objects http://wiki.sdn.sap.com/wiki/display/XI/FiletofilewithoutusingwithIntegration+Repository). This will move the file from FTP location to your local NFS system and then you use processing sequence : By Date

2. Use BPM and collect multiple files and then do the further processing.

[Former Member]

Yes Puneet, I too though of the same option !!

Thanks