Please excuse duplication to multiple lists.
Thank you to all for your help and suggestions! Here's a summation
of the solutions and suggestions for further inquiry that I've
received so far:
1. This suggestion from Ross Whitley at the University of Essex
Library uses text based access to III (i.e. PuTTY) and would
probably work best for sets of records smaller than 5,000 at most:
Create a list from a file of IDs – barcodes, record
numbers, OCLC numbers, etc by creating a list of keystrokes which
you can copy and paste to create a long search argument.
Keystrokes to search for bib record .b12345672 would be
09=.b12345672 [return]
To add a second line to the argument, to search for bib record
.b17654324, I would then key
o09=.b17654324 [return]
A search in INNOPAC can contain a maximum of 99 lines of searches,
so the way to construct a search would be:
- Get your list of IDs in MS Excel, and break it into batches
of 99 records each.
- Use the =CONCATENATE() function to add the four characters
o09= to the start of each bib record number [find and replace
all .b with o09=.b would work for this, too -- Chris Blackman]
- Copy and paste the entire list of prefixed bib record
numbers into Notepad
- Change the prefix of the first entry in your list to
09=.b12345672 [i.e. remove the letter ‘o’]
- Open INNOPAC and navigate to CREATE LISTS of records [for me
this is ML<initials><password>]
- Choose a file in which to perform your search, choose to
create a new file, and then select the type of list
[bibliographic]
- Copy your search string from Notepad and paste into INNOPAC
- Once all lines have been pasted, start your search by keying
S [you may need to press return before keying s]
- Give your file of records a name as requested by INNOPAC
- Wait for the search to complete
- If you have more than 99 items to search for, choose to
APPEND more records to file and copy the above steps for the
next set of items [again max 99]
Once finished, you can use INNOPAC to manipulate your list, or you
can move to Create Lists in Millennium and manipulate/export from
there.
2. This option from Ryan Finnerty of the UC San Diego Library uses
Data Exchange in Millennium and would work for large files. The
only caveat is that it requires a special load table.
[Turn] the file of bib numbers into MARC records using
MarcEdit, load the records in Data Exchange by matching on bib#
AND using a special load table that protects all existing data and
strips all incoming data. Check off use review files when loading
and when done copy your load file into an actual review file in
Create Lists. If you don't have edit/create access to your load
tables then you'd need to ask III to do make that table for you.
3. Lastly, it was brought to my attention that there was an IUG
session on the subject presented by Kathleen Botter, Systems
Librarian at Concordia University. It was titled "Turning a
Collection of Physical Items or Electronic List into Create Lists --
IUG Clearinghouse Script Redux."
Thanks again to all! This will make life much easier.
Chris
__________________________________________
Christine W. Blackman
Catalog Librarian
Williams College Libraries
Williamstown, MA
413-597-4403
cblackma@williams.edu