EasyPopulate 4.0 Support Thread

Quote:

---

Originally Posted by hockey2112

I just updated to the latest version listed above, and my product info is no longer being added to my site. The file uploads fine, and then when I click "Import" next to the file it gives me the "File Import Completed" message, but no products are added to my catalog. Any idea what would cause this?

The only major change I made recently was the installation of my SSL.

--EDIT--
I'm an idiot. It had to do with the file name of the CSV file. I removed the spaces and the & and it now works.



A separate issue... I have Product Category ! and 2 filled out for a few products that should be listed in a subcategory, but all of those products are just getting lumped into the primary category. Any idea what might fix that?

---

Looks like I was doing the categories the "old" way. They now seem to be working fine when I use a single category column with a "^" between the category names.



Another issue... the products that I just uploaded using the latest EP were now showing "Min: 0 Units: 0" on the product pages and on the category pages. This does not show up on my other products that I had previously added to the site. When I add one of those new products to my cart, it gives me a "Quantity Units errors" message and I cannot proceed.

I had my Product Layout set to not display the amount in stock. I have each product set to Product Qty Minimum: 1 / Product Qty Maximum: 0 / Product Qty Units: 1, and have confirmed that the new products are set up exactly like the old ones. Every one of my products has "1000" in the Products Quantity field.

I downloaded a full EP and it shows that the units and minimum were set to "0", even though they were showing up as 1 and 1 in my zen cart back-end. I changed them all to 1, re-imported, and the issue is resolved.

Quote:

---

Originally Posted by hockey2112

A separate issue... I have Product Category ! and 2 filled out for a few products that should be listed in a subcategory, but all of those products are just getting lumped into the primary category. Any idea what might fix that?

---

Please attach some data... you more than likely have the category specified wrong.

If you have mixed products and categories on the same level, you will need to fix this first, then run Tools > Store Manager "Reset ALL Products Master Categories ID" to be sure you don't have something wrong here.

Also. If you are not making backups with Dr. Byte's MySQL Backup tool prior to importing data, you have no way to easily roll back when something goes wrong. Please see Post #1 in this thread.

-chadd

Hi chadderuski,

I followed your guideline, but the option name and option values do not display. Do you have any other tips?

Thanks for your support and help.

John

Quote:

---

Originally Posted by chadderuski

Please try this: Describe in plain English the attribute and attribute values that you want to assign to one product. Note that the product must already exist in your database.

For example: "I have a product widget that I want to assign the attribute Color with values red,green,blue as a dropdown box"

Then your CSV will look like:



hope this helps

---

John,

Are you following the mandatory naming convention for attribute importing? The basic file must start with "Attrib-Basic-EP" and the detailed with "Attrib-Detailed-EP" (with no quotes in the name).

If you don't use these, the script doesn't know how to handle the file.

Also, if you attach a portion of your basic file that would help.

Quote:

---

Originally Posted by chadderuski

John,

Are you following the mandatory naming convention for attribute importing? The basic file must start with "Attrib-Basic-EP" and the detailed with "Attrib-Detailed-EP" (with no quotes in the name).

If you don't use these, the script doesn't know how to handle the file.

Also, if you attach a portion of your basic file that would help.

---

Yes, I do follow the mandatory naming convention for attribute importing. I tried to attach the file, but I could not upload it. Therefore, I use this link directly from my web folder. Please take a look at it and give me your advice. Thanks so much.

http://theladystuff.com/temp/test.csv

John

Quote:

---

Originally Posted by johnn196703

Yes, I do follow the mandatory naming convention for attribute importing. I tried to attach the file, but I could not upload it. Therefore, I use this link directly from my web folder. Please take a look at it and give me your advice. Thanks so much.

http://theladystuff.com/temp/test.csv

John

---

John,

What name did you give the file? Also, you are attempting to load more columns that the BASIC allows. Please see my example above.

After you load the basic attributes, you can export the detail sheet to modify any of the settings.

-chadd

My sister is our spreadsheet-queen and her results, and from what little I've done myself, show that the basic attributes are working out just fine! So far, so good. And possibly the easiest, simplest attribute importer of all easy populates over the years.

Quote:

---

Originally Posted by chadderuski

John,

What name did you give the file? Also, you are attempting to load more columns that the BASIC allows. Please see my example above.

After you load the basic attributes, you can export the detail sheet to modify any of the settings.

