PRODUCING BARCODES IN WORKFLOWS Jan 2007

PRODUCING BARCODES: 

PRODUCING BARCODES In Workflows Library Services Lisa Wendt Chris Seckman January 4, 2007

Producing Barcodes / Spine Labels => => => here’s what you need <= <= <=: 

Producing Barcodes / Spine Labels =andgt; =andgt; =andgt; here’s what you need andlt;= andlt;= andlt;= Laser labels and a LASER PRINTER (not a deskjet!) Barcode log Microsoft Excel (comes with MS OFFICE software) Free 3 of 9 Font andamp; The Barcoder Program http://www.infohio.org/Documents/SirsiManual/Sirsi31/SirsiHandbook31.html MEC version Barcode / Spine Label Spreadsheet [Link] Free 3 of 9 (Barcode) Font and installation instructions  [HERE}

Barcodes / Spine Labels => => => Printers & Labels <= <= <=: 

Barcodes / Spine Labels =andgt; =andgt; =andgt; Printers andamp; Labels andlt;= andlt;= andlt;= Be sure you are printing to a LASER printer and not a deskjet printer! LABELS: Barcodes =andgt; Avery #5160 (or equivalent) =andgt;3 across x 10 down =andgt;1' x 2-5/8' Spines: =andgt; 8 across x 7 down =andgt;1-1/2' x 1'

Keeping “The Log” : 

Keeping 'The Log' Your Library Name My Item Barcode Range =andgt; 01 000 000x – 02 000 000x Assignment of Item Numbers: VENDOR: # RANGE USED #s Dumb: 01 990 000x – 02 000 000x 01 990 000x – 01 990 299x 01 990 300x – 01 990 599x Follett: 01 200 000x – 01 300 000x 01 200 000x – 01 200 199x Reading Counts: 01 300 001x – 01 400 000x 01 300 001x - 01 300 089x Rainbow Reading:01 400 001x – 01 500 000x 01 400 001x - 01 400 189x

Get familiar with the Barcoder Spreadsheet: 

Get familiar with the Barcoder Spreadsheet Open the Excel file named INFOhioBarcodesSpineLabels.xls. Note: When opening the file, a Macro warning may be presented. For this spreadsheet, select the Enable Macros button. THIS ONLY NEEDS TO BE DONE THE FIRST TIME YOU USE THE SPREADSHEET: If the pop-up window informs you that 'Macros in this workbook are disabled because the security level is high', it will be necessary to adjust the Macro security level by selecting the following options within Excel:

Setting the security level of the Barcoder Spreadsheet: 

Setting the security level of the Barcoder Spreadsheet Tools Macro Security Medium. You can choose whether or not to run potentially unsafe macros. OK It will then be necessary to exit and re-start Microsoft Excel. While exiting, you will be prompted as to whether or not you want to save the changes you made to INFOhioBarcodesSpineLabels.xls'. Be certain to select the 'No' button to exit without saving. You can then load the INFOhioBarcodesSpineLabels.xls spreadsheet again.

Get familiar with the Barcoder Spreadsheet: 

Get familiar with the Barcoder Spreadsheet Once the spreadsheet is properly opened, notice the series of tabs in the middle of the spreadsheet labeled Users (Patrons) Items andamp; Spines Dumb Barcodes Replacement. These tabs represent different options available for barcodes. Select the tab for the barcodes you wish to generate.

Using the Barcoder Spreadsheet: 

Using the Barcoder Spreadsheet Enter your district, building name and Institution Code. (This is only done once if you save the spreadsheet when you exit.)

Using the Barcoder Spreadsheet: 

Using the Barcoder Spreadsheet Tweak Print Format – This will allow you to adjust your margins if the spacing is off on the labels. (Test the label print before adjusting) Click the Tweak Print Format Click OK Select the Margins tab and adjust the Top margin up or down one click by using the arrows. You may need to adjust a 2nd time. Change Header/Footer to zero. SAVE the spreadsheet and you will not need to set the margins again.

Barcode Tip : 

Barcode Tip

Producing USER Barcodes: 

Producing USER Barcodes

Producing USER Barcodes: 

Producing USER Barcodes Click Schedule New Reports wizard. Click the INFOhio tab. Select the appropriate report. Click Setup andamp; Schedule Open Workflows – Select REPORTS * Change PAGE WIDTH property to 200; click OK

Producing USER Barcodes: 

Producing USER Barcodes 1. Select BAR: User Bar Codes and then select the Setup andamp; Schedule button. 2. Select the SELECTION CRITERIA tab and use gadgets to limit barcodes produced.

Producing USER Barcodes: 

