Using with PI Tag Configurator The general steps for using AXS4TagExport and PI Tag Configurator to maintain PI points are: Run AXS4TagExport to export PI point definitions to a CSV file (see the chapter). “” Open Excel. On the File tab, click Open. Select Text Files (*.prn;*.txt;*.csv). Browse to the folder containing the CSV file from AXS4TagExport. Select the CSV file. Click OK. Revise the worksheet. For example, remove rows for unwanted IED attributes or clear the cell in the column of the unwanted rows. “Select (x)” Export the PI point definitions in the worksheet to the PI Server. As the revisions to the worksheet become routine, you can record your revisions as Excel macros to reuse in subsequent PI point maintenance sessions. Specific Considerations Keep the following issues in mind when you revise the worksheet. Empty Cells When a CSV file is imported, Excel does not differentiate between a field with no value and a field with a zero-length string. Both cases result in an empty cell in the worksheet. Note: Excel does not distinguish between an empty field and a field containing two consecutive quotation marks. Point Creation PI Tag Configurator does not require a worksheet to contain columns for all supported PI point attributes because data sources rarely provide values for the entire set of supported attributes. If a CSV file does not contain a field for an attribute, the worksheet will not contain a column for the attribute. If the worksheet is exported to the PI Server to create PI points, the default value from the PI Server is used for missing attributes.
Using with PI Tag Configurator The general steps for using AXS4TagExport and PI Tag Configurator to maintain PI points are: Run AXS4TagExport to export PI point definitions to a CSV file (see the “” chapter). Open Excel. On the File tab, click Open. Select Text Files (*.prn;*.txt;*.csv). Browse to the folder containing the CSV file from AXS4TagExport. Select the CSV file. Click OK. Revise the worksheet. For example, remove rows for unwanted IED attributes or clear the cell in the “Select (x)” column of the unwanted rows. Export the PI point definitions in the worksheet to the PI Server. As the revisions to the worksheet become routine, you can record your revisions as Excel macros to reuse in subsequent PI point maintenance sessions. Specific Considerations Keep the following issues in mind when you revise the worksheet. Empty Cells When a CSV file is imported, Excel does not differentiate between a field with no value and a field with a zero-length string. Both cases result in an empty cell in the worksheet. Note: Excel does not distinguish between an empty field and a field containing two consecutive quotation marks. Point Creation PI Tag Configurator does not require a worksheet to contain columns for all supported PI point attributes because data sources rarely provide values for the entire set of supported attributes. If a CSV file does not contain a field for an attribute, the worksheet will not contain a column for the attribute. If the worksheet is exported to the PI Server to create PI points, the default value from the PI Server is used for missing attributes.
PI_AXS4TagExport_1.0.0.6.docx