Community Administrators and User Administrators can export a comprehensive list of users into a CSV file. This export is useful for auditing data or creating a template to update user records in bulk.
Prerequisites
Roles: You must have the Community Administrator or User Administrator role.
Steps to Export Users
Follow these steps to generate and download your user data file.
Navigate to the Administration module.
Click Users.
Click Filters to open the search options.
Apply any desired filters to customize the data in your export.
Click Export and select Export Users.
In the Job Submitted pop-up box, click the here hyperlink.
On the Background Jobs screen, wait for the status to show Finished.
Select Download to save the CSV file to your device.
User Fields and Values
| Field | Definition |
|---|---|
| Username | The user's system username following your organization's naming conventions. |
| First Name | The user's first name. |
| Last Name | The user's last name. |
The user's primary email address. |
|
| Enabled | Indicates account status: Y (Yes) or N (No). |
| External User Management | Indicates if user details are managed in an external system: Y (Yes) or N (No). |
| External User ID | The unique identifier from an external system, if applicable. |
| Vendor ID | The specific vendor identification code, if provided. |
| Self Approval Level | The maximum value for which a user can approve their own requisitions or expenses. |
| Org Units | The primary Organization Unit(s) assigned to the user. |
| On Behalf Of Org Units | The Organization Unit(s) for which the user has purchasing authority. |
| Roles | The specific permissions and access levels assigned to the user. |
| Buyer Groups | The group(s) determining which suppliers and catalogs the user can view in the marketplace. |
| Phone | The contact phone number associated with the user profile. |
| Last Login | The timestamp of the user's most recent system access. |
| Created Date | The date and time the user account was first established. |
| Deactivated Date | The date and time the user account was disabled. |
Results
You will receive a CSV file containing user details such as usernames, email addresses, assigned roles, and buyer groups. This file can be used as a reference or edited for a bulk upload.
What's Next/Related
Bulk Updates: Use the exported file as a template to Upload Users for bulk changes.
User Reference: See User Field Definitions for a detailed breakdown of each column in your export.