Using bulk import
NetIM supports bulk operations using properly formatted CSV files on devices, interfaces, links, and groups/sites.
Bulk import provides a simple, easy-to-use means of manually augmenting your NetIM model. For example, NetIM’s Bulk Import can be used to create a few devices from a simple CSV file.
The CSV file contains deliberate errors (an extra field and a missing required cell value) to illustrate how the Bulk Import WebUI detects errors and allows you to repair the errors before import.
Bulk import limitations
Bulk import has the following limitations:
• Bulk Import delete operations must reference existing objects for proper operation. Failing to do so may result in the creation of an object.
• Bulk import does not support wrapping of import fields in quotes or double quotes
Instead, you must use a delimiter other than the default comma to import data such as sysUptime. For example, to import a sysUptime of 1 days, 1 hours, 1 minutes, 1 seconds you should use a delimiter other than the default comma and leave the sysUptime string as-is.
• Bulk Import does not support the inclusion of a header in the text file to import.
All lines are treated as data to import. Including a header in the input file will result in an error or erroneous data from the header being imported into the database.
• Bulk Import requires that ifAdminStatus and ifOperStatus values be supplied in their numeric, integer value, not string value.
Supplying string values will result in a failure to import the values. See RFC2863 or the IF-MIB for a definition of the supported integer values.
Working with bulk import
To perform a bulk import
1. Log in to the UI as admin.
2. Choose Configure > All Settings > Customize > Bulk Import.
3. Work with Bulk Import – Devices
The following operations are supported for bulk devices:
– Create Device
– Delete Device
– Set Device Properties
4. Work with Bulk Import – Interfaces
The following bulk operations supported for interfaces:
– Create Interface
– Create Subinterface
– Delete Interface
– Delete Subinterface
– Set Interface Address
– Set Interface/Subinterface Address Properties
– Set Subinterface Address
5. Work with Bulk Import – Groups
The following bulk operations are supported for groups:
– Add Device to Group
– Create Group
– Create Subgroup
– Delete Group
– Delete Subgroup
– Remove Device from Group
6. Work with Bulk Import – Links
The following bulk operation are supported for links:
– Create Link (by interface preferred name)
– Create Link (by interface index)
– Create Link (by interface name)