Uploading multiple users via CSV
Instead of creating users one at a time, you can upload many users in one go, saving time and effort. The major steps are:
- Gather the user info you want to upload in a spreadsheet
- Save it as a CSV
- Upload the sheet
- Match columns in Safety OnDemand to your spreadsheet
- Save the upload
We’ll go over these one at a time.
Creating Your Spreadsheet
Creating a user upload is very simple. There aren’t any complicated formats you need to know, or specific naming structures. At the bare minimum, all you need is a unique user ID and a name. However, you can also add as many custom columns as you want and make custom fields to fit that information. Here’s an example spreadsheet you can use to build off of.
As you can see in the image above, we’ve included email addresses for everyone, given everyone a “Unique ID,” or username, and included the custom field for “Team.” We also linked people to their managers in the final column. For more information, see the article on creating Managers.
You can also choose to leave out the unique ID and just use Email addresses as long as everyone has an email address.
NOTE! As an administrator, you do not need to upload yourself as a learner. You can access your own learning through your administrator account via the My Learning tab.
Save this file you’ve created as a “CSV” file. That will allow you to upload it.
To get started, we’ll need to get to the Manage Users screen.
First, navigate to the Admin section using the Application Switcher in the upper right. From there, click on Users & Permissions [1] and in the menu that appears, click Manage Users [2].
From here, click Add via CSV as pictured below:
This will bring you to a new screen. Click “choose a file” or just drag your CSV onto the window. That will upload the CSV and allow you to start matching columns to fields.
The first step is to drag the Login ID Key [1] to the field with your Usernames [2], or to the email field if everyone has an email. Just click and drag it to the top of the appropriate column.
Next, you’ll be asked to drag the Manager ID Key to the appropriate column. If you have a Manager column, do that now, but otherwise just click Next in the upper right.
Now it’s time to match the rest of the columns to the appropriate fields. For existing fields, simply drag the names over to the appropriate columns. It should end up looking something like this:
However, we don’t have anything for Team. That’s okay, we can just create a New Field! First, click New Field, then type in the appropriate name, and finally drag it over to the correct column, as seen below:
When you’re done, click on Finish in the upper right. That will bring you to a summary screen, which will show you how many users will be uploaded or modified, and any possible errors. You shouldn’t have any errors, however, so if you do, please contact us.
To finalize the upload, click Confirm.
And that’s it! Your users will be created, or modified if they already existed. If email notifications are turned on, each of them will also receive an email letting them know they have a new account, and allowing them to set a password.