sakai.assigment to sakai.assignment.grades migration

[Ron Peterson]

I have some course in 2.3 which were using the sakai.assignment tool.
After upgrading to 2.5, the assignments page still refers to the
now-nonexistant sakai.assignment tool (now called $tool.Tool.Id in the
admin 'Sites' administration tool), and opens a blank page (as you'd
expect).  The sakai.assignment.grades tool is available in the list of
tools under worksite setup.  If it is turned on, it contains the
assigments that were previously in the old tool.

Did I miss a step in the upgrade process?  If not, I'm wondering how
folks would recommend I fix these sites so that the proper page shows
up.  I'm comfortable doing webservices scripting, but I don't know the
proper way to call of the available functions.  How would I even refer
to a toolid for a tool that doesn't exist?

--
Ron Peterson
Network & Systems Manager
Mount Holyoke College
http://www.mtholyoke.edu/~rpeterso
-
I wish my computer would do what I want it to do - not what I tell it to do.
----------------------
This automatic notification message was sent by Sakai Collab (https://collab.sakaiproject.org//portal) from the DG: Development (a.k.a. sakai-dev) site.
You can modify how you receive notifications at My Workspace > Preferences.

[Seth Theriault]

Ron Peterson wrote:

> Did I miss a step in the upgrade process?  If not, I'm
> wondering how folks would recommend I fix these sites so that
> the proper page shows up.  I'm comfortable doing webservices
> scripting, but I don't know the proper way to call of the
> available functions.  How would I even refer to a toolid for a
> tool that doesn't exist?

If the sakai.assignment.grades version is the one you want (read:
testing), I am pretty sure you can -- brace yourself -- update
the database directly with some SQL like this:

UPDATE SAKAI_SITE_TOOL SET REGISTRATION='sakai.assigment'
WHERE REGISTRATION='sakai.assignment.grades';

That's for Oracle by the way.

This method has been used in conversion scripts when tools have
changed toolids.

Seth
----------------------
This automatic notification message was sent by Sakai Collab (https://collab.sakaiproject.org//portal) from the DG: Development (a.k.a. sakai-dev) site.
You can modify how you receive notifications at My Workspace > Preferences.

[Zhen Qian]

Seth,

Maybe the query should be:

UPDATE SAKAI_SITE_TOOL SET REGISTRATION='sakai.assignment.grades'  
WHERE REGISTRATION='sakai.assignment';

Thanks,

- Zhen

On Jul 24, 2008, at 10:15 PM, Seth Theriault wrote:

> Ron Peterson wrote:
>
> > Did I miss a step in the upgrade process? If not, I'm
> > wondering how folks would recommend I fix these sites so that
> > the proper page shows up. I'm comfortable doing webservices
> > scripting, but I don't know the proper way to call of the
> > available functions. How would I even refer to a toolid for a
> > tool that doesn't exist?
>
> If the sakai.assignment.grades version is the one you want (read:
> testing), I am pretty sure you can -- brace yourself -- update
> the database directly with some SQL like this:
>
> UPDATE SAKAI_SITE_TOOL SET REGISTRATION='sakai.assigment'
> WHERE REGISTRATION='sakai.assignment.grades';
>
> That's for Oracle by the way.
>
> This method has been used in conversion scripts when tools have
> changed toolids.
>
> Seth
>
> This automatic notification message was sent by Sakai Collab  
> (https://collab.sakaiproject.org//portal) from the DG: Development  
> (a.k.a. sakai-dev) site.
> You can modify how you receive notifications at My Workspace >  
> Preferences.

----------------------
This automatic notification message was sent by Sakai Collab (https://collab.sakaiproject.org//portal) from the DG: Development (a.k.a. sakai-dev) site.
You can modify how you receive notifications at My Workspace > Preferences.

[Ron Peterson]

2008-07-24_22:30:12-0400 Zhen Qian <zqian@...>:
> Seth,
>
> Maybe the query should be:
>
> UPDATE SAKAI_SITE_TOOL SET REGISTRATION='sakai.assignment.grades'  
> WHERE REGISTRATION='sakai.assignment';
>
Thanks guys.  I was going to write a webservices script to do this, but
this is much easier.

As an interesting (to me anyway) aside, I added a function getSitePages
to SakaiScript.jws which returns the page titles and associated tools
(ids, names, and descriptions) for a given site.  An oddity is that for
the sites where my Assignments page was associated with the
(non-existent) sakai.assignment tool, the webservice call reports it as
the sakai.assignment.grades tool.

tools = page.getTools();
for (iTools = tools.iterator(); iTools.hasNext();) {
  tool = (ToolConfiguration)iTools.next();
  try {
    t = tool.getTool();
    s = t.getId();
    toolNode = dom.createElement(s);
    ...

I was going to use this function to find the sites that had the wrong
tool assigned to the Assignments page so I could update them, but
obviously that approach doesn't work if it doesn't report the proper
tool id.

--
Ron Peterson
Network & Systems Manager
Mount Holyoke College
http://www.mtholyoke.edu/~rpeterso
-
I wish my computer would do what I want it to do - not what I tell it to do.
----------------------
This automatic notification message was sent by Sakai Collab (https://collab.sakaiproject.org//portal) from the DG: Development (a.k.a. sakai-dev) site.
You can modify how you receive notifications at My Workspace > Preferences.

[Ron Peterson]

2008-07-27_12:10:58-0400 Ron Peterson <rpeterso@...>:

>
> 2008-07-24_22:30:12-0400 Zhen Qian <zqian@...>:
> > Seth,
> >
> > Maybe the query should be:
> >
> > UPDATE SAKAI_SITE_TOOL SET REGISTRATION='sakai.assignment.grades'  
> > WHERE REGISTRATION='sakai.assignment';
> >
> Thanks guys.  I was going to write a webservices script to do this, but
> this is much easier.
>
> As an interesting (to me anyway) aside, I added a function getSitePages
> to SakaiScript.jws which returns the page titles and associated tools
> (ids, names, and descriptions) for a given site.  An oddity is that for
> the sites where my Assignments page was associated with the
> (non-existent) sakai.assignment tool, the webservice call reports it as
> the sakai.assignment.grades tool.

As usual, immediate after posting to a big list, I found my problem.
Nevermind.

--
Ron Peterson
Network & Systems Manager
Mount Holyoke College
http://www.mtholyoke.edu/~rpeterso
-
I wish my computer would do what I want it to do - not what I tell it to do.
----------------------
This automatic notification message was sent by Sakai Collab (https://collab.sakaiproject.org//portal) from the DG: Development (a.k.a. sakai-dev) site.
You can modify how you receive notifications at My Workspace > Preferences.