Bulk Upload Users - CSV troubleshooting guide

Bulk Upload Users - CSV troubleshooting guide

This article provides troubleshooting support for CSV file errors encountered during the bulk upload users process. 

To learn how to bulk upload users, please refer to this article - How to bulk upload new users

Issues related to language-specific characters

What does this problem look like? 

When opening, the file may display characters differently than intended. Language-specific characters may appears as different symbols, and text may become unreadable. 

This can occur as .CSV files when you export data are in UTF-8 format. By default, Microsoft Excel uses ANSI encoding which causes many special characters, such as Chinese Characters/Logograms, to display incorrectly. 

How to resolve? 

You can change your settings in excel to resolve this. 
  1. In Excel, navigate to Data > Import External Data > Import Data/Import from text and choose 65001 Unicode (UTF-8)
  2. Save these settings then reopen the file to confirm that the special characters are displayed correctly
Issues related to column-merging/incorrect cell layout

What does this problem look like? 

Cells may merge together into a single cell, with cell partitions not displaying correctly. This can occur due to the CSV not being parsed into columns correctly. 

How to resolve? 

You can find additional information on how to resolve here. You can use the data tab to set Text to Columns or you may find that importing the data as CSV in the UTF-8 format will resolve.


    • Related Articles

    • How to bulk upload new users

      In order to bulk upload new users into a Zaptic instance, you need; Access to the Zaptic portal User Management permissions 1. In order to bulk upload users, first navigate to the teams page and select the bulk upload users button. 2. From here you ...
    • How to upload a users call file

      When adding a new TDM, you need to update their location ownership within the Zaptic portal. You can view a users call file from the teams page > finding the user > selecting them > and then clicking 'edit locations'. In order to upload a call file ...
    • How to bulk update locations

      How to bulk update locations In order to bulk update locations in Zaptic you need - Access to the portal Data-management permissions A CSV containing the Zaptic ID's of the location you wish to update, and the data you wish to amend 1. Access the ...
    • How to invite new users

      What you need to be able to invite new users to Zaptic -  Access to the Zaptic portal through my.zaptic.com User Management permissions within the portal You need to be a member of any team(s) you wish to add users to when inviting How to invite new ...
    • How to use the troubleshooting page within the app

      1. To access the troubleshooting page, you first need to navigate to the settings cog found in the top left corner of the to-do list page of the app -  2. Then select the troubleshooting section -  3. This page can be used to check for any un-synced ...