File Tailer

Characteristics

• File Tailer monitors a given file in a given location.

• Data is processed line by line.

• Note that the File Tailer does not support the definition type List in the Information Model.

Supported File Formats:

• CSV

• JSON

• XML

Information Model Requirements

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

CSV

• 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 configure the File Tailer (CSV) Channel

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

2. Click the Configure button.

3. Make sure the root model node is selected to be able to configure the File Tailer to String and CSV String to Model.

4. File Tailer to String - Configuration:

   • Enter the File path for the CSV-file on your machine

   • Specify the Polling interval and select the Unit

   • Enable Tail from end if you want to pick up always the last line of the file

   • Enable Reopen between chunks if the file should be closed and reopened between chunks

   • Select the Charset according to the file in use

5. CSV String to Model - Configuration:

   • Enter the Separator which is used in the CSV-file as well as the String delimiter

   • Input the Eol delimiter and the Timestamp format if one is used.

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

   • Input the Polling interval and select the Unit

6. Select 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. Check the Routes checkbox.

8. Enter a Regular expression for the message filter.

9. Click the Apply button, then the Close button and save the Channel by clicking the Save button on the upper right corner.

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
File	Path to the csv file	C:\test.csv
Delay Millis	Delay between checks of the file for new content in milliseconds	250
TailFromEnd	Set to true to tail from the end of the file, false to tail from the beginning of the file	true, false
ReopenBetweenChunks	If true, close and reopen the file between reading chunks	true, false
routes	Path of a node in the Information Model	true, false
messageFilterRegEx	Regular Expression for the message filter used in the implementation	.*