Import or Modify Users from a File

You can create new users or batch-update existing users by importing user data that you have saved in a CSV file.

Prerequisites

The user data you want to import must be stored in a CSV file. At minimum, your CSV file needs columns for UserID, LastName, and Email, but it is recommended that you also include FirstName and DisplayName.

If you want all new users to be assigned the same role, set a default role before importing users. For more information, see Set the Default Role.

If you want to assign new users different roles, include a Roles column in the CSV file. The role IDs used for role assignment are outlined in Standard Application Roles.

For existing users that you want to modify, you can create the CSV file by first exporting a CSV file from SAP Analytics Cloud. For more information, see Export Users.

Note

The first name, last name, and display name are linked to the identity provider, and can't be changed in the User list page, or when importing a CSV file. (In the User list page, those columns are grayed out.)

To edit those values, you'll need to use the user login, and edit that user's profile.

Edit the downloaded CSV file to remove columns whose values you don't want to modify, and to remove rows for users whose values you don't want to modify. Do not modify the USERID column. This ensures that entries can be matched to existing users when you re-import the CSV.

These are the available mapping parameters when importing CSV user data:

Parameter	Description
User ID
First Name
Last Name
Display Name
Email
Manager
Roles
Mobile
Phone
Office Location
Function Area	Can be used to refer to a user's team or area within their organization.
Job Title
Clean up notifications older than	Set in user settings: when to automatically delete notifications.
Email Notification	Set in user settings.
Welcome message	Message that is shown to the user on the home screen.
Page tips	Enabled/disabled via the help center (deprecated).
Closed Page tips	Closed page tips are tracked so that they are not shown again.
Closed Item Picker Tips	Closed tooltips are tracked so that they won't be reopened again (for first time users).
Current Banner	Saves which banner is currently showing.
Last Banner	The UUID of the last closed banner.
Last Maintenance Banner Version	The version when the last maintenance banner was shown.
Marketing email opt in	Set in user settings.
Homescreen content is initialized	If default tiles have been set for the home screen.
Expand Story Toolbar	Set in user settings.
Is user concurrent	If the user has a concurrent license.
Default Application	The application that will launch when you access your SAP Analytics Cloud URL. The default application can be set in System Administration System Configuration or in the user settings.
On the Edit Home Screen dialog, a user can override all the default preferences that have been set by the administrator for the system (System Administration Default Appearance). These are the preferences:
Override Background Option
Override Logo Option
Override Welcome Message
Override Home Search To Insight
Override Get Started
Override Recent Stories
Override Recent Presentations
Override Calendar Highlights

Procedure

From the side navigation, go to Security Users.
Select (Import Users) Import Users from File.
In the Import Users dialog, choose Select Source File to upload your CSV file.
Choose Define Mapping to assign the fields of your user data from the CSV file to the fields in user management.
Select the appropriate entries for the Header, Line Separator, Delimiter, and Text Qualifier.
Select OK when you've finished mapping.
In the Import Users dialog, choose Import to upload your CSV file according to the defined mapping.

Next Steps

If the CSV file doesn't define roles, you must assign roles to the imported users or a default role will be applied. For more information, see Assign Roles to Users and Teams.

If you use SAML authentication, you can perform SAML-based dynamic role assignment. For more information, see Map Roles Using SAML Attributes.
You can also assign roles programmatically using the User and Team Provisioning API. For more information, see SAP Analytics Cloud User and Team Provisioning API.