Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

EasyPopulate 2.4, now with Froogle support!


wasson65

Recommended Posts

  • Replies 285
  • Created
  • Last Reply

Top Posters In This Topic

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

Link to comment
Share on other sites

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

[no external urls in signatures please, kthanks]

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

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 :?:

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Who said computers are supposed to be FUN?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

[no external urls in signatures please, kthanks]

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

[no external urls in signatures please, kthanks]

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

[no external urls in signatures please, kthanks]

Link to comment
Share on other sites

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

[no external urls in signatures please, kthanks]

Link to comment
Share on other sites

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);

 }

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

[no external urls in signatures please, kthanks]

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...