[Building Sakai] Auto-adding a tool to all existing users
|
View:
New views
19 Messages
—
Rating Filter:
Alert me
|
 |
[Building Sakai] Auto-adding a tool to all existing users
by David Wafula-2
::
Rate this Message:
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 _______________________________________________ sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by David Wafula-2
::
Rate this Message:
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@...> 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@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Bryan Holladay
::
Rate this Message:
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@...> 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@...> 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@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Bryan Holladay
::
Rate this Message:
Oh, just realized it's MyWorkspace after I sent this... With the
MyWorkspace sites, you can just deleted all existing My Workspaces and that will trigger Sakai to create a new one based on the template (!user) when they log back in. You can see an example WebService to do this at: https://source.sakaiproject.org/svn//msub/longsight.com/webservices/webservices-1.0.x/axis/src/webapp/WSLongsight.jws (function: deleteAllMyWorkspaceSites)... or you can do it manually in the DB. -Bryan On Mon, Apr 16, 2012 at 9:52 AM, Bryan Holladay <holladay@...> wrote: > 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@...> 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@...> 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@... >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Stephen Marquard
::
Rate this Message:
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@... Phone: +27-21-650-5037 Cell: +27-83-500-5290 >>> Bryan Holladay <holladay@...> 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@...> 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@...> 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@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to "unsubscribe" _______________________________________________ sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... 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@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by David Wafula-2
::
Rate this Message:
Excellent suggestions. Thanks everyone.
On Mon, Apr 16, 2012 at 3:56 PM, Stephen Marquard <stephen.marquard@...> wrote: > 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@... > Phone: +27-21-650-5037 Cell: +27-83-500-5290 > > > >>>> Bryan Holladay <holladay@...> 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@...> > 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@...> > 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@... >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> TO UNSUBSCRIBE: send email to > sakai-dev-unsubscribe@... with a subject of > "unsubscribe" > _______________________________________________ > sakai-dev mailing list > sakai-dev@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to > sakai-dev-unsubscribe@... 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. > > ### > > -- David Wafula _______________________________________________ sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by JOSE MARIANO LUJAN GONZALEZ
::
Rate this Message:
El 16/04/2012 16:20, David Wafula escribió:
> Excellent suggestions. Thanks everyone. > > On Mon, Apr 16, 2012 at 3:56 PM, Stephen Marquard > <stephen.marquard@...> wrote: >> 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@... >> Phone: +27-21-650-5037 Cell: +27-83-500-5290 >> >> >> >>>>> Bryan Holladay<holladay@...> 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@...> >> 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@...> >> 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@... >>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >>> >>> TO UNSUBSCRIBE: send email to >> sakai-dev-unsubscribe@... with a subject of >> "unsubscribe" >> _______________________________________________ >> sakai-dev mailing list >> sakai-dev@... >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> TO UNSUBSCRIBE: send email to >> sakai-dev-unsubscribe@... 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. >> >> ### >> >> > > you could use the contrib tool UMUSYNC which will allow you to add tools or permissions to all existing sites using filters. https://confluence.sakaiproject.org/display/UMUSYNC/Sites+sync+tool+-+Umusync cheers! mariano _______________________________________________ sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Liu, Peter-2
::
Rate this Message:
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@... [mailto:sakai-dev-bounces@...] 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@... Phone: +27-21-650-5037 Cell: +27-83-500-5290 >>> Bryan Holladay <holladay@...> 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@...> 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@...> 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@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to _______________________________________________ sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... 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@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" _______________________________________________ sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Bryan Holladay
::
Rate this Message:
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@...> 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@... [mailto:sakai-dev-bounces@...] 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@... > Phone: +27-21-650-5037 Cell: +27-83-500-5290 > > > >>>> Bryan Holladay <holladay@...> 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@...> > 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@...> > 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@... >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> TO UNSUBSCRIBE: send email to > sakai-dev-unsubscribe@... with a subject of "unsubscribe" > _______________________________________________ > sakai-dev mailing list > sakai-dev@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to > sakai-dev-unsubscribe@... 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@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" > _______________________________________________ > sakai-dev mailing list > sakai-dev@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Steve Swinsburg-3
::
Rate this Message:
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:
_______________________________________________ sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Bryan Holladay
::
Rate this Message:
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@...> 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@...> 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@... > [mailto:sakai-dev-bounces@...] 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@... > > Phone: +27-21-650-5037 Cell: +27-83-500-5290 > > > > > Bryan Holladay <holladay@...> 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@...> > > 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@...> > > 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@... > > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > > TO UNSUBSCRIBE: send email to > > sakai-dev-unsubscribe@... with a subject of > "unsubscribe" > > _______________________________________________ > > sakai-dev mailing list > > sakai-dev@... > > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > > TO UNSUBSCRIBE: send email to > > sakai-dev-unsubscribe@... 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@... > > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > > TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... > with a subject of "unsubscribe" > > _______________________________________________ > > sakai-dev mailing list > > sakai-dev@... > > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > > TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... > with a subject of "unsubscribe" > > _______________________________________________ > sakai-dev mailing list > sakai-dev@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... > with a subject of "unsubscribe" > > sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by David Wafula-2
::
Rate this Message:
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@...> 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@...> 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@...> 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@... >> [mailto:sakai-dev-bounces@...] 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@... >> >> Phone: +27-21-650-5037 Cell: +27-83-500-5290 >> >> >> >> >> Bryan Holladay <holladay@...> 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@...> >> >> 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@...> >> >> 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@... >> >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> >> TO UNSUBSCRIBE: send email to >> >> sakai-dev-unsubscribe@... with a subject of >> "unsubscribe" >> >> _______________________________________________ >> >> sakai-dev mailing list >> >> sakai-dev@... >> >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> >> TO UNSUBSCRIBE: send email to >> >> sakai-dev-unsubscribe@... 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@... >> >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> >> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... >> with a subject of "unsubscribe" >> >> _______________________________________________ >> >> sakai-dev mailing list >> >> sakai-dev@... >> >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> >> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... >> with a subject of "unsubscribe" >> >> _______________________________________________ >> sakai-dev mailing list >> sakai-dev@... >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... >> with a subject of "unsubscribe" >> >> > _______________________________________________ > sakai-dev mailing list > sakai-dev@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" -- David Wafula _______________________________________________ sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Bryan Holladay
::
Rate this Message:
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@...> 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@...> 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@...> 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@...> 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@... >>> [mailto:sakai-dev-bounces@...] 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@... >>> >>> Phone: +27-21-650-5037 Cell: +27-83-500-5290 >>> >>> >>> >>> >>> Bryan Holladay <holladay@...> 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@...> >>> >>> 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@...> >>> >>> 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@... >>> >>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >>> >>> >>> TO UNSUBSCRIBE: send email to >>> >>> sakai-dev-unsubscribe@... with a subject of >>> "unsubscribe" >>> >>> _______________________________________________ >>> >>> sakai-dev mailing list >>> >>> sakai-dev@... >>> >>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >>> >>> >>> TO UNSUBSCRIBE: send email to >>> >>> sakai-dev-unsubscribe@... 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@... >>> >>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >>> >>> >>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... >>> with a subject of "unsubscribe" >>> >>> _______________________________________________ >>> >>> sakai-dev mailing list >>> >>> sakai-dev@... >>> >>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >>> >>> >>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... >>> with a subject of "unsubscribe" >>> >>> _______________________________________________ >>> sakai-dev mailing list >>> sakai-dev@... >>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >>> >>> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... >>> with a subject of "unsubscribe" >>> >>> >> _______________________________________________ >> sakai-dev mailing list >> sakai-dev@... >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" > > > > -- > David Wafula sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by vikramsujithkumart
::
Rate this Message:
Hi All,
We were trying to add new tool link to more than 200000 registered users in myworkspace for each user and system is hanging as it is taking more than 30 hours (after processing for 30 hours it updated only for 51000 users). Please suggest if it can be done in other way (at database level). Many Thanks Vikram. |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Steve Swinsburg-3
::
Rate this Message:
How are you doing it? I'd suggest batching it and pausing every few thousand users or so. Is it a quartz job or web service or the contrib updater tool?
Sent from my iPhone On 08/08/2012, at 17:24, vikramsujithkumart <vikram.sujith@...> wrote: > > Hi All, > > We were trying to add new tool link to more than 200000 registered users in > myworkspace for each user and system is hanging as it is taking more than 30 > hours (after processing for 30 hours it updated only for 51000 users). > Please suggest if it can be done in other way (at database level). > > Many Thanks > Vikram. > > > -- > View this message in context: http://old.nabble.com/-Building-Sakai--Auto-adding-a-tool-to-all-existing-users-tp33695155p34270197.html > Sent from the Sakai - Development mailing list archive at Nabble.com. > > _______________________________________________ > sakai-dev mailing list > sakai-dev@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by rash143
::
Rate this Message:
Hi Steve,
I am facing a similar problem is it possible to add a tool to 5000 users at a time instead of adding it to a large no of users, regards, Rasheed
|
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Bryan Holladay
::
Rate this Message:
If it's myworkspace, just add the new link/tool to the template then
delete all the existing workspaces. You can do this via script or batch webservice like Steve suggested. Once a user re-enters sakai, if they don't have a myworkspace, it will be re-created on login and no data links will be lost since the site ID will be the same. -Bryan On Wed, Aug 8, 2012 at 4:04 AM, Steve Swinsburg <steve.swinsburg@...> wrote: > How are you doing it? I'd suggest batching it and pausing every few thousand users or so. Is it a quartz job or web service or the contrib updater tool? > > Sent from my iPhone > > On 08/08/2012, at 17:24, vikramsujithkumart <vikram.sujith@...> wrote: > >> >> Hi All, >> >> We were trying to add new tool link to more than 200000 registered users in >> myworkspace for each user and system is hanging as it is taking more than 30 >> hours (after processing for 30 hours it updated only for 51000 users). >> Please suggest if it can be done in other way (at database level). >> >> Many Thanks >> Vikram. >> >> >> -- >> View this message in context: http://old.nabble.com/-Building-Sakai--Auto-adding-a-tool-to-all-existing-users-tp33695155p34270197.html >> Sent from the Sakai - Development mailing list archive at Nabble.com. >> >> _______________________________________________ >> sakai-dev mailing list >> sakai-dev@... >> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev >> >> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" > _______________________________________________ > sakai-dev mailing list > sakai-dev@... > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev > > TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by juanarcadio
::
Rate this Message:
Hi Vikram,
At the University of Murcia we used the "umusync" tool that is able to perform this task. https://confluence.sakaiproject.org/display/UMUSYNC/ In our Sakai, a common task which is adding a new tool to all myworkspaces it usually takes about 2 hours for 50000 users. If you have any question regarding the use or instalation of the tool, please ask us!!! Best wishes. Juan Arcadio. El 08/08/2012 9:24, vikramsujithkumart escribió: Hi All, We were trying to add new tool link to more than 200000 registered users in myworkspace for each user and system is hanging as it is taking more than 30 hours (after processing for 30 hours it updated only for 51000 users). Please suggest if it can be done in other way (at database level). Many Thanks Vikram. --
 _______________________________________________ sakai-dev mailing list sakai-dev@... http://collab.sakaiproject.org/mailman/listinfo/sakai-dev TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe@... with a subject of "unsubscribe" |
