This is something I find myself doing over and over and over again, when importing data to CRM, seeing as CRM wants the contacts as Firstname and Lastname. And the data I receive is very rarely in that condition. So I find myself having to split the column fairly often – and I always forget […]
I was tasked with migrating a ClickDimensions solution from one Dynamics 365 to another Dynamics365 (both version 9.0). The only differences were, that it was a different CRM tenant and a newer version of ClickDimensions (v9.4.0 – the old was v9.2.0). Before starting a migration, which has quite a lot of entities and data, I […]
Note: I have not yet been able to fix or workaround the issue described below I recently had to install VS2017 with KingswaySoft on a computer, and I ran into some issues in regard to the installation. After I had installed the Visual Studio software, I needed to install SSDT (15.5.0). When I attempted to […]
KingswaySoft recently released their spring 2018 release marked as version 10. This release introduces numerous awesome changes, which makes data integration and transformation a lot easier and seamless. Some of the changes include: The CRM Source component now includes a SQL to FetchXML converter which allows you to convert SQL script to FetchXML query directly […]
KingswaySoft just pushed out their Winter release for the Dynamics 365 toolkit (version 9.2), which primarily contains fixes in their toolkit. One of the bugs it fixes, is something I ran into myself. When using an upsert action to an N:N Destination, it can cause an Object reference error. I recieved a hotfix from KingswaySoft […]
Lately I’ve been working a lot more in Dynamics365 than I have onPremise, and for the most part, the online CRM offers some very cool customization options, but there are scenarios, where I really would love access to the database, when performing data transformations. The fact that we can’t simply connect to the database for […]