Importing Data in Zoho Desk - Online Help | Zoho Desk

Importing Data in Zoho Desk

This feature is released in a phased manner and will be available only to those who request for it. To request early access, click the registration link and provide your details. We will enable the feature for your Desk account. 
Most organizations maintain a secure data repository for internal usage and reference. When there is a need to import that data within an application, it's essential to avoid any data loss or duplication that prevents the building of a clean, well-organized database.  

Zoho Desk allows users to import data in bulk. The system automatically maps the modules and fields, which significantly reduces the chances of data loss and also maintains data sanctity by allowing users to verify the field mappings beforehand. 

This plays an important role in preventing confusion and significantly reduces the challenges of user adoption. For example, clients can be mapped to the "Contact name" field. Similarly, the company name can be mapped to "Account name". 

Availability
Permission Required
Users with the Support Administrator permission profile can access this feature.
Check Feature Availability and Limits

Initiating data import

Zoho Desk allows admins to import tickets, accounts, contacts, products, tasks, events, calls, custom modules, and KB articles. Only .csv files can be imported, such as <modulename>.csv or <modulename>_<id>.csv. For example, for Tickets module it should appear as Tickets.csv or Tickets_<id>.csv

Note: XLS format is not supported for import. A maximum of 10,000 rows or a maximum of 30MB file size (CSV file) can be imported.

Prerequisite

  • Create a .zip file containing the CSV file of the data that needs to be imported.
  • Users can also upload a direct .csv file or as a .zip file containing multiple .csv files.
  • The .zip file must be named as, for example Contact.zip, Accounts.zip etc.

Importing data comprises the following steps:

File upload

Select the Desk module where the data should be imported and upload the respective .csv or zip file. As mentioned in the prerequisite, the CSV files must be named appropriately to auto-map them to the selected module. The maximum file size of the .zip file cannot exceed 30MB.

Unmapped files

The system will analyze the uploaded file. If the file name doesn't match the required format, it will be moved to the un-mapped files. From there, users can drag and drop it to the Mapped Files and proceed with the import.

 

Field mapping

Users need to select what should be done with the records:
  1. Create a new record and skip the existing records. The system will identify the duplicate records and skip it during import. If the records are unique or are not already present in the respective module, a new record will be created.  Users can select a unique field using which the system will identify duplicate records. For example, Account ID, Last name, Ticket ID, phone number, email address, and so on.  Users can also identify duplicates by using one of the following methods: external ID, module name, or by choosing the None option. Refer to the table for a complete list of module-specific unique fields and external IDs.



    Note: If a user doesn't have a unique ID for the records in their CSV file, they can choose the None option. However, entities created with this option cannot be updated later. Without a predefined field, the import tool cannot identify if the entity already exists in Zoho Desk, and therefore cannot update it.

  2. Update only the existing records. The system will use the above-mentioned unique field to identify existing records in the modules. If a duplicate record is found, then it will update the field values with the ones provided in the import file. However, if there are more than one duplicate record the system may not update the field value. The user must manually verify the record and the values.
  3. Both the above - If both options are selected, then the field value will only be updated if a duplicate record is found; if not, a new record will be created in the respective module.
The fields from the CSV file will be automatically mapped against the fields present in the Desk module if the field name in Desk and the column name in the csv file are same . You can change it by selecting the right field from the dropdown. During field mapping, users can choose to update the Desk fields.
External ID, a unique identifier for each entity, is used to identify duplicates during import and map parent entities (e.g., associating tickets with contacts). The Ticket ID field in a CSV file from FreshDesk or ZenDesk can serve as an external ID for data migration. 
List of modules from CSV file that can be mapped to the Desk module during import module
Module
To be mapped to (Module)
To be mapped to (Fields)
Accounts
  • Products

  • Agents

  • Product ID

  • Product external ID
    -------------------------

  • Agent ID

  • Email ID

Contacts
  • Products

  • Accounts

  • Agents

  • Product ID

  • Product external ID
    ------------------------

  • Accounts ID

  • Account name

  • Account external ID
    -------------------------

  • Agent ID

  • Email ID

Tickets

  • Products

  • Account

  • Contact

  • Department

  • Teams

  • Agent

  • Product ID

  • Product external ID
    -------------------------

  • Accounts ID

  • Account name

  • Account external ID
    -------------------------

  • Contact ID

  • Contact External ID

  • Contact Email ID

  • Contact Last Name

  • Phone
    --------------------------

  • Department ID

  • Department Name
    --------------------------

  • Team ID
    --------------------------

  • Agent ID

  • Email ID

