Remain DRY by checking your @testSetup

Posted by on January 30, 2015  |  commentsComments (0)

Among the many exciting features of the upcoming Spring ’15 release there is a hidden gem for developers coming: the new @testSetup annotation. This new annotation will let you refactor chunks of code common to each test within a test class in to a common setup method that is guaranteed to be called before each test method is run. When combined with a Factory pattern to actually do the creation of test data and settings, this becomes a powerful way to organize your code so that it is easy to read and understand, and consistent across projects.

Trying to remain DRY

Historically, unit tests have been a difficult place for developers to remain DRY. There are several solutions for this, but most get ignored or are underutilized due to the overriding need for unit tests to be exceptionally readable. Testing software is notoriously difficult, and anything that attempts this in an automated fashion needs to be simpler, more readable and more maintainable than the software it is testing – otherwise you may need to start testing the tests! Generally, the lack of patterns and desire to remain simple and readable leads to the opposite of what we would want in any other part of our code base: repeated code. It’s not uncommon to see code like the following, with repeated setup code at the beginning of each test method:

Oftentimes, developers will see this repeated code and attempt to remain dry by refactoring the code into a helper method which gets called at the beginning of each test:

While this mostly works, what we’d really like is for the framework to handle this for us so that we can avoid having to put in the extra method calls if possible.

@testSetup – removing repeated code

@testSetup is a new annotation that will allow you to specify methods that the test framework will run just before each test method runs. The test methods must return null and be static (similar to most other testing frameworks) but otherwise can do whatever is needed by your tests. This annotation is totally optional as well, so if you don’t need/don’t like it you don’t have to use it. Continuing our sample from above, we can refactor the code base to:

By being able to gloss over the setup details, the next person who has to maintain these tests can more easily focus on the core concept each method is trying to test hopefully promoting more reliable and robust code.

Wrap Up

We are excited for this new annotation and will be exploring its creative uses when it’s released. As with any new release there are some important caveats to it, so we encourage you to read the documentation on it before attempting to refactor any existing code bases. If you are confused by this or want to know more, feel free to leave us a comment below or contact us!

Make Your Visualforce Components More Useful, Part 3

Posted by on January 29, 2015  |  commentsComments (0)

Today's post is written by Andrew Monshizadeh, an iOS Developer at Sonoma Partners.

In the first blog post we discussed a situation where it would make sense to split part of a Visualforce page out into a component, and in the second blog post we actually did the work of that split, ending up with an easily reusable component. This time we will discuss a few more advanced uses for a Visualforce Component.

Probably the most useful aspect of a Visualforce Component is that it can contain the same content as a normal Visualforce page; it has access to the standard Visualforce tags, but also HTML, CSS, and Javascript. Therefore, it is possible to build tags that contain only Javascript or styling contents. The benefit of this is the reusability provided by a component. If a component is defined such that it contains all of the necessary references to static resources, say for CSS in a community, then the individual Visualforce pages need only include the one component, which would then provide all of the styling. Even more advanced would be composing the styling of the page with components. This would be accomplished by having components that held the styles for individual aspects of the page, and then placing them either in one container component and including that one component, or adding them in as needed to individual pages.

Figure 5 - Bootstrap, JQuery, CSS and Javascript from a component

Another great use for components are buttons that can be used throughout the customized application. Consider a situation where potentially a customer requires a set of Visualforce pages that provide a progression for users. The progression log could be completely stripped from the process pages and moved to a single component. In the example below, this is accomplished by making the component take in the name of the previous and next pages in the progression, then passing those strings into the PageReference(String) constructor. With this pattern, each page only needs to know the name of the previous and next page, but nothing about how to make that transition.

Lastly, the most complex, but potentially most useful use for Visualforce components: components that can take care of formatting values and then pass those back to the containing Visualforce page. This pattern requires a little more setup than others, but provides so much potential it is easily forgiven. For example, consider that the client wants users to enter names in numerous locations in various Visualforce pages, but each name field will have the same kind of formatting of the input. Look over the screenshots and code below, and then reference the steps that follow for the explanation.
Figure 6 - Page after loading

Figure 7 - Page as user edits the text field

Figure 8 - Page after the component formats the text

Figure 9 - Page with message indicating the formatted text is available to the parent page's controller

1. Create a class named DataWrapper. This class will wrap the values you want to pass between the containing Visualforce page's controller and the component. The reason this class is necessary is that by default primitive data types are passed by value and thus copied from the container page's controller to the component, while objects are passed by reference. This matters because a copied value no longer will update the original value. Note that it has only the one internal property, this is all we really want and need, but it must be in an Object so we get the by reference behavior.

2. Create a component named NameInputTextComponent. This is where we will encapsulate all of the formatting logic. The component is not complex for this example, it has one attribute that takes in a DataWrapper type of object, the one <apex:inputText> tag with a <apex:actionSupport> tag. The input is pretty self-explanatory, while the action support tag is used to fire off the formatting function when the input field loses focus.

3. Create a controller for the component (NameInputTextComponentController). This is where all the heavy lifting will be done. It will have a property with the type DataWrapper, a String property to actually be referenced in the component and a method to do the formatting. As discussed before, the formatting method is called by the <apex:actionSupport> tag after the input field loses focus. The input field is bound to the String property, and so gets and sets data to that property. The formatting function is the function that puts the formatted data back into the wrapper.

4. Create a page and controller where this component will be used (NameInputTextPage and NameInputTextPageController, respectively). In the controller is a property of the DataWrapper type, and lazily instantiate it with some wrapped String value. The lazy initialization is not required, but a good habit. Also in the controller is an action function that will be used just to demonstrate that the values that are truly being updated in the component and containing page.

With this simple component, a developer would be able to provide the formatted name fields wherever necessary. For example, the developer could provide a page where users are able to enter some number of names in a table format, click a button, and that number of Contacts are created. With this component, the client could be sure that all of the names would be formatted correctly.

Finally, that simple demonstration should showcase the power of components. They are able to do some pretty heavy lifting, and remove some of the maintenance headache that is part of large Visualforce customization by encapsulating and reusing pieces throughout.

Have questions about Visualforce Components? Let's set up a time to talk.

Sonoma Partners Community Applications for CRM 2015

Posted by on January 28, 2015  |  commentsComments (0)

Today’s post is co-written by Kevin Yamashita, a Senior Quality Analyst at Sonoma Partners.

With the release of Dynamics 2015, we're excited to announce that our community applications (Editable Grid, Universal Search, Dynamic Forms) have been updated and are now compatible with CRM 2015. As always, these tools are available for both on-prem and online deployments for free!

