[Building Sakai] Auto-adding a tool to all existing users

[David Wafula]

Excellent suggestions. Thanks everyone.

On Mon, Apr 16, 2012 at 3:56 PM, Stephen Marquard
<stephen.marquard at uct.ac.za> wrote:
> You can also drop the My Workspace sites for all existing users (in the
> database), and they'll get recreated on login from the templates.
>
> You shouldn't do that when any users are logged in though.
>
> Regards
> Stephen
>
> Stephen Marquard, Acting Director
> Centre for Educational Technology, University of Cape Town
> http://www.cet.uct.ac.za
> Email/IM/XMPP: stephen.marquard at uct.ac.za
> Phone: +27-21-650-5037 Cell: +27-83-500-5290
>
>
>
>>>> Bryan Holladay <holladay at longsight.com> 4/16/2012 3:52 PM >>>
> You can use a DB script like so:
>
> This is a simple script that will backfill a tool into every site
> selected.  This example goes over how to add the Search Tool and
> insert it alphabetically.
> Ensure that you do a find and replace for both the registration
> (sakai.search) and the tool Title ('Search').  There are multiple
> places where these show up in the script.
>
>
> create table TOOL_TMP(
>    PAGE_ID VARCHAR(99),
>    SITE_ID VARCHAR(99)
> )
> Go
>
> create table TOOL_TMP2(
>    PAGE_ID VARCHAR(99),
>    SITE_ID VARCHAR(99),
>    TITLE VARCHAR(99),
>    LAYOUT char(1),
>    SITE_ORDER int(11),
>    POPUP char(1)
> )
> Go
>
> insert into TOOL_TMP
> (
>    select uuid() as PAGE_ID, SITE_ID as SITE_ID
>    from SAKAI_SITE
>    where SITE_ID not in (select SITE_ID from SAKAI_SITE_TOOL where
> REGISTRATION = 'sakai.search')
>    and SITE_ID not like '!%'
>    and  SITE_ID not like '~%'
> )
> Go
>
>
> --This adds the site page in alphabetical order
> insert into TOOL_TMP2
> (
>    select PAGE_ID, SITE_ID, "Search", 0, (select SITE_ORDER + 1 from
> SAKAI_SITE_PAGE ssp where ssp.SITE_ID = tt.SITE_ID and ucase(TITLE) <
> 'SEARCH' Order By Title DESC Limit 1) as toolOrder, 0
>    from TOOL_TMP tt
> )
> Go
>
> --now update any null values since there could be some, just make it
> the last tool in the site
> update TOOL_TMP2 tt
> Set SITE_ORDER = (select count(*) + 1 from SAKAI_SITE_PAGE ssp where
> ssp.SITE_ID = tt.SITE_ID)
> where SITE_ORDER is null
> Go
>
> insert into SAKAI_SITE_PAGE
> (
> select * from TOOL_TMP2
> )
> Go
>
>
> insert into SAKAI_SITE_TOOL
> (select uuid(), PAGE_ID, SITE_ID, 'sakai.search', 1, 'Search', null
> from TOOL_TMP2)
> Go
>
>
> Drop Table TOOL_TMP2
> Go
>
> Drop Table TOOL_TMP
> Go
>
>
> On Mon, Apr 16, 2012 at 9:50 AM, David Wafula <davidwaf at gmail.com>
> wrote:
>> Forgot to mention that is there a way to do it without coding ?
>>
>> thanks.
>>
>> On Mon, Apr 16, 2012 at 3:49 PM, David Wafula <davidwaf at gmail.com>
> wrote:
>>> Dear all,
>>> I can make a tool  auto-appear on workspace for new users once they
>>> log in. How do it for existing ones?
>>>
>>> Thanks.
>>> --
>>> David Wafula
>>
>>
>>
>> --
>> David Wafula
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
>
>
>
>
> ###
>
> UNIVERSITY OF CAPE TOWN
>
> This e-mail is subject to the UCT ICT policies and e-mail disclaimer
> published on our website at
> http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from
> +27 21 650 9111. This e-mail is intended only for the person(s) to whom
> it is addressed. If the e-mail has reached you in error, please notify
> the author. If you are not the intended recipient of the e-mail you may
> not use, disclose, copy, redirect or print the content. If this e-mail
> is not related to the business of UCT it is sent by the sender in the
> sender's individual capacity.
>
> ###
>
>



-- 
David Wafula