View Issue Details

IDProjectCategoryView StatusLast Update
0007255OXID eShop (all versions)2.8. Servicepublic2021-08-10 15:54
Reporterxeruf Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version6.1.5 
Summary0007255: CSV Export is faulty
DescriptionThere are multiple issues with the csv export as it is, all of them should not be hard to fix:
- the file should be a .csv not a .txt file
- if there is no user defined header, it would be handy if there was an auto-generated one with the field names
- if the CSV-Encloser appears in the text, it needs to be escaped

The last point is especially nasty, as that currently produces invalid csv files.
See https://datatracker.ietf.org/doc/html/rfc4180#section-2
If double-quotes are used to enclose fields, then a double-quote appearing inside a field must be escaped by preceding it with another double quote.
Steps To ReproduceDo a csv export
TagsCSV, Export
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Activities

xeruf

2021-08-10 15:53

reporter   ~0013473

Furthermore, newlines from the description are not exported, which is the whole point of using a quoting character ^^