Question about how XI process files in FTP

[Former Member]

Hi experts,

I have a file-FTP to JDBC scenario.

XI scans a folder every minute to see if any file has appear.

My question is, does XI process the files in their order of creation, or randomly ?

If not, is there a way to make XI process them in order of creation ?

Thanks a lot, any help would be appreciated.

Kind regards,

Jamal

[Former Member · Accepted solution]

Hi ba_da_boom

while configuring your channel in ID , you can see the option under TAB transport protocol

once you select the option NFS additional fields will be highlighted in the window

then you can give the settings

As per my suggestion to set QOS EOIO once you will select QOS EOIO , in the channel setting there will be a text box where you can give the name of the queue which will be used for EOIO processing

Thanks

sandeep

[Former Member]

Hi Patrick,

thanks for the answer.

I dont see where exactly can I make these additional specifications.

Could you please tell me ?

Thanks a lot,

Jamal

[Former Member]

Hi,

sorry I should have highlighted the one sentence:

> The following are then not possible specifications

So it seems (like said by the others) not to be possible with FTP.

Regards

Patrick

[dharamveer_gaur2]

Hi

If you use NFS then can use Select by Date. File would be process in time sequence.

[Former Member]

Hi,

Ive made some tests, and XI processes apparently in alphabetical order in default for FTP files.

It does not take in account the time I have put the file on the FTP.

For example,

if I put the file 'FILE3.xml' on the FTP at 10:00:20 and then the file 'FILE1.xml' at 10:00:45, it will process FILE1 first.

Is there anyway I can change that ? So that XI takes the files by order of arrival ?

Thanks,

Jamal

[SudhirT]

Hi,

By Default, It works on Oldest file first with the timestamp.

It means if the file itself contains the timestamp with its name then that will be processed on the oldest time or alphabetical order.

Is there anyway I can change that ? So that XI takes the files by order of arrival ?

For this you can create files with suffix as the timestamp in the name.

Thanks!

[Former Member]

Hi,

from SAP Help:

If you select files from an FTP server and not from the file system, you need to make the following additional specifications:

○ ftp.host=<ftp-server>

The host name or IP address of the FTP server. If this specification is made, it is assumed that you are accessing an FTP server. The specifications file.sourceDir and file.sourceFileName then refer to the FTP server. The following are then not possible specifications:

■ setAttribute for parameter file.processingMode.

■ byDate for parameter file.processingOrder.

Regards

Patrick

[dharamveer_gaur2]

Hi

Process in Alphabetical order.

[Former Member]

Hi,

thanks for your answers; Sekhar, you talk about conf. for NFS, but I cant see the same options for FTP.

Sandeep, what do you mean by define a separate queue ? how can i do that ?

Thanks a lot,

Jamal

[Former Member]

hi

define the quality of service as exactly once in order (EOIO) and define the seprate queue for this

regards

sandeep

[SudhirT]

Hi,

By Default, It works on Oldest file first with the timestamp.

Thanks!

[Former Member]

Hi ,

Yes...We have two options. 1.Order by date 2.Order by Name. We can set this parameter in the file config.

From SAP Help

Processing Sequence (for transport protocol File System (NFS))

If you used placeholders when specifying the file name, define the processing sequence of the files:

○ By Name: Files are processed alphabetically by file name.

○ By Date: Files are processed according to their time stamp in the file system, starting with the oldest file.

Regards,

Sekhar