[Contrib: Evaluation System] Can't release evaluation to site

Matthew Jones jonespm at umich.edu
Wed Mar 24 11:40:42 PDT 2010


Ideally this could be done with webservices, but all of the the WS calls
needed don't exist yet and neither does a convenient function in the authz
api for changing this either. (Skip to the bold *Anyway* for a current
solution that Aaron mentoned)

I'd *guess* with the current calls you could get with this as an admin with

getAllSitesForUser (or getSiteList(null,1,MAX_INT))

Then go through all of these sites looking for the evaluation tool

getPagesAndToolsForSite(sessionid, <siteid from previous call>)

(It would be nice if getSites could incorporate a tool search, but
this isn't a huge deal.)

... Then you'd need to use the webservice call that doesn't exist to add a
realm function to a particular role in a site

Value would be true or valse.
setRealmFunction(role,site,function,value)

Internally it would have to get the authz associated with this site and
role, allow or disallow this function and save it back. Perhaps it could do
it in bulk for performance?

Some tools like mneme [1] have written an admin tool which takes care of all
of this internally, but this is extra work for the tool developer and isn't
entirely trivial.

*Anyway*, this comes up enough here that this seems like a good way to do
it. I think that the only current (easish) way is to do this is to modify
and run an SQL query. (which is what the conversion scripts do) . . . SASH
(Sakai Shell) [2] is an option but probably to much for this.

For instance if you looked at the 2.6.0 Sakai databae conversion script [3]
(This is the mysql, for oracle just the url with oracle) and scroll down a
page to the line that says "backfill new msg.emailout permissions into
existing realms" you'll see underneath this large block of SQL for
backfilling permissions. It's essentially a search and replace block. You
modify a few lines in this block and put in the roles you want to have this
permission in top to insert into this TEMP table.
The block starts with the line
CREATE TABLE PERMISSIONS_SRC_TEMP . . .
and ends with
DROP TABLE PERMISSIONS_SRC_TEMP . . .

The only lines you'll change are the INSERT INTO to add/change the roles and
the function for evaluation. Just use the example that's there.
INSERT INTO PERMISSIONS_SRC_TEMP values . . .

(and replace msg.emailout with whatever function you need)

Then you'd run the script on your database.

Good luck, hope that helps! (I hope to have that webservice and a client
example for setting these realms done *soon* we need it for some QA testing
we're doing locally as well as problems like this in the future)

[1] http://etudes.org/mneme/download.html#Mneme Admin
[2] http://www.unicon.net/node/969
[3]
https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_6_0_mysql_conversion.sql

On Wed, Mar 24, 2010 at 9:13 AM, Aaron Zeckoski <azeckoski at unicon.net>wrote:

> You need to add the permissions to the existing sites. This is
> unfortunately not very easy to do but there are a few options. I am
> rushed right now but if you search the mailing list archives of
> sakai-dev there are a few options there.
>
> -AZ
>
>
> On Wed, Mar 24, 2010 at 12:57 PM,  <Leah.Bergman at notes.udayton.edu> wrote:
> > We have installed Eval Sys on one of our test boxes.  Eval Sys works
> great
> > with newly created sites, but we're having a problem releasing
> evaluations
> > to courses that were created prior to installing Eval Sys (even with the
> > tool added).  In the older course sites, we're only getting the option to
> > release the evaluation to ad-hoc groups, not the site members.  Has
> anyone
> > experienced this issue?  If so, do you know how to resolve it?  Thank
> you.
> >
> >
> > Leah Bergman, M.Ed.
> > E-Learning Specialist
> > University of Dayton
> > 300 College Park, LTC Rm 038
> > Dayton, OH 45469-1302
> > Office:  (937) 229-5499
> > Fax:  (937) 229-2249
> >
> >
> >
> > _______________________________________________
> > evaluation mailing list
> > evaluation at collab.sakaiproject.org
> > http://collab.sakaiproject.org/mailman/listinfo/evaluation
> >
> > TO UNSUBSCRIBE: send email to
> evaluation-unsubscribe at collab.sakaiproject.org
> > with a subject of "unsubscribe"
> >
>
>
>
> --
> Aaron Zeckoski - Software Engineer - http://tinyurl.com/azprofile
> _______________________________________________
> evaluation mailing list
> evaluation at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/evaluation
>
> TO UNSUBSCRIBE: send email to
> evaluation-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/evaluation/attachments/20100324/ef322fb4/attachment-0001.html 


More information about the evaluation mailing list