Export Configuration Data
About this task
Procedure
- Log in and start a command shell in the project from which you want to export data.
-
At the system prompt, invoke the following command:
$ clie export < file> [-Pr] [-Ef <format>] [-Sp<point_id>] [-Sd <device_id>] [-So <origin_id>] [-St <type>] [-Sr <resource_id>]
Where
< file> is a required argument, and is the full path of export file to be written. The file may be in any directory, but the project's Data subdirectory is recommended. You should always use the .csv extension with this filename.
Important: Option names are case sensitive and must be entered as defined.The optional arguments for the export command are:
Argument Description -Pr Remove all prefixes from Point IDs (up to and including the underscore), before exporting. -Ef < format> The type of file format to use. Specify one of the formats, found in the project's ie_formats.cfg format configuration file. Default formats in the file are: "Full Set" all supported fields will be exported "Logicmaster Export" only 4 fields will be exported. If no format name is specified, the internal format is used. This format includes all of the fields in the Full Set, plus additional unsupported fields. -Sp < point_id> A full or partial Point ID. Export data for Point IDs that begin with the string you specify. Note: Wildcards are required for partial point name matches.. -Sd < device_id> A full or partial Device ID. You can use the * and ?wildcard characters when specifying a partial Device ID. Export data for Point IDs whose Device IDs match the string you specify. -So < origin_id> Export data for Point IDs whose Origin IDs match the string you specify. Specify one of the following: D - device point G - global virtual point R - derived virtual point -St < type> A full or partial Point Type in the CIMPLICITY database. You can use the * and ?wildcard characters when specifying a partial Point Type. Export data for Point IDs whose Point Types match the string you specify. Sr < resource_id> A full or partial Resource ID. You can use the * and ?wildcard characters when specifying a partial Resource ID. Export data for Point IDs whose Resource IDs match the string you specify. Two export files will be generated by the Export utility: <filename>.csv and <filename>.rol. The .ROL file will contain information on additional roles configured for alarm routing. If there are no roles other than SYSMGR, USER and OPER, the file will still be generated, but will contain no information.
Example
clie export myfile.csv -Pr -Ef "My Set"
exports the data fields defined by "My Set" in ie_formats.cfg to MYFILE.CSV and MYFILE.ROL, and strips off any prefixes on the Point IDs.