-chadd

---

Hi Chadd,

If I upload the BASIC attributes and import them, I saw the message "None of your products imported, "Skipped All""

v_products_model, v_products_options_type, v_products_options_name_1, v_products_options_values_name_1

Please give me more tips. Thanks!

John

Quote:

---

Originally Posted by johnn196703

Hi Chadd,
If I upload the BASIC attributes and import them, I saw the message "None of your products imported, "Skipped All""
v_products_model, v_products_options_type, v_products_options_name_1, v_products_options_values_name_1
Please give me more tips. Thanks!
John

---

John, I'd like to help, but I'm not getting enough information. Please send me a PM with a location of your original CSV file... the one you clicking "Import" on.

Also, you did FIRST import the products to create them? Attributes can only be assigned to Existing products.

-chadd

Hi

Sorry for my english, i'm spanish and write bad
Please, I need help with typical spanish symbols. When I import a CSV file, if exist spanish symbol in the descriptions, then cut the description.
Example: To import "Pequeño horno eléctrico" in the BD only appears "Peque", because the next character only exist in spanish.
I don't know solve it
Thanks, regards

Quote:

---

Originally Posted by badaboomtech

Hi
Sorry for my english, i'm spanish and write bad
Please, I need help with typical spanish symbols. When I import a CSV file, if exist spanish symbol in the descriptions, then cut the description.
Example: To import "Pequeño horno eléctrico" in the BD only appears "Peque", because the next character only exist in spanish.
I don't know solve it
Thanks, regards

---

Hey!
Couple of questions... which version of zencart? which version of EP4? Are you using UTF-8 characters? If so, are your databases set to UTF-8?

Would appreciate it if you could PM me and send a link of the file you are importing. So far from my testing, I have not had any trouble with spanish.

-chadd

i'm so sorry,, but somehow i dont get it and im affraid it the fault of my mac. ( lets hope it is just that)
i get over and over:No model field in record. This line was not imported
No model field in record. This line was not imported
when copieeng back the file i downloaded and added 12 products to..
but yes i DO have product/model


v_products_model" "v_products_type" "v_products_image" "v_products_name_2" "v_products_description_2" "v_products_url_2" "v_products_name_1" "v_products_description_1" "v_products_url_1" "v_products_name_3" "v_products_description_3" "v_products_url_3" "v_products_name_4" "v_products_description_4" "v_products_url_4" "v_specials_price" "v_specials_date_avail" "v_specials_expires_date" "v_products_price" "v_products_weight" "v_product_is_call" "v_products_sort_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_2" "v_categories_name_1" "v_categories_name_3" "v_categories_name_4" "v_tax_class_title" "v_status" "v_metatags_products_name_status" "v_metatags_title_status" "v_metatags_model_status" "v_metatags_price_status" "v_metatags_title_tagline_status" "v_metatags_title_2" "v_metatags_keywords_2" "v_metatags_description_2" "v_metatags_title_1" "v_metatags_keywords_1" "v_metatags_description_1" "v_metatags_title_3" "v_metatags_keywords_3" "v_metatags_description_3" "v_metatags_title_4" "v_metatags_keywords_4" "v_metatags_description_4"
"AIR1001" "1" "air/qrcode.wit.png" " 100 ML Snowwhite" "<p> <span id=""result_box"" lang=""nl""> etc.....

i don''t get it to be honest....

Quote:

---

Originally Posted by kernheimer

i'm so sorry,, but somehow i dont get it and im affraid it the fault of my mac. ( lets hope it is just that)
i get over and over:No model field in record. This line was not imported
No model field in record. This line was not imported
when copieeng back the file i downloaded and added 12 products to..
but yes i DO have product/model


v_products_model" "v_products_type" "v_products_image" "v_products_name_2" "v_products_description_2" "v_products_url_2" "v_products_name_1" "v_products_description_1" "v_products_url_1" "v_products_name_3" "v_products_description_3" "v_products_url_3" "v_products_name_4" "v_products_description_4" "v_products_url_4" "v_specials_price" "v_specials_date_avail" "v_specials_expires_date" "v_products_price" "v_products_weight" "v_product_is_call" "v_products_sort_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_2" "v_categories_name_1" "v_categories_name_3" "v_categories_name_4" "v_tax_class_title" "v_status" "v_metatags_products_name_status" "v_metatags_title_status" "v_metatags_model_status" "v_metatags_price_status" "v_metatags_title_tagline_status" "v_metatags_title_2" "v_metatags_keywords_2" "v_metatags_description_2" "v_metatags_title_1" "v_metatags_keywords_1" "v_metatags_description_1" "v_metatags_title_3" "v_metatags_keywords_3" "v_metatags_description_3" "v_metatags_title_4" "v_metatags_keywords_4" "v_metatags_description_4"
"AIR1001" "1" "air/qrcode.wit.png" " 100 ML Snowwhite" "<p> <span id=""result_box"" lang=""nl""> etc.....

