EasyPopulate 4.0 Support Thread

[sw1138lr]

I went into my phpMyAdmin to view the length of the Options Value. products_options_values_name is varchar(150). So it is long enough to hold "Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures".

The problem is EasyPopulate is creating two "products_attributes" out of the value from my spreadsheet. This is due to the comma "," in the value in the column from the spreadsheet v_products_options_values_name_1. It takes the first part before the comma and added that as an attribute to my product then it took what was after the comma and added that as a second attribute.

Can I change EasyPopulate to see this as one continuous field regardless of the comma?

Can anyone answer this question?

[kcb410]

Hello Everyone,

I've successfully uploaded a couple of test products to a temporary category where I'll copy repetitive attributes to every product before moving them to their proper category.

I'm using the Full-EP file and attempting to move the test products from the temporary category to their proper categories by changing the category in the v_categories_name_1 column, uploading and importing the file. This process actually creates a linked file. I have attached the test file that I'm using.

Has anyone bumped into this issue? or am I just doing something incorrectly?

Any help would be appreciated. Thanks!
Zen 1.3.9h
PHP 5.3.10
MySQL 5.0.95
Easy Populate 4.0.21

[chadderuski]

Hi Everyone! Just want to apologize for being unavailable... I've been under the weather and unable to work. Will try to address every one's issues over the next day.

-chadd

[chadderuski]

Chadd,

When we installed Numinix's "Google Merchant Center Feeder Configuration" version 1.13.0 it did not create a column products_gpc. In the Numinix's instructions it indicates to create the "Google Product Categories" as attributes.

So can I just add the new field manually? If so, how would I get the new field to show up on the products page in the ADMIN?

Thanks,
Kevin

Hi Kevin,

This is correct. I did my own customization of Numinix's code so that I could simply add the products_gpc to the products database and then submit that field rather than going through the effort of creating all the attributes...

-chadd

[chadderuski]

Please excuse my ignorance...

From what I see, Easy Populate creates a .txt file. I need a .csv file. Is this possible? Thank you!

Easy Populate 4.0 will only use CSV files unless you modify the source code...

[chadderuski]

Hi CybaGirl and Chadderuski

I have read all 44 pages of this forum and can still find no solution for my problem. I have sat here for nearly 48 hours straight and have created the same databse/new zen installation and EP mod 10 times. I followed every instruction to the tee. I installed fresh Zen 5. Changed the admin folder to "apurplelisting" deleted the zc_install folder. New site and admin and database working fine. Then I follow your steps again to the tee. Downloaded EP 4. Renamed the ADMIN folder to "apurplelisting" using Filezilla uploaded the 2 folders into "businesslisting" which is a subdomain. So my filezilla route is : public_html/businesslisting/apurplelisting
Login on the admin and no drop down for EP is there in either tools or configuration. ????????????????

This has made me try again and again and agaiin and again and again and again and again and again (you get the point) LOL and there is no answer on this forum expect that whoever experienced the problem managed to get it sorted. Trust me this is no user error. Your post above and the post just before it CybaGirl is exactly the problem I have. BUT wait for it... Your solution is not helping...

In Zen 5 fresh install admin there is a new categories called "Admin Access Management" and there is nowhere in any of the 4 drop down menu's that you as you suggested above "To fix the issue go into Tools --> Admin Settings - Edit Permissions " nor is there any admin settings on under tools as it used to be in Zen 1.3.9. So if this was the case in your situation and I can't access "admin settings", then where can I "edit permissions" to fix this problem ? I even tried the "langer="
method after uploading files and it actually works but before it does it comes up with this error


Easy Populate Configuration Missing. Please install your configuration by clicking here
Warning Easy Populate uploads folder not found!
NIX SERVERS: Your uploads folder is either missing, or you have altered the name and/or directory of your uploads folder without configuring this in Easy Populate.
WINDOWS SERVERS: Please request your web host to assign write permissions to the uploads folder. This is usually granted through Windows server user account IUSR_COMPUTERNAME.
Your configuration indicates that your uploads folder is named EASYPOPULATE_CONFIG_TEMP_DIR/, and is located in /home/purple/public_html/businesslisting/, however this cannot be found.
Easy Populate cannot upload files until you have provided an uploads folder with read/write/execute permissions for the site owner (usually chmod 700 but you may require chmod 777)"

My server runs on Linux and I have full permission to change all permissions. Which I did. But then when you refresh the admin it still does not show and EP in any dropdown menu's.

Please somehelp me as I am prepared to sit here for another 48hrs but after that if the problem has not been resolved, I am going to my garden shed, get my chainsaw and do some really crazy things to my PC. :-)

Hi!

You would not by chance be on a Windows IIS server? If you are, EP4 will probably not work for you as is. I had a recent ***torturous*** experience installing zencart 1.5 and all my "goodies" on an IIS server and I had to make a number of modifications to the code for it to *sort of* work.

