Universal Data Exporter PHP Support Product Page

excel and large table

Asked 06 Dec 2010 17:36:16
has this question
06 Dec 2010 17:36:16 Berrodier Christophe posted:

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


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:

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

Reply to this topic