TSV

Starting from Liverig 5.29.0 and Liverig Collector 5.28.0, LiveRig collector supports the pushing of TSV payloads in order to convert them into Live events.

The TSV protocol is very similar to CSV protocol, however, it uses the tab character (\t) to delimit values instead of a comma (,).

That is a very simple alternative to input data from third-party software through a LiveRig collector instance, typically co-located at operational sites.

Configuration by remote control

Once the Remote Control feature is enabled, the user can configure a new TSV source remotely as follows:

Overview of TSV source configuration options

Null values

As a textual representation, TSV typically carries some standard number that needs to be interpreted as null values. The TSV source enables you to specify your typical values and drop them from the actual event representation for the channels.

Date time pattern

The date time pattern can be customized to detect seconds, milliseconds, or textual samples of information like months, AM/PM marks, or either some fixed strings in the rows which represent the timestamp of each data measurement. See the full list of symbols supported (as in Java).

Date time custom format configuration rules

Each column in the TSV file will be interpreted as a channel value and the first column will be the date time index for each row in the dataset.

Access endpoint

The TSV source can execute in client or server mode. Third parties applications may push data into the LiveRig TSV source endpoint.

Starting at LiveRig 5.29.0, the access configuration supports both TCP and Serial ports:

TCP port configuration for TSV source endpoint

Serial port configuration for TSV source endpoint

The TCP connector puts the source in server mode and waits for data to be pushed into it. On the other hand, the Serial port connector configures the source as client mode and watches the Unix device file to consume the data passing through.

Configuration by source file

Locally in the LiveRig Collector machine, the sources.xml can be configured as demonstrated below. This configuration opens the TCP port 9873 on all local interfaces to listen for files.

<source>
	<name>TSV endpoint</name>
	<mode>server</mode>
	<rig_name>my_rig</rig_name>
	<service_company>my_company</service_company>
	<protocol_name>tsv</protocol_name>
	<endpoint>tcp://0.0.0.0:9873/</endpoint>
</source>

This other example reads the first COM port in a Unix system available at /dev/ttyS0 to watch for events in TSV format.

<source>
	<name>TSV endpoint</name>
	<mode>client</mode>
	<rig_name>my_rig</rig_name>
	<service_company>my_company</service_company>
	<protocol_name>tsv</protocol_name>
	<endpoint>serial:///dev/ttyS0?baudRate=9600</endpoint>
</source>

Each line of the input data stream should end with the '\n' (the end of line character). The maximum allowed line length in characters is 4,194,304. This limit was imposed to avoid huge lines that could extrapolate the Live event maximum size or extrapolate the internal implementation buffer capacity.