Hosk’s Top CRM 2013 articles of the week 30th May 2014

I have been on holiday this week, so I didn’t have my usual collection of articles but I have cobbled together a few articles that I read last night and some of my previous articles of the week.  I’m in a rush today (still on holiday) so I don’t have time to summarise them

Article of the Week

An interesting look at the new case creation and routing.

CRM 2013 SP1: Case Creation and Routing – The Big Picture



The Best of the Rest


 Dupe Detection on Create/Update Returned to Dynamics CRM 2013…with a bug


Optimizing SSIS with Microsoft Dynamics CRM


how to install the wave updates to your CRM


Microsoft and salesforce.com announce global, strategic partnership

With Salesforce partnership, the Microsoft Dynamics CRM community backlash begins

Building Mobile applications in CRM

Unified Service Desk for Microsoft Dynamics CRM 2013 Released

Tool – Performance Analysis of Logs (PAL) Tool


CRM 2013 and the Platform Evolution: Webcast Recording and Slides


previous Hosk’s article of the week

his article by Gareth Tucker who has written any blogs this year (come back Gareth we love you) is an excellent run through JavaScript notification and he also has some other good blogs on the new CRM 2013 features



Last 4 articles of the week a great article from CRM MVP Adam Vero on why you should use Access Teams. There have been quite a few blogs and a videos on how to use access teams and a quick introduction to access teams but this deep dive from Adam explains WHY you should use access teams. http://blog.crmguru.co.uk/2014/05/16/why-use-access-teams-in-dynamics-crm-2013/



This weeks article of the week is from CRM MVP Jukka Niiranen who has written an excellent blog on one of the popular scenarios in Microsoft Dynamics CRM and something which people do seem to struggle with.

It’s a very detailed article and goes into great depth explaining the various aspects of recurring workflows.

Dynamics CRM Reminder Workflows Done Right



It’s not one article this week but four, an amazing Super hero Fiddler 2 tutorial from CRM MVP Scott Durow


This is a great blog post about Auto Save, it shows you how it works and ways to interact, turn it off and a few gotcha’s.  This article seems to collate many articles I have read on auto saving into one handy blog post.

All you want to know about Auto Save

Previous Week


If you want more great articles, why not go back and read last weeks top CRM articles again, did you read them?

Hosk’s Top CRM 2013 articles of the week 16th May 2014

if you find reading to difficult today, why not go and watch some CRM videos on my youtube channel

Hosk’s CRM Dev

Hosk’s Top CRM 2013 articles of the week 23rd May 2014

Welcome to another exciting week of Hosk’s Top CRM articles

Hosk Video roundup


Article of the Week

a great article from CRM MVP Adam Vero on why you should use Access Teams. There have been quite a few blogs and a videos on how to use access teams and a quick introduction to access teams but this deep dive from Adam explains WHY you should use access teams.




The Best of the Rest

This is a great article on migration tips, focusing on the database

11 Dynamics CRM Data Migration Tips


How to set up soap authentication for CRM Online using JavaScript.  A good example from Jason Lattimer CRM MVP

 SOAP Authentication to CRM Online using JavaScript


The CRM SDK update has brought in some refresh tools.  The Plugin Registration tool gets a face lift

Dynamics CRM 2013 SP1 Plugin Registration Tool Revamped!


Also in the new CRM 2013 SDK update is the migration tool, this allows you to bring things like duplicate detection rules from one CRM organisation to another, which saves you have to recreate them in each instance.

Dynamics CRM 2013 SP1 SDK – New Tool: Configuration Migration


You can add use security roles to filter dashboards

Dynamics CRM Quick Tip – How to Secure Your Dashboards


Comparing filter functionality between CRM 2011 and CRM2013

Comparison of the CRM 2011 and CRM 2013 Filter Functionality


Nice trick to show you how to colour code tracked appointments in outlook

Color Code Your Calendar for Tracked Appointments in Microsoft Dynamics CRM


Hosk CRM MVP questions for Blake Scarlavai

CRM MVP Question and Answer – Blake Scarlavai



Great Ribbon Workbench tutorial to show you how to add a custom advanced find in the command bar.  Very useful if you are planning to go through

