article-detail-page
knowledge
close

Bulk import troubleshooting.

The following information applies to Voalte Platform 3.7. There may be some differences with older versions of Voalte Platform.™

Below is a list of common issues, error messages, and suggestions related to a bulk import.

Common import errors when bulk importing users to Voalte Admin.

The following table lists common import errors when bulk importing users to Voalte Admin, their potential causes and resolutions. 

Error Cause Resolution
Import Failure

In most cases when this error is received, the value of the input parameter on the .CSV file does not match the Voalte Admin parameter requirements. 

 

  • Verify the client type access is correctly formatted and there are no duplicates (e.g., Client type value voalte_me,voalte_one,voalte_me is incorrect)

  • Verify that the home unit is assigned to the correct building as it appears in Voalte Admin and that the unit and building is spelled correctly.
Incompatible with UTF-8 This error is related to an issue with different versions of Microsoft Excel and how they handle .CSV files. 

Import the file into Google Sheets, export as a .CSV, then upload the file to Voalte Admin™. Please reach out to Voalte if you do not have access to Google Sheets.

Invalid field value There is typically a spelling error that results in a field not matching with a possible option. For example, if the spelling of a unit name in the .CSV does not match what is in Voalte Admin, you will see this error for every row that it applies to.
  • Check the entire .CSV for misspellings of the units, departments or buildings.
  • Verify the client type access is correctly formatted and there are no duplicates.
  • Verify the Title column matches the options in Voalte Admin.
  • Verify the authentication type.

This list is not exhaustive.

Role 1 required, default role required

Either the role in the .CSV is not in Voalte Admin, or the entry in the .CSV is slightly different than how it appears in Voalte Admin.

 

  • Do not use roles that have commas in the name. Roles with commas will not upload properly since Voalte Admin will think the comma is a separator between the role group and role.
  • Double-check the role in the .CSV follows the hierarchy in Voalte Admin, with commas separating the role group(s) and role. 
Username/domain and/or email already in use

A user(s) already exists in the system. Usernames and emails are unique and cannot be associated with multiple accounts, even deactivated ones.

You may also have cleared out the GUID when editing an existing user, so the system thinks you're trying to add a new user.

  • Verify the username or email you are trying to add is not associated with:
    • an active user
    • a deactivated username
  • If you see this when updating an existing user, verify that the GUID cell is not blank. If it is, export the user again and copy the GUID.

Common issues encountered when importing the directory structure to Voalte Admin.

The following table lists common issues when bulk importing the directory structure to Voalte Admin, their potential causes and resolutions. 

Issue Cause Resolution
Building, Unit, or Room names have extra spaces that are not trimmed on import. When creating the directory structure, it can be easy to accidentally add an extra space character. The directory structure .CSV does not strip leading or trailing spaces on upload, unlike the User .CSV. This causes the User .CSV to fail even though the building and units are listed correctly (without spaces) on the User .CSV.  Verify that your .CSV does not contain any extra spaces prior to uploading. Microsoft Excel's TRIM can help with spaces that appear before or after the cell's contents, but not with extra spaces within the content itself.

Leading zeros are stripped from room names or IDs

When opening the .CSV file in Microsoft Excel, it imports the columns as a General data type. This type of format strips leading zeros without any warning. This can be a disruption to the EHR integration feature (room IDs will no longer match the room ID being sent through the ADT feed) if the file is uploaded without being in the correct format. 

Open Microsoft Excel with a blank document. 

  1. Click the Data tab.
  2. Click From Text.
  3. Select Delimited.
  4. Select Comma, Unselect Tab.
  5. Column Data Format: Change any column with numerical data (e.g., Room name or IDs) to Text.

Note: Some versions of Microsoft Excel are missing the scroll bar when setting the column data format in step 5 that is necessary to reach the room name and ID columns.

Microsoft Office instructions