Easy Populate 1.2.5.4 support

I also found that uploading the file with just the model, v_status and the end column has no effect also.

Is it possible change the v_status en masse in phpMyAdmin?

Sorry, three posts in a row!

Answer thanks to Bunyip on another thread:

From Admin > Tools > Install SQL Patches, run this sql query:

UPDATE products SET products_status = 1 WHERE products_id > 0;

There was a new easypopulate.php attached a few pages back. I looked at it and some new fields are in it like meta tag and so forth. Has anybody succeeded creating a version with a field for minimum quantity? This would save me a lot of hand editing.

Hi,

Just installed Easy Populate and its great.

Got two issues though.

Firstly, the images I am uploading are from another website. Is there any way of getting them automatically put onto my website. At the moment they dont appear.

Secondly, I sell iphone accessories and would like the cases to have an option orange blue, black etc etc. How do I do that. I download a csv attributes but it doesn't seam to work.

Thanks in advance.

Best Price Accessori:

Firstly, the images I am uploading are from another website. Is there any way of getting them automatically put onto my website. At the moment they dont appear.

You have to "mass grab" those images and get them onto your local drive - then, ftp them to your shop's images folder.

See how to do that here:
http://www.zen-cart.com/forum/showpost.php?p=682618&postcount=9

Have you tried the admin setting? In the Admin, under Configuration>Easy Populate, there is a setting "Make Zero Quantity Products Inactive?". You could set that to "false".

coolglobal:

I do need items to have a quantity of 0 to enable my "back in stock notification" module. So cannot use the first option.

Hi all
I'm having monster problems trying to upload products to my store. I've done all this before and it's worked fine apart from me stuffing up the subcats which is what I'm trying to fix now.... anyway...

With every upload attempt I get the error msg:

No model field in record. This line was not imported
Upload Complete

I know that this has a tendency to occur in the absence of errors.

With larger uploads of even a few products I get:

No model field in record. This line was not imported
No model field in record. This line was not importedopposed on | Allied tro | while dire | artillery | tanks | and aircra |
No model field in record. This line was not imported
No model field in record. This line was not importeda hex-base | such as su | mechanics | and random |

which contains extracts from the lines that it says failed.

In all cases, easy populate fails to update the database with any information.

This is the text file for a single product that fails to upload and I can't see anything wrong with it.

v_products_model v_products_image v_products_name_1 v_products_description_1 v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_tax_class_title v_status EOREOR
FFGVA08 FFGVA08.jpg Doom Boardgame In doom...lengthy descripton 20/10/08 1 Fantasy Flight Games Boardgames Taxable Goods 1 EOREOR

I've also extracted, using EP, the current db and tried to reupload edited portions without success.

The temp directory is 777. Are there any other file/folder permissions that I need to set?

I'm using zc1.3.8 and uploaded a fresh installation of ep1.2.5.4 and ep1.2.5.5 to check whether that would resolve the issue. I've also used Open Office Calc rather than Excel to make sure nothing sneaky was creeping into the upload. Any help would be very much appreciated as I've been looking at this now for 7hrs and am going slowly nuts. rrrrr :shocking:
Thanks, Steve

sjk1000:

Hi all
I'm having monster problems trying to upload products to my store. I've done all this before and it's worked fine apart from me stuffing up the subcats which is what I'm trying to fix now.... anyway...

With every upload attempt I get the error msg:

No model field in record. This line was not imported
Upload Complete

I know that this has a tendency to occur in the absence of errors.

With larger uploads of even a few products I get:

No model field in record. This line was not imported
No model field in record. This line was not importedopposed on | Allied tro | while dire | artillery | tanks | and aircra |
No model field in record. This line was not imported
No model field in record. This line was not importeda hex-base | such as su | mechanics | and random |

which contains extracts from the lines that it says failed.

In all cases, easy populate fails to update the database with any information.

This is the text file for a single product that fails to upload and I can't see anything wrong with it.

v_products_model v_products_image v_products_name_1 v_products_description_1 v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_tax_class_title v_status EOREOR
FFGVA08 FFGVA08.jpg Doom Boardgame In doom...lengthy descripton 20/10/08 1 Fantasy Flight Games Boardgames Taxable Goods 1 EOREOR

I've also extracted, using EP, the current db and tried to reupload edited portions without success.

The temp directory is 777. Are there any other file/folder permissions that I need to set?

I'm using zc1.3.8 and uploaded a fresh installation of ep1.2.5.4 and ep1.2.5.5 to check whether that would resolve the issue. I've also used Open Office Calc rather than Excel to make sure nothing sneaky was creeping into the upload. Any help would be very much appreciated as I've been looking at this now for 7hrs and am going slowly nuts. rrrrr :shocking:
Thanks, Steve

I have never had that problem before but seems like your messing a few parts of the header section.
v_products_model v_products_image v_products_name_1 v_products_description_1 v_products_url_1 v_products_price v_products_weight v_date_avail v_date_added v_products_quantity v_manufacturers_name v_categories_name_1 v_tax_class_title v_status EOREOR

I think if your missing some of the required fields you might get the error you mention. I have not tried but worth a test. Hope this helps

Hi
Thanks for your reply. Got it working just a few hours ago. Here are some rules I came up with. Some of them might not be necessary:

1. Use EP1.2.5.4 rather than 1.2.5.5. My first problem came from a corrupt 1.2.5.4 and my second problem was something to do with 1.2.5.5. It's kinda confusing following 1.2.5.4 help files when using 1.2.5.5 because 5 uses csv rather than txt and also didn't seem to have EOREORs. I've no idea what my problem was exactly with 5 but it just wouldn't work. A re-install of 4 solved it all.

