Re: Issue of getting emails when new issue is created/assigned

This is a follow up the post below. I am trying to figure
out how make
it so all existing users will automatically receive emails
for any
projects they are added to. I have this working fine with
new users, but
can't seem to get it working for existing users. I tried the
SQL update
below (on just one user) and it didn't seem to work.  I am
hoping to
understand the serialized array a bit better so I can
understand what
kind of change is needed to alter a user to ensure that for
each project
they are added to, they have the "*Receive emails when
new issues are
assigned to you?*" option set to "yes" every
time. 

The change below did not seem to work with existing users
and existing
projects, nor with existing users and new projects.

Maybe I am missing something.

thanks,

-Brian

> Hemant Madaan wrote:
> > Hi Bryan,
> >
> > The problem is that we have created all our users
already. Is there any
> > script or any DB changes which we can do to the
settings for the existing
> > users in bulk. Look forward to your response.
>
> Those settings are stored in a serialized array in the
usr_preferences
> field of the eventum_user table. Here is a statement
that will update
> all users to have "yes" for those to
settings. It will also overwrite
> any other preferences they might have already set.

> UPDATE eventum_user SET usr_preferences =
>
'a:9:{s:19:"close_popup_windows";s:1:"0"
;s:23:"receive_assigned_emails";a:1:{i:1;s:1:"
;1";}s:18:"receive_new_emails";a:1:{i:1;s:1:&
quot;1";}s:8:"timezone";s:10:"Etc/GMT+12
";s:17:"list_refresh_rate";s:1:"5";
s:19:"emails_refresh_rate";s:1:"5";s:15:
"email_signature";s:0:"";s:15:"auto
_append_sig";N;s:20:"auto_append_note_sig";N;
}';

> Note: email clients may wrap the above statement, you
need to make sure
> it is all on one line.

> /bryan

The fix for this is on the wiki.

Barry


-----Original Message-----
From: Brian E. Bothwell [mailto:brian.bothwellwisdomtools.com] 
Sent: Thursday, May 10, 2007 7:09 PM
To: eventum-userslists.mysql.com
Subject: Re: Issue of getting emails when new issue is
created/assigned

This is a follow up the post below. I am trying to figure
out how make
it so all existing users will automatically receive emails
for any
projects they are added to. I have this working fine with
new users, but
can't seem to get it working for existing users. I tried the
SQL update
below (on just one user) and it didn't seem to work.  I am
hoping to
understand the serialized array a bit better so I can
understand what
kind of change is needed to alter a user to ensure that for
each project
they are added to, they have the "*Receive emails when
new issues are
assigned to you?*" option set to "yes" every
time. 

The change below did not seem to work with existing users
and existing
projects, nor with existing users and new projects.

Maybe I am missing something.

thanks,

-Brian

> Hemant Madaan wrote:
> > Hi Bryan,
> >
> > The problem is that we have created all our users
already. Is there
any
> > script or any DB changes which we can do to the
settings for the
existing
> > users in bulk. Look forward to your response.
>
> Those settings are stored in a serialized array in the
usr_preferences
> field of the eventum_user table. Here is a statement
that will update
> all users to have "yes" for those to
settings. It will also overwrite
> any other preferences they might have already set.

> UPDATE eventum_user SET usr_preferences =
>
'a:9:{s:19:"close_popup_windows";s:1:"0"
;s:23:"receive_assigned_emails";
a:1:{i:1;s:1:"1";}s:18:"receive_new_emails&qu
ot;;a:1:{i:1;s:1:"1";}s:8:"timez
one";s:10:"Etc/GMT+12";s:17:"list_refres
h_rate";s:1:"5";s:19:"emails_ref
resh_rate";s:1:"5";s:15:"email_signature
";s:0:"";s:15:"auto_append_sig";
N;s:20:"auto_append_note_sig";N;}';

> Note: email clients may wrap the above statement, you
need to make
sure
> it is all on one line.

> /bryan


--
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe:    http:
//lists.mysql.com/eventum-users?unsub=bondyahoo.com