Import Data

Overview: Import SalesforceIQ activity after migrating to Sales Cloud

Here are the high-level steps for importing your SalesforceIQ activity after migrating to Sales Cloud. If you just want to migrate to Sales Cloud without importing activity, follow these steps instead.

* Note: This import process will work for Sales Cloud Professional Edition or Sales Cloud Enterprise Edition only.

  1. Have your team stop manually logging activity into your SalesforceIQ Organization.
  2. Migrate your data using the SalesforceIQ migration tool. This migrates Lists, Contacts, and Accounts.
  3. After your Salesforce migration has completed, use the Organization export functionality to retrieve all manually logged activities. Create a copy of the export file to retain for your records
  4. Ensure that all users that were in SalesforceIQ have a user record in Salesforce. This step is required if you want the author of Stream comments to be the author of the respective chatter comment.
  5. Marry the exported data files.
  6. Re-import the data into Salesforce using Data Loader. The steps depend on the data type:

-----------------------------------------------------------

In this video, Importing Comments into Sales Cloud [6 minutes], you'll learn:

  • How to import Comments into Sales Cloud using Data loader
  • Where to download the Comments import template
  • How to copy and paste your SalesforceIQ data into the import template
  • How to map your fields into Sales Cloud for import using Data Loader

Import comments into Salesforce using Data Loader

Before You Begin

This article is for customers who have already migrated their data from SalesforceIQ CRM into Sales Cloud, and are looking to import their SalesforceIQ comments into Sales Cloud.

    • Review these high-level steps for how to import SalesforceIQ data into Sales Cloud after you have completed the data transfer into Sales Cloud.

*Note: This example is focused on importing comments from the Opportunities List in SalesforceIQ to the Opportunities Object in Sales Cloud. The general process applies to importing into other Objects in Sales Cloud.


System Permissions Needed

  • You must be a System Administrator in both SalesforceIQ and Sales Cloud in order to complete data migrations or imports.
  • In Sales Cloud, make sure the System Administrator user has the “Insert System Field Values for Chatter Feeds” user permission enabled:
    • Navigate to Setup > Users
    • Find the user and select the user's profile
    • Search for the permission and check the box if it's unchecked

Download the Import Resources

  1. Export your Comments file from SalesforceIQ using the Organization Export. Your exported file will be titled, "Opportunities-XXXXXXXXXXXXXXXXX-comments.csv”
  2. Run an export of your Opportunity Object in Sales Cloud via Data Loader, include all fields in the export.
    • Learn more about using Data Loader to export data
  3. Run an export of your Users Object in Sales Cloud via Data Loader, include all fields in the export.

Prepare the Final Import File

  1. Download and open this template. Then follow the instructions below.
  2. Paste your data in columns A, B and C. Use the data from your Opportunity Object export from Sales Cloud.
  3. Paste your data in columns D and E. Use the data from your Users export from Sales Cloud.
  4. Copy the worksheet tab called "CommentsTemplate", and merge it with the workbook "Opportunities-XXXXXX-comments.csv". It should look like the screenshot below.

  5. Return to the tab called "CommentsTemplate", copy the table highlighted in blue and paste it as new columns in your tab called "Opportunities-XXXXXX-comments.csv". It should look like screenshots below.

*Note: These fields contain pre-written formulas or fixed values that will marry/merge the proper Sales Cloud values with your SalesforceIQ comments, allowing you to map your SalesforceIQ comments to the correct opportunity record in Sales Cloud. Do not edit or delete these formulas or fixed values as it will cause errors with your data template and data import

