+- Logic Machine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: General (https://forum.logicmachine.net/forumdisplay.php?fid=2)
+--- Thread: Holidays synchronisation (/showthread.php?tid=971)
Holidays synchronisation - Thomas - 30.08.2017
Hi
I want the only one place where holidays are stored. And this place is our ERP. Is there a way how to synchronise holidays from an ERP to LM? Is it possible to do it via JSON, XML etc?
Thank you.
RE: Holidays synchronisation - admin - 04.09.2017
This can be only done via direct DB queries. Can you get holiday list in JSON format from your ERP via HTTP?
RE: Holidays synchronisation - Thomas - 11.09.2017
(04.09.2017, 08:27)admin Wrote: This can be only done via direct DB queries. Can you get holiday list in JSON format from your ERP via HTTP?
Hi,
yes, it's not problem.
RE: Holidays synchronisation - andrepneves@gmail.com - 02.04.2019
(04.09.2017, 08:27)admin Wrote: This can be only done via direct DB queries. Can you get holiday list in JSON format from your ERP via HTTP?
Hi,
Can you post an example of this?
Thank you.
BR,
André Neves
RE: Holidays synchronisation - Thomas - 14.04.2020
Hi
the problem is back.
I can develop an interface which transforms ERP records to ANY format and service. Please, how to synchronize public holidays?
Thank you
RE: Holidays synchronisation - admin - 15.04.2020
Only via direct db queries at the moment.
Here's table structure:
Code:
scheduler_holidays
type
Holiday type (string): empty string = Specific date, "dayweeknr" = Day of the week
name
Holiday name (string)
year
Holiday year (integer): 0 = Recurring every year
month
Holiday month (integer)
day INTEGER
Holiday day of the month (integer, only for Specific date type)
dayofweek INTEGER
Day of the week (integer, only for Day of the week type): 1 = Monday, 7 = Sunday
dayweeknr INTEGER
Day of the week number in month (integer, only for Day of the week type): 1 = 1st, 5 = 5th, 6 = Last
duration
Holiday duration in days (integer)