Csv file formats, Csv file formats -3 – Rockwell Automation 1757-PROCESSLINX ProcessLinx OPC Server to Server Software User Manual User Manual

Page 53

Advertising
background image

Publication 1757-UM002B-EN-P - January 2003

Import/Export 5-3

CSV File Formats

A CSV file is an ASCII Text file that contains fields delimited by commas. Text
editors, spreadsheet programs, and database packages can create, edit, and save
CSV files. Because commas are used as field delimiters, commas are NOT
allowed in field values. Each text line represents one ProcessLinx command or
object definition. A CSV file example with one Pipe, three Groups, and two
Translation tables is given in Figure 4-2.

BEGIN_PIPE
PIPE,Pipe1,,1,localHost,HWHsc.OPCServer,localHost,HWHsc.OPC-
Server,5000,localHost,Rov iSys.OPC90Server,localHost,Rovi-
Sys.OPC90Server,5000
BEGIN_GROUPMAP
GROUPMAP,Outputs,,0,1,1.000000,1000,0,1.000000,1000,0
TAGMAP,,YHS103_B.DEVCTLA.MODE,,Device1.TIC108_B.MODE,,,0,0
TAGMAP,,HS_036.DEVCTLA.PV,,Device1.TIC108_B.PV,,,0,0
TAGMAP,,pidloop.pida.ophilm,,Device1.TIC108_R.HI_LIM,,,0,0
TAGMAP,,pidloop.pida.oplolm,,Device1.TIC108_R.LO_LIM,,,0,0
TAGMAP,,PIDLOOP.PIDA.PV,,Device1.TT108_R.SP,,,0,0
END_GROUPMAP
BEGIN_GROUPMAP
GROUPMAP,Inputs,,1,1,1.000000,1000,0,1.000000,1000,0
TAGMAP,,HS_036_EXTERNAL.DEVCTLA.PV,,Device1.FHS104_B.F1,,,1,0
TAGMAP,,LEVEL_EXTERNAL.NUMERIC18.PV,,Device1.WI113_B.OUT,,,1,0
TAGMAP,,PIDLOOP_EXTERNAL.NUMERIC6.PV,,Device1.TT108_B.OUT,,,1,0
END_GROUPMAP
BEGIN_GROUPMAP
GROUPMAP,READ-WRITE,,2,1,1.000000,1000,0,1.000000,1000,0
TAGMAP,,pidloop.pida.OP,,Device1.TIC108_R.OUT,,,0,1
TAGMAP,,pidloop.pida.MODE,,Device1.TIC108_R.MODE,,,0,0
TAGMAP,,pidloop.pida.SP,,Device1.TIC108_R.SP,,,0,0
TAGMAP,,pidloop.pida.PV,,Device1.TIC108_R.PV,,,0,0
TAGMAP,,HS_039.DEVCTLA.OP,,Device1.FHS107_R.OUT,,,0,1
TAGMAP,,HOPPER.DEVCTLA.OP,,Device1.YI109_R.OUT,,,0,1
TAGMAP,,PIDLOOP_EXTERNAL.PIDA.SP,,Device1.TIC108_B.SP,,,1,1
TAGMAP,,MIXER.DEVCTLA.OP,,Device1.YHS111_R.OUT,,,0,1
TAGMAP,,SPEED.DEVCTLA.OP,,Device1.YI130_R.OUT,,,0,1
END_GROUPMAP
END_PIPE
BEGIN_TABLE
TABLE,Device Output,DISCRETE
TABLE_VAL,5,1
TABLE_VAL,4,0
END_TABLE
BEGIN_TABLE
TABLE,Device Mode,DISCRETE
TABLE_VAL,1,1
TABLE_VAL,2,0
END_TABLE

Figure 5.2 Sample ProcessLinx CSV file

Advertising