File Processing tab

Use this tab to specify the file processing details. This tab is displayed only when Interface Direction is set to Import and Interface Type is set to CSV. You must specify this information on 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 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.