Importing Data with Guids into Dynamics 365

Often when moving data around between Dynamics 365 (CRM) instances, you want to preserve the guids of certain records so they are the same across instances. This helps with workflows that link to entities directly - you don't have to edit the workflow and re-link things. Additionally, configuration information is usually guid-sensitive. In the past I've used Scribe or Kingsway Soft to move records around and preserve the guids - but it turns out to be very simple with Excel. Here's how to do it... [More]

My New Guitar - a Telecaster!

So, I hope everyone is staying safe and doing well during these unusual times. My family and I are doing fine and keeping busy. One of the things I decided during this COVID-19 outbreak/lockdown was to renew my passion for playing guitar. [More]

Building WinVICE 2.4

WinVICE is a Commodore emulator that lets you run Commodore 64, VIC-20, PET, etc programs on your modern computer. I prefer an older version (2.4) the most as I feel newer versions have too many extra features that I don't require.

I am also interested in Bulletin Board Systems (BBS), and I'd like to set up WinVICE on an older computer and run a Commodore BBS on it. One item has gotten in my way: any versions of WinVICE that I use will not report the presence of a modem carrier tone to the BBS software (DCD). [More]

Betelgeuse fainting spell is finally over?

According to a recent update from the Astronomer's Telegram (issue 13512 -, it is clear that decrease in brightness of Betelgeuse has stopped, and now it is increasing. This is based on photometry from the last two weeks or so that indicates Betelgeuse's visual magnitude has increased from it's lowest point of ~1.614 back up to ~1.575. [More]

Excel Checking List from Another List

This is similar to my last blog post where I explained how to filter a list in Excel based on another list. This time, the task is more straightforward - we just want to identify if an item in one list is present in another list. I find I use this technique quite often when using Excel (especially during data migrations). [More]

Excel Filtering a List Based on Another List

I've been doing some data migration recently for a customer and I've run into a few situations where I have a big list of Customer ID numbers (plus the other associated fields like Name, Address, Email, Phone, etc) and I have a smaller list of Customer ID number that I'm interested in. Using Advanced Filtering in Excel, I can get to just the records I'm interested in. [More]

D365: Set Customer field to default to Contact

Here's a handy little JavaScript that lets you set a Customer Field in CRM to default to Contact instead of Account. A Customer Field is a "special type" of field in CRM that can either be set to an Account or Contact. When you add a custom one in CRM, it defaults the lookup to go to Accounts first - the user then has to manually (every time!) change it to Contacts if they want to select a Contact record. [More]