Import custom property values in the Orion Platform

This topic applies to all Orion Platform products except for the following products:

ETSSCMWPM

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.

Things to consider before the import

  • The import will overwrite existing custom properties.
  • Your data must be formatted as a table.
  • At least one column title should match an existing object property, such as IP Address.
  • The import supports the following formats: .csv, .txt, .xls or .xlsx.
  • If your .xls or .xlsx file has multiple worksheets, only the first worksheet will be imported.

Import steps

  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. On Select File, browse to the custom property data file, and click Open.
  6. Select the object type you want in the Import Values For drop-down.
  7. Specify whether you want to import everything or only items that have changed, and click Next.
    • To import everything and overwrite existing values, clear the Remove unchanged rows box.
    • To overwrite only values that changed, keep the Remove unchanged rows box selected.

      This option expects that you had exported custom properties and edited some values in the exported file. Selecting the box means that before importing the file, the Orion Platform will identify the changed rows and will only import the updates.

  8. On the Match Columns tab, select an Orion Database Column for each detected 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.

    • 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.

    • 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.
  9. Click Import.

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