EasyPopulate 4.0 Support Thread

[pdevo]

Hello,

I am new to the ZC Forum and have never posted before. Hoping this is the correct place and method.

Using EP4 and ZC 1.5.1. I loaded 1700 products simultaneously with success, (updated existing and added new), except for the length of the "v_products_name_1" field was too short for some of the products names. The field length is set at 128 according to the "warning" I received on the products "with issues" and the settings shown on the upper right hand part of the EP4 page. I need about 135 in length.

I have looked everywhere for a solution on the Forum. Closest suggestion found in the Forum was to go to phpMyAdmin in cPanel, then go to "products_description" and "change products_name" there to length of 135. Also go to orders_products and change products_names to 135. I did both and it made no difference. I don't see a name for "products_name_v1" - only for "products_name".

Can you please tell me exactly where to adjust this setting? I am not a developer and am without anyone right now to help me but can follow explicit instructions. I hope you can help me.

Thank you.

[mc12345678]

Hello,

I am new to the ZC Forum and have never posted before. Hoping this is the correct place and method.

Using EP4 and ZC 1.5.1. I loaded 1700 products simultaneously with success, (updated existing and added new), except for the length of the "v_products_name_1" field was too short for some of the products names. The field length is set at 128 according to the "warning" I received on the products "with issues" and the settings shown on the upper right hand part of the EP4 page. I need about 135 in length.

I have looked everywhere for a solution on the Forum. Closest suggestion found in the Forum was to go to phpMyAdmin in cPanel, then go to "products_description" and "change products_name" there to length of 135. Also go to orders_products and change products_names to 135. I did both and it made no difference. I don't see a name for "products_name_v1" - only for "products_name".

Can you please tell me exactly where to adjust this setting? I am not a developer and am without anyone right now to help me but can follow explicit instructions. I hope you can help me.

Thank you.

You came to the right area for this question (I think), good first post, keep up that type of description in future posts.

Either I or someone that already know the answer for the first part will get back to you with how to change the size/length of the field, but there is a part of your post that I don't fully understand, but may make an assumption.

When you say there is no product_name_v1, do you mean that when you look in mysqladmin at the table in question, all you see is product_name and you don't see product_name_1?

The extra _1 is a language "switch". The value of _1 means to assign the product_name to language1 (whatever thatmay be ie. English) a product_2 would be to assign the text to the second language. This way an update can be made to a product in multiple languages. If that has given you enough to make the desired change(s), then good.

Now as for the fulllength needed, should be able to use the spreadsheet program to identify the maximum length of your current products. Add a new column that calculates the length of the cell that has the name, then using a different cell, find the maximum in that column. After you have figured that out, if the new data is on the same spreadsheet as all of your other data, I recommend deleting it before saving/exporting to prepare for upload to urstore. Otherwise do the calculations on a different sheet, and don't have to worry about deleting it. Probably want to add a few characters to the total length so that don't have to increase again any time soon.

Didn't check the above, but hopefully my spacebar worked enough times to not be confusing. :) (cell phone used to type this.)

[pdevo]

Hello and thank you so much for taking time to reply with your cell phone. :) I can read your post just fine.

You asked, "When you say there is no product_name_v1, do you mean that when you look in mysqladmin at the table in question, all you see is product_name and you don't see product_name_1?"

Yes, and sorry for the typo adding the "v" in front of the "1". There is no "product_name_1" I can find in the phpMyAdmin table. I learned through other posts about the "1" being a designator for language and did not know that until today. Thank you for explaining it is a "switch" and why it's there as I did not know that. I always just followed the example I had for the column heading and didn't question it. Now it makes sense.

I look forward to someone telling me how to change the length of the field with the "_1" at the end of products_name since what I did does not seem to have fixed it. There are several column headings on my EP4 template for updating and loading new products which have the "_1" suffix on them. So I don't know if there is something special I have to do with regard to making this change or if it should have worked the way I did it. Obviously, I am missing something.

Thank you for the suggestion of running a formula for length of cell. Very helpful and I should have thought of that. :) Much easier.

Thank you for your time.

[mc12345678]

Hello and thank you so much for taking time to reply with your cell phone. :) I can read your post just fine.

You asked, "When you say there is no product_name_v1, do you mean that when you look in mysqladmin at the table in question, all you see is product_name and you don't see product_name_1?"

