Re: [IUG] exporting with URL for Serials Solutions

["Sue E Boggs" <boggs at ups dot edu>]

You are so right. Thanks to you and Robert for pointing out that
important detail I forgot.

Sue

Sue Boggs
Cataloging & Library Technician
Collins Memorial 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 John De La Fontaine
> Sent: Thursday, September 04, 2008 4:53 PM
> To: IUG INNOPAC List
> Subject: Re: [IUG] exporting with URL for Serials Solutions
> 
> One further note of clarification:  the last digit of a bib number is
a
> check digit and it needs to be trimmed from the URL as Sue
demonstrates.
> I find the best way to do this is to use the "left" (Left 7 since a
bib
> is 8 digits) function in Excel copying the results into a new column.
> Next Copy Special (the literal/text value) the contents of the
> 'function' column into yet another column. The first two columns can
> then be deleted and the trimmed Bib number remains. In this column
Find
> 'b' and replace it with the beginning of the URL. [ example:  b  will
be
> replaced with http://simon.ups.edu/record=b ]
> 
> This is hairy, I know, but my experience is that the URLS will not
with
> the check digit included.
> 
> Best of luck,
> 
> John de La Fontaine
> Systems Librarian
> Occidental College (Los Angeles)
> 
> 
> 
> -----Original Message-----
> From: innopac-bounces at innopacusers dot org
> [mailto:innopac-bounces at innopacusers dot org] On Behalf Of Sue E Boggs
> Sent: Thursday, September 04, 2008 3:36 PM
> To: IUG INNOPAC List
> Subject: Re: [IUG] exporting with URL for Serials Solutions
> 
> Welcome to the Serials Solutions group. Create a list of all your
> journal records and export the bib numbers. In Excel, add your catalog
> url/record= and you'll end up with a column of url's such as this
> http://simon.ups.edu/record=b1174059. Of course if you use Ezproxy
> you'll need to add that in too.
> 
> Sue Boggs
> Cataloging & Library Technician
> Collins Memorial 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 Gregory, Gwen
> > Sent: Thursday, September 04, 2008 2:39 PM
> > To: IUG INNOPAC List
> > Subject: [IUG] exporting with URL for Serials Solutions
> >
> > Hi - We are a new user of Serials Solutions.  To construct our A-Z
> list including print
> > holdings, I need to get a spreadsheet which includes a column
> containing the URL
> > to access the catalog record for each of our titles.  Does anyone
have
> suggestions
> > as to how to do this?
> >
> > Thanks, Gwen
> >
> > --------------------------
> > Gwen M. Gregory
> > Associate Director for Technical Services
> > --------------------------
> > John Marshall Law School Library
> > 315 S. Plymouth Ct.
> > Chicago, IL  60604
> > 8gregory at jmls dot edu
> > (312) 427-2737 x580
> >
> >
> > --
> > 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
> 
> --
> 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