+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: export script (/showthread.php?tid=1300)
export script - brettam - May 13th, 2011
sorry if this is a stupid or basic answer but i get this message when i try to view the submited form data in any format.
"Sorry, the export script didn't receive all the required fields and cannot proceed."
Any help would be greatley appreciated as i dont want to play with things im not sure about and loose the data allready submited
Thanks
RE: export script - Ben - May 19th, 2011
Hi Brettam,
No, not a stupid question at all! It shouldn't behave like that and it's totally not clear what's happening.
The Export Manager relies on a bunch of information being stored in sessions in order to make sense of what it should display (what fields, what order, which export group & type, etc). If, for whatever reason it doesn't have all the information is needs, it throws that error.
Generally, this is caused by PHP sessions being maxed out - or the data being stored in them gets corrupted. The only simple fix for this is to move to database sessions. It doesn't always work, but it's worth a shot.
Open up your /global/config.php and add the following line:
PHP Code:
$g_session_type = "database";
Then log out and in again, and try to do the export again.
- Ben
RE: export script - bvdveen - Jun 26th, 2011
Hi Ben,
I have a problem here too...I get a blank page after requesting an excel export of a form with lots of fields (about 280). This form gets filled in twice a day by about 5 persons.
Is there a MAX limit of the data when exporting?
My export to excel gives me a blank page.
Tried your solution above....same results.
When I try another form in the same database everything goes ok!
Please help...we need the information of our formtools database urgently!
If not our only solution would be a mySQL export...but that would be a little clumsy don't you think?
Cheers
Bert van der Veen
RE: export script - Ben - Jun 26th, 2011
Heya,
Yeah, doing a MySQL dump is kind of crumby...
Interesting the other form works.
Does it take a very long time? Could you maybe try exporting just half the results (e.g. create a View with a filter to only return results after a certain date or something). Does that work? I'm just wondering if maybe it's timing out on you, or something...
- Ben
RE: export script - brettam - Jun 26th, 2011
tried using your fix but still not working on some of the submissions. got me baffled why from the same form, some work and some dont !
RE: export script - Ben - Jun 27th, 2011
Hi Brettam,
Which of my suggestions did you try? The line in the config.php file, or creating a View to split the results in two? Does it take a long time to export the results - is it timing out on you?
Thanks!
- Ben
RE: export script - Lola Arscott - Oct 22nd, 2020
No dear it is not a stupid question at all. You can use PHP export manager essayshark reviews to export the scripting as the max limit of data is 128 megabytes.