CRM File attachments

Question

CRM saves attachements in AnnotationBase base table.

How can I convert the text in the DocumentBody entity back to file and save it the file system.

I’m comfortable with plugins and workflow activities. But can't figure how to convert a string in the database to a file on the system.

Answer 1

using(FileStream fs = new FileStream("fileName", FileMode.Create, 
                                            FileAccess.Write))
{
    StreamWriter writer = new StreamWriter(fs);
    writer.Write(yourString);
    fs.Flush();
}

[EDIT] If we're talking about BASE64 strings then try this:

using (FileStream fs = new FileStream("fileName", FileMode.Create,
                                            FileAccess.Write))
 {
     byte[] bytes = Convert.FromBase64String(yourString);
     fs.Write(bytes, 0, bytes.Length);
     fs.Flush();
 }

Answer 2

Grrr.

Look all day, then find the answer 5mins after posting the question.

     File.WriteAllBytes("c:\\word1.docx", System.Convert.FromBase64String(str));

Answer 3

What about the other way. e.g. I've got a Image.jpg and wants to Upload into DocumentBody.