Yes, and sorry for the typo adding the "v" in front of the "1". There is no "product_name_1" I can find in the phpMyAdmin table. I learned through other posts about the "1" being a designator for language and did not know that until today. Thank you for explaining it is a "switch" and why it's there as I did not know that. I always just followed the example I had for the column heading and didn't question it. Now it makes sense.

I look forward to someone telling me how to change the length of the field with the "_1" at the end of products_name since what I did does not seem to have fixed it. There are several column headings on my EP4 template for updating and loading new products which have the "_1" suffix on them. So I don't know if there is something special I have to do with regard to making this change or if it should have worked the way I did it. Obviously, I am missing something.

Thank you for the suggestion of running a formula for length of cell. Very helpful and I should have thought of that. :) Much easier.

Thank you for your time.

Okay, so another confusing statement, but no matter... :)

So, each field that has an underscore followed by a number (ie. _1) is a field that can be found in the (prefix)products_description table. And again, the number corresponds to an installed language. No two stores are guaranteed to have the same sequence of languages. (Meaning a random selection of websites that have multiple languages may put Spanish 2nd, 1st, 6th, etc... Assuming that another language was applied/installed at some point before...

So, regarding the field length... That is controlled within your mySQLadmin editor...
If you open the mySQLAdmin editor (most likely through your cPanel), then open your store's database, then open the table (prefix)products_description, then while on the Structure tab, select the products_name field and edit it.

The next window should show the various information related to the field. For example the Length/Values... Update though for this type of data to have the maximum that you want to be able to enter.

Hope that helps.

[pdevo]

Okay, so another confusing statement, but no matter... :)

