1 Sep’15

BIImporting Data from Excel to CRM online using Scribe Online

In this article, we will migrate the Data from Excel Spreadsheet (Source) To Microsoft Dynamics CRM Online (Target), using SCRIBE ONLINE as integration tool.

Pre-Requisite:

  1. Microsoft Excel 2013
  2. Microsoft Excel Driver ( This can be downloaded and installed from URL (https://www.microsoft.com/en-in/download/details.aspx?id=13255)
  3. Scribe Online subscription.
  4. Scribe Online On-Premise Agent.
  5. Microsoft Dynamics CRM Online, Target where the Data from Excel will be inserted into.

Note: Please ensure that you have correct 32-bit or 64-bit version of Microsoft Office installed as per Windows OS. Installing 32-bit version Office on 64-bit Windows, will create issues while creating DSN connections.

(The Below Demo is being done on Windows 8.1 OS 64-bit with Microsoft Office 2013 64-bit)

STEP 01.

Launch ODBC Data Source Administrator Window and under Tab Drivers, ensure “Microsoft Excel Driver” is present. (C:\Windows\System32\odbcad32.exe.

1

In ODBC Data Source Administrator under System DSN à Add à  Microsoft Excel Driver

Fill in the details for Data Source, Description, and Version of Excel Version (If you have older Excel you can select Excel 97-2000)

Select the Workbook Path.

2

STEP 02:

  1. Login to Scribe Online (https://online.scribesoft.com/ScribeOnline.aspx#/Logon) (Requires Silver Light)
  2. Go to Agents and Create Agent from NEW option.
    Install On-Premise Agent and copy the Agent key as well.

    After Installation, You can provide the name for the agent.

    Under Connections, create new connection, Select the Type as ODBC from Drop Down list. DSN Name should be the same name as provided in the DSN Admin console. Authentication would be Application. Test the connection. (Ensure the Excel file is closed)

    3

  3.  
     

STEP 03:

Creating the Map in Scribe Online.

In Scribe Online create new solution

Select the Agent

Create Advanced Map

In the Map for source connection select the connection created earlier pointing to DSN with Excel Spreadsheet. (Sheet1 is the Excel Spreadsheet, where the Data is present). Target here is the Microsoft Dynamics CRM Online.

4

You can do 1-to1 mapping between the fields in the Excel Source and the Target Entity Accounts in CRM. In this example I have mapped AccountName to Name in the Target CRM.

5

Run the Map and check the data in the Target CRM.

6

This solutions is useful where large no of data needs to be created either from legacy systems or some new requirements. All you need to do is get the data in excel and run the solutions.
 

Written by

Team Member

CloudFronts

2 thoughts on “Importing Data from Excel to CRM online using Scribe Online”

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Design Views in App Designer – D365

    11 April’ 2018

    Introduction: Create and edit public or system views by using the app designer Description: Dynamics 365 sales app des...

    Read more
  • Call Management in D365 Field Service

    10 April’ 2018

    Introduction: This blog provides a solution to requirement of Client for Call Management in D365 Field Service. Scenari...

    Read more
  • Fetch Hierarchical data for Product Category in Dynamics 365 Operations

    10 April’ 2018

    Introduction: In this blog article, we will see how we can fetch hierarchical data using X++. How to fetch? We will ta...

    Read more
  • PowerBI April 2018 Update: Combo Chart Line Formatting

    10 April’ 2018

    Introduction: PowerBI introduced the feature to format line styles and legends for line charts a while ago. However, th...

    Read more
  • Power BI April 2018 Update: Q&A Explorer

    10 April’ 2018

    Introduction: In this blog we will explore some of the new features added to Power BI. Power BI has upgraded its Q&...

    Read more