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

Import - Excel Issue

 		3/16/2009 11:24:06 AM
PHPRunner General questions
C
 comlan author

I am just starting to use the Import function in PHPRunner. My test excel file has five rows. The first row has the field names, and then four rows of info to import.
When I use the Import feature it always reports that "25 rows were imported". When I examine the database I see the four valid rows of data, then 21 additional blank rows containing only the auto-increment key value.
I have just updated from build 587 to 766 and see no difference.
Am I doing something wrong here?
I need to be able to import an excel file with around 2,000 rows, is this possible?
Thanks for your help.
Sergey Kornilov admin 3/16/2009

It looks like PHPRunner is not able to parse this file. You may want to save it in CSV format and give it another try.
If this doesn't help post your application to Demo Account (last tab in PHPRunner) and contact support team directly at http://support.xlinesoft.com sending Excel file in question.
C
 		comlan author 3/18/2009

You are correct.
It was a problem with a corrupt excel file. Looked fine, but would not work.
Started with a fresh file and everything works great.
Thanks