CRM 2015 introduces Multi-Entity Search functionality for the Web client and also enhanced their Business Rules feature. You may wonder how that impacts Universal Search and Dynamic Forms. Let’s compare each of our community tools to those new features so you can decide which tool will best suit your needs.

Universal Search  (US) vs Multi-Entity Search (MES)

Feature Universal Search Multi-Entity Search Notes
Search Configuration Native Quick Find View Native Quick Find View Both solutions use the Quick Find View to configure the search and return columns
Entity Support Unlimited* 10 max * We still recommend limiting to a reasonable number for performance
Results Display Configurable – unlimited fields from Quick Find* Configurable - first 3 fields of Quick Find * We still recommend limiting to a reasonable number for performance
Tablet Client Access No Yes  
Web Access Application menu CRM masthead MES will always be available for users, while US may not depending on how CRM displays the application menu buttons
Related Record Access Yes No US allows a user to click a link to a related lookup record when returned in the search results
Filter Data Search Yes – using record createdon date No In addition to the native Quick Find configuration, US allows you to filter based on the record createdon date, which can improve performance for large data sets

As you can see from the above comparison, the native multi-entity search now provides much of the same functionality as Universal Search. And with MES’s ‘always available’ placement in the masthead & tablet client support, we recommend starting with MES for your implementations. Since Microsoft made it easy for us to update our 2013 solution for 2015 and a couple of differences still remain, we thought we would keep it available as a free download.

Dynamic Forms (DF) vs. Business Rules (BR)

Feature Dynamic Forms Business Rules Notes

Error Message Dialog
Field - Require
Field - Hide
Field - Show
Field - Disable
Field - Set
Field - Clear
Form - Disable
Form - Refresh
Form - Save
Section - Show
Section - Hide
Section - Disable
Tab - Show
Tab - Hide
Tab - Disable
JavaScript - Execute Function

Error Message Dialog
Field - Require
Field - Hide
Field - Show
Field - Disable
Field - Set
Field - Clear


Entity Field
Related Entity Field
Client (Web/ Mobile/Outlook)
Client State (Online/ Offline)
Form Type (Create/ Update/Read Only/Disabled)
Security Role
User Record Field

Entity Field

Related Entity Reference Yes No  
Else If Logic No Yes  
“And” or “Or” No Yes BR allows for the use of "and" or "or" logic between conditions, while DF supports only "and" logic
Event Triggers Client-side Both client and server side  
Number of Rules 10* Unlimited * The free community edition allows you a maximum of 10 rules.
Tablet Client Yes Yes  

Unlike Universal Search, Dynamic Forms continues to have advantages, particularly with the number of extra conditions that DF provides. We recommend you consider the functionality you need to provide and decide on the best tool to accomplish it. When you can, keep using the native tools that Microsoft provides and then augment the gaps with DF.

Also, note that our latest solution file downloads for CRM 2015 also should import to CRM 2013 (you should see both versions in the download zip file name).

Duplicate Management and Salesforce Spring ’15

Posted by on January 28, 2015  |  commentsComments (0)

Today's post is written by Richard Failla, a Salesforce Business Analyst at Sonoma Partners.

We told you why we’re excited for Spring ’15 but now we want to dive deeper into one long-awaited feature: native Duplicate Management. While it technically falls under, it does not require a separate license to use. So if you’re running Professional Edition or above, follow along as we detail some specifics you can expect when the switch is flipped in your org.

It’s a Plumber, Not a Cleaner

Once enabled, the feature essentially creates a barrier for duplicate records to enter your system. It will not scrub your org for existing duplicates in the first release but we’re hopeful to see this enhancement in the future.

Not All Dupes Are Created Equal

In addition to Accounts, Contacts, and Leads, native Duplicate Management will work with custom objects. It’s good to see support for the core standard objects but adding in custom objects is a huge win for those with more complex orgs.

One Of These Things Is (Not) Like The Other

Any dupe-detection solution requires matching rules and often those rules need to compare data between standard and custom fields. But often we need to go further and cross data between objects. Is your new Lead already a Contact? Crossing standard and custom fields is core to managing duplicate records but to extend the feature and support cross-object detection makes this more robust than anticipated for a first release.


Warm Fuzzies

Duplicate detection is nothing without the matching algorithm underneath. And rarely will an “exact match” suit our needs. With numerous ways to abbreviate a name, we need to be able to find a match between subtle distinctions like “Incorporated” vs. “Inc.” and 5-digit vs. 9-digit zip codes. The support for “fuzzy match” logic is a great feature to roll out of the gate and Salesforce has even provided preset matching methods to help us get started.


One API To Rule Them All

If you run a data import job via the API and a match is found for a given record, you’ll get an error and that record will not import. However, there is a new Apex Class that theoretically allows developers to force a save for matching records. That should help with those unique cases where you want to avoid turning off a rule just to tend to some admin housekeeping.


Search No More

Gone are the painstaking days of training end-users to search for existing records before creating new ones. Now when users try to save a new record, potential duplicate records can pop-up (if found). Users can then peruse these records and even edit the new record’s data on the fly.

Search No More

Agnostic Platforms

Whether your end-users are entering records from their computer, phone, or tablet, native Duplicate Management is supported across all devices running Salesforce or SF1.

The “Silent Reporter”

Any dupe-detection solution brings to the fore the classic dichotomy between administrators and end-users; admins want quality data while end-users want pain-free data entry. Salesforce executed a solution that strives for balance between the two: rather than alerting end-users every time a potential dupe is found (or blocking their entry entirely), admins can now setup reports to track duplicate records on the backend without annoying end-users with popups and alerts on the frontend.

Silent Reporter

Duplicate Management is not a panacea; there are plenty of cases that demand more detailed dupe-detection capabilities. Nevertheless, we’re impressed to see all the nuances Salesforce has packed into the first release of their native Duplicate Management feature. Better yet, releasing it for free for Professional Editions and above goes a long way to help organizations looking to reduce dupes and maximize data quality without breaking the bank on 3rd-party solutions.

Activity Tracker – Microsoft Dynamics CRM Mobile Samples

Posted by on January 27, 2015  |  commentsComments (0)

Today’s post is co-written by Kyle Gerstner, a Principal Mobility Architect at Sonoma Partners.

With the rush of the holidays, you may not have noticed that the Microsoft Dynamics CRM team released a new set of sample mobile code that demonstrate how to connect and interact with Dynamics CRM from Windows Phone, Android and iOS devices.

