Re: [OPEN-ILS-GENERAL] Copy status for reference books?

[Linda Jansova]

Thank you, Jennifer, we shall try it and see whether it would work for 
us :-)!


Linda

Dne 17.1.2012 16:49, Turner, Jennifer M napsal(a):


Hi Linda,

Our libraries had this problem, too.  To work around it, they created 
separate volumes for reference copies.  This allows the call number 
and location to display separately from the items in the general 
collection.


The following is an example on our development system:

http://ecrldev.mnpals.net/opac/en-US/skin/default/xml/rdetail.xml?r=146847&t=free%20money&tp=title&d=0&hc=10&rt=title 
 



I hope this helps!

Jennifer Turner | PALS, A Program of the Minnesota State Colleges and 
Universities | 507-389-2000


*From:*open-ils-general-boun...@list.georgialibraries.org 
[mailto:open-ils-general-boun...@list.georgialibraries.org] *On Behalf 
Of *Linda Jansova

*Sent:* Tuesday, January 17, 2012 1:06 AM
*To:* open-ils-general@list.georgialibraries.org
*Subject:* Re: [OPEN-ILS-GENERAL] Copy status for reference books?

Mike, I forgot to mention that Jabok Library actually uses the 
reference flag but the problem is that the user only sees what is 
displayed in the OPAC and it seems that it is impossible for the user 
to distinguish between a copy which is a reference copy and a copy 
which is not.


An example could be this book:

http://www.jabok.cuni.cz/opac/en-US/skin/default/xml/rdetail.xml?r=11941&t=soci%C3%A1ln%C3%AD%20v%20praxi%20matou%C5%A1ek&tp=keyword&d=0&hc=1&rt=keyword 



and a copy with a barcode 424480018601 listed in copy location 
"Odborná knihovna". The user sees that it is available. However, he or 
she does not see whether it is a reference copy or not...


Linda

Dne 16.1.2012 20:34, Mike Rylander napsal(a):

2012/1/16 Linda Jansova  :

Hi,

  


We have come across a probably more or less country-specific issue:

  


In Jabok Library, reference books (i.e., books which cannot be checked out

and can only be read in the library) don't share the same copy location (as

often, though probably not always, do reference books in US libraries).

Rather, the books in Jabok Library are dispersed throughout the library. A

typical example would five copies of the book - four of them could be

checked out and one of them could not be. All five copies would be

physically located on the very same shelf - distinguished by a spine label

so that the user immediately sees whether he or she is able to check out the

particular copy.

  


When it comes to Evergreen (we are currently using version 2.0.9), would you

recommend creating a new copy status (in Server Administration ->  Copy

statuses) entitled (in English) say "Reference" which would be visible in

the OPAC and one could not place holds on it? What we need is to make it

more visible for the user to see whether a particular copy is a "usual" copy

which could be checked out whether it is a reference book... In case we use

the copy status as indicated, we (and the users of course) can conveniently

see the status below the record of the title...

  


Or perhaps an entirely different solution would be better in this case?

  

  
There's a Reference flag that can be set on a per-copy basis, and can

be used to disallow holds and circulations.
  
HTH,
  

Re: [OPEN-ILS-GENERAL] ***SPAM*** Question about putting books on display

[Thomas Berezansky]

For the record, I have given this some thought (in how it could be  
improved) and come up with a number of solutions. All of which I have  
notes (some mental, some not) on implementation. I just haven't dug up  
the tuits needed to do any of it yet.


The way I see it, there are two basic ways to flag something as "On  
Display". One is a copy location, the other is a status. The copy  
location has the effect of sticking with the item after circulations  
occur and remaining visible to staff and patrons in the catalog during  
those circulations. The status has the effect of being temporary, but  
also (currently) requires code modifications to prevent errors at  
checkin/checkout (or staff having override permissions).


For copy locations I can see some possible improvements:

1 - Add an "alert" flag to locations. Any item going to reshelving  
with an "alerting" location gets a prompt similar to the "route to  
cataloging" prompt, to ensure that staff know it is in a specially  
handled location. I suspect this would be nearly trivial, actually.


2 - Add a "temporary" copy location in some fashion. I would go for a  
secondary table saying "after this date, at checkin, switch this copy  
to this location". The copy's location then gets the new location. If  
you use "now" as the date it will switch back as soon as it is checked  
in later, whether it be from a return or otherwise. Using a date in  
the future, such as when the display is to be taken down, allows the  
system to automatically return the copy to the original location when  
done.


For copy statuses, on the other hand:

3 - Add a "allowed for direct checkout" flag. If set no override is  
needed for a direct (non-renewal) checkout from this status.


4 - Add a "target status" for checkins. If set no override is needed  
for checkins from the status *and* at checkin the status changes to  
the specified one. For a display status you could set the checkin  
status to "Reshelving" to allow a pass through checkin to auto-clear.  
This would be useful for custom workflows as well, and that goal was  
actually the origin of this idea.


5 - Add a "preferred status" for copies that is used instead of  
"Available", perhaps with a date-mapped table. In this case I would  
use a "until date X use status Y as preferred for this copy" model.  
Perhaps a null date could be used as the "default" status for  
something that should never fall into "Available"?


