...
Creating Files to upload Orientation Bookings or Exams
| Expand | ||
|---|---|---|
| ||
If you’re getting this error:  the csv file that’s being sent to us has a hidden character that’s appearing in it, here’s how to get rid of it and see if it’s actually there. Once you get the file in from the orientation office or the bookings office, open it with Ultra Edit and then view it in Hex mode.   you’ll want to go to File the Save as and in stead of “Default” for encoding choose “ANSI/ASCII”    sneaky characters gone!! 💃 |
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\Systems\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 hhHH:mm 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 hhHH:mmMM
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 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
...
File Type should be Character Delimited Values and, in the box next to it, that’s a comma.
Place a copy of the files on the desktop of the Campus Admin client you’re using, in a folder called “Reservations”. Search for the files and you should only have booked rooms checked – reservations, event management and scheduling they will get auto checked – but make sure. The top default file path is where the reservations.txt file is and the second on is where the booked rooms file is.
Then Click “Import”
...
If there are reject check the transfer log and see what went wrong, it’s usually a room has been mislabeled, or there’s a weird time and date. Otherwise check to ensure everything came in correctly. You can upload the same files again until everything has come in without errors – it doesn’t create extra bookings or conflicts (thankfully!)
...
Then close.