What’s new


I would appreciate if you would take a moment to provide a small comment and vote for the software on the following link.

http://wvw.logitheque.com/voter_logiciel.asp?I=16503


Release 2.3.316.9 - January 2009


This is a minor release correcting a few of problems.

 

    Dialog - Bottle tag assignment

         An exception was shown when running out of available bottle tags, instead of a meaningful error message. Thanks to Mr C. Haan for reporting this issue.

 

    List controls

         In some situations a “keyerror” was shown. Thanks to Mr G. Mathieu and Mr P. Price for reporting this issue.

 

    Image tab

         A MS Windows no access right exception is shown when one tries to access a folder one has to access rights too. Now an empty folder list is shown and one can continue trying to find the folder containing the image. Thanks to Mr Sette for reporting this issue.

 

    Wine tab

         In some situations an exception would be shown when one tried to use the “Category” button. Thanks to Mr DS and Mr Kay for reporting this issue.

 

    CVS import dialog

         If the “.cvs” file contained an invalid bottle size an error would be shown, now the system will just default to 75cl bottle size. Thanks to Mr Hery for reporting this issue.

         If the “.cvs” file contained certain special characters within a wine name it would not be accepted. This has been improved now, but only for the wine name and wine name 2 columns, other columns should only contain alphanumeric or numeric characters. Thanks to Mr A. Luger for reporting this issue.


Release 2.3.310.9 - September 2008


This is a minor release correcting a few of problems.

 

    Dialogs

         There was an issue with some of the master data dialogs. Thanks to Mr J. Marbacher for reporting this issue.

 

    Dialog - Wine rack design

         There was an issue when creating a new rack. Thanks to Mr C. Haan for reporting this issue.

         There was an issue when changing rack type. Changing of the rack type is after creation no longer allowed. Thanks to Mr A. Wegmann for reporting this issue.

 

    Dialog - CVS import

         There was a problem when names included an apostrophe. Thanks to Mr M. Struppe for reporting this issue.


Release 2.3.302.9 - June 2008


This is a minor release correcting a few of problems.

 

    Dialog consumption event

         There was one more issue with switching between the menu and consumption pages. Thanks to Mr Naim and Klaus O. for reporting this issue.

 

    Reports

         The Purchase and Consumption history report would not work with some printers. Thanks to Klaus O. for reporting this issue.

         The Cellar Book Reports used the vintage information for first and past maturity information, changed it to now use the bottle information. Thanks to Yan G. for bringing this to my attention.

 

    Dialog error reporting

         The dialog did not allow to provide additional information in the message. Thanks to Klaus O. for reporting this issue.


Release 2.3.286.9 - April 2008


This is a minor release correcting a few of problems.

 

    Dialog consumption event

         A problem occurred if one switched between the menu and consumption pages. Thanks to Mr Naim for reporting this issue.

    Reports

         The cellar book report by current value had incorrect totals. Thanks to Mr Schatto for reporting this issue.

         The wine card report did not show the current value. Thanks to Mr Schatto for suggestion this change.

 

    Transfer between cellars

         The button for this function on the consumption page was sometimes available when it should not have been. Thanks to Ms Augay for reporting this issue.

 

    Purchase

         Sometimes an error would occur. Thanks to Ms Augay for reporting this issue.

 

    Tasting

         Sometimes an error would occur. Thanks to Stephen E. for reporting this issue.

 

    Report Manager

         Upgraded to version 2.7e



Release 2.3.282.9 - February 2008


This is a minor release correcting a few of problems.

 

    vinoXML file download

         Program now ensures that a file name is provided. Thanks to M. Yusuf for reporting this issue.

         Temporary file is not removed if MS Internet Explorer is used, it’s left up to MS IE to clean up the temporary file. Thanks to Mr. Pinault for reporting this issue.

 

    Vineyard dialog

         Updating an existing entry may have caused an error. Thanks to Yan G. for reporting this issue.

 

    GWS value update

         Trying to report a missing wine to GWS would cause an error on Windows Vista.

 

    Wine rack display

         Custom wine rack would have a problem with displaying certain drink types. Thanks to Mr. Pinault for reporting this issue.

Release 2.3.275.9 - November 2007


