How to Format the Members CSV File

The Essential Information

• Include emails for every member across all programs.
• Include manager's email
• If no role is assigned to a user, they will automatically be assigned as 'Member.'
• Keep columns in the following order: 

Additional Requirements for FAVR Programs:

• For FAVR programs, ensure you provide Annual Business Miles, State, Zip Code, and Program Name.

Non-Editable Fields:

• User ID, Compliance status, Fixed rate, Variable rate, and Work hours cannot be changed here. 

Role Management:

• Use the "Roles" column to assign multiple roles; separate them with a semicolon (e.g., Manager; reviewer). For more information on role permissions, click here.

Custom Data:

• If you have extra details you want to add to your members, utilize the last column labeled 'meta_example1'. For instance, you can use it to categorize information like departments (e.g., 'meta_department') and input relevant data such as sales, customer support, finance, etc. Click here to learn more about custom data. This data will be visible at the bottom of 'Member Info' on the Member's tab.

Download Tips:

• When downloading using Numbers, remove the first row of your report. Apple Numbers tends to save the report title as the first row, and removing it ensures correct formatting upon re-upload.

Customer Support:

If you need to contact support or have questions, please check out our help center at help.everlance.com or reach out at support@everlance.com or by phone at (872) 814-6308 (USA) or (877)704-2687 (CAN). Our office hours are 9am-5pm EST Monday - Friday and 9am-1pm EST on weekends.