Re: [OPEN-ILS-GENERAL] Covers and ISBNs

2011-10-07 Thread Ian Bays

Hi Ben, Brian et al,

We came across this when trying to show images from Amazon.  We know 
from experience that Amazon mostly only responds to 10-digit ISBNs as 
the Amazon ID matched the 10-digit ISBN.  Amazon's line has always been 
that they provide images keyed on their Amazon ID.


When loading data there are 10-digit and 13-digit ISBNs often in no 
particular order.  So we found the script in Evergreen that forms the 
URL for the image from Amazon and test if the ISBN is 13-digits, and if 
so convert it using Business::ISBN perl module to be a 10-digit ISBN.  
So no messing with the data in bib at all.  Seems to work well.


On our system the script to change is:
/openils/lib/perl5/OpenILS/WWW/AddedContent/Amazon.pm

We're happy to share - it's just a few lines.  Maybe this should be on 
the DEV list?


Also we noticed that if your ISBNs have hyphens in them then the ISBN 
only comes through as the digits up to the first hyphen (in our case 
usually 0).  We do get lots of cataloguers who believe ISBNs should 
have hyphens.  So we are weighing up removing hyphens in data conversion 
versus finding the code that writes the ISBN field and getting it to 
skip/ignore hyphens.  Should make it look real pretty!


All the best.

Ian

On 06/10/2011 18:56, Ben Shum wrote:

Hi Brian,

As far as I know, the first ISBN entry of a record will always be used 
to retrieve added content images.  I'm not familiar with any 
workarounds other than editing the records to order the information in 
them accordingly, but maybe someone is working on this?  Otherwise, I 
think that'd be a useful feature to have in the future.


-- Ben

On 10/6/2011 1:17 PM, Brian Greene wrote:
In many cases covers won't display in our OPAC if the 13-digit ISBN 
is above the 10-digit ISBN in the bib record. If I switch the order 
of the ISBNs so that the 10-digit one is first then the cover 
displays. This is the case most of the time, although I have come 
across instances where the 13-digit ISBN displays the cover properly. 
Does anyone know of a fix for this? Is there a setting we can 
change to use a second ISBN if the first one doesn't retrieve a 
cover? We're running 2.1.

Thanks,
Brian Greene, Library Director
Columbia Gorge Community College
The Dalles, Oregon 97058
(541) 506-6080 | www.cgcc.cc.or.us http://www.cgcc.cc.or.us/


--
Benjamin Shum
Open Source Software Coordinator
Bibliomation, Inc.
32 Crest Road
Middlebury, CT 06762
203-577-4070, ext. 113


--
Ian Bays
Director of Projects
PTFS Europe
mobile: +44 (0) 7774995297
phone: +44 (0) 800 756 6803
skype: ian.bays
email: ian.b...@ptfs-europe.com



Re: [OPEN-ILS-GENERAL] Problem with yaz, debian-squeeze and Net::Z3950-SimpleServer

2011-10-07 Thread Dan Scott
On Thu, Oct 6, 2011 at 9:11 PM, Dan Scott d...@coffeecode.net wrote:
snip

 Net-SimpleServer-Z3950 1.12 works happily with Debian Squeeze. Don't
 have the command at my fingertips but something like the following
 from the CPAN shell should work:

 cpan install M/MI/MIRK/Net-SimpleServer-Z3950-1.12

Correction, now that I have a dev system ready at hand - the command should be:

cpan install M/MI/MIRK/Net-Z3950-SimpleServer-1.12.tar.gz


Re: [OPEN-ILS-GENERAL] Covers and ISBNs

2011-10-07 Thread Gordana Vitez
Hi Ian,
 
I would be interested to know how you got this to work.
 
Thanks!
Gordana
 
Gordana Vitez
Library Services  Systems Coordinator
NC Libraries and Learning Commons
Niagara College
300 Woodlawn Rd
Welland Ontario
L3C 7L3
Phone: (905) 735 2211 ext 7404
Fax: (905) 736 6021
gvi...@niagaracollege.ca


 Ian Bays ian.b...@ptfs-europe.com 10/7/2011 5:52 AM 
Hi Ben, Brian et al,

