Queries that must be be run before importing the courses, they can be run by anyone with query access. The queries can be run throughout the entering of prior term copies to save you from having to a monster clean up, but they all must be run after the prior term copies have been entered and checked.
...
Run scheduling queries related to course cleanup:
UW_RS_SOC_ORGS_GROUPS_NP – If you get results you must do a course roll (Curriculum Management -> Roll Curriculum Data Forward -> Course Roll) that should fix them!
Run query to look for missing RC weights (UW_RS_MISS_RC_IN_RCWGHT_TBL_NP) if there were some that needed to be added re-run: UW_RS_RESERVE_CAP_ORDER_NP to catch any changes.
| Note |
|---|
Ensure Scheduling has updated all course changes |
Quest work:
Waterloo Student Admin > CEM > Process > Course Scheduling Anomaly Report
Enter in the term you about to run – run it twice once for GRD and once for UG, and the server name is SISP1
Once it’s finished running and the status is “Success” and “Posted” in the Process monitor click “Details” then “View/Log Trace” then the “.out” file
fix in Timetabler if required (most fixes will be within Quest as there’s no courses imported yet in Timetabler)
...
The Delete records from Academic Suite if they are not found in the source file should be Checked (differential). Select Next
...
...
Select Clear and then select the following file: Courses
Select Next
...
...
Click “Browse” and point to DCU folder on the local machine drive. Then click “Next”
...
Check the Report for any problems.
...
| Expand | ||
|---|---|---|
| ||
 |
If everything is ok, select Next, check the rejected records on this next report.
...
If everything is ok, click Next.
...
...
Keep the Backup option selected (because why not) and select Import Check the reports and when everything is ok click Done.
...
| Expand | ||
|---|---|---|
| ||
|
...
In In the Course characteristics file (crschar.txt) in the DCU folder remove all the reserves that are brought in and DE, DIST, EVE, NEVE, OC, RESALL, SPACE , UAE – this will save you from manually removing them within Timetabler later
In Infosilem Timetabler navigate to Import. File -> Import. Make sure the "Select File Type(s)” are Space-delimited (TXT).
The Keep in EnCampus Suite records that do not exist in the source files (Do not delete) is checked. Then click “Next”
...
...
Select Clear and select the following files: 18 of them
...
Click on Next and Browse and point to DCU folder on desktop. Click on Set All and Same Folder as Selected then select Next.
...
| Expand | ||
|---|---|---|
| ||
The “open Rejected Records Report” will have some errors these are courses with time/days on their deliveries and it’s telling you the “dates” are incorrect – but we delete anything in the database with days/times/rooms on it. We clean it up later and is okay to ignore.   |
| Note |
|---|
You will get rejects here. Open up the “source”.txt file on the O drive and see if you can plainly see what's missing (say a start date) if it's a forced pattern move on. otherwise dig further and check that the files were pointing to the correct ones. Timereq was pointing to Delivtimes - but I think I clicked it incorrectly - so pay attention and don't do that! |
...
| Expand | ||
|---|---|---|
| ||
Timereq errors - these are forced times and dates that no longer are in the system
LocSpec errors - the building either has changed or didn’t get attached correctly - this is again fine as we delete everything with a room attached anyways CompChar - these are the course characteristics - we deleted them above, so it makes sense that we have errors for it!  |
| Info |
|---|
delivtimes = delivery times that are forced Timereq = delivery pattern requests those two combined make the timetable |
...