Amazon Connect can leverage is set up to run an AWS Lambda function to dynamically notify callers of any current UT University holidays that fall outside of our normal closed hours. AWS To do this, Lambda will need to read a specifically named and structured .csv file in order to determine which days during the fiscal year or long semester are holidays. The below instructions will detail the creation and upload of this file and the upload process so that this functionality can be used. - Obtain a list of upcoming University holidays. You can find UT System's holiday schedule here.
- Launch Microsoft Excel, or your preferred spreadsheet program
- Please note, the below : these instructions will only detail the process in Excel, though the process should not differ too much in other tools.
- Create two columns, with headers "Holidays" and "Name" respectively
- These are mostly here for human-readable benefit; Lambda will strip discard the first row and discard these headers, but they're useful for keeping organized!from this
.csv , so remember to include these headers
- In the "Holidays" column, enter in each of the scheduled holiday dates
Warning |
---|
title | Expected Date Formatting |
---|
| Excel will attempt to automatically reformat your dates to whatever your default date format is. Normally, this is the DD/MM/YYYY format for US/English computers and devices. However, Lambda will be expecting these dates in ISO 8601 format, e.g., "1976-07-04". Please be sure to select the dates you entered and set the formatting (using the "Format Cells" dialog) to the required format, as shown here: Image Removed Formatting can be specified after all dates have been entered. |
Lambda will be able to interpret MM/DD/YY, DD/MM/YY, or ISO 8601 date formats If Lambda does not properly interpret a given date, please alter its formatting to fit ISO 8601 Info |
---|
| When you have entered in all the needed dates, you may wish to specify their formatting. Specifically, you may wish to change the format to ISO 8601, as shown below. Image Added |
- In the "Name" column, enter in the name of the holiday
Please note, UT System uses "Winter Holiday" to refer to the holiday time granted between Fall and Spring semesters, not including Christmas Eve, Christmas Day, Day After Christmas, and New Year's Day. This field should be considered required, as the text-to-speech system expects to be able to read this value back as part of its script with the caller. This may not be the case in future versions, but is status quo as of 2020-05-29Connect will read the holiday name out to the caller via text-to-speech. This field should be provided, if possible, so that Connect can give specific information. If no name is provided for a holiday, Connect will instead say "a university holiday". |
- When you have confirmed that the data entry is complete and properly formatted, you can proceed to save the file as a
.csv file with the filename, holidays.csv
- Please be sure to select "CSV (Comma delimited) (*.csv)", rather than any of the other available
.csv formats. The other formats add extraneous information that is not necessary and may not work properly with Lambda.
- Upload your
holidays.csv file to our AWS S3 bucket so that Lambda can interact with it during each call- You can visit this link to be taken directly to the appropriate S3 bucket
- Alternatively, you can navigate to AWS, select the S3 service, and open the
laitscc bucket, navigating to laitscc/connect/laits
- Click "Upload", then drag and drop your
holidays.csv file or browse to it using the dialog box - Click the "Upload" button in the lower-left corner of the dialog box. You'll receive a confirmation message when the upload is complete.
|