To automate user management using CSV imports, you need to map the CSV field attributes to the profile field IDs in the Staffbase 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.
Staffbase recommends not modifying identifiers after they are set. If you do update an identifier, you must also update it in the CSV file. Otherwise, duplicate users may be created on the platform.
Use the following mapping table as reference to implement your Automatic CSV Import.
| Staffbase Studio Naming | CSV Attribute |
|---|---|
| Identifier mandatory | externalId |
| Email primary email address | |
| Username | userName |
| One-time password | accessCode |
| Recovery code | recoveryCode |
| Expiration date of Recovery code 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 Name | profile-field:firstName |
| Last Name | profile-field:lastName |
| Position | profile-field:position |
| Department | profile-field:department |
| Location | profile-field:location |
| Public email address | profile-field:publicEmailAddress |
| Public phone number | profile-field:phoneNumber |
| Custom Profile Field Please replace the “identifier” with the custom profile field ID for data import. | profile-field:identifier |