Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Populate + Big Images = Can't get it to work.


ripthesystem

Recommended Posts

I've scoured the forums, read every post I could find with a search relating to this and I know that I'm not the only one to have had this problem. However solutions seem only partially available and I've tried everything my limited PHP knowledge will let me and I still can't get Easy Populate to work correctly with the Big Images Contrib.

 

Here's the specifics:

Easy Populate 2.74 MS2 contribution (link)

Big Images 1.25 - 2.2MS2 contrib (link)

 

 

I have Easy Populate and Big Images both installed and working on their own, the problem is that when you add a column to your import file for v_products_bimage, the address doesn't actually get imported into the DB, even though EP doesn't throw back an error.

 

My understanding (from the EP manual) is that to get this to work you would only have to uncomment the correct lines in the easypopulate.php. However if you do this you will only get white screens and errors as it seems the commented code is out of date with current releases(?)

 

So I dug through the code and these are the changes that I made:

 

Near line 201, find

	#'v_products_mimage',
#'v_products_bimage',

Change to

	#'v_products_mimage',
'v_products_bimage',

 

Near line 908, find

  $filelayout = array(
	 'v_products_model'  => $iii++,
	 'v_products_image'  => $iii++,
	 );

Change to

  $filelayout = array(
	 'v_products_model'  => $iii++,
	 'v_products_image'  => $iii++,
	 'v_products_bimage'  => $iii++,
	 );

 

 

Near line 999, find

 	 p.products_model as v_products_model,
	 p.products_image as v_products_image,
	 p.products_price as v_products_price,

Change to

 	 p.products_model as v_products_model,
	 p.products_image as v_products_image,
	 p.products_bimage as v_products_bimage,
	 p.products_price as v_products_price,

 

 

 

Near line 1140, find

 	 p.products_model as v_products_model,
	 p.products_image as v_products_image,
	 p.products_price as v_products_price,

Change to

 	 p.products_model as v_products_model,
	 p.products_image as v_products_image,
	 p.products_bimage as v_products_bimage,
	 p.products_price as v_products_price,

 

 

Near line 1298, find

  p.products_model as v_products_model,
 p.products_image as v_products_image,
 p.products_price as v_products_price,

Change to

  p.products_model as v_products_model,
 p.products_image as v_products_image,
 p.products_bimage as v_products_bimage,
 p.products_price as v_products_price,

 

 

Near line 1679, find

 	 $query = "INSERT INTO ".TABLE_PRODUCTS." (
  	 products_image,
  	 products_model,
  	 products_price,

Change to

 	 $query = "INSERT INTO ".TABLE_PRODUCTS." (
  	 products_image,
  	 products_bimage,
  	 products_model,
  	 products_price,

 

Near line 1690, find

 	 // unmcomment these lines if you are running the image mods
	 /*
   $query .=  . $v_products_mimage . '", "'
    	 . $v_products_bimage . '", "'
    	 . $v_products_subimage1 . '", "'
    	 . $v_products_bsubimage1 . '", "'
    	 . $v_products_subimage2 . '", "'
    	 . $v_products_bsubimage2 . '", "'
    	 . $v_products_subimage3 . '", "'
    	 . $v_products_bsubimage3 . '", "'
	 */

Change to

 	 // unmcomment these lines if you are running the image mods
      $query .=               "'$v_products_bimage',"; 

//                               '$v_products_mimage',";

//                              . $v_products_subimage1 . '", "'

//                              . $v_products_bsubimage1 . '", "'

//                              . $v_products_subimage2 . '", "'

//                              . $v_products_bsubimage2 . '", "'

//                              . $v_products_subimage3 . '", "'

//                              . $v_products_bsubimage3 . '", "'

 

 

 

Near line 1726, find

 	 // uncomment these lines if you are running the image mods
/*
   $query .=
  	 '" ,products_mimage="'.$v_products_mimage.
  	 '" ,products_bimage="'.$v_products_bimage.
  	 '" ,products_subimage1="'.$v_products_subimage1.
  	 '" ,products_bsubimage1="'.$v_products_bsubimage1.
  	 '" ,products_subimage2="'.$v_products_subimage2.
  	 '" ,products_bsubimage2="'.$v_products_bsubimage2.
  	 '" ,products_subimage3="'.$v_products_subimage3.
  	 '" ,products_bsubimage3="'.$v_products_bsubimage3;
*/

Change to

// uncomment these lines if you are running the image mods



      $query .=

              '" ,products_bimage="'.$v_products_bimage;

/*               '" ,products_mimage="'.$v_products_mimage.

             '" ,products_subimage1="'.$v_products_subimage1.

              '" ,products_bsubimage1="'.$v_products_bsubimage1.

              '" ,products_subimage2="'.$v_products_subimage2.

              '" ,products_bsubimage2="'.$v_products_bsubimage2.

              '" ,products_subimage3="'.$v_products_subimage3.

              '" ,products_bsubimage3="'.$v_products_bsubimage3;

*/

 

If you want to download my easypopulate.php file to see all the changes I made above, CLICK HERE.

 

 

 

---

 

So now I've made all the above changes and I have added a column on my Import file like this:

 

v_products_image | v_products_bimage | v_products_name_1

 

Easy Populate runs, gives no errors, puts the product in the store appropriately, etc. BUT STILL DOESN'T show any location for bimage. The fields in the database (products_bimage) are blank. Not Null. Not the wrong image... blank... empty

 

 

What am I doing wrong?

 

Help please?!

Link to comment
Share on other sites

I keep banging my head against the wall here as I also tried changing my above post so that lines 1695-1715 read like:

 	 // unmcomment these lines if you are running the image mods
//       $query .=               "'$v_products_bimage',"; 

//                               '$v_products_mimage',";

//                              . $v_products_subimage1 . '", "'

//                              . $v_products_bsubimage1 . '", "'

//                              . $v_products_subimage2 . '", "'

//                              . $v_products_bsubimage2 . '", "'

//                              . $v_products_subimage3 . '", "'

//                              . $v_products_bsubimage3 . '", "'

	 $query .="'$v_products_bimage',
        '$v_products_model',
       '$v_products_price',
       '$v_db_status',

 

and lines 1737-1762 read like:

// uncomment these lines if you are running the image mods
/*


      $query .=

              '" ,products_bimage="'.$v_products_bimage;

              '" ,products_mimage="'.$v_products_mimage.

             '" ,products_subimage1="'.$v_products_subimage1.

              '" ,products_bsubimage1="'.$v_products_bsubimage1.

              '" ,products_subimage2="'.$v_products_subimage2.

              '" ,products_bsubimage2="'.$v_products_bsubimage2.

              '" ,products_subimage3="'.$v_products_subimage3.

              '" ,products_bsubimage3="'.$v_products_bsubimage3;

*/

	 $query .= '", products_bimage="'.$v_products_bimage .
      '", products_weight="'.$v_products_weight .

 

And that didn't do anything differently at all.

 

Ideas? Suggestions?

Many thanks in advance!!

Link to comment
Share on other sites

Alright, well I tried several other changes last night (just shots in the dark really) and none of them worked but did get EP to give me some errors! :D

 

So let me just ignore all of that and all of my attempts to get this to work and ask the question:

 

Has anyone gotten these 2 contributions to work together?

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