home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
High Voltage Shareware
/
high1.zip
/
high1
/
DIR22
/
VINOFL.ZIP
/
VINOFILE.TXT
< prev
next >
Wrap
Text File
|
1990-06-05
|
234KB
|
7,062 lines
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
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 US Mail to : Mark Christian,
737 Post Street, Apt 1612,
San Francisco,
CA, 94109.
* Telephone : (415) 441-2695. Please note that the
author will not normally be available at this number
during working hours, but please leave a message and
we will return your call as soon as possible.
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