EasyPopulate 4.0 Support Thread

Progress Report: Attributes!

I finally had some free time and have been working on attribute importing again. So far, I have the Basic Attributes export/import working and have added Multiple-Language support so you can define your Options Names and Options Values for each language at import.

The Basic Attributes import sheet is for creating Options Names and Options Values and assigning them to a existing Product Model. Options Names and Options Values are created dynamically at import and assigned to the specified product.

I am now working on the Detailed Attributes import. This sheet will let you set all the specific micro details for attributes as assigned to a product. This sheet will be a restrictive 1-to-1 import that is used ONLY to update Attribute/Option Values details as assigned to a given product.

This shouldn't take too much longer ... hopefully I'll be able to complete things this week and get an update posted by the week-end. No Promises! But this is my goal, BUGS willing!

-chadd

Outstanding news, thanks!

sph

WANTED! Guinea Pigs for Attribute Testing.

I am looking for several zencart veterans that are avid Attribute users for some pre-release testing. You should be confident on how to install mods, have a backup of your site for testing purposes and also be using the MySQL Backup mod so you can easily backup/restore your store's databases. Multiple language users a plus.

Please DO NOT use on a LIVE site.

This is what I've accomplished to date:

Basic Attribute export: Single Line for each products_model. Will create
options_name and options_values_name dynamically and assign that set to
given products_model. Multi-language enabled!
This export is now 'round robin' ... meaning that the export file layout now matches the import file layout.