2. Use Open Office Calc rather than Excel. As recommended in the readme.txt, extract the existing database from your site using 1.2.5.4 under Tools-Easy Populate and then open it in OO Calc. To save once edited, use Save As Text CSV file but replace the 'csv' in the filename with 'txt' and check the 'edit filter settings' box. In the filter settings, make sure 'tab' is selected in the Field delimiter and remove the double quotes (...inverted comma) from the Text delimited to leave the field blank.

3. I then either used easy populate to browse for my file or uploaded it straight the to the server's temp folder in Catalog. I have 1200 products and the browse still worked fine without the need to split the file.

4. Not really a tip, but I noticed that setting the v_status to 9 to delete the product had the slightly rude tendency to delete the small image file used for thumbnails from the server. I'd rather it didn't do that and if I find the line in easy populate's php file that does this I'm gonna maliciously comment it out.

Hope this is all clear. PM me if it isn't. Tonnes of respect to the guy who wrote EP (it would be a horrible task to upload without it). A friendlier batch import wizard mod based on EP would be genius if anybody can produce one... v2 maybe?
Cheers, Steve

Hi! I added easy Populate CSV 2 1.2.5.5 for the 4 th time just to make sure I wasn't the problem. I am running cart 1.3.8a.

I have followed the instructions to the letter and continually get an error.

I have re-installed a fresh EP. It downloaded the first file (csv) to the temp. I didn't touch the file and when I re-import the file from the temp I get:

"Warning: array_flip() [function.array-flip]: The argument should be an array in /xxxx/xxxx/admin/easypopulate.php on line 1222"

at the top of the screen. (xxxx edited for security)

I have looked at the admin/easypopulate.php at line 1222 and I can not see anything wrong. I didn't edit the file so it is from the download in a virgin state.

HELP! I only have a few items on the store as a test but have over 2000 to upload. Sure don't want to do them all manually!

sjk1000:

Hi
Thanks for your reply. Got it working just a few hours ago. Here are some rules I came up with. Some of them might not be necessary:

1. Use EP1.2.5.4 rather than 1.2.5.5. My first problem came from a corrupt 1.2.5.4 and my second problem was something to do with 1.2.5.5. It's kinda confusing following 1.2.5.4 help files when using 1.2.5.5 because 5 uses csv rather than txt and also didn't seem to have EOREORs. I've no idea what my problem was exactly with 5 but it just wouldn't work. A re-install of 4 solved it all.

Hey!

I have same problem as you have. And I also solved it with installing EP1.2.5.4. After 6h troubleshooting...

Have someone here get the EP1.2.5.5 csv-2 to work?

I think thats version have better attribute management.

I did read through as many posts as I could...could someone please direct me to the correct place to download version 1.2.5.4? The link i keep seeing at http://modhole.com is not working...Any help in the right direction would be greatly appreciated. Thanks

I've been having a hell of a time trying to format my CSV correctly. I have a feeling it is my version of Excel not formatting correctly.

I've used Easy populate for over a year on osCommerce, but I am having a major headache with this. I've noticed that when you open a file through excel [txt/csv] so you can view it in a way to edit it and pump it back out to re-import, it screws with the format. It looks totally different than what originally came out of EP.

The is the first time I've used EP on my home comp so I know it has to do with my Excel settings. Is there a program that can load a csv file and format it correct for proper importation?

CSV Example [Pre-load] renamed CSV to TXT so I am assuming it left it comma deliminated.

v_products_model,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_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
"WJ-B2024-E,,""Test wonder"",,,,,,233,12,,""2009-03-24 00:34:02"",10,,""Premium Products"",,,,,,,""Taxable Goods"",1,0,0,0,0,0,,,"

CSV Example [Post Excel] Piece of file I'm trying to add.

v_products_model;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_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
WJ-A1011-BLUE;WJ-A1011-BLUE.jpg;"3"" RETANGULAR ALUMINUM DRIVING LIGHT - BLUE";"3"" RETANGULAR ALUMINUM DRIVING LIGHT - BLUE";;;24.03.2009 00:34;;34,51;4;;;10;WinJet;Aftermarket Lighting;Universal Fog Light Kits;;;;;;Taxable Goods;1;;;;;;;;

Looks like it's semi colon deliminated as well as missing quote markes in specific sections. However it is saved as a CSV file. Not sure how to get around this.

Use OpenOffice instead of excel...make sure to add EOREOR
at end of every product entry or EP will not work

Thanks for the quick response, was going nuts. I tried the EOREOR, however thought .5 did not use it.

Thanks for the Open Office recommendation, I'll try that.

No problem..let us know how you get on...
BTW..EP Version 1.2.5.4 is best!!

momof2:

I did read through as many posts as I could...could someone please direct me to the correct place to download version 1.2.5.4? The link i keep seeing at http://modhole.com is not working...Any help in the right direction would be greatly appreciated. Thanks
You can download Easy Populate Version 1.2.5.4 from

http://www.zen-cart.com/archived_contributions/admin-tools/

I can downgrade, not a problem. Curious though, open office seems to work better, but if I open as a semicolon and save as a CSV, it still reads as semicolon delimited instead comma.

Is there a way to force it to save SPECIFICALLY as comma.

Edit: Never mind, think I got it.

http://www.zen-cart.com/wiki/index.php/Easy_Populate
Suggest you read wiki above...

Thanks a bunch misty!