6 - If making heavy use of preferred statuses you may need to be able  
to pull from them on the pull list, so a flag to say "this is a valid  
pull list status" may be useful.



I see locations as being better for display purposes, in part because  
there is already work completed for keeping track of the location an  
item was in at checkout, so you can very easily get statistics on when  
your display items are being checked out. Locations are also  
Evergreen's collection codes, and thus are well suited for the task.


Thomas Berezansky
Merrimack Valley Library Consortium


Quoting Brian Herzog :

I'm curious how other Evergreen libraries handle marking books that  
are on display.  For us, "Display" is a copy location that we  
manually mark for books on display, and then manually switch back to  
their real copy location when the books come off display.


The problem is that we miss a lot of "Display" books when they get  
returned, and so they just go back on the normal shelves instead of  
back on display.  Pretty soon, the catalog no longer matches our  
shelves, which is a problem.  We've tried to clean things up a bit  
using Copy Buckets, but there are always items that slip through the  
cracks and produce inaccuracies.


Our previous ILS (SirsiDynix Horizon) had a Display item status,  
instead of copy location.  The benefit to that method was that, once  
a book marked "Display" was returned, the system automatically  
removed the "Display" designation so that it could be shelved and  
the catalog would be accurate.


If you have any best practices or a solution to this, I would really  
appreciate hearing them.  Thanks.


Brian Herzog
Head of Reference
Chelmsford Public Library
Merrimack Valley Library Consortium (MVLC)

[OPEN-ILS-GENERAL] ***SPAM*** Question about putting books on display

[Brian Herzog]

I'm curious how other Evergreen libraries handle marking books that  
are on display.  For us, "Display" is a copy location that we manually  
mark for books on display, and then manually switch back to their real  
copy location when the books come off display.


The problem is that we miss a lot of "Display" books when they get  
returned, and so they just go back on the normal shelves instead of  
back on display.  Pretty soon, the catalog no longer matches our  
shelves, which is a problem.  We've tried to clean things up a bit  
using Copy Buckets, but there are always items that slip through the  
cracks and produce inaccuracies.


Our previous ILS (SirsiDynix Horizon) had a Display item status,  
instead of copy location.  The benefit to that method was that, once a  
book marked "Display" was returned, the system automatically removed  
the "Display" designation so that it could be shelved and the catalog  
would be accurate.


If you have any best practices or a solution to this, I would really  
appreciate hearing them.  Thanks.


Brian Herzog
Head of Reference
Chelmsford Public Library
Merrimack Valley Library Consortium (MVLC)

Re: [OPEN-ILS-GENERAL] Copy status for reference books?

[Turner, Jennifer M]

Hi Linda,

Our libraries had this problem, too.  To work around it, they created separate 
volumes for reference copies.  This allows the call number and location to 
display separately from the items in the general collection.

The following is an example on our development system:
http://ecrldev.mnpals.net/opac/en-US/skin/default/xml/rdetail.xml?r=146847&t=free%20money&tp=title&d=0&hc=10&rt=title

I hope this helps!

Jennifer Turner | PALS, A Program of the Minnesota State Colleges and 
Universities | 507-389-2000




From: open-ils-general-boun...@list.georgialibraries.org 
[mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Linda 
Jansova
Sent: Tuesday, January 17, 2012 1:06 AM
To: open-ils-general@list.georgialibraries.org
Subject: Re: [OPEN-ILS-GENERAL] Copy status for reference books?

Mike, I forgot to mention that Jabok Library actually uses the reference flag 
but the problem is that the user only sees what is displayed in the OPAC and it 
seems that it is impossible for the user to distinguish between a copy which is 
a reference copy and a copy which is not.

An example could be this book:

http://www.jabok.cuni.cz/opac/en-US/skin/default/xml/rdetail.xml?r=11941&t=soci%C3%A1ln%C3%AD%20v%20praxi%20matou%C5%A1ek&tp=keyword&d=0&hc=1&rt=keyword

and a copy with a barcode 424480018601 listed in copy location "Odborná 
knihovna". The user sees that it is available. However, he or she does not see 
whether it is a reference copy or not...

Linda

Dne 16.1.2012 20:34, Mike Rylander napsal(a):

2012/1/16 Linda Jansova :

Hi,



We have come across a probably more or less country-specific issue:



In Jabok Library, reference books (i.e., books which cannot be checked out

and can only be read in the library) don't share the same copy location (as

often, though probably not always, do reference books in US libraries).

Rather, the books in Jabok Library are dispersed throughout the library. A

typical example would five copies of the book - four of them could be

checked out and one of them could not be. All five copies would be

physically located on the very same shelf - distinguished by a spine label

so that the user immediately sees whether he or she is able to check out the

particular copy.



When it comes to Evergreen (we are currently using version 2.0.9), would you

recommend creating a new copy status (in Server Administration -> Copy

statuses) entitled (in English) say "Reference" which would be visible in

the OPAC and one could not place holds on it? What we need is to make it