i don''t get it to be honest....

---

How many languages do you have installed?

Your file doesn't look correct. Simplify things by going into Configuration -> Easy Populate 4 and set "Enable Products Meta Data" to False (0).

And I need a section of that entire file. Patching in the forum without attaching the file doesn't help at all. For all I know, you left off category names, or
you did category names wrong for multilingual sites. If you don't want to attached a file to the forum, send me a PM with a link to a file somewhere.

I'll not be able to help you otherwise. There are just too many variables!

Chadd

PS: Just so you know, I'm also on a Mac :p

Chad,

We installed Easy Populate 4.0.19 - Beta 1-28-2012 first. Later we installed Numinix version of Google Feeder. The Google Feeder added the UPC, ISBN, EAN, ASIN, Wholesale Price, MSRP Price, and Condition to the product database. When I added v_products_upc to my excel spreadsheet it does not add the UPC code to my product. I'm just trying to see if I can get one product to update before trying my entire inventory. Does the install of easy populate have to occur after the Google Feeder? If not, How do I get the UPC code to add to the database?

Thanks,
Kevin

Quote:

---

Originally Posted by sw1138lr

Chad,

We installed Easy Populate 4.0.19 - Beta 1-28-2012 first. Later we installed Numinix version of Google Feeder. The Google Feeder added the UPC, ISBN, EAN, ASIN, Wholesale Price, MSRP Price, and Condition to the product database. When I added v_products_upc to my excel spreadsheet it does not add the UPC code to my product. I'm just trying to see if I can get one product to update before trying my entire inventory. Does the install of easy populate have to occur after the Google Feeder? If not, How do I get the UPC code to add to the database?

Thanks,
Kevin

---

Hi Kevin,

Update to the latest version of EP 4.0.22 - Beta 6-10-2012 now at github. I added support for User Defined Products Fields. You'll be able to add your field names in the configuration sections, then export/import with the appropriate column headers.

-chadd

Thanks Chadd,

We installed the new version EP 4.0.22 - But the Admin "Easy Populate 4" does not show any new fields. According to what I read it should have a new field with true and false. I also updated by spreadsheet with the column name of v_products_upc - no success. So I changed it to products_upc - no success. On the Tools menu - it does show TRUE next to UPC. Did we install something wrong?

Product Short Descriptions: FALSE
Product Unit of Measure: FALSE
Product UPC Code: TRUE
Google Product Category: FALSE
Manufacturer's Suggested Retail Price: TRUE
Group Pricing Per Item: FALSE
Exclusive Products Mod: FALSE

Just to let you know I've used easy populate to upload over 6,000 products with success. I just can't get the UPC to upload.

Chadd,

We fixed the issue with the UPC - one of the directories didn't get uploaded to the site.

I was under the impression the ADMIN was also suppose change. I don't see any additional options listed in the ADMIN. Can you help with this?

Uploads Directory EPUploads/
Upload File Date Format m-d-y
Default Raw Time 09:00:00
Upload/Download Prices Include Tax false
Verbose Feedback true
Make Zero Qty Products Inactive false
Smart Tags Replacement of Newlines true
Advanced Smart Tags false
Debug Logging true
Maximum Quantity Discounts 3
Split On Number of Records 8000
Script Execution Time 60
Convert Curly Quotes, etc. 0

Thanks
Kevin

Quote:

---

Originally Posted by sw1138lr

Thanks Chadd,

We installed the new version EP 4.0.22 - But the Admin "Easy Populate 4" does not show any new fields. According to what I read it should have a new field with true and false. I also updated by spreadsheet with the column name of v_products_upc - no success. So I changed it to products_upc - no success. On the Tools menu - it does show TRUE next to UPC. Did we install something wrong?

