Before running any of these tools, please have a current backup and no other users in the database.
These are special-purpose tools for manipulating specific tables.
Checking Only recent records and entering a date will run the tool on the first two options, Check letters for... and Resample scanned form..., only if created or updated on or after that date.
After running any of these tools, if you're using a NexusDB database and receive a message about many updated records or a large amount of space freed, you should also run the NexusDB table repair tool on the
letters tables to reclaim the disk space that was saved.
Check letters for oversized images and log files
This tool checks all letters in the database (optionally only those after a specific date) for large log files or large images that were not removed and compressed using image reduction. Oversized logs will usually only happen due to problems dealing with e-mail addresses. Any letters with these types of issues will be automatically corrected and logged.
Resample scanned form images to reduce their size
Very large scanned images take up a lot of space in the "
comments" table. This tool goes through all scanned images attached to comments, certifications and background checks, looking for images which are larger than the size you specify. Run it specifying the maximum width and height for scanned images and VSys will go through all images which are too large and resize them.
This is not a fast process and may take a while to run, especially if you're on a slow network connection.
Check for assignments in projects without matching delegations
If a person registered within a project is given assignments, and moved from one delegation to another, their assignments can stay associated with their previous delegation. Should this happen, VSys will still usually report those assignments, but you won't be able to edit them from within that person's Profile editor.
Running this tool scans all assignments within projects:
E-mail addresses with leading or trailing spaces or semicolons
E-mail addresses associated with people may have leading or trailing space characters in them, which can cause problems when they're used with the E-mail Robot. In some other cases, imported e-mail addresses from other programs can have semicolons at the end of the e-mail address, usually entered to make copying and pasting them into Outlook easier. For both of these cases, the E-mail addresses with leading or trailing spaces or semicolons tool will find e-mail addresses like this and automatically correct them, removing any leading spaces plus any trailing semicolons or spaces.