Content Comparison

...

• For these bookings, we book everything before the start of the Fall term in RO rooms.

• We hold off on any bookings that are going to take place during the term until after the Fall courses have been moved into Campus. There’s no need to wait for the Midterm queue to be processed, orientation usually takes priority due to number of students and it’s a Presidentially backed event.

• All outside spaces and foyer/common areas that Central Stores is responsible for can be booked upon receipt.

• Key requests to make RO managed rooms lockable during Orientation - head here for more details: Requesting Key Control services (revisions happening May 2024)

Creating Files to upload Orientation Bookings or Exams

...

1. Place the CSV file (received from Annette for exams and Jamie for Orientation) in the format required into the appropriate folder on the R drive (“R:\Scheduling\Enterprise Reservation ScriptsCampus Script\Bookings or Exam”). There should be an example of the file format in the “Scripts” “Reservations” folder. The name of the file should not have spaces – use underscores.

2. Using ultraedit open up the csv file and ensure the time is HH:MM (09:00) and the date is YYYY-MM-DD (with the dashes)

3. If you open the .csv in excel you’ll have to fix the formatting of the E and F columns (the times) make it a custom format of HH:MM

4. Ensure that there’s no commas in between section numbers (example: ACTSC 372 LEC 001, 002) it will throw it into a new column and make no sense in the transfer.

5. Delete the Reservation and Reservation_bookedRoom.txt files if they exist in the “Exam” folder

6. *Please note * the script (called add_Finals.pl) hard codes the name/description to Winter Exams – you need to change this in the file!!!!

7. From your PC search bar type CMD. Click on Command Prompt.  Type R: (enter) then

8. cd scheduling\Enterprise Reservation ScriptsCampus Script

9. If for exams type “cd exam” (or tab to find the folder name) then enter. Then press tab until “add_Finals.pl” then a space then “<” space and tab again until the file name is there “f19_2.csv”. hit enter

10. Once entered it should appear as R:\Scheduling\Enterprise Reservation ScriptsCampus Script\Exam>add_Finals.pl < test_training.csv

11. *Used for Orientation only (frosh week) If for orientation type \Bookings (or tab to find the folder name) add_bookings.pl < ori_final2.csv

...

Expand
title File directory mapping
Fall Final Exams,Fall Final Exams,Fall Final Exams,Final Exams,20191206-1,Scheduled Only,0,20191206,20191206,0,,09:00,11:30,,,,Final Exams,AFM 462 ,,,1,,1,SO,00:10,00:10,,, K:\sisp\Infosilem-downloads (pick which ever you’ve installed – the most current install version) {K:\sisp\Infosilem-downloads\unZip\Enterprise2018Campus_23.1_.0.152\Documentation\English\Integration Guides\Text Files   In the document this is referring to Scheduling - Event management then looking for the Reservation.txt Text file name} Event Id, EventType, ActivityID, ActivityType, ReservationID, ReservationType, Number of attendees, Start date, end Date, recurrence type, Reservation description is the course (MATH136)

...