Data Import: New interface, improved field mapping, and more

Data Import: New interface, improved field mapping, and more

Hello everyone!

We’ve redesigned the data import process to ensure accurate field alignment and verify that every column in the uploaded file maps correctly with Desk fields before import. Here's how:

Streamlined Import Steps

Importing data is now more guided and detailed—from selecting multiple modules to mapping fields with clearer steps and improved instructions at every stage—it is now simpler to validate and manage imports.



User can now review and validate every mapping detail before proceeding:
  1. Field in File: Displays the column names contained in the first row of data in the uploaded file, which helps identify the data source for each field.
  2. Desk Fields: Shows the corresponding field names in Zoho Desk, ensuring that each imported data point lands in the right place.
  3. Field Format: Allows users to set formatting for data in a field, especially dates and times, for consistency after import.
  4. Sample Data from File: Displays real examples from the second and third rows of import file, letting a user verify that each mapping and data format looks correct before importing.






Import History

The Import History page shows every a record of the imported files in one place along with the following details:
  1. Import ID, module name, and import stage
  2. Import status (In Progress, Success, Failed, Waiting)
  3. Imported by and imported time

Additional capabilities

  1. Add data to existing imports: New records can be added to a completed import using the same module and field mappings. No need to start over; Desk automatically applies the previous mapping setup for continuity.

  2. Revert imports: Undo imported data in just one click. If users have added data multiple times (e.g., Add Data 1, Add Data 2), reverting will remove only the latest addition.

  3. Detailed error logs: Identify why an import failed in the new Error Logs section lists so the users can correct and re-import without repeating previous errors.

Points to remember

  1. Add Data is available only if the original import was successful.
  2. A user cannot modify mappings while adding data as it follows the original import setup.
  3. Unsupported file types (.xls, .pdf, etc.) will be automatically separated under Unsupported Files.
The new interface for import is now available in all data centers. For more details, please refer to the help document.

PM: @Nivedhan Senthilkumar 

Regards,
Velantina V
User Ed | Zoho Desk

    • Sticky Posts

    • 2024 Email Authentication Standards: Elevating Security with Google and Yahoo

      In contemporary email communication, email authentication plays a pivotal role in mitigating email fraud, spam, and phishing attacks. Brace yourself for a new level of security. Starting February 2024, Gmail and Yahoo will be implementing robust email

    • Using Agent Email Address as From Address

      Currently, while replying to a ticket, it is possible for agents to choose their own email addresses as 'from' addresses. Although we built this just for that little extra flexibility, in hindsight, it hasn't figured much in conventional usage.  Almost all businesses prefer that responses to their customers' tickets be sent from the common support/service email address and NOT from those of individual agents. During personal interactions at events, some of you have even made passing mentions about

    • Edit and Delete options in Comments

      A lot of teams have been using ticket comments extensively to collaborate everyday. Notification Center further improved this experience by bringing real-time updates. As we continue to build more improvements to this experience, we've shipped a small-yet-important

    • Webinar 2: Supercharged customer support for growing business

      Join us for this webinar and learn how to step up your support game using a real-time communication platform to generate happier, more successful customers. In this live webinar, we will will discuss the importance of SalesIQ for your support team and how it can help you:  Understand your customers better and their journeys to proactively support and engage them even before they ask for help.  Integrating real time conversations into Zoho Desk’s Support, providing a conversational customer service

    • Customize Colors of your Customer Self Service Portal

      You asked for it. We heard you. We're happy to roll out the most sought after feature request, Customizing the Colors of your Customer Self-service Portal. Now you can set the color of your customer portal to mimic your company's web site, so that your customers visiting the portal will not feel alienated by the default theme.  Go ahead and configure the color of the header, tabs, fonts and background according to your needs. You can either choose between default color themes like Blue, Grey, Green