Export users

If you are an administrator, you can export all users in your environment to a CSV file. The exported CSV file can be updated and imported back into IBM® Planning Analytics Workspace, which makes it easy to update roles and environments of users with a single bulk upload.

About this task

You can export users in a .csv file and save the file to your Downloads folder as all-users.csv or open it in the editor and save it with a file name of your choice.

The .csv file is formatted so that you can edit it and upload users back into your environment with any changes that you want to apply. Columns in the exported .csv file match the format that is required for importing users. The values in the Directive column are hardcoded as ADD, which can be used to update existing users. The Last Login column shows the date and time of the most recent login for each user, but this column is ignored when importing users.

Each row in the .csv file represents a user in an environment. If a user is in multiple environments, there will be multiple rows for that user.

An example of the all-users.csv file that is created when an administrator downloads users.

Export users in Planning Analytics Workspace

Procedure

  1. On the Planning Analytics Workspace home page, click the Administration tile.
  2. Click Users & Groups.
  3. Click the Users tab.
    Note: Selecting users has no impact. Clicking Download users always exports all users in the current environment.
  4. Click Download users Download users icon.