Once carefully tested, I will add select additional columns based on feedback from KNOWLEDGEABLE attribute users (of which BTW, I'm NOT one. LOL!).

Detailed Attribute export: This is the "whole shabang" ... giving you all
the info in the PRODUCTS_ATTRIBUTES table. This sheet has an entry for
each products_model + options_name + options_values_name. With this table
you can set all the specifics for each option. This sheet is ONE-TO-ONE and only used
to UPDATE existing PRODUCTS_ATTRIBUTES table entries, i.e. no deleting/adding options_names or options_values_names.

Current state is working. However, I don't have a great deal of error
trapping. I also don't have a functionality that will "replace" an
existing attribute set. This would need to be done within the admin, but
you can add to existing options/values.

This testing is not for noobies, so please be confident in your skills.

Leave me a PM if you qualify and want to do some pre-release testing.

Thanks,
chadd

Hey Chad,

I have tried several times to download the EasyPopulate 4.0 from https://github.com/chaddro/EasyPopulate-4.0 but I cannot get it or download it. :(
Could you please advise?

Thanks in advance,
Kind regards
EC

ecosmic:

Hey Chad,

I have tried several times to download the EasyPopulate 4.0 from https://github.com/chaddro/EasyPopulate-4.0 but I cannot get it or download it. :(
Could you please advise?

Thanks in advance,
Kind regards
EC

It looks like github may be having some issues. I got a 503 Bad Gateway error myself when attempting to download the zip. Give it a little time. Perhaps github is having some server issues.

-chadd

chadderuski:

It looks like github may be having some issues. I got a 503 Bad Gateway error myself when attempting to download the zip. Give it a little time. Perhaps github is having some server issues.

-chadd

Yep, it seems this happens from time to time...

Github is back online:

https://github.com/chaddro/EasyPopulate-4.0/zipball/master

Thanks a lot Chadd!! :clap: I'll install it today.

chadderuski:

Progress Report: Attributes!

I finally had some free time and have been working on attribute importing again. So far, I have the Basic Attributes export/import working and have added Multiple-Language support so you can define your Options Names and Options Values for each language at import.

The Basic Attributes import sheet is for creating Options Names and Options Values and assigning them to a existing Product Model. Options Names and Options Values are created dynamically at import and assigned to the specified product.

I am now working on the Detailed Attributes import. This sheet will let you set all the specific micro details for attributes as assigned to a product. This sheet will be a restrictive 1-to-1 import that is used ONLY to update Attribute/Option Values details as assigned to a given product.

This shouldn't take too much longer ... hopefully I'll be able to complete things this week and get an update posted by the week-end. No Promises! But this is my goal, BUGS willing!

-chadd

:clap:
Can't Wait!

How do you add non-product table values - example Featured?:
v_featured_date_available
v_featured_expires_date
v_featured_date_added
v_featured_date_modified

Thank you.

Chad,
Is the new basic attribute import functionaltiy already in the current github Ep4 zip download? Id love to play with it.

makenoiz

fewusa:

How do you add non-product table values - example Featured?:
v_featured_date_available
v_featured_expires_date
v_featured_date_added
v_featured_date_modified

Thank you.

This would require specific programming and I'd have to look to see where the "featured" information is held. I can do this, but it will have to wait until attributes passes muster.

makenoiz:

Chad,
Is the new basic attribute import functionality already in the current github Ep4 zip download? Id love to play with it.

makenoiz

Yes, but it is VERY basic. Give me a few more days to round out the new attribute import features.

Hi Chad, this is my first time posting in zencart community. I have installed Easy Populate 4.0.19 - Beta 1-28-2012 safely and add some product in my category. This is my new zencart store and i have tried upload my 500 product into the database using 4.0 version.

The problem i'm having is data upload all but it appear in my admin only less than half. i check in my phpmyadmin, it only upload half.

Updated records: 461
New Imported records: 21
Errors Detected: 0
Warnings Detected: 14
Memory Usage: 3720348
Memory Peak: 3925776
Execution Time: 2.43897008896 seconds.

The updated records seems did not appear in my cart but updated. This is my second attempt try to upload full data into the database and failed.

Really need your advise why it can't fully upload although system said updated.

Thanks in advance.
Ariff

Chad... changing the delimiter from COMMA to TAB is just a case of:

// CSV VARIABLES - need to make this configurable in the ADMIN
// $csv_delimiter = "\t"; // "\t" = tab AND "," = COMMA
$csv_delimiter = ","; // "\t" = tab AND "," = COMMA
$csv_enclosure   = '"'; // chadd - i think you should always us the '"' for best compatibility

TO

// CSV VARIABLES - need to make this configurable in the ADMIN
$csv_delimiter = "\t"; // "\t" = tab AND "," = COMMA
// $csv_delimiter = ","; // "\t" = tab AND "," = COMMA
//$csv_enclosure   = '"'; // chadd - i think you should always us the '"' for best compatibility

Is that all that needs to be done?

Chad,

New to ZenCart, advised to get EP4 "The Chad Version", have read this complete thread. Downloaded EP4 from github, and have installed per instructions. :smile: All have gone very well, until we went to Tools->Easy Populate 4.

The stated version and date on this is: "Easy Populate 4.0.19 - Beta 1-28-2012". :dontgetit

Reading the thread shows a flurry of activity has happened since then. :lookaroun

Is the downloaded version actually up-to-date with your releases and just not marked correctly, or is there a better/newer version for download? :unsure:

I got a fatal erro after i changed my host,The version worked fin in my old host,someone please help.

atal error: Call to undefined function mb_internal_encoding() in /home/...easypopulate_4.php on line 4

what can i do to solve this problem.Thank you very much

Hello,

I have a clean install of Zencart 1.5 I downloaded chad's EP 4.0
I put all my admin folders in and the zen 1.5 extra files in. I ran the sql to create the table.

To test the file I put a fake product in. And exported full product categories list.

The csv came through with the headers, but no product?

So I put a few products into the file, and imported in. I did not get the congrats products added, lines ready. Anything.

Did I miss a step in the installation?

Thank you.

I've followed the installation directions exactly for ZenCart 1.5, but Easy Populate 4 is still not showing up in my tools. I've tried reinstalling it twice now with no luck. Where should I start with troubleshooting this?

I ended up getting the installation working, but I'm still getting the warning that my uploads folder is missing even after I change the directory.