Importing the holidays will update the Service Hours and Holidays section in the Octopus options of a team.
This section is particularly important when the Service Level Agreement (SLA) option is enabled. Because public holidays are then considered as outside the service hours of the service in the SLA calculations.
Links to articles related to importing and configuring the XML file:
- XML configuration file
- Back to main page for DataImporter
- Back to the Import Source Specification list
Available fields to Import Holidays
- Description - Text (100)
- Name of the holiday.
- Note that the name of the holiday is not visible outside the option's window.
- Date - Date and Time
- Date of the holiday.
- The format of the date must be compatible with the Octopus server settings, YYYY-MM-DD.
Configuration File Content (Holidays.xml)
The declaration of the source is done by indicating the Holiday value in the <Content> tag.
<?xml version="1.0" encoding="utf-8" ?> <Sources> <Source Name="Holidays"> <ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Import\Holidays.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";</ConnectionString> <ViewName>[Holidays$]</ViewName> <Content>Holiday</Content> <!-- Additional tags --> </Source> </Sources>
To explain the tags used in all types and to find out more about the types of files, please refer to the XML Configuration File article.
Thank you, your message has been sent.