Advanced Find from Form Command Bar in Dynamics CRM 2013


Hosk goes through auditing in CRM 2013 and then gives some key facts for the people studying MB2-703 CRM 2013 customization and configuration exam.

CRM 2013 – MB2-703 – Quick Overview of Auditing


linking CRM 2013 with Google Analytics – cheeky



A new CRM 2013 book is unleashed and available to buy

new CRM 2013 book – Microsoft Dynamics CRM Unleashed 2013


Joel Abbot tells you why the new changes in service and case in the spring wave are good and why we should be excited

Service & Case Changes…Small But Mighty! Microsoft Dynamics CRM 2013 – Spring Wave


Links to CRM 2013 documentation

CRM 2013 – Information and documentation to get you started in CRM 2013 but no User Guide


How you can add bing maps to entities quickly

 Add Bing Maps to CRM 2013 Entities Quickly and Easily


Really useful tip form Robert Peledie I had forgotten about.  When importing data into CRM 2013/2011 you have the option to create a new entity and then create new records.

Quick Create Entity in Dynamics CRM 2013 – Custom Country List Example





Video to show you how to create new entities and records using just a CRM import

Quick Create Entity in Dynamics CRM 2013


Hosk shows you how to quickly get the record id (guid) using Chrome and IE in CRM 2013

CRM 2013 – Quick way to get a guid for a record using Chrome and IE


A good/long tutorial on loading JavaScript from the CRM 2013 Developer toolkit and then how to debug the files

CRM 2013 – JavaScript tutorial using CRM 2013 Developer Toolkit


How auditing works and a few key facts from the Hosk

CRM 2013 – How Auditing works and key facts


Previous Week

If you want more great articles, why not go back and read last weeks top CRM articles again, did you read them?

Hosk’s Top CRM 2013 articles of the week 16th May 2014

if you find reading to difficult today, why not go and watch some CRM videos on my youtube channel

Hosk’s CRM Dev

CRM 2013 – How to set up Field Level Security

I have covered all the other aspects of Security in CRM 2013 and now I am left with Field Level Security, which in some ways is apt because this is probably the most strict.

Field level security was a much requested feature when it was added in CRM 2011, probably up there with auditing.

Here is the video walkthrough

Field level security allows you to add extra security around individual fields.  The three security values are






Adding Security to a Field

The first rule is, you cannot set field level security for any of the default fields. If you try to the pesky field level security checkbox is disabled.  I’m not entirely sure the reasons for this, the most likely is if you stop people adding values to the default fields then some of the functionality might stop working or the system as whole might not work probably (that is my interpretation of it)

You can only set field level security on custom fields!

So go to record, either create or find a custom field and then enable Field Security

field level 1

If you now look at your custom field on the form then you will see there is a key on the field

field level 2

Publish the changes to the entity and before we add the field to a Field Level Security profile go and have a look at the form, which in my case is the account form.

If you go to the form with a user who has the System Administrator role then you will be able to see the value in field but if you go to that form as another user then you will see some asterisks ****** (even if the field is blank).  The reason all other users see asterisks is because the field is added to field level security profiles (all of them) with the Create, Update, Read values all set to NO.

This means when you add field level security, no users (except System Administrators) will be able to view or edit the field, so you better quickly set it to a field level security profile and add some users.

below is a screen shot for a user who isn’t a System Administrator

field level 3


Create Field Level Security Profile

Now we are ready to create a profile.  The order of these steps can catch people out because if you start with Field Level security you might first create your Field Level Security profile and find them blank and then you will wonder how to get fields in there.

Go to Settings –> Administration –> Field Security Profiles

field level 5


This will then take you to a list of all the field level security profiles.

Notice the System Administrator is a default team maintained by CRM, although it is possible to add members to the team.

Now edit or create a new field security profile

field level 6

Opening your new field security profile.

If you go to field permission you will see a list of all fields which have field security enabled.

By default the privileges are set to NO

field level 7


if you click on one of the fields you can then edit the security

field level 4

The other important thing you need to do is add users/teams to the field security profile (otherwise only System Administrators can view/edit the fields)

field level 9


