Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
serviscl
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
Code:
$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
Re: EasyPopulate 4.0 Support Thread
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?
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
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?
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
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chadderuski
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.
1 Attachment(s)
Re: EasyPopulate 4.0 Support Thread
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.
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
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.
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...
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chadderuski
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?
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mrmanners
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
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
chadderuski
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.
Re: EasyPopulate 4.0 Support Thread
Quote:
Originally Posted by
mrmanners
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