Exporting all attachments RRS feed

  • Question

  • Hello

    I have found a tool that exports all file attachments from Dynamics CRM 4.0, the problem is that it simply dumps all the files in to one folder with the original file name, so I have no way of identifying which files belong to which customer account records.

    My plan is to prefix each filename in the AnnotationBase table with a field from the AccountExtensionBase table. This will allow me to identify each file once it has been exported.

    My problem is that when I join the AnnotationBase table to the AccountExtensionBase table, not all AnnotationBase records have a related record in the AccountExtensionBase table. I believe this is because files are not only linked to companies, but could also be opportunities, contacts, activities, other 'objects' etc. 

    In the front-end application however, I can see that all these files are linked to the original company record, so there must be some link in there somewhere leading back to the company, I just can't find it in the SQL DB.

    Does anyone have any ideas please?

    Tuesday, February 25, 2014 10:22 AM