2. PHPRunner General questions
  3. Excel Import Problem - Solved
This topic is locked

Excel Import Problem - Solved

 		3/12/2009 2:18:53 AM
PHPRunner General questions
A
 acpan author

Hi,
Just want to share a mistery problem with Excel Import on all PHPR version.

I checked the forum, quite a few had the same issue and no solution so far.
When you export data as Excel from PHPR generated Web, i suppose it

is in new excel format and when you use the same file to import, it shows:

The filename C:\XXX\XXX\php6D.tmp is not readable. This does not

tell what happen. So most will just use the CSV import instead and give

up on Excel.
Workaround: Open the exported excel file in MS Excel and

save as "95 version". Then import via PHPR generated web page.

This fixed the problem for me.
Sergey and Team, can you confirm this as a bug and will it be fixed in the next version?
Thanks

AC Pan
R
 		Ravengaard 5/6/2009

I am experiencing the exact same problem, but acpan's workaround does not work for me.

I have tried saving as Windows 95-Excel and .csv without any luck. Any new word on this?
I have also tried changing the temporary upload folder (php.ini) and giving the user the correct rights to it. But still no luck.
J
 		Jane 5/6/2009

Hi,
try to open generated output\libs\oleread.inc file and remove following code:

if(!is_readable($sFileName)) {

$this->error = 1;

return false;

}
R
 		Ravengaard 5/7/2009

It worked!, Thank you.

Is this a known bug?, I have been able to reproduce the problem on 3 different systems.
A
 		acpan author 5/22/2009

It worked!, Thank you.

Is this a known bug?, I have been able to reproduce the problem on 3 different systems.


For my case working on latest phpr 5.1 version, same problem exsits,

i tried the following:

  1. Followed the above advise.
    I got this error:
    Maximum execution time of 60 seconds exceeded in C:\XXXXXX\libs\oleread.inc
    and sometime this error:
    Max memory exceeded.
    I increased the memory for PHP.INI and still the same error reported.
    I checked the forum of the excelreader plugin, no such problem

    were logged in the forum.
  2. I then used my old tricks to try my luck i.e. saved the Excel file

    as 95 version and tried again. It worked!
    I am runnng php and apache on WIN32 machine.
    acpan