Return to main CellarTracker site...

Barcode Procedures

Front Page | Recent Changes | Title Index | Help
Difference from prior major revision.
minor diff author diff hide diff

One ofPlease see 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
ExistingUPC.<br><br>
https://www.cellartracker.com/images/30336.jpg
  
<TableOfContents>
  
= Using Labels =
There are three screens where CellarTracker barcodes can be used:
  * Scanning a single bottle into the Search control takes you to the screen
to drink that bottle.
  * Or click **[https://www.cellartracker.com/list.asp?Table=Scan Scan barcode
labels]** to scan multiple bottles at once for relocation or consumption.
  * Or click **[https://www.cellartracker.com/bulkscan.asp Click for bulk
entry]** to scan even more quickly or gather input from memory based scanners.
  
As mentioned above, you can also add wine to your cellar by scanning an
ExistingUPC.
  
There are three types of labels:
  1. Unique per-bottle barcodes. This is what is [LabelTypes pictured on this
page].
  1. 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.
  1. You can also generate barcodes for your storage locations and bins. This
allows you to [https://www.cellartracker.com/list.asp?Table=Scan 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 ==
  * **BARCODE PRINTER:** 
[http://www.amazon.com/gp/product/B0027JBLV4?ie=UTF8&tag=cellartracker-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=B0027JBLV4
LabelWriter 450] (~$90) or 
[http://www.amazon.com/gp/product/B0027JIIKQ?ie=UTF8&tag=cellartracker-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=B0027JIIKQ
LabelWriter 450 Turbo] (~$120).
  * **BARCODE LABELS:** There are several LabelTypes with the default
[http://www.amazon.com/exec/obidos/ASIN/B00004Z60P/cellartracker-20 Dymo 30336
(White 1" x 2-1/8" Labels)], ~$14.95 for 500 labels, (NOTE: you will
not find these at Office Depot.)
  * **(OPTIONAL, OPTION A) WIRED BARCODE SCANNER:** CipherLab 1070 (~$40, USB,
model #A1070CBS0U001);
[http://www.barcodediscount.com/catalog/cipherlab/part-a1070cbs0u001.htm Buy on
BarcodeDiscount].
  * **(OPTIONAL, OPTION B) WIRELESS BARCODE SCANNER:** CipherLab 1560 (~$260,
USB base, model #A1560CBK0H002);
[http://www.barcodediscount.com/catalog/cipherlab/part-a1560cbk0h002.htm Buy on
BarcodeDiscount].
  * **(OPTIONAL, OPTION C) WIRELESS POCKET LASER BARCODE SCANNER:**
Scanfob® 2002 for Windows (Scanfob® is a registered trademark of
Serialio, LLC), Mac OS X, iOS: Bluetooth (~$299); Buy on
[https://serialio.com/store/product_info.php?cPath=38_58&products_id=603
serialio.com].<br>(NO built-in Bluetooth on Windows or Mac? Also get this
USB Bluetooth adapter: (~$49 ); Buy on
[https://serialio.com//store/product_info.php?cPath=23&products_id=214
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. People using
Socket barcode scanners also need to enable support for scanning ANY LENGTH of
ITF barcode. That can be done with [http://www.cellartracker.com/socket.pdf PDF
configuration file] here. Just scan the proper barcode.//
  
== Steps for Windows Users ==
  * **Installation** - [https://www.cellartracker.com/dymo.asp Automated
install troubleshooter]
    1. You need to [http://sites.dymo.com/Support/Pages/Drivers.aspx install
the latest DYMO software]. **The simplest solution is to install the 8.3 or
later software, and then no further configuration should be required in ANY
major browser.**
    1. 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 [InternetExplorerTrustedSites accept the ActiveX control or add
CellarTracker to your list of trusted sites]. //(definitely required on Vista)//
**FireFox**: **[http://www.cellartracker.com/xpcom/install.htm Install the XPCOM
extension]**. (You may need to do some [FireFoxExtensions 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 click on
**[https://www.cellartracker.com/list.asp?Table=Labels Print barcode labels]**
in the Actions section of the navigation bar.
    1. Press the PRINT USING DYMO button. This will give you a preview.
    1. 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.
    1. 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 [https://www.cellartracker.com/list.asp?Table=Labels&Pending=False
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) - [http://www.cellartracker.com/dymo.asp
Automated install troubleshooter]
    1. Install the [http://sites.dymo.com/Support/Pages/Drivers.aspx 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”.)
    1. You **MUST RESTART YOUR MACINTOSH** after you install the Dymo
software.
  * **Instructions**
    1. As of 5/8/2010, at last, the rest is the same as above for Window
users. You can print directly from the CellarTracker website with no special
scripts required.
NOTE: Sadly, 
[https://dymodevelopers.wordpress.com/2011/07/28/dymo-label-software-version-8-3-1-for-mac/
per Dymo], Chrome versions 22 and higher have broken the way they implemented
their library. There is no fix until Dymo makes a new version of their library,
and right now they are saying this is Q2-2013.
== 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
[https://www.cellartracker.com/labelsettings.asp Change Label Settings]. More
adventurous users can also modify the label templates that are loaded by the
Dymo software [CustomBarcodes as described
[https://www.cellartracker.com/content.asp?iContent=24 help content 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 [BarcodeMailMerge Microsoft Word mail
merge] to comparable Avery labels using the site, but this is ONLY recommended
for those users who are quite technical.
  
-------
CategoryFAQ

Front Page | Recent Changes | Title Index | Help
Edit this page | View other revisions
Print this page | View XML
Find page by browsing, searching or an index
Edited October 31, 2013 (hide diff)