EasyPopulate 4.0 Support Thread

[Mikec87]

I found a solution. Using excel formula like this one: =CONCATENATE(A1," ",C1) and also adding the ^ to the first row first using a simple formula.

[mc12345678]

I found a solution. Using excel formula like this one: =CONCATENATE(A1," ",C1) and also adding the ^ to the first row first using a simple formula.

To be carefule/cautious/clear, the goal is for the entire v_category_name text to be one word without spaces. Because we're sort of talking about math here, there are a number of ways to accomplish the task. The concatenate function is certainly one of them. In the case of joining two fields (columns) with a caret between the two, the following would be appropriate.

If v_category_name_1 is in column F and v_category_name_2 is in column G, and perhaps the last column of the spreadsheet is column V, then in column W row 2 one could place the following equation. =CONCATENATE(F2,"^",G2) then copy that equation down to the last row. Another such equation could be: =F2&"^"&G2
Then the values generated should be copied and special pasted back to either the original v_category_name_1 or back to itself so that the result (value) remains not the equation. If pasted back to itself, then be sure to remove the old version(s) of the column(s) before uploading.

If there are more subcategories such as v_category_name_3 in the old data, then it should be appended as well to the result from above.

A series of checks could be included in a single cell to address the multiple columns if they exist, hopefully not too deeply. Could test for the existence of content in a cell, and if there is, then concatenate that text, otherwise return the text from the earlier process.

For example without using exact code if there is appropriate content in cat_3, then concatenate(cat_1,"^",cat_2,"^",cat_3), else if there is appropriate content in cat_2, then concatenate(cat_1,"^",cat_2), else cat_1. (This method doesn't assign product(s) to "non-category" as if there is a cat_1, then every product must be in a cat_1 as all categories are to contain either categories or products, not both and that includes the root of the category tree.)

So, sum and total, one reason I posted the above is that if the equation in the OP's message is used, then a space is going to be added to the category name on one side or the other. Per the image, the sub-category will have a space before it. This is not desired and could lead to issues...

[Mikec87]

To be carefule/cautious/clear, the goal is for the entire v_category_name text to be one word without spaces. Because we're sort of talking about math here, there are a number of ways to accomplish the task. The concatenate function is certainly one of them. In the case of joining two fields (columns) with a caret between the two, the following would be appropriate.

If v_category_name_1 is in column F and v_category_name_2 is in column G, and perhaps the last column of the spreadsheet is column V, then in column W row 2 one could place the following equation. =CONCATENATE(F2,"^",G2) then copy that equation down to the last row. Another such equation could be: =F2&"^"&G2
Then the values generated should be copied and special pasted back to either the original v_category_name_1 or back to itself so that the result (value) remains not the equation. If pasted back to itself, then be sure to remove the old version(s) of the column(s) before uploading.

If there are more subcategories such as v_category_name_3 in the old data, then it should be appended as well to the result from above.

A series of checks could be included in a single cell to address the multiple columns if they exist, hopefully not too deeply. Could test for the existence of content in a cell, and if there is, then concatenate that text, otherwise return the text from the earlier process.

For example without using exact code if there is appropriate content in cat_3, then concatenate(cat_1,"^",cat_2,"^",cat_3), else if there is appropriate content in cat_2, then concatenate(cat_1,"^",cat_2), else cat_1. (This method doesn't assign product(s) to "non-category" as if there is a cat_1, then every product must be in a cat_1 as all categories are to contain either categories or products, not both and that includes the root of the category tree.)

So, sum and total, one reason I posted the above is that if the equation in the OP's message is used, then a space is going to be added to the category name on one side or the other. Per the image, the sub-category will have a space before it. This is not desired and could lead to issues...

Thank you for the reply. It worked the way I did it but I think the way you showed is faster.

My shop has all 1380+ items listed and it imported without a hitch. Thanks again :) Below is a link to my store.

http://www.southerncrossemporium.com.au/

[mc12345678]

Thank you for the reply. It worked the way I did it but I think the way you showed is faster.

My shop has all 1380+ items listed and it imported without a hitch. Thanks again :) Below is a link to my store.

http://www.southerncrossemporium.com.au/

Haven't been able to check the site for what I would like to try to verify, the mobile version of the template pretty much makes the site useless at least on my device as all that can be seen is the top banner of the menu with logo, etc... There is no room remaining to see product or other information, even the "menu" button "slides" out as one tries to scroll down which just takes up even more of the screen landscape. Otherwise, the code may include a trim of each category when importing to prevent a space from being prepended or appended to the category name. Otherwise, the number of categories in the store could grow by simply adding/removing a space.

