Add users and companies to MBS in bulk


This article describes a procedure that allows to bulk-add multiple users accounts, for example, when transitioning from another solution to Managed Backup Services. The users are imported based on information contained in a CSV file with the help of a Powershell script.


Prerequisites

  • Windows operation system with Windows PowerShell 3.0 or higher.
  • Administrator privileges
  • MBS root account credentials

Prepare files for import

  1. Download two files by following the links below.

      1.1 Import-Users.ps1

      1.2 Users.csv

  1. Go to MBS portal -> Settings -> General -> API 2.0 Credentials -> Change Credentials

  1. Generate new API credentials and copy them. We need them for Powershell file.

  1. Open Users.csv with Excel or OpenOffice. Make sure you use comma as a separator.

4.1 Add user information.

Email, Password and Enabled columns are required.

4.2 Companies, specified for users, will be created automatically or assigned if already exists.

4.3 Use semicolon to separate notification emails for user.

4.4 Save file as CSV.

5. Open Import-Users.ps1 for editing with any text editor.

5.1 Insert User and Password, which you saved on step 3, between double quotation marks.

  $User = ""

  $Pass = "" 

5.2 Specify the path to csv file.

  $UserFile = "C:\Path\Users.csv"

Run script in Powershell

  1. Run Powershell as administrator

  1. Allow running scripts by Set-ExecutionPolicy -ExecutionPolicy RemoteSigned command.

  1. Change directory to where you store scripts.

  1. Run Powershell script by .\Import-Users.ps1 command.

  1. As a result of importing users, script shows user ID or error message.


Contact Us

Tech questions: tech@cloudberrylab.com

Sales questions: sales@cloudberrylab.com