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

[Bryan Holladay]

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"