Microsoft asked Sonoma Partners to create a sample code solution specifically for iOS and Android developers. In these discussions, we wanted to showcase more than a simple mobile example connecting CRM. We believed we could come up with a quick, easy to understand reference application that leverages the code samples mobile developers would use in common applications, but also be immediately valuable to the user community. Our key solution tenants were:

  • Provide framework for custom mobile applications
  • Phone-based application
  • Simple & common use case
  • Stand-alone reference application
  • No CRM solution changes required

We focused our use case on something every mobile user can appreciate: the ability to quickly find a contact’s details and record an interaction with that person. The results are the Activity Tracker phone sample application!


While we focused on the iOS and Android versions, Microsoft developed the Windows Phone in parallel, providing you the code to natively work with whichever device makes sense for your organization.

This starter application code was designed for mobile developers looking to get started with Dynamics CRM for the first time, as well as seasoned Dynamics CRM developers. Activity Tracker demonstrates how to find a contact and submit one type of activity interaction (a check-in task). However, the code is open source, so you have a framework to easily add additional activity types, brand the application to your color scheme, and also add additional entities (such as account and opportunity). You can also look to extend the use case slightly for more advanced scenarios.

To demonstrate, we have extended the application for our internal use to bring back tweets from a contact. We simply added a ‘Twitter Handle’ field to the contact form and use that to make a call to Twitter, retrieving all public tweets associated with that twitter handle. As you can see from the screenshot, we also altered the design of the activity history to use a horizontal scroll, for better usability with more information sources.


The Microsoft team also has demonstrated extending the application. They have a sample that enhanced the Windows Phone example to use Cortana – bringing the power of voice commands to your CRM data entry!

From a technical perspective, the samples show you how to connect to both the SOAP and OData endpoints that Dynamics CRM uses. As a mobile developer using Dynamics CRM, you will probably use both endpoints in your custom applications.

The OData endpoint is a more common approach for connecting mobile applications, and is the primary approach taken in this sample. For example, we use OData to fetch details of the contact and get the recent records list, which comes back in an easy-to-consume JSON format. However, not all of the Dynamics CRM API methods are currently supported with OData. One example of this, is using the Execute method which was needed to mark an activity as completed. Hence the need to also demonstrate how to interact with the SOAP endpoint.

We also made use of Microsoft’s ADAL library for Objective C and ADAL library for Android, which uses OAuth to authenticate the user to CRM. Like many mobile applications, this means your user authenticates from their appropriate authentication endpoint, with the credentials they already know and commonly use.  More importantly from an application development perspective, the custom application does not need or has access to your username and password. The OAuth model gives the user and system administrators the ability to revoke access if a device is lost or an employee leaves the organization, helping to further reduce the security risks generally associated with mobile applications. 

We believe these mobile samples will allow you to more quickly deploy a customized mobile application for your organization and make your mobile workforce more efficient and engaged.

Ready to mobilize your workforce? We can help. Contact us to learn more about mobile CRM applications for your business.

CRM 2015 – Scripting Options for Business Process Flows

Posted by on January 27, 2015  |  commentsComments (0)

Since the release of business process flows in CRM 2013, we’ve been clamoring for more extensibility from a scripting standpoint.  With the release of CRM 2015 Microsoft has added several new methods to the javascript API that allow developers to greatly extend the out-of-the-box business process flows capability.

The following is a list of the new API methods from this MSDN article.  We are particularly most excited about the ability to dynamically hide/show the business process flow control.

Change the process when there are more than one process available for the entity.
Use to retrieve information about enabled processes that the user can choose for the entity. Then use to make one of the enabled processes the active one.

Move to the next stage when all required steps are completed to make it the current active stage.

Move to the previous stage and make it the current active stage.

Select a stage to view the status of the steps in the stage.
Use to retrieve information about the stages that have been completed, the current active stage, and valid stages available from the current active stage. Examine the steps included in that stage and compare the corresponding form attribute values to determine whether they are completed.

Complete a step
Steps are completed when the corresponding data in the form is entered. You can determine the attribute using the step getAttribute method. This will return the logical name of the attribute. Then use Xrm.Page.getAttribute to retrieve attribute from the collection and then use the attribute setValue method to set the value.

Detect whether a step is required
Use the step isRequired method to determine if a step is required by the business process flow.

Expand or collapse the business process flow control
Use Xrm.Page.ui.process.setDisplayState.

Hide the process control
Use Xrm.Page.ui.process.setVisible, you can control whether to display the business process flow control.

Skip to a valid completed stage.
Use to set one of the valid completed stages for the current entity.

Query the process definition including stages not currently visible
Use to query the definition of the business process flow, including stages that might not be visible because of branching logic in the process.

Events for business process flows
You can interact any event provided by the form with business process flows, but two new events allow you to execute code based on events just for the business process flow control. You can execute code when the active stage of a business process flow changes (OnStageChange event) or when a stage is selected (OnStageSelected event).

The SDK team also provided a couple great samples for the new scripting methods.  Check out this sample on how to retrieve information about the enabled processes for an entity and this sample on retrieving information about the stages and steps in the active business process flow path.

Make Your Visualforce Components More Useful, Part 2

Posted by on January 22, 2015  |  commentsComments (0)

Today's post is written by Andrew Monshizadeh, an iOS Developer at Sonoma Partners.

In the previous blog post, we discussed a situation where it would be beneficial to break parts of a Visualforce page and Apex backing into a Visualforce component. As a review, the benefit of Visualforce components is that they make it possible to prevent duplication of code. The less code there is overall, the easier it is to test and maintain.

At the end of the last blog post, the naïve approach to the Case and Case Comment list was implemented using a normal <apex:pageBlockTable> tag in the Visualforce page.

Figure 3 - Custom page block table

This example is simple. But it isn’t difficult to imagine that a client would want a Visualforce page that included a large number of fields, some for display and some editable, along with validation logic that needs to happen throughout the time the user is on the page, which would need to be done in the Apex controller. Though it would be possible to move the Case Comment based logic to a separate extension controller, this doesn’t solve the problem of truly breaking the code into a reusable chunk. The developer would still need to come back to this page and copy/paste the Visualforce.

Enter Visualforce components.

Visualforce components make it easier to reuse Visualforce and Apex code throughout the entire org. This is because it forces the developer to consider the behavior and content in the component as a stand-alone unit.

The first step to breaking out a component, is determining what exactly should be in the component. It is important at this point to try and determine the smallest set of content and behavior to break out. There is no benefit in carrying around excess baggage. So in this case, the developer would only be interested in the actual table displaying the Case Comments. For this simple example, it is possible to take the original Visualforce and move it into a new component, almost entirely unchanged.


Note that the component has its own backing Apex controller. This simplifies the logic within the component’s Visualforce markup because the backing controller can be developed to fit the needs of the component. Therefore, it is possible to contain just the list of Case Comments with no look ups necessary.


