Skip to main content

Importing public holidays/special events

Importing public holidays/special events

Previously, public holidays for Germany could be created annually using the Holidays/Special Events moduleM. As of version 12.1R12, public holidays can be imported across countries and in multiple languages. The public holidays are imported from an external source, OpenHolidays API https://www.openholidaysapi.org/de/, using a data maintenance list. The user can therefore still make individual decisions during import.

  • Load the scenario

    Once your database has been updated to a current version (at least 12.1p25), you can load the integrated e-invoice scenario yourself.

    1. Log in to the database as Administrator.
    2. Go to the Administration  Administration tab in the function bar and select Administrationexpand Settings > Administration  General settings > Lizenzen Licences.
    3. Tick Import public holidays from www.openholidays.org.
    4. Speichern Save your input by clicking on the icon in the top left-hand corner of the input window.
    5. Click on Actions > Load Bp scenarios now > Load without enforcing.
    6. speichern schliessenSave your input by clicking on the icon in the top left-hand corner of the input window.
  • Authorise users to import events
    1. Go to the Administration Administration tab in the function bar and select Usersexpand Users > Benutzer User Groups
    2. Open the user group ER_Import.
    3. Go to the Benutzer Users/Groups tab and neu Add the users or groups that you want to authorise for importing holidays/events in future.
    4. speichern schliessen Save and close the authorisation.
  • Import public holidays/special events
    1. Go to the Einrichtung  Configurations tab in the function bar and select Ereignis Holidays/Special Events > import  Import > Ereignis ER_Import-Feiertage.
    2. Determine which public holidays to import.
      a) Company (Multi-Companies module)M
      Example: Your corporation has sites in Germany, Belgium and Switzerland. Determine which holidays should be imported per country.
      - Which company?
      - Which language?
      Note: only if the country code is not "DE". The language is taken from the country setting mapping ISO country code (Alpha-2).
      - Which date range to import
      Note: If there are several companies with the same country setting, apply your selction to all of them by confirming the message "There are several companies in the same country. Do you want to copy the events to other companies?" by clicking Yes and ok  Confirm for the selected companies.

      b) Other country
      Note: Without the Multi-companies module, no queries will appear. The default setting is "Other country".
      Example: Your company is located close to the French border and is directly affected by French public holidays. You might want to import French public holidays (in the respective national language if necessary).
      - which language to import
      - which country to import
      - which federal state to import
      - which date range to import
      - which language to use for the name of the special event
    3. A data maintenance list will open.
      Note: Tables with a grey background are excluded from changes. If necessary, make changes in the column per federal state (white background).
    4. To exclude individual rows from the import, remove the tick in the first column.
    5. To import data, click on save Save in the top left-hand corner.