This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm that you accept these cookies being set.

Holidays synchronisation
#1
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.
LM5Lp, firmware: 2018.08.22 and 2021.12.15, FlashSYS v2, ARMv7 Processor rev 5 (v7l), kernel 4.4.151 and 4.4.259
Reply
#2
This can be only done via direct DB queries. Can you get holiday list in JSON format from your ERP via HTTP?
Reply
#3
(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.
LM5Lp, firmware: 2018.08.22 and 2021.12.15, FlashSYS v2, ARMv7 Processor rev 5 (v7l), kernel 4.4.151 and 4.4.259
Reply
#4
(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
Reply
#5
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
LM5Lp, firmware: 2018.08.22 and 2021.12.15, FlashSYS v2, ARMv7 Processor rev 5 (v7l), kernel 4.4.151 and 4.4.259
Reply
#6
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)
Reply


Forum Jump: