Recent searches


No recent searches

How to migrate tickets and related data from CSV to Zendesk



Posted Feb 06, 2019

Importing data from another help desk to Zendesk while preserving support history is crucial for maintaining strong customer relationships and delivering exceptional service.

This article outlines the steps required to seamlessly import your tickets, including agents, contacts, and other associated data, from a CSV file into Zendesk using the Help Desk Migration service.

Help Desk Migration, an official Zendesk solution partner, provides data migration services tailored to companies seeking to transition their data from one help desk platform to another. It's worth noting that there is a fee associated with using the automatic data migration tool. However, you have the opportunity to test it free of charge before making a payment decision. 

Benefits of migrating data with Help Desk Migration

  • Your data relationships are meticulously preserved throughout the migration process.
  • Enjoy the flexibility of importing an unlimited number of rows in a single file, accommodating even large datasets.
  • You can import all critical data, ensuring that nothing important is left behind during the migration.
  • Take advantage of the ability to conduct unlimited migration tests to ensure a seamless transition.

Help desk records you can import

You can import the following help desk records using this data migration tool:

  • Groups
  • Agents
  • Companies
  • Contacts
  • Tickets
  • Ticket comments
  • Tags
  • Attachments
  • Standard and custom fields

You also can import Knowledge Base objects, including:

  • Categories
  • Folders
  • Articles

Preparing data for migration

To begin the migration process, it's essential to organize your data into the following CSV files:

  • CSV file with tickets
  • CSV file with ticket comments
  • CSV file with Knowledge Base.

When preparing your files, please ensure they meet the following requirements:

  1. File Size Limit: Keep each file under 1GB in size.
  2. Include Headings: All files must have a heading row that clearly labels each column.
  3. Delimiter: Use a comma as the delimiter to separate data within each row.
  4. Attachments: For importing attachments, provide publicly accessible URLs for each attachment. If there are multiple attachments, separate them with commas.
  5. Multiline Data: When dealing with data that spans multiple lines, such as Tags, Attachments, or Description, enclose the content within double-quote marks (").
  6. Language Flexibility: The information you're importing can be in any language, but the headers in the heading row must be in English.
  7. Capitalized Headers: Begin all headers with a capital letter for consistency and readability.

How to prepare the Tickets.csv file

Here are the data fields and their requirements for the ticket CSV file:

  • TicketId - required
  • Subject - required
  • Tags - optional
  • DepartmentName - optional
  • Description - required
  • Type - required
  • Status - required
  • Priority - required
  • AgentEmail - required
  • AgentName - required
  • ContactEmail - required
  • ContactName - required
  • ContactPhone - optional
  • CompanyName - optional
  • CreatedTime - required. (Use YYYY-MM-DD HH:MM:SS time format)
  • UpdatedTime - required. (Use YYYY-MM-DD HH:MM:SS time format)
  • ClosedTime - optional. (Use YYYY-MM-DD HH:MM:SS time format)
  • Attachments - optional.

Importing custom fields


To migrate custom fields, use the appropriate tags in the column header. Here are the tags you should use for different custom field types: 

  • _select - dropdown (e.g., product_select)
  • _date - time (e.g., due_date)
  • _integer - number (e.g., TicketInternal_integer)

For other types of custom fields, you can use the _textArea tag.

Importing ticket comments

To import ticket comments along with your tickets, you need to provide them in a separate file, which should contain the following headers:

  • CommentId - optional
  • TicketId - required
  • AuthorEmail - required
  • Public - required (Use 0 for private and 1 for public comments)
  • Body - required
  • CreatedTime - required (Use YYYY-MM-DD HH:MM:SS time format)
  • Attachments - optional

For tickets with multiple comments, arrange them as follows in the file:

How to import files to Zendesk

When your files are prepared and ready, follow these steps to begin your import on the Help Desk Migration website: 

1. Go to the Help Desk Migration website. Select CSV as your data source. Upload your CSV files. You can choose from the following options: 

If you do not need to import knowledge base articles, you can utilize our sample data to pass the source step. Later, when you are selecting which data you want to migrate, simply skip the option for Knowledge Base objects. This allows you to focus solely on the data that is relevant to your migration process.

2. Select "Zendesk" as the target platform and provide your company's Zendesk URL.

3. Choose which specific records you want to migrate and proceed to map the ticket fields, ensuring that your data aligns correctly with Zendesk's structure.

4. Initiate the Free Demo Migration to obtain a quote and verify that the data has been migrated accurately. You can review the migration results by following the guidelines provided in the linked guide.

5. If you are satisfied with the results of the Free Demo Migration, you can proceed to complete your data transfer.

Once you've initiated the migration of all records, you can simply close the tab and continue with your daily activities. We will send you an email notification once the entire import process is completed.

However, please exercise patience during this period and refrain from merging, editing, or deleting any of the imported data. Making changes to the data during this phase can result in irreversible alterations. It's advisable to wait for the migration to conclude before safely working with your data in the new platform.

If you have any questions or require assistance throughout the migration process, please do not hesitate to contact Help Desk Migration. Our team is here to provide support and address any inquiries you may have. Your successful data migration is our priority, and we are ready to assist you every step of the way.


1

14

14 comments

image avatar

Brett Bowser

Zendesk Community Manager

Thanks for sharing :)

