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

[David Wafula]

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