Live Utilities allows you to import your master CSV file – it will automatically create new users and update existing users with new data.
Step 1
Begin by clicking on Import
Step 2
Set Import Type > User Accounts
Set Import Action > Create & Update Users
Click on the “Upload File” and browse for your CSV File.
Step 3
Map your CSV columns to appropriate User Accounts column. An Email is required to create new users. Other required fields can be automatically generated.
If an existing user exists with same username (either mapped or automatically generated) then the module will update it.
Note: Only the mapped fields are updated for existing users. For example, auto generated “Display Name” does not apply when updating existing users. If you want to update the Display Name, make sure you have “Display Name” column mapped to one of the fields in your CSV File
Step 4
Preview your columns mappings and continue to next step.
Step 5
The following options only apply when creating a new user – they do not apply when updating an existing user.
Automatically Generate: Display Name
If you didn’t specify a column for Display Name then one will be automatically generated. Select the appropriate data to use as Display Name.
Automatically Generate: Username
If you didn’t specify a column for username then one will be automatically generated. Select the appropriate data to use as Username.
Automatically Generate: Password
If you didn’t specify a column for username then one will be automatically / randomly generated.
Force User to Change Password on Next Login
If selected, the user will be prompted to change their password on first login.
Delete All Users Before Importing (Except Administrators)
If selected, the import job will delete (hard delete) all existing users except administrators. This can be helpful in test imports.