So, each field that has an underscore followed by a number (ie. _1) is a field that can be found in the (prefix)products_description table. And again, the number corresponds to an installed language. No two stores are guaranteed to have the same sequence of languages. (Meaning a random selection of websites that have multiple languages may put Spanish 2nd, 1st, 6th, etc... Assuming that another language was applied/installed at some point before...

So, regarding the field length... That is controlled within your mySQLadmin editor...
If you open the mySQLAdmin editor (most likely through your cPanel), then open your store's database, then open the table (prefix)products_description, then while on the Structure tab, select the products_name field and edit it.

The next window should show the various information related to the field. For example the Length/Values... Update though for this type of data to have the maximum that you want to be able to enter.

Hope that helps.

I'm so sorry I made my statement confusing. Thank you for the instructions. I followed them exactly, and unfortunately, this is the exact same thing I did previously which did not work.

Went to database>table: products_description>products_name and changed VARCHAR to 165 under Length/Values.

Went to database>table: orders_products>products_name and changed VARCHAR to 165 under Length/Values.

The Database Field Lengths are still listed as follows on the "Easy Populate 4.0.22 - Beta 6-10-2012" page from where I again imported the file to my test site:

Database Field Lengths
categories_name:255
manufacturers_name:32
products_model:32
products_name:128

After I re-imported the file, I got the same results on some of the products: "Warning! ...(product Model and info are listed)... exceeds max. length: 128"

Any more ideas? Is there a modification which has to be made to the EP4 code which is downloaded on my site? If so, where and how or is this not applicable?

Thank you for your help.

[mc12345678]

I'm so sorry I made my statement confusing. Thank you for the instructions. I followed them exactly, and unfortunately, this is the exact same thing I did previously which did not work.

Went to database>table: products_description>products_name and changed VARCHAR to 165 under Length/Values.

Went to database>table: orders_products>products_name and changed VARCHAR to 165 under Length/Values.

The Database Field Lengths are still listed as follows on the "Easy Populate 4.0.22 - Beta 6-10-2012" page from where I again imported the file to my test site:

Database Field Lengths
categories_name:255
manufacturers_name:32
products_model:32
products_name:128

After I re-imported the file, I got the same results on some of the products: "Warning! ...(product Model and info are listed)... exceeds max. length: 128"

Any more ideas? Is there a modification which has to be made to the EP4 code which is downloaded on my site? If so, where and how or is this not applicable?

Thank you for your help.

If you haven't modified the EP4 code, then there is nothing about EP4 that is hindering using more space in the field. I say this because EP4 reads the size of the field from the database and then reports (and uses) that size to display what you are seeing. It could be that the value was cached somewhere in the process. Suggest clearingcache/cookies and trying again, or trying to access from a different browser or machine (sort of like clearing those two without actually doing so for the first two tries or so.) Anyways, EP4 just didntsee the change at the tme of testing, perhaps when you read this next (if the change stays the way it is/was) EP4 will report a. Different result.

[pdevo]

If you haven't modified the EP4 code, then there is nothing about EP4 that is hindering using more space in the field. I say this because EP4 reads the size of the field from the database and then reports (and uses) that size to display what you are seeing. It could be that the value was cached somewhere in the process. Suggest clearingcache/cookies and trying again, or trying to access from a different browser or machine (sort of like clearing those two without actually doing so for the first two tries or so.) Anyways, EP4 just didntsee the change at the tme of testing, perhaps when you read this next (if the change stays the way it is/was) EP4 will report a. Different result.

Thank you so much for the follow up. Although I tried clearing the cache yesterday and didn't see a change, this morning when I booted up fresh for the day, the change showed up. It is not showing on my test site but I am taking steps to clear that up. Thank you so much for your help. I am without a developer right now (and desperately need one) and truly appreciate your assistance and that of the forum.

I see we can "buy you a cup of coffee" for your help. I would be happy to do that. Can you please direct me on how to get that done?

Thank you.

[allmart]

Hello Again,

I have a similar problem, however mine is not related to character length. When importing with EP4, new products are not appearing, yet in Zen Cart in Category/Products, it displays that there are multiple products active yet they don't display. After looking at my SQL Database the new products are there and displaying all the imported data except for "product_name" and "product_description". For example if the new product I imported has products_id 5, there is no data for the two fields in question, obvious why they don't show up in Zen Cart. What am I doing wrong?

[mc12345678]

Hello Again,

I have a similar problem, however mine is not related to character length. When importing with EP4, new products are not appearing, yet in Zen Cart in Category/Products, it displays that there are multiple products active yet they don't display. After looking at my SQL Database the new products are there and displaying all the imported data except for "product_name" and "product_description". For example if the new product I imported has products_id 5, there is no data for the two fields in question, obvious why they don't show up in Zen Cart. What am I doing wrong?

Okay, so now that I've gone back to identify what version of EP4 has possibly been installed (assuming still EP4 version 4.0.32 on ZC 1.5.4) the questions posted above apply to this issue as well... What filetype was trying to be populated, what was the filename, what are the headers in the csv file that was imported, and what is the text for one or more of the product that. Are not showing up, what are the admin settings for items such as what the primary_key is (assuming the default being products_model), are these new product or is data being removed from existing product...

In otherwords need enough information to reproduce the issue and/or possibly identify if something in fact was being done incorrectly.

[allmart]

Sorry, Easy Populate 4.0.32 on ZC 1.5.4.

csv file below:
---------------------------------------------------
v_products_model,v_products_type,v_products_image,v_products_name_1,v_products_d escription_1,v_products_url_1,v_specials_price,v_specials_date_avail,v_specials_ expires_date,v_products_price,v_products_weight,v_product_is_call,v_products_sor t_order,v_products_quantity_order_min,v_products_quantity_order_units,v_products _priced_by_attribute,v_product_is_always_free_shipping,v_date_avail,v_date_added ,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_tax_class_title, v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_mode l_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_titl e_1,v_metatags_keywords_1,v_metatags_description_1
AR695GR,1,AR695GR.png,Arizona Grapeade 24x680ml Can,24x680ml Can,,,,,17.99,39,0,0,1,1,0,0,0000-00-00 00:00:00,0000-00-00 00:00:00,100,Arizona Beverages Canada,Cans Non-Carbonated,Taxable Goods,1,0,0,0,0,0,,,
---------------------------------------------------
msg after import:
--------------------------
UPDATED! - Model: AR695GR | 1 | AR695GR.pn | Arizona Gr | 24x680ml C | | | | | 17.99 | 39 | 0 | 0 | 1 | 1 | 0 | 0 | 0000-00-00 | 0000-00-00 | 100 | Arizona Be | Cans Non-C | Taxable Go | 1 | 0 | 0 | 0 | 0 | 0 | | | |
--------------------------

filename: Book1.csv