EasyPopulate 4.0 Support Thread

[chadderuski]

Hello.
I have got a problem with categories name.
My categories include ", " and I can not import via EP4, because character "," always divide :-( it would use a semicolon instead of a comma? Thanks :-)

Excuse My English.

Categories Names are split with the carat '^' character, not the comma. Which version are you using? What language? I tested this myself, and the comma was retained in the categories name.

On, or about line 487 of easypopulate_4_import.php

			
$categories_names_array = explode('^',$v_categories_name_1);
$categories_count = count($categories_names_array);

Unless you modified the code, or are using a very old version of EP4, I don't see how EP4 could split the categories name on the comma.

-chadd

[mrmanners]

May not be the right place for this but I am using Easy Populate to edit my categories and sub-categories so here goes.

Using Zen Cart 1.5 and Easy Populate 4.0. I am trying to use v_categories_name_7 already in the csv file but when I populate that column where needed, and then import it back into the database, it doesn't populate anything. It doesn't indicate any failures either.

Any ideas?

[chadderuski]

May not be the right place for this but I am using Easy Populate to edit my categories and sub-categories so here goes.

Using Zen Cart 1.5 and Easy Populate 4.0. I am trying to use v_categories_name_7 already in the csv file but when I populate that column where needed, and then import it back into the database, it doesn't populate anything. It doesn't indicate any failures either.

Any ideas?

How many languages do you have defined? EP4's handling of category names is VERY different than EP 1.2.5.4 ...

With EP4 the _1, _2, _3 refer to the installed languages in your zencart. If you only have one language (_1 for english) then you will not have any other.

v_categories_names_1 then has your desired path to the product "top_level_name^sub_cat_name^sub_cat_name..."

Please read the first posts in this thread and the documentation about category names... that should solve your issue.

-chadd

[mrmanners]

How many languages do you have defined? EP4's handling of category names is VERY different than EP 1.2.5.4 ...

With EP4 the _1, _2, _3 refer to the installed languages in your zencart. If you only have one language (_1 for english) then you will not have any other.

v_categories_names_1 then has your desired path to the product "top_level_name^sub_cat_name^sub_cat_name..."

Please read the first posts in this thread and the documentation about category names... that should solve your issue.

-chadd

Thanks Chadd. I only have one langauge. I will see if I can decipher what is being said in the first part of this thread. Thanks.

[mrmanners]

So I went through the first 15 pages of information and saw how you use a ^ between categories. Here is the thing; not knowing this until now, I used each of the V_categories_1-7 as different categories. Here is an example. Until now this has been working flawlessly. When I try to use the 7th column, it doesn't recognize it like the others were. Is there no other way?

Thanks for your help.

[chadderuski]

So I went through the first 15 pages of information and saw how you use a ^ between categories. Here is the thing; not knowing this until now, I used each of the V_categories_1-7 as different categories. Here is an example. Until now this has been working flawlessly. When I try to use the 7th column, it doesn't recognize it like the others were. Is there no other way?

Thanks for your help.

Are you SURE your using EP4?? Those additional category columns would go no where.... and all your products would be dumped into their main category...

[mrmanners]

Are you SURE your using EP4?? Those additional category columns would go no where.... and all your products would be dumped into their main category...

Yes sir. Check out the site. I built the entire database using csv and easy populate; categories and all. I tried using ^ but when I attempted to import, I got the max 32 character error. Is there a way around this?

[chadderuski]

Yes sir. Check out the site. I built the entire database using csv and easy populate; categories and all. I tried using ^ but when I attempted to import, I got the max 32 character error. Is there a way around this?

Yes, use your cpanel phpmyadmin to modify the database ... find the relevant field and increase to meet your needs.
This error arises when a single category name exceeds the maximum length.

You can see the other vital name lengths listed for your databases on the right side of the EP4 screen.

-chadd

[mrmanners]

Yes, use your cpanel phpmyadmin to modify the database ... find the relevant field and increase to meet your needs.
This error arises when a single category name exceeds the maximum length.

You can see the other vital name lengths listed for your databases on the right side of the EP4 screen.

-chadd

You are getting above my skill level now. I have not messed with the back end of the database in the cpanel at all.

[chadderuski]

You are getting above my skill level now. I have not messed with the back end of the database in the cpanel at all.

It's easy to do and has been discussed earlier in this thread. The length check is very important to the import so that's why I added it.

-chadd