more visible for the user to see whether a particular copy is a "usual" copy

which could be checked out whether it is a reference book... In case we use

the copy status as indicated, we (and the users of course) can conveniently

see the status below the record of the title...



Or perhaps an entirely different solution would be better in this case?





There's a Reference flag that can be set on a per-copy basis, and can

be used to disallow holds and circulations.



HTH,

Re: [OPEN-ILS-GENERAL] 2, 1, 1 server cannot provide pages for 2.1.1 client

[Jim Bond-Harris]

Sharp, Chris  writes:

> 
> Can you paste it in a pastebin and share the link (better than attachment
anyway for archival reasons)?
> 
> http://paste.lisp.org/
> 

Back again - I pasted a listing of all of the input I typed in during the 
OpenSRF and Evergreen installations at http://paste.lisp.org/+2Q2W.  
As I thought about this over the weekend, I think the problem is likely to be
in the set of the opensrf_core.xml configuration.  Here is what I want to
have happen:
Library is on A.library.local
Staff client is on B.library.local

Right now, login is fine if I am on A, where opensrf and evergreen are
installed.  And I technically log in (according to log entries) from B, but
I don't get any of the EG web pages.  In all of the configurations, I always
specified "localhost" and "public.localhost" and "private.localhost".  
Should I have specified "A.library.local" in one or more of those configuration 
files?

I can paste the configuration files themselves, if that would help.  I figure
someone can compare mine to their working configuration, and let me know
where I went off the rails.

Thanks in advance.

Jim Bond-Harris

Re: [OPEN-ILS-GENERAL] Evergreen Reports Task Force January Meeting

[Turner, Jennifer M]

REMINDER (and cross posting): The Evergreen Reports Task Force will meet TODAY, 
Tuesday, January 17, at 3:30 Eastern on IRC (#evergreen): 
http://open-ils.org/irc.php

We will follow the agenda for December's canceled meeting: 
http://open-ils.org/dokuwiki/doku.php?id=evergreen-reports:meetings:2011-12-14-agenda.

Talk to you soon,
Jenny


Jennifer Turner | PALS, A Program of the Minnesota State Colleges and 
Universities | 507-389-2000



From: evergreen-reports-boun...@list.evergreen-ils.org 
[mailto:evergreen-reports-boun...@list.evergreen-ils.org] On Behalf Of Turner, 
Jennifer M
Sent: Wednesday, January 11, 2012 11:34 AM
To: evergreen-repo...@list.evergreen-ils.org
Subject: Re: [Evergreen-reports] Evergreen Reports Task Force January Meeting

In my haste to get the change of date/time posted, I keyed in the wrong date!  
Please mark your calendars for Tuesday, January 17 at 3:30 Eastern!

We'll meet on IRC (#evergreen): http://open-ils.org/irc.php

From: Turner, Jennifer M
Sent: Wednesday, January 11, 2012 11:15 AM
To: evergreen-repo...@list.evergreen-ils.org
Subject: Evergreen Reports Task Force January Meeting

The January meeting of the Evergreen Reports Group has been rescheduled from 
this afternoon to Tuesday, January 13, 2012 at 3:30 Eastern.  Thanks to those 
that responded to our emergency planning poll!

Since the December meeting was canceled due to low attendance, we will plan on 
following the same agenda this month: 
http://open-ils.org/dokuwiki/doku.php?id=evergreen-reports:meetings:2011-12-14-agenda.

Please add/edit the agenda as needed.

Thanks for your understanding on this last minute rescheduling!

Jenny

Jennifer Turner | PALS, A Program of the Minnesota State Colleges and 
Universities | 507-389-2000

Re: [OPEN-ILS-GENERAL] Report View error

[Aaron Zsembery]

 Original Message - 
> From: "Araik Manukyan" 
> However, when we try export ILC Users report, the Evergreen responses
> with this error text
> -
> DBD::Pg::st execute failed: ERROR: column
> fe21ca9ecd516f33ec379ecc11aa7051.groups does not exist LINE 2:
> "fe21ca9ecd516f33ec379ecc11aa7051"."groups" AS "Additional ... ^ at
> /openils/bin/clark-kent.pl line 217.
> ---
That would indicate that you have a problem with your template, namely, it 
cannot find the column "groups" in the database table 
"fe21ca9ecd516f33ec379ecc11aa7051".
If you click on the "Debugging Info" link from the report page, there should be 
a "Generated SQL" section. In there where should be a "FROM" statement with a 
bunch of "LEFT OUTER JOIN" and other "JOIN" statments. They will each have a 
table name after the JOIN along with an AS. One of the text strings after the 
AS should match the one you posted above.
For example, one of our reports has the following:
FROMreporter.overdue_circs AS "c8a790b472655be78d781328a75d9fb5"
LEFT OUTER JOIN asset.copy AS "4dea4106377793e92f172d1c616f01d1"
That should let you see which table and column it cannot find.

If you have SQL access, you should be able to copy/paste the whole "Generated 
SQL" section and run that as a query to get the same data as the report will 
give you.

HTH

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260>