Support Portal ContactGet in touch

Scribe Online: Defining an Advanced Data Map

   Words by CRM Consultancy

   on 31/01/2016 16:01:51

Now we have defined a Basic Data Map to see Scribe Online in action – we can take the ‘kid gloves’ off and look at a more practical map.


After the Connections have been set, this gives us a number of Commands that we can drag into the Execution area:

  • Add a Query step from the Source so the Map knows to read a series records from Source
  • Add a For Each Result step to inform the Map to loop through each record returned by the Query
  • Add a Update/Insert step to prompt that an existing record in CRM should be Updated, or a new record to be Created.



  • We can then modify the details our Update/Insert to tailor how the step will run.
  • Matching Criteria - to determine how the Map will decide between Update or Insert
  • Fields – configure which fields should be copied from Source to Destination, and whether any translation logic (via script) should be put in place


Matching Criteria from Source to Destination


Mapping Data Links from Source fields to Destination fields


Using Script to develop a set of logic for how the Source field should be translated into the Destination field

  • The Scripting here mirrors the Script from the earlier versions of Scribe Insight, which in turn mimics aspects of Excel Scripting, and so can be quite familiar after an initial learning curve.
  • Once we have our Query, Matching Criteria and Data Links in place, we are then ready to Preview our Advanced Map.
  • Preview – we do this by clicking in the Debug tab and clicking Start, this then allows us to run through our steps one step at a time


  • Here we can view how the data changes whilst going through the steps – seeing the raw input from the Source, to the formatted Update Message that is then passed to Dynamics CRM, which gives us the ability to spot and track errors as they happen.
  • After reviewing our Advanced Map via the Debugger and ironing out any problems, we are ready to run for real.
  • We do this by jumping back to our list of Maps in the Solution, and clicking Run Map Now
  • Scribe Online will start the job running as a service in the background, and then give us a pop-up notification when the job finishes.
  • After which, we can review previous jobs (in the same fashion as a Simple Map) by highlighting our Solution and clicking View History – this gives the list of past executions and the rows of data processed:


  • This should be familiar to users of Scribe Insight, as is effectively the Online method of viewing the Execution Log.

  • This then imports into CRM and completes the migration job for the Advanced Map:


  • The data can then be used for the intended purpose in our CRM Solution:


This is aimed at showing how an Advanced Map can be used to migrate data into Dynamics CRM using Scribe Online as part of a wider post here on Scribe Online.

Further Reading

Defining an Advanced Map

Using Scribe to Migrate Data From a Text Field to an Option Set

Share this Article

Search Articles

Filter Articles

CRM Tech DocMan

Recent Articles

CRMCS Quick Start Guide: How To Produce a Microsoft Teams Live Event Dynamics 365 Marketing: Lead Scoring and Sales Acceptance Designing and Developing Microsoft Power Apps Portals Thank You for Attending CRMCS’ Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Thank You for Attending Our Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Webinar: Discover How CRMCS Have United Dynamics 365, SharePoint and Microsoft Teams To Create Sales Excellence Ignite your workflow by adding DocDrive365 to Office 365 The CRMCS guide to everything you need to know about integrating Teams with Dynamics 365 Saving Time By Keeping Documents In One Place TDE Database Encryption with On Premise Dynamics The Key to Successful Compliance in 2020 Part 2: Let’s get GDPR Compliant with Microsoft Power Automate Top 3 Essential Tips for Remote Working Dynamics 365 Marketing: Top 5 Best Features Dynamics Day in the Life - Puma Investments Can you use Teams to amplify collaboration in Dynamics? Part 1: Using a Scheduled Power Automate to Trigger Expiry Date Reminders The secrets of successful document collaboration in Dynamics CRMCS launches new AppSource approved DocDrive365 Dynamics Day in the Life - Moneypenny Release Management Add the App to Dynamics DocDrive365 Security: Day One - Getting Started with Dynamics to SharePoint Permissions Building a New Scheduled Process using Flow
  • "Paul has made a real difference to how my team of 24 people record and store valuable customer data and sales opportunities. Highly recommended."

    James, Operations Director

  • "Understanding your business allows us to advise when to implement aspects of CRM and, likewise, when not to."

    Paul McQuillan, Managing Director

  • "Dynamics 365 and CRMCS have made a real lasting difference to our business, allowing us to replace older systems that were holding back our performance."

    Grahame, Chief Operating Officer

  • "James worked well with us to help connect CRM with Outlook and relate how this might benefit our team using CRM for Property Care."

    Natalie, Property Care Supervisor

  • "Matt was really good with helping us run User Testing on the new Compliance Module of our CRM System."

    Tom, Compliance Administrator

Prefer to go old-school?

Write to us using the below addresses.

Head Office
CRM Consultancy
61 Oxford Street
M1 6EQ

London Office
CRM Consultancy London
Grosvenor Avenue

Content © CRM Consultancy.