[Building Sakai] Samigo deleted tests aren't deleted in Gradebook (in 2.5.3)

[Karen Tsao]

Hi Daniel,

Yes. If you want to remove all the deleted tests, your sql looks correct.
Just want to clarify, the unpublished tests are not in
SAM_PUBLISHEDASSESSMENT_T. They are in SAM_ASSESSMENTBASE_T.

Thanks,
Karen

On Fri, Apr 9, 2010 at 1:57 AM, Daniel Merino <daniel.merino at unavarra.es>wrote:

> Hi, Karen.
>
> I have tried this SQL and it seems to work fine.
>
> update GB_GRADABLE_OBJECT_T
> set removed = 1
> where external_app_name = 'Exámenes'
> and external_id in (select id from SAM_PUBLISHEDASSESSMENT_T where
> status=2)
>
> All unpublished or deleted tests in Samigo seem to have their status set
> to 2 in SAM_PUBLISHEDASSESSMENT_T so I think that this SQL should fix
> our problem.
>
> Please, if you have any dissapointment to this SQL, just tell me.
>
> Thanks and best regards.
>
> Karen Tsao escribió:
> > Hi Daniel,
> >
> > Please try following query:
> >
> > update gb_gradable_object_t set removed = 1 where external_app_name =
> > 'Tests & Quizzes' and external_id in (:published_assessment_id_1,
> > :published_assessment_id_2, ...)
> >
> > As I am not an expert in Gradebook, please test the query in your QA
> > instance first. And let me know if this doesn't work for you.
> >
> > Thanks,
> > Karen
> >
> > On Wed, Mar 31, 2010 at 10:20 AM, Karen Tsao <ktsao at stanford.edu
> > <mailto:ktsao at stanford.edu>> wrote:
> >
> >     Hi Daniel,
> >
> >     This is fixed in http://jira.sakaiproject.org/browse/SAK-12907.
> >     Please patch the fix and see if your issue can be solved.
> >
> >     Thanks,
> >     Karen
> >
> >
> >     On Wed, Mar 31, 2010 at 4:08 AM, Daniel Merino
> >     <daniel.merino at unavarra.es <mailto:daniel.merino at unavarra.es>>
> wrote:
> >
> >         Hi everybody.
> >
> >         We have a fresh & clean 2.5.3 Sakai where we are having the
> >         next issue:
> >
> >         -We create a Samigo test with grading available in Gradebook
> >         and publish it.
> >         -The test is showed in Gradebook as usual.
> >         -We delete from Samigo the published test, and even the test
> >         itself. But
> >         that test can still be viewed in Gradebook. Even worse, an
> >         attempt to
> >         re-publish in Samigo the same test gives us an error because
> there
> >         exists already in Gradebook a test with that name.
> >
> >         I have tested this in a 2.5.x qa server
> >         (http://qa5-us.sakaiproject.org/portal) and it seems that this
> >         problem
> >         is solved there. But I'm not able to find the issue in
> >         Samigo's JIRA
> >         neither in Gradebook's JIRA.
> >
> >         Please, could somebody guide me to the patch which solves this
> >         problem?
> >         Thanks in advance.
> >         --
> >         Daniel Merino Echeverría
> >         daniel.merino at unavarra.es <mailto:daniel.merino at unavarra.es>
> >         Gestor de teleformación - Centro Superior de Innovación
> Educativa.
> >         Tfno: 948-168489 - Universidad Pública de Navarra.
> >         --
> >         Lo consiguió porque no sabía que era imposible.
> >
> >         _______________________________________________
> >         sakai-dev mailing list
> >         sakai-dev at collab.sakaiproject.org
> >         <mailto: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
> >         <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
> >         subject of "unsubscribe"
> >
> >
> >
>
> --
> Daniel Merino Echeverría
> daniel.merino at unavarra.es
> Gestor de teleformación - Centro Superior de Innovación Educativa.
> Tfno: 948-168489 - Universidad Pública de Navarra.
> --
> La esclavitud no se abolió, se cambió a 8 horas diarias.
> _______________________________________________
> 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100409/6b667e9b/attachment.html