Tuesday, April 20, 2010

Who has the Outlook Client Installed

There could be times when you would want the list of User's using the CRM Client for Office Outlook. Here is a small script which you could execute on CRM's Organization database. This script will give you the machine name and user's fullname.

SELECT dbo.Subscription.MachineName,
dbo.SystemUserBase.FullName
FROM dbo.Subscription, dbo.SystemUserBase
WHERE dbo.Subscription.SystemUserId = dbo.SystemUserBase.SystemUserId

Tuesday, April 13, 2010

Uploading Attachments using Data Migration Manager

If you want to upload Attachments in bulk into the CRM system, Data Migration Manager comes handy if you know the tricks. Let me summarize the procedure here:

1. List your attachments in a CSV file as shown in the figure below. Let it contain these columns

#Filename, The name of the attachment file.

#Document, Give each attachment a unique name and store it in the file system organized in one of the following ways.

  1. Store attachments in the folder which contains the CSV file where you listed your attachments.
  2. Store them in the sub-folder named Attachments. It must be a sub-folder of the folder where the attachments list CSV file is stored.
  3. Store them in a sub-folder named Documents. It must be a sub-folder of the folder where the attachements list CSV file is stored. (I've used this option as shown below)

#Regarding, Is the name of the record in CRM (Account, Contact etc.) against which this attachment will be stored.

#Title, The title of the Attachment in CRM.

#Here I show the attachment file that is being uploaded. Notice that I've given it a unique name and mentioned the same in the excel file above.

#You are ready to begin the Migration. Here map the CSV file that contains the annotations to the Note entity. If the CSV file contains attachments, check the "Includes Attachments" checkbox as shown below.

#If the CSV file contains notes you can ignore the checkbox. Here is a figure that shows how you can upload Notes.

#Map the columns as usual and if you are uploading attachments map the "Document" Column with the "Document" attribute in CRM.

You are done. The attachments are now accessible on CRM.