2. PHPRunner General questions
  3. [SOLVED]  Exporting to Excel only parcial data
This topic is locked
[SOLVED]

 Exporting to Excel only parcial data

 		9/7/2010 7:29:53 AM
PHPRunner General questions
J
 jcoelho author

Hello.
We had a PHPRunner 4.2 application instaled and running correctly at a local computer with Windows XP under Apache webserver.

Now we changed to IIS 7.5 on Windows Server 2008 64 bits, and the Export to Excel functionality only exports 672 rows or 425kb file size.

We have more than 6000 rows to export.

I did try to increase time limits at php.ini with no success.

Can this be a IIS problem/limitation (some timout or memory limit?)
Sergey Kornilov admin 9/7/2010

There might be an issue with IIS configuration.
Check this article for some advice:

http://www.webcheatsheet.com/asp/asp_troubleshooting.php#problems
J
 		jcoelho author 9/8/2010

Thank you very much, but the article didnt helped me much. I did increase the IIS and PHP.INI timeouts and memory limits,without success.

Still the excel,csv and word exports are incomplete. This applies to all diferent reports/tables exportings, and it seems a buffer/cache or memory problem.
I realy need help here. Anyone with same problem?



There might be an issue with IIS configuration.
Check this article for some advice:

http://www.webcheatsheet.com/asp/asp_troubleshooting.php#problems
Sergey Kornilov admin 9/8/2010

Did you check 'Response Buffer Limit Exceeded' part in that article?
Anyway, this is obviously a server issue. Without having access to the server this is very little we can do.
If you are able to provide access to the server contact support team directly at http://support.xlinesoft.com.
J
 		jcoelho author 10/29/2010



Did you check 'Response Buffer Limit Exceeded' part in that article?
Anyway, this is obviously a server issue. Without having access to the server this is very little we can do.
If you are able to provide access to the server contact support team directly at http://support.xlinesoft.com.


Solved! I did it replacing ISAPI to FAST CGI + PHP WinCache extension.

In my opionion the problem must have been on performance and/or configuration issues on the server/iis/php side.
Soo, dont use ISAPI. FAST CGI is indeed easy to install and configure, even if you already had your application running on ISAPI (as was my case).
Regards,

Joao Coelho