Amazon Connect is set up to run an AWS Lambda function to dynamically notify callers of any University holidays that fall outside of our normal closed hours. To do this, Lambda will need to read a specifically named and structured .csv file to determine which days during the fiscal year or long semester are holidays. The below instructions will detail the creation 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: 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
- Lambda will discard the first row from this
.csv, so remember to include these headers
- In the "Holidays" column, enter in each of the scheduled holiday dates
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. 
|
- 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. | Note |
|---|
Connect 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, 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.
|