The option "Add and update" is suitable 

  1. for the inital Excel import of the user data before go-live as well as 
  2. for updating the user data during the awareness training.



I. Initial Excel import of the user data


To upload the user list, please follow the steps below:

  1. Open the section Users > User Management in the SoSafe Manager.

  2. Click "Import user data" and start the User Management.

  3. Select "Add and update".
  4. Download our Excel template and fill in the user data. Using the Excel template is the easiest way as the required columns correspond exactly to our system.
    Note: Please keep in mind that the Excel file must be complete. Empty fields such as a missing name are considered to be an error.
    Enterprise: If you booked the Enterprise option, you can add two further columns for extended user data.

  5. Upload the complete Excel file via drag & drop.

  6. Select a header from the Excel file (the first row is usually correct and therefore selected per default). The header is the basis for the attribute mapping in the next step.

  7. In the following area, the defined user data attributes are assigned to the columns of the Excel file. When using our Excel template, this is done automatically by our system. On the left you find the required fields/attributes, on the right the match with the Excel file. __________________________________________________________________________________________________________________________
    Note: Attributes marked with a star (*) are mandatory. Only if these fields are filled out will you be able to save the setting and proceed.
    Enterprise: At the bottom of the page, you find a list of the Excel columns that could not be matched automatically and therefore could not be assigned to the attributes. Here you have the option to add extended user data.

  8. a) Fixing errors: No errors were found: You can skip to the next step. 
    b) Fixing errors: Errors were foundWhen errors are found you are prompted to correct or delete incorrect user data. You can either correct the errors individually or at once: 

    • Delete record: The record is completely deleted from the database (red trash bin).

    • Edit record: The error is visually highlighted and can be easily edited and corrected (blue pen).

      _________________________________________________________________________________________________________________________

      Common errors are:
      • Duplicates

      • Domain unknown

      • Empty field

      • Umlauts or spaces in the email addresses

      • Unknown salutation or academic degree (in this case, it is best to compare whether the name is available in the dropdown of the corresponding field).

      • Invalid declaration as collective address (please note that for collective addresses the first four fields (salutation, academic degree, first name and last name) must be empty)

        Please find further information here.

        Note: If there are many errors (>20), we recommend aborting the process, correcting the errors in the Excel file, and uploading it again.



  9.  User group assignment: 
    • When all user groups have been successfully uploaded and assigned, you can directly proceed with the next step.

    • This is not possible, if users are not assigned to any user group or the assigned user group is too small. To proceed, you have these options:

      • Create a new user groupAll unassigned records can be transferred to a new user group (at least 5 persons). 

      • Add to existing user group: The users are collectively assigned to an existing user group.
      • Skip: If the user group is too small, the data records will not be considered in the Analytics. However, the upload is possible as well as the manual editing and group assignment in the User Management section. 
      • Edit original Excel file so all users are assigned to a user group that includes at least 5 persons.

  10. At the end there is a summary for newly added user data and user groups. 

  11. After the final confirmation the data records are imported. 



II: Update user data


If you want to update existing user records (e.g., change surnames or email addresses), we recommend this procedure:

  1. Export the current user data to receive the most recent data records including the SoSafe ID.

    Please find further information on the SoSafe ID here.

  2. Edit the user data directly in the Excel file.

  3. Start the User Management and import the new Excel file as described in section I above.

  4. In the final step you receive an overview of already existing and/or newly added user data and user groups.