This Voyager 1202g barcode scanner has been great for our inventory project! I’ve had some questions from my co-workers about how much this scanner can really do in batch mode. Well I finally found something that says the scanner can hold 14,000 twelve digit numbers in it’s memory. Even though our barcodes are 14 digits long, I think my colleagues can rest easy…the biggest file students have scanned so far is only 321 barcodes. That’s still a lot of books to manually scan in one sitting, but our scanner can handle it.
This is the third time I’ve needed to look-up/remember how to take a list of barcodes, convert them to oclc numbers in Aleph, and run the list through SUNY Geneseo’s Getting It System Toolkit Gift & Deselection Manager v22.214.171.124. So I’m writing directions for myself and anyone else who finds themselves in a similar situation.
- Get a text file with barcodes (one barcode per line and file name saved with lowercase letters/numbers – no spaces)
- Upload the barcode file into Aleph’s the xxx50/scratch/directory
- Open Aleph client (Circ or Cataloging)
- Run p_manage_70 = Services -> General -> Retrieve Record Keys (manage-70)
- Choose BARCODE-TO-BIB for “Convert Type”
- Write xxx01 in “Convert Library”
- Make note of the output file name
- In the Cataloging module, run print-08 = Services -> Retrieve Catalog Records -> Print Catalog Records – Columnar Format (print-08)
- Enter previous output file as the new input file
- Choose “OCLC Reclam: Doc no. | Title | 035 | 935” for Report Format
- Copy and past results into MS Excel
- Split the 035 column to separate (OCLC) from the numbers
- Data -> Text to Columns (It is ok to loose leading zeros in the oclc number)
- Save the list of OCLC numbers as a txt or csv file
- Open the Gift and Deselection Manager (GDM)
- Go to File -> Batch Analysis
- Open File, choose options, and click “Begin Batch Process”
- This can take a few seconds for each item. Be patient… walk away, multitask, or go home for the night 😉
- When the batch process is over, you will get a message to save the batch process output as an excel file.
Attribution: I want to recognize SUNY OLIS and Natalie Sturr for providing some directions on “How To Create a Report of Bib Information from a File of Barcodes.”