1


Always welcome, Brett!

Hope we can help somebody!

1


Can this also work for updating existing tickets?

If I have a list of Zendesk tickets, can I do an upload to edit/update them? To add an additional tag without creating new tickets or changing anything else?

0


image avatar

Brett Bowser

Zendesk Community Manager

Hey Chris,

I can't speak for the integration mentioned above, however, it may be worth taking a look at our Managing Tickets in Bulk article which I've linked for you.

You can also use the Zendesk API to update your tickets in bulk and add the appropriate tag.

Hopefully, the developer of the integration can comment back here and point you in the right direction using their app.

Cheers!

0


@..., @... is right!

The best way to add tags to existing tickets is to use Bulk feature in Zendesk.

 

1


Hi Brett & HDM, 

Thanks for the response. 

 

Unfortunately the Bulk feature isn't really an option as I cannot create a view to filter for only the tickets I need to edit at this time since they don't have any other identifiers at this time - hence the tags I need to add to separate them out.

We're looking at an automated solution in the future, but was hoping for an easy win in the interim. Thanks anyways!

 

0


Hi there! Thank you for this post. I just would like to know if this has 100% accuracy as to moving the data (tickets, contact info,)?

Our company is looking into moving back to zendesk and we are seeking help on how to move our data from the previous CS platform to zen faster and more accurate. Any help suggestions and repsonses aside from this article is highly appreciated. Thanks ahead!

0


How can I link a ticket with a specific group via *.csv import ?

0


image avatar

Jason Schaeffer

Zendesk Customer Care

Hi Grao,
 
Thanks for reaching out! You may want to look into a 3rd party app to accomplish this. I will link an example for this below:
 
https://www.zendesk.com/apps/support/275742/import-app/
 
This is not native to Zendesk but they may be able to customize to your needs when executing the Import.

I hope that helps!

-1


How can we ensure the SLAs of the open tickets we are migrating from JIRA to Zendesk are also migrated? If it cannot be migrated, what is the work around ?

 

0


Unfortunatelly, SLA settings can't be imported. You can set them up only for the new tickets. For the old ones, there's an option to migrate information about SLA timing into private comments. Thus, this workaround depends on the tools used for SLA in Jira.

0


Can we import CSV without help-desk?

1


Yes, Usman, you need to upload your CSV files into Migration Wizard and connect the desired help desk, ITSM, or ticketing system. Then the process as a default migration -- adjust fields, run a Demo to test, check results and set a Full Migration.

1


Another option to integrate Zendesk with CSV is Skyvia. It is freemium and has a very intuitive UI.

-1


Please sign in to leave a comment.

Didn't find what you're looking for?

New post