...
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 Scripts\Bookings or Exam”). There should be an example of the file format in the “Scripts” folder. The name of the file should not have spaces – use underscores.
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)
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
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.
Delete the Reservation and Reservation_bookedRoom.txt files if they exist in the “Exam” folder
*Please note * the script (called add_Finals.pl) hard codes the name/description to Winter Exams – you need to change this in the file!!!!
From your PC search bar type CMD. Click on Command Prompt. Type R: (enter) then
cd scheduling\Enterprise Reservation Scripts
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
Once entered it should appear as R:\Scheduling\Enterprise Reservation Scripts\Exam>add_Finals.pl < test_training.csv
*Used for Orientation only (frosh week) If for orientation type \Bookings (or tab to find the folder name) add_bookings.pl < ori_final2.csv
...