Attachments Analyzer

Concepts

The attachments table in VSys can become quite large depending on how you use e-mail and personal attachments. To determine what's actually stored in this table, use the attachments analyzer. Its output will detail every stored attachment, its original size and numerous other properties.

Steps in this task

From the Administrator tools panel, click on Attachments analyzer.
Allow VSys to perform its analysis.
At the prompt, enter the name of an Excel file to be created: this file will contain the details of all of the attachments in the VSys database.

Sample

Field name	Description
Code	A description for your own use, will not appear to the volunteer.
Type	`E-mail` or `Attachment`. E-mail is one used by a letter template to be sent with e-mails based on that template; Attachment is a file associated with one or more people.
Description	Description entered when the attachment is used as an e-mail attachment Not applicable to attachments associated with people.
Filename
Size	Original size of of the file.
Date	Date that the attachment was created.
Owner	A list of all people to whom this file is attached. Note that if more than one person has the identical file attached to them, the actual file is only stored once. The attachment is deleted from the database when no one is associated with that attachment anymore.

Linked Graphic