Key Facts about Field Level security for MB2-703 exam

Enabling or disabling of field level security by setting the IsSecured attribute cannot be audited.

System Admin is has all privileges on all field level security fields, the user has a System Administrator field security profile where all values are set to yes and will be for any fields checked for field level security.

Every field enabled for field level security is added to all field level security profiles

when you turn on field level security for a field, it will automatically be added to all Field Level security roles with Read, Create and Update all set to No.

New field level security fields can only be seen by users with the System Administrator role, so you have to go and configure the field level security privileges.

Every field level security profile will include all fields with field level security enabled.

Fields that are ticked for field level security will be added to field security profiles but with Read, Update, Create all set to No, so you must go in to configure

users/teams can be added to more than one field level security profile.

*** asterisks show if a user does not have read access to a field

*** asterisks show even if the field is null/blank

You cannot delete the System Administrator field level security profile

You can only set field level security on custom fields!

CRM 2013 Video – How to Quickly way to get a guid for a record using Chrome and IE

I created a new video on my YouTube channel Hosk CRM Dev and as you can see from the logo I have been a busy CRM bee.


Hosk CRM Dev Bee Trimmed

I highly recommend you visit the channel as there are lots of useful and interesting videos on CRM on things like Plugin Development, JavaScript, MB2-703 CRM 2013 Customization and Configuration study material, CRM 2013 Tool Reviews, quick tips and other stuff.

The video shows you how to get the guid from opening an account record and then getting the JavaScript debugger up and then getting the guid in both Chrome and Internet Explorer.  Below is the JavaScript I used



Internet Explorer





CRM MVP Question and Answer – Blake Scarlavai

This weeks MVP is Blake Scarlavai from Chicago and this is what Wikipedia tells me about Chicago (Wiki doesn’t tell us anything about Blake!)

Chicago (Listeni/ʃɪˈkɑːɡ/ or /ʃɪˈkɔːɡ/) is the third most populous city in the United States, after New York City and Los Angeles. With 2.7 million residents,[1] it is the most populous city in both the U.S. state of Illinois and the American Midwest. Its metropolitan area, sometimes called Chicagoland, is home to 9.5 million people and is the third-largest in the United States.[2] Chicago is the seat of Cook County.[a]

The name “Chicago” is derived from a French rendering of the Native American word shikaakwa, translated as “wild onion” or “wild garlic”


Blake is one of the brand new shiny CRM MVP’s, he only burst out of the MVP egg on April 1st 2014.  So in MVP terms he is merely a new born baby and here he is


His MVP bio is rather short

About bscarlavai

CRM developer for 6 years since CRM 3.0 working at Sonoma Partners

I can’t find much on Blake  so lets just move onto the Q&A


Thanks for Blake for answering my questions, greatly appreciated

If you want to read previous CRM MVP Q&A by clicking the link on the header – HOSK’S CRM MVP Q&A



Name, current job title and social media links please

Blake Scarlavai

Senior Developer / Manager at Sonoma Partners

Blog: http://blog.sonomapartners.com

Twitter: @bscarlav


What does an average day at work look like

85% developing or designing for clients and 15% internal (management, meetings, blogging)


What different roles/Job titles have you had whilst using CRM

Started as a Developer and moved into a Senior Developer / Manager role


What job did you did before you starting using CRM

None.  Almost 6 and a half years ago I graduated college and came straight to Sonoma Partners to develop for CRM 3.0/4.0 at the time.


What was the first version of Microsoft Dynamics CRM you worked with and how long have you been using Microsoft Dynamics CRM

CRM 3.0, almost 6 and a half years


How do you stay up to date with the CRM

Twitter, blogs, TAP program


How do you find time to contribute to the CRM community whilst doing your job

Mainly after hours blogging about an interesting/unique topic I found during the day or working on a CRM tool as a side project. I will try to hop on the forums in the morning or at lunch as well to see if I can provide any help.


What advice would you give to someone who wants to have a successful career in Microsoft Dynamics CRM?

It is definitely helpful to take the time to learn the product first and the best way to learn is to take a certification or play around with CRM hands-on. As a developer, we typically want to solve everything with custom code but that can be very costly and inefficient.  It would be very valuable to your company or client if you know the capabilities of CRM as you should always try to go native and supported before trying to dive in with custom development.


