GRID to EXCEL opens generate.php page which is blank

Suite and Optimus Suite 5
#1

When i press the Grid to Excel button, I get redirected to generate.php which is a blank page.
a debug file does get created which looks like all the grid info is in there. However, no excel file. Any Ideas?
Here is the debug file:

<rows profile='color'><head><columns><column  width='310' align='center' type='ro' hidden='false' sort='str' color=''><![CDATA[Command]]></column><column  width='310' align='center' type='ro' hidden='false' sort='str' color=''><![CDATA[Completed]]></column><column  width='297' align='center' type='ro' hidden='false' sort='date' color=''><![CDATA[SentDate]]></column></columns></head>
<row><cell><![CDATA[ALARM]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-17 18:54:31]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 2]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-17 18:54:16]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 60]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-17 18:54:16]]></cell></row>
<row><cell><![CDATA[ALARM]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-16 20:24:58]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 2]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-16 09:45:59]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 60]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-16 09:45:59]]></cell></row>
<row><cell><![CDATA[BLOCK_ONLY]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-14 20:02:02]]></cell></row>
<row><cell><![CDATA[MESSAGE Hello there]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-14 15:23:48]]></cell></row>
<row><cell><![CDATA[RINGER]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-14 15:23:23]]></cell></row>
<row><cell><![CDATA[WIPE]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-14 15:21:10]]></cell></row>
<row><cell><![CDATA[LOCK 1234]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-14 15:20:23]]></cell></row>
<row><cell><![CDATA[RINGER]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-14 12:46:05]]></cell></row>
<row><cell><![CDATA[RINGER]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-07-03 21:43:35]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 3]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-26 08:46:02]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 3]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-26 08:46:02]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 3]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-26 08:32:34]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 3]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-26 08:32:34]]></cell></row>
<row><cell><![CDATA[BLOCK_ONLY]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-22 18:03:49]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 20]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-22 18:02:04]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 5]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-22 18:02:04]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 5]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-20 19:01:15]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-20 19:01:15]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 5]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-20 18:33:30]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 3]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-20 18:33:30]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 5]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-20 18:07:30]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 3]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-20 18:07:30]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 3]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-20 17:27:18]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 5]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-20 17:27:18]]></cell></row>
<row><cell><![CDATA[BLOCK_ONLY]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-18 08:25:11]]></cell></row>
<row><cell><![CDATA[BLOCK_ONLY]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-18 08:25:07]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 5]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 15:17:07]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 15:17:07]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 13:27:11]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 2]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 13:27:11]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 13:24:30]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 13:24:30]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 2]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 13:04:52]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 13:04:52]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 12:50:50]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 12:50:50]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 12:07:22]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 12:07:22]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 12:02:57]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 12:02:57]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 11:49:35]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-16 11:49:35]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 2]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 22:18:48]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 22:18:48]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 20:53:18]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 20:53:18]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 20:46:02]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 2]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 20:46:02]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 2]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 20:31:03]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 20:31:03]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 20:26:18]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 20:26:18]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 20:10:03]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 20:10:03]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 19:42:50]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 19:42:49]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 16:54:03]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 16:54:03]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 16:48:10]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 16:48:10]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 15:09:22]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 4]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 15:09:22]]></cell></row>
<row><cell><![CDATA[PHONE CHECKIN 1]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 14:00:53]]></cell></row>
<row><cell><![CDATA[GPS CHECKIN 15]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-15 14:00:53]]></cell></row>
<row><cell><![CDATA[MESSAGE 11:02 pm]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-01 20:03:49]]></cell></row>
<row><cell><![CDATA[MESSAGE 10:55 pm]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-06-01 19:56:53]]></cell></row>
<row><cell><![CDATA[MESSAGE[code]

[/code] Hi]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-05-29 21:23:50]]></cell></row>
<row><cell><![CDATA[LOCK 1234]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-05-29 20:58:30]]></cell></row>
<row><cell><![CDATA[LOCK 1234]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-05-29 20:08:57]]></cell></row>
<row><cell><![CDATA[MESSAGE Hello]]></cell><cell><![CDATA[True]]></cell><cell><![CDATA[2011-05-29 15:33:38]]></cell></row></rows>

