by H. Vernon Leighton
Autodocs is an electronic check-in and shelflist system designed to be used with Microsoft Access 97. (It has been tested and can be converted to Access 2002.) It allows one to download an electronic shipping list to check-in and shelflist receipts without keying in shipping list data. There is a method of handling items that regularly arrive without a shipping list. Labels are generated only at the end of the session, not at the end of each shipping list, thereby reducing the number of wasted blank labels.
The zipped version of the Autodocs system and documentation
is located at:
The User's Guide and FAQ to the Autodocs system is located at:
Within the zipped packageare files entitled:
autodocs readme first.txt - this introduction file
autodocs14.mdb - the autodocs system itself, in Access 97 format
autofaq.htm - likely questions and general information about Autodocs answered about Autodocs in html
autotutorial.rtf - an detailed walk through of the features with the preinstalled demo data tables.
procedures14.rtf - the detailed procedures for checking in materials
procedures14.doc - the same file in Word 2002 format.
ship.dbf - a shipping list of paper items that can be used to test the check-in. (They are not yet in the database.)
The Types of Items Checked-in
I have created four classes of items that get received: the first three are paper, maps, microfiche and electronic items. All formats allow you to manually key data into a blank shipping list. All formats except maps also allow the user to import shipping lists in dBase format as downloaded from the FedBBS web site. The paper format also allows users to customize a list of direct mail items. There are many fewer of these than there were in 1999 when Autodocs was first released.
I have created functions to allow the list of items selected and the other lists (e.g., superceded items) to be printed out so that the items can at least be checked in and processed manually if necessary.
The Check-in Process (briefly)
For shipping lists where there is an electronic copy in dBase format on the FedBBS, the first step is to and download the shipping list to your hard drive, and then prepare to import it into Autodocs.
The shipping list that was downloaded from the FBB server is automatically run through the institution's selection profile, so that person checking the material in (the checker) only sees those items that matched the profile. (There is the obvious drawback that these lists aren't perfect, but there is a function to edit and add to the shipping list if the items fail to be processed due to typos on the shipping list.)
After the shipping list is filtered against your selection profile, the system checks helper tables for a match to the item. I have customized these tables for our operation at Winona State, so I apologize to anyone who has a different setup and wants to use this system without having to customize it.
I have three helper tables. The first tries to match the new item to the 1996 list of items that are superseded. The second matches the item against a local list of items that get special treatment (for example, the series gets cataloged in Library of Congress and is in a different location with a different call number). The third table changes the label information if the series gets a special label (for example, slip laws in our depository all get a quick label with an LC number, though they are not individually barcoded and cataloged).
I call the shipping list that has been enhanced with local details the "check-in list". It is stored in a table called the Intermediate Ship Table. Step three in the check-in process is to display this enhanced check-in list for review. The checker then compares the displayed records to the actual items received and to the paper shipping list. If an item is not received, the person can delete the item from the check-in list. If an item is on the superseded list, the person can automatically search the shelflist for all items that have the same class stem, to easily delete the superseded edition. The check-in list record will indicate special handling of a class gathered from the helper tables. Labels can be suppressed at the individual item level. What the label says can be changed on the fly by the person processing.
Once that list is finished, the checker may add the label items to the label job. Then the checker may in step 4 add the items to the shelflist, and delete the just finished shipping list in preparation for a new one. At the point of adding to the shelflist, a field is created that allows items to be sorted by SuDoc number. (The algorithm for this sorter is adapted with permission from SuDS by Stanley Price at USC Aiken.) When check-in is finished, the checker runs another macro that prints labels and deletes the temporary label table.
The final shelflist can then be searched by Sudoc number, by date, by title keyword or phrase (but not Boolean syntax), by item number, and by format, or any intersection (Boolean AND) of those searches. The searches are automatically truncated, so you can search for all items from the Geological Survey (I 19) that have the phrase "Mississippi River" sent on a shipping list from a given year, etc. The searching is not world class (fully SQL), but it works. Skilled Access users can create their own queries.
What is Missing
I have not yet developed a weeding module that creates candidate weeding lists from the shelflist. At Winona State, we have only been using the system for four years, so there are no older records yet to weed. When I looked at Kendra Swope's system, she had a table for storing information about the shipping list, which I decided not to include. (Too much keyboarding.)
One major structural problem is that there are no serial records. Every piece is treated as a unique item. The reason for this is that the shipping list treats each item as unique. My goal in this system is to reduce the amount of keyboarding that the checker needs to do. Adding a serial record would, I believe, add to the keyboarding and the time that check-in requires. I do not think that serial records are absolutely necessary, especially since you can search the shelflist by class number and pull up all items in the series. So I have stressed the convenience of the checker over the cleanness and friendliness of the database.
I wanted the form to automatically rebuild the sorting field when you change the sudoc number in a Main Shelflist record. I fought Visual Basic, and Visual Basic won. You have to rebuild all of the sorting fields of all of the records in order to fix the ones that you had edited. If anyone is a VBA hacker and can fix it, please contact me. I will give you credit if you succeed.
revised hvl 9/12/2007