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









                          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

                                                                                                          • Tip of the week #31: Share your personal calendars within organization.

                                                                                                            Keep your Organization members aware of what's happening. In Zoho Calendar, you can share your personal calendar with all the members in your organization using the Share with org option.When you enable org sharing for a particular personal calendar,
                                                                                                          • Tip of the Week #33: Appointment scheduler in Zoho Calendar.

                                                                                                            In Zoho Calendar, you can use the Schedule Appointment option to share your appointment request form with the public, allowing people to fill out the form to request an appointment with you. This form can be embedded on your website or blog. Visitors
                                                                                                          • Tip of the Week #34: Embed Calendars using Zoho Calendar

                                                                                                            You can make your calendars public and visible to the general public by embedding them in your websites/blogs using Zoho Calendar. You can use the embed code to add your own calendars to your website's/ blog's HTML code, and the calendar will appear on
                                                                                                          • Tip of the week #35: Migrate to Zoho Calendar from Google Calendar.

                                                                                                            If you are looking to move your Google Calendar events to Zoho Calendar, never worry about missing out the events from your Google Calendar. You can migrate the events from Google Calendar using the export option and import it to Zoho Calendar and manage
                                                                                                          • Tip of the week #36: Migrate to Zoho Calendar from Outlook Calendar.

                                                                                                            If you've been using Outlook calendar and looking to migrate to Zoho Calendar, you can seamlessly export your calendars from Outlook and import them into Zoho Calendar without losing any events, participants, and the reminders set for each event. To migrate
                                                                                                          • Shared calendar issues and duplications

                                                                                                            Apparently there was a calendar update?  Now when I schedule an event for a team member that has shared his calendar with me, the event makes me the organizer and adds the event to my calendar as well.  Previous to this "update" I would scheduled an event
                                                                                                          • Subscribed Calendar

                                                                                                            Hi i have subscribed to a calendar for Holidays in Canada it shows all the holidays perfectly but every one of them has the word Canada before the rest of the name is there a way to remove that word Canada? It takes up a lot of space in the square on
                                                                                                          • The year that was at Zoho Calendar 2023- Part 1

                                                                                                            Hello, amazing community members! Happy new year from all of us here at Zoho Calendar. As we begin the new year, we'd like to thank each and everyone of our community members for your unwavering support and love that you have shown for Zoho Calendar.
                                                                                                          • Zoho Calendar 2024: A Year in Review

                                                                                                            Hello, community members! Happy new year from all of us here at Zoho Calendar. As we turn the page to a new year, we extend our heartfelt gratitude to every member of our Zoho Calendar community for your continued support and enthusiasm. Your feedback
                                                                                                          • Zoho Calendar not syncing correctly with personal Google Calendar

                                                                                                            Coming to this forum as Zoho Calendar support team is not responding, any more. For the past 8 weeks, I have been having an issue with Zoho Calendar not syncing with my personal Google Calendar correctly. I subscribed to Zoho Calendar iCal in my personal
                                                                                                          • MTA - BAD IP reputation by outlook/hotmail

                                                                                                            Messages to Microsoft email servers are bouncing back due to poor reputation. Message: 4.7.650 The mail server [136.143.188.206] has been temporarily rate limited due to IP reputation. For e-mail delivery information see https://postmaster.live.com (S775)
                                                                                                          • Zeptomail API error 500 internal server error

                                                                                                            Hi Everyone, getting this eror continuously! Can anyone please guide around the same! Zeptomail API error 500 internal server error Best Regards
                                                                                                          • Waiting multiple days to buy credits, causing my website to suffer

                                                                                                            So I own a fairly large website that gets a lot of registered users. I use transmail send activation emails, and also forgot password emails. I sent an email to zoho's presales team when I was only at 4K/10K emails sent, hoping to buy more credits before
                                                                                                          • Follow up

                                                                                                            Hello, I sent a message 2 days ago but I don't receive any response and I cannot find my ticket here. this is the ticket: Your ticket has been created with the ticket ID 68925465 and subject "Fwd: Fishing-alert" looking forward to seeing your response.
                                                                                                          • What's new in TransMail!

                                                                                                            Note: TransMail is now ZeptoMail. Click here to know more. Hello again, everyone! We've recently crossed the 6 months mark of TransMail's launch. In this time post our launch, we have been constantly working on updating our platform and adding new features
                                                                                                          • June 2021 in TransMail!

                                                                                                            Note: TransMail is now ZeptoMail. Click here to know more. Hello again, everyone! Hope you and your loved ones are doing well. If you're doing less than fine, we truly hope that things only get better for you.  We've had a few updates in the past month
                                                                                                          • TransMail has a new name—ZeptoMail!

                                                                                                            Tried navigating to TransMail's community forum but see a different name now? That's because TransMail has a new name. TransMail is now ZeptoMail! As we’ve grown from an internal service used mainly by other Zoho products to an up-and-coming competitor
                                                                                                          • July 2021 in ZeptoMail!

                                                                                                            Note: TransMail is now ZeptoMail. Click here to know more. Hello again, everyone! Hope you and your loved ones are doing well.  We've had a few updates in the past month in ZeptoMail—some new features and some important announcements. Take look at what
                                                                                                          • Send Email From the ZeptoMail BY API

                                                                                                            What is Zeptomail:- Transactional email service with reliable and fast delivery How we can Create a Connection for Zeptomail in Zoho CRM Go to the Setup Click on Connection Enter Connection Details:- Generate Consumer Key & Consumer Secret Using Zoho
                                                                                                          • Customer email on Opencart 3

                                                                                                            When I place an order, 2 emails are sent: 1) administrator 2) to the user The administrator receives a beautiful letter, but the user receives a damaged letter (see screenshot). What could be the problem?
                                                                                                          • [Announcement] Insert image from URL changes in Zoho Writer

                                                                                                            Hi Zoho Writer users! We'd like to let you know that we've changed the behavior of the Insert image from URL option in Zoho Writer for security reasons. Earlier behavior Once you inserted an image URL in a Writer document, the image would be fetched from
                                                                                                          • Dynamic Signature - Record owner

                                                                                                            Hi everyone, I’m using Zoho Writer merge templates from Zoho CRM and have two questions: Owner signature: How can I automatically insert the CRM record owner’s signature in the merged document? I’m not sure where this signature is stored or how to reference
                                                                                                          • Writer sing up problom

                                                                                                            Zoho writer sing up prolom face
                                                                                                          • Unable to copy into a new document

                                                                                                            Whe I create a new Writer doc and attemp to copy and past I get this message. The only way to copy into a document is I duplicate an existing document, erase the text and save it under a different name and then paste the information. Not ideal. Can you
                                                                                                          • [Webinar] Live demos and user Q&A with Zoho Writer product experts

                                                                                                            Join us on June 12, 2025 for live demos based on your use cases and real-world scenarios raised via form. This is also an opportunity to get your questions answered directly by product experts from the Zoho Writer team. Webinar agenda Live demos based
                                                                                                          • Zoho Writer's built-in citation and bibliography generator

                                                                                                            Hey researchers and writers! Do you manually format citations and bibliographies, spending hours jumping between apps and tabs? If so, then check out Zoho Writer's built-in "Citations and Bibliography" feature. Imagine you're writing a thesis on the future
                                                                                                          • Single and group checkboxes in Zoho Writer's fillable forms

                                                                                                            Hey Writer Fam, Are you making the most out of single and group checkboxes in fillable forms in Zoho Writer? Here is a handy tip to optimize your use of checkboxes, both single and group, and enhance your data collection process. Single checkboxes: Single
                                                                                                          • Collaborate efficiently with Zoho Writer's track changes feature

                                                                                                            Hi Zoho Writer Community, Zoho Writer's track changes feature is a simple, built-in solution that helps you and your team work together efficiently. Instead of juggling multiple versions of a document or building up a long email chain of comments, each
                                                                                                          • Zoho Writer's WordPress extensions

                                                                                                            Hey Zoho Writer users! Say goodbye to all your WordPress content publishing woes with Zoho Writer's WordPress extensions. Publish content with all your formatting and images, republish content when you update a document, and more—from a single window
                                                                                                          • Time-saving table hacks

                                                                                                            Hey Zoho Writer Community, Do you find yourself using a lot of tables in your documents? We're here to share some of our time-saving hacks that will help you work more efficiently, organize your data, and make your documents look neat and professional.
                                                                                                          • Automating document approval and signing with Zoho Writer and Zoho Sign

                                                                                                            Hey Zoho Writer Community! Here's another automation tip to make your processes more efficient! Question: Can I send a document for client approval first, then automatically send it for signing with Zoho Sign if they approve? Since it's the same person
                                                                                                          • Customization hacks in Zoho Writer - Part 2

                                                                                                            Hey community, We're back with some more tricks to personalize your documents, save time, and get in the zone when you work in Writer. Check out part 1 of this post if you haven't already. Let's dive right in! Document ruler units Imagine you're creating
                                                                                                          • Simplify your tax calculations with Zoho Writer

                                                                                                            Hello Zoho Writer Community! Tax season can be stressful, but with Zoho Writer, managing your income tax calculations becomes straightforward and efficient. Here’s an example of how you can use the tables and formulae of Zoho Writer to calculate income
                                                                                                          • Enhance document navigation with headings and TOC

                                                                                                            Hey Zoho Writer Community! We're back with some useful features in Zoho Writer that can simplify your document creation and navigation process. Let's dive right in! Check out our video on how to make the most of Zoho Writer's heading and table of contents
                                                                                                          • Use and download in PDF format of Zoho wirter Merge template using deluge

                                                                                                            Hello Zoho Developers. Here is some information about Zoho Writer. Writer is not just another online word processor, it's a powerful tool for editing, collaboration, and publishing. Even with its wide range of features, Writer's pared-down user interface
                                                                                                          • Customization hacks in Zoho Writer - Part 3

                                                                                                            Hello everyone, Welcome back to Part 3 of our customization tips in Zoho Writer! In this third installment, we'll be diving into some essential customization settings that can enhance your document creation experience. Sender email address in mail merge
                                                                                                          • Daytime saving timezones messing up writer pdf

                                                                                                            Hi, I need help for something I can't figure out. I created a Form to collect data and it is set up with my current Daylight Saving Time (GMT-3). This form is used to generate a contract (pdf Writer) with dates from an event that is being held in 4 months
                                                                                                          • Issue with locked content in Writer

                                                                                                            Hi, I have seen the documentation which outlines how to lock specific content within a Writer document so that it can't be modified by collaborators, but I have come across an issue. When the editor locks a paragraph for example, then a collaborator can't
                                                                                                          • Deprecation of certain URL patterns for published Zoho Writer documents

                                                                                                            Hi Zoho Writer users! We'd like to let you know that we have deprecated certain URL patterns for published and embedded documents in Zoho Writer due to security reasons. If the published or embedded documents are in any of these URL patterns, then their
                                                                                                          • Using Mail Merge Template to Print Documents with One Subform Record's Fields per Document

                                                                                                            Hello, We have a Mail Merge template created in Zoho Writer which is not able to perform the functionality which is currently required to automate the documentation task portion of our process. The CRM module we are primarily using is based on a "Loans"
                                                                                                          • Next Page