V I N O : F I L E Cellar Master A Wine Cellar Management System for IBM and compatible computers By Mark Christian Version 3 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- The VINO:FILE Cellar Master manual is Copyright 1990, 1992 by Mark Christian. All rights reserved. This document may not, in whole or part, be copied, photocopied, reproduced, translated, or reduced to any electronic medium or machine readable form without the prior written consent of the copyright holder. First Printing July, 1992 Credits: VINO:FILE Cellar Master is written in Turbo Pascal and Assembly Language using Turbo Pascal Professional and TurboPower's Object Professional. This manual was prepared using Microsoft Word for Windows. Special thanks to all of the members of the ``Bacchus Wine Forum'' on CompuServe for guidance and support. Extra special thanks for the hard work performed by all of the beta testers. Trademarks: VINO:FILE and VINO:FILE Cellar Master are trademarks of Mark Christian. Turbo Pascal is a trademark of Borland International. Object Professional is a trademark of TurboPower Software. Microsoft, Windows, Word For Windows and MS-DOS are trademarks or registered trademarks of Microsoft Corporation. IBM is a registered trademark of International Business Machines Corporation. DESQview and Quarterdeck Extended Memory Manager are trademarks of Quarterdeck Office Systems. Ultravision and Laptop Ultravision are trademarks of Personics Corporation. ASP and the ASP logo are registered trademarks of the Association of Shareware Professionals. CompuServe is a trademark of CompuServe Incorporated. Other trademarks appearing in this manual are trademarks of their respective holders. --------------------------------------------------------------- Preface Page i VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- LIMIT OF LIABILITY ALL USERS OF VINO:FILE CELLAR MASTER MUST AGREE TO BE BOUND BY THIS DISCLAIMER OF WARRANTY: VINO:FILE CELLAR MASTER IS DISTRIBUTED AS-IS. THE AUTHOR DISCLAIMS ALL WARRANTIES, EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO, THE WARRANTIES OF MERCHANTABILITY AND OF FITNESS FOR ANY PURPOSE. THE AUTHOR WILL ASSUME NO LIABILITY FOR DAMAGES EITHER FROM THE DIRECT USE OF THIS PRODUCT OR AS A CONSEQUENCE OF THE USE OF VINO:FILE CELLAR MASTER. OUR SIMPLE LICENCE CONDITIONS Purchase of VINO:FILE Cellar Master will license one copy for use on one computer at any time. You must treat a copy of VINO:FILE like a book - it may be used by more than one person and moved from one computer to another as long as there is no possibility of it being used at one location while it's being used at another (just like a book cannot be read by more than one person at a time). A NOTE ABOUT THIS MANUAL This manual is included on the VINO:FILE disks. The content is exactly the same as the printed version that comes with registered versions of the program. However, the screen illustrations are removed and other minor formatting details changed due to the requirements of producing a plain text version from source material designed to be typeset. VINO:FILE Cellar Master Copyright Mark Christian 1990, 1992 All rights reserved. --------------------------------------------------------------- Preface Page ii VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- ENQUIRIES, REGISTRATIONS & SUPPORT For Technical Support and General Enquiries, please contact the author in one of the following ways (in approximate order of preference): . On CompuServe, via the `Bacchus Wine Forum' - GO WINEFO - or CompuServe Mail to ID [70032,117]. (Please send registrations by mail to the address below.) . By Mail to: Mark Christian, 7 Campbell Grove, East Hawthorn, 3123, Australia. or: Mark Christian, 210 Columbus Ave, Suite 220, San Francisco, CA, 94133, USA. . FAX: +61-3-882-0640 (Australia). If you have suggestions, complaints, or ideas for future enhancements please feel free to contact us. We welcome any feedback from users and will do our best to incorporate all ideas in future versions of VINO:FILE Cellar Master. Only you, the users, can make VINO:FILE the most complete and functional cellar management software available from any source! With your help we will continue to make VINO:FILE the only wine cellar software that fully meets the needs of all of its users. If there is any defect in the VINO:FILE diskettes or documentation - or if any files appear to be missing or incomplete - please contact the author. You will find a list of files later in this manual and also in the file VINOREAD.ME. --------------------------------------------------------------- Preface Page iii VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- ASP OMBUDSMAN This program is produced by a member of the Association of Shareware Professionals (ASP). ASP wants to make sure that the shareware principle works for you. If you are unable to resolve a shareware-related problem with an ASP member by contacting the member directly, ASP may be able to help. The ASP Ombudsman can help you resolve a dispute or problem with an ASP member, but does not provide technical support for members' products. Please write to the ASP Ombudsman at 545 Grover Rd., Muskegon, MI 49442-9427 or send a message via CompuServe Mail to ASP Ombudsman 70007,3536. The Ombudsman may be contacted by FAX by sending to the ASP FAX number: (616) 788-2765. In communication with the Ombudsman please include a telephone number and/or FAX if available. --------------------------------------------------------------- Preface Page iv VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- TABLE OF CONTENTS SECTION I. INTRODUCTION 1 1.1. WHY VINO:FILE ? 1 1.2. SYSTEM REQUIREMENTS 2 1.3. WHAT'S NEW IN VERSION 3 2 SECTION II. GETTING STARTED 5 2.1. INSTALLING VINO:FILE 5 2.2. THE VINO:FILE FILES 5 2.3. STARTING VINO:FILE WITH THE SAMPLE DATABASE 5 2.4. SETTING YOUR CONFIGURATION 6 2.5. A GUIDED TOUR OF THE MAIN FEATURES 7 2.5.1. SEARCHING FOR WINES 7 2.5.2. USING WINE LISTS 10 2.5.3. DISPLAYING BOTTLE LISTS 12 2.5.4. CHANGING A BOTTLE RECORD 13 2.5.5. DRINKING A BOTTLE OF WINE 14 2.5.6. UN-DRINKING BOTTLE RECORDS 15 2.5.7. ADDING WINES TO THE DATABASE 15 2.5.8. CHANGING A WINE RECORD 19 2.5.9. SAVING & CHANGING DATABASE FILES 19 2.5.10. ADDING, RESTORING AND RE-SORTING 20 2.5.11. SUMMARY SCREENS 21 2.5.12. CHANGE CONFIGURATION 22 2.5.13. PRINTING REPORTS 25 2.5.14. THE CROSS REFERENCE FILE 26 2.5.15. QUITTING VINO:FILE 28 SECTION III. GENERAL INFORMATION 29 3.1. COMMAND LINE PARAMETERS 29 3.2. SYSTEM PLATFORMS 30 3.2.1. MICROSOFT WINDOWS 30 3.2.2. DESQVIEW 31 3.2.3. OS/2 31 3.2.4. ULTRAVISION 32 3.3. MERGING SAMPLE CROSS REFERENCE FILES 32 3.4. SCREEN LAYOUT AND DATA ENTRY 33 3.4.1. USING THE MOUSE 33 3.4.2. STATUS LINE 34 3.4.3. DATA ENTRY PANELS 34 3.4.4. FIELD EDITING COMMANDS 35 3.4.5. MEMO FIELDS 37 3.4.6. SPECIAL FIELDS 39 3.4.7. THE MENU BAR 41 3.4.8. HELP PANELS 41 3.4.9. SCROLLABLE LISTS 42 --------------------------------------------------------------- Table Of Contents Page v VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- SECTION IV. USER REFERENCE 44 4.1. VINO:FILE MENU FUNCTIONS 44 4.1.1. OPEN NEW DATABASE 44 4.1.2. IMPORTING & EXPORTING TEXT FILES 44 4.1.2.1. IMPORT A FILE 45 4.1.2.2. EXPORT A FILE 46 4.1.2.3. TEXT FILE FORMATS 46 4.1.2.4. GENERAL IMPORT FIELD RULES 47 4.1.2.5. IMPORT WINE RECORD FORMAT 48 4.1.2.6. USING CROSS REFERENCE IN IMPORT 50 4.1.2.7. IMPORT BOTTLE RECORD FORMAT 51 4.1.3. SHELL TO DOS 52 4.1.4. ADD TASTING NOTES 52 4.1.5. RESTORE DELETED WINES 53 4.1.6. BROWSE DELETED BOTTLE PANEL 53 4.1.7. SHOW CELLAR STATISTICS 54 4.1.8. MEMORY USAGE SUMMARY 55 4.1.9. OPEN A NEW CROSS REFERENCE 57 4.1.10. PRINT A CROSS REFERENCE REPORT 58 4.1.11. THE VARIETY CROSS REFERENCE LIST 58 4.2. THE VINO:FILE DATABASE STRUCTURE 59 4.2.1. RECORD STRUCTURES 59 4.2.2. DATABASE CAPACITY 60 INDEX 63 --------------------------------------------------------------- Table Of Contents Page vi VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- SECTION I. INTRODUCTION 1.1. WHY VINO:FILE ? Do you need to keep track of the bottles of wine in your cellar and have instant access to your tasting notes? Want to be able to analyze the geographical spread of your collection, maintain a list of wines to drink or taste soon, and identify future purchasing needs? Would you like to locate a particular bottle of wine by bin or box number - without hunting through the cellar, packing and unpacking valuable bottles? The VINO:FILE Cellar Master program is the answer for every wine lover with access to an IBM PC or compatible. VINO:FILE was written by a wine collector with a moderate sized cellar of 60 dozen bottles - so you know that this program, and future enhancements, will be geared towards the needs of fellow wine lovers, not the pre-conceived ideas of a large software publisher. VINO:FILE's database system is tailored especially for wine cellar record keeping. It gives you instant access to information about the bottles of wine in your cellar, and allows you to file tasting notes for future reference once you have consumed the wines. Want to know how many 1985 Cabernet Sauvignons are in your cellar? VINO:FILE will tell you. Trying to remember whether you thought the 1974 Chateau Palmer was better than the 1975? Just look up your notes - with a single query! Wine records are kept in your computer's memory while VINO:FILE is running for fast and flexible execution and then stored in a single disk file between sessions. You can search wine records using many fields including the Producer, Variety, Year, Geographical Origin, Peak Drinking Period, Category, Rating and Cellar Location. While you work, VINO:FILE uses a Cross Reference file to keep track of the geographic origins of the wines you file in the database. This saves you from having to enter that information more than once. The information in the Cross Reference file is used so that you need a minimum of typing to enter new entries to your database. Sample Cross Reference files for the major wineries in America, Australia and Europe are provided. Easy to use menus and lists drive all of VINO:FILE's functions with full error messages and help panels. The windowing interface is easy to use for novices and experienced PC users alike. Full mouse support is included. Mastering your wine records is just a few keystrokes away! --------------------------------------------------------------- Section I. Introduction Page 1 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- For a quick guide to VINO:FILE and a guided tour of its major features see the next section `Getting Started' - you'll see how easy to use and powerful VINO:FILE is. When you begin using the more advanced features, you'll find the `General Information' and `User Reference' sections have all the details that you need to get the most from VINO:FILE Cellar Master. 1.2. SYSTEM REQUIREMENTS To run VINO:FILE Cellar Master you will need: . an IBM (or compatible) PC with DOS . 640 Kb of RAM memory (445,000 bytes free) . a high density 3.5" or 5.25" floppy disk drive* * You can install VINO:FILE from low density (DS-DD) diskettes but the VINO:FILE files are too large to run from this type of diskette. You can run the program from a high density (DS-HD) 5.25" or 3.5" diskette or from a hard disk. For optimum use of VINO:FILE it is desirable to have: . a hard disk drive 1.3. WHAT'S NEW IN VERSION 3 VINO:FILE Cellar Master Version 3 is a major update. Users of Version 2 will be especially interested in these major new features: . Full Mouse support is now included. All data fields, menu items and status line options are Hot Spots where you can click with your mouse to perform the appropriate actions. . VINO:FILE now uses virtual memory paging to allow Wine Databases and Cross Reference files to be far bigger than before. If enough RAM is not available then VINO:FILE can use EMS (Expanded) memory, XMS (Extended) memory or Disk space to store the data. . Two User fields and three Rating fields have been added to the Wine Record. The names of these fields can be specified by the user. The size of several other fields has been increased. --------------------------------------------------------------- Section I. Introduction Page 2 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . The Help system is much improved and uses a Hypertext system to allow navigation and browsing of all help options. . Automatic support for screen sizes larger than 80x25, such as provided by Ultravision, is now included. . You can now sort the Wine List on any combination of fields for better analysis of your cellar and customization of printed reports. . The Cellar Statistics function allows detailed analysis of your cellar contents using any of the wine fields for displaying or printing in graphic and tabular form. . A new option `Add Tasting Notes' on the Add Menu allows quicker entry of tasting notes where the wine tasted was not already in your cellar. . Alphanumeric data values can now be presented in Upper, Lower or Mixed cases for greater readability. . Turbo Fields allow you to paste in winery names, varieties, districts, states or countries with a minimum of typing when entering or changing data. . Improvements to the Wine List include: . scrolling horizontally to make other fields visible; . a Repeat function to aid in entering new wines similar to one already there; . a Zap function to temporarily hide a wine so that it is not displayed in the list; . a Re-List function to re-search the wine list. . On the Bottle List you can now use the F3 and F4 keys to skip to the bottle list of the next or previous wine in the wine list. --------------------------------------------------------------- Section I. Introduction Page 3 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . Several improvements have been made to the Wine Search panel: . You can enter *99 and #99 in Year Ready and Drink By search fields to find wines that are ready or not ready in a particular year instead of in the current year. . You can enter `+' or `-' in all search fields to search on `any value' and `blank' respectively. . Instead of just a default bottle search value you can now save ALL of the fields on the Wine Search panel between sessions. Select the `Save Search Record' option on Change Configuration. --------------------------------------------------------------- Section I. Introduction Page 4 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- SECTION II. GETTING STARTED 2.1. INSTALLING VINO:FILE VINO:FILE comes with an automated installation program called INSTALL. To install the VINO:FILE program files from a floppy disk (assuming the floppy is in drive `A'): . place the diskette in your floppy disk drive . run the install procedure by typing `A:INSTALL' You will be able to choose where to put the program files on your system. If you have a hard disk drive we highly recommend that you install VINO:FILE there. 2.2. THE VINO:FILE FILES The INSTALL program places the following files on your system: AUSSIE.XRF Sample Cross Reference - Australia EUROPE.XRF Sample Cross Reference - Europe SAMPLE.DBA Sample Wine Database USA.XRF Sample Cross Reference - USA VF.EXE VINO:FILE Program File VF.HLP VINO:FILE Help File VF.ICO Windows 3.0 Icon VF.OVR VINO:FILE Overlay File VF.PIF Windows 3.0 PIF File VINOREAD.ME Documentation Updates WINE.XRF Sample Cross Reference File For information on VINO:FILE that could not be included in this manual please print or display the file `VINOREAD.ME'. 2.3. STARTING VINO:FILE WITH THE SAMPLE DATABASE VINO:FILE comes with a sample wine database and cross reference file so that you can get a feel for the program as soon as you have installed it. The sample wine database (SAMPLE.DBA) contains a variety of wine records and shows how to enter the wines of various countries into VINO:FILE with typical contents for the various data fields. --------------------------------------------------------------- Section II. Getting Started Page 5 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- The sample cross reference (WINE.XRF) is a starter set of cross reference entries for some of the world's most common wine producing areas. The cross reference file helps you avoid typing in the geographic locations for every different wine that you enter into the database. To start VINO:FILE and load up the samples change to the directory on your hard disk where you installed VINO:FILE and type: VF SAMPLE If you want to start your own database you can load VINO:FILE by just typing `VF'. 2.4. SETTING YOUR CONFIGURATION VINO:FILE Cellar Master uses a configuration file (WINEPARM.CFG) to keep configuration settings from session to session. One of these settings is the color set used by the program. If the default colors are difficult to read on your computer's screen you should use the command line options `/L' or `/M' to select an alternative video mode and then change your configuration settings to ensure that this setting is active every time you start VINO:FILE. If you start VINO:FILE by typing `VF /L' on the command line, an alternative color set is used which should be more readable on some laptops or other computer displays which map colors to shades of gray. To use a monochrome color set, start VINO:FILE by typing `VF /M' on the command line. Try both of these to determine which is best for your computer. Now bring up the `Summary' menu by pressing Alt-S (or press F10, use the right arrow to move the cursor to `Summary' and then press Enter). Choose `Change Configuration' by pressing the down arrow until that choice is highlighted and then pressing Enter. This will display the configuration panel. The `Video Mode' is the option that controls the color set used. Set this field to be `L' or `M' whichever you have decided is best for you. A `C' in this field denotes the default color set. Then press Ctrl-Enter (hold down the Ctrl key while pressing Enter) to accept the changes. When you change the `Video Mode' on this panel you must quit VINO:FILE by pressing Alt-Q or Esc, and then restart the program before the change will take effect. The other settings on this panel are described in the Change Configuration section beginning on page 22. --------------------------------------------------------------- Section II. Getting Started Page 6 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 2.5. A GUIDED TOUR OF THE MAIN FEATURES To introduce new users to VINO:FILE Cellar Master, this section provides a step by step guide to the major functions of the program. Users who are upgrading from previous versions or who are already familiar with the main features of VINO:FILE may skip this section. To follow this `guided tour' you should load the SAMPLE database that is distributed with VINO:FILE. Start up the program with the following line command: VF SAMPLE After the database is loaded you will see the `Wine Search' panel. All the panels in VINO:FILE have the same basic structure. Across the top of the screen is the `Menu Bar' which you can use to access various utility functions. Across the bottom of the screen is the `Status Line' which shows the main key functions for each screen and also displays error messages. You can get help from any panel by pressing `F1'. To exit from a panel without saving any changes you press Esc (the escape key). To exit and accept all field entries or changes press Ctrl-Enter (hold down the Ctrl key while pressing Enter). If you have a mouse you will see the mouse cursor - a white diamond on a red background - which you can move around the screens. Use the left button to select fields, actions and menu items. Clicking on the right button of the mouse is equivalent to pressing Esc and will exit from the current panel without saving any changes. Note: VINO:FILE supports screens larger than the standard 80x25 screen size. If you have a screen size utility such as Ultravision the screens you see are slightly different to the illustrations in this manual. 2.5.1. SEARCHING FOR WINES The Wine Search Panel is displayed when you start up VINO:FILE. Check now that you have loaded the sample database - on the left side of the title box you should see `- Database -' and underneath that the name of the wine database `SAMPLE'. On the right hand side you should see `- XRef -' and `WINE' which is the name of the sample cross reference. --------------------------------------------------------------- Section II. Getting Started Page 7 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- On this panel you enter search arguments to determine which of the records in the database will be listed. By pressing Enter without any search criteria you can display a list of all wines in the database. This will include all wines that have ever been in the cellar. Press Enter now. To return to the Wine Search panel, press Esc. All the search criteria on this panel are AND-ed together to restrict the list of wines to be displayed. In this way you can construct very quickly a simple, or complicated, search for a particular wine or group of wines. Type the name `PINE RIDGE' in the `PRODUCER' field. Press Enter to perform the search after entering the name - you should now see a list of wines from the Pine Ridge winery only. Press Esc again. Some of the fields on the Wine Search panel are `Turbo Fields'. You might have noticed when typing `PINE RIDGE' before that some winery names were displayed at the bottom right part of the screen. When you start typing a Producer name, VINO:FILE will search the Cross Reference to see if it recognizes what you are typing. So, when you press the `P' key, the first producer in the Cross Reference that begins with `P' will appear - Pecota. When you press `I', that changes to `Pichon Lalande', and when you press the `N' key it finds `Pine Ridge'. Now press Enter to paste in that name - only 3 keystrokes instead of 10! You can also use wild card searches - type `P*' in the Producer field. Now when you press enter you will see a list of all the wineries that begin with the letter `P'. Press Esc again. Instead of wild cards that will match anything - including blank values - you can search for `any value' by entering `+' in any of the fields. To search for `no value' you can enter `-' in any field. Remove the producer name by pressing the space bar - any character typed in the first position of a field will erase the entire field. If you want to change one or more characters in the field without erasing it you must first use the right arrow to move the cursor away from the first position. --------------------------------------------------------------- Section II. Getting Started Page 8 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- Use TAB and the down arrow to move over to the District field. Type `NAPA VALLEY' (this is another Turbo Field). Use Shift-TAB to move back to the Variety field. Type `Cabernet Sauvignon' (and this is another Turbo Field - you could have used only 2 keystrokes for both of these selections!). Now when you press enter you will see a list of all the Cabernet Sauvignon wines from the Napa Valley. Press Esc again. Press F3 to clear all of the fields on the Wine Search panel. Another shortcut - `Two-Digit Years' is available in the Year fields (including Year Ready and Drink By). You can type `1985' in the Year field to find all the wines from that vintage - but why waste your time typing `19' every time? Try just typing `85' - VINO:FILE will fill in the rest for you! If you type `00' in the Drink By field VINO:FILE is clever enough to know that you want the year 2000 rather than the year 1900! Use the Down Arrow key to move down to the Bottles field. Change the value from `0' to `1'. Now when you press Enter, the list of wines will only contain wines of which there are at least one bottle currently in the cellar. To display the wines of which there is exactly one bottle in the cellar enter `=' in the `Bottles Search Type' field. You will also see Search Type fields for the Year field and the Ratings fields. To toggle through the possible values for any of the Search Type fields use the space bar or the `+' and `-' keys. Finally, you can use the `Year Ready' and `Drink By' search fields to identify those wines in your cellar that are in their optimal drinking period. First clear all fields by pressing F3 and then enter `89' in the Year Ready field. Press Enter to display a list of all wines that became ready to drink in 1989. Clear the Year Ready field and enter `95' in the Drink By field. Press Enter to display a list of the wines to drink before 1995. There are two special searches in the Year Ready and Drink By fields - `*' which means `ready' and `#' which means `not ready'. In the Year Ready field, `*' will display all wines that are ready to drink in the current year or earlier - that is, all wines now ready to drink. The `#' character will list wines that are not yet ready to drink. --------------------------------------------------------------- Section II. Getting Started Page 9 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- In the Drink By field, `*' will display all wines to drink in the current year or later. The `#' character will list wines that have passed their Drink By date - that is, wines that may be `over the hill'. To list all wines that are currently in their optimum drinking period enter `*' in both the Year Ready and Drink By search fields and press Enter. This will display all wines that have passed their Year Ready date and have NOT passed their Drink By date - perfect wines for current drinking! If you want to find wines that will be ready next year, or any other year, you can add a year to these special values. Try entering `*96' in both Year Ready and Drink By for a list of wines that will be at their best in 1996. For information about other fields, and VINO:FILE's field editing commands, press `F1' to display the Help Screens for this panel. When you have finished experimenting with the various searches, clear all the fields, set `Bottles' to 0, and press Enter to search. The next section uses the resulting list of wines to explain the options available on the wine list. 2.5.2. USING WINE LISTS The wine list is a scrollable list of wines from the database. The following fields are displayed for each wine: . Producer The name of the winery or shipper of the wine; . Other Info Any other distinguishing information. The vineyard name, a bin number, a `Reserve' wine etc; . Variety The grape variety (blank if the wine is not a varietal, such as many European wines); . Year The vintage year, which may be blank (or `NV') for non-vintage wines; . Number The number of bottles of this wine in your cellar. A `0' shows that you have consumed all of these wines. --------------------------------------------------------------- Section II. Getting Started Page 10 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- The highlight bar and arrow indicator on the left hand side of the list show the current wine record - starting at the first wine in the list. You can move the indicator up and down the list using the Up and Down Arrow keys or by clicking on the arrow symbols at the top or bottom of the scroll bar if you have a mouse installed. Use the PgUp and PgDn keys to scroll the list one page at a time, or you can click on the PGUP or PGDN symbols on the bottom right part of the screen. The Home key moves the indicator to the top of the list, and the End key to the last wine in the list. With your mouse you can click on the main part of the scroll bar at the right side of the list. This will select the corresponding record - that is, clicking three-quarters of the way down the scroll bar will scroll to the wine three-quarters of the way through the list. Pressing Enter will select the current entry. You can also scroll the Wine List horizontally to show other fields in each wine record. Press the Right Arrow (or F4) to scroll to the right, the Left Arrow (or F3) to scroll left or click on the symbols at the bottom left part of the screen. Note that the Producer and Number fields always remain on screen while the other fields between them change. The other Wine Record fields that can be displayed by scrolling are: Year Ready, Drink By, Flag, Category, Ratings, User 1 and User 2. The actions that you can perform on each wine are listed on the status line at the bottom of the screen. Pressing the letter indicated or clicking on that part of the status line performs the action on the current wine: . A Add more bottles of this wine; . C Change one or more of the data fields for this wine; . D Delete the wine record (and all of its bottles); . F Find - searches for a particular producer and scrolls to that position. The search name is displayed at the bottom left corner of the screen - press Enter when you have found the one that you want; . R Repeat - add a new wine to the database starting with all fields the same as the current wine; --------------------------------------------------------------- Section II. Getting Started Page 11 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . S Select this wine and display the list of bottles (Enter also performs this action); . Z Zap - remove this wine from the displayed list. This only affects the display - the wine is not deleted from the database. You can reset this by pressing F2 to re-apply all the current search criteria. Try out each of these. Press F1 for Help if you are in doubt at any time. Now we'll look at a bottle list - position the arrow indicator to the wine `BEAULIEU VINEYARDS, RUTHERFORD, CABERNET SAUVIGNON, 1985' and press the `S' or Enter key to select the bottle list for that wine. 2.5.3. DISPLAYING BOTTLE LISTS The bottle list is a scrollable list that looks similar to the wine list. This screen, however, shows all the bottle records for one particular wine. The main information about the wine is in the top area of the screen - the wine you are looking at now should be `BEAULIEU VINEYARDS, RUTHERFORD, CABERNET SAUVIGNON, 1985'. In the bottle list part of the screen the following fields appear for each record. Note that each record represents one or more identical bottles. . Number (#) The number of bottles that this record represents; . Size The size (in ml) of each bottle; . Bought The date when these bottles were purchased; . Cost The purchase price of each bottle; . Origin Where the bottles were bought; . Location The Cellar Location where these bottles can be found; . Drank The date when these bottles were consumed (if applicable); . Points Your point rating for wines that have been consumed. --------------------------------------------------------------- Section II. Getting Started Page 12 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- The key fields for a bottle record are Date Consumed, Purchase Date, Size and Location - and each record must have a unique key. Therefore any bottles with the same values for these four fields will be combined into a single record. VINO:FILE will look after splitting and combining records automatically throughout the life of the bottles of wine. The highlight bar and arrow indicator show the current bottle record. You can scroll the bottle list in the same way as the wine list above. As a short cut, the F4 key (or right arrow) will skip to the next wine in the wine list and the F3 key (or left arrow) to the previous wine. The actions that you can perform on each bottle record are listed on the status line at the bottom of the screen. Pressing the letter indicated or clicking on that part of the status line performs the action: . S or C Change data fields for one or more of these bottles; . D Drink one or more of these bottles of wine; . L Delete this bottle record; . U Un-Drink bottles that are incorrectly marked as consumed. Pressing the `F2' key or clicking on the part of the screen where the Comments data is displayed lets you browse the full Wine Comments field. Try out each of these options. Some further notes are provided on the following pages. Press F1 for Help if you are in doubt at any time. 2.5.4. CHANGING A BOTTLE RECORD There are a few tricks when changing the fields of a bottle record: . If the bottles in this record have been consumed then the Date Consumed, Occasion, Tasting Notes and Points fields are displayed and can be changed. If the bottles are still in the cellar then these fields are not displayed. --------------------------------------------------------------- Section II. Getting Started Page 13 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . Each record can represent more than one bottle of wine. So the first question you must answer is do you want to `Change All Bottles?'. The default is `Y' - change the fields for all bottles that this record represents - changing the `Number' field will change the number of bottles represented by the record. . If you set `Change All Bottles' to `N' then you are splitting this record into two records. Set the `Number To Change' field to the number of bottles that will take the changed values, and the remaining bottles will keep the old values. When you do this the new bottles must have a new unique key - therefore you MUST change either the Date Consumed, Date Purchased, Size or Location fields. You would use this type of change to move some of the bottles to a new location, for example. . The VALUE field defaults to the same as the COST field when you add bottles to the database. If you feel that your wines are appreciating (or depreciating?) you can change their values on this panel. . VINO:FILE calculates the Total Cost and Total Value fields automatically whenever you change the Cost, Value or Number fields. 2.5.5. DRINKING A BOTTLE OF WINE Updating the VINO:FILE record after you drink a bottle of wine is easy: . On the Bottle List, select a bottle still in the cellar and press the `D' key. Check that the existing fields are correct - that you are drinking the correct bottle - and, if not, press Esc to cancel; . Enter the number of bottles that you drank at this sitting - if you had two or more of these bottles and the tasting notes are substantially the same, then you need only enter them once; . Enter the drink date, occasion (restaurant name, food served, guests' names etc), tasting notes and rating (on any scale - with a maximum value of 100.0); . All fields other than the Number to Drink and Date Consumed are optional. --------------------------------------------------------------- Section II. Getting Started Page 14 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 2.5.6. UN-DRINKING BOTTLE RECORDS If you mistakenly mark a bottle as consumed and later discover that it is still in the cellar, the Un-Drink Bottle function will quickly repair the damage. . On the Bottle List, select a bottle which has been consumed and press the `U' key; . Check the warning screen to make sure the correct bottle was selected; . The drink date, occasion, tasting notes and points rating will all be cleared; . Enter the number of bottles to `Un-Drink', their Location and Value per bottle. All fields other than the Number to Un-Drink are optional. 2.5.7. ADDING WINES TO THE DATABASE To add new wines to the database, you need to use the Menu Bar. The Menu Bar is the line across the top of the screen that looks like: Files Add Summary Print XRef Quit You can access the Menu Bar from the `Wine Search', `Wine List' and `Bottle List' screens. Access it by pressing the F10 key and then using the right and left arrow keys to move to the appropriate option on the menu. As a shortcut you can press the Alt key and the first letter of the option that you want. To Add Wines you can press Alt-A. Do that now. We want the first choice on the Add Menu - `Add Wines' - so make sure that option is highlighted and press Enter to select it. The first four fields you enter to add a wine to the database are the four key fields for a wine record. These four fields uniquely identify every wine and you may need to take care entering the `Other Info' field to ensure that the wines remain unique. This field will normally contain a bin number or `reserve' notation (for New World wine), a vineyard name or appellation (for European wines). Let's add a `Robert Mondavi, Private Reserve, Cabernet Sauvignon, 1985': PRODUCER ==> ROBERT MONDAVI OTHER INFO ==> PRIVATE RESERVE VARIETY ==> CABERNET SAUVIGNON YEAR ==> 1985 Don't forget that you can use the Turbo Fields and the Two- Digit Year features to minimize your typing when filling in these details. --------------------------------------------------------------- Section II. Getting Started Page 15 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- You need to enter the `Private Reserve' in the `Other Info' field to distinguish this wine from the normal non-reserve Mondavi Cabernet which is a totally different wine. If, after you enter these fields, VINO:FILE finds that this wine is already in the database it will allow you to go straight to the `Add Bottles' screen - or let you change one of the key fields so that the new wine is unique. When you press Enter after typing the `Other Info' you will notice that the District, State and Country fields are filled in automatically for you - this is the VINO:FILE Cross Reference file at work. We know that you've got better things to do than type in `NAPA VALLEY, CALIFORNIA, USA' every time you enter a wine from that district into the database. So, we've included a sample cross reference file that knows the location of many of California's best known wineries and several others from around the world. If VINO:FILE's Cross Reference does not know which District the winery is in, chances are it does know that District once you type it - so it will then enter the State and the Country for you. What's more, whenever you enter a winery, a district, a state or even a country that is not already in the Cross Reference file - VINO:FILE will add it to your Cross Reference for future use. VINO:FILE has other sample Cross Reference files that include almost all the wines in California and Australia and many of the better known wines of France, Italy and the rest of Europe - see the `Merging Sample Cross Reference Files' section beginning on page 32 for details of how to use these extra files. When you enter the Variety the Category is also filled in for you from the Cross Reference file. Once the geographical information is complete, there are nine further fields. These fields are completely optional, and the following might be applicable for the Mondavi Reserve that we used as our example above: User 1 ==> User 2 ==> Year Ready ==> 1990 Drink By ==> 1999 Flag ==> Rating 1 ==> 0.0 Rating 2 ==> 0.0 Rating 3 ==> 0.0 Comments ==> Exciting. More evolved than the 1984 but promises more eventual subtlety. Already approachable, but its fascination should increase. (JR) --------------------------------------------------------------- Section II. Getting Started Page 16 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- Use these fields as follows: . CATEGORY Two free-form characters that allow searching on different styles of wine. We suggest the following abbreviations although you can modify these and add your own abbreviations for other styles: DR Dry Red DW Dry White SW Sweet White MC Methode Champenoise (Champagne) FO Fortified wines (Ports and Sherries). . USER 1, USER 2 As their names suggest, you can use the User 1 and User 2 fields for anything you like. If there's information you would like to keep that VINO:FILE does not provide a field for you can use these. You can even change the field names to match the contents - see Change Configuration for details. . YEAR READY, DRINK BY The approximate years between which you aim to drink the bottles of this wine. The values above are from Jancis Robinson's `Vintage Timecharts' for the 1985 Mondavi Reserve Cabernet Sauvignon. . FLAG You can use this single character any way you like to give you an extra search field. You might want to use `Q' or `*' to denote wines that are in your drinking / tasting queue, or `$' to indicate a good value wine. . RATING 1, RATING 2, RATING 3 The Rating fields can be your own, or from industry guides such as Robert Parker, The Wine Spectator, or Decanter. Like the User fields you can change the field names for all of these to match their contents. . COMMENTS A text memo field. Enter as many lines of comments on this wine as you like. You could use this field to enter a winemaker's comments, a Parker review, or any other information that might help you keep an accurate record of this wine. Again, the above comments are courtesy of Jancis Robinson. --------------------------------------------------------------- Section II. Getting Started Page 17 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- Of course, you can come back and change any of these values later using the `Change Wine' screen so if you don't have the information at hand just leave those fields blank or accept the default values. Once you've entered the wine record details you need to enter the details of the bottles you have bought. Press Ctrl_Enter on the Add Wine screen to display the `Add Bottles' screen. Now enter the following fields: . NUMBER OF BOTTLES The number of bottles of this wine that you purchased; . DATE OF PURCHASE The date you bought them (defaults to current date). You can blank out the field if you do not know when you acquired these bottles; . COST PER BOTTLE The price you paid - per bottle (the total cost will be calculated for you); . SIZE OF BOTTLE The size in ml (millilitres) per bottle - usually 750 ml; . ORIGIN Free-form characters indicating where you purchased these bottles of wine; . LOCATION The cellar location (bin number, box number, room number etc) where these wines are kept. Again, you can come back and change any of these values later using the `Change Bottle' screen so if you don't have the information at hand just leave those fields blank or accept the default values. After you enter these fields, the `Add Wine' screen will be displayed again for adding more wines. For all subsequent wines you can recall the field values for the last wine added by pressing F2 - this will make it quicker and easier to add several wines that have some values the same. You can use the F2 recall key in both the `Add Wine' or `Add Bottles' screen. --------------------------------------------------------------- Section II. Getting Started Page 18 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 2.5.8. CHANGING A WINE RECORD To change a wine record, highlight it on the Wine List and press `C'. You can edit all fields on this panel. The usage of each of the fields is described above in the `Adding Wines to the Database' section. 2.5.9. SAVING & CHANGING DATABASE FILES You can keep more than one wine database on your hard disk. At the moment you have the database `SAMPLE.DBA' loaded. So that you can make changes without permanently altering the sample database you should now save the database under a new name. Return to the `Wine Search' panel and bring up the Files Menu by pressing Alt-F, or F10 and then Enter. Move to the third choice `Save Database As ...' using the down arrow and then press Enter or press the `A' key. You can now enter a new name. Type in any name - up to 8 characters in the normal DOS way. The extension .DBA will be added by VINO:FILE and the database saved to disk. VINO:FILE will check to see that your database name is valid and that it doesn't already exist. To save the database without changing the name you can use the second option on the Files Menu - `Save Database'. If you like, you can reload the sample database. Choose the first item on the Files Menu - `Open New Database'. Leave the `Load Option' as `NEW' and type `SAMPLE' for the new name. Alternately you can leave the new name blank and choose a database from the directory list. There are two ways you can load a database. Mostly you will load it as `NEW' - this will clear the database currently in memory and load the new one in its place. Sometimes you might want to `MERGE' two databases together, where you add the wines and bottles from the new database to the one already in memory - discarding duplicates. The other options on the Files menu are detailed in the User Reference section. Briefly: . Clear Database Erase the database in memory and start afresh. --------------------------------------------------------------- Section II. Getting Started Page 19 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . Import File Read a text file and create a database from it. The text file format must be exact - see the `Importing and Exporting Text Files' section on page 44 for details. . Export File Write the database to a text file - the format is the same as for Import files. . Shell to DOS Temporarily exit VINO:FILE so that you can run a program from the DOS prompt. 2.5.10. ADDING, RESTORING AND RE-SORTING We've already used the Add Menu to add new wines to the database. There are several other options on this menu. `Add Tasting Notes' provides a quick way of entering tasting notes for bottles of wine that did not come from your cellar. You can enter the wine details and bottle details - including tasting notes in one step. Details are in the User's Reference section, beginning on page 52. `Restore Deleted Wines' ensures that you can recover deleted wine or bottle records if you have erased them by mistake. Details are in the User's Reference section, beginning on page 53. `Sort Wine List' allows you to resort the wine list on any combination of wine record fields. Normally the wine list is in key sequence - Producer is the primary key with Other Info, Variety and Year as secondary keys. You can change the sort order by specifying up to 12 sort fields. To sort the wine list geographically, for example, use the space bar or `+' and ` -' keys to change the sort fields as shown below. Now press Ctrl_Enter to resort the wine list. If you list the wines you will see all the Australian wines at the top followed by France, Germany, Italy and the USA. Within each country the wines are sorted by State and those in the same state are sorted by District. To return to the normal sort order select `Sort Wine List' again, press the F2 key to reset to the default sort fields and then Ctrl_Enter. To reset any single sort field press F3 when the cursor is on it to change it to ` - None - `. --------------------------------------------------------------- Section II. Getting Started Page 20 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- Sorting the wine list is very helpful when preparing printed reports as the wines are printed in the same order as the wine list is sorted. 2.5.11. SUMMARY SCREENS To display information about the current database bring up the Summary Menu by pressing Alt-S. The Database Summary shows statistical information: . The number of wine and bottle records (and actual bottles); . The number of memo fields and text records (each text record is a line of text in the Comments, Occasion and Taste memo fields); . The total cost of all wines in the database (you're allowed to close your eyes and not look at this one!); . The number of wines and bottles that are currently in the cellar (that is, not yet consumed) and the cost and total value of those wines; . The Date of Valuation. If you re-value your cellar on a regular basis (for insurance purposes, for example) you can record and change the Valuation Date by pressing F2 on this screen. The `List Summary' shows similar information but is restricted to the CURRENTLY SELECTED LIST of wines only - determined by the criteria that you last entered on the Wine Search screen. `Show Cellar Statistics' allows you to display and print a wide range of statistical reports about your cellar. Details are in the User Reference section beginning on page 54. `Memory Usage' shows how VINO:FILE is storing the Database and Cross Reference information while the program is running. This information is mostly for debugging purposes but you will notice that the program makes use of Expanded (EMS) and / or Extended (XMS) memory if you have those types available in your system. `About VINO:FILE' displays information about the program, the version number, copyright information, where to get support. --------------------------------------------------------------- Section II. Getting Started Page 21 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 2.5.12. CHANGE CONFIGURATION VINO:FILE stores its start-up options in a configuration file (WINEPARM.CFG). You can change these options by selecting `Change Configuration' on the `Summary Menu'. Depending on your computer system, you may like to change some of these options now: . Auto Currency Format If set to `Y', which is the default, the information DOS has about your country will be used to format all currency values throughout the program. If you are living outside North America you will need to have a `COUNTRY=xxx' command in your CONFIG.SYS file - details are in your DOS manual. . Currency Symbol This field is displayed ONLY if Auto Currency Format is `N'. Defaults to `$'. If you are in another country you can change this to the appropriate symbol for your currency. Up to three characters are allowed. . Decimal Places This field is displayed ONLY if Auto Currency Format is `N'. Defaults to `2' which means that all currency values will have 2 decimal places - for example, 5.99. If this is not appropriate for your country you can choose any number from 0 to 4. . Date Format The display of date fields defaults to the format that DOS uses in directory displays (mm-dd- yy in North America). To choose a different format toggle through the possible values using the `+' and `-' keys. . Max String Length The size of the memo field edit buffer. Defaults to 1750 characters, you can increase it if you need more room for editing - to a maximum of 32767 characters. . Initial Database The name of the database to be loaded when VINO:FILE starts. --------------------------------------------------------------- Section II. Getting Started Page 22 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . Initial XRef File The name of the Cross Reference file to be loaded when VINO:FILE starts. . Video Mode The color set to use. If you have a color monitor you should leave this set to `C'. If your monitor does not display color then you can set the video mode to `L' - an alternative color set that displays better on some laptop gray-scale screens - or `M' for monochrome displays. . Use Mouse ? If you have a mouse but, for some reason, do not want VINO:FILE to use it set this to `N'. . Disable Brightness VINO:FILE uses special video functions to display bright background colors. Most systems will handle this without any problems and this option should be left as `N'. If you get strange blinking you should disable the feature by setting this to `Y'. . Screen Size VINO:FILE will adjust to systems that can display more than the usual 80 columns and 25 lines. On EGA or VGA systems there is a special 43/50 line mode and utilities such as Ultravision allow even more choices. You can force VINO:FILE to run in `25 Line' or `43/50 Line' modes. When set to `Default' VINO:FILE will run in the same screen mode that was active when it started. . Pop Menus ? Determines whether to pop menus all the way back to where you were or step back one level at a time when a menu function is complete. . String Fields VINO:FILE can format all string fields to Upper, Lower or Mixed case. If you prefer, set this to `Anything' to display fields exactly as you enter them. For mixed case format rules see page 40. --------------------------------------------------------------- Section II. Getting Started Page 23 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . User FieldName 1, User FieldName 2 You can change the prompts that will be displayed on all VINO:FILE panels for the two User fields in the Wine Record to match the use that you have chosen for each field. . Rating FieldName 1, Rating FieldName 2, Rating FieldName 3 You can change the prompts that will be displayed for the three Rating fields in the Wine Record to match the use that you have chosen for each field. . Save Search Record If set to `Y', all the search criteria on the Wine Search screen are saved between VINO:FILE sessions. . Temporary Files Directory a directory on your hard disk where VINO:FILE can put temporary files. It can be the same as the directory where you have installed VINO:FILE or any other directory. If you have a RAM disk you could use that. . Initial Data Directory a directory on your hard disk - or floppy diskette - where VINO:FILE can find and store your databases and Cross Reference files. . Default Print Header The heading text that you want on your printed reports. Most field changes will take effect immediately except: . Initial Database, Initial XRef and Initial Data Directory are only relevant at program start up; . Video Mode, Screen Size and Use Mouse. You must quit VINO:FILE and restart to ensure full use of the new options. --------------------------------------------------------------- Section II. Getting Started Page 24 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 2.5.13. PRINTING REPORTS If you have a printer you can produce printed reports by selecting the `Print Menu'. The first thing to do is ensure that your printer is set up correctly. Choose the third option - `Printer Setup'. You can use five printer types for formatting: EPSON printers, the Hewlett Packard LaserJet (HPLJ) series, the HPLJ+ printer (use this if your LaserJet does not have a 12 point font), the IBM Proprinter line and generic ASCII printers. Many others can emulate one of these printers - so even if you don't have those particular brands you may still be able to get formatted printouts. If not, choose `NONE'. You can still print reports but won't get any bold face or different point sizes. Choose `NONE' if you want to output standard ASCII disk files for your reports. VINO:FILE also needs to know your printer port . VINO:FILE can print to a parallel port (LPT1 - 4) or to a disk file but not to a serial (COM) port. If your printer is attached serially you can still print but will have to use the DOS MODE command to re-direct the output from serial to parallel - see your DOS manual for details on the MODE command. If you select `FILE', VINO:FILE will prompt you for a file name for each report that you print. Once you have set your printer you can print either the entire database or just the wines that are currently displayed on the `Wine List' screen. The printout options are the same. Print Wine Details can be: . NO Print only the name of the wine (Producer, Other Info, Variety, Year), the number of bottles and their locations. . YES Print all wine record fields. Print Bottles can be: . NO No bottle details are printed at all. . YES Print the bottle record fields (Date Bought, Date Consumed, Origin, Cost etc) but not the Occasion and Tasting Notes. --------------------------------------------------------------- Section II. Getting Started Page 25 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . FULL Print all fields, including the Occasion and Tasting Notes. Heading Text: . A heading for each page of the report. You can cancel a report that has started printing by pressing Ctrl_C - that is, hold down the Ctrl key while pressing the C key. You can then confirm that you want to cancel the report. If you answer `Y' the report will be cancelled immediately. Press any other key to resume the printout. Note that some printers (and software print spoolers) will buffer data before printing it, so the printer may not stop printing immediately. Reports are printed in the same order as the wine list - if you want to have the wines printed out in a different order just re-sort the list by choosing `Sort Wine List' on the Add Menu. You can also print out Cellar Statistics and Cross Reference reports. Details are on pages 54 and 58 respectively. 2.5.14. THE CROSS REFERENCE FILE VINO:FILE uses a Cross Reference file to record the geographic location of all the wineries / vineyards or shippers that you have ever entered into your database. That way, if you enter that winery name again you will not have to re-enter the District, State or Country. This information is also used for the Turbo Field facilities. The Cross Reference also keeps track of Varieties that you have entered and the Category that is usually associated with that variety. You can display and modify the Cross Reference file using the `XRef Menu' options. They are: . List XRef List all Cross Reference records. This produces a scrollable list where you can change, delete or add entries; . Open New XRef Load a different Cross Reference; . Save XRef Save the Cross Reference file to disk; . Print XRef Print Cross Reference Reports; --------------------------------------------------------------- Section II. Getting Started Page 26 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . Variety List List all Variety records. This produces a scrollable list of varieties and you can choose to change, delete or add entries. Choose `List XRef' now and you will see the XRef List sorted by the `Producer' field. This shows the District for each Producer / Other Info combination. To see and/or change the State and Country for an entry, position the indicator using the Up and Down Arrows and press `S', `C' or Enter. You can also press `A' to add a new Cross Reference entry, `D' to delete an entry or `F' to find a particular entry in the list. Each Producer Cross Reference file entry contains: . Producer the winery, producer or shipper; . Other Info a specific notation, or vineyard name. Many wineries have vineyards in different districts and you can have an entry for each. If a winery produces all its wine in one district you should set this field to `*' which will match any value; . District the District where the grapes originated. This can be left blank for wines which obtain their fruit from multiple areas; . State the State where that District is located. This can be left blank for wines which obtain their fruit from multiple states; . Country the Country of origin. Cannot be left blank. You can also display the Cross Reference List sorted by District. Press F2 to toggle the sort order from `By Producer' to `By District'. To change a district entry, press `C' after positioning the record pointer. This will change the details for all companies that are in this district. You can use the `By District' display to ensure that your Cross Reference file is as accurate as possible. If you have entered `Sonoma' for some companies and `Sonoma County' for others, you can set all the entries to one value by changing the misspelled or incorrect entry here. --------------------------------------------------------------- Section II. Getting Started Page 27 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- To see the list of companies for a particular District, position the indicator using the Up and Down Arrow keys and press `S' or Enter. Press F2 again to resort the list by Country and State. The sub-list of companies is also scrollable and you can change the entry for a particular winery by positioning the indicator and pressing `S' or `C'. Return to the District list by pressing `Esc'. When you have finished trying out the Cross Reference panels, press `Esc' until you return to the Wine Search Menu - the VINO:FILE entry screen. 2.5.15. QUITTING VINO:FILE When you have finished this Guided Tour of VINO:FILE's main functions you can return to DOS in the same way you will end all of your VINO:FILE sessions. From the `Wine Search', `Wine List' or `Bottle List' screens press Alt-Q, and then Enter to confirm. On the Wine Search panel only you can also press the `Esc' key to Quit. If you have made changes to the wine database or the cross reference file then you will be asked whether you want to save them before quitting - if you are just playing around then you will want to enter `N' to these questions - but normally you should save your changes when you exit. If you want to resume your VINO:FILE session without quitting or saving the files, you can press `Esc'. We hope that you have found VINO:FILE Cellar Master easy to use and that it provides all of the functions that you need to manage your own cellar or tasting notes. For more information on a particular function see the `General Information' and `User Reference' sections of this manual and remember - if you need help while using VINO:FILE you can press `F1' from just about any panel. --------------------------------------------------------------- Section II. Getting Started Page 28 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- SECTION III. GENERAL INFORMATION 3.1. COMMAND LINE PARAMETERS To start VINO:FILE from the command line enter the following: VF [drive:] [directory\] [filename] [ {/C /L /M} {/0 /2 /4 /5} /E /X /B ] What all this means is that after the name of the program (VF) you may OPTIONALLY enter the name of the wine database to load and then one or more configuration parameters. If you do not enter a database name then VINO:FILE will load the database that you have entered on the `Change Configuration' panel. If you have not yet set up or changed your configuration then a database called WINE will be loaded if it exists. You do not need to enter the extension which is always `.DBA' for wine database files. If VINO:FILE cannot find the database you have specified (on the command line or the configuration file) it will ask you whether you want to create a new database with that name or abandon the load. If you press `ESC' you'll be returned to DOS. The command line configuration parameters are as follows: . /C /L or /M Video Mode (Choose one only) You will not need to specify a video mode unless the default colors (/C) are unreadable on your computer. /L installs an alternative color set that should be more readable on some gray-scale monitors such as laptops. If that is still not readable then enter /M for Mono. . /0 /2 /4 or /5 Screen Size (Choose one only) VINO:FILE will automatically support screen sizes larger than the normal 80 columns by 25 rows. To force VINO:FILE to run in 80x25 mode enter /2. EGA and VGA monitors have a 43 or 50 line mode - the parameters /4 or /5 will force VINO:FILE to use that mode. If you want VINO:FILE to use the mode the video is already in specify /0 (the default). . /E Specifies that VINO:FILE should NOT use Expanded (EMS) Memory even if it is installed on your system. --------------------------------------------------------------- Section III. General Information Page 29 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . /X Specifies that VINO:FILE should NOT use Extended (XMS) Memory even if installed. . /B Disable Brightness. VINO:FILE uses video functions that could result in extraneous blinking on some systems. Use this parameter to turn off these functions. All of these parameters can be permanently set using the `Change Configuration' option on the `Summary Menu' - see `Change Configuration' on page 22 for details. 3.2. SYSTEM PLATFORMS VINO:FILE Cellar Master is written for the DOS operating system. It has been tested on versions of MS-DOS and PC- DOS from 2.2 through 5. Support for any future versions of the DOS operating system should not be a problem - but cannot be guaranteed, of course. There are several DOS-based user interface platforms that have become common in recent times - such as Microsoft Windows and DESQview from Quarterdeck Office Systems. Support for these platforms is built into VINO:FILE. Compatibility with Ultravision and the OS/2 DOS box is also included. 3.2.1. MICROSOFT WINDOWS Although it is not a `Windows Program', VINO:FILE will run as a Full Screen DOS program under Windows. In 386 Enhanced Mode you can run it either Full Screen or in a Window. For your convenience the VINO:FILE package includes the file VF.PIF (a Windows Program Information File) and VF.ICO (a Windows Icon). Copy both of these files to your Windows Directory. When adding VINO:FILE to the Program Manager you should enter VF.PIF where prompted for the `Command Line'. Then choose the `Change Icon' button and enter VF.ICO as the `File Name'. You can use the Windows PIF Editor to change the directory name if you have not installed VINO:FILE in the default directory C:\VINOFILE. --------------------------------------------------------------- Section III. General Information Page 30 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 3.2.2. DESQVIEW DESQview is another multi-tasking platform that allows you to run multiple DOS programs at the same time. VINO:FILE is `DESQview aware' and needs little customization to work with this program. There is one limitation - VINO:FILE requires a minimum of 445,000 bytes of RAM memory to run and DESQview cannot always provide that much memory. This should not be a problem on 80386 or i486 systems where DESQview runs in conjunction with Quarterdeck's QEMM memory manager. However, on 80286 processors or less it may not be possible to obtain enough free memory in a DESQview window to run VINO:FILE. You can run VINO:FILE in a small window but you will find that it is better to have the program start in full screen mode. You will need to use DESQview's `Add Program' function and set the following values on the first screen: Memory Size (in K) 445 Program VF.EXE Parameters Directory your directory Writes text directly to screen N Displays Graphics Information N Virtualize text/graphics (Y,N,T) N (`Y' on some 80286 systems) Uses Serial Ports (Y,N,1,2) N Requires floppy diskette N On the Advanced Options screen, set the `Maximum Program Memory Size (in K)' to 640. You should also set `Uses its own colors' to `Y'. All other values can use the defaults. 3.2.3. OS/2 OS/2 is an operating system that allows DOS programs to run in a compatibility box (up to Version 1.3) and in multiple windows (Version 2.0). VINO:FILE has been tested under IBM OS/2 Versions 1.3 and 2.0 and no problems have been detected. However, we cannot guarantee support for this operating environment. The performance of DOS under the OS/2 operating system in Version 1.3 can occasionally be unpredictable, and Version 2.0 is still in beta test at the time of writing. --------------------------------------------------------------- Section III. General Information Page 31 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 3.2.4. ULTRAVISION Ultravision and Laptop Ultravision by Personics Corporation are highly recommended products that extend the capability of some EGA and VGA video monitors. (Note: not all monitors are supported, refer to the Ultravision documentation for details.) These products allow you to display more than the usual 25 rows by 80 columns of information on your screen and to replace the default screen font and colors with others of your choice. Ultravision high resolution modes are generally more readable and easy on the eyes than the standard DOS screens. VINO:FILE will automatically detect any of the Ultravision modes and re-format its panels to take advantage of these high resolution screens. Make sure that you have VINO:FILE's Screen Size option set to Default on the Change Configuration panel. 3.3. MERGING SAMPLE CROSS REFERENCE FILES The VINO:FILE diskette contains four sample Cross Reference files. The file WINE.XRF, which you used in the Guided Tour, contains a small sample of wineries from around the world. The other three files include many more wineries from Australia (AUSSIE.XRF ), Europe (EUROPE.XRF) and North America (USA.XRF) . To save you even more typing when making entries you can merge one or more of the other samples into the WINE.XRF file. Each of these files is quite large. To save loading time when you start VINO:FILE you should only merge the files for areas where you often purchase wine. To merge the USA.XRF sample into your WINE.XRF file: . Start VINO:FILE and make sure the WINE.XRF is loaded as the XRef file; . Choose `Open New XRef' on the XRef Menu; . Change `Load Option' to MERGE using the space bar; . Type USA as the new filename and press Ctrl_Enter; . Save WINE.XRF by selecting `Save XRef' on the XRef Menu. Your XRef will now contain entries for most of the major wineries in the United States. If you also often purchase wines from Europe and/or Australia then you should repeat the process with the other sample Cross Reference files. --------------------------------------------------------------- Section III. General Information Page 32 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 3.4. SCREEN LAYOUT AND DATA ENTRY The screens in VINO:FILE Cellar Master are designed so that, as far as possible, you use the same keys for the same function throughout the program. There are several types of panel used in VINO:FILE. The following are common to all of the panels: . F1 will display a context-sensitive Help Panel. All non-trivial panels in VINO:FILE have help panels available; . Esc cancels any input and returns to the previous panel; . Ctrl_Enter accepts all input and displays the next panel. The panels do not always fill up the whole screen. Some panels are pop-up windows that overlay another panel on the screen. The key functions described here are the same for both types. 3.4.1. USING THE MOUSE VINO:FILE allows you to do everything with the mouse that you can do from the keyboard - except for entering your data. If you have a mouse and wish to use it with VINO:FILE all you have to do is make sure you have loaded the mouse driver before you start the program. The mouse cursor displays as a white diamond on a red square and will move around the screen as you move your mouse. If the mouse is not working check the `Use Mouse' parameter on the `Change Configuration' screen. If setting this to `Y' still does not fix your problem then you probably need to load the DOS mouse driver by adding the line DEVICE=C:\MOUSE.SYS to your CONFIG.SYS file. You will find complete instructions in the documentation supplied with your mouse. To perform the common actions noted above with your mouse: . HELP for help, click on the section of the Status Line where you see `F1:Help'; --------------------------------------------------------------- Section III. General Information Page 33 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . CANCEL to cancel any input on the current panel and return to the previous panel press the right button on your mouse; . ACCEPT to accept all input on the current panel and display the next panel, click on the Status Line where you see `Ctrl_ENTER : Accept'. 3.4.2. STATUS LINE On the bottom line of the screen is the `Status Line'. The status line displays error messages and also gives brief instructions for the panel currently displayed. Where there is a list of action keys or function keys you can click on that part of the status line to perform that action at any time. Clicking on informational messages will have no effect. 3.4.3. DATA ENTRY PANELS Most of the screens in VINO:FILE ask you to enter data about wines, bottles of wine or Cross Reference Information. These data entry panels consist of a number of fields in which you can enter the relevant data values. Each field is indicated by `==>` on the screen. The name of the field is on the left of the `==>` and you enter the value of the field to the right of it. You will see a blinking cursor in the current field. When you have finished entering values, press Ctrl_Enter (press the Ctrl and Enter keys together) to accept the data. The following sections describe the editing commands that you can use in the data fields. Use the following keys to move from field to field: . Enter accepts any data typed by the user and moves the cursor to the next field; . Tab moves the cursor to the next field; . Shift_Tab moves the cursor to the previous field; . Down_Arrow moves the cursor to the field directly below the current field; . Up_Arrow moves the cursor to the field directly above the current field; . PgUp moves to the first field on the panel; --------------------------------------------------------------- Section III. General Information Page 34 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . PgDn moves to the last field on the panel; . Esc cancels all data entered on the panel and returns to the previous panel; . Ctrl_Enter accepts all data entered on the panel and displays the next panel. You can move to any field by clicking on the data part of it with your mouse. Some Data Entry panels have other keys that perform special functions on that panel only. You will find a list of these functions either on the Status Line or on the window frame. 3.4.4. FIELD EDITING COMMANDS You can enter a value into a data entry field by typing it using the normal keyboard keys. In addition, however, there are many editing commands that you can use to make data entry easier. Note that these editing commands are for normal (single line) fields. The editing commands for memo fields - fields that accept multiple lines of input in a pop-up memo window - are given in the following section. Many of these editing commands are shown as `Ctrl_x' which you enter by holding down the Ctrl key while pressing the keyboard key `x' where `x' varies from command to command. Normal Data Entry field editing commands: . Left Arrow moves cursor one character to the left; . Right Arrow moves cursor one character to the right; . Home moves cursor to the first character; . End moves cursor just past the last character; . Ctrl_Left Arrow moves cursor one word to the left; . Ctrl_Right Arrow moves cursor one word to the right; . Ins toggles insert mode on and off; . Del deletes the character to the right of the cursor; . Backspace deletes the character to the left of the cursor; --------------------------------------------------------------- Section III. General Information Page 35 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . Enter accepts entered data and move to the next field; . Ctrl_E erases the entire field; . Ctrl_P restores previous or Ctrl_E(rased) field contents; . Ctrl_S starts editing over; . Ctrl_T deletes word to right of cursor; . Ctrl_Home erases all characters to the left of the cursor; . Ctrl_End, Ctrl_X erases all characters to the right of the cursor. You can also move around in a field by clicking on a particular character position with your mouse. There are several types of data fields. The format rules for each field vary according to its type. A short beep indicates that you pressed an invalid key. . Alphanumeric you can enter any printable character. Note that alphanumeric fields will adjust the case of the contents. You can select Upper Case, Lower Case, Mixed Case or `Anything' using `Change Configuration' on the Summary Menu. . Integer only numbers `0' through `9' are allowed. Some fields have limited values - see the Help screen for that panel for details. . Real (Decimal) numbers `0' through `9' plus the decimal point `.' are allowed. . Choice Fields some fields offer a choice between several values. To toggle forward through the possible values press the space bar or the `+' key. To toggle backwards use the `-' key. . Yes/No Fields a yes or no answer is required - you can only press the `Y' or `N' keys. --------------------------------------------------------------- Section III. General Information Page 36 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . Date Fields only numbers are allowed - the date separator character (`/', `-' or `.') remains constant. When you press Enter the date is checked for validity - months must be between 1 and 12 inclusive and the day appropriate for that month. Note that dates are edited in either mm/dd/yy, dd/mm/yy or yy/mm/dd format - depending on the Date Format option in the configuration file. Use `Change Configuration' on the Summary Menu to change this option. 3.4.5. MEMO FIELDS A VINO:FILE memo field contains multiple lines of text that you edit in a pop-up window. Examples of memo fields are the Wine Comments, Bottle Occasion and Bottle Taste fields. Although the length is effectively unlimited, there is an actual limit to the length of a memo field. This defaults to 1750 characters (around 20 lines) but can be increased up to 32,767 characters (over 400 lines of text) on the `Change Configuration' panel. Initially, only the first few characters of the first line are displayed on the data entry panel. If there is more data, there will be three dots ( ... ) at the end of the line. When you move the cursor to the memo field, you can pop up the edit window by pressing the right arrow key or by starting to type data. You can then type the rest of the memo text. In addition, however, there are many editing commands that you can use to make data entry easier. Note that these editing commands are for memo fields. The editing commands for normal fields were given in the previous section. Many of these editing commands are shown as `Ctrl_x' and are entered by holding down the Ctrl key while pressing the keyboard key `x' where `x' varies from command to command. Memo Data Entry field editing commands: . Left Arrow moves cursor one character to the left; . Right Arrow moves cursor one character to the right; . Up Arrow moves cursor up one line; --------------------------------------------------------------- Section III. General Information Page 37 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . Down Arrow moves cursor down one line; . Home moves cursor to the start of the current line; . End moves cursor just past the last character in the current line; . Ctrl_Left Arrow moves cursor one word to the left; . Ctrl_Right Arrow moves cursor one word to the right; . Ctrl_Home moves cursor to the start of the window; . Ctrl_End moves cursor to the end of the window; . PgUp scrolls up the memo window one page; . PgDn scrolls down the memo window one page; . Ctrl_PgUp scrolls to the top of the memo; . Ctrl_PgDn scrolls to the end of the memo; . Ins toggles insert mode on and off; . Del deletes character to the right of the cursor; . Backspace deletes character to the left of the cursor; . Enter moves to the next line - or inserts a carriage return if in insert mode; . Ctrl_B reformats paragraph; . Ctrl_E erases characters in current line; . Ctrl_K_G reformats the entire memo (hold Ctrl down while pressing `K' and then `G'); . Ctrl_N inserts a line; . Ctrl_O_I toggles auto-indent mode (hold Ctrl down while pressing `O' and then `I'); . Ctrl_P restores previous contents of the line; . Ctrl_S starts editing over - current line; . Ctrl_T deletes a word; . Ctrl_X erases all characters to the end of the line; --------------------------------------------------------------- Section III. General Information Page 38 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . Ctrl_Y deletes the current line; . Ctrl_Enter, Esc ends editing, saving all changes. You can also use the mouse to move and scroll around the editing window. The Esc key does not cancel the changes when used in a memo field. However, if you do want to cancel any changes that you made to the memo field you can press Esc again to cancel all changes on the data entry panel that contained the memo field. For example, on the `Change Wine' panel you begin to edit the Comments field. You realize that you are editing the wrong wine - or have made a major mistake. Press Esc to pop down the window and press Esc again. All changes on the change wine panel - including the changes to the Comments field - will be cancelled and you can start over. Memo Edit windows can be Zoomed, Moved or Re-Sized: . Press F2 to zoom the window - alternating between full size and reduced size. If you have a mouse you can also click on the Arrow symbol on the top right corner of the frame. . Press F3 and then use the arrow keys to move the window around the screen. Or press and hold the mouse button while pointing to the top line of the frame and moving the mouse. . Press F4 and use the arrow keys to re-size the window. You can also press and hold the mouse button while pointing at the symbol at the bottom right corner and moving the mouse. 3.4.6. SPECIAL FIELDS There are two special field types that you can take advantage of in VINO:FILE Cellar Master - Turbo Fields and Year Fields. Also, you can set up string fields to display in Upper Case, Lower Case or Mixed Case. TURBO FIELDS In many cases, VINO:FILE can use the Cross Reference information to make intuitive guesses about the likely contents of fields you are typing. Producers, Districts and Varieties are all examples. --------------------------------------------------------------- Section III. General Information Page 39 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- These are Turbo Fields and you will often see VINO:FILE displaying a possible value on the bottom right part of the frame. This value always starts with the letters you have already typed - if a match cannot be found then nothing is displayed. To accept the value that the Turbo Field is displaying just press Enter and the value will be pasted into the field. If you do not want to paste the value displayed keep typing or put a space at the end of your data - this will disable the Turbo Field. You can also cycle through possible values while a Turbo Field is active by pressing the numeric `+' and ` -' keys. Note: Only the minus key on the numeric keypad cycles a Turbo Field - the hyphen character key does not. YEAR FIELDS There is nothing worse than typing `19' in front of every year in any application - in VINO:FILE you don't have to. Even though year fields are stored and displayed in full 4- digit format you only have to type the last two digits in any year field. This includes the `Year Ready' and `Drink By' fields. If you enter `89' VINO:FILE will interpret that as 1989. If you enter `01' this will be interpreted as 2001 - although if you really did mean 1901 you can type that in full and it will not be re-interpreted. STRING FIELD MIXED CASE RULES VINO:FILE allows you to have string fields displayed in UPPER CASE, lower case, Mixed Case or displayed exactly as entered. You set these options on the Change Configuration panel - see page 23 for details. If you select Mixed Case the following rules apply. A character is capitalized if and only if: . it is the first letter of the first word or is preceded by a blank, period (.), slash (/) or hyphen (-); . or a character is preceded by a quote (') but is not an `S'. The following examples illustrate these rules: Robert Mondavi B.R. Cohn Cabernet/Merlot Gundlach-Bundschu Stag's Leap 'Martha's Vineyard' --------------------------------------------------------------- Section III. General Information Page 40 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 3.4.7. THE MENU BAR VINO:FILE displays the `Menu Bar' on the top line of the screen at all times - though you can only access it from some of the panels. From the `Wine Search', `Wine List' and `Bottle List' panels you can access the `Menu Bar' by pressing F10. On other panels, F10 will do nothing. When you select the Menu Bar with F10, one of the Menu Bar options will be highlighted in reverse video. You can choose one of the options by using the right and left arrow keys and pressing Enter while that option is highlighted. This will display the sub-menu for that option. As a shortcut you can press Alt and the first letter of the Menu Bar option (Alt-F, Alt-A, Alt-S etc) instead of F10 - you can still move to a different pick list using the left and right arrows. If you have a mouse you can access the menu bar and select menu options by clicking on the option you want. Each option on the Menu Bar displays a pick list of sub- options that you select from using the Up and Down Arrow keys. On a list of sub-options you can also press the Highlighted letter of a particular option. The highlighted letter is usually the first one, but not always. For example, to save the current database from the Wine List screen you can press Alt-F and then `S'. For `Save Database As' you would press Alt-F and then `A'. After you have selected an option from a sub-menu and performed that operation you will return to what you were doing on the Wine Search, Wine List or Bottle List screens. This is also the case if you press `Esc' to cancel the operation. If you would like to change this behavior you can use Change Configuration (see page 22 for details) to change the `Pop Menus' option to `N'. Thereafter you will be able to back out of the menu system one step at a time. 3.4.8. HELP PANELS Help is available on all non-trivial VINO:FILE panels by pressing the F1 key or by clicking on the Status Line where you see `F1:Help'. VINO:FILE Help is what is commonly referred to as a `Context-Sensitive, Hypertext System'. The Help Panel displayed will contain information relevant to the current VINO:FILE panel. From there you can navigate through the Help System to find information about any aspect of VINO:FILE using the `Topic Index' or `Topic Hot Spots'. --------------------------------------------------------------- Section III. General Information Page 41 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- You can display the Topic Index by pressing the F1 key on any Help panel. On the index you can select any of the listed topics by moving the highlight bar with the arrow keys and pressing Enter on the topic you would like to view. You can also use your mouse to double click on a topic of interest. Embedded in many of the Help panels are Topic Hot Spots. These areas, highlighted in reverse video, indicate that there is further information available about that topic. You can view that information by moving the cursor into the highlighted area (using arrow or Tab keys) and pressing Enter - or by double clicking on the highlighted area with your mouse. If there is more than one screen of help information then you can use the arrows, PgDn and PgUp keys to scroll through the screens. The Help Panel for the `Wine Search' screen is shown here. When you have finished reading the help information, pressing Esc will return you to the VINO:FILE program. 3.4.9. SCROLLABLE LISTS At the heart of VINO:FILE Cellar Master are the scrollable panels - the Wine List, Bottle List and Cross Reference List screens - so it is worth a quick look at the common functions. In a display window at the top of the panel are the details showing what is being displayed in the list. For example, at the top of the bottle list screen (shown on page 13) are the details of the wine record that these bottles represent. In the lower part of the screen is the scrollable list. Each line in the list represents one entry that you can select by moving the highlight bar and pointer at the left side of the screen. Use the following keys to move the pointer: . Tab, Up Arrow move the pointer up one line; . Shift_Tab, Down Arrow move the pointer down one line; . PgUp scroll up by one page; . PgDn scroll down by one page; . Home scroll to the top of the list; . End scroll to the bottom of the list. --------------------------------------------------------------- Section III. General Information Page 42 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- If you have a mouse installed you can also use the Scroll Bar on the right hand edge of the list. Clicking on the arrows at either end of the scroll bar will move the pointer up or down one line. Clicking at any point in the middle of the scroll bar will scroll to the corresponding entry in the list. That is, clicking half way down will scroll to the middle entry. You can also click on the PgUp and PgDn symbols at the bottom right part of the frame to scroll up or down by a page at a time. With the pointer set to the desired entry, the user can perform many actions on it. The list of action keys is on the status line - you can press the appropriate key or click on that part of the status line. Pressing Enter or double clicking on an entry with your mouse is always the same as `S' for select. --------------------------------------------------------------- Section III. General Information Page 43 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- SECTION IV. USER REFERENCE 4.1. VINO:FILE MENU FUNCTIONS Many of the VINO:FILE functions are covered in the Guided Tour section beginning on page 7. The other functions are explained in more detail here. 4.1.1. OPEN NEW DATABASE To load a new wine database from disk choose `Open New Database' on the Files Menu . When you select this option, it will display a window showing the current database name and asking you to enter two fields: . Load Option Enter `NEW' (the default) to erase the database currently in memory and then load the new database. If you have made changes to the current database since it was last saved to disk then you will have the option to save it before loading the new database. Enter `MERGE' to keep the current database in memory and add all wines from the new database. In this case, any EXACT duplicates (wines or bottles with the same key fields) will be skipped. . New Name The name of the database to be loaded. You can type in the name (without the .DBA extension). If you press ENTER without typing anything then a directory window will be displayed. Select a database from the list using the up and down arrow keys and press ENTER. Selecting the entry ``..'' and others with at the right hand side of the directory list allows you to move around the directory hierarchy to choose a database file. 4.1.2. IMPORTING & EXPORTING TEXT FILES You can import databases from, or export to, a plain ASCII text file. If you want to swap data between VINO:FILE and a word processor, spread-sheet program or another database system you may find this useful. --------------------------------------------------------------- Section IV. User Reference Page 44 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 4.1.2.1. IMPORT A FILE To import a new wine database from a text file on disk choose `Import File' on the Files Menu. The structure of text files that you can import is covered below. This format is very important. VINO:FILE can only interpret text files with a certain structure - so please read this entire section before using the Import function. When you select Import File, a window will display showing the current database and asking you to enter the following fields: . Load Option Enter `NEW' (the default) to erase the database currently in memory and then import the new database or `MERGE' to keep the current database in memory and add all wines from the import file. In this case, any EXACT duplicates (wines or bottles with the same key fields) will be skipped. . Import File Name The name of the text file to be imported. You can type in the name - with an extension. If you press Enter without typing anything in the field then a directory window will be displayed. Select a file name from the list using the up and down arrow keys and press Enter. Directory entries in the list allow you to move around the directory hierarchy to choose a file from another directory. . Field Termination Character / Record Termination Character In the import file, VINO:FILE is expecting to see a number of wine and bottle records with each record consisting of multiple fields. You need to tell the program what characters are going to separate the fields and records. The defaults are Commas to separate fields and (New Lines) to separate records. You can also use Tabs or Semi-colons (;) as separator characters. You must use the same characters importing to VINO:FILE as you did when you created the text file. --------------------------------------------------------------- Section IV. User Reference Page 45 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . Use and Update XRef File When VINO:FILE reads the new wine records from the text file it can use the Cross Reference file to provide geographical information about the wines - if that information is not already in the text file. Similarly, if the information is in the file it can add those wineries to the Cross Reference for future use. Please read the `Using Cross Reference in Import' section carefully for details on the effects of this option. 4.1.2.2. EXPORT A FILE To export the wine database to a text file on disk choose `Export File' on the Files Menu. The structure of the text file created is the same as for import files. When you select this option, a window will display showing the current database and asking you to enter the following fields: . Export File Name The name of the text file to be created. Enter the name (without an extension, .TXT is assumed). If that file already exists you will be asked whether to overwrite it. . Field Termination Character / Record Termination Character VINO:FILE creates a number of records in the text file with each record consisting of multiple fields. You need to specify which characters will separate fields and records. The defaults are Commas to separate fields and (New Lines) to separate records. You can also use Tabs or Semi-colons (;). If you later import this file, you must specify the same characters. 4.1.2.3. TEXT FILE FORMATS When importing text files, the format of the file is very important. If you do not follow this format exactly, VINO:FILE will not understand the file when it tries to import it. --------------------------------------------------------------- Section IV. User Reference Page 46 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- In some situations, VINO:FILE may truncate the database or even hang when trying to import a file, although normally it will display an error message showing you the cause of the error. The import file consists of a number of wine records and bottle records: WINE RECORD 1 BOTTLE RECORD 1 BOTTLE RECORD 2 WINE RECORD 2 BOTTLE RECORD 3 etc Each bottle record `belongs' to the wine record that precedes it. So bottle records 1 and 2 both represent bottles of Wine 1 in the example above. Like the bottle records in VINO:FILE databases, each bottle record can represent a number (1 to 999) of actual bottles. You must separate the records with a particular character - the `Record Termination Character'. We recommend that an ASCII New Line (which is actually 2 characters - carriage return & linefeed) be used to separate records. The valid termination characters are: . ASCII 13 (X`0D') followed by ASCII 10 (X`0A'); . COMMA `,' - ASCII 44 (X`2D'); . SEMI COLON `;' - ASCII 59 (X`3B'); . TAB ASCII 9 (X`09'). Each record, wine or bottle, consists of many fields. Fields must also be separated by one of the above characters - we recommend that you use a Comma. The field terminator MUST be a different character to the Record Termination character. 4.1.2.4. GENERAL IMPORT FIELD RULES Each field may optionally be enclosed in quotes (single or double). You MUST enclose a field in quotes if it contains either of the termination characters - field or record terminators - or quote characters themselves. To place quote characters inside a quoted string you must use double quotes. For example: "Robert Parker says ""Excellent value""." . The following is also valid: "Robert Parker says 'Excellent value'." because the single quote is not being used to enclose the string in this case. --------------------------------------------------------------- Section IV. User Reference Page 47 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- Date fields are controlled by the Date Format that you have set in `Change Configuration'. That determines whether dates are in mm/dd/yy, dd/mm/yy or yy/mm/dd format. Invalid dates will be trapped and an error message displayed. Fields generally have a maximum length. If you provide a longer value, all characters after the maximum will be ignored (truncated). Values less than the indicated length are acceptable. Some fields have default values that apply if you do not supply one. You can omit fields at the END of the record. If a record ends before all field values have been found then those fields are assumed to be empty and the defaults used, if any. Here's an example of a valid import text file using Comma as the Field Terminator, as the Record Terminator and mm/dd/yy dates: W, Acacia, , Pinot Noir, 1985, Napa Valley, California, U.S.A, DR, , , , B, 10/03/87, , 750, 12, 1, 9.00, , 9.00, , , W, Baileys,,Vintage Port, 1976, N.E. Victoria, Victoria, Australia, FO, 1989, 1999, #, "Comments on this wine. Quite Good, typical Rutherglen port. " B, 12/06/86, , 750, 21, 2, 10.00, Cellar Door, 5.00, , , B, 12/05/86,12/12/86,750, ,2,9.00,Cellar Door, ,0.0,, W, Balgownie, , Cabernet Sauvignon, 1980, Central Victoria, Victoria, AUSTRALIA, DR, , , , B, 07/07/84, ,750,37,11,9.80, Mailing List,0.00, , , B, 05/12/84, 06/15/84, 750, , 1, 10.95, 'RH Cellars, West', , 15.0, , 'Full bodied. Will Last' W, Beaulieu Vineyards, Rutherford, Cabernet Sauvignon, 1985, Napa Valley, California, U.S.A, DR, 1990, 1995, , B, 02/23/89, 04/11/89, 750, , 2, 6.75, SAFEWAY, , 17.5, "Dinner Party with Fred and Jane. (Roast Spatchcock).", "Excellent, full-bodied blackberry fruit flavors. Elegant and classy, great drinking now but should improve up to 7 years." 4.1.2.5. IMPORT WINE RECORD FORMAT Wine records contain 18 fields. All fields are alphanumeric unless indicated. Values longer than the indicated length will be truncated. Values less than the indicated length are acceptable. All import fields are directly imported to the fields of the same name in the VINO:FILE wine record. --------------------------------------------------------------- Section IV. User Reference Page 48 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- FIELD NAME LENGTH DESCRIPTION . Record Type Code 1 Constant. Must be `W'. . Company 30 Name of winery or shipper. . Other Info 30 Additional Info about the wine. . Variety 20 Grape variety. . Year 4 Vintage Year. . District 30 Geographical district. . State 20 Geographical state. . Country 20 Geographical Country. . Category 2 Type of wine. . Year Ready 4 Year to start drinking the wine. . Drink By 4 Expected life of the wine. . Flag 1 Any character. Default - blank. . User 1 20 User defined field. . User 2 20 User defined field. . Rating 1 5 Wine rating - format 999.9 (max 100). . Rating 2 5 Wine Rating - format 999.9 (max 100). . Rating 3 5 Wine Rating - format 999.9 (max 100). . Comments Unlimited length comments field. Must be in quotes. --------------------------------------------------------------- Section IV. User Reference Page 49 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 4.1.2.6. USING CROSS REFERENCE IN IMPORT If you select the `Use and Update XRef' option then VINO:FILE will use the Cross Reference file to provide District, State and Country field defaults. In addition, if District, State and Country fields are provided in the text file then they will be added to the XRef file if not already there. The rules are (D=District, S=State, C=country, . = no value): +----------+-----------------------+----------------------+ | Import | Wine is in XRef | Wine is NOT in | | Record | | XRef | | Contains | | | +----------+-----------------------+----------------------+ | D S C | Do nothing. Use | Add Wine to | | . C S | provided values. | XRef using the | | . C . | | provided values. | +----------+-----------------------+----------------------+ | . . . | Use values from | Do nothing. | | | the XRef file. | | +----------+-----------------------+----------------------+ | D . . | If district exists | If the district is | | D . C | in the XRef then use | not known then use | | | the XRef state & | provided values. If | | | country. | the district exists | | | | in the XRef then add | | | | the wine to the XRef | | | | using the XRef state | | | | & country. | +----------+-----------------------+----------------------+ | . . S | If state exists in | If the State exists | | | the XRef then use | in the XRef then add | | | the XRef country. | the wine to the XRef | | | If the state is not | using the XRef | | | known then use | country. | | | provided values. | | +----------+-----------------------+----------------------+ If the Cross Reference file is updated when importing files, bad and incomplete entries (and mis-spellings) can be added to the Cross Reference and the Wine Database records. You should check all records immediately afterwards and correct any errors. --------------------------------------------------------------- Section IV. User Reference Page 50 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 4.1.2.7. IMPORT BOTTLE RECORD FORMAT Bottle records contain 12 fields. All fields are alphanumeric unless indicated. Values longer than the indicated length will be truncated, values less than the indicated length are acceptable. All import fields are directly imported to the fields of the same name in the VINO:FILE bottle record. FIELD NAME LENGTH DESCRIPTION . Record Type Code 1 Constant. Must be `B'. . Purchase Date 8 MM/DD/YY or DD/MM/YY or YY/MM/DD according to the current configuration settings. . Date Consumed 8 MM/DD/YY or DD/MM/YY or YY/MM/DD according to the current configuration settings. Default - no date. . Size 4 Integer. Size of bottle. . Location 8 Cellar location. . Number 3 Integer. Number of bottles. . Cost 6 Real. Default - 0. . Origin 20 Source of bottle. . Value 6 Real. Default - if not consumed, same as cost. . Points 5 Real (999.9). Default - 0, Max 100. . Occasion No limit Occasion when these bottles were consumed. Must be in quotes. . Tasting Notes No limit Tasting notes for these bottles. Must be in quotes. Note - if there is no `Date Consumed' then the bottles will be considered still in the cellar. Therefore the Points, Occasion and Tasting Notes fields will be ignored. --------------------------------------------------------------- Section IV. User Reference Page 51 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 4.1.3. SHELL TO DOS If you want to enter normal DOS commands or run another program without quitting VINO:FILE then you can choose `Shell to DOS' from the Files Menu. VINO:FILE will be temporarily suspended and the DOS prompt is displayed. It is wise to save your Wine Database and XRef files before shelling to DOS. Do not start any TSR's or run any `system' utilities that directly modify the disk drive while shelled - this would include Disk Defragmenters, Directory Sorters, Un-delete utilities and so forth. When you have finished entering DOS commands and want to return to VINO:FILE you must type `EXIT' at the DOS prompt. VINO:FILE uses an advanced technique to swap itself out of memory when shelling to DOS - so you have almost all of the DOS memory at your disposal when shelled. When you `EXIT' back to VINO:FILE the program will be swapped back in. If you have EMS (Expanded) or XMS (Extended) memory available in your computer then VINO:FILE will swap itself into that memory. If you do not have EMS or XMS then VINO:FILE will swap to your hard disk - you will need to have approximately 600Kb of free space on your disk. If VINO:FILE cannot find either EMS, XMS or enough free space on disk then it will not allow you to shell to DOS. 4.1.4. ADD TASTING NOTES Quite often you will taste wines that are not part of your cellar - at a restaurant or a tasting group, perhaps - but you still want to keep the tasting notes as part of your VINO:FILE database. It does not make much sense to enter them to the cellar using `Add Wines' and then have to go straight to the Bottle List and `Drink' the wine. Instead, select `Add Tasting Notes' from the Add Menu. You will first enter the wine details as usual - this panel is the same as when you select `Add Wines'. After you have entered these details the Add Tasting Notes panel will be displayed instead of the normal Add Bottles screen. On this panel you enter the usual bottle records for a wine that has been consumed - the Date Consumed, Occasion, Tasting Notes and Points - at the same time as the purchase information. This single step saves a lot of time. --------------------------------------------------------------- Section IV. User Reference Page 52 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- You can change the Number, Purchase Date, Cost and Origin on the Add Tasting Notes panel but the Location and Value Fields cannot be altered as they are not relevant when the wine is not in the cellar. 4.1.5. RESTORE DELETED WINES If you mistakenly delete wines or bottles from the database you can restore them - in the same VINO:FILE session only - by selecting `Restore Deleted Wines' from the Add Menu. To test this feature, make sure that you have deleted at least one wine or bottle record, press Alt_A and select this option. VINO:FILE will display a list of the deleted wines. This list works like the main Wine List, however the only line commands available are: . S or Enter Display the bottle list; . R Restore this wine and its bottles to the cellar; . F Find a particular wine in the list; When you display the bottle list you will be able to select: . S or Enter Display fields for this bottle (browse only); . R Restore just this bottle record to the cellar. 4.1.6. BROWSE DELETED BOTTLE PANEL The Browse Deleted Bottle panel is available only from the Deleted Bottles List and allows you to view the field values for the selected bottle record (and associated wine record). You cannot change any of the field values on this panel. You can browse the memo fields, if present, by pressing the following keys: . F2 Wine Comments field; . F4 Bottle Occasion field; . F5 Bottle Tasting Notes field; --------------------------------------------------------------- Section IV. User Reference Page 53 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 4.1.7. SHOW CELLAR STATISTICS Choose `Show Cellar Statistics' on the Summary Menu to analyze the contents of your cellar. The Choose Statistics Fields panel is displayed and you can enter the following fields. All field values are toggled by pressing the space bar or the `+' and `-' keys. . Analyze You can analyze the entire database, the cellar or the current wine list. Analyzing the `Database' will include all wines that have ever been entered, `Cellar' only the wines that have not been consumed, and `List' the currently displayed Wine List. . Primary Field, Secondary Field You can choose one or two wine record fields to use as the basis for your analysis. The database will be divided into categories based on those fields and VINO:FILE will count the number in each category. There are three special fields that are not actually part of the Wine Record. `Cellar Location' is obvious. `Optimum Drink Date' is the midway point between the `Year Ready' and `Drink By' values. `Year in Ready Range' will match all years between the `Year Ready' and `Drink By' fields inclusive. There is a restriction - you cannot specify any Secondary Field if the Primary Field is either `Cellar Location' or `Year In Ready Range'. . Sort Order The Statistics List can be ordered by Field (the combined Primary and Secondary Fields) or by Number (the number in each category). . Count You can count the number of `Wines' in each category, `Bottles' - the number of bottles, including those that have been consumed, or `Bottles In Cellar' - the number of bottles in each category that are not yet consumed. Note that you cannot count wines if Cellar Location is the Primary or Secondary field. --------------------------------------------------------------- Section IV. User Reference Page 54 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- After choosing these parameters, press Ctrl_Enter to display the statistics. This shows the statistics for the entire Sample database - by Wine Category and Year. You can see the number of Dry Red (DR), Dry White (DW), Fortified (FO) and Methode Champenoise (MC) bottles of wine by vintage year. You can display the statistics in Tabular or Graphic format. Switch between formats by pressing the F3 key. To print a statistics report , press F2. The printout can be in either Tabular or Graphic format depending on the current display format. 4.1.8. MEMORY USAGE SUMMARY To display statistics on system memory choose `Memory Usage' on the Summary Menu . This screen is basically for debugging purposes but may also be of interest to some users. The meanings of the various fields are as follows: . Total Memory Available the number of bytes of memory free after VINO:FILE has started up. . Overlay Buffer Size the amount of memory that VINO:FILE uses to buffer its overlay files. This is generally 150,000 bytes but will be reduced - at the cost of performance - when memory is limited. . Memory Now Used by VINO:FILE The total RAM memory used by VINO:FILE for internal structures, screen buffers, and data. . Memory Used for Wine Database Information on memory use for storage of the Wine Database. The first figure is the amount of RAM memory used for miscellaneous database structures. The next three lines show the data structures that are used for the Wine Records, Bottle Records and Text Records respectively. --------------------------------------------------------------- Section IV. User Reference Page 55 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . W: 10984, and 8806 / 10948 in RAM indicates that, for Wine Records, 10948 bytes have been reserved in RAM and 8806 bytes are in use. The first figure is the total amount of RAM - in this case it includes the main storage. If main storage is in EMS, XMS or Disk there is still some RAM used for overhead. . Memory Used for XRef is in the same format as for the Wine Database above. . Memory Free for Use by Wine/XRef VINO:FILE reserves some RAM for internal use. This is the amount of memory available for the Database and Cross Reference. . Maximum RAM for Array Buffers The amount of RAM that is allowed for each of the database data structures (Wines, Bottles and Texts) and the XRef. If more is needed then EMS, XMS or Disk Virtual Storage is used allowing each structure to be far bigger than the amount of free RAM. . Actual / Max Memory Free the total amount of free RAM and the size of the largest free block. . Total Expanded Memory Installed The amount of EMS (Expanded) memory that is defined in your system. If you specified the /E parameter when you started VINO:FILE then the Expanded memory will NOT be used and is noted with (*). . EMS Now Available The amount of EMS (Expanded) memory now available. . Overlay File in EMS If EMS is installed the overlay file is loaded there to improve swapping times. This usage of EMS is NOT affected by the /E command line parameter. --------------------------------------------------------------- Section IV. User Reference Page 56 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- . XMS Now Available to VINO:FILE The amount of XMS (Extended) memory that is now available. If you specified the /X parameter when you started VINO:FILE then the Extended memory will NOT be used and is noted with (*). 4.1.9. OPEN A NEW CROSS REFERENCE To load a new Cross Reference file from disk choose `Open New XRef' on the XRef Menu. When you select this option, a window displays showing the current Cross Reference file and asking you to enter two fields: . Load Option Enter `NEW' (the default) to erase the Cross Reference currently in memory and then load the new Cross Reference file. If you have made changes to the current XRef since it was last saved to disk then you will have the option to save it before loading the new file. Enter `MERGE' to keep the current Cross Reference in memory and add all entries from the new Cross Reference file. In this case, any EXACT duplicates will be skipped. . New XRef Name The name of the Cross Reference file to load. You can type in the name (without the .XRF extension). If you press Enter without typing anything in the field then a directory window will be displayed. Select a Cross Reference file from the list using the up and down arrow keys and press Enter. The directory entries in the list allow you to move up the directory hierarchy to choose a Cross Reference file from another directory. --------------------------------------------------------------- Section IV. User Reference Page 57 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 4.1.10. PRINT A CROSS REFERENCE REPORT Choose `Print XRef' on the XRef Menu to print reports on all entries in the current Cross Reference file. Displayed on the second line is the current printer setup information (such as `HPLJ to LPT1') which shows the type of formatting and where to direct the output. To change this, choose `Printer Setup' on the Print Menu. THE FIELDS THAT YOU ENTER ON THE PRINT XREF PANEL ARE: . Print By Producer / District press the space bar to toggle the value. The report can be ordered by Producer or by District. . Heading Text allows you to enter up to 40 characters that will be printed at the top of each page of the report. . File Name This field is displayed only if you have set up VINO:FILE to print to a file. Enter a DOS filename - with extension. 4.1.11. THE VARIETY CROSS REFERENCE LIST The Cross Reference file includes information on Grape Varieties and Wine Categories to make data entry quicker and easier. Any time you add a wine of a particular variety to the database the variety will be added automatically to the Variety list. You can display and change this information by selecting `Variety List' on the XRef Menu. The Variety list displays Grape Varieties and the Wine Category usually produced from that variety. It is scrollable using the Up and Down arrow keys, PgUp and PgDn and the scroll bar if you have a mouse. You can perform the following actions on each entry: . A Add a new Variety . S or C Change a Variety . D Delete a Variety . F Find a particular variety in the list. Remember to specify the Category when adding or changing a variety. --------------------------------------------------------------- Section IV. User Reference Page 58 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- 4.2. THE VINO:FILE DATABASE STRUCTURE The VINO:FILE database is kept in memory while VINO:FILE is running. If VINO:FILE cannot obtain enough normal RAM to store the database it will automatically use EMS (Expanded) Memory, XMS (Extended Memory) or a disk file to store some or all of the data. 4.2.1. RECORD STRUCTURES The database contains three classes of records - wine records, bottle records and text records. Fields in the records which are used internally by VINO:FILE are not shown here. Each wine in the database is kept in a WINE RECORD and identified by a unique key consisting of the following fields (in sort order): . Producer Alphanumeric, 30 characters; . Other Info Alphanumeric, 30 characters; . Variety Alphanumeric, 20 characters; . Year Alphanumeric, 4 characters. Fields in the wine record that are not part of the key but which the user can enter and change are: . District Alphanumeric, 30 characters; . State Alphanumeric, 20 characters; . Country Alphanumeric, 20 characters; . Category Alphanumeric, 2 characters; . Year Ready Alphanumeric, 4 characters; . Drink By Alphanumeric, 4 characters; . Flag Alphanumeric, 1 characters; . User 1 Alphanumeric, 20 characters; . User 2 Alphanumeric, 20 characters; . Rating 1 Real, format 999.9, maximum 100; . Rating 2 Real, format 999.9, maximum 100; . Rating 3 Real, format 999.9, maximum 100; . Comments A text memo. --------------------------------------------------------------- Section IV. User Reference Page 59 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- Each wine record contains a pointer to a list of BOTTLE RECORDS. Each bottle record represents one or more bottles of that wine and identified by a unique key consisting of the following fields (in sort order): . Drink Date Date; . Purchase Date Date; . Size integer, format 9999; . Location alphanumeric, 8 characters. Fields in the bottle record that are not part of the key but which the user can enter and change are: . Number integer, format 999; . Cost real; . Origin alphanumeric, 20 characters; . Value real; . Occasion a text memo; . Taste a text memo; . Points real, format 999.9, maximum 100. All TEXT MEMO fields (wine comments, bottle occasion and tasting notes) consist of a pointer to a list of text records each containing up to 70 characters. When edited, they are spooled as a single string in a text buffer. 4.2.2. DATABASE CAPACITY VINO:FILE keeps as much of the database in RAM memory as possible at all times - in order to ensure that operation remains as fast as possible. At least part of the database is always in memory. Therefore there is always a limit to the capacity of any one database. VINO:FILE can store parts of the database in RAM Memory, Expanded (EMS) Memory, Extended (XMS) Memory and in Disk Files at any time depending on the amount of each memory type available. The database can be split with some records in each type of memory - it does not have to be all in RAM or all in Expanded, for example. All of these types of memory are also used to store the Cross Reference and so the size of your Cross Reference will also affect the database capacity. --------------------------------------------------------------- Section IV. User Reference Page 60 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- Note also that each user will have different numbers of bottle records per wine, and very different numbers of text records depending on how verbose the Wine Comments, Bottle Occasion and Tasting Notes are. Because of this it is not possible to state an exact maximum number of wines or bottles of wine that you can keep in the database. The following values are VERY APPROXIMATE and may not be accurate for your particular system. IF YOU DO NOT HAVE ANY EMS OR XMS: If your system does not have any expanded or extended memory then VINO:FILE can store the database only in RAM Memory or on Disk. The performance of the system will be better when the database is stored in RAM but not significantly so unless the database is very large. Although we can usually assume that disk space itself is unlimited, VINO:FILE needs to keep buffers and disk usage records in RAM and therefore the capacity of the database when stored on disk is sometimes lower than you might expect. The following table shows the number of different wines (not bottles) you can expect to store in a database stored in RAM or on Disk. Note the assumptions that follow the table as these will vary widely between different users. +----------+-------------+--------------+--------------+ | | Total RAM Available | | Where | (see Memory Usage Summary) | | Stored +-------------+--------------+--------------+ | | 270,000 | 220,000 | 190,000 | +----------+-------------+--------------+--------------+ | RAM | 120 Wines | 80 Wines | 55 Wines | +----------+-------------+--------------+--------------+ | DISK | 3,250 Wines | 2,250 Wines | 1,500 Wines | +----------+-------------+--------------+--------------+ Assumptions: Each Wine Record has 3 Bottle Records; there is one line of Comments per two wine records; there is one line of Occasion or Tasting Notes per two bottle records. --------------------------------------------------------------- Section IV. User Reference Page 61 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- IF YOU DO HAVE EMS OR XMS: If your system has expanded or extended memory then VINO:FILE will always use this in preference to storing the database on disk. The performance of the system will be almost as fast with the database in EMS or XMS as it is in RAM. When the database is in EMS or XMS there is still some RAM storage required but the RAM requirements are less than with any other storage method. Therefore the database capacity is greatest if you have EMS or XMS available to VINO:FILE. The following table shows the number of different wines (not bottles) you can expect to store in a database stored in EMS or XMS. +----------+-------------+--------------+--------------+ | | Total RAM Available | | | (see Memory Usage Summary) | | +-------------+--------------+--------------+ | | 270,000 | 220,000 | 190,000 | +----------+-------------+--------------+--------------+ | # WINES | 6,000 Wines | 4,250 Wines | 3,000 Wines | +----------+-------------+--------------+--------------+ | EMS/XMS | 2,980 Kb | 2,110 Kb | 1,490 Kb | | Required | | | | +----------+-------------+--------------+--------------+ Assumptions: Each Wine Record has 3 Bottle Records; there is one line of Comments per two wine records; there is one line of Occasion or Tasting Notes per two bottle records. The amount of RAM is no longer an issue when the database is stored in EMS or XMS, however the EMS / XMS requirements for these maximums are quite large. Let's state the capacity another way: If you have 650,000 bytes of EMS or XMS free when starting VINO:FILE you can easily process a database containing over 1,000 different wines, 3,000 bottle records and 1,000 lines of text. The more EMS or XMS available, the larger the database can be. As you can see, the use of either expanded or extended memory allows VINO:FILE to comfortably handle the management of extremely large cellars. --------------------------------------------------------------- Section IV. User Reference Page 62 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- INDEX Use in Import, 50 A Variety List, 58 Currency Format, 22 Adding Bottle Records, 18 D Tasting Notes, 14, 52 Wine Records, 15 Data Fields Editing, 35 B Turbo Fields, 39 Two-Digit Years, 40 Bottle List Database Format, 12 Capacity, 60 Bottle Record Clear, 19 Adding, 18 directory list, 44 Change, 13 Export To Text File, 46 Drink, 14 Import File Format, 46 Format, 60 Import Text File, 45 Import/Export Format, 51 Merging, 44 Key Fields, 13 Record Structure, 59 Purchase Fields, 18 Sample, 5 Restore Deleted, 53 Save, 19 Tasting Notes, 13, 14, 52 Save With New Name, 19 Brightness Summary, 21 Disabling, 23 Date Format, 22 Date of Valuation, 21 C Default Print Header, 24 DesqView, 31 Capacity Directory Database, 60 Initial Data Directory, 24 Change Disable Bottle Records, 13 Brightness, 30 Wine Records, 19 Expanded Memory, 29 Color Set, 6, 23, 29 Extended Memory, 30 Command Line Parameters, 29 DOS Commands Platforms, 30 Data Field Editing, 35 Field Movement, 34 E Memo Field Editing, 37 Cross Reference Editing AUSSIE.XRF, 32 Bottle Records, 13 Directory List, 57 Data Fields, 35 District Sub-List, 28 Memo Fields, 37 EUROPE.XRF, 32 Wine Records, 19 in Add Wines, 16 Ending VINO:FILE, 28 Listing, 26 Expanded Memory Merging, 57 Disabling, 29 Merging Files, 32 Export Open New, 26, 57 Database, 46 Printing Reports, 26, 58 Text File Format, 46 Record Fields, 27 Extended Memory Sample, 6 Disabling, 30 Save, 26 USA.XRF, 32 Index Page 63 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- Pop Menus, 23, 41 F Summary Menu, 21, 54, 55 XRef Menu, 57, 58 Fields Microsoft Windows, 30 Case of Strings, 23, 40 Mouse Configuration, 22 Disabling, 23 Cross Reference, 27 General Use, 33 Data Field Commands, 35 Scroll Bars, 11, 43 Data Field Types, 36 Memo Field Commands, 37 O Rating Field Names, 24 Search Type, 9 OS/2 Special Searches, 9 Support, 31 Turbo Fields, 8, 39 Two-Digit Years, 9, 40 P User Field Names, 24 Files Panel Configuration File, 6 Add Bottles, 18 List of, 5 Add Wines, 16 Format Bottle List, 12 Currency, 22 Cellar Statistics, 54 Data Fields, 36 Change Bottle, 13 Date, 22 Change Configuration, 22 String Fields, 23, 40 Change Wine, 19 Drink Bottle, 14 H Help Panels, 41 Sort Wine List, 21 Help Panels, 41 Variety List, 58 Wine List, 10 I Wine Search, 7 XRef List, 27 Import Platforms Database, 45 DesqView, 31 Text File Format, 46 Microsoft Windows, 30 Using Cross Reference, 50 OS/2, 31 Installation Program, 5 Ultravision, 32 Printing M Bottle Details, 25 Cancel Printout, 26 Memo Fields Cross Reference, 26, 58 edit buffer size, 22 Default Header, 24 Editing, 37 Heading Text, 26 Moving, 39 Printer Port, 25 Re-sizing, 39 Printer Setup, 25 Zooming, 39 Printers Supported, 25 Memory Sort Order, 26 Capacity, 60 Statistics Report, 55 Expanded (EMS), 29, 52, Wine Details, 25 56, 60 Extended (XMS), 30, 52, Q 57, 60 Requirements, 2 Quitting VINO:FILE, 28 Menu Add Menu, 20, 52, 53 R Files Menu, 19, 44, 45, 46, 52 Rating Fields --------------------------------------------------------------- Index Page 64 VINO:FILE Cellar Master - Version 3 - July 1, 1992 --------------------------------------------------------------- Changing Name, 24 Windows Requirements Microsoft Windows, 30 Memory, 2 Wine List System, 2 Action Keys, 11, 13 Restore Format, 10 Deleted Bottles, 53 Horizontal Scrolling, 11 Deleted Wines, 53 Statistics, 54 Summary, 21 S Wine Record Adding, 15 Save Search Record, 24 Changing, 19 Screen Size, 23, 29, 32 Format, 59 Scrolling Import/Export Format, 48 Lists, 42 Key Fields, 15 Search Repeating, 11 Arguments, 8 Restore Deleted, 53 Optimum Drinking Period, Wine Search 10 Arguments, 8 Search Type Fields, 9 Save Record, 24 Special Search Fields, 9 Two-Digit Years, 9 Y Wild Cards, 8 Starting Year Initial Data Directory, 24 Drink By, 9 Initial Database, 22, 29 Optimum Drinking Search, 9 Initial XRef, 23 Two-Digit Fields, 9 Parameters, 29 Year Ready, 9 Statistics Database Summary, 21 Summary Database, 21 List, 21 System Requirements, 2 T Tasting Notes Adding, 14, 52 Turbo Fields, 8, 39 Two-Digit Years, 40 U Ultravision, 23, 32 User Fields Changing Name, 24 V Valuation Date, 21 Variety List, 58 Video Mode, 6, 23, 29 W What's New, 2 --------------------------------------------------------------- Index Page 65