You have the option to import users, both internal users and customers, with a CSV file. The CSV file should have comma-separated values, where the very first row contains the column names.
Import of customer records
Note: There is actually no need to import users, as email addresses are automatically stored on every email sent to your mailbox
In order to import user records successfully, your CSV should have the following columns. Columns must be in lowercase:
email = Email address
first_name = First name
last_name = Last name
company_id = The ID of a company
labels = The exact name of the label (*)
labels_id = The ID of the label (*)
first_name = First name
last_name = Last name
company_id = The ID of a company
labels = The exact name of the label (*)
labels_id = The ID of the label (*)
(*) : You can also use a “:” separated list to add labels, e.g., Marketing:Trial:Demo
Please note that the labels’ names are case-sensitive! You do not need to provide a “labels” and a “labels_id” value if you only have one. However, you always need to create an empty value in your CSV file (this is automatically done in Excel).
Custom Fields
Starting from December 12th, 2023, you will be able to update custom field values through CSV import. To update your custom fields, make use of the "variable name" assigned to each custom field. You should use this variable name as a column header when importing your CSV file. During the CSV import process, the system will either update the value of an existing custom field or add a new value if the field does not yet exist for a particular contact.
Import of Helpmonks users
In order to import user records successfully, your CSV should have the following columns (header):
email = Email address
first_name = First name
last_name = Last name
password = Password (at least 6 characters) (Passwords will be encrypted!)
active = true for active, false for inactive
first_name = First name
last_name = Last name
password = Password (at least 6 characters) (Passwords will be encrypted!)
active = true for active, false for inactive
Note: Columns should be written in lowercase!
Updating records
A record gets updated when the email address matches.
Last updated on Dec. 12th, 2023
Still need help?Contact us