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

Wed Apr 18 05:28:38 PDT 2012

Thats a safe assumption... some people avoid deleting the admin and
post-master myworkspaces (i.e. user eid: admin and postmaster) or any
other special user's set in the property: "webservice.specialUsers",
just a preference.

-Bryan

On Wed, Apr 18, 2012 at 4:20 AM, David Wafula <davidwaf at gmail.com> wrote:
> Just to carry on..would i be correct to assume that to uniquely
> identify My Workspace sites, i use  "SITE_ID like '~%' "?  There are
> no other sites likely to be trapped in here accidentally ?
> Thanks.
>
> On Tue, Apr 17, 2012 at 2:35 PM, Bryan Holladay <holladay at longsight.com> wrote:
>> It doesn't look like that webservice handles externals users My
>> Workspaces (otherwise, it looks good).
>>
>> -Bryan
>>
>> On Mon, Apr 16, 2012 at 7:18 PM, Steve Swinsburg
>> <steve.swinsburg at gmail.com> wrote:
>>> There is also a webservice to do this:
>>>
>>> public String addNewToolToAllWorkspaces(String sessionid, String toolid,
>>> String pagetitle, String tooltitle, int pagelayout, int position, boolean
>>> popup);
>>>
>>> cheers,
>>> Steve
>>>
>>>
>>>
>>> On 17/04/2012, at 3:46 AM, Bryan Holladay wrote:
>>>
>>> Nope, the files will still be there.  The link in the Resources tool
>>> is based on the Site Id, and when the new My Workspace is recreated,
>>> it will have the same Site Id (i.e. "~{userid}")
>>>
>>> -Bryan
>>>
>>> On Mon, Apr 16, 2012 at 1:39 PM, Liu, Peter <peter.liu at yale.edu> wrote:
>>>
>>> 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"
>>>
>>> _______________________________________________
>>>
>>> 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"
>>>
>>>
>> _______________________________________________
>> 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"
>
>
>
> --
> David Wafula