Easy Populate 1.2.5.4 support

Has anyone had success running this from the command line or from a "Read HTML page" type function?

I'd like to setup some automated exports but not having success....

EarlyFloyd Not with the current version of EP, this could be done with a SQL query tho'

MotoDelta If you have command line access, why don't you directly connect to Database using Python(very easy to learn using MYSQLdb module) or any other language and write an automated script to export data?

Doing some testing here before I make mass changes...

I've downloaded a Complete tab-delimited .txt file to edit. I made one change to one product which was to the v_products_name_1. I just changed the product name.

I then deleted all other product rows, leaving just the one row with the test product to change.

I saved file as a tab-delimited text file and uploaded it to the database with EP.

EP uploads the file but, I always get this error which baffles me because I am uploading the same data and all columns as I downloaded except for one change to the product name.

Now the product update actually worked but, I am not sure if this is something of concern or if it's normal.

UPDATED! - Model: my model number | imagefolder | productname | productdescripttion | | | | | price | 0 | | 3/1/2009 1 | 25 | | Catagory1 | Category2 | Category3 | | | | | Taxable Go | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
Upload Complete

Crunch Check your file, have you got a carriage return on the end of your second row, normally you would get this error if you do ?:

UPDATED! - Model: test | test | test | test | | | | | 137.02 | 1.2 | | 0000-00-00 | 200 | 1 | 2 | 3 | | | | | | Vatable Go | 1 |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | |
Upload Complete

May be as simple as that, if so remove/delete it

EarlyFloyd Not with the current version of EP, this could be done with a SQL query tho'

Could you please provide and example? I know how to run a query at this point, but not how to write from scratch yet. I would appreciate it!

EarlyFloyd

Please note I haven't tested this and use at your own RISK... as always TEST first before use on a live site and always BACK UP....

UPDATE products SET products_status = '1' WHERE master_categories_id = 'x' and manufactures_id = 'y';

This should update the product status to active in all the products in the top level category down wards of your top category 'y' with manufacturer 'x'.

(y and x are the id numbers of the category and manufacturer which you can find in your database via phpMyAdmin in the products table)

A very good site for learning SQL for Mysql is tizag you just remove the ' $result = mysql_query(" ' to use pure sql in the Zen Carts SQL Query Executor, always end your SQL with ';'.

Thank you very much for the example and source for further knowledge. I will give it a go tomorrow. :smile:

Scrat:

Crunch Check your file, have you got a carriage return on the end of your second row, normally you would get this error if you do ?:

UPDATED! - Model: test | test | test | test | | | | | 137.02 | 1.2 | | 0000-00-00 | 200 | 1 | 2 | 3 | | | | | | Vatable Go | 1 |
No model field in record. This line was not imported | | | | | | | | | | | | | | | | | | | | | |
Upload Complete

> 
> May be as simple as that, if so remove/delete it

I tested again and checked the tab delimited file and there was a carriage return after EOREOR which I deleted and saved.  Still got the same error when I uploaded again.  This error must be an odd quirk with the contribution.

I have a product listing of over 30,000 items. I tried to upload a .csv to the datbase, via easypopulate, and it did import 13,000 or so of those items...then the server timed out. I seperated the master .csv into three smaller .csv's. Now they don't seem to be uploading at all. Should I TRUNCATE the table in phpMyAdmin before I try uploading again? Also, if I have to upload three different .csv's will they simply overwrite each other or will they add to the tables in the database?

Dale

:blush:

jdw1979 EP Version 1.2.5.4(langer) really works best with approx. 400 products at once, have you got the headers in each cut down file, as you do need these or EP would not know what it is uploading. Do you get any error messages - me thinks not as with over 400 products you usually do not.
As a test cut the original file down to say 10 products and the header row and try it if all seems well this is your problem.

I have continued to fool with this batch update and I have cut the file down to 5000 products per sheet. This seems to upload fine. Thanks for your help.

Dale

I dont really understand this.

7. If you have an Apple/MAC, then uncomment the line in the "configuration variables" section in the easypopulate.php
   file that is in the admin folder.

Also when I download the Download Complete .csv file to edit (Attributes Not Included)

it crashes my excel I m on a mac

any ideas

touchclothing What version of EP are you using ? I don't use a MAC so not the best to advise, but i am sure i have read it some where in this forum that MAC file formats cause problems with EP and tab separated files, hence the > uncomment the line in the "configuration variables"

OK Found this:

jimmysflyshop:

