Guest Posted June 21, 2006 Share Posted June 21, 2006 When I try to import a file using EP I get this message File uploaded. Temporary filename: /tmp/phpmnN27D User filename: sample_output_file.txt Size: 80290 Warning: file(/hsphere/local/home/tconcept/tconcept.no/shop/EP_TEMP_DIRsample_output_file.txt): failed to open stream: No such file or directory in /hsphere/local/home/tconcept/tconcept.no/shop/admin/easypopulate.php on line 719 I can't figure out whats wrong.... pls help me.. Quote Link to comment Share on other sites More sharing options...
choosealogin Posted June 21, 2006 Share Posted June 21, 2006 (edited) Before you go further, I should have just asked - what version of EP are you using? I think you are using a version of easy populate that would have included an SQL file, probably named update.sql That contents of that sql file needs to be loaded into your database , i.e. copy/paste the contents of the update.sql file into the "sql" window in Phpmyadmin, usually accessible via the control panel that your host provides. But before you do that, please go back to the easy populate contribution download page and read the description of the version you're using ...make sure it's not specifically written for use with certain other contributions that you might not need/have. Edited June 21, 2006 by choosealogin Quote Link to comment Share on other sites More sharing options...
Guest Posted June 21, 2006 Share Posted June 21, 2006 Thx for quick feedback.... I'm using version 2.90. Quote Link to comment Share on other sites More sharing options...
choosealogin Posted June 21, 2006 Share Posted June 21, 2006 2.9 has some stuff hard-coded into it that could cause you some headaches, IF you don't need it. In the version 2.90b I have fixed a problem of import file. For to use this version you need to install this contribs: - Quantity Price Breaks for Separate Pricing Per Customer 1.02 - Separate Pricing Per Customer 4.11 - Extra fileds. if you don't have installed e checked this easy polulate don't work!!! It's specifically written for use ALONG with those other contributions. If you have those installed and need them, that's great, but if you don't - I would suggest turning back now and using a different version. Version 2.76 is OK for stock OSC, nothing extra is hard-coded into that one. It can be found somewhere near the top on the EP contribution page, where it says 'easy poulate is EASY, ...' Quote Link to comment Share on other sites More sharing options...
Guest Posted June 21, 2006 Share Posted June 21, 2006 I have now changed to version 3.00-MS2 and now I get this message: File uploaded. Temporary filename: /tmp/php92sjaY User filename: sample_output_file.txt Size: 80290 1054 - Unknown column 'p.products_hide_from_groups' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_added as v_date_avail, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.products_hide_from_groups as v_products_hide_from_groups, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND p.products_model = 'MG200MMS' AND ptoc.categories_id = subc.categories_id Quote Link to comment Share on other sites More sharing options...
choosealogin Posted June 21, 2006 Share Posted June 21, 2006 (edited) That one has the same problem. It's written for those other contributions, that's why you are getting the error. Please try 2.76 It's in the spot where you see 'Easy Populate is EASY just start here FIRST !!!!" Edited June 21, 2006 by choosealogin Quote Link to comment Share on other sites More sharing options...
Guest Posted June 21, 2006 Share Posted June 21, 2006 :D It worked..... but on last thing.. Can I delete som coulms from the sample data file. Just need a few of them. Quote Link to comment Share on other sites More sharing options...
choosealogin Posted June 21, 2006 Share Posted June 21, 2006 Rather than fill anything in the sample data file, it would be best to go to your admin panel > catalog > easy populate, then select Download Complete tab-delimited .txt file to edit Then use that file. If you have existing products that you don't need to edit, it is safe to clear them out of that file, then fill in your new products (EP doesn't have the capability to delete, anyway). If you don't have existing products, then just start filling it in :) I've never tried deleting columns, I normally just right click and "hide" w/excel. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 27, 2006 Share Posted July 27, 2006 The file upload works, but something weird is happening. When I'm in the administration and browse the categories is says the DVD's has 2 products. But under the category I cant find anything. Where did the product go? Same thing is on the website. Quote Link to comment Share on other sites More sharing options...
12stepcds.com Posted August 10, 2006 Share Posted August 10, 2006 When I try to import a file using EP I get this message File uploaded. Temporary filename: /tmp/phpmnN27D User filename: sample_output_file.txt Size: 80290 Warning: file(/hsphere/local/home/tconcept/tconcept.no/shop/EP_TEMP_DIRsample_output_file.txt): failed to open stream: No such file or directory in /hsphere/local/home/tconcept/tconcept.no/shop/admin/easypopulate.php on line 719 I can't figure out whats wrong.... pls help me.. I have the SAME problem and I am using the version that was recommended and ironically seemed to FIX this user's situation: EasyPopulate 2.76c-MS2 (The one listed under EASY). I don't know what I am doing wrong! *I downloaded the delimited file and then (without trying to change it) tried to reupload it back. And this is what I got: Warning: move_uploaded_file(/mnt/w0511/d08/s36/b026c191/www/12stepcd.com//shop//catalog//catalog/temp/EP2006Aug10-1503.txt): failed to open stream: No such file or directory in /mnt/w0511/d08/s36/b026c191/www/12stepcd.com/shop/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/tmp/phpq7caQS' to '/mnt/w0511/d08/s36/b026c191/www/12stepcd.com//shop//catalog//catalog/temp/EP2006Aug10-1503.txt' in /mnt/w0511/d08/s36/b026c191/www/12stepcd.com/shop/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /tmp/phpq7caQS User filename: EP2006Aug10-1503.txt Size: 12336 Warning: file(/mnt/w0511/d08/s36/b026c191/www/12stepcd.com//shop//catalog//catalog/temp/EP2006Aug10-1503.txt): failed to open stream: No such file or directory in /mnt/w0511/d08/s36/b026c191/www/12stepcd.com/shop/catalog/admin/easypopulate.php on line 667 Warning: Invalid argument supplied for foreach() in /mnt/w0511/d08/s36/b026c191/www/12stepcd.com/shop/catalog/admin/easypopulate.php on line 690 *I have gone over and over and over the code that I changed in the files. I only did what was suggested. Didn't even change the configurations in EP. Just copied and pasted where suggested. PLEASE help. I am stuck! Quote Link to comment Share on other sites More sharing options...
12stepcds.com Posted August 10, 2006 Share Posted August 10, 2006 One other thing. The temp directory (I had to put one in as there was none there) is empty. I set the settings for permission to 777. I moved the delimited file into it manually even via ftp. It won't take. Not with an upload. Not with ftp. Confused. Quote Link to comment Share on other sites More sharing options...
jahazii Posted August 28, 2006 Share Posted August 28, 2006 I have the same problem if anyone can help Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.