2. PHPRunner General questions
  3. Import error
This topic is locked

Import error

 		4/18/2008 08:34:20
PHPRunner General questions
M
 mmponline author

I'm trying to import a simple file with 20 records but get an "error in line" message.

Table:

AgentID int(12) Yes NULL auto_increment

Branch varchar(255)

Name varchar(255)

Cell varchar(255)

Photo varchar(255)

FidNo varchar(255)

Description mediumtext

Active varchar(255)
CSV File

AgentID Branch Name Cell Photo FidNo Description Active

Nelspruit Sonja Botes 082 551 1257 2007203929 Complete Yes

Nelspruit Mariska Botes 082 398 4260 2007317690 Complete Yes

Nelspruit Pauline Greyling 084 815 4403 Complete Yes

Nelspruit Ronel Buitendag 082 338 1075 2007701731 Complete Yes

...
Message:
Error: in the line: 0,'Nelspruit','Sonja Botes','082 551 1257','','2007203929','Complete','Yes'

...
Number of records: 21

Imported: 0

Not imported: 21
Sergey Kornilov admin 4/18/2008

Stephan,
I think you need to remove autoincrement field from import file.
M
 		mmponline author 4/18/2008

Tried that already. Double checked. Still error.
J
 		Jane 4/21/2008

Stephan,
please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error and your import file.

I'll find what's wrong with your project inspecting it at Demo account site.
M
 		mmponline author 4/21/2008

Loaded fields manually. Will do a test project and the upload to demo account. Chasing a deadline at the moment.
Will come back on this. Thanks!