Front Page | Recent Changes | Title Index | HelpOne of the most valuable features of CellarTracker is the ability to print individual barcode labels for each bottle in your cellar. Using these barcodes, you can easily and accurately record consumed bottles as well as exercise the ability to batch update location and bin with the assistance of a barcode scanner. You can also add wine to your cellar by scanning an Existing UPC.
Per-wine/size barcodes. You can optionally generate these. They are less specific than the prior labels. If you have 7 x 750ml bottles of the same wine, you will have 7 different per-bottle barcodes. However, you will have only 1 per-wine barcode (which you would print out 7 times in concept).
You can also generate barcodes for your storage locations and bins. This allows you to scan bottles. You can then relocate these bottles by scanning a location or bin.
Generating Labels with a Dymo Printer
There are two ways to generate barcode labels. The preferred solution is to use a Dymo printer, as this offers the most automated and easiest solution. For Windows users of Internet Explorer and FireFox this is fully automated. For Safari users on the Macintosh there exists a partially automated solution. If you do not own a Dymo, you can also export data from the site to be used for a Microsoft Word mail merge to comparable Avery labels using the site, but this is ONLY recommended for those users who are quite technical.
(OPTIONAL, OPTION A) WIRED BARCODE SCANNER: CipherLab 1000B-USB (~$70); Buy on eBarcode.com.
(OPTIONAL, OPTION B) WIRELESS BARCODE SCANNER: CipherLab 1166 and 366-BLUETOOTH BASE (~$380); Buy on eBarcode.com.
(OPTIONAL, OPTION C) BLUETOOTH WIRELESS LASER BARCODE SCANNER:
LaserChamp II for Windows: built-in Bluetooth: YES (~$299); Buy on serialio.com.
LaserChamp II for Windows: built-in Bluetooth: NO (~$359 ); Buy on serialio.com.
LaserChamp II for Mac OS X: built-in Bluetooth: YES (~$299); Buy on serialio.com.
LaserChamp II for Mac OS X: built-in Bluetooth: NO (~$349); Buy on serialio.com.
NOTE: The Dymo labels currently use Interleaved 2 of 5 (ITF) as the barcode format for single-bottle labels and Code 128 Auto for per-wine labels, so make sure any barcode scanner you plan to use supports this symbology. If you are using the LaserChamp, ITF support is turned off by default. Please print this document and scan the barcode in upper-right ("Enable Decode ITF").
You need to install the DYMO software. Please note that the 8.0 software that comes with Dymo 450 printers is very problematic. You MUST use the 8.2 software in Windows with a Dymo 450, and 7.8 works well for older printers. PLEASE NOTE THAT THE NEW 8.X SOFTWARE ON THE MAC BREAKS OBJECT MODEL SUPPORT. PLEASE USE THE OLDER VERSION! Update for Dymo 8.1 for Windows users.
For best results, download and install the Arial Narrow font if it is not on your system. This is installed with Microsoft Office.
OPTIONAL: If you want to modify the default templates, download BARCODE.EXE and run it. This is a self-extracting ZIP file containing several .LWT files. Press the UNZIP button and extract to "C:\Program Files\CellarTracker" directory on your computer. Feel free to edit the LWT files in the Dymo editor. Read more about Label Options.
Instructions
Go to CellarTracker! and click on Print barcode labels in the Actions section of the navigation bar.
Press the PRINT USING DYMO button. This will give you a preview.
To take things in smaller bite-sized chunks you may want to do 100 at a time. Fill out the "Show # of labels" edit control on that first page of pending labels. Press the PRINT USING DYMO button to commit the print job.
Once you are caught up, the label printing user interface, by default, will only show you bottles for which you haven't yet printed labels. You can however toggle to show all labels.
Steps for Macintosh Users
Install the Macintosh version of the Dymo label software.