What where your first impressions of CRM 2013 and what do you think now.

First impressions were that it looked great.  I love the flat UI and it is less clicky.  After using it, I think the navigation could use a bit of help but what is always nice about CRM is that it is so flexible that developers can fill the gaps with custom code.  Some MVPs have already done that by providing different solutions to help enhance the navigation.  Convergence also got me excited for the future of CRM 2013.  Functionality like Unified Service Desk and Social Listening look great!


What one feature would you add to CRM 2013

More flexibility for Custom Actions.  Custom Actions have a lot of potential but currently they can only be called from custom code. Allowing the ability to call them from workflows or even Portable Business Logic would greatly increase their usefulness.


Most annoying feature of CRM 2013

The navigation.  If you’re upgrading from 2011 and you have a lot of navigation items then you will most likely need to re-think them when upgrading to 2013 or build a web resource to help group the navigation items better.


You favourite 2 CRM blogs (I have filled the first one in for you)

1.  Hosks Dynamic CRM blog

2.  Besides http://blog.sonomapartners.com of course, I enjoy Jukka Niiranen’s blog .  He provides some excellent and unique content and goes into great detail.


Are you doing more CRM projects with CRM online?  Do you think it will all be online in the future

Yes, we have a nice varienty of both CRM online and on-premise projects.  I don’t think it can be all online in the future though, at least the near future.  We have a few clients that can’t be online due to their industry.


What is the best tool/solution you have used recently

Scott Durrow’s Ribbon Workbench, it is excellent!


What CRM certifications do you have, do you try and keep up to date with CRM certifications

Currently only CRM 3.0 but I am looking forward to completing the 2013 exams.


How important is it to have good business analytical skills working with Microsoft Dynamics CRM.

Very important.  Either you or someone on your team needs to be able to understand the business and know how to design CRM to fit the needs.


How useful is it to have programming knowledge to become a good Microsoft Dynamics CRM Professional?

I don’t think it is necessary to be a good CRM Professional but more than likely, someone on your team will need to have some development knowledge to have a successful CRM project.


What knowledge/experience do you have with software/systems which integrate with Microsoft Dynamics CRM e.g. (sharepoint, SQL Server, Scribe, Etc)

I’ve done many SharePoint integrations and I have colleagues with expertise in SQL Server and Scribe to help me out in those areas.


How often do you travel as a Microsoft Dynamics CRM Professional?

Depends but usually only 15% of the year.


Can you see yourself not using CRM in your career in the future

Sure, who knows what will happen in 20 or even 10 years but I do think CRM can keep me busy for a really long time.


What is favourite part of being a CRM MVP

I’m not sure yet, today’s my first day!  But I’m looking forward to getting to know the other MVPs better and getting closer to the product team.


What are your hobbies outside of CRM

Developing, video games, movies, and traveling


What was the last book you read and what was the last film you watched

Book – A Storm of Swords

Movie – The Grand Budapest Hotel


Has CRM ever got you in trouble with your partner/family.

Maybe a few times doing some late night hackathons while trying to release a CRM tool.

Have you friends ever told you to stop talking/tweeting/blogging about CRM? What does your partner/family member(s) think of CRM

Sometimes but they are glad I am passionate about something.


Tell me something interesting/unusual about yourself

In this day and age, I think it is pretty unusual that I’ve been at one company for almost 6 and a half years!  That’s just how great Sonoma Partners is!

P.S. – we’re hiring!  🙂


Who is the first CRM MVP you remember reading/seeing

Besides my colleagues Mike Snyder and Jim Steger, I had the honor of meeting Shan McArthur at the BUILD conference in 2011.


Tips for someone who wants to become a CRM MVP

The nice thing is that there isn’t one defined path and it is flexible based on your expertise.  I think the easiest first step is to get on twitter and start a blog as well as join your local CRMUG and browse the forums to see if you can help.  From there you can gather speaking ideas for conference sessions or webinars or as a developer, build some free custom tools/utilities.

Quickfire questions (choose one option and no explanation)


