tws_addata -o export -s adcom -f export.csv -- export additional data in common segment to file export.csv
tws_addata -o export -s adop -f export_oper.csv -- export additional data in operation segment to file export_oper.csv
tws_addata -o import -s adcom -f export.csv -- import additional data from file export.csv to additional data in common segment
tws_addata -o import -s adop -f export_oper.csv -- import additional data from file export.csv to additional data in operation segment
tws_addata –o export –s adcom –i adid=BG*;owner=P368V – export all applications with id starts with BG, owner of application is P368V
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
-h show help menu
-o option for manipulation - import, export
-s IWS data segment – adcom (applications) or adop (operations), default value adcom
-f Filename for command ouput or input
-c csv file format, txt or excel, default txt, txt is csv format for common text editors, excel means csv format readable by MS Excel, the main format differences are in multiline text fields
-e text encoding of csv file, UTF-8 or CP1252 (Windows-1252), default UTF-8
-m file export mode, w - overwrite existing file, a - append existing file
-i export filter, option for exporting only part of IWS applications, consisting from pairs of name=value separated by semicolons, example adid=AD*;subsys=TWGC – filter for all applications starting with AD from system TWGC,
The export filter can use following fields:
adid - Application ID
subsys - IWS system
Owner - Application owner
type - Type
stat - Status
authgrp - Group Definition
grpdef - IWS Authority group id
addname - Additional data field name
dbstat - State (ACTUAL, INSERTED, MODIFIED)