Introducing a new Customer Center experience Learn more

How do I update the public holidays (red letter days) in SuperOffice CRM diary?

I cannot see some of the public holidays in my SuperOffice diary. How do I include some celebrations and national days that do not appear in the diary now?

SuperOffice Online and SuperOffice Onsite starting from version 8.5 R11 have all official "red" days of the 23 supported countries up to 2030.

Note! These are the 23 supported countries:

  • Belgium (BE) (Dutch)
  • Sri Lanka (SL) (English) (only had access for 2020-2022)
  • Czechia (CZ)
  • Denmark (DA)
  • Finland (FI)
  • Germany (DE)
  • Lithuania (LT)
  • Netherlands (the) (NL)
  • Norway (NO)
  • Russian Federation (the) (RU)
  • Spain (SP)
  • Sweden (SE)
  • Switzerland (CH) (German)
  • United Kingdom of Great Britain and Northern Ireland (the) (UK)
  • United States of America (the) (US) 
  • Austria (AT) (German)
  • China (CN)
  • France (FR)
  • Ireland (IE)
  • Italy (IT)
  • Japan (JP)
  • Poland (PL)
  • Ukraine (UA)

 

It is possible to update the predefined list of holidays by following the instructions in the sections below:

  • Please click here if you want to update the red day list in SuperOffice CRM Onsite
     
  • Please click here if you want to update the red day list in SuperOffice Service



​

Update the red day list in SuperOffice CRM Onsite

If you need to include some other days or if you want to get an updated list of the red days, but you cannot upgrade it is possible to import them manually into your SuperOffice CRM. To do it please follow the steps below:

  1. Update the file with your red days or download this file.
     
  2. Move the file with the updated red days to the SuperOffice server installation Init folder. Replace the old I_RLDay.imp​ file with the one you have created or downloaded.


     
  3. Make sure that the SoTables.ini (2) file can be found in SuperOffice\Server (1) folder and that it has a section [UpdateRedLetterDays] AA=C:\program files\superoffice\server\Init\I_RLDay.imp (3).


     
  4. Start DBSetup.exe, select Load or re-load the initial data (1) from the drop-down list select the UpdateRedLetterDays (3) then the correct ODBC source as Target Database (3) and click Start (4). This will truncate the existing red letter days from the database table and import the new values. That means that all the holidays/red days that might have been added manually before will be deleted and they will be not added again if they do not exist in the new file.

Note!

1. SuperOffice version 8.1 and higher use a continuous database development method, which uses a different approach for importing .imp files. We recommend contacting a SuperOffice consultant or partner if you need to make a change to the SuperOffice database. The consultant service involves a fee.

2. We performing a backup before making any change directly in the database. This FAQ explains how to do it.
 

​

Update the red day list in SuperOffice Service

If you want to include or update the red days in SuperOffice Service, please follow the steps below:

  1. Click on the  button then Priorities (1) and double-click on the priority (2) that you want to adjust.


     
  2. Click on the Time frame (1) tab and in the field of Holidays (day/month) (2) include the days that SuperOffice Service would treat as holidays. Click Ok (3) to save it.


     
  3. Repeat the same steps on other priorities if you need to update the whole SuperOffice Service solution.

 

Note! Which Red letter days will be visible in a user's Diary depends on the User or System Preference Current home country. When user changes the home country preference she needs to log out from SuperOffice and log in again to see the change in the Diary.


More information:

Article: Data dictionary

Forum: Import/update .zip with a .imp-file