Update Existing Users by Bulk Import

If you want to make a change to multiple users, for example, change them from active to inactive or populate a new user attribute, you can use the bulk import feature.

To update a single user, see Edit an Existing User.

Note: We recommend you that you prevalidate the CSV file prior to uploading it. You cannot undo an import. We suggest that you keep your CSV files at least one back in case you need to roll back any changes.
Caution: When a column in the CSV file is left blank, Percipio imports a default value for the associated user profile field or removes existing values from custom attributes. Prior to uploading a CSV file, we recommend you delete all blank columns from the file to avoid overwriting any existing field values.

Creating the CSV file for importing

When creating a CSV file for changing user data, the only columns you need to specify in the CSV are the externalUserID (the unique user identifier in Percipio) and the columns for which you want to add or change data.

Example: If you want to change a many users from active to inactive, your CSV file can look like this:

When you ensure all other columns are removed from your file, you avoid any accidental data overwrites.

Updating the data

The best way to get the externalUserID for each user and exact column heading titles is to download the current user list.

  1. From the Admin menu, click USERS > User Management. The User Management page displays.
  2. Click Download List. A CSV file containing all of your users and their user profile data downloads.

The downloaded list contains a row for each user and a column for each user profile and custom user attribute. To update this file with changes:

  1. Sort and filter the columns to group users together. Delete any rows that contain users you do not want to update.

  2. Delete any columns that contain data that you do not want to update.

  3. Update the data in the remaining columns. If you leave a column blank, Percipio will populate it using system defaults or if it is a custom attribute, Percipio will remove any existing data. See CSV fields and accepted values for how to specify data in columns.

  4. Save your file.

If you have a list of user ID's that need to be updated, you can copy them into the downloaded import template.

  1. From the Admin menu, click USERS > User Management. The User Management page displays.
  2. Click Download Template. A CSV file containing all user attributes downloads.

The downloaded template contains a column for each user profile and custom user attribute. To create your file for uploading changes:

  1. Copy user ID's into the externalUserID field.

  2. Delete any columns that you do not want to update.

  3. Add data in the remaining columns. If you leave a column blank, Percipio will populate it using system defaults or if it is a custom attribute, Percipio will remove any data. See CSV fields and accepted values for how to specify data in columns.

  4. Save your file.

To update many existing users via a bulk import

  1. On the Users > User Management page, click Bulk import users.
  2. Click the IMPORT tab.
  3. Choose the file you want to import and click Open. Percipio conducts the following checks on the import file:
    • File format (CSV)
    • Authorized separators: a comma (,) a semicolon (;) and the Tab function.
    • Empty file
    • Maximum size
    • CSV field values
  4. Select the date and time you want to send the initial Welcome email.
    Note: The date and time are based on your local system settings, not the email recipients' settings.
  5. Click Import.
  6. View the bulk import reports.