Skip to content

Latest commit

 

History

History
65 lines (38 loc) · 3.63 KB

createstudentsInstructions.md

File metadata and controls

65 lines (38 loc) · 3.63 KB

Create bulk student accounts using Bash

This bash script will read a list of accounts to create from a csv to bulk create email addresses for students taking a course. It will assign an Azure subscription to each of the students.

Prerequisites

Set up Bash environment to run the script

This is a bash script so you need to run it on a Unix machine or use Bash for Windows. You need npm, node.js, the Azure CLI, and dos2unix to run the script.

  1. If running on Windows, install bash for Windows

  2. Launch a command prompt and run bash

  3. Within your bash environment install node.js and npm by executing the following commands

    curl -sL https://deb.nodesource.com/setup_6.x | sudo -E bash -
sudo apt-get install -y nodejs

  4. Install the Linux version of the Azure CLI

  5. Log in to Azure cli using the azure login command. When prompted, log in using the microsoft account associated with the education grant.

  6. Install dos2unix. dos2unix is a utility that converts plain text files in DOS format to UNIX format. In this script dos2unix converts your csv file to a format understood by UNIX. You can install it using the following command:

    sudo apt-get install dos2unix

Create your CSV file

Each line of the csv file should include the following fields in order:

Name,Login,password,SubscriptionId,RoleName

  • Name is a string name of students

  • Login is the part of the email address before the @. You may want to generate this based on the students name

  • Password is the password assigned to the account. You might use something such as student id as a basis for passwords.

  • SubscriptionId is the SubscriptionId of the subscription to which you want to add the student. You can find the subscription id listed in the Azure Education portal. the subscription id will be a value such as 'fa57eb5c-7e21-49d8-b521-7c1bc81a3adc'

  • RoleName specifies the role you want to assign to the user, usually this will be Contributor

Update the createstudents.sh script

  1. Replace the variable INPUT in line 2 with the path of your csv file (Do not use Notepad or Wordpad or you may get extra carriage return and escape characters in the script that cause file not found errors, better to edit the script in a tool such as VS Code, vi, or Notepad++)

  2. Replace the string xxxx.onmicrosoft.com with the AAD of the subscription with the educator grant. if the address is XXX@YYY.com, the value should be XXXYYY.onmicrosoft.com.

Note: If there is any punctuation in the email address (e.g. john.smith@live.com) do not include the punctuation e.g. AAD address would be johnsmithlive.onmicrosoft.com.
You can look up the AAD in the Azure portal. Log into the portal using the account name associated with the Azure Education portal subscription. From the home page select More services | Azure Active Directory Preview | Domain names to see the AAD account name format.

Execute the script

./createstudents.sh

A big thanks to Djordje Relic from the swiss MSP program for his help creating the script and to Mikhail Chatillon for writing documentation and sharing the script