Zen Cart Logo
Forums / Addon Admin Tools / EasyPopulate 4.0 Support Thread

EasyPopulate 4.0 Support Thread

Sticky

Views: 733,317

Results 2,021 to 2,040 of 3,671
28 Jul 2015, 1:10 PM
#2021
blenderite avatar

blenderite

New Zenner

Join Date:
Jul 2015
Location:
Virginia
Posts:
57
Plugin Contributions:
0

EasyPopulate 4.0 Support Thread

mc12345678:

Mind identifying what the issue was to all of those that received the first notification? :)

Otherwise, glad that the issue was resolved.

When I edited it, it was a double post. But I don't see the other one. I am going to have to remember what I posted about lol!

28 Jul 2015, 1:26 PM
#2022
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

Blenderite:

What is the best program to edit the CSV files? I am having troubles with OpenOffice. I tried Notepad++ but it got pretty confusing.

So, open office has been the best program to use mostly because of it's direct support of UTF-8 character handling, date formatting and CSV formatting. I have recently seen instructions by internet search that have identified a way to maintain UTF-8 encoding when using the commercial program Microsoft Excel. The last time I tried it the major issue I encountered was how the date was formatted upon export and that it was not YYYY-MM-DD. That format is what is expected for date fields if they are to be contained in the upload... If the date field is not to be modified then would want to not include the field in the CSV file.

I have also seen some capability in Beyond Compare to manipulate CSV data, but then don't have spreadsheet related versatility.

What issues wth OO are being experienced?

28 Jul 2015, 1:42 PM
#2023
blenderite avatar

blenderite

New Zenner

Join Date:
Jul 2015
Location:
Virginia
Posts:
57
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

OO does open it fine and edit it fine, but when I import the edited file, it doesn't import correctly. All the data entered is randomly mixed up with other columns and stuff. It makes me think that maybe I am not saving it correctly so it is importing wrong. Is there a specific method to save it to make sure it doesn't get messed up?

28 Jul 2015, 1:53 PM
#2024
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

Blenderite:

OO does open it fine and edit it fine, but when I import the edited file, it doesn't import correctly. All the data entered is randomly mixed up with other columns and stuff. It makes me think that maybe I am not saving it correctly so it is importing wrong. Is there a specific method to save it to make sure it doesn't get messed up?

More than likely that step is probably the issue. See post #10 about Open Office Settings for Export. Certainly the software has been updated a bit, but same basic process still seems to apply.

28 Jul 2015, 2:44 PM
#2025
blenderite avatar

blenderite

New Zenner

Join Date:
Jul 2015
Location:
Virginia
Posts:
57
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

I followed step #10 and added a couple of items. Here is the error it throws: http://www.pasteall.org/pic/91219

28 Jul 2015, 2:49 PM
#2026
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

No rows imported, or did only some of them? Contents of the file being imported? (Possibly post the first few lines if those did not import.) Before pasting, please click the # symbol in the toolbar above the text box, then paste.

28 Jul 2015, 2:52 PM
#2027
blenderite avatar

blenderite

New Zenner

Join Date:
Jul 2015
Location:
Virginia
Posts:
57
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

mc12345678:

No rows imported, or did only some of them? Contents of the file being imported? (Possibly post the first few lines if those did not import.) Before pasting, please click the # symbol in the toolbar above the text box, then paste.

Nothing was imported.

