Import & export of IWS additional data

IWS additional data can imported or exported to text based csv files. Import and export is done using the batch file tws_addata.cmd, which is located in the bin directory in ProcMan installation.

The command is using for export and import of data csv format (comma separated text). csv file consists from 3 common fields and 1 optional field:

• application key – application key for tws application

• operation number – optional field operation number for operation data for operations

• field name – field name of additional data

• field value – field value of additional data

The csv file is by default in character encoding UTF-8, but it is possible to use also character encoding Windows-1252.

Example of csv file with IWS additional data

application key, field name, field value

application key, field name, field value
"ACTUAL.TWEC.BGT3000A.P.A.20711231","note1","test1"
"ACTUAL.TWEC.BGT3000A.P.A.20711231","note2","test 2 \n test22"
"ACTUAL.TWEC.BGT3000A.P.A.20711231","select4","1"
"ACTUAL.TWEC.BGT3001A.P.A.20711231","checkbox3",""
"ACTUAL.TWEC.BGT3001A.P.A.20711231","note1","test 1"
"ACTUAL.TWEC.BGT3001A.P.A.20711231","note2","test 2"
"ACTUAL.TWEC.BGT3001A.P.A.20711231","select4","1"