With this component defined, it is now possible to use it in the original Visualforce page in place of the normal table. This also simplifies the page’s controller, so much so in fact, that it is no longer necessary.

2Figure 4 - Custom page block table but now in a component

Clearly this simplifies the overall Visualforce page development, and does not impact the user experience. Also, it means that this list of Case Comments may be used anywhere Visualforce is used (and an Account object is available) with a minimum amount of code. Finally, by making this a component, any time a change is made to the component that is reflected everywhere the component is used.

In our next and final Visualforce component post, we will discuss a few advanced uses for Visualforce components.


Dynamics CRM 2015 – Advanced Find Returns

Posted by on January 21, 2015  |  commentsComments (1)

Like most users of Dynamics CRM 2013, it’s taking me awhile to get used to the new navigation.  However, with any software deployment, it takes users time to get used to the new functionality and especially the new look and feel. 

It’s hard to remember when CRM 2011 came out (way back almost 4 years ago now) and the introduction of the ribbon.  What a crazy concept the ribbon was and how would we ever get used to it?  However, after using 2011 over time (and honestly any Microsoft product), the ribbon became second nature.  When Microsoft removed the ribbon in 2013, everyone complained it was missing.  How would we now get used to not having a ribbon?  I believe that over time Dynamics CRM 2013 and 2015 will fall into the same camp as 2011 where users will become comfortable using the new navigation and will have forgotten the ribbon ever existed.

We recently just upgraded our internal CRM deployment to 2015 and I’m forced to get used to the navigation even quicker than originally anticipated.  Of course with every new release there are those learning curves and the questions you ask “why did they do it this way?” but the good news is that with Microsoft, they’re listening.

One of the biggest complaints of 2013 is the fact that the Advanced Find was buried and not readily available on the global tool bar like it was in 2011.  In some areas of the application you couldn’t even initiate Advanced Find.  And those areas where you could, you had to click on the ellipsis to bring down additional contextual menu items to find Advanced Find.


However, the good news is in 2015, Microsoft has listened to initial feedback from users of 2013, and have added the Advanced Find menu back in the global tool bar so that you can always initiate Advanced Find no matter where you are in the application. Enjoy!


Data De-Duplication through Fuzzy Matching

Posted by on January 16, 2015  |  commentsComments (0)

Today's guest blogger is Chris LaBadie, a Senior Database Developer at Sonoma Partners

Whenever we work on a data project for a customer the subject of cleaning their client data is always a discussion point.  The project could involve a migration from one CRM platform to another, integrating an ERP system into CRM, or even cleaning their data “in place”- but the message is usually the same, “we know we have duplicates in our data, help us clean it up!”

Anybody that has ever tried to track people or companies knows that it can be a huge challenge to avoid duplicate data.  When you have multiple users maintaining data, it is very common to introduce duplicate data no matter the de-duplication safeguards your system uses. 

Working with people-
•    Names can be difficult to track (misspellings, maiden names, nicknames, etc).
•    People move/change contact information.
•    Even unique fields like address or email address can be shared amongst more than one person. 

Working with companies-
•    Abbreviations or acronyms in names can present a challenge.
•    Companies can have multiple locations.
•    Often use different addresses to track billing, shipping, etc.

In our experience, there isn’t a magic bullet to eliminate de-duplication.  The best solution is usually a layered approach- use form validation to ensure quality data entry, intelligent system design to store records in an organized manner, and system de-duplication rules to search out potential duplicate data and present to a user records that might match the information they are attempting to enter. 

However, a common project for Sonoma Partners is moving a client to a new CRM platform and an important part of migrating data to the new platform is to identify potential duplicate data before it ever reaches the new system.  While this may sound like a large effort, it is actually pretty easy thanks to the Fuzzy Grouping functionality built into SQL Server Integration Services (SSIS). 

Fuzzy Grouping allows SSIS to inspect a set of data and compare one or more fields in the dataset.  Rather than comparing the field data, Fuzzy Grouping will match strings based on their sounds- giving more accurate results based on how a person would hear the string while overcoming misspellings, typos, abbreviations, nicknames, etc.  Note, you will need SQL Server Enterprise or SQL Server Developer edition to use Fuzzy Grouping.  This example is developed using the Business Intelligence Design Studio (BIDS) in SQL Server 2012.

In this demonstration we will process an Excel file of contacts.  This file can be generated from any other system and used in a process like this to identify potential duplicate data before that data is migrated to CRM.  The end result of this process is to produce a file containing potential duplicates so they can be reviewed and cleaned up in the source system before data migration.

Fuzzy Grouping evaluates the file of Contacts and compares them based on selected fields.  Potentially duplicate records are grouped together and assigned a group number.

After Fuzzy Grouping, the process splits so it can sort the results based on their Fuzzy Grouping group number and count the number of records per group. 

Finally, a step to check the group count determines which records are potential dupes- a group count of 1 means the record is unique, anything more than 1 means that group contains 1 or more records that should be reviewed.  The potential duplicates are then exported to an Excel file for review. 


Configuring Fuzzy Grouping is a pretty straight-forward process, just select the fields you want to compare and set the minimum amount of similarity (roughly a percentage of matching).  This process can involve a little bit of trial and error while you fine-tune the Fuzzy Grouping to identify the records that are potential duplicates without letting through any false positives. 

Typically we will start with lower minimums and go up until we are seeing the desired results.


When you run the process, you can see how many records it processes and how many records SSIS ultimately decided to export to Excel for review.


When the process is complete, you can view the results in your Excel file. Here you can see the unique record number assigned to the record (KeyIn), group number (KeyOut), overall score (percentage of match to the potential duplicate record), similarities for First Name/Last Name/City (percentage of match for each column), and the Group Count (number of potential duplicates per record group).  The highlighted values in the screenshot show some of the values that were compared and demonstrate how Fuzzy Grouping can identify potential duplicates despite common misspellings, nicknames, and partial matches. 


In conclusion, Fuzzy Grouping is an easy to use and powerful tool to assist in any data cleanup effort.  It is simple to setup, and quickly evaluates large amounts of data.  SSIS can provide you with all of the tools to make informed decisions regarding your customer data, your most valuable asset.

Spring ’15 – Why we’re excited

Posted by on January 14, 2015  |  commentsComments (0)

Over the holidays, Salesforce posted the Spring ’15 release notes detailing what they’re planning on releasing come mid-February. I’ve poured through them to pull out what I think are the most exciting for both our customers and us.

Duplicate Management now Generally Available

