Empty location field breaks bulk-import #8667

New Issue

adam · 2025-12-29T20:39:37+01:00

adam commented

2025-12-29 20:39:37 +01:00

Originally created by @ekrichbaum on GitHub (Sep 22, 2023).

Originally assigned to: @jeremystretch on GitHub.

NetBox version

v3.6.2

Python version

3.8

Steps to Reproduce

Given data:
site named import-test
rack named import-rack in site import-test
device role named import-role
manufacturer named import-manufacturer
device-type named import-device with manufacturer of import-manufacturer

CSV data:

name,role,serial,description,manufacturer,device_type,airflow,status,site,location,rack,position,face
,import-role,3412341,,import-manufacturer,import-device,front-to-rear,active,import-test,,import-rack,,
,import-role,kljadf123,,import-manufacturer,import-device,front-to-rear,active,import-test,,import-rack,,

Steps to replicate import failure:
Devices -> Devices -> Import.
Paste data to direct import text box.
Submit.

Expected Behavior

Devices from csv would be imported.

Observed Behavior

Removing the location field (and leaving other empty fields) successfully imports devices.

New CSV:

name,role,serial,description,manufacturer,device_type,airflow,status,site,rack,position,face
,import-role,3412341,,import-manufacturer,import-device,front-to-rear,active,import-test,import-rack,,
,import-role,kljadf123,,import-manufacturer,import-device,front-to-rear,active,import-test,import-rack,,

Devices import as expected.

Originally created by @ekrichbaum on GitHub (Sep 22, 2023). Originally assigned to: @jeremystretch on GitHub. ### NetBox version v3.6.2 ### Python version 3.8 ### Steps to Reproduce Given data: site named import-test rack named import-rack in site import-test device role named import-role manufacturer named import-manufacturer device-type named import-device with manufacturer of import-manufacturer CSV data: ``` name,role,serial,description,manufacturer,device_type,airflow,status,site,location,rack,position,face ,import-role,3412341,,import-manufacturer,import-device,front-to-rear,active,import-test,,import-rack,, ,import-role,kljadf123,,import-manufacturer,import-device,front-to-rear,active,import-test,,import-rack,, ``` Steps to replicate import failure: Devices -> Devices -> Import. Paste data to direct import text box. Submit. ### Expected Behavior Devices from csv would be imported. ### Observed Behavior ![image](https://github.com/netbox-community/netbox/assets/11653069/d1b7767f-94d1-4f50-ac9a-cc1efebf0282) Removing the location field (and leaving other empty fields) successfully imports devices. New CSV: ``` name,role,serial,description,manufacturer,device_type,airflow,status,site,rack,position,face ,import-role,3412341,,import-manufacturer,import-device,front-to-rear,active,import-test,import-rack,, ,import-role,kljadf123,,import-manufacturer,import-device,front-to-rear,active,import-test,import-rack,, ``` Devices import as expected.

adam added the type: bug status: accepted severity: medium labels 2025-12-29 20:39:37 +01:00

adam closed this issue

2025-12-29 20:39:38 +01:00

Sign in to join this conversation.

Branches Tags

main

update-changelog-comments-docs

feature-removal-issue-type

20911-dropdown

20239-plugin-menu-classes-mutable-state

21097-graphql-id-lookups

feature

fix_module_substitution

20923-dcim-templates

20044-elevation-stuck-lightmode

feature-ip-prefix-link

v4.5-beta1-release

20068-import-moduletype-attrs

20766-fix-german-translation-code-literals

20378-del-script

7604-filter-modifiers-v3

circuit-swap

12318-case-insensitive-uniqueness

20637-improve-device-q-filter

20660-script-load

19724-graphql

20614-update-ruff

14884-script

02496-max-page

19720-macaddress-interface-generic-relation

19408-circuit-terminations-export-templates

20203-openapi-check

fix-19669-api-image-download

7604-filter-modifiers

19275-fixes-interface-bulk-edit

fix-17794-get_field_value_return_list

11507-show-aggregate-and-rir-on-api

9583-add_column_specific_search_field_to_tables

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/netbox#8667