Univention Bugzilla – Bug 57142
Strings in class list export are not always quoted
Last modified: 2024-03-13 14:43:11 CET
For the class lists, we have one requirement that states that users can open them in libreoffice and excel without having to adjust any settings. Libreoffice (LibreOffice 7.6.5.2) will open CSV files and interpret tabs, semi-colons and commas as separators. If a semicolon or comma is present in the first or last name of a student this will violate the above requirement because the strings (firstname, lastname, class, username) are not being quoted and they will be interpreted as separators. As first names and last names usually do not have commas/semicolons, this is unlikely to be a problem, but if we add any new data column in the future which can contain commas/semicolons we may want to quote all strings in a class list export to avoid any customer confusion.
(In reply to Johannes Königer from comment #0) > As first names and last names usually do not have commas/semicolons, this is > unlikely to be a problem, but if we add any new data column in the future > which can contain commas/semicolons we may want to quote all strings in a > class list export to avoid any customer confusion. I did not realize we had this feature already: `ucsschool/umc/lists/class/attributes` can be set so other udm-attributes are included in the export. So for example when adding the attribute `description` to the export, the chance is very high to get comma/semicolons in there. It is still 'only' a nuisance, as you can just adjust your import settings in libreoffice, but it does not fulfill our originally set requirements to the class list export.