American Miltary Musuem Bulk Barcode Creation

Batch Print Barcode Labels
This document provides the step by step procedure for printing barcode labels. This document is available at C:\Users\tanklandlibrary\Google Drive\Library Documents\Procedures\Periodic - Technical Services - Bulk Barcode Print 2014 01 03.odt

Barcodes are the primary way that our media assets are identified. Each item, as it's placed into the Integrated Library System or Digital Archive System, is assigned a barcode as a unique key.

Barcode labels can be printed in both batch and individually. This document provides the procedure for batch printing barcodes.

The two significant tasks are to create the sequential barcode numbers, then to print them on the DYMO Label Software.

Create sequential barcode numbers
Open OpenOffice Calc

From the C:\Users\tanklandlibrary\Google Drive\Library Documents\Data Files\Barcode  directory,  select the barcode.xls file.

The barcode file will have a sequence of 250 numbers already generated. This is the last set of barcodes printed. Check the Barcode Generation log to ensure you are not duplicating numbers. Enter the first and last barcode number generated each time a batch or individual barcodes are generated. This step is accomplished in order to avoid repeated barcode numbers.

The Barcode Generation Log is located at C:\Users\tanklandlibrary\Google Drive\Library Documents\Data Files\Barcode in the file '''Barcode Generation Log.ods. '''

To create the sequential barcode numbers, you will use an automatic incrementing feature of the spreadsheet. First, add one to the last barcode number generated and type it in column A1. For example purposes, the number is 00002450. Type the next two sequential numbers in A2 and A3 respectively. For example: 00002450 and 00002450..

Then, highlight cells A1 – A3 and place the cursor over the small back square in the corner of the collum. Your pointer will become a crosshair when you successfully point at the right location.

Click and drag the highlighting down until you reach A250, the numbers should sequentially increment.

Place the date, beginning and ending numbers, and you name in the Barcode Generation Log is located at C:\Users\tanklandlibrary\Google Drive\Library Documents\Data Files\Barcode in the file '''Barcode Generation Log.ods. '''

If Open Office prompts you for format, you must keep the current format. The DYMO software does not read the .ods file format, only the .xls format.

Save the barcode.xls file.

Close OpenOffice Calc.

Create sequential barcode numbers
Open DYMO Label Software by doubleclicking on the DYMO Label v.8 icon.

<p style="margin-bottom: 0in">Open the saved Barcode template located on the drive.

<p style="margin-bottom: 0in">Selecting File->Open

<p style="margin-bottom: 0in"> Look in:  C:\Users\tanklandlibrary\Google Drive\Library Documents\Data Files\Barcode

<p style="margin-bottom: 0in">Select Barcode Label

<p style="margin-bottom: 0in">The screen will show the barcode label for the American Military Museum.

<p style="margin-bottom: 0in">Select File -> Import Data and Print -> New.

<p style="margin-bottom: 0in">Select Next to pass the Getting Started screen.

<p style="margin-bottom: 0in">Select the Browse button to choose your database file located at C:\Users\tanklandlibrary\Google Drive\Library Documents\Data Files\Barcode.xls

<p style="margin-bottom: 0in">Press Open

<p style="margin-bottom: 0in">Select Sheet1$ select Next.

<p style="margin-bottom: 0in">Click and drag Filed1 into the large box as show in the next screenshot. select Next.

<p style="margin-bottom: 0in">Press Print

<p style="margin-bottom: 0in">The barcodes will now print to your LabelWriter.