Steve Jobs or Bill Gates

Bill Gates


Javascript or .NET



Internet Explorer/Chrome/Firefox/Safari



Wine/Beer/Soft Drink



Certifications or Use CRM



twerking or tweeting



books or ebooks



save or autosave



OnLine or On Premise

on premise


Windows 7/Windows 8/Linux/Mac/Other

Windows 8


work from home or work from office



Miley Cyrus or Billy Ray Cyrus






Zero Inbox/Overflowing Inbox



Early Bird/Night Owl

early bird


Do Today/Do Tomorrow

do today


CRM Developer/CRM Consultant

crm developer


Hot Weather/Cold Weather

hot weather


Half Full/Half Empty

half full


CRM 2013 – MB2-703 – Quick Overview of Auditing

Auditing was added to CRM in version CRM 2011, it was a good move from Microsoft because this was a much requested feature and in CRM 4 it was mainly done using a auditing plugin.

Auditing is one of the straight forward features in Microsoft which does a good job of just working, doing what you need and rarely going wrong.

Auditing is set at various levels

Global settings – do you want to audit

Entity level – what entities do you want to audit

Field Level – what fields on the enabled entities to Audit

You can also audit users, when they log into CRM, when security roles are assigned to the user.

The auditing functionality can be found by going to

Settings – Auditing

auditing 1

Then you can click Global Audit settings

auditing 2

This allows you to start auditing, notice there is also a section for user auditing.

User auditing can be turned on or off, you can change what is audited.

Enabling auditing in the common areas is a way to turn auditing on for groups of entities and fields.

Once you have turned on auditing you can then choose to audit individual fields

auditing 3

Auditing Table

After you have enabled auditing all the auditing changes will be  held in the audit tale in CRM Database.  It will store the user who triggered the event, what type of event and the date of time.

Auditing Key Features:

Any entity can be audited

if auditing is not enabled at organisational level, it doesn’t matter if auditing is turned on at an entity level, nothing will be audited.

audit logs are partioned every 3 months.  These can be  deleted in the audit log management screen

User has to have the View Audit History privilege

when you turn on auditing for an entity, all the available fields are enabled for auditing

Some System fields are not applicable for auditing

  • CreatedOn
  • CreatedBy
  • ModifiedOn
  • ModifiedBy
  • Owning Business Unit
  • Owning User
  • Customer AddressId

To see a detailed list of is audited go the CRM SDK Auditing Overview

CRM 2013 – Information and documentation to get you started in CRM 2013 but no User Guide

A user posted on the CRM forum a question asking  if there was a CRM 2013 handbook

Now there isn’t a handbook that’s for sure but there is quite a lot of information but it’s in separate locations and a bit confusing as to what you will need.


So there isn’t a CRM 2013 user guide but what have got

Microsoft Dynamics CRM 2013 and Microsoft Dynamics CRM Online Implementation Guide



Microsoft has a CRM customer centre which is a great place to start and this has ebooks, videos and online articles to help get you started and I will admit it’s not a PDF you can print out but really once you have got use to CRM I don’t think you would need to print it out and think of the tree’s people


CRM Customer service centre

and in there they have some videos and ebooks/pdfs and top tasks


they do have a special section for ebooks, although they are more like short guides rather than a book


CRM 2013 eBooks

 eBook: Bring in your contacts

 eBook: Start working in CRM

 eBook: Business processes

 eBook: Change a business process

 eBook: What’s changed in this version?

There is the Training and Adoption kit for CRM 2013


which seems to show the same details in a slightly different way.

If you want a more detailed list of Dynamics CRM Help and Resources the this link is pretty good


OR you have these links

Find everything you need to know to manage the system every day

Administration Guide

Get info about planning and deploying Microsoft Dynamics CRM

Implementation Guide

Customize Microsoft Dynamics CRM to match your business needs

Customization Guide

Get info designed for IT pros who administer Microsoft Dynamics CRM

CRM IT Pro Center

Get developer resources and see sample code

CRM Developer Center

Finally, you want a book, here’s a book (sort of, a website really)

there is this a free online book from powerobjects has a good mix of basic stuff and some CRM admin