Holidays synchronisation

[Thomas]

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.

[admin]

This can be only done via direct DB queries. Can you get holiday list in JSON format from your ERP via HTTP?

[Thomas]

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.

[andrepneves@gmail.com]

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

[Thomas]

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

[admin]

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)