Configure the SOR integration

To synchronize WorkZone contact data with data from Sundhedsvæsenets Organisations Register (SOR), you must first enable the SOR contact synchronization in WorkZone Configurator. By default, the SOR integration is disabled. Once it is enabled and configured, WorkZone contacts of the type H SOR unit will be synchronized with the latest update from SOR.

Prerequisite: You must be assigned the CONFIGADM access code.

  1. In WorkZone Configurator, go to Services > Contact synchronization > SOR tab.

  2. Turn on the SOR integration enabled setting.

  3. Select whether you want to force a full synchronization or run a daily synchronization, or both.

    Full synchronization

    The next update will perform a full synchronization.

    • Turn on the Force full synchronization on nearest update setting.

    • In the Full import URL field, enter the URL that points to the CSV file that contains a full data set. The current location provided by Sundhedsdatastyrelsen (Danish Health Authority) is:

      https://sor-filer.sundhedsdata.dk/sor2_produktion/V1_00/data/SorEntity_daily.csv.

    • The date and time of the last synchronization will be displayed.

    Daily synchronization

    The next update will perform a synchronization of changes since the last update.

    • In the Daily import URL field, enter the URL that points to the CSV file that contains a daily update. The current location provided by Sundhedsdatastyrelsen (Danish Health Authority) is: 

      • https://sor-filer.sundhedsdata.dk/sor2_produktion/V1_00/data/SorEntity_daily.csv.

    • The date and time of the last synchronization will be shown.

    If an error occurs during synchronization, the date and time of the last successful synchronization remain unchanged. The next synchronization will synchronize from this last saved date and time.

    Important: If Sundhedsdatastyrelsen (Danish Health Authority) changes the location of the CSV files, you need to change the URLs accordingly.

  4. Click Test connection to ensure that the URL works.

  5. Click Save to save the configurations.

Disable the SOR integration

When you disable the SOR integration, existing SOR contacts will remain as they were at the time of the last synchronized.

  1. In WorkZone Configurator, go to Services > Contact synchronization > SOR tab.

  2. Turn off the SOR integration enabled setting.

Schedule SOR synchronizations

You can configure when to perform synchronization of SOR data.

  1. In WorkZone Configurator, go to Services > Contact synchronization > Schedule tab.

  2. In the SOR section, turn on Enable for the type of synchronization you want to schedule and enter a Cron expression that tells the server at what time and how often to perform the synchronization.

    3. Example: Cron expressions:

    Daily synchronization

    15 0 * * *

    which will synchronize data every day at 00:15.

    Full synchronization

    0 19 * * mon

    which synchronize data every Monday at 7 PM.