If you are experiencing any issues adding users to Lattice using a CSV Upload, we recommend following the steps listed below to troubleshoot the issue. You can re-upload the CSV as many times as you want with no negative effects, as long as you don't change an employee's email address (changes to email addresses will generate new accounts).
Note: Admins must change employee emails by editing their profiles directly. To learn more about this process, check out this help center article here!
Step 1: Make sure all your email addresses are valid
You can do this easily by using the function "ISEMAIL()" in Google Sheets
Step 2: Make sure you're using a CSV file when uploading your employee data into Lattice.
Step 3: Make sure that you have headers in your CSV (highlighted below). The CSV must include fields for Full Name, Title, Email, and Manager Email. You may also include fields for Start Date, Phone Number, Status, and any other Custom Attributes you've added to Lattice.
Step 4: Make sure there are no fields with exponents or errors
You can have fields that are blank, but make sure they are actually empty!
Step 5: Make sure there are no special characters in any fields (e.g. %, $)
Step 6: Make sure that your dates are in the format YYYY-MM-DD
Notes on upload behavior
If the CSV uploaded contains a field as a column and there are rows that contain empty values, the previous field value for those users will be removed. This does not apply to name or employee email fields, nor does it apply to employee IDs if they are set. For an employee's role, the field will populate with "n/a" if left blank on a CSV. If you only need to add or change one or a few users' details, you can upload a partial .csv that just contains the email addresses and attributes (custom and required) of those users.
FAQs:
Q: My CEO doesn't have a manager, do I need to fill in this field before uploading my CSV?
A: You can leave the "manager" field blank for the CEO when uploading the CSV into Lattice.
Q: Can I leave a field blank in the CSV?
A: Leaving fields blank will neither remove information from a user's Lattice account nor change their account status.
Q: What if I only need to update the details for a few users?
A: You can upload a partial .csv that only contains their email addresses. Excluding email addresses/users from the upload will not effect those users' accounts.
Q: I'm seeing an error that says "CyclicOrgTreeError" (image below). How can I fix this issue?
A: This issue is most likely caused if two employees are said to be reporting to each other. For example, if I indicate Michael Stein (CEO) is reporting to Joseph Stone (VP of Ops) but Joseph Stone is also reporting to Michael Stein, I'll see this error. To troubleshoot this, you can simply remove a manager from the CEO, Michael Stein's "manager" column, save the CSV, then re-upload.
If you have followed these steps and are continuing to receive an error, please send a screenshot of your error message and the CSV to Customer Care to troubleshoot next steps. You can reach out to the by chatting in or emailing the team at customercare@lattice.com.