Re: Uploading to database via SSH
Quote:
Originally Posted by
maxim
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.:D
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.
Re: Uploading to database via SSH
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
Re: Easy Populate support for Version 1.2.5.4
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;
Code:
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
Re: Easy Populate support for Version 1.2.5.4
Open openoffice calc then file open and choose
Files of type: Text CVS
then it will work...:D
Re: Easy Populate support for Version 1.2.5.4
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?
Re: Easy Populate support for Version 1.2.5.4
Quote:
Originally Posted by
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?
I noticed this problem too. First I create a new OO spreadsheet then I use the menu Insert / Sheet from File. Good luck.
Re: Easy Populate support for Version 1.2.5.4
Thanks a lot! seems to be working now :clap:
Re: Easy Populate support for Version 1.2.5.4
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.
Re: Easy Populate support for Version 1.2.5.4
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;
Quote:
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
Re: Easy Populate support for Version 1.2.5.4
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
