« Return to Thread: [Building Sakai] rest all 'My Workspaces'

Re: [Building Sakai] rest all 'My Workspaces'

by Matthew Buckett :: Rate this Message:

Reply to Author | View in Thread

2009/7/6 Steve Swinsburg <s.swinsburg@...>:
> Hi Jon,
> If you delete all My Workspaces their resources will remain intact :) The
> sites will be re-created when they next login with the changes picked up
> from the !user.template.
> For doing it en-masse, you could use the web services and iterate over every
> userId.

If your ok writing web service client I'd use that as it's less likely
to leave your database in a inconsistent state, however if you can't
easily do that then this may help. It some  SQL (for MySQL) we
recently ran to remove everyone's MyWorkspace, so that they would all
get the latest template.

Attached is the SQL. This doesn't delete anything outside the site
service (eg authz).

--
  Matthew Buckett


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

del-workspace.sql (2K) Download Attachment

 « Return to Thread: [Building Sakai] rest all 'My Workspaces'