Bulk Import / Deactivate Users
  • 25 Jul 2023
  • 4 Minutes to read
  • Dark
    Light

Bulk Import / Deactivate Users

  • Dark
    Light

Article Summary

Bulk Import Steps

If you need to create multiple users at once, LSVT provides two simple options for bulk user creation.

  1. The Enrollment Feature allows admins and managers (who have the privilege to “Create Users”) an option to easily enroll users at their location. To learn more about the Enrollment Feature, click here.
  2. You can also use a CSV file (Excel Spreadsheet) to collect enrollment information and upload users in bulk.

Download the User Import Template.

Note

Do not remove or edit any main columns in the excel template, or it will cause errors when you try to import.

Below, is an explanation for each field name and the expected values:

ParameterValue or Description

*Location

This can be the exact name of the location or the location ID

*Username / Login

Username – No illegal characters

*Password

Password in plain text format

*First Name

First name – No illegal characters

*Last Name

Last name – No illegal characters

Middle Name

(Optional) Middle name – No illegal characters

*Email

User’s email address

Affiliate ID

(Optional) Can be used to pass extra information like an affiliate ID for example

Title

(Optional) Assign a user a Title

Team

(Optional) Assign a user to a team – Must be the exact name of an existing team

User Expiration Date

(Optional) Set a date for user to be expired – this must be set in the future with the following format “mm.dd.yyyy”

*Content Role

This is used to specify the user’s “Content Roles” (Role ID numbers only) List these separated by commas, like this, with no spaces: 1234,12345,43213,12343

Active

(Optional) This is used to determine if the Users account is set to Active or Inactive – must be TRUE or FALSE

*Access Level

Select the number for the access level, this is a range of 2 through 12 Only

*Update Profile

Set this to allow user to update their profile or not – must be TRUE or FALSE

Work Phone

(Optional) Main phone number – Must be in this format: xxx-xxx-xxxx

Cell Phone

(Optional) Cell phone number that will be used for SMS – Must be in this format: xxx-xxx-xxxx

Role Scheduler Days

(Optional) Setting this will perform a command to add or remove a content role after a number of days specified here

Roles Add

(Optional) Specify content role ID’s here to “Add” after the number of days specified in the Role Scheduler field

Roles Remove

((Optional) Specify content role ID’s here to “Remove” after the number of days specified in the Role Scheduler field

Misc 1

(Optional) Info that will be visivle in the Misc Info 1 field in the user profile

Misc 2

(Optional) Info that will be visivle in the Misc Info 2 field in the user profile

Language

(Optional) Language code for the user (Example: es-es, ca-fr, etc.)

Billing Frequency

(Optional) Billing frequency of the user’s subscription in months

Gross Fee Charged

(Optional) Gross fee (Decimals are accepted)

Force Password Update

If set to “TRUE”, the user will have to update their password upon first login

Here is an example of what the CSV file (Excel Spreadsheet) should look like.

Reminder: In the content role column, DO NOT use the Content Role Names, ONLY the Content Role IDs will be accepted, in a format like this, with no spaces: 1234,12341,432134,64332,3422

Step 1

Once you log in to your LSVT account, you’re going to want to click on the “Super User Dashboard” icon.

Step 2

Under the “Account [100]” section, click on “API Management” to access the API Manager.

201908integration-mgmt-sud.jpg

Step 3

When you get to the API Manager screen, you will see the “More” tab, it’s the 7th tab from the left. Click that tab and then click on the "Utilities" drop down menu. In the second drop down menu, “Users Import” will appear - Click on this and then pick your system.

201908step3apiManager-1024x482-1024x482.png

Step 4

After you pick your system, you’ll be brought to the users import screen where there will be three sections “Settings”, “Scheduler Settings” and “File”.

The fields in the “Settings” and “Scheduler Settings” sections do NOT need to be filled out since the CSV file will contain all of the information needed.

Just make sure that the checkbox "Active" is checked and if you want users to emailed with their account login you can adjust these settings from the "Email user immediately" pulldown.

*NOTE: Anything that is populating in the "Settings" and "Scheduler Settings" fields will override what you have in your CSV file.*


201908step51apiManager-968x1024-968x1024.png

Step 5

The “File” section is where you will pick your CSV file. After you have found and selected your CSV file, click the Submit button.

After you submit the CSV file and all the information is correct, a confirmation modal will appear detailing how many users were imported and asking for your confirmation, click “Ok” and that’s it, you’ve successfully uploaded users in bulk!

201908successUpload-1024x560.png

Please contact our support team if you run into any problems or have any questions.

Bulk Deactivation Steps

You can find the Bulk Deactivation option in the same area as the Bulk User Import.

From the Super User Dashboard, click on Bulk Import Users, and then select the Bulk User Deactivation link.

From there, you can enter a list of User IDs or Usernames, separated by a comma with no space, to deactivate the Users.

Example of User IDs:

1234,1235,1236,1237,1238

Example of Usernames:

username1,username2,username3,username4


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.