[Building Sakai] Auto-adding a tool to all existing users
Steve Swinsburg
steve.swinsburg at gmail.com
Mon Apr 16 16:18:12 PDT 2012
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"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120417/38a66102/attachment.html
More information about the sakai-dev
mailing list