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

[Liu, Peter]

I am wondering Whether the files or /data in the Resource tool at the existing 'My Workspace' will get lost or not, when you drop My Workspace site first and then recreate it by loging-in?

-Peter

-----Original Message-----
From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Stephen Marquard
Sent: Monday, April 16, 2012 9:57 AM
To: David Wafula
Cc: Sakai Developers
Subject: Re: [Building Sakai] Auto-adding a tool to all existing users

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.

###
 

_______________________________________________
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"