February 2003 Edition
New Feature Spotlight: Associator Plug-in
Q&A with Technical Support: Slammer SQL Worm
Smart Tip of the Month: Privileges for Digital Resource Deletion
Third Party Software: Spell Checking
Support Bookshelf: Windows 2000, AppleScript References
New Feature Spotlight
Associator Plug-in
The Associator Plug-in, located inside the Management Console of InterSync 2.0, provides users with the ability to automatically associate files added by InterSync with any file collector in Virtual Ticket 5.0. This automatic association of files provides numerous benefits, including:
- Saving time previously needed to drag and drop files on file collectors.
- Providing users with a real-time view of the files in the file system, eliminating the need to manually synchronize files in Virtual Ticket 5.0 with the file system.
- Preparing files for archiving by generating previews, capturing metadata and associating with jobs in Virtual Ticket 5.0.
For example, suppose the naming convention of job folders on a file server contain the job number and job name separated by a dash (12345-Job Name). By creating a rule in the Associator Plug-in folders are watched for this naming convention, any folders matching the rule will be associated with a file collector specified in the rule criteria.
Q&A with Technical Support
How can a Job Manager/Virtual Ticket system using Microsoft SQL Server 2000 be protected from the "Slammer" SQL worm?
Microsoft SQL Server 2000 Service Pack 3 can be applied to protect against issues related to the "Slammer" SQL worm. This service pack has been tested by MetaCommunications and is suitable for use with the Virtual Ticket/Job Manager system. If you experience any problems with your Virtual Ticket/Job Manager system after applying this service pack, contact MetaCommunications Technical Support at support@meta-comm.com.
A step-by-step description of the upgrade process is available at:
http://www.meta-comm.com/support/knowledge_base/article.asp?id=16128
More information about the "Slammer" SQL worm can be found at:
http://www.microsoft.com/security/slammer.asp
Smart Tip of the Month
Privileges for Digital Resource Deletion
Privileges for deleting digital resources from a Virtual Ticket 5.0 database can be implemented by applying a two-step approach.
- Create a special user group in Virtual Ticket Administrator 5.0. Users who are members of this group will have privileges to delete digital resources.
- Apply a SQL trigger to the database. When an attempt is made to delete a digital resource in Virtual Ticket 5.0, the SQL trigger fires and verifies that the user belongs to the special user group. If the user does not belong to the special group, the user will be prompted with a message informing them they do not have enough privileges to delete digital resources.
For detailed instructions on applying this solution, visit:
http://www.meta-comm.com/support/knowledge_base/article.asp?id=16127
Third Party Software
Spell Catcher
The product Spell Catcher, produced by Casady and Greene, provides users with a method of spell checking documents in Virtual Ticket and Job Manager, as well as other applications. Available for Macintosh and Windows operating systems, this spell checker provides several methods for scanning your document for incorrect spellings.
For more information visit:
http://www.casadyg.com
Support Bookshelf
The following reference has been recommended by the MetaCommunications Engineering Department:
Inside Microsoft Windows 2000 Server. David A. Solomon. This guide is a self-described under the hood manual and covers a wide-range of topics from the operating system kernel to memory management and network communications. This book is geared more towards users who want to develop applications or advanced users looking to get more from their Windows 2000 installation.
AppleScript for Dummies. Tom Trinko. While the name suggests a lack of knowledge, this book is recommended because of its simplicity and wealth of useful information. For those who are beginners, this reference is filled with examples which can be referred to when AppleScripting with Virtual Ticket 5.0.
Miss an issue of the MetaCommunications Support News? For back issues, visit:
http://www.meta-comm.com/support/support_news.htm
Have a topic you would like covered in the MetaCommunications Support News? Send your topics and questions to:
support@meta-comm.com
THE INFORMATION PROVIDED IN THE METACOMMUNICATIONS SUPPORT NEWS IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. METACOMMUNICATIONS DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL METACOMMUNICATIONS OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF METACOMMUNICATIONS OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCHDAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.