6. To activate the formula fields, double-click on Row 2 in the columns (the blue fields) and delete the special character, an apostrophe ('), located at the very beginning of the formula.

7. Then click into the formula field, on Row 2 in each column, and drag down the formula fields and fixed value fields to all applicable rows within your data set.

8. Once the formula has populated for the whole column, you then need to copy each of the formula ID columns and paste special as Value. Highlight all of the columns and right click to select copy, then right click again, and select the ‘Paste Special’ option, choose ‘Value’ and click OK.

9. Save this file as a .csv format, and name it “Opportunity-comments-for-import.csv”

    • A finished version of this, with proper formatting can be found HERE, for your reference.


Import Using Data Loader

  1. Open Data Loader and click Insert.
  2. Log into Salesforce as a System Administrator user.
  3. Check the 'Show all Salesforce objects' box and select 'Feed Item (FeedItem)'.
  4. Browse for your final import file, titled "Opportunity-comments-for-import.csv" and click 'Next'.
  5. Click 'Create or Edit Map', and then click 'Auto-Match Fields to Columns'.
  6. Once you 'Auto-Match Fields to Columns', you should see something like the following screenshot below.
  7. Click OK > Next > Finish.
  8. Success and Error logs will be generated after the import is complete (see screenshot below). If you see any errors, click on "View Errors", follow the error logs to correct them. If you need additional assistance on fixing the errors, please contact Salesforce Support.
  9. The import comment activities are located in the Chatter section of your Opportunity record.

Import calls into Salesforce using Data Loader

Before You Begin

This article is for customers who have already migrated their data from SalesforceIQ CRM into Sales Cloud and are looking to import their SalesforceIQ calls into Sales Cloud.

    • Review these high-level steps for how to import SalesforceIQ data into Sales Cloud after you have completed the data transfer into Sales Cloud.

*Note: This example is focused on importing calls from the Opportunities List in SalesforceIQ to the Opportunities Object in Sales Cloud. The general process applies when importing into other Objects in Sales Cloud.


System Permissions Needed

  • You must be a System Administrator in both SalesforceIQ and Sales Cloud in order to complete data migrations or imports
  • In Sales Cloud, make sure the System Administrator user has the “Insert System Field Values for Chatter Feeds” user permission enabled:
    • Navigate to Setup > Users
    • Find the user and select the user's profile
    • Search for the permission and check the box if it's unchecked


Download the Import Resources

  1. Export your Calls file from SalesforceIQ using the Organization Export. Your exported file will be titled, "Opportunities-XXXXXX-calls.csv”
  2. Run an export of your Opportunity Object in Sales Cloud via Data Loader, include all fields in the export.
    • Learn more about using Data Loader to export data
  3. Run an export of your Users Object in Sales Cloud via Data Loader, include all fields in the export.
  4. Run an export of your Contacts Object in Sales Cloud via Data Loader, include all fields in the export.

Prepare the Final Import File

  1. Download and open this template. Then follow the instructions below.
  2. Paste your data in columns A, B and C. Use the data from your Opportunity Object export from Sales Cloud
  3. Paste your data in columns D and E. Use the data from your Users export from Sales Cloud
  4. Paste your data in columns F and G. Use the data from your Contacts export from Sales Cloud
  5. Copy the worksheet tab called "CallsTemplate", and merge it with the workbook "Opportunities-XXXXXX-calls.csv". It should look like below:

  6. Return to the tab called "CallsTemplate", copy the table highlighted in blue and paste it as new columns in your tab called "Opportunities-XXXXXX-calls.csv". It should look like screenshots below.

    *Note:
    These fields contain pre-written formulas or fixed values that will marry/merge the proper Sales Cloud values with your SalesforceIQ calls, allowing you to map your SalesforceIQ calls to the correct opportunity record in Sales Cloud. Do not edit or delete these formulas or fixed values as it will cause errors with your data template and data import.

  7. Do Not complete this step if you are importing calls into Opportunities or other account based Objects in Sales Cloud
    • Follow the steps below if you are importing calls into the Leads or Contacts Objects
      • Delete the entire column of "WhoID"
      • Rename the column header "WhatID" as "WhoID"
  8. To activate these formula fields, double-click on Row 2 in the columns (the blue fields) and delete the special character, an apostrophe ('), located at the very beginning of the formula.
  9. Then click into the formula field, on Row 2 in each column, and drag down the formula fields and fixed value fields to all applicable rows within your data set.
  10. Rename the column header “Created Date” as "ActivityDate"
  11. Rename the column header “Body” as "Description"
  12. Once the formula has populated for the whole column, you then need to copy each of the formula ID columns and paste special as Value. Highlight all of the columns and right click to select copy, then right click again, and select the ‘Paste Special’ option, choose ‘Value’ and click OK.
  13. Save this file as a .csv format, and name it “Opportunity-calls-for-import.csv”
    • A finished version of this, with proper formatting can be found HERE, for your reference.


Import Using Data Loader

  1. Open Apex Data Loader and click Insert
  2. Log in to Salesforce as a System Administrator user
  3. Check the 'Show all Salesforce objects' and select 'Task (Task)'
  4. Browse for your final import file, titled “Opportunity-calls-for-import.csv” and click Next.
  5. Click 'Create or Edit Map', and then click 'Auto-Match Fields to Columns'.
  6. Once you 'Auto-Match Fields to Columns', you should see something like the following screenshot below.
  7. Click OK > Next > Finish.
  8. Success and Error logs will be generated after the import is complete (see screenshot below). If you see any errors, click on "View Errors", follow the error logs to correct them. If you need additional assistance on fixing the errors, please contact Salesforce Support.
  9. The imported call activities are located in Past Activity section of your Opportunity record.

Note: This import process will work for Sales Cloud Professional Edition or Sales Cloud Enterprise Edition only.

Import meetings into Salesforce using Data Loader

Before You Begin

This article is for customers who have already migrated their data from SalesforceIQ CRM into Sales Cloud and are looking to import their SalesforceIQ meetings into Sales Cloud.

    • Review these high-level steps for how to import SalesforceIQ data into Sales Cloud after you have completed the data transfer into Sales Cloud.

*Note: This example is focused on importing meetings from the Opportunities List in SalesforceIQ to the Opportunities Object in Sales Cloud. The general process applies when importing into other Objects in Sales Cloud.


System Permissions Needed

  • You must be a System Administrator in both SalesforceIQ and Sales Cloud in order to complete data migrations or imports
  • In Sales Cloud, make sure the System Administrator user has the “Insert System Field Values for Chatter Feeds” user permission enabled:
    • Navigate to Setup > Users
    • Find the user and select the user's profile
    • Search for the permission and check the box if it's unchecked


Download the Import Resources

  1. Export your Meetings file from SalesforceIQ using the Organization Export. Your exported file will be titled, "Opportunities-XXXXXX-meetings.csv”
  2. Run an export of your Opportunity Object in Sales Cloud via Data Loader, include all fields in the export.
    • Learn more about using Data Loader to export data
  3. Run an export of your Users Object in Sales Cloud via Data Loader, include all fields in the export.
  4. Run an export of your Contacts Object in Sales Cloud via Data Loader, include all fields in the export.

Prepare the Final Import File

  1. Download and open this template. Then follow the instructions below.
  2. Paste your data in columns A, B and C. Use the data from your Opportunity Object export from Sales Cloud
  3. Paste your data in columns D and E. Use the data from your Users export from Sales Cloud
  4. Paste your data in columns F and G. Use the data from your Contacts export from Sales Cloud
  5. Copy the worksheet tab called "MeetingsTemplate", and merge it with the workbook "Opportunities-XXXXXX-meetings.csv". It should look like below:

  6. Return to the tab called "MeetingsTemplate", copy the table highlighted in blue and paste it as new columns in your tab called "Opportunities-XXXXXX-meetings.csv". It should look like screenshots below.

    *Note:
    These fields contain pre-written formulas or fixed values that will marry/merge the proper Sales Cloud values with your SalesforceIQ meetings, allowing you to map your SalesforceIQ meetings to the correct opportunity record in Sales Cloud. Do not edit or delete these formulas or fixed values as it will cause errors with your data template and data import.

  7. Do Not complete this step if you are importing meetings into Opportunities or other account based Objects in Sales Cloud
    • Follow the steps below if you are importing meetings into the Leads or Contacts Objects
      • Delete the entire column of "WhoID"
      • Rename the column header "WhatID" as "WhoID"
  8. To activate these formula fields, double-click on Row 2 in the columns (the blue fields) and delete the special character, an apostrophe ('), located at the very beginning of the formula.
  9. Then click into the formula field, on Row 2 in each column, and drag down the formula fields and fixed value fields to all applicable rows within your data set.
  10. Rename the column header “Created Date” as "ActivityDate"
  11. Rename the column header “Body” as "Description"
  12. Once the formula has populated for the whole column, you then need to copy each of the formula ID columns and paste special as Value. Highlight all of the columns and right click to select copy, then right click again, and select the ‘Paste Special’ option, choose ‘Value’ and click OK.
  13. Save this file as a .csv format, and name it “Opportunity-meetings-for-import.csv”
    • A finished version of this, with proper formatting can be found HERE, for your reference.


Import Using Data Loader

  1. Open Apex Data Loader and click Insert
  2. Log in to Salesforce as a System Administrator user
  3. Check the 'Show all Salesforce objects' and select 'Event (Event)'
  4. Browse for your final import file, titled “Opportunity-meetings-for-import.csv” and click Next.
  5. Click 'Create or Edit Map', and then click 'Auto-Match Fields to Columns'.
  6. Once you 'Auto-Match Fields to Columns', you should see something like the following screenshot below.
  7. Click OK > Next > Finish.
  8. Success and Error logs will be generated after the import is complete (see screenshot below). If you see any errors, click on "View Errors", follow the error logs to correct them. If you need additional assistance on fixing the errors, please contact Salesforce Support.
  9. The imported meeting activities are located in Past Activity section of your Opportunity record.