Bulk Set Initial Pref's

[cpscdave]

Hi,
I'd like to Bulk load some user preferences, and I know I can do it with User::setPreference

However how do I figure out what the name/val should be. I've been able to make the change and see the fields changing in the DB but of course everything is obsificated. I suppose I could just copy the DB row to other users but thats not all that elegant.

Any insight into how to figure this out would be great.

Specifically I need to set

Pipeline Dashlet -> Show specific stages
Oppertunity Dashlet -> Show Client File Name

[eggsurplus]

Hey cpscdave,

How about just doing a log dump inside of setPreferences and saving preferences for a User to see what goes through?

function setPreference($name, $value, $nosession = 0, $category = 'global', $user = null) {
$GLOBALS['log']->fatal("user id: $user->id category: $category name: $name value: $value ");

[cpscdave]

this gets filed under "DOH! Why didnt I think of that"

Thanks again egg! This will get me the info I need to do what I need!

[cpscdave]

Hmmm cant seem to get this to work.

I outputed all the jazz and got the values of

dashlets, array, 0,, home

so I outputed the array to a file and wrote this

 <?php
 
require_once('modules/Users/User.php');
global $db;
 
$results = $db->query("SELECT id FROM users WHERE deleted = 0 and last_name = 'Robertson'");
 
 
while($row = $db->fetchByAssoc($results))
 {
   $focus = new User();
   $focus->retrieve($row['id']);
   $dashletVal = getDashletVal();
   print_r($dashletVal);
   $focus->setPreference('dashlets', $dashletVal,false,'home',$focus);
   $focus->savePreferecesToDB();
 }
 
 
 
 
function getDashletVal()
{
 
  $file = "/var/www/html/crm/initialSetting/pipeline_pref.txt";
  $fp = fopen($file, "r");
  $content = fread($fp, filesize($file));
  $val = unserialize($content);
  //  print_r($val);
  return $val;
 
 
 
}
 
?>  

as far as I Can tell its pumping in the same items but its not updating the pregs.... grrrr

[eggsurplus]

You can print the values of the array to the screen using print_r() or you can append it to a string using a function like the following:

  
function debug_print_r($data)
{
    ob_start();
    print_r($data);
    $result = ob_get_contents();
    ob_end_clean();
    return $result;
} 
  

Usage like echo "my array values are: ".debug_print_r($myarray);

[cpscdave]

Yep did that, and they look correct to me.

What I think is happening is the value array has the format of
[SOME_ID] => array

I'm wondering if that ID is unique somehow and thats what's preventing the update from working.

[eggsurplus]

Oh sure, that's probably the id from the dashboards table. This may be where the preferences for items just as the Home page dashlets are kept. It for sure stores it for the Dashboard tab here. There's a column called "name" though that is set to Home in my db making me guess that it's for the Home page. Any ideas?

[SugarDev.net]

You can print the values of the array to the screen using print_r() or you can append it to a string using a function like the following:

  
function debug_print_r($data)
{
    ob_start();
    print_r($data);
    $result = ob_get_contents();
    ob_end_clean();
    return $result;
} 
  

Usage like echo "my array values are: ".debug_print_r($myarray);

Simpler would be

 echo print_r($myarray, true); 
  

[eggsurplus]

Thanks SugarDev! Must be new in PHP 5.0?