We talked briefly about this in our Winter ’15 preview post, and with this release it has both become Generally Available and includes several improvements. This feature brings improved duplicate detection and blocking to the core Salesforce platform, and contrary to our preview post this feature does not require an extra license (although it does use technology). Several key enhancements were made from the Beta release in Winter ’15 including:

  • Support for custom objects
  • Ability to define cross object rules for duplicates
  • Support for picklist values
  • APIs and Apex classes added to let developers manage duplicate detection programmatically

There are some limitations to the duplicate detection to be aware of, so as always be sure to read the release notes.

This feature is available in Professional, Enterprise, Performance, Unlimited, and Developer editions.

Analytics Cloud (Wave)

It would be difficult to create this list and justify leaving out Analytics Cloud. Arguably the biggest announcement to come out of Dreamforce this past year, Analytics Cloud is Salesforce’s take on how to do analytics and reporting in a user and mobile friendly way. It’s built on top of the Salesforce platform so there’s no need to host it yourself, but it does cost an additional fee.

This feature is available in Enterprise, Performance, and Unlimited editions.

Exchange Sync (beta)

This feature is actually a combination of 2 new product offerings from Salesforce: an exchange connector which can sync contacts and events to and from an exchange server and Salesforce, and the Salesforce Side Panel. The exchange connector is the beta portion here, giving administrators the ability to set up a connection between Salesforce and Exchange so that users not using Outlook can still have the records sync between the two. Since this is a server side process, no additional software is needed to be installed on the user’s machines.

Create or Edit Records Owned by Inactive Users

This may seem like a silly feature at first, but any business that’s been around for more than a few years will probably have records owned by people who no longer work at the company. Until now, you needed to reassign those records to another user before you could update them. In some cases, especially in integration scenarios, we really just want to update the record no matter who the owner is. With this feature, we can finally do so.

This feature is available in all editions.

Google Maps

With this feature, any record which has a standard address field (Accounts, Contacts, etc) will now display a Google map image of the address if the fields are filled in. Note that Salesforce did send an opt-out notice, and that the feature can always be disabled via the settings menu.

And much more…

Of course, this only scratches the surface of all the improvements made by Salesforce in the upcoming release. If there’s something in particular you are wondering about that we didn’t cover here, feel free to read through the full release notes or contact us and we can help you find what you’re looking for.

Salesforce HTTPS Certificate Change

Posted by on January 8, 2015  |  commentsComments (0)

Salesforce recently alerted administrators of organizations to an upcoming change to the certificates used in HTTPS. We think that security should always be taken seriously. That being said, it can be frustrating to stay on top of updates, especially if a change breaks your everyday flow.  To ensure that as many people as possible see the notification, we’ve posted the body of the notification below.

What is changing?
To maintain alignment with security best practices and the industry-wide shift to use more complex algorithms for HTTPS certificates, Salesforce will be replacing current HTTPS certificates, which are signed with a SHA-1 hash algorithm, to new certificates signed with a SHA-256 hash algorithm. HTTPS certificates are reflected in the browser’s URL bar to indicate a secure connection while accessing secure websites, including Salesforce.

What action do I need to take?
In order for users to continue to have access to Salesforce, you need to ensure your operating systems (OSs), browsers and middleware are capable of accepting HTTPS certificates with SHA-256 hash algorithms.

We are asking all customers to be prepared for this change by:

  • April 1, 2015 for Sandboxes
  • August 1, 2015 for all Instances

We will begin changing HTTPS certificates in a phased approach shortly after these dates. Exact dates will be published in March 2015.

Is there a quick way to test if I am prepared for this change?
Yes. We have established this test page to quickly check if your OSs, browsers and middleware will accept HTTPS certificates with SHA-256 hash algorithms. We have provided instructions for how to use this test page in this Knowledge Article.

What will happen if my OSs, browsers, and middleware are not capable of accepting these new HTTPS certificates?
If your OSs, browsers, and middleware cannot validate the new HTTPS certificates, your users will not be able to access Salesforce.

Why are you not changing the HTTPS certificates sooner?
The HTTPS certificates that Salesforce uses today are secure. However, it is a best practice to continuously increase the complexity of security encryption protocols and tools. We designed the timeline to give customers time to prepare for this change while maintaining a secure environment.

What if we use middleware that requires us to upload the certificate into the middleware (i.e. locally cached)?
If your organization is running middleware that requires the certificates to be locally cached, you will need to update the cached certificates as a result of this change. To learn more about how this information will be communicated, please join the customer Success Community Collaboration group, Official: Certificate Changes.

Where can I get more information?
We have developed a Knowledge Article to provide additional information. Additionally, you can reach out to Customer Support by logging a case in the Help & Training portal.

Dynamics CRM 2015 Outlook and Sync Enhancements

Posted by on January 5, 2015  |  commentsComments (0)

Microsoft recently announced new features that have come out with their next version of Microsoft Dynamics CRM 2015 (previously code named Vega).  Check out the Dynamics CRM 2015 Release Preview Guide to see what features came with 2015. 

Next up for our review are the enhancements being made to Outlook and the Sync Process.  One thing to note is that all the enhancements outlined in this blog apply to both the legacy Outlook Sync and new Server Side Sync process introduced with CRM 2013. 

Below are the enhancements that are included with CRM 2015.  We’ll go into a few of these enhancements in more detail later in this blog.

  • Contact Phone Number and Address Sync Improvements
  • Sync Outlook Assigned Task (Outlook task assigned to another user that is also in CRM).  This is not enabled out of the box and a System Setting needs to be enabled to turn this on
  • Sync Appointment Attachments.  This is also controlled via a System Setting.
  • Configurable Field Level Sync
  • Outlook Client

System Settings

Navigating to Settings –> Administration –> System Settings –> Synchronization will display the dialog of all the organization level settings regarding the Outlook sync process.  See below.

In this dialog you have a mix of legacy pre-2015 settings, and a handful of new 2015 settings.  The new configuration settings you have at your disposal are:

  • Synchronized Fields:  This is where an admin can modify what direction fields are synced.  This is explained more below.
  • Synchronize Appointment Attachments:  With 2015, you can enable attachments on appointments to synchronize between Outlook and Dynamics CRM.
  • Address Sync:  This is explained more in the section below.
  • Synchronize Assigned Tasks:  An admin can enable if Outlook Tasks that are assigned to another user are tracked in CRM or not.


Contact Phone Number and Address Sync

With CRM 2015, Microsoft has changed the sync process for Contacts.  4 more phone numbers were added to the sync process for a total of 11:

  • Assistant’s Phone
  • Business Fax
  • Business Phone
  • Business Phone 2
  • Callback Number
  • Company Phone
  • Home Phone
  • Home Phone 2
  • Mobile Phone
  • Telephone 3
  • Pager

