EasyPopulate 4.0 Support Thread

favjola:

I changed the field delimiter with commas (,), and I'm the same mistake because it seems that puts (;)

What are you using to save your text file? Open office as Chadd recommended?

Did you set up some categories in your store and do the export Chadd recommended? What do you see there?

you can see the file with fields delimited by commas and delimited text "

how do I edit the export file?

tomorrow I'll try 'with open office, many thanks

ok whit openoffice now we are on good track

now only the field (v_products_model) which remains without "

I am attaching the first line

v_products_model,,"v_products_image,","v_products_name_2," ..........................................

Excellent add-on - and "almost" does what I need, with one show-stopper exception!
I may be listed as a New Zenner, but have been using OSC since it began 14 years ago!

We have multiple systems that need to talk to each other to synchronize data - including our "composer" for products, and have to do the synchronization using the products_id, not the products_model.

The products_model "could", but seldom changes. The products_id (which also syncs to the POS for inventory) is the one constant!

Is there an easy way to force the products_id field to be respected and used as the products key?

favjola:

now only the field (v_products_model) which remains without "
I am attaching the first line......

I did not see your response.

When I download the "Full-EP2012Oct31...." none of the field names have quotes around them.

And the first few look like this:

v_products_model,v_products_type,v_products_image,

Even if you use quotes, do not put the comma that separates fields inside the quote mark.

Ok, I give up...

I just can't seem to get this to work.

If I download the Basic Products Attributes (basic single-line), then modify the size in v_products_options_values_name_1 (i.e. default is S,M,L) by adding a comma and then XL, then import it back with EP4, the attribute of the product won't change.

I got the radio buttons in attributes for each size but if I add it to the CSV and then upload it, nothing happens.

Anyone can help me out ? I'm really about to bash my brains in with the keyboard (broke the mouse already).

Thanks.

ejunk:

If I download the Basic Products Attributes (basic single-line), then modify the size in v_products_options_values_name_1 (i.e. default is S,M,L) by adding a comma and then XL, then import it back with EP4, the attribute of the product won't change.

So, assuming model number 1001, 0 for radio button, and the attribute name "Size", is this what you have?:

"1001","0","Size","S,M,L,XL"

v_products_model	v_products_options_type	v_products_options_name_1	v_products_options_values_name_1
Chilot Acanta Black	2	Culoare	Negru
Chilot Acanta Black	2	Marime	S/M,L/XL,L

Marime means Size and Culoare means Color (Negru = Black) because it's in Romanian. Could that be the problem ?

Thank you for your quick response.

I've got two ZenCart shops setup. One is running 1.38a, the second is running 1.51. I have EasyPopulate4 installed and working on both shops. I am trying to export from the 1.38a shop and import the CSV into the 1.51 shop, but nothing is happening. I get a success message, but nada! I've tried doing a complete product export/import and also starting with just the categories. Still, nothing. Any idea where I might have gone wrong? Thanks!

ejunk:

Marime means Size and Culoare means Color (Negru = Black) because it's in Romanian. Could that be the problem ?

No. It is more likely a problem is quote marks and commas, none of which we are seeing is your post. Send me a zipped version of what you are uploading. I'll pm you.

ejunk:

v_products_model v_products_options_type v_products_options_name_1 v_products_options_values_name_1
Chilot Acanta Black 2 Culoare Negru
Chilot Acanta Black 2 Marime S/M,L/XL,L

> 
> Marime means Size and Culoare means Color (Negru = Black) because it's in Romanian. Could that be the problem ?
> 
> Thank you for your quick response.

Heya!

One other thought, how many languages do you have installed? You can zip your csv file and attach the zip so we can look at it.

-chadd

DanT:

Excellent add-on - and "almost" does what I need, with one show-stopper exception!
I may be listed as a New Zenner, but have been using OSC since it began 14 years ago!

We have multiple systems that need to talk to each other to synchronize data - including our "composer" for products, and have to do the synchronization using the products_id, not the products_model.

The products_model "could", but seldom changes. The products_id (which also syncs to the POS for inventory) is the one constant!

Is there an easy way to force the products_id field to be respected and used as the products key?

Hi Dan!

This will take some thought... EP4 has been coded to work specifically on the products_model. Not saying that the products_id is not doable, but there would be some significant coding for this.

Have you looked at Langer's Easy Populate Advanced 3.0.3? He does allow use of the products_id, but I don't know much more than that.

I can put this on the "slate" but I am terribly busy with several paid projects and the "day job", so I don't know just when I could get to it...

Sorry if that's a disappointment. I really do want to make EP4 a complete product for us zenners.

-chadd

Hello,

I am using zen cart 1.51, new install, using Bristol Lace template. After installing easy populate, I click on Configuration, Easy Populate, and it takes me to my image handler link. When I hover over image handler link it gives me the id=31, and when I hover over Easy Populate, it gives me the same id=31. Somehow, they have the same link. When I go to Tools, Easy populate, that link works. How to I correct the link under configuration?

