[ List Archives Home ] [ Thread index for 2008 ]
[ Date index for 2008 ]
[ Author index for 2008 ]
[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Hi Gwen
We ran a review file for our periodical titles and included the record
number when we exported. If you give Serials an example of the URL
string for the persistent link to the record, they will add each
individual record themselves. One thing you will need to change: the
record number exported from MillCirc includes an extra digit (your
system librarian will know why--all I know is that it gave me a
headache)
When you import in Excel you need to eliminate that extra digit. My
co-worker found the easiest way is to use text to columns in Data tab,
and use fixed width to drag the column bar past that last digit. This
moves the last digit to a new column that you can then delete.
Your original review file may need some clean up also. Hope this helps.
Also, FYI there is a Serials Solution listserv:
http://listserv.tamu.edu/archives/serialssolutionsusers.html
>>> "Gregory, Gwen" <8Gregory at jmls dot edu> 9/4/2008 3:38 PM >>>
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
Gina Scioscia
Boulder Public Library
303-441-3194
sciosciag at boulder dot lib dot co dot us
But if you say: "How am I to know what he means, when I see nothing but
the signs he gives?"
then I say: "How is he to know what he means, when he has nothing but
the signs either?"
*- Ludwig Wittgenstein Philosophical Investigations
Home
Mailing list