September 2002 Edition
New Feature Spotlight: Quick Jump, Control Button Functionality
Smart Tip of the Month: Archiving
Q&A with MetaSupport: User Access, Delayed Thumbnailing
Support Bookshelf: SQL References
New Feature Spotlight
Quick Jump in Notification Setup
Save time when creating notifications by using the new quick jump feature in Virtual Ticket 4.0. When creating automatic notifications in the Events and Actions window of Virtual Ticket Administrator 4.0, jump to the name of a user by typing the first letter of the person’s name. You may use the same action when generating manual notifications in the Send Notifications dialog window of Virtual Ticket 4.0.
Control Button Functionality
Now it’s even easier to work with Digital Resources in the Macintosh version of Virtual Ticket 4.0 by using new Control button functionality. Press the Control button on your keyboard and click on a digital resource in a Virtual Ticket 4.0 file collector window. A menu will appear, giving a quick list of options. By holding down the Control button, selecting a file and choosing Reveal in Finder from this menu, you can display the file in the Macintosh Finder - making it easy to locate files you need to work with. Pressing the Control button while double-clicking an image in a Virtual Ticket 4.0 file collector will automatically open the file in the native application (ie, QuarkXpress, Adobe Illustrator).
Smart Tip of the Month
Archive Using Move
The Move function in Virtual Ticket 4.0 allows you to move a selected group of files/folders from one location to another. This is especially helpful in situations where InterSync is monitoring the volume where your files reside, and you archive to a location not watched by InterSync. In this situation, moving files manually (through the operating system) would cause InterSync to delete and re-add the files in the database. Using the Move process in Virtual Ticket 4.0 will prevent InterSync from deleting the files from the database. To use the Move functionality:
- Display the files/folders to be moved in a file collector window. Drag and drop the files/folders on a file collector and choose Lookup from the dialog window. This will display the files as they exist in the database.
- Choose Move from File Tool menu.
- Select the new location of the files/folders. Virtual Ticket will then move the files to the new location and update the file path information.
Q&A with MetaSupport
Q: How can I give a user the ability to search all files in Virtual Ticket WebServer without granting him Administrator privileges?
A: Enter an asterisk (*) for the customer code when setting up or editing a user. This will give the user access to all files available in Virtual Ticket WebServer.
Q: How are thumbnails created for files that are added to the system through delayed thumbnailing?
A: There are two ways this happens, depending on your version of Virtual Ticket:
- In Virtual Ticket 4.0 systems with InterSync installed and configured on the server, InterSync will quickly produce delayed thumbnails in the database.
- In Virtual Ticket 3.0 systems, the Thumbnailing Server feature can be used to generate delayed thumbnails. Thumbnailing Server is enabled by logging into Virtual Ticket as the Administrator and selecting Thumbnailing Server from the Tools menu.
Have a question for the MetaCommunications Technical Support Team? Send it to support@metacomm.com.
Support Bookshelf
With the addition of Job Manager Custom Queries and support for SQL Queries in MetaScript 2.0, the following references are good places to look when you need help building SQL queries:
The Practical SQL Handbook by Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky.
This book is a good all-around reference for SQL. It contains many database structure diagrams and examples to help readers design, build, add and retrieve data from SQL databases. If you are using other SQL products in your organization, The Practical SQL Handbook provides syntax examples for Microsoft SQL Server, Sybase SQL, Oracle, and others.
Microsoft SQL Server 2000: Administrator’s Pocket Consultant by William R. Stanek.
This guide is designed with the SQL Server 2000 Administrator in mind. This quick reference guide includes such topics as creating maintenance plans, setting up a Data Transformation Services package, using database replication, and other helpful SQL Server procedures and shortcuts.
The Practical SQL Handbook and Microsoft SQL Server 2000: Administrator’s Pocket Consultant are both available at www.amazon.com or www.barnesandnoble.com.
SQL Books Online by Microsoft.
This reference is located on the Microsoft SQL Server. It provides a complete resource to syntax examples and error message descriptions, plus it contains a searchable help area. The reference can be launched from within all Microsoft SQL Server applications, making it quickly accessible in times of need.
For more information about SQL Books Online visit: www.microsoft.com/sql/techinfo/productdoc/2000/default.asp.
Do you have a topic you would like us to cover? Looking for an answer to a technical problem?
Check out the MetaCommunications Support page or email support@meta-comm.com.
