VSys One: Volunteer Management Software

Attachments Analyzer

The attachments table in VSys can become quite large depending on how you use e-mail attachments 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

Click on Attachments analyzer from the Administrator tools panel.
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.

Example output

Linked Graphic

Field name	Description
Code	Internal ID code of the attachment.
Type	`E-mail` or `Attachment`. E-mail is used by a letter template to be sent with e-mails based on that template. An 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 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 only when no one is associated with that attachment anymore.