|
|
Re: [Building Sakai] Auto-adding a tool to all existing users
by Baynaa_sk
::
Rate this Message:
I used trunk version.(2.10-SNAPSHOT)
C:\Users\bayansuren\trunk\umusync>mvn clean install [INFO] Scanning for projects... [ERROR] The build could not read 1 project -> [Help 1] [ERROR] [ERROR] The project umu.sakai-indie:umusync-indie-project:1.1-SNAPSHOT (C:\Users\bayansuren\trunk\umusync\pom.xml) has 1 error [ERROR] Non-resolvable parent POM: Failure to find org.sakaiproject.purepoms:sakai-standard-tool:pom:2.7.8 in http://repo.maven.apache.org/maven2 was cached in the local repository, resolution wil l not be reattempted until the update interval of central has elapsed or updates are forced and 'parent.relativePath' points at wrong local POM @ line 4, column 10 -> [Help 2] [ERROR] [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch. [ERROR] Re-run Maven using the -X switch to enable full debug logging. [ERROR] [ERROR] For more information about the errors and possible solutions, please read the following articles: [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingException [ERROR] [Help 2] http://cwiki.apache.org/confluence/display/MAVEN/UnresolvableModelException C:\Users\bayansuren\trunk\umusync>
|
| Free embeddable forum powered by Nabble | Forum Help |
