Easy Populate 1.2.5.4 support

[awhfy99]

Greetings all,

I have large files to import, which I was previously able to upload via splitting the file. Recently, the server on my host - hostgator - hasn't been allowing me to split or upload files properly. The host gave me SSH access - mind you, I'm a newbie here - to do the upload. (I'm using putty for SSH.)

Here are my questions:

1) I noticed in tutorials on SSH that the file name ends in ".sql". Should I use that extension or use the ".txt" extension on my file?

2) The host recommended that I not split the file. Do I need to change anything on the Easy Populate configuration since I'm not splitting the file?

Any and all advice is appreciated. I may not be able to reply to responses right away...the toddler might need its momma.

Thanks a bunch.

Newbie Linda

Hi Linda,

Please use this at you own descretion, as I never used SSH, but if it is in sql format, it would probably need to be socked straight into the database (not uploaded via EP). There is a MySQL Patch in the tools section that allows for sql inserts. Backup your database, make a 1 product file and try inserting it there (just copy/paste the file there). If it works, great, if not, you will get a host of error messages and hopefully no ill effects. Push come to shove, just restore that backup you did a few minutes before, no harm, no foul. PS, I backup before any EP upload, just in case. It would be prudent to do so if using SSH also.

[maxim]

Thanks for the input.

My file is in the "easy populate" format. (I had just thought about changing the extension to .sql, but I do not think that's necessary - after reading a bit more on SSH.)

What I am not clear about is whether I can do a direct import of the easy populate formatted file to the database. Ultimately, I will give it a try with backups, etc...but, will check the forum for any other replies before doing so.

(My host is trying to fix a problem before I can try, but I will update the forum once done...hopefully successfully.

Linda

[jamesdavid]

A lot of my products are going to be the same price so i downloaded Easy Populate. When i go Admin/ Tools/ Easy Populate I can only export my current products list as a text document.

Here are my options;
Download Complete tab-delimited .txt file to edit (Attributes Not Included)
Download Model/Price/Qty tab-delimited .txt file to edit
Download Model/Category tab-delimited .txt file to edit
Download Froogle tab-delimited .txt file
Download Model/Attributes tab-delimited .txt file

When i open my complete download with open office i get this;

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	EOREOR
		500 34mm Red Gemstones	Pack of 500 34mm Gemstones					5.5	0		2008-06-04 13:39:23	999		More Gems	Red Gems						--none--	1	EOREOR
		500 30mm Red Gemstones	Pack of 500 30mm Red Gemstones					5.5	0		2008-06-04 13:38:27	999		More Gems	Red Gems						--none--	1	EOREOR
	/products/stamptool/stamptool.jpg	Gem Setting Kit	Everything you need to get started!    <br />Gem Setter Tool    <br />500 Gems    <br />Free Template					15	0		2008-05-28 15:18:48	9999		Gem Setting Kit							--none--	1	EOREOR
		black1	black1					0	0		2008-06-03 18:01:25	0		More Gems	Black Gems						--none--	1	EOREOR
		Torque Blue Gems	Torque Blue Gems					0	0		2008-06-03 18:01:36	0		More Gems	Torque Blue Gems						--none--	1	EOREOR
		Silver Studs temop	Silver Studs temop					0	0		2008-06-03 18:01:50	0		More Gems	Silver Studs						--none--	1	EOREOR
		500  20mm Red Gemstones	Pack of 500 20mm Gemstones					5.5	0		2008-06-04 13:37:44	999		More Gems	Red Gems						--none--	1	EOREOR
		black prod2	black prod2					0	0		2008-06-03 18:02:38	0		More Gems	Black Gems						--none--	1	EOREOR

The wiki said something about being able to read this file as a spread sheet, how do you do this?

thanks
james

[mydanilo]

Open openoffice calc then file open and choose
Files of type: Text CVS

then it will work...

[jamesdavid]

Even if i open calc, when i open the file with calc it opens it as a text document in the text editor. It even does this when i rename to file to .cvs

My admin Easy Populate tools will only let me export files as txt, is this normal?

[ButterflyPressInk]

Even if i open calc, when i open the file with calc it opens it as a text document in the text editor. It even does this when i rename to file to .cvs

My admin Easy Populate tools will only let me export files as txt, is this normal?

I noticed this problem too. First I create a new OO spreadsheet then I use the menu Insert / Sheet from File. Good luck.

[jamesdavid]

Thanks a lot! seems to be working now

[jamesdavid]

Sorry for all the questions but how do I upload my new catalog?
Ive only changed the names of a few products as a test. Do I need to save the open office spread sheet as a txt file? The closest I can find is a .csv file, but that doesn't seem to work.

[jamesdavid]

Forgot to mention, Ive also tried just changing the text description of one product in the downloaded catalog with a text editor. When I upload this file I get the following;

Upload Results

File uploaded.
Temporary filename: /Applications/MAMP/tmp/php/phph4BC1U
User filename: Full-EP2008Jun06-1010.txt
Size: 1556

No model field in record. This line was not importedproducts/4 | 500 34mm R | Pack of 50 | | | | | 5.5 | 0 | | 2008-06-04 | 999 | | More Gems | Red Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported/products/ | 500 30mm R | Pack of 50 | | | | | 5.5 | 0 | | 2008-06-04 | 999 | | More Gems | Red Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported/products/ | GemSetting | Everything | | | | | 15 | 0 | | 2008-05-28 | 9999 | | Gem Settin | | | | | | | --none-- | 1 |
No model field in record. This line was not imported | black1 | black1 | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Black Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported | Torque Blu | Torque Blu | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Torque Blu | | | | | | --none-- | 1 |
No model field in record. This line was not imported | Silver Stu | Silver Stu | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Silver Stu | | | | | | --none-- | 1 |
No model field in record. This line was not imported/products/ | 500 20mm | Pack of 50 | | | | | 5.5 | 0 | | 2008-06-04 | 999 | | More Gems | Red Gems | | | | | | --none-- | 1 |
No model field in record. This line was not imported | black prod | black prod | | | | | 0 | 0 | | 2008-06-03 | 0 | | More Gems | Black Gems | | | | | | --none-- | 1 |
SKIPPED! - Model: - No category provided for this product | | | | | | | | | | | | | | | | | | | | | |
Upload Complete

[hduk]

Hey all, im trying to update my product list using easy populate. Initially i populated with just product name, price and category. I now want to add descriptions.

My suppliers provide the descriptions, i just want to be able to paste them into ep and upload without having to manually tweak the formatting. Is there any way of doing this.

I have tried several ways but the descriptions all end up on 1 line. The supplied descriptions are in a text format on separate lines.

Thanks in advance