My company are in the process of migrating from Outlook Business Contacts Manager to Microsoft Dynamic CRM 4.0.
I've hit and overcame a few brick walls during this process, which is still ongoing. I've decided to document my findings in case anyone else comes up against the same problems.
The first problem I came up against and probably the most common is line breaks in your field data causes the validation process of the data migration manager to fail. It seems to see a line break as the start of a new field even when your data is surrounded by double quotes.
To be more specific it's a carriage return (Cr) followed by a line feed (Lf) that causes the problems. The only solution that I know of is to replace the CrLf pairs with just a Lf.
This can be easily done in Excel with a macro that you run over your worksheet.
Sub repLF()
Cells.Replace What:=vbCrLf, Replacement:=vbLf, LookAt:=xlPart, _SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _ReplaceFormat:=False
End Sub
For me that seems to get rid of most validation errors. I've looked at the imported data in the CRM and it seems to be OK i.e. line break still appear properly.
Hope that helps seem people who are facing the same problem.
4 comments:
Hi Jamie,
Thanks for posting this info.
I followed the outline of what you have written above to remove the (Cr)'s from my data but still wasn't able to load the data into CRM using the DMM. Did you do anything else to get the DMM to allow your line feeds?
BTW there's a small typo in your code: bvLf --> vbLf
Cheers,
Stu
Hi Stu,
Sorry for the late reply.
I never had to do anything extra, but I have read of people removing double quotes and comma's from there data.
At what point is it failing? During the validate of the data or does it not look right in the CRM?
Cheers
Ecommerce and offshore software development are burgeoning trends these days and several India-based offshore software development companies have gained reputation for offering excellent services to the clientele throughout the world. However, it would be extremely advantageous for you to assign your software development project to one of the popular India-based company because services offered by Indian software companies are cost-effective and flexible that ensure future growth and transparency.http://www.eberrymedia.com
Post a Comment