...
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! Well apparently not always, if the Acad Org has changed, that you can make a manual change on the Basic Data Panel under maintain Schedule of Classes (this is usually found and fixed after running this tedious query: UW_RS_CATLG_ORGS_GROUPS_NP and systems has time to fix it)
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 |
...
run control: timetabler_extract
Upcoming term gets entered and previous like term
Evening start time is 4:00PM (16:00)
filepath: /software/sa.sisp-1.0_prod/spool/outgoing/DCU/
When running in a test environment “/software/sa.sisp-1.0_dev/spool/outgoing/DCU/”
The highlighted text above changes depending on the SISP test site you’re using (Eg. CSTS it should be “test”, not “dev”)
Run the PS Job (UWTPINTT)
The order the processes run are:
UWTPINEX = Timetabler Course Extract
UWTPINSE = timetabler extract setup - set up files
UWTPINST = Timetabler Extract Student - we don't use students - but it might contain programs
UWTPINCP - Timetabler extract conversion
...
Q: > k2 > PROD > outgoing
Test would be “Q:\ozark\dev\outgoing”
Should save a copy of the DCU folder on the O M drive "OM:\Timetabler\Import" (it should have todays date and replace the last DCU folder)
...
Keep the Backup option selected (because why not) and and select Import
...
| Expand | ||
|---|---|---|
| ||
|
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 (OM:\Timetabler\Import\DCU)
In Infosilem Timetabler navigate to Import. File -> Import. Make sure the "Select File Type(s)” are Space-delimited (TXT).
The Keep in EnCampus Infosilem Academic Suite records that do not exist in the source files (Do not delete) is checked. Then click “Next”
...
| Note |
|---|
Infosilem advised us to not download room types, pavilions, campus so if there are any new rooms etc we know we need to add alternates etc because it will come out as an error. |
Click Click on Next and Browse and point to DCU folder on desktopserver. 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 M 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 |
...
In the Timetabler database use “Tools” then “RollOver” then “Delete…” and “Advanced” to “Select a data element:” then select “Deliveries”:
any deliveries associated with a TST slot
Keep fully white, and Red top/White bottom (anything green must go!)
any deliveries with no time or no room request (Status red top/bottom)
any deliveries with a room request and no time (white top/red bottom)
Getting rid of any deliveries that have forced times and/or rooms.
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 a forced time (Status has a green bottom)
any deliveries with forced room and time (complete green)
Run the Data Consistency Check of “Deliveries having room requests without specified Pavilion“ and batch edit all deliveries to remove the room requests that are blank (these are mostly WLU room requests, if they weren’t already removed by the white top/red bottom roll over delete)
...
Run the MyView of “Deliv Meth w Crs Char” and attach the delivery method that makes sense. If it’s ONLN with a time attach the delivery method of “Synchronous online” main campus' attach “in class”, ect. BLND is weird, so just make a judgement call!
Deactivate Reactive all the held withs , then re-activate them all to catch any that aren’t aligned with the same delivery information. Tools → Scheduling Groups Deactivation→ Component Groups
...
within the DCU for the reps
Tools → Scheduling Groups Activation → Component Groups
...