Posts by Mehmet Ozdemir
Code Free Dynamics 365 Configuration Values
Dynamics 365 Configuration Values In many systems, there will be a need to store key/value pairs for configuration data. Examples of this might be contact email address for an email template or a link to a payment gateway etc. To further complicate things we have development, test and production environments. What will be a valid…
Read MoreWindows 10 Creators Update 1703 (and April 2018 1803) VPN Not Working Fix
Update: Confirmed fixes April 2018 update as well. Are you having issues connecting to VPN services on Windows 10 Creators Update 1703? If so then read on. Having installed Windows 10 Creators Update everything was working well with no real issues for me other than needing to re-install the Dell Audio application that the Microsoft updated…
Read MoreConverting a CRM Workflow to an Action
Actions have been around for a while now and they’re a great addition to the CRM developers toolkit. But what about when you revisit an existing workflow and think, wouldn’t it be great if I could convert this guy to an action and then either call it from JavaScript or if using CRM 2016 or above use a…
Read MoreCRM 2016 On-Premise to SharePoint Online Gotcha’s
CRM 2016 On-Premise to SharePoint Online Recently, I was asked to setup server-based authentication from Dynamics CRM 2016 to SharePoint Online. Step 1, read through the TechNet article and make sure all the prerequisite stuff was complete on the CRM installation. Microsoft Dynamics CRM System Administrator security role. This is required to run the Enable Server-based SharePoint…
Read MoreQuick tip: Unable to connect to IFD Organization using XRMToolBox
Here’s a quick tip if you’re getting the following error message when trying to connect to an IFD Organization using newer versions of XRMToolBox (that use the connection wizard): Unable to Login to Dynamics CRM Assuming your IFD is setup and working correctly the issue could be something as simple as the domain and username…
Read MoreImporting a CRM Organization doesn’t always reflect the new Organization name
A typical practice when developing for CRM is to import a template org into your target environment then apply any custom schema changes (via solutions) over the top. You would then import any seed data that is required for the organization. The way to do this is a have a template organization in CRM, then…
Read MoreSSIS Task: The SQL command requires a parameter named “@Param”, which is not found in the parameter mapping.
Time for a quick blog post on this error. This error has caught me out on more than one occasion, so much so that I’m writing this post now, grrrrr! So what happens? You’re creating an SSIS Task that includes an OLEDB source. The OLEDB source calls a Stored Procedure and you’re passing in some…
Read MoreReporting Services migration made easy with ReportSync
Recently I was given a task to move a custom application developed on top of SQL Server 2005 to SQL Server 2014 (yes a big jump!). One of the tasks was to move the reports over to the new server. The server was already built and an empty reporting services instance was available. I needed a way…
Read MoreTSQL pattern matching as part of a table join
OK so anyone with some fundamental SQL knowledge will be able to read the following SQL statement and understand what it’s returning, let’s take a look:
|
1 2 3 4 5 6 |
SELECT DC.LastName, DC.FirstName, FIS.TotalProductCost FROM FactInternetSales FIS INNER JOIN DimCustomer DC ON FIS.CustomerKey = DC.CustomerKey |
To summarize we’re joining the FactInternetSales table to the DimCustomer table via the foreign key called CustomerKey. From the DimCustomer table we’re returning the LastName and FirstName and…
Read MoreConnecting the CRM Email Router to a CRM Online deployment
Here’s a quick tip for connecting the CRM Email Router to a CRM Online Deployment. If you’re following along with the documentation from Microsoft: Microsoft Dynamics CRM Email Router Installing Guide for use with Microsoft Dynamics CRM Online The section that describes connecting to a CRM Online deployment states: If you are connecting to Microsoft…
Read More