Adding Employees via CSV into Email Experiences

In order for Terminus to pull employee information into a signature template, user data needs to be available within the Email Experiences application. The following steps detail how to add employee data via a CSV import.

Step 1

First, organize employee information via a CSV file. CSV files can be exported from Active Directory or virtually any HR management software. The first row of the CSV file should identify the information contained in each column and the subsequent rows should contain user information. The only field required to create a user profile within Email Experiences is the employee email address.

Employee field options in Email Experiences include:

• email – The ONLY required field.
• first_name
• last_name
• group – This is the easiest way to create groups in Email Experiences. Note each Email Experiences user can only be aligned to one group.
• mobile_phone
• office_phone
• phone_extension
• personal_url
• skype_username
• title
• address
• facebook_handle – Everything after the last / in a FB link
• facebook_text
• twitter_handle – Username or @handle
• twitter_text
• linkedin_handle
• linkedin_text
• googleplus_handle
• googleplus_text
• pinterest_handle
• pinterest_text
• youtube_handle
• youtube_text
• instagram_handle
• instagram_text

It is not necessary to perfectly align CSV column headers to Email Experiences field titles. You will have the opportunity to map fields during the CSV upload.

Step 2

Once the CSV file is ready for upload, log-in to your Email Experiences account, navigate to the Employees section and click Add Employees.

Step 3

After clicking Add Employees, you will be given the opportunity to upload a CSV file.

Step 4

You will be taken to the Integrations page. Click the "Upload CSV" button on the right.

Step 4

Click Choose File, select your previously produced CSV file, and click Open.

Step 5

Once you have uploaded the CSV file, the next screen will give you the opportunity to map CSV column headers to Email Experiences fields. After the fields have been placed, click Next to Select Users.

Step 6

The final screen will allow you to dictate which users listed in the CSV file will be imported. If a user is highlighted in green, that user profile already exists in Email Experiences. You can choose to import all users, all existing users, all available users (meaning they do not exist in Email Experiences), or individual users.

Step 7

If you check the option to Overwrite Changes Made By Users, the import will override any data changes previously made by end users.

Step 8

After choosing the users and groups to import, the CSV import process is complete! You can view imported users via the Email Experiences Employee page.

Note: When assigning groups via CSV upload, please make sure the Group name text in the file matches the Group name defined in the platform. If not, a new group will be created in the platform upon upload.