Importing Custom Property Values from a Microsoft Excel File - Honeywell DOC4000 - 7.3 - Administration & Configuration - Intergraph

DOC4000 Administration Guide

Language
English
Product
Honeywell DOC4000
Subproduct
Cyber
Search by Category
Administration & Configuration
PAS Version
7.3

Once you create a custom property template and attach it to one or more object types, you can select an object and then use the tab defined by the template to populate the custom properties for the associated object. Rather than setting these property values one object at a time, you can import the property values for many objects from a Microsoft Excel file.

The Import from Excel link in the Admin Utility displays the Import from Excel window, which allows you to import custom property values for objects. Each row in the spreadsheet represents an object and each column is a property for the object. The Microsoft Excel file must be formatted as follows:

  • The first row provides the name of the property for each column, such as OUID, Checked, Labeled, and others.

  • The first column defines the OUID of the object and it must be unique. If multiple rows have the same value in the first column, the same object will be modified multiple times and the last row of values will overwrite previous row values.

  • Each column, starting with the second column, provides a value for a custom property. Make sure you have already defined each custom property and its name exactly matches the property name specified in the first row of the column.

To import custom property values from an Excel spreadsheet:

  1. In the Admin Utility, click the Import from Excel link.

  2. Click Select file.

  3. Navigate to the location of the Microsoft Excel file, select it, and then click Open.

    admin-excel-import

  4. The list below the Select file button displays the names of worksheets and name ranges from the Microsoft Excel file. The first item is selected and a preview of the first 100 rows is displayed in the grid. Click on a different worksheet or range to view information for the selected item. You can select only one item at a time.

  5. Click Select type. The Select Object Type window is displayed.

    admin-excel-object-type

  6. In Assets, select the asset with the object type you want to set the custom property values for.

  7. In Types, select the object type you want to set the custom property values for. You can also type the name of a new object type.

  8. If you want to save the custom properties as additional properties in the selected object type, clear the Save as Custom Type check box. Leaving this check box checked creates a custom object type with the custom properties.

  9. Click OK.

  10. Click Import to import the Excel file and set the property values.