- Edited
Dear CitrixraptorThank you very much for reply and help. It is working fine in ajax.report.php. I found button in ajax file and I do not know Ajax, thats why I will try to add button in php, somewhere in dashboard.php.Best regardsOrik3ll0
Divide Colums in exported CSV file
- Edited
Dear Citrixraptor.I added button and just noticed that unicode is not working. I added charset=UTF-8 in header and still I have unicode problem. How can I solve this unicode problem?Best RegardsOrik3ll0
- Edited
"ЛОЖЬ" means lie. I do not know why it write it... i do not have it in my table
- Edited
Hello orik3ll0,>> "ЛОЖЬ" means lie. I do not know why it write it... i do not have it in my tableOk ... ЛОЖЬ is the result of non utf8 coding ! ... see 01.jpg !!!Add the yellow highlighting code in your reporting php file:$objPHPExcel = new PHPExcel();$conn = mysql_connect('localhost', 'root', 'password');mysql_set_charset('utf8',$conn);if (!$conn) { die('Could not connect: ' . mysqli_error());}... now the utf8 coding is ok ... for example: äüöß and your ЛОЖЬ ... i use both as example username;-)see 02.jpg and 03.jpgMy example user page in the osticket database.see 03.jpg Hope, this solve your UTF8 problemBest Regardscitrixraptor
- Edited
Dear CitrixraptorThank you very much for help and reply, it helped me and works perfect!) Please do not close topic, because maybe I will have 1 more question.Best RegardsOrik3ll0
- Edited
Hello orik3ll0,
>> Thank you very much for help and reply, it helped me and works perfect!)
You are welcome ... i think a nice thread also for other people in the forum :-)
>> Please do not close topic, because maybe I will have 1 more question.
Mh ... Ok
Best Regards
citrixraptor
- Edited
Hi citrixraptor,I try your trick with semi coma in /upload/include/ajax.reports.php (better open csv in excel), but it is not work. osTicket 1.9.14. (I replace coma with semi coma, but export file with tickets steel contains coma).Steve
- Edited
Hi,bbetter export to excel I solved add str_replace function to replate cona with semi coma for output.File: /include/class.export.phpOriginal:if ($stuff) Http:($filename, "text/$how", $stuff);New:$stuff = str_replace(',', ';', $stuff); // replaceif ($stuff) Http:($filename, "text/$how", $stuff);