dhis2-devs team mailing list archive

[Ant Snyman <ant@xxxxxxxx>]

Hi Jason, thanks for your response. This is what I used:

insert into usersetting
values
(21527, 'keyMessageEmailNotification',
'\254\355\000\005sr\000\021java.lang.Boolean\315
r\200\325\234\372\356\002\000\001Z\000\005valuexp\000')

Interesting point about the "001"and "000". Will investigate that a bit
further also.

Regards

Ant


On 27 October 2015 at 09:23, Jason Pickering <jason.p.pickering@xxxxxxxxx>
wrote:

> Hi Ant,
>
> What SQL command did you use to "set" the email notification? I am just
> curious, as I have never actually done it, but just guessing that this
> might work.
>
> Note that the data looks like this
>
> userinfoid |            name             |
>              value
>
> ------------+-----------------------------+--------------------------------------------------------------------------------------------------
>     2125003 | keyMessageEmailNotification |
> \xaced0005737200116a6176612e6c616e672e426f6f6c65616ecd207280d59cfaee0200015a000576616c7565787001
>     1979887 | keyMessageEmailNotification |
> \xaced0005737200116a6176612e6c616e672e426f6f6c65616ecd207280d59cfaee0200015a000576616c7565787000
>
> The first one should be when a user wishes to receive email, the second
> for when they do not.  ( I think)
>
> Is this what your table looks like?
>
> Regards,
> Jason
>
>
> On Tue, Oct 27, 2015 at 8:19 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> Did you also clear the server cache? Alternatively restart Tomcat
>> On Oct 27, 2015 8:16 AM, "Ant Snyman" <ant@xxxxxxxx> wrote:
>>
>>> Hi All,
>>> We want to enable all the users to receive email notifications and is
>>> looking for a way to do it in the backend via a SQL script (without having
>>> each user go into Profile-- > Settings).
>>>
>>> We have seen the table "usersetting" which is populated when the email
>>> notification is ticked on the UI. I played around by creating a user (with
>>> email address) and populating this table with a SQL insert but then I do
>>> not see the tick on the UI (after doing all the usual stuff like clearing
>>> cache). The system then also do not pick up that this user must receive
>>> email notifications.
>>>
>>> Where else in the database is the user flagged to receive email
>>> notifications?
>>>
>>> Regards
>>>
>>> *Ant Snyman*
>>>
>>> *Cell: 0824910449 <0824910449>*
>>>
>>> *Landline: 028 2713242*
>>>
>>>
>>> Health Information Systems Program - SA
>>>
>>> *This message and any attachments are subject to a disclaimer published
>>> at http://www.hisp.org/policies.html#comms_disclaimer
>>> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
>>> disclaimer before opening any attachment or taking any other action in
>>> terms of this electronic transmission.  If you cannot access the
>>> disclaimer, kindly send an email to disclaimer@xxxxxxxx
>>> <disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to
>>> this e-mail or opening any attachment you agree to be bound by the
>>> provisions of the disclaimer.*
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+46764147049
>



-- 

*Ant Snyman*

*Cell: 0824910449*

*Landline: 028 2713242*


Health Information Systems Program - SA

-- 


*This message and any attachments are subject to a disclaimer published at 
http://www.hisp.org/policies.html#comms_disclaimer 
<http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the 
disclaimer before opening any attachment or taking any other action in 
terms of this electronic transmission.  If you cannot access the 
disclaimer, kindly send an email to disclaimer@xxxxxxxx 
<disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to 
this e-mail or opening any attachment you agree to be bound by the 
provisions of the disclaimer.*