paton000 Posted February 14, 2007 Share Posted February 14, 2007 I am having a little trouble configuring Easy Populate. Easy Populate appears in the menu but will not run without correct script. I presume this relates to the Temp Directory not being in the right place....can anyone advise....? I have created a number of Catalog files in various location containing a temp file set to (777). but alas no luck. The easypopulate.php file is in / public_html / admin and easypopulate_functions.php is also in the same directory. Anybody got any ideas as this will be perfect for the number of products I have to amend. Got the following error in osc: Warning: main(includes/functions/easypopulate_functions.php): failed to open stream: No such file or directory in /home/hilosof/public_html/admin/easypopulate.php on line 52 Warning: main(includes/functions/easypopulate_functions.php): failed to open stream: No such file or directory in /home/hilosof/public_html/admin/easypopulate.php on line 52 Warning: main(): Failed opening 'includes/functions/easypopulate_functions.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/hilosof/public_html/admin/easypopulate.php on line 52 ----------------------------------------------------- HEADING_TITLE_EP DEFAUL_LANGUAGE_EP English IMPORT_EP SPLIT_EP IMPORT_TMP_EPEP_TEMP_DIR : INACTIVATE_EP2 INACTIVATE_click_EP DOWNLOAD_EP DOWNLOAD_EP_2COMPLETE_EP DOWNLOAD_EP_2MODEL_PRICE_QUANTITY_EP DOWNLOAD_EP_2MODEL_CATEGORY_EP DOWNLOAD_EP_2EXTRA_FIELD_EP DOWNLOAD_EP_2FROOGLE_EP CREATE_EPEP_TEMP_DIR : CREATE_EP_2COMPLETE_EP CREATE_EP_2MODEL_PRICE_QUANTITY_EP CREATE_EP_2MODEL_CATEGORY_EP CREATE_EP_2EXTRA_FIELD_EP CREATE_EP_2FROOGLE_EP Link to comment Share on other sites More sharing options...
Guest Posted February 15, 2007 Share Posted February 15, 2007 Andy, I started trying to get EP to work last week and had a coupel of errors... Finally got a BLANK screen and stopped working on it and went to check out another product very similar to OSC... That product seems to have WAY too much overhead and is very slow on my DB servers... SO, I am back to trying to use EPopulate.... It has to work... no way to use this without a slick clean method to populate or re-=populate our store.... This has to work ! I'll get back here soon as I finish testing again.... SteveRF Link to comment Share on other sites More sharing options...
drsawbones Posted February 15, 2007 Share Posted February 15, 2007 Don't mind me, I could never make a contribution here, though I've been into PHP for about 10yrs....but! I've got about 60hrs into trying to get it to work. I've read the entire EP forum, from 2003 to current. Lot's in there, made me go chase my tail mostly, but some nice working tidbits that help me to get to next round of problems. If you have a working install with no errors, then the basics ie all your model numbers filled in and no zero values or special characters in your titles...it actually goes pretty smoothly....but, I cannot get it to work with attributes...so my quest continues...I want it all! Not just the model, descriptions and prices. I am also working on trying to make a copy of EP that works with customer levels mod that adds the 4 levels of prices to customer groups. Best thing to do is build a couple test servers, one for your current modded configuration or older version, and one for your new with the latest milestone that you can mod after you get it configured and ep working. Link to comment Share on other sites More sharing options...
drsawbones Posted February 15, 2007 Share Posted February 15, 2007 AS PER TOPIC OF THREAD I'd check your main osc config files for paths, double check they are correct. Then, open up the easypopulate.php file on or around line 30 set this: $tempdir = DIR_FS_DOCUMENT_ROOT . "temp/"; that helpped over here. Link to comment Share on other sites More sharing options...
paton000 Posted February 15, 2007 Author Share Posted February 15, 2007 Thanks for the reply Steve, It looks like the right tool for the job if it works..! I have been trawling the archives trying to find solutions and mods and it does take you round in circles a bit. I am going to get a couple of the developers here to have a look and see if they can get their heads around it. Mind numbing when you dont know ..! Thanks again Andy Andy,I started trying to get EP to work last week and had a coupel of errors... Finally got a BLANK screen and stopped working on it and went to check out another product very similar to OSC... That product seems to have WAY too much overhead and is very slow on my DB servers... SO, I am back to trying to use EPopulate.... It has to work... no way to use this without a slick clean method to populate or re-=populate our store.... This has to work ! I'll get back here soon as I finish testing again.... SteveRF Link to comment Share on other sites More sharing options...
paton000 Posted February 15, 2007 Author Share Posted February 15, 2007 Thanks for the reply. Yep I think it will be all about trial and error. Thanks for the information. You sound pretty clueded up on EP. I see some patients and hardwork coming in my direction I think....! When working with multiple products there has to be a non manual way of updating the products that works. I am sure it is very straight forward to break these problems down but unlike you I have not been in php that long. dawnting is the word I think. Thanks for the reply it is much appreciated (I do prefer the open source community to the MS like products of the world..!) Andy Don't mind me, I could never make a contribution here, though I've been into PHP for about 10yrs....but! I've got about 60hrs into trying to get it to work. I've read the entire EP forum, from 2003 to current. Lot's in there, made me go chase my tail mostly, but some nice working tidbits that help me to get to next round of problems. If you have a working install with no errors, then the basics ie all your model numbers filled in and no zero values or special characters in your titles...it actually goes pretty smoothly....but, I cannot get it to work with attributes...so my quest continues...I want it all! Not just the model, descriptions and prices. I am also working on trying to make a copy of EP that works with customer levels mod that adds the 4 levels of prices to customer groups. Best thing to do is build a couple test servers, one for your current modded configuration or older version, and one for your new with the latest milestone that you can mod after you get it configured and ep working. Link to comment Share on other sites More sharing options...
Guest Posted February 17, 2007 Share Posted February 17, 2007 Easy Populate... We have got to get this working ! EP Version 2.76d NO Addons Stock OSC Install Followed ALL install directions as best I could. I finally resorted to a reinstallation of OSC complete with the test DB to test EP ver2.76d I downloaded by way of the EP menu in Admin, the entire db in cvs format... Opened the downloaded file in Excel, made ONE change to the Model Number (1st field) Saved in Text (Tab Delimited format) Went back into Admin/EasyPopulate , pointed at the new TXT file and attempted to update the DB. The ERROR: No products_model field in record. This line was not imported All records contained a model number.... NOTHING was uploaded... DARN ! (Not what I really wanted to say here..) We have got to get this working... Creating a usable OSC Store without being able to Upload and Edit with EP would be totally unusable... We have got to have a ROCK SOLID method of updating or Uploading products. Hand typing in hundreds of products, prices and descriptions etcetc..is out of the question... SO, bottom line... lots of us need help here... We think we know what we are doing and try hard...but I guess I missed something... Calling ALL experts ! Please help us get this fixed so that we have the correct ver of EP and KNOW how to make it work for us ! PLEASE ! Reagrds, SteveRF Link to comment Share on other sites More sharing options...
Guest Posted February 17, 2007 Share Posted February 17, 2007 Well Hum... I deleted all the "stock" products and attributes... added ONE product and did a download with Easy Populate in the CSV format... The download look perfect ! Opened in Excel, modified ONE Model number and saved in Text (Tab Delimited format).. Uploaded with EP into the database... Same Thing...DID NOT Update ! The error was: No Model Number again , although it DID have a changed model number... BLAH !!! This has just got to work !!! Where are all the EXPERTS... HELP !!! SteveRF Link to comment Share on other sites More sharing options...
paton000 Posted February 18, 2007 Author Share Posted February 18, 2007 Hi Steve. I have not had much luch with EP either. I am now looking at creating a query from the PHPadmin area and downloading directly from MySQL I have managed to download various formats from CSV to Microsoft Excel and Excel 2000. If I can import all my pricing into the CSV/.xls file I should be able to import it back into SQL. When I have worked out the correct query to download it all should be fine as it will be just a case of cutting & pasting a range of cells from each heading, Then uploading. hopefully you should be able to to do the same. I will drop you a line when I have finished the query. Rgds Andy Well Hum...I deleted all the "stock" products and attributes... added ONE product and did a download with Easy Populate in the CSV format... The download look perfect ! Opened in Excel, modified ONE Model number and saved in Text (Tab Delimited format).. Uploaded with EP into the database... Same Thing...DID NOT Update ! The error was: No Model Number again , although it DID have a changed model number... BLAH !!! This has just got to work !!! Where are all the EXPERTS... HELP !!! SteveRF Link to comment Share on other sites More sharing options...
Guest Posted February 18, 2007 Share Posted February 18, 2007 Hi Steve. I have not had much luch with EP either. I am now looking at creating a query from the PHPadmin area and downloading directly from MySQLI have managed to download various formats from CSV to Microsoft Excel and Excel 2000. If I can import all my pricing into the CSV/.xls file I should be able to import it back into SQL. When I have worked out the correct query to download it all should be fine as it will be just a case of cutting & pasting a range of cells from each heading, Then uploading. hopefully you should be able to to do the same. I will drop you a line when I have finished the query. Rgds Andy Andy, Thanks.... I had a good download from Easy Populate... The download worked very well and placed everything from the database in the appropriate field in an excel file... If it comes down, seems like the program would be able to put it back... There MUST be some tiny glitch here.... It is just UNBELIEVEABLE that this EPopulate or a like program is not available and WELL tested for OSCommerce..! There is NO WAY anyone wants to populate their store and maintain it one product at a time through the admin function... We have got to be missing something here..... Somehow, we need to get this thread and a bunch of folks involved to help us...There has to be LOTS of people needing the same solution... I tried ZENCART.... but Oh my... It is a nice program but so loaded that it brings my db server to its knees.... I am going to install a NEW STOCK copy of OSCommerce on yet another domain and test again. Hopefully, some EXPERTS will get in here and help us and keep this thread active until we can get a REAL GOOD SOLUTION to this Easy Populate thing... Thaks for your response SteveRF Perdido Beach Alabama Link to comment Share on other sites More sharing options...
Guest Posted February 18, 2007 Share Posted February 18, 2007 drsawbones.... I have: $tempdir = DIR_FS_DOCUMENT_ROOT . "/catalog/temp/"; My temp dir was placed under the Catalog... so assume this is correct ? My download from the database was perfect and I uploaded without any trouble into an excel file... Upload, however, is another story... After filling in the excel file with a changed model number (to see if this works) the upload executed but nothing was added .. The reported error was that the line was not added becasue the model number was blank...hummm.Nope..it was not blank... at least not in the tab delimited txt file that I submitted to EP for upload... This has just GOT TO WORK before I'd commit to OSCommerce.... We have to have a reliable way to upload and edit products... SteveRF Link to comment Share on other sites More sharing options...
Guest Posted February 18, 2007 Share Posted February 18, 2007 Well... My last upload retured an error listed below: File uploaded. Temporary filename: /tmp/php513xnb User filename: EP2007Feb18-1503.txt Size: 521 No products_model field in record. This line was not imported ------------------------------------------------------------------------ The field I think this is referring to is: v_products_model and that field is the FIRST one in the txt file... What in the world are we doing wrong..This has got to work... Steve Link to comment Share on other sites More sharing options...
Guest Posted February 19, 2007 Share Posted February 19, 2007 IS THERE NO ONE IS INTERESTED IN THIS THREAD ! Getting Easy Populate working correctly is VERY IMPORTANT SteveRF Link to comment Share on other sites More sharing options...
paton000 Posted February 19, 2007 Author Share Posted February 19, 2007 Steve. I know, its like nobody thinks it is a worthwhile project. I did find this offering which I have only just downloaded. uses access to import and export as xls/txt file. might be worth a look at. http://www.oscommerce.com/forums/lofiversion/i...php/t92185.html hope it helps. Andy Andy,Thanks.... I had a good download from Easy Populate... The download worked very well and placed everything from the database in the appropriate field in an excel file... If it comes down, seems like the program would be able to put it back... There MUST be some tiny glitch here.... It is just UNBELIEVEABLE that this EPopulate or a like program is not available and WELL tested for OSCommerce..! There is NO WAY anyone wants to populate their store and maintain it one product at a time through the admin function... We have got to be missing something here..... Somehow, we need to get this thread and a bunch of folks involved to help us...There has to be LOTS of people needing the same solution... I tried ZENCART.... but Oh my... It is a nice program but so loaded that it brings my db server to its knees.... I am going to install a NEW STOCK copy of OSCommerce on yet another domain and test again. Hopefully, some EXPERTS will get in here and help us and keep this thread active until we can get a REAL GOOD SOLUTION to this Easy Populate thing... Thaks for your response SteveRF Perdido Beach Alabama Link to comment Share on other sites More sharing options...
Guest Posted February 20, 2007 Share Posted February 20, 2007 Andy, I took a look at the access db... promising and may make it easier but it looks like it still depends on EP. I had some success today after reloading a stock zip of EP 2.76d I think... I was successful in downloading the txt file with EP, then reading in the txt as a data file into excel 2003 Then manipulated one price and added several new products with new products_model (all different). Each of the new products were successfully added to the database. Now the big test will be to actually set up several catagories, add and mod several products in each.... Will try that tomorrow... SteveRF Link to comment Share on other sites More sharing options...
knott Posted February 23, 2007 Share Posted February 23, 2007 Hi can anyone here help me with getting EP to work - I've posted the problem in http://www.oscommerce.com/forums/index.php?sho...44&st=5300# post number 5318 many thanks Graeme Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.