Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

EasyPopulate MODIF Question


DicE

Recommended Posts

I would like to change Easypopulate 2.60 so it doesn't touch my descriptions anymore. This is because they get totaly messed up when I upload them again + when you export the excel file back to tab-delimited text file, you must make sure that the complete field of "description" is visible!

 

If you don't do that, the part that was still hidden does not get exported. That and the way EP handles special characters like " and ' ... In short, that bugs me :)

 

I already made changes so I can now export to a text file that doesn't include the description, but when I upload it again, it keeps blanking out my descriptions again. So somewhere in the import routine, something's going wrong...

 

could someone give me some pointers as to where I should look for this?

 

This is the modified export part:

is this ok like that?

 

case 'priceqty':  // CHANGE TO REFLECT THINQ NEEDS

 $iii = 0;

 // 

 $filelayout = array(

	 'v_products_model'  => $iii++,

	 'v_products_image'  => $iii++,  

   );

   

 foreach ($langcode as $key => $lang){

	 $l_id = $lang['id'];

	 $filelayout  = tep_array_merge($filelayout , array(

  	 'v_products_name_' . $l_id  => $iii++,

  	 'v_products_head_title_tag_'.$l_id	=> $iii++,

  	 ));

 }

 

 $filelayout  = tep_array_merge($filelayout , array(

	 'v_products_price'  => $iii++,

	 'v_date_avail' 	 => $iii++,

	 'v_manufacturers_name'  => $iii++,

	 'v_tax_class_title'  => $iii++,

	 'v_status' 	 => $iii++,

	 ));

 

 // build the categories name section of the array based on the number of categores the user wants to have

 for($i=1;$i<$max_categories+1;$i++){

	 $filelayout = tep_array_merge($filelayout, array('v_categories_name_' . $i => $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_date_available as v_date_avail,

	 p.manufacturers_id as v_manufacturers_id,

	 p.products_tax_class_id as v_tax_class_id,

	 p.products_status as v_status,

	 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

	 ptoc.categories_id = subc.categories_id

	 ";



 break;

 

I always thought that EP made it's upload scalable according to the headingline (first line of your text file containing the "v_description_" blablabla etc... but I don't have the description, and it still overwrites my description field in the DB...

 

Any suggestions?

 

Thanks a Lot!!!!!

 

Maarten

_____.:::.________###__________|/______

:(o o): . (o o) (o o)

ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo-

Link to comment
Share on other sites

is there nobody who can help me with this?

 

I'm not asking that much. Just a few hints where to look...

I've read about plenty of people who modified EP for there needs. Can't be that there is nobody who can answer this for me...

 

thank you very much!

_____.:::.________###__________|/______

:(o o): . (o o) (o o)

ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo-

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