Export Manager 2.1.1 Problem

[David Ward]

Hi

I'm having a problem with export manager it was working fine. Today every time I try and export a form entries database I get an error.

This is whats happening -
I click to view the entries on a form and it loads the submissions page
I select ALL next to the excel icon and press the generate button
After some time I get a page saying - [an error occurred while processing this directive]

It was working fine before. Any suggestions how I can sort this issue out?

I'm using version 2.26 of Formtools and version 2.1.1 of the exportmanager which came with the version of Formtools. I've not altered anything in the export manager.

Thanks

[Joe]

Hi David,

Have any changes been made to your server? Is there a lot of data being exported? This sounds like a server error. I suspect that the script might be timing out.

Cheers,

Joe

[David Ward]

Hi been speaking with our server guys and they did rebuild the server, but it looks like the issue is down to the speed of our internal network.

I can download the for submissions without a problem from an external network.

The problem I have now is I think I messed up the setting for the excel download because it's not downloading as a file any more it's just displaying the form data in a separate window. Does anyone now how I can get it to download the data as an excel file again?

Thanks

[Joe]

Hi David,

Hmm.. sounds like there might be an issue with your header.

Module > Export Manager > Excel Edit icon > Header:

Header should be:

Pragma: public
Cache-Control: max-age=0
Content-Type: application/vnd.ms-excel; charset=utf-8
Content-Disposition: attachment; filename={$filename}

Cheers,

Joe

[David Ward]

Hi Joe

Thanks for the info. Still having issues with my server now even from an external network. On smaller exports it works fine, but with some exports which have over 10000 entries I keep getting [an error occurred while processing this directive]

I think something needs changing on our server but have no idea what.

[Joe]

You'll probably need to update you php.ini file. You can give this a try: http://davidwalsh.name/increase-php-scri...it-ini_set

Cheers,

Joe