Add a user preference for CSV delimiter #11304

Closed
opened 2025-12-29 21:43:18 +01:00 by adam · 2 comments
Owner

Originally created by @jeremystretch on GitHub (Jun 20, 2025).

Originally assigned to: @jeremystretch on GitHub.

NetBox version

v4.3.2

Feature type

New functionality

Proposed functionality

Introduce a new user preference which allows the user to override the default CSV delimiter (,) with a semicolon or other character.

Use case

Different locales use different delimiters, most notably commas and semicolons but potentially others.

Database changes

None

External dependencies

None

Originally created by @jeremystretch on GitHub (Jun 20, 2025). Originally assigned to: @jeremystretch on GitHub. ### NetBox version v4.3.2 ### Feature type New functionality ### Proposed functionality Introduce a new user preference which allows the user to override the default CSV delimiter (`,`) with a semicolon or other character. ### Use case Different locales use different delimiters, most notably commas and semicolons but potentially others. ### Database changes None ### External dependencies None
adam added the status: acceptedtype: featurecomplexity: medium labels 2025-12-29 21:43:18 +01:00
adam closed this issue 2025-12-29 21:43:18 +01:00
Author
Owner

@joernheissler commented on GitHub (Jun 21, 2025):

Perhaps related: Some users might want CSV files to start with a byte order mark, i.e. python encoding utf_8_sig.

From what I remember, Microsoft Excel won't use UTF-8 but a local encoding like cp1252 when there is no BOM, i.e. Ümläuts are garbled.

Disclaimer: I can't confirm this at the moment for lack of an Excel installation.

@joernheissler commented on GitHub (Jun 21, 2025): Perhaps related: **Some** users might want CSV files to start with a [byte order mark](https://en.wikipedia.org/wiki/Byte_order_mark), i.e. python encoding `utf_8_sig`. From what I remember, Microsoft Excel won't use UTF-8 but a local encoding like cp1252 when there is no BOM, i.e. Ümläuts are garbled. Disclaimer: I can't confirm this at the moment for lack of an Excel installation.
Author
Owner

@mkriegs commented on GitHub (Jul 22, 2025):

@jeremystretch Some values are strings that contain \n or \r, for example "Site's physical address" or "comments".
During export, the data structure breaks due to improper handling — either the values are not correctly encapsulated or they get removed entirely.

Just Open the Export in Notepad++

@mkriegs commented on GitHub (Jul 22, 2025): @jeremystretch Some values are strings that contain \n or \r, for example "Site's physical address" or "comments". During export, the data structure breaks due to improper handling — either the values are not correctly encapsulated or they get removed entirely. Just Open the Export in Notepad++
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#11304