Universal Data Exporter PHP Support Product Page
excel and large table
Asked 06 Dec 2010 17:36:16
1
has this question
06 Dec 2010 17:36:16 Berrodier Christophe posted:
Hi,I have problems to export to excel a recordset (in a table) with more than 6 columns.
if there are more than 6 columns the excel file is empty.
I have another problem as well, i can't have more than 500 lines in the excel (or pdf file) even if the recordset (table) is bigger.
Any idea ?
Thanks a lot
Replies
Replied 10 Mar 2011 13:53:04
10 Mar 2011 13:53:04 Dan Ove Tuven replied:
I had the same problem, though I could receive up to 800-900 records successfully. More than 900 results in a blank excel sheet.
So I tried to put the following two lines of code above the UDE script on the page:
set_time_limit(0);
ini_set('memory_limit','-1');
Then I could receive thousands of records, so it seems that UDE reaches a timeout which breaks the data transfer. And most probably due to the server resources.
This is absolutely something DMXZone should take a closer look at. I have been reporting this "bug" earlier, and there was no solution to it.
Maybe this can help them finding a solution to it, so we don't have to compromise the server's security in order to have the scripts to work.
So I tried to put the following two lines of code above the UDE script on the page:
set_time_limit(0);
ini_set('memory_limit','-1');
Then I could receive thousands of records, so it seems that UDE reaches a timeout which breaks the data transfer. And most probably due to the server resources.
This is absolutely something DMXZone should take a closer look at. I have been reporting this "bug" earlier, and there was no solution to it.
Maybe this can help them finding a solution to it, so we don't have to compromise the server's security in order to have the scripts to work.
Edited by - Dan Ove Tuven on 10 Mar 2011 13:55:10