Blank server error page when exporting to Excel

[jak]

Hi all,

I can't generate an Excel spreadsheet. When I attempt it, I get a blank page after the page initially hangs. What I get is a server connection error similar to when you try to access a site that isn't there. My client is freaking out. A real hothead. Need a fix fast.

Please, if there is anyone that can help it would be much appreciated. Can't seem to find the issue in the forum.

Thanks in advance.

[jak]

Sorry, the export script didn't receive all the required fields and cannot proceed.

Anybody ever get the above error?

Thanks.

[michatmaster7]

I haven't gotten that error. However, I did get the blank page.

I was about to make backups (via export to Excel) of all my submission data, so that I could upgrade my core to 2.1.0. So I have about a dozen or so active forms. Of all of them, this only happens with one of the forms. In fact, it happens that I cannot generate table views of the submission data, either.

I found that if I select only 10 lines of my initial data, it will generate without a problem. But when I want to export all 2500 or so lines of data, it just hangs on a blank page. I am kind of freaking out over this, too. Did you ever find a solution?

To clarify: when clicking on Generate, a new window opens at the following URL and just sits there, blank. But only on my form with over 2400 submissions:

Code:

http://www.domain.com/formtools/modules/export_manager/export.php

[michatmaster7]

I just realized that with the Export Manager I can show the option to use a CSV file instead of XLS (I'm a little slow). So I used the CSV option to export all 2500 or so records and I get the following error message:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 1550172 bytes) in /home/{domain}/public_html/formtools/global/code/general.php on line 198

Is this a limit that cannot be lifted? Do I need to export records in smaller batches, no matter what?

[Ben]

Hi michatmaster,

You *can* lift the limit, yes. The Export Manager is very CPU intensive - it does a great deal of work to generate the entire contents of a View / form, so memory can become an issue.

If you have access to the server's php.ini file, try updating the memory_limit directive to something higher than it is now. If you don't have access, perhaps ask your hosting provider on how you can do a customization for your site / folder. Some hosts have the server configured to let you define your own php.ini file in a folder that overrides specific settings like that one. Other hosts let you do that, but only by including the php.ini file in a cgi-bin folder. Other (for security reasons) don't let you do that at all.

If all else fails, you may have to resort to exporting the entire content in pieces (e.g. creating Views that show date ranges, or by specific content).

Good luck!

- Ben

[JLA]

Sorry, the export script didn't receive all the required fields and cannot proceed.

Anybody ever get the above error?

Thanks.

I know this is an older thread, but we just had this happen to one of our installations. The problem fixed itself when I changed the global/config.php file thusly:

$g_root_url = "http://domain.org/formtools";

to

$g_root_url = "http://www.domain.org/formtools";

We had recently standardized our use of "www" but not updated the formtools url. For some reason that did the trick. Hope that is helpful.