I am using the Reports module to export CSV format reports of the data within my database.
Unfortunately, if any fields from the database (such as a descriptive text field) contains a comma within it, this then ‘breaks’ the exported CSV file. I believe that this is because the generated CSV file, only separates the filed values with commas (,), but it does not wrap them in quotes (" "), therefore a field such as
Find free cycle support available, such as cycle training, journey planning, cycle maintenance courses, cycle mapsthen displays as 5 fields instead of one!
I am using the default “UTC-8” encoding (Import/Export Character Set), set in both the Admin -> Locale and User Managment / User / Advanced.
I have tested that exporting data directly from the other modules (Organisations, Contacts, etc) does export to CSV, enclosing field values in quotes as expected:
"Action","bcdacf5d-dcc6-0ea8-c1db-5666ba3e4281","Find free cycle support available, such as cycle training, journey planning, cycle maintenance courses, cycle maps","0","general","Ongoing","01/03/2016","","","","","","year2","active"
Why, therefore, does the report module export data differently and how can this be fixed?