Export function changing & to & in csv file

dalepmay

When exporting CSV files from osTicket, fields with & are being changed to &. Example: what appears in osTicket UI as 'A&W' would appear in the exported csv file as 'A&W'. What file would I edit to change this? I have tried almost every file that contains '&', but no luck so far.

KevinTheJedi

dalepmay

I believe it’s going to dump the raw content from the database. You can look at the exported and how it calls the fields to get the values and go from there.

Cheers.

dalepmay

KevinTheJedi
I thought that too, but the raw data in the DB only contains the &. If I wasn't already bald, I'd be pulling my hair out right now.

KevinTheJedi

dalepmay

Then it sounds like it’s doing htmlspecialchars or converting to HTML entities somewhere.

Cheers.

dalepmay

KevinTheJedi

Thanks for the ideas, but I can't seem to find where it would be doing that. The issue is in the ost_department.name field. Works perfectly when I export from the Dashboard. But from ticket view, exporting does the modification. I have tried editing everywhere I can think of in the class.export.php file, no luck. Thanks again for your suggestions.