EasyPopulate 4.0 Support Thread

Good Afternoon-
I seem to have run into a problem while using easypopulate 4.0 I am no longer able to upload my spreadsheet from my computer to my website. This morning I uploaded all my products with no problem. I then attempted to upload my descriptions, at that top of the page it states that the file was uploaded successfully but there is no file listed below it shows that there are no supported data files. I tried to download another Complete Products spreadsheet to my computer and was able to do this without any problems I then tried to upload it back to my website without making any changes or opening it so it was exactly what I had downloaded. I was unable to do so. I noticed that my hosting company had decreased the file size I was able to upload so I spoke with them and they increased it upto 50MB I also tried uploading this file to both my main site as well as my subdomains and I can't upload my spreadsheet to any of my sites. Up until this morning I was able to use easypopulate 4 with no problems.
I am using zen cart 1.5
PHP Version 5.2.17

I am attaching a screenshot of the page

BTW,

if character has code similar to 0x92, for example d0 92 (russian capital letter VE), it converted too. And line with this character(s) getting cut. Lost some time to understand what happening.

zen cart 1.3.9h
Easy Populate 4.0.22 - Beta 6-10-2012
Installed Languages
2-ru: Russian
1-en: English
Default Language: 2-Russian
Internal Character Encoding: UTF-8
DB Collation: utf8

Stizzed:

I have one small issue; I have several product admins who have limited access to the admin. I gave them access to both EZ Populate menu items and they are able to get to /configuration/EZ Populate 4 with no problems. However, attempting to use /tools/EZ Populate 4 throws the following:

**Sorry, your security clearance does not allow you to access this resource.
Please contact your site administrator if you believe this to be incorrect.
Sorry for any inconvenience.
**

chadderuski:

Actually, I haven't messed with the admin profiles in 1.5 at all. I will have to look into it to see if I can duplicate your issue. Thanks for the heads up.

I am having the exact same problem. All users, except for the SUPERUSER, is not able to access the Easypopulate uploader. Any luck looking into this and finding a fix?

wj694:

Good Afternoon-
I seem to have run into a problem while using easypopulate 4.0 I am no longer able to upload my spreadsheet from my computer to my website. This morning I uploaded all my products with no problem. I then attempted to upload my descriptions, at that top of the page it states that the file was uploaded successfully but there is no file listed below it shows that there are no supported data files. I tried to download another Complete Products spreadsheet to my computer and was able to do this without any problems I then tried to upload it back to my website without making any changes or opening it so it was exactly what I had downloaded. I was unable to do so. I noticed that my hosting company had decreased the file size I was able to upload so I spoke with them and they increased it upto 50MB I also tried uploading this file to both my main site as well as my subdomains and I can't upload my spreadsheet to any of my sites. Up until this morning I was able to use easypopulate 4 with no problems.
I am using zen cart 1.5
PHP Version 5.2.17

I am attaching a screenshot of the page

Make sure you have an extension on your filename and NO spaces in your filename. Also be sure to follow the file naming conventions.

Secondly, use FTP and check the contents of your remote folder. EP4 will only show files that are of a valid type.

dremlin:

BTW,

if character has code similar to 0x92, for example d0 92 (russian capital letter VE), it converted too. And line with this character(s) getting cut. Lost some time to understand what happening.

zen cart 1.3.9h
Easy Populate 4.0.22 - Beta 6-10-2012
Installed Languages
2-ru: Russian
1-en: English
Default Language: 2-Russian
Internal Character Encoding: UTF-8
DB Collation: utf8

I'm sending you a PM so we can work offline on this as I will need some of your data and also which language pack you installed so I can attempt to duplicate the same issue.

-chadd

jackie.taferner:

I am having the exact same problem. All users, except for the SUPERUSER, is not able to access the Easypopulate uploader. Any luck looking into this and finding a fix?

This should be fixed in the latest version on Github.

