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

Tue Apr 17 05:35:09 PDT 2012

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"
>
>