This is a release providing an enhancement and correcting a couple of known problems.

 

    Transfer dialog

         The current value will in the ‘to’ cellar will be updated with the ‘from’ cellar value. Thanks to Lars J. for the suggestion.

 

    Image tabs

         One could not select a particular file type in the file browser. Thanks to Wilma M. for reporting this.

         Copy from the clipboard now also supports using the filename, i.e. some source application provide only file name and not a Windows Bitmap.

 

    URL controls

         These controls are used for the web site fields, pasting certain values or changing the value would cause an error. Thanks to D. Terrett for reporting this.



Release 2.3.272.9 - October 2007


This is a minor release correcting a couple of problems.

 

    Ingredient dialog

         Creating a new item and closing the dialog without saving caused a problem. Thanks to R. Henry. for reporting this.

 

    Recipe

         Pasting ingredients containing an apostrophe from the clipboard was causing a problem. Thanks to R. Henry. for reporting this.



Release 2.3.270.9 - October 2007


This is a minor release correcting a couple of problems and it includes a Danish translation done by Jesper R.

 

    vinoXML copy problem

    Wine rack designer problems



Release 2.3.266.9 - September 2007


This is a release providing a few enhancements and correcting known problems.

 

    Global Wine Stocks

         Improved integration with the GWS site.

         You can now obtain current market values for your wine. This feature requires a subscription with Global Wine Stocks which you can get from here .

         There are two additional menu options to support this.

               First of all under menu Master data - wine/Internet search configuration you need to define the e-mail address you used when signing up with GWS (I would appreciate if you use the link above should you sign up with them) and the password and then you can obtain an authentication key by clicking the appropriate button.

               Second under the menu Tools/Obtain current value from GWS is the dialog which allows you to search the Global Wine Stocks database to find their reference number for your wine and for wines which already have a GWS reference you can obtain the current value.

         Bottle tab

               The GWS reference number is shown on this tab and the current value will be written to the current value field.

               The button next to Internet source allows you to obtain a reference code and/or current value for just this wine.

 

    vinoXML import wine information

         Supplier and/or Producer information can now be imported from the vinoXML file. This is not done automatically, but when you click on the Supplier or Producer button the program will give you the option to import from the vinoXML file or create a new entry.

         Convert price to local currency when importing.

 

    Master data updates

         Added over 40 regions for Portugal.

         Added Whisky (Scottish) and Whiskey (Irish and North American) as drink type

         Added 14 Whisky regions

 

    Import from CSV file

         Please note that the layout has changed, it is not the same as it was in 2.2!

         Support for additional columns has been added.

               for alcohol percentage with a heading of: alcohol

               for additional varietals with headings of: varietal2, varietal3, varietal4

               for producer name with a heading of: producer

               for supplier name with a heading of: supplier

               for maturity information headings are now: maturityfrom, maturitybest, maturitypast

         A sample twcb.csv file is provided and installed in the folder “C:\TheWineCellarBook\xmlImport”

 

    Cellar book reports

         Two cellar book reports have been added which will print by price in descending order. There is one menu option which will print it using the last purchase price and a second one which prints it using current value. Thanks to Loraine M. for this suggestion.

 

    Events listing

         This now prints the menu served for a particular event - a parameter (F12 in report preview) allows you to suppress this section.

         Cleaned up the layout of the report and fixed some problems with it. Thanks to Loraine M. for reporting this.

 

    Wine rack / Bottle tag assignment

         This dialog now allows you to filter by wine rack. Thanks to P. Girot for this suggestion.

         The system can now auto assign tags, you need to activate this in preferences. When you click on the button “Assign tags” on the purchase tab the appropriate number of tags are assigned to this purchase and shown in a list, you then just need to assign them to the appropriate wine rack position.

 

    Database backup

         It is now possible to select a particular folder when performing the backup, it defaults to “C:\TheWineCellarBook\Backup”. Thanks to P. Girot for this suggestion.

    Ingredient search

         Corrected problem when adding a new ingredient from this dialog. Thanks to Klaus O. for reporting this problem.

         This dialog can now be maximized, which allows you to see more ingredients and/or recipes. Thanks to Klaus O. for this suggestion.

 

    Supplier and Producer dialog

         A new keyword field with the corresponding search. Thanks to Yan G. for suggestion this.

         Country information was not saved on these dialogs. Thanks to Yan G. for reporting this problem.

 

    Notebook for wines

         The pages on this notebook are now only loaded when one accesses the particular page, this means that there is less database access which translates into a bit of a speed up.

 

    Purchase

         Default supplier name onto new purchase. Thanks to Klaus O. for suggesting this.

 

    Consumption

         Show the consumption event or batch description. Thanks to Klaus O. for suggestion this.

 

    Winemaker’s tab

         Changed field size for residual sugar content.

 

    Charts

         Better use of available colors for plots and better positioning of percentage text. Thanks to Yan G. for suggesting this.

 

    Report Manager

         Upgraded to version 2.6v

 

    GUI tool kit

         Upgraded to version 2.8.4.2



