Re: [IUG] Creating holdings list for Serials Solutions

["Sally Smith" <ssmith at bethel dot edu>]

Hi Sara,
The url which I use, is the url to our OPAC plus the bib record, (=b2227432)
which can easily be extracted in Create Lists.
http://clicnet.clic.edu/record=b2227432

Exporting the dates was problematic, and I tried a variety of techniques all
to no avail.  In the end it took manually cutting and pasting to sort out
all of the holdings information.
 
In my Create List, I included the Acq Status, this enabled me to quickly
identify titles no longer received and the end dates.  For dates of
currently received titles it was just a matter of learning to read the very
long string of data.

In your spreadsheet you are able to indicate gaps (just separate by
semicolon) for example in your Start Date column 1969-1976; 1990 

Limited retention can be displayed as "3 months ago" in the Start column and
Serials Solutions supplies "to present" in an empty End column.

I also created separate files for different formats, so a user can readily
see the format for the holdings listed.

"from 1936 to 1987 in Bethel University Microfilm Drawers
from 1987 to present in Bethel University Print Journals"

Good Luck,
Sally


Sally Smith                 
Bethel University Library/Serials Dept.    
3900 Bethel Drive  St. Paul, MN 55112 
Phone:  651-635-8544   Fax:  651-635-1971 
http://www.library.bethel.edu/
 

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Sue E Boggs
Sent: Wednesday, February 13, 2008 2:13 PM
To: IUG INNOPAC List
Subject: Re: [IUG] Creating holdings list for Serials Solutions

If I recall correctly when we sent our list to Serials Solutions I
exported all that data into an Excel spreadsheet and manually deleted
the end date from our holdings lines and put it in a separate column. We
weren't using holdings records at that time and had all that data in an
866 in the bib record in the format v.6-14 1970-79. For Serials
Solutions it had to read v.6 1970 in one column and v.14 1979 in
another.

Sue

Sue Boggs
Cataloging & Library Technician
Technical Services
Library
University of Puget Sound
1500 N. Warner St. #1021
Tacoma, WA 98416-1021
(253) 879-2667
boggs at ups dot edu
 
 
> -----Original Message-----
> From: innopac-bounces at innopacusers dot org [mailto:innopac-
> bounces at innopacusers dot org] On Behalf Of Sara Cinquemani
> Sent: Wednesday, February 13, 2008 10:53 AM
> To: innopac at innopacusers dot org
> Subject: [IUG] Creating holdings list for Serials Solutions
> 
> Hi everyone,
> 
> I am trying to create a list of our print holdings to update our
> Serials Solutions A-Z list. I need the following information to send
> them: title, ISSN, coverage date start, coverage date end, and the url
> for the catalog record. I can create a list of titles and ISSNs
easily,
> but I can't figure out if there's a way of exporting the start and end
> dates separately, nor can I figure out how to pull up the url. Does
> anyone have any experience coming up with this kind of data,
especially
> for Serials Solutions?
> 
> Thanks!
> Sara Cinquemani
> 
> Serials Librarian
> Hofstra University
> Sara dot Cinquemani at hofstra dot edu
> --
> This message was distributed through the Innovative Users Group
INNOPAC list
> Public replies:  INNOPAC at innopacusers dot org
> Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac

--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC at innopacusers dot org
Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac