Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Configuration Manager (NCM) > NCM 7.7 Administrator Guide > Custom properties > Import custom property data

Import custom property data

Table of contents
No headers
Created by Caroline Juszczak, last modified by Anthony.Rinaldi_ret on Jan 26, 2017

Views: 28 Votes: 0 Revisions: 7

If you have a spreadsheet listing custom property values, such as asset tags of all your network nodes, you can make this information available for reporting and publication in the Orion Web Console.

Your data must be formatted as a table, and at least one column title should match an existing object property such as IP Address.

  1. Log in to the Orion Web Console as an administrator.
  2. Click Settings > All Settings in the menu bar.
  3. In the Node & Group Management grouping, click Manage Custom Properties.
  4. Click Import Values.
  5. Browse to the custom property data file, and click Open.
  6. Select the object type you want in the Import Values For drop-down, and click Next.
  7. For each detected Spreadsheet Column in your data, select the corresponding Orion Database Column, and select the Relationship between the columns.
    • Select Matches to indicate columns in the spreadsheet that correspond to existing columns in the SolarWinds Orion database, such as IP Address or MAC address.

      File:Success_Center/New_Articles/NPMAG_forMT_final/CO0/CustomProperties_Import_matches.png

    • Select Imports To to import the data in the spreadsheet column to the selected SolarWinds Orion database column.

      This option overwrites any existing data in the corresponding custom properties.

    • Select Imports To, and select <No Match Found, Ignore> for any spreadsheet column you do not want to import.

      File:Success_Center/New_Articles/NPMAG_forMT_final/CO0/CustomProperties_Import_noMatchIgnore.png

    • Click Create This Custom Property Now to open the Add Custom Property in a new browser tab if you need to create a custom property for this spreadsheet column.
  8. Click Import.

When you view the values of the object type, the values of the custom property you selected are populated.

 

Last modified

Tags

Classifications

Public