import calendar data (leaves, holidays) via SQL into SD+
Hello
1)
I would like to import (on a daily basis via scheduler) calendar data via SQL into SD+.
The idea behind is to export agenda data (like holidays, absence, training, shifts, ...) from our groupware system and to import this data into SD+ in order to have
a) a synchronisation (one-directional, unsynchrone) with our group agenda
b) to be able to make a better planning in SD+
Which table(s) do I have to update in the servicedeskplus database? Could anyone give me some help on the corresponding SQL statement?
2)
on a long term, it could eventually be useful for manageenine to create an interface for importing such agenda data (like .ics files or other standard formats). Does anybody share my opinion?
Thanks a lot
Marc
1)
I would like to import (on a daily basis via scheduler) calendar data via SQL into SD+.
The idea behind is to export agenda data (like holidays, absence, training, shifts, ...) from our groupware system and to import this data into SD+ in order to have
a) a synchronisation (one-directional, unsynchrone) with our group agenda
b) to be able to make a better planning in SD+
Which table(s) do I have to update in the servicedeskplus database? Could anyone give me some help on the corresponding SQL statement?
2)
on a long term, it could eventually be useful for manageenine to create an interface for importing such agenda data (like .ics files or other standard formats). Does anybody share my opinion?
Thanks a lot
Marc