Document toolboxDocument toolbox

Importing Custom Field Data

Owned by Viktoryia Varapayeva (Deactivated)
Last updated: Aug 23, 2022
2 min read

As a labor-saving move, and a way to enforce a design and data standard for all custom data fields you wish to define in the appliance, you can create one or more device custom data fields in any of the six categories (Changes, Devices, Interfaces, Job News, Jobs or Components), or import bulk data to populate the fields for Devices, Interfaces or Components data types. Each record is comma-delimited. Place the data in a CSV file having the following syntax:

For Devices:

<VirtualNetworkName>,<DeviceIPAddress>,<CustomFieldName>,<CustomFieldValue> first_network,192.168.2.1,Numeric_ID,2

For Interfaces:

<VirtualNetworkName>,<DeviceIPAddress>,<InterfaceName>,<CustomFieldName>,<CustomFieldValue> first_network,192.168.2.1,eth3,Identifier,inbound_marketing

For Components:

<VirtualNetworkName>,<DeviceIPAddress>,<PhysicalName>,<CustomFieldName>,<CustomFieldValue> first_network,192.168.2.1,eth3,Identifier,inbound_marketing

For all custom field entries, the Virtual Network Name field is optional. When it is not defined, a search is performed for a device not included in any virtual network view.

Examples:

first_network,192.168.1.2,lo,integer_custom_field,2

second_network,192.168.1.3,eth0,string_custom_field,something_cool

To import bulk custom data of any type, do the following:

  1. In the upper left corner of the Settings icon > General Settings > Custom Fields page, open the Type menu and choose Devices, Interfaces or Components depending on the application. These are the only three Custom Field categories that support
  2. Click Import. The Import Custom Field Data dialog opens.
  3. Click Browse, then locate and select the bulk data CSV file.
  4. Click Import.
  5. Under Network Analysis > Changes, view the table of recent changes to devices in the network.
  6. Move the mouse over any column in the table, and click the down arrow at the right end of the column heading.
  7. In the drop-down menu, hover over Columns.
  8. In the Columns submenu, check the custom field column(s) you want to appear in the table. The table will update to display the new column of data.

Also, see Viewing Changes in the Network for more information about the Changes page in NetMRI.