Remulon Posted December 12, 2005 Share Posted December 12, 2005 Hi I was wondering if anyone has written a patch for easy populate to import specials? If anyone has, please let me know. If not, and there is enough interest, I will get onto it. Thanks Remo :thumbsup: Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 I don't know if this will help anyone - but I was getting the double slash lines error (as indicated in some prior posts) in my error messages that indicated the file or directory could not be found. I had created a TEMP folder in the Catalog folder. And then I had edited the easypopulate.php lines to read: $tempdir = "/catalog/temp/"; $tempdir2 = "/catalog/temp/"; Well it was doubling up the catalog portion of the address and looking for catalog//catalog/temp..... So I changed the lines to: $tempdir = "/temp/"; $tempdir2 = "/temp/"; And it works great!! Good luck. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 taking a look at your data, it is set at semicolon delimited. when you opened it up in excel, you should have been prompted for a format of the data.also check your easypopulate.php file to make sure it is set at tab delimited and not semicolon delimited. Excellent! My easypopulate.php was defaulting to semicolon delimited. I had not changed this setting, so apparently the downloaded file is set this way (even though it says in the comment code that tab delimited is the default setting). The tab delimited line was commented out in my file and the semicolon delimited line was active. Thanks so much for the fast response - now I can proceed!! Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 you will probably have problems down the road, set the document_root to how i asked, set the temp to /catalog/temp/ and then all will be fine. Excellent! My easypopulate.php was defaulting to semicolon delimited. I had not changed this setting, so apparently the downloaded file is set this way (even though it says in the comment code that tab delimited is the default setting). The tab delimited line was commented out in my file and the semicolon delimited line was active. Thanks so much for the fast response - now I can proceed!! Quote Link to comment Share on other sites More sharing options...
mystifier_uk Posted December 13, 2005 Share Posted December 13, 2005 When I open the file in excel there is no prompts! Can someone tell me what is wrong because I'm a total novice! Thanks! Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 I'm trying to import a CSV file that i've exported from another shop. I've set the delimiter in easypopulate.php, and i've read the instructions... I proceeded with the upload and got this: File uploaded. Temporary filename: /tmp/phpmgrifC User filename: export121205.txt Size: 10107665 Brilliant! I thought, but when I examined the product table, there was nothing in it. I expected it to throw an error, so to find this message and nothing in the product table was surpising. Has anyone had anything like this before? thanks in advance. John Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 open excel first, then from there select 'file, open' and choose your file, you will then be prompted. When I open the file in excel there is no prompts! Can someone tell me what is wrong because I'm a total novice! Thanks! Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 did you first try exporting data to see what you get? what is your temp file setting? what is document_root set to in your admin/includes/configure.php? this one is critical. I'm trying to import a CSV file that i've exported from another shop. I've set the delimiter in easypopulate.php, and i've read the instructions... I proceeded with the upload and got this: File uploaded. Temporary filename: /tmp/phpmgrifC User filename: export121205.txt Size: 10107665 Brilliant! I thought, but when I examined the product table, there was nothing in it. I expected it to throw an error, so to find this message and nothing in the product table was surpising. Has anyone had anything like this before? thanks in advance. John Quote Link to comment Share on other sites More sharing options...
mystifier_uk Posted December 13, 2005 Share Posted December 13, 2005 (edited) Thanks Mibble, that solved the problem! But there's another problem now! :( I open the file okay in Excel but when I have added to it and saved it - and then uploaded it again, it just says: File uploaded. Temporary filename: /tmp/phpM2tUwK User filename: EP2005Dec13-1604.txt Size: 52616 And when I click on the store nothing has been updated! What am I doing wrong? :( Edited December 13, 2005 by mystifier_uk Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 did you first try exporting data to see what you get?what is your temp file setting? what is document_root set to in your admin/includes/configure.php? this one is critical. John When I choose "Download Complete tab-delimited .txt file to edit" (I think that's what you meant) I get a string of comma separated fields, but no data: v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_p roducts_url_1,v_products_price,v_products_weight,........,EOREOR My temp setting in easypopulate.php is now the complete path from the root of my server to the /catalog/temp/ directory. It was just /catalog/temp/ but after this didn't work and I read someone's notes advising this, I changed it. There doesn't appear to be a document_root variable in /catalog/admin/includes/configure.php just lines like the following: define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); Thanks john Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 check your easypopulate.php file, see if it is set for semicolon delimited or tab delimited, needs to be tab delimited. Thanks Mibble, that solved the problem! But there's another problem now! :( I open the file okay in Excel but when I have added to it and saved it - and then uploaded it again, it just says: File uploaded. Temporary filename: /tmp/phpM2tUwK User filename: EP2005Dec13-1604.txt Size: 52616 And when I click on the store nothing has been updated! What am I doing wrong? :( Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 the configure.php will look like this: <?php /* $Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ // define our webserver variables // FS = Filesystem (physical) // WS = Webserver (virtual) define('HTTP_SERVER', ''); // eg, http://localhost or - https://localhost should not be NULL for productive servers define('HTTP_CATALOG_SERVER', ''); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs) define('DIR_WS_ADMIN', '/admin/'); define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN); define('DIR_WS_CATALOG', '/catalog/'); define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); // define our database connection define('DB_SERVER', ''); define('DB_SERVER_USERNAME', 'mysql'); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'osCommerce'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', ''); ?> thus until this is corrected no telling what you will get. also check your easypopulate.php file make sure it is set to tab delimited and NOT to semicolon. John When I choose "Download Complete tab-delimited .txt file to edit" (I think that's what you meant) I get a string of comma separated fields, but no data: v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_p roducts_url_1,v_products_price,v_products_weight,........,EOREOR My temp setting in easypopulate.php is now the complete path from the root of my server to the /catalog/temp/ directory. It was just /catalog/temp/ but after this didn't work and I read someone's notes advising this, I changed it. There doesn't appear to be a document_root variable in /catalog/admin/includes/configure.php just lines like the following: define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); Thanks john Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 John The middle part of the configure.php file now looks like this: // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://oscommerce.tagish.net'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://oscommerce.tagish.net'); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/usr/local/apache/home/oscommerce.tagish.net/htdocs/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/catalog/admin/'); define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN); define('DIR_WS_CATALOG', '/catalog/'); define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); Unfortunately, I still can't upload my CSV file. Regards John Quote Link to comment Share on other sites More sharing options...
Guest Posted December 13, 2005 Share Posted December 13, 2005 (edited) most likely because of this: define('DIR_FS_DOCUMENT_ROOT', '/usr/local/apache/home/oscommerce.tagish.net/htdocs/'); // where the pages are located on the server should be as stated in the docs: define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT) your temp still needs to be /catalog/temp/ on another note, why are you using a subweb? you will get more responses from the main web (tagish) than you will oscommerce.tagish Edited December 13, 2005 by Mibble Quote Link to comment Share on other sites More sharing options...
mystifier_uk Posted December 13, 2005 Share Posted December 13, 2005 check your easypopulate.php file, see if it is set for semicolon delimited or tab delimited, needs to be tab delimited. I've done that and it seems to work - you've done it again Mibble! Now I am assuming that you just have to insert information into the columns of the empty fields and save it as a text file (delimited) when in Excel? Because when I do that and upload it again nothing happens! :blink: Quote Link to comment Share on other sites More sharing options...
ivax23 Posted December 13, 2005 Share Posted December 13, 2005 Hello, I just installed Easy Populate 2.76b and it works perfect! It's really usefull. But i have a problem, i've installated a stock contribution, all my stock depends on every size and some attributes. For example, i've a 42 size shoe with attribute x=2,y=3 and every one the same. I've installated in my data base a new field called products_stock that depends on product_stock_id, products_id, product_stock_attributes, products_stock_quantity (all primary keys). And i'd like being able to modify that trough easy populate. Anybpody knows the solution? Thanks, ivax23 Quote Link to comment Share on other sites More sharing options...
BenFremer Posted December 14, 2005 Share Posted December 14, 2005 Hi. I installed the Short Description contribution, and now I need easy populate to additionally populate the Short Description for each product. How do I do this? Thanks, Ben Quote Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2005 Share Posted December 14, 2005 you will have to fill in the information Quote Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2005 Share Posted December 14, 2005 most likely because of this:define('DIR_FS_DOCUMENT_ROOT', '/usr/local/apache/home/oscommerce.tagish.net/htdocs/'); // where the pages are located on the server should be as stated in the docs: define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT) your temp still needs to be /catalog/temp/ on another note, why are you using a subweb? you will get more responses from the main web (tagish) than you will oscommerce.tagish Is '/usr/local/apache/home/oscommerce.tagish.net/htdocs/' not the same as $DOCUMENT_ROOT? We are using a sub-domain as the site is a shared server, it houses many sites. In this case the oscommerce.tagish.net site is simply used as a test to get the site up and running. Eventually, however, the live site will also be on a sub-domain, so it needs to operate in this environment. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2005 Share Posted December 14, 2005 take a look at admin/tools/server info and search for document_root Quote Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2005 Share Posted December 14, 2005 take a look at admin/tools/server info and search for document_root John I've managed to get it working, it's importing everything into the products table just fine... Thanks for your help. It didn't mind having: /usr/local/apache/home/oscommerce.tagish.net/htdocs/ set instead of $DOCUMENT_ROOT, but it didn't like the full path to the temp directory. It started working once I set them back to /catalog/temp/. However, the next problem is that it isn't populating the products_description table. I've tracked the problem to around here (around line 1778): // the following is common in both the updating an existing product and creating a new product if ( isset($v_products_name)){ foreach( $v_products_name as $key => $name){ The condition for the if statement is met, but nothing seems to happen with the iteration of the array, and it drops straight back out of the if statement never running the code to populate the products_description table. has anyone come across this before? John Quote Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2005 Share Posted December 14, 2005 it will still hiccup down the road as you have an extra slash at the end. as i stated take a look at admin/tools/server info and search for document root, compate the path there with what you have. it is different. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2005 Share Posted December 14, 2005 it will still hiccup down the road as you have an extra slash at the end. as i stated take a look at admin/tools/server info and search for document root, compate the path there with what you have. it is different. DOCUMENT_ROOT=/usr/local/apache/home/oscommerce.tagish.net/htdocs I have now altered the 'DIR_FS_DOCUMENT_ROOT' in configure.php to reflect this. I can now update data to populate the products table, but it will not populate the products_description table. Quote Link to comment Share on other sites More sharing options...
laurelsstitchery Posted December 14, 2005 Share Posted December 14, 2005 I've finally uploaded all my items using Easy Populate. For some reason, the products_date_added is defaulting to 0000-00-00 00:00:00 instead of the correct date. How can I fix this? Quote Laurel Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2005 Share Posted December 14, 2005 what is your setting in your easypopulate file set to? 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.