For some, this utility is frequently used and having say an "equation" or a macro in one's back pocket can make the upload process go so smoothly whereas not having that extra "functionality" readily available can make the task seem tedious. If the upload is going to begin from the same format offile each time, then additional coding could be done to join those categories say based on the prefix of the filename and to ignore that the number typically corresponds to a language.

[w2e]

i have having problems installing EP1.2.5.7 on zencart 1.5.3
i uploaded everything in temEP folder to my zencart root folder, and everything in YOUR_ADMIN to my admin folder.

1, when i go to tools>easy populate, i get "Strange but there is no default language to work... That may not happen, just in case...
Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer"

2, there is no EP under the "configuration" tab.

3, i had to create an upload folder in the zencart root folder. i am unable to use /upload outside the zencart folder? where is the location of the upload folder specified?

i use sql patch to run the lines in install_sql line by line, but i cannot run the last 3 lines?

please help. thanks

[brittainmark]

Had the same issue I think it is bacaues it is not using MSQLI. I have moded the files to work for me.
note changed to use MSQLI and $db->link and default the custom fields.
I have attached a zip of the changed files. EZmods.zip
Back up the old Ezpopulate files then unzip the attached file.
Change the name of the admin file to your admin file name.
Copy over the changed files.

This is just the changes I made not a full set of ezpopulate file so you will need to install ezpopulate first.
Mark

[mc12345678]

i have having problems installing EP1.2.5.7 on zencart 1.5.3
i uploaded everything in temEP folder to my zencart root folder, and everything in YOUR_ADMIN to my admin folder.

1, when i go to tools>easy populate, i get "Strange but there is no default language to work... That may not happen, just in case...
Warning An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer"

2, there is no EP under the "configuration" tab.

3, i had to create an upload folder in the zencart root folder. i am unable to use /upload outside the zencart folder? where is the location of the upload folder specified?

i use sql patch to run the lines in install_sql line by line, but i cannot run the last 3 lines?

please help. thanks

Had the same issue I think it is bacaues it is not using MSQLI. I have moded the files to work for me.
note changed to use MSQLI and $db->link and default the custom fields.
I have attached a zip of the changed files. EZmods.zip
Back up the old Ezpopulate files then unzip the attached file.
Change the name of the admin file to your admin file name.
Copy over the changed files.

This is just the changes I made not a full set of ezpopulate file so you will need to install ezpopulate first.
Mark

Also, recognize that the files disccused in these two posts have nothing to do with EP4, but an entirely different version of code that does something similar as the code discussed in this thread... Further discussion ofthe above should be taken to it's own thread either: http://www.zen-cart.com/showthread.p...-2-5-4-support or a new one.

The file changes posted above have no relation to EP4 and may (or may not) cause issues if "blindly" implemented with EP4... Truly the files have no business of being in this thread at all. EP4 has alreadybeen modified to workwith Zc 1.5.3, it still needs at least a minor tweak to work with ZC 1.5.4 as well aspossibly some added code to worrk along one of the new "tracking" features of ZC 1.5.4... But the first part is relatively easy/straight forward, the second needs some inspection still.

[wtashby]

One quick, perhaps dumb question. Why did you move from v_category_name_1, v_category_name_2, etc. to using the caret? That, to me just complicates things having to use formulas and such instead of the old way.

[mc12345678]

One quick, perhaps dumb question. Why did you move from v_category_name_1, v_category_name_2, etc. to using the caret? That, to me just complicates things having to use formulas and such instead of the old way.

You mean, way back when why did chadderuski change up the method of assigning categories?

Well, there were two things at play from what I have seen throughout the thread and from looking at how it works. One was that there was the concept of multiple languages, so there had to be a method to apply that, then there was the "stack-up" of categories.. How many v_categories_name_x fields need to be added to address the multiple layers in which a product can exist? Then on top of that applying a second+ language at the same time...

So, as to the use of the caret (or other character as so desired), v_category_name_1 is the category name for the product in the row that is to be in the first language of the store (having language_id = 1), the category that it resides is main_cat1^sub_cat1^sub_sub_cat1^sub_sub_sub_cat1 Thus the product's category is fully defined in a single field.

This has been this way with EP4 for as long as I've known it (4+ years), so I'm curious about to what "old way" this is being compared.