Helgdagar - hur automatisera inläggning ?

[Bamsefar]

Jag insåg just att jag inte får nya helgdagar registrerade automagiskt i SK - det var ju lite av en besvikelse, då de flesta faktiskt går att räkna fram...

Så hur kan jag få automagisk uppdatering av helgdagar att fungera ?
Eller kan man få t.ex. ett Excel gränssnitt så man kan exportera det från något lämpligt i *.csv format och läsa in detta i SK ?
Eller ännu hellre få helt automatisk beräkning av helgdagar:
http://www.sgv.m.se/nar-ar-du-fodd.htm

[Martin]

Eftersom varje användare kan lägga in egna helgdagar så är det lite vanskligt att skripta in dessa med automatik. För att lägga extra komplexitet med i bilden så är inte helgdagarna samma i alla länder där Switch King används (även om de flesta är det) - exempelvis nationaldagen...

"Fasta helgdagar" som exempelvis juldagarna är dock inlagda "för all framtid" eftersom de är inlagda som exempelvis "25:e december" istället för "2012-12-25".

Det är möjligt att skapa skript med helgdagar som kan läsas in via applikationen ServerGUI (som följer med i Switch Kings installationspaket) men vi har inte gjort några sådana skript. Det är vanliga SQL-satser som gäller - då vår tid måste prioriteras är det fritt för den som önskar att skapa skript och göra dessa tillgängliga för alla.

[Bamsefar]

Såhär då:

Code: Select all

INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Skärtorsdagen', 2013,3,28,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Långfredag', 2013,3,29,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskafton', 2013,3,20,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskdagen', 2013,3,31,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag påsk', 2013,4,1,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Kristi himmelsfärdsdag', 2013,5,9,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Pingstdagen', 2013,5,19,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag pingst', 2013,5,20,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommarafton', 2013,6,21,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommardagen', 2013,6,22,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Alla helgons dag', 2013,11,2,2);

INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Skärtorsdagen', 2014,4,17,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Långfredag', 2014,4,18,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskafton', 2014,4,9,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskdagen', 2014,4,20,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag påsk', 2014,4,21,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Kristi himmelsfärdsdag', 2014,5,29,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Pingstdagen', 2014,6,8,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag pingst', 2014,6,9,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommarafton', 2014,6,20,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommardagen', 2014,6,21,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Alla helgons dag', 2014,11,1,2);

INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Skärtorsdagen', 2015,4,2,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Långfredag', 2015,4,3,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskafton', 2015,4,25,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskdagen', 2015,4,5,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag påsk', 2015,4,6,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Kristi himmelsfärdsdag', 2015,5,14,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Pingstdagen', 2015,5,24,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag pingst', 2015,5,25,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommarafton', 2015,6,19,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommardagen', 2015,6,20,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Alla helgons dag', 2015,10,31,2);

INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Skärtorsdagen', 2016,3,24,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Långfredag', 2016,3,25,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskafton', 2016,3,16,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskdagen', 2016,3,27,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag påsk', 2016,3,28,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Kristi himmelsfärdsdag', 2016,5,5,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Pingstdagen', 2016,5,15,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag pingst', 2016,5,16,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommarafton', 2016,6,24,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommardagen', 2016,6,25,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Alla helgons dag', 2016,11,5,2);

INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Skärtorsdagen', 2017,4,13,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Långfredag', 2017,4,14,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskafton', 2017,4,5,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskdagen', 2017,4,16,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag påsk', 2017,4,17,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Kristi himmelsfärdsdag', 2017,5,25,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Pingstdagen', 2017,6,4,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag pingst', 2017,6,5,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommarafton', 2017,6,23,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommardagen', 2017,6,24,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Alla helgons dag', 2017,11,4,2);

INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Skärtorsdagen', 2018,3,29,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Långfredag', 2018,3,30,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskafton', 2018,3,21,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskdagen', 2018,4,1,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag påsk', 2018,4,2,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Kristi himmelsfärdsdag', 2018,5,10,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Pingstdagen', 2018,5,20,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag pingst', 2018,5,21,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommarafton', 2018,6,22,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommardagen', 2018,6,23,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Alla helgons dag', 2018,11,3,2);

INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Skärtorsdagen', 2019,4,18,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Långfredag', 2019,4,19,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskafton', 2019,4,10,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Påskdagen', 2019,4,21,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag påsk', 2019,4,22,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Kristi himmelsfärdsdag', 2019,5,30,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Pingstdagen', 2019,6,9,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Annandag pingst', 2019,6,10,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommarafton', 2019,6,21,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Midsommardagen', 2019,6,22,2);
INSERT INTO CalendarDateDefinitions
(CalendarDateDefinitionName, CalendarDateDefinitionYear, CalendarDateDefinitionMonth, CalendarDateDefinitionDay, CalendarDateDefinitionTypeOfDay)
VALUES
('Alla helgons dag', 2019,11,2,2);