Product Short Descriptions: FALSE
Product Unit of Measure: FALSE
Product UPC Code: TRUE
Google Product Category: FALSE
Manufacturer's Suggested Retail Price: TRUE
Group Pricing Per Item: FALSE
Exclusive Products Mod: FALSE

Just to let you know I've used easy populate to upload over 6,000 products with success. I just can't get the UPC to upload.

---

You need to go to Tools -> Easy Populate 4 and click Un-Install, then click Install again to load the new configuration variables...

Chadd,

That fixed my issue.

Thanks for helping me.
Kevin

Quote:

---

Originally Posted by sw1138lr

Chadd,

That fixed my issue.

Thanks for helping me.
Kevin

---

Glad to help!

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

Attachment 10669

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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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...

Quote:

---

Originally Posted by 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!

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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?

Quote:

---

Originally Posted by 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_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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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_produc ts_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 :)

Quote:

---

Originally Posted by 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;

Quote:

---

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

Darkwander: You appear to be on an old version of PHP! Your host should upgrade you to 5.3.

Can you verify which version you're on?

Quote:

---

Originally Posted by chadderuski

Darkwander: You appear to be on an old version of PHP! Your host should upgrade you to 5.3.

Can you verify which version you're on?

---

Quote:

---

PHP version 5.3.6
MySQL version 5.0.95-community-log

---

It isnt that much older then the current, but i will ask them to put it on the new php server for me...

Quote:

---

Originally Posted by Darkwander

It isnt that much older then the current, but i will ask them to put it on the new php server for me...

---

Well, that's not right. mb_internal_encoding() is supported in all version of PHP 5 from the manual. Ask your hosting why it's not enabled.

When your check your phpinfo() you should see --enable-mbstring' in the configuration command under build date. If it's not there, then your host will have to recompile php and add multi-byte support.

-chadd

Quote:

---

Originally Posted by chadderuski

Well, that's not right. mb_internal_encoding() is supported in all version of PHP 5 from the manual. Ask your hosting why it's not enabled.

When your check your phpinfo() you should see --enable-mbstring' in the configuration command under build date. If it's not there, then your host will have to recompile php and add multi-byte support.

-chadd

---

The only thing i really have access to is PHPAdmin.. Where do i find if the option is turned on there ?

Quote:

---

Originally Posted by Darkwander

The only thing i really have access to is PHPAdmin.. Where do i find if the option is turned on there ?

---

From within your zencart admin, on the right side is "Version" ... this give you your phpinfo() and a few other things. The should be an entry for mbstring. Perhaps not if php wasn't compiled with the above option.

-chadd

Quote:

---

Originally Posted by chadderuski

From within your zencart admin, on the right side is "Version" ... this give you your phpinfo() and a few other things. The should be an entry for mbstring. Perhaps not if php wasn't compiled with the above option.

-chadd

---

Cant find it in there anywhere... i did a search for mb and also for string, nothing comes up.

okay, i checked on my other site where easy populate is working and there is this under "Configure Command" '--enable-mbstring', this is missing from agelessartifacts where easy populate isnt working, i will get a hold of them at the hosting company and get them to turn it on...

See if that fixes the issue, thanks for the help, will keep you posted.

Greetings;

I got my hosting company to turn on the feature and it is working now.. Thanks for the help..

I am having a serious issue with the dates not working...

when it uploads the file it show as this;

Quote:

---

UPDATED! - Model: AARD0010 | 1 | Animal_Art | We Three L | Dutch Para | | | | | 18 | Resin | | | 1.5 | | 0.2 | | | | Drop us an | 0.2 | | | | | | | 21/06/2012 | 21/06/2012 | 0 | Statue | Animal Art | 0 | 1 | | | | | | | | |

---

but when i go into the site to edit the product manually it shows this

Quote:

---

Date Available:(YYYY-MM-DD)1969-12-31

---

and i have set the option on easy populate to this;

Quote:

---

d-m-y

---

which matches my Text file...

Why isnt it working still, i have tried changing the option in easy populate and it isnt changing the date on the product.

Quote:

---

Originally Posted by Darkwander

I am having a serious issue with the dates not working...

when it uploads the file it show as this;



but when i go into the site to edit the product manually it shows this


and i have set the option on easy populate to this;


which matches my Text file...

Why isnt it working still, i have tried changing the option in easy populate and it isnt changing the date on the product.