We came across this when trying to show images from Amazon.  We know from 
experience that Amazon mostly only responds to 10-digit ISBNs as the Amazon ID 
matched the 10-digit ISBN.  Amazon's line has always been that they provide 
images keyed on their Amazon ID.

When loading data there are 10-digit and 13-digit ISBNs often in no particular 
order.  So we found the script in Evergreen that forms the URL for the image 
from Amazon and test if the ISBN is 13-digits, and if so convert it using 
Business::ISBN perl module to be a 10-digit ISBN.  So no messing with the data 
in bib at all.  Seems to work well.

On our system the script to change is:
/openils/lib/perl5/OpenILS/WWW/AddedContent/Amazon.pm

We're happy to share - it's just a few lines.  Maybe this should be on the DEV 
list?

Also we noticed that if your ISBNs have hyphens in them then the ISBN only 
comes through as the digits up to the first hyphen (in our case usually 0).  
We do get lots of cataloguers who believe ISBNs should have hyphens.  So we are 
weighing up removing hyphens in data conversion versus finding the code that 
writes the ISBN field and getting it to skip/ignore hyphens.  Should make it 
look real pretty!

All the best.

Ian

On 06/10/2011 18:56, Ben Shum wrote: 


Hi Brian,

As far as I know, the first ISBN entry of a record will always be used to 
retrieve added content images.  I'm not familiar with any workarounds other 
than editing the records to order the information in them accordingly, but 
maybe someone is working on this?  Otherwise, I think that'd be a useful 
feature to have in the future.

-- Ben

On 10/6/2011 1:17 PM, Brian Greene wrote: 

In many cases covers won't display in our OPAC if the 13-digit ISBN is above 
the 10-digit ISBN in the bib record. If I switch the order of the ISBNs so that 
the 10-digit one is first then the cover displays. This is the case most of the 
time, although I have come across instances where the 13-digit ISBN displays 
the cover properly. Does anyone know of a fix for this? Is there a setting we 
can change to use a second ISBN if the first one doesn't retrieve a cover? 
We're running 2.1.
 
Thanks,
 
 
Brian Greene, Library Director
Columbia Gorge Community College 
The Dalles, Oregon 97058
(541) 506-6080 | www.cgcc.cc.or.us ( http://www.cgcc.cc.or.us/ ) 

-- 
Benjamin Shum
Open Source Software Coordinator
Bibliomation, Inc.
32 Crest Road
Middlebury, CT 06762
203-577-4070, ext. 113
-- 
Ian Bays
Director of Projects
PTFS Europe
mobile: +44 (0) 7774995297
phone: +44 (0) 800 756 6803
skype: ian.bays
email: ian.b...@ptfs-europe.com


[OPEN-ILS-GENERAL] More questions :)

2011-10-07 Thread Snell, Cindy
Thank you to everyone who answer the questions about location/collections. That 
was a great help. Now I am having some other challenges that I am hoping 
someone can point me in the right direction in order to continue moving forward 
with getting this new system running effectively. Our OPAC is located at: 
https://dl-572-46.slc.westdc.net/opac/ - there is not an SSL certificate 
attached to the site at this time, but it is safe.

I really only have 3 titles in so far. (Teaching information literacy online, 
Managing online Instructor workload,  Chavela and the magic bubble). I am 
trying to get the correct process created before doing a migration. But for 
those 3 titles I am experiencing the following:


1.   The title does not appear record summary

