#39 Data Import

[Anonymous]

Hi

As for today we've got a MS Excel table with all our racks and devices. Now since there are around 600 devices in our data center, it'd be way too much work to list them all again. So my question: is there a possible way of importing those data from like a csv file?

Greetings

[Jesse Becker]

The database schema is pretty simple, and a DBA should be able to make quick work of a CSV file.

That said, a generalized import script is tricky to write (but not impossible), since various tables have to be populated before the actual devices can be entered. For example, you have to define the racks and hardware type in two separate tables before you can add a specific device.

[Jesse Becker]

The database schema is pretty simple, and a DBA should be able to make quick work of a CSV file.

That said, a generalized import script is tricky to write (but not impossible), since various tables have to be populated before the actual devices can be entered. For example, you have to define the racks and hardware type in two separate tables before you can add a specific device.