New Student Roster Creation Tool (SRCT) now available

For the past few days, I have been working on re-writing the roster generator tool from the ground up:

1. so that I can fix some issues that it had, and make it faster and more efficient
2. to add some new functionality 

As part of the process, I also ended up creating 3 security layers for the application: IT Admin, Site Admin, and Teacher. Each will give separate layers of permissions for the rosters:

In a few words:
IT Admin:

• Can choose which school to get the roster for
• Can choose what teachers to get the roster for (single, or multiple teachers available)
• Can choose  (for secondaries) whether to get Spring/Fall semester or First/Second/Third semester
• Can choose to output single file or multiples for teacher

Site Admin: 

• Is locked down to working with their school (and any other schools they may be part of, [multiple schools possible] 
• Can choose one or more teachers to retrieve the rosters for. 

Teacher:

• Simple one button tool that will retrieve the teacher's students. For secondary teachers, multiple entries could be listed if the student exists for multiple period for that teacher. 

Below you can find the ChangeLog for the enhancements and additions. You can also find some more information, and documentation about the tool and its usage, as well as how to setup AD users to give them privileges to one or more of these tools. Please read those carefully. The documentation can be found here:  

http://wiki.chino.k12.ca.us/operations/user_management_resource_administrator#student_roster_generator

ADD: Added new module for site admin, allowing them to have access to run rosters for any teacher within their site. 
REMOVE: Removed the ability for teachers to run rosters for the whole school. Their module will now only allow them to run the roster for themselves. 
ADD: New security layer for available features. There are now 3 editions of the tool: IT Admin, Site Admin, and Teacher. 
ENHANCE: All queries on the backend of the utility have been rewritten from scratch, tremendously speeding up the process to retrieve a roster. 
ENHANCE: All rosters now include the full header of the CSV. 
ADD: For the IT Admin, and Site Admin editions, you now have the option to select what specific teachers to get the roster for. Multiple teachers at a time also allowed. 
ENHANCE: Added some enhancement to the interface of the teacher tool, and specific error handling that would guide users in the correct direction. 
ENHANCE: Additional error handling has been added which includes information for the helpdesk, and guidance to fix Active Directory Membership Problems. 
ADD: New option to select Fall/Spring/First, Second or Third Semester/Trimester for the secondary schools. 
ENHANCE: For the IT Admin tool, any previously created files will now be deleted prior to running a roster for a new school. This mitigates against having new data append to old data that may already exist on the user's computer.

If you have any questions, please let me know. 

• This application was put in production on 09/27/2012 at 11:00am