commit e083c8102632f0b1c00ea673d945065a46b4bfcd
parent dc323b7eaa042b42558fc98f1c6b6317e9fc1191
Author: breadcat <breadcat@users.noreply.github.com>
Date: Thu, 13 Aug 2026 17:23:21 +0100
Current iteration of this script
Diffstat:
1 file changed, 249 insertions(+), 0 deletions(-)
diff --git a/content/posts/webex-bulk-uk-bank-holidays.md b/content/posts/webex-bulk-uk-bank-holidays.md
@@ -0,0 +1,249 @@
+---
+title: "Webex bulk UK bank holidays generator"
+date: 2026-08-13T12:59:00
+tags: ["Downloads", "Tools", "Work"]
+---
+
+For pretty much every Webex site I build I end up manually adding [UK bank holiday dates](https://www.gov.uk/bank-holidays), this page generates that list (up until 2028). Just fill in the Location name, click download, then upload them via `Management > Locations > Location Name > Calling > Calling features settings > Schedules > Bulk Manage > Upload .csv data`.
+
+If you want to build your own, check out the source code and the dates are defined in an ISO-8601 const block.
+
+<label for="location">Location</label>
+<input type="text" id="location" placeholder="Enter location" >
+<button id="generateButton">Download CSV</button>
+
+<div id="status"></div>
+
+<script>
+
+ /* Bank holiday dates in ISO-8601 standard */
+ const bankHolidayDates = [
+ "2026-08-31",
+ "2026-12-25",
+ "2026-12-28",
+ "2027-01-01",
+ "2027-03-26",
+ "2027-03-29",
+ "2027-05-03",
+ "2027-05-31",
+ "2027-08-30",
+ "2027-12-27",
+ "2027-12-28",
+ "2028-01-03",
+ "2028-04-14",
+ "2028-04-17",
+ "2028-05-01",
+ "2028-05-29",
+ "2028-08-28",
+ "2028-12-25",
+ "2028-12-26"
+ ];
+
+
+ /* CSV Headers */
+ const headers = [
+ "Name",
+ "Location",
+ "Schedule action",
+ "Schedule type",
+ "Event action"
+ ];
+
+
+ // Add the 10 event groups.
+ for (let i = 1; i <= 10; i++) {
+
+ headers.push(
+ `Event ${i} name`,
+ `Event ${i} start date`,
+ `Event ${i} end date`,
+ `Event ${i} start HOLIDAY`,
+ `Event ${i} end HOLIDAY`,
+ `Event ${i} recurrence type`,
+ `Event ${i} day of recurrence by week`,
+ `Event ${i} day of yearly recurrence by day`,
+ `Event ${i} week of yearly recurrence by day`,
+ `Event ${i} month of yearly recurrence by day`,
+ `Event ${i} date of yearly recurrence by date`,
+ `Event ${i} month of yearly recurrence by date`
+ );
+ }
+
+ function isoToAmericanDate(isoDate) {
+
+ const [year, month, day] = isoDate.split("-");
+
+ return `${month}/${day}/${year}`;
+ }
+
+ function csvEscape(value) {
+
+ if (value === null || value === undefined) {
+ return "";
+ }
+
+ const text = String(value);
+
+ if (
+ text.includes(",") ||
+ text.includes('"') ||
+ text.includes("\n") ||
+ text.includes("\r")
+ ) {
+ return `"${text.replace(/"/g, '""')}"`;
+ }
+
+ return text;
+ }
+
+
+ /* Create event 1 CSV */
+
+ function createRow(location, isoDate) {
+
+ const americanDate =
+ isoToAmericanDate(isoDate);
+
+ const row = [
+
+ // Event 1
+ "Bank Holidays",
+ location,
+ "ADD",
+ "HOLIDAY",
+ "ADD",
+
+ isoDate, // Event 1 name
+ americanDate, // Event 1 start date
+ americanDate, // Event 1 end date
+ "12:00", // Event 1 start HOLIDAY
+ "14:00", // Event 1 end HOLIDAY
+ "NONE", // Event 1 recurrence type
+ "", // Event 1 day of recurrence by week
+ "", // Event 1 day of yearly recurrence by day
+ "", // Event 1 week of yearly recurrence by day
+ "", // Event 1 month of yearly recurrence by day
+ "", // Event 1 date of yearly recurrence by date
+ "" // Event 1 month of yearly recurrence by date
+ ];
+
+
+ // Events 2–10
+ for (let i = 2; i <= 10; i++) {
+
+ for (let field = 0; field < 12; field++) {
+ row.push("");
+ }
+ }
+
+
+ return row;
+ }
+
+ function generateCSV(location) {
+
+ const rows = [];
+
+ rows.push(headers);
+ for (const isoDate of bankHolidayDates) {
+
+ rows.push(
+ createRow(location, isoDate)
+ );
+ }
+
+ return rows
+ .map(row =>
+ row
+ .map(csvEscape)
+ .join(",")
+ )
+ .join("\r\n");
+ }
+
+ function downloadCSV(csv, location) {
+
+ const blob = new Blob(
+ ["\uFEFF" + csv],
+ {
+ type: "text/csv;charset=utf-8;"
+ }
+ );
+
+ const url =
+ URL.createObjectURL(blob);
+
+ const link =
+ document.createElement("a");
+
+ link.href = url;
+
+ // Clean location for filename.
+ let filename =
+ location
+ .trim()
+ .replace(/[^a-z0-9]+/gi, "_")
+ .replace(/^_+|_+$/g, "");
+
+ if (!filename) {
+ filename = "Location";
+ }
+
+ link.download =
+ `Bank_Holidays_${filename}.csv`;
+
+ document.body.appendChild(link);
+
+ link.click();
+
+ document.body.removeChild(link);
+
+ URL.revokeObjectURL(url);
+ }
+
+ document
+ .getElementById("generateButton")
+ .addEventListener("click", function () {
+
+ const location =
+ document
+ .getElementById("location")
+ .value
+ .trim();
+
+ const status =
+ document.getElementById("status");
+
+
+ if (!location) {
+
+ status.style.display = "block";
+ status.style.background = "#fff0f0";
+ status.style.color = "#8a1f1f";
+
+ status.textContent =
+ "Please enter a Location.";
+
+ return;
+ }
+
+
+ const csv =
+ generateCSV(location);
+
+
+ downloadCSV(
+ csv,
+ location
+ );
+
+ status.style.display = "block";
+ status.style.background = "#eef8ee";
+ status.style.color = "#276327";
+
+ status.textContent =
+ `CSV generated successfully for "${location}". ` +
+ `${bankHolidayDates.length} holiday rows created.`;
+ });
+
+</script>
