Easy Populate 1.2.5.4 support

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 ?:

PHP Code:

---

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

Quote:

---

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

PHP Code:

---

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:

Quote:

---

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

PHP Code:

---

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