---

Product URL: http://www.agelessartifacts.com/inde...oducts_id=1362 - incase you need to see the product on the site.

Quote:

---

Originally Posted by Darkwander

Product URL: http://www.agelessartifacts.com/inde...oducts_id=1362 - incase you need to see the product on the site.

---

I will have to look at the dates again when I have some open time. In the interim, you can turn of the "was added to our catalog" ...

Thanks for the contribution.

I just wanted to see if I could get more of your input on the .htaccess. I saw your script on page 14 and used it, but I was still unsuccessful in downloading the file. I was able to create and delete but not download.

Thanks,

TOG

Quote:

---

Originally Posted by TheOnyxGuy

Thanks for the contribution.

I just wanted to see if I could get more of your input on the .htaccess. I saw your script on page 14 and used it, but I was still unsuccessful in downloading the file. I was able to create and delete but not download.

Thanks,

TOG

---

You may have to right-click the download link and select "save target/save link as" depending on your browser and operating system.

I believe that .htaccess file was for when you put your temp inside your admin directory for added security.

-chadd

Yep, my temp I placed in the admin, and permissions are set 755, and I placed the .htaccess (just like on pg14 nothing added or rmvd) in the temp folder. I just tried to do the right click like you mentioned and it saved the error page, that I would've got had I just clicked on it, as a .csv. So when I open it up in LibreOffice I get html source of the page. Upload, create, and delete work but not the download.

Is it safe enough to leave it out of the admin folder?

Quote:

---

Originally Posted by TheOnyxGuy

Yep, my temp I placed in the admin, and permissions are set 755, and I placed the .htaccess (just like on pg14 nothing added or rmvd) in the temp folder. I just tried to do the right click like you mentioned and it saved the error page, that I would've got had I just clicked on it, as a .csv. So when I open it up in LibreOffice I get html source of the page. Upload, create, and delete work but not the download.

Is it safe enough to leave it out of the admin folder?

---

You should also check your configure.php files. Depending on your installation, I've seen errors that needed to be corrected. Namely, extra '\\' in the url's

correct:

http:\\www.yourstore.com\youradmin\easyphpopulate_4.php

incorrect:

http:\\http://www.yourstore.com\\youradmin\...populate_4.php

If you have that extra double-whack, you will need to edit your configure.php files and correct them.

Alternatively, your .htaccess file is not being read. Don't know how to advise you on correcting it if this is the case, sorry.

-chadd

Ok thanks, appreciate you're input. I will look into the config's and if I resolve it I'll let you know.

Thanks,

TOG

Quote:

---

Originally Posted by chadderuski

I will have to look at the dates again when I have some open time. In the interim, you can turn of the "was added to our catalog" ...

---

Okay dokie, i might have a look at the coding too, see if i can see anything that is causing the problem, however be warned my coding skills are pretty basic... :)

Quote:

---

Originally Posted by igi2011

OK here's how I did it - my example shows the field I wanted to add (products_family), obviously yours will be different :)

There are three files to edit:
YOUR-ADMIN-FOLDER/includes/functions/extra_functions/easypopulate_4_functions.php
YOUR-ADMIN-FOLDER/easypopulate_4.php
and YOUR-ADMIN-FOLDER/easypopulate_4_import.php

You're using the existing 'upc' field each time to create a new product field.

Firstly open YOUR-ADMIN-FOLDER/includes/functions/extra_functions/easypopulate_4_functions.php. Search for

if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}

Now make a copy of this code directly underneath and change this to

if ($ep_supported_mods['family'] == true) { // Products Family Mod
$filelayout[] = 'v_products_family';
}

so you now have

if ($ep_supported_mods['upc'] == true) { // UPC Mod
$filelayout[] = 'v_products_upc';
}
if ($ep_supported_mods['family'] == true) { // Products Family Mod
$filelayout[] = 'v_products_family';
}

Now find the following a few lines further down:

if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}

Copy this chunk of code and change as before, so you now have:

if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$filelayout_sql .= 'p.products_upc as v_products_upc,';
}
if ($ep_supported_mods['family'] == true) { // Products Family mod
$filelayout_sql .= 'p.products_family as v_products_family,';
}

Now open YOUR-ADMIN-FOLDER/easypopulate_4.php and search for 'upc' again - around line 90

