Posted on May 16th, 2013
Some would wonder why such a question is asked… but in my Microsoft Dynamics CRM 2011 environment, we do not require a First Name or Last Name on a Lead. When a Lead is qualified, users often click the buttons to create an Account and a Contact, even when they haven’t specified any contact-specific information (such as first and last name). What results is often a Contact with no name, and that contact is the Primary Contact for the Account. Ouch!

To fix this, we created a workflow on the Contact entity, which would deactivate the Contact if it had a Qualifying Lead, and had a blank First Name or Last Name. This took care of the Contact, but there was still a problem: the Account’s Primary Contact pointed still pointed to the nameless Contact we just deactivated!
Looking at the Audit History on the Account, we were able to figure out that, when qualifying a lead, CRM creates and updates records as follows:
- A new Account record is created. The Primary Contact field is left blank.
- A new Contact record is created. The Contact’s Account is set to the Account created in step #1.
- The Account record created in step #1 is updated. The Primary Contact field is set to the Contact created in step #2.
To solve the deactivated Primary Contact problem, we created a workflow on the Account entity, which would clear the Primary Contact field if the Primary Contact was set to a deactivated Contact.
Problem solved! Users can continue trying to create Contacts with no names, and we’ll make sure they never see them.
Posted on May 7th, 2013
Recently, I needed to compress all contents of a folder (including subfolders) to an archive file, and copy it to a remote (network) location, all from a command line. In other words, I wanted to do this:
compressAndCopyFolder <sourceFolder> <destinationFolder> <archiveFileName>
Here’s how each parameter would work:
sourceFolder is the folder, along with all subfolders, to be added to the archive.
destinationFolder is the folder where the archive would be created.
archiveFileName is the file name of the archive
I prefer 7zip for archiving, so I could have done this simply using one command:
7z.exe" a -r "%destinationFolder%\%archiveFileName%.7z" %sourceFolder%\*
The problem with this is that it is inefficient to work with a large archive file over the network — there’s a lot of chatter going on to add files to an archive file. Much faster to create the archive locally, then copy the final archive file to the network. So, instead of one command, we have two:
echo off
if "%3"=="" (
echo usage: 7zfolder ^<sourcefolder^> ^<destinationfolder^> ^<destinationfilename^>
echo Note: The suffix .7z will be added at the end of destinationFilename.
goto :eof
)
if not exist "%1" (
echo ERROR: Source folder does not exist: %1
goto :eof
)
if not exist "%2" (
echo ERROR: Destination folder does not exist: %2
goto :eof
)
if exist "%2\%3.7z" (
@echo ERROR: Destination file already exists in destination folder: %2\%3
goto :eof
)
@"c:\Program Files\7-Zip\7z.exe" a -r "%temp%\%3.7z" %1\*
@copy "%temp%\%3.7z" %2\%3.7z /z
Now, from a command line, I just do this…
7zfolder c:\mysource \\myserver\mydest archive
… and all files in c:\mysource will be added to an archive \\myserver\mydest\archive.7z.
Don’t you just love batch files?
Posted on April 29th, 2013
Today at work, someone wrote the following as a work item summary: “Synch production and test data”.
Reading this, I thought, “Which is correct – sync or synch – when shortening synchronize?”
The winner is sync, and here’s why:
We pronounce either variant as sink.
c alone is often pronounced k (cake, panic)
ch alone is often pronounced ch (church, match)
Sync = ”sink”
Synch = “sinch”
One less keystroke for sync
I was happy with that until reading an article on The Language Lover’s Blog, “Sync or Synch?“, which made me conscious of other common variants, such as psych as short for psychology.
Ultimately, my search was put to bed when I read this comment:
you guys are such nerds!!! the world really doesnt care about the voiceles velar fricative converting to a velar plosive. blogging should be eliminated from the internet.
Guilty as charged…
. . .
→ Read More: Sync or synch as short for synchronize?
Posted on April 19th, 2013
Author’s Note: I am not a runner, and I probably never will be. My body isn’t made for running. But running is a good metaphor for journeys, and like many others, though I may not run, I still take many journeys in life, some with my body, some with my mind, and some with my heart. The below came to me this morning while driving to work, a journey in itself, as I reflected not on that journey, but on the greater journey of life, and how we get through it: one step at a time.
He had prepared for this for so long, so precisely; yet nothing was going as planned.
For years, he trained on a predictable track, its curves coming at regular intervals, its flatness something he didn’t have to think about. He trained on the perfect days, not too hot, not too cold, just the right amount of moisture in the air . . .
→ Read More: The Runner’s Dilemma: A Story
Posted on January 23rd, 2013
I stumbled across this on the web today, courtesy of Mark Perry / Carpe Diem, and had to share it, because it does a good job of illustrating the perceived gender inequality in education.
57% of students in postsecondary education are men.
52% of students in gifted and talented education programs in 2009 were boys.
In 2009-10, men received 62% of all associate’s degrees, 57% of of all bachelor’s degrees, 62% of all master’s degrees, and 53% of all doctorate degrees.
One would read that and likely say it is conclusive evidence that women are under-represented in education, and there is gender inequality against them.
However, that would be a lie. In copying the above from . . .
→ Read More: Is there gender inequality in education (or anywhere else)?
|
|