File Reader

Characteristics

• File Reader monitors a specified folder - the so-called input folder

• If a file is inserted the following actions take place:

  • The Trigger of the specified Rule in the Mapping is activated

  • Thus, the Rule is executed

• After successful execution of the rule the file is moved into a so-called output folder

• In case of an exception the file is moved into an error folder

Supported File Formats:

• CSV

• JSON

• XML

Information Model Requirements

The first Node after the root node must be of type Event .

CSV

• The node after the Event must be of type List - multiple lines, each representing a data record.

• Fields, which are separated by commas, are represented by the Node Type Variable . Note that the order of fields in the CSV file must match the order of Variables in the Information Model.

XML

• Elements of the XML file are represented by the Node Type Variable .

• Attributes of the XML file are represented by the Node Type Property . In order to assign attributes to elements in the Information Model, the element Node Type must be a Custom Data Type.

How to use File Reader with CSV

1. Select File reader (CSV) from the Drop-Down.

2. Click the Configure button.

3. Make sure the root model node is selected to configure the File Consumer to String as well as the CSV String to Model.

4. File Consumer to String - Configuration

   • Enter a path for the input folder - In Folder

   • Enter a path for the process folder - Process Folder

   • Enter a path for the output folder - Out Folder

   • Enter a path for the error folder - Error Folder

   • Specify the Polling interval and select the Unit

   • Select the CharSet according to the file in use

5. CSV Consumer to Model - Configuration

   • Enter the Separator which is used in the CSV-file

   • If needed, set String delimiter, EOL delimiter and the Timestamp format

   • If the CSV file contains a header enable Ignore first line

   • Specify the Polling interval and select the Unit

6. Specify the Event used by selecting the event node in the tree on the left side

Note

The entries of a CSV-File can only be mapped directly to an Event object and its parameters.

7. File Consumer to String - Configuration

   • Enable the Event checkbox for the File Name Filter

   • Enter a Regular expression in order to determine which file is to be processed in the input folder

8. Csv String to Model - Configuration

   • Enable the Event checkbox for the Csv Model Configuration

   • Start of processing

     • If the entire content of the file is processed on this event enter a wildcard in the RegEx field

     • If the processing starts at a specific line enter a regular expression in the RegEx field to identify the line

9. Click the Apply button, then the Close button and save the Channel by clicking the Save button

Description of configuration properties:

Property	Description	Example
Separator	Separator type, used in the csv file	, , ;
Delimiter	Values that have an additional delimiter like “Date”, “Time”	"
Eol Delimiter	Defining Carriage return and/or Line Feed	\r, \n
Timestamp format	Format of the timestamp	YYYY-MM-DD HH:mm:ss
ignoreFirstLine	Delay between checks of the file for new content in milliseconds	true, false
TailFromEnd	Set to true to tail from the end of the file, false to tail from the beginning of the file	true, false
InFolder	Path leading to the Input Folder	C:\FileConsumer\In
OutFolder	Path of a node in the Information Model	C:\FileConsumer\Out
ErrorFolder	Regular Expression for the message filter used in the implementation	C:\FileConsumer\Error
CharSet	Encoding of the file in use	UTF-8, UTF-8 BOM, etc
ProcessFolder	Regular Expression for the message filter used in the implementation	C:\FileConsumer\Process