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?
From: sakai-dev-bounces@... [mailto:sakai-dev-bounces@...] 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.
>>> Bryan Holladay <holladay@...> 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(
create table TOOL_TMP2(
insert into TOOL_TMP
select uuid() as PAGE_ID, SITE_ID as SITE_ID
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 '~%'
--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
--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
insert into SAKAI_SITE_TOOL
(select uuid(), PAGE_ID, SITE_ID, 'sakai.search', 1, 'Search', null from TOOL_TMP2) Go
Drop Table TOOL_TMP2
Drop Table TOOL_TMP
On Mon, Apr 16, 2012 at 9:50 AM, David Wafula <davidwaf@...>
> Forgot to mention that is there a way to do it without coding ?
> On Mon, Apr 16, 2012 at 3:49 PM, David Wafula <davidwaf@...>
>> Dear all,
>> I can make a tool auto-appear on workspace for new users once they
>> log in. How do it for existing ones?
>> David Wafula
> David Wafula
> sakai-dev mailing list
> sakai-dev@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >
> TO UNSUBSCRIBE: send email to
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.