There’s also an organization level System Setting that allows you to indicate if you want to sync either A) just the Outlook Mailing Address, or B) all 3 Outlook Addresses (Business, Home, Other).  This setting is available by going to Settings –> Administration –> System Settings (shown above).

Configurable Field Level Sync

One of the biggest questions we’re asked over and over with our clients is what fields are synchronized between Outlook and Dynamics CRM.  There are a few sites out there that go into detail on what fields are synchronized, but nothing within the application provided by Microsoft.  They also don’t easily indicate which Outlook fields synchronize to which CRM fields, the direction of the sync, and the ability to turn off that sync (in other words, all fields synchronized all the time).

Now with Dynamics CRM 2015, you can navigate to Settings –> Administration –> System Settings –> Synchronization –> Synchronized Fields.  From this location, you can see the mapping between Outlook fields and CRM fields and the direction that the sync is currently configured for. 


For each field you can modify the sync direction so that it syncs both ways, sync one way, or don’t sync at all.  This is currently an Organization level setting that’s setup in the Settings area of CRM and one improvement that I can see here is making this a user setting so that each user can have individual unique sync experiences if for some reason they don’t want to share information about Contacts that are in their Outlook and also tracked within CRM. However, for the current release of 2015, individual users can at least view the sync directions that their administrator setup by navigating to their Personal Options –> Synchronization –> Synchronized Fields

There are a couple quick use cases that come to mind that I know most customers would be ecstatic to get their hands on:

  • Private Notes:  Turn off the sync process on the Outlook Notes field.  Therefore users can add Notes within Outlook and they won’t flow to CRM for everyone to see.  They can keep their own personal notes locally in Outlook.
  • Read Only CRM Data:  Set the sync direction on the desired read only fields to go from CRM to Outlook only, meaning updates in Outlook will not update CRM, and CRM will overwrite Outlook changes.

Another resource on this subject is an article that Microsoft recently published.  While having this in the application is useful, this link also provides more details for administrators.

Outlook Client Enhancements

There have been changes to the Outlook Client itself in addition to the sync changes. 

First off Microsoft has now added OAuth support to the Outlook Client.  This enables multi-factor authorization to the Outlook client and brings consistency across CRM clients (web and Outlook). 

Microsoft has also cut the clutter out of configuring the Outlook client.  Users simply need to provide the Organization URL to get up and running as fast as possible.  See below for what the configuration process looks in Dynamics 2013, and how much easier it is in 2015.



Also, in order to help troubleshooting issues between Client and Server, Dynamics CRM 2015 now automatically detects compatibility issues between the Client and Server.  A notification is sent to the user if a compatibility issue is detected.

Finally, another troubleshooting addition made by Microsoft is when errors are detected, a “Resolve This Issue” dynamic help link will appear.  This link will be dynamic and will search a server side database of articles that will route customers to the right resolution for their issue.

Upgrade Experience and Supportability

This topic isn’t really an enhancement, but goes into details on moving to the Dynamics CRM 2015 Outlook client, and what versions are supported.

In order to upgrade to the 2015 Outlook client, you must be on Outlook 2010 or higher (support for Office 2007 is being dropped).  Microsoft is also dropping support for:

  • IE 8, IE 9
  • Windows Vista
  • Windows Server 2008 Remote Desktop Services
  • Windows Server 2008 R2 Remote Desktop Services

The Outlook Client must be in “Online Mode” for the upgrade to succeed, and Microsoft is allowing all 2013 Outlook Client versions to upgrade to the 2015 Outlook Client.  Also, users will be able to continue to use the 2013 Outlook Client if they deploy the 2015 server.  However, they’ll only be able to use it in “Online Mode” (i.e., no offline capabilities will be supported).

The recommended process for upgrading your Outlook Client is the following.  This process will ensure users are able to continue to use their Outlook Clients during your server upgrade to Dynamics 2015.

  • Upgrade all Outlook Clients to 2013
  • Upgrade your server to 2015
  • Upgrade all Outlook Clients to 2015

We hope you’ll find that these improvements will add more configurability and robust functionality to the Outlook Client.  I can see some future improvements Microsoft may want to add in with the sync process (allowing administrators to add/remove/edit what Outlook fields sync to what CRM fields including the ability to sync to custom fields), but it’s good to see Microsoft is continuing to go down the path of putting more configurability options in the hands of administrators, and removing any hard coded logic.

Good luck with your 2015 upgrade, and with all upgrades, plan…test…plan…and test some more!!

$Permission on the Salesforce Platform – Part 3

Posted by on December 29, 2014  |  commentsComments (0)

In part one of this series, we looked at how and why you would create custom permissions, and in part two we looked at how a developer could use them when writing Visualforce. In today’s post, we’ll be looking at how developers can use custom permissions when writing Apex code to control access and functionality inside triggers, web services, and Visualforce controllers.

Custom Permission

Under the hood, Salesforce stores custom permissions as Custom Permission records. When writing apex code, we need to query this table to determine what custom permissions exist, and then tie those records back to the user through the SetupEntityAccess and PermissionSetAssignment objects. To help visualize the hierarchy we need to traverse, we’ve created an ERD describing the relationship of the objects:


The important thing to understand here is that eventually every permission gets tracked through a PermissionSet record, even the permissions granted by profiles (API 25+). Using these objects, developers can write utility functions for determining what custom permissions a user or group of users have assigned to them, and act accordingly.

Wrap Up

Confused about custom permissions? Not sure how to access them from your code? Need a partner to help you navigate the configuration sea? Contact us and we can help.

$Permission on the Salesforce Platform – Part 2

Posted by on December 22, 2014  |  commentsComments (0)

In part one of this series, we looked at how and why you would create custom permissions. Now that we have a custom permission created, we’re going to look at how a developer can use them when writing a Visualforce page to control the functionality of the page.

The $Permission global variable

Along with the release of custom permissions, Salesforce also released a new global merge variable for Visualforce called $Permission. The new merge variable contains boolean values indicating if the current user has a given custom permission.

Using our Manage VIP Status custom permission we built in part one, we can build a very simple Visualforce page which just prints out if the current user has the custom permission or not:

When the user does not have the custom permission assigned to them, the page displays:


However, when the custom permission is assigned to the user, the page displays:


As you can see, it is very easy for developers to leverage custom permissions when building Visualforce pages to control access and functionality at a more granular level.

In part 3 of this series, we will look at how developers can access custom permissions from Apex code to control access inside triggers, web services and Visualforce controllers.

Wrap Up

Confused about the new merge variable? Not sure what merge variables are? Something else on your mind? Contact us and we can help.

Unsupported Customizations in CRM 2015

