Tuesday, April 20, 2010
FROM dbo.Subscription, dbo.SystemUserBase
WHERE dbo.Subscription.SystemUserId = dbo.SystemUserBase.SystemUserId
Tuesday, April 13, 2010
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.
- Store attachments in the folder which contains the CSV file where you listed your attachments.
- 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.
- 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)
#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.
You are done. The attachments are now accessible on CRM.