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_CATLG_ORGS_GROUPS_NP – Manually scroll through list and ensure that for the subject the Acad Org and Group are the same through the list – if different contact catalog person in either Grad or UG to have them fix it
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 |
...
The Delete records from Academic Suite if they are not found in the source file should be Checked (differential). Click Select Next
...
Select Clear and then select the following file: Courses Click on
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, click on select Next, check the rejected records on this next report.
...
...
If If everything is ok, click Next.
...
Keep the Backup option selected (because why not)
Check and select Import
Check the reports and when everything is ok click ImportDone.
the first report is checking the format (is it space delimited?)
the next report is checking the content (the hierarchy of the faculty, department all that jazz)
...
The Keep in EnCampus Suite records that do not exist in the source files (Do not delete) is checked. Then click “Next”
...
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 click select Next.
...
Check the Report for any problems. If everything is ok, click on 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 |
...
When the Import is complete. Click “Done”
...
In the database use rollover delete and advanced to delete deliveries:
any deliveries associated with a TST slot
any deliveries with no time or no room request (Status red top/bottom)
Getting rid of any deliveries that have forced times and/or rooms.
any deliveries with a forced time (Status has a green bottom)
any deliveries with forced room and no time
(green top red bottom)
any deliveries with forced room and
time request (green top
white bottom)
any deliveries with forced
Must change blockoff dates and remove all instructors from any blockoffs that aren't their names only
...
room and time (complete green)
In the new term (Secondary Files → Terms) change the start and end dates to the actual first and last day of the term.
Ensure all scheduling groups are activated - : Tools > → Scheduling Groups Activation> Activation → Component Groups. Select all and Save to activate
Make sure course combinations are enabled and the academic block type should be "to spread things out"
Change registrar owned rooms to REG. If accounting prefers, add a Pavilion of HHA and change the appropriate Accounting rooms to HHA. Change BMH and REN rooms as requested by the reps activate.
Must change blockoff dates and remove all instructors from any blockoffs that aren't their names only
Make sure Instructors do not have any constraints overridden (checkbox) If necessary, add electronic room and DOC camera as characteristics to appropriate REG rooms. Combine blackboard and whiteboard characteristics into 1. We keep them separate due to allergies.
DCU Admin Setup
The procedure is called Academic Suite - Opening DCU and Message Board Examples
https://isacadweb.nexus.uwaterloo.ca/DCU/Admin/
Room Assets should be in this format (no headers):
...
BLDG NBR
...
Bldg Short
...
Bldg Long
...
Floor
...
Room Number
...
Asset Standard Code
...
Asset Standard Name
...
032A
...
AHS
...
Applied Health Sciences
...
1
...
2677
...
AT-01
...
Whiteboard
...
9
...
AL
...
Arts Lecture Hall
...
1
...
6
...
AT-01
...
No Tablet Armchairs
...
...
...
...
...
...
Note: this arbitrary but required - can all be the same - in this format
...
...
Navigating to Text File locations in Quest:
Waterloo Student Admin > → CEM > → Setup > → Text File Columns
...
Characteristics should be in this format (no headers):
...
...
Column A (Asset standard code ?)
...
Asset Standard Name
...
AT-01
...
Blackboard
...
AT-01
...
Data Projector
...
...
...
Note: this arbitrary but required - can all be the same - in this format
...
This is important during an upgrade and there’s been a change to the text files, other changes need to be made to the setup tables by IST and the Quest team as well.