Thank you in advance,

Jeremiah

chadderuski:

Heya!

One other thought, how many languages do you have installed? You can zip your csv file and attach the zip so we can look at it.

-chadd

Hey Chadd,

Just the default English. I translated a few checkout files here and there but nothing major. Just he files from languages.

Here is the file, used openoffice as you recommended.

Attachment #11546

ejunk:

Hey Chadd,

Just the default English. I translated a few checkout files here and there but nothing major. Just he files from languages.

Here is the file, used openoffice as you recommended.

Attachment #11546

you file looks fine... pm sent.

-chadd

chadderuski:

Hi Dan!

This will take some thought... EP4 has been coded to work specifically on the products_model. Not saying that the products_id is not doable, but there would be some significant coding for this.

Have you looked at Langer's Easy Populate Advanced 3.0.3? He does allow use of the products_id, but I don't know much more than that.

I can put this on the "slate" but I am terribly busy with several paid projects and the "day job", so I don't know just when I could get to it...

Sorry if that's a disappointment. I really do want to make EP4 a complete product for us zenners.

-chadd

I certainly understand Chad! I have those restrictions myself!

I looked at the Langer 3.03 and it doesn't seem to do as much error checking etc, so I've put a couple mods into yours!
It doesn't do everything, but from testing it "prefers" the model for ALL changes.
On additions to the DB, IF the v_products_id column exists in the import file, it will use that ID #.
If there is an insert conflict (duplicate ID), you already throw the error.

I'm sending a PM with some "minor" changes (snippets only) that appears to do what I need. Possibly others could need too.

Let me know what you think!

Dan

Jeremiah H:

Hello,

I am using zen cart 1.51, new install, using Bristol Lace template. After installing easy populate, I click on Configuration, Easy Populate, and it takes me to my image handler link. When I hover over image handler link it gives me the id=31, and when I hover over Easy Populate, it gives me the same id=31. Somehow, they have the same link. When I go to Tools, Easy populate, that link works. How to I correct the link under configuration?

Thank you in advance,

Jeremiah

Hi Jeremiah,

Sorry to leave you hanging! Are you SURE you are using Easy Populate 4? Not an earlier version of Easy Populate?

When you navigate to Tools > Easy Populate 4 you should have "Easy Populate 4.0.22 - Beta 6-10-2012"
for your page title...

-chadd

chadderuski:

Hi Jeremiah,

Sorry to leave you hanging! Are you SURE you are using Easy Populate 4? Not an earlier version of Easy Populate?

When you navigate to Tools > Easy Populate 4 you should have "Easy Populate 4.0.22 - Beta 6-10-2012"
for your page title...

-chadd

Hello Chadd,

Thank you for apologizing for leaving me hanging, but no apology is necessary, it has only been a day or two,and I know that all of you that are helping the rest of us are doing it for free and on your own time, so I always appreciate any and all help given.

As far as which version of Easy Populate, I downloaded the plug-in Easy Populate CSV from this site. My page title from the Tools> Easy Populate (mine does not have 4) is Easy Populate For ZenCart v1.5.

I have found a way to get to the configuration, but I would like to correct the link. Like I said, when I click on Configuration> Easy Populate it takes me to my Image Handler, and after hovering, I saw where the Easy Populate and Image Handler had the same page id. I went into my db and saw that the id for Easy Populate was 39. So when it takes me to Image Handler, I change the id in the url to 39 and I am able to get to the configuratioon page for Easy Populate.

I have no idea how or why Easy Populate and Image Handler were assigned the same id. Image handler was installed first.

If there is a different link for Easy Populate 4 than the CSV, I will try that one if it will be easier and you think that would help or be better.

Thank you again,

Jeremiah

Jeremiah H:

If there is a different link for Easy Populate 4 than the CSV, I will try that one if it will be easier and you think that would help or be better.

Jeremiah

Hey Jeremiah,

Go to the first post in this thread. There is a link to github for EP4 which is my project. I am not doing support on the other versions anymore, sorry. I'm aware of the version you are using. I think they just hacked the code to sort of work.

My version has many many more features. I DO need to submit to the zencart team which would make this easier for the zenners, but time has been a serious limiting factor for me. If you install my version, please read through some of the first pages of this thread. A lot of info there that you might find useful.

-chadd

Hello!
I read almost everything in the forum.
I could not find solution to my problem.
My problem with the Cyrillic alphabet.
I tried anything: Openoffice, Notepad + +
Nothing happens, the file is uploaded but not read Cyrillic.
My database is utf8.
I use Zen Cart 1.5, Easy Populate 4.0
Please a little help.
Here is the code I'm trying to load.

v_products_model,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7
100,Електротехника1,Категория1,,,,,
200,Електро1,Категрия2,,,,,