Porting UCD Gradebook changes to 2.3

Abstract class defining string and vector constants for ...

• properties file name and properties keys

• property value delimiter and 'placeholder' property values for 'roster' and 'final' grades respectively

• default column sort order

• enumeration of course metadata column keys

Stub extension of GradebookCourseGradeFeedService

Interface for Facade of Sakai SiteService

• getSiteProviderId(): gets current site's provider id from Sakai SiteService

• getSiteTitle(): gets current site's title from Sakai SiteService

Implementation of SiteService facade

• getSiteTitle(): uses gradebook id as the site id

• getSiteTitle(): uses gradebook id as the site id

properties bundle for new download options.

• keys with example values:

  • export_course_grade_gradebookid_column_name=Site Id

  • export_course_grade_siteprovider_column_name=Provider Id

  • export_course_grade_sitetitle_column_name=Site Title

  • export_course_grade_column_order_keys=export_course_grade_sitetitle_column_name,export_course_grade_gradebookid_column_name,export_course_grade_siteprovider_column_name,export_student_name,export_student_id,course_or_roster,assignments

  • course_grade_export_enabled=false

  • roster_export_enabled=false

  • export_course_grade_ent_submission_enabled=true

  • export_course_grade_ent_path=/afs/.ucdavis.edu/app/sakai/gradefiles

  • export_course_grade_ent_submission_url=https://ips.ucdavis.edu/CourseManagement/final_submit/fgs_direct_upload.cfm?providerid=export_course_grade_siteprovider_column_name&siteid=export_course_grade_gradebookid_column_name

• calculateMean(): changed mean calculation to exclude gradeableObjects with null grades

• added UC Davis' 7 kinds of 'pass/no pass' grades (S/U excluded)

• added 5 of UC Davis' 7 kinds of 'pass/no pass' grades (S/U excluded)

Added new properties defining for a export filename template which uses column names as placeholders for the implied data for that 'column'. These keys are passed to ExportBean.getCourseMetadataValue(String key) for each data.

Examples:

• #export_filename_sitemetadata_format=export_course_grade_gradebookid_column_name-export_course_grade_siteprovider_column_name

• export_filename_sitemetadata_format=export_course_grade_siteprovider_column_name

• export_filename_sitemetadata_format_delimiter=- (<-- that's a "dash character")

added bean definition for org_sakaiproject_service_gradebook_GradebookCourseGradeFeedService bean

added faces bean for SiteService facade: org_sakaiproject_tool_gradebook_facades_SakaiSiteService
added injection of org_sakaiproject_tool_gradebook_facades_ContextManagement into SiteService facade

edited 'rendered' attribute of csv and excel export command buttons to check
(!courseGradeDetailsBean.emptyEnrollments && exportBean.courseGradeDownloadEnabled)

added commandButton for 'Enterprise Export/Download' with 'rendered' attribute checking
(!courseGradeDetailsBean.emptyEnrollments && exportBean.courseGradeEntSubmissionEnabled)

Summary:

• added property initialization logic to constructor

• added second (boolean) parameter to getAsCsv() and getAsExcel() to switch inclusion of defined course metadata columns in the returned data

• added getOrderedColumns() method to return a List of columns from config files or default settings

• added getCourseMetadataValue(String key) to return appropriate values for metadata keys used in prop files (eg, Site Id, Site Title, Provider Id)

• modified nested loops in getAs*() methods to place grade-able objects based on ordered Column settings