advertisement

PRODUCING BARCODES IN WORKFLOWS Jan 2007

50 %
50 %
advertisement
Information about PRODUCING BARCODES IN WORKFLOWS Jan 2007
Education

Published on June 18, 2007

Author: Woofer

Source: authorstream.com

advertisement

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

Add a comment

Related presentations

Related pages

Insert a barcode into an Office document - Office Support

... you may need to insert a barcode into your 2007 Microsoft Office system file ... This means you can easily view all of the associated workflow, ...
Read more

Workflow Automation Software & Platform - Nintex

The Nintex workflow automation platform can streamline your everyday business processes, saving you time and money. Start a free trial today!
Read more

Patent WO2013109276A2 - Progressive barcode - Google Patents

... typically producing a ... typically configured such that the prior stage of the progression of the barcode through the workflow cannot ... 2007: Paul ...
Read more

Step by Step Approach to Create a Visual Studio SharePoint ...

Create a Visual Studio SharePoint Workflow (sequential).; Author: Melick; Updated: 12 Jul 2013; Section: SharePoint Server; Chapter: Enterprise ...
Read more

c# - Copy ID column from List A to TASK List B using ...

I have created approval workflow in SPD 2007. ... 100 – CsharpGuru Jan 17 '11 at 18:05 ... Shortest infinite loop producing no output
Read more

Jan Tielens' Bloggings - Where did Workflow go In ...

If you have installed Microsoft Office SharePoint Server 2007 ... did Workflow go In SharePoint Designer ... opened the wizard to create a new workflow.
Read more

Introduction to Microsoft Office SharePoint Server 2007 ...

Introduction to Microsoft Office ... customize Office SharePoint Server 2007 sites and workflows. ... of producing and maintaining variations ...
Read more

Barcode Service Providers capable of producing RSS Barcodes

Barcode Service Providers capable of producing RSS Barcodes Author: sarad Created Date: 1/23/2007 11:29:53 AM ...
Read more