PRODUCING BARCODES IN WORKFLOWS Jan 2007

Information about PRODUCING BARCODES IN WORKFLOWS Jan 2007

Published on June 18, 2007

Author: Woofer

Source: authorstream.com

Content

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 [email protected] 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

Related presentations


Other presentations created by Woofer

Power Point Basics
19. 06. 2007
0 views

Power Point Basics

Intro to Latin America
03. 10. 2007
0 views

Intro to Latin America

Currall Energy Nano
01. 10. 2007
0 views

Currall Energy Nano

Welcome to the Aztecs
01. 11. 2007
0 views

Welcome to the Aztecs

halloween safety tips
02. 11. 2007
0 views

halloween safety tips

us army vehicle identific
07. 11. 2007
0 views

us army vehicle identific

Ebbes Personalisierung
16. 11. 2007
0 views

Ebbes Personalisierung

Lecture 17
22. 11. 2007
0 views

Lecture 17

Chiasson0306 4
30. 12. 2007
0 views

Chiasson0306 4

The Chemistry of Life
02. 01. 2008
0 views

The Chemistry of Life

ShortageofGirlsinChi na
12. 10. 2007
0 views

ShortageofGirlsinChi na

Masis
22. 10. 2007
0 views

Masis

AEP3 PPT Generic
27. 11. 2007
0 views

AEP3 PPT Generic

mod3 lecture 5b
05. 10. 2007
0 views

mod3 lecture 5b

vesseltracking
22. 10. 2007
0 views

vesseltracking

carynong
04. 10. 2007
0 views

carynong

svt formules sponsor
23. 10. 2007
0 views

svt formules sponsor

911 sp
26. 02. 2008
0 views

911 sp

Ballistics
28. 02. 2008
0 views

Ballistics

Gosnold IASPEI
22. 10. 2007
0 views

Gosnold IASPEI

Eco driving 4web
21. 03. 2008
0 views

Eco driving 4web

TerraCottaWarriors SDaly
26. 03. 2008
0 views

TerraCottaWarriors SDaly

2nd session6
27. 03. 2008
0 views

2nd session6

15 Man on the Moon
07. 04. 2008
0 views

15 Man on the Moon

switchroute1
01. 01. 2008
0 views

switchroute1

Nijenrode230507
28. 03. 2008
0 views

Nijenrode230507

2004intl USC Kumar
30. 03. 2008
0 views

2004intl USC Kumar

ernest adams
11. 12. 2007
0 views

ernest adams

5 Project01 04
04. 03. 2008
0 views

5 Project01 04

RoxanaBojariu
09. 04. 2008
0 views

RoxanaBojariu

frontline
10. 04. 2008
0 views

frontline

Mexico HOME BUIDERS ingles 8feb
13. 04. 2008
0 views

Mexico HOME BUIDERS ingles 8feb

Flowers lab
14. 12. 2007
0 views

Flowers lab

David Smith 20061102
14. 04. 2008
0 views

David Smith 20061102

AML Business Requirements neut
17. 04. 2008
0 views

AML Business Requirements neut

Preparing the Way Power Point
18. 06. 2007
0 views

Preparing the Way Power Point

prelims 2005
19. 06. 2007
0 views

prelims 2005

PORTS
19. 06. 2007
0 views

PORTS

Perkins IV Workshop 2007 draft 2
19. 06. 2007
0 views

Perkins IV Workshop 2007 draft 2

pascal
19. 06. 2007
0 views

pascal

Open House Presentation0412
19. 06. 2007
0 views

Open House Presentation0412

Presentation Rvbg
18. 06. 2007
0 views

Presentation Rvbg

Process Algebra as Modelling
18. 06. 2007
0 views

Process Algebra as Modelling

Presentation MA 02
18. 06. 2007
0 views

Presentation MA 02

prospectus mta nespl
18. 06. 2007
0 views

prospectus mta nespl

orientation 2006
19. 06. 2007
0 views

orientation 2006

ç04çDNSèä
23. 10. 2007
0 views

ç04çDNSèä

U9B2
24. 02. 2008
0 views

U9B2

Presentazione CorsoE
18. 06. 2007
0 views

Presentazione CorsoE

Presentazione CorsoA
18. 06. 2007
0 views

Presentazione CorsoA

Filatova
11. 10. 2007
0 views

Filatova

lemonade 0
29. 10. 2007
0 views

lemonade 0

MTScrapbook1
26. 07. 2007
0 views

MTScrapbook1

pb
19. 06. 2007
0 views

pb

Gut Feeling Mikels RIP
06. 08. 2007
0 views

Gut Feeling Mikels RIP

slides na3
27. 09. 2007
0 views

slides na3

Special Areas of Conservation
28. 12. 2007
0 views

Special Areas of Conservation

Braulio2
22. 10. 2007
0 views

Braulio2

Open House Pix
19. 06. 2007
0 views

Open House Pix

Legnaro Variola
04. 01. 2008
0 views

Legnaro Variola

PNUD SNU Agenda Nacional
19. 06. 2007
0 views

PNUD SNU Agenda Nacional

Plan Empleados SAGARPA
14. 11. 2007
0 views

Plan Empleados SAGARPA