Live File Processor Agent File Extensions

The Live File Processor Agent processes a file based on its extension (e.g., CSV is the extension of the file name data.csv).

File Extension	Description
XLS, XLSX (Excel)	Uses the Syncfusion XlsIO library to save each worksheet within the Excel file as a delimited (e.g., CSV) file, which it then processes (as it processes All Other files). Note: In Excel, date formats that begin with an asterisk (*) respond to changes in regional date and time settings. This agent uses the first Culture info name (e.g., 'en-AU') within the dateTimeFormats setting to save the file as a delimited file. Also, see note about FileNameRegexGroups and ZIP files; Excel files are similar: they include the Excel file name and worksheet name (e.g., 'something.xlsx\Sheet1'). Note: To properly process Excel files which contain commas within the data, it is necessary to change the Live File Processor delimiter setting from tabs and commas to tabs.
ZIP	Processes each file within the ZIP file, except for USR files. Note: The FileNameRegexGroups settings (e.g., loggerCodeFileNameRegexGroups) need to consider both the ZIP file name and sub-file name. For example, 'something.zip\data_20211018.csv' can use ^(.\.zip\\)(?'a'[^_.]*) to capture 'data' and ignore the '.zip\' and everything preceding it.
All Other (CSV, TXT, etc.)

File Extension

Description

XLS, XLSX (Excel)

Uses the Syncfusion XlsIO library to save each worksheet within the Excel file as a delimited (e.g., CSV) file, which it then processes (as it processes All Other files).

Note: In Excel, date formats that begin with an asterisk (*) respond to changes in regional date and time settings. This agent uses the first Culture info name (e.g., 'en-AU') within the dateTimeFormats setting to save the file as a delimited file.

Also, see note about FileNameRegexGroups and ZIP files; Excel files are similar: they include the Excel file name and worksheet name (e.g., 'something.xlsx\Sheet1').

Note: To properly process Excel files which contain commas within the data, it is necessary to change the Live File Processor delimiter setting from tabs and commas to tabs.

ZIP

Processes each file within the ZIP file, except for USR files.

Note: The FileNameRegexGroups settings (e.g., loggerCodeFileNameRegexGroups) need to consider both the ZIP file name and sub-file name. For example, 'something.zip\data_20211018.csv' can use ^(.*\.zip\\)*(?'a'[^_.]*) to capture 'data' and ignore the '.zip\' and everything preceding it.

All Other (CSV, TXT, etc.)