2.   Book covers do not show up (I made sure the first of the 020 fields 
held the ISBN 10 #)

3.   When you click shelf browser, titles appear more than once

4.   Authority records, can I retrieve those through the z39 connection?

Thank you so much for your help.

Cynthia Snell - Emerging Technologies Librarian
Columbia College
1301 Columbia College Dr.
J Drake Edens Library
Columbia, SC 29203
Phone: 803-786-3595



Re: [OPEN-ILS-GENERAL] Covers and ISBNs

2011-10-07 Thread Dan Scott
On Fri, Oct 7, 2011 at 5:52 AM, Ian Bays ian.b...@ptfs-europe.com wrote:
 Hi Ben, Brian et al,

 We came across this when trying to show images from Amazon.  We know from
 experience that Amazon mostly only responds to 10-digit ISBNs as the Amazon
 ID matched the 10-digit ISBN.  Amazon's line has always been that they
 provide images keyed on their Amazon ID.

 When loading data there are 10-digit and 13-digit ISBNs often in no
 particular order.  So we found the script in Evergreen that forms the URL
 for the image from Amazon and test if the ISBN is 13-digits, and if so
 convert it using Business::ISBN perl module to be a 10-digit ISBN.  So no
 messing with the data in bib at all.  Seems to work well.

 On our system the script to change is:
 /openils/lib/perl5/OpenILS/WWW/AddedContent/Amazon.pm

 We're happy to share - it's just a few lines.  Maybe this should be on the
 DEV list?

Please do share: it's an open-source project and it sounds like a good
incremental improvement to Amazon added content. The contribution
process is at http://evergreen-ils.org/dokuwiki/doku.php?id=contributing
- it would be great to see your name / company added to the
contributor list!

 Also we noticed that if your ISBNs have hyphens in them then the ISBN only
 comes through as the digits up to the first hyphen (in our case usually
 0).  We do get lots of cataloguers who believe ISBNs should have hyphens.
 So we are weighing up removing hyphens in data conversion versus finding the
 code that writes the ISBN field and getting it to skip/ignore hyphens.
 Should make it look real pretty!

There are multiple ways of addressing this. I would err on the side of
letting cataloguers enter whatever they want and cleaning up the
results when you pull the ISBN - it looks like the cleanISBN()
function in opac_utils.js is a candidate, and/or in the AddedContent
Perl layer (given that requests may come in from places other than
rdetail.js / result_common.js).


Re: [OPEN-ILS-GENERAL] More questions :)

