File Tailer

Characteristics

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

  • Data is processed line by line.

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

  • The File Tailer can be used for CSV Files.

Information Model Requirements

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

CSV

  • Data in the CSV columns is represented by the Node Type Variable variableNode. Note that the order of fields in the CSV file must match the order of Variables in the Information Model.

CSVConfiguration

Configuration

In this example, the setup of the File Tailer for CSV is illustrated.

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

  2. Click the Configure button.

CSVConfiguration

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

  2. 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

CSVConfiguration_FileTailerToString

  1. 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

CSVConfiguration_CSVStringToModel

  1. Select the event node in the tree on the left side.

  2. Check the Routes checkbox.

  3. Enter a Regular expression for the message filter.

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

CSVConfiguration

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

.*