Also here is the HTML code calling it, and I know that the paths are correct:

<img src="pdf.png" alt="PDF" onclick="jmygrid4.toPDF('../../../generate.php');" width="64px" height="64px" />
<img src="xls.png" alt="EXCEL" onclick="jmygrid4.toExcel('../../../generate.php');" width="64px" height="64px" />
<div id="mygrid4" style="width:935px; height:391px;"></div>
<script>
	jmygrid4 = new dhtmlXGridObject('mygrid4');
	jmygrid4.setImagePath('codebase/imgs/');
	jmygrid4.setHeader("Command,Completed,SentDate");
	jmygrid4.sortRows(2,"date","des");
	jmygrid4.setInitWidths("310,310,*");
	jmygrid4.enableMultiline(true);
	jmygrid4.setColAlign("center,center,center")
	jmygrid4.setColSorting("str,str,date");
	jmygrid4.setColTypes("ro,ro,ro");
	jmygrid4.setSkin("modern");
	jmygrid4.enableAlterCss("even_row","odd_row");
	jmygrid4.setStyle("background-color:#515252;color:white; font-weight:bold;", "","", "");
	jmygrid4.init();
	<?php echo "jmygrid4.loadXML(\"db.php?dbtable=command&linkid=" . $_SESSION['imei'] . "\");";?> //this is a call to a php file that get=nerates xml data
</script>
#2

Same data results in correct export locally.
Try to update php files with the attached ones.

If problem still occurs - it must be caused by the version of php , which you are using.
You can try to use the hosted version of export script.
viewtopic.php?f=23&t=18333
grid2Excel.zip (5.07 KB)

#3

Hi there, i also have the similar problem with chetstriker. I found a blank page when get redirect to generate.php. I think it’s because the number of row, but I hope that I was wrong. :slight_smile:

When I load data until 300 rows, the export action running smoothly. But when I tried to export 500 rows & more, it’s start display the blank page on generate.php. :frowning:

So I tried to see the debug file, all of data (500rows) which I want to export can displayed there But it doesn’t generate the excel file. :confused:

I used the original file from [url]Export dhtmlxGrid to Excel - DHTMLX Blog, and gridExcelWrapper.php that has been modified by radyno on [url]Different Table Header Result After Export to Excel - Suite 5.0 - DHTMLX. Here’s the file that I used server.zip (4.56 KB)I also have try to used the above script from stanislav, but it’s generate the error excell file.

Can somebody help to explain what happen in this case :question:

#4

If problem occurs with big number of rows - most possible you have hit the memory limit of php script. Try to increase it in the php.ini

#5

It’s work, thx.

#6

so easy man…send me ur generate.php code…i ll tell u the solution…

#7

I have the same problem occurs when there are characters like the accent (ó) and the letter Ñ

#8

Could you provide debug file?
By the way, try to modify your generate.php file like here:

...
$debug = true;
error_reporting(E_ALL);
//$error_handler = set_error_handler("PDFErrorHandler");
...
#9

Notice: Undefined index: grid_xml in /u01/www/component/convertgrid2excel/generate.php on line 14

Notice: Trying to get property of non-object in /u01/www/component/convertgrid2excel/gridExcelGenerator.php on line 48

Notice: Trying to get property of non-object in /u01/www/component/convertgrid2excel/gridExcelGenerator.php on line 99

Warning: Invalid argument supplied for foreach() in /u01/www/component/convertgrid2excel/gridExcelGenerator.php on line 103

Notice: Trying to get property of non-object in /u01/www/component/convertgrid2excel/gridExcelGenerator.php on line 49

Fatal error: Call to a member function attributes() on a non-object in /u01/www/component/convertgrid2excel/gridExcelGenerator.php on line 85

#10

Please, try to update dhtmlxgrid_export.js from attachment.
dhtmlxgrid_export.zip (2.79 KB)