Problems Importing into phpMyAdmin

[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.

[THUNBUG]

Perhaps you meant "insert into db" step(?) If so, yes, I selected my tab delimited file and clicked "insert into tab". I then got the upload results I got earlier which seemed to have worked because of of the "Updated!" message. If there is is a procedure to "apply to DB", then I don't know it. Please clarify what this is.