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
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:
- 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.
- 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.
- 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 | | |
Contacts | | |
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 | | |
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
- Log into your Desk account with administrative privileges.
- Navigate to Setup > Data Administration > Import/Export > Import.
- Click New Import.
- In the File Upload tab, select the module from the drop-down list.
- 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.
- Click Next.
Under Mapping, select from the following options:
- Create a new record and skip existing records
- Update existing records
- Both
- Select a field to identify duplicates from the drop-down list.
- Check the field mapping and make changes as needed.
- Click Next.
- Review the import details. You can go back to make changes.
- 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.