[Building Sakai] samigo submitted assessments not displaying.
Karen Tsao
ktsao at stanford.edu
Tue Apr 17 11:10:09 PDT 2012
Hi Sonette,
Your query for published assessments is not correct. Please use:
FROM *SAM_PUBLISHEDACCESSCONTROL_T*, SAM_PUBLISHEDASSESSMENT_T,
SAM_ASSESSMENTGRADING_T,
SAKAI_USER_ID_MAP
WHERE SAM_PUBLISHEDACCESSCONTROL_T.RELEASETO LIKE ('ECH2601-12-S1')
AND SAM_PUBLISHEDACCESSCONTROL_T.ASSESSMENTID =
SAM_PUBLISHEDASSESSMENT_T.ID
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;
> ** **
>
> In the beginning 8 of the 25 records were displaying. Now 18 of the 25
> are displaying.****
>
> Is it the way the assessments are marked, or must something be published?*
> ***
>
> **
>
I have no idea about this... Can you talk to the instructors/graders to see
if they changed anything? Not only in Samigo. Any membership changes?
Thanks,
Karen
> **
>
> Sonette****
>
> ** **
>
> Sonette Yzelle****
>
> Analyst Developer****
>
> Portal and Academic Solutions****
>
> ICT****
>
> UNISA****
>
> ** **
>
> *From:* Yzelle, Sonette
> *Sent:* 17 April 2012 03:12 PM
> *To:* Karen Tsao
> *Cc:* sakai-dev at collab.sakaiproject.org; Moller, Johann; Yzelle, Sonette
> *Subject:* RE: [Building Sakai] samigo submitted assessments not
> displaying.****
>
> ** **
>
> Hi Karin,****
>
> ** **
>
> *Regarding the problem where we have 25 submissions but not all are
> displaying when you click on “25” (number submitted link).*
>
> ** **
>
> The releaseto “ECH2601-12-S1”.****
>
> ** **
>
> When I use this select I get 25 records:****
>
> 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 ****
>
> 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;****
>
> ** **
>
> *When I use this select I get 0 records:*
>
> select * ****
>
> FROM *SAM_PUBLISHEDACCESSCONTROL_T*, SAM_PUBLISHEDASSESSMENT_T,
> SAM_ASSESSMENTGRADING_T, ****
>
> SAKAI_USER_ID_MAP****
>
> WHERE SAM_PUBLISHEDACCESSCONTROL_T.RELEASETO LIKE ('ECH2601-12-S1')****
>
> AND SAM_PUBLISHEDACCESSCONTROL_T.ASSESSMENTID =
> SAM_PUBLISHEDASSESSMENT_T.ASSESSMENTID****
>
> AND SAM_ASSESSMENTGRADING_T.PUBLISHEDASSESSMENTID =
> 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;****
>
> ** **
>
> What is the correct select to use to get the assessments?****
>
> ** **
>
> Attached is the result set for the first select. A .csv file, delimiter ~*
> ***
>
> ** **
>
> Thank you for your help.****
>
> ** **
>
> Sonette****
>
> ** **
>
> ** **
>
> 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:* 02 April 2012 09:18 PM
> *To:* Yzelle, Sonette
> *Cc:* sakai-dev at collab.sakaiproject.org; Moller, Johann
> *Subject:* Re: [Building Sakai] samigo submitted assessments not
> displaying.****
>
> ** **
>
> Hi Sonette,
>
> So when you change from SAM_ACCESSACCESSCONTROL_T to
> SAM_PUBLISHEDACCESSCONTROL_T, you got nothing return? But if you see some
> data from UI, that means your query is wrong. What is your value in
> ReleaseTo column?
>
> And the attached data is from the previous query? If that's from SAM_ACCESSACCESSCONTROL_T,
> the data actually is incorrect. Can you send me the results after your
> modify your query?
>
> Thanks,
> Karen****
>
> On Thu, Mar 29, 2012 at 11:11 PM, Yzelle, Sonette <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 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>
> 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 *****
>
> *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] *On Behalf Of *Karen Tsao
> *Sent:* 23 March 2012 06:56 PM
> *To:* Yzelle, Sonette
> *Cc:* 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>
> 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
> 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/20120417/986c158e/attachment.html
More information about the sakai-dev
mailing list