41
The attachments against an email message is affecting the DB size and hence we are looking a feasible option to manage attachments? The user would like to view the attachment and its details when accessing the record at any point in time though within CRM or an easily accessible location (like SharePoint). Any suggestions on how best we can manage this in a CRM on-prem instance w/o impacting the DB size?
Thanks Nikhil. However as a user accessing the attachment within the email, how does the design look like? Will I still access the attachment within the email message? Also after utility runs to move the attachment to Azure, do I see the attachment in a different section of the email message?
Sure the way we had developed this utility is that we have a workflow that processes email older than say (1 year) extracts the attachments and moves them to azure. And provides the azure link via the azure archive entity so that the same can be accessed.
Also, we had developed a custom desktop utility which we run one time (for bulk data migration) before we deployed this workflow. This utility is run only once to move the attachments were moved to azure in bulk else the workflow would have to process high number and would eventually timeout.
Workflow then continuously moves the data on a daily basis.
Hope that make sense.
Regards,
Nikhil
PS: Do mark this as answer if it meets your requirement
Yes, Please can you please provide more details on the tool developed? We are looking at various option for document (email attachment) management solution. So far zeroed in on SP and Azure Bob. We have D365 on prem instance and the solution that we finalize on give minimal change from an user experience perspective and system storage impact.
Hi Veena,
We had developed a solution wherein the attachments from Emails and Notes would go into Azure Storage Blob and the links for the same are stored on the entity so that the user can access them anytime.
Do reach out to me if you need details.
Yes Veena, with the help little bit of scripting, we can fetch and display attachment in Dynamic CRM.
Here is complete detail for reference.
Fetching Azure Blob File Attachments and listing in Dynamic 365 CRM
https://vjcity.blogspot.com/2019/11/fetching-azure-blob-file-attachments.html
Please mark answer correct, if it help you resolve your problem.
Hi Vipin, If using Azure Blob can the user still see the attachment within CRM? From a user experience how will it be?
Thanks, will it work for on-premise instance?
Hi Veena,
SharePoint is a good option, but I have also another solution -
https://vjcity.blogspot.com/2019/11/moving-attachments-of-dynamic-365-crm.html
Please let me know your thoughts on this.
Thanks.
Vipin
Refer and follow Blog : https://vjcity.blogspot.com/
Get Latest updates of Dynamic CRM from Group : https://www.facebook.com/groups/554941725236365/
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (