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

[Stephen Marquard]

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.

###