$ep_supported_mods['upc'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_upc'); // upc = UPC Code, added by Chadd

Make a copy so you now have

$ep_supported_mods['upc'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_upc'); // upc = UPC Code, added by Chadd
$ep_supported_mods['family'] = ep_4_check_table_column(TABLE_PRODUCTS,'products_family'); // Products Family

Finally open YOUR-ADMIN-FOLDER/easypopulate_4_import.php and search for 'upc' again, there are four edits to make here, here's what mine looks like with the 'family' fields added (the line numbers may be slightly out)

Line 26:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod - chadd
$default_these[] = 'v_products_upc';
}
if ($ep_supported_mods['family'] == true) { // UPC Code mod - chadd
$default_these[] = 'v_products_family';
}


Line 150:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod- chadd
$sql .= 'p.products_upc as v_products_upc,';
}
if ($ep_supported_mods['family'] == true) { // products_family
$sql .= 'p.products_family as v_products_family,';
}

Line 594:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$query .= "products_upc = '".addslashes($v_products_upc)."',";
}
if ($ep_supported_mods['family'] == true) { // products_family
$query .= "products_family = '".addslashes($v_products_family)."',";
}

Line 660:
if ($ep_supported_mods['upc'] == true) { // UPC Code mod
$query .= "products_upc = '".addslashes($v_products_upc)."',";
}
if ($ep_supported_mods['family'] == true) { // family
$query .= "products_family = '".addslashes($v_products_family)."',";
}


