If the network admin wants to invite a list of large number of users to the portal, then he can do it by using the “Import CSV” feature in MangoApps.

Steps to import users from CSV

I. Creating a CSV file

To invite users by importing them from a CSV file, first you need to create a CSV file with the first line being the field headings and all subsequent lines being field values for each user to be invited.

Notes on CSV Files

  • It’s recommended that each field be surrounded by quotes. This means that each value must not contain any quotes or close attention must be made to properly escape quotes that are part of the field’s value.
  • For users’ fields that do not have values, there should be nothing between the quotes such as in this example where the user “Will Smith” has no “title” in the 5th column:
    "name","firstname","lastname","email/login","title","location","organization","phone","mobile","manager","Enabled"
    "Will Smith","Will","Smith","willsmith@gmail.com","","Seattle","Hollywood","(+91)1234123411","(+91)1234123411","johnny_depp@yahoo.com","TRUE"
  • Each user must have the same number of fields, even if they are empty, as there are field headings in the CSV file.
  • With CSV even the custom fields of user profile can be imported.
  • Manager will get assigned only if email id of the manager is already an active network user in your domain.
  • Description of Enabled flag value:-
    • TRUE- This will activate an existing user if the current status is Deactivated. If the user is not present in the domain then the user will be created.
    • FALSE – This will deactivate an existing user if the current status is Activate. If the user is not present in the domain then user will not be created.
    • <Blank> – If the Enabled field is left blank, then the user state will not be touched.

The format of the CSV file is below. The first line is the field headers and subsequent lines are users that will be imported.

“name”,”firstname”,”lastname”,”email/login”,”title”,”location”,”organization”,”phone”,”mobile”,”manager”,”Enabled”
“Will Smith”,”Will”,”Smith”,”willsmith@gmail.com”,”Director”,”Seattle”,”Hollywood”,”(+91)1234123411″,”(+91)1234123411″,”johnny_depp@yahoo.com”, “TRUE”
“JohnnyDepp”,”Johnny”,”Depp”,”johnny_depp@yahoo.com”,”Manager”,”Seattle”,”Hollywood”,”(+91)1234123411″,”(+91)1234123411″,”ashton@yahoo.com”, “FALSE”

 

II. Importing the CSV file 
Once the CSV file has been created it is ready to be used to import users to MangoApps. To invite users from your CSV file:

  1. Go to the Admin portal of your MangoApps domain.
  2. Choose “Users” -> “Invite Users” -> “Import Users” tab
  3. Choose between “Skip existing users” or “Update existing users” (Please note that if you select Skip existing users”, then this would skip updating the existing users. It will only add the new users found in the uploaded CSV. If you select “Update existing users”, then it would update all the users already present in the data base with new values from the uploaded CSV. Additionally it will create new users that are found in uploaded CSV.)
  4. You can check or uncheck “Allow out-of-network users to be invited to your network” – which lets users whose email address does not match the company email address be added to your domain.
  5. Click the “Choose file” button and navigate to the CSV file you created.
  6. Click the “Import Now” button.
  7. No emails will be sent out to the imported users. Once the import is successful network admin will be notified via email with a link to invite the imported users to MangoApps.

Screenshot:1

Video:

(Visited 400 times, 1 visits today)