VINO:FILE CELLAR MASTER Version 2.15 DOCUMENTATION UPDATES October 31st, 1990 Version 2.15 of VINO:FILE fixes several bugs in earlier versions, adds new features and provides several enhancements. (Note that Version 2.14 was an internal version which was never released to the public). This document provides information on all changes since the VINO:FILE manual was written. These documentation updates follow the same order as the users manual and reference the existing section numbers where appropriate. SUMMARY OF CHANGES IN VERSION 2.15: * A change has been made to prevent a problem with corrupted wine database and XRef files experienced by some users. Symptoms included garbage characters on some screens, lock-ups after adding wines or when loading the database. This change is 'transparent to the user' - no documentation updates apply. * Printing Cross Reference files did not work correctly with some printers. No documentation updates apply. * Under some circumstances the wine record pointer was incorrectly positioned when 'Add Wines' was selected from the Wine List. No documentation updates apply. * Fixed a problem where garbage characters were written to the screen when the last entry in the Cross Reference file was deleted. No documentation updates apply. * New IMPORT and EXPORT features have been added. These functions allow you to transfer data to and from other file or data management systems. CONTINUED ON FOLLOWING PAGE . . . DOCUMENTATION UPDATES PAGE 1 VINO:FILE Cellar Master - Version 2.15 * New features have been added for the fleet of finger. Bottles that were marked as drunk in error can now be 'UN-DRUNK' using the 'U' line command on the Bottle List. Wine and bottle records that were deleted in error can now be restored by selecting 'RESTORE DELETED WINES' on the Add Menu. * NEW SEARCH OPTIONS have been added. A 'Search Type' field has been included for 'Year' so that you can search for wines from '>=' or '<=' the search value in the 'Year' field. In addition, the special search characters '*' and '#' have been defined for the 'Year Ready' and 'Drink By' fields. * Several enhancements have been made to printed reports. The IBM PROPRINTER family are now fully supported; the DEFAULT PRINT HEADER can now be set on the Change Configuration panel; the ability to CANCEL PRINTOUTS by pressing CTRL_C has been added; and a REPORT SUMMARY is now printed after each report giving the search criteria and statistics for that report. * When SHELL TO DOS is selected from the File menu, a message is now displayed on the DOS screen informing the user the type of shell (to EMS, XMS or Disk), the amount of memory available, and how to return to VINO:FILE. The program will now use XMS (Extended Memory managed by HIMEM. SYS or similar memory managers) when shelling if EMS Expanded memory is not available. * The MEMORY USAGE statistics have been expanded and moved to a separate option on the Summary screen. * The CURRENCY SYMBOL can now be up to 3 characters long and the number of decimal places in the currency field can be adjusted to 0, 1 or 2 to cater for foreign currencies such as Francs (Fr), Deutsche Marks (DM) or Swiss Francs (SFr). * The END key now scrolls to the bottom of all the lists. * An OVERLAY FILE (WINE.OVR) is now included in the VINO:FILE package. Overlays reduce the amount of memory the program needs to run. DOCUMENTATION UPDATES PAGE 2 VINO:FILE Cellar Master - Version 2.15 SECTION II - GETTING STARTED Additions to 2.4.1 'SEARCHING AND DISPLAYING WINE LISTS' A new field has been added - Year Search Type - to allow searches for wines from later or earlier years than the search value. Two special search characters for the 'Year Ready' and 'Drink By' fields are defined. The 'Year Search Type' controls the use of the Year field in a similar way to the Bottles Search Type. Enter '1985' in the Year field and press Enter to search. Only wines from the vintage 1985 will be displayed. Now return to the Search Panel and enter '>' in the 'Year Search Type' field. Now search again and all wines from 1985 AND later years will be listed. Entering '<' will list wines from 1985 and earlier. Finally, you can use the 'Year Ready' and 'Drink By' search fields to identify those wines in your cellar that are in their optimal drinking period. First clear all fields by pressing PgDn and enter '1989' in the Year Ready field. Press Enter to display a list of all wines that became ready to drink in 1989. Clear the Year Ready field and enter '1990' in the Drink By field. Press Enter to display a list of the wines that should be drunk by 1990. There are two special searches in the Year Ready and Drink By fields - '*' which means 'ready' and '#' which means 'not ready'. In the Year Ready field, '*' will display all wines which are ready to drink in the current year or earlier - that is, all wines which are ready to drink. The '#' character will list wines which are not yet ready to drink. In the Drink By field, '*' will display all wines which should be drunk in the current year or later. The '#' character will list wines which have passed their Drink By date - that is, wines that are 'over the hill'. To list all wines which are currently in their optimum drinking period enter '*' in both the Year Ready and Drink By search fields and press Enter. This will display all wines which have passed their Year Ready date and have NOT passed their Drink By date - perfect wines for current drinking! DOCUMENTATION UPDATES PAGE 3 VINO:FILE Cellar Master - Version 2.15 Additions to 2.4.3 'DISPLAYING BOTTLE LISTS' If you mark bottles as having been drunk when they have not been - or delete bottles in error - you can now reverse those mistakes. To the list of actions add: * U Un-drink bottles which were incorrectly marked as drunk. To restore bottles which were deleted from the database choose 'Restore Deleted Wines' from the Add Menu. Additions to 2.4.5 'DRINKING A BOTTLE OF WINE' If you have incorrectly marked a particular bottle record as being drunk - when in fact it has not been - you can now 'Un- Drink' the record: * From the Bottle List screen, place the indicator next to a bottle record which has a drink date, and press the 'U' key. * Check that the existing date fields are correct - that you are un-drinking the correct bottle - and, if so, press 'Y'. To cancel, press 'N', Esc or F3; * Enter the number of bottles to restore which must be less than or equal to the number of bottles currently represented by this record; * Enter the cellar location and, if you like, the value of the bottle. Both these fields are optional. Additions to 2.4.6 'ADDING WINES TO THE DATABASE' The number of digits after the decimal point in the Cost and Value fields can now be changed on the 'Change Configuration' screen. By default there are two decimal digits - as used in American, Australian and British currencies, however you can change this to 0 or 1 for other currencies. DOCUMENTATION UPDATES PAGE 4 VINO:FILE Cellar Master - Version 2.15 New Section 2.4.x 'RESTORING DELETED WINES' If you mistakenly delete wines or bottles from the database you can now restore them - in the same VINO:FILE session only - by selecting 'Restore Deleted Wines' from the Add menu. To test this feature, make sure that you have deleted at least one wine or bottle record, press Alt_A and select that option. VINO:FILE will display a list of the deleted wines. This list works in the same way as the main Wine List, however the only line commands available are: * S or Enter Display the bottle list; * R Restore this record plus all its bottles to the cellar; * F Find a particular wine in the list; When you display the bottle list you will be able to select: * S or Enter Display all fields for this bottle (browse only); * R Restore just this bottle record to the cellar. Additions to 2.4.9 'SUMMARY SCREENS' There are now five options on the Summary menu - 'Memory Usage' has been added. Some memory usage statistics were included on the Database Summary screen in Version 2.13. These figures have been expanded and moved to a new screen. The Memory Usage screen includes information about the three types of memory that you may have in your computer - Standard, Expanded and Extended Memory - and how much of each VINO:FILE is using. All of the database and cross reference information is loaded in Standard memory - the type that comes with your computer when you purchase it. Expanded Memory (EMS) is bought separately and requires an 'Expanded Memory Manager'. VINO:FILE will use this memory to store program and data information when you select 'Shell to DOS' from the File Menu. VINO:FILE will also store the Overlay file here if it can. DOCUMENTATION UPDATES PAGE 5 VINO:FILE Cellar Master - Version 2.15 Extended Memory (XMS) is also a separate item and requires an 'Extended Memory Manager' - HIMEM.SYS is the most common. VINO:FILE will use this memory to store program and data information when shelling to DOS, but only if EMS is not available. Additions to 2.4.10 'CHANGE CONFIGURATION' The Currency Symbol field on the Change Configuration menu can now be up to 3 characters long to accomodate currencies such as Deutsch Marks (DM) and Swiss Francs (SFr) where the standard abbreviation is more than a single character. There are two new configuration fields: * Decimals The number of digits after the decimal point in currency fields. The default value is two - as used in American Dollar, Australian Dollar and British sterling currencies - which means that all currency values can be set to a maximum of 999.99. For currencies that do not usually have two digits after the decimal point, or where values greater than 999.99 per bottle are needed, the number of decimals can be set to 1 or zero. * Print Header The default value for the Heading Text on printed reports. You can still modify the header for each particular report when printing. Additions to 2.4.11 'PRINTED REPORTS' The IBM Proprinter family of printers is now separately supported by VINO:FILE. Enter 'IBM' as the printer type on the Printer Setup screen. Once a report has started printing you can cancel it by pressing CTRL_C - that is, hold down the CTRL key while pressing the C key. You will be asked to confirm that you want to cancel the report. If you answer 'Y' the report will be cancelled immediately. Press any other key to resume the printout. Note that some printers (and software print spoolers) will buffer data before printing it, so the printer may not stop printing immediately. DOCUMENTATION UPDATES PAGE 6 VINO:FILE Cellar Master - Version 2.15 SECTION III - USER REFERENCE Additions to 3.2.6 'SCROLLABLE LIST PANELS' To the list of scroll keys add: * End scroll to the end of the list. Addition to 3.3.1. 'THE WINE SEARCH PANEL' DEFAULT VALUES: YEAR SEARCH TYPE - defaults to = (displays blank). Only wines which match the Year exactly will be listed. DATA FIELDS: YEAR SEARCH TYPE - can take the values '<', '=', or '>'. This field determines how the Year field is used in the wine search. If the search type is '=' or blank then only wines that match the year exactly will be listed. '<' means wines from the specified year or earlier and '>' means wines from the specified year or later. The search type has no effect if the wild card character has been used in the year field (198*, for example). YEAR READY - is a 4 character field. In addition to entering a specific year or a wild card year ('1985' or '198*', for example) you can use the special characters '*' (ready) and '#' (not yet ready). '*' will match wines whose Year Ready dates are less than or equal to the current year. '#' will match wines whose Year Ready dates are greater than the current year. DRINK BY - is a 4 character field. In addition to entering a specific year or a wild card year ('1985' or '198*', for example) you can use the special characters '*' (still ready) and '#' (over the hill). '*' will match wines whose Drink By dates are greater than or equal to the current year. '#' will match wines whose Drink By dates are less than than the current year. DOCUMENTATION UPDATES PAGE 7 VINO:FILE Cellar Master - Version 2.15 Additions to 3.3.4 'ADD BOTTLES PANEL' and 3.3.7 'CHANGE BOTTLE PANEL' The format of the COST and VALUE fields is now determined by the number of Decimals specified on the Change Configuration panel. New Section 3.3.x 'UNDRINK BOTTLES PANEL' FUNCTION: The Drink Bottle panel allows the user to change a bottle record to 'not drunk' for bottles of wine which were incorrectly marked as having been drunk. DEFAULT VALUES: NUMBER TO RESTORE - defaults to the number of bottles represented by this record. VALUE - defaults to the same as the purchase price. DATA FIELDS: NUMBER TO RESTORE - this 3-digit integer field represents the number of bottles that should be changed to 'not drunk'. CELLAR LOCATION - an 8 character alphanumeric - forced to upper case. VALUE PER BOTTLE - a real number in currency format. The number of digits after the decimal point is determined by the 'Decimals' field on the Change Configuration screen. The number of decimal digits can be 0, 1 or 2. NEXT PANEL: When all desired field entries have been entered, pressing CTRL_ENTER (or ENTER in the value 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. DOCUMENTATION UPDATES PAGE 8 VINO:FILE Cellar Master - Version 2.15 New Section 3.3.x 'THE DELETED WINES LIST' FUNCTION: The Deleted Wines List panel lists wine records which have been deleted from the database in this session and allows you to restore them. 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 Deleted Bottles List Panel; * 'R' restore the wine record (and all associated bottles) to the database. A confirm window is first displayed - you must then enter 'Y' for the record to be restored. * 'F' finds a particular company name in the list. The Find Wine Panel is displayed. DOCUMENTATION UPDATES PAGE 9 VINO:FILE Cellar Master - Version 2.15 New Section 3.3.x 'THE DELETED BOTTLES LIST' FUNCTION: The Deleted Bottles List panel lists bottle records which have been deleted from the database, corresponding to the wine record which was selected on the Deleted Wines List. GENERAL KEY FUNCTIONS: See 'Scrollable List Panels' in the previous section for the cursor movement keys - up and down arrows, PgUp, PgDn, HOME and END. In addition the F2 key allows you to browse the Wine Comments field in full. DISPLAYED FIELDS: For each bottle 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 the 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 parameter. Cost and Values are displayed with the chosen Currency Symbol and number of Decimal digits. Use 'Change Configuration' on the Summary menu to change these parameters. DOCUMENTATION UPDATES PAGE 10 VINO:FILE Cellar Master - Version 2.15 ACTION KEYS: The action keys act on the current bottle record - 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) displays the Browse Deleted Bottle Panel to view bottle record fields; * 'R' restore the bottle record to the database. A confirm window is first displayed - you must then enter 'Y' for the record to be restored. New Section 3.3.x 'THE BROWSE DELETED BOTTLE PANEL' FUNCTION: The Browse Deleted Bottle panel allows the user to view the field values for the bottle record (and associated wine record) which was selected from the Deleted Bottles List. None of the field values can be changed on this panel. MEMO FIELDS: The memo fields, if present, can be browsed by pressing the following keys: * F2 Wine comments field; * F4 Bottle Occasion field; * F5 Bottle Tasting Notes field; NEXT PANEL: Pressing ENTER, F3 or ESC will return the user to the Deleted Bottles List. DOCUMENTATION UPDATES PAGE 11 VINO:FILE Cellar Master - Version 2.15 New Section 3.4.1.x 'IMPORT DATABASE FROM FILE' To import a new wine database from a text file on disk choose 'Import File' on the Files Menu. The structure of text files which can be imported is covered in 'IMPORTING & EXPORTING TEXT FILES' starting on page 17 of this document - please read that section before using the Import function. When you select this option, a window will be displayed showing the current database and asking you to enter the following fields: * Load Option Enter 'NEW' (the default) to erase the database currently in memory and then import the new database. 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 import file. In this case, any EXACT duplicates (wines or bottles with the same key fields) will be skipped. * Import File Name The name of the text file to be imported. You can type in the name (with or without an extension, .TXT is assumed). If you press ENTER without typing anything in the field then a directory window will be displayed. Select a file name from the list using the up and down arrow keys 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 file from another directory. DOCUMENTATION UPDATES PAGE 12 VINO:FILE Cellar Master - Version 2.15 * Field Termination Character / Record Termination Character In the import file, VINO:FILE is expecting to see a number of wine and bottle records - each record consisting of multiple fields. You need to tell the program what characters are going to separate the fields and records. The defaults (and the most commonly used) are Commas to separate fields and New Lines (Carriage Return + Line Feed) to separate records. You can also use Tabs or Semi-colons (;) as separator characters. You must use the same characters importing to VINO:FILE as you did when you created the text file. * Use and Update XRef File When VINO:FILE reads the new wine records from the text file it can use its Cross Reference file to provide geographical information about the wines - if that information is not in the text file. Similarly, if the information is in the file it can add those wineries to the cross reference for future use. Please read the Importing & Exporting Text Files section carefully as the rules for how the Cross Reference is used during import are detailed there. DOCUMENTATION UPDATES PAGE 13 VINO:FILE Cellar Master - Version 2.15 New Section 3.4.1.x 'EXPORT DATABASE TO FILE' To export the wine database to a text file on disk choose 'Export File' on the Files Menu. The structure of the text file created is the same as for import files, covered beginning on page 17. When you select this option, a window will be displayed showing the current database and asking you to enter the following fields: * Export File Name The name of the text file to be created. You can type in the name (without an extension, .TXT is assumed). If a file of that name already exists you will be asked whether to overwrite it. * Field Termination Character / Record Termination Character VINO:FILE creates a number of wine and bottle records in the text file with each record consisting of multiple fields. You need to tell the program what characters are going to separate fields and records. The defaults (and the most commonly used) are Commas to separate fields and New Lines (Carriage Return + Line Feed) to separate records. You can also use Tabs or Semi-colons (;) as separator characters. If you later import this file, you must use the same characters. DOCUMENTATION UPDATES PAGE 14 VINO:FILE Cellar Master - Version 2.15 Additions to 3.4.1.6 'SHELL TO DOS' If EMS (Expanded Memory) is not available, VINO:FILE can now use XMS Extended Memory to swap itself out when shelling to DOS. Note that only XMS as supplied by an extended memory manager like HIMEM.SYS can be used - unmanaged extended memory can not be used. If VINO:FILE cannot allocated EMS or XMS, it will shell to disk. A floppy diskette cannot be used - if you are running VINO:FILE from a floppy disk and you have a hard disk on your computer you should use Change Configuration to set the Temporary Files Directory to a directory on the hard disk. Additions to 3.4.2 'THE ADD MENU' There are now two options on the Add Menu - 'Add Wines' and 'Restore Deleted Wines'. Both are covered in detail elsewhere in the documentation. Additions to 3.4.3.1 'DATABASE SUMMARY SCREEN' Memory Usage figures are no longer on this panel. New Section 3.4.3.x 'MEMORY USAGE SCREEN' The memory usage screen gives you information about the system memory that VINO:FILE is using. Firstly, the amount of Standard DOS memory used to hold the various VINO:FILE data structures is listed. If you are running short of free standard memory you may need to remove some TSR's or break your database into multiple smaller files. After that the availability of additional memory is listed. Expanded Memory (EMS) can be used by VINO:FILE to load the Overlay file into, and when shelling to DOS. Extended Memory (XMS) can be used by VINO:FILE when shelling to DOS if EMS is not available. Note that only the XMS memory provided by HIMEM.SYS or similar memory managers can be used by VINO:FILE. DOCUMENTATION UPDATES PAGE 15 VINO:FILE Cellar Master - Version 2.15 Additions to 3.4.3.3 'CHANGE CONFIGURATION' * Currency Symbol can now be up to three characters to better suit international currencies like Deutsch Marks (DM), Francs (Fr) or Swiss Francs (SFr). * Decimals The number of digits after the decimal point in currency fields can be varied from 0 to 2. The default is 2. This is also for better compatibility with foreign currencies - some of which may also require values greater than 999.99 per bottle. * Print Header The default Heading Text for printed reports. You will get the opportunity to change the heading text for each particular report when you print it. Additions to 3.4.4.1 'PRINT THE DATABASE' Once a report has started printing you can cancel it by pressing CTRL_C - that is, hold down the CTRL key while pressing the C key. You will be asked to confirm that you want to cancel the report. If you answer 'Y' the report will be cancelled immediately. Press any other key to resume the printout. Note that some printers (and software print spoolers) will buffer data before printing it, so the printer may not stop printing immediately. At the end of the printout a Report Summary is now printed. This shows the search criteria for the report, and the applicable statistics. Additions to 3.4.4.3 'PRINTER SETUP' The IBM Proprinter can now be selected by entering IBM as the Printer Type. DOCUMENTATION UPDATES PAGE 16 VINO:FILE Cellar Master - Version 2.15 New Section 3.6 IMPORTING & EXPORTING TEXT FILES When importing text files, the format of the file is very important. If you do not follow this format exactly, VINO:FILE will not understand the file when it tries to import it. In some situations, VINO:FILE may even hang when trying to import a file, although normally an error message will be displayed showing you the cause of the error. The import file consists of a number of wine records and bottle records: WINE RECORD 1 BOTTLE RECORD 1 BOTTLE RECORD 2 WINE RECORD 2 BOTTLE RECORD 3 etc Each bottle record 'belongs' to the wine record which precedes it. So bottle records 1 and 2 both represent bottles of Wine 1 in the example above. Like the bottle records in VINO:FILE databases, each bottle record can represent a number (1-999) of actual bottles. The records must be separated by a particular character - the 'Record Termination Character'. We recommend that ASCII carriage return/linefeed (actually 2 characters) be used to separate records. The valid record termination characters are: * CR/LF ASCII 13 (X'0D') followed by ASCII 10 (X'0A'); * COMMA ',' - ASCII 44 (X'2D'); * SEMI COLON ';' - ASCII 59 (X'3B'); * TAB ASCII 9 (X'09'). Each record, wine or bottle, consists of many fields. Fields must also be separated by a particular character - we recommend that a Comma be used. The valid 'Field Termination Characters' are the same as above. The field terminator MUST be a different character to the Record Termination character. DOCUMENTATION UPDATES PAGE 17 VINO:FILE Cellar Master - Version 2.15 GENERAL FIELD RULES: Each field may be enclosed in quotes (single or double) at the user's option. A field MUST be enclosed in quotes if it contains either of the termination characters - field or record terminators - or quote characters themselves. To place quote characters inside a quoted string you must use double quote characters. For example: "Robert Parker says ""Excellent value""." . The following is also valid: "Robert Parker says 'Excellent value'." because the single quote is not being used to enclose the string in this case. Fields generally have a stated maximum length. If a longer value is provided, all characters after the maximum has been reached will be ignored (truncated). Values less than the indicated length are acceptable. Date fields are controlled by the Date Format that you have set in 'Change Configuration'. That determines whether dates are in mm/dd/yy, dd/mm/yy or yy/mm/dd format. Invalid dates will be trapped and an error message displayed. Many fields have default values which apply if no value is supplied. Fields can be omitted at the END of the record. If a record ends before all field values have been found then those fields are assumed to be empty and the defaults used, if any. DOCUMENTATION UPDATES PAGE 18 VINO:FILE Cellar Master - Version 2.15 Example: Here's an example of a valid import text file using Comma as the Field Terminator and as the Record Terminator (indicated by ) and using the mm/dd/yy date format. W, ACACIA, , PINOT NOIR, 1985, NAPA VALLEY, CALIFORNIA, USA, DR, , , , B, 10/03/87, , 750, 12, 1, 9.00, , 9.00, , , W, BAILEYS, , VINTAGE PORT, 1976, NE VICTORIA, VICTORIA, AUSTRALIA, FO, 1989, 1999, #, "Comments on this wine. Quite Good, typical Rutherglen port." B, 12/06/86, , 750, 21, 2, 10.00, CELLAR DOOR, 5.00, , , B, 12/05/86, 12/12/86, 750, , 2, 9.00, CELLAR DOOR, , 0.0, , W, BALGOWNIE, , CABERNET SAUVIGNON, 1980, CENTRAL VICTORIA, VICTORIA, AUSTRALIA, DR, , , , B, 07/07/84, , 750, 37, 11, 9.80, MAILING LIST, 0.00, , , B, 05/12/84, 06/15/84, 750, , 1, 10.95, 'RH CELLARS, WEST', , 15.0, , 'FULL BODIED. WILL LAST' B, 07/07/84, 02/22/85, 750, , 1, 9.80, MAILING LIST, , 12.0, , "OXIDISED, VARIES WITH EACH BOTTLE. BREATHING HELPS." W, BEAULIEU VINEYARDS, RUTHERFORD, CABERNET SAUVIGNON, 1985, NAPA VALLEY, CALIFORNIA, USA, DR, 1990, 1995, , B, 02/23/89, , 750, 15, 10, 6.75, SAFEWAY, 0.00, , , B, 02/23/89, 04/11/89, 750, , 2, 6.75, SAFEWAY, , 17.5, "Dinner Party with Fred and Jane. (Roast Spatchcock).", "Excellent, full- bodied blackberry fruit flavors. Elegant and classy, great drinking now but should improve up to 7 years." DOCUMENTATION UPDATES PAGE 19 VINO:FILE Cellar Master - Version 2.15 WINE RECORD FORMAT: Wine records contain 13 fields. All fields are alphanumeric unless indicated. Values longer than the indicated length will be truncated. Values less than the indicated length are acceptable. All field names are directly imported to the fields of the same name in the VINO:FILE wine record. Field Name Length Description * Record Type Code 1 Constant. Must be 'W'. * Company 20 Name of Winery or shipper. * Other Info 20 Additional Info about the wine. * Variety 20 Grape variety. * Year 4 Vintage Year. * District 20 Geographical district. Default - see Using Cross Reference in Import below. * State 20 Geographical state. Default - see Using Cross Reference in Import below. * Country 20 Geographical Country. Default - see Using Cross Reference in Import below. * Category 2 Type of wine. * Year Ready 4 Year to start drinking the wine. * Drink By 4 Expected life of the wine. * Flag 1 Any character. Default - blank. * Comments Unlimited length comments field. Must be in quotes. DOCUMENTATION UPDATES PAGE 20 VINO:FILE Cellar Master - Version 2.15 USING CROSS REFERENCE IN IMPORT: If the 'Use and Update XRef' option is selected then the Cross Reference file will be used to provide District, State and Country field defaults. In addition, if District, State and Country fields are provided in the text file then they will be added to the XRef file. The following rules apply (D=district, S=state, C=country, . =no value): Import Wine is in XREF Wine is NOT File --------------- in XREF Contains --------------- -------- D S C Do nothing, Use Add Wine to XRef . S C provided values. using the provided . . C values. . . . Use values from Do nothing. the XRef file. D . . If district exists If the district D . C in the XRef then exists in the XRef use the XRef state then add the wine & country. to the XRef using If the district is the XRef state & not known then use country. provided values. . S . If state exists in If the State exists the XRef then use in the XRef then the XRef country. add the wine to the If the state is not XRef using the XRef known then use the country. provided values. When the Cross Reference file is updated when importing files, bad and incomplete entries (together with mis-spellings) can be added to the Cross Reference and to the wine database records. You should check all records and the Cross Reference file immediately afterwards and correct any errors. DOCUMENTATION UPDATES PAGE 21 VINO:FILE Cellar Master - Version 2.15 BOTTLE RECORD FORMAT: Bottle records contain 12 fields. All fields are alphanumeric unless indicated. Values longer than the indicated length will be truncated. Values less than the indicated length are acceptable. All field names are directly imported to the fields of the same name in the VINO:FILE bottle record. Field Name Length Description * Record Type Code 1 Constant. Must be 'B'. * Purchase Date 8 Must be MM/DD/YY or DD/MM/YY or YY/MM/DD according to the current VINO:FILE configuration settings. * Drink Date 8 Must be MM/DD/YY or DD/MM/YY or YY/MM/DD according to the current VINO:FILE configuration settings. Default - not drunk. * Size 4 Numeric (Integer). Size of bottle. * Location 8 Cellar location. * Number 3 Numeric (Integer). Number of bottles. * Cost 6 Numeric (Real). Default - 0. * Origin 20 Source of bottle. * Value 6 Numeric (Real). Default - if not drunk, same as cost. * Points 4 Numeric (Real 99. 9). Default - 0. * Occasion Unlimited length field - occasion when these bottles were drunk. Must be in quotes. DOCUMENTATION UPDATES PAGE 22 VINO:FILE Cellar Master - Version 2.15 * Tasting Notes Unlimited length field - tasting notes for these bottles. Must be in quotes. Note - if a 'Drink Date' is not provided then the bottles will be considered NOT drunk. Therefore the Points, Occasion and Tasting Notes fields will be ignored. DOCUMENTATION UPDATES PAGE 23