Events/Calls/Tasks
  • Contact

  • Ticket

  • Department

  • Teams

  • Agent

  • Contact ID

  • Contact External ID

  • Contact Email ID

  • Contact Last Name

  • Phone
    ---------------------------

  • Ticket ID

  • Ticket External ID
    --------------------------

  • Department ID

  • Department Name
    --------------------------

  • Team ID
    ---------------------------

  • Agent ID

  • Email ID

Knowledge base
  • KB

  • Agents

  • Category ID
    ---------------------------

  • Agent ID

  • Email ID


If the date or date and time field has a different format in the import file

If the Date and time or date fields in the import file do not match the format in which the values are supposed to be present in Desk, then the system will automatically format it for compatibility. Such fields will be listed with the file name: Field Name, format <Column Name In the File>_isoDate for date fields or <Column Name In the File>_isoTime for date time.


Users must map the original import field to None and map the system generated field to the appropriate Desk field.

The table below is for field mapping reference. 
Alternatively, users can change the fields in the accepted format and re-upload the file by initiating a fresh import.

Review

Users can review the import details and make changes if needed.

To import data to desk modules
  1. Log into your Desk account with administrative privileges.
  2. Navigate to Setup > Data Administration > Import/Export > Import.
  3. Click New Import.
  4. In the File Upload tab, select the module from the drop-down list.
  5. Click Browse File and upload the CSV file or .zip containing the CSV file to be imported from your system.
    Check the unsupported files and re-upload the file if needed. The file size cannot exceed 30MB/file.
  6. Click Next.
  7. Under Mapping, select from the following options:
    • Create a new record and skip existing records
    • Update existing records
    • Both
  8. Select a field to identify duplicates from the drop-down list.
  9. Check the field mapping and make changes as needed.
  10. Click Next.
  11. Review the import details. You can go back to make changes.
  12. Click Start Import.
    It will take some time to complete the import process; the progress will be displayed on the Import History page

Viewing import history

Import history is a logbook for all the imports that have been performed in the account. The list view shows the following details about each import:

  • Import ID
  • Module to which the data was imported
  • Import stage, such as review in progress or import completed
  • Import status, such as in progress, success, failed, or waiting 
  • User who initiated the import
  • Date on which the import was performed

Upon clicking the import ID, a detailed report is generated, providing information on the total number of records, the count of records imported, skipped, and failed.


Viewing the error log

Some records that are not successfully imported can be viewed under Completed with error under the error log. The report can be exported for reference. 


Reverting import

The UI Import feature supports reverting, allowing users to undo the creation of all entities and their mapped child entities. However, entities that were updated during the import process cannot be reverted. Only the import that was successful or completed with error can be reverted within two weeks of import. If the import was completed more than two weeks ago, you will not find the option to revert.

Note, if the data is updated using either the Update or Upset options, you will not be able to revert the import.

    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Importing Data to Zoho Desk - Old UI

                                                                                                                If you've been using a help desk software before Zoho Desk, you must start importing your existing data to Zoho Desk. You can import your support tickets, contacts, customer accounts, knowledge base articles, products, calls, events, and tasks to ...
                                                                                                              • FAQs: Data Administration

                                                                                                                Can I retrieve deleted records from the recycle bin? Yes, it is possible to retrieve deleted records. The recycle bin is a temporary storage location for deleted records in Zoho Desk. It is designed to give users the ability to retrieve any ...
                                                                                                              • Introduction to Zoho Desk

                                                                                                                Help Desk is a department in an organization that is in charge of providing the support needed by customers while using the company's product or a service. Customers contact the help desk when they have a question or a problem and a product expert ...
                                                                                                              • Assisted Data Migration Guide

                                                                                                                Whether you’re moving from a cloud-based or on-premise system, you’ll need to find an efficient method of migrating your data to Zoho Desk. Our dedicated migration team can help you migrate your data safely and ensure your help desk operation is up ...
                                                                                                              • Migrate Data From Other Help Desk Servers to Zoho Desk (Zwitch)

                                                                                                                Customer support is the cornerstone of every organization. Businesses mostly rely on help desk software that simplifies ticket management, streamlines support processes, and improves overall customer satisfaction. As businesses expand, the ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources