Narrative 13: Import - Data mapping

Narrative 13: Import - Data mapping

Behind the scenes of a successful ticketing system: BTS Series

Narrative 13: Importing your data


When importing data into an application, it is crucial to prevent data loss or duplication. These types of errors can hinder the development of a clean and well-organized database, which is essential for effective data management and security.

Zoho Desk provides robust functionality for importing your data. The system intelligently automates the mapping of modules and fields to reduce the risk of data loss and maintain data integrity. Users have the advantage of verifying the field mappings in advance, thus adding an extra layer of security to the import process.

This capability is essential not only for clarity but also in mitigating the challenges associated with user adoption. For instance, clients can be accurately mapped to the "Contact name" field, while company names align with the "Account name" field to maintain an organized database, which helps ensure user trust in the system. 

Related knowledge base article: Importing data into Zoho Desk

Quote

Prerequisites

  1. Users can upload a .csv file or a .zip file containing multiple .csv files. 
  2. The .zip file must be named, for example, Contacts.zip, Accounts.zip, etc.

What are Identifier Fields?  

Identifier fields are fields used to find and match existing records when importing data into the product. They also help link related records, like connecting a contact’s name with their email address.

Each module supports different unique identifier fields for identification, as described in the table below:.  

Modules

Unique Identifier Fields

Accounts

Account ID

Account External ID

Account Name

Contacts

Contact ID

Contact External ID

Last Name

First Name

Email

Phone Number

Mobile

Tickets

Ticket ID

Ticket External ID

Ticket Number

Products

Product ID

Product External ID

Product Name

Tasks

TaskId

Task External ID

Calls

Call ID

Call External ID

Events

Event ID

Event External ID

Article Translation

Translation: External ID

Translation ID

Custom Modules

Record External ID

Custom Module Name

Quote

Points to remember: 

  1.  These fields help find matching records. 
  2.  If multiple records match the value, the first matching record will be selected automatically. 
  3. This can lead to unexpected matches or data being updated in the wrong record if you're not careful. 

Background:

  • Some users expressed a preference for matching Contacts by Last Name instead of Email, highlighting the importance of flexibility in their workflow. 
  • Other users approached matching through the use of a custom field, emphasizing the need for tailored solutions to fit their unique requirements. 
  • We also heard from many users who requested that the functionality be enhanced by updating existing records with the relevant entity's Zoho Desk ID to streamline their processes and improve data accuracy.

Working with the Identifier Field

When importing data into Zoho Desk, the Identifier Field is important because it helps identify existing records and avoid duplicate entries. 

Commonly used identifier fields

  • Find By is used to identify an existing record during the import process.
  • Map By is utilized to link a child record to a parent record, for instance, by linking a Contact to a Ticket.
You can now select specific fields for matching, providing enhanced control and customization during bulk processes or integrations. This functionality enables more precise data handling, ensuring that the information aligns with your specific requirements. By tailoring the matching criteria, you can streamline processes, enhance efficiency, and provide better outcomes for your team. This flexibility enables you to harness the full potential of your data.

Improvements in user experience 

Transparent process and status tracking 

We’ve implemented a straightforward, step-by-step process for data imports, complete with real-time status updates for each stage. This transparency enables users to monitor import progress and understand the current state of the process.

Unique identifiers for entity mapping 

New fields have been introduced to help users identify if a parent entity already exists when importing related child entities. For example, users can seamlessly map a contact to an existing account in Zoho Desk to streamline the import process while minimizing the risk of duplicate entries.

Enhanced error handling and log accessibility

We’ve made significant improvements in error handling by allowing users to download detailed error logs right from the history page in case of import failures. This enhancement provides users with greater insight into any issues and facilitates faster troubleshooting and resolution.

Support for custom modules

The import UI has been revamped to support custom modules, providing users with greater flexibility and customization options. This enables a more personalized and efficient data import experience.

Coming up soon

Custom unique fields

Identifying key data points, such as a Customer ID in the Contact Module, ensures that every customer has a distinct reference, which streamlines ticket management and resolution. By establishing these fields as identifiers, support agents can quickly access and update customer records, enhancing response times and accuracy.

External ID fields 

Integration with various systems often generates External ID fields, such as CRM ID, Invoice ID, and Bug ID. Utilizingthese fields as identifiers enables agents to cross-reference relevant records seamlessly. When records need to be updated or retrieved from different systems, these unique identifiers are crucial in maintaining data consistency across platforms.

Composite identifier fields

