Skip to main content

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 Benutzerexpand 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 are to be imported.
      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?
      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-company module, no decision queries will appear. The default setting is "Other country".
      Example: Your company is close to the French border and is directly affected by French public holidays. Decide to import French public holidays (in the respective national language if necessary).
      - Which language should be imported?
      - Which country should be imported?
      - Welches Bundesland soll importiert werden?
      - Which period should be imported?
      - Should the event name be written in the foreign language?
    3. A data maintenance list opens.
      Note: Tables with a grey background are excluded from changes. If necessary, make changes in the column for the federal state (white background).
    4. To exclude individual rows from the import, remove the tick in the first column.
    5. To import the data, click on save Saveat the top left.