Suite 7.10.10 - unable to export to CSV


#1

HI Val, with our latest upgrades to Suite we can no longer export to CSV. those that have the extended version can export to PDF and Excel. but CSV does not work. this goes for 4.4 as well.


#2

Hi Stephen, it works well on my SuiteCRM 7.10.10.
Can you detail “CSV does not work”?
Does the button to export not appear even if it set properly?
No file at all is generated
A file is generated but is empty?
Which browser is it?
Any errors in php error log or suitecrm log?


#3

Hi Val, the webpage goes to this site cannot be reached.
errors from error_log
Stack trace:
#0 /home/upgrade/public_html/modules/KReports/Plugins/Integration/kcsvexport/controller/pluginkcsvexportcontroller.php(53): KReport->createCSV(NULL)
#1 /home/upgrade/public_html/modules/KReports/KReport.php(319): pluginkcsvexportcontroller->action_export(Array)
#2 /home/upgrade/public_html/KREST/extensions/KReporter.php(169): KReportPluginManager->processPluginAction(‘kcsvexport’, ‘action_export’, Array)
#3 [internal function]: {closure}(‘kcsvexport’, ‘export’)
#4 /home/upgrade/public_html/KREST/Slim/Route.php(468): call_user_func_array(Object(Closure), Array)
#5 /home/upgrade/public_html/KREST/Slim/Slim.php(1357): Slim\Route->dispatch()
#6 /home/upgrade/public_html/KREST/Slim/Middleware/Flash.php(85): Slim\Slim->call()
#7 /home/upgrade/public_html/KREST/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call()
#8 /home/upgrade/public_html/KREST/Slim/CorsSlim.php(117): in /home/upgrade/public_html/modules/KReports/KReport.php on line 1067
[14-Dec-2018 11:07:05 Europe/London] PHP Fatal error: Uncaught Error: [] operator not supported for strings in /home/upgrade/public_html/modules/KReports/KReport.php:1067
Stack trace:
#0 /home/upgrade/public_html/modules/KReports/Plugins/Integration/kcsvexport/controller/pluginkcsvexportcontroller.php(53): KReport->createCSV(NULL)
#1 /home/upgrade/public_html/modules/KReports/KReport.php(319): pluginkcsvexportcontroller->action_export(Array)
#2 /home/upgrade/public_html/KREST/extensions/KReporter.php(169): KReportPluginManager->processPluginAction(‘kcsvexport’, ‘action_export’, Array)
#3 [internal function]: {closure}(‘kcsvexport’, ‘export’)
#4 /home/upgrade/public_html/KREST/Slim/Route.php(468): call_user_func_array(Object(Closure), Array)
#5 /home/upgrade/public_html/KREST/Slim/Slim.php(1357): Slim\Route->dispatch()
#6 /home/upgrade/public_html/KREST/Slim/Middleware/Flash.php(85): Slim\Slim->call()
#7 /home/upgrade/public_html/KREST/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call()
#8 /home/upgrade/public_html/KREST/Slim/CorsSlim.php(117): in /home/upgrade/public_html/modules/KReports/KReport.php on line 1067


#4

Thanks Stephen.
I can’t reproduce the error. I tried under php 5.6, 7.0, 7.1
The retrieved data might contain some special char that breaks the processing of the results.
Can you catch the content of $results just to see if have any?
Can you catch the content of $whereSelectionArray and post it ?

modules/KReports/KReport.php on line 1067