surfalot Posted March 31, 2007 Share Posted March 31, 2007 (edited) Sorry Todd, it's been awhile since I looked into OSC code. I'm not sure what the problem is with my shop using Easy Populate When I had it at http://www.makepeace.org.au/shop/ - EP worked fine. My test store at http://www.makepeace.org.au/shop_dev/ - still works fine. Now that I've moved the live store to the root I can't upload my excel files to the shop (same file works fine in test store though) I changed the temp directory in admin/easypopulate.php to what it should be ('/temp/') But when I try and import the database Oscommerce is still looking for the temp files at /shop/temp/ How do I get it to see the new temp file? Here is a screenshot of my EP screen: Those bits should just say temp not shop/temp/ I'm not familiar with v2.75. what does your temp directory setting show in your easypopulate.php ? Edited March 31, 2007 by surfalot Quote Link to comment Share on other sites More sharing options...
surfalot Posted March 31, 2007 Share Posted March 31, 2007 thans for your reply surfalot, although it still doesnt work :blink: I realised that i actually have the structure 'public_html/' and then everything is in there. It says it is looking for 'home/discoun/public_html/' maybe this si why it is not working? is there a way to change this? i know nothing about programming, this is just something i spotted, what do you think? check with your host for the complete path to your web docs. Then set it to what they tell you in your configure.php. if that doesn't help set it to this in your admin/includes/configure.php: define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); beyond that, I need some versions to help further. EP vers? PHP vers? MySQL vers? PHP globals on/off ?? Quote Link to comment Share on other sites More sharing options...
Guest Posted March 31, 2007 Share Posted March 31, 2007 what country are you in? the problem is your excel is not using the comma for your CSV separator. go to your windows control panel. open regional and language options. click on customize. find list separator. this is what excel will use. you need to use that same character in your easypopulate.php. find this: if ($excel_safe_output == true) { $separator = ","; } change the $separator = "," to reflect what your windows is expecting for the separator. post 4939 for more info on this. I am in the US. Via control panel/language options/customize...The seperator was already set to ",".... easypopulate.php looks like this, as you can see I implemented the "fix" from the more info thread you recommended: This problem only happens when I insert that html into the product description column. Every time I save before upload I get: Ideas? -Dano Quote Link to comment Share on other sites More sharing options...
surfalot Posted March 31, 2007 Share Posted March 31, 2007 I am in the US. Via control panel/language options/customize...The seperator was already set to ",".... easypopulate.php looks like this, as you can see I implemented the "fix" from the more info thread you recommended: This problem only happens when I insert that html into the product description column. Ideas? -Dano if you are in the US, you don't need that fix and it would be better if you didn't use it. please post or pm me a link to the export file. I would like to see the export with your html in it. Quote Link to comment Share on other sites More sharing options...
Guest Posted April 1, 2007 Share Posted April 1, 2007 I'm not familiar with v2.75. what does your temp directory setting show in your easypopulate.php ? $tempdir = "/temp/"; $tempdir2 = "/temp/"; Quote Link to comment Share on other sites More sharing options...
Guest Posted April 1, 2007 Share Posted April 1, 2007 $tempdir = "/temp/";$tempdir2 = "/temp/"; and admin/includes/config // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://www.makepeace.org.au'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://www.makepeace.org.au'); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where the pages are located on the server define('DIR_WS_ADMIN', '/admin/'); // absolute path required define('DIR_FS_ADMIN', '/xxxxxxxxxxpublic_html/admin/'); // absolute pate required define('DIR_WS_CATALOG', ''); // absolute path required define('DIR_FS_CATALOG', '/xxxxxx/xxxxxxx/public_html/'); // absolute path required 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/'); Quote Link to comment Share on other sites More sharing options...
Guest Posted April 1, 2007 Share Posted April 1, 2007 further: this is my error: Warning: move_uploaded_file(/xxxxx/xxxx/xxxxxx/shop/temp/october2005faces.txt.xls) [function.move-uploaded-file]: failed to open stream: No such file or directory in //xxxxx/xxxx/xxxxxx/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '/tmp/phpqHhN4a' to '/xxxxx/xxxx/xxxxxx/shop/temp/october2005faces.txt.xls' in /xxxxx/xxxx/xxxxxx/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /tmp/phpqHhN4a User filename: october2005faces.txt.xls Size: 90773 Warning: file(/xxxxx/xxxx/xxxxxx/shop/temp/october2005faces.txt.xls) [function.file]: failed to open stream: No such file or directory in /xxxxx/xxxx/xxxxxx/admin/easypopulate.php on line 656 Warning: Invalid argument supplied for foreach() in /xxxxx/xxxx/xxxxxx/admin/easypopulate.php on line 679 Quote Link to comment Share on other sites More sharing options...
Guest Posted April 1, 2007 Share Posted April 1, 2007 Sorry to waste your time - looks like an issue with my server or my FTP program. Fixed now. Quote Link to comment Share on other sites More sharing options...
Dragos Posted April 2, 2007 Share Posted April 2, 2007 I just found another issue: When I try to "Upload and Import EP File", the screen refreshes, but I don't get anything. No error or success message. There is nothing in the database. Per the manual, I tried downloading a complete EP file and without even opening it, I tried to upload. Same results. It can't be a size issue, as there are only three products in the store right now. Any ideas? Hi, I got the same problem with Easy Populate 2.76 MS2. I switched from PHP 4 and MySQL 4 to PHP 5 and MySQL 5. Under previous configuation RasyPopulate worked fine. Now I can not import anything. I think it is related to PHP5. Did anybody solved this problem ? Quote Link to comment Share on other sites More sharing options...
surfalot Posted April 2, 2007 Share Posted April 2, 2007 Hi, I got the same problem with Easy Populate 2.76 MS2. I switched from PHP 4 and MySQL 4 to PHP 5 and MySQL 5. Under previous configuation RasyPopulate worked fine. Now I can not import anything. I think it is related to PHP5. Did anybody solved this problem ? more importantly is your PHP globals on/off? Is the php error reporting turned on? (ask your host) then look at this post about php 5. but that problem will still insert the first line, then quit. post 5554 might have more info for you to look at. Quote Link to comment Share on other sites More sharing options...
Orik Posted April 3, 2007 Share Posted April 3, 2007 (edited) Hello! I use EP for add new products in my store. Now i need second manufacturer, i make it - work fine, but what need to add it in EP? How i make (easypopulate.php) 'v_instock', 'v_tax_class_title', 'v_manufacturers_name', 'v_manufacturers_id', //after it i add 'v_manufacturers2_name', 'v_manufacturers2_id', $row['v_froogle_color'] = ''; $row['v_froogle_size'] = ''; $row['v_froogle_quantitylevel'] = ''; $row['v_froogle_manufacturer_id'] = ''; //after $row['v_froogle_manufacturer2_id'] = ''; // if the filelayout says we need a manufacturers name, get it if (isset($filelayout['v_manufacturers_name'])){ if ($row['v_manufacturers_id'] != ''){ $sql2 = "SELECT manufacturers_name FROM ".TABLE_MANUFACTURERS." WHERE manufacturers_id = " . $row['v_manufacturers_id'] ; $result2 = tep_db_query($sql2); $row2 = tep_db_fetch_array($result2); $row['v_manufacturers_name'] = $row2['manufacturers_name']; } } //after // if the filelayout says we need a manufacturers name, get it if (isset($filelayout['v_manufacturers2_name'])){ if ($row['v_manufacturers2_id'] != ''){ $sql2 = "SELECT manufacturers2_name FROM ".TABLE_MANUFACTURERS2." WHERE manufacturers2_id = " . $row['v_manufacturers2_id'] ; $result2 = tep_db_query($sql2); $row2 = tep_db_fetch_array($result2); $row['v_manufacturers2_name'] = $row2['manufacturers2_name']; } } $header_array['v_manufacturers_name'] = $iii++; //after $header_array['v_manufacturers2_name'] = $iii++; p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, //after p.manufacturers2_id as v_manufacturers2_id, 'v_froogle_instock' => $iii++, 'v_froogle_ shipping' => $iii++, 'v_manufacturers_name' => $iii++, //after 'v_manufacturers2_name' => $iii++, 'v_froogle_manufacturer_id' => $iii++, //after 'v_froogle_manufacturer_id' => $iii++, 'size' => $iii++, 'quantity' => $iii++, 'product_id' => $iii++, 'manufacturer_id' => $iii++, //after 'manufacturer2_id' => $iii++, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, //after p.manufacturers2_id as v_manufacturers2_id, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, //after p.manufacturers2_id as v_manufacturers2_id, // temprow has the old style low to high level categories. $newlevel = 1; // let's turn them into high to low level categories for( $categorylevel=EP_MAX_CAT+1; $categorylevel>0; $categorylevel--){ if ($temprow['v_categories_name_' . $categorylevel] != ''){ $row['v_categories_name_' . $newlevel++] = $temprow['v_categories_name_' . $categorylevel]; } } if ($row['v_manufacturers_id'] != ''){ $sql2 = "SELECT manufacturers_name FROM ".TABLE_MANUFACTURERS." WHERE manufacturers_id = " . $row['v_manufacturers_id'] ; $result2 = tep_db_query($sql2); $row2 = tep_db_fetch_array($result2); $row['v_manufacturers_name'] = $row2['manufacturers_name']; } //after // temprow has the old style low to high level categories. // let's turn them into high to low level categories for( $categorylevel=EP_MAX_CAT+1; $categorylevel>0; $categorylevel--){ if ($temprow['v_categories_name_' . $categorylevel] != ''){ $row['v_categories_name_' . $newlevel++] = $temprow['v_categories_name_' . $categorylevel]; } } if ($row['v_manufacturers2_id'] != ''){ $sql2 = "SELECT manufacturers2_name FROM ".TABLE_MANUFACTURERS2." WHERE manufacturers2_id = " . $row['v_manufacturers2_id'] ; $result2 = tep_db_query($sql2); $row2 = tep_db_fetch_array($result2); $row['v_manufacturers2_name'] = $row2['manufacturers2_name']; } if ($v_manufacturer_id==''){ $v_manufacturer_id="NULL"; } //after if ($v_manufacturer2_id==''){ $v_manufacturer2_id="NULL"; } // OK, we need to convert the manufacturer's name into id's for the database if ( isset($v_manufacturers_name) && $v_manufacturers_name != '' ){ $sql = "SELECT man.manufacturers_id FROM ".TABLE_MANUFACTURERS." as man WHERE man.manufacturers_name = '" . $v_manufacturers_name . "'"; $result = tep_db_query($sql); $row = tep_db_fetch_array($result); if ( $row != '' ){ foreach( $row as $item ){ $v_manufacturer_id = $item; } } else { // to add, we need to put stuff in categories and categories_description $sql = "SELECT MAX( manufacturers_id) max FROM ".TABLE_MANUFACTURERS; $result = tep_db_query($sql); $row = tep_db_fetch_array($result); $max_mfg_id = $row['max']+1; // default the id if there are no manufacturers yet if (!is_numeric($max_mfg_id) ){ $max_mfg_id=1; } // Uncomment this query if you have an older 2.2 codebase /* $sql = "INSERT INTO ".TABLE_MANUFACTURERS."(manufacturers_id, manufacturers_name, manufacturers_image) VALUES ('".$max_mfg_id."','".$v_manufacturers_name."','".EP_MANF_IMAGE."')"; */ // Comment this query out if you have an older 2.2 codebase $sql = "INSERT INTO ".TABLE_MANUFACTURERS."(manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified) VALUES ('" . $max_mfg_id . "', '" . $v_manufacturers_name . "','" . EP_MANF_IMAGE . "', " . CURRENT_TIMESTAMP . "," . CURRENT_TIMESTAMP . ")"; $result = tep_db_query($sql); $v_manufacturer_id = $max_mfg_id; } } //after // OK, we need to convert the manufacturer's name into id's for the database if ( isset($v_manufacturers2_name) && $v_manufacturers2_name != '' ){ $sql = "SELECT man.manufacturers2_id FROM ".TABLE_MANUFACTURERS2." as man WHERE man.manufacturers2_name = '" . $v_manufacturers2_name . "'"; $result = tep_db_query($sql); $row = tep_db_fetch_array($result); if ( $row != '' ){ foreach( $row as $item ){ $v_manufacturer2_id = $item; } } else { // to add, we need to put stuff in categories and categories_description $sql = "SELECT MAX( manufacturers2_id) max FROM ".TABLE_MANUFACTURERS2; $result = tep_db_query($sql); $row = tep_db_fetch_array($result); $max_mfg_id = $row['max']+1; // default the id if there are no manufacturers yet if (!is_numeric($max_mfg_id) ){ $max_mfg_id=1; } // Uncomment this query if you have an older 2.2 codebase /* $sql = "INSERT INTO ".TABLE_MANUFACTURERS."(manufacturers_id, manufacturers_name, manufacturers_image) VALUES ('".$max_mfg_id."','".$v_manufacturers_name."','".EP_MANF_IMAGE."')"; */ // Comment this query out if you have an older 2.2 codebase $sql = "INSERT INTO ".TABLE_MANUFACTURERS2."(manufacturers2_id, manufacturers2_name, manufacturers2_image, date_added, last_modified) VALUES ('" . $max_mfg_id . "', '" . $v_manufacturers2_name . "','" . EP_MANF_IMAGE . "', " . CURRENT_TIMESTAMP . "," . CURRENT_TIMESTAMP . ")"; $result = tep_db_query($sql); $v_manufacturer2_id = $max_mfg_id; } } products_weight, products_quantity, manufacturers_id, //after manufacturers2_id '$v_products_weight', '$v_products_quantity', '$v_manufacturer_id', //after '$v_manufacturer2_id' ', products_last_modified=CURRENT_TIMESTAMP , products_quantity="' . $v_products_quantity . '" ,manufacturers_id=' . $v_manufacturer_id . //after '" ,manufacturers2_id=' . $v_manufacturer2_id . in export xls i see new column - v_manufacturers2_name and i see allright manufacturers2 in his products, but if i change manufacturer2 and make upload and insert this file i have error - File uploaded. Temporary filename: /home/u50422/aquast.ru/tmp/php3qTlTD User filename: EP2007Apr03-140255.xls Size: 40064 | ванна MIAN | editorPics | | ванна MIAN | Описание т | | | | 2320 | 8.00 | | 0000-00-00 | 421 | 1 | Цвет | 14 | | Хром | 15 | | Серебро | 16 | | Золото | 17 | | хром/золот | 2 | | | 55 | Ванны | Прямоуголь | | | | | | --нет-- | Active Updated 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '" ,manufacturers2_id=13 , products_status=1 ' at line 4 UPDATE products SET products_price="2320" ,products_image="editorPics/img42ca6b6ced90d.jpg" ,products_subimage1="" ,products_subimage2="" ,products_subimage3="" ,products_subimage4="" ,products_subimage5="" ,products_subimage6="", products_weight="8.00", products_tax_class_id="", products_date_available= NULL, products_date_added= "0000-00-00 00:00:00", products_last_modified=CURRENT_TIMESTAMP , products_quantity="421" ,manufacturers_id=NULL" ,manufacturers2_id=13 , products_status=1 WHERE (products_id = "282") [TEP STOP] PLEASE HELP! Edited April 3, 2007 by Orik Quote Link to comment Share on other sites More sharing options...
Orik Posted April 3, 2007 Share Posted April 3, 2007 (edited) ups double Edited April 3, 2007 by Orik Quote Link to comment Share on other sites More sharing options...
Benjjj6 Posted April 3, 2007 Share Posted April 3, 2007 thankyou surfalot, everything is almost working now. i changed define('DIR_FS_DOCUMENT_ROOT', 'public_html/'); to define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT ); and I added a '/' before 'temp/' in easypopulate.php I can now download files and edit them fine although i tried to upload a file and insert it into the db and i got this: File uploaded.Temporary filename: /tmp/phpSaBan1 User filename: EP2007Apr03-1705.txt Size: 531343 | capcom_cla | Capcom Cla | Brand new, | | 26.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product! | burnout_le | Burnout Le | Brand new, | | 19.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product! | sudoku.gif | Go Sudoku | Brand new, | | 15.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product! | gradius.gi | Gradius Co | Brand new, | | 26.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product! | gripshift. | Gripshift | GripShift | | 16.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product! | goblet.gif | Harry Pott | Brand new, | | 17.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product! | king_kong. | Peter Jack | Brand new, | | 19.99 | 0.00 | | 2006-11-22 | 0 | Sony | Gaming | PSP Games | | --none-- | Inactive | !New Product! 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's King Kong PSP', 'king_kong.gif', '0', '1', CURRE' at line 14 INSERT INTO products ( products_image, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'Peter Jackson's King Kong PSP', 'king_kong.gif', '0', '1', CURRENT_TIMESTAMP, "0", "2006-11-22 22:33:01", '', '', 'Sony', '454') What is wrong with the SQL syntax? also, just a general question: If I upload a EP file containing products that are already in my store would they be added twice, or just ignored? And, when I upload an EP file do I need to include products that are already active in my store or can I just upload a spreadsheet with all the products i want to add to my store? Quote Link to comment Share on other sites More sharing options...
surfalot Posted April 3, 2007 Share Posted April 3, 2007 thankyou surfalot, everything is almost working now. i changed define('DIR_FS_DOCUMENT_ROOT', 'public_html/'); to define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT ); and I added a '/' before 'temp/' in easypopulate.php I can now download files and edit them fine although i tried to upload a file and insert it into the db and i got this: What is wrong with the SQL syntax? also, just a general question: If I upload a EP file containing products that are already in my store would they be added twice, or just ignored? And, when I upload an EP file do I need to include products that are already active in my store or can I just upload a spreadsheet with all the products i want to add to my store? the problem is the single qoute in your data. you should try the excel safe option. the download will then be comma separated (for the US (maybe all english countries)), and quoted values and the file extension will change to .CSV. You can open in excel and save back to the same CSV to import (or save as... DOS CSV file type). Looks like your first column is an image. EP requires all products have a unique model number (per the directions). That is how imported products are matched with existing products for an update. If no matching model number is found, a new product is created. you can import any portion of your inventory, new products or updated products. Quote Link to comment Share on other sites More sharing options...
Benjjj6 Posted April 3, 2007 Share Posted April 3, 2007 okay, ive turned the excel safe option on. When i download a .csv file to edit like you say none of my products have unique model numbers. Im worried that if i now download a .csv file and give each product a unique number and then re-upload the file it will create doubles of every product because it will see each product as different to the ones already in my store (without a unique num.) sorry if that didnt make sense :/ do you understand what im saying? Quote Link to comment Share on other sites More sharing options...
surfalot Posted April 3, 2007 Share Posted April 3, 2007 okay, ive turned the excel safe option on. When i download a .csv file to edit like you say none of my products have unique model numbers. Im worried that if i now download a .csv file and give each product a unique number and then re-upload the file it will create doubles of every product because it will see each product as different to the ones already in my store (without a unique num.) sorry if that didnt make sense :/ do you understand what im saying? yes, if you have all the product entered in the shop now without model numbers, then upload all of them with new model numbers, you will have duplicate products. if you have the complete product list downloaded with easy populate, you can try this. ***************************************** First, backup your database using something like phpMyAdmin or the osC backup just in case. ***************************************** then you can clear all your products by running the following script in phpMyAdmin. then you can import your products with model numbers using easy populate. DELETE FROM `products`; DELETE FROM `products_attributes`; DELETE FROM `products_attributes_download`; DELETE FROM `products_description`; DELETE FROM `products_notifications`; DELETE FROM `products_options`; DELETE FROM `products_options_values`; DELETE FROM `products_options_values_to_products_options`; DELETE FROM `products_to_categories`; ALTER TABLE `products` AUTO_INCREMENT = 1; ALTER TABLE `products_attributes` AUTO_INCREMENT = 1; ALTER TABLE `products_description` AUTO_INCREMENT = 1; ALTER TABLE `products_options_values_to_products_options` AUTO_INCREMENT = 1; there is a more complete script available if you need orders, manufacturer, customers, etc. cleaned up. if you have any problems with this you can restore the backup and try something else. Quote Link to comment Share on other sites More sharing options...
Benjjj6 Posted April 3, 2007 Share Posted April 3, 2007 okay then, it looks like i will go ahead with what you are suggesting (and I do want to keep orders, customers etc.) I just want to make sure of a few things first: EP can handle HTML descriptions ok without any problems right? How do I enable product attributes with EP? they are currently set to 'false' so when i download a file they are not included, obviously deleting them would loose them as they are not in my EP file. How do I reduce the Category depth to 2 instead of 3? and when I go to EP in the Admin section of my site even though Excel Safe Output is set to true it says 'Field seperator: comma' will my descriptions interfer with this? or does Excel safe output stop that from happening? thankyou, youve been ssoooooooooo helpful so far, I thought I would never get Ep to work :) Quote Link to comment Share on other sites More sharing options...
nicholaszen Posted April 4, 2007 Share Posted April 4, 2007 Hi, I've a problem downloading all the attributes, for example if I've the following attributes: - size - color - type - extra - other In the $attributes_options_select I've filled in all the above attributes: size, color, type, extra, other But for some reason I can only download the 'size' attribute and all other attributes doesn't download.. I want to download this so I can make a default file, which I can easily update.. Is there something I'm doing wrong or forgot to do.. because I really can't get it working.. Hope someone could help me out.. BTW I'm using Easy Populate 2.76d Quote Link to comment Share on other sites More sharing options...
Guest Posted April 4, 2007 Share Posted April 4, 2007 how many columns are you currently downloading? have you made changes to the EP code? Quote Link to comment Share on other sites More sharing options...
surfalot Posted April 4, 2007 Share Posted April 4, 2007 EP can handle HTML descriptions ok without any problems right? yes. there has been a bug reported for php vers 4.3.4+ and early versions of php 5. if the your data field starts with a double quote, it's not handled correctly. there is a fix for that. How do I enable product attributes with EP? they are currently set to 'false' so when i download a file they are not included, obviously deleting them would loose them as they are not in my EP file. set that to true and it should work. How do I reduce the Category depth to 2 instead of 3? check the settings in easypopulate.php. and when I go to EP in the Admin section of my site even though Excel Safe Output is set to true it says 'Field seperator: comma' will my descriptions interfer with this? or does Excel safe output stop that from happening? that's OK. true CSV format (which is what I was trying to accomplish) quotes all the fields so commas in the field should not hurt anything. Asside from the issue mentioned above, all special characters should be handled correctly. Quote Link to comment Share on other sites More sharing options...
surfalot Posted April 4, 2007 Share Posted April 4, 2007 Hi, I've a problem downloading all the attributes, for example if I've the following attributes: - size - color - type - extra - other In the $attributes_options_select I've filled in all the above attributes: size, color, type, extra, other But for some reason I can only download the 'size' attribute and all other attributes doesn't download.. I want to download this so I can make a default file, which I can easily update.. Is there something I'm doing wrong or forgot to do.. because I really can't get it working.. Hope someone could help me out.. BTW I'm using Easy Populate 2.76d so you've set this: $attribute_options_select = array('size', 'color','type','extra','other'); and those are exactly the same names as in the database (case sensitive) I just looked at the code and ran a test with 2.76d and all seems to be OK. I don't see any php or mysql versions issues in that code. Quote Link to comment Share on other sites More sharing options...
nicholaszen Posted April 5, 2007 Share Posted April 5, 2007 Hi Todd, I've put the exact names in the configuration admin interface (created with the files of Tone).. or do you think I need to hard code it, like in your example above.. ? I will try that.. maybe that would work better.. Quote Link to comment Share on other sites More sharing options...
nicholaszen Posted April 5, 2007 Share Posted April 5, 2007 Just tried to do it hard code.. but also doesn't work.. really don't know what to do.. or what I'm doing wrong.. Quote Link to comment Share on other sites More sharing options...
surfalot Posted April 5, 2007 Share Posted April 5, 2007 Just tried to do it hard code.. but also doesn't work.. really don't know what to do.. or what I'm doing wrong.. if you don't have php globals problems, you may consider trying the version I uploaded. There is some confusion about what v2.76d is since the other uploaders didn't give their work a unique version number. all the settings are in the easypopulate file not the admin. Quote Link to comment Share on other sites More sharing options...
Benjjj6 Posted April 5, 2007 Share Posted April 5, 2007 yes. there has been a bug reported for php vers 4.3.4+ and early versions of php 5. if the your data field starts with a double quote, it's not handled correctly. there is a fix for that.set that to true and it should work. check the settings in easypopulate.php. that's OK. true CSV format (which is what I was trying to accomplish) quotes all the fields so commas in the field should not hurt anything. Asside from the issue mentioned above, all special characters should be handled correctly. thankyou surfalot, it worked great ! :D 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.