Barcode

Barcoding using a Dymo printer, as described here, is the strongly recommended approach.

One 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.

Using Labels

There are three screens where CellarTracker barcodes can be used:

As mentioned above, you can also add wine to your cellar by scanning an Existing UPC.

There are three types of labels:

  1. Unique per-bottle barcodes. This is what is pictured on this page.
  2. 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). Please note that these are NOT supported on the dual-barcode labels and in fact ONLY print on the 30336 label template.
  3. 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

The strongly preferred barcode printing solution is to use a Dymo printer, as this offers the most automated and easiest solution.

Recommended Equipment

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 and it is currently enabled in the scanner.
People using Socket barcode scanners also need to enable support for scanning ANY LENGTH of ITF barcode. That can be done with PDF configuration file here. Just scan the proper barcode. Mac users of OSX with CipherLab scanners need to configure their scanner to 'Transmit By Character' with this PDF configuration file.

Steps for Windows Users

Installation - Automated install troubleshooter

  1. You need to install the latest DYMO software. The simplest solution is to install the 8.3 or later software, the full package, and then no further configuration should be required in ANY major browser.
  2. Alternatively model 400 and earlier printers do have legacy support for 32-bit Internet Explorer and FireFox so long as you are running version 7.8 or 8.2 of the Dymo software. However extra browser configuration is required. Internet Explorer: Because the Dymo ActiveX control is unsigned, you might need to accept the ActiveX control or add CellarTracker to your list of trusted sites. (definitely required on Vista) FireFox: Install the XPCOM extension. (You may need to do some tweaking and troubleshooting here.) For best results, download and install the Arial Narrow font if it is not on your system. This is installed with Microsoft Office.

Instructions

  1. Go to CellarTracker and from the QUICK LINKS menu (under the search box), select the PRINT LISTS AND LABELS option. Or, navigate to the barcode labels view and click PRINT.
  2. With the Print dialog open, make sure the BARCODE LABELS tab is selected. This will give you a preview of the labels tagged to be printed, and allow you to specify your desired label options. NOTE: if the Dymo printer option is greyed out, then there is a problem with your Dymo installation. Please try the troubleshooter to diagnose the problem.
  3. To take things in smaller bite-sized chunks you may want to do 100 at a time. Fill out the QUANTITY box with the number of labels you'd like to print at a time (NOTE: this is not the quantity of EACH label, but rather the total quantity of labels to print). Then, click PRINT to commit the print job.
  4. If you'd like to print a different set of labels than what is displayed, click the Customize in Label View link in the print dialog. From there, you can apply various filters to get the list of wines you'd like to print. You can also use the checkboxes to select individual labels to print.
  5. 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.
  6. By default, the print dialog will attempt to preview all unprinted labels. However, if you launch the print dialog from any Wine Detail page, we will attempt to print labels for ALL bottles of that wine. Additionally, in most bottle views, you can use the checkboxes to select bottles and click PRINT to just print labels for those bottles.

Instructions for CLASSIC site

  1. Go to CellarTracker! and click on Print barcode labels in the Actions section of the navigation bar.
  2. Press the PRINT USING DYMO button. This will give you a preview.
  3. 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.
  4. 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

Installation (Install Dymo 8.3.1 for support in Safari, FireFox, Opera, and Chrome below version 22) - Automated install troubleshooter

  1. Install the latest Macintosh version of the Dymo label software, at least version 8.3.1 to use non-Safari browsers or 8.2.2 for Safari. Also please note that the "Check for Updates" functionality within the Dymo software itself will not reliably point you to this version. You MUST manually download and install this. (NOTE: Dymo has released 8.3.1 as a requirement for OSX Lion. Safari should be run in default (64-bit) mode. Make sure that the “Open in 32-bit mode” checkbox is unchecked (right click on Safari icon in “Applications”, select “Get Info”.)
  2. You MUST RESTART YOUR MACINTOSH after you install the Dymo software.

NOTE: per DymoChrome versions 22 and higher on the Macintosh have broken the way they implemented their library, but the Dymo 8.5 software fixes this.

Instructions

  1. As of May 8, 2010, at last, the rest is the same as above for Windows users. You can print directly from the CellarTracker website with no special scripts required.

Label Customization

The site allows you to control many aspects of the information that will appear on the labels, so make sure to click on the link to Change Label Settings. More adventurous users can also modify the label templates that are loaded by the Dymo software as described here.

Generating Avery Labels with a Regular Printer

The preferred solution is to use a Dymo printer, as this offers the most automated and easiest solution. However, 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.