EasyPopulate 4.0 Support Thread

[chrysalid]

Yes - that is what has happened.
In the long descriptions, there are commas.
Is there a way I can fix this? Or do I need to replace all commas? (that would be a lot of work!)
Thanks,
Amber

[chrysalid]

I've been trying to find a way to 'escape' the comma - and have had no luck. So I just deleted all of the contents in the description.
There are now no comma's anywhere in the csv file.
When I try to import I get "No model field in record. This line was not imported" over and over - no records import.
But I have no idea why...
What now?
Thanks!
Amber

[hermes369]

I haven't any trouble with commas as long as they are encapsulated inside quotes. I'd make sure you are using LibreOffice's Spreadsheet program.

If I'm not mistaken, the docs say that one must provide a model name or the import will fail. I just put the product's category name in there. I really don't think it matters what content is in that field so long as it isn't empty. Hope that helps!

[VideoStan]

I've been trying to find a way to 'escape' the comma - and have had no luck.

As Hermes says, you don't need to escape commas; just a field with a comma inside it must be enclosed in quote marks. Chad had a post somewhere that related to what character set is used. Something more than the problem I suspected is wrong.

[chadderuski]

JeeWizz! Since the forum upgrade I never get regular notifications of new posts! Sorry I missed so much activity.

Appreciate the help VideoStan, DocByte!

[chadderuski]

Just to recap:

When first learning to use EP4, first manually create a product within your category tree, i.e.

products_model: widget_101

in it's proper category:

Widgets > My 101 Widgets

So you now have a widget within it's Top level category, and sub-level category.

When you export your data, you'll see the category column as this: "Widgets^My 101 Widgets"

Now, before you do anything else, you should be able to Export your data, and WITHOUT DOWNLOADING OR EDITING, import that SAME file. You should get NO errors, and a notice that says the products was "Updated".

Go look at the product and ensure the the "round-robin" Export -> Import worked without error. If you have not error, you're ready to download your CSV file and begin working on it.

If you have not experience with data import/export, easypopulate (any versions!), it is best to go slow and only work with a couple products until you are confident about what you are doing.

All I can say is that EP4 has been tested by numerous users, some with sku's numbering the hundreds of thousands (one store has 980,000 sku's!!!) without error (server permitting!).

I hope this clarifies some things for new users...

-chadd

[hermes369]

Hmmmm. v_products_type is set to 1 for all items. There must be some kind of way to see what's different between whatever is generating the product preview for products I may edit and the ones I can't. I guess I'm looking for something like a Console, or Event Viewer for mysql. Obviously there is some difference somewhere. I appreciate the advice to go slow. I will try that again presently.

Thanks for the response!

[chadderuski]

I've been trying to find a way to 'escape' the comma - and have had no luck. So I just deleted all of the contents in the description.
There are now no comma's anywhere in the csv file.
When I try to import I get "No model field in record. This line was not imported" over and over - no records import.
But I have no idea why...
What now?
Thanks!
Amber

If you are using OpenOffice to export your file, you do NOT have to worry about commas, quotes, etc. in your descriptions. But you do need to make sure you are exporting your file correctly from OpenOffice. This has been explain in detail in the first couple posts of this thread.

Also, please read the README docs that come with the mod. I always recommend that you enter a product manually first through the admin, then do an EXPORT to get your file header and column mapping. This goes a long way to explain how to use the mod. Most things are very self-explanatory.

-chadd

[kobra]

when I do I get the error messages "No Model Field In Record. This line was not imported" What does that mean

Did you have a model entered??

[kobra]

sash,
Try exporting your products
Open resulting file and locate product and add attributes to it