TOPServer_257w_76h

Save Engineering Time with
CSV File Export/Import

SWTB_logo_93w_76h

clearpixel

SWTB_7Button_BlueLine_900w

Comma Separated Variable File Support

CSV_DelimiterThe server supports the import and export of tag data in a CSV (comma separated variable) file. The CSV functions are only available when a Device or Tag Group is selected. Using CSV import and export, tags can be created quickly in the application of your choice.  If you need to use a ; - semicolon instead of a comma to separate items, go to the Tools | Options | General tab and select the CSV delimiter you want to use.

Important Note: The easiest way to create an import CSV file is to create a template using File|Export CSV. Define the channels and devices that the project will contain. Next define a tag for each device. Export each device or tag group as a CSV file. Use this template in a spreadsheet application that supports CSV files and modify the file. The resulting CSV file can then be saved to disk and imported back into the server under the same device or tag group or under a new device or tag group.  If you need to modify the Channel or Device level settings, use the XML file.
 

CSV_Export


Exporting a Server Tag List:
This generates a .CSV (comma separated variable) text file that contains a heading record followed by a record for each tag defined under the selected device or tag group. The heading record contains the following fields. If you leave a column blank, the server will just use the default value for that setting.  Often all you need to set is the Tag Name, Address and possibly the Data Type.

    Tag Name - Name of the tag as it will be referenced in an OPC client.
    Address - The device location referenced by the tag.
    Data Type - The data type used for the tag as shown in the server Tag Data Type drop down list box.
    Respect Data Type - This forces the tag to follow its defined data type not the OPC client request.(1, 0)
    Client Access - Read/ Write access (RO, RW, WO)
    Scan Rate - The rate in milliseconds that the tag address will be scanned when used with most non-OPC clients.
    Scaling - Scaling mode (Linear, Square Root)
    Raw Low - Low raw value
    Raw High - High raw value
    Scaled Low - Scaled low value
    Scaled High - Scaled high value
    Scaled Data Type - The data type used for the tag after scaling is applied.
    Clamp Low - Force the resulting scaled value to stay within the limit of Scaled Low.(1, 0)
    Clamp High - Force the resulting scaled value to stay within the limit of Scaled High.(1, 0)
    Engineering Units - Units string.
    Description - Tag description

 

 | TOP SERVER HOME  | PRODUCT DETAILS  | DRIVERS LIST  | FREE TRIAL  | ORDERING TOP SERVER  | SUPPORT  | NEWS

P: 1-888-665-3678 (US-Sales) or +1-704-849-2773 (Support & International), F: +1-704-849-6388
148A East Charles Street, Matthews, North Carolina, USA 28105
Copyright Software Toolbox, Inc., 1996-2009, All Rights Reserved Worldwide.

Wonderware, InTouch, and Invensys are registered trademarks of Invensys plc.  All  other marks are the property of their respective owners.
The Software Toolbox name and logo are registered trademarks of Software Toolbox Inc.