Oh Yeah... I will never do another IIS install again. Freaking unbelievably frustrating. Nothing works out of the box. If you are on a Windows IIS server, do yourself a favor and switch to a nice linux box... I like wiredtree.com. Great service, nice boxes... if you need a VPS that is.

Sorry, RANT over!

[chadderuski]

Chadd,

I went into my phpMyAdmin to view the length of the Options Value. products_options_values_name is varchar(150). So it is long enough to hold "Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures".

The problem is EasyPopulate is creating two "products_attributes" out of the value from my spreadsheet. This is due to the comma "," in the value in the column from the spreadsheet v_products_options_values_name_1. It takes the first part before the comma and added that as an attribute to my product then it took what was after the comma and added that as a second attribute.

Can I change EasyPopulate to see this as one continuous field regardless of the comma?

thanks,
Kevin

Hi Kevin,

Yes, you will not be able to use EP4 AS IS to do what you want because EP4 is useing the COMMA as a delimiter. If you want, drop me a PM and we'll test a different delimiter for you.

-chadd

[chadderuski]

I just got EP4.0 working this afternoon. I have ZC1.5.

Can someone set me in the right direction? I am trying to add options. Even the sample file doesn't seem to work. So here is what I know. Let me know what you need to know to help me.

I added columns for the three different items v_products_options_type v_products_options_name_1 v_products_options_values_name_1

Uploaded the csv. Took some time but figured it out.
Products are there but they have no options.
Added the suggested columns.
Still no options. No colors in my shirts.

Does it matter which order in the file? I just added at end.

What do I need to know to proceed.

Hi Mom!

Could you attach the file you used (or send me a pm and you can email to me) as you uploaded it?

Note that you need to first Import your products using the FULL sheet. The Attrib-Basic-EP (you must start the attribute file with that string) is then imported.

The file name is VERY important! If you don't name your files correctly, EP4 won't know what to do with the data. So check your file name.

For example. You can use: Attrib-Basic-EP-shirtcolors.csv

but ShirtColors.csv will NOT work.

Hope this helps!

BTW, you did have a v_products_model column with the model number of the item you wanted to attach the attribute options/values to, yes?

[chadderuski]

Hello everyone,

I've installed EP4 and it seems to working well. Good work chadderuski !

Regarding importing attributes........Is anyone experimenting or having success importing attributes such as?:
v_options_values_price
v_price_prefix
v_products_options_sort_order
v_products_attributes_weight
v_products_attributes_weight_prefix

We have an attribute heavy site with some products having 10-12 option_names with each name having from 5 to 12 option_values some on which are 'priced by attributes'. We're preparing a spreadsheet with approx 500 new products and we're trying to find the best strategy to deal with their attributes.

Any comments are appreciated. Thank you

PLEASE READ: IMPORTANT FOR ATTRIBUTE USERS!!

Your ATTRIBUTE file names MUST begin with:

Attrib-Basic-EP
Attrib-Detailed-EP

Example:

Attrib-Basic-EP-colors.csv
Attrib-Detailed-EP-colors.csv

You must FIRST use the Basic sheet to create your attribute Options Name and Options Values Names and attach these to your products_model.

AFTER your Import your Basic sheet, you can Export the Detailed sheet to edit all the columns. NOTE: you cannot alter the first (8) columns of the sheet as these
are used to assign the DETAILS for that given products_model, products_options_name, and products_options_values_name!

DO NOT MODIFY THESE COLUMNS:

v_products_attributes_id,v_products_id,v_products_model,v_options_id,v_products_ options_name,v_products_options_type,v_options_values_id,v_products_options_valu es_name

You can, however, set the data for the other columns. I highly recommend that you first create at least ONE completed products with the correct options_name and options_values_name with all the detailed setting FROM WITHIN THE ADMIN so you can see what the proper values are when you export the Detailed sheet.

ALSO NOTE: The included sample files will not work for your store unless you first create the products. Perhaps in the next release I will include a sample FULL sheet that can be used to more in conjunction with the attribute samples.

I know the learning curve is a bit steep the first go around, but stick in there. I hope this post helps to clarify some of the confusion in using attrbiutes!

-chadd

[chadderuski]

Hello Everyone,

I've successfully uploaded a couple of test products to a temporary category where I'll copy repetitive attributes to every product before moving them to their proper category.

I'm using the Full-EP file and attempting to move the test products from the temporary category to their proper categories by changing the category in the v_categories_name_1 column, uploading and importing the file. This process actually creates a linked file. I have attached the test file that I'm using.

Has anyone bumped into this issue? or am I just doing something incorrectly?

Any help would be appreciated. Thanks!
Zen 1.3.9h
PHP 5.3.10
MySQL 5.0.95
Easy Populate 4.0.21

Hi!

Unfortunately there is no MOVE functionality in EP4. You will have to manually move them from within the admin to achieve what you want working as you are.