CSV Import Mappings

Overview of CSV Import mapping attributes

To automate user management using CSV imports, you need to map the CSV field attributes to the profile field IDs in the Experience Studio. This ensures that the endpoints can match the data and update the platform.

Prerequisites

  • The identifier for each user is defined in the CSV file.

Note: Staffbase recommends not to modify identifiers once you set them. If you update the identifiers, it is necessary to update them in the CSV file. Otherwise you will end up duplicating users on the Staffbase platform.

Use the following mapping table as reference to implement your Automatic CSV Import.

Experience Studio NamingCSV Attribute
Identifier
mandatory
externalID
Email
primary email address
eMail
UsernameuserName
One-time passwordaccessCode
Recovery coderecoveryCode
Expiration date of Recovery code
Note: The expiration date for the recovery code is in a timestamp format with milliseconds. For example, 1585532247000 stands for Monday, 30. March 2020 01:37:27
recoveryCodeExpiration
First Nameprofile-field:firstName
Last Name profile­-field:lastName
Positionprofile­-field:position
Departmentprofile­-field:department
Locationprofile­-field:location
Public email addressprofile­-field:publicEmailAddress
Public phone numberprofile­-field:phoneNumber
Custom Profile Field
Note: Please replace the "identifier" with the custom profile field ID for data import.
profile-field:identifier
Mandatory open groups mandatoryGroupIDs

Additional Helpful Information