Bulk import prefixes with associated VLAN not working when multiple VLANs with the same vid exist.

[gabrielmarmen]

Deployment Type

Self-hosted

NetBox Version

v4.2.3

Python Version

3.12

Steps to Reproduce

1. Create multiple VLAN entries with the same vid but associated to different sites. I use this to represent VLANs with the same vid, but located in different sites with different prefixes.

2. Import prefix csv with the following fields: prefix, status, role, scope_type, scope_id, vlan. Include the previously added VLANs vid in the "vlan" field.

3. The import will fail because multiple vlans with the same vid exist

Expected Behavior

Import succeeds associating the right vlan depending on the DCIM.site value. The import should use the VLAN with the specified vid contained in the specified scope (site).

To fix this issue, it could also be possible to specify the VLAN object ID instead of the vid to avoid confusion.

Observed Behavior

Import fails with error :

[jeremystretch]

Please provide the specific data you're using to reproduce the bug.

[steve-hbt]

Please provide the specific data you're using to reproduce the bug.

Hi, same issue here in 4.2.1

Here my csv import :

prefix;status;scope_type;scope_id;vlan
192.168.65.0/24;active;dcim.site;13;565
172.17.65.0/24;active;dcim.site;13;17
172.23.65.0/24;active;dcim.site;13;23
10.88.65.0/24;active;dcim.site;13;888
172.18.65.0/24;active;dcim.site;13;18
172.16.65.0/24;active;dcim.site;13;16

And error : Record 2 vlan: "17" is not a unique value for this field; multiple objects were found

VLAN ID 565 is unique and others VLAN exists on all my others sites.
VLAN 17 is created on my site id "13"

Thanks !

[gabrielmarmen]

Please provide the specific data you're using to reproduce the bug.

Hi, same issue here in 4.2.1

Here my csv import :

prefix;status;scope_type;scope_id;vlan
192.168.65.0/24;active;dcim.site;13;565
172.17.65.0/24;active;dcim.site;13;17
172.23.65.0/24;active;dcim.site;13;23
10.88.65.0/24;active;dcim.site;13;888
172.18.65.0/24;active;dcim.site;13;18
172.16.65.0/24;active;dcim.site;13;16

And error : Record 2 vlan: "17" is not a unique value for this field; multiple objects were found

VLAN ID 565 is unique and others VLAN exists on all my others sites. VLAN 17 is created on my site id "13"

Thanks !

Thanks, this corresponds to approximatly what I have.

[majorwolf]

Encountered this issue today on 4.2.1. The only workaround was to remove the conflicting VLAN ID's and then manually reassign them after they got added.

In this case, we have two sites with conflicting VLAN ID's. The import function doesn't seem to check the site ID first before checking the VLAN ID to see if it conflicts.

[jeremystretch]

@Steve-Hubert @gabrielmarmen @majorwolf would any of you like to volunteer for this work?

[steve-hbt]

@Steve-Hubert @gabrielmarmen @majorwolf would any of you like to volunteer for this work?

@jeremystretch I can do tests if needed