Release 2.2.238.9 - June 2007


This is a minor release correcting a couple of problems

 

    German translation corrections

         Major revision to the German translation done by Klaus O., this should have been mentioned in 2.2.211 already, but I just forgot it.

 

    Tasting tabs

         Problems when trying to work with tasting method “Broadbent”. Thanks to Y. Gagnon for reporting this problem.

         Invalid point values were accepted when one changed to the summary page, causing an error. Thanks to Y. Gagnon for reporting this problem.

    Rating type

         The rating type “100” could not be selected easily. Thanks to Y. Gagnon for reporting this problem.

 

    Graphics

         Upgrade to a newer version of the library matplotlib.



Release 2.2.211.9 - May 2007


This is a release providing a few enhancements and correcting known problems.

 

    CSV (comma separated value) file import tool

         On the Menu Tools there is a new import tool which allows you to import information about wines stored in a CSV file (this type of file can be generated very easily from e.g. Microsoft Excel, or OpenOffice Calc, or Corel Office and from many other programs).

         Currently one layout of the file is supported.

               twcb.csv - a sample of this format is included in the “xmlimport” folder.

               should your software generate a CSV with a different layout you can use your favorite spreadsheet program (Calc from OpenOffice, Excel etc) to change the column labels and the column order to match the ones shown in the sample file twcb.csv.

         See the help file for more details (currently only in English).

               Prices in the file are all considered to be in the home currency set in The Wine Cellar Book.

               Bottle size values should be valid types as defined in The Wine Cellar Book.

               Drink type values should be valid types as defined in The Wine Cellar Book.

 

    vinoXML

         On most sites supporting vinoXML the file will be automatically be saved to the xmlImport folder when downloading a “.vinoxml” file.

 

    Tasting Notes

         Entry fields were sometimes available when they should not have been.

 

    American Viticultural Areas (AVA)

         Added new areas from Snake River Valley in Idaho, Outer Coastal Plain in New Jersey and Shawnee Hills in Illinois.

 

    Error log files location

         In 2.1 I had relocated these files, but it caused some issue with the error reporting tool, so I had to relocate them once more.

         These files are no longer created in “Program Files/TheWineCellarBook” as this is not allowed on Vista.

         On Vista they are now located in:

           “/user/YOURLOGINNAME/TheWineCellarBook”

         On XP, 2000 etc they are now located in:

           “Documents and Settings/YOURLOGINNAME/TheWineCellarBook”

 

    Batch and Event Consumption

         It is now possible to create a rating for the wine for which you are entering a consumption.

 

    Error dialog

         When using the option “Send via MAPI” the error logs were not attached.

 

    Tasting tab

         Average score would not update when deleting tasting record.

 

    Average rating score per wine

         An average rating score is shown per wine. You need to select which type of ratings should be averaged, currently it defaults to the “100 “ point ratings, but you can change this in the menu option File/Preferences.

 

    Rating types

         Additional rating types have been added to the database (Wine Enthusiast, Wein Plus and Hachette).

         When defining rating types one now has to select the maximum points they use for their rating (100, 20, 5). This definition is used for the average rating score calculation.

 

    Changes for Vista

         Date fields were using too much space

         Legend on graphs was not totally shown

         Tab key on combobox was not working

         Yellow background on combobox is not supported by Vista. The status bar will now show a message which identifies which fields have not been completed, instead of highlighting them with a yellow back ground.


Release 2.1.166.9 - March 2007


