Add configuration option for admin to set the character encoding for the CSV exports from the system
Currently the way the encoding is setup for the CSV exports from the system, it does not correctly handle when the data in the fields contains accents or special characters ( for us since we have French as an official language, this is fairly common ). This causes additional work to handle that in excel post export of the data. It would ideal to add a configuration that the administrator can setup to configure the character encoding used by the CSV export function across the system.
Comments: 1
Oldest
•
Newest
•
Most likes
•
Fewest likes
-
25 Jul, '23
Terry JuddHighlighted comment
Related to this, I'd like to include the ability to escape certain characters during the export process, and I'm thinking in particular of line breaks/returns within text elements (blueprints) that are included as fields in a report. At the moment these are retained as is, which is fine I guess if you want to open the csv file in Excel, which converts them to soft returns, but is a complete PITA if you want to process your data further elsewhere and you need to ensure that it really is 'one record per line'.