Viewing Import History

Viewing Import History

Viewing Import History

Maintaining a log of the activities performed in your 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 the 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 the 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 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 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 organisation'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 the 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.


    • Related Articles

    • Tracking History of Picklist Values

      Tracking History of Picklist Values Enable picklist history tracking  View history tracking Edit History Tracking in Deals Module Points to Remember In every business it is very important to keep track of the updates so that you don't miss out any ...
    • Setting up Data Sharing Rules On this page

      Setting up Data Sharing Rules Managing Default Data Sharing Process Creating Data Sharing Rules By default, access rights to CRM records is set as private so that the record owner and his/her manager can oversee the CRM data. However, using the Data ...
    • Working with Translations

      Working with Translations Begin Translation View Language Import History Export a Translated File Revoke Language Import Deactivate Translation Reference Values for Picklist Fields In a globally run business where employees and customers are spread ...
    • Projects Overview

      The Projects, Companies and Roles modules are where the Data feed from Barbour ABI will filter through after import. Within the CRM, this is the basic view of what you will see: When you select a Project, your view will change to this: Above you can ...
    • Migrating Data from Salesforce

      Migrating Data from Salesforce Data files from Salesforce Modules Mapping Migrate data Follow the steps in this document to migrate your Salesforce data into the CRM. Data files from Salesforce The zip file you upload should contain all the files in ...