Export/Import CSV - Devices doesn't work to import

[mroupie34]

Hello everyone,

I need your help about this issue.
I got an error when i import the CSV.

Inside the CSV when i export them :

Inside the CSV when i import them :

Do you know if this bug wil be resolved ?

What can I do while waiting ? Do you have a solution about that ?

Version Netbox : 3.6.1

Thanks a lot for yourfeedback,
Best regards,

Maxime ROUPIE
Engineer Systems and Network
Koesio Corporate IT

[candlerb]

Netbox's CSV Export and Import are completely different formats, and are not compatible with each other. This is documented in the FAQ. So unfortunately, you can't use the export data to guide what correct import data might look like.

When you import some data from a CSV (even if it's the wrong format) you shouldn't be able to trigger a Python exception, so there is a bug here.

However, it's not possible to reproduce your bug from screenshots of spreadsheets. Please provide plain text than can be copy-pasted into the import box.

If you can't provide data which can reproduce the bug, then at least provide the backtrace (set DEBUG=True, and/or set ADMINS and EMAIL, in configuration.py)

There is a known issue where if you give unexpected column names, they are ignored. Hence if you give a column called (say) "Role" where it should be "role", it's as if you didn't give the column at all. See #11617 - although in future they won't be case sensitive, see #13775. This might be why your upload is failing and seeing "None" where it should see some real data.

For another example of the sorts of problems you can get with bad CSV data, see #12259 (comment)

[mroupie34]

Hello,

Anyway, it's for exported "Rack" and then imported with all data.

For example my template :

Template-import-dbs-devices.csv

But i got an error :

I don't know if it's possible or not because the nomenclature in Netbox is like this on the column "Rack" :

Thanks a lot for your feedback,
Max

[candlerb]

The allowed fields in a CSV upload are documented on the import page:

You've put column "rack_id" when it should be "rack". That's invalid, and as I explained before, is currently treated the same as if you'd left the column out completely. That's why Netbox is complaining that you didn't specify the rack.