Opmantek How-To: Quickly import devices from CSV into Open-AudIT

Join Paul McClendon, an Opmantek Support Engineer, as he demonstrates how to import devices, using a CSV file, into Open-AudIT.

It is possible to import one or many devices using a CSV file, Audit Script Result or an NMIS Nodes file.

Go to menu: Manage -> Devices -> Import Devices from CSV (you can also choose Audit Script Result or NMIS Nodes file.)

Below is an example of the required CSV format:

The minimum required attributes for attributes are ‘name’ and ‘org_id’.

You should not include the edited_by and edited_date fields. These will be automatically set.

If you include the “id” field and set it with a number, that item will be updated rather than created.

You should use a header line containing the names of the columns you wish to populate, then your data lines below that.