label creating and scanning of books

Now that we have a way of recording books and people who check out books we need to figure out how t make this easier. Having someone type in the book title and student name at checkout time will be a time consuming process and lead to errors. If there are two sudents with the same name, there will be errors. If there are multiple books with the same name and author, this will cause errors. We need to come up with a way to streamline this process. The obvious thing is to look at what a library does and replicate this.

If you go to a local library, they have a bar code scanner at checkout and scan each book when you check out. The bar code does not need to be an industry standard but something unique that identifies the book. This can be easily done by using the book identifier provided by LibraryThing.

The first thing that we did was to look at scanners that are available. This was done by going to the Micro Center, Frys, and Radio Shack. The only scanner that was available commercially is the scanner. We purchased the hand scanner for $250 and made sure that it worked with our laptop. The specific scanner that we purchased was the WLR8900 scanner. This worked very well in reading the ISBN bar codes that were on the back of most books.

The second thing that we wanted to do was to print out own labels since to books will resolve to the same book if we us the ISBN number on the book. To do this we purchased some software from a local office supply store. The software that we purchased was the Avanquest Label Maker 4.0 software for $25.  Using this software we are able to import the data from LibraryThing and print out a label using a barcode on a standard Avery label.

The label that we wanted to use needed to contain a barcode that uniquely identifies the book. We also want to print out the book title, author name, the dewey decimal number, and the HSE Library. This is easy to do through the Design interface of Label Maker. We initially picked an Avery label format 8250 so that we can have 30 labels per sheet. This create a 2 5/8 inch by 1 inch label.

Our initial tests with the barcode did not work very well because the printer that we used were not of very good quality. We initially picked Code 128 format for the barcode layout. To make the printing easier we increaed the space width by 10% and increased the bar width by 10%. Once we did this we had very few scan failures. When we did a random sampling of 1000 labels, less than 2 per sample required multiple rescans to read the barcode. We used standard Times New Roman font to get the label and text on the label. Once we printed this label it was easily put on the last page of the book. This is probably the most labor intensive part of getting everything done but it does allow us to uniquely identify books.

Once we had the format properly created, we needed to import the book inventory ino the Label Maker software. This is easly done by defining the data table with some unique titles to make importing easier. If we define the columns as follows, the excel table that we try to import will come in easily without modification. The table looks like:

 – author (last, first) 

 – author (first, last)

 – Title

 – ?book id


 – Your Tags

 – DCC

When we try to import the excel data sheet, we need to first save the Excel sheet as a comma separated file. In doing this we can use the File->Import option to bring in the csv file. When we do this we get data entries of the entire library.

On a weekly basis we import the library list and sort it by date entered into LibraryThing. When we import the csv file, we do not import the entire library list but only books that have been entered since the last label printing. This is done by truncating the csv file to include a list of books from the last week or two weeks and importing it into the Label Maker software.

This process has been very effective in tracking books and correlating them to users. The students are required to have a picture id that has their student id on the card. We can easily scan the book bar code a well as the student id which is also a bar code and correlate the two in a database or Excel spreadsheet.

The execution of printing labels is realtively easy. The difficult parts are setting up a printer on the library laptop because the IT department does not want to support printers or something that they did not install. They also do not want to support the Label Maker software since it was not purchased by them. Fortunately, these items are easy to setup but it does require having an administrator login and execute the setup scripts. Once this has been done the library system is relatively easy to use on a weekly basis to print labels as well as check in and check out books.

Up next, we will look at the logic required to implement a checkout system using a database as well as through application express.


One thought on “label creating and scanning of books”

  1. I just came across your blog, it was a really interesting read! On the subject of label printing, i actually get all my labels printed by a british labels company for a really low price. If anyone is at all interested then it may be worth taking a look at their website as they do all types of label printing.

  2. how to check credit check

    Furnished apartments for rent ( Video
    Furnished apartments for rent Furnished apartments for rent Furnished Apartments for Temporary Rental in Munich Home is Where the Job Is Not only corporations arrange housing for employees Labor market changes housing market: furnished temporary rental apartments gaining popularity with expats and project employees New Munich residents increasingly start off with temporary rentals Forty years at the same company in the same place – that is a thing of the past: Flexibility, globalization, and mobility are changing not only the working world, but also increasingly the housing market. “Especially in large cities like Berlin, Hamburg, or Munich furnished apartments for …
    The post Furnished apartments for rent ( Video appeared first on Credit.

    San-antonio Business
    cleveland cars hull
    toad software review


  3. my campus
    Decorative Concrete of Virginia, Stained Concrete, Stamped Concrete, Concrete Restoration, Epoxy, Concrete Overlay, Polished Concrete, credit restoration.Credit restoration
    credit restoration Welcome! We have been serving Lynchburg, Roanoke, Charlottesville, Lexington, Richmond, Danville and the surrounding areas for 16 years. Stained Concrete Our beautiful stained concrete system creates mottled color tones in existing concrete. Metallic Epoxy Coatings Our designer epoxy coating is a unique product that is capable of creating marbled colors on any existing concrete surface. Polished Concrete Countertops Our highly customizable lightweight concrete countertops can be designed to fit any modern or rustic decor. Sprayed Concrete Overlays Sprayed concrete overlays, while beautiful, create a safe non-skid surface ideal for pool decks, patios and walkways. Vinyl Chip Epoxy Urethane …
    The post Decorative Concrete of Virginia, Stained Concrete, Stamped Concrete, Concrete Restoration, Epoxy, Concrete Overlay, Polished Concrete, credit restoration.Credit restoration appeared first on Credit.

    Commercial News
    drafting jobs san antonio
    infusion brewery
    reply must sms in
    cool math games evil wyrm

    TOP 250 FREE DOFOLLOW SITE LINK LIST…%0AThe+post+Cinturon+de+seguridad+%29+Video+appeared+first+on+Car+Auto+News.%0D%0A%0D%0A+%0D%0ACorpus-christi+Finance&g-recaptcha-response=

Leave a Reply

Your email address will not be published. Required fields are marked *