Producing USER Barcodes The output file will be opened in Word pad, Notepad, or Microsoft Word (as set in your print properties). 4. When the report is complete, select the results from the Finished Reports menu and then select the View button. 5. When presented with the View Finished Reports window, uncheck the View log and Format report options.

Producing USER Barcodes: 

Producing USER Barcodes From the File menu, select Save As. a. Save the file to a directory of your choice; ie: C:\INFOhio b. When saving the file, use the name 'user.txt'. c. Be certain to save the file as a text file.

Importing USER.TXT file into the Barcoder Spreadsheet: 

Importing USER.TXT file into the Barcoder Spreadsheet a. File location: This is where the Workflows report was saved. You can click the browse button if you need to find the file user.txt b. Import File – Click this button to import the data from the report you ran in Workflows. A message will open showing the number of barcodes. c. Barcodes – Click this button to create the barcodes. You will receive a message to save the file or not , you may click yes or no. d. Printing - The Excel spreadsheet will open with your barcodes displayed. Select from the top menu File – Print When your are finished printing the barcodes, CLOSE the page (not necessary to save it) and/or Excel.

Producing ITEMS & SPINES barcodes: 

Producing ITEMS andamp; SPINES barcodes

Barcode Tip : 

Barcode Tip

Producing ITEMS & SPINES barcodes: 

Click Schedule New Reports wizard. Click the INFOhio tab. Select the appropriate report. Click Setup andamp; Schedule Producing ITEMS andamp; SPINES barcodes * Change PAGE WIDTH property to 200; click OK Open Workflows – Select REPORTS The output file will be opened in Word pad, Notepad, or Microsoft Word (as set in your print properties). 1.

Producing ITEMS & SPINES barcodes: 

Producing ITEMS andamp; SPINES barcodes 2. Select BAR: Barcodes for Items report and then select the Setup andamp; Schedule button. 3. Use the SELECTION CRITERIA tab to filter data, schedule the report to generate an item data file. 4. When the report is complete, select the results from the Finished Reports menu and then select the View button. 5. When presented with the View Finished Reports window, uncheck the View log and Format report options.

Producing ITEMS & SPINES barcodes: 

Producing ITEMS andamp; SPINES barcodes From the File menu, select Save As. a. Save the file to a directory of your choice; ie: In this lab: C:\INFOhio or to your own desktop b. When saving the file, use the name 'item.txt'. c. Be certain to save the file as a text file.

Importing ITEM.TXT file into the Barcoder Spreadsheet: 

Importing ITEM.TXT file into the Barcoder Spreadsheet a. File location: This is where the Workflows report was saved. You can click the browse button if you need to find the file item.txt b. Import File – Click this button to import the data from the report you ran in Workflows. A message will open showing the number of barcodes.

Produce BARCODE and/or SPINE labels: 

Produce BARCODE and/or SPINE labels Spine Labels – Follow the same procedures for producing ITEMS except SELECT the SPINE LABELS button. You will receive a message to save the file or not , you may click yes or no. When your are finished printing the barcodes CLOSE the page and/or Excel. c. Barcodes – Click this button to create the barcodes. You will receive a message to save the file or not , you may click yes or no. d. Printing - The Excel spreadsheet will open with your barcodes displayed. Select from the top menu File – Print When your are finished printing the barcodes, CLOSE the page and/or Excel.

Your turn… : 

Your turn… Take a break ! Try producing a set of patron or item smart barcodes on your own

Barcode Tip : 

Barcode Tip

Producing DUMB barcodes: 

Producing DUMB barcodes No need to use Workflows for dumb barcodes !

Producing DUMB barcodes: 

Producing DUMB barcodes Dumb Barcodes – You will create either Patron or Item dumb barcodes with this screen. a. Select Patron(2) or Item(3) b. Enter the number of barcodes you wish to generate. c. Enter the starting number you were given by NOECA. d. Click the Dumb Barcodes button.

Producing DUMB barcodes: 

Producing DUMB barcodes When you are finished printing the barcodes, CLOSE the page and/or Excel. This helps you with your barcode log by giving the new starting barcode number Click OK; then print the barcodes

Not sure if your LOG is up-to-date ?: 

Not sure if your LOG is up-to-date ? Email library@noeca.net Include the range of barcode #s you want to use We will run a script to determine if this range is clear and will email you a list of used barcodes within your District

Producing REPLACEMENT barcodes: 

Producing REPLACEMENT barcodes

Producing REPLACEMENT barcodes: 

Producing REPLACEMENT barcodes Replacement – Use this screen to create a single barcode. Enter the data you would like on the barcode Scan or type in the barcode number. Click the Single Label button. When your are finished printing the barcodes CLOSE the page and/or Excel.

Slide32: 

Congratulations ! You are hereby certified to go forth and PRODUCE YOUR OWN BARCODES