Posted by on December 19, 2014  |  commentsComments (1)

Microsoft has been rolling out CRM 2015 for Online organizations (On-prem download can be found here) but before you perform the update you will want to review the new list of unsupported customizations in 2015 to see if you are currently using any of them.

Earlier in the year, in the 2013 SDK, Microsoft provided a list of things that will be changing in the next release which can also be found here in the MSDN.  Only 3 functions are being removed, getServerUrl (use getClientUrl), isOutlookClient (use client.getClient) and isOutlookClientOnline (use client.getClientState).  The Xrm.Page.ui.getFormType call will no longer return 5 for Quick Create and 11 for Read Optimized as those types of forms were removed/deprecated in earlier releases.  Also be sure that your customizations are no longer using the old 2007 endpoint as it is removed in CRM 2015.  To help detect if you are using the 2007 endpoint, you can run the Legacy Feature Check tool against your organizations.

Lastly, there have been some changes to the web application requirements for CRM 2015.  Support for IE8 and IE9 has been removed with the new version.  See below for a list of all the supported browsers:

  • Internet Explorer 10
  • Internet Explorer 11
  • Mozilla Firefox (latest publicly released version) running on Windows 8.1 or Windows 8, or Windows 7
  • Google Chrome (latest publicly released version) running on Windows 8.1 or Windows 8, or Windows 7, or Google Nexus 10 tablet
  • Apple Safari (latest publicly released version) running on Mac OS X 10.8 (Mountain Lion), 10.9 (Mavericks), or Apple iPad

And the supported versions of Microsoft Office:

  • Microsoft Office 365
  • Microsoft Office 2010
  • Microsoft Office 2013

As always be sure to perform the upgrade first in a development or sandbox org to verify that your customizations are still functioning post-upgrade before upgrading your production environment.

Make Your Visualforce Components More Useful

Posted by on December 19, 2014  |  commentsComments (0)

Today's post is written by Andrew Monshizadeh, an iOS Developer at Sonoma Partners.

As consultants, we are often asked to provide fully customized solutions for our clients' needs. This can range from basic customization via the Setup interface (Point & Click Customization) to creating entirely new experiences on top of the platform. Often though, we are found somewhere in the middle and need to create simpler Visualforce pages, and backing Apex controller/extensions, to simplify some processes for the client.

When developing Visualforce pages, there comes a point where it feels like sections are starting to be repeated. In development, there is a principle called "Don't Repeat Yourself" (DRY) that says if there is code being repeated, the developer needs to rewrite that code into a reusable component. The DRY'er the code, the easier it should be to maintain and understand. Thankfully, the platform provides this functionality for Visualforce -- Visualforce Components.

Visualforce Components are little (or big) snippets of Visualforce that can be reused across numerous Visualforce pages, or multiple times in a single page. These components, then encapsulate whatever reusable visual and logical elements necessary to be self-containing. Additionally, a Visualforce Component can have a backing Apex controller class. With that backing controller, the component can do additional processing necessary for itself, without relying on the parent page's controller.

As an example of where this can be helpful, consider the situation where a client wants to display a table of Case records relating to a given Account. Normally, the developer would just put an <apex:relatedList> tag in there, and call it good. 
Figure 1: What a standard related list would look like

However, what if the client wants some dynamically generated content in that table, like the most recent Case Comment inline with the Case Number? This is not so simple.

The most common solution would be to use an <apex:pageBlockTable> tag, pass in a list of Cases, and create a Map of Case ID to Case Comment Body in the page's Apex Controller. However, this potentially breaks the concept of DRY code if there is even another situation where the client wants to use this list of Cases and Case Comments because all of the logic and view is tied into this one Visualforce page. In order to reuse this Case list, the developer would have to copy/paste the Visualforce and Apex into another page and controller.
Figure 2: Custom page block table

A better solution would be to move the <apex:pageBlockTable> tag, along with the Case and Case Comment Apex code out into a Visualforce Component and backing Apex Controller. With a properly developed component, it is extremely simple to add this Case and Case Comment list to any page that needs to display this information.

In the second part of this post, we will discuss the process of building this example component.

Have questions about Visualforce Components? Let's set up a time to talk.

The Salesforce Admin’s Toolbox: Embed a Flow in a Custom Button

Posted by on December 18, 2014  |  commentsComments (0)


The Salesforce Admin's Toolbox is written by Megan Burch, a Salesforce Business Analyst at Sonoma Partners.

Salesforce is a powerful platform and it’s incredible to see what administrators can do without custom code or development. But what many Salesforce admins don’t realize is that they can solve many complex scenarios with a just a little bit of code and configuration, without the assistance of a developer.

The Salesforce Admin’s Toolbox is a series designed to showcase a variety of technical tasks that admins can do to elevate their Salesforce solution. I’m here to empower the admin and show you how to accomplish things you once believed could only be done by a developer.

Visual workflows allow admins to construct complex scenarios with forms and business processes. What becomes a little tricky, is providing users an easy way to access the flow within Salesforce.  Users access these flows directly from a URL, through a custom web tab, or a custom button. Personally, I like using custom buttons to access the flow because the user can run it directly from the record they’re viewing.  This approach may appear a bit intimidating because in addition to creating the custom button, you first have to embed the flow in a Visualforce page. But as you will see, this is really not as hard as it sounds if you follow these steps. 

1. Create a new Visualforce Page
This can be done by navigating to Setup > Develop > Pages then clicking “New”

2. Embed your flow
Every new Visualforce page starts out looking like this 


Remove the existing code.

For line 1, type the following:

<apex:page standardController="Contact" tabStyle="Contact" >›

The <apex:page /> tag is the command to create the page.

Note you’ll set the style of the page based on the object where you want the button to appear. In this case we’re going to put it on the Contact page. If you’re using this on another object, just substitute the name in line 1, if you’re using a custom object, append __c at the end for the standardController and tabStyle values. 

The second line of your page will call the flow using a component. The component for calling a flow is simply <flow:interview /> with a name filled out.

On the second line, use the following:

<flow:interview name="Call_Script"></flow:interview>

Note: The name must be the unique name you created in Salesforce, so underscores will be used between words. If you’re not sure what the unique name of your flow is, navigate back to the flow you created and locate the unique name on the top right.


The last line will just be the closing page tag, so overall you’re page will look like this:

<apex:page standardController="Contact" tabStyle="Contact" >

         <flow:interview name="Call_Script"></flow:interview>


We have just created a custom VisualForce page! Next we need to create the custom button that will access our new page.

3. Create a Custom Button
To create a custom button navigate to the “Button, Links, and Actions” option from the object you want to create the button. For your example, we will use the Contact object.

