File Processing tab

This tab is displayed only when Interface Direction is set to Import and Interface Type is set to CSV or EXCEL. You must specify this information in the File Processing tab.

Order Files By

The order (ascending) in which the files are organized in the directory based on the value specified. These variables can be used:

%file_1= the first variable in the file name
%file_2= the second variable in the file name

Note: This option is enabled only if the Use File Name Pattern option is set to On in the Data Source tab.

Import Latest File

Indicates the importing pattern of the interface service. Possible scenarios:

On: The latest file is imported based on the files time stamp or by the value specified in the Order Files By field.
Off: All the files are imported in an order, either by Time Stamp (the system time when the file is saved) or by the value specified in the Order Files By field.

Note:

This option is enabled only if the Use File Name Pattern option is set to On.
Time Stamp is based on the source OS.

Group File By

The value based on which the matched files can be split into group. The files in each group are ordered based on the value specified in the Order Files By field. Else, the latest date and time is considered. The latest file in each group is imported.

Note: This option is enabled only if the Use File Name Pattern and Import Latest Files options are set to On.

Rename File After Import

The variables based on which the imported files are renamed. These variables are used for renaming:

%file = Complete file name
%file_0 = file name without extension

Example:

%file_0_complete: TAR_MD_BOM_20170705060012.csv file is renamed to TAR_MD_BOM_20170705060012_complete.
%file_save: TAR_MD_BOM_20170705060012.csv file is renamed to TAR_MD_BOM_20170705060012_save.csv

Rename Non-Imported Files

The variables based on which the files that are not imported, are renamed.

Note: This option is enabled only if the Use File Name Pattern and Import Latest Files options are set to On.