The proces can be difficult.

The proces can be difficult, further the results are well worth the effort

I one time read the dictionary and idea it was a giant blank stave about everything.--comedian Steven Wright

close examiners who are doing research in any kind of library be attendant to have one question that overshadows all others: "I construct this citation; can I master the article in your library?" Finding the answer to that question formerly required looking at a printout list of the journals that the library held in paper, microfilm, or microfiche. Failing to find the journal there meant that the pupil had exactly two choices: drive to a library that holds the journal or request the article from interlibrary loan and wait a week or two

Our library's periodical manager kept this printout in big r binders that were updated twice a year. A fate can happen in 6 month further this was still a bonny good way to keep track of paper and microform holdings. However, as the library began adding more online journals, a small in number problems arose that ultimately expanded into a portion of problems. Students would check the r binders and find public that the college didn't avow the journal in paper or fiche. They would fill not at home an interlibrary loan form and wait for the article to arrive. A small in number days later, they'd get a note telling them that the library already memorizes that journal in ProQuest or Health intimation Center. Furthermore, there's a law library forward campus that makes its collection available for our bookish mans to use. Unfortunately, its holdings aren't in the big r binders either. My original goal was to provide bookish mans with one file that would range from A to Z and count them if they could find the suited journal within our system.

It pretends like a fairly simple task, further getting it done was the library equivalent of NASA's space program. It took nearly 3 years and dozens of "learning experiences" (i.e., failures) before we were able to proffer a truly adequate file.

My first challenge was to tackle the list of paper and microform resources. It had been lovingly kept in a program that was state-of-the-art during the Reagan administration. It actually comprised pair files that were brought together for display and printing objects but that couldn't be exported in a single file. Fortunately, we fix somebody on campus who knew for what cause to parse the data, in like manner we were able to reverse it into an Excel file. Since I wanted this information to appear forward the library's Web page, I decided to interchange the file to HTML. Naturally, I wanted it to appear in table format. When we were done, it examineed great-the problem was that the file took more than 5 minutes to load. In these days of MTV attention spans, anything that takes longer than 20 others is certain death. When we loaded the file in straight HTML brazen-faced text it looked fine, moreover we already had a problem: In the month that it took us to revolve out the file lots of journals came and went in the periodicals play and we were working wit h of long date data.

We ran this file for about a year until it was hopelessly out-of-date. The advantage of the file was that we could link each title to its record in the online catalog, in such a manner users could get current check-in data. However, the disadvantages outweighed this benefit.

The affair that helped us turn the corner was the conversion of the periodical database into a Microsoft Access file. It took about 6 month of false starts and "learning experiences," further when it was finished we had a file that could be exported to my PC between the sides of ftp and converted to bear the bell Also, I decided to give up in succession HTML for a file of this size, and started creating Adobe PDF files. Since we'd been working forward this for so many years and file naming was beginning to be a question at issue I worked out a naming classification for all working files: "allpaperandfichedate." one time I converted the files to Adobe PDF they were always called "periodicals.pdf." I ground that by converting the file in landscape rather than portrait print format I had latitude for 80 characters of title, and the filled information about the journal--including title changes, ISSN, and volume

At the same time, I was beginning to compile a list of full-text holdings based forward vendor data. This was a challenge in many ways--different vendors bring this data in different formats, gave varying evens of description, and adhered to different quality-control standards. I worked gone out a bare-bones format that would mask all cases: the title, the beginning year of replete text, the ending year, and the vendor. Initially, I decided to take the approach that all vendor-provided data were accurate until proven otherwise with a given title.

by means of early this year, I had arrived at a format that worked for as well-as; not only-but also; not only-but; not alone-but physical and online journal holdings, with equal reason I added the file of online holdings to the original file and produc the first version of the A-Z list, which can be base at http://invictus.quinnipiac.edu/everything.pdf. Originally, we published three files: the paper and fiche holdings, the online-only holdings, and the combined holdings. Eventually, we sculpture out the online-only file. This was based in succession usage reports plus the ordinary sense notion that we didn't want to spread ourselves too thin.