v_products_model,v_products_type,v_products_image,v_products_name_1,v_products_description_1,v_products_url_1,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_1,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_1,v_metatags_keywords_1,v_metatags_description_1
,1,,Laconiko Olive Oil - 16.9 fl.oz,"Laconiko olive oil is a fourth generation family of olive oil producers whose estate is on the sandy beaches of Southern Peloponnese, just outside Sparti, Greece. The relatively small number of olive trees on their estate, surrounded by orange and grapefruit trees, allows for an olive oil that is unique and wonderful. The family is committed to bringing a true extra virgin olive oil to the States. Brothers, Diamantis and Dino, reside in Gainesville, VA, but take turns returning to their family's olive estate to work the land with their father. Laconiko olive oil is on Weston A. Price's ""best"" list for their shopping guide. http://laconiko.com/index.html    Each bottle is 500mL/16.9fl.oz.",,,,,25,0,0,0,1,1,0,0,,2015-07-27 15:23:09,6,,"Honey, Olive Oil, Tea, FireCider",--none--,1,0,0,0,0,0,,,
,1,,Laconiko Olive Oil - Value Size - 67.6 fl.oz,"The 2-litre value size of the Laconiko Olive Oil. Save $25 by purchasing this size!  <p>  Laconiko olive oil is a fourth generation family of olive oil producers whose estate is on the sandy beaches of Southern Peloponnese, just outside Sparti, Greece. The relatively small number of olive trees on their estate, surrounded by orange and grapefruit trees, allows for an olive oil that is unique and wonderful. The family is committed to bringing a true extra virgin olive oil to the States, this years harvest has a low acidity of 0.13% (to be an extra virgin acidity must be below 0.8%). Brothers, Diamantis and Dino, reside in Gainesville, VA, but take turns returning to their family's olive estate to work the land with their father. Laconiko olive oil is on Weston A. Price's ""best"" list for their shopping guide. http://laconiko.com/index.html",,,,,75,0,0,0,1,1,0,0,,2015-07-27 15:26:34,4,,"Honey, Olive Oil, Tea, FireCider",--none--,1,0,0,0,0,0,,,
,1,,Wild Alaskan Salmon,"Wild Caught Bristol Bay, Alaskan Salmon Filet Portions $18/lb. (NOW IN SMALLER PORTIONS! .4 lb./package).  <p>  We came across a northern Virginia native who has relocated to Bristol Bay Alaska as a fisherman! Here is the fisherman's description: ""Wild caught in Bristol Bay, Alaska, the largest true certified wild sustainable salmon fishery in the world. After being caught, fish are bled on the spot for higher quality, then stored in 33-35 degree refrigerated seawater until off loaded to tender-ships. Tender-ships transport the salmon from the fishing grounds to the salmon processing plant where the fish are filleted, de-boned and flash frozen. This entire process takes place from the water to the freezer all within 24-30 hours. I have been a Professional Commercial Fishermen in Bristol Bay, Alaska, for seven years. Originally growing up in Fairfax, Virginia I started off by bringing back personally caught fish for family and friends to enjoy. After taking extreme care of our fish on the fishermen's side, I have seen the poor quality of salmon offered in local stores. Therefore, I am offering the highest quality salmon available. Our salmon comes directly from me the fishermen then to you, the consumer.""",,,,,18,0,0,0,0.4,0.4,0,0,,2015-07-27 15:32:29,445.24,,Salmon,--none--,1,0,0,0,0,0,,,

That is what Notepad++ shows. That is after I exported the file from OO. I notice that there is no double quotes.

28 Jul 2015, 2:59 PM
#2028
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

Well, the "error" is reporting what is true with that file. The first column that has the header: v_products_model does not have any data in it.

As to the double quotes, there are occasion of double quotes in the file where basically at least in one instance a comma (field separator) was within the section of information to be updated. Notice in the first row of data the comma after Southern Peloponnese.

28 Jul 2015, 3:20 PM
#2029
blenderite avatar

blenderite

New Zenner

Join Date:
Jul 2015
Location:
Virginia
Posts:
57
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

But when I imported the file into OO, there was no data in that column for the items already there. Can I delete that column and not have an error?

28 Jul 2015, 3:36 PM
#2030
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

Blenderite:

But when I imported the file, there was no data in that column for the items already there. Can I delete that column and not have an error?

For the moment no. EP4 works off of the model field, expecting every product to have a unique model. There are ways to autopopulate the database with a unique model number so that upon export, a model number would be present, the data modified then the import would make the change.

If there are/were no model # information in the initial export, then could do the following:

In the ZC admin-> tools->install SQL Patches box:

Update products set products_model = products_id;

Could concat() information to make it ever more unique or could only update values where products_model = '' or IS NULL, etc...

28 Jul 2015, 5:18 PM
#2031
blenderite avatar

blenderite

New Zenner

Join Date:
Jul 2015
Location:
Virginia
Posts:
57
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

That worked great! Thanks!

28 Jul 2015, 5:32 PM
#2032
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

Blenderite:

That worked great! Thanks!

