After the schedule has been created and the reps have had time to make any last minutes edits this is the process and procedure to move the course information from Timetabler to Quest.
...
Compare differences between real sections/topic # appearing in Quest and those appearing in Timetabler (The excel that you’ll get from Quest you’ll need to concatenate the subject||Catalog_NBR||topic ID to get them the same as the courses from Timetabler) From Timetabler you’ll just go to the courses level in Timetabler, and simply pull the list of courses directly from there. Need to remove duplicates and sort then do an EXACT function in Excel [example: =EXACT(A2,B2)] (UW_RS_SCH_CRSES_OFFRD_SB)
Compare scheduling groups from timetable (HWDR and HELD) to Quest and ensure they match and we aren’t missing one from each side. Grab a list of the component heldwiths from Timetabler paste it into excel, and run this query: UW_RS_SCTN_CMBN_TOTALS_SB in Quest and use “=EXACT” to find the odd ones out.
Finding who enrolled students into real sections before all the course information has been uploaded so they can remove the students (excludes COOP/WKRPT) (UW_RS_SCH_REAL_ENRL_CHECK_JV)
Run queries to ensure that all the necessary tables are blank:
UW_RS_CLASS_MTG_PAT_NO_ROWS_SB
UW_RS_CLASS_INSTR_NO_ROWS_SB
UW_RS_CLAS_EVNT_NBR_NOBLANK_SB
Infosilem Work:
Once the task document work has been finished and a back up has been taken then you can start the upload.
...
ACCDB staging file path: C:\Infosilem\AcademicSuite\1415.10\Transfer\Timetabler\Export\Target\TimetablerExport.accdb
...
Click on export. When export is complete view report to ensure there are no errors then click Close. Not looking for specific numbers in the report, just making sure there’s information and results.
...
Navigate to “O“M:\Timetabler\Export\Target”
Select the 7 files and copy to:
...
R: > Records and Systems > Timetabler > appropriate term folder (with the removal of R drive this is no longer required)
Q:\k2-up\prod\incoming (if testing move to *Q:\oz-up\qa\incoming* tentative path may change and changes for each instance. Heads up the files will disappear and be transferred into the cloud…but then you can view what’s been uploaded in Q:\ozark\qa\incoming (back on premises) so if you have to make changes to the .txt files make them there BUT you have to move it back into Q:\oz-up\dev\incoming for it to go back into the cloud – which is where the upload is pulling from *like a triangle*) Can also check it in Quest → Waterloo Students Admin → Utilities → Inquire → Cloud Sync Utilities
Do this all within the VDI so it makes the file transfer faster.
...
Run Queries to ensure there’s no bad data in Quest:
UW_RS_INSTR_MISS_MTG_PAT_NP
RT #1080936 - if you get results for this query - use this RT as an example
RT #1164199 - in 1219 - 54 rows!
RT #1164199 – another example
Buffer error without an integration SISP-242 (RT #1190284) (
)Jira Legacy server System Jira serverId 2174d23a-1c18-3dfb-9a53-87620f8159d6 key SISP-242 Jira Legacy server System Jira serverId 2174d23a-1c18-3dfb-9a53-87620f8159d6 key SISP-867
UW_RS_SCH_STIME_GT_ETIME_NP
start time is greater than end time (times are messed up!)
UW_RS_SCH_SCTN_CMB_DIFF_DT_NP
for this query you will have to manually look to see if there are mismatched start dates or end dates to know if there are different dates
UW_RS_SINGLE_DAY_GT1_DAY_PAT_N
UW_RS_MISMATCH_PATTERN_DAYS_NP
| Info |
|---|
Let Isaac Morland know that the schedule of classes has been updated |
...
Log into the Campus Admin with “super”your own account
Add term:
o Management → Academic Calendar → Academic Terms
...
By using this Jira (Records Support - Quest), have the systems team to change the term on the run controls while logged in as sarecord “Enterprise_Next“, “Enterprise_Current” and “Enterprise_Past” accordingly
...
To find instructors attached to courses that are not in their approved subject lists in the instructor/advisor table (their teachables) UW_RS_SCH_NO_SUBJ_INSTR_TBL_NP
To find instructors that were added to only one side of the held with, manually scroll through the list and ensure that each of the held with courses have the same instructors attached: UW_SCH_MISMATCH_DELIV
To ensure that the correct flags are checked on for REG rooms - all facility ID’s (except ONLINE room) is checked on, and only RO rooms are checked on for general assignment. UW_RS_SCH_FAC_NO_CNFL_SB
| Expand | ||
|---|---|---|
| ||
|
...