When uploading permanent reservations through the DMU be sure to download a new ADD RESERVATION template from the DMU. Add the reservations for the necessary users that will receive permanent spaces. When creating permanent reservations, the start time and end time should be formatted correctly.
Formatting Start and End Time Cells
Start by highlighting all the cells under “Start Time” & “End Time” columns. Then right-click the highlighted cells and select “Format Cells” in the pop-up menu.
Then select “Text"
Date and Time
Type in the date and time. The correct format for the date and time should be as follows:
Ex: yyyy-MM-dd hh:mm
Time should be in 24hr military format. Start Time should occur a day after the upload. If you upload on 2021-10-12, then the start time should occur the day after: 2021-10-13 08:00. A permanent/no-end-date reservation MUST have the year "2999" for the "End Time" column. Furthermore, the time for "End Time" MUST be on the last minute of the hour in order to upload successfully.
Ex: 2999-12-31 15:59
Here is a screen shot for both Start Time and End Time format.
Comments
0 comments
Please sign in to leave a comment.