Netbox 3.5.0 Bulk Import Issues regarding Tags #8041

Closed
opened 2025-12-29 20:31:38 +01:00 by adam · 2 comments
Owner

Originally created by @ahantzes on GitHub (May 11, 2023).

NetBox version

v3.5.0

Python version

3.8

Steps to Reproduce

  1. Create a CSV file to import IP ranges
  2. When entering tag slugs into the CSV, follow the syntax used in the "tag" field's description in the Field Options table for IP Range Bulk Import

image

  1. Upload and Submit CSV file via the Upload File tab of the IP Range Bulk Import page

Expected Behavior

CSV file should successfully import the new IP ranges, including their intended tags.

Observed Behavior

An error message pops up:

image

CSV will only be able to successfully import new IP ranges if the tag slugs are not encased in double quotes, and are just separated with commas.

Examples:

this formatting will raise the error message
image

this formatting will import without issue
image

This behavior suggests either an inaccuracy in the Field Options table, or an error within the Bulk Import feature.

If it is a matter of inaccurate information, then the issue may also affect Bulk Imports overall, as I have not been able to find any mention of Tags in any of the Field Options tables that does not instruct the user to encase the slugs in double quotes. If this is an error with the Bulk Importing feature itself, then I can only verify this behavior for importing IP Ranges, as I have not yet had an opportunity to attempt importing anything else as of the writing of this report

Originally created by @ahantzes on GitHub (May 11, 2023). ### NetBox version v3.5.0 ### Python version 3.8 ### Steps to Reproduce 1. Create a CSV file to import IP ranges 2. When entering tag slugs into the CSV, follow the syntax used in the "tag" field's description in the Field Options table for IP Range Bulk Import > ![image](https://github.com/netbox-community/netbox/assets/133260991/a708769a-373a-4824-a579-5b2b39f727e7) 3. Upload and Submit CSV file via the Upload File tab of the IP Range Bulk Import page ### Expected Behavior CSV file should successfully import the new IP ranges, including their intended tags. ### Observed Behavior An error message pops up: > ![image](https://github.com/netbox-community/netbox/assets/133260991/c1b9dbe2-7239-41d2-8b98-80074d0f9c53) CSV will only be able to successfully import new IP ranges if the tag slugs are not encased in double quotes, and are just separated with commas. Examples: > this formatting will raise the error message ![image](https://github.com/netbox-community/netbox/assets/133260991/bf14822d-b2ee-4f3f-8105-10e4166ac9d6) >this formatting will import without issue ![image](https://github.com/netbox-community/netbox/assets/133260991/07519626-1580-42f7-94fd-975f0fc0e75d) This behavior suggests either an inaccuracy in the Field Options table, or an error within the Bulk Import feature. If it is a matter of inaccurate information, then the issue may also affect Bulk Imports overall, as I have not been able to find any mention of Tags in any of the Field Options tables that does not instruct the user to encase the slugs in double quotes. If this is an error with the Bulk Importing feature itself, then I can only verify this behavior for importing IP Ranges, as I have not yet had an opportunity to attempt importing anything else as of the writing of this report
adam added the type: bugstatus: revisions needed labels 2025-12-29 20:31:38 +01:00
adam closed this issue 2025-12-29 20:31:38 +01:00
Author
Owner

@kkthxbye-code commented on GitHub (May 11, 2023):

Try to open the failing CSV in a text editor, or upload the CSV here. I think you are double quoting without realizing it.

@kkthxbye-code commented on GitHub (May 11, 2023): Try to open the failing CSV in a text editor, or upload the CSV here. I think you are double quoting without realizing it.
Author
Owner

@ahantzes commented on GitHub (May 11, 2023):

Try to open the failing CSV in a text editor, or upload the CSV here. I think you are double quoting without realizing it.

I hadn't thought to check it in a text editor, but yeah, you're right. when I did, every entry that was encased with a single pair of double quotes was being saved by excel as an entry encased with three pairs of quotes. I don't really know what causes that, but regardless this issue doesn't appear to be the fault of Netbox so I'll go ahead and close this report. thank you for pointing this out to me.

@ahantzes commented on GitHub (May 11, 2023): > Try to open the failing CSV in a text editor, or upload the CSV here. I think you are double quoting without realizing it. I hadn't thought to check it in a text editor, but yeah, you're right. when I did, every entry that was encased with a single pair of double quotes was being saved by excel as an entry encased with three pairs of quotes. I don't really know what causes that, but regardless this issue doesn't appear to be the fault of Netbox so I'll go ahead and close this report. thank you for pointing this out to me.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#8041