We are using Zen Cart 1.3.8 which I believe is the current program. We have been using Zen Cart for the last few months and have just recently launched our site. We have all the latest programs for Zen Cart. During the building process I was using a PC. I have just purchased an Macbook, and installed Microsoft Office so that I would be able to use Easy Populate with Zen Cart. Everything works okay except for one issue.

My issue is that when I download and update the .csv file and try to import it back to Zen Cart it is not properly updated. The new information that I have entered and saved on the .cvs file is not imported into Zen Cart. When I save the file to be imported I save it as a .csv file. I get a message that the import was successful but I don't receive any messages about the site being updated like I do on my PC.

Am I missing something here? I know I can't be the only one using an Apple to run Easy Populate. Any help would be appreciated. Hopefully I have given you enough information to help me, if not let me know.

rstevenson:

I'm on Mac (OS X v10.4.11) and I too use Excel and EZ Populate, but not often so my memory is a bit rusty on this. I recall that I had some sort of problem using the Excel-created file directly. Since I have a programmer's editor (the excellent BBEdit, see barebones.com) it was easy and quick to open the file in my editor, save it again and then upload it. I never trust MS products to do things simply, so I wouldn't expect the Excel file to be a plain text file. There'll be some junk in it somewhere, I'm sure.

Rob

EP is not updating my images file name and path. Is the problem the "/" in the file path? I need to get this working ASAP, I have over 5000 itmes to input.

Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2.?
MySQL 5.?

I've been using Zen-Cart for over 2 years, this is the first site I have done with this Easy Populate mod, in the past I used the paid version, but I thought I would give this one a try.

my images are all in images/products/123456.jpg and I have verified they are there.

My csv file looks like this:

v_products_model,v_products_imagev_products_model,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_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,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
33838,products/33838.jpg,PATRIOTIC PACHYDERM PR,"With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
34190,products/34190.jpg,UNITED WE STAND WALL PLAQUE,"Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
```yet when I upload and import the file I get images/no_picture.gif assigned to each item.
 
What am I missing?
JOhn ><>

Stuff4Toys As far as I was aware you will only get 'images/no_picture.gif' if no image is assigned to the product, so it would appear that the version you are using is not updating the database in someway properly.
When you edit the product manually is there a image assigned or is the image box empty.

Also I would try the Langer's version from Modhole as this is a tried and tested version that just works !

Stuff4Toys:

EP is not updating my images file name and path. Is the problem the "/" in the file path? I need to get this working ASAP, I have over 5000 itmes to input.

Easy Populate 1.2.5.5.csv
Zen-Cart 1.3.8a Fresh Install
PHP 5.2.?
MySQL 5.?

I've been using Zen-Cart for over 2 years, this is the first site I have done with this Easy Populate mod, in the past I used the paid version, but I thought I would give this one a try.

my images are all in images/products/123456.jpg and I have verified they are there.

My csv file looks like this:

v_products_model,v_products_imagev_products_model,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_date_avail,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,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
33838,products/33838.jpg,PATRIOTIC PACHYDERM PR,"With trunks entwined, these elephants express their affection for each other— and for the USA! Brilliant American flag patchwork pattern. Porcelain. Each is 8¾"" x 5"" x 8"" high, and together form a 16"" long display. Pair",,,,,39.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,
34190,products/34190.jpg,UNITED WE STAND WALL PLAQUE,"Rustic wooden hanging sign proudly proclaims “United We Stand” as patriotic stars cleverly bounce on coils. 12¾"" x ¾"" x 14"" high. ",,,,,12.95,,,,999,,Americana,,,,,,,Taxable Goods,1,0,0,0,0,0,,,

>  
> What am I missing?
> JOhn ><>

Its a problem with your directory.  I think by default it chooses /images which means that your images should be in /images/products I think.

fsc09 EP takes the folder /images/ as default so their is no need to put this in the v_products_image, just the child folder to /images/. In this case that would be products/ - e.g products/33838.jpg.

What is strange, if EP had put the image in the 'products_image' you should not get 'images/no_picture.gif' appearing as ZC sees that the 'product_image' field is not 'null', therefore that is why I asked does the image details appear when you edit the product by ZC.

I am on Zen Cart v 1.3.8a

Does Easy Populate 1.2.5.5 work with that? The download page says it is for Zen Cart v 1.3.6

I just want to make sure as I am new to Zen Cart in the last month.

I uploaded quite a few products last night successfully. This morning I'm getting "Upload Complete", but nothing is being uploaded. I don't get the list of products added like I did last night - just the complete message (with temp file name, user filename, and size displayed). Any ideas?

Nevermind. I found it - I had saved the file as csv rather than txt (tab).