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

[Bryan Holladay]

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"