Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Path: utzoo!utgpu!water!watmath!clyde!rutgers!seismo!mcnc!ecsvax!ehr From: ehr@ecsvax.UUCP Newsgroups: comp.databases Subject: Re: Automated Slide Collection Message-ID: <3300@ecsvax.UUCP> Date: Fri, 29-May-87 18:06:03 EDT Article-I.D.: ecsvax.3300 Posted: Fri May 29 18:06:03 1987 Date-Received: Sat, 30-May-87 12:13:46 EDT References: <360@aucs.UUCP> Distribution: na Organization: UNC Educational Computing Service Lines: 83 Summary: Considerations for automating slide libraries (Sorry to post this long item. I tried to mail the following, but it got rejected somewhere along the way.) In response to your query about a database systems for slides: I would consider the ability to print small labels fairly trivial -- most printers (dot matrix or laser) should be programmable to produce some type of microfont that would allow production of labels with up to four lines of about 30-40 characters that would fit on a slidemount. A feature I would consider extremely important in addition to the actual database format would be some type of machine- readable label on the slide itself. This would facilitate checking slides in and out (a circulation function) and generating lists when slides are projected. With visual materials, a "text" catalog is useful, but sometimes the only way to make a final selection for whatever purpose -- study, projection in a classroom, publication, etc. -- is to look at the images themselves. Once that selection has been made, you need to (1) keep track of what the user is taking away from your files; and (2) supply the user with some type of list. The labels on the slides themselves are useful for some applications -- but no longer of any help once the slides are in a projector tray. I have seen applications with both barcodes on slides and a new system where a small magnetic strip is placed on the slidemount. The latter has the capability of carrying more information than a barcode (usually a file number only), and can be reprogrammed, if necessary. It is, however more susceptible to damage than a barcode label. If you are really going to use a computer to manage a sizable library of slides, it probably needs to be dedicated to that application -- that is if you are going to use a micro. For that reason, I would first find a software package that fulfilled my requirements, including an interface to a device capable of reading a barcode or magnetic stripe on the slides, then pick the type of hardware that the system is designed to run on. I don't have any specific hardware/software vendor literature handy at the moment, but could probably dig up some, given some time. There are even several books, produced by the Visual Resources Association -- a professional organization of art slide librarians working for museums and college art departments -- that discuss automating these types of collections. I hope these comments help. Let me know what specific information you want, based on the above, and I'll try to send some more along. To give you a frame of reference for what my comments are based on: (1) I am the system administrator for the Tandem super mini on which the Duke University library on-line catalog resides (60 terminals, currently) and worked as a cataloger for a dozen years before that. (2) In addition, I operate a stock photo business, supplying photos from my files to a variety of clients, chiefly book and magazine publishers. My personal collection consists of 25,000 35mm transparencies. (I do use a micro and data bases on it for my business, but these are less than ideal, largely due to financial considerations; I do hope to upgrade to some better hardware/ software within the next two years, and have been looking at available options.) (3) I am the outgoing chair of the Picture Division of the Special Libraries Association. And (4) In an effort to help others understand the application of library practices to picture collections, I wrote the book ORGANIZING YOUR PHOTOGRAPHS, which was published by Watson-Guptill's Amphoto division last year. The book is aimed primarily at professional photographers with no library background, but most of the principles discussed apply to all types of picture collections. Three of the chapters discuss computer applications. -- Ernest -- My opinions are my own and not necessarily IBM-compatible.--ehr Ernest H. Robl (ehr@ecsvax) (919) 684-6269 (w) Systems Specialist, Library Systems, (919) 286-3845 (h) Perkins Library, Duke University, Durham, NC 27706 U.S.A.