Converting or Exporting Banner Schedule to MS Word

Problem Description : 

Each semester schedule requires converting (or exporting) from Banner to MS Word for inclusion in the printed Schedule Book. This process is performed at request of Academic Affairs (currently Brenda B)

 Resolution : 

Each semester requires running 3 Crystal Reports and exporting them to a folder under n:\Schedules\yyyy Schedule Books\term_of_book. The Crystal Report files are saved under n:\csd\britt and named as below:

First prepare the Learning Community groups

Update ssrcorq table using the following sql in Toad

select rowid, ssrcorq. * from SSRCORQ

where SSRCORQ_TERM_CODE = '201208' 

In the SSRCORQ_GROUP column add a L1, L2, etc. based on the community set number from Academic Affairs.

1. Schedule (schedule.rpt) - creates mast list of classes sorted by subject, number and section

2. Schedule By Time (schedule_by_time.rpt for fall & spring, schedule_by_time_summer.rpt for summer

3. offcampus_schedule.rpt - Offcampus schedule listing

After running for required semester, do the following for each:

1 - Export and save in Microsoft Word (97-2003) format to the schedule folder for term

2 - Open in MS Word (file will be a .rtf document)

3 - Run the "Macro1" which cleans up the document

4 - Save As document and save in MS Word 2007 format

5 - Delete the .rtf document created by export in #1

A key to this process is having the Macro1 macro setup on PC doing the MS Word step 3 above. This macro is saved in the document n:\csd\britt\schedule_Macro.docx and, using the MS Word Macro Organizer, can be loaded into the default template for PC doing this step. 

 Revision Date : 10/10/2012