News.mscrm-addons.com BlogHello and welcome to our blog! What can we do for you? Are you looking for further technical information or step-by-step instructions to our products? Or would you like to read the latest news on mscrm-addons? Please feel free to browse our blog for detailed information and to share our posts! https://www.mscrm-addons.com/BlogAttachmentExtractor move email bodyhttps://www.mscrm-addons.com/Blog/PostId/10209/attachmentextractor-move-email-bodyAttachmentExtractor (AE),AE 365Tue, 30 Apr 2019 14:31:48 GMT<p><span style="font-size: 16px; color: #ff0000;"><strong>NOTE! This feature is still considered BETA and is used at own risk! </strong></span></p> <p><strong>Overview</strong> </p> <p>Starting with AE version 2017.26, AE is offering a new feature, allowing you to remove the email body text from within CRM and replace it with a text-only and line break conserving representation of the former email body. The complete email body content is moved to an azure blob storage and streamed into CRM on accessing the email.</p> <p>CRM Timeline and CRM Activity overview will per default only show the shortened text to allow for more information in less space.&nbsp; </p> <p><strong>Why?</strong></p> <p> Emails are often consisting of mostly HTML formatting information. Inlcuding header, footer and maybe an embedded company logo, the content of an EMPTY email can be up to 30 kilobytes in size. In most companies, an email conversation usually consists of several replies and each reply will replicate the full HTML content of the previous emails, adding those 30 kilobytes AGAIN on every answer you write and possibly the same sized formatting information from the recipient of the email. </p> <p>Asuming the above, a conversation, that contains an email being answered 4 times is generating a total overhead of 550kb. Still not much, but it adds up.</p> <p>If you have 100.000 emails in your system and only half of them would be part of a conversation as sketched above, those emails add up to 10.000 conversations at 5 emails, occupying up to 5 Gb of space in the ActivityPointerBase table without containing any information yet. Also the actual email text is being replicated in each answer, growing the size even further. Not to mention that nearly all of the one-direction emails will contain a certain amount of HTML information on their own.</p> <p>Remember, as of Q2 2019, the maximum table size of the WHOLE CRM database (excluding attachments) is 10 GB without additional cost. </p> <p><strong>How?</strong></p> <p> </p> <p>AttachmentExtractor is inspecting each email in CRM and looks for known seperators of emails. If any is found, the email is cut and then all HTML tags except linebreaks are removed from the email body. The original body is stored in an AzureBlobStorage and the plaintext representation of the email body is left in CRM. When you are opening an email, a plugin will retrieve the unchanged emailbody from the AzureBlobStorage and replace the stripped down version with the full content.</p> <p><strong>What is not&nbsp; supported?</strong></p> <p>AttachmentExtractor preserves both, the original modified by and modified on, therefore not all emails might be processed.</p> <ul> <li>The email must habe a valid state/status combination<br /> (e.g. you cannot have a completed (state) draft (status) email, as CRM does not support this combination<br /> NOTE! As email state/status code pairs can be customized, AttachmentExtractor will only process emails, where those are still defined in CRM! </li> <li>All activityparties of the email (from, to, cc, bcc) must be resolved to an existing entity in CRM</li> <li>All activityparties of the email (from, to, cc, bcc) must have the "allow email" property set to allow.</li> <li>Alternative email body storage options are NOT supported (due to accesstime) (Only AzureBlobStorage)</li> </ul> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p>10209