Glad that worked, just remember now though how the software works as currently written. All product to have a model number, if the model number in one row of data is the same as another, then the later row wll "replace" the content of the previous. The model # can be anything desired that fits within the model field. Also verify on your site side that you are okay with the current results of having a model # flled in the way it is...

28 Jul 2015, 5:50 PM
#2033
blenderite avatar

blenderite

New Zenner

Join Date:
Jul 2015
Location:
Virginia
Posts:
57
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Ok. Now, if I want to update a item, do I just use the same model number to update a particular field or what?

28 Jul 2015, 6:33 PM
#2034
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

Blenderite:

Ok. Now, if I want to update a item, do I just use the same model number to update a particular field or what?

When uploading/importing, yes basically, model number identified will be updated with the contents of the field header along the top. If you're doing a onsey, twosey type update, just include those rows in your upload file.

The best thing to do though is basically go through the readme, export the file(s) for the type of action desired, and when trying something "new", use a single row first. This program modifies the database, so it is always suggested to backup (use of a development site to try new processes is also suggested). There are a few different backup tools available in the plugins section. DrBytes' database backup utility is pretty useful.

28 Jul 2015, 6:50 PM
#2035
blenderite avatar

blenderite

New Zenner

Join Date:
Jul 2015
Location:
Virginia
Posts:
57
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

That makes sense! Thanks!!

11 Aug 2015, 1:53 AM
#2036
fabburl avatar

fabburl

New Zenner

Join Date:
Sep 2012
Posts:
18
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Having a problem that I am uploading attributes with the basic attributes uploader following the template given by easy populate

I get the following message

Updated records: 2229
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0

however, these are actually all new imported records?? I am not sure why this is happening or what I am doing wrong.

11 Aug 2015, 2:20 AM
#2037
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

fabburl:

Having a problem that I am uploading attributes with the basic attributes uploader following the template given by easy populate

I get the following message

Updated records: 2229
New Imported records: 0
Errors Detected: 0
Warnings Detected: 0

however, these are actually all new imported records?? I am not sure why this is happening or what I am doing wrong.

Well, the reason for the above result is because the following sql when executed/queried provided a non-zero number of returned rows and as a result an update was performed:

"SELECT * FROM "
                        .TABLE_PRODUCTS_ATTRIBUTES. "
                        WHERE 
                        products_id = '".$v_products_id."' AND
                        options_id = '".$v_products_options_id."' AND
                        options_values_id = '".$a_products_options_values_id."'"

Each of the variables are collected by related queries above the condition.

This is of course assuming that the filename follows the convention of beginning with

attrib-basic-ep

Otherwise, the result is because the records were being updated as a full import or some other import style...

11 Aug 2015, 5:05 PM
#2038
fabburl avatar

fabburl

New Zenner

Join Date:
Sep 2012
Posts:
18
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

Ah, I did not know the filename has to start with attrib-basic-ep - I assumed any name was fine. I will try again with that name then.

11 Aug 2015, 5:17 PM
#2039
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: EasyPopulate 4.0 Support Thread

fabburl:

Ah, I did not know the filename has to start with attrib-basic-ep - I assumed any name was fine. I will try again with that name then.

While minimally documenated it s covered in the readme... Also, may I suggest downloading/installing verson 4.0.30 whch translates those requirements to the admin window...

12 Aug 2015, 4:03 PM
#2040
ronaldnavarro689 avatar

ronaldnavarro689

New Zenner

Join Date:
Jun 2015
Posts:
25
Plugin Contributions:
0

Re: EasyPopulate 4.0 Support Thread

hello,

I'm using zen cart v1.5.4 and latest easy populate version. The installation went smoothly but I don't know how to enable the Custom Products Fields.
I've read that I should add extra plugins for this ( you mentioned that for short descriptions and upc you've designed it) but I could find only this:
https://www.zen-cart.com/search.php?searchid=3539052
I've also read that you just have to enter the field in the feed and it automatically generates the field?
I also see that I can use the User Defined Products Fields. Should I just generate the UPC field inside it and ignore the custom product fields?
I've also found that I should have true false buttons for each field into the configuration/easy populate 4 section?
https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread/page42
Can you please tell me how I can do it? I didn't try any of the versions because I don't want to mess up.
Please let me know the best way to proceed.
If it's field related can you please tell me what title I should enter for the row?