{"id":2931,"date":"2018-02-18T11:51:12","date_gmt":"2018-02-18T11:51:12","guid":{"rendered":"http:\/\/himbap.com\/blog\/?p=2931"},"modified":"2018-02-18T11:51:12","modified_gmt":"2018-02-18T11:51:12","slug":"using-business-rule-for-data-import-validation","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=2931","title":{"rendered":"Using business rule for Data Import Validation"},"content":{"rendered":"

Recently I saw one question in CRM forum where user was interested in using Business Rules to implement data validation for Data Import? so can we do that ?? The answer is Yes !!, of course we can do that, business provides support to run your logic on server side right, if you don\u2019t know this, check our earlier article first, but from end user perspective it will not be helpful.<\/p>\n

Let\u2019s see this in action using a quick business rule on Contact entity. Suppose we have couple of fields which is required and we want to cancel data import if those set of fields are missing in import file. Let\u2019s say we want to enforce user to supply contact\u2019s email and phone number:<\/p>\n

\"busr1\"<\/a><\/p>\n

So let\u2019s setup quick business rules for contact entity to show error message if contact\u2019s email or phone number is null.<\/span><\/span><\/p>\n

If you are new to business rule, please check our earlier articles<\/a><\/p>\n

    \n
  1. Navigate to your Dynamics 365 customer engagement application or you can setup a trail, using our earlier article<\/a><\/li>\n
  2. Create custom solution and contact entity in our solution.<\/li>\n
  3. Expand entity node under Components<\/li>\n
  4. Select Contact and select Business Rules under Contact entity node<\/li>\n
  5. Click on New under business rule tool bar to create new business rule<\/li>\n
  6. Click on Add condition and add two rules one for email and one for phone, we can use or operator between them.<\/li>\n
  7. Add Show Error Message action, to show error message, write some message. After completion it should look something like below:<\/li>\n<\/ol>\n

    \"busr2\"<\/a><\/p>\n

    8. Now make sure to set scope of business rule as Entity (Because we want to make sure this should run from server side call)<\/p>\n

    \"busr3\"<\/a><\/p>\n

    9. Save and activate business rule.<\/p>\n

    Now when we will import contact record, with missing email or phone number, it will show us error<\/p>\n

    \"busr4\"<\/a><\/p>\n

    So as you can see the message is not user friendly so we should look for other more options which can provide more user friendly message.<\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    Recently I saw one question in CRM forum where user was interested in using Business Rules to implement data validation for Data Import? so can we do that ?? The answer is Yes !!, of course we can do that, business provides support to run your logic on server side right, if you don\u2019t know this, check our earlier article… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[402],"tags":[502,501,500,466],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2931"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2931"}],"version-history":[{"count":2,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2931\/revisions"}],"predecessor-version":[{"id":2937,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2931\/revisions\/2937"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}