V I N O : F I L E Cellar Master A Wine Cellar Management System By Mark Christian Version 2.1 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 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. SHAREWARE LICENSE VINO:FILE is a copyrighted program offered as 'Shareware' for your use, testing and evaluation. The author is committed to the concept of 'Shareware' - an alternative distribution system for copyrighted software which provides professional computer software at low prices. 'Shareware' is 'try-before-you-buy' software - but it is not free. If you decide to keep and use VINO:FILE you must pay a registration fee to the author. A limited license is granted to use and to duplicate this program for your personal use. After a reasonable period of time (approximately 3 weeks) you are expected to register with the author or discontinue your use of this program. You may make and distribute copies of the SHAREWARE VERSION of VINO:FILE freely - as long as ALL of the files on the diskette are copied, INCLUDING THIS MANUAL AND THE REGISTRATION FILE, and that all recipients agree to be similarly bound by this Shareware License. Please pass copies of VINO:FILE to your friends for evaluation and encourage them to register if they, too, like and use the program. VINO:FILE Cellar Master Copyright Mark Christian 1986, 1989, 1990 All rights reserved. _______ ____|__ | (R) --| |o |------------------- | ____|__ | Association of | | |_| Shareware |__| o | Professionals -----| | |--------------------- |___|___| MEMBER Preface Page i VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 DISTRIBUTION FOR REMUNERATION Anyone distributing VINO:FILE Cellar Master for any kind of remuneration or fee must first contact the author at the address below for written authorization. This authorization will be granted automatically to distributors recognized by the Association of Shareware Professionals (ASP) as adhering to its guidelines for shareware distributors, and such organizations may start distributing the program immediately pending written notification of authorization. No person, company or organization may charge more than $10 for a shareware copy of VINO:FILE Cellar Master. If any of the above conditions appear to have been breached by a distributor, we would appreciate being notified at the address below. REGISTRATION If you like and use VINO:FILE after the initial trial period you must register, and pay for, this program. Full details can be found in the file WINE.REG which is distributed with VINO:FILE. VINO:FILE can print this file for you at the end of any session if you answer 'Y' to the question 'Do you want to print a registration form?'. The price for VINO:FILE is included on the form. When you register VINO:FILE you will receive: * a registered copy of the latest version of VINO:FILE on diskette; * extra sample databases and cross-reference files; * a printed copy of this reference manual; * notification of upgrades and new releases; * access to technical support. Registration of VINO:FILE will license one copy for use on one computer at any time. You must treat a licensed 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). Page ii Preface VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 ADDRESS FOR ENQUIRIES, REGISTRATIONS & SUPPORT The author is now residing in Australia and so telephone support will not be available except in unusual circumstances. For Technical Support and General Enquiries, the author can be contacted in the following ways (in approximate order of preference): * On Compuserve, via the 'Bacchus Wine Forum' - GO WINEFO - or EASYPLEX to ID [70032,117]. Registrations should be sent 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: In Australia: 61-3-882-0640. If you have suggestions, complaints, or ideas for future enhancements please feel free to call. We welcome any feedback from users and will do our best to incorporate all ideas in future versions of VINO:FILE Cellar Master. This is USER-SUPPORTED software - only you, the users, can make VINO:FILE the most complete and functional cellar management software available from any source! I started writing this program because there was no other product - commercial, shareware or public domain - that provided the features that were required to manage a wine cellar. This is still true today - and with your help we will continue to make VINO:FILE the only wine cellar software that fully meets the needs of the users. If there is any defect in the VINO:FILE diskette or a copy of VINO:FILE you received from a friend, a BBS or any source - or if any files appear to be missing or incomplete - please contact the author. A list of files can be found in the README.TXT file. Preface Page iii VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 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 P.O. Box 5786, Bellevue, WA 98006 or send a Compuserve message via easyplex to ASP Ombudsman 70007,3536 Page iv Preface VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 TABLE OF CONTENTS SECTION I. INTRODUCTION...............................7 WHY VINO:FILE ?......................................7 SYSTEM REQUIREMENTS..................................8 SECTION II. GETTING STARTED............................9 INSTALLING VINO:FILE.................................9 STARTING VINO:FILE WITH THE SAMPLE DATABASE..........10 SETTING YOUR CONFIGURATION...........................11 A GUIDED TOUR OF THE MAIN MENUS & PANELS.............12 SEARCHING AND DISPLAYING WINE LISTS...............14 DISPLAYING WINE LISTS.............................16 DISPLAYING BOTTLE LISTS...........................19 CHANGING A BOTTLE RECORD..........................21 DRINKING A BOTTLE OF WINE.........................23 ADDING WINES TO THE DATABASE......................26 THE MAIN MENU.....................................34 SAVING & CHANGING DATABASE FILES..................36 SUMMARY SCREENS...................................38 CHANGE CONFIGURATION..............................41 PRINTING REPORTS..................................45 THE CROSS REFERENCE FILE..........................49 QUITTING VINO:FILE................................55 SECTION III. USER REFERENCE.............................56 COMMAND LINE PARAMETERS..............................56 GENERAL PANEL AND DATA ENTRY.........................57 MENU PANELS.......................................58 HELP PANELS.......................................59 DATA ENTRY PANELS.................................60 FIELD EDITING COMMANDS............................62 MEMO FIELDS.......................................65 SCROLLABLE LIST PANELS............................69 STATUS LINE.......................................69 VINO:FILE PANEL REFERENCE............................70 THE WINE SEARCH PANEL.............................70 THE WINE LIST.....................................72 CHANGE WINE PANEL.................................74 ADD BOTTLES PANEL.................................76 FIND WINE PANEL...................................78 THE BOTTLE LIST...................................80 CHANGE BOTTLE PANEL...............................82 DRINK BOTTLES PANEL...............................84 THE CROSS REFERENCE LIST BY COMPANY...............86 THE CROSS REFERENCE LIST BY DISTRICT..............88 THE CROSS REFERENCE DISTRICT SUBLIST..............90 CHANGING A CROSS REFERENCE RECORD.................92 FINDING A CROSS REFERENCE RECORD..................93 VINO:FILE MENU REFERENCE.............................95 THE FILES MENU....................................95 Table of Contents Page 5 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 OPEN NEW DATABASE...............................95 SAVE DATABASE...................................98 SAVE DATABASE WITH A NEW NAME...................98 CLEAR DATABASE..................................98 CHANGE DATA DIRECTORY...........................100 SHELL TO DOS....................................102 THE ADD MENU......................................102 THE SUMMARY MENU..................................103 DATABASE SUMMARY SCREEN.........................103 CURRENT LIST SUMMARY............................105 CHANGE CONFIGURATION............................106 ABOUT VINO:FILE.................................108 THE PRINT MENU....................................109 PRINT THE DATABASE..............................109 PRINT THE CURRENT LIST..........................111 PRINTER SETUP...................................111 THE CROSS REFERENCE (XREF) MENU...................113 OPEN A NEW CROSS REFERENCE......................113 SAVE CROSS REFERENCE FILE.......................116 PRINT A CROSS REFERENCE REPORT..................116 THE VINO:FILE DATABASE STRUCTURE.....................118 Page 6 Table of Contents VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 SECTION I. INTRODUCTION 1.1. WHY VINO:FILE ? 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 that should be drunk or tasted soon, and identify future purchasing needs ? 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 to these needs 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 company. As a member of the Association of Shareware Professionals, the author will assure that all users (whether registered or not) receive a complete, uncrippled, professional program with prompt support. VINO:FILE's database system has been 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 drunk the wines. You may keep multiple wine databases if you wish, or save older tasting notes in a secondary database. Want to know how many 1985 California Cabernet Sauvignons are in your cellar ? VINO:FILE will tell you. Trying to remember whether the 1974 Chateau Palmer was better than the 1975 ? Just look up your notes - with a single query! All the 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. Wine records can be searched using many fields including the Winery Name, Variety, Year, Geographical Origin, Peak Drinking Period, Category and Cellar Location. Section I. Introduction Page 7 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 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. Sample Cross Reference files for the major wineries in America, Australia and Europe are provided with the registered version of VINO:FILE - smaller sample files are provided with the Shareware version. All VINO:FILE's functions are driven by easy to use menus and lists with full error messages and help panels. The windowing interface will be easy to use for novices and experienced PC users alike. Mastering your wine records is just a few keystrokes away! 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 using VINO:FILE can be. When you are begin using the more advanced features, you'll find the User Reference section has all the detail that you need to get the most from VINO:FILE Cellar Master. 1.2. SYSTEM REQUIREMENTS To run VINO:FILE you will need: * an IBM (or compatible) PC with DOS * a 3.5" or 5.25" floppy disk drive * at least 256 Kb of RAM memory * monochrome, CGA, EGA or VGA display. For optimum use of VINO:FILE it is desirable to have: * a hard disk drive * 640 Kb of RAM memory Page 8 Section I. Introduction VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 SECTION II. GETTING STARTED 2.1. INSTALLING VINO:FILE To install the VINO:FILE program (Shareware Version) from a floppy disk (assumes drive 'A'): * place the diskette in your floppy disk drive; * run the install procedure by typing 'A:INSTALL A C:\WINE'. To install the VINO:FILE Cellar Master program (Shareware Version) from a BBS archive: * make a directory for VINO:FILE on your hard disk drive; * place the archived VINO:FILE file in that directory; * unarchive the file using UNPAK (.ARC), UNZIP (.ZIP) or LHARC (.LZH) etc depending on the archive version used on the BBS; * delete the archive. To see a list of changes in the current version print or display the file 'WINE.CHG' which is included with VINO:FILE. Section II. Getting Started Page 9 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.2. 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 on your hard drive. The sample wine database (SAMPLE.DBA) contains a variety of wine records and shows how the wines of various countries can be entered into VINO:FILE and typical contents for the various data fields. 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 is used to 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: WINE SAMPLE If you want to start your own database you can load VINO:FILE by typing 'WINE'. If you have an unregistered version of VINO:FILE there will be a short pause for you to read the 'Shareware' screen at start-up. This pause should be no more than a few seconds. Page 10 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.3. SETTING YOUR CONFIGURATION The 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' and '/M' to select an alternative video mode and then change your configuration settings to ensure that this setting is used every time you start VINO:FILE. If you start VINO:FILE by typing 'WINE /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. If you start VINO:FILE by typing 'WINE /M' on the command line, a monochrome color set is used. 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' - the third choice - by pressing the down arrow twice 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. The default color set is denoted by a 'C' in this field. 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, all new screens will use the new color set - but screens already drawn will stay in the old colors. To use the new colors quit VINO:FILE by pressing Alt-Q or ESC, and then restart the program. The other settings on the Change Configuration Panel are described in detail in the USER'S REFERENCE section of this manual under the heading 'The Summary Menu'. Section II. Getting Started Page 11 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4. A GUIDED TOUR OF THE MAIN MENUS & PANELS To introduce the new user to the VINO:FILE Cellar Master, this section provides a step by step guide to the major functions of the program. 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: WINE SAMPLE After the database has been loaded you will see the 'Wine Search' panel. Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | +---------------------------------------+ | | - Database - | V I N O : F I L E | - XRef - | | SAMPLE | C E L L A R M A S T E R | WINE | | +---------------------------------------+ | | | | WINE SEARCH - ENTER ARGUMENTS | | | | COMPANY ==> COUNTRY ==> | | | | OTHER INFO ==> STATE ==> | | | | VARIETY ==> DISTRICT ==> | | | | YEAR ==> CATEGORY ==> | | | | LOCATION ==> FLAG ==> | | | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ ENTER, CTRL_ENTER - SEARCH PGDN - Clear All F1 - Help F10 - Menu Page 12 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 All the panels in VINO:FILE have the same basic structure. Across the top of the screen is the 'main menu' which is used to access the various utility functions of the program. Across the bottom of the screen is the 'status line' which is used to show the main key functions for this screen. The status line is also where error messages are displayed. You can get help from any panel by pressing 'F1'. If the main menu is available you can access it by pressing 'F10' or Alt plus the first letter of the menu option that you want. To exit from any panel without saving changes you press either 'F3' or Esc (the escape key). To exit and accept all field entries or changes press CTRL-Enter (hold down the CTRL key while pressing Enter). Section II. Getting Started Page 13 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.1. SEARCHING AND DISPLAYING WINE LISTS The Wine Search Panel is the screen 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 have '- Database -' and underneath that the name of the wine database 'SAMPLE'. On the right hand side of the screen you should see '- XRef -' and 'WINE' which is the name of the sample cross reference. On this panel you enter the arguments which determine which of the wine records in the database will be listed. By pressing Enter without entering any search criteria you can display a list of all wines in the database. This will include all wines which have ever been in the cellar. Press Enter now. To return to the Wine Search panel, press Escape (Esc). All of the search criteria on this panel are ANDed together to restrict the list of wines that will be displayed. In this way you can construct very quickly a simple, or complicated, search for a particular wine or group of wines from your database. Type the name 'PINE RIDGE' in the 'Company' search field. Press Enter to perform the search after entering the name - you should now see a list of wines form the Pine Ridge winery only. Press Esc again. Now type 'P*' in the company search field - first press Ctrl-E (hold down Ctrl while pressing the 'E' key) to clear the field. Now when you press enter you will see a list of all the wineries which begin with the letter 'P'. Press Esc again. Use Ctrl-E to remove the company name. Use TAB and the down arrow to move over to the District field. Type 'NAPA VALLEY'. Use Shift-TAB to move back to the Variety field. Type 'Cabernet*'. Now when you press enter you will see a list of all the Cabernet Sauvignon wines from the Napa Valley. Press Esc again. Finally, use the Down Arrow key to move down to the Bottles field. Change the value of '0' to '1'. Now when you press Enter, the list of wines displayed will be restricted to 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 can also enter '<' in this field for wines with fewer bottles than the number that you've entered in the 'Bottles' field. To clear all of the fields on the Wine Search panel - press PgDn. Page 14 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 For information about other fields, and the field editing commands that can be used, press 'F1' to display the Help Screens for this panel. When you have finished experimenting with the various searches that can be performed, clear all the fields, set 'Bottles' to 0, and then press Enter to search. The next section uses the resulting list of wines to explain the options available on the wine list. Section II. Getting Started Page 15 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.2. DISPLAYING WINE LISTS The wine list is a scrollable list of wines from the wine database. The following fields are displayed for each wine: * Company 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 of the wine (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 drunk all of these wines. The arrow indicator on the left hand side of the list shows 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. The PgUp and PgDn keys can be used to scroll the list one page at a time. The HOME key moves the indicator to the top of the list. Pressing Enter will select the current entry. Page 16 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | WINE LIST | | | | Current Wine Database: SAMPLE | | | +- Company ------------ Other Information -- Variety ------------ Year --- Num | |> ACACIA PINOT NOIR 1985 3 | | BAILEYS VINTAGE PORT 1976 3 | | BAILEYS ASD 1987 1 | | BAILEYS ASD 1988 1 | | BAILEYS ASD 1989 1 | | BAILEYS HJT MUSCAT NV 5 | | BALGOWNIE CABERNET SAUVIGNON 1980 11 | | BEAULIEU VINEYARDS RUTHERFORD CABERNET SAUVIGNON 1985 10 | | BEYCHEVILLE 1986 1 | | BIONDI-SANTI BRUNELLO DI MONTALCI 1982 1 | | BUENA VISTA CARNEROS CABERNET SAUVIGNON 1985 0 | | CALLAWAY CALLA LEES CHARDONNAY 1988 1 | | CAYMUS VINEYARDS CABERNET SAUVIGNON 1985 1 | | CHATEAU STE MICHELLE WASHINGTON RIESLING 1988 1 | | CHRISTIAN BROTHERS CABERNET SAUVIGNON 1985 1 | | DRC LA TACHE 1985 1 | +------------------------------------------------------------------------------+ S: Select C: Change A: Add Bottles D:Delete F:Find PGDN The actions that can be taken on each wine are listed at the bottom of the screen on the status line. Section II. Getting Started Page 17 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Pressing the letter indicated performs that action on the current wine: * S Select that wine and display the list of bottles; * C Change one or more of the data fields for that wine; * A Add more bottles of this wine; * D Delete the wine record (and all of its bottles); * F Search for a particular company in the list and scroll up or down to that position. If this company is not found in the list and you then press 'ESC', the position is set to the place where that wine would be inserted. If you end your search company with the '*' wild card character, the insert position is found immediately without displaying a message or requiring further input. Try out each of these options, if you are in doubt at any time - press F1 for Help. Now we will look at the bottle list screen - position the arrow indicator to the wine 'BEAULIEU VINEYARDS, RUTHERFORD, CABERNET SAUVIGNON, 1985' and press the 'S' key to select the bottle list for that wine. Page 18 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.3. DISPLAYING BOTTLE LISTS The bottle list is a scrollable list which 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 shown in the top area of the screen - the wine you are looking at now should be 'BEAULIEU VINEYARDS, RUTHERFORD, CABERNET SAUVIGNON, 1985'. In the scrollable bottle record part of the screen the following fields are displayed for each record: * 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; * Drunk The date when these bottles were drunk (if applicable); * Points The point rating for wines which have been drunk. Section II. Getting Started Page 19 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | BEAULIEU VINEYARDS RUTHERFORD, CABERNET SAUVIGNON, 1985 | | District: NAPA VALLEY, CALIFORNIA, USA | | Category: DR Year Ready: 1990 Drink By: 1995 Flag: | | Comments: Bottles: 10 | +-- # - Size - Bought --- Cost ----- Origin ---------- Location - Drunk - Pts -| |> 10 750 02/23/89 $ 6.75 SAFEWAY 15 | | 2 750 02/23/89 $ 6.75 SAFEWAY 04/11/89 17.5 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | +------------------------------------------------------------------------------+ S,C: Change D: Drink L: Delete F1:Help F2:Comments | HOME Note that each record represents one or more identical bottles. The KEY FIELDS for a bottle record are DATE DRUNK, 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 arrow indicator on the left hand side of the list shows the current bottle record - starting at the first bottle in the list. You can move the indicator up and down the list using the Up and Down Arrow keys. The PgUp and PgDn keys can be used to scroll the list one page at a time. The HOME key moves the indicator to the top of the list. Pressing Enter will select the current entry. Page 20 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 The actions that can be taken on each bottle record are listed at the bottom of the screen on the status line. Pressing the letter indicated performs that action on the current record: * 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 the bottle record; Pressing the 'F2' key lets you browse the full wine comments field. Try out each of these options. Some further notes are provided on the following pages. If you are in doubt at any time - Press F1 for Help. 2.4.4. CHANGING A BOTTLE RECORD The tricks in changing the fields of a bottle record are: * If the bottles in this record have been drunk then the Drunk Date, Occasion, Tasting Notes and Points fields are displayed - and can be changed. If the bottles are still in the cellar then these are not displayed. * 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. With 'Change All Bottles' set to 'Y', changing the 'Number' field will change the number of bottles represented by the record. Section II. Getting Started Page 21 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * 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 Drunk Date, 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 is initially set 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. * Any field which is right justified (number, cost, value and points) will allow you to type past the end of the field. That is, if you move the cursor to the cost field in the screen shown below, the cursor will be placed over the '6' in '6.75'. You can now type '10.99' and the numbers will be automatically pushed to the left of the field to make it fit. Page 22 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | CHANGE BOTTLE DETAILS | | BEAULIEU VINEYARDS RUTHERFORD, CABERNET SAUVIGNON, 1985 | | District: NAPA VALLEY, CALIFORNIA, USA | | Category: DR Year Ready: 1990 Drink By: 1995 Flag: | | Comments: Bottles: 10 | +------------------------------------------------------------------------------| | | | Change All Bottles? ==> Y | | | | Number of Bottles ==> 2 | | Purchase Date ==> 02/23/89 | | Cost per Bottle ==> $ 6.75 | | Size of Bottle ==> 750 | | Origin ==> SAFEWAY | | Cellar Location ==> | | Value Per Bottle ==> $ 0.00 | | | | Date Drunk ==> 04/11/89 | | Occasion ==> Dinner Party with Fred and Jane ... | | Tasting Notes ==> Excellent, full-bodied blackber ... | | Points ==> 17.5 | +------------------------------------------------------------------------------+ F1 : Help TAB : Tab CTRL_ENTER : Accept Changes F3/ESC - Cancel 2.4.5. DRINKING A BOTTLE OF WINE Drinking a bottle of wine is fairly straight-forward - and so is updating the VINO:FILE record! * From the Bottle List screen, place the indicator next to a bottle record which does not have a drink date already, and press the 'D' key. * Check that the existing fields are correct - that you are drinking the correct bottle - and, if not, press Esc or F3 to cancel; * Enter the number of bottles that were drunk at this sitting - if you drank two or three of these bottles, and the tasting notes are substantially the same, then you need only enter them once. Section II. Getting Started Page 23 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * Enter the date when the bottles were drunk, the occasion (which could include a restaurant name, menu, food that was served with the wine, your guests' names etc), your tasting notes and a point rating if you want to.The point rating can be on any scale - with a maximum value of 99.9. Page 24 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * All fields other than the Number drunk and Date Drunk are optional. Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | DRINK BOTTLE(S) OF WINE | | BEAULIEU VINEYARDS RUTHERFORD, CABERNET SAUVIGNON, 1985 | | District: NAPA VALLEY, CALIFORNIA, USA | | Category: DR Year Ready: 1990 Drink By: 1995 Flag: | | Comments: Bottles: 10 | +------------------------------------------------------------------------------| | | | Number of Bottles ==> 10 | | Date of Purchase ==> 02/23/89 | | Cost per Bottle ==> $ 6.75 | | Size of Bottle ==> 750 | | Origin ==> SAFEWAY | | Cellar Location ==> 15 | | Value Per Bottle ==> $ 0.00 | | | | Number Drunk ==> 1 | | Date Drunk ==> | | Occasion ==> | | Tasting Notes ==> | | Points ==> | | | +------------------------------------------------------------------------------+ F1 : Help TAB : Tab CTRL_ENTER : Accept Changes F3/ESC - Cancel Section II. Getting Started Page 25 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.6. ADDING WINES TO THE DATABASE To add new wines to the database, you need to use the Main Menu. The Main Menu is the line across the top of the screen that looks something like: Files Add Summary Printer XRef Quit The Main Menu can be accessed from the 'Wine Search', 'Wine List' and 'Bottle List' screens. You 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. There is only one choice on the Add Menu - 'Add Wines' - so 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). Page 26 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | ADD NEW WINE TO CELLAR | | | | Current Wine Database: SAMPLE | | | +------------------------------------------------------------------------------| | | | COMPANY ==> | | OTHER INFO ==> | | VARIETY ==> | | YEAR ==> (or NV) | | | | | | | | | | | | | | | | | | | | | | | +------------------------------------------------------------------------------+ F1:Help CTRL_ENTER:Accept PGUP:Copy Last PGDN:Clear All F3/ESC - Exit Section II. Getting Started Page 27 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Let's add a 'ROBERT MONDAVI PRIVATE RESERVE CABERNET SAUVIGNON, 1985': COMPANY ==> ROBERT MONDAVI OTHER INFO ==> PRIVATE RESERVE VARIETY ==> CABERNET SAUVIGNON YEAR ==> 1985 You need to enter the 'Private Reserve' in the 'Other Info' field to distinguish this wine from the non-reserve Mondavi Cabernet which is a totally different wine. When you press Enter after typing the year 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 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 located in, chances are it does know that District once you type it in - 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. The registered version of VINO:FILE has 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. Once the geographical information has been completed, there are five further fields to be added. These fields are completely optional, and the following might be entered for the Mondavi Reserve that we used as our example above: CATEGORY ==> DR (For example: DR,DW,SW,MC,FO etc) YEAR READY ==> 1990 DRINK BY ==> 1999 FLAG ==> COMMENTS ==> Exciting. More evolved than the 1984 but promises more eventual subtlety. Already approachable, but its fascination should increase. (JR) Page 28 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | ADD NEW WINE TO CELLAR | | | | Current Wine Database: SAMPLE | | | +------------------------------------------------------------------------------| | | | COMPANY ==> ROBERT MONDAVI | | OTHER INFO ==> PRIVATE RESERVE | | VARIETY ==> CABERNET SAUVIGNON | | YEAR ==> 1985 (or NV) | | | | DISTRICT ==> NAPA VALLEY | | STATE ==> CALIFORNIA | | COUNTRY ==> USA | | | | CATEGORY ==> DR ( For Example: DR,DW,SW,MC,FO etc ) | | YEAR READY ==> 1990 | | DRINK BY ==> 1999 | | FLAG ==> | | COMMENTS ==> Exciting. More evolved than the 1984 but promi ... | | | +------------------------------------------------------------------------------+ F1:Help CTRL_ENTER:Accept PGUP:Copy Last PGDN:Clear All F3/ESC - Exit These fields are used as follows: CATEGORY The category is two free-form characters which are intended to allow searching on the different styles of wine. We suggest the following abbreviations although, of course, you can modify these and add your own abbreviations for other wine styles: DR Dry Red DW Dry White SW Sweet White MC Methode Champenoise (Champagne / sparkling wine) FO Fortified wines (Ports and Sherries). YEAR READY, DRINK BY The approximate years between which you aim to drink the bottles of this wine. The values above are taken from Jancis Robinson's 'Vintage Timecharts' for the 1985 Mondavi Reserve Cabernet Sauvignon. Section II. Getting Started Page 29 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 FLAG This single character can be used 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. Page 30 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 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 which might help you keep an accurate record of this wine. Again, the above comments are from Jancis Robinson. Once you've entered the wine record details you need to enter the details of the bottles you have bought. When you press Enter on the Comments field, the 'Add Bottles' screen is displayed. If, after the first four fields have been entered, 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. Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | ADD NEW BOTTLES OF WINE | | ROBERT MONDAVI PRIVATE RESERVE, CABERNET SAUVIGNON, 1985 | | District: NAPA VALLEY, CALIFORNIA, USA | | Category: DR Year Ready: 1990 Drink By: 1999 Flag: | | Comments: Exciting. More evolved than the 1984 but pro ... Bottles: 0 | +------------------------------------------------------------------------------| | | | Number of Bottles ==> 1 | | | | Date of Purchase ==> 04/30/90 | | | | Cost Per Bottle ==> $ 20.00 | | | | Size of Bottle ==> 750 | | | | Origin ==> | | | | Cellar Location ==> | | | | | | | +------------------------------------------------------------------------------+ F1:Help CTRL_ENTER:Accept PGUP:Copy Last PGDN:Clear All F3/ESC:Exit Now enter the following fields: * NUMBER OF BOTTLES The number of bottles of this wine that you purchased; Section II. Getting Started Page 31 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * DATE OF PURCHASE The date you bought them (defaults to current date); * COST PER BOTTLE The price you paid - per bottle; Page 32 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * SIZE OF BOTTLE The size in ml (milliliters) per bottle - usually 750 ml; * ORIGIN Free-form twenty characters for where you purchased these bottles of wine; * LOCATION The cellar location (bin number, box number, room number etc) where these wines will be kept. When these fields have been entered, the 'Add Wine' screen will be displayed again for more wines to be entered. For all subsequent wines you can recall the field values for the last wine added by pressing PgUp - this will make it quicker and easier to add several wines that have some values the same. The PgUp recall can be used in either the 'Add Wine' or 'Add Bottles' screens. Section II. Getting Started Page 33 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.7. THE MAIN MENU As already mentioned, the 'Main Menu' is the bar across the top of the screen and has the following options on it: Files Add Summary Printer XRef Quit The main menu can be accessed from the 'Wine Search', 'Wine List' and 'Bottle List' panels by pressing 'F10'. You can then use the Right and Left Arrow keys to move the highlighted cursor to the appropriate option and press Enter. Each option on the main menu displays a pick list of sub-options which you select using the Up and Down Arrow keys. As a shortcut you can press Alt and the first letter of the main menu option (Alt-F, Alt-A, Alt-S etc) instead of F10 - the pick list will be displayed immediately and you can still move to a different pick list using the left and right arrows. You will find complete instructions for all of the options and sub- options in the User Reference section of this manual. In the following few pages we'll continue the 'guided tour' by touching on the main functions available through each of the menus. Page 34 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit ++----------------------+------------------------------------------------------+ || Open New Database |-----------------------------------+ | || Save Database | V I N O : F I L E | - XRef - | || Save Database As ... | C E L L A R M A S T E R | WINE | || Clear Database |-----------------------------------+ | || Change Directory | | || Shell to DOS | WINE SEARCH - ENTER ARGUMENTS | |+----------------------+ | | COMPANY ==> COUNTRY ==> | | | | OTHER INFO ==> STATE ==> | | | | VARIETY ==> DISTRICT ==> | | | | YEAR ==> CATEGORY ==> | | | | LOCATION ==> FLAG ==> | | | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ Choose item using the arrow keys ^ v | Press ESC to abort | Press <+ when done Section II. Getting Started Page 35 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.8. 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 if you are not there already and bring up the Files Menu by pressing Alt-F, or F10 and then Enter. The options on the Files Menu are: * Open New Database * Save Database * Save Database As ... * Clear Database * Change Directory * Shell to DOS Move to the third choice 'Save Database As ...' using the down arrow and then press enter. You are then shown the current name of the database (SAMPLE) and asked to enter a new name. Type in any name - up to 8 characters in the normal DOS filename way. The extension .DBA will be added by VINO:FILE and the database will be saved to disk. VINO:FILE will check to see that your database name is a valid filename. To save the database without changing the name you can select the second option on the Files Menu - 'Save Database'. No further input is needed - try it now, if you like. Finally, 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 a directory list will be provided for you. There are two ways you can load a database. Mostly you will load it as 'NEW' - the database currently in memory will be cleared and the new one loaded in its place. Sometimes you might want to 'MERGE' two databases together, where the wines and bottles from the new database are added to the one already in memory - with duplicates being discarded. Page 36 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 The other options on the files menu are detailed in the User Reference section. Briefly: * Clear Database Erase the database in memory to start a fresh database. * Change Directory Read and write databases to a different directory on your hard disk. * Shell to DOS Temporarily exit from VINO:FILE so that you can run another program from the DOS prompt. Section II. Getting Started Page 37 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.9. SUMMARY SCREENS To display information about the database that you have loaded bring up the Summary menu by pressing Alt-S. There are four options: * Database Summary * Current List Summary * Change Configuration * About VINO:FILE The Database Summary shows statistical information about the database that is currently loaded: Files Add Summary Print XRef Quit +--------+----------------------------------------------------------+----------+ | | SUMMARY OF DATABASE CONTENTS | | | - Dat| |XRef - | | SA| Current Wine Database: SAMPLE |WINE | | | | | | | Number of Wine Records in Database: 33 | | | | No of Bottle Records (Bottles) in Database: 43 ( 75) | | | | Number of Text Records in the Database: 22 | | | COMP| Cost of Bottles in the Database: 1040.13 | | | | | | | OTHE| Number of Wines in the Cellar: 28 | | | | Number of Bottles in the Cellar: 62 | | | VARI| Cost of Bottles in the Cellar: 788.36 | | | | Value of Bottles in the Cellar: 10.00 | | | YEAR| | | | | Total Memory Available (bytes): 280992 | | | LOCA| Memory Now Used by Vino:File: 36953 | | | | Memory Used by Wine Database: 11010 | | | YEAR| Memory Used by XRef: 7601 | | | | Memory Reserved for Overhead: 12244 | | | BOTT| Memory Free for Use by Wine/XRef: 231795 | | | +----------------------------------------------------------+ | +------------------------------------------------------------------------------+ Press Any Key to Continue * The number of wine and bottle records (and actual bottles) in the database. Page 38 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * The number of text records (each text record is one line of text in the Wine Comments, Bottle 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 drunk) and the cost and total value of those wines. Section II. Getting Started Page 39 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * Memory usage figures - if your computer is short of available memory then you may have to split your databases into smaller ones (this means a very limited computer, too many TSR's loaded or enormous quantities of wine and tasting notes). The 'Current List Summary' shows similar information but is restricted to the CURRENTLY SELECTED LIST of wines only - as determined by the Wine Search criteria that you last entered. 'About VINO:FILE' displays information about the program, the version number, copyright information, where to get support and whether your copy of VINO:FILE is registered or not. If it is NOT registered you can print out a registration form by pressing 'Y'. The 'Change Configuration' panel is described on the following page. Page 40 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.10. CHANGE CONFIGURATION The options used when VINO:FILE starts up are stored in a configuration file (WINEPARM.CFG). These options can be changed by selecting 'Change Configuration' on the 'Summary Menu'. Depending on your computer system, you may like to change some of these options now: Files Add Summary Print XRef Quit +--------+---------------------------------------------------------------+-----+ | | CHANGE VINO:FILE CONFIGURATION | | | - Dat| ------------------------------ | - | | SA| | | | | * Currency Symbol: $ * Date Format: MDY | | | | | | | | * Printer Type: NONE * Printer Port: FILE | | | | | | | COMP| Initial Database: SAMPLE Initial XREF: WINE | | | | | | | OTHE| * Video Mode: C * Bottle Search Default 0 | | | | | | | VARI| - * Temporary Files Directory - | | | | C:\ | | | YEAR| (These files should be on a HARD DRIVE, if possible.) | | | | | | | LOCA| - Initial Data Directory - | | | | C:\VINOFILE\DATA | | | YEAR| | | | | * Most Fields will take effect immediately (VideoMode Partly) | | | BOTT| New Database, XRef and Data Directory can be set elsewhere. | | | +---------------------------------------------------------------+ | +------------------------------------------------------------------------------+ F1 : Help TAB : Tab CTRL_ENTER : Accept Changes F3,ESC : Cancel * Currency Symbol Defaults to '$'. If you are using this program in another country you can change this to the appropriate symbol for your currency. Section II. Getting Started Page 41 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * Date Format Defaults to 'MDY' which means that all dates will be shown as mm/dd/yy. If you want a different format you can change this to 'DMY' or 'YMD'. * Printer Type The printed reports can be formatted for 'EPSON', 'HPLJ' (HP LaserJet) printers. If you don't have either of these (or a compatible) enter 'NONE' and plain text will be printed without any formatting. * Printer Port The printer port where you want the reports sent for printing. This can be 'LPT1', 'LPT2' etc or 'FILE' to send the output to a file. Serial ports (COM1 etc) are NOT supported. Page 42 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * Initial Database The name of the database that is to be loaded when VINO:FILE starts. * Initial XRef The name of the Cross Reference file that is to be loaded when VINO:FILE starts. * Video Mode Determines the color set that will be used. 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. * Bottle Search Default The initial value for the 'Bottles' field on the 'Wine Search' panel. You would set this to either '0' or '1' depending on whether you normally want to list all wines in the database or only those that are in your cellar. * Temporary Files Directory a directory on your hard disk where VINO:FILE can put temporary files while it is working. It can be the same as the directory where you have installed VINO:FILE or any other directory. * 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. Section II. Getting Started Page 43 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 All field changes will take effect immediately except: * Initial Database, Initial XRef and Initial Data Directory are only relevant at program start up; * Video Mode. Only newly drawn fields and screens will use the new color set. Quit VINO:FILE and restart to ensure full use of the new colors. Page 44 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.11. 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'. Two printer types can be used for formatting the reports: EPSON printers and the Hewlett Packard LaserJet (HPLJ) series. Many other printers can emulate either of these printers - so even if you don't have those particular brands you may still be able to get formatted printouts. If not, then you should choose 'NONE' for formatting - you can still print reports but will not get any boldface or different point sizes. The other information that VINO:FILE needs is which port your printer is attached to. VINO:FILE can print to any parallel port (LPT1, LPT2 etc) or to a disk file but it will not print 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 parallel to serial - see the User Reference section for details. Printing to a FILE will be useful if you do not have your printer attached but want to print the output at a later time or on another PC. If you select 'FILE', VINO:FILE will prompt you for a file name for each report that you print. Section II. Getting Started Page 45 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------+----------------------+------------------+ | +----------------| Print Database | | | - Database+----------------------------------------------------------+ - | | SAMPLE | CHOOSE PRINTER TYPE | | | | ------------------- | | | | | | | | Printer Type ==> NONE | | | | | | | COMPANY | EPSON - EPSON or IBM Proprinters | | | | HPLJ - HP Laserjet II, IID, IIP or III | | | OTHER INF| HPLJ+ - HP Laserjet or Laserjet+ | | | | NONE - Generic Printer | | | VARIETY | | | | | Printer Port ==> FILE | | | YEAR | | | | | FILE - Print to Disk | | | LOCATION | LPT1, LPT2 etc - Parallel Printer | | | | | | | YEAR READ| All Output is to a File or LPTx, Redirect with | | | | the DOS Mode Command for serial printers | | | BOTTLES +----------------------------------------------------------+ | | | +------------------------------------------------------------------------------+ Choose one of the Printer Types and Destinations listed; F1 : Help Page 46 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 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: Files Add Summary Print XRef Quit +------------------------------------+----------------------+------------------+ | +----------------| Print Database | | | - Database - | V I N| Print Current List | - XRef - | | SAMPLE | C E L L A| Printer Setup | WINE | | +-----------------------------------------------------+ | | | | | | | CHOOSE PRINT OPTIONS | | | | | | | COMPANY | Source : Database Printer : NONE to FILE | | | | | | | OTHER INF| Print Wine Details ==> Y (N,Y) | | | | Print Bottles ==> N (N,Y,F) | | | VARIETY | | | | | | | | YEAR | Heading Text ==> | | | | VINO:FILE Database Printout | | | LOCATION | | | | +-----------------------------------------------------+ | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ F1 : Help CTRL_ENTER - Accept Fields F3, ESC to Cancel Print Wine Details can be: * N Only the name of the wine (Company, Other Info, Variety, Year) plus the number of bottles in the cellar and their location are printed. * Y All wine record fields are printed. Print Bottles can be: * N No bottle details are displayed at all * Y The bottle record fields (Date Bought, Date Drunk, Origin, Cost etc) are printed but the Occasion and Tasting Notes are not. * F All fields, including the Occasion and Tasting Notes are displayed. Section II. Getting Started Page 47 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Heading Text: * A heading to be printed at the top of each page of the report. Page 48 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.12. THE CROSS REFERENCE FILE As I explained briefly in the section on adding new wines, 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. You can display and modify the Cross Reference file using the 'XRef Menu' options. They are: * Display XRef List all Cross Reference records. This produces a scrollable list where you can choose to change, delete or add entries; * Open New XRef You can maintain multiple Cross Reference files and load different ones from this panel; * Save XRef Save the Cross Reference file to disk; * Print XRef Print Cross Reference Reports. Choose 'Display XRef' and you will see XRef List sorted by the 'Company' field. Section II. Getting Started Page 49 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | CROSS REFERENCE LIST | | BY COMPANY | | | | F2 SWAPS SORT ORDER XRef File: WINE.XRF | +------ Company -------------- Wine / Vineyard ---------- District ------------| |> ACACIA * NAPA VALLEY | | BAILEYS * NE VICTORIA | | BALGOWNIE * MILDURA | | BALGOWNIE ESTATE CENTRAL VICTORIA | | BEAULIEU VINEYARDS * NAPA VALLEY | | BEAULIEU VINEYARDS RUTHERFORD NAPA VALLEY | | BEYCHEVILLE * ST JULIEN | | BILLECART SALMON BRUT ROSE | | BIONDI-SANTI BRUNELLO DI MONTALCI BRUNELLO DI MONTALCI | | BONNY DOON * MONTEREY BAY | | BOWEN ESTATE * COONAWARRA | | BROWN BROTHERS * MILLAWA | | BROWN BROTHERS KOOMBAHLA GOULBURN VALLEY | | CALLAWAY CALLA LEES TEMECULA VALLEY | | CAPE MENTELLE * MARGARET RIVER | | CARMENET SONOMA VALLEY SONOMA COUNTY | +------------------------------------------------------------------------------+ S: Select C: Change A: Add XRef Entry D:Delete F:Find PGDN This shows the District for each Company / Additional 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' or 'C'. You can also press 'A' to add a new Cross Reference entry, or 'F' to find a particular entry in the list. Page 50 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Each cross reference file entry contains: * Company the name of the winery, company or shipper. * Other Info a specific notation, or vineyard name. Many wineries have several vineyards in different locations. You can enter a different Cross Reference entry for each vineyard. If a winery produces all of its wine in the same district then you should set this field to '*' which will match any value. * District the district where the grapes originated. The District can be left blank for wines which obtain their fruit from multiple vineyard areas. * State the state where that district is located. The State can be left blank for wines which obtain their fruit from multiple states. * Country the country of origin. Cannot be left blank. Section II. Getting Started Page 51 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | CHANGE CROSS REFERENCE ENTRY | | | | XRef File: WINE | | | +------------------------------------------------------------------------------| | | | | | Company: BEAULIEU VINEYARDS | | | | Other Info: * | | | | | | District: NAPA VALLEY | | | | State: CALIFORNIA | | | | Country: USA | | | | | | | | | +------------------------------------------------------------------------------+ F1 : Help TAB : Tab F3/ESC - Cancel Page 52 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 You can also display the Cross Reference List sorted by District. Press F2 to toggle the sort order from 'By Company' to 'By District'. Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | CROSS REFERENCE LIST | | BY DISTRICT | | | | F2 SWAPS SORT ORDER XRef File: WINE.XRF | +------ District ------------- State -------------------- Country -------------| |> CALIFORNIA USA | | CHAMPAGNE FRANCE | | CHATEAUNEUF DU PAPE FRANCE | | SOUTH AUSTRALIA AUSTRALIA | | WASHINGTON USA | | BAROLO PIEMONTE ITALY | | BAROSSA VALLEY SOUTH AUSTRALIA AUSTRALIA | | BLENHEIM SOUTH ISLAND NEW ZEALAND | | BRUNELLO DI MONTALCI TUSCANY ITALY | | CENTRAL VICTORIA VICTORIA AUSTRALIA | | CHIANTI TUSCANY ITALY | | COONAWARRA SOUTH AUSTRALIA AUSTRALIA | | COTE ROTIE COTES DU RHONE FRANCE | | FINGER LAKES NEW YORK USA | | FLEURIE BEAUJOLAIS FRANCE | | GEVREY-CHAMBERTIN BURGUNDY FRANCE | +------------------------------------------------------------------------------+ S: Select C: Change A: Add XRef Entry D:Delete F:Find PGDN You will now see all of the districts that are stored in the Cross Reference file. 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 get all the entries set to the one or other value by changing the misspelled or incorrect entry here. Section II. Getting Started Page 53 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 To see the list of companies for a particular District, position the indicator using the Up and Down Arrow keys and press 'S'. 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'. Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | CROSS REFERENCE LIST | | BY DISTRICT | | | | F2 SWAPS SORT ORDER +-----------------------------------------------+ | +------ District ----------| LIST OF COMPANIES in NAPA VALLEY |---| | GOULBURN VALLEY +-----------------------------------------------| | | LA TACHE |> ACACIA * | | | LOWER HUNTER | BEAULIEU VINEYARDS * | | | MACEDON | BEAULIEU VINEYARDS RUTHERFORD | | | MARGARET RIVER | CAYMUS VINEYARDS * | | | MILDURA | HEITZ CELLARS MARTHA'S VINEYARD | | | MILLAWA | ROBERT MONDAVI * | | | MONTEREY | RUTHERFORD HILL * | | | MONTEREY BAY | SILVERADO * | | |> NAPA VALLEY | | | | NE VICTORIA | | | | PAUILLAC | | | | PIPERS BROOK | | | | POMEROL | | | | RUDESHEIM | | | | SANTA YNEZ VALLEY +-----------------------------------------------| | +------------------------------------------------------------------------------+ S,C : Change ESC, F3 : Return to District List 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. Page 54 Section II. Getting Started VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 2.4.13. 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' panel press Esc, F3 or Alt-Q, and then enter to confirm. From the 'Wine List' or 'Bottle List' screens press Alt-Q, and then enter to confirm. In either case, 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 'NO' 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 'F3' or 'ESC'. If you are using an unregistered version of VINO:FILE it will pause and ask you whether you would like to print a registration form. If you press 'Y' a form will be printed for you to fill out, any other key will return you to DOS. We hope that you have found the 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 User Reference section of this manual and remember - if you need help while using VINO:FILE you can press 'F1' from just about any panel. Thanks for reading this far and, if you like what you have seen, we look forward to having you as a registered user of the VINO:FILE Cellar Master. Section II. Getting Started Page 55 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 SECTION III. USER REFERENCE 3.1. COMMAND LINE PARAMETERS When starting VINO:FILE from the command line you enter the following: WINE [drive:] [directory\] [filename] [.DBA] { /C /L /M } What all this means is that after the name of the program (WINE) you may OPTIONALLY enter the name of the wine database that should be loaded. Also you can OPTIONALLY choose one of the parameters /C, /L or /M to choose the color set. The following are all valid VINO:FILE command line alternatives: WINE SAMPLE WINE SAMPLE /L WINE SAMPLE.DBA WINE DATA\MYDBA WINE C:VINOFILE\DATA\FRENCH.DBA If you do not enter a database name then the database that you have entered on the 'Configuration' panel will be loaded. 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 should always be '.DBA' for wine database files. If the database you have specified (on the command line or the configuration file) cannot be found you'll be asked 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. You will not need to specify a color set unless the default colors (/C) are unreadable on your computer. Try /L first and if that is still not readable then enter /M. Then go straight to the 'Change Configuration panel on the 'Summary Menu' and change the default color set accordingly - see 'Setting Your Configuration' on page 11 for details. Page 56 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.2. GENERAL PANEL AND DATA ENTRY The panels in VINO:FILE Cellar Master are designed so that, as far as possible, the same keys are used for the same function throughout the program. There are several types of panel used in VINO:FILE. This section gives general instructions and key functions for the VINO:FILE program. Instructions for specific panels are given in section Error! Bookmark not defined. Error! Bookmark not defined. The following are common to all of the panels in VINO:FILE: * F1 will display a context-sensitive Help Panel. All non-trivial panels in VINO:FILE have help panels available; * F3 or ESC cancels any input on the current panel and returns to the previous panel; * CTRL_ENTER accepts all input on the current panel and displays the next panel. The panels in VINO:FILE 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 whole- screen panels and pop-up panels. Section III. User Reference Page 57 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.2.1. MENU PANELS The 'Main Menu' is displayed on the top line of the screen at all times - even though it can only be accessed from some of the panels. From the 'Wine Search', 'Wine List' and 'Bottle List' panels you can access the 'Main Menu' by pressing F10. As a short cut you can press the ALT key and the first letter of any Main Menu option. On other panels, these keys will do nothing. When the main menu is selected with F10, one of the main menu 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. The ALT key short cut will automatically display that sub-menu. To choose an option on the sub-menu you use the up and down arrow keys to highlight one of the options and then press ENTER to select it. The illustration on page 35 shows the 'Files' sub- menu. The options available on each of the menus and sub-menus are documented in detail later in this section. Page 58 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.2.2. HELP PANELS Help is available on all non-trivial VINO:FILE panels by pressing the F1 key. The Help Panel displayed will contain information relevant to the VINO:FILE panel that is currently displayed. If there is more than one screenful of help information then the user will press the PgDn and PgUp keys to scroll through the screens. The Help Panel for the 'Wine Search' panel is shown below. For all data entry panels the last help screen will contain information on the field entry editing commands. When you have finished reading the help information, pressing F3 or ESC will return you to the VINO:FILE program where you left off. Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | +--------------------------------------------------------------------+ | | | Help - List Wines | - | | | | | | | To search for wines in the database enter the arguments here. | | | | Any number of field searches will be ANDed together. Enter a | | | | particular value for any of the fields - or use the wild card | | | | character '*'. For example, for all wineries starting with | | | | 'A' enter 'A*' for Company. | | | | | | | | To control searching on the 'BOTTLES' field, you can enter | | | | '=' or '<' in the 'Bottles Search Type' Field. '=' will match | | | | any wines with exactly 'BOTTLES' number of bottles. '<' will | | | | match wines with less than that number. The default (leave the | | | | Search Type blank) will match wines with >= bottles. | | | | | | | | The startup value for 'BOTTLES' can be changed by selecting | | | | 'Change Configuration' on the Summary Menu (Alt-S). | | | | | | | | For commands used in editing fields, press PGDN. | | | +--------------------------------------------------------------------+ | | | +------------------------------------------------------------------------------+ F3,ESC to Return to VINO:FILE. Section III. User Reference Page 59 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.2.3. DATA ENTRY PANELS A 'data entry' panel has one or more data entry fields where the user can enter values. Each field is indicated by '==>' on the screen. The name of the field is on the left of the '==>' and the value of the field is entered by the user to the right of it. A blinking cursor is placed in the current field. The user types a value into the current field. The editing commands that are available in a data field are described in the following section. To move from field to field the following keys are used: * ENTER accepts any data typed by the user and moves the cursor to the next field; on the last field of the panel, accepts all data entered on the panel and displays the next panel; * TAB moves the cursor to the next field; * SHIFT_TAB moves the cursor to the previous field; * DOWN_ARROW on a data entry panel with two distinct columns of data fields (for example, the Wine Search panel), the down arrow key moves the cursor to the field directly below the current field; on other data entry panels, the down arrow key moves the cursor to the next field; * UP_ARROW on a data entry panel with two distinct columns of data fields (for example, the Wine Search panel), the up arrow key moves the cursor to the field directly above the current field; on other data entry panels, the up arrow key moves the cursor to the previous field; * CTRL_HOME moves to the first field on the panel; * CTRL_END moves to the last field on the panel; Page 60 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * F3 or 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. Section III. User Reference Page 61 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.2.4. FIELD EDITING COMMANDS The user can enter a value into a data entry field by typing that value using the normal keyboard keys. In addition, however, there are many editing commands that can be used to make data entry easier for the user. Note that these editing commands are for normal or short data entry fields. The editing commands for memo fields - fields which 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' and are entered 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; * ENTER accept entered data; * CTRL_D change all data to lower case (unless all characters are forced to upper case - as most VINO:FILE fields are); * CTRL_E erase entire field; * CTRL_L left justify data; * CTRL_N quit editing, restore previous field contents; Page 62 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * CTRL_P restore the previous - or CTRL_E(rased) - field contents; * CTRL_Q quit editing, restore previous field contents; * CTRL_R right justify data; * CTRL_S start editing over; * CTRL_U change all data to Upper Case; * CTRL_X erase all characters to the right of the cursor; Section III. User Reference Page 63 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 The characters that can be typed in each field varies according to field type: * Alphanumeric all printable characters can be entered. Note that many fields force all alphabetic characters to upper case. * Integer only numbers '0' through '9' are allowed. * Real (Decimal) numbers '0' through '9' plus the decimal point '.' are allowed. * Dates numbers and the '/' are allowed. When enter is pressed 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. See 'Change Configuration' on the Summary menu to change this option. Page 64 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.2.5. MEMO FIELDS A VINO:FILE memo field contains unlimited, multiple lines of text. Examples of memo fields are the Wine Comments, Bottle Occasion and Bottle Taste fields. Initially, only the first few characters of the first line are displayed on the data entry panel. If there is more data than that displayed, three dots (. . .) are displayed at the end of that line. When the cursor is moved to the memo field, the user can pop up the memo editing window by pressing the right arrow key or by starting to type data. Once the memo window has popped up, the user can enter text by typing using the normal keyboard keys. In addition, however, there are many editing commands that can be used to make data entry easier for the user. 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; * 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; * PgUp scroll up the memo window one page; * PgDn scroll down the memo window one page; * 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; Section III. User Reference Page 65 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * DEL deletes the character to the right of the cursor; * BACKSPACE deletes the character to the left of the cursor; * ENTER moves to the next line - or inserts a carriage return if in insert mode; * CTRL_D change all data in the current line to lower case; * CTRL_E erase characters in current line; * CTRL_L left justify current line; Page 66 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | CHANGE WINE DETAILS | | | | Current Wine Database: SAMPLE | | | +------------------------------------------------------------------------------| | | | | | Company: MOUNT MARY Other Info: | | Variety: CABERNET SAUVIGNON Year: 1986 | | | | | | District: YARRA VALLEY State: VICTORIA | | Country: AUSTRALIA | | +--------------------------- Wine Comments ----------------------------+ | | |Mount Mary is one of Australia's best wine investments. | | | | | | | |Very limited production and superb quality make this wine hard to | | | |get. | | | | | | | +----------------------------------------------------------------------+ | | | +------------------------------------------------------------------------------+ F1 - Help F3, ESC, CTRL_ENTER - Exit * CTRL_N same as ENTER but restores previous contents of the current line; * CTRL_P restore the previous - or CTRL_E(rased) - contents of the current line; * CTRL_Q same as ENTER but restores previous contents of the current line; * CTRL_R right justify current line; * CTRL_S start editing over - current line; * CTRL_U change all data in the current line to Upper Case; * CTRL_X erase all characters to the end of the current line; * CTRL_Y delete the current line; Section III. User Reference Page 67 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * CTRL_ENTER, F3, ESC end editing, saving all changes. The memo window is popped down. As you can see above, the F3 and ESC keys do not cancel the changes when used in a memo field. However, if you want to cancel any changes that you made to the memo field you can press F3 or ESC again to cancel all changes on the data entry panel that contained the memo field. For example, you are on the 'Change Wine' panel and begin to edit the wine Comments memo field. You then realize that you are editing the comments for the wrong wine - or have made a mistake in the comments field. Press F3 or ESC to pop down the memo window and now press F3 or ESC again. All changes made on the change wine panel - including the changes to the comments memo field - will be cancelled and you can start over. Page 68 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.2.6. SCROLLABLE LIST PANELS At the heart of VINO:FILE Cellar Master are the scrollable panels - the Wine List, Bottle List and Cross Reference List screens. 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 20) 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 record which can be selected by using the record pointer at the left side of the screen. The following keys are used 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 one screen full; * PgDn scroll down one screen full; * Home scroll to the top of the list. With the pointer set to the desired record, the user can perform many actions on it. These action keys are listed on the status line. Pressing ENTER is always the same as 'S' for select. 3.2.7. 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. Section III. User Reference Page 69 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3. VINO:FILE PANEL REFERENCE 3.3.1. THE WINE SEARCH PANEL The Wine Search panel is the first displayed when VINO:FILE is started. It is shown on page 12. FUNCTION: The Wine Search panel allows the user to enter field values to be used when searching the wine database. This determines which wines are displayed in the 'Wine List'. All field arguments are ANDed together to create the search argument. GENERAL KEY FUNCTIONS: See 'Data Entry Panels' in the previous section for a description of the cursor movement keys - up arrow, down arrow, TAB, SHIFT_TAB, CTRL_HOME. In addition to these keys, pressing 'PgDn' will clear all fields to their default values. MENU: The Main Menu is available by pressing F10 or ALT plus the first letter of the desired option. DEFAULT VALUES: BOTTLES - default is set in the Configuration file. Change using 'Set Configuration' on the Summary menu. BOTTLES SEARCH TYPE - defaults to >= (displays blank). All wines with more bottles (or the same number) as the BOTTLES field will be displayed in the wine list. Page 70 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 DATA FIELDS: All fields, with the exception of the "Bottles Search Type" field are directly related to fields of the same name in the wine or bottle record. If a value is entered then only wines which match that value in that field are displayed in the Wine List. The wild card character '*' can be used at the end of any alphanumeric field to match any remaining characters. For example, entering a Company of 'P*' will match any winery that begins with the letter 'P'. BOTTLES is an integer field which will take numeric whole numbers from 0 to 999. It is right justified on the screen but the user can 'type past' the end of the field - until all 3 positions are filled. BOTTLES SEARCH TYPE can take the values '=', '<' and ' ' (blank - which is equivalent to '>='). This field determines how the bottles field is used in the wine search. '=' means that only wines where exactly BOTTLES bottles are in the cellar are displayed. '<' means fewer than the BOTTLES value, ' ' means greater than or equal to BOTTLES bottles in the cellar. All other fields are alphanumeric fields, upper case with all printable characters allowed. COMPANY, OTHER INFO, VARIETY, COUNTRY, STATE and DISTRICT are 20 characters long. YEAR, DRINK BY and YEAR READY are 4 characters long. LOCATION is 8 characters long. FLAG is one character long. NEXT PANEL: When all desired field entries have been entered, pressing ENTER or CTRL_ENTER will perform the search of the database and display the Wine List Panel. QUITTING VINO:FILE: Press F10 and select Quit, or press ALT_Q (press ALT and Q together) to end your VINO:FILE session. Section III. User Reference Page 71 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.2. THE WINE LIST FUNCTION: The Wine List panel lists wine records in the database, restricted according to the arguments which were entered on the 'Wine Search' panel. The Wine List panel is pictured on page 17. GENERAL KEY FUNCTIONS: See 'Scrollable List Panels' in the previous section for the cursor movement keys - up and down arrows, PgUp, PgDn and HOME. DISPLAYED FIELDS: For each wine record the following fields are displayed: * COMPANY the name of the winery or shipper; * OTHER INFORMATION a field to further identify the particular wine; * VARIETY the grape variety; * YEAR the year of vintage, if applicable; * NUM the number of bottles of the wine in the cellar. ACTION KEYS: The action keys act on the current wine - which is indicated by the triangular 'pointer' at the left side of the list. The options are listed on the status line: * 'S' (or ENTER) selects the current record and displays the Bottle List Panel; * 'C' displays the Change Wine Panel to change wine record fields; Page 72 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * 'A' displays the 'Add Bottles' Panel to add more bottles of that wine, * 'D' delete the wine record (and all associated bottles). A confirm window is first displayed - you must then enter 'Y' for the record to be deleted. * 'F' finds a particular company name in the list. The Find Wine Panel is displayed. MENU: The Main Menu is available by pressing F10 or ALT plus the first letter of the desired option. DEFAULT VALUES: None. QUITTING VINO:FILE: Press F10 and select Quit, or press ALT_Q (press ALT and Q together) to end your VINO:FILE session. Section III. User Reference Page 73 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.3. CHANGE WINE PANEL FUNCTION: The Change Wine panel allows the user to change existing field values for the wine record which was selected from the Wine List. GENERAL KEY FUNCTIONS: See 'Data Entry Panels' in the previous section for a description of the cursor movement keys - up arrow, down arrow, TAB, SHIFT_TAB, CTRL_HOME. MENU: The Main Menu is NOT available from this panel. DEFAULT VALUES: All fields contain their current values (as stored in the current wine record) when the panel is displayed. DATA FIELDS: COMPANY, OTHER INFO, and VARIETY are 20 character alphanumeric - forced to upper case. YEAR is 4 characters alphanumeric - forced to upper case. COUNTRY, STATE and DISTRICT are 20 character alphanumeric - forced to upper case. CATEGORY is two characters alphanumeric - forced to upper case. See page 29 for suggested values. DRINK BY and YEAR READY are 4 character alphanumeric - forced to upper case. FLAG is one character alphanumeric - forced to upper case. COMMENTS is a memo field - see page 65. Page 74 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 NEXT PANEL: When all desired field entries have been entered, pressing CTRL_ENTER (or ENTER in the comments field) will accept the changed values and return you to the Wine List. Pressing F3 or ESC at any time will cancel any changes that have been made and return the user to the Wine List. Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | CHANGE WINE DETAILS | | | | Current Wine Database: SAMPLE | | | +------------------------------------------------------------------------------| | | | | | Company: PENFOLDS Other Info: GRANGE HERMITAGE | | Variety: SHIRAZ Year: 1978 | | | | | | District: BAROSSA VALLEY State: STH AUST | | Country: AUSTRALIA | | | | | | Category: DR Flag: | | Year Ready: Drink By: | | | | Comments: | | | | | +------------------------------------------------------------------------------+ F1 : Help CTRL_ENTER : Accept Fields F3/ESC - Cancel Section III. User Reference Page 75 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.4. ADD BOTTLES PANEL FUNCTION: When selected from the Wine List the Add Bottles panel allows the user to add more bottles of a wine that is already in the database - the wine is the one that was selected on the Wine List. The Add Bottles panel is also displayed following the 'Add Wine' panel to enter the bottle values for a new wine being added to the database. The Add Bottles panel is pictured on page 31. GENERAL KEY FUNCTIONS: See 'Data Entry Panels' in the previous section for a description of the cursor movement keys - up arrow, down arrow, TAB, SHIFT_TAB, CTRL_HOME. In addition the PgUp key will recall the values of the last bottle that was entered - this may save some typing when entering a number of wines and bottles which were purchased on the same day. The PgDn key restores all fields to their default values - clearing those fields which do not have defaults. MENU: The Main Menu is NOT available from this panel. DEFAULT VALUES: NUMBER OF BOTTLES defaults to 1. DATE OF PURCHASE defaults to the current date. COST PER BOTTLE initially set at 0.00. SIZE OF BOTTLE defaults to 750 (ml). Page 76 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 DATA FIELDS: NUMBER OF BOTTLES is a 3-digit integer which can take values from 1 to 999. DATE OF PURCHASE is a date field. Date fields are edited in 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. Only valid dates are allowed. COST PER BOTTLE is a 3.2 format real number. That is there must be always 2 digits after the decimal point and up to 3 before. This field can take values from 0.00 to 999.99. ORIGIN is a 20 character alphanumeric - forced to upper case. CELLAR LOCATION is an 8 character alphanumeric - forced to upper case. NEXT PANEL: When all desired field entries have been entered, pressing CTRL_ENTER (or ENTER in the comments field) will accept the changed values and return you to the Wine List or Add Wine panels - whichever called up Add Bottles. Pressing F3 or ESC at any time will cancel any changes that have been made and return the user to the calling panel. Section III. User Reference Page 77 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.5. FIND WINE PANEL FUNCTION: The Find Wine panel allows the user to search for a specific company name in the Wine List - without having to use the scroll keys to locate it. DATA FIELDS: There is only one data field - the COMPANY to search for. This is 20 character alphanumeric. If you enter the full name of a company (e.g: ROBERT MONDAVI) then the list will be searched. If that company is not present in the list an error message will be displayed and you can re- enter the company name. Pressing ESC or F3 will return you to the Wine List with the cursor positioned at the point where that company would be inserted. If you enter a partial name (e.g: ROB*) then the Wine List will be displayed immediately with the cursor positioned to the insert position for that name - whether it is in the list or not. This provides a quicker method of jumping quickly to an approximate position in a long list. Page 78 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | WINE LIST | | | | Current Wine Database: SAMPLE | | | +- Company ------------ Other Information -- Variety ------------ Year --- Num | |> ACACIA PINOT NOIR 1985 3 | | BAILEYS +--------------------------------------+ 3 | | BAILEYS ASD | FIND WINE | 1 | | BAILEYS ASD | --------- | 1 | | BAILEYS ASD | | 1 | | BAILEYS HJT | Enter Company Name | 5 | | BALGOWNIE | ==> | 11 | | BEAULIEU VINEYARDS RUTHERFORD| | 10 | | BEYCHEVILLE +--------------------------------------+ 1 | | BIONDI-SANTI BRUNELLO DI MONTALCI 1982 1 | | BUENA VISTA CARNEROS CABERNET SAUVIGNON 1985 0 | | CALLAWAY CALLA LEES CHARDONNAY 1988 1 | | CAYMUS VINEYARDS CABERNET SAUVIGNON 1985 1 | | CHATEAU STE MICHELLE WASHINGTON RIESLING 1988 1 | | CHRISTIAN BROTHERS CABERNET SAUVIGNON 1985 1 | | DRC LA TACHE 1985 1 | +------------------------------------------------------------------------------+ S: Select C: Change A: Add Bottles D:Delete F:Find PGDN Section III. User Reference Page 79 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.6. THE BOTTLE LIST FUNCTION: The Bottle List panel lists bottle records in the database, corresponding to the wine record which was selected on the Wine List. GENERAL KEY FUNCTIONS: See 'Scrollable List Panels' in the previous section for the cursor movement keys - up and down arrows, PgUp, PgDn and HOME. In addition the F2 key allows you to browse the Wine Comments field in full. DISPLAYED FIELDS: For each wine record the following fields are displayed: * # (Number) number of bottles; * SIZE size of each bottle in ml; * BOUGHT the purchase date; * COST the purchase price, per bottle; * ORIGIN where the bottles were bought; * LOCATION the cellar location where these bottles are stored; * DRUNK the date when these bottles were consumed (if applicable); * POINTS the point rating for wines which have been drunk. Note that date fields can be displayed as mm.dd.yy, dd/mm/yy or yy/mm/dd depending on the Date Format option set in the configuration. Use 'Change Configuration' on the Summary menu to change. Page 80 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 ACTION KEYS: The action keys act on the current wine - which is indicated by the triangular 'pointer' at the left side of the list. The options are listed on the status line: * 'S', 'C' (or ENTER) displays the Change Bottle Panel to change bottle record fields; * 'D' displays the 'Drink Bottles' Panel to enter information for bottles of wine that have been drunk, * 'L' delete the bottle record. A confirm window is first displayed - you must then enter 'Y' for the record to be deleted. MENU: The Main Menu is available by pressing F10 or ALT plus the first letter of the desired option. DEFAULT VALUES: None. QUITTING VINO:FILE: Press F10, Q or ALT_Q (press ALT and Q together) to end your VINO:FILE session. Section III. User Reference Page 81 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.7. CHANGE BOTTLE PANEL FUNCTION: The Change Bottle panel allows the user to change existing field values for the bottle record which was selected from the Bottle List. The panel is pictured on page 23. GENERAL KEY FUNCTIONS: See 'Data Entry Panels' in the previous section for a description of the cursor movement keys - up arrow, down arrow, TAB, SHIFT_TAB, CTRL_HOME. MENU: The Main Menu is NOT available from this panel. DEFAULT VALUES: All fields contain their current values (as stored in the current bottle record) when the panel is displayed. DATA FIELDS: CHANGE ALL BOTTLES ? - allows the user to specify whether the changed fields should apply to all the bottles represented by this bottle record or not. Enter 'Y' or 'N'. If 'N' is entered then the meaning of the second field is changed (see below) and the user MUST also change one of the bottle key fields (Purchase Date, Size, Location or Date Drunk). NUMBER OF BOTTLES / NUMBER TO CHANGE - If the user is changing all bottles then changing this integer field changes the number of bottles represented by the record. If the user is not changing all bottles then this number represents the number of bottles that will take the changed values. PURCHASE DATE - date field. Date fields are edited in 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. Only valid dates are allowed. Page 82 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 COST PER BOTTLE - a 3.2 format real number. That is, there must be always 2 digits after the decimal point and up to 3 before. This field can take values from 0.00 to 999.99. SIZE OF BOTTLE - a 4-digit integer which can take values from 0 to 9999. ORIGIN - a 20 character alphanumeric - forced to upper case. CELLAR LOCATION - an 8 character alphanumeric - forced to upper case. VALUE PER BOTTLE - a 3.2 format real number. That is, there must be always 2 digits after the decimal point and up to 3 before. This field can take values from 0.00 to 999.99. The value is initially set to be the same as the cost of the bottle. The remaining fields are displayed only if these bottles of wine have been drunk: DATE DRUNK - date field. Date fields are edited in 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. Only valid dates are allowed. OCCASION - a text memo field for recording the occasion at which the wine was drunk. TASTE - a text memo field for tasting notes. POINTS - a 2.1 format real number. That is there must be always 1 digit after the decimal point and up to 2 before. This field can take values from 0.0 to 99.9. NEXT PANEL: When all desired field entries have been entered, pressing CTRL_ENTER (or ENTER in the points field) will accept the changed values and return you to the Bottle List. Pressing F3 or ESC at any time will cancel any changes that have been made and return the user to the Bottle List. Section III. User Reference Page 83 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.8. DRINK BOTTLES PANEL FUNCTION: The Drink Bottle panel allows the user to enter information for bottles of wine which have been drunk. This panel is pictured on page 25. GENERAL KEY FUNCTIONS: See 'Data Entry Panels' in the previous section for a description of the cursor movement keys - up arrow, down arrow, TAB, SHIFT_TAB, CTRL_HOME. MENU: The Main Menu is NOT available from this panel. DEFAULT VALUES: NUMBER DRUNK - defaults to 1. DATE DRUNK - defaults to the current date. DATA FIELDS: NUMBER DRUNK - this 3-digit integer field represents the number of bottles that have been drunk at this time. DATE DRUNK - date field. Date fields are edited in 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. Only valid dates are allowed. OCCASION - a text memo field for recording the occasion at which the wine was drunk. TASTE - a text memo field for tasting notes. POINTS - a 2.1 format real number. That is there must be always 1 digit after the decimal point and up to 2 before. This field can take values from 0.0 to 99.9. Page 84 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 NEXT PANEL: When all desired field entries have been entered, pressing CTRL_ENTER (or ENTER in the comments field) will accept the changed values and return you to the Bottle List. Pressing F3 or ESC at any time will cancel any changes that have been made and return the user to the Bottle List. Section III. User Reference Page 85 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.9. THE CROSS REFERENCE LIST BY COMPANY FUNCTION: The Cross Reference (XRef) List by Company panel lists XRef records. The entries are organized and sorted by Company. It is displayed from the Cross Reference Menu (an option on the Main Menu). This panel is pictured on page 50. GENERAL KEY FUNCTIONS: See 'Scrollable List Panels' in the previous section for the cursor movement keys - up and down arrows, PgUp, PgDn and HOME. To toggle the display between 'List By Company' and 'List By District' press F2. DISPLAYED FIELDS: For each Cross Reference Company record the following fields are displayed: * COMPANY the name of the winery or shipper; * WINE / VINEYARD a field to further identify the origin of the particular wine; * DISTRICT the geographical district where the wine comes from (can be blank for wines blended from more than one district). To see the STATE and COUNTRY fields for a company, use the 'S' or 'C' action key. ACTION KEYS: The action keys act on the current entry - which is indicated by the triangular 'pointer' at the left side of the list. The options are listed on the status line: * 'S', 'C' (or ENTER) selects the current entry and displays the Change XRef Panel; Page 86 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * 'A' displays the 'Add XRef' Panel to add Cross Reference entries to the file, * 'D' delete the Cross Reference Entry. A confirm window is first displayed - you must then enter 'Y' for the record to be deleted. * 'F' finds a particular company name in the list. The Find XRef Panel is displayed. Section III. User Reference Page 87 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.10. THE CROSS REFERENCE LIST BY DISTRICT FUNCTION: The Cross Reference (XRef) List by District panel lists XRef records. The entries are organized and sorted by District. It is displayed from the Cross Reference Menu (an option on the Main Menu). This panel is pictured on page 53. GENERAL KEY FUNCTIONS: See 'Scrollable List Panels' in the previous section for the cursor movement keys - up and down arrows, PgUp, PgDn and HOME. To toggle the display between 'List By Company' and 'List By District' press F2. DISPLAYED FIELDS: For each Cross Reference Company record the following fields are displayed: * DISTRICT the geographical district where the wine comes from (can be blank for wines blended from more than one district). * STATE the state (or major wine growing district) where that district is located. * COUNTRY the country where that state is located. ACTION KEYS: The action keys act on the current entry - which is indicated by the triangular 'pointer' at the left side of the list. The options are listed on the status line: * 'S', (or ENTER) selects the current entry and displays the XRef District SubList Panel; Page 88 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * 'C' selects the current entry and displays the Change XRef Panel; * 'A' displays the 'Add XRef' Panel to add Cross Reference entries to the file, * 'D' delete the Cross Reference Entry. A confirm window is first displayed - you must then enter 'Y' for the record to be deleted. * 'F' finds a particular company name in the list. The Find XRef Panel is displayed. Section III. User Reference Page 89 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.11. THE CROSS REFERENCE DISTRICT SUBLIST FUNCTION: The Cross Reference District SubList panel lists companies located in a particular geographic district selected on the XRef by District panel. This panel is pictured on page 54. GENERAL KEY FUNCTIONS: See 'Scrollable List Panels' in the previous section for the cursor movement keys - up and down arrows, PgUp, PgDn and HOME. DISPLAYED FIELDS: For each Company located in the currently selected district the following fields are displayed: * COMPANY the name of the winery or shipper; * WINE / VINEYARD a field to further identify the origin of the particular wine; To see the STATE and COUNTRY fields for a company, use the 'S' or 'C' action key (below). ACTION KEYS: The action keys act on the current entry - which is indicated by the triangular 'pointer' at the left side of the list. The options are listed on the status line: * 'S', 'C' (or ENTER) selects the current entry and displays the Change XRef Panel; * 'D' delete the Cross Reference Entry. A confirm window is first displayed - you must then enter 'Y' for the record to be deleted. Page 90 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Section III. User Reference Page 91 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.12. CHANGING A CROSS REFERENCE RECORD FUNCTION: The Change XRef panel allows the user to change existing field values for the Cross Reference entry which was selected from the XRef List whether listed by company, by district or on the sublist. GENERAL KEY FUNCTIONS: See 'Data Entry Panels' in the previous section for a description of the cursor movement keys - up arrow, down arrow, TAB, SHIFT_TAB, CTRL_HOME. MENU: The Main Menu is NOT available from this panel. DEFAULT VALUES: All fields contain their current values (as stored in the current XRef entry) when the panel is displayed. DATA FIELDS: COMPANY and OTHER INFO are 20 character alphanumeric - forced to upper case. These fields are NOT displayed when Change XRef was called up from the 'Cross Reference List by District' panel - in this case ALL companies are changed. COUNTRY, STATE and DISTRICT are 20 character alphanumeric - forced to upper case. NEXT PANEL: When all desired field entries have been entered, pressing CTRL_ENTER (or ENTER in the comments field) will accept the changed values and return you to the XRef List. Pressing F3 or ESC at any time will cancel any changes that have been made and return the user to the XRef List. Page 92 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.3.13. FINDING A CROSS REFERENCE RECORD FUNCTION: The Find XRef panel allows the user to search for a specific company (By Company) or district (By District) name in the XRef List - without having to use the scroll keys to locate it. DATA FIELDS: There is only one data field - the COMPANY or DISTRICT to search for. This is 20 character alphanumeric. If you enter the full name then the list will be searched. If that company / district is not present in the list an error message will be displayed and you can re-enter the name. Pressing ESC or F3 will return you to the XRef List with the cursor positioned at the point where that company / district would be inserted. If you enter a partial name (with a wild card '*' character) then the XRef List will be displayed immediately with the cursor positioned to the insert position for that name - whether it is in the list or not. This provides a quicker method of jumping quickly to an approximate position in a long list. Section III. User Reference Page 93 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------------------------------------+ | CROSS REFERENCE LIST | | BY DISTRICT | | | | F2 SWAPS SORT ORDER XRef File: WINE.XRF | +------ District ------------- State -------------------- Country -------------| | CALIFORNIA USA | | CHAM+--------------------------------------+ | | CHAT| FIND XREF ENTRY | | | COTE| | | | SOUT| Enter District | | | WASH| ==> | | |> BAROLO PIEM| | | | BAROSSA VALLEY SOUT| | | | BLENHEIM SOUT+--------------------------------------+ | | BRUNELLO DI MONTALCI TUSCANY ITALY | | CENTRAL VICTORIA VICTORIA AUSTRALIA | | CHIANTI TUSCANY ITALY | | COONAWARRA SOUTH AUSTRALIA AUSTRALIA | | COTE ROTIE COTES DU RHONE FRANCE | | FINGER LAKES NEW YORK USA | | FLEURIE BEAUJOLAIS FRANCE | +------------------------------------------------------------------------------+ S: Select C: Change A: Add XRef Entry D:Delete F:Find PGDN Page 94 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4. VINO:FILE MENU REFERENCE 3.4.1. THE FILES MENU The files menu allows several functions to be performed on your VINO:FILE Wine Databases - like saving them or loading new databases from your disks. Note that saving and loading Cross Reference files from hard disk is done on the XRef menu. Files Add Summary Print XRef Quit ++----------------------+------------------------------------------------------+ || Open New Database |-----------------------------------+ | || Save Database | V I N O : F I L E | - XRef - | || Save Database As ... | C E L L A R M A S T E R | WINE | || Clear Database |-----------------------------------+ | || Change Directory | | || Shell to DOS | WINE SEARCH - ENTER ARGUMENTS | |+----------------------+ | | COMPANY ==> COUNTRY ==> | | | | OTHER INFO ==> STATE ==> | | | | VARIETY ==> DISTRICT ==> | | | | YEAR ==> CATEGORY ==> | | | | LOCATION ==> FLAG ==> | | | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ Choose item using the arrow keys ^ v | Press ESC to abort | Press <+ when done 3.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, a window will be displayed showing the current database and asking you to enter two fields: Section III. User Reference Page 95 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * 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 be given 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. No other options are allowed. * New Database 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 in the field then a directory window will be displayed (shown in the picture below). Select a database from the list using the up and down arrow keys to move the highlight bar and press ENTER. The entry "..\" in the directory list allows you to move up the directory hierarchy to choose a database file from another directory. Be careful here, even if you choose a database from a different directory the 'Current Data Directory' is not changed - so when you save the database it will go to the current directory not the directory where it was loaded from. To change the current data directory there is a 'Choose Directory' option on the Files Menu - see section 3.4.1.1.1. Page 96 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit ++----------------------+------------------------------------------------------+ || +--------------------------------------------------+----+--------------+ | || | LOAD NEW DATABASE | | USA .DBA | - | || | | | AUSSIE .DBA | | || | Current Wine Database Name: SAMPLE |----| SAMPLE .DBA | | || | | | NEWWINE .DBA | | || | Load Option (NEW or MERGE) ==> NEW | | WINE .DBA | | |+-| | | ..\ | | | | NEW Wine Database Name ==> | | | | | | | | | | | | | | | | | | Leave New Name Blank for Directory | | | | | +--------------------------------------------------+ +--------------+ | | | | YEAR ==> CATEGORY ==> | | | | LOCATION ==> FLAG ==> | | | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ Use ^ and v to position, Select file with ENTER. ESC/F3 to CANCEL Section III. User Reference Page 97 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.1.2. SAVE DATABASE This option saves the current wine database to disk - replacing any previous version that may already be on your disk. 3.4.1.3. SAVE DATABASE WITH A NEW NAME If you do not want to overwrite an existing database on disk - or you want to change the name of the current database for any other reason - then choose the 'Save Database As ...' option on the File Menu. You will then be asked to type a new name for the database. The new name must be a valid DOS file name - without the .DBA extension. If a database of this name already exists on the disk you will be warned - you can then overwrite the existing file or choose another name. Files Add Summary Print XRef Quit ++----------------------+------------------------------------------------------+ || +--------------------------------------------------+-----+ | || | | | - XRef - | || | Current Wine Database Name: SAMPLE | | WINE | || | |-----+ | || | NEW Wine Database Name ==> | | || | | | |+-| | | | | | | | +--------------------------------------------------+ | | OTHER INFO ==> STATE ==> | | | | VARIETY ==> DISTRICT ==> | | | | YEAR ==> CATEGORY ==> | | | | LOCATION ==> FLAG ==> | | | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ F3/ESC to Cancel 3.4.1.4. CLEAR DATABASE Page 98 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 To start a new wine database from scratch - erasing the current database in memory - choose 'Clear Database' on the Files Menu. If you have made changes to the current database since it was last saved to disk then you will be given the option to save it before the database is cleared. Section III. User Reference Page 99 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.1.5. CHANGE DATA DIRECTORY By default, all data files - Wine databases and XRef files - are expected to be in the 'Current Data Directory'. If you keep all your databases and Cross Reference files in one directory then you will not need to use this option. The current directory at start-up is set from the database specified on the command line (if one was specified) or from the configuration file otherwise. However, it may sometimes be necessary to load or save files from other directories. You can make another directory the current directory by choosing 'Change Directory' on the Files Menu. Files will be loaded from the Current Data Directory unless you use the directory window to move to a different directory. Selecting a different directory like this does not reset the current directory. Files will always be saved to the Current Data Directory. The current directory should contain both the wine database AND the Cross Reference file at all times. Be very careful changing directories. If you still want to change the directory after considering all of the above then just type in a valid DOS directory name (e.g: C:\VINOFILE\TEMPDATA). Page 100 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit ++----------------------+------------------------------------------------------+ || Open N+-------------------------------------------------++ | || Save D| CHANGE DATA DIRECTORY || - XRef - | || Save D| --------------------- || WINE | || Clear | |+ | || Change| Search Path for Wine Databases | | || Shell | and Cross Reference Files: | | |+-------| | | | COMP| C:\TURBO\TP\DATA\ | | | | | | | OTHE| WARNING - The Wine Database and Cross Reference | | | | files should always be in the same directory. | | | VARI+-------------------------------------------------+ | | | | YEAR ==> CATEGORY ==> | | | | LOCATION ==> FLAG ==> | | | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ ENTER - Accept Changes F3,ESC - Cancel Section III. User Reference Page 101 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.1.6. 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. When you have finished entering DOS commands and want to return to VINO:FILE you must type 'EXIT' at the DOS prompt. It is wise to save your database and XRef files before shelling to DOS. 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) memory available in your computer then VINO:FILE will swap itself into the EMS memory. If you do not have EMS 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 or enough free space on disk then it will not allow you to shell to DOS. 3.4.2. THE ADD MENU There is only one option on the Add Menu - Add Wines. See 'The Add Wine Panel' above for details. Page 102 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.3. THE SUMMARY MENU Options on the Summary Menu allow you to display summaries of VINO:FILE's operation, the wine database and XRef that are loaded. Other general functions are also on this menu. Files Add Summary Print XRef Quit +------------------------+----------------------+------------------------------+ | +----| Database Summary |-----------+ | | - Database - | | Current List Summary | | - XRef - | | SAMPLE | | Change Configuration | E R | WINE | | +----| About VINO:FILE |-----------+ | | +----------------------+ | | WINE SEARCH - ENTER ARGUMENTS | | | | COMPANY ==> COUNTRY ==> | | | | OTHER INFO ==> STATE ==> | | | | VARIETY ==> DISTRICT ==> | | | | YEAR ==> CATEGORY ==> | | | | LOCATION ==> FLAG ==> | | | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ Choose item using the arrow keys ^ v | Press ESC to abort | Press <+ when done 3.4.3.1. DATABASE SUMMARY SCREEN The "Database Summary" option on the Summary Menu displays statistical information about VINO:FILE and the wine database that is currently loaded. This includes the number of wine records, bottle records and text records that are in the database, the number of bottles that these records represent, and the total cost. The same information is provided for wines and bottles that are currently in the cellar (i.e: wines that have not been drunk). Section III. User Reference Page 103 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Also memory usage figures are shown - if you are running short of free memory then you should consider removing some TSR's or breaking your database into multiple smaller files. See page 38 for a picture of the Database Summary panel. Page 104 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.3.2. CURRENT LIST SUMMARY The "List Summary" displays statistical information about the wines currently listed - restricted by entering search criteria on the Wine Search panel. Files Add Summary Print XRef Quit +------------------------+----------------------+------------------------------+ | | Database Summary | | | +----------------------------------------------------------+ | | | | | | | SUMMARY OF LIST CONTENTS | | +- Compan| ------------------------ |r --- Num | |> ACACIA| |5 3 | | BEAULI| |5 10 | | CALLAW| Contents of Current Search List Only |8 1 | | CAYMUS| |5 1 | | CHATEA| |8 1 | | CHRIST| Number of Wine Records in List: 12 |5 1 | | FETZER| |8 1 | | FIREST| Number of these Wines in the Cellar: 12 |4 1 | | FROG'S| |7 1 | | HERON | Number of these Bottles in the Cellar: 25 |7 1 | | HOGUE | |8 1 | | RUTHER| |7 3 | | +----------------------------------------------------------+ | | | | | | | +------------------------------------------------------------------------------+ Press Any Key to Continue Section III. User Reference Page 105 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.3.3. CHANGE CONFIGURATION All of the information that VINO:FILE needs at start-up time is stored in a configuration file on your disk. To change information in the configuration choose 'Change Configuration' from the Summary Menu. See page 41 for a picture of the Change Configuration panel. The data fields are as follows: * CURRENCY SYMBOL is a single character. Any printable ASCII character is allowed. International users should enter their currency character. * DATE FORMAT can take the values 'MDY', 'DMY' and 'YMD' only. * PRINTER TYPE can take the values 'NONE', 'EPSON', 'HPLJ' or 'HPLJ+' only. * PRINTER PORT can take the values 'LPT1', 'LPT2', 'LPT3' or 'FILE' only. * INITIAL DATABASE and INITIAL XREF are 8 character fields - only valid DOS file names (without any extension) should be entered. * VIDEO MODE can take the values 'C', 'L' or 'M' only. * BOTTLE SEARCH DEFAULT Page 106 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 is an integer field and can take any numeric value between 0 and 999 inclusive. * TEMPORARY FILES DIRECTORY and INITIAL DATA DIRERCTORY require a valid DOS directory name (e.g: C:\VINOFILE\TEMPDIR). Section III. User Reference Page 107 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.3.4. ABOUT VINO:FILE Choose 'About VINO:FILE' on the Summary menu to see details about the program such as the version number, copyright information, support and registration details. If your copy of VINO:FILE is not registered then you can print out a registration form by pressing 'Y'. Files Add Summary Print XRef Quit +------------------------+----------------------+------------------------------+ | +----| Database Summary |-----------+ | | - D+--------------------------------------------------------------+ef - | | | |NE | | | <<< V I N O : F I L E >>> | | | | <<< C E L L A R M A S T E R >>> | | | | Version 2.1 | | | | | | | CO| Copyright MARK CHRISTIAN 1986, 1989, 1990. | | | | San Francisco, California; Melbourne, Australia; | | | OT| Member of the Association of Shareware Professionals. | | | | | | | VA| VINO:FILE is SHAREWARE, supported by the author | | | | on Compuserve - via Wineforum or Easyplex to ID | | | YE| [70032,117] - see the manual for details. | | | | | | | LO| VINO:FILE is a program for managing your Wine Cellar. | | | | | | | YE| This is an UNREGISTERED VERSION of VINO:FILE. | | | | Please REGISTER if you continue to use this program. | | | BO+--------------------------------------------------------------+ | | | +------------------------------------------------------------------------------+ To print out a registration form PRESS Y NOW. Any key to continue... Page 108 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.4. THE PRINT MENU Printing wine database reports is done on the Print Menu. Note that printing Cross Reference reports is done on the Xref Menu. Files Add Summary Print XRef Quit +------------------------------------+----------------------+------------------+ | +----------------| Print Database | | | - Database - | V I N| Print Current List | - XRef - | | SAMPLE | C E L L A| Printer Setup | WINE | | +----------------+----------------------+ | | | | WINE SEARCH - ENTER ARGUMENTS | | | | COMPANY ==> COUNTRY ==> | | | | OTHER INFO ==> STATE ==> | | | | VARIETY ==> DISTRICT ==> | | | | YEAR ==> CATEGORY ==> | | | | LOCATION ==> FLAG ==> | | | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ Choose item using the arrow keys ^ v | Press ESC to abort | Press <+ when done 3.4.4.1. PRINT THE DATABASE Choose 'Print Database' on the Print Menu to print reports on all wines in the current wine database. This panel is pictured on page 47. On the second line the source (DATABASE) is displayed. Also displayed is the current printer setup information (such as 'NONE to FILE') which shows what sort of formatting will be done and where the output will be directed. To change this, press ESC and choose 'Printer Setup' on the Print Menu. Section III. User Reference Page 109 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 The fields that you enter on the Print Database panel are: * PRINT WINE DETAILS requires you to enter 'Y' or 'N'. If you enter 'Y' then all fields are printed for every wine record. If you choose 'N' then only the Company, Other Info, Variety, Year, Number of Bottles and the location of the first bottle are printed. * PRINT BOTTLE DETAILS requires you to enter 'Y' or 'N'. If you enter 'Y' then all fields are printed for every bottle record. If you choose 'N' then the Occasion and Tasting Notes are NOT printed. * HEADER 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 setup VINO:FILE to print to a file. Enter a DOS filename - with extension. Page 110 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.4.2. PRINT THE CURRENT LIST If you choose 'Print Current List' on the Print menu then the same panel is displayed as for 'Print Database' above. The difference is that you will see 'Source : List' and only records that are currently displayed in the wine list - determined by the criteria you entered on the WIne Search panel will be printed. 3.4.4.3. PRINTER SETUP VINO:FILE can print reports to several different printers and use the capabilities of these printers are used to provide formatting (bold characters, different fonts) for the report. To specify what sort of printer you have, and which port on your computer it is attached to choose 'Printer Setup' on the Print Menu. The panel displayed is pictured on page 46. The fields are: * PRINTER TYPE can take the values 'EPSON', 'HPLJ', 'HPLJ+' or 'NONE' only. Enter 'HPLJ+' only if you have an older model LaserJet and do not have a 12 cpi font available (either in the printer or on a font cartridge). * PRINTER PORT can take the values 'LPT1', 'LPT2', 'LPT3' or 'FILE'. VINO:FILE cannot print to serial ports (COM1, COM2 etc). If your printer is attached to a serial port then you will have to use re- directed printing using the DOS MODE command. Consult your DOS manual for details. Section III. User Reference Page 111 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 If you choose 'FILE' then you will be prompted for a filename whenever you print a report. Page 112 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.5. THE CROSS REFERENCE (XREF) MENU All of the functions that act on the VINO:FILE Cross Reference (XRef) file are on the XRef Menu - including loading, saving and printing XRef files. Files Add Summary Print XRef Quit +------------------------------------------------+----------------------+------+ | +----------------------------| List XRef | | | - Database - | V I N O : F I L E| Open New XRef | - | | SAMPLE | C E L L A R M A S T| Save XRef | | | +----------------------------| Print XRef | | | +----------------------+ | | WINE SEARCH - ENTER ARGUMENTS | | | | COMPANY ==> COUNTRY ==> | | | | OTHER INFO ==> STATE ==> | | | | VARIETY ==> DISTRICT ==> | | | | YEAR ==> CATEGORY ==> | | | | LOCATION ==> FLAG ==> | | | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ Choose item using the arrow keys ^ v | Press ESC to abort | Press <+ when done 3.4.5.1. 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 will be displayed showing the current Cross Reference file and asking you to enter two fields: Section III. User Reference Page 113 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 * Load Option Enter 'NEW' (the default) to erase the XRef 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 be given the option to save it before loading the new file. Enter 'MERGE' to keep the current XRef in memory and add all entries from the new Cross Reference file. In this case, any EXACT duplicates will be skipped. No other options are allowed. * New XRef Name The name of the Cross Reference file to be loaded. 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 (shown in the picture below). Select a Cross Reference file from the list using the up and down arrow keys to move the highlight bar and press ENTER. The entry "..\" in the directory list allows you to move up the directory hierarchy to choose a Cross Reference file from another directory. Be careful here, even if you choose a database from a different directory the 'Current Data Directory' is not changed - so when you save the XRef it will go to the current directory not the directory where it was loaded from. To change the current data directory there is a 'Choose Directory' option on the Files Menu - see section 3.4.5.1.1. Page 114 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------+----------------------+------+ | +--------------++--+--------------------------------------------------+ | | | WINE2 .XRF || | LOAD NEW CROSS REFERENCE | - | | | SMALL2 .XRF || | | | | | FULLWINE.XRF |+--| Current Cross Reference Name ==> WINE | | | | WINE .XRF | | | | | | SMALL .XRF | | Load Option (NEW or MERGE) ==> NEW | | | | USA .XRF | | | | | | EUROPE .XRF | | NEW Cross Reference Name ==> | | | | AUSSIE .XRF | | | | | | ..\ | | Leave New Name Blank for Directory | | | | | | DO NOT CHANGE DIRECTORY ON XREF ALONE | | | +--------------+ +--------------------------------------------------+ | | | | YEAR ==> CATEGORY ==> | | | | LOCATION ==> FLAG ==> | | | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 0 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ Use ^ and v to position, Select file with ENTER. ESC/F3 to CANCEL Section III. User Reference Page 115 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.4.5.2. SAVE CROSS REFERENCE FILE This option saves the current Cross Reference file to disk - replacing any previous version that may already be on your disk. 3.4.5.3. PRINT A CROSS REFERENCE REPORT Choose 'Print XRef' on the Print Menu to print reports on all entries in the current Cross Reference file. This panel is pictured on page . Displayed on the second line is the current printer setup information (such as 'NONE to FILE') which shows what sort of formatting will be done and where the output will be directed. To change this, press ESC and choose 'Printer Setup' on the Print Menu. The fields that you enter on the Print XRef panel are: * PRINT BY you can enter 'C' or 'D' to have the report ordered by Company or by District. No other values are allowed. * HEADER 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 setup VINO:FILE to print to a file. Enter a DOS filename - with extension. Page 116 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 Files Add Summary Print XRef Quit +------------------------------------------------+----------------------+------+ | +----------------------------| List XRef | | | - Database - | V I N O : F I L E| Open New XRef | - | | SAMPLE | C E L L A R M A S T| Save XRef | | | +-----------------------------------------------------+ | | | | |---+ | | | CHOOSE PRINT OPTIONS | | | | | | | COMPANY | Printer: NONE to FILE | | | | | | | OTHER INF| Print By Company / District ==> C (C,D) | | | | | | | VARIETY | | | | | | | | YEAR | Heading Text ==> | | | | VINO:FILE Cross Reference Printout | | | LOCATION | | | | +-----------------------------------------------------+ | | YEAR READY ==> DRINK BY ==> | | | | BOTTLES ==> 1 Bottles Search Type ==> | | | +------------------------------------------------------------------------------+ F1 : Help CTRL_ENTER - Accept Fields F3, ESC to Cancel Section III. User Reference Page 117 VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 3.5. THE VINO:FILE DATABASE STRUCTURE The VINO:FILE database is kept in memory while VINO:FILE is running. The database contains three classes of records - wine records, bottle records and text records. Fields in the record which are used internally by VINO:FILE are not listed below (and are not stored on disk between sessions) are not shown below. Note that all alphanumeric characters are stored as UPPER CASE except in text records. This is to make searching on field contents easier. 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): * Company Alphanumeric, 20 characters; * Other Info Alphanumeric, 20 characters; * Variety Alphanumeric, 20 characters; * Year Alphanumeric, 4 characters. Fields in the wine record which are not part of the key but are directly entered & changed by the user are: * District Alphanumeric, 20 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; * Comments A list of text records. Page 118 Section III. User Reference VINO:FILE CELLAR MASTER - VERSION 2.1 - 30 APRIL 1990 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): * DrinkDate Date; * PurchaseDate Date; * Size integer; * Location alphanumeric, 8 characters. Fields in the bottle record which are not part of the key but are directly entered & changed by the user are: * Number integer * Cost real * Origin alphanumeric, 20 characters * Value real * Occasion a list of text records * Taste a list of text records * Points real All text memo fields (wine comments, bottle occasion and tasting notes) are stored as a list of TEXT RECORDS. Each record contains one line of text: * Line Alphanumeric, 70 characters Section III. User Reference Page 119