Hope this helps - this should work for the fields in the products table, but it might need a bit of tweaking for the field you have in the description table (not sure myself as I haven't tried it)

---

THANKS chadd for this GREAT contribution!
Today I hv installed the latest version chaddro-EasyPopulate-4.0-f4314dc for my ZC1.50, and it works fine for my basic use.
However, there is another reason for me to arrived here, as I just installed the 'related product', and I really need EP4 for a quick update of the new product field (products_family).
As posted by igi2011, thanks for code, it works for at least the Export side. When I tried to Upload the CSV with changes on the products_family, it is Not updated. I wonder where is the mistake..
I've double confirmed the mod on the 3 suggested file.. Any idea, pls?

Quote:

---

Originally Posted by songseng

THANKS chadd for this GREAT contribution!
Today I hv installed the latest version chaddro-EasyPopulate-4.0-f4314dc for my ZC1.50, and it works fine for my basic use.
However, there is another reason for me to arrived here, as I just installed the 'related product', and I really need EP4 for a quick update of the new product field (products_family).
As posted by igi2011, thanks for code, it works for at least the Export side. When I tried to Upload the CSV with changes on the products_family, it is Not updated. I wonder where is the mistake..
I've double confirmed the mod on the 3 suggested file.. Any idea, pls?

---

Songseng,

You no longer have to make edits to the code if you want to add a custom field to your products table. The latest version of EP4 on github adds a new configuration variable for "User Defined Products Fields" ... just list your "products_family" here, and then add the column "v_products_family" to your spreadsheet.

When you return to the EP4 page, you will see an entry for your User Defined Fields and "True" if detected or "False" if not...

Hope this helps!

-chadd

ps: your EP4 version should be 4.0.22 (or later) for this feature

Quote:

---

Originally Posted by chadderuski

Songseng,

You no longer have to make edits to the code if you want to add a custom field to your products table. The latest version of EP4 on github adds a new configuration variable for "User Defined Products Fields" ... just list your "products_family" here, and then add the column "v_products_family" to your spreadsheet.

When you return to the EP4 page, you will see an entry for your User Defined Fields and "True" if detected or "False" if not...

Hope this helps!

-chadd

ps: your EP4 version should be 4.0.22 (or later) for this feature

---

Yes it's EP4 4.0.22 Beta.
Feel great with the "User Defined Products Fields", thats make job more easy and quick.

So I restored the 3 original files. Fill in "User Defined Products Fields" with 'products_family'. I was able to Export the v_products_family data without adding the column "v_products_family" manually to the spreadsheet. Meaning after the Export, I could see "v_products_family" in my CSV straight away.
BUT:
-I wasn't able to see User Defined Fields set to "True" if detected or "False" if not. I'm looking into Configuration > Easy Populate 4 > User Defined Products Fields. It's still showing the 'products_family' as I filled in before.
-After the Upload, the product family field is still Not updated.

I tried manually adding the "v_products_family" to the CSV and upload again, but it's still the same.
Chadd, correct me if I don't follow your steps, appreciate your hints again :blush:

Quote:

---

Originally Posted by songseng

Yes it's EP4 4.0.22 Beta.
BUT:
-I wasn't able to see User Defined Fields set to "True" if detected or "False" if not. I'm looking into Configuration > Easy Populate 4 > User Defined Products Fields. It's still showing the 'products_family' as I filled in before.
-After the Upload, the product family field is still Not updated.

---

Songseng:

In Tools -> Easy Populate 4 on the right-hand side where the info columns are will be an entry for user defined fields. This is
where you will see True/False next to your field name.

You are probably missing something simple. Send me a pm and I'll take a look at your CSV file off site.

-chadd

Greetings;

Just wondering if we have had a chances to look at the date issue, know why it happened and what we need to do to fix it...

Thanks

Quote:

---

Originally Posted by Darkwander

Greetings;

Just wondering if we have had a chances to look at the date issue, know why it happened and what we need to do to fix it...

Thanks

---

Sorry, I have not. I am rather swamped right now too, so I don't know when I'll get a chance to dive into it....

Quote:

---

Originally Posted by 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.

---

Has anyone found a workaround for this? I've got hundreds of products that I need to be moved from a 'new items' type category to their real categories and needless to say, doing it in bulk would be much faster. :)

Quote:

---

Originally Posted by Boggled

Has anyone found a workaround for this? I've got hundreds of products that I need to be moved from a 'new items' type category to their real categories and needless to say, doing it in bulk would be much faster. :)

---

What I do in this situation is to delete them and then reinsert to the correct category(s).

Download the ones to be moved and change the status to 9 and upload. This will delete the product and the image. If you change the image folder name first, then the images should be left untouched.

Change the target folders and the status back to 1 (and rename the image folder back to what it was) and you will be done.

I would try a test product first and be sure to backup your db.

I installed EP, but I don't get any EP options under Tools or Configuration. I had to use ' ?langer=install ' to install EP.

I checked all files against the package three times and they are all there (plus several more that were added during the install). I've installed/downloaded all files into the tempEP folder (screen shot at bottom)


The only way I can get to the function is to call the php file in the browser:

Attachment 10806

I installed from a Mac (OS 10.6.8), although the server is Linux. Do I still need to uncomment the configuration variables, and if so, which section? I'm thinking it's the block below:


/* put below
@set_time_limit(1200);
@ini_set('max_input_time','1200');
//*/


Here's the code for the entire block.
################################################################################ ################################################################################ ##########

//*******************************
//*******************************
// C O N F I G U R A T I O N
// V A R I A B L E S
//*******************************
//*******************************


//CSV VARIABLES
$csv_deliminator = ","; // "\t" for tab
$csv_enclosure = '"'; //if want none, change to space.

/* put below
@set_time_limit(1200);
@ini_set('max_input_time','1200');
//*/
/**
* Advanced Smart Tags - activated/de-activated in Zencart Admin
*/
################################################################################ ################################################################################ ##########

Contents of tempEP folder:

Attachment 10807

Quote:

---

Originally Posted by homebre

I installed EP, but I don't get any EP options under Tools or Configuration. I had to use ' ?langer=install ' to install EP.

I checked all files against the package three times and they are all there (plus several more that were added during the install). I've installed/downloaded all files into the tempEP folder (screen shot at bottom)

---

Homebre,

Sorry, this is not my version of EasyPopulate that you have installed. I am no longer helping to support the other version, sorry.

-chadd

how to make a deafult value for fields such as
v_products_quantity_order_min

i don't want to fill it evertytime.

I've installed the mod and got the normal errors:
Easy Populate "Uploads Folder" missing!
Your uploads folder is missing. Your configuration indicates that your uploads folder is named EASYPOPULATE_4_CONFIG_TEMP_DIR/, and is located in /home/t14dark/public_html/.
Easy Populate Configuration Missing. Please install your configuration by clicking Install EP4

But when I click the Install EP4 link I get the error WARNING: An Error occurred, please refresh the page and try again.

Help please?

Which version are you supporting? The one listed at the start of the thread? https://github.com/chaddro/EasyPopulate-4.0 ??

Yes, I downloaded it about 12 hours ago so I think it's the latest updated version

I'm not entirely sure how I fixed it but I deleted ALL easy populate files from EP4 and previous versions as well and re installed. It's now working

Sorry blonde moment, delete this post please

Quote:

---

Originally Posted by chadderuski

Homebre,

Sorry, this is not my version of EasyPopulate that you have installed. I am no longer helping to support the other version, sorry.

-chadd

---

Reposted, in case it wasn't obvious who I was talking to:

Chadd,

Which version are you supporting? The one listed at the start of the thread? https://github.com/chaddro/EasyPopulate-4.0 ??

Quote:

---

Originally Posted by chadderuski

Sorry, I have not. I am rather swamped right now too, so I don't know when I'll get a chance to dive into it....

---

Hey Chad, i had a play with this today, it seems that if we change the dates in the easy populate file to American (M/D/Y) it seems to upload fine, regardless of what the settings say, i am guessing it isnt pullling the date order from the options or something..

Quote:

---

Originally Posted by homebre

Reposted, in case it wasn't obvious who I was talking to:

Chadd,

Which version are you supporting? The one listed at the start of the thread? https://github.com/chaddro/EasyPopulate-4.0 ??

---

Yes, EasyPopulate 4.0 ... 4.0 is my re-written version. There are other version from other programmers/modders, but this thread in only for my 4.0 version currently only available at GITHUB because I'm still in **beta** ... once EP4 exits beta I will submit to the zencart team.

-chadd

Quote:

---

Originally Posted by Darkwander

Hey Chad, i had a play with this today, it seems that if we change the dates in the easy populate file to American (M/D/Y) it seems to upload fine, regardless of what the settings say, i am guessing it isnt pullling the date order from the options or something..

---

Ya know, it's been some time since I fiddled with that code. There was a LOT of funkiness with the date handling code and I MAY have just standardized it and said "to hell" with the configuration settings! Opps :p Sorry if it's created any confusion!

-chadd

Quote:

---

Originally Posted by chadderuski

Ya know, it's been some time since I fiddled with that code. There was a LOT of funkiness with the date handling code and I MAY have just standardized it and said "to hell" with the configuration settings! Opps :p Sorry if it's created any confusion!

-chadd

---

Err no biggy mate, at least we know what is going on and how to temp fix the problem. You planning on taking another look later down the track or should I set file maker to export as American date for the time been... Rlol

Quote:

---

Originally Posted by homebre

Which version are you supporting? The one listed at the start of the thread? https://github.com/chaddro/EasyPopulate-4.0 ??

---

Well, it could be weeks, or a couple months before I get free time to fix this (and some other minor things). So don't wait on me for now. But your work is appreciated, and I should review this code carefully before exiting beta.

Thanks!
chadd

One small point that I have come across which has caused me no end of pain ! I have had a look for solutions but haven't noticed anything relevant.

I had a piece of code to extract required fields from an XML file and write them to a CSV file for import.

I was originally using fputcsv for this but I discovered that it has a mind of it's own when deciding what fields to use quote marks and not.

I have now had to go the long way round and use fput and some jiggling to make sure each field is written with quote marks.

Is there any real reason why quote marks are needed ??

For anyone interested, here is how I did it. I used some other code I found online and modified it slightly. I don't guarantee that it will be perfect but it does seem to work. Should have more error checking.

Code:

---

function sendCSV($data_array, $enclosure, $field_sep, $record_sep)
{

        dumbescape(false, $enclosure);
        $data_array=array_map('dumbescape',$data_array);
        //return
        $uploadFile = "output" . (12*1024*1024) . ".csv";
        $file = fopen($uploadFile, 'a+');
        fputs($file, $enclosure        . implode($enclosure . $field_sep . $enclosure, $data_array) . $enclosure . $record_sep);
        fclose($file);
}

function dumbescape($in, $enclosure=false)
{
        static $enc;
        if ($enclosure===false) {
                return str_replace($enc, '\\' . $enc, $in);
        }
        $enc=$enclosure;
}

---

Then

Code:

---

sendCSV($my_array,  '"',  ','  ,  "\n");

---

I know it is probably slow (and a lot slower than fputcsv) but this will give correctly formatted CSV for EP 4. Any suggestions on improving this would be gratefully appreciated :-)

If anyone wants more info on how I got the fields out of XML then I can post the rest. Again, it's not professional (because I'm not a professional !) but it works for me.



B. Rgds
John