This topic is locked

Import .csv or .xls files

1/24/2010 7:13:35 PM
PHPRunner General questions
M
mcasassus author

Hello,
I have a problem with the Import .csv or .xls files !!!
I try with a lot of options, different Excel versions, .csv , etc.

I don't undestand what going on with this fonctionnality...
Please if some one know the solution, please let me know !
Thank you for your help
Mario

Sergey Kornilov admin 1/25/2010

I would recommend to post your application to 'Demo Account' and open a ticket at http://support.xlinesof.com sending your Demo Account URL along with CSV/XLS file in question.

S
swanside 1/28/2010



Hello,
I have a problem with the Import .csv or .xls files !!!
I try with a lot of options, different Excel versions, .csv , etc.

I don't undestand what going on with this fonctionnality...
Please if some one know the solution, please let me know !
Thank you for your help
Mario


Best thing to do is export a field with phprunner as a csv file, then look at the files you are trying to import and see how the fields line up between the two files.

A
acpan 1/28/2010

Hi,
Just my experience for XLS import and export.
To test the import and export, we normally export from the phpr

generated website and save to file and immediately import again just

to test.
When you export EXCEL from PHPRunner, and save it to your PC,

the file is not suitable immediately to import back, you may get this error:
The filename \XXX\XXX\php6D.tmp is not readable.
I normally export it to a file as XLS, than i open the file in XLS and

click SAVE AS XLS format without changing any value.
(Default is XML format for the save as window , be careful to double check it's XLS,

i think it could be MS EXCEL detect some XML header in the exported file and prompt

the format as XML).
Then import again will be ok.
Some other solution suggested in this website

may also solve ... filename \XXX\XXX\php6D.tmp is not readable problem:
Try to open generated output\libs\oleread.inc file and remove following code:

Quote

if(!is_readable($sFileName)) {

$this->error = 1;

return false;

}
acpan