Csv text file format, Tagname line – Echelon LonPoint Application and Plug-In User Manual

Page 183

Advertising
background image

The LonPoint Application and Plug-in Guide

13-17

quotes) may be used to represent the full pathname of
the generated CSV text file.

For example, select this option and enter the
following command line to run the InTouch Historical
Data Merge Utility on the output CSV text file (the
first set of quotes are required because the path has
spaces in it):

"C:\Program
Files\FactorySuite\InTouch\hdmerge.exe"
"%1"

Or, select this option and enter the following
command line to start Excel with the output CSV text
file. The /e option skips the Excel splash screen:

"C:\Program Files\Microsoft
Office\Office\excel .exe" /e "%1"

Append header file

Appends the specified file to the beginning of every
CSV text file generated. Enter the full pathname of
the file to be appended.

Append footer file

Appends the specified file to the end of every CSV
text file generated. Enter the full pathname of the file
to be appended.

CSV Text File Format

The LonPoint Data Logger Utility translates a DL-10 binary log file into a
Comma Separated Values (CSV) text file for exporting to trending applications.
The comma delimiter is configurable and is based on the Windows Regional
Setting / List Separator property.

There are several factors which affect the layout of this file. A Data Logger CSV
text file consists of a tagname line followed by a series of data lines.

Tagname Line

The first line in a CSV text file is the tagname line. This consists of textual
column descriptors. The first two fields are $Date followed by $Time. Following
these fields are the tagnames for the subsequent data columns.

A data column and a unique tagname is included for each unique data source
identified in the binary log file. A unique data source is identified for each of the
seven Data network variable inputs to the Data Logger functional block. In
addition, unique data sources are identified for multiple network variables
received on the same Data input if you have enabled logging of source addresses
(see the Input Options tab of the Data Logger plug-in) and the network variable
updates come from different source addresses. Multiple updates received on the
same Data network variable from the same device will not be identified as
unique data sources because they have the same source address.

Advertising