2011-10-07 Thread Mike Rylander
On Fri, Oct 7, 2011 at 10:23 AM, Snell, Cindy csn...@columbiasc.edu wrote:
 Thank you to everyone who answer the questions about location/collections.
 That was a great help. Now I am having some other challenges that I am
 hoping someone can point me in the right direction in order to continue
 moving forward with getting this new system running effectively. Our OPAC is
 located at: https://dl-572-46.slc.westdc.net/opac/ - there is not an SSL
 certificate attached to the site at this time, but it is safe.



 I really only have 3 titles in so far. (Teaching information literacy
 online, Managing online Instructor workload,  Chavela and the magic
 bubble). I am trying to get the correct process created before doing a
 migration. But for those 3 titles I am experiencing the following:



 1.   The title does not appear record summary

 2.   Book covers do not show up (I made sure the first of the 020 fields
 held the ISBN 10 #)


These are likely simple configuration issues, but without more information...

 3.   When you click shelf browser, titles appear more than once


This is by design. You're browsing call numbers, not bib records,
here.  It's a virtual representation of the physical shelf.

 4.   Authority records, can I retrieve those through the z39 connection?


Do you mean you're looking to import records via Z39.50, or access
records already in evergreen via Z39.50?

-- 
Mike Rylander
 | Director of Research and Development
 | Equinox Software, Inc. / Your Library's Guide to Open Source
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


Re: [OPEN-ILS-GENERAL] Covers and ISBNs

2011-10-07 Thread Ian Bays

Hi Gordona,
(dev list copied in case we need to submit a patch) - I have just seen 
Dan's latest post so will contribute it properly:-)

So in case you want it before it goes through the process here it is.

Using documentation from Business::ISBN:
Changes are to:

/openils/lib/perl5/OpenILS/WWW/AddedContent$ diff Amazon.pm Amazon_safe.pm
9d8
 use Business::ISBN;
70,81d68
 #open( my $diag, '/tmp/diagISBN.log' );
 #print $diag before: $key\n;
 #print $diag length:  . length($key) . \n;
 if (length($key) == 13) {
   my $isbn = Business::ISBN-new( $key );
   $isbn = $isbn-as_isbn10 if $isbn-type eq 'ISBN13';
   if (defined $isbn) {
   $key = $isbn-as_string([]);
   }
 }
 #print $diag after : $key\n;
 #close ($diag);

So the subroutine (without diagnostic comments) is:

# returns the HTTP response object from the URL fetch
sub fetch_response {
my( $self, $page, $key ) = @_;
my $uname = $self-userid;
if (length($key) == 13) {
my $isbn = Business::ISBN-new( $key );
$isbn = $isbn-as_isbn10 if $isbn-type eq 'ISBN13';
if (defined $isbn) {
$key = $isbn-as_string([]);
}
}
my $url = $self-base_url . $key.01.$page;
return $AC-get_url($url);
}

This of course assumes you are using Amazon content.  I think we had to 
restart caching to make it work.


Good luck.

Ian

On 07/10/2011 15:18, Gordana Vitez wrote:

Hi Ian,
I would be interested to know how you got this to work.
Thanks!
Gordana
Gordana Vitez
Library Services  Systems Coordinator
NC Libraries and Learning Commons
Niagara College
300 Woodlawn Rd
Welland Ontario
L3C 7L3
Phone: (905) 735 2211 ext 7404
Fax: (905) 736 6021
gvi...@niagaracollege.ca


 Ian Bays ian.b...@ptfs-europe.com 10/7/2011 5:52 AM 
Hi Ben, Brian et al,

We came across this when trying to show images from Amazon.  We know 
from experience that Amazon mostly only responds to 10-digit ISBNs as 
the Amazon ID matched the 10-digit ISBN.  Amazon's line has always 
been that they provide images keyed on their Amazon ID.


When loading data there are 10-digit and 13-digit ISBNs often in no 
particular order.  So we found the script in Evergreen that forms the 
URL for the image from Amazon and test if the ISBN is 13-digits, and 
if so convert it using Business::ISBN perl module to be a 10-digit 
ISBN.  So no messing with the data in bib at all.  Seems to work well.


On our system the script to change is:
/openils/lib/perl5/OpenILS/WWW/AddedContent/Amazon.pm

We're happy to share - it's just a few lines.  Maybe this should be on 
the DEV list?


Also we noticed that if your ISBNs have hyphens in them then the ISBN 
only comes through as the digits up to the first hyphen (in our case 
usually 0).  We do get lots of cataloguers who believe ISBNs should 
have hyphens.  So we are weighing up removing hyphens in data 
conversion versus finding the code that writes the ISBN field and 
getting it to skip/ignore hyphens.  Should make it look real pretty!


All the best.

Ian

On 06/10/2011 18:56, Ben Shum wrote:

Hi Brian,

As far as I know, the first ISBN entry of a record will always be 
used to retrieve added content images.  I'm not familiar with any 
workarounds other than editing the records to order the information 
in them accordingly, but maybe someone is working on this?  
Otherwise, I think that'd be a useful feature to have in the future.


-- Ben

On 10/6/2011 1:17 PM, Brian Greene wrote:
In many cases covers won't display in our OPAC if the 13-digit ISBN 
is above the 10-digit ISBN in the bib record. If I switch the order 
of the ISBNs so that the 10-digit one is first then the cover 
displays. This is the case most of the time, although I have come 
across instances where the 13-digit ISBN displays the cover 
properly. Does anyone know of a fix for this? Is there a setting we 
can change to use a second ISBN if the first one doesn't retrieve a 
cover? We're running 2.1.

Thanks,
Brian Greene, Library Director
Columbia Gorge Community College
The Dalles, Oregon 97058
(541) 506-6080 | www.cgcc.cc.or.us http://www.cgcc.cc.or.us/


--
Benjamin Shum
Open Source Software Coordinator
Bibliomation, Inc.
32 Crest Road
Middlebury, CT 06762
203-577-4070, ext. 113


--
Ian Bays
Director of Projects
PTFS Europe
mobile: +44 (0) 7774995297
phone: +44 (0) 800 756 6803
skype: ian.bays
email:ian.b...@ptfs-europe.com


--
Ian Bays
Director of Projects
PTFS Europe
mobile: +44 (0) 7774995297
phone: +44 (0) 800 756 6803
skype: ian.bays
email: ian.b...@ptfs-europe.com



Re: [OPEN-ILS-GENERAL] Problem with yaz, debian-squeeze and Net::Z3950-SimpleServer

2011-10-07 Thread John Morris
On Thu, 2011-10-06 at 21:11 -0400, Dan Scott wrote:

 You have to install a previous version of Net::Z3950::SimpleServer
 from CPAN. There were hopes that the maintainers would realize that it
 would be nice if their package would install on the most recent stable
 Debian release and make the dependency on the most recent source
 version of yaz optional, but that seems not to be in the cards.
 
 Net-SimpleServer-Z3950 1.12 works happily with Debian Squeeze. Don't
 have the command at my fingertips but something like the following
 from the CPAN shell should work:
 
 cpan install M/MI/MIRK/Net-SimpleServer-Z3950-1.12

Ok, that is solved.  Had to apt-get install yaz first but that might
have been me installing and reinstalling things trying in vain to make
it work.

 This is a relatively recent development (well - middle of August) and
 as the package is only required for providing a Z39.50 server it
 hasn't been on the front of people's minds; they generally don't run
 into it when testing out the basic functions of an installed system.
 We should be able to tweak Makefile.install accordingly - either to
 install the latest yaz from source (sigh - hopefully _that_ won't
 introduce problems to more core functions like z39.50 import...) or to
 install Net::SimpleServer::Z3950 1.12 specifically (I'd lean towards
 that because it has less impact on the system as a whole).

Well I am running 1.6.0.8 in production right now and and the idea is to
get this pair of machines up and try a test import of our data with an
idea to migrate after letting the staff beat on it a week or so.  So I
was watching the install logs carefully for errors since the plan is for
this install to go into production.

I am working on the assumption that I can stuff a copy of our data in,
run each of the schema update scripts and be ready to test?  The
postgresql versions differ so I plan to just import the evergreen db
instead of a dumpall.  Will still have to edit a few things here and
there but don't expect it to be painless.

  Second problem is BOBTFISH::Class-DBI-Frozen fails because it won't
  build without a working postgres server on localhost.  I'm testing a
  split database so hadn't installed postgres and the dependencies coded
  in Makefile.install didn't catch it.  Oops.  Will install a server long
  enough to build it once I get past the more serious problem.
 
 Are you _sure_ it didn't install? I've never had to have a PostgreSQL
 server installed for that package to be installed. The CPAN directives
 in Makefile.install state that it should be installed forcefully -
 there are one or two tests that are known to fail and therefore kick
 out scary error messages, but they're red herrings.

Apparently it did.  After seeing the error I tried manually installing
and couldn't and didn't think about the makefile doing a force.  So that
clears both holdups and I'm back in business.




signature.asc
Description: This is a digitally signed message part


[OPEN-ILS-GENERAL] Looking for field definitions for item records

2011-10-07 Thread Boggs, John
Hi all,

I've searched the documentation, the source code, and Google, and I can't turn 
up definitions of the various item fields in Evergreen. Some are obvious, like 
barcode. Others less so (to me), like circulate as MARC type.

Is there a list anywhere that defines all the various item fields? I'm working 
on a migration from Millennium and need to figure out what to map to where.

Thanks!

John D. Boggs, PLAN Database Manager
Peninsula Library System
2471 Flores Street
San Mateo, CA  94403-2273
(650)571-6799 x3062
bo...@plsinfo.orgblocked::mailto:bo...@plsinfo.org



Re: [OPEN-ILS-GENERAL] Looking for field definitions for item records

2011-10-07 Thread bfeifarek
Hi John, 


I have not seen definitive descriptions of the fields, and would be happy if 
somebody can indicate if this exists. 


What I use to find my way around the Evergreen tables is mostly the Evergreen 
1.6 schema , which does not have column descriptions but tracing through 
foreign key relationships (which are very helpfully hyperlinked) helps quite a 
bit. To tease out what a particular column gets used for may also require some 
searching through source code to see where it gets used, but that can become a 
daunting undertaking. 


Brian 

- Original Message -
From: John Boggs bo...@plsinfo.org 
To: Evergreen Discussion Group (open-ils-general@list.georgialibraries.org) 
open-ils-general@list.georgialibraries.org 
Sent: Friday, October 7, 2011 3:36:58 PM 
Subject: [OPEN-ILS-GENERAL] Looking for field definitions for item records 




Hi all, 



I’ve searched the documentation, the source code, and Google, and I can’t turn 
up definitions of the various item fields in Evergreen. Some are obvious, like 
barcode. Others less so (to me), like “circulate as MARC type.” 



Is there a list anywhere that defines all the various item fields? I’m working 
on a migration from Millennium and need to figure out what to map to where. 



Thanks! 



John D. Boggs, PLAN Database Manager 
Peninsula Library System 
2471 Flores Street 
San Mateo, CA 94403-2273 
(650)571-6799 x3062 
bo...@plsinfo.org