Downloading the Import Template
The first step for importing your traits is to download the import template. The template is an empty spreadsheet with the allowed headers pre-filled. We'll walk you through where to find the template in the admin console.
1. Make sure your custom fields have been created.
*If you intend to import custom user or account traits, you must create fields for them before downloading the import template. You can do this on the Users or Accounts page by clicking the "gear" icon on the right (screenshot).
For more details on setting up custom fields and your options, check out this article.
2. Click the "Users" icon in the left-hand menu -> Click the cloud icon in the top-right -> Select "Import user data".
3. Click the link to download the User Data Import Template.
Formatting Your Data
You must use the pre-filled headers from the template and save your file as a UTF-8 encoded CSV (100,000 row limit). You may get your source data from a salesforce export, your product database, etc.
- external_user.email_address OR user_id
User and Account Details
- user.id: the user ID in UserVoice
- external_user.external_id: unique identifier in your system
- external_user.email_address: if a user's email address does not already exist in UserVoice this will create a new user profile.
- external_user.name: only seen by admins, and does not update their UserVoice display name
- external_user.created_timestamp: must be in standard format: yyyy/mm/dd hh:mm:ss. Default timezone matches the zone the uploader is in. To specify a time zone use the following format: yyyy/mm/ddThh:mm:ss-06:00 (for eastern)
- external_user.ip : used to set a location for the user
- external_user.type: admin, owner, developer, end user etc.
- account.external_id: required to create an account
- account.name: the name of the organization
- account.plan: the account's plan level in your system
- account.mrr: monthly recurring revenue represented in dollar units (If you pass in 1.5 this will be interpreted as $1.50)
- account.ltv: represented in dollar units (If you pass in 1.5 this will be interpreted as $1.50)
- account.created_timestamp: must be in standard format: yyyy/mm/dd hh:mm:ss. Default timezone matches the zone the uploader is in. To specify a time zone use the following format: yyyy/mm/ddThh:mm:ss-06:00 (for eastern)
If you would like to use multiple, you can create custom fields for those, but you will need to choose just one of the standard ID fields above.
- List out all User and Account traits you would like to see in UserVoice, using the field names you see in your Database.
- Match up as many fields as possible to fields that are already found in UserVoice (standard traits fields).
- If you have fields remaining, these will be your custom fields. Name them using the naming convention 'cf_you_custom_field'.
- Add the datatype to each (from the list of accepted data types).
Importing Your Traits
Now that your data is formatted you can add it to Uservoice. We'll walk you through how to do this and explain some of the errors you may encounter.
- If you do not have the import dialogue open already, click the "Users" icon in the left-hand menu -> Click the "cloud" icon in the top-right -> Select "Import user data".
- Click the "Select .csv file" button -> choose your file -> click "Next".
- The next screen will show you how many rows will be imported. If a row contains an error, the whole row will be ignored and it will not be imported. You can choose to ignore the rows with errors or fix them and try again.
- Click the "Start Import" button, and you're done! You'll receive an email when the import has been completed.
- Uploaded .csv file is invalid: Make sure you have saved your file as a CSV (comma delimited).
- Required column missing: The following columns must be included in your file: External_User.external_id and UV ID or user email.
- Required values missing: Make sure the following required columns are filled in with your data - they cannot be empty cells: External_User.external_id and UV ID or user email.
- Invalid values provided: Your field values may not be in the correct format. You can find the accepted content for your user and account fields in this article.
- Unrecognized column provided: This means that one of the column headers is not recognized by our system. Make sure you are using the headers directly from the template and that any custom fields you are importing have already been created as detailed here.
Q: Can import just account traits?
A: Yes, click the user icon in the left-hand menu -> click the "Accounts" tab -> click the "cloud" icon at the top -> Choose the option to "Import account data." Make sure to use the template which will be pre-filled with your account fields.
Q. My import created a new UserVoice user, can I edit their display name or email address?
A. At this time, we do not have a way to edit a user's name or email address within UserVoice. If you'd like to see this added, add your support to the idea on our forum.
Q: How do I delete the traits I imported?
You can always use our API to do this as documented here or you can do this with another import.
- Delete Values: Place
#DELin the field’s cell in your spreadsheet. The following cannot be deleted: the user.id, external_user.id, external_user.email_address, and account.external_id.
- Delete an External User or Account: Set the 'delete account' or ‘delete external user’ column to
#DELon that row (all other values in that row will be ignored). This is the last column in the template. Note: You cannot unlink an external user from an account without either deleting the external user or the account.
A: For the maximum size CSV file (100K records), the import may take up to an hour to process.
Q: Can I import supporters of a suggestion?
A: This article will walk you through how to import supporters and requests on an idea.
Q: How can import more than 100,000 rows at once?
A: At this time, this is not possible. If you want to see us add support for this, please share your idea on our forum.