Any ideas on the following, I have been using EP4 with no problems, I can upload files and they are shown on EP4, when I go to UPLOAD my web site showed FORBIDDEN, I tried looking at all permissions and they "seemed" fine (im learning by the way im in no way a profesional). I had someone look at it and they moved the path to EP4 and now it shows "PAGE NOT FOUND" any ideas I can pass on to someone who can sort it.

Chadd-
It was actually my hosting company that was causing the problem they lowered the max file upload size on my account on my main domain and all my subdomains, they put all my setting back to what they were before the problems started and now it work perfectly!

wj694:

Chadd-
It was actually my hosting company that was causing the problem they lowered the max file upload size on my account on my main domain and all my subdomains, they put all my setting back to what they were before the problems started and now it work perfectly!

That's good. It's also good to remember that if you are importing very large files that FTP is more reliable. You can FTP your files to your EP temp directory and then Import (or Split if they are truely massive) as normal.

Also, if you have very large Import files, you'll want to turn Verbose Feedback OFF... this will save memory and improve performance. EP4 will still display any Errors or Cautions that it detects.

-chadd

chadderuski:

This should be fixed in the latest version on Github.

Works great, thank you!

Chadd,

I'm attempting to upload my Google Product Categories into the attributes. The field v_products_options_values_name_1 has a value of
"Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures". After I imported the file it creates two attributes due to the comma.
The first one is "Toys & Games > Toys > Dolls" and the second one is "Playsets & Toy Figures > Action Figures". These are not even valid "Option Values" that I created. The valid one is "Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures".

How can I overcome this problem?

Kevin

sw1138lr:

Chadd,

I'm attempting to upload my Google Product Categories into the attributes. The field v_products_options_values_name_1 has a value of
"Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures". After I imported the file it creates two attributes due to the comma.
The first one is "Toys & Games > Toys > Dolls" and the second one is "Playsets & Toy Figures > Action Figures". These are not even valid "Option Values" that I created. The valid one is "Toys & Games > Toys > Dolls, Playsets & Toy Figures > Action Figures".

How can I overcome this problem?

Kevin

Hi Kevin,
May I ask why you are using attributes (I assume a read-only one) for GPC? The default length of products_options_values_name is way to short to support this, and even your example will get cut off if created through the admin.

What I did was create a field in my products table called products_gpc. Now you have a new column in your Full import sheet v_products_gpc which is supported in EP4. Then I did a quick tweak to Numinix's Google Merchant Feeder to submit this column with my data.

To continue along your path would require using a different delimiter in the core code.

-chadd

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

Please excuse my ignorance...

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

CybaGirl:

Never mind problem fixed :smartalec:...

For those of you who come across this issue the issue is caused by having the "Admin Profiles" mod installed.

To fix the issue go into Tools --> Admin Settings - Edit Permissions

Scroll down to the bottom to where it says:

Third Party Mods (when enabled these 3rd party contributions will appear in the Admin menus determined by their authors)

Then put a tick in the box that says "easypopulate 4" and click the Save Changes button.

EasyPopulate 4.0 should then be shown under your Tools menu.

Chad you might consider adding this information to your install file so that others who are using the "Admin Profiles" mod don't forget to edit their profiles accordingly.

BTW for those of you who are interested. I found out what the issue was by directly accessing the link to EP4 from within my admin panel.

:clap:

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

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

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.

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.

We have the Attrib_Basic (sheet has to be named that) working. Here are our columns, in rows for this post, with what we have below each:

v_products_model
Precious Formals P20550

v_products_options_type
0

v_products_options_name_1
Color

v_products_options_values_name_1
White,Red,Black

SPH:

We have the Attrib_Basic (sheet has to be named that) working. Here are our columns, in rows for this post, with what we have below each:

v_products_model
Precious Formals P20550

v_products_options_type
0

v_products_options_name_1
Color

v_products_options_values_name_1
White,Red,Black

Thank you for your reply. I am having such a hard time understanding all of ZC but I am determined. OK. Back to work.

I added the columns from the sample and the options given. They never showed up. When I downloaded the csv file to see how it was done. They had disappeared. I am sure I am missing something fundamental.

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