An 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 Staffbase Studio. This ensures that the endpoints can match the data and update the platform.
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.
| 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 |
| Mandatory open groups | mandatoryGroupIDs |