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]
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]
If there is a problem with your Windows NT 3.51 server or workstation, you may need an Emergency Repair Disk to help restore corrupted or missing configuration files in order to recover your system. The Repair disk can assist you with that task.
[More]
In Windows 10, it is pretty easy to create a self-signed SSL certificate. Open an administrative PowerShell and execute the following...
[More]
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]
According to a recent update from the Astronomer's Telegram (issue 13512 - http://www.astronomerstelegram.org/?read=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]
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]
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]
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]
So, you’ve got a JavaScript you’re having trouble with. What you can do is fire up Chrome, open the Developer Tools by pressing F12, choose the Console tab, and then log into your D365 instance.
[More]