About
This plugin will add the validation reports to the custom reports bundle base. Note: the base plugin will need to be installed before you will see these reports automatically appear.
What's New in Version 4.1.1
Return of the export buttons. Also added some "make current selection of students" buttons when applicable.
How do I install a plugin?
Directions can be found here
Change History
V 4.1.1 - Released 2015-07-27
V 4.0.0 - Released 2014-04-01
Comments
erickenbacker
Tue, 03/31/2015 - 8:09am
Permalink
Sync Error SQL Script - CC Report
I need some help with these sync error reports. How do you troubleshoot the error, "Unknown Sync Error"? I have several and I'm not sure where I should be looking to clean these up.
Thanks,
Elainna
gmatyola
Fri, 06/19/2015 - 9:18am
Permalink
Update to RollOver Errors...
I've got a patch that does the following:
1> Adds a warning if Next_Grade is equal to or less than the current grade level of the student.
2> Fixes the "Make Current Student Selection", and "Add to Current Student Selection" buttons so they select the entire selection.
(It seemed that the buttons were intended to only select Enrolled students, but they weren't working, so I fixed them by selecting all of the students in the report.)
The Patch file (I'm an old school *nix hack) follows:
--- RollOverErrors.html.orig Fri Jun 19 11:09:07 2015
+++ RollOverErrors.html.new Fri Jun 19 11:09:21 2015
@@ -60,7 +60,8 @@
CASE WHEN (s.Enroll_Status = 0 AND s.Sched_NextYearGrade = 99 AND s.Next_School != 999999) THEN 1 END nGradSch,
CASE WHEN (s.Enroll_Status = 0 AND s.Sched_NextYearGrade != 99 AND s.Next_School = 999999) THEN 1 END nGradGr,
CASE WHEN (s.Enroll_Status = 0 AND s.Next_School != 0 AND s.Sched_NextYearGrade NOT BETWEEN nsch.Low_Grade AND nsch.High_Grade) THEN 1 END NGOutOfRange,
- CASE WHEN (s.Enroll_Status IN (0,-1) AND s.SchoolID != s.Enrollment_SchoolID) THEN 1 END schMatch
+ CASE WHEN (s.Enroll_Status IN (0,-1) AND s.SchoolID != s.Enrollment_SchoolID) THEN 1 END schMatch,
+ CASE WHEN (s.Enroll_Status = 0 AND s.Sched_NextYearGrade BETWEEN -2 AND s.Grade_Level) THEN 1 END GrDemote
FROM Students s
INNER JOIN Schools nsch ON CASE WHEN s.Next_School = 0 THEN s.SchoolID ELSE s.Next_School END = nsch.School_Number
AND s.SchoolID LIKE CASE WHEN ~(curschoolid)=0 THEN '%' ELSE to_char(~(curschoolid)) END
@@ -71,6 +72,7 @@
OR (s.Enroll_Status = 0 AND s.Sched_NextYearGrade = 99 AND s.Next_School != 999999)
OR (s.Enroll_Status = 0 AND s.Sched_NextYearGrade != 99 AND s.Next_School = 999999)
OR (s.Enroll_Status = 0 AND s.Next_School NOT IN (0,999999) AND s.Sched_NextYearGrade NOT BETWEEN nsch.Low_Grade AND nsch.High_Grade)
+ OR (s.Enroll_Status = 0 AND s.Sched_NextYearGrade BETWEEN -2 AND s.Grade_Level)
ORDER BY s.enroll_Status, std, gr
;alternatecolor]
<tr class="oddRow" valign="top">
@@ -90,6 +92,7 @@
~(nGradGr;t;if.test=1;then=-Next Year School suggests Graduating but Next year grade does not<br>)
~(NGOutOfRange;t;if.test=1;then=-Next Year Grade not in grade range for school<br>)
~(schMatch;t;if.test=1;then=-SchoolID and Enrollment SchoolID should match for Active/Pre-enrolled students<br>)
+ ~(GrDemote;t;if.test=1;then=-Next Year Grade is less than or equal to Current Grade Placement<br>)
</td>
</tr>
[/tlist_sql]
@@ -98,8 +101,8 @@
<div style="text-align:center;">Report generated at ~[time] on ~[date]</div>
<h3 class="makeCurrentSelection">Use Students Above To Modify The Current Student Selection:</h3>
-<button type="button" onClick="selectStudents('replace','studentIDsEnrolled')" >Make Current Student Selection</button>
-<button type="button" onClick="selectStudents('add','studentIDsEnrolled')" >Add to Current Student Selection</button>
+<button type="button" onClick="selectStudents('replace','studentIDs')" >Make Current Student Selection</button>
+<button type="button" onClick="selectStudents('add','studentIDs')" >Add to Current Student Selection</button>
</div>
</div>
drsimon44
Tue, 04/19/2016 - 11:43am
Permalink
changing security group
Hey guys,
Can you tell me all the places that need to be changed to allow security group 8 to see the validation reports in dynamic mode? I've found quite a few but I'm missing something.
Thanks.
Don