SolarWinds uses cookies on our websites to facilitate and improve your online experience. By continuing to use our website, you consent to our use of cookies. For further details on cookies, please see our cookies policy.

Overview

Environment

IPAM version 4.x

Steps

Create a .csv, .xls, or .xlsx spreadsheet. This needs a column showing the Type (i.e. subnets, groups, supernets, IPv6 Subnets, IPv6 sites and global prefixes) of each entity being imported. This is the only required field. You can also add the following:

Address/CIDR

Address

Mask

CIDR

Display Name

Group Description

Scan Interval

Node Expunge Interval

Retain User Data (Y/N)

Transient Period

Disable Auto Scanning (Y/N)

Disable Neighbor Scanning (Y/N)

Neighbor Scan Address

Neighbor Scan Interval

VLAN

Location

Additional columns can be created and then imported by creating custom fields in step 11.

Go to My Dashboards > IP Addresses > Manage Subnets and IP Addresses.

Click Import > Import spreadsheet.

If you have not selected to hide it, the Preparing to import a spreadsheet is displayed.
This screen gives links to example spreadsheets for importing IP addresses and Subnets. You can also find these sample import spreadsheets located on your primary poller within the directory: inetpub\SolarWinds\Orion\IPAM\res\samples. Click Next to continue.

Select the spreadsheet you want to import.

Select Group/Supernets/Subnets, and click Next.

Match the IPAM column names to the column names within the spreadsheet using the dropdown buttons.
Select "[Do not import]" if you do not want to import a field.

Select whether you want IPAM to create the subnet hierarchy from the information provided or to import into a single folder called Subnet/Supernet/Group which you can organize later. Click Next.

The information is now validated and any problems displayed.

If there are problems, the columns or portions are displayed in red. If you need help in determining the problem, export the results to spreadsheet to check. Adjust as needed and re-import.

A common error is caused by trying to import a blank field when IPAM is expecting Y or N, such as Retain User Data. In this case, select "[Do not import]" from the field dropdown.

If errors involve IP addresses and CIDRs, you can use a subnet calculator such as that provided by MXToolBox (external link, checked 6/21/18) to verify addresses and CIDRs.

If your spreadsheet has additional columns that you want to add to IPAM, a Custom Fields page is displayed. Here you can click Add Custom Field to add this column as a custom field.