Learning Management Systems Buzz

Prepare the user import file for New users

Required Fields

Additional Fields

Assumptions

• Usernames must be unique and cannot exist anywhere else within the Latitude Learning LMS. Field character limit: 100.
• Primary Location Code, Primary Position Code, and User Group columns must contain existing codes from your LMS. Entering new/invalid information will cause the import of that user record to fail.
• Email address is an optional field, but is HIGHLY encouraged. The Data Import Exception Log will include a list of users added without Email data.
  
• Address is an all or nothing option. If you enter user data in any one of these fields you must populate the complete address, or the import will fail. (Street Address Line 1, Street Address Line 2, City, State or Province Code, Postal Code, Country Code)
  
• Dates must be formatted as mm/dd/yyyy.
• State and Country codes must match standard LMS codes.
• Phone and Fax numbers must be formatted with dashes or parentheses.
• If you have Organization or Position codes that include a comma or leading zero, you must place double quotations around those values (Example: "001").
  

 
upload the user import file to the lms

1. Click Choose File to browse your local computer and select the appropriate CSV file. 
2. Enter a Temporary Password with at least 8 characters, including both numbers and letters, that will be given to new users for initial access to the LMS. 
3. Click Process User Import to queue the upload for processing. 

Administrators will receive a confirmation email, typically within a few minutes of initiating, to let them know that their file was accepted and processing is in progress.

Once the LMS completes the import process, administrators will receive a second email titled "Latitude Learning Data Import Exception Log" with an attached Excel file. The file contains information about successfully imported users and lists any import errors as failures  (SuccessFailureLog).  There is only one log file generated per 24 hour period. If you import multiple sets of users in one day, you will be re-sent the same SuccessFailureLog, but the additional entries will be appended each time. Different sets of data will be identified with a different Load ID. Imported users do not receive notification of their username and password credentials. The import process creates a User Group of all the imported users to allow targeted Announcements to be made for that specific population.

USING THE TEMPLATE TO UPDATE EXISTING USERS

You can use the template to update data for existing users if care is given to the validity of the data entered. The requirements for filling out the form are the same regardless of whether the user is new or existing. When you import an existing user with the template:

• The LMS will not change data that it finds to be identical to the data already listed for that user. 
• If a change is detected, the LMS will overwrite that data with the imported value. 
• If a new location is provided for Primary Profile, a new profile will be added to the user's profile list and flagged as primary, with the position and role provided. 
• Any temporary password provided during the import process will not affect existing users, only those on the list who are new.