Re: [IUG] exporting with URL for Serials Solutions

["John De La Fontaine" <delafo at oxy dot edu>]

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