This release is to ensure compatibility with Windows Vista.

 

    “fixedpoint.py:300: RuntimeWarning”

         Thanks to P. Desenfans for reporting this problem.

 

    “C++ assertion "!(lvi.mask & LVIF_STATE)"”

         Thanks to W. Struck for reporting this problem.

 

    Log files

         The error log files are now stored in the following folder.

           “C:\Documents and Settings\username\Application Data\TheWineCellarBook”

 

    Notebook widgets

         All screens and dialogs using a notebook have been changed to use a nicer looking version of the notebook widget.





Release 2.1.142.9 - February 2007


This is a release providing a few enhancements and correcting known problems.

 

    Wine maker’s information

         A new tab on the vintage/bottle tab has been added to record additional information about how the wine was made.

 

    Vintage information

         Total acidity and residual sugar fields have been moved to the wine maker’s information tab.

 

    Printing cellar labels

         If no bottle size is defined to print a cellar label a program error is generated. Thanks to A. Fleuri and H. Roche for reporting this problem.

    Vinoté tab

         Added information about the location of a bottle tag. Thanks E. Sieger for the suggestion.

 

    vinoXML

         Updated to support version 1.1 of the standard. Note that “http://www.globalwinestocks.com/” is now supporting vinoXML and from their site you have access to well over one hundred thousand wine profiles and over 1.9 million prices.

 

    Tasting tab

         Average score would not update when creating a new tasting record.

 

    New wine dialog

         Using the edit category button causes an error. Thanks to C. Cuevas for reporting this problem.

         Using the edit vineyard button would erase data entered in other fields.

 

    Guest book dialog

         Deleting an event from this dialog causes an error. Thanks to V. Reinhartz for reporting this problem.

         Deleting a guest was not always working correctly.

 

    Wine search dialog

         Double clicking to select and close the dialog causes sometimes an error. Thanks to L. Jorgenson for reporting this problem.

 

    Images

         The image file names could not contain multiple “.”. Thanks to T. Karl for reporting this problem.

 

    Lists

         Clicking on a column header would sometimes cause an error.

 

    Delete key on numeric pad

         Using this key in certain circumstances would cause an error. Thanks to E. Graber for reporting this problem.



Release 2.0.131.9 - December 2006


This is a minor release correcting a couple of problems and providing a few enhancements.

 

    Wine rack design dialog

         It is now possible to delete a wine rack design

 

    Guest dialog

         It is now possible to delete a guest


 

    Restoring a database

         This is now fully automated, no more manual renaming of files. Thanks to T. Coudray for the suggestion.

 

    Region search dialog

         Wine region search did sometimes not work. Thanks to Y. Gagnon for reporting this problem.

         Geographical region search sometimes did not work.

         Country search sometimes did not work.

 

    vinoXML Export dialog

         Wine search did not work. Thanks to Y. Gagnon for reporting this problem.

         Import of new wine sometimes did not work. Thanks to Y. Gagnon for reporting this problem.

 

    Assign bottle tag dialog

         Sometimes caused an error. Thanks to M. Holmstrom for reporting this problem.

 

    Rack view dialog

         If design was changed this could sometimes cause an error on this screen. Thanks to M. Holmstrom for reporting this problem.



Release 2.0.128.9 - November 2006


This is a minor release correcting a couple of problems

 

    Tasting and Rating tabs

         Creating a new entry did not work. Thanks to L. Jorgensen for reporting this problem.



Release 2.0.126.9 - November 2006


Release 2.0 is the first really major upgrade of The Wine Cellar Book. This upgrade brings the following four new features which we are confident will provide our users with much greater functionality.

 

1.  Recipe Management

2.  Wine Pairing

3.  Wine Rack Design and Management

4.  Import/Export Facility


Instead of just adding functionality to pair wines with food categories we thought that creating a recipe book application would bring much more value for our users - hopefully most of you will agree.


The concept of “wine and food pairing” relies heavily on the new Recipe Book feature and the definition of Wine Families (as defined by the French authority “Larousse des vins”).


For those who do not have the time or desire to set up recipes, it is still possible to pair wines with food by simply associating a wine family with an ingredient or group of ingredients. Incidentally, version 2.0 comes with over 600 pre-defined ingredients.



