Easy Populate uploading cataloge problem

[jamesdavid]

How do I upload my new catalog with Easy Populate?
Ive downloaded my catalogue and open it with cal (open office). Ive only changed the names of a few products as a test. Do I need to save the open office spread sheet as a txt file to upload it? The closest I can save as is a .csv file, but that doesn't seem to work.

Ive also tried opening the downloaded catalogue with a text editor and just changing the text description of one product. When I upload this file I get the following;

Upload Results

File uploaded.
Temporary filename: /Applications/MAMP/tmp/php/phph4BC1U
User filename: Full-EP2008Jun06-1010.txt
Size: 1556

No model field in record. This line was not importedproducts/4 | 500 34mm R | Pack of 50 | | | | | 5.5 | 0 | | 2008-06-04 | 999 | | More Gems | Red Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported/products/ | 500 30mm R | Pack of 50 | | | | | 5.5 | 0 | | 2008-06-04 | 999 | | More Gems | Red Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported/products/ | GemSetting | Everything | | | | | 15 | 0 | | 2008-05-28 | 9999 | | Gem Settin | | | | | | | --none-- | 1 |
No model field in record. This line was not imported | black1 | black1 | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Black Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported | Torque Blu | Torque Blu | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Torque Blu | | | | | | --none-- | 1 |
No model field in record. This line was not imported | Silver Stu | Silver Stu | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Silver Stu | | | | | | --none-- | 1 |
No model field in record. This line was not imported/products/ | 500 20mm | Pack of 50 | | | | | 5.5 | 0 | | 2008-06-04 | 999 | | More Gems | Red Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported | black prod | black prod | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Black Gems | | | | | | --none-- | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | |
Upload Complete

I posted this on the stick but no one has replied, so sorry for the repeat.
thanks
james

[misty]

No model field in record

To use Easy Populate, EVERY product must have UNIQUE
MODEL name or number

[jamesdavid]

I seem to have got it working so thats a lot misty.

One thing is still worrying me a little bit. When I upload I get a message saying all the products that were added/ updated, and i also get this message at the bottom;

No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | |
Upload Complete

This the screen i get when importing the downloaded catalogue txt file into open office calc;
http://www.jameschetwood.com/easy/importpic.jpg

When i save my open office calc document as a csv i get this screen;
http://www.jameschetwood.com/easy/save1.jpg

And then this one;
http://www.jameschetwood.com/easy/save2.jpg

The way I got this working was to mess about with the settings on that last screen. It seems there can be issues with the field and text delimiter when switching from spread sheet to txt based documents.

Is there a standard way this is supposed to be done?
Thanks
James

[misty]

So were all the products in your .csv file added to
your zencart install?
Did you also put
EOREOR
at the end of EVERY line?

[jamesdavid]

Yes they were, i think its fine.
thanks for replying again.
james

[misty]

Yes they were, i think its fine.
thanks for replying again.
james

Great news...Well Done !!

[jamesdavid]

haha thanks!

[jamesdavid]

How can I define the Categories Description in Easy Populate?

I made one category with the description in the admin and then exported it into Easy Populate so I could use it as a template. Everything appears in Easy Populate except for the Categories Description.

[jamesdavid]

I posted this here as well;

http://www.zen-cart.com/forum/showth...807#post567807