Import Data – Watch Out for the Hyphen and Dash

On a recent Data Migration project, I needed to trouble-shoot imports from various Excel and Word data sources into Microsoft CRM entities such as Account, Contact, Notes, etc.
I had used the new November Release (R4) of the Import Data Wizard for Microsoft CRM Online.  One of the import failures encountered was that it can’t resolve the Contact Lookup of a particular Note record’s Regarding field.  The contact name was "Jung-Chai Sung" and was a CRM Contact record so the Import Data Wizard should had resolved it for the lookup in the Note’s Regarding field, but it didn’t.
Here is what I found:
Your eyes are not playing tricks on you – the two dashes are different!  And they are two different characters with different ASCII Codes so therefore they don’t match.  As a reference, there are three types of "dashes" (ASCII Code) in the ASCII Code table:
–  (45 Hyphen)

–  (150 En dash)
—  (151 Em dash)

Microsoft CRM Online’s Import Data Wizard is performing as expected.  We need to clean-up the source file and replace all the dashes with a consistent dash "-" (45 Hyphen).  Mystery solved!


Contact us if you need help with your Microsoft CRM.  Free Estimate.
Workopia, Inc.
Microsoft Dynamics CRM MVP

Follow Workopia on Twitter

FREE 30-Day Trial, Setup & Training – Microsoft CRM Online
 Sign up for a FREE 30-Day Trial, Setup & Training


About Microsoft Dynamics CRM Online

Microsoft Dynamics CRM and CRM Online specialist. Microsoft CRM MVP since 2006
This entry was posted in Data Import. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s