Adding a Note\Annotation attachment as an Email Attachment

(0) Share

Report

Posted on by Community Member

I've been trying for several hours to get this to work to no avail.

I have a custom entity with notes enabled. I manually added note to one of my records with a PDF attachment. The purpose of this is that another plugin will use this attachment to include within a custom e-mail when needed. So the only thing I need to do is pull the note with attachment and transfer the attachment to the email attachment.

I can do this numerous ways that work with no errors (the email and attachment get created correctly), however when I download the attachment from the e-mail it says the PDF is damaged.

Here is what I have tried so far, the first and simplest approach is what I think should work:

myActivityMimeAttachment["body"] = myNote.GetAttributeValue<AliasedValue>("note.documentbody").Value;

myActivityMimeAttachment["body"] = (string)myNote.GetAttributeValue<AliasedValue>("note.documentbody").Value;

// Converting back to byte array and to filestring and back to base 64 under different formats
string stringBase64 = (string)myNote.GetAttributeValue<AliasedValue>("note.documentbody").Value;
byte[] byteFile = Convert.FromBase64String(stringBase64);
string fileString = Encoding.Unicode.GetString(byteFile); 
myActivityMimeAttachment["body"] = Convert.ToBase64String(new UnicodeEncoding().GetBytes(fileString)); // Error - damaged

I tried several different encoding types in the above example....nothing works.

Any help is appreciated!

Coty

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Community Member on at

Like (0)

Report
Just a small update:

I tried just reading the PDF from the file system and saving to an email attachment.

Like this:

byte[] bytes = System.IO.File.ReadAllBytes("Notes.pdf"); myActivityMimeAttachment["body"] = Convert.ToBase64String(bytes);

This works fine and the file is not corrupted/damaged, it's only copying the field from a note attachment that damages the file.

thanks,

Coty

Was this reply helpful? Yes No
Kokulan 18,054 on at

Like (0)

Report

Hi

You do not need to convert the document body again, you can set that as is because its already in Base64 string. And you have to set the Mime type for it be recongnised as a PDF file.

Please try the following

myActivityMimeAttachment["body"] = myNote.GetAttributeValue<AliasedValue>("note.documentbody").Value;

myActivityMimeAttachment["mimetype"] = myNote.GetAttributeValue<AliasedValue>("note.mimetype").Value; - Make sure you include both document body and mimetype columns when you query to note to get the attachment.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Kokulan,

Thanks for the response. I have tried setting the mimetype exactly as you have above already (and tried hard coding to application\pdf and it does not work.

I just noticed something that doesn't look correct though. In the e-mail attachment it has a file size of 1500. That does not seem correct. My e-mail has 2 attachments, one is a PDF and one is a small txt file.

That seems too small, Does CRM truncate the base64 string for any reason?

Coty

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
I found the issue - not sure how to fix it yet...

myNote.GetAttributeValue<AliasedValue>("note.documentbody").Value;

Is only returning the first 1500 characters for some reason. I verified in the DB it is ~11,000 characters.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (2)

Report

I found the answer:

community.dynamics.com/.../crm-issue-with-retrieving-large-document-body-using-fetch-xml-solution

I had to remove distinct="true" from my fetch XML query.......

Really that was it. I had everything else correct. My entire day wasted. Thank you CRM.

Was this reply helpful? Yes No
Suggested answer

Pawar Pravin 5,237 on at

Like (0)

Report

Hi Codiax,

Please refer following code, its working for me....

string _subject = nt.Attributes.Contains("subject") ? nt.GetAttributeValue<string>("subject") : "";

string _filename = nt.Attributes.Contains("filename") ? nt.GetAttributeValue<string>("filename") : "";

Entity note = new Entity("annotation");

note["subject"] = _subject;

note["filename"] = _filename;

note["documentbody"] = nt.Attributes["documentbody"];

if (emailguid != Guid.Empty)

{

note["objectid"] = new EntityReference("email", emailguid);

}

Guid attachmentId = service.Create(note);

Entity note1 = service.Retrieve("annotation", attachmentId, new ColumnSet(true));

Entity attachment = new Entity("activitymimeattachment");

attachment["subject"] = _subject;

string fileName = _filename;

attachment["filename"] = _filename;

byte[] fileStream = new byte[] { };

attachment["body"] = Convert.ToBase64String(fileStream);

attachment["mimetype"] = "text / plain";

attachment["attachmentnumber"] = 1;

attachment["objectid"] = new EntityReference("email", emailguid);

attachment["objecttypecode"] = "email";

service.Create(attachment);

Was this reply helpful? Yes No
RaviKashyap 55,410 Moderator on at

Like (0)

Report

Thanks Codiax for posting your finding. This will surely help someone help facing the same issue. :)

Was this reply helpful? Yes No