Import Virtual Machines with Interfaces and IP's

[Kevin W]

Hi, I want to import 100+ Virtual machines. I have a CSV which includes all the info for each VM, including IP's. My question is related to, what is the easiest and correct way to import al these VM's, Interfaces with IP's please?

Kind regards.

[Brian Candler]

Sadly, creating or importing VMs does not automatically create interfaces:

https://github.com/digitalocean/netbox/issues/1492

and there's no CSV import for interfaces:

https://github.com/digitalocean/netbox/issues/822

I did it by direct SQL import, but the recommended approach is to do it via the REST API, or python shell if you can get to grips with Django's ORM:

https://github.com/digitalocean/netbox/issues/1501

https://netbox.readthedocs.io/en/latest/miscellaneous/shell/

Version 2.3.0 recently added support for bulk object creation via the API:

https://github.com/digitalocean/netbox/pull/1913

You would have to create all the VMs in one call (to learn the database-assigned IDs), then create all the interfaces in another, and then all the IPs is another.  AFAIK there's no way to import a 'tree' of related objects in a single call.

HTH,

Brian.

[Joseph Wegner]

I made a script to automate synchronization between vCenter and Netbox in PowerCLI: https://github.com/jwegner89/netbox-utilities/blob/master/Sync-Netbox.ps1

[Chris Petrolino]

Great job! This is extremely helpful.....