Server Error while trying to import RACKs

[benek984]

Getting below error while trying to import few RACKs

Example of my file

Name,Site,Status,Role,Height,Width
UK-CH-RACK01,Chesterford Office,Active,,49U,19 inches
UAE-DU-RACK01,Dubai ICS,Active,,49U,19 inches

[candlerb]

I can reproduce the exception with Netbox v3.4.8, so that ought to be fixed to give a proper data validation error.

Firstly: change the header row to

name,site,status,role,u_height,width

and try again. Now, assuming that the sites you have named do actually exist, then you should get other errors, properly shown this time (if you still get an excecption, hit the Back button on your browser to see the flash messages).

Various things you'll need to change:

• status "Active" to "active"
• u_height "49U" to "49"
• width "19 inches" to "19"

This is certainly a rather terrible user experience.

[benek984]

Thank you for you suggestion I will give it a go. However, capital first letters are done by Netbox when exporting file. I added few Racks manually then exported them so I can have template file. In this case I think Netbox should accept something that has produce themself.

[candlerb]

However, capital first letters are done by Netbox when exporting file

Sorry, but export and import CSV formats in Netbox are completely different and incompatible, so you cannot use an export as a template for an import. (It has been discussed many times before)

[jeremystretch]

There's a table directly below the import form which lists all of the supported attributes (many of which are not included in the default export template) and their formats. Please refer to this instead of trying to guess from exported data, which is intended to be used in systems outside of NetBox.