loxly Posted February 13, 2003 Share Posted February 13, 2003 Got it!!! Thank you, thank you, thank you! Here's to another all nighter!!! :lol: Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
howardh Posted February 13, 2003 Share Posted February 13, 2003 Hi floridagal, Please email it to me at [email protected]. I really appreciate it :o Quote Link to comment Share on other sites More sharing options...
wasson65 Posted February 15, 2003 Author Share Posted February 15, 2003 Howard & Deborah, I've got my EasyPopulate running with those additional image fields. Would be glad to email you a copy or if anyone else needs it??? Thanks to Tim for such a fantastic contribution -- I can't even imagine trying to put in any sizeable number of products w/o EasyPopulate!! And of course, thanks to the developers for this awesome program, and to everyone in the forums - whenever I get stuck on something, I can always find the answer eventually, by just digging & digging through all the posts here.... - Nickie 8) (Glad I can finally do a tiny little *something* to help someone out! LOL!) Send it to me and I'll add it into the stock EasyPopulate. Thanks for sharing your work! Tim Quote Link to comment Share on other sites More sharing options...
loxly Posted February 15, 2003 Share Posted February 15, 2003 Hi Tim, You came up for air? :lol: Good to see you! I used this and it works great, it'll be great to see it added to the stock version. Someone mentioned they had added the fields for MoPics, but I forget who it was, maybe they could share with you too?? (Still haven't had time to do it myself.) Debbie Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
Erik Posted February 17, 2003 Share Posted February 17, 2003 Hi to everyone. i've uploaded and configured the 01/16/2003 - EasyPopulate_v2.41beta7 I need help, i've got this error: Warning: Cannot set time limit in safe mode in /usr/local/psa/home/vhosts/esco.csaelettronica.it/httpdocs/metodo/admin/easypopulate.php on line 165 Warning: Cannot send session cache limiter - headers already sent (output started at /usr/local/psa/home/vhosts/esco.csaelettronica.it/httpdocs/metodo/admin/easypopulate.php:165) in /usr/local/psa/home/vhosts/esco.csaelettronica.it/httpdocs/metodo/admin/includes/functions/sessions.php on line 67 Fatal error: Cannot redeclare tep_get_tax_class_title() in /usr/local/psa/home/vhosts/esco.csaelettronica.it/httpdocs/metodo/admin/easypopulate_functions.php on line 34 what's wrong ? Thanks for reading... Quote Link to comment Share on other sites More sharing options...
thejerk Posted February 17, 2003 Share Posted February 17, 2003 Hello, Anyone familiar with this message? Warning: Cannot set time limit in safe mode in /home/virtual/site271/fst/var/www/html/catalog/admin/easypopulate.php on line 165 Warning: Cannot send session cache limiter - headers already sent (output started at /home/virtual/site271/fst/var/www/html/catalog/admin/easypopulate.php:165) in /home/virtual/site271/fst/var/www/html/catalog/admin/includes/functions/sessions.php on line 67 Appreciate the input Txs :?: Quote Link to comment Share on other sites More sharing options...
floridagal Posted February 17, 2003 Share Posted February 17, 2003 Hi Tim, Sorry I missed your post before now -- file is on it's way to you! Thanks again for such an incredibly helpful tool!!! Quote Link to comment Share on other sites More sharing options...
vonbrocklin Posted February 25, 2003 Share Posted February 25, 2003 I have added two custom fields to my products table, and have modified Easy Populate to work with these changes. Everything seems to work fine, except that it tries to keep going even after adding the last line: No products_model field in record. This line was not imported Everything up until this works great, and all of my lines end in EOREOR, including the final line. Any ideas as to why my changes would cause this? Does the order of the fields in the spreadsheet (and in the update code) have any bearing on this? Any help appreciated, I'm going back to try and hack this out. Quote Link to comment Share on other sites More sharing options...
vesaire Posted February 25, 2003 Share Posted February 25, 2003 This line also appears in my site but creates no problem. By the way could you please the steps to customize easy populate for the new fields? Cheers Ugur Quote Link to comment Share on other sites More sharing options...
vonbrocklin Posted February 25, 2003 Share Posted February 25, 2003 I just followed the basic steps listed about 6 pages back, substituting my field names for the ones listed in this post: http://www.oscommerce.com/forums/viewtopic.php...pulate&start=40 Now I'm just wondering why the code isnt' stopping after hitting the last line. It does not seem to be causing trouble but I would like to get it working properly. Quote Link to comment Share on other sites More sharing options...
erodzen Posted February 25, 2003 Share Posted February 25, 2003 Froogle has made me modify my feed as per the following from their email. Does EasyPopulate need a slight adjustment in my setup somewhere or within the code? * Please take out the endline (return key) at the beginning of your feed and above your header. Here is what we're seeing: endl # html_escaped=YESendl # updates_only=NOendl # product_type=OTHERendl # quoted=YESendl Quote Who said computers are supposed to be FUN? Link to comment Share on other sites More sharing options...
alanpace Posted February 25, 2003 Share Posted February 25, 2003 vonbrocklin, your EasyPopulate is working properly. The error message you're getting is "normal". I always get the same one. Just pretend that it says, "Upload Complete!" Quote Alan Pace Link to comment Share on other sites More sharing options...
vonbrocklin Posted February 26, 2003 Share Posted February 26, 2003 vonbrocklin, your EasyPopulate is working properly. The error message you're getting is "normal". I always get the same one. Just pretend that it says, "Upload Complete!" Thanks - That thought occurred to me since I didn't really test EP more than once before I started adding my new fields. So I installed a second fresh copy on an unmodded version of OSC, and sure enough the same message. The UI Geek in me just keeps crying out for a more intuitive finish such as you "Upload Complete!" Good to know all of my modifications are actually working as intended though. Quote Link to comment Share on other sites More sharing options...
loxly Posted February 26, 2003 Share Posted February 26, 2003 I have added two custom fields to my products table, and have modified Easy Populate to work with these changes. Everything seems to work fine, except that it tries to keep going even after adding the last line: No products_model field in record. This line was not imported Everything up until this works great, and all of my lines end in EOREOR, including the final line. Any ideas as to why my changes would cause this? Does the order of the fields in the spreadsheet (and in the update code) have any bearing on this? Any help appreciated, I'm going back to try and hack this out. This has been happening since I started using the script. It doesn't really seem to be a problem, all products upload and I don't get any "empty" products or misconfigured ones. So my belief is "if it doesn't hurt anything, leave it alone" :) debbie Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
howardh Posted February 26, 2003 Share Posted February 26, 2003 Froogle replied to my first feed upload with the following: *Please remove the quotes from around all of your fields and set the'quoted' option to NO. The quoted field option is there for the user who want to use <tab>s and <enter>s in their description fields. Because each of these normally mean something to the data file reader (<tab> is the break between fields and <enter> is the break between products), they can't be used in writing a description. The 'quoted' field is there to allow the use of these special keys. Since you use no special keys in your description, there is no need to put quotes around your fields. So 2 questions... 1) I couldn't find an option to do this in the script, do I need to hack it myself. 2) Has anyone else received this error, and is it something you HAVE to correct? Should I just add a tab and/or <enter> in my descriptions? hehe. Thanks all. Quote Link to comment Share on other sites More sharing options...
loxly Posted February 27, 2003 Share Posted February 27, 2003 1) I think it probably happens to everyone 2)If it needed to be fixed we'd have heard by now :-) I think it is fine as is, Tim has been busy with a new contract and will get back to EP when he gets a minute to breathe. Debbie Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
jesse9201 Posted March 1, 2003 Share Posted March 1, 2003 Hello, I keep getting sql quotes errors when trying to add Quantity Controller 5.1 fields to Easy Populate 2.4. (can't seem to get those darn "'s working right) If someone has already added Quantity Controller to Easy Populate, could you pleazzzze help a 'brother' out by posting the code as it should appear on EP? Muchas Gracias/Thanks! :) P.S. I'm using a non MS1 OSC snapshot/dated Feb. 03 2004. Quote Link to comment Share on other sites More sharing options...
loxly Posted March 1, 2003 Share Posted March 1, 2003 Why would field names have 's in them??? Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
jesse9201 Posted March 1, 2003 Share Posted March 1, 2003 Why would field names have 's in them??? Thanks for your reply. The field names do not have 's in them. My problems as far as I can tell is that I have not properly set up Quantity Controller fields in all the places it needs to be added in Easy Populate. That's why (since I obviously do not know what I'm doing ;-) ) I'm asking for a "cheat", where I can just copy and paste the correct code onto EP. Quote Link to comment Share on other sites More sharing options...
loxly Posted March 1, 2003 Share Posted March 1, 2003 OK, your post was confusing. Find a field that is in the same table as the fields you have added. Do a "Find" for it in easypopulate.php. You should find about 4 places that you need to add your new fields. Debbie Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
loxly Posted March 1, 2003 Share Posted March 1, 2003 And if you get it working with the extra fields, please post here, or email Tim Wasson so he can add it to the code :) Debbie Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
jesse9201 Posted March 1, 2003 Share Posted March 1, 2003 Below are the 4 places where I tried to add the Quantity Controller new fields to Easy Populate.php. I then download a "Complete tab-delimited .txt file to edit" and try to upload 1 new product. This is the error I continue to get. DateAvail was --34.95--DateAdded was --1.00--1064 - You have an error in your SQL syntax near ')' at line 15 INSERT INTO categories( categories_id, categories_image, parent_id, sort_order, date_added, last_modified ) VALUES ( 133, '', 0, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ) I'm not a programmer, so if someone could please show me what the correct code should be by pasting it in this forum, then I'll just copy it to EP. Thanks. function ep_create_filelayout($dltype){ global $filelayout, $filelayout_count, $filelayout_sql, $langcode, $froogle_quotes, $fileheaders; // depending on the type of the download the user wanted, create a file layout for it. $froogle_quotes = false; // default to false, froogle file layout will set to true if needed. $fieldmap = array(); // default to no mapping to change internal field names to external. switch( $dltype ){ case 'full': // The file layout is dynamically made depending on the number of languages $iii = 0; $filelayout = array( 'v_products_model' => $iii++, 'v_products_image' => $iii++, ); foreach ($langcode as $key => $lang){ $l_id = $lang['id']; // uncomment the head_title, head_desc, and head_keywords to use // Linda's Header Tag Controller 2.0 //echo $langcode['id'] . $langcode['code']; $filelayout = tep_array_merge($filelayout , array( 'v_products_name_' . $l_id => $iii++, 'v_products_description_' . $l_id => $iii++, #'v_products_head_title_tag_'.$l_id => $iii++, #'v_products_head_desc_tag_'.$l_id => $iii++, #'v_products_head_keywords_tag_'.$l_id => $iii++, )); } // uncomment the customer_price and customer_group to support multi-price per product contrib $filelayout = tep_array_merge($filelayout , array( 'v_products_price' => $iii++, 'v_products_price_list' => $iii++, 'v_products_discount1' => $iii++, 'v_products_discount1_qty' => $iii++, 'v_products_weight' => $iii++, 'v_date_avail' => $iii++, 'v_date_added' => $iii++, 'v_products_quantity' => $iii++, 'v_products_quantity_order_min' => $iii++, 'v_products_quantity_order_units' => $iii++, #'v_customer_price_1' => $iii++, #'v_customer_group_id_1' => $iii++, #'v_customer_price_2' => $iii++, #'v_customer_group_id_2' => $iii++, #'v_customer_price_3' => $iii++, #'v_customer_group_id_3' => $iii++, #'v_customer_price_4' => $iii++, #'v_customer_group_id_4' => $iii++, 'v_manufacturers_name' => $iii++, 'v_categories_name_1' => $iii++, 'v_categories_name_2' => $iii++, 'v_categories_name_3' => $iii++, #'v_categories_name_4' => $iii++, #'v_categories_name_5' => $iii++, #'v_categories_name_6' => $iii++, #'v_categories_name_7' => $iii++, #'v_tax_class_title' => $iii++, 'v_status' => $iii++, )); $filelayout_sql = "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_price_list as v_products_price_list, p.products_discount1 as v_products_discount1, p.products_discount1_qty as v_products_discount1_qty, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, p.products_tax_class_id as v_tax_class_id, p.manufacturers_id as v_manufacturers_id, p.products_quantity as v_products_quantity, p.products_quantity_order_min as v_products_quantity_order_min, p.products_quantity_order_units as v_products_quantity_order_units, subc.categories_id as v_categories_id, p.products_status as v_status FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id "; break; case 'priceqty': $iii = 0; // uncomment the customer_price and customer_group to support multi-price per product contrib $filelayout = array( 'v_products_model' => $iii++, 'v_products_price' => $iii++, 'v_products_price_list' => $iii++, 'v_products_quantity' => $iii++, 'v_products_quantity_order_min' => $iii++, 'v_products_quantity_order_units' => $iii++, 'v_products_discount1' => $iii++, 'v_products_discount1_qty' => $iii++, #'v_customer_price_1' => $iii++, #'v_customer_group_id_1' => $iii++, #'v_customer_price_2' => $iii++, #'v_customer_group_id_2' => $iii++, #'v_customer_price_3' => $iii++, #'v_customer_group_id_3' => $iii++, #'v_customer_price_4' => $iii++, #'v_customer_group_id_4' => $iii++, ); $filelayout_sql = "SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_price as v_products_price, p.products_price_list as v_products_price_list, p.products_quantity as v_products_quantity, p.products_quantity_order_min as v_products_quantity_order_min, p.products_quantity_order_units as v_products_quantity_order_units, p.products_discount1 as v_products_discount1, p.products_discount1_qty as v_products_discount1_qty, FROM products as p "; break; // now do a query to get the record's current contents $sql = "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_price_list as v_products_price_list, 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.manufacturers_id as v_manufacturers_id, p.products_quantity_order_min as v_products_quantity_order_min, p.products_quantity_order_units as v_products_quantity_order_units, p.products_discount1 as v_products_discount1, p.products_discount1_qty as v_products_discount1_qty, 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 = '" . $items[$filelayout['v_products_model']] . "' AND ptoc.categories_id = subc.categories_id "; echo "<font color='green'> !New Product!</font><br>"; $query = 'INSERT INTO products ( products_image, products_model, products_price, products_price_list, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, products_quantity_order_min, products_quantity_order_units, products_discount1, products_discount1_qty, manufacturers_id) VALUES ("' . $v_products_image . '", "' . $v_products_model . '", "' . $v_products_price . '", "' . $v_products_price_list . '", ' . $v_status . ', CURRENT_TIMESTAMP, ' . $v_date_avail . ', "' . $v_tax_class_id . '", "' . $v_products_weight .'", "' . $v_products_quantity .'", "' . $v_products_quantity_order_min .'", "' . $v_products_quantity_order_units .'", "' . $v_products_discount1 .'", "' . $v_products_discount1_qty .'", ' . $v_manufacturers_id.')'; $result = tep_db_query($query); } else { // existing product, get the id from the query $query = 'UPDATE products SET products_price="'.$v_products_price. '" ,products_price_list="'.$v_products_price_list. '" ,products_image="'.$v_products_image. ' ,products_weight= ' . $v_products_weight. ' ,products_tax_class_id= ' . $v_tax_class_id. '" ,products_date_available= ' . $v_date_avail . ' ,products_date_added= ' . $v_date_added . ' ,products_last_modified=CURRENT_TIMESTAMP ,products_quantity="'.$v_products_quantity. '" ,products_quantity_order_min="'. $v_products_quantity_order_min . '" ,products_quantity_order_units="'. $v_products_quantity_order_units . '" ,products_discount1="'. $v_products_discount1 . '" ,products_discount1_qty="'. $v_products_discount1_qty . '" ,manufacturers_id='.$v_manufacturer_id. ' , products_status='.$v_db_status . ' WHERE (products_id = "'. $v_products_id . '")'; $result = tep_db_query($query); } Quote Link to comment Share on other sites More sharing options...
Ajeh Posted March 1, 2003 Share Posted March 1, 2003 I have not used easy populate, but note there are 4 discount sets per product so I think you need the others in there too ... not just products_discount1 and products_discount1_quantity Quote Link to comment Share on other sites More sharing options...
loxly Posted March 1, 2003 Share Posted March 1, 2003 It isn't that easy to add fields and if you do a search through this thread someone did a "tutorial" on how to add image fields. No one, to my knowledge, has added fields for the quantity controller. You also have to make sure the fields are set to the proper type. Please remember this is a user contributed addon and it does a basic job. It isn't made to handle every situation - yet..... :) The person that developed Easy Populate has work commitments and hasn't been able to add custom fields, but I am sure if he has a minute, or someone else that may know how to do this has aminute, they would be glad to point you in the right direction. Debbie Quote [no external urls in signatures please, kthanks] Link to comment Share on other sites More sharing options...
jesse9201 Posted March 1, 2003 Share Posted March 1, 2003 So am I better off uploading directly to the mysql "products" database than using Easy Populate? I have several thousand items for my store. Thanks again for trying to help - I really do appreciate it and don't feel like such a "dummy" for getting errors. 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.