Viewing Import History

Viewing Import History

Maintaining a log of the activities performed in your Zoho CRM account is always useful. You know when a record was edited, or who added a record. Similarly, a log of the import activities is also useful in knowing who imported records, when it was imported and whether the records were properly imported or not. The Import History page in Zoho CRM provides a clear picture of the recently imported files to individual modules and also of the bulk data migration, i.e. Import as well as the Migrate features.

A user with Administrator profile can view all the migration and data import actions by other user as well. Users in any other profile can view only the history of the migration and data import they performed. One can see the following details under the import history:

  • Imported file name
  • Module's name to which the records are imported
  • The user's name who imported the records
  • Imported date and time
  • Details on the number of records that are added, updated and skipped

In the Import History page you can perform the following operations:

  • Check details of the import
  • Confirm the imported data
  • Undo the data import

Files imported within the span of 60 days will be listed under Import History. Each entry in the imported history gives you the option to view the records that were added, updated and skipped. These details are available only for 7 days from the day the records are imported after which you can only see the number of records that were added, updated or skipped. In case the records are not imported properly and you want to undo the import, you can do so within 30 days, after which the import action will be locked and confirmed automatically.

Check Import Details

On importing a file, the import details will be listed under the Import History. This includes the date and time when the records were imported, user's name who imported the file, details on the number of records that were added, updated or skipped, details on why records were skipped, etc.

To check the import details

  1. Go to Setup > Data Administration > Import Import History.
    In the Import History page, every import action will be recorded along with the details on the date and time that it was imported.
  2. Click on the AddedUpdated or Skipped numbers to get details.
  3. Click on the updated link to check the records that were updated on importing.
    The fields in the import file will be listed, along with the values for each record. The row numbers help you easily locate the records in your import file.
  4. Click on the skipped link to check the records that were not added in Zoho CRM.
    The fields in the import file will be listed, along with the reason why the records were not imported. The row numbers help you easily locate the records in your import file.
  5. Click on the Download list of records with error link and get a copy of the skipped records and the reason why they were not imported.

Note
  • The summary of the import will be available for any migration or data import done in the last 7 days.
  • In the Skipped records list, the details of the first 5 fields (from the import file) that were mapped with the Zoho CRM fields will be listed. The rest of the field details will be available when you export the list. This option to export will be available only if less than 3000 records are skipped.
  • When you export the skipped records, you will get a .csv file with all the fields that were mapped with the Zoho CRM fields during the import process. Also, the reason why the records were skipped will be available. You can make the necessary changes to the file and import it again.
  • The Added and Updated view will list only those fields available in the All [Records] list view of the respective module.
  • There is a possibility of a mismatch in the added/updated records count and the number of records that you see in the detailed list. There are two reason why this mismatch is there.
    • Records are deleted manually by a user.
    • You do not have permission to view the records. (When organization's data is imported).

Undo Imported Data

Within 30 days from the import, you can undo the import process and remove the imported records from Zoho CRM.

To undo the import activity

  1. Go to Setup > Data Administration > Import Import History.
    In the Import History page, the import entries are listed.
  2. Move your mouse pointer to an entry and click the Undo Import link to undo the action and remove the imported data.
Note
  • After 30 days from the import, you cannot undo the import action.
  • If you undo the imported Contacts, then the imported Accounts associated to contacts will also be deleted.
  • If you delete the imported Accounts, then the imported Contacts associated to the accounts will also be deleted.
  • If the data import fails, it will be clearly marked in the data history.

You can undo import action on only added records and cannot undo an import action on updated records.
For example, say that you import 500 records into CRM, of which, 400 records are added newly and 100 records are updated with the email IDs. When you perform an undo action, all the 400 added records will be removed from CRM but the 100 records with updated email IDs will not be removed. 

Import Contacts with Multiple Tags

While importing a .csv file or an excel file, you can add a column exclusively for tags and include all the tag values separated by comma. For example, Zylker,Premium,Cannotlose
                                      

Import Contacts with Multi-select Picklist

While importing a .csv file or an excel file, you can add a column exclusively for multi-select picklist and include all the values separated by semi colon. For example, Car choices - Suzuki;Hyundai;Honda


    • Related Articles

    • FAQs: Import

      How do I import records and assign them to other users in my organization? You can import records and assign them to other users in your organization through three options: Users: You can select a particular user and assign all the leads to that ...
    • View Approval History

      Approval History gives you a list of records that were submitted for approval. To view the Approval History In your Zoho CRM account, click the My Jobs tab. Click the Approval Process tab. In the Awaiting your Approval page, click Approval History. ...
    • Troubleshooting Data Import and Export

      1. When I try to import leads, I get an error message which says "Duplicate record exist in system: Email." I've checked my CRM data and there is no duplicate record with the same email address. How do I resolve this? Once you have ensured there is ...
    • Sending Survey and Viewing Survey Response from CRM

      Build a Survey In order to send an email survey from Zoho CRM, you must first create a survey using Zoho Survey. Go to https://survey.zoho.com/and choose from three options - Blank Survey, Template and Existing Survey - to build your survey. See ...
    • Migrating from Salesforce to Zoho CRM

      Data files from Salesforce The zip file you upload should contain all the files in CSV format and a folder named Attachments. This folder contains the source files used as attachments in Salesforce records. One of the CSV files will list the record ...