Re: [IUG] print holdings in Serials Solutions

["Bissen, Sheryl" <bissen at grinnell dot edu>]

I use Excel and Text to Columns to limit the bib record column to 8 digits rather than 9 (with the b included).

I then use Replace to change 'b' to 'http://cat.lib.grinnell.edu/record=b'

It is a pretty simplistic approach but using this method I don't have to worry about using the concatenate then copying the values only.

Sheryl Bissen
Library Systems Support Specialist
Grinnell College Libraries
1111 Sixth Ave.
Grinnell, IA 50112

bissen at grinnell dot edu

641-269-3359

-----Original Message-----
From: innopac-bounces at innovativeusers dot org [mailto:innopac-bounces at innovativeusers dot org] On Behalf Of Bill Kelm
Sent: Thursday, January 26, 2012 10:28 AM
To: IUG INNOPAC List
Subject: Re: [IUG] print holdings in Serials Solutions

Dawn,

  Here are the steps we use with create lists and excel:

To create the direct links to the catalog bib record, we export the bib record number to the excel file.

Create a column next to the bib record number column with:

=CONCATENATE("http://library.willamette.edu/record=",LEFT(E2,8),"~S1")

This chops the check digit and appends are library catalog link to the front, and our scope to the back.

I then made a copy of only the values for the file we import to Serials Solutions in the next column.


  Must say I found these instructions from someone in the listserv archives a while ago.


Bill Kelm





On Thu, Jan 26, 2012 at 7:17 AM, Dawn Stephen <des57 at georgetown dot edu> wrote:

> Is there anyone out there who has successfully set up their print 
> holdings in Serials Solutions to link to title-level bib records in 
> III? The instructions for adding print holdings from III to Serials 
> Solutions indicate that this is possible:
>
> "A library can link to the MARC record of the journal. For some 
> Innovative systems, we are able to build record-specific links for the 
> print journals, based on ISSNs. Clicking on these links will take 
> patrons to the journal's MARC record. *When using journal-specific 
> URLs, it's best to also provide a general link to your OPAC."
>
> *We created a list of titles and issns, but are stumped as to how to 
> generate/harvest the journal-specific URL from Create Lists. Can 
> anyone help with this? Thank you.
>
> Dawn Rapoza
> Head, Electronic Resources & Serials Unit Lauinger Library Georgetown 
> University
> 202-687-0774
> des57 at georgetown dot edu
>
> --
> This message has been scanned for viruses and dangerous content by 
> MailScanner, and is believed to be clean.
>
> --
> This message was distributed through the Innovative Users Group 
> INNOPAC list Public replies:  INNOPAC at innovativeusers dot org You are 
> currently subscribed to innopac as: bkelm at willamette dot edu dot 
> Update your subscription options: http://innovativeusers.org/** 
> iug-discussion-list <http://innovativeusers.org/iug-discussion-list>
>



--
Bill G. Kelm - Systems Librarian
Willamette University Library
900 State Street - Salem, OR 97301
Phone: 503-375-5332   Fax: 503-370-6141

--
This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---
--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC at innovativeusers dot org
You are currently subscribed to innopac as: bissen at grinnell dot edu dot 
Update your subscription options: http://innovativeusers.org/iug-discussion-list

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.