Skip to main content

Sitecore 9 Dynamic CRM Connector: Conditionally Sync Sitecore Field (Part 6)

Sitecore 9 Dynamic CRM Connector: Conditionally Sync Sitecore Field (Part 6)

Part 5: Schedule Pipeline Batches in Sitecore 9 Dynamic CRM Connector 

There can be the situation while you are syncing xDB contacts to CRM and you want to update some field on the basis of some logic. Just like the below condition where I wanted to sync to “Birthdate” when it is above 1990 otherwise, it will be blank in CRM.

Apply Mapping Rules

  • To apply mapping rules firstly create custom class “BirthdateValueMappingRule”
       
 namespace Namespace  
 {  
   public class BirthdateValueMappingRule : IApplyMappingRule  
   {  
     public readonly int Year = 1990;  
     public readonly string FacetName = "Personal";  
     public bool ShouldMappingBeApplied(object value, IMapping mapping, MappingContext context)  
     {  
       if (value != null && context != null)  
       {  
         var MappingSource = (EntityModel)context.Source;  
         var MappingFacets = MappingSource?.Facets;  
         if (MappingFacets != null)  
         {  
           foreach (var facet in MappingFacets)  
           {  
             if (facet.Key.Equals(FacetName))  
             {  
               var val = (PersonalInformation)facet.Value;  
               if (val.Birthdate != null)  
               {  
                 DateTime date = (DateTime)val.Birthdate;  
                 if (date.Year > Year)  
                 {  
                   return true;  
                 }  
                 else  
                 {  
                   return false;  
                 }  
               }  
               else  
               {  
                 return true;  
               }  
             }  
           }  
         }  
       }  
       return true;  
     }  
   }  
 }  
  • Create another class “BirthdateValueMappingRuleConvertor”

 namespace Namespace  
 {  
   public class BirthdateValueMappingRuleConvertor : BaseItemModelConverter<IApplyMappingRule>  
   {  
     private static BirthdateValueMappingRule _rule;  
     public BirthdateValueMappingRuleConvertor(IItemModelRepository repository)  
      : base(repository)  
     {  
     }  
     protected override ConvertResult<IApplyMappingRule> ConvertSupportedItem(  
      ItemModel source)  
     {  
       if (_rule == null)  
         _rule = new BirthdateValueMappingRule();  
         return PositiveResult(_rule);  
     }  
   }  
 }  
  • In Sitecore, navigate to this location “/sitecore/system/Data Exchange/XXX/Data Access/Apply Mapping Rules/Providers” and create “xConnect Apply Mapping Rules” item
xConnect Apply Mapping Rules
  • Create an item
    • Template: /sitecore/templates/Data Exchange/Framework/Data Access/Apply Mapping Rules/Null Value Mapping Rule
    • Item Name: “Birthdate Mapping Rule”
Null Value Mapping Rule

  • Update “Converter Type” field with “Namespace.BirthdateValueMappingRuleConvertor,AssemblyName”
Contact Model to Dynamics Contact
  • Navigate to this location “/sitecore/system/Data Exchange/XXX/Value Mapping Sets/xConnect Contact to Dynamics Contact Mappings/Contact Model to Dynamics Contact/Birthdate” 
  • In “Apply Mapping Rules” field select “Birthdate Mapping Rule”
Contact Model to Dynamics Contact

  • Now sync “xConnect Contacts to Dynamics Sync”

Comments

Popular posts from this blog

Sitecore Certification Sample Questions

Sitecore Certification Sample Questions I have completed the Sitecore 9 certification in 2019 and Sitecore 8.2 Certification in 2018. Let me tell you if you have some knowledge about Sitecore then it will be easier for you to understand questions and clear certification exam. Your main focus should be to understand the questions and answers carefully because it is too confusing There will be two options to give the exam: Install the software in your laptop (Laptop should have mic and webcam) Authorized training Center If you have proper Internet, then you can choose option 1 otherwise option 2 is a good choice. Disclaimer : Please note that the below question is only for information purpose only. Below question does not claim the accuracy of the content. Sample Questions: Question 1: What is the name of Component architecture guideline of Sitecore? Answer : Helix Question 2 : What is horizontal scaling and vertical scaling? Answer :  https://doc.

Sitecore 9 Forms: Google reCaptcha field

Sitecore 9 Forms: Google reCaptcha field  Re-Captcha is the most important part of any form’s submission. Google reCaptcha run internet bot detector and determined whether a user is a bot or not.  Sitecore Forms does not provide Google reCaptcha field, which was available in WFFM before, so I have created my custom Google reCaptcha.   Below you can find step by step process to create Google reCaptcha field. Create patch config for reCaptcha Sitekey and SecretKey <?xml version="1.0"?> <configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:set="http://www.sitecore.net/xmlconfig/set/"> <sitecore> <settings> <setting name="ReCaptchaSiteKey" value="site-key" /> <setting name="ReCaptchaSecretKey" value="secret-key" /> </settings> </sitecore> </configuration> Create new viewmodel class RecaptchaViewMode

Create Sitecore Custom Admin Page

Create Sitecore Custom Admin Page Sitecore provides you lots of Admin pages just like ShowConfig.aspx, cache.aspx, Logs.aspx, howServicesConfig.aspx, etc. which you can check from here http://<yoursite>/sitecore/admin/. All Sitecore Admin pages is available in this folder “sitecore/admin/*” Sometimes there can be requirement that you want to create custom Admin page which will be accessible to Admin/Non-Admin user. Here is an example: Create aspx page “CustomAdminPage.aspx” inside “<root>/sitecore/admin” folder <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CustomAdminPage.aspx.cs" Inherits="Namespace.CustomAdminPage" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Custom Admin Page</title> <link rel="stylesheet" type="text/css" href="/sitecore/she