Phil Edry’s Dynamics CRM Blog

According to PartnerSource, the following CRM 4.0 exams release tomorrow: 

Don’t forget to get a Second Shot voucher before you register for the exam. My plan is to take the exams without much studying, and then retake them if necessary. I’m already 3.0 certified, and I took the beta training at Microsoft on 30-631 and 30-633, so who knows, I might pass the first time. I’ll write back with how I do.

The tests are listed as MB2-631, MB2-632, and MB2-633 on the Prometric website.

Thanks to Menno te Koppele for pointing it out: http://www.tekoppele.com/Blog/post/2008/04/Get-certified!.aspx

According to the Data Migration Manager help documentation, “You cannot migrate attachments to e-mail messages, sales literature items, or to any record type that does not support notes.”

So what do you do when you’re doing a data conversion and you need to migrate email attachments?

Well, there’s got to be an more elegant way than this out there, but the first thing that came to mind for me was to migrate the attachments as notes by following the instructions here: http://blogs.msdn.com/crm/archive/2008/03/11/migrating-notes-and-attachments-using-data-migration-manager.aspx

For the csv file, I had three columns. The GUID of the email’s ActivityID, the filepath+filename of the attachment relative to the “Attachments” folder, and the name of the file. I then mapped the ActivityID guid to “Title”  the filepath+filename to “Document” and the file name to “File Name”.

Then, all you need to do is go into the database and INSERT INTO ActivityMimeAttachment FROM AnnotationBase where applicable and you’re good to go! Reply to this message if you want more details or code snippets on the specifics of this hack. Fair warning, this is very unsupported.