Problems Importing into phpMyAdmin

[THUNBUG]

I keep getting the following error when I attempt to import 2 new records for the table products_description: "Invalid field count in CSV input on line 1"

Here's a summary of my phpMyAdmin import settings:

In phpMyAdmin on my hosts server (cpanel),
- File to import (I browse to Products_updates.csv)
- Character set - utf8 (default no idea what this means)
Partial import
Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions.

Number of records(queries) to skip from start = 0

Format of imported file = csv


Ok, so i checked to make sure I have the same number of columns on my csv file as the database table. I am confident that I have the right format because I exported the only 2 records I set up through Zen cart admin and replaced with 2 new ones. Then again, if someone wants to look at my csv file to check, let me know. I wasn't sure wether or not to include the headings so I tried with and without and got the same error.

I've been testing Zen cart and this is the deal-maker or deal-breaker for me at this point. Please help me become a Zen cart guru and lover like you all!

[kobra]

Get easy populate to do this the free ver will assist...you can search here in the contributions forum

[THUNBUG]

Get easy populate to do this the free ver will assist...you can search here in the contributions forum

I found info on this at this link: http://modhole.com/modhole/index.php...N_position=5:5. For whatever reason the link for "Uploading data to your Zen Cart using Easy Populate" does not work. Know why?

[kobra]

probably permission related check them

[THUNBUG]

That's okay. I ignored that and went ahead and installed Easy populate. I downloaded a completed tab-delimited file of my products and used that as a template to test upload 2 more products. Should have been a slam dunk in my mind but I got these errors:

No model field in record. This line was not imported27073.jpg | CHERUB BIR | An English | | 9.3 | 3/7/2007 | 0001-01-01 | 19.95 | 0 | | | 0 | | Taxable Go | 1 |
No model field in record. This line was not imported27382.jpg | COMPASSION | The Virgin | | 11.6 | 3/7/2007 | 0001-01-02 | 24.95 | 0 | | | 0 | | Taxable Go | 1 |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Upload Complete

The model field is blank for my current and new products. In Configuration - Product Listing, I have a zero for Display Product Model. What else do I need to configure to have the system ignore the Model field in my uploads? Or do I have to enter something in this field?

[THUNBUG]

That's okay. I ignored that and went ahead and installed Easy populate. I downloaded a completed tab-delimited file of my products and used that as a template to test upload 2 more products. Should have been a slam dunk in my mind but I got these errors:

No model field in record. This line was not imported27073.jpg | CHERUB BIR | An English | | 9.3 | 3/7/2007 | 0001-01-01 | 19.95 | 0 | | | 0 | | Taxable Go | 1 |
No model field in record. This line was not imported27382.jpg | COMPASSION | The Virgin | | 11.6 | 3/7/2007 | 0001-01-02 | 24.95 | 0 | | | 0 | | Taxable Go | 1 |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Upload Complete

The model field is blank for my current and new products. In Configuration - Product Listing, I have a zero for Display Product Model. What else do I need to configure to have the system ignore the Model field in my uploads? Or do I have to enter something in this field?

Sorry, bumping this and changing title since I've moved from phpMyAdmin to Easy Populate. Thank you.

[THUNBUG]

Ok. I threw away my "don't assume" mentality because it's not like the documentation is comprehensive anyway...lesson number one. So for those as slow as me, Easy Populate the model of the product is a mandatory field for the upload file. I typed "General" and it seemed to work...or at least, it got past that error. Now I don't really have an error but can't find my new product. Geesh. I'll probably kick myself again when I find out why but I've already used too much company time on my business website. If someone would kindly advise in the meantime, please do. My upload results:

Upload Results
File uploaded.
Temporary filename: /tmp/phpYE9rDt
User filename: Test_EP.txt
Size: 3037

UPDATED! - Model: General | large/1932 | CHILD AND | This touch | | 4.577 | 3/7/2007 | | 9.95 | 0 | | | 1000 | | Inspiratio | | | | | | | Taxable Go | 1 |
UPDATED! - Model: General | large/2702 | MUSICAL AN | On her gli | | 11.477 | 3/7/2007 | | 24.95 | 0 | | | 1000 | | Inspiratio | | | | | | | Taxable Go | 1 |
UPDATED! - Model: General | large/2707 | CHERUB BIR | An English | | 9.3 | 3/7/2007 | | 19.95 | 0 | | | 1000 | | Inspiratio | | | | | | | Taxable Go | 1 |
UPDATED! - Model: General | large/2738 | COMPASSION | The Virgin | | 11.6 | 3/7/2007 | | 24.95 | 0 | | | 1000 | | Inspiratio | | | | | | | Taxable Go | 1 |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

The last message doesn't really bother me right now. I just can't find the bottom 2 records. The first 2 were already in my website. So how can I find the records I tried to add?

Thanks.

[THUNBUG]

Then again...if you guys know a good place that has all the information regarding importing files (format, rules..etc) that would be great. Searching these forums is giving me a headache!

[kobra]

With this, it first is uploaded to a folder - have you then run the apply it to the DB step?

[THUNBUG]

With this, it first is uploaded to a folder - have you then run the apply it to the DB step?

No. I thought that's it. I'm not familiar with the procedure. Can you please tell me how to do this? Oh...I am using the free version of Easy Populate just in case that makes a difference. I've read the readme.txt and no help there. I feel so close yet so far.