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?

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 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

sw1138lr:

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

dstegall:

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...

Shroomjunkie:

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!

sw1138lr:

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

dairymom:

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! :p

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?

kcb410:

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_values_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

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

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.

chadderuski:

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.

Thanks Chad. I'll change my strategy and attempt to use EP4 for all of the attributes.

how to use the calc oppenoffice and ep4.0.22 beta 6-10-2012 to import or export names (categories, products,..) with accents in Spanish as "cocó". I have over a thousand products from my zen1.38 and must enter in my new zen1.5.

Should I change the encoding to UTF8? How do I

thanks

sitges65:

how to use the calc oppenoffice and ep4.0.22 beta 6-10-2012 to import or export names (categories, products,..) with accents in Spanish as "cocó". I have over a thousand products from my zen1.38 and must enter in my new zen1.5.

Should I change the encoding to UTF8? How do I

thanks

Is EP4 installed on your 1.38 site? If so, you would do a normal FULL export, but when you open the CSV with OpenOffice, you need to select the correct language encoding on the CSV import page.

Then, when you go do save from withing OO, you would select "edit filter settings" and on the export page select UTF8.

That SHOULD work. Back up everthing first!

excelent
thanks

Greetings;

Love the mod, excellent job, installed perfectly on the first site i run, but on the second site, i cant even load the webpage "http://www.agelessartifacts.com/*****/easypopulate_4.php" i havnt even gotten to the install part when it just comes up with a blank white page....

Any Suggestions on why this is happening.

Darkwander:

Greetings;

Love the mod, excellent job, installed perfectly on the first site i run, but on the second site, i cant even load the webpage "http://www.agelessartifacts.com/*****/easypopulate_4.php" i havnt even gotten to the install part when it just comes up with a blank white page....

Any Suggestions on why this is happening.

Check your cache directory for any error log files. Sounds like a php error. Most likely a file didn't get uploaded correctly, or was corrupted on upload so manually check that each file has uploaded correctly.

Hi everyone.
I've recently found that when I import data with a large number of option values, not all of them are added to the database. For instance if I import the following file:
"v_products_model","v_products_options_name","v_products_options_type","v_products_options_values_name"
"SS044","Colours","0","Ash,Black,Bottle Green,Burgundy,Chocolate,Classic Olive,Deep Navy,Heather Grey,Khaki,Light Graphite,Navy,Orange,Red,Royal Blue,Sky Blue,Sunflower,White,Zinc"

Only the first 6 colours are imported. Am I doing something wrong?

Actually, I made a mistake there.... Only the first six colour options are being added to the product. I think they're being added to the database.

Panic over.... fixed it :)

chadderuski:

Check your cache directory for any error log files. Sounds like a php error. Most likely a file didn't get uploaded correctly, or was corrupted on upload so manually check that each file has uploaded correctly.

Greetings;

I did get an error log it just says this;

[01-Jul-2012 09:52:36] PHP Fatal error: Call to undefined function mb_internal_encoding() in /home/agelessa/public_html/****/easypopulate_4.php on line 139

*** = admin directory which has been removed for security issues.