Description of New Features and Changes

 

    Help

         The online help has been totally rewritten. It is now more of a “how to” type of manual which better complements the help made available with ToolTips and ContextHelp.

         We are also planning to issue this new manual in German and French in the future (during 2007).

 

    Toolbar - wines

         Wine rack

               This is a new button to the left of the Chart button which allows you to visualize your wine racks in a graphical format - see below.

         Recipe book

               This is a new button to the far right of the toolbar giving access to the recipe book function.

         Consumption Event

               We moved the “Maintain Consumption Event” to the right of “Delete wine”, to access the “Create Consumption Event” dialog use this button.

         Consumption Batch

               We moved the “Maintain Consumption Batch” to the right of “Maintain Consumption Event”, to access the “Create Consumption Batch” dialog use this button.

 

    Recipe book

         The is one of the major enhancements for this version, the following are just some of the highlights.

               Ingredients

                     The system comes with many ingredients predefined in all three languages, currently over 600 items.

                     The ingredients are categorized into groups, facilitating the linking of these groups to particular wine families.

                     The ingredient groups are further categorized into main groups to facilitate searching.

               Recipe

                     Ingredients, an unlimited number of ingredients can be defined per recipe.

                     Recipe, an unlimited number of recipes can be included into a recipe (particularly useful for base recipes such as sauces etc.).

                     You may attach an unlimited number of images to a particular recipe.

                     It allows you to record detailed cooking instructions.

                     It allows you to record tips and tricks and which utensils are necessary for a particular recipe.

               Ingredient import from the clipboard - see online help.

 

    vinoXML.org

         The import/export facility to a standard format (vinoXML) is the other major enhancement included in this release. We have in late 2005 initiated the discussion and worked with other wine cellar book software authors to create a definition for a common data exchange standard. The standard is available free of charge on www.vinoxml.org to any interested parties and we hope that over time sites providing information on wines will use this standard.

         Export wines to “.vinoXML” files

               Under the new Tools menu there is an option to export wine information, selecting the option will bring up a dialog on which you can select which wine you want to export. The export files will be saved to the following folder: “C:\TheWineCellarBook\xmlexport”.

         Import wine information from “.vinoXML” files

               If you receive, or download “.vinoXML” files you should store them in “C:\TheWineCellarBook\xmlimport” and use the Import option on the new Tools menu, a dialog will open showing you all the files available for import, when you select a file by clicking on it the system will show the wine name, vintage etc of the selected wine and will try to find similar wines already in your cellar. If similar wines are found in your cellar you can import just the new vintage and/or bottle information or you can import it as a new wine.

 

    Wine rack design

         This dialog can be accessed from the menu Master data - Wine. It allows you to define/configure the wine racks you have in your cellar(s).

         There are two types of racks supported at this time, which should allow you to define just about any kind of rack configuration.

               Standard rack layout

                     You would use this for racks (e.g. the often seen metal racks) which store a bottle per slot. The one we have has 15 rows and 12 columns, but they come in all kind of sizes and also exist in wood and other materials - this type of rack can easily be defined - see online help for details.

               Custom rack layout

                     A custom layout is anything which can NOT be done using the standard rack layout. It allows you to define bins and their capacity and then lay them out with graphical shapes. In our cellar we would use this to define the rack which provides for storing anything from 6 to 36 bottles per bin and the bottles are stored neck to neck - again see the online help for details.

 

    Consumption event dialog

         A new tab has been added which allows you to define the menu served during the event.

         Menu items are free format, but you can assign an ingredient or recipe to each - in the future this will allow to generate a shopping list.

         A wine can be assigned to each menu item

         If you want to use this for planning events, just enter the guests and the menu and update the event later on with the consumption information.

 

    Beverage list

         Additional optional columns have been added (Supplier name, Producer name and Average score), all of them need to be activated through the menu Master Data/Configuration listctrl. Thanks to J. Novak for suggesting these changes.

 

    Wine search

         Bar code search field has been added

         Country search field has been added

 

    Wine details tab

         Wine Family

               Added a “Wine family” combobox which allows for the definition of the particularity of a wine and is used to link wines with food items.

               It allows you to easily link a particular wine families to a particular ingredient, to a particular ingredient group and/or to recipes.

         Variety

               Added a “Variety” text field which is similar to the “Additional name” field in that it allows you to define more detailed information about a particular wine. It should only be used to enter grape variety names (e.g. for Penfolds Merlot you would enter Merlot into this field), however you will probably still want to define the grape variety in the cuvée to define the percentage and for the search by grape variety.

         Tree list of vintage/bottle

               Entries are now sorted in ascending order of the vintage

               Entries with zero quantity on hand will NOT be shown. If all bottle sizes of a certain vintage are ALL at zero quantity on hand the vintage will NOT be shown, unless the check box “Incl. Zero” for wine search has been checked..

         Added additional drink types for better mapping with the new vinoXML import/export facility.

 

    Vintages/Bottles tab

         Tree list of vintage/bottle

               Entries are now sorted in ascending order of the vintage

               Entries with zero quantity on hand will NOT be shown. If all bottles sizes of a certain vintage are ALL at zero quantity on hand the vintage will NOT be shown, unless the check box “Incl. Zero” for wine search has been checked.

         Bar code

               Allows to record a bar code (supports the entry via a barcode scanner or by hand of any barcode up to 22 characters long). It can also be used to record any other type of unique identification code for a particular bottle size.

         Minimum quantity on hand

               Allows the recording of the min. quantity on hand which is very useful for a suggested purchase report.

 

         Serving temperature

               Allows for the definition of the ideal serving temperature

         Decanting time

               Allows for the definition of the recommended decanting time, e.g 1.5 for one and a half hour.

         Total acidity

               Change the label to Acidity g/L, I believe this is the more often used way to define the Total Acidity - instead of in %.

 

    Tastings and Ratings tab

         Both of these will now show all Tastings or Ratings for a selected vintage, regardless of bottle size and/or cellar location..

         However creating a Tasting or a Rating record can only be done when a bottle size is selected.

         A new tasting method has been added “100 - Wein.Plus.com”, you can find details on how they taste and rate wines on the page listed below. http://www.wein-plus.com/wineguide/bewert.htm

 

    Dialog Maintain Consumption Event

         Events are sorted by event date instead of description. You can sort them by the other columns by clicking on the appropriate column header.

 

    Dialog Consumption Event

         The layout of the screen has been modified and a notebook providing two tabs, see below.

         Consumption details tab

               Added quantity on hand as a display only field. When creating a new consumption entry it shows the quantity on hand in the cellar, after saving this entry it will show the quantity on hand in the cellar taking this entry into account.

               Quantity is now limited to the quantity on hand before this consumption was entered.

               The reason and consumption date is now shown, it defaults to the entries you made on the top of the screen (event reason and date).

         Menu details tab

               This allows you to define the menu served at this particular event and which wines were served with which menu item (course).

 

    Consumptions tab

         A new button allows you to transfer from this cellar to another cellar.

               You could use this to manage your “Primeur” purchases, e.g. create a cellar called “Primeur” and record the wine in that cellar when you order it, when it gets delivered you transfer it using this new function to the cellar where you store it.

               The transfer will create a consumption entry in the cellar you transfer from and a purchase entry in the cellar you transfer to. If the same vintage/bottle size exists in the transfer to cellar it will be used, otherwise a new entry will automatically be created.

               The quantity to transfer is limited to the quantity on hand.

 

    Dialog preferences

         Allows for the definition of a default reason code for the cellar transfer (see above)

         Allows for the definition of a backup interval which defaults to 14 days. If you have not done a backup for more than 14 days (or whatever number of days you set this to) a reminder prompt will be shown when you startup The Wine Cellar Book.

         Allows for the definition of defaults for measures and ingredients, used if a corresponding item is not found during the new ingredient import from the clipboard.

         Allows the user to specify which tasting system to use for average score calculation on the beverage list.

 

    Dialog assign bottle tags to wines on hand

         If you have been using The Wine Cellar Book for some time, and subsequently decide to use the bottle tag function you can use this tool (under the menu Tools) to assign bottle tags based on the quantity on hand.

 

    Technical changes

         Report Manager - version 2.6e

               This version allows for the translation of all the report prompts into the supported languages.

               The way reports are accessed has also changed, this means that there is no DOS window shown when running reports from within The Wine Cellar Book.

               If you are creating custom reports you need to upgrade to this version.

 

         wxPython - version 2.6.3.3

               Current stable release of the GUI library.

 

         Firebird SQL

               Version 2.0 of the SQL database engine

 

         OdbcFb32.dll - ODBC driver for Firebird, version 2.0.142 Beta

               This is a new version of what previously was called OdbcJdbc.dll.

               Much better support for e.g. MsAccess.

               Easier install/use with 3rd party packages such as OpenOffice, MsAccess etc by using the Firebird variable - see online help.