Archive
Archive for December 17, 2017
Move Attachments from CRM to Azure Blob – “Attachment Management” tool
Recently I was exploring options to move attachments from CRM (i.e., Notes and Email) to Azure Blob storage and came across “Attachment Management” tool from Microsoft Labs.
This tool can be installed as a solution to your Dynamics 365 instance. Detailed steps and usage guide are available here.
In this article I am going to detail the imperative Azure and Dynamics 365 settings which would avoid the connectivity issues you may encounter during my usage.
Pre-requisites to use this solution:
- Dynamics 365 instance (You can subscribe for 30 days trail)
- Enable the “Attachment Management” solution from App Source.
- Microsoft Azure Account (You can subscribe for trail)
- Note: You can use the same Dynamics Office 365 account to register for Azure trail account.
Setting up Azure Storage Account:
Make sure your Azure Storage Account settings matches with below
- Azure “Storage Account” ‘KIND’ must be “BlobStorage”.
- “Storage Account” Containers ‘Public Access Level’ must be “Blob”.
- “Shared Access Signature” (SAS token)
- Set the “Start” to Previous Day as the Azure time zone depends the data Center you choose. (For example, your IST date may be 1 day ahead of your ‘Data Center’ date which may make your ‘SAS token’ invalid)
- Set the “End” to at least a week ahead of today.
Settings in Dynamics 365:
- With the “Attachment Management” solution you will get 3 entities and a ‘Site Map Area’ (i.e., Azure Attachment Storage)
- Make sure you configure settings only from ‘Azure Attachment Storage’ site map link and not from ‘Advanced Find’
- In “Azure Blob Storage Setup” page, make sure the ‘Storage Account Name’, ‘Container names’ and ‘SAS token’ matches with Azure settings
- In “NOTES ATTACHMENT SETTING ENTITY” page, pick your entities and provide correct “Container” name or leave that blank.
- Note: If you have Dynamics Portal solution installed, uncheck the ‘Web Files’ entity, if its selected.
Troubleshooting steps:
- After you configure all the settings try adding a Note with attachment to the entity you configured.
- If you don’t see your attachments move to Azure Container, go to ‘System Settings’ and look for “MicrosoftLabs.AttachmentManagement…..” job for exception.
🙂
Categories: Azure, CRM
Tags: Attachment Management, Azure Blob, Container
Stats
- 1,245,135 hits
Translate
Categories
Top Posts
- [Step by Step] Postman tool to test Dynamics 365 online Web API
- Power Apps component framework (PCF) - Beginner guide
- Useful JScript syntax's – ADX/Dynamics 365 Portals
- Sandbox vs Production Instances – Dynamics 365
- Associate/Disassociate plugin messages in CRM
- [Step by Step] Restore a Database from Azure Blob to Azure SQL Server
- Auto generate new GUID for ‘uniqueidentifier’ column in SQL Table
- C# - Bulk Update Records - Pass Data Table to SQL Stored Procedure
- Get and Set ‘Partylist’ fields using Jscript
- [Step by Step] Connecting to Azure SQL Server using OLEDB Connection from SSIS