Fixing the CSV export so that it is compliant to the CSV standard RFC 4180.
The export was also fixed so that it removes columns when they are unchecked in the report options.
These changes were made:
Change the CSV delimiter to a comma
Escape double quotes and commas
Change CSV MIME type to text/csv
Change column filtering so all "screen" columns can be removed and the Status column removes the "export" columns as they seem to be analogous
Benefits:
Excel recognises the CSV as a CSV
Fields with a semi-colon in them no longer make the result unparsable
Commas are no longer removed from fields
Exports can now be filtered to only the columns of interest
Fixing the CSV export so that it is compliant to the CSV standard RFC 4180. The export was also fixed so that it removes columns when they are unchecked in the report options.
These changes were made:
Benefits:
Fixes issues:
29
63