The first thing you’ll want to set is the display type. 

A “Detail Page Link” button will show up next to the custom links on the detail page. 


A “List Button” will show up on any related lists or list view you choose to put it on. 


For this example, I chose a “Detail Page Button”. This means the custom button will show up at the top of the record along with the standard Salesforce buttons.

Next, choose your behavior. This just gives you an option of how you want the flow to open. As you can guess, the Display in new window option opens the page in a new window. 

Display in existing window with sidebar will run the flow in the same window you were in, showing the Salesforce sidebar. 

Display in existing window without sidebar will run the flow in the same window you were in, without showing the Salesforce sidebar. 

Display in existing window without sidebar or header will run the flow in the same window you were in, without showing the Salesforce sidebar or standard header. 

Execute JavaScript will execute any JavaScript written in your organization that is set to run items upon click.

Again for this example, I chose Display in new window. I chose this behavior so the user could run the flow without losing visibility of the contact record they were on previously.Finally, you’ll want to select your content source, which in this case is Visualforce page.

In the Content drop down, you’ll see a list of all the Visualforce pages in your organization. Pick the page you just created and save.

4. Adding a Custom Button to a Page Layout
To add your custom button, navigate to the edit page layout screen. Select the “Buttons” option from the sidebar, and drag your button onto the page.

Users will now be able to launch the custom flow without leaving the record, which is a huge win over the custom URL solution.



$Permission on the Salesforce Platform – Part 1

Posted by on December 15, 2014  |  commentsComments (2)

Salesforce comes with an extensive security model built in that can handle many different scenarios, from controlling access to data and functionality, to guiding data through different flows and business processes. However, no security model, no matter how extensive, can possibly cover every need of every business and still be useable. To account for this, Salesforce added custom permissions in Winter ‘15 to allow administrators and developers to extend the security model to meet their needs. In the following posts, we will be looking at use cases for custom permissions, as well as how to create them and use them.

A use case for custom permissions

Let’s assume we work at a company where Accounts can become “VIP” accounts. The rule is that there is one person at the company in charge of maintaining who the VIP accounts are. This person could potentially be anyone. Our company would like the ability to change who the VIP manager is as needed. How would we accomplish this?

One solution is to add a checkbox to the User record that tracks if the user is a VIP manager or not. This works, but there are a few draw backs. The first is that to maintain who is a VIP manager, you need to go in to each user record and update the bit field accordingly. For a large company that has many potential VIP managers, this can become time consuming and error prone. The second main problem is that this architecture isn’t semantic about what the bit field is actually doing. What this option really represents is the ability (read: permission) of the User to elevate and demote Accounts to VIP status.

With Winter ’15, we now have the ability to create and assign custom permissions. Once created, custom permissions can then be leveraged by developers while they’re writing code to enforce that certain functionality or behavior is only available to people with or without the permission.

The advantages of custom permissions are twofold. To start, they can be included in Permission Sets to bulk apply it to your users, as well as associated with profiles so that any user with the profile automatically gets the custom permission assigned to them. Secondly, they’re more semantic about what they’re doing. It’s clear that they’re granting someone access to do something instead of just providing data about the user.

Creating a custom permission

To create a custom permission, navigate to Setup > Develop > Custom Permissions and click the New button. 


On the following screen, give the custom permission a Label and Name (the name is used by developers when referencing the permission in code). You can optionally give a description of the permission, and relate it to a Connected Application if applicable.


After clicking save, your new permission is created and available for use in code.

In part 2 of this series, we’ll look at how developers can use the custom permission when creating Visualforce pages to control how the page functions.

Wrap Up

Curious about custom permissions? Not sure when to use them? Just need someone to talk to? Contact us and we can help.

Salesforce Logins for Safari

Posted by on December 3, 2014  |  commentsComments (0)

Today's post is written by Andrew Monshizadeh, an iOS Developer at Sonoma Partners.

As a developer who primarily works on an Apple laptop, I recently upgraded to OS X Yosemite.

However, that brought with it a few problems - namely, my browser of choice (Chrome) updated to a version that broke compatibility with a few enterprise applications we use on a daily basis. To prevent having to switch between browsers constantly, I decided to move my entire workflow to Safari. 

I quickly ran into a roadblock though — with the number of Salesforce orgs I use numbering into the double digits, I am unable to remember all of those logins. On Chrome I used the wonderful Logins. Safari, however, did not have anything like that. Therefore, I decided to build it. 

My goal was never to completely reimplement Logins, but rather to learn about Safari Extensions by building out the most important and basic functions — store a list of login information with one click to login.  Using Bootstrap 3, I was able to create a simple interface that looks decent. Safari allows developers to create Extensions that take advantage of standard web technologies, like Local Storage or injected Javascript. Originally the extension used Local Storage, but that was potentially more insecure than we would have liked, so it was moved to a Secure Setting which is intended for things like passwords.

Overall this was a great experience learning the advantages, limitations, and potential for building Safari Extensions. If you would like to view the code, help make it better, or just use the extension, please head over to our github page and check it out!

Poodle and your CRM

Posted by on December 2, 2014  |  commentsComments (0)

Today I am co-blogging with Blake Scarlavai, Development Principal and Microsoft Dynamics blogger at Sonoma Partners.


Recently a vulnerability in SSL 3.0 known as “Poodle” gained some significant attention, with many companies responding in various ways to ensure their customers’ data is protected. It can be confusing to keep track of what companies are doing what, and what is expected of you as a customer to ensure you are not vulnerable. Below are the summaries of the responses that Salesforce and Microsoft have taken.

Salesforce’s Response

Salesforce is in the process of disabling SSL 3.0 on their platform. By the end of December, you will no longer be able to use SSL 3.0 visit Salesforce’s platform. For the most part, we don’t expect this to affect our clients as the browsers which needed SSL 3.0 still enabled (IE 6 mainly) are already not supported by Salesforce. You can get the full list of the disable schedule and more information about the changes on Salesforce’s help page.


Microsoft’s Response

Microsoft is in the process of remediating their online services for the SSL 3.0 vulnerability.  Below is a time table for each of the CRM services:


SSL v3.0 Mitigation Status

Microsoft Dynamics  CRM Online


Microsoft Dynamics Marketing


Microsoft Social Listening


Parature for Microsoft Dynamics


Microsoft Dynamics Lifecycle Services


Online Services for Microsoft Dynamics



Microsoft also recommends disabling SSL 3.0 in your browser.  The following resources can be used for your respective browser:

For more information on Microsoft’s response, click here.

Contact Us for a Quote, or Personalized Demonstrationof or Microsoft Dynamics CRM for Your Business.

Contact Us