[Building Sakai] samigo submitted assessments not displaying.

[Yzelle, Sonette]

This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________

Hi Karen,

Please find attached the .csv file as requested.
Your willingness to help is really appreciated.
When I use SAM_PUBLISHEDACCESSCONTROL_T instead of SAM_ACCESSACCESSCONTROL_T then no results are returned.
A funny thing also happened, normally only 8 of the 25 displayed but today there are 11 displaying.  I don't know if the lecturer is doing something funny.
Here is the assessmentgradingids of the assessments that are not being displayed.
1529772

1529789

1529832

1529842

1529897

1530076

1530217

1530235

1530289

1530344

1530430

1530555

1530605

1531444






Sonette Yzelle
Analyst Developer
Portal and Academic Solutions
ICT
UNISA

From: ktsao at hungs.org [mailto:ktsao at hungs.org] On Behalf Of Karen Tsao
Sent: 27 March 2012 08:31 PM
To: Yzelle, Sonette
Cc: sakai-dev at collab.sakaiproject.org; Moller, Johann
Subject: Re: [Building Sakai] samigo submitted assessments not displaying.

Hi Sonette,

Is it possible for you to export your result in .csv format. It's kind of hard for me to read your result because your result contain lots information. Also, can you please let me know couple of IDs that can and cannot be viewed?

By the way, please use SAM_PUBLISHEDACCESSCONTROL_T instead of SAM_ACCESSACCESSCONTROL_T in your query. Although I don't think this make any difference in this case.

Thanks,
Karen

On Mon, Mar 26, 2012 at 1:07 AM, Yzelle, Sonette <SYzelle at unisa.ac.za<mailto:SYzelle at unisa.ac.za>> wrote:
This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________

Hi Karin,

Thank you for your feedback.

The assessment is not released to multiple sections and the students are still valid users.

Here are the queries and the results (attached) that I got from the database:
select *
FROM   SAM_ASSESSACCESSCONTROL_T, SAM_PUBLISHEDASSESSMENT_T, SAM_ASSESSMENTGRADING_T,
       SAKAI_USER_ID_MAP
WHERE  SAM_ASSESSACCESSCONTROL_T.RELEASETO LIKE ('ECH2601-12-S1')
AND    SAM_ASSESSACCESSCONTROL_T.ASSESSMENTID = SAM_PUBLISHEDASSESSMENT_T.ASSESSMENTID
AND    SAM_ASSESSMENTGRADING_T.PUBLISHEDASSESSMENTID = SAM_PUBLISHEDASSESSMENT_T.ID<http://SAM_PUBLISHEDASSESSMENT_T.ID>
AND    SAM_ASSESSMENTGRADING_T.SUBMITTEDDATE IS NOT NULL
AND    SAM_ASSESSMENTGRADING_T.AGENTID IS NOT NULL
AND    SAM_ASSESSMENTGRADING_T.STATUS = 1
AND    SAM_ASSESSMENTGRADING_T.AGENTID = SAKAI_USER_ID_MAP.USER_ID
ORDER BY SAM_ASSESSMENTGRADING_T.ASSESSMENTGRADINGID, SAM_ASSESSMENTGRADING_T.AGENTID;


Sonette Yzelle
Analyst Developer
Portal and Academic Solutions
ICT
UNISA

From: ktsao at hungs.org<mailto:ktsao at hungs.org> [mailto:ktsao at hungs.org<mailto:ktsao at hungs.org>] On Behalf Of Karen Tsao
Sent: 23 March 2012 06:56 PM
To: Yzelle, Sonette
Cc: sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
Subject: Re: [Building Sakai] samigo submitted assessments not displaying.

Hi Sonette,

Is this assessment released to multiple sections? Are these 17 students still valid users? If you already queried db, can you send me the results?

Thanks,
Karen

On Fri, Mar 23, 2012 at 6:31 AM, Yzelle, Sonette <SYzelle at unisa.ac.za<mailto:SYzelle at unisa.ac.za>> wrote:
This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________

Good day,

I am Sonette from Unisa and we on Sakai 2.8 (Samigo -2.8.0)

We have a case where there are 25 submitted assessments. When the lecturer clicks on the "25" only 8 submissions are displayed.
Any idea why this is happening?  I can see the submissions in the database. I don't know if there is maybe a setting somewhere that will stop a submission from displaying?

Your help will be appreciated.

Regards
Sonette

Sonette Yzelle
Analyst Developer
Portal and Academic Solutions
ICT
UNISA


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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120330/32c8a576/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SamigoUnisaResults.csv
Type: application/octet-stream
Size: 19538 bytes
Desc: SamigoUnisaResults.csv
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120330/32c8a576/attachment.obj