Sakai Community DocumentationSakai 23 Administrator Guide (English)UsersHow do I create multiple new user accounts by importing a file?

How do I create multiple new user accounts by importing a file?

Go to Users.

Image of users button

Select the Users tool from the Tool Menu in the Administration Workspace.

Click Import from file.

Image of the import button

Click Import a file.

Image of the import file button

Click the Import a file button to browse for an select a properly formatted CSV file containing the user account information for the users you would like to create.

Please note the following file requirements when preparing your CSV file.

  • Include the following headings: user id, first name, last name, email, password, type.
  • Column headings must match EXACTLY the list above. They do not need to be in the same order.
  • Fields must be comma separated, contain no spaces between fields and each field surrounded with double quotes if it is to contain a space.
  • You can also add other columns and these will be stored as user properties, as long as the headings do not clash with the main set above. It can be any arbitrary data.

Upload your file.

Image of the upload files options

If the import file has not been previously uploaded to Resources, click Add and then Upload Files to upload a new item.

Locate the file to upload, then click Continue.

Image of more upload files options

You may drag and drop your file or click in the drag and drop area to browse for the file to be uploaded. Click Continue to upload the file.

Select the import file.

Image selecting the recently uploaded file

Click the Select link for the file containing the user information you wish to import.

Click Continue.

Image of the continue button

Preview and confirm the user information.

Image of the uploaded data for review

The information for each new user will be displayed. If everything looks correct, click Continue to proceed and add the accounts.