search

meeting-room-booking-system / mrbs-code

MRBS application code
Other
124 stars 61 forks source link

CSV Export is in "Jibberish" #2095

Open jberanek opened 6 years ago

jberanek commented 6 years ago

When running a report, the HTML version looks great but the CSV comes out in jibberish.

Reported by: *anonymous

Original Ticket: mrbs/support-requests/1384

jberanek commented 6 years ago

What are you trying to read it with? By default the CSV reports are designed to open sensibly with Microsoft Excel for Windows and are produced in UTF-8 with no BOM, and with new lines (\n) for row separators and commas for column separators.

You need to play around with either your program's character set settings and/or the CSV settings for MRBS. See the section "CSV format" in systemdefaults.inc.php.

Original comment by: campbell-m

jberanek commented 6 years ago

I opened it in notepad as well as Excel and they both did it

Original comment by: *anonymous

jberanek commented 6 years ago

Which version of Excel and for which platform? You should be able to change the settings in Excel when you open it.

Original comment by: campbell-m

jberanek commented 6 years ago

Windows, Excel 2017. When I do a Data --> From Text nothing changes

Original comment by: *anonymous

jberanek commented 6 years ago

Thanks. Some more questions:

(1) What is your webserver platform? (The answer is on the Help page when logged in as an admin) (2) What are the values of $csv_charset and $csv_bom in your config file?

Original comment by: campbell-m

jberanek commented 6 years ago

One other thing that would help is if you could post a sample .csv file, provided that it doesn't contain any confidential data. I you create a test booking, run an HTML report that just produces that test booking and then re-run it the same report to produce a .csv file.

Original comment by: campbell-m