Often, relying solely on a single identifier may not be sufficient to pinpoint a customer accurately or a record.Implementing multiple fields as composite identifiers can enhance data integrity and accuracy. For example, considering both the Last Name and Email of a contact can significantly reduce errors in data retrieval and ensure that support inquiries are directed and resolved correctly.

Wrapping up

Using these features positions support teams to operate more effectively and improve overall customer interactions. For instance, a large corporation merging client data from multiple legacy systems into Zoho Desk modules will benefit significantly from automatic field mapping to ensure that contact and account names are accurately aligned. This attention to detail not only improves the user experience but also enhances overall data integrity during the merging process.


Please stay tuned for more in the Desk behind-the-scenes series.

 

Regards,

 

Kavya Rao

The Zoho Desk Team


    Access your files securely from anywhere

        All-in-one knowledge management and training platform for your employees and customers.






                              Zoho Developer Community




                                                    • Desk Community Learning Series


                                                    • Digest


                                                    • Functions


                                                    • Meetups


                                                    • Kbase


                                                    • Resources


                                                    • Glossary


                                                    • Desk Marketplace


                                                    • MVP Corner


                                                    • Word of the Day


                                                    • Ask the Experts





                                                              Manage your brands on social media



                                                                    Zoho TeamInbox Resources



                                                                        Zoho CRM Plus Resources

                                                                          Zoho Books Resources


                                                                            Zoho Subscriptions Resources

                                                                              Zoho Projects Resources


                                                                                Zoho Sprints Resources


                                                                                  Qntrl Resources


                                                                                    Zoho Creator Resources



                                                                                        Zoho CRM Resources

                                                                                        • CRM Community Learning Series

                                                                                          CRM Community Learning Series


                                                                                        • Kaizen

                                                                                          Kaizen

                                                                                        • Functions

                                                                                          Functions

                                                                                        • Meetups

                                                                                          Meetups

                                                                                        • Kbase

                                                                                          Kbase

                                                                                        • Resources

                                                                                          Resources

                                                                                        • Digest

                                                                                          Digest

                                                                                        • CRM Marketplace

                                                                                          CRM Marketplace

                                                                                        • MVP Corner

                                                                                          MVP Corner







                                                                                            Design. Discuss. Deliver.

                                                                                            Create visually engaging stories with Zoho Show.

                                                                                            Get Started Now


                                                                                              Zoho Show Resources

                                                                                                Zoho Writer

                                                                                                Get Started. Write Away!

                                                                                                Writer is a powerful online word processor, designed for collaborative work.

                                                                                                  Zoho CRM コンテンツ




                                                                                                    Nederlandse Hulpbronnen


                                                                                                        ご検討中の方




                                                                                                                • Recent Topics

                                                                                                                • Refresh frequency

                                                                                                                  Dear Zoho Team, I really, truly appreciate that Zoho Books gets frequent updates. As a matter of fact this is how a good SaaS company should stay on top. However, I feel that I have to hit refresh almost every day. This was exciting at the beginning but
                                                                                                                • Weekly Tips : Save Time with Saved Search

                                                                                                                  Let's assume your work requires you to regularly check emails from important clients that have attachments and were sent within a specific time period. Instead of entering the same conditions every time—like sender, date range, and attachments included—you
                                                                                                                • Discontinuing Zoho ShowTime service on May 30, 2026

                                                                                                                  Hello everyone, As a follow-up to our earlier announcement, we’d like to share an important update regarding Zoho ShowTime’s discontinuation timeline. Zoho ShowTime, our online training platform, reached its end of life on December 31, 2025, and its services
                                                                                                                • Ability to CC on a mass email

                                                                                                                  Ability to CC someone on a mass email.
                                                                                                                • Bookings duration - days

                                                                                                                  Hi team, Is there any way to setup services/bookings that span multiple days? I am using Zoho Bookings for meeting room bookings. Clients may wish to book a room for more than one day, for up to a month.  If not, is there a plan to allow services to be setup with durations of Days as well as hours and minutes? Many thanks, Anna.
                                                                                                                • Customer address in Zoho Bookings

                                                                                                                  Hello,  Is it possible to add customer address information to the Zoho bookings appointment screen? Or have it pull that information automatically from the CRM? We are wanting to use this as a field management software but it is difficult to pull the address from multiple sources when it would be ideal to have a clickable address on the appointment screen that opens up the user's maps.  It would also be advantageous for the "list view" to show appointment times instead of just duration and booking
                                                                                                                • Feature Request - Allow Customers To Pick Meeting Duration

                                                                                                                  Hi Bookings Team, It would be great if there was an option to allow customers to pick a duration based on a max and minimum amount of time defined by me and in increments defined by me. For example, I have some slots which are available for customers
                                                                                                                • New feature: Invite additional guests for your bookings

                                                                                                                  Hello everyone, Greetings from Zoho Bookings! We are happy to announce the much-awaited feature Guest Invite, which enhances your booking experience like never before. This feature allows additional participants to be invited for the bookings to make
                                                                                                                • Changing the owner of a call

                                                                                                                  Am I correct in my conclusion that I cannot change the owner of a call in Zoho? The field does not show up in the screen, nor can I make it show up as the systems does not give me that option. I cannot "mass update" it either. I tried it, but Zoho refuses to change the name of the owner. Please help out: how do I change the owner of a call.
                                                                                                                • Unified Notes View For Seamless Collaboration

                                                                                                                  To facilitate better coordination among different departments and team members, the notes added to a record can now be accessed in all its associated records. With this, team members, from customer service representatives to field technicians, can easily
                                                                                                                • Remove Profiles from "Forecast" Module

                                                                                                                  How can I remove Profiles from My forecast Module? Image Below The only revenue generators are the VP's, and the Estimation Managers, and the Estimators subordinate to the Est. Managers. How can I remove the unused Profiles? Its frustrating to see them
                                                                                                                • Uplifted homepage experience

                                                                                                                  Editions: All editions. Availability update: 17th February 2026: All editions in the CA and SA DC | JP DC (Free, Standard and Professional editions) 23 February 2026: JP (All Editions) | AU, CN (Free, Standard, Professional editions) 27 February 2026:
                                                                                                                • Restoring records from the recycle bin programatically

                                                                                                                  Background I'm working on a piece of software to automate conversion of Leads into Deals based on order status from my company's website. The process is mostly complete, right now I'm just working on handling a few edge cases to ensure data integrity.
                                                                                                                • Does Zoho Learn integrate with Zoho Connect,People,Workdrive,Project,Desk?

                                                                                                                  Can we propose Zoho LEarn as a centralised Knowledge Portal tool that can get synched with the other Zoho products and serve as a central Knowledge repository?
                                                                                                                • All new Address Field in Zoho CRM: maintain structured and accurate address inputs

                                                                                                                  Availability Update: 29 September 2025: It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition exclusively for IN DC users. 2 March 2026: Available to users in all DCs except US and EU DC. Latest
                                                                                                                • Create static subforms in Zoho CRM: streamline data entry with pre-defined values

                                                                                                                  Last modified on (9 July, 2025): This feature was available in early access and is currently being rolled out to customers in phases. Currently available for users in the the AU, CA, and SA DCs. It will be enabled for the remaining DCs in the next couple
                                                                                                                • Invoices not arriving and mail server settings

                                                                                                                  I am having an issue where some clients are not receiving invoices. I have configured Zoho Books to send on my behalf and configured the appropriate SPF, DKIM and DMARC settings on my mail server and tested these as working. I get the CC'd copies so I
                                                                                                                • SalesIQ Identity Update for Logged In Wordpress User

                                                                                                                  Hey folks, SalesIQ does not automatically detect when a visitor logs in to WordPress and update their identity to match. For example, if a client of ours visits the site and logs in, SalesIQ will not track them correctly by default. The Solution The solution
                                                                                                                • Paragraph spacings in Zoho Notebook are double-spaced only. Is there a way to keep the original spacing format?

                                                                                                                  Sorry I don't know the proper terminologies but the best way I can put it is all single-spaced paragraphs that I copy to Zoho Notebook become double-spaced paragraphs. It's very inconvenient and counterproductive when copying and pasting things from and
                                                                                                                • Changing line space in Notebook

                                                                                                                  My lines are double spaced. How do i change to single space?
                                                                                                                • Plug Sample #14: Automate Invoice Queries with SalesIQ Chatbot

                                                                                                                  Hi everyone! We're back with a powerful plug to make your Zobot smarter and your support faster. This time, we're solving a common friction point for finance teams by giving customers quick access to their invoices. We are going to be automating invoice
                                                                                                                • Workdrive on Android - Gallery Photo Backups

                                                                                                                  Hello, Is there any way of backing up the photos on my android phone directly to a specific folder on Workdrive? Assuming i have the workdrive app installed on the phone in question. Emma
                                                                                                                • Auto sync Photo storage

                                                                                                                  Hello I am new to Zoho Workdrive and was wondering if the is a way of automatically syncing photos on my Android phone to my workdrive as want to move away from Google? Thanks
                                                                                                                • Is anyone experience missing functions in the new UI until hard refresh?

                                                                                                                  The set of functions including search is almost always missing upon loading an app in the new UI. If you refresh, the functions return. (see second screenshot) Anyone else experiencing this?
                                                                                                                • Not receiving New Ticket Emails

                                                                                                                  Hello! The company I work for uses the Zoho ticketing system, however, I've noticed I'm not receiving email notifications when new tickets are published. I have admin rights to see these tickets on Zoho Desk and respond to them, but am not receiving the
                                                                                                                • Can't update a field on a parent form from a child form's On Success workflow

                                                                                                                  Title: Can't update a field on a parent form from a child form's On Success workflow Hi everyone, I'm building a simple Golf Lesson Tracker app and I'm stuck on what should be a basic operation — updating a number field on a parent form when a child form
                                                                                                                • Upload from Zoho Creator File Upload field to OpenAI Vector Store

                                                                                                                  I’ve struggled for quite a while to get this working properly. For a long time we relied on Azure Functions as a workaround to handle file transfers between Zoho Creator and OpenAI Vector Stores. It worked, but added unnecessary infrastructure and complexity.
                                                                                                                • Calendar start time limit

                                                                                                                  Hi all, Has anyone found a magical way to filter calendar reports to start from, let's say 8:00, and not 0:00? Or at least to auto scroll there like Google Calendar for example?
                                                                                                                • EU Problem

                                                                                                                  Hi all, we've been facing issues with the Europe data center for two days. It's starting to disrupt our daily workflow. Any word on when this will be resolved?
                                                                                                                • How can I clone my website in order to try new templates?

                                                                                                                  I want to try a new template for my existing Zoho website without the risk of changing the current site or accidentally publishing the wrong template. Therefore I thought a 'clone website'-option should be somewhere, but I can't find it. How do I try
                                                                                                                • Custom Module Missing from Roles & Permissions List

                                                                                                                  Hi Zoho Community, I created a new Custom Module in Zoho Expense. The module is fully built and I can see it in the Module Builder (Settings > Customization > Modules). However, I am unable to deploy this to my users because the module does not appear
                                                                                                                • Need Customer Item Inward Module along with QC

                                                                                                                  Need Customer Item Inward Module along with QC 1. Using Transfer Orders hit the item balance sheet 2. Items without inventory it becomes difficult for tracking purpose. 3. Custom Modules become tedious to capture multiple items, item subforms are not
                                                                                                                • Possible to Turn Off Automatic Notifications for Approvals?

                                                                                                                  Hello, This is another question regarding the approval process. First a bit of background: Each of our accounts is assigned a rank based on potential sales. In Zoho, the account rank field is a drop-down with the 5 rank levels and is located on the account
                                                                                                                • Will be possible to create a merge mail template for products?

                                                                                                                  Hi, we would need to create a mail merge template for products (native) module. Will be possibile? or do you have a smart solutions to merge products data with a mail merge? thanks Chris
                                                                                                                • Maximum incoming email (attachment size) limit

                                                                                                                  I see that the maximum size of received emails can now be set to 20MB, however I'd still like to see it be larger. It's embarrassing when a client sends me an email with a large attachment and I can't receive it. 50, even 100 MB seems reasonable these
                                                                                                                • [Free Webinar] Learning Table Series - Multi-currency management in Zoho Creator

                                                                                                                  Hello everyone, We’re excited to invite you to another edition of the Learning Table Series webinar. As you may already know, we've moved to a purpose-based approach in the Learning Table Series this year. Each session now focuses on how a Zoho Creator
                                                                                                                • LESS_THAN_MIN_OCCURANCE - code 2945

                                                                                                                  Hi I'm trying to post a customer record to creator API and getting this error message. So cryptic. Can someone please help? Thanks Varun
                                                                                                                • Ranking by group in report

                                                                                                                  Dears, I am new to Zoho Analytics and I would like to ask you guys help to creating a ranking column. Report type: Pivot Matter: I want to create a ranking column on the right of Percentage. This ranking is group by column Type, and ranking by Final Score/Percent.
                                                                                                                • How do I add a project template to a pre-existing project?

                                                                                                                  Help....How do I add a project template to a pre-existing project? Right now I have to delete the old project, make a new one and add the project template at the time of creating the new project.
                                                                                                                • Passing the image/file uploaded in form to openai api

                                                                                                                  I'm trying to use the OpenAI's new vision feature where we can send image through Api. What I want is the user to upload an image in the form and send this image to OpenAI. But I can't access this image properly in deluge script. There are also some constraints
                                                                                                                • Next Page