Re: [OPEN-ILS-GENERAL] Scannable barcode font in web client receipts

[Mike Rylander]

Hi Lindsay,

There are a few variations on Code-39 and Code-128 WOFF font families
that we could use.  I'm not sure of the process for embedding them in
Evergreen OTTOMH, but once included it should just be a matter of CSS
to make use of them -- though hatch-based printing may cause some
problems, I'm not sure.  I think a launchpad wishlist bug is in order!

https://fonts.google.com/specimen/Libre+Barcode+39

Thanks,
--
Mike Rylander
 | Research and Development Manager
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org

On Tue, Jun 9, 2020 at 10:05 AM Lindsay Stratton  wrote:
>
> Good morning,
>
> Is anybody using scannable barcodes in receipts in the web client?
>
> I had been using them in the past (XUL client) but after upgrading to the web 
> client, creating new receipt templates did not seem to work. Currently 
> running 3.4.
>
> There is interest in scannable barcodes to streamline contactless pick up 
> services.
>
> Thanks!
>
> Lindsay
>
> Lindsay Stratton
> Systems Librarian
> Westchester Library System
> 570 Taxter Rd., 4th Floor
> Elmsford, NY 10523
> lstrat...@wlsmail.org

Re: [OPEN-ILS-GENERAL] REST API with Libro by Conversight

[Mike Rylander]

Hi Bill,

Do you know if they're using the xml output format to avoid having to learn
about the IDL mapping?  I'm mostly curious about external use of various
OpenSRF entry points, and where any effort might be best spent.

Regards,

Mike Rylander

--   Sent from my phone, please pardon my thumbs.
 | Research and Development Manager
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://EquinoxInitiative.org

On Wed, May 27, 2020, 5:14 PM Bill Erickson  wrote:

> Hi Lynn,
>
> We've done some work with Conversight at KCLS.  In our case, they are
> using standard Evergreen APIs via the osrf-gateway-v1 and a Supercat feed
> for MARC records.  This should not require any local changes.
>
> We did create one small API tweak to support a certain work flow for them
> (including lost items in a certain patron items out call) that I'd be happy
> to share.
>
> -b
>
>
>
> On Wed, May 27, 2020 at 5:05 PM Floyd, Angelia Lynn <
> lflo...@library.in.gov> wrote:
>
>> We have had several conversations with Conversight about Libro, and
>> adding it for several different libraries.  They prefer to us the REST API
>> for access, does anyone have Evergreen set up this way?  That may be able
>> to  help me.
>>
>>
>>
>> Thanks.
>>
>>
>>
>> -
>> Lynn Floyd
>> MIS Supervisor
>>
>>
>> Indiana State Library
>> https://www.in.gov/library/
>> 315 W Ohio St
>> Indianapolis, IN 46202
>> 317-232-3290
>> lflo...@library.in.gov
>>
>>
>>
>

Re: [OPEN-ILS-GENERAL] Updating Facet Labels

[Mike Rylander]

Hi Jennifer,

That's provided by the label column on the table config.metabib_field.
You'll find that in the staff client under Admin -> Server Admin ->
MARC Search/Facet Fields.  A service restart, and possibly apache,
restart may be needed after changing that to force the changes to be
seen.

HTH,

--
Mike Rylander
 | Executive Director
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org

On Fri, Jun 28, 2019 at 1:05 PM Jennifer Pringle
 wrote:
>
>
> Hello,
>
> We're trying to update the Genre label in the OPAC to be Genre/Form to
> better represent the information coming from the 655 field.
> (https://bugs.launchpad.net/evergreen/+bug/1824029)
>
> We've successfully updated it in the OPAC record view under "Search
> for related items by subject" but are having a hard time finding the
> facet label for Genre.  Could someone point us in the right direction
> to find the facet labels?
>
> Thanks,
>
> Jennifer
> --
> Jennifer Pringle
> Co-op Support
> BC Libraries Cooperative
> Tel: 1-888-848-9250
> Email:jennifer.prin...@bc.libraries.coop
> Website: http://bc.libraries.coop
>
> Gratefully acknowledging that I live and work in the unceded
> Traditional Territory of the St'at'yemc Nations.
>

Re: [OPEN-ILS-GENERAL] Publisher in Evergreen Reports

[Mike Rylander]

Hi Mary, I believe I can help with your XPath questions.

If you wanted to get just the "current/latest" dates, and only publication
dates (as opposed to distribution, etc) you could do something like this:

 //*[(@tag="260" and @ind1="3") or (@tag="264" and @ind1="3" and
@ind2="1")]/*[@code="c"]

I imagine the indicator 1 values may be too strict, though.  To get just
the first found in the record (and without the perhaps-too-strict indicator
1 tests):

 //*[@tag="260" or (@tag="264" and @ind2="1")]/*[@code="c"][1]

And to get the last, presumably the 264 if it exists:

 //*[@tag="260" or (@tag="264" and @ind2="1")]/*[@code="c"][last()]

Ordering is based on document element order, FWIW.

And, finally, the "Remove \D" refers to removing non-numeric characters
from the extracted string.

HTH,

--
Mike Rylander
 | Executive Director
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Fri, Jun 14, 2019 at 2:48 PM Mary Llewellyn  wrote:

> Hi Janet,
>
> You inspired me to tweak my Vandelay queue display. I figured out how to
> combine the two publisher tags, and now I don't have any empty boxes in the
> publisher column.
>
> *//*[@tag="260" or @tag="264"]/*[@code="b"]*
>
> I tried the same thing with the pub dates, but ended up with two dates
> strung together when there are 2 264 tags for the differing types of dates.
> I either need to now how to insert a space between them, or how to skip one
> iteration based on indicator values.
>
> /*/*[@tag="260"or @tag="264"]/*[@code="c"] Remove \D*  (That last
> part was already in place, I don't really know what it means.)
>
> Anyway, thanks for the inspiration!
>
> Mary
>
>
> On Tue, Jun 11, 2019 at 2:59 PM Janet Schrader 
> wrote:
>
>> Hi,
>> I do not do reports, but I can say that in Vandelay I have two columns
>> for publisher: Publisher and Publisher RDA and likewise two columns for Pub
>> date and Pub date RDA. I have this attribute definition for the RDA
>> publisher. Is it possible to use this for reports?
>> *264  b  //*[@tag="264"]/*[@code="b"]*
>>
>>
>> Janet
>>
>>
>> Janet Schrader
>>
>> Bibliographic Services Supervisor | CW MARS
>>
>> 67 Millbrook Street, Suite 201, Worcester, MA 01606
>>
>> P: 508-755-3323 x 325 | F: 508-757-7801
>>
>> --
>>
>> jschra...@cwmars.org  ||  http;//cwmars.org <http://www.cwmars.org/>
>>
>>
>>
>> On Tue, Jun 11, 2019 at 12:51 PM Jane Sandberg 
>> wrote:
>>
>>> John Yorio at Equinox helped me track this down in our system.  John
>>> found out that the issue was that Evergreen uses the Library of Congress'
>>> MARC->MODS 3.3 mapping, which only includes 260$b publishers.  See
>>> https://www.loc.gov/standards/mods/v3/mods-mapping-3-3.html#publication
>>>
>>> I think a bug report would be a good idea.
>>>
>>> On Tue, Jun 11, 2019 at 8:45 AM Patrick, Irene 
>>> wrote:
>>>
>>>> Someone here asked me for a report that includes the Publisher
>>>> information.  In the report I created, I used the Simple Record Extracts to
>>>> pull the “Publisher (normalized)” field into the report.  Unfortunately, in
>>>> the output, the Publisher column was mostly empty.  On investigation, it
>>>> appears that records with the publisher in the 264 are not included in the
>>>> output.  Only records where the publisher is in the 260 have the publisher
>>>> information show up in the output.
>>>>
>>>>
>>>>
>>>> We are on Evergreen 3.1.6.  I’ve searched Launchpad, but I don’t find
>>>> anything about this issue.  Has it been corrected in a later release?  Or
>>>> do we need to create a bug report?
>>>>
>>>>
>>>>
>>>> Or should I use a different method to get the publisher information
>>>> into the report?
>>>>
>>>>
>>>>
>>>> *Irene Patrick *
>>>>
>>>> Library & Information Management Systems Librarian, NC Government &
>>>> Heritage Library
>>>>
>>>> NC Dept. of Natural and Cultural Resources
>>>>
>>>> 919.814.6788  |  irene.patr...@ncdcr.gov
>>>>
>>>>
>>>>
>>>> 109 E. Jones Street  | 4640 Mail Service Center
>>>>
>>>> Raleigh, North Carolina 27699-4600
>>>>
>>>> Facebook <http://www.facebook.com/ncghl>  Instagram
>>>> <https://www.instagram.com/foreverythingnc/>  Twitter
>>>> <https://twitter.com/ForEverythingNC>  YouTube
>>>> <https://www.youtube.com/statelibrarync>  Website
>>>> <https://statelibrary.ncdcr.gov/>
>>>>
>>>>
>>>>
>>>> *Email correspondence to and from this address is subject to the North
>>>> Carolina Public Records Law and may be disclosed to third parties.*
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Jane Sandberg
>>> Electronic Resources Librarian
>>> Linn-Benton Community College
>>> sand...@linnbenton.edu / 541-917-4655
>>> Pronouns: she/her/hers
>>>
>>
>
> --
> Mary Llewellyn
> Database Manager
> Bibliomation, Inc.
> 24 Wooster Ave.
> Waterbury, CT 06708
> mllew...@biblio.org
>

Re: [OPEN-ILS-GENERAL] [OPEN-ILS-DEV] Cannot save authority record with a 155 field

[Mike Rylander]

Hi Linda and Josh,

Great work figuring that out! We should definitely report this
upstream to the MODS/MADS folks, but we maintain a local copy of the
XSLT (altered to work without external file or network access for xml
includes) and can fix it locally.  I don't have time right now to jump
on it, but both the file on the filesystem and the version in the
config.xml_transform table in the db should be corrected.

Thanks!
--
Mike Rylander
 | Executive Director
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org

On Wed, Oct 31, 2018 at 10:58 AM Josh Stompro
 wrote:
>
> Linda, I wonder if this is a bug in the MARCslim2MADS.xslt?  The error 
> message is
>
>
>
> runtime error: file ./MARC21slim2MADS.xsl line 1404 element attribute
>
> xsl:attribute: Cannot add attributes to an element if children have been 
> already added to the element.
>
>
>
> I agree that it looks like the problem is when the xslt is processing the 755 
> and trying to set the authority source.
>
>
>
> I think the bug may be that when processing the 755 tag on line 1081, the 
> genre template is called before the setAuthority template.  The Genre 
> template adds child elements, then the setAuthority tries to set attributes, 
> which is where the error pops up.
>
>
>
> If I swap lines 1084 and 1085 then the error goes away and both the 
> genre(155) and related genre(755) show up in the transformed xml.
>
>
>
> I think the way to report this to the MADS project is via the MODS listserv, 
> as listed on http://www.loc.gov/standards/mads/
>
>
>
> I don’t have enough experience with these technologies to be all that 
> confident that this is the issue though.  I would be happy to report this to 
> the MODS listserv if it seems to make sense to someone that is more familiar 
> with mods/mads/xml/authorities.
>
>
>
> Josh Stompro - LARL IT Director
>
>
>
> From: Linda Jansova 
> Sent: Wednesday, October 31, 2018 7:16 AM
> To: Evergreen Discussion Group ; 
> Josh Stompro ; Evergreen Development Discussion 
> List 
> Subject: Re: [OPEN-ILS-GENERAL] Cannot save authority record with a 155 field
>
>
>
> Dear Josh,
>
> Thank you for letting me know about the right XSL file!
>
> After some more investigations I have come to a conclusion that it is not 
> actually a 155 field which causes the problem but a 755 field. If it has any 
> value in second indicator, xsltproc fails to process it. When the indicator 
> does not have any value (or, to be more precise, there is just a space), it 
> is okay.
>
> So far, it seems that we will have to get rid either of the values of 
> indicators in 755s, or of the following part of the XSL file:
>
>  test="(700 = ancestor-or-self::marc:datafield/@tag and 
> ancestor-or-self::marc:datafield/@tag = 755 ) and @ind2='7'">
> 
> 
> 
> 
>
> Hopefully it will work for us and let us proceed in the upgrade :-)!
>
> Linda
>
> On 10/30/18 9:38 PM, Josh Stompro wrote:
>
> Hello Linda, I think the Authority ingest uses the MARC21slim2MADS.xsl 
> transform file to convert the authority data into MADS format.  Could you try 
> manually processing your problem authority record using the MADS file instead 
> of the MODS and see what you get.
>
>
>
> The MADS xsl does look like it references tag 155.
>
>
>
> Josh Stompro - LARL IT Director
>
>
>
> From: Open-ils-general  
> On Behalf Of Linda Jansova
> Sent: Friday, October 26, 2018 5:29 AM
> To: Evergreen Discussion Group ; 
> Evergreen Development Discussion List 
> Subject: [OPEN-ILS-GENERAL] Cannot save authority record with a 155 field
>
>
>
> Hi,
>
> back in August we started investigating why we couldn't proceed with upgrade 
> from 2.12.6 to 3.1.4 (for more details please see 
> http://libmail.georgialibraries.org/pipermail/open-ils-general/2018-August/015298.html).
>
> After removing obviously invalid MARCXML records (which surprisingly made 
> their way to our 2.12 installation) we still have some records which cannot 
> be reingested (or saved).
>
> Attached is a sample record americke_romany.xml which is one of those 
> troublesome ones. It is a genre/form term record with the main heading in the 
> field 155.
>
> We have tried the SQL upgrade from 2.12.6 to 3.0.0 without authority records 
> reingest (the particular lines were commented out) and, once we were at 
> 3.1.4, used the web client to save this particular record (without actually 
> making any changes in it). However, it appeared that it could not 

Re: [OPEN-ILS-GENERAL] Bills Paid by Staff Login

[Mike Rylander]

Hi Elizabeth,

The cash reports are focused on the workstation, not the staff member, and
they include only cash, check and credit card payments made at a
workstation.  The Brick-and-mortar source includes account adjustments, as
well as forgive, credit (not credit card, but patron credit), work, and
goods payments.  You may want to consider using the Payment: Desk source,
which includes only the same payment types as the cash reports.

HTH,

--
Mike Rylander
 | Executive Director
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Tue, Aug 28, 2018 at 4:03 PM Elizabeth Davis  wrote:

> Hi Scott and Mike
>
>
>
> I have been testing the Payments: Brick-and-mortar source and comparing it
> to the Cash Reports and the cash totals do not seem to be matching.  Is
> anyone familiar with this?
>
>
>
>
>
> Elizabeth Davis
>
> Head of Digital Services
>
> Scranton Public Library
>
> 500 Vine Street
>
> Scranton, PA 18509
>
> 570-348-3000 ext. 3050
>
> eda...@albright.org
>
>
>
>
>
>
>
> *From:* Open-ils-general [mailto:
> open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Mike
> Rylander
> *Sent:* Tuesday, August 28, 2018 9:59 AM
> *To:* Evergreen Discussion Group <
> open-ils-general@list.georgialibraries.org>
> *Subject:* Re: [OPEN-ILS-GENERAL] Bills Paid by Staff Login
>
>
>
> Hi Scott,
>
>
>
> In addition to what Bill mentions, the Accepting Staff Member field of the
> "Payments: Brick-and-mortar" links to the staff user that was logged in at
> the workstation where the payment was accepted.  That can be used to report
> exactly on how much money a staff member took in.
>
>
>
> HTH,
>
>
> --
> Mike Rylander
>  | Executive Director
>  | Equinox Open Library Initiative
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  mi...@equinoxinitiative.org
>  | web:  http://equinoxinitiative.org
>
>
>
>
>
> On Tue, Aug 28, 2018 at 8:14 AM Joan Kranich  wrote:
>
> Hi Scott,
>
>
>
> CW MARS has a few Payment report sources we use and one of our reports is
> by login.
>
>
>
> Joan
>
>
>
> On Tue, Aug 28, 2018 at 7:52 AM, Bill Ott  wrote:
>
> Check out: Administration > Local Administration > Cash Reports
>
> That will give you daily summaries (or whatever days you select). If
> you're looking for more detail, then a custom report may be in order.
>
>
>
> On 8/27/18 3:14 PM, scott.tho...@sparkpa.org wrote:
>
> We just migrated a library that is very strict about reporting out revenue
> collected by individual staff members at the Circulation Desk. Their
> previous ILS was able to output bill payments by staff login, but there is
> apparently no reporting source for this in Evergreen. First of all, is
> there a reporting source for this in Evergreen that we just haven’t found?
> If not, has anyone found a workaround for this?
>
>
>
> Thank you,
>
> Scott
>
>
>
> Scott Thomas
>
> Executive Director
>
> *PaILS / SPARK*
>
> (717) 873-9461
>
> scott.tho...@sparkpa.org
>
> Stay informed! Join the SPARK-User Email List:
>
> https://mail.palibrary.org/mailman/listinfo/spark-users
>
> [image: Description: Description: Training | SPARK – Pennsylvania's
> Statewide Library System] <http://www.palibrary.org/pails/>
>
>
>
>
>
>
>
> --
>
> ​​
>
> Joan Kranich | Member Services Supervisor
>
> CW MARS
>
> jkran...@cwmars.org
>
> 508-755-3323 x321 or x1 <(508)%20755-3323>
>
> http://www.cwmars.org
>
>
>
>

Re: [OPEN-ILS-GENERAL] Bills Paid by Staff Login

[Mike Rylander]

Hi Scott,

In addition to what Bill mentions, the Accepting Staff Member field of the
"Payments: Brick-and-mortar" links to the staff user that was logged in at
the workstation where the payment was accepted.  That can be used to report
exactly on how much money a staff member took in.

HTH,

--
Mike Rylander
 | Executive Director
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Tue, Aug 28, 2018 at 8:14 AM Joan Kranich  wrote:

> Hi Scott,
>
> CW MARS has a few Payment report sources we use and one of our reports is
> by login.
>
> Joan
>
> On Tue, Aug 28, 2018 at 7:52 AM, Bill Ott  wrote:
>
>> Check out: Administration > Local Administration > Cash Reports
>>
>> That will give you daily summaries (or whatever days you select). If
>> you're looking for more detail, then a custom report may be in order.
>>
>>
>> On 8/27/18 3:14 PM, scott.tho...@sparkpa.org wrote:
>>
>> We just migrated a library that is very strict about reporting out
>> revenue collected by individual staff members at the Circulation Desk.
>> Their previous ILS was able to output bill payments by staff login, but
>> there is apparently no reporting source for this in Evergreen. First of
>> all, is there a reporting source for this in Evergreen that we just haven’t
>> found? If not, has anyone found a workaround for this?
>>
>>
>>
>> Thank you,
>>
>> Scott
>>
>>
>>
>> Scott Thomas
>>
>> Executive Director
>>
>> *PaILS / SPARK*
>>
>> (717) 873-9461
>>
>> scott.tho...@sparkpa.org
>>
>> Stay informed! Join the SPARK-User Email List:
>>
>> https://mail.palibrary.org/mailman/listinfo/spark-users
>>
>> [image: Description: Description: Training | SPARK – Pennsylvania's
>> Statewide Library System] <http://www.palibrary.org/pails/>
>>
>>
>>
>>
>
>
> --
>
> ​​
>
> Joan Kranich | Member Services Supervisor
>
> CW MARS
>
> jkran...@cwmars.org
>
> 508-755-3323 x321 or x1 <(508)%20755-3323>
>
> http://www.cwmars.org
>
>

Re: [OPEN-ILS-GENERAL] Delay on removing deleted records

[Mike Rylander]

Hi Easter,

There is a 5 minute cache for search results, so if you perform an
identical search before and after the removal, within five minutes of
each other, you will see a cached version of the bibliographic data
for the search.  The delete, however, is complete as soon as the
action (record merge, direct bib deletion, "last copy" automatic
deletion) completes in the interface.

Hope that helps,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org

On Tue, Jun 19, 2018 at 9:52 AM DiGangi, Easter
 wrote:
>
> Good morning,
>
>
>
> Has anyone noticed a delay on deleted records being removed from the OPAC? We 
> have noticed it a few times (we are using 3.0) but wanted to see if anyone 
> else was observing it.
>
>
>
> Thanks,
> Easter
>
>
>
> Easter DiGangi
>
> Cataloging and Acquisitions Librarian
>
> Portsmouth Public Library
>
> 4934 High Street West
>
> Portsmouth, VA 23703
>
> Phone: 757-686-2538 Ext. 6614
>
> Email: digan...@portsmouthva.org
>
> Pronouns: she/her/hers
>
>
>
> www.PortsmouthPublicLibrary.org
>
>
>
>

Re: [OPEN-ILS-GENERAL] [External] [Evergreen-acq] Overview and mockups for acquisitions development project

[Mike Rylander]

Irene,

Equinox is as excited to be designing the features and writing the code as
you are to see it happening, I assure you!

The way we do development intentionally takes feedback like this into
account.  The initial phase will be creation of the sets of functional
specifications in consultation with our funding partners, and to the degree
we can, by the broader community.  While I can't promise specifics before
we've created the functional specs, I can say that the two things you list
here are relatively minor additions given the full scope of the project,
and could likely be incorporated into the specs as we move forward.  I
would not expect either to blow up the budget of the provider portion of
our work.

Thanks for the feedback!

--
Mike Rylander
  | President
  | Equinox Open Library Initiative
  | phone:  1-877-OPEN-ILS (673-6457)
  | email:  mi...@equinoxinitiative.org
  | web:  http://equinoxinitiative.org

On Thu, May 10, 2018 at 4:40 PM Patrick, Irene <irene.patr...@ncdcr.gov>
wrote:

> Kathy,

> Today is my first day back after the conference where I've had time to
look at list mail, so I just saw your message today.  I'm very excited to
see this work on the Acquisitions module!  I'm especially happy to see the
proposal to handle provider records and searching more like the patron
records, which is what I've been wishing for ever since we migrated to
Evergreen last year.

> I have a couple of comments on the proposal.  One is that in the provider
record, I don't see a field for FEIN.  Our budget office has required us to
provide the FEIN for all our vendors, for the past 20 years or so.  They
will not pay anyone without an FEIN or SSN, and have required us to get
that information from our providers. I wonder if you all could consider
adding a dedicated field for FEIN on the provider records, along with the
name, provider code and SAN.

> Our other big problem with the provider records is that we made extensive
use of vendor notes in our former ILS.  These were actually all migrated to
Evergreen.  But they're useless to us because, although there is a notes
field in the Evergreen provider record, it does not display in the client.
I don't see a notes field for providers anywhere in the proposal.  No doubt
adding a notes field would throw off the quote provided, but it's a big
concern for our library.  We've got plenty of places for notes on patron
records in Evergreen; I'd like to see something similar for provider
records.  Maybe this could be kept in mind for future development?

> Those two points aside, this proposal would be a great advance for
acquisitions in Evergreen.  I am looking forward to seeing the improvements!

> Irene Patrick
> Library & Information Management Systems Librarian
> NC Dept. of Natural and Cultural Resources
> 919.807.7413  |  irene dot patrick at ncdcr dot gov
> 109 E. Jones St.  | 4640 Mail Service Center
> Raleigh, North Carolina 27699-4600
> Facebook  Twitter  Instagram  YouTube  Website

> Email correspondence to and from this address is subject to the North
Carolina Public Records Law and may be disclosed to third parties.



> -Original Message-
> From: Kathy Lussier [mailto:kluss...@masslnc.org]
> Sent: Thursday, May 3, 2018 3:18 PM
> To: 'Evergreen Discussion Group' <
open-ils-general@list.georgialibraries.org>;
evergreen-...@list.evergreen-ils.org
> Subject: [External] [Evergreen-acq] Overview and mockups for acquisitions
development project

> CAUTION: External email. Do not click links or open attachments unless
verified. Send all suspicious email as an attachment to Report Spam.


> Hi all,

> I'm sending along a link to the overview of the acquisitions development
project that was discussed at the acquisitions interest group this morning.

https://yeti.esilibrary.com/dev/public/techspecs/angular-acq-phase0-rept.pdf

> Equinox created this report, which breaks down a project to move
acquisitions to AngularJS (or Angular) in ten different sprints. The report
also includes some draft mock-ups for acquisitions interfaces.
> Many thanks to Georgia PINES for funding this report!

> Along with this report, MassLNC has received a quote to create tech specs
for this project. We'll be reviewing the quote over the next few weeks and
will possibly reaching out to the community for help in funding this
project.

> Feel free to let me know if you have any questions!

> Kathy

> --
> Kathy Lussier
> Project Coordinator
> Massachusetts Library Network Cooperative
> (508) 343-0128
> kluss...@masslnc.org
> Twitter: http://www.twitter.com/kmlussier

> ___
> Evergreen-acq mailing list
> evergreen-...@list.evergreen-ils.org
> http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-acq

Re: [OPEN-ILS-GENERAL] metabib.browse_entry unused cleanup?

[Mike Rylander]

Josh,

It's not causing any issues in any instance that EOLI oversees.  It's
a unique string listing based on a B+Tree index, so until you get past
several quintillion entries you should be fine.  The one benefit of
removing orphaned entries would be for the off chance that the terms
in the string are collectively entirely unique and you've disabled the
visibility test for autosuggest, where you might get a browse
suggestion that would lead to a dead end.

If you do clear them out, make sure you vacuum and analyze the table
(/not/ vacuum full, mind) afterwords.

HTH,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Mon, Apr 2, 2018 at 4:10 PM, Josh Stompro <stomp...@exchange.larl.org> wrote:
> Hello, I’ve been changing around some indexing rules and applied the fix to
> the full stop/rda relator code normalization issue and now just noticed that
> all the no longer used browse entries are sticking around in
> metabib.browse_entry.
>
>
>
> There are 175K entries out of 950K that are no longer used according to
> metabib.browse_entry_def_map and metabib.browse_entry_simple_heading_map.
>
>
>
> Has anyone found this to be an issue and removed those unused entries?  I
> don’t think this is causing any issues, it just seems strange to hold on to
> that data.  Any typo that was ever entered in a browse field and corrected
> is recorded there.
>
>
>
> Thanks
>
> Josh
>
>
>
> Lake Agassiz Regional Library - Moorhead MN larl.org
>
> Josh Stompro | Office 218.233.3757 EXT-139
>
> LARL IT Director | Cell 218.790.2110
>
>

Re: [OPEN-ILS-GENERAL] Fixed-field elements mnemonic names translations

[Mike Rylander]

Hi Eva,

The current "Audn" translation you found is actually for a field label
on an IDL class rather than a value in a column.  It's an identical
string, but is only used to create a translation for the fm_IDL.xml
file, not other instances of "Audn".  If the new branch goes in, there
will be a new translation that would be used in the web staff client
and allows translation there as well.  Hopefully Launchpad will pick
up the identical string and suggest (or even just use) the translation
there.

Permission codes are, as you suspected, like fixed field mnemonics in
that they should not be translated generally.  The UPDATE_COPY_STATUS
translation you found is actually for the description value associated
the permission that has the same code.  That translation is safe to
use.  If we generally made better use of the permission description
field, displaying that instead of or in addition to the code, I think
things would be improved.

Thanks,


--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Mon, Mar 26, 2018 at 5:34 PM, Cerninakova Eva <cer...@jabok.cz> wrote:
> Ben and Mike,
>
> Thanks both of you for very useful information.
>
> I must admit I have been  little surprised by your answers. I was sure it is
> possible to translate those strings (at least in XUL client)  because I
> found them in Launchpad translations in fm-idl.dtd template (see e.g.
> https://translations.launchpad.net/evergreen/master/+pots/fm-idl.dtd/cs/+translate?batch=10=all=Audn)
> . I only asked to make sure how to deal with them  because I suspected that
> the values represent a special codes and could be used by system differently
> than ordinary strings (which turned out to be true).
> Thanks for pushing new branch - I will open a Launchpad wishlist bug and
> send the link
>
> I have one   more question, that is similar to the previous. I would like to
> translate  Evergreen permissions too. This could be useful for staff at
> least in situation, when pop-up window appears with important information
> about insufficient permission etc. I have found those permissions in
> Launchpad translations too (in this case in db.seed template, see
> e.g.https://translations.launchpad.net/evergreen/master/+pots/db.seed/cs/+translate?batch=10=all=UPDATE_COPY_STATUS).
> Again, I was not sure whether to translate this because this looks like
> "system string" that could be handled specifically by the Evergreen.
> Is it safe to translate it (may be I should also ask whether permissions are
> translatable at the moment).
>
> Thanks for one more answer ;-)
>
> Eva
>
>
>
>
>
>
>
>
>
>
> ---
> Mgr. Eva Cerniňáková
> cer...@jabok.cz
> Tel. +420 211 222 409
>
> Knihovna Jabok
> http:/knihovna.jabok.cz
> Tel.  +420 211 222 410
> Jabok - Vyšší odborná škola sociálně pedagogická a teologická
> Salmovská 8, 120 00 Praha 2
>
>
> 2018-03-26 21:04 GMT+02:00 Mike Rylander <mrylan...@gmail.com>:
>>
>> Hi Eva,
>>
>> In short, no, you can't do that today because those strings are used
>> to fetch values from the server.  However, I've pushed a branch to
>>
>> http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/miker/translate-fixed-field-labels
>> that will allow you to translate the display labels.
>>
>> If you want to open a Launchpad wishlist bug for this, I'll update my
>> branch and link it there.
>>
>> Thanks,
>>
>> --
>> Mike Rylander
>>  | President
>>  | Equinox Open Library Initiative
>>  | phone:  1-877-OPEN-ILS (673-6457)
>>  | email:  mi...@equinoxinitiative.org
>>  | web:  http://equinoxinitiative.org
>>
>>
>> On Mon, Mar 26, 2018 at 12:34 PM, Cerninakova Eva <cer...@jabok.cz> wrote:
>> > Hi all,
>> >
>> >
>> > I have a question about translation of fixed-field elements mnemonic
>> > names
>> > (like BLvl, DtSt, Audn etc, see
>> > https://www.oclc.org/bibformats/en/fixedfield.html.) used in Evergreen
>> > in
>> > the fixed field grid. We have not translated the mnemonic names to Czech
>> > yet
>> > (and as far as a know, neither they have  been  translated to some of
>> > supported Evergreen languages). However,  it turned out eventually,
>> > that
>> > the using of English mnemonic names is not very practical for Czech
>> > catalogers. That is why we would like to translate them to Czech now. At
>> > this point two practical question came up:
>> >
>> > 1. Must translation necessari

Re: [OPEN-ILS-GENERAL] Fixed-field elements mnemonic names translations

[Mike Rylander]

Hi Eva,

In short, no, you can't do that today because those strings are used
to fetch values from the server.  However, I've pushed a branch to
http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/miker/translate-fixed-field-labels
that will allow you to translate the display labels.

If you want to open a Launchpad wishlist bug for this, I'll update my
branch and link it there.

Thanks,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Mon, Mar 26, 2018 at 12:34 PM, Cerninakova Eva <cer...@jabok.cz> wrote:
> Hi all,
>
>
> I have a question about translation of fixed-field elements mnemonic names
> (like BLvl, DtSt, Audn etc, see
> https://www.oclc.org/bibformats/en/fixedfield.html.) used in Evergreen in
> the fixed field grid. We have not translated the mnemonic names to Czech yet
> (and as far as a know, neither they have  been  translated to some of
> supported Evergreen languages). However,  it turned out eventually,  that
> the using of English mnemonic names is not very practical for Czech
> catalogers. That is why we would like to translate them to Czech now. At
> this point two practical question came up:
>
> 1. Must translation necessarily consist of only  four characters, as the
> original mnemonic names mostly do? Or would it be possible use to use more
> characters for translation, possibly from six to eight (e.g. Ctry translate
> as ZemVyd, or GPub translate as VladPub) without causing a crush of the fix
> field grid interface?
>
> 2. Is it safe to use a special Czech characters (extended ASCII characters
> like ž, š, č, ř ...) for mnemonic names translation? Or could i cause a
> problem?
>
>
> Thanks in advance for an answer
>
> Eva
>
>
>
> ---
> Mgr. Eva Cerniňáková
> cer...@jabok.cz
> Tel. +420 211 222 409
>
> Knihovna Jabok
> http:/knihovna.jabok.cz
> Tel.  +420 211 222 410
> Jabok - Vyšší odborná škola sociálně pedagogická a teologická
> Salmovská 8, 120 00 Praha 2
>

Re: [OPEN-ILS-GENERAL] Unexected report writer behaviour.

[Mike Rylander]

Steve,

The HTML output of every report has a link at the top (intentionally
made dimmer than others) that says "Debugging Info".  If you click
that, you'll see the actual SQL that ran.

Your problem comes from this path: Circulation -> Item :: Circulations

That goes from one circ (presumably your target), to the item, and
then to all the circs that item has had, adding a row for each to the
output.  Without more information I couldn't say if that path is
actually needed for the report you want to produce, but from the
description I would suspect it's not.

HTH,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Tue, Mar 20, 2018 at 8:04 AM, swills beyond-print.com
<swi...@beyond-print.com> wrote:
> Chris asked me to post this problem.  It was surprising to me that he gets
> the report results that he does.  As an aside, i'd like to be able to see
> the report writers actual query at some point.  Is there a debug trap for
> that? Anyway, here is his problem.
>
>
> have an interesting Evergreen “Reports” issue.
>
> I want an “overdues” report where:
>
> 1. I want to name the library
>
> 2. I want a range of Overdue/Due Dates
>
> 3. For everything that isn’t checked in.
>
> The problem I am having is that the report seems to add additional records
> (with later Due dates) to the report.
>
> I built a report with these Base Filters.
>
> [overduereportfailure1.jpg] attached shows a pic of the reportwriter filters
> used.
>
> But, when I run the report, I get “extra records” (Due dates in the future).
> In the following case, I asked for a range of Mar 16 to Mar 16. But I got
> two “extra” items.
>
> [overduereportfailure2.jpg] attached shows a pic of unexpected result report
> rows
>
>
> We looked at one of the items (“Princess Stories, etc.) in the database and
> found this:
>
> [overduereportfailure3.jpg] attached shows psql select of the item
> asset.copy rows for the princess story item.
>
> As you can see, this item has two transactions. The first, has a “null”
> check In Date/Time. The second has a due date of 2018-03-16.
>
> Logically, I understand why this item might be included. But how can I
> filter out items like this??
>
> Steve says:  I don't see why the items that don't satify all of the filters
> were included?  suggestions?
>
> Thanks
>
>
>

Re: [OPEN-ILS-GENERAL] web client hold slip

[Mike Rylander]

Hi Michael,

To follow up on what Terran said, I would recommend using transform
rather than -moz-transform, as the latter likely won't work in Chrome.
For more info:

https://www.w3schools.com/cssref/css3_pr_transform.asp

Thanks,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Thu, Mar 8, 2018 at 2:40 PM, Terran McCanna
<tmcca...@georgialibraries.org> wrote:
> Hi Michael,
>
> Rotating text should work the same. It looks funky in the preview pane, but
> when printing it should be okay.
>
> Limiting the number of characters:
>
> {{checkout.title | limitTo:10}}   (limits to first 10 characters)
>
> {{patron.card.barcode | limitTo:-5}}   (limits to last 5 characters)
>
>
> Hold shelf slip - shelf expire date:
> {{hold.shelf_expire_time | date:'M/d/'}}
>
> I have written up documentation for our libraries you are welcome to refer
> to (I believe this is going to mostly be ported into the official
> documentation when someone gets a chance):
>
> https://pines.georgialibraries.org/dokuwiki/doku.php?id=circ:workstations:receipts
> and
> https://pines.georgialibraries.org/dokuwiki/doku.php?id=circ:workstations:receipt-content
>
>
>
> Terran McCanna
> PINES Program Manager
> Georgia Public Library Service
> 1800 Century Place, Suite 150
> Atlanta, GA 30345
> 404-235-7138
> tmcca...@georgialibraries.org
>
>
> On Thu, Mar 8, 2018 at 2:28 PM, Michael Schell <msch...@fepl.ca> wrote:
>>
>> Hi All,
>>
>> I'm trying to get my hold slips setup in the web client but have a few
>> questions. Does anyone know how to rotate text, limit the number of letters
>> displayed in a patron barcode/last name, or  what the code is for shelf
>> expire time. This is the code that worked in the desktop client for
>> reference.
>>
>> 
>> h1 {font-size:50px; -moz-transform:rotate(90deg);
>> text-transform:uppercase; padding-bottom:20px;padding-left:50px}
>> 
>>
>> Patron:%PATRON_FIRSTNAME% %PATRON_LASTNAME%
>> Title: %item_title%
>> 
>>
>> Notify by phone: %notify_by_phone%
>> Notified by text: %notify_by_text%
>> Notified by email: %notify_by_email%
>> 
>> - - - - - - -  TEAR HERE  - - - - - - -
>>
>> 
>> 
>> 
>> 
>>
>>
>>
>> %SUBSTR(0,3)%%PATRON_LASTNAME%%SUBSTR_END%%SUBSTR(-4)%%PATRON_BARCODE%%SUBSTR_END%%DATE_FORMAT(%shelf_expire_time%,%m/%d)%
>>
>> Any help would be appreciated.  Thanks.
>>
>> Michael
>>
>> --
>> Michael Schell
>> Systems Administrator
>> Fort Erie Public Library
>> 905-871-2546 x301
>> msch...@fepl.ca
>> www.fepl.ca
>
>

Re: [OPEN-ILS-GENERAL] SIP2 - Block certain patrons from authenticating for a particular login - Evergreen End

[Mike Rylander]

Josh,

It might be better added this to the Evergreen driver, which is ILS-aware,
to avoid pain down the road when SipServer eventually changes.  It could be
driven (heh) by an  chunk in the config file, or
perhaps as a new attribute on the  element (where $server->{account}
comes from, IIRC).  This could list one or more permissions required for
patron authz.  The driver could then test for those permissions, and if the
patron does not have any of them (or maybe all of them, or, perhaps,
any/all based on different config locations), the authz request fails.

Thoughts?  Anyone with tuits?

Thanks.


--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org

On Thu, Dec 7, 2017 at 5:27 PM, Josh Stompro <stomp...@exchange.larl.org>
wrote:

> I think I found a way to hard code this sort of check into sipserver, once
> I found the correct spot to look.
>
>
>
> At the following locations I just added a check to not allow certain
> combinations of sip login accounts and patron types.  This seems to short
> circuit the login check/info check correctly, just for the services that we
> want to restrict.
>
>
>
> http://git.evergreen-ils.org/?p=SIPServer.git;a=blob;f=Sip/MsgType.pm;h=
> bd7cb521beeda53787a64264a0f75a4364285d11;hb=HEAD#l458
>
>
>
> http://git.evergreen-ils.org/?p=SIPServer.git;a=blob;f=Sip/MsgType.pm;h=
> bd7cb521beeda53787a64264a0f75a4364285d11;hb=HEAD#l1001
>
>
>
> The patron type and login username was readily available.
>
>
>
> if ($patron && !($server->{account}='SIP_MNLINK' && $patron->ptype =~
> m/LARL Temporary|LARL ND Reciprocal|LARL Fee|LARL ILL/)) {
>
>
>
> I love evergreen!  And thanks to wolfram alpha for building me a truth
> table to make sure I had the logic correct.
>
> https://www.wolframalpha.com/input/?i=P+and+not+(+Q+and+Z+)
>
>
>
> Josh Stompro - LARL IT Director
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> boun...@list.georgialibraries.org] *On Behalf Of *Josh Stompro
> *Sent:* Thursday, December 07, 2017 2:20 PM
> *To:* Evergreen Discussion Group <open-ils-general@list.
> georgialibraries.org>
> *Subject:* Re: [OPEN-ILS-GENERAL] SIP2 - Block certain patrons from
> authenticating for a particular login - Evergreen End
>
>
>
> This sender failed our fraud detection checks and may not
> be who they appear to be. Learn about spoofing
> <http://aka.ms/LearnAboutSpoofing>
>
> Feedback <http://aka.ms/SafetyTipsFeedback>
>
> I just realized that I was wrong about the patron info response not
> including the patron type, it does include it in the PC message, but I
> think it would still be nice to do this server side in some cases.
>
>
>
> Josh Stompro - LARL IT Director
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> boun...@list.georgialibraries.org
> <open-ils-general-boun...@list.georgialibraries.org>] *On Behalf Of *Josh
> Stompro
> *Sent:* Thursday, December 07, 2017 11:47 AM
> *To:* 'Evergreen Discussion Group' <open-ils-general@list.
> georgialibraries.org>
> *Subject:* [OPEN-ILS-GENERAL] SIP2 - Block certain patrons from
> authenticating for a particular login - Evergreen End
>
>
>
> This sender failed our fraud detection checks and may not
> be who they appear to be. Learn about spoofing
> <http://aka.ms/LearnAboutSpoofing>
>
> Feedback <http://aka.ms/SafetyTipsFeedback>
>
> Hello, Has anyone come up with a way of controlling authentication via
> sip2 on the sip2 server side for particular users or types of users?
>
>
>
> We have various different services that authenticate via sip2, such as our
> patron management (cassie), Overdrive, and our state ILL system (MNLINK).
> The problem we are running into is that certain user groups (permission
> groups) shouldn’t be able to access some of those services.
>
>
>
> For example, we have temporary users that have more limited capabilities
> since we cannot fully verify their info, or their residence status is in
> flux.  We don’t want those patrons to be able to request material from
> other libraries, but we do want them to be able to access public computers
> and overdrive.
>
>
>
> The patron permission group doesn’t seem like it is something that is sent
> in the patron status response to the vendors, so I don’t think there is a
> way for them to check it on their end.  And it seems like it would be more
> fool proof to handle it on the server side, not trusting a vendor to take
> care of something.
>
>
>
> When we used the III patron API product the info w

Re: [OPEN-ILS-GENERAL] Catalog holds status display - Hold queue and potential copies

[Mike Rylander]

Scott,

It's not that you can't have a hybrid, but that FIFO sites will end up
getting their holds prioritized over proximity-based sites if there is
resource sharing between them, all else being equal, as FIFO only cares
about request time and proximity cares about "closeness".  Having just one
or the other in use means nobody gets the short end of the stick.

HTH,


--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org

On Tue, Nov 28, 2017 at 8:30 AM, scott.tho...@sparkpa.org <
scott.tho...@sparkpa.org> wrote:

> Another interesting issue was raised in this discussion. Our consortium is
> all proximity because we were told that, if org units within a consortium
> plan to resource share, they must all be FIFO or proximity, but it appears
> some of you are hybrids. Can I assume you do not resource share at all or
> do not do so beyond the local library system?
>
> Thank you,
> Scott
>
>
>
>
>
> Scott Thomas
>
> Executive Director
>
> *PaILS / SPARK*
>
> (717) 873-9461
>
> scott.tho...@sparkpa.org
>
> [image: Description: Description: Training | SPARK – Pennsylvania's
> Statewide Library System] <http://www.palibrary.org/pails/>
>
>
>
>
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> boun...@list.georgialibraries.org] *On Behalf Of *Diane Disbro
> *Sent:* Monday, November 27, 2017 8:30 PM
> *To:* Evergreen Discussion Group <open-ils-general@list.
> georgialibraries.org>; ME list serv <evergr...@lists.mobiusconsortium.org>
> *Subject:* Re: [OPEN-ILS-GENERAL] Catalog holds status display - Hold
> queue and potential copies
>
>
>
> I am very interested to hear if someone has done something with this other
> than try to explain to disgruntled patrons why they see in their online
> account that they are next in the queue for an item but they wait weeks or
> months to get it.
>
>
>
> Thank you, Josh, for asking.
>
>
> Diane Disbro
>
> Circulation Coordinator/Branch Manager
>
> Union Branch
>
> Scenic Regional Library
>
> 308 Hawthorne Drive
> <https://maps.google.com/?q=308+Hawthorne+Drive%0D+%0D+%0D+Union,+MO+%C2%A0+%C2%A0+63084=gmail=g>
>
> Union, MO
> <https://maps.google.com/?q=308+Hawthorne+Drive%0D+%0D+%0D+Union,+MO+%C2%A0+%C2%A0+63084=gmail=g>
>   63084
> <https://maps.google.com/?q=308+Hawthorne+Drive%0D+%0D+%0D+Union,+MO+%C2%A0+%C2%A0+63084=gmail=g>
>
> (636) 583-3224
>
>
>
> On Mon, Nov 27, 2017 at 4:28 PM, Josh Stompro <stomp...@exchange.larl.org>
> wrote:
>
> Hello, Those of you that use age hold protection and non FIFO best hold
> selection sort order, what have you done with the status column of holds in
> your catalog.  We just noticed that it is showing the FIFO queue position
> for holds, along with all potential copies.  This gives users bad info
> since for us holds are sometimes filled in FIFO order for some orgs, and
> are filled based on proximity for other locations.  And since one org uses
> age hold protection, the total copy count isn’t accurate either since half
> the copies might be age hold protected so they cannot fill the users holds.
>
>
>
> Did you just remove that section from templates/opac/parts/hold_status.tt2?
> Did you modify it in some way?  I would like to see examples of what you
> changed it to if you changed it.
>
>
>
> Should the potential copies count exclude copies that are age hold
> protected and cannot be captured for that hold?  Right now it pulls from
> hold copy map, but it looks like restricting the copy count based on the
> age hold protection might be possible to add.
>
>
>
> Thanks
>
> Josh
>
>
>
>
>
>
>
> Lake Agassiz Regional Library - Moorhead MN larl.org
>
> Josh Stompro | Office 218.233.3757 EXT-139 <(218)%20233-3757>
>
> LARL IT Director | Cell 218.790.2110 <(218)%20790-2110>
>
>
>
>
>

Re: [OPEN-ILS-GENERAL] Z39.50 Errors

[Mike Rylander]

Hi Lisa,

If EDS is making a persistent connection to the Z server, the first
thing I would suspect is a firewall on your network that drops
quiescent connections after a pre-determined amount of time.  This can
manifest as a half open connection that some programs (presumably the
EDS backend services, in this case) do not detect, so they don't know
to attempt to reconnect.  This is more often seen with SIP2
connections, as Z connections are usually not long-lived and so don't
stay quiescent long enough to trigger the issue like SIP2 client do.

The next time this happens, it would be a good test to see if an
external program such as MARCEdit can connect to your Z server.  If
so, it's not the Z server, but something between it and EDS (or EDS
itself).  If you cannot connect, though, then it is likely a problem
with the ZOOM perl program we use to translate from Z to SRU.  You may
want to see if EDS can use SRU instead in that case.

HTH,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Mon, Sep 18, 2017 at 9:27 AM, Lisa Setters
<lisa.sett...@asburyseminary.edu> wrote:
> We have our EBSCO Discovery Service (EDS) configured to use Evergreen's
> Z39.50 server to display call numbers and availability.
>
> Too often, we find that this connection has gone down. In this case, we see
> a spinning wheel showing that EDS is trying to connect to Evergreen. This
> spinning wheel disappears after EDS determines that it will not be able to
> access the material.
>
> When this happens, we reboot the Z39.50 server and the connection is
> restored.
>
> Does anybody have any idea as to how we can resolve this?
>
>
> Lisa Setters
> Research and Web Librarian
> 859.858.2100
> Frequently Asked Questions
> Library Instructional Services
> Asbury Theological Seminary
>
> *We have a new Library Loan Website! See
> http://guides.asburyseminary.edu/libraryloan for instructions.*

Re: [OPEN-ILS-GENERAL] Outreach use of evergreen and printing

[Mike Rylander]

Sevarl? Several. :)


--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org

On Thu, Aug 31, 2017 at 11:13 AM, Mike Rylander <mrylan...@gmail.com> wrote:

> Bill,
>
> There's a USB version of the Star Micronics TSP100 that sevarl libraries
> have used with success.
>
> HTH,
>
>
> --
> Mike Rylander
>  | President
>  | Equinox Open Library Initiative
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  mi...@equinoxinitiative.org
>  | web:  http://equinoxinitiative.org
>
> On Thu, Aug 31, 2017 at 9:20 AM, Bill Coffey <bill.cof...@waynegov.com>
> wrote:
>
>> We are currently wanting to so something like a bookmobile (very small
>> outreach) to where we can take books out to areas and have people be able
>> to check out books.
>>
>> Has anyone ever used a small portable receipt printer with Evergreen?
>>
>> If So What model were you using and if it worked well?
>>
>> We would be using it with a Surface Pro type laptop.
>>
>> Thanks
>>
>>
>>
>> [image: Electronic Circuit Board]
>>
>> Bill Coffey
>>
>> Systems Administrator
>>
>> Wayne County Public Library
>>
>> 1001 E. Ash St
>>
>> Goldsboro, NC 27530
>>
>>
>>
>> Phone:  (919) 735-6249
>>
>> Fax:  (919) 731-2889
>>
>> email:   bill.cof...@waynegov.com
>>
>>
>>
>
>

Re: [OPEN-ILS-GENERAL] Outreach use of evergreen and printing

[Mike Rylander]

Bill,

There's a USB version of the Star Micronics TSP100 that sevarl libraries
have used with success.

HTH,


--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org

On Thu, Aug 31, 2017 at 9:20 AM, Bill Coffey <bill.cof...@waynegov.com>
wrote:

> We are currently wanting to so something like a bookmobile (very small
> outreach) to where we can take books out to areas and have people be able
> to check out books.
>
> Has anyone ever used a small portable receipt printer with Evergreen?
>
> If So What model were you using and if it worked well?
>
> We would be using it with a Surface Pro type laptop.
>
> Thanks
>
>
>
> [image: Electronic Circuit Board]
>
> Bill Coffey
>
> Systems Administrator
>
> Wayne County Public Library
>
> 1001 E. Ash St
>
> Goldsboro, NC 27530
>
>
>
> Phone:  (919) 735-6249
>
> Fax:  (919) 731-2889
>
> email:   bill.cof...@waynegov.com
>
>
>

Re: [OPEN-ILS-GENERAL] Hidden titles in OPAC

[Mike Rylander]

Hi Don,

A title must have at least one copy, at least one located URI, or use
transcendent bibliographic source in order to show up in the public
catalog.

http://docs.evergreen-ils.org/dev/_cataloging_electronic_resources_8201_8212_8201_finding_them_in_catalog_searches.html
http://docs.evergreen-ils.org/dev/_using_transcendent_bib_sources_for_electronic_resources.html

HTH,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Mon, Aug 7, 2017 at 2:50 PM, Donald Butterworth
<don.butterwo...@asburyseminary.edu> wrote:
> Hi All,
>
> We are finding that some of our titles show in the Staff Client but do not
> show n the OPAC. One example of this: titles that have a copy record Status
> "New Book".
>
> The only titles we want hidden are deleted titles. Everything else we want
> to display. What value do we need to change to make this happen?
>
> Thanks!
>
> Don
>
> --
> Don Butterworth
> Collection Management Librarian /
> Faculty Associate
> B.L. Fisher Library
> Asbury Theological Seminary
> don.butterwo...@asburyseminary.edu
> (859) 858-2227

Re: [OPEN-ILS-GENERAL] OpenSearch - Relevance

[Mike Rylander]

Jim,

You might try using the slimpac interface to do some searches and see
how to build OpenSearch URLs in Evergreen:
http://evergreen.asburyseminary.edu/opac/en-US/extras/slimpac/start.html
-- that interface sits directly on top of OpenSearch, and just uses an
XSLT to transform the ATOM output to HTML.

Since you've looked at opensearch.org, you probably know about OSD
files.  Yours is at
http://evergreen.asburyseminary.edu/opac/extras/opensearch/1.1/ATS/-/osd.xml
and it can help you construct URLs as well.

Note, if you're searching for a specific phrase, you can enclose it in
double quotes to make sure you get the title you are looking for.

Finally, OpenSearch uses the same backend for searching as the OPAC,
you'll just need to construct the URLs a little differently.

HTH,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Mon, Jul 31, 2017 at 3:51 PM, Jim Taylor <jtay...@jtdata.com> wrote:
> Hoping someone can tell me how to get useful results from opensearch.  I
> submit a search such as the following…
>
>
>
> http://evergreen.asburyseminary.edu/opac/extras/opensearch/1.1/ATS/marcxml-full/title/Bible+in+Mission?count=25
>
>
>
> but I have to go to the 5th page to find this title.   Is there a way to
> tell opensearch to sort by relevance?
>
>
>
> I’ve looked at opensearch.org but not seeing anything helpful and can’t find
> anything the Evergreen documentation that applies…may just not be doing the
> right search of course.
>
>
>
> Open to other suggestions as well.  I have tried
>
>
>
>
> http://evergreen.asburyseminary.edu/opac/extras//browse/mods/title/ASLAN/Bible%20in%20Mission?count=20
>
>
>
> and it works much faster unless there are no results and then it can take
> about 45 seconds to get a response.  The results seem far more appropriate
> but not as good as what is returned in the OPAC and the 45 second delay for
> no results is a non-starter for that approach.
>
>
>
> Are there any other options or ways to make the above work better and
> faster?   Any way to return the OPAC search results in an XML format?
>
>
>
> Any other suggestions or links to documentation for the above that might
> shine some light in my vast dark cavern of ignorance?
>
>
>
> Thanks.
>
>
>
>
>
> Jim

Re: [OPEN-ILS-GENERAL] Evergreen Self-Check and locking media cases

[Mike Rylander]

Interestingly, Grand Rapids PL (Bill Ott) has done exactly that:
http://www.rfidjournal.com/articles/view?9914

I'm not sure if it's still in use, though.

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Wed, Jul 26, 2017 at 9:57 AM, Rogan Hamby
<rha...@equinoxinitiative.org> wrote:
> Just a quick thought that regardless of where the code resided to do the
> unlocking (internal to Evergreen or in a third party product) some third
> party hardware would be required to do this so the inherent division between
> ILS code and vendor hardware is always going to be there and therefore it's
> more likely that the unlocking will remain on the side of the hardware
> vendor.
>
> That isn't to say that someone couldn't write their own native Evergreen
> client to do all this with their own hardware but the task would be ...
> non-trivial.  :)
>
>
>
>
> Rogan Hamby
>
> Data and Project Analyst
>
> Equinox Open Library Initiative
>
> phone:  1-877-OPEN-ILS (673-6457)
>
> email:  ro...@equinoxinitiative.org
>
> web:  http://EquinoxInitiative.org
>
> On Wed, Jul 26, 2017 at 9:51 AM, Terran McCanna
> <tmcca...@georgialibraries.org> wrote:
>>
>> Hi Jesse,
>>
>> I just wanted to chime in that I'm not aware of anyone who is working on
>> developing functionality like that. The self-check interface hasn't gotten a
>> lot of attention in the past few years, possibly because not a lot of
>> libraries are using it. (Only 2 or 3 libraries out of our 285 total
>> libraries that have opted to use it.) There are a number of things that
>> could be done to improve it which would encourage more people to adopt it,
>> like adding the ability to pay fines through the same functionality that the
>> OPAC uses, and to allow patrons to renew books through it.
>>
>>
>>
>> Terran McCanna
>> PINES Program Manager
>> Georgia Public Library Service
>> 1800 Century Place, Suite 150
>> Atlanta, GA 30345
>> 404-235-7138
>> tmcca...@georgialibraries.org
>>
>>
>> On Tue, Jul 25, 2017 at 4:16 PM, Jesse McCarty <jes...@burlingtonwa.gov>
>> wrote:
>>>
>>> Hello Everyone,
>>>
>>>
>>>
>>> Currently we are running an ITG self-check system that utilizes magnetic
>>> locking cases for DVDs and CDs. I know the documentation references no
>>> security mechanisms in Evergreen self-check, but I was wondering if there is
>>> a way for the Evergreen self-check to interact/activate the magnetic
>>> unlockers for security cases? Is this a sought after feature/planned
>>> possibility? Or is the built in self-check designed to be nothing more than
>>> its current basic form?
>>>
>>>
>>>
>>> Thanks in advance,
>>>
>>>
>>>
>>> Jesse McCarty
>>>
>>> City of Burlington
>>>
>>> IT Technical Assistant
>>>
>>>
>>
>>
>

Re: [OPEN-ILS-GENERAL] Linking bibliographic records to non-LoC authorities using a support script

[Mike Rylander]

Hi Vaclav,

The script has an internalized summary of the LoC control set, and
doesn't load it from the server.  With development, it should be
possible to teach authority_control_fields.pl how to load the control
set definition from the database.  That's still on my wish list,
though.  As with most new features, it's a matter of time and
priority...

Thanks,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Thu, Jul 13, 2017 at 6:17 AM, Vaclav Jansa <vaclav.ja...@gmail.com> wrote:
> Hi,
>
> We are trying to automatically link bibliographic records to authority
> records using the authority_control_fields.pl support script
> (http://docs.evergreen-ils.org/2.12/_support_scripts.html). We are currently
> on 2.12.
>
> It seems that the script is only aware of the default LoC Control Set as
> mentioned in Mike's 2014 presentation
> (http://evergreen-ils.org/wp-content/uploads/2014/04/eg14_Authorities-presentation-EGCON-2014.pdf,slide
> 19).
>
> Is there a way to add custom control sets to the authority_control_fields.pl
> script? So far we haven't been able to identify the right part of the script
> which would indicate that only LoC Control Set is taken into account...
>
> Thank you in advance for any hints!
>
> Vaclav

Re: [OPEN-ILS-GENERAL] Synonym Dictionary - Numbers,

[Mike Rylander]

Josh,

To cover numbers, it looks like you just need to add dictionaries (I
probably wouldn't use just one for everything) for uint, etc.  Note,
you can stack dictionaries.

As for & (along with |, !, and maybe parens), it may be best to simply
map those to some well-known token in search_normalize() that's very
unlikely to be used in the real world.  Perhaps some unicode
codepoint, like ☃ and friends.  Those are special characters used by
tsearch itself.

HTH,
--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Thu, May 25, 2017 at 11:05 AM, Josh Stompro
<stomp...@exchange.larl.org> wrote:
> Hello, I’ve followed the steps in the following wiki pages to enable a
> synonym dictionary but I’m not getting the results I expect.
>
>
>
> https://wiki.evergreen-ils.org/doku.php?id=scratchpad:brush_up_search#synonym_dictionary
>
>
>
> Spelled out numbers do get translated to digits (six -> 6) but digits don’t
> get translated ( 6 -> six).
>
>
>
> When I test the synonym dictionary with something like the following it
> looks like it works:
>
> select ts_lexize('synonym_larl', '6');
>
> ts_lexize
>
> ---
>
> {six}
>
> (1 row)
>
>
>
> But when I look at the the metabib.title_field_entry for a record that has
> been reindexed I see the following.
>
> select * from metabib.title_field_entry where source=102449 limit 100;
>
>id| source | field |  value
> |
> index_vector
>
> -++---+--+-
>
> 2402931 | 102449 | 6 | Little house on the prairie Season 6 [disc 2]
> test seven | '2':9A,13C,20C '6':7A,12C,18C '7':14C 'disc':8A,19C 'hous':13C
> 'house':2A 'littl':12C 'little':1A 'on':3A,14C 'prairi':16C 'prairie':5A
> 'season':6A,17C 'seven':11A,22C 'test':10A,21C 'the':4A,15C
>
>
>
> Seven gets added as ‘seven’ and ‘7’, but the ‘2’ and ‘6’ do not.
>
>
>
> So I’m wondering if the search configuration needs to cover numeric tokens
> to make that work?
>
>
>
> select * from ts_debug('synonym_larl', '6');
>
> alias |   description| token | dictionaries | dictionary | lexemes
>
> ---+--+---+--++-
>
> uint  | Unsigned integer | 6 | {simple} | simple | {6}
>
>
>
> \dF+ synonym_larl;
>
> Text search configuration "public.synonym_larl"
>
> Parser: "pg_catalog.default"
>
>   Token  | Dictionaries
>
> -+--
>
> asciihword  | synonym_larl
>
> asciiword   | synonym_larl
>
> email   | simple
>
> file| simple
>
> float   | simple
>
> host| simple
>
> hword   | simple
>
> hword_asciipart | synonym_larl
>
> hword_numpart   | simple
>
> hword_part  | simple
>
> int | simple
>
> numhword| simple
>
> numword | simple
>
> sfloat  | simple
>
> uint| simple
>
> url | simple
>
> url_path| simple
>
> version | simple
>
> word| simple
>
>
>
> Maybe the uint token needs to be set to synonym_larl also? But I’m wondering
> if this has bad side effects?
>
>
>
> Also, another mapping we would like to make is ‘&’ -> ‘and’ , ‘and’ -> ‘&’.
> But it doesn’t look like tsearch knows how to categorize ‘&’ as a token.
>
>
>
> select * from ts_debug('synonym_larl', '&');
>
> alias |  description  | token | dictionaries | dictionary | lexemes
>
> ---+---+---+--++-
>
> blank | Space symbols | & | {}   ||
>
>
>
> Works fine going the other way and the ‘&’ ends up in the index.
>
>
>
> select * from ts_debug('synonym_larl', 'and');
>
>alias   |   description   | token |  dictionaries  |  dictionary  |
> lexemes
>
> ---+-+---++--+-
>
> asciiword | Word, all ASCII | and   | {synonym_larl} | synonym_larl | {&}
>
>
>
> Thanks
>
> Josh
>
>
>
>
>
> Lake Agassiz Regional Library - Moorhead MN larl.org
>
> Josh Stompro | Office 218.233.3757 EXT-139
>
> LARL IT Director | Cell 218.790.2110
>
>

Re: [OPEN-ILS-GENERAL] Disabling SSL in Evergreen ILS

[Mike Rylander]

Hi,

There are several relatively simple services (some entirely
in-browser) that can get certs from Let's Encrypt available at
https://letsencrypt.org/docs/client-options/ .  If have control over
DNS for your domain, you could set up an external DNS entry for the
name of the internal server and receive a cert, then use internal
(split-brain) DNS to use that name for a private IP and make use of
the cert you generate.  These certs are fairly short-lived, but once
DNS is set up, the update process is easy.

HTH,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Thu, Mar 30, 2017 at 10:19 AM, Josh Stompro
<stomp...@exchange.larl.org> wrote:
> StartSSL shouldn’t be used any more.  They were banned from Chrome and
> Firefox early this year because of reasons including the fact that they were
> silently purchased by a Chinese company, and because they were issuing back
> dated certificates to get around the SHA-1 phase out.  They also allowed
> users to get certificates for main domains if they could certify that they
> had control of subdomains.
>
>
>
> https://arstechnica.com/security/2016/09/firefox-ready-to-block-certificate-authority-that-threatened-web-security/
>
>
>
> Josh Stompro - LARL IT Director
>
>
>
> From: Open-ils-general
> [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
> Bill Ott
> Sent: Thursday, March 30, 2017 9:10 AM
> To: open-ils-general@list.georgialibraries.org
> Subject: Re: [OPEN-ILS-GENERAL] Disabling SSL in Evergreen ILS
>
>
>
> For single server implementations, there are also free certificates
> available from organizations like StartSSL.
>
>
>
> On 03/30/2017 10:04 AM, Rogan Hamby wrote:
>
> While SSL on an intranet may not be necessary it still isn't harmful.  I may
> be of a paranoid bent but you can have security issues even on an intranet,
> especially large geographically distributed ones.  And with the increasingly
> punitive behavior of browsers to punish non-encrypted connections in various
> ways (usually with warnings and such) I'd question if it would be easier to
> just implement the SSL for the intranet than try to pass around it.
>
>
>
>
>
>
> Rogan Hamby
>
> Data and Project Analyst
>
> Equinox Open Library Initiative
>
> phone:  1-877-OPEN-ILS (673-6457)
>
> email:  ro...@equinoxinitiative.org
>
> web:  http://EquinoxInitiative.org
>
>
>
> On Thu, Mar 30, 2017 at 10:00 AM, Jason Stephenson <ja...@sigio.com> wrote:
>
> I should add that the staff client requires SSL and there's no easy way
> to chagne that, so you can't completely disable SSL and expect things to
> still function properly.
>
>
>
>
> On 03/30/2017 09:23 AM, Jason Stephenson wrote:
>> Jayaraj,
>>
>> It would be done via the Apache configuration files. You'd move
>> everything from the SSL enabled vhost configurations to the non-SSL
>> vhosts, i.e everything from the port 443 configuration sections to the
>> port 80 configuration. Some of that configuration is duplicated, so only
>> the unique things need to go.
>>
>> There may also be some directives to force SSL on some locations. You'll
>> want to remove those also.
>>
>> I'm writing this from memory without looking at the files, which is
>> alway a bad thing to do, but I think that covers it.
>>
>> HtH,
>> Jason
>>
>> On 03/30/2017 04:16 AM, Jayaraj JR wrote:
>>> Hello,
>>>
>>> Greetings of the day !
>>>
>>> SSL or https is a better option as far as security is concerned. But the
>>> heightened security level may not be necessary at many times especially
>>> while using Evergreen in Intranet. Besides the browser often warns the
>>> user that entering to my account in evergreen catalog is dangerous if
>>> purchased SSL is not implemented. This may often create confusion for
>>> childern and beginning users who are not well versed with computers.
>>> They are very often advised to add security exception for accessing the
>>> library catalog.
>>>
>>> It would appreciable, if any option or configuration is available to
>>> disable the SSL and to use the full library catalog via http.
>>> Kindly advice the configuration to use my account in Evergreen catalog
>>> via http itself and not https
>>>
>>> --
>>> Thanks in Advance,
>>>
>>> Jayaraj J R
>>> Library Information Assistant
>>> IISER Thiruvananthapuram
>
>
>
>

Re: [OPEN-ILS-GENERAL] WEbby Staff Client

[Mike Rylander]

Stuart,

>From time to time we deploy new code on webby as we fix bugs and add
features.  I think you just caught it during a refresh, as it seems to
be working fine now, but let us know if you continue to have issues.

Thanks,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org


On Thu, Mar 23, 2017 at 1:13 PM, Forrest, Stuart <sforr...@bcgov.net> wrote:
> Hi
>
>
>
> I am having trouble logging into the demo web staff client at
> https://webby.evergreencatalog.com/eg/staff/login?route_to=%2Feg%2Fstaff%2F
> with the username admin and password demo123. Tried this in Chrome and
> Firefox.
>
>
>
> When I click the Sign In button nothing happens, not even an error message.
> I have tried clearing my cache to no avail.
>
>
>
> Any advice would be appreciated.
>
>
>
> Stuart
>
>
>
> 
>
> Stuart Forrest PhD
>
> Library Systems Specialist
>
> Beaufort County Library System
>
> 843 255 6450
>
> sforr...@bcgov.net
>
>
>
> http://www.beaufortcountylibrary.org
>
>
>
> For Leisure, For Learning, For Life
>
>
>
>

Re: [OPEN-ILS-GENERAL] Series index, only first entry getting indexed

[Mike Rylander]

Josh,

btrim would be the natural normalizer to use, so let's test the timing to
see if it's faster...

evergreen=# explain analyze select count(btrim(value)) from
metabib.real_full_rec ;
 QUERY PLAN

-
 Aggregate  (cost=6129.66..6129.67 rows=1 width=11) (actual
time=542.861..542.862 rows=1 loops=1)
   ->  Seq Scan on real_full_rec  (cost=0.00..4989.77 rows=227977 width=11)
(actual time=0.010..221.404 rows=228822 loops=1)
 Planning time: 0.080 ms
 Execution time: 542.899 ms
(4 rows)

evergreen=# explain analyze select count(regexp_replace(value,' *$','',''))
from metabib.real_full_rec ;
 QUERY PLAN

-
 Aggregate  (cost=6129.66..6129.67 rows=1 width=11) (actual
time=818.893..818.894 rows=1 loops=1)
   ->  Seq Scan on real_full_rec  (cost=0.00..4989.77 rows=227977 width=11)
(actual time=0.010..230.265 rows=228822 loops=1)
 Planning time: 0.079 ms
 Execution time: 818.931 ms
(4 rows)


btrim is almost 50% faster! I didn't expect that, actually.  So I'd
recommend using btrim instead.  Your future self will thank you on your
next full reingest.

HTH,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.org
 | web:  http://equinoxinitiative.org

On Thu, Mar 2, 2017 at 9:29 AM, Josh Stompro <stomp...@exchange.larl.org>
wrote:

> Jason, this alone seems to leave trailing spaces in the facet entry table,
> since the space before the semicolon is left, which is required for the
> series index to not concatenate the last word of one 490 with the first
> word of the next 490.
>
>
>
> I tried adding a second normalizer that just strips trailing spaces and
> that seems to take care of it.
>
> insert into config.metabib_field_index_norm_map (field,norm,params,pos)
> values (1,18,'[" *$","",""]',-1);
>
> -- Change the first normazlier position to -2.
>
>
>
> There is also the btrim normalizer, I don’t know if that would be a
> better/faster than using another regexp_replace.
>
>
>
> Josh Stompro - LARL IT Director
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> boun...@list.georgialibraries.org] *On Behalf Of *Boyer, Jason A
> *Sent:* Wednesday, March 01, 2017 10:22 AM
> *To:* Evergreen Discussion Group
>
> *Subject:* Re: [OPEN-ILS-GENERAL] Series index, only first entry getting
> indexed
>
>
>
> Thanks for figuring this out, Josh. I was able to modify our normalizer
> like so to continue removing the $v:
>
> BEGIN;
>
> UPDATE config. index_normalizer SET param_count =3 WHERE id IN (SELECT id
> FROM config. index_normalizer WHERE func = 'regexp_replace');
>
> UPDATE config.metabib_field_index_norm_map SET params='[";
> *[0-9]*","","g"]' WHERE field = 1 and norm in (SELECT id FROM config.
> index_normalizer WHERE func = 'regexp_replace');
>
> COMMIT;
>
>
>
> If you have more than 1 normalizer that uses regexp_replace or are using
> it on more than one field you won't want to use this as-is, but if you only
> have the 1 and are currently only using it on your series titles it's good
> to go.
>
>
>
> Jason
>
>
>
> --
>
> Jason Boyer
>
> MIS Supervisor
>
> Indiana State Library
>
> http://library.in.gov/
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> boun...@list.georgialibraries.org
> <open-ils-general-boun...@list.georgialibraries.org>] *On Behalf Of *Josh
> Stompro
> *Sent:* Wednesday, March 01, 2017 10:41 AM
> *To:* Evergreen Discussion Group <open-ils-general@list.
> georgialibraries.org>
> *Subject:* Re: [OPEN-ILS-GENERAL] Series index, only first entry getting
> indexed
>
>
>
>  This is an EXTERNAL email. Exercise caution. DO NOT open attachments
> or click links from unknown senders or unexpected email. 
> --
>
> Removing the regex replace normalizer did take care of it, sorry I didn’t
> try that before posting.  I think my regex will have to be more selective,
> only getting rid of the number and the ‘;’ so it doesn’t clear out too much
> data.
>
>
>
> Josh Stompro - LARL IT Director
>
>
>
> *From:* Open-ils-general [mailto:open-ils-general-
> boun...@list.georgialibraries.org
> <open-ils-general-boun...@list.georgialibraries.org>] *On Behalf Of *Josh
> Stompro
> *Sent:* Wednesday, March 01, 2017 9:19 AM
> *T

Re: [OPEN-ILS-GENERAL] Slowness/freezing with XUL staff client

[Mike Rylander]

Jeff,

Is there an OS version that this happens on more often?  I'm looking
at you, Windows 10.

Thanks,

--
Mike Rylander
 | President
 | Equinox Open Library Initiative
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@equinoxinitiative.com
 | web:  http://equinoxinitiative.org


On Wed, Feb 1, 2017 at 4:43 PM, Jeff Davis <jeff.da...@bc.libraries.coop> wrote:
> Our consortium has a few libraries where the Evergreen staff client
> periodically becomes unusably slow or freezes up altogether.  I'm curious
> about other libraries' experiences with this problem.
>
> 1. Does the staff client slow down or freeze up regularly at your library?
> How often does it happen?  Are there any noticeable patterns (e.g. are only
> circ stations affected, not cataloguing)?
>
> 2. How do you deal with the problem?  We usually recommend limiting the
> number of open tabs, restarting the client periodically throughout the day,
> and increasing RAM.
>
> 3. If you use the web client, have you noticed an improvement?  We suspect
> that the root of the problem is the ancient version of XULrunner used by the
> old staff client, but we haven't had the opportunity to compare the web
> client in production.
> --
> Jeff Davis
> BC Libraries Cooperative

Re: [OPEN-ILS-GENERAL] Mangled UTF8 characters with imported MARC records in Z39.50

[Mike Rylander]

Jason hit on (almost certainly) the answer: bad records from sources that
don't restrict cataloging to valid character sets.  I'll add a couple
comments below for general clarification, as well...

On Fri, Dec 2, 2016 at 4:52 PM, Brent Mills 
wrote:

> Hello,
>
> I’ve recently noticed some issues with imported MARC records from a
> specific set of Z39.50 servers.
>
> A noticeable amount of records that are imported through
> Prospector/MaineCat targets have mangled characters when diacritics,
> symbols,etc.. are present in the record.
>
> Does anyone have some ideas on what could be causing the character
> encoding problems from these particular targets? Or run into this at their
> own site?
>
> - dgo.conf has marc-8. changing that to usmarc, utf8
> has had no effect
> - xml2marc-yaz.cfg is setup like described in https://wiki.evergreen-ils.
> org/doku.php?id=evergreen-admin:sru_and_z39.50 changing the charset
> options hasn’t had any effect either
>

The reason this doesn't change anything is that it's only used to describe
how Evergreen will server records to /others/ as a z39.50 server.  Those
are not client settings.


> - the encoding/translation problems do not happen with OCLC and Library of
> Congress targets, it seems to mainly affect servers with the INNOPAC db
> type. I’m not sure if that’s related.
>
>
This and the log message below are the smoking guns.  OCLC and LoC are
generally very good about making sure records really are in the character
set they advertise, and that that character set is one of only MARC-8 or
UTF8.

So, Jason nailed it -- there are non-UTF8, non-MARC-8 characters in those
records, as served by the INNOPAC sources.  That's a (remote) cataloging
issue.

HTH,

--Mike

Going through the logs I can see things like:
>
> open-ils.search.z3950.search_class: no mapping found for [0x80] at
> position 56 in Kurt and Joe tangle with the most determined enemy they’ve
> ever encountered when a ruthless powerbroker schemes to build a new
> Egyptian empire as glorious as those of the Pharaohs. Part of his plan
> rests on the manipulation of a newly discovered aquifer beneath the Sahara,
> but an even more devastating weapon at his disposal may threaten the entire
> world: a plant extract known as the black mist, discovered in the City of
> the Dead and rumored to have the power to take life from the living and
> restore it to the dead. With the balance of power in Africa and Europe on
> the verge of tipping, Kurt, Joe, and the rest of the NUMA team will have to
> fight to discover the truth behind the legends—but to do that, they have
> to confront in person the greatest legend of them all: Osiris, the ruler of
> the Egyptian underworld. g0=ASCII_DEFAULT g1=EXTENDED_LATIN at
> /usr/share/perl5/MARC/Charset.pm line 308.
>
>
> So I’m thinking something is happening in the MARC8 to UTF8 conversion?
>
> Attaching a screenshot of what it looks like in the Z39.50 Import screen.
> The 264s have been the most obvious place to see the issue, but it happens
> in any field with special characters.
>
> Been banging my head trying to figure out what’s causing this. Any help
> would be appreciated!
>
> Thank you,
>
> -Brent
>
> -
>
> Brent Mills
> Systems Librarian | Sage Library System
>
> email: br...@hoodriverlibrary.org
> tickets: https://sagelib.org/support
>
>

Re: [OPEN-ILS-GENERAL] Evergreen 2.11 proposed release schedule

[Mike Rylander]

Heads up, all!

If you're a committer and were planning to merge any pre-RC bug fix
branches, now's the time to do so.  If we can avoid DB updates, that'd
be best, but I'll leave that up to committers doing the committing.

For my part, I'll be committing two branches today in prep for the RC release.

Thanks, and happy merging!

--
Mike Rylander
 | President
 | Equinox Software, Inc. / Open Your Library
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, Aug 10, 2016 at 3:44 PM, Mike Rylander <mrylan...@gmail.com> wrote:
> UPDATE!!!
>
> By consensus during today's dev meeting in IRC, we're pushing back the
> Beta release date by one week.  The new date is August 24.
>
> This does not effect the RC or final release dates, which remain as
> listed below.
>
> Thanks, all!
>
> --
> Mike Rylander
>  | President
>  | Equinox Software, Inc. / Open Your Library
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  mi...@esilibrary.com
>  | web:  http://www.esilibrary.com
>
>
> On Fri, Jun 3, 2016 at 3:18 PM, Mike Rylander <mrylan...@gmail.com> wrote:
>> Hello all!
>>
>> Only a day late than originally promised, here is the proposed
>> schedule for the 2.11 release.
>>
>> 2.11 Alpha: Wednesday, July 27
>> 2.11 Beta and feature freeze: Wednesday, August 17, three weeks later
>> 2.11 RC1: Wednesday, September 7, three weeks later
>> 2.11.0: Wednesday, September 21, two weeks later
>>
>> As mentioned, it hews closely to the 2.9 schedule, just shifting a
>> week here or there.  Like Jason did, I want to align the beta feature
>> freeze and .0 cutting with regular maintenance releases of prior
>> versions.
>>
>> I promised a set of lists along with the schedule setting down the LP
>> bugs I hope to help wrangle before the Beta cut-off.  Unfortunately
>> for the purpose of making the promised email deadline (and fortunately
>> for every other purpose) bug squashing day kept changing those lists
>> right under me!  Thus, my delay in this email.  I'll be revising that
>> separately and sending that along soon.
>>
>> Thanks, all!  Questions? Ask away.
>>
>> --
>> Mike Rylander
>>  | President
>>  | Equinox Software, Inc. / Open Your Library
>>  | phone:  1-877-OPEN-ILS (673-6457)
>>  | email:  mi...@esilibrary.com
>>  | web:  http://www.esilibrary.com

Re: [OPEN-ILS-GENERAL] Reports

[Mike Rylander]

Stuart,

They're stored in the table called action.hold_request_cancel_cause:

=# select * from action.hold_request_cancel_cause;
 id | label
+---
  1 | Untargeted expiration
  2 | Hold Shelf expiration
  3 | Patron via phone
  4 | Patron in person
  5 | Staff forced
  6 | Patron via OPAC
  7 | Patron via SIP
(7 rows)

>From a recent stock load.

HTH,

--
Mike Rylander
 | President
 | Equinox Software, Inc. / Open Your Library
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, Jul 27, 2016 at 1:09 PM, Forrest, Stuart <sforr...@bcgov.net> wrote:
> Beth
>
>
>
> Thanks, that is what I was missing. Where can I get a list of all the
> possible values for this field?
>
>
>
> Thanks
>
> Stuart
>
>
>
> 
>
> Stuart Forrest PhD
>
> Library Systems Specialist
>
> Beaufort County Library
>
> 843 255 6450
>
> sforr...@bcgov.net
>
>
>
> http://www.beaufortcountylibrary.org
>
>
>
> For Leisure, For Learning, For Life
>
>
>
>
>
>
>
> From: Open-ils-general
> [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
> Willis, Beth
> Sent: Wednesday, July 27, 2016 12:57 PM
> To: Evergreen Discussion Group
> Subject: Re: [OPEN-ILS-GENERAL] Reports
>
>
>
> Hi,
>
>
>
> Change the value for the "Cause ID" filter to 5 to limit to "Staff forced"
> holds.
>
>
>
> On Tue, Jul 26, 2016 at 5:35 PM, Justin Bryant
> <jbry...@clarendoncountylibrary.com> wrote:
>
> I attached two screenshots, let me know if you need any more!
>
>
>
> On 2016-07-26 4:25 pm, Elizabeth Davis wrote:
>
> Hello Justin,
>
> I would love to see this template you are referring to.  Would you be
> able to share it either via screenshots or a documentation of it?
>
> Thanks!
>
> Elizabeth Davis
> Head of Digital Services
> Scranton Public Library
> 500 Vine Street
> Scranton, PA 18509
> 570-348-3000 ext. 3050
> eda...@albright.org
>
>
>
> -Original Message-
> From: Open-ils-general
> [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf
> Of Justin Bryant
> Sent: Tuesday, July 26, 2016 2:11 PM
> To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org>
> Subject: Re: [OPEN-ILS-GENERAL] Reports
>
> This isn't a complete solution, but maybe it'll put you closer.
>
> If you go to SCLENDS shared folder, and Circulation, there's a report
> template called "List of Patron Cancelled holds on Holds Shelf". This
> report can be used to show items not on the Hold Shelf too. If you
> clone the report and go to base filters, it has the 'Cause ID' as "6".
> If you can determine what number equals staff cancellation, you'll
> have your report.  I've no idea which number that'd be tho'.
>
> On 2016-07-26 11:15, Forrest, Stuart wrote:
>
> Hi
>
> Does anyone know of a report I can use to list all of the holds
> cancelled by staff in a certain period?
>
> Thanks
>
> Stuart
>
> ==
> ==
>
>
> Stuart Forrest PhD
>
> Library Systems Specialist
>
> Beaufort County Library
>
> 843 255 6450
>
> sforr...@bcgov.net
>
> http://www.beaufortcountylibrary.org [1]
>
> For Leisure, For Learning, For Life
>
>
>
> Links:
> --
> [1] http://www.beaufortcountylibrary.org/
>
>
>
>
>
> --
>
> Beth Willis
> Digital & Catalog Librarian
> NOBLE, Inc.
> 26 Cherry Hill Drive
> Danvers, MA 01923

Re: [OPEN-ILS-GENERAL] Help with reports - need end of year stats - can't get data - blank report

[Mike Rylander]

Jennifer,

It does this because a range goes from first (earliest) to last (latest).
That is true for any "between" (range) query, regardless of the data type.

Hope that helps.

Regards,

Mike Rylander

--   Sent from my phone, please pardon my thumbs.
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com
On Jun 30, 2016 10:22 AM, "Walz, Jennifer" <jlw...@asbury.edu> wrote:

> Brent,
>
>
>
> Thanks!
>
>
>
>   This did it.Whew.  I thought maybe I was going nuts. WHY does it
> do this? And can some instruction be listed someplace?
>
>
>
>   Just wondering.   Now to figure out how many Titles we added last year.
> Ha!
>
>
>
> Jennifer
>
>
>
> *From:* Open-ils-general [mailto:
> open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Brent
> Mills
> *Sent:* Wednesday, June 29, 2016 7:10 PM
> *To:* Evergreen Discussion Group
> *Subject:* Re: [OPEN-ILS-GENERAL] Help with reports - need end of year
> stats - can't get data - blank report
>
>
>
> Jennifer,
>
>
>
> And there is a ‘canned’ report from Equinox that is Count Items Added by
> Date Range.But nothing ever comes out.  I just get a blank.   I’ve
> tried all kinds of date ranges and don’t know what is wrong.
>
>
>
> Have you tried putting the older date range value in the first section of
> the between? I think that’s been an issue with a few of our date range
> reports.
>
>
>
>
>
>
>
> -Brent
>
>
>
> -
>
> Brent Mills
> Systems Librarian | Sage Library System
>
> email: br...@hoodriverlibrary.org
> tickets: https://sagesupport.eou.edu
> phone: 541.610.8384
>
>
>
> On Jun 29, 2016, at 1:47 PM, Walz, Jennifer <jlw...@asbury.edu> wrote:
>
>
>
> And there is a ‘canned’ report from Equinox that is Count Items Added by
> Date Range.But nothing ever comes out.  I just get a blank.   I’ve
> tried all kinds of date ranges and don’t know what is wrong.
>
>
>

[OPEN-ILS-GENERAL] Evergreen 2.11 proposed release schedule

[Mike Rylander]

Hello all!

Only a day late than originally promised, here is the proposed
schedule for the 2.11 release.

2.11 Alpha: Wednesday, July 27
2.11 Beta and feature freeze: Wednesday, August 17, three weeks later
2.11 RC1: Wednesday, September 7, three weeks later
2.11.0: Wednesday, September 21, two weeks later

As mentioned, it hews closely to the 2.9 schedule, just shifting a
week here or there.  Like Jason did, I want to align the beta feature
freeze and .0 cutting with regular maintenance releases of prior
versions.

I promised a set of lists along with the schedule setting down the LP
bugs I hope to help wrangle before the Beta cut-off.  Unfortunately
for the purpose of making the promised email deadline (and fortunately
for every other purpose) bug squashing day kept changing those lists
right under me!  Thus, my delay in this email.  I'll be revising that
separately and sending that along soon.

Thanks, all!  Questions? Ask away.

--
Mike Rylander
 | President
 | Equinox Software, Inc. / Open Your Library
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com

Re: [OPEN-ILS-GENERAL] Searchable Copy Notes

[Mike Rylander]

Sarah,

Thanks, that's useful use-case information.

I don't want to muddy the waters any more with specific backend details,
because regardless, development will be required.  To move this outside the
discussion of implementation details, would it be fair to say that, for the
uses you mention that you want "tags" that are searchable, and could be
applied to any copy?

I do want to point out that there's always the option to "upgrade" data as
well, so that the specific data stored in certain structures can be moved.

Thanks!


--
Mike Rylander
 | President
 | Equinox Software, Inc. / Open Your Library
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com

On Thu, May 19, 2016 at 2:43 PM, Sarah Childs <sar...@zionsvillelibrary.org>
wrote:

> My first thought is that like us, the libraries in Scott's consortium
> likely already have 1000s of existing copy notes that they want to be able
> to search. The alternate proposal sounds interesting, but I want to be able
> to search all the data that I already have. We've been using Evergreen
> since 2008, so we have many, many existing copy notes I'd like to be able
> to search.
>
> It sound like we use copy notes in a similar way. We put notes about
> various memorials. We also do annual "benefactor" notes for special Friend
> of the Library gifts. We also do notes which honor library volunteers each
> year. Basically, any time we do a book plate, we also add a copy note. It
> would be very useful to be able to search the copy note information. It
> would also be useful to have copy note templates that could be applied to
> multiple copies at once.
>
> On Thu, May 19, 2016 at 1:59 PM, Mike Rylander <mrylan...@gmail.com>
> wrote:
>
>> Scott,
>>
>> Since your main use case is about applying the same message to many
>> specific copies, like a "digital book plate", it might be interesting to
>> consider using copy buckets with a new type of, say, "donation", instead.
>> Each bucket of that type would get its own name and description fields,
>> analogous to the title and value fields on copy notes.  Here are some
>> benefits I see:
>>
>>  * By only having the one bucket for a given donation, regardless of the
>> number of items, we avoid human error on the note entry.
>>  * Also, searching the name and description strings becomes very "cheap"
>> compared to copy note title/value, since there is only the one bucket
>> rather than a note per item.
>>  * We already have specialized bucket-related interfaces already, which
>> allow seeing the item set as a whole and manipulating them together.
>>  * A URL can already be created that points any user, via the OPAC, at
>> the set of records with items in the container, and (as a bonus) searches
>> can be performed /within/ that set.
>>  * Because we have container-specific logic in the search code already,
>> it's a (much, much, much) simpler path to add "searching" on name or
>> description of these donation buckets, rather than copy notes.
>>
>> Thoughts?
>>
>>
>> --
>> Mike Rylander
>>  | President
>>  | Equinox Software, Inc. / Open Your Library
>>  | phone:  1-877-OPEN-ILS (673-6457)
>>  | email:  mi...@esilibrary.com
>>  | web:  http://www.esilibrary.com
>>
>> On Thu, May 19, 2016 at 1:14 PM, scott.tho...@sparkpa.org <
>> scott.tho...@sparkpa.org> wrote:
>>
>>> Hi,
>>>   We are trying to gauge community support for creating, in the staff
>>> client, a keyword search interface for Copy Notes. We are a statewide
>>> consortium. Since bib records are shared, we do not allow our members to
>>> use Local Notes tags like 590 for very localized information like “In
>>> memory of Jim Jones” or “Donated by Harry Haynes.” The problem is that
>>> descendants of Mr. Jones and Mr. Haynes himself might come in and demand to
>>> know what items come up, and we have no way of doing that (other than
>>> reports which cannot easily be run by front-line staff). Would anyone else
>>> like to see a search interface for Copy Notes? Also, what kind of
>>> information do other libraries and consortia place in Copy Notes?
>>>
>>> Thank you,
>>> Scott
>>>
>>>
>>>
>>> Scott Thomas
>>>
>>> Executive Director
>>>
>>> *PaILS / SPARK*
>>>
>>> (717) 873-9461
>>>
>>> scott.tho...@sparkpa.org
>>>
>>> [image: Description: Description: Training | SPARK – Pennsylvania's
>>> Statewide Library System] <http://www.palibrary.org/pails/>
>>>
>>>
>>>
>>
>>
>
>
> --
> Sarah Childs
> Technical Services Department Head
> Hussey-Mayfield Memorial Public Library
> 250 North Fifth Street
> Zionsville, IN 46077
> 317-873-3149 x13330
> sar...@zionsvillelibrary.org
>

Re: [OPEN-ILS-GENERAL] Searchable Copy Notes

[Mike Rylander]

Elaine,

Sorry, I should have mentioned that all of what I said still requires
development, and adding display of specific types of buckets would be a
trivial component of that work.

The fact that public copy notes can display in the OPAC today doesn't
really mean that making their content searchable would be simpler that what
I've suggested.  In terms of effort and cost (both direct development and
maintenance of the code, and I believe for cataloger efficiency benefits),
folding copy notes into search is much more costly than displaying specific
copy buckets that a copy belongs to.

Does that help clarify?



--
Mike Rylander
 | President
 | Equinox Software, Inc. / Open Your Library
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com

On Thu, May 19, 2016 at 2:37 PM, Elaine Hardy <eha...@georgialibraries.org>
wrote:

> The main problem I see with the copy bucket approach is that it removes
> the direct acknowledgement of the gift  a public copy note gives by being
> displayed in the OPAC, which is desired by many donors.  They want everyone
> to see that they donated the book both in the book itself and in the OPAC,
> as well as being able to search the catalog for their donations. Removing
> that direct link and using just a copy bucket would mean that the item
> retrieved by itself would not indicate the gift in the OPAC.
>
> Like PaILS, PINES also does not allow information of a local nature to be
> input into the bibliographic record, so copy notes are used to indicate
> gifts. There are many changes we would like to see to notes, the ability
> for patrons and staff to search them is one. Our libraries do often get
> donors wanting to see the books they donated in the catalog as well as the
> physical item on the shelf.
>
> Elaine
>
>
>
> J. Elaine Hardy
> PINES & Collaborative Projects Manager
> Georgia Public Library Service/PINES
> 1800 Century Place, Ste. 150
> Atlanta, GA 30045
>
> 404.235.7128 Office
> 404.548.4241 Cell
> 404.235.7201 FAX
>
> On Thu, May 19, 2016 at 1:59 PM, Mike Rylander <mrylan...@gmail.com>
> wrote:
>
>> Scott,
>>
>> Since your main use case is about applying the same message to many
>> specific copies, like a "digital book plate", it might be interesting to
>> consider using copy buckets with a new type of, say, "donation", instead.
>> Each bucket of that type would get its own name and description fields,
>> analogous to the title and value fields on copy notes.  Here are some
>> benefits I see:
>>
>>  * By only having the one bucket for a given donation, regardless of the
>> number of items, we avoid human error on the note entry.
>>  * Also, searching the name and description strings becomes very "cheap"
>> compared to copy note title/value, since there is only the one bucket
>> rather than a note per item.
>>  * We already have specialized bucket-related interfaces already, which
>> allow seeing the item set as a whole and manipulating them together.
>>  * A URL can already be created that points any user, via the OPAC, at
>> the set of records with items in the container, and (as a bonus) searches
>> can be performed /within/ that set.
>>  * Because we have container-specific logic in the search code already,
>> it's a (much, much, much) simpler path to add "searching" on name or
>> description of these donation buckets, rather than copy notes.
>>
>> Thoughts?
>>
>>
>> --
>> Mike Rylander
>>  | President
>>  | Equinox Software, Inc. / Open Your Library
>>  | phone:  1-877-OPEN-ILS (673-6457)
>>  | email:  mi...@esilibrary.com
>>  | web:  http://www.esilibrary.com
>>
>> On Thu, May 19, 2016 at 1:14 PM, scott.tho...@sparkpa.org <
>> scott.tho...@sparkpa.org> wrote:
>>
>>> Hi,
>>>   We are trying to gauge community support for creating, in the staff
>>> client, a keyword search interface for Copy Notes. We are a statewide
>>> consortium. Since bib records are shared, we do not allow our members to
>>> use Local Notes tags like 590 for very localized information like “In
>>> memory of Jim Jones” or “Donated by Harry Haynes.” The problem is that
>>> descendants of Mr. Jones and Mr. Haynes himself might come in and demand to
>>> know what items come up, and we have no way of doing that (other than
>>> reports which cannot easily be run by front-line staff). Would anyone else
>>> like to see a search interface for Copy Notes? Also, what kind of
>>> information do other libraries and consortia place in Copy Notes?
>>>
>>> Thank you,
>>> Scott
>>>
>>>
>>>
>>> Scott Thomas
>>>
>>> Executive Director
>>>
>>> *PaILS / SPARK*
>>>
>>> (717) 873-9461
>>>
>>> scott.tho...@sparkpa.org
>>>
>>> [image: Description: Description: Training | SPARK – Pennsylvania's
>>> Statewide Library System] <http://www.palibrary.org/pails/>
>>>
>>>
>>>
>>
>>
>

Re: [OPEN-ILS-GENERAL] Reports including in-house use

[Mike Rylander]

I do what I can. :)

Regards,

Mike Rylander

--   Sent from my phone, please pardon my thumbs.
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com
On May 18, 2016 7:04 PM, "Jane Sandberg" <sand...@linnbenton.edu> wrote:

> Mike Rylander, you are a gentleman and a scholar.  That was the trick!
> Thanks!
>
> On Wed, May 18, 2016 at 11:10 AM, Mike Rylander <mrylan...@gmail.com>
> wrote:
> > Jane,
> >
> > You should be able to enable nullability, start with the In-house Use
> > source, and select a "parent nullable" (right join) link to items.
> > Does that work for you?
> >
> > Regards,
> >
> > --
> > Mike Rylander
> >  | President
> >  | Equinox Software, Inc. / Open Your Library
> >  | phone:  1-877-OPEN-ILS (673-6457)
> >  | email:  mi...@esilibrary.com
> >  | web:  http://www.esilibrary.com
> >
> >
> > On Wed, May 18, 2016 at 12:31 PM, Jane Sandberg <sand...@linnbenton.edu>
> wrote:
> >> Hi colleagues,
> >>
> >> I am trying to create a report in the reporter that lists all items
> >> and how many in-house uses they have.
> >>
> >> * I can use In-house Use as my initial source, but then I don't get
> >> any items with 0 in-house uses.
> >> * I can use Item as my initial source, but it doesn't seem to be
> >> linked to the In-house use table for reporter purposes.
> >>
> >> I was thinking of filing a launchpad bug that a link to in-house use
> >> is missing from the item source.  However, I want to make sure that I
> >> am not missing something!
> >>
> >> Thanks!
> >>
> >>   -Jane
> >>
> >> --
> >> Jane Sandberg
> >> Electronic Resources Librarian
> >> Linn-Benton Community College
> >> sand...@linnbenton.edu / 541-917-4655
>
>
>
> --
> Jane Sandberg
> Electronic Resources Librarian
> Linn-Benton Community College
> sand...@linnbenton.edu / 541-917-4655
>

Re: [OPEN-ILS-GENERAL] Reports including in-house use

[Mike Rylander]

Jane,

You should be able to enable nullability, start with the In-house Use
source, and select a "parent nullable" (right join) link to items.
Does that work for you?

Regards,

--
Mike Rylander
 | President
 | Equinox Software, Inc. / Open Your Library
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, May 18, 2016 at 12:31 PM, Jane Sandberg <sand...@linnbenton.edu> wrote:
> Hi colleagues,
>
> I am trying to create a report in the reporter that lists all items
> and how many in-house uses they have.
>
> * I can use In-house Use as my initial source, but then I don't get
> any items with 0 in-house uses.
> * I can use Item as my initial source, but it doesn't seem to be
> linked to the In-house use table for reporter purposes.
>
> I was thinking of filing a launchpad bug that a link to in-house use
> is missing from the item source.  However, I want to make sure that I
> am not missing something!
>
> Thanks!
>
>   -Jane
>
> --
> Jane Sandberg
> Electronic Resources Librarian
> Linn-Benton Community College
> sand...@linnbenton.edu / 541-917-4655

Re: [OPEN-ILS-GENERAL] Bibliomation - Evergreen System Manager Promotion

[Mike Rylander]

That's great news!  Congrats, Melissa!

--
Mike Rylander
 | President
 | Equinox Software, Inc. / Open Your Library
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Thu, Apr 14, 2016 at 4:11 PM, Brent Mills <br...@hoodriverlibrary.org> wrote:
> Nice! Congratulations Melissa!
>
> Brent Mills
> Systems Librarian | Sage Library System
> email: br...@hoodriverlibrary.org
> tickets: sagelib.org/support
> mobile: 541.610.8384
>
>
> On Thu, Apr 14, 2016 at 12:51 PM, Amy Terlaga <terl...@biblio.org> wrote:
>
> I am happy to announce that Melissa Ceraso has been promoted to
> Bibliomation's Evergreen System Manager position. Melissa has been with
> Bibliomation for two and a half years now and she has proven herself to be
> very skilled, resourceful, and a joy to work with. We know we have so much
> to look forward to with her in this very critical role.
>
> Please join me in congratulating her in her new position. We'll be at the
> Evergreen conference, so you can congratulate her there, too!
>
> Amy
> --
> +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
> Amy Terlaga
> Director of Member Services
> Bibliomation, Inc.
> 24 Wooster Avenue
> Waterbury, CT 06708
> (203)577-4070 x101
> terl...@biblio.org

Re: [OPEN-ILS-GENERAL] Evergreen 2.9 and PostgreSQL 9.4 - A Cautionary Tale

[Mike Rylander]

Chris,

I was happy be able to perform that emergency diagnosis and
immediately implement several of the changes you listed, and glad you
were able to move quickly to implement my recommendations requiring
restarts.  I know it was a stressful time for your team, and it's
frustrating when the things you've tried in the past don't help in new
situations.

I want to provide some context regarding the specific changes I made,
and had you make, just so folks can make the best use of the
information out there.  Though I'm sure you know this, the details of
the tuning any given Postgres instance are extremely dependent on the
particular data set, even when you're using the same application
(Evergreen in this case).

With regard to the join collapse limit, there are many other data sets
that do not show the same sensitivity to the setting as PINES.  Most
are well-served by the bug fix on
https://bugs.launchpad.net/evergreen/+bug/1527731 .  There is a
not-insignificant cost to increasing this value, so there is a trade
off to be weighed.  In PINES case, the increase in large-query
planning time was far outweighed by the cost of the very-slow queries
being seen, of course.  You'll notice that a much smaller increase
described in the bug was all that was needed in Dan Wells' case,
though even that was not necessary with the patch.  An overly-high
setting here can be detrimental to performance in general -- IOW,
setting the join collapse limit as high as I've had you set it for
PINES is definitely not a blanket optimization opportunity.

For the ROWS adjustments, that can have a significant effect on plan
creation (positive or negative) and is directly dependent on the data
set.  It was also critical in combination with the join collapse limit
change, as otherwise row estimates in the PINES data set were still
pushing plans in a sub-optimal direction.  The specific setting of 300
is only applicable to PINES.  It feeds into the calculus that Postgres
uses when constructing query plans, and must be tuned to the data set
if it needs to be tuned at all.  In many cases it does not need to be
adjusted, and a high setting here can cause bad plans.  While it does
look like the value is essentially the number of org units in the
instance, identifying the best value is not simply a matter of setting
ROWS to approximately the number of org units you have -- there are
situations (and configurations) where that isn't the correct thing to
do, and it requires instance-specific evaluation to determine what's
best.

Indexes are also extremely data set dependent, of course, and their
cost comes from the regular index maintenance costs. Obviously there's
no need for multiple, identical indexes, so removing those is always a
good recommendation if they are, indeed, duplicates.  Adding an index
is (relative to other tuning measures) pretty cheap if you have the
drive space, but action.circulation is a pretty hot table (it changes
a lot, and quickly), so unless there is a problem with timeouts to a
site's collections vendor, I wouldn't recommend adding that specific
index.

For shared buffers, I can't think of a situation where I would
recommend more than 32G, and even for PINES 16G is probably enough.
However, since 32G is working well for you I wouldn't change it at
this point.  A large shared buffers setting causes a lot of waste in
terms of RAM (pages are loaded twice, once in shared buffers and once
in the OS page cache; wasted bookkeeping memory for the page map) and
CPU time (locking stalls, CHECKPOINT timeout I/O storms, buffer
eviction clock sweep work, load on the background writer, just to name
a few). This is definitely one of those "every instance is different"
things.

Having said all that, disabling transparent huge pages is pretty much
critical -- it's as important as disabling zone reclaim on any NUMA
system.  This was a non-issue on 9.2, became important in some
situations on 9.3, and is a huge issue for 9.4.  The reasons are
complicated, but the cause is Postgres' change from System V to POSIX
shared memory.  Basically, just do it. :)

Thanks for sharing, Chris, and again, I was glad to help when needed.

--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com



On Wed, Feb 10, 2016 at 2:41 PM, Chris Sharp
<csh...@georgialibraries.org> wrote:
> Hello all,
>
> As watchers of the Evergreen IRC channel, know, the PINES upgrade from 
> Evergreen 2.7.2/PostgreSQL 9.3 to Evergreen 2.9.1/PostgreSQL 9.4 was a bit 
> bumpy.  Our system slowed to a crawl on go-live day, and we were quick to 
> determine that the culprit was the database.  After consulting with Mike 
> Rylander of Equinox Software, we implemented several tweaks to our system 
> that I'll share here in hopes that they may help others in the future:
>
> The slowness appears to have been

Re: [OPEN-ILS-GENERAL] Custom Org Unit Trees

[Mike Rylander]

Robert,

Sorry, but the subfield 9 in located URIs don't work that way with the
custom org unit tree.  What you want, as you describe it, isn't
possible today.

HTH,

--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com



On Fri, Feb 5, 2016 at 10:29 AM, Jackson, Robert
<rjack...@library.in.gov> wrote:
> Hi all,
>
>
>
> Hoping someone can tell me if it is possible to use the Custom Org Unit
> Trees to create a list of branches to assist in maintaining which branches
> are subscribed to a specific service (such as Hoopla).  The thought here is
> to create a system level entry (Hoopla) and add the participating branches
> under Hoopla without messing up the Opac Org Unit tree?
>
>
>
> For example: Hoopla is system level entry/shortname
>
>
>
> Branch1 Branch2 and Branch3 are Hoopla subscribers.
>
>
>
>
>
> All Bib records from Hoopla are added with an 856 entry with $u Link to
> item, $y text to display and $9 as Hoopla
>
>
>
> This would make updates to the sites subscribed be as simple as changing the
> Custom Org Tree as opposed to dumping all Hoopla bibs and redoing the 856
> entries with multiple $9 values per site.
>
>
>
> I appreciate any thoughts in this regards!
>
>
>
>
>
>
>
> -
> Robert J. Jackson
> Systems Administrator Int.
> Indiana State Library
> http://library.in.gov
> 315 W Ohio St
> Indianapolis, IN 46202
> (317) 234-7317
> rjack...@library.in.gov

Re: [OPEN-ILS-GENERAL] Android app and 856 links, any shortcuts?

[Mike Rylander]

On Mon, Jan 18, 2016 at 9:19 AM, Galen Charlton <g...@esilibrary.com> wrote:
> Hi,
>
> On Sun, Jan 17, 2016 at 1:19 PM, Ken Cox <kens...@gmail.com> wrote:
>> Has anyone found any shortcuts to make the checkout process less cumbersome?
>> For instance, if the app knew the library card number a priori, could I
>> construct a URL that lands closer to checkout?  Or login to the catalog
>> before following the resource link?
>
> In the general case, no, or at least not in one fell swoop -- there
> are a variety of services that libraries contract with to provide
> ebooks, and they don't all use the same APIs.  The news is better for
> specific services such as OverDrive, where there is work underway to
> have Evergreen use OverDrive's APIs to perform direct checkouts and
> provisioning of ebooks.
>
> As far as Axis 360 is concerned, it looks like Baker and Taylor
> advertises some sort of "ILS integration", but I'm not sure whether
> that will support direct checkout and download of ebooks via the ILS.
> Hopefully folks from libraries using Axis 360 will chime in.
>

To look at it from a slightly different direction, it's really up to
B to make the process seamless since they are supplying just a bare
link to the library.

Evergreen supplies APIs for 3rd parties to use, for example, to verify
pre-existing Evergreen sessions.  This allows them to make sure that
the requesting patron is from an authorized library.  There are
services making use of that particular API today -- the online
database service call Galileo that PINES provides to its patrons has
been using it since Evergreen version 1.0 -- and we would love to see
other 3rd party services make use of (and even extend) what Evergreen
already provides.  There are other mechanisms as well that an outside
agent could leverage.

--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com

Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts - AND books?

[Mike Rylander]

Jennifer,

Where, other than reports that lack a filter on Is deleted, are these
items showing up?

Thanks,


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, Aug 5, 2015 at 10:35 AM, Walz, Jennifer jlw...@asbury.edu wrote:

 All –



   I completely understand!   This is a valuable option for those folks who
 need this.  But there should ALSO be an option for completely and utterly
 obliterating the record – if you need to.We just REMOVED about 600
 books from our collection (remember that we are an academic library) and we
 never want to see them again.   We expect that they are weeded and gone.
 But no.   They are still hanging around the system to clutter things up.
 And confuse things too.   That is why we are experiencing so much problem
 with our items we are moving around into a new Children’s collection.   We
 weeded, we merged, and now we are changing call numbers.   But the
 “deleted” stuff keeps showing up when we THOUGHT we deleted it and never
 want to see it again.



   I’m NOT saying to remove the option to “hide” items in case you want to
 use them again or in the case where there are items attached or fines or
 such.   BUT, it would be really great to also have the option to really and
 finally REMOVE items from the system.  There are times when that is needed
 as well.



   Thanks!



 Jennifer

 --
 Jennifer Walz, MLS - Head of ILS Ministrations
 Kinlaw Library -  *Asbury University*
 One Macklem Drive, Wilmore, KY 40390
 859-858-3511 ext. 2269
 jlw...@asbury.edu



 *From:* Open-ils-general [mailto:
 open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Rogan
 Hamby
 *Sent:* Wednesday, August 05, 2015 10:10 AM
 *To:* Evergreen Discussion Group
 *Subject:* Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts - AND books?



 Oh yeah, they reappear like fleas.  It's one reason I don't like
 obliterating, things that folks are sure they never want to see again one
 day suddenly are desirable the next.







 On Wed, Aug 5, 2015 at 10:00 AM, Jason Stephenson jstephen...@mvlc.org
 wrote:

 Funny thing about deleted copies is they come back!

 Just last week I was asked to undelete about 1 dozen copies that showed up
 in the returns.

 If you really delete them from the database, you can't do that.

 Just some food for thought.

 Jason
 --
 Jason Stephenson
 Assistant Director for Technology Services
 Merrimack Valley Library Consortium
 4 High ST, Suite 175
 North Andover, MA 01845
 Phone: 978-557-5891
 Email: jstephen...@mvlc.org





 --



 Rogan Hamby, MLS, CCNP, MIA

 Managers Headquarters Library and Reference Services,

 York County Library System



 “You can never get a cup of tea large enough or a book long enough to suit
 me.”
 ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis

Re: [OPEN-ILS-GENERAL] Inventory Item

[Mike Rylander]

Scott,

I think it certainly could, unless you include that count in your, say,
annual state-wide circulation reports.  I was going to say that you might
want to put a prohibition in place while you scan in everything for your
inventory run, but (barring the circulation report issue) that isn't a
worry -- scanning an item for actual in-house use or for inventory is fine
since either way you're recording the fact that the book is in a known
location.

Great thought!


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Thu, Jul 30, 2015 at 8:40 AM, Scott Thomas sc...@albright.org wrote:

 Thank you, everyone, for your insights. We don't use In Record In-House
 Use very often. Would this work as an ersatz  inventory tool?

 Scott

 -Original Message-
 From: Open-ils-general [mailto:
 open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Hardy,
 Elaine
 Sent: Wednesday, July 29, 2015 1:27 PM
 To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org
 
 Subject: Re: [OPEN-ILS-GENERAL] Inventory Item

 If the item is checked in or out. The inventory date is set for any item
 scanned during an inventory process and would include items never checked
 out such as non-circulating  collections and those items that are
 circulating but haven't checked out. It helps identify missing copies and
 other exceptions. You can fake an inventory date in Evergreen by checking
 in the items on the shelf all on one date, setting the active/last edit
 date and then allowing you to run reports for items not on the shelf and
 not checked out for that date.

 Elaine


 J. Elaine Hardy
 PINES  Collaborative Projects Manager
 Georgia Public Library Service
 1800 Century Place, Ste 150
 Atlanta, Ga. 30345-4304


 404.235.7128
 404.235.7201, fax
 eha...@georgialibraries.org
 www.georgialibraries.org
 www.georgialibraries.org/pines


 -Original Message-
 From: Open-ils-general
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
 Jason Stephenson
 Sent: Wednesday, July 29, 2015 1:21 PM
 To: Evergreen Discussion Group
 Subject: Re: [OPEN-ILS-GENERAL] Inventory Item

 The active date is set the first time a copy is scanned for check in or
 check out.
 It sounds to me like the date that you want.

 Quoting Hardy, Elaine eha...@georgialibraries.org:

  Not exactly. The date inventoried is the date an item is confirmed to
  be in the library's collection, either on the shelf or out on loan. It
  is system set during an automated inventory and is separate from
  active or other system dates on an item
 
  Elaine
 
 
  J. Elaine Hardy
  PINES  Collaborative Projects Manager Georgia Public Library Service
  1800 Century Place, Ste 150
  Atlanta, Ga. 30345-4304
 
 
  404.235.7128
  404.235.7201, fax
  eha...@georgialibraries.org
  www.georgialibraries.org
  www.georgialibraries.org/pines
 
  -Original Message-
  From: Open-ils-general
  [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
  Jason Stephenson
  Sent: Wednesday, July 29, 2015 1:15 PM
  To: Evergreen Discussion Group
  Subject: Re: [OPEN-ILS-GENERAL] Inventory Item
 
  If I understand the question correctly, the active_date on a copy should
  serve this purpose.  This meant to be the date that the copy became
 live
  in the system.
 
  Quoting Scott Thomas sc...@albright.org:
 
  We have been with EG for four months, and this is the first time this
  has come up: there does not appear to be an Inventory Item function
  (at least in 2.6.3). I am not finding a Date Inventoried field in the
  item record nor can I locate a way to inventory an item. Am I missing
  something obvious? If not, how do Evergreen libraries inventory their
  collections?
 
  Thank you,
  Scott
 
 
  Scott  Thomas, MLS
  Head of Information Technologies and Technical Services Scranton
  Public Library Lackawanna County Library System
  2006 N. Main Ave.
  Scranton, PA 18508
  Ph: 570-207-2379
  Fx: 570-348-3020
  Email: sc...@albright.orgmailto:sc...@albright.org
 
 
  --
  Jason Stephenson
  Assistant Director for Technology Services
  Merrimack Valley Library Consortium
  4 High ST, Suite 175
  North Andover, MA 01845
  Phone: 978-557-5891
  Email: jstephen...@mvlc.org


 --
 Jason Stephenson
 Assistant Director for Technology Services
 Merrimack Valley Library Consortium
 4 High ST, Suite 175
 North Andover, MA 01845
 Phone: 978-557-5891
 Email: jstephen...@mvlc.org

Re: [OPEN-ILS-GENERAL] Full author date on individual titles?

[Mike Rylander]

Interestingly, the search under the author name link is retaining the full
value from the 100$d.  I suspect normalization in the tpac itself is at
work here...

[looks at code]

Yep, it looks like there is some normalization of $d around line 72
of Open-ILS/src/templates/opac/parts/record/authors.tt2.  If the field
starts with for numbers we take just those, and likewise take just the year
part of the death date.

HTH,


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, Jul 29, 2015 at 3:46 PM, Hardy, Elaine eha...@georgialibraries.org
wrote:

 I see the same thing in the PINES database with Sandford, John and  with a
 different author -- Johnson, Michael, ‡d1937 April 22-

 For retrieval list:

 http://gapines.org/eg/opac/results?query=johnson%2C%20michael;qtype=author;locg=1;facet=author|personal[Johnson%2C%20Michael%201937%20April%2022-]
 The first record in the list :

 http://gapines.org/eg/opac/record/5549682?query=johnson%2C%20michael;qtype=author;locg=1;facet=author|personal[Johnson%2C%20Michael%201937%20April%2022-]


 Elaine


 J. Elaine Hardy
 PINES  Collaborative Projects Manager
 Georgia Public Library Service
 1800 Century Place, Ste 150
 Atlanta, Ga. 30345-4304


 404.235.7128
 404.235.7201, fax
 eha...@georgialibraries.org
 www.georgialibraries.org
 www.georgialibraries.org/pines


 -Original Message-
 From: Open-ils-general
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
 Tony Bandy
 Sent: Wednesday, July 29, 2015 3:26 PM
 To: Evergreen Discussion Group
 Subject: Re: [OPEN-ILS-GENERAL] Full author date on individual titles?

 Hi Galen, folks,

 Thanks for the update!

 ---

 Here's a search that should show a bit better:


 1.  Search our Blanchester Library for books from John Sandford


 http://blanchester.cool-cat.org/eg/opac/results?fi%3Aformat=query=Sandford%2C+John.qtype=authorlocg=111

 The results are mixed, but if you look at the hit for Uncaged you will
 see:

 Sandford, John, 1944 February 23-


 2.  Now if I select that particular title:


 http://blanchester.cool-cat.org/eg/opac/record/930326?query=Sandford%2C%20John.;qtype=author;locg=111

 The results are:

 Sandford, John, 1944-   Cook, Michele.

 ---

 I'm not a cataloger, so maybe the full date is a nonstandard use?  I
 checked
 the authors.tt2 file(s), but wasn't sure--thinking maybe it might be
 something else?  I checked the bugs list as well, but didn't see anything
 directly related...

 Thanks for any ideas as you have a moment!

 --Tony

 Tony Bandy
 to...@ohionet.org
 OHIONET
 1500 West Lane Ave.
 Columbus, OH  43221-3975
 614-484-1074 (Direct)
 614-486-2966 x19

 -Original Message-
 From: Open-ils-general
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
 Galen Charlton
 Sent: Wednesday, July 29, 2015 3:19 PM
 To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org
 
 Subject: Re: [OPEN-ILS-GENERAL] Full author date on individual titles?

 Hi,

 On Wed, Jul 29, 2015 at 12:19 PM, Tony Bandy to...@ohionet.org wrote:
  On our Evergreen 2.7.2 system, when we search for an author, say Ernie
  Pyle, the results list includes a full birthdate in this format:
 
  Author--YEAR—Month—Day
 
  However, when looking at individual title results, the format is only
  this:
 
  Author--YEAR

 Could you send links to search results and title details showing the
 problem?  I tried doing an author search for Ernie Pyle in your catalog,
 and am not seeing hits that include the author's full birthdate (which
 aren't commonly found in name headings).

 Regards,

 Galen
 --
 Galen Charlton
 Infrastructure and Added Services Manager Equinox Software, Inc. / The Open
 Source Experts
 email:  g...@esilibrary.com
 direct: +1 770-709-5581
 cell:   +1 404-984-4366
 skype:  gmcharlt
 web:http://www.esilibrary.com/
 Supporting Koha and Evergreen: http://koha-community.org 
 http://evergreen-ils.org

Re: [OPEN-ILS-GENERAL] Apache leaking sockets/FD

[Mike Rylander]

Josh,

When you see this happen again, please try `lsof -n -P -p pid` (note the
-n and -P) instead.  That will give the IP addrs and port numbers without
attempting to convert host or service names and should help you identify
the offending connections.

Regards,


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, Jul 22, 2015 at 9:14 PM, Josh Stompro stomp...@exchange.larl.org
wrote:

  Greetings,  I’ve been trying to figure out why my two front end
 Evergreen application servers keep hitting some resource limits having to
 do with tcp sockets (numtcpsock openvz beancounters).



 I’m running EG 2.8.2, OpenSRF 2.4.1, Debian Jessie in an Openvz container
 on Proxmox VE 3.4



 Nothing looks out of the ordinary when I look at the output of ‘ss –s’ or
 ‘netstat –a’, but the numtcpsock counter keeps going up, until I have 5000+
 reported open tcp socket connections.



 I think I’ve narrowed it down to apache, since restarting apache resets
 the numtcpsock numbers back in line with what is reported by ‘ss –s’



 If I take a look at all the open fd’s of an apache process, I see a bunch
 of the following.  So I think some socket connections are being opened but
 not closed properly.



 (lsof –p pid)



 /usr/sbin 11821 opensrf  171u  sock0,6  0t0 61135031
 can't identify protocol

 /usr/sbin 11821 opensrf  172u  sock0,6  0t0 61135034
 can't identify protocol

 /usr/sbin 11821 opensrf  173u  sock0,6  0t0 61135037
 can't identify protocol

 /usr/sbin 11821 opensrf  174u  sock0,6  0t0 61321969
 can't identify protocol

 /usr/sbin 11821 opensrf  175u  sock0,6  0t0 61321972
 can't identify protocol

 /usr/sbin 11821 opensrf  176u  sock0,6  0t0 61321975
 can't identify protocol

 /usr/sbin 11821 opensrf  177u  sock0,6  0t0 61321978
 can't identify protocol

 /usr/sbin 11821 opensrf  178u  sock0,6  0t0 61321981
 can't identify protocol

 /usr/sbin 11821 opensrf  179u  sock0,6  0t0 61458539
 can't identify protocol

 /usr/sbin 11821 opensrf  180u  sock0,6  0t0 61458542
 can't identify protocol

 /usr/sbin 11821 opensrf  181u  sock0,6  0t0 61458545
 can't identify protocol

 /usr/sbin 11821 opensrf  182u  sock0,6  0t0 61458548
 can't identify protocol

 /usr/sbin 11821 opensrf  183u  sock0,6  0t0 61458551
 can't identify protocol

 /usr/sbin 11821 opensrf  184u  sock0,6  0t0 62085495
 can't identify protocol

 /usr/sbin 11821 opensrf  185u  sock0,6  0t0 62085498
 can't identify protocol

 /usr/sbin 11821 opensrf  186u  sock0,6  0t0 62085501
 can't identify protocol

 /usr/sbin 11821 opensrf  187u  sock0,6  0t0 62085504
 can't identify protocol

 /usr/sbin 11821 opensrf  188u  sock0,6  0t0 62085507
 can't identify protocol

 /usr/sbin 11821 opensrf  189u  sock0,6  0t0 63801157
 can't identify protocol

 /usr/sbin 11821 opensrf  190u  sock0,6  0t0 63801160
 can't identify protocol

 /usr/sbin 11821 opensrf  191u  sock0,6  0t0 63801163
 can't identify protocol

 /usr/sbin 11821 opensrf  192u  sock0,6  0t0 63801166
 can't identify protocol

 /usr/sbin 11821 opensrf  193u  sock0,6  0t0 63801169
 can't identify protocol

 /usr/sbin 11821 opensrf  194u  sock0,6  0t0 63961716
 can't identify protocol

 /usr/sbin 11821 opensrf  195u  sock0,6  0t0 63961719
 can't identify protocol

 /usr/sbin 11821 opensrf  196u  sock0,6  0t0 63961722
 can't identify protocol

 /usr/sbin 11821 opensrf  197u  sock0,6  0t0 63961725
 can't identify protocol

 /usr/sbin 11821 opensrf  198u  sock0,6  0t0 63961728
 can't identify protocol

 /usr/sbin 11821 opensrf  199u  sock0,6  0t0 64808966
 can't identify protocol

 /usr/sbin 11821 opensrf  200u  sock0,6  0t0 64808971
 can't identify protocol

 /usr/sbin 11821 opensrf  201u  sock0,6  0t0 64808974
 can't identify protocol

 /usr/sbin 11821 opensrf  202u  sock0,6  0t0 64808977
 can't identify protocol

 /usr/sbin 11821 opensrf  203u  sock0,6  0t0 64808980
 can't identify protocol



 I’m not sure how to track down the problem, I’ll try using strace to see
 what connections are being created, but I’m not quite sure what to look for.



 If anyone has run into this before, please let me know.

 Josh

Re: [OPEN-ILS-GENERAL] Web Client Design - Fixed Page Elements?

[Mike Rylander]

I haven't digested all the ramifications of trying to make all per-UI
navigational components static, but I fear that it will end up leading us
far from the responsive design we've managed to maintain so far in the
relevant web client UIs.

However, I think having the navbar (and only the navbar, until custom
toolbars are implemented) float at the top could be useful.  We need to be
careful, though, that we don't eat significant vertical real estate.  I
would like to see that bar shrink if it is made to float at the top of the
page regardless of scroll distance.

These are just my initial thoughts...

Thanks, Dan and Kathy!


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Fri, Jul 10, 2015 at 5:08 PM, Kathy Lussier kluss...@masslnc.org wrote:

  Hi Dan,

 In general, I would agree that the top navigation bar in the client should
 remain fixed. I can't speak to other page elements that we might also want
 to see fixed.

 I think the patron editor work raised some concerns here about the need to
 scroll back up to access the menu, but I hadn't raised it in the previous
 thread because, as you noted in your email, it really is something that
 will impact multiple areas of the client.

 In fact, I was just talking to somebody about this topic this very
 afternoon and was going to poke at the code at some time - if you don't
 beat me to it :) - to see how it might look.

 A +1 from me.

 Kathy



 On 07/10/2015 03:14 PM, Dan Wells wrote:

  Hello all,



 This came up in Kathy’s recent thread asking about the patron editor, and
 rather than hijack that thread, I’d like to broaden the conversation a
 little, because the same usability issues will affect many areas of the
 staff client.



 To cut straight to the point, I strongly believe that using fixed position
 for large portions of the staff client interface will have a major positive
 effect on usability.  This has been applied and proven in desktop
 applications for decades, and is now being rediscovered within the browser
 environment as web “pages” become applications.  There is plenty of
 evidence out there to support this stance, but here is a quick read which
 highlights the point well:
 http://www.smashingmagazine.com/2012/09/11/sticky-menus-are-quicker-to-navigate/



 If we consider the mockups from our design internship a few months back,
 in the screenshot Kathy referenced, the entire top area (and, in this case,
 the right sidebar) would ideally be fixed position.  The only scrolling
 area should be the actual form.  For any who attended my talk on design at
 the conference, this is exactly the concern of rule of thumb #3: “Scroll
 the data, not the interface”, with “data” broadly including all information
 and workspaces which are not “the program”.  (Here is Kathy’s screenshot
 link again for reference:
 http://media.tumblr.com/69beec7802a938b889bdfa80c7e0d54b/tumblr_inline_nkn0okinXl1t572gy.png
 )



 The main complaint driven at fixed screen elements is that they take up
 too much space.  They do take up space, obviously, but with the amount of
 use these elements get on a moment by moment basis, the space is well worth
 taking.  In cases where more workspace is truly of benefit, we are better
 off using fixed position with a “hide” option (auto or manual) than we
 would be with using scroll, as we can retain the clear benefits of
 persistent availability and predictability.  (Expert users might also
 choose to do without some toolbars and rely on keyboard shortcuts, but that
 sort of use will never be feasible for many staff client users and
 scenarios.)



 As the Smashing Magazine article points out, the easiest way to understand
 the situation is to simply imagine other software working with
 fully-scrolling interfaces.  In this imaginary scenario, when you are using
 a word processor, a spreadsheet application, or even a browser itself, all
 of your menus, toolbars, tabs, etc., would simply scroll off the screen as
 soon as you tried to scroll down to see additional content.  It’s likely
 that some ancient desktop software did exactly that, but if they did, they
 are now extinct, and not without good reason.



 Another valid concern sometimes raised is the effect a rich, fixed
 interface might have on a small screen appliance, like a phone.  This topic
 should be addressed, but I believe it is best kept separate from the
 problems at hand, which are already large enough.  My personal stance would
 be that a full, first-class staff client interface on a small screen device
 is not a realistic concern for a community of our size, needs, and
 capabilities.  Our bar for using the full client on phones should be “not
 impossible”, and then we can re-dedicate a portion of our energy to
 creating limited, purpose-built interfaces for functions of known value on
 small devices (e.g. inventory scanning

Re: [OPEN-ILS-GENERAL] bookbagupdate.pl

[Mike Rylander]

Jayaraj,

The error message suggests you're not including org_utils.js via a template
override, or including it too late.  Other than that, though, the evergreen
community at large won't be able to help you much, as that script is well
outside stock Evergreen, and the feature looks like it takes a good bit of
instance-specific tweaking to get working.

Sorry we can't help more...


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Sat, Jul 4, 2015 at 4:52 AM, Jayaraj JR jaya...@iisertvm.ac.in wrote:


 We have tried to implement book bag update system. We have done as per the
 instruction seen in the email discussion. We got the error message 
 Reference Error _tree_killer not found while inspecting the HTML output. I
 have checked the user book bag after running the perl script throgh
 crontab. No data (book details) is seen either in the user account book bag
 or in the OPAC home page. Kindly help to resolve the problem. The screen
 shot is attached.

 --
 Thanking You

 Jayaraj J R
 Library Information Assistant
 IISER Thiruvananthapuram
 Attachments area
 Preview attachment book_bag.jpg

 https://mail.google.com/mail/u/0/?ui=2ik=5c407d8536view=attth=14e535e0a96451edattid=0.2.3.0.1disp=saferealattid=f_ibng8sen0zw

 Included below is the log file we got after running the bookbag_update.pl
 file.

 2015-07-01 17:04:45 :   Script Starting 
 SELECT ID,(SELECT PARENT_OU FROM ACTOR.ORG_UNIT WHERE ID=(SELECT HOME_OU
 FROM ACTOR.USR WHERE ID=A.OWNER)),DESCRIPTION FROM
 CONTAINER.BIBLIO_RECORD_ENTRY_BUCKET A WHERE DESCRIPTION
 IN('newitems','recentreturned','last14daytopcirc')

 SELECT DISTINCT REC FROM
 (
 SELECT (SELECT RECORD FROM ASSET.CALL_NUMBER WHERE RECORD0 AND RECORD IS
 NOT NULL AND
 ID=(SELECT CALL_NUMBER FROM ASSET.COPY WHERE ID=A.TARGET_COPY
 AND LOCATION IN(SELECT ID FROM ASSET.COPY_LOCATION WHERE OWNING_LIB
 IN(2,4) AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE) AND OPAC_VISIBLE AND
 HOLDABLE AND CIRCULATE AND ID != -1::BIGINT
 )) REC,
 CHECKIN_SCAN_TIME::DATE FROM ACTION.CIRCULATION  A
 WHERE CIRC_LIB IN(2,4) AND
 CHECKIN_SCAN_TIME IS NOT NULL AND
 TARGET_COPY IN(SELECT ID FROM ASSET.COPY WHERE CALL_NUMBER IN(SELECT ID
 FROM ASSET.CALL_NUMBER WHERE RECORD0 AND RECORD IS NOT NULL))
 ORDER BY
 CHECKIN_SCAN_TIME::DATE DESC LIMIT 200
 ) AS B
 ORDER BY REC DESC
 LIMIT 100

  SELECT DISTINCT REC,COUNT(*) FROM
  (
 SELECT (SELECT RECORD FROM ASSET.CALL_NUMBER WHERE ID=(SELECT CALL_NUMBER
 FROM ASSET.COPY WHERE ID=A.TARGET_COPY) AND RECORD0 AND RECORD IS NOT
 NULL) REC
 ,XACT_START::DATE
 FROM ACTION.CIRCULATION  A
 WHERE CIRC_LIB IN(2,4) AND
 (TARGET_COPY IN(SELECT ID FROM ASSET.COPY WHERE LOCATION IN(SELECT ID FROM
 ASSET.COPY_LOCATION WHERE OWNING_LIB IN(2,4) AND OPAC_VISIBLE AND HOLDABLE
 AND CIRCULATE) AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE AND ID !=
 -1::BIGINT)) AND
 XACT_START  NOW() - $$14 DAYS$$::INTERVAL
 ) AS B
 GROUP BY REC
 ORDER BY COUNT(*) DESC
 LIMIT 100


 SELECT * FROM
 (
  SELECT DISTINCT REC,
  (SELECT MAX(CREATE_DATE::DATE) FROM ASSET.COPY WHERE CALL_NUMBER =
 (SELECT MAX(ID) FROM ASSET.CALL_NUMBER WHERE RECORD=REC)
  AND CIRC_LIB IN(2,4)) THEDATE

   FROM
 (
 SELECT (SELECT RECORD FROM ASSET.CALL_NUMBER WHERE ID=A.CALL_NUMBER AND
 RECORD0 AND RECORD IS NOT NULL) REC,CREATE_DATE::DATE FROM ASSET.COPY  A
 WHERE CIRC_LIB IN(2,4)
 AND LOCATION IN(SELECT ID FROM ASSET.COPY_LOCATION WHERE OWNING_LIB
 IN(2,4) AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE) AND OPAC_VISIBLE AND
 HOLDABLE AND CIRCULATE AND ID != -1::BIGINT
 ORDER BY
 CREATE_DATE::DATE DESC LIMIT 300
 ) AS B
 ) AS C
 where C.THEDATE IS NOT NULL
 ORDER BY C.THEDATE DESC
 LIMIT 100

 2015-07-01 17:04:46 :   Script End 
 --
 धन्यवाद ,

 जयराज जे आर| Jayaraj J R
 पुस्तकालय सूचना सहायक | Library Information Assistant

Re: [OPEN-ILS-GENERAL] Best-Hold Selection Sort Order

[Mike Rylander]

Hi Johnnie,

On Wed, Jul 1, 2015 at 4:22 PM, Pippin, Johnnie johnnie.pip...@ncdcr.gov
wrote:

 Ben and all,

 Thank you for your valuable information.

 We have an issue with certain systems having holds placed but looking
 outward to fulfill the hold within the consortium instead of first
 searching the available hold within its owning system.

 Our configuration for searching placed holds should be as follows:

 Hold placed at branch
 Search branch, not available
 Search System, not available
 Search Consortium


That's the way the default hold setup works. It's very unlikely that
proximity adjustment or best-hold sort order will help you here.  However...


 It seems that this works some of the time but not always. Proximity is key
 for what we want accomplished.


... can you expand on what you mean by this?  For instance, might the times
when it is not working as you expect coincide with a hold being older than
the Holds: Soft stalling interval time period? Or, might the
now-available copies have come in to the pickup branch or system after the
hold targeter ran or the specifically-targeted foreign copy was captured?

Thanks,

--Mike

Thanks!

 -  Johnnie

 The true measure of a man is how he treats someone who can do him
 absolutely no good. - Samuel Johnson
 
 Johnnie Pippin - NC Cardinal Consultant
 State Library of North Carolina
 4640 Mail Service Center
 Raleigh, NC 27699-4640
 johnnie.pip...@ncdcr.gov
 Office: 919.807.7408 / Fax: 919.733.8748

 ---
 North Carolina Department of Cultural Resources

 Opinions expressed in this message may not represent the policy of my
 agency.  Email correspondence to and from this address may be subject to
 the North Carolina Public Records law “NCGS.Ch. 132” and may be disclosed
 to third parties by an authorized state official.




 -Original Message-
 From: Open-ils-general [mailto:
 open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
 open-ils-general-requ...@list.georgialibraries.org
 Sent: Wednesday, July 01, 2015 1:07 PM
 To: open-ils-general@list.georgialibraries.org
 Subject: Open-ils-general Digest, Vol 109, Issue 5

 Send Open-ils-general mailing list submissions to
 open-ils-general@list.georgialibraries.org

 To subscribe or unsubscribe via the World Wide Web, visit

 http://libmail.georgialibraries.org/mailman/listinfo/open-ils-general
 or, via email, send a message with subject or body 'help' to
 open-ils-general-requ...@list.georgialibraries.org

 You can reach the person managing the list at
 open-ils-general-ow...@list.georgialibraries.org

 When replying, please edit your Subject line so it is more specific than
 Re: Contents of Open-ils-general digest...


 Today's Topics:

1. Re: Best-Hold Selection Sort Order (Beth Longwell)


 --

 Message: 1
 Date: Wed, 1 Jul 2015 10:17:59 -0700
 From: Beth Longwell blong...@eou.edu
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Subject: Re: [OPEN-ILS-GENERAL] Best-Hold Selection Sort Order
 Message-ID:
 
 cacacn80maaphd3yifncvpzln3gf2gnm2whzwa2nmy3xfhpb...@mail.gmail.com
 Content-Type: text/plain; charset=utf-8

 Johnnie,

 We use it to prioritize hold fulfillment based on the way our courier is
 set up, hoping to minimize transit time for the patron.

 Beth Longwell
 Sage Library System

 On Wed, Jul 1, 2015 at 10:07 AM, Michele Morgan mmor...@noblenet.org
 wrote:

  Hi Johnnie,
 
  NOBLE implemented Traditional with Holds Always Go Home Best-Hold
  Selection Sort Order systemwide so that items will always travel home
  if there are any holds for pickup at the owning library.
 
  We actually tweaked it a bit, removing approx and aprox. Since we do
  not adjust proximity, there's no need to include them.
 
  Hope this helps.
 
  Michele
 
  --
  Michele M. Morgan, Technical Assistant North of Boston Library
  Exchange, Danvers Massachusetts mmor...@noblenet.org
 
 
  On Wed, Jul 1, 2015 at 12:30 PM, Ben Shum bs...@biblio.org wrote:
 
  Hi Johnnie,
 
  Bibliomation implemented Best-Hold Selection Sort Order changes for
  at least one member library that required a specific approach to
  holds that differed from the rest of our consortium.  I described
  that use case in more detail in this post to the dev list a few years
  ago (
  http://markmail.org/message/pdksulwazgwzlro4) and that led to the
  feature's development too.  Since implementation, we have had no
  complaints about hold prioritization for the use case, so I consider
  that a Pro of it works for us with no speakable Cons for now.
 
  Can you give us a little more information about what potential use
  case are you hoping to achieve with the feature?  Are you trying to
  raise or prioritize holds for a given subset of libraries?  Is it
  based on 

Re: [OPEN-ILS-GENERAL] GOKb

[Mike Rylander]

Tim,

GOKb might one day be interesting, particularly as a source of KB data, but
like most kuali software, it's been several years in the making and isn't
here yet.

I would encourage you (and the rest of the community) to take a look at
reSearcher* from SFU. It's complete with a link resolver, knowledge base,
and serials management component, and has been around for years.

And it's actually open source, not community source.

* http://researcher.sfu.ca

Regards,

Mike Rylander

--   Sent from my phone, please pardon my thumbs.
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com
On Jun 29, 2015 1:59 PM, Tim Spindler tjspind...@gmail.com wrote:

 I'm sitting in at ALA and listening to the session on Kuali and open
 source.  One of the related opensource systems developed is GOKb which is
 knowledge base related to electronic resources.

 I was wondering if anyone in the Evergreen Community has looked at this
 for academic libraries in particular.

 Tim Spindler
 C/W MARS

Re: [OPEN-ILS-GENERAL] Multi-Valued Fields in the wild

[Mike Rylander]

Kate,

What is the use case you have in mind?

I ask because anyone on 2.6 or greater is actually already using them.  For
instance, if you have a record for a DVD/Blu-Ray combo set that has two 007
fields, one for each video recording format, you can search by either (or
both) and find the record.

Hope that helps!


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Thu, Jun 11, 2015 at 2:49 PM, Kate Butler katebut...@rodgerslibrary.org
wrote:

  Has anyone implemented Multi-Valued Fields in their catalogs?  We are
 considering taking a look at these later this summer and I wondered how
 much people had used this feature yet.  (Any words of wisdom?)



 Thanks,



 Kate Butler

 Technology Librarian

 Rodgers Memorial Library (Hudson, NH)

 http://www.rodgerslibrary.org/

Re: [OPEN-ILS-GENERAL] Correction for Release Manager Plans/Goals for 2.9

[Mike Rylander]

Heh... I figured you just wanted to return to the old days of
RC-before-beta. ;)


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Tue, May 26, 2015 at 10:54 AM, Jason Stephenson jstephen...@mvlc.org
wrote:

 Hi, all!

 Hat tip to Dan Wells for pointing out a typo/thinko in my
 timeline for the 2.9 release.  I have the date for the release
 candidate as August 2.  That should be September 2.

 Cheers,
 Jason

 --
 Jason Stephenson
 Assistant Director for Technology Services
 Merrimack Valley Library Consortium
 1600 Osgood ST, Suite 2094
 North Andover, MA 01845
 Phone: 978-557-5891
 Email: jstephen...@mvlc.org

Re: [OPEN-ILS-GENERAL] Resetting karma in IRC

[Mike Rylander]

+1


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Sat, May 16, 2015 at 12:58 PM, Jason Etheridge ja...@esilibrary.com
wrote:

 +1

 On Sat, May 16, 2015 at 1:57 PM, Bill Erickson beric...@gmail.com wrote:
  +1
 
  On Sat, May 16, 2015 at 1:18 PM, Galen Charlton g...@esilibrary.com
 wrote:
 
  Hi,
 
  On Sat, May 16, 2015 at 8:45 AM, Kathy Lussier kluss...@masslnc.org
  wrote:
   I would like to suggest that we reset the karma points in the
 #evergreen
   channel by the end of next week (to give adequate time for any
   dissension).
   For future conferences, I would like to suggest that the karma points
   are
   reset on the Monday after the conference ends.
 
  +1. It's a good practice for #code4lib, and I think it's a good idea
  for #evergreen.
 
  Regards,
 
  Galen
  --
  Galen Charlton
  Infrastructure and Added Services Manager
  Equinox Software, Inc. / The Open Source Experts
  email:  g...@esilibrary.com
  direct: +1 770-709-5581
  cell:   +1 404-984-4366
  skype:  gmcharlt
  web:http://www.esilibrary.com/
  Supporting Koha and Evergreen: http://koha-community.org 
  http://evergreen-ils.org
 
 



 --
 Jason Etheridge
 | Community and Migration Manager
 | Equinox Software, Inc. / The Open Source Experts
 | phone: 1-877-OPEN-ILS (673-6457)
 | email: ja...@esilibrary.com
 | web: http://www.esilibrary.com

Re: [OPEN-ILS-GENERAL] Upgrade Script for 2.6.4 to 2.7

[Mike Rylander]

On Fri, Mar 13, 2015 at 4:00 PM, Ben Shum bs...@biblio.org wrote:

 Without getting into too detailed or specifics, but

 While the numbers for upgrade scripts are purely sequential in master,
 they are not complete and sequential for upgrades in release branches,
 at least once you start talking maintenance releases since we do not
 always backport every upgrade script to previous versions of
 Evergreen.

 So if an upgrade script went 0001, 0002, 0003, etc. through release
 2.7.0, then we started developing for 2.8 series and the numbers
 continued, 0004, 0005, 0006, etc. then there might be gaps where
 things did not backport cleanly.

 So if 0005 was backported, but 0004 and 0006 was not, then the upgrade
 scripts in 2.7 might look like 0001, 0002, 0003, 0005, while the chain
 would remain unbroken in 2.8/master.  If you then upgraded from 2.7 to
 2.8, how would you know which you missed or didn't already get?  What
 if 0005 applied a fix for something that was changed in 0004.  So if
 you ran 0004 and not 0005 (a second time during the upgrade), your
 system breaks with an older bad upgrade script function.


FWIW, if folks are reusing numbers for similar-but-different in back
branches (as in, same effect, different code) then they're doing it wrong.
It's happened a couple times in the past and is nothing but trouble.

The rule is: every upgrade script number should be allocated in master,
even if the script in master may be effectively empty (just a
config.upgrade_log entry), as would be the case when the change is only
needed in a back branch.

--miker

Creating a giant version-upgrade script is how things have been done
 to this point, but moving between major versions can still be fraught
 with strangeness in the upgrade scripts even if you face each one on
 its own.

 That said, we're getting better about making good upgrade scripts that
 don't stack against each other or cause disruptions.

 I would say that this is the main reason our library system has stuck
 to master so that we have an unbroken chain of upgrade script by the
 numbers without any confusion of when to apply X or Y, etc.

 Perhaps not helpful, but some background thoughts to the mix.

 -- Ben

 On Fri, Mar 13, 2015 at 3:47 PM, Chris Sharp
 csh...@georgialibraries.org wrote:
  Since that's true...
 
  Couldn't we develop some sort of upgrade mechanism that just aggregates
 and runs each of the constituent scripts?  What is the reasoning behind
 stringing them into the longer monolithic scripts since running through the
 numbered scripts provides the same outcome?
 
  (Asking the full list, not Galen specifically).
 
  - Original Message -
  From: Galen Charlton g...@esilibrary.com
  To: Evergreen Discussion Group 
 open-ils-general@list.georgialibraries.org
  Sent: Friday, March 13, 2015 3:31:33 PM
  Subject: Re: [OPEN-ILS-GENERAL] Upgrade Script for 2.6.4 to 2.7
 
  Hi,
 
  On Fri, Mar 13, 2015 at 1:51 PM, Lazar, Alexey Vladimirovich 
  alexey.la...@mnsu.edu wrote:
  
   Since an Open-ILS/src/sql/Pg/version-upgrade script is a subset of
 several
   specific Open-ILS/src/sql/Pg/upgrade/ scripts, is there any harm
 in
   just applying the  scripts separately, in the order they appear,
 to get
   the database up to a certain “version number?
  
 
  That approach will work just fine, though checking through all of the
 point
  schema upgrades you plan to apply and seeing if there are any redundant
 bib
  reingests that you can skip can save you some time.
 
  Regards,
 
  Galen
  --
  Galen Charlton
  Infrastructure and Added Services Manager
  Equinox Software, Inc. / The Open Source Experts
  email:  g...@esilibrary.com
  direct: +1 770-709-5581
  cell:   +1 404-984-4366
  skype:  gmcharlt
  web:http://www.esilibrary.com/
  Supporting Koha and Evergreen: http://koha-community.org 
  http://evergreen-ils.org
 
 
  --
  Chris Sharp
  PINES System Administrator
  Georgia Public Library Service
  1800 Century Place, Suite 150
  Atlanta, Georgia 30345
  (404) 235-7147
  csh...@georgialibraries.org
  http://pines.georgialibraries.org/



 --
 Benjamin Shum
 Evergreen Systems Manager
 Bibliomation, Inc.
 24 Wooster Ave.
 Waterbury, CT 06708
 203-577-4070, ext. 113

Re: [OPEN-ILS-GENERAL] Upgrade Script for 2.6.4 to 2.7

[Mike Rylander]

Chris,

That's what I've advocated for in the past (see upgrade scripts 0526 and
0537), via a helper script that 1) only applies what's needed (based on
config.upgrade_log) and 2) knows how to look up supersedes/deprecated-by
info from within the scripts.  Writing down a detailed plan keeps getting
back-burnered, but there are at least four different scripts floating
around that attempt to do various versions of that.

tl;dr of such a thing: all that's really needed to make that work is
 1) a concerted effort by devs to do things like supplying fine-grained db
scripts, particularly reingest-only scripts when a reingest is needed
 2) RM involvement in the creation of per-release scripts that do just
what's needed for the upgrade proper (like, do one and only one reingest)
 3) inclusion of supersedes/deprecated-by info in upgrade scripts that do,
in fact, supersede (or are deprecated by) early scripts
 4) a (say) perl script to read all the upgrade scripts and apply them in
order, as needed, based on config.upgrade_log



--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Fri, Mar 13, 2015 at 3:47 PM, Chris Sharp csh...@georgialibraries.org
wrote:

 Since that's true...

 Couldn't we develop some sort of upgrade mechanism that just aggregates
 and runs each of the constituent scripts?  What is the reasoning behind
 stringing them into the longer monolithic scripts since running through the
 numbered scripts provides the same outcome?

 (Asking the full list, not Galen specifically).

 - Original Message -
  From: Galen Charlton g...@esilibrary.com
  To: Evergreen Discussion Group 
 open-ils-general@list.georgialibraries.org
  Sent: Friday, March 13, 2015 3:31:33 PM
  Subject: Re: [OPEN-ILS-GENERAL] Upgrade Script for 2.6.4 to 2.7
 
  Hi,
 
  On Fri, Mar 13, 2015 at 1:51 PM, Lazar, Alexey Vladimirovich 
  alexey.la...@mnsu.edu wrote:
  
   Since an Open-ILS/src/sql/Pg/version-upgrade script is a subset of
 several
   specific Open-ILS/src/sql/Pg/upgrade/ scripts, is there any harm in
   just applying the  scripts separately, in the order they appear,
 to get
   the database up to a certain “version number?
  
 
  That approach will work just fine, though checking through all of the
 point
  schema upgrades you plan to apply and seeing if there are any redundant
 bib
  reingests that you can skip can save you some time.
 
  Regards,
 
  Galen
  --
  Galen Charlton
  Infrastructure and Added Services Manager
  Equinox Software, Inc. / The Open Source Experts
  email:  g...@esilibrary.com
  direct: +1 770-709-5581
  cell:   +1 404-984-4366
  skype:  gmcharlt
  web:http://www.esilibrary.com/
  Supporting Koha and Evergreen: http://koha-community.org 
  http://evergreen-ils.org
 

 --
 Chris Sharp
 PINES System Administrator
 Georgia Public Library Service
 1800 Century Place, Suite 150
 Atlanta, Georgia 30345
 (404) 235-7147
 csh...@georgialibraries.org
 http://pines.georgialibraries.org/

Re: [OPEN-ILS-GENERAL] Due date conundrum - time due is weird

[Mike Rylander]

Jennifer,

Evergreen pushes the due time to 11:59pm on transactions that have
day-granular circ durations.  So, it sounds like you've got a timezone
mismatch somewhere.  Likely, your database server (or the database
iteself), or the app server if separate, thinks it lives in UTC instead
your correct timezone.

HTH,


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Thu, Feb 26, 2015 at 4:05 PM, Walz, Jennifer jlw...@asbury.edu wrote:

  All –



   I have a conundrum with our due date / times.   When we currently check
 out an item to a student, it give them the normal three week due DATE, but
 adds a time which is 7:59pm.Where is it getting the time from??   We
 are open until 11:59 each day of the week (m-f) and a due TIME of 7:59 is
 really odd.  I have checked our Org hours and they are set correctly for
 our branch.   Our due dates are set for the circ rules for 21 days.   WHERE
 is it getting the TIME from??



   If someone can enlighten me about some setting that I have missed, I
 would be very grateful.  Currently when students turn in an item on the day
 it was due but AFTER the time it was due, they are charged a fine.   We
 would like to fix that!



 Thanks!

  Jennifer



 --
 Jennifer Walz, MLS – ILS befuddled
 Kinlaw Library
 Asbury University
 1 Macklem Drive, Wilmore, KY 40390
 859-858-3511 ext. 2269
 jlw...@asbury.edu

Re: [OPEN-ILS-GENERAL] Show available copies link in the catalog

[Mike Rylander]

I would vote for #2 (make X total copies a link), and extend that
linkiness to the X copies available at... area, except when X == 0.


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, Feb 18, 2015 at 11:08 AM, Benjamin Kalish bkal...@forbeslibrary.org
 wrote:

 I vote for #1. What better place to put a link to all the copies than by
 the number of total copies?

 Benjamin Kalish
 Forbes Library / 413-587-1012 / bkal...@forbeslibrary.org

 Currently reading:* North and South* by Mrs. Gaskell
 Just Finished: *The Riddle of the Sands* by Erskine Childers

 On Tue, Feb 17, 2015 at 12:29 PM, Kathy Lussier kluss...@masslnc.org
 wrote:

 Hi all,

 I've periodically heard from our libraries that they would like the show
 copies link that displays in the available copies area of the public
 catalog record to display even if there are no copies available.

 To demonstrate what I'm talking about, if you look at the
 record-with-available-copies screenshot, there is a link to show all of the
 available copies, which, when clicked, displays copies owned by all
 libraries in the consortium. However, if you look at the
 record-with-no-available-copies screenshot, that link does not display.
 I believe this is because the intent of this particular section of the
 screen is to display available copy information, in which case, the Show
 link wouldn't make sense if there are zero available copies.

 However, there are many cases when a user may start a search scoped to
 their own library, but then may want to see all of the copies in the
 consortium. For example, if there are zero copies available, but only a
 handful of holds, they may want to see the status of the existing copies to
 get an idea of whether they are due soon. Or we may have a situation
 described by one of our libraries where they already have a hold on the
 title, click to the title from their holds list (carrying along the search
 scope in the process), and then want to see the status of the copies owned
 by other libraries in the consortium.

 I think it's a good idea to add a link to display all copies, but the
 question is where would be a good place to put. I've thought of a couple of
 options:

 1 - Display a Show link adjacent to the x current holds with x total
 copies statement. The problem here is that the Show link is a bit
 redundant if the other Show link is always displaying.
 2 - Make the x total copies text in the holds area clickable to show
 all copies owned by the consortium. The problem with this approach is it is
 inconsistent with what's happening in the available copies area.
 3 - Make the existing Show link display regardless of the current
 availability status of copies on the record, even if it is a bit
 incongruous with what that area is supposed to represent.

 Of course, we could always leave that area as it is if other libraries
 are happy with the display.

 What are your thoughts?

 Thanks!
 Kathy

 --
 Kathy Lussier
 Project Coordinator
 Massachusetts Library Network Cooperative
 (508) 343-0128
 kluss...@masslnc.org
 Twitter: http://www.twitter.com/kmlussier

Re: [OPEN-ILS-GENERAL] Reminder for Conference proposals

[Mike Rylander]

Lise,

Angela Kilsdonk and I would be happy to reprise our talk from last year if
there's interest.  We can update it a bit, and talk about future directions
for which there are some plans already and next steps needed to head toward
that future.

What I'd love to do is a new features panel with other developers to
introduce some of the features the folks may not even know exist but might
make life easier for staff and patrons.

Thanks,


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Thu, Feb 12, 2015 at 7:50 AM, Elisabeth Keppler keppl...@forsyth.cc
wrote:

 I realize the developers are busy writing code, but might a few be enticed
 to present?

- Many library systems are back-leveled and a session about the key
features of the newer major releases would be welcome.  Perhaps 2.6, 2.7,
and 2.8?
- What are the key projects in development right now?
- I had to miss Mike Rylander's session on authority control last
year.  Might he be willing to offer it again?


 Thanks to all who are willing to present!

 Lise

 On Wed, Feb 11, 2015 at 9:18 PM, Geoff Sams gs...@roanoketexas.com
 wrote:

  I’m not sure that I’d be speaking for a majority, but I’d like to see
 some of the more difficult requests for information that you may have
 gotten.  Okay, maybe moderately difficult for you, I’m not asking for the
 magnum opus “weeding query” (I think that was what you said it was anyway,
 it’s been almost a year now) that you showed a snippet of last year.  But
 sometimes I get requests that don’t seem feasibly possible in reports that
 if I were a bit more comfortable I’d be happy to tackle in SQL.  I feel bad
 because I don’t have an example coming to mind today, but if I think of
 something I’d be happy to forward it along.



 Other than that, perhaps a mashup between SQL and reports would be
 helpful to some?  Showing how certain choices translate between reports and
 SQL?  I’m not sure if that would be helpful or not really, but it seemed
 like an idea.



 Thanks,

 Geoff Sams

 Library Manager

 Roanoke Public Library



 *From:* Open-ils-general [mailto:
 open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Rogan
 Hamby
 *Sent:* Wednesday, February 11, 2015 7:53 PM

 *To:* Evergreen Discussion Group
 *Subject:* Re: [OPEN-ILS-GENERAL] Reminder for Conference proposals



 If I do a hands on workshop (I threw a rough proposal up) what kinds of
 sql tasks would folks like to step through as learning examples?



 On Wed, Feb 11, 2015 at 5:24 PM, Holly Brennan haderh...@ci.homer.ak.us
 wrote:

  +1



 *From:* Open-ils-general [mailto:
 open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Rogan
 Hamby
 *Sent:* Wednesday, February 11, 2015 1:21 PM


 *To:* Evergreen Discussion Group
 *Subject:* Re: [OPEN-ILS-GENERAL] Reminder for Conference proposals



 I had been hoping to do a half day session this year but I was under the
 impression that format wasn't an option this year.  I may have
 misunderstood though.  Heck, I'll put one on the proposal listing and we'll
 see what works out in the wash.

 On Wednesday, February 11, 2015, Holly Brennan haderh...@ci.homer.ak.us
 wrote:





 *From:* Open-ils-general [
 mailto:open-ils-general-boun...@list.georgialibraries.org
 open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Rogan
 Hamby
 *Sent:* Wednesday, February 11, 2015 12:46 PM
 *To:* Evergreen Discussion Group
 *Subject:* Re: [OPEN-ILS-GENERAL] Reminder for Conference proposals



 I'm game for that.  Heck I'll take requests if someone finds me space in
 the schedule.  I'm willing to do anything useful to others.  I learn from
 others continually in the community so I'm glad to do what I can.



 What would you like?  Something like a workshop?



 Something like the half day tutorial would be terrific! Having your
 session last year on Saturday (and only 1 hour) made it difficult to
 digest, and I left the conference wanting more. Heck, you could just
 re-present your session from 2014! I will still attend it every year. J



 -Holly



 On Wednesday, February 11, 2015, Holly Brennan haderh...@ci.homer.ak.us
 wrote:

 I’m really hoping that Rogan (or someone) will be doing a longer SQL
 session this year! J



 *From:* Open-ils-general [
 mailto:open-ils-general-boun...@list.georgialibraries.org
 open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Beth
 Longwell
 *Sent:* Wednesday, February 11, 2015 10:54 AM
 *To:* Evergreen Discussion Group
 *Subject:* [OPEN-ILS-GENERAL] Reminder for Conference proposals



 Hi everyone,

 Just a gentle reminder to submit your program proposals for the upcoming
 Evergreen conference. Below is the original message. Thanks to those who
 have already submitted.

 Beth

 ---

 Dear Evergreen Community,



 The 2015 Evergreen International

Re: [OPEN-ILS-GENERAL] Displaying patron information for checked out books

[Mike Rylander]

I, too, am hesitant to move on this for all the reasons Rogan suggests.
However, to play devil's advocate, with the protection of separate view and
update permissions on the org unit setting, and the non-existence of those
permissions in stock, it should be safe from all but the admin superuser.
Sites wanting to use the feature would need to first add both permissions
and then give those permissions to appropriate staff accounts.  That sets
the bar pretty high.  One could even imagine an internal flag (which
requires database access to set) that would preclude the use of the setting
even if present and configured.

--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, Feb 4, 2015 at 10:14 AM, Rogan Hamby rogan.ha...@yclibrary.net
wrote:

 I hadn't considered special libraries, I was thinking of academic and
 public.  Still, I would want some pretty tight safeguards.  Some
 consortiums allow some local admins to have access to org unit settings to
 customize behavior for their systems (in our case county).  The training
 and preparation of those local admin often varies with the county's
 resources.  Most mistakes can be recovered from without too much fuss but
 the bad impression this would leave ... well, it could be downright toxic.
 I admit, we in SC may be overly sensitive to privacy in some ways since our
 Dept of Revenue got hacked and folks in Eastern Europe got so much of our
 information but yeah, if this went into Evergreen as a patron viewable
 option it would have to be very controllable on a server level in a top
 down way or we would have to seriously re-evaluate a lot and it could end
 up with removing a lot of options from local systems.




 On Wed, Feb 4, 2015 at 10:06 AM, Galen Charlton g...@esilibrary.com
 wrote:

 Hi,

 On Wed, Feb 4, 2015 at 9:55 AM, Rogan Hamby rogan.ha...@yclibrary.net
 wrote:
  I want to make sure I'm understanding you.  Do you mean to display it in
  TPAC for patrons to be able to see what other patrons have a book
 checked
  out?  If so, at least for us in the United States* that would be a huge
  violation of patron privacy.  To be honest, it would be such a big
 violation
  that I wouldn't even feel comfortable with that as an option in TPAC.
 It
  would be like having a bomb waiting to blow up in case someone turned
 it on
  by accident.

 I agree with Rogan that such an option is not one to be added to
 Evergreen lightly, nor would I personally feel comfortable if an
 academic or public library were to turn it on. However, as a data
 point, such an option does exist in Koha (the OPACShowCheckoutName
 system preference), and it is specifically for use by corporate
 libraries.

 Regards,

 Galen
 --
 Galen Charlton
 Manager of Implementation
 Equinox Software, Inc. / The Open Source Experts
 email:  g...@esilibrary.com
 direct: +1 770-709-5581
 cell:   +1 404-984-4366
 skype:  gmcharlt
 web:http://www.esilibrary.com/
 Supporting Koha and Evergreen: http://koha-community.org 
 http://evergreen-ils.org




 --

 Rogan Hamby, MLS, CCNP, MIA
 Managers Headquarters Library and Reference Services,
 York County Library System

 “You can never get a cup of tea large enough or a book long enough to suit
 me.”
 ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis

Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving Location

[Mike Rylander]

Holly,

You can use the id of the shelving location with a locations() filter,
like this:

http://catalog.ci.homer.ak.us/eg/opac/results?query=locations(187)qtype=keywordlocg=4

That can be a comma-separated list, to include multiple locations

HTH,


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Wed, Jan 21, 2015 at 9:16 PM, Holly Brennan haderh...@ci.homer.ak.us
wrote:

  I want to provide a link to all graphic novels for kids, so patrons can
 click the link on our website and go directly to a “pre-searched” page of
 catalog results.



 In the past I have created this type of link with keyword searches and
 Copy Location Groups, but because the individual Shelving Locations aren’t
 listed in Advanced Search I’m a bit stumped.



 Our collection has these books cataloged with the Shelving Location of
 ‘Children’s Library – Graphic Novel’, so I don’t need to mine the MARC data
 or keywords for this search. I just need to figure out the formula for
 grabbing from a particular Shelving Location.



 I’m thinking there must be a clue in this link below, which is a search
 for everything in the Copy/Shelving Location *GROUP* containing all
 Children’s Shelving Locations (* in the Keyword box, ‘All Children’s’ group
 selected, everything else blank)…. This link below shows that “All
 Children’s” copy location group is coded as locg=4….. so what is the code
 for individual shelving locations? And how do I figure out what number this
 group has been assigned? In the staff client Copy Location Groups ‘All
 Children’s’ is listed as #2, so it’s not listed as #4 there….




 http://catalog.ci.homer.ak.us/eg/opac/results?bool=andqtype=keywordcontains=containsquery=*bool=andqtype=titlecontains=containsquery=bool=andqtype=authorcontains=containsquery=_adv=1locg=4%3A2pubdate=isdate1=date2=sort
 =



 Thank you!!





 Holly Brennan

 Library Technology Specialist

 Homer Public Library, Alaska



 hbren...@cityofhomer-ak.gov

 907-235-3180 (main)

 907-435-3154 (direct)

Re: [OPEN-ILS-GENERAL] [Evergreen-catalogers] Audience filter excluding blank again

[Mike Rylander]

Elaine,

A new bug would be better in this case, as the underlying code that handles
audience changed with the 2.6-era record attribute functionality.

Thanks!


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Thu, Jan 22, 2015 at 8:38 AM, Hardy, Elaine eha...@georgialibraries.org
wrote:

 The audience filter for adult is excluding blank again. There is an
 existing bug https://bugs.launchpad.net/evergreen/+bug/760890  from 2011
 that is marked incomplete; however it was fixed in earlier versions. We are
 unsure whether the best course would be to add to the existing bug or open
 a new one. Since this is a pretty serious search issue, we don’t want it to
 get lost either way.



 To illustrate: our test server is still on 2.5 and an author search for
 weber, david filtered by adult is successful. See
 http://test.gapines.org/eg/opac/results?bool=andqtype=keywordcontains=containsquery=bool=andqtype=titlecontains=containsquery=bool=andqtype=authorcontains=containsquery=weber%2C+david_adv=1fi%3Aaudience=+%2Ce%2Cf%2Cglocg=1pubdate=isdate1=date2=sort=






 The same search on our live server (running 2.7.2) retrieves only 7
 titles, all Audn code g:




 http://gapines.org/eg/opac/results?bool=andqtype=keywordcontains=containsquery=bool=andqtype=titlecontains=containsquery=bool=andqtype=authorcontains=containsquery=weber%2C+davidfi%3Aaudience=+%2Ce%2Cf%2Cglocg=1pubdate=isdate1=date2=sort=_adv=1



 We have altered the adult filter to include blank, e,f,g. Testing on
 another test server running 2.7.2 using a filter with just blank has the
 same results as live.



 I also checked NC Cardinal’s catalog which is running 2.6, I believe. An
 unfiltered author search for weber, David retrieved 211 titles. A filtered
 search (linked below) retrieved 10, so the problem came back in 2.6:




 https://mauney.nccardinal.org/eg/opac/results?bool=andqtype=keywordcontains=containsquery=bool=andqtype=titlecontains=containsquery=bool=andqtype=authorcontains=containsquery=weber%2C+david_adv=1fi%3Aaudience=elocg=1pubdate=isdate1=date2=sort=




 Would bug wranglers rather us open a new ticket or add to the existing one?





 *Elaine*



 J. Elaine Hardy
 PINES  Collaborative Projects Manager
 Georgia Public Library Service
 1800 Century Place, Ste 150
 Atlanta, Ga. 30345-4304



 404.235.7128
 404.235.7201, fax
 eha...@georgialibraries.org
 www.georgialibraries.org
 www.georgialibraries.org/pines



 ___
 Evergreen-catalogers mailing list
 evergreen-catalog...@list.evergreen-ils.org
 http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-catalogers

Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving Location

[Mike Rylander]

Sure thing.  They're in the table asset.copy_location.  I don't recall if
the id is visible in the copy location editor or not...


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Thu, Jan 22, 2015 at 1:14 PM, Holly Brennan haderh...@ci.homer.ak.us
wrote:

  That’s awesome, Mike! Thanks!



 How do I find the number codes? Can you give me the database path?



 -Holly



 *From:* open-ils-general-boun...@list.georgialibraries.org [mailto:
 open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Mike
 Rylander
 *Sent:* Thursday, January 22, 2015 8:06 AM
 *To:* Evergreen Discussion Group
 *Subject:* Re: [OPEN-ILS-GENERAL] catalog link for particular Shelving
 Location



 Holly,



 You can use the id of the shelving location with a locations() filter,
 like this:




 http://catalog.ci.homer.ak.us/eg/opac/results?query=locations(187)qtype=keywordlocg=4



 That can be a comma-separated list, to include multiple locations



 HTH,




--

 Mike Rylander

  | President

  | Equinox Software, Inc. / The Open Source Experts

  | phone:  1-877-OPEN-ILS (673-6457)

  | email:  mi...@esilibrary.com

  | web:  http://www.esilibrary.com





 On Wed, Jan 21, 2015 at 9:16 PM, Holly Brennan haderh...@ci.homer.ak.us
 wrote:

 I want to provide a link to all graphic novels for kids, so patrons can
 click the link on our website and go directly to a “pre-searched” page of
 catalog results.



 In the past I have created this type of link with keyword searches and
 Copy Location Groups, but because the individual Shelving Locations aren’t
 listed in Advanced Search I’m a bit stumped.



 Our collection has these books cataloged with the Shelving Location of
 ‘Children’s Library – Graphic Novel’, so I don’t need to mine the MARC data
 or keywords for this search. I just need to figure out the formula for
 grabbing from a particular Shelving Location.



 I’m thinking there must be a clue in this link below, which is a search
 for everything in the Copy/Shelving Location *GROUP* containing all
 Children’s Shelving Locations (* in the Keyword box, ‘All Children’s’ group
 selected, everything else blank)…. This link below shows that “All
 Children’s” copy location group is coded as locg=4….. so what is the code
 for individual shelving locations? And how do I figure out what number this
 group has been assigned? In the staff client Copy Location Groups ‘All
 Children’s’ is listed as #2, so it’s not listed as #4 there….




 http://catalog.ci.homer.ak.us/eg/opac/results?bool=andqtype=keywordcontains=containsquery=*bool=andqtype=titlecontains=containsquery=bool=andqtype=authorcontains=containsquery=_adv=1locg=4%3A2pubdate=isdate1=date2=sort
 =



 Thank you!!





 Holly Brennan

 Library Technology Specialist

 Homer Public Library, Alaska



 hbren...@cityofhomer-ak.gov

 907-235-3180 (main)

 907-435-3154 (direct)

Re: [OPEN-ILS-GENERAL] Results list of the Call Number (Shelf Browse) list

[Mike Rylander]

Thanks, Elaine.

Based on that, it seems that (with appropriate styling and integration) the
backend behind the old slimpac call number browse does, indeed, fill the
need and pretty well matches your definition of a shelf list.  Here are a
couple example URLs:

non-repeating area of call numbers
http://webby.evergreencatalog.com/opac/extras/browse/html/call_number/-/PZ6

area with repeating values
http://webby.evergreencatalog.com/opac/extras/browse/html/call_number/-/FIC

Of course, as a simple demo site, the cataloging and normalization of call
numbers is not what a cataloger would provide.  Note: the Display Fields
work that is pending inclusion would allow improved sorting of repeated
call number rows.


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Tue, Jan 20, 2015 at 2:30 PM, Hardy, Elaine eha...@georgialibraries.org
wrote:

 Found a few images of the different ILS’s shelflisting functionality ---




 http://www.lsuc.on.ca/For-Lawyers/Manage-Your-Practice/Research/Cataloguing-Request-Manual-for-County---District-Law-Libraries/#shelflists



 http://tualatints.pbworks.com/w/page/9224546/Assigning%20Dewey (scroll
 down to image from Polaris)



 http://www.tulane.edu/~techserv/shelflist.html (again, scroll down for
 images. This is Tulane’s instructions for shelflisting, if you want an idea
 of what many academic catalogers have to do to assign a call number)




 https://staff.lib.ncsu.edu/confluence/display/MNC/Institute+of+Textile+Technology+%28ITT%29+Thesis
 (scroll down to section Shelflisting the Cataloging Calculator Author
 Cutter and click on images)



 A real shelflist would display call number, title, author, publisher,
 edition, and pub date in a format that indicates where the call number you
 wish to assign  falls within the list of titles on the shelf (shelflisting
 from a cataloging perspective). The cataloger can then easily scan the
 surrounding titles to make sure the call number is correct, isn’t
 duplicated, and follows shelflisting local practice. From this standpoint,
 the shelf list in Evergreen isn’t real – it doesn’t provide a cataloger
 with enough information to properly assign a call number. Since many public
 libraries don’t have the complex shelflisting rules that academics have,
 and we don’t care if we use the same call number over and over and over
 again, the lack of real shelflisting functionality in Evergreen wasn’t an
 issue until more academic libraries came on board. Having good shelflisting
 capability will allow Evergreen to continue to appeal to a broad spectrum
 of libraries.



 *Elaine*



 J. Elaine Hardy
 PINES  Collaborative Projects Manager
 Georgia Public Library Service
 1800 Century Place, Ste 150
 Atlanta, Ga. 30345-4304



 404.235.7128
 404.235.7201, fax
 eha...@georgialibraries.org
 www.georgialibraries.org
 www.georgialibraries.org/pines



 *From:* open-ils-general-boun...@list.georgialibraries.org [mailto:
 open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Rogan
 Hamby
 *Sent:* Tuesday, January 20, 2015 1:28 PM
 *To:* Evergreen Discussion Group
 *Subject:* Re: [OPEN-ILS-GENERAL] Results list of the Call Number (Shelf
 Browse) list



 Can you define what constitutes real in this feature set?



 On Tue, Jan 20, 2015 at 12:10 PM, gislaine.hame...@statcan.gc.ca wrote:

 I too would like to see a real shelf list in Evergreen.


 Gislaine Hamelin
 Intergrated Library Systems Coordinator | Coordonnatrice du système
 integrée de la bibliotheque
 Library Services | Services bibliothèque
 R.H. Coats Building | Immeuble R.-H.-Coats / Floor | Étage 2 Q
 Statistics Canada | 100 Tunney's Pasture Driveway, Ottawa ON K1A 0T6
 Statistique Canada | 100, promenade Tunney's Pasture, Ottawa ON K1A 0T6
 gislaine.hame...@statcan.gc.ca
 Telephone | Téléphone 613-762-5443
 Facsimile | Télécopieur 613-951-0939
 Government of Canada | Gouvernement du Canada



 -Message d'origine-
 De : open-ils-general-boun...@list.georgialibraries.org [mailto:
 open-ils-general-boun...@list.georgialibraries.org] De la part de
 McCanna, Terran
 Envoyé : January-15-15 10:46 AM
 À : Evergreen Discussion Group
 Objet : Re: [OPEN-ILS-GENERAL] Results list of the Call Number (Shelf
 Browse) list


 I like having multiple ways to look at the same info, so a list view would
 be a great addition.

 What I'd REALLY like is a single-row horizontal widget that you can scroll
 back and forth so it shows the books in question as if they were lined up
 on an actual shelf.




 Terran McCanna
 PINES Program Manager
 Georgia Public Library Service
 1800 Century Place, Suite 150
 Atlanta, GA 30345
 404-235-7138
 tmcca...@georgialibraries.org





 --



 Rogan Hamby, MLS, CCNP, MIA

 Managers Headquarters Library and Reference Services,

 York County Library System



 “You can never get a cup of tea large enough or a book long

Re: [OPEN-ILS-GENERAL] Results list of the Call Number (Shelf Browse) list

[Mike Rylander]

Janet,

That's a good (and important) point to bring up.  The question is this: are
we talking about a virtual shelf or a call number listing?  If the former,
they'd be duplicated (one version of the callnumber per bib with items at
or below the search location), and if the latter, they could be collapsed
(count of bibs with items at or below the search location using that string
as the callnumber label).  The former supports book jackets and shelf
listing (approximately), the latter is just an index of labels.

There's room for both, IMO.

Thoughts?


--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Thu, Jan 15, 2015 at 12:56 PM, Janet Schrader jschra...@cwmars.org
wrote:

  For “Call number (shelf browse)”  I definitely prefer a list view and I
 know several libraries in our consortium that have been advocating for this
 development in order to do this shelf browse for their collections. I’m
 curious as to how it would work. Would duplicate call numbers by collapsed
 into one entry as even individual libraries may have several books on the
 same topic by the same author?



 973.2 Tam  (1)

 973.2 TAY  (21)

 973.2 Taylor  (5)

 973.2 Ter  (1)

 973.2 Terkel  (2)

 973.2 Thane  (1)









 Janet



 Janet Schrader

 Bibliographic Services Supervisor

 C/W MARS, Inc.

 67 Millbrook Street, Suite 201

 Worcester, MA 01606

 Tel: 508-755-3323 ext. 25

 FaX: 508-757-7801

 jschra...@cwmars.org





 *From:* open-ils-general-boun...@list.georgialibraries.org [mailto:
 open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Hardy,
 Elaine
 *Sent:* Thursday, January 15, 2015 10:28 AM

 *To:* Evergreen Discussion Group
 *Subject:* Re: [OPEN-ILS-GENERAL] Results list of the Call Number (Shelf
 Browse) list



 I also would prefer a list view.



 *Elaine*



 J. Elaine Hardy
 PINES  Collaborative Projects Manager
 Georgia Public Library Service
 1800 Century Place, Ste 150
 Atlanta, Ga. 30345-4304



 404.235.7128
 404.235.7201, fax
 eha...@georgialibraries.org
 www.georgialibraries.org
 www.georgialibraries.org/pines



 *From:* open-ils-general-boun...@list.georgialibraries.org [
 mailto:open-ils-general-boun...@list.georgialibraries.org
 open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Joan
 Kranich
 *Sent:* Thursday, January 15, 2015 9:54 AM
 *To:* 'Evergreen Discussion Group'
 *Subject:* Re: [OPEN-ILS-GENERAL] Results list of the Call Number (Shelf
 Browse) list



 Hi,



 I would prefer a list view for call number search results.  I think it is
 easier to understand for patrons and is consistent with other results
 screen displays.



 Joan



 Joan Kranich

 C/W MARS Member Services

 jkran...@cwmars.org

 508-755-3323 ext. 21



 *From:* open-ils-general-boun...@list.georgialibraries.org [
 mailto:open-ils-general-boun...@list.georgialibraries.org
 open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Donald
 Butterworth
 *Sent:* Thursday, January 15, 2015 8:01 AM
 *To:* Evergreen Discussion Group
 *Subject:* [OPEN-ILS-GENERAL] Results list of the Call Number (Shelf
 Browse) list



 In the Ditch the Bib Call Number search? thread, Jennifer indicated
 that she would prefer a list view display as compared to the current
 shelf view display that returns with a Call Number (Shelf Browse) search.
 I too, would prefer a list view. Would anybody else prefer a list view
 search result? Would this change be a huge project, given Yamil's comment
 that this index is very different than for others indexes?



 Don

 --

 Don Butterworth
 Faculty Associate / Librarian III
 B.L. Fisher Library
 Asbury Theological Seminary
 don.butterwo...@asburyseminary.edu
 (859) 858-2227

Re: [OPEN-ILS-GENERAL] Results list of the Call Number (Shelf Browse) list

[Mike Rylander]

It shouldn't bet terribly hard, since it's been done before in the old
SlimPAC and the underlying code we need already exists:

http://webby.evergreencatalog.com/opac/extras/browse/html/call_number/-/FIC

It would need TPAC treatment, obviously.

--
Mike Rylander
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  mi...@esilibrary.com
 | web:  http://www.esilibrary.com


On Thu, Jan 15, 2015 at 8:00 AM, Donald Butterworth 
don.butterwo...@asburyseminary.edu wrote:

 In the Ditch the Bib Call Number search? thread, Jennifer indicated
 that she would prefer a list view display as compared to the current
 shelf view display that returns with a Call Number (Shelf Browse) search.
 I too, would prefer a list view. Would anybody else prefer a list view
 search result? Would this change be a huge project, given Yamil's comment
 that this index is very different than for others indexes?

 Don

 --
 Don Butterworth
 Faculty Associate / Librarian III
 B.L. Fisher Library
 Asbury Theological Seminary
 don.butterwo...@asburyseminary.edu
 (859) 858-2227

Re: [OPEN-ILS-GENERAL] [OPEN-ILS-DEV] 2.8 release scheduling

[Mike Rylander]

On Thu, Dec 18, 2014 at 4:42 PM, Bill Erickson beric...@gmail.com wrote:


 On Thu, Dec 18, 2014 at 2:20 PM, Mike Rylander mrylan...@gmail.com
 wrote:

 On Thu, Dec 18, 2014 at 12:11 PM, Bill Erickson beric...@gmail.com
 wrote:


 On Thu, Dec 18, 2014 at 8:29 AM, Mike Rylander mrylan...@gmail.com
 wrote:

 Bill,

 First, thanks for putting out a timeline.

 I am a little concerned about the pre-beta feature freeze.  In the
 past, the merge deadline for features has always been whatever makes it
 into the beta release, and I don't see cutting that back by a week helping
 things to get done faster -- we just end up with a week less features in
 2.8, and that last week is often (us being humans, and whatnot) the
 critical push time for things that are almost there.  Do you have something
 in mind that I'm not seeing for the change there?


 The feature freeze basically is the beta.  (I recall now this was called
 the beta cut-off during the 2.6 cycle.  I'll use this terminology going
 forward).  The interval between the cut-off and beta release cutting is our
 chance to let the dust settle after the merge rush so we're not cutting a
 buggy beta.  If Feb 18th is too soon, we can certainly push the beta back.


 I won't fight you hard on the week between cut-off and beta wrapping, but
 IMO it doesn't serve much purpose. Believe me, I know better than most that
 betas often don't get the attention they deserve, and because of that it
 feels (again, to me and maybe not to anyone else) like a week of doldrums.
 But if you feel that week will help you shake things out as RM, I'll
 mentally s/25/18/ the beta date


 I didn't really explain my expectations of the cut-off interval very
 well.  It's definitely helpful for the RM (finalizing the DB upgrade,
 compiling release notes, misc. cleanup, etc.), but to me it's more about
 developers testing this shiny new thing that we're about to call the Beta,
 particularly since it's the first time some of the features will be living
 together.  A group sniff test, if you will.  (e).


Gotcha.  I was attributing some of Ben's observations to your motives, but
not entirely rightly.

I would expect most of the feature branches to be merged before the
cut-off, but those ones at the end will tend to be less-well-tested in
combination, so the sniff test reason is totally sane and sound.  Thanks
for helping me see the logic. :)


 I see your point about the doldrums, though.  A week is probably too
 long.  Let's push the beta cut-off up to the 20th?


Merge by the end of the week seems like a good idea to me, so I'm +1 to
that.

Thanks!

-miker

-b

Re: [OPEN-ILS-GENERAL] 2.8 release scheduling

[Mike Rylander]

On Thu, Dec 18, 2014 at 12:11 PM, Bill Erickson beric...@gmail.com wrote:


 On Thu, Dec 18, 2014 at 8:29 AM, Mike Rylander mrylan...@gmail.com
 wrote:

 Bill,

 First, thanks for putting out a timeline.

 I am a little concerned about the pre-beta feature freeze.  In the past,
 the merge deadline for features has always been whatever makes it into the
 beta release, and I don't see cutting that back by a week helping things
 to get done faster -- we just end up with a week less features in 2.8, and
 that last week is often (us being humans, and whatnot) the critical push
 time for things that are almost there.  Do you have something in mind that
 I'm not seeing for the change there?


 The feature freeze basically is the beta.  (I recall now this was called
 the beta cut-off during the 2.6 cycle.  I'll use this terminology going
 forward).  The interval between the cut-off and beta release cutting is our
 chance to let the dust settle after the merge rush so we're not cutting a
 buggy beta.  If Feb 18th is too soon, we can certainly push the beta back.


I won't fight you hard on the week between cut-off and beta wrapping, but
IMO it doesn't serve much purpose. Believe me, I know better than most that
betas often don't get the attention they deserve, and because of that it
feels (again, to me and maybe not to anyone else) like a week of doldrums.
But if you feel that week will help you shake things out as RM, I'll
mentally s/25/18/ the beta date


 With my proposed schedule, the post-freeze period for 2.8 is already 2
 weeks shorter than it was for 2.7.  So, if we push the beta back, we should
 push back the mid-march release date as well.


Point taken.  I'll consent that the winter time loss (vacations and such)
is surely causing more time crunch than that week.





 I did note that the feature target deadline is not a hard deadline, but
 for my part I can say that with the schedule only being clarified over what
 amounts to 3 months (the remainder of December through release in
 mid-March), the middle of January will be a tight squeeze to target things
 by then.  Being one that does a good bit of feature development, I expect
 to be begging leave to target features after the scheduled date on several
 smaller features, as dev time permits in January and February.  I just want
 to set that expectation now, so it's not a surprise if it ends up
 happening...


 I am definitely expecting new features to emerge after the LP target
 deadline.  This deadline serves two purposes in my mind.  1. If you know
 about it, document it, so others will know about it.  2. If you want to
 introduce large architectural changes after this date, be prepared for
 additional community scrutiny.


Understood, and that makes sense, thanks.  I was thinking of small things,
not big architectural stuff, with my head's up.


 I was in no particular rush to publish the schedule with the assumption
 that release schedules are highly predictable.  Release mid-March/October,
 beta cut-off a month before that, and everything else is gravy.  For my own
 sake and that of future RM's, is that not a reasonable assumption?


I agree that should be a reasonable assumption.  While it may just be a
matter of terminology and taste, it seemed like there were some departures
from the past (feature cutoff and beta wrapping offset, no alpha (which I
agree with you on, fwiw)), so it felt less predictable (predicted?) to me.

Thanks!

--miker

Thanks,

 -b




 Thanks!


 --
 Mike Rylander
  | President
  | Equinox Software, Inc. / The Open Source Experts
  | phone:  1-877-OPEN-ILS (673-6457)
  | email:  mi...@esilibrary.com
  | web:  http://www.esilibrary.com


 On Fri, Dec 12, 2014 at 4:07 PM, Bill Erickson beric...@gmail.com
 wrote:

 Hi All,

 I'm attempting to sketch out the release schedule for Evergreen 2.8, so
 I'd like to run some dates/thoughts by everyone.

 For starters, unless someone requests it, I'm not planning to cut an
 Alpha release.  I've never seen anyone install one :).  I'm happy to cut
 one if desired, though.

 Proposed schedule:

 * Jan 14 2015: Feature Target Deadline

 This is the date where all features we expect to get into 2.8 are
 documented in LP and targeted to 2.8.  They do not have to be coded or
 tagged as pull requests by this date.  They just need to be documented.  As
 before, this is a strong recommendation, but not a hard deadline.

 Feb 18 2015: Feature Freeze

 From this date forward, only bug fixes may be committed to master.  Any
 un-merged features will be booted to 2.9.

 Feb 25 2015: 2.8.beta1 Release

 March 9 2015: 2.8.rc1 Release

 March 18 2015: 2.8.0 Release

 Comments/suggestions welcome.

 Note that in the future I'll avoid cross-posting to both -general and
 -dev lists and just send 2.8 updates to -general to cut down on noise.

 Thanks, everyone.

 -b

Re: [OPEN-ILS-GENERAL] Retrieving no results using Bib Call Number search

[Mike Rylander]

Just for clarification, Evergreen can index any field that's needed for the
bib call number search.  It's a matter of configuration (available directly
in the staff client) and a reindex if fields are added.

HTH,


On Tue, Oct 21, 2014 at 8:49 AM, Hardy, Elaine eha...@georgialibraries.org
wrote:

 Or 050 for an Library of Congress Classification scheme. I don't know that
 Evergreen also indexes the 084 if you use classification scheme other than
 Dewey or LCC. Or even if it indexes 055, 060, etc.

 Elaine

 J. Elaine Hardy
 PINES  Collaborative Projects Manager
 Georgia Public Library Service
 1800 Century Place, Ste 150
 Atlanta, Ga. 30345-4304

 404.235-7128
 404.235-7201, fax
 eha...@georgialibraries.org
 www.georgialibraries.org
 www.georgialibraries.org/pines

 -Original Message-
 From: open-ils-general-boun...@list.georgialibraries.org
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
 Sharp, Chris
 Sent: Tuesday, October 21, 2014 8:09 AM
 To: Evergreen Discussion Group
 Subject: Re: [OPEN-ILS-GENERAL] Retrieving no results using Bib Call Number
 search

 Hi Jayaraj,

 The Bib Call Number search is searching the MARC record (082 field, if I'm
 not mistaken) for a dewey call number, so that search is entirely dependent
 on your catalogers adding that field for each of your items' bib records.

 Does that help?

 Chris

 - Original Message -
  From: Jayaraj JR jaya...@iisertvm.ac.in
  To: open-ils-general@list.georgialibraries.org
  Sent: Tuesday, October 21, 2014 7:44:10 AM
  Subject: [OPEN-ILS-GENERAL] Retrieving no results using Bib Call
 Numbersearch
 
 
 
  Hello,
 
  In Evergreen 2.6.1, wee are unable to retrieve any record/ result
  while search using Bib Call Number option either in the TPAC/ Staff
  Client. Kindly advice us how to rectfy this option. All other search
  options are functioning and retrieving correct results
 
  Thanking You
 
 
 
 
  --
 
 
  Jayaraj J R
  Library Information Assistant
 
  IISER Thiruvananthapuram
 
 
  http://www.iisertvm.ac.in
 

 --
 Chris Sharp
 PINES System Administrator
 Georgia Public Library Service
 1800 Century Place, Suite 150
 Atlanta, Georgia 30345
 (404) 235-7147
 csh...@georgialibraries.org
 http://pines.georgialibraries.org/




-- 
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] [OPEN-ILS-DEV] Web Client (Sprint 1) demo - initial testing results

[Mike Rylander]

On Thu, Oct 2, 2014 at 1:58 PM, Kathy Lussier kluss...@masslnc.org wrote:

  Hi all,

 Sorry to be replying to an older thread, but I came across it while
 looking at column pickers in the web client.

  ITEMS OUT SCREEN - COLUMN PICKER:
 - I didn't go through every option, but there were obvious differences
 between the current staff client and the web client and definitely some
 columns missing that are in the current staff client.


  There are a few things missing (like checkout/checkin workstation and
 circ or renewal worktation), and the list of values in the web based client
 is not ordered alphabetically.  We can fix the latter and the former is due
 to one of the known challenges going to a web interface.  A longer and more
 explanatory email to come on that.


 Did we ever get the longer and more explanatory e-mail? I'm guessing it
 has something to do with cutting back our column picker options?


I didn't go into a ton of detail, but I did respond, I'm pretty sure.
However, I /did/ add the missing columns and add full-list sorting.  Those
commits are in a working branch that is waiting to be merged into master.


  - Show All Columns and Hide All Columns don't appear to do anything


  They surely don't.  And honestly, I would not recommend anyone ever use
 show all columns - do we really need that option when we have 60+ column
 options?  And, now that I think about it... Has anyone ever user hide all
 columns except after you accidentally chose show all columns? Any opinions
 on keeping those functions?

 +1 to removing those options.


I tend to agree, though I think it might be worth while for show-all to be
possible for some UIs with just a few columns.  Thoughts?

-- 
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



 Kathy

 Kathy Lussier
 Project Coordinator
 Massachusetts Library Network Cooperative(508) 343-0128kluss...@masslnc.org
 Twitter: http://www.twitter.com/kmlussier
 #evergreen IRC: kmlussier

 On 8/27/2014 9:13 AM, Grace Dunbar wrote:

 Answers inline.


 On Mon, Aug 25, 2014 at 6:32 PM, McCanna, Terran 
 tmcca...@georgialibraries.org wrote:

 MAIN SCREEN OF INTERFACE:
 - Register Patron(s) link missing
 - Pull List for Hold Requests link missing
 - Catalog Search field missing
 - Advanced Search link missing
 - Item Status link missing


  To be clear, I assume you mean that all of the above should be added as
 quick links from the splash page?
 These actions
 - Register Patrons
 - Pull List for Hold Requests
 - Catalog Search
 - Advanced Search
 - Item Status
 are all available from the menus at the top.

  Since we're moving to a browser client and have the opportunity to
 re-think the splash page I think this might be a good time to get community
 input as to what actions should be included and how those should be
 organized.
 Should there even be a splash page with a browser client and, if so, what
 should be included as quick links by default?



 - Is the large Equinox banner across the bottom of the screen present
 because it's being hosted on an Equinox server, or is this something you
 have added to the default interface?


 Equinox would never brand the Evergreen open source product with its name.

 Never.
 This is simply a style banner to indicate that we are hosting this
 community test server.  I'm sorry if that wasn't clear.


 MENUS:
 - Search Catalog link missing from Search dropdown menu


  We can add that.  (Right now it appears under Cataloging, for those who
 are just following the email discussion)  In the current client a link to
 search the catalog appears under both Cataloging and Search menus. Should
 we keep them both or eliminate one?

  PATRON FUNCTIONS:
 - When creating a new message on an account there is an empty dropdown
 box on the right side of the pop-up window - what is that for? I don't seem
 to be able to do anything with it.


  What Bill said. It exists in the current client for custom penalties. We
 should probably put a label on it at the very least.


 - the Message pop-up window is missing the field to record staff initials
 that is in the current staff client


  Good catch.  We'll add that.


 ITEMS OUT SCREEN - COLUMN PICKER:
 - I didn't go through every option, but there were obvious differences
 between the current staff client and the web client and definitely some
 columns missing that are in the current staff client.


  There are a few things missing (like checkout/checkin workstation and
 circ or renewal worktation), and the list of values in the web based client
 is not ordered alphabetically.  We can fix the latter and the former is due
 to one of the known challenges going to a web interface.  A longer and more
 explanatory email to come on that.



 - Show All Columns and Hide All Columns don't appear to do anything


  They surely don't

Re: [OPEN-ILS-GENERAL] [OPEN-ILS-DEV] Web Client (Sprint 1) demo - initial testing results

[Mike Rylander]

On Wed, Aug 27, 2014 at 10:57 AM, McCanna, Terran 
tmcca...@georgialibraries.org wrote:

 Hi Grace,


 

 To be clear, I assume you mean that all of the above should be added as
 quick links from the splash page?
 These actions
 - Register Patrons
 - Pull List for Hold Requests
 - Catalog Search
 - Advanced Search
 - Item Status
 are all available from the menus at the top.


 Since we're moving to a browser client and have the opportunity to
 re-think the splash page I think this might be a good time to get community
 input as to what actions should be included and how those should be
 organized.
 Should there even be a splash page with a browser client and, if so, what
 should be included as quick links by default?

 

 Yes, this list is based on what's currently in the staff client under the
 assumption that the developers are recreating what is currently there. I'm
 not opposed to the idea of re-thinking what is on the splash page, but I
 would be opposed to removing it entirely as I think it's very helpful for
 staff.


Also, just to be clear, for both the splash page and menus we'll be adding
only those entries that are being addressed during the current sprint.  So,
for instance, there won't be a Reports link until we address the reporter.


 MENUS:
 - Search Catalog link missing from Search dropdown menu

 We can add that. (Right now it appears under Cataloging, for those who are
 just following the email discussion) In the current client a link to search
 the catalog appears under both Cataloging and Search menus. Should we keep
 them both or eliminate one?
 

 I prefer to have it in both places, but if it were only to be in one
 place, I would put it under Search.


For the time being, I've added it to the Search menu as well.




 

 ITEMS OUT SCREEN - COLUMN PICKER:
 - I didn't go through every option, but there were obvious differences
 between the current staff client and the web client and definitely some
 columns missing that are in the current staff client.

 There are a few things missing (like checkout/checkin workstation and circ
 or renewal worktation), and the list of values in the web based client is
 not ordered alphabetically. We can fix the latter and the former is due to
 one of the known challenges going to a web interface. A longer and more
 explanatory email to come on that.
 

 Great, thank you.


I've added both of the workstation columns, and we can add more as needed.
The ability to use the show/hide all actions is fixed already in master, so
that will show up with the next update to Webby.

To address the sorting of columns in the picker, I've added code that
recognizes when a field has been added explicitly and individually, as
opposed to the full field set of a table via wildcard.  Explicit columns
are pushed to the top of the list, and their UI order retained, and
wildcard-added columns are then sorted by their labels, regardless of the
table from which they came.

You can see that code, along with the workstation column additions and the
nav bar update, here:
http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/collab/miker/web-client-sprint1-cleanup

Others should feel free to toss small fixes on that collab branch, and we
can squash it down as a general fix branch later.

Thanks!

-- 
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] Web Client (Sprint 1) demo server

[Mike Rylander]

Folks,

I've updated the certs on webby.evergreencatalog.com, so all should be well
in that regard now.


On Thu, Sep 18, 2014 at 11:37 AM, Bill Erickson beric...@gmail.com wrote:



 On Tue, Sep 16, 2014 at 2:22 AM, Liam Whalen 
 liam.wha...@bc.libraries.coop wrote:

 snip


 I am getting the following error when I try to login via Firefox on the
 Windows VM:

 webby.evergreencatalog.com:7682 uses an invalid security certificate.

 The certificate is not trusted because no issuer chain was provided.

 (Error code: sec_error_unknown_issuer)

 Firefox can't establish a connection to the server at wss://
 webby.evergreencatalog.com:7682/osrf-websocket-translator.
 evergreen-staff-client.0.0.1.min.js:9
 Error: WebSocket Error [object Event] : undefined
 evergreen-staff-client.0.0.1.min.js:9
 closing websocket evergreen-staff-client.0.0.1.min.js:9
 Synchronous XMLHttpRequest on the main thread is deprecated because of
 its detrimental effects to the end user's experience. For more help
 http://xhr.spec.whatwg.org/ exceptionDialog.js:136
 www.evergreencatalog.com:443 uses an invalid security certificate.

 The certificate is only valid for the following names:
   *.esilibrary.com, esilibrary.com


 I can confirm this is a problem in Linux / FF 31 as well.  Firefox is
 considerably more rigid in its security restrictions than Chrome.  If I
 recall correctly, in previous versions of FF, adding an exception for https
 would allow websockets connections to succeed as well.  Apparently not
 anymore.  We'll need a valid certificate on the server for Firefox to work.


 -b




-- 
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] Proposed change in Vendor Listing Policy

[Mike Rylander]

 IRC: kmlussier

 On 9/8/2014 9:23 PM, W. Brad LaJeunesse wrote:

 Speaking as one of the vendors, I don't see a link back requirement as a
 burden, but rather it seems a simple reciprocal gesture. It seems totally
 reasonable to me. It's not like you're asking us to cut down the largest
 tree in the forest with a herring. [1]

 I couldn't remember, so I just took a look at our website, and while we
 don't have a link back from any of our services pages, we do have a link
 back from our dedicated Evergreen page. We support multiple open source
 products, and our services are at least very similar across all of them, so
 we created a page for each open source community (that don't mention our
 services, actually) and link back to each community website from there.

  So, there are some changes required on our website in order to fully
 comply with this proposal (as I read it, at least), but we're fine with
 that.

  Thanks for asking for input.

  [1] https://www.youtube.com/watch?v=2DopGxUAoAY

  --
  W. Brad LaJeunesse
 | President
 | Equinox Software, Inc. / The Open Source Experts
 | phone: 1-877-OPEN-ILS (673-6457)
 | email: b...@esilibrary.com
 | web: http://www.esilibrary.com

 On Mon, Sep 8, 2014 at 5:03 PM, Kathy Lussier kluss...@masslnc.org
 wrote:

  Hi all,

 This has been a great discussion so far!

 In addition to hearing from the general user community, I'm also
 interested in hearing from the vendors who are part of our community.
 Please let us know what you think because I think we ultimately want to
 strike a balance between providing useful information to our users while
 also not imposing an undue burden on our vendor community.

 Thanks!
 Kathy

 Kathy Lussier
 Project Coordinator
 Massachusetts Library Network Cooperative(508) 343-0128kluss...@masslnc.org
 Twitter: http://www.twitter.com/kmlussier
 #evergreen IRC: kmlussier

   On 9/8/2014 1:28 PM, Rogan Hamby wrote:

 No, I thank you for bringing up those points and I think you're right we
 do seem to have a slightly differently view of the intent and so these
 discussions are good to have.  I hope we will hear from more folks!


 On Mon, Sep 8, 2014 at 1:18 PM, Sharp, Chris 
 csh...@georgialibraries.org wrote:

 Thanks again, Rogan, for the continued discussion on this.  I'm glad
 we're able to air our respective opinions.

  There was some discussion during the meeting about it being suggested
  versus required. To me those elements that make it more user
  friendly should be required or we start diluting the purpose.

 Ah, here is where I think we're disagreeing.  From my perspective, the
 purpose of the vendor page is to provide a simple directory that gives our
 project's end users pointers toward potential vendors for support.  What
 happens after the user sees these listings is beyond the scope of that
 purpose, as I see things.  I think our responsibility from the Evergreen
 community side ends at making sure to the best of our ability that the
 listings *on the page itself* are up-to-date and accurate.  I see a clear
 dividing line between that responsibility and the responsibility of the
 vendors to keep their web pages up to date.  I'm not generally for laissez
 faire policies, but in this case, it seems that vendors will do what's best
 to communicate their services to users without us needing to add
 requirements to do so.

 Having said that, I'm satisfied that I've been heard and I'll be quiet
 now and let community consensus decide whether or not this requirement
 becomes part of our vendor listing policy.

 Thanks for hearing me out,

 Chris

 --
 Chris Sharp
 PINES System Administrator
 Georgia Public Library Service
 1800 Century Place, Suite 150
 Atlanta, Georgia 30345
 (404) 235-7147 %28404%29%20235-7147
 csh...@georgialibraries.org
 http://pines.georgialibraries.org/




  --

 Rogan Hamby, MLS, CCNP, MIA
 Managers Headquarters Library and Reference Services,
 York County Library System

  “You can never get a cup of tea large enough or a book long enough to
 suit me.”
 ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis






 --

 Rogan Hamby, MLS, CCNP, MIA
 Managers Headquarters Library and Reference Services,
 York County Library System

 “You can never get a cup of tea large enough or a book long enough to suit
 me.”
 ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis




-- 
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] Regarding auth-bib linking on combined name/title headings (1xx main entry + 240 field)

[Mike Rylander]

This isn't an answer to the question, but for some background, I personally
heard about this for the first time at the 2014 Evergreen conference.
 There's no code supporting 1-auth-field/multi-bib-fields today.

As a general question to the catalogers out there, is the 1XX/240 combo the
only instance of this that you're aware of, or is there a general pattern
of combining the control of multiple bib fields into a single authority
field?  That might inform the direction taken with any code to address this.

TIA,



On Thu, Aug 14, 2014 at 12:56 PM, Srey Seng ss...@catalystitservices.com
wrote:

   Hello,



 *Question*: Has any libraries out there performed bib-auth linking (with
 Backstage as a vendor ) and encounter the following scenario in their data?
 Any insight into how you approach this situation?



 According to Backstage, their system will combine the 1XX and 240 into a
 temporary unified heading for matching against LC. In short, we can have
 situations where we have a Bib that generated an authority record after
 processing, similar to the example bib and auth snippet listed below.



 This bib…

 =100  0\$aMartial.

 =240  10$aEpigrammata.$lEnglish  Latin.$kSelections

  Generates this auth…

 =100  0\$aMartial.$tEpigrammata.$kSelections.$lEnglish  Latin



 From my understanding of authority control and bib-auth linking in
 Evergreen, only a one MARC tag to one MARC tag (and one subfield to one
 subfield) type of linking/control is supported. So, running this bib/auth
 pair through bib-auth linking does not link these two together. I found
 this situation to be one reason why some authority records returned from
 backstage does not link to any bib when looking at some stats after
 linking.



 Thanks again for your help!






-- 
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] URL Display in PAC

[Mike Rylander]

Don,

I'd recommend against using fake copies.  You can use Located URIs owned at
the top of the org tree to the same end.  Also, be sure your indicators are
correct.  You want ind1 = 4 or 1, ind2 = 0 or 1:
http://www.loc.gov/marc/856guide.html

The label comes from either $y or $3, in that order.  $z, $2 or $n, in that
order, are used to display an access note next to the link.

http://docs.evergreen-ils.org/2.6/_cataloging_electronic_resources_8201_8212_8201_finding_them_in_catalog_searches.html

HTH,

-- 
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


On Tue, Jul 29, 2014 at 8:36 AM, Donald Butterworth 
don.butterwo...@asburyseminary.edu wrote:

 URL Display in PAC: Part 2

 Sorry about that. Accidentally hit the send key too soon. sigh

 I also created copy records for each electronic volume, with a shelving
 location of E-Resource Freely Available. What would y'all think about
 making the Shelving Location a hot link in the Available Copies display?

 Don



 On Tue, Jul 29, 2014 at 8:25 AM, Donald Butterworth 
 don.butterwo...@asburyseminary.edu wrote:

 All,

 Hope I'm not being to pesty with all these questions. Here is an issue
 that I ran into doing some bibliographic clean-up.

 I found a bib record for an old set that has 4 volumes. We were missing
 one of the volumes. The good news is that Internet Archives has a digital
 copy of all 4 volumes, so I added the URL for all 4 volumes, in 4 separate
 856 tags. $3e-Book$uURL$zVolume 1, 3rd edition, freely available from
 Internet Archives.

 Once the record is saved all that appears in the PAC Under the Electronic
 Resources banner are 3 lonesome URLs.

 First, is there a setting that needs attention so that all 4 URLs
 display? Second, is there a setting that needs attention so that the $z
 Note subfiled displays with the URL?

 I also created copy records for each electronic volume, with a shelving
 location of 



 --
 Don Butterworth
 Faculty Associate / Librarian III
 B.L. Fisher Library
 Asbury Theological Seminary
 don.butterwo...@asburyseminary.edu
 (859) 858-2227




 --
 Don Butterworth
 Faculty Associate / Librarian III
 B.L. Fisher Library
 Asbury Theological Seminary
 don.butterwo...@asburyseminary.edu
 (859) 858-2227

Re: [OPEN-ILS-GENERAL] URL Display in PAC

[Mike Rylander]

 subfiled displays with the URL?

  I also created copy records for each electronic volume, with a shelving
 location of 



 --
 Don Butterworth
 Faculty Associate / Librarian III
 B.L. Fisher Library
 Asbury Theological Seminary
 don.butterwo...@asburyseminary.edu
 (859) 858-2227






-- 
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] Installation question / comments

[Mike Rylander]

://info.cool-cat.org




 --
 Benjamin Shum
 Evergreen Systems Manager
 Bibliomation, Inc.
 24 Wooster Ave.
 Waterbury, CT 06708
 203-577-4070, ext. 113



-- 
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] Browse the Catalog and Auto Suggest not retrieving complete results

[Mike Rylander]

During the database upgrade, the 2.5-2.6 script informs the user that
they would need to perform a full bibliographic record reingest after
the schema upgrade was completed, and provides instructions on how to
do that.  If you didn't follow those instructions then you would see
exactly the result you see now.  Simply follow the instructions that
were provided, or see the end of the script here:
http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/sql/Pg/version-upgrade/2.5.3-2.6.0-upgrade-db.sql;h=05f6d67ef80c70bdc238a150a36a82e54b39a0c3;hb=e6a68a2d702909f0b11f6bac974430755385e621#l5836


On Mon, Jun 30, 2014 at 6:13 AM, Jayaraj JR jaya...@iisertvm.ac.in wrote:
 Hello,

 We have updated from Evergreen 2.3.7 to 2.6.1. It is noticed that Browse the
 Catalog Option and Auto Suggest Option in the TPAC retrieves only those
 titles that are added to our collection after the up-gradation. The search
 option ( basic and advanced ) in the catalog is working fine and retrieving
 correct results.

 Please advice us how to solve the problem

 Thanking You
 --

 Jayaraj J R
 Library Information Assistant
 IISER Thiruvananthapuram




-- 
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] 2.5.2 Subject Browse Index

[Mike Rylander]

Kathy and Don,

To the separator issue, those can certainly be added, but not without
adjusting the search-oriented All Subjects index.  You'd need to (at
least) set the joiner field to ' -- ' (note the spaces!), add a
browse_xpath of '//*', and to set browse_field=TRUE.  Then a reingest.
If testing that, I'd suggest picking a few records to try it with
first, of course.

This will be create entries for the full subject heading in addition
to the separated ones from the topic, name, etc subject indexes.  My
previously mentioned method would be more cataloging correct.


On Wed, Jun 18, 2014 at 10:14 AM, Kathy Lussier kluss...@masslnc.org wrote:
 Hi Don,

 I think there is another way you can get the catalog to display the entire
 string. When MassLNC was testing this development with Bibliomation, we
 noticed the same issue and were advised to set the All Subjects index
 browse field to true to get the entire string to display in the browse
 search. By default, the browse flag is set to false in this index, and the
 subject browse is based on the geographic, name, topic, time period subject
 indexes.

 If you look at Bibliomation's catalog at http://acorn.biblio.org/, you'll
 see that the browse search is displaying the complete subject string (minus
 separators). I was just talking to Ben Shum about their setup, and they do
 not have authority records loaded in their system yet, but they were able to
 get the entire string to display by enabling browse in the All Subjects
 index.

 What I don't know is if a reingest is required after you set the browse flag
 to true for an existing index in your system. Could anyone answer that
 question?

 One thing we would like to see is the separators added to those browse
 headings.

 Also, +1 to the idea of setting the All Subjects index to browse by default
 so that you can get the entire string. In speaking to multiple Evergreen
 sites, I have not heard from one that does not want the entire subject
 string to display. I'll file a LP bug for that too.

 Kathy

 Kathy Lussier
 Project Coordinator
 Massachusetts Library Network Cooperative
 (508) 343-0128
 kluss...@masslnc.org
 Twitter: http://www.twitter.com/kmlussier

 On 6/6/2014 1:24 PM, Donald Butterworth wrote:

 Thanks for the great response Mike!

 For the subject browse, I'm not yet familiar enough with authority record
 links in Evergreen to know if this is viable solution. There are an
 incredible number of subject permutations which would make it impossible to
 anticipate every possible subject that would be legitimate.

 Is there any support out in Evergreen Land for making option two the
 default? We really are out of step with the rest of the library community. I
 can't think of another library system that has a subject browse index, that
 doesn't include the entire subject phrase.

 For the series browse, I'm pretty sure we didn't do anything special to make
 it appear. It just show up after the upgrade ... which is real good.

 Is there any support in Evergreen Land to include Series Browse as a default
 that excludes the subfield v as part of the indexing?



 On Fri, Jun 6, 2014 at 10:23 AM, Mike Rylander mrylan...@gmail.com wrote:

 Don,

 For the subjects, there are two ways to handle it.  The first is to
 add authority records and link those to the appropriate bib records.
 This will get you what you want without any further configuration, as
 authority is browse-indexed the way you describe by default.

 The second way involves new configuration entries and a partial
 reingest, but it can certainly be done.  You'll need a new
 browse-specific indexing definition to replace the one that's
 piggybacking on the exiting topic index.  For the 650, something along
 the lines of:

 INSERT INTO config.metabib_field (name, field_class, label, format,
 xpath, search_field, facet_field, browse_field, authority_xpath,
 browse_xpath)
   VALUES ('browse_topic', 'subject', 'Browse Topic', 'marcxml',
 '//marc:datafield[@tag=650]', false, false, true, '//*[@code=0]',
 '//*[contains(avxyz,@code)]');
 UPDATE config.metabib_field SET browse_field = false WHERE name =
 'topic' AND field_class = 'subject';

 All of that can also be done in the staff client through Admin -
 Server Administration - MARC Search/Facet Fields.  After that, you'll
 need to perform a browse reingest after hours.  Something like the
 following will do it in one fell swoop:

 SELECT metabib.reingest_metabib_field_entries(id, TRUE, FALSE, TRUE)
 FROM biblio.record_entry;
 DELETE FROM metabib.browse_entry WHERE id NOT IN (SELECT entry FROM
 metabib.browse_entry_def_map UNION SELECT entry FROM
 metabib.browse_entry_simple_heading_map);

 Series is not indexed for browse by default, so I assume you mean the
 series facet?  Assuming so, you could replace the MODS-based XPath for
 the Series Title indexing definition with one that goes directly to
 the MARC and excludes the fields you don't want.  That would be more
 involved, though.  See here

Re: [OPEN-ILS-GENERAL] 2.5.2 Subject Browse Index

[Mike Rylander]

Don,

For the subjects, there are two ways to handle it.  The first is to
add authority records and link those to the appropriate bib records.
This will get you what you want without any further configuration, as
authority is browse-indexed the way you describe by default.

The second way involves new configuration entries and a partial
reingest, but it can certainly be done.  You'll need a new
browse-specific indexing definition to replace the one that's
piggybacking on the exiting topic index.  For the 650, something along
the lines of:

INSERT INTO config.metabib_field (name, field_class, label, format,
xpath, search_field, facet_field, browse_field, authority_xpath,
browse_xpath)
  VALUES ('browse_topic', 'subject', 'Browse Topic', 'marcxml',
'//marc:datafield[@tag=650]', false, false, true, '//*[@code=0]',
'//*[contains(avxyz,@code)]');
UPDATE config.metabib_field SET browse_field = false WHERE name =
'topic' AND field_class = 'subject';

All of that can also be done in the staff client through Admin -
Server Administration - MARC Search/Facet Fields.  After that, you'll
need to perform a browse reingest after hours.  Something like the
following will do it in one fell swoop:

SELECT metabib.reingest_metabib_field_entries(id, TRUE, FALSE, TRUE)
FROM biblio.record_entry;
DELETE FROM metabib.browse_entry WHERE id NOT IN (SELECT entry FROM
metabib.browse_entry_def_map UNION SELECT entry FROM
metabib.browse_entry_simple_heading_map);

Series is not indexed for browse by default, so I assume you mean the
series facet?  Assuming so, you could replace the MODS-based XPath for
the Series Title indexing definition with one that goes directly to
the MARC and excludes the fields you don't want.  That would be more
involved, though.  See here for the current mapping used:
http://www.loc.gov/standards/mods/v3/mods-mapping.html#relateditem

HTH,


On Fri, Jun 6, 2014 at 9:16 AM, Donald Butterworth
don.butterwo...@asburyseminary.edu wrote:
 Colleagues,

 We recently upgraded to the 2.5.2 release and, as a cataloger, I was
 ecstatic to find that Browse the Catalog is now available. I will use this
 feature extensively when assigning author names, series, and subjects.

 The author and title indexes looks great, but there is one tweak in the
 subject index and one in series that I want to make.

 In subjects each individual subject subfield is being indexed rather than
 the whole line. For example:

 650  0 Conflict management -- Religious aspects -- Christianity

 is being displayed in the results list as

 * Conflict management
 * Religious aspects
 * Christianity

 What do I need to do to change this?

 In series I don't want the subfield v to be included in the results list
 display. For example:

 Tyndale studies ; v. 1 (1)
 Tyndale studies ; v. 2 (1)
 Tyndale studies ; v. 3 (1)

 should display as

 Tyndale studies ; (3)

 Again, what do we need to do to change this?

 Thanks for you insights!

 Don


 --
 Don Butterworth
 Faculty Associate / Librarian III
 B.L. Fisher Library
 Asbury Theological Seminary
 don.butterwo...@asburyseminary.edu
 (859) 858-2227



-- 
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] staff client dev 2014-05-19 / feedback requests

[Mike Rylander]

 off-base?  Or is this the beginning of
 something we can work with?



 Thanks,

 Dan



 P.S.  Bill, I think you are doing an outstanding job, and we couldn’t even
 have this conversation without all the work you have done to pave the way.
 Please don’t take anything above as being critical of the hundreds of
 decisions you’ve had to make to get to where we are today.  Again, thank
 you!





 Daniel Wells

 Library Programmer/Analyst

 Hekman Library, Calvin College

 616.526.7133



 From: open-ils-general-boun...@list.georgialibraries.org
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
 Bill Erickson


 Sent: Monday, May 19, 2014 5:01 PM
 To: Evergreen Discussion Group
 Subject: [OPEN-ILS-GENERAL] staff client dev 2014-05-19 / feedback requests



 http://wiki.evergreen-ils.org/doku.php?id=dev:browser_staff:dev_notes#section20140519



 I have feedback requests for patron horizontal vs. vertical display and link
 (a) behavior.



 Thanks,



 -b



 --

 Bill Erickson

 | Senior Software Developer

 | phone: 877-OPEN-ILS (673-6457)

 | email: ber...@esilibrary.com

 | web: http://esilibrary.com

 | Equinox Software, Inc. / The Open Source Experts





-- 
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] Authority Control Processing

[Mike Rylander]

On Thu, May 15, 2014 at 9:37 AM, Martha Driscoll drisc...@noblenet.org wrote:
 The discussion of authority control vendors reminds me that I don't have a
 solid grasp of authority record processing.

 This is what I have been able to figure out.  Let me know if I have made any
 incorrect assumptions.

 Let's assume a 2.5 system.

 Initial record loading

 1. Authority records are loaded into the system.

 2. The script authority_authority_linker.pl is run.  This script links
 reference headings in authority records to main entry headings in other
 authority records.

 3. The script authority_control_fields.pl is run.  This script goes though
 each bib record and creates a $0 in any field with a matching authority
 record.

 Does it matter what order this is done in?


I would strongly recommend authority_authority_linker.pl first, to
avoid causing yet more (unnecessary) bib reingest.  Also, there is a
bug fix for authority_authority_linker.pl at
https://bugs.launchpad.net/evergreen/+bug/1312945 that you'll want.

 Ongoing Processing

 1. As new bibs are added to the database, run authority_control_fields.pl on
 the range of new bib id's.

 2. As new authority records are added to the database, run
 authority_authority_linker.pl on the range of new authority record id's.


Sounds good.

 Do old bib records ever need to be run through authority_control_fields.pl
 again?

Not unless they are edited, which brings us to ...

  What if they are updated?

The right-click authority mechanism can be used for controllable
fields during human edits.

  What if they are overlaid via vandelay?

Probably good to re-link these.

 Is there ever a circumstance where a new or updated authority record now
 matches old bibs?

Sure, that could happen ...

  How would you identify the bibs, or do you have to run
 authority_control_fields.pl through the bib database periodically?


Actually, the browse data (metabib.browse_entry, and the bib- and
auth-related linking tables that point at it) could probably identify
most of this.  There's no preexisting SQL for that today, but all the
data is theoretically there, and the bib browse interface effectively
uses the same logic you'd need to find unlinked-but-matching headings
in order to fold all headings together.

 --
 Martha Driscoll
 Systems Manager
 North of Boston Library Exchange
 Danvers, Massachusetts
 www.noblenet.org



-- 
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] 2.4.7 Available for testing

[Mike Rylander]

2.4.7 has now been released, and is available on the downloads page*.
2.4 is dead, long live 2.6!

This is the final 2.4 release, barring security issues.  It contains
improvements to documentation, acquisitions, speed, character
encoding, Vandelay, holds targetting, serials, and general usability.

Thanks to those that made 2.4.7 possible.  In alphabetical order, and
according to the changelog, those folks are:

Ben Shum
Bill Erickson
Dan Scott
Dan Wells
Elliot V
Galen Charlton
Jeff Godin
Kathy Lussier
Lebbeous Fogle-Weekley
Mike Rylander
Pasi Kallinen
Remington Steed
Steven Callender
Thomas Berezansky
Yamil Suarez

Thanks also to bug submitters, code reviewers, and committers not
listed here.  Excelsior!

* http://evergreen-ils.org/egdownloads/


On Mon, Apr 21, 2014 at 3:56 PM, Mike Rylander mrylan...@gmail.com wrote:
 Hot on the heals of the 2.6.0 release (thanks, Dan!), I offer you
 2.4.7 for testing.  I'll move it to release status once I get back at
 least one it worked, or we wait a week ... whichever comes first.

 You can grab it from:

 http://evergreen-ils.org/downloads/previews/Evergreen-ILS-2.4.7.tar.gz
 http://evergreen-ils.org/downloads/previews/Evergreen-ILS-2.4.7.tar.gz.md5
 http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.7_i686.tar.bz2
 http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.7_i686.tar.bz2.md5
 http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.7_x86_64.tar.bz2
 http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.7_x86_64.tar.bz2.md5
 http://evergreen-ils.org/downloads/previews/evergreen-setup-2.4.7.exe
 http://evergreen-ils.org/downloads/previews/evergreen-setup-2.4.7.exe.md5
 http://evergreen-ils.org/downloads/previews/ChangeLog-2.4.6-2.4.7

 Thanks, all!

 --
 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



-- 
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] Pre-Cataloged Items

[Mike Rylander]

Also, once (if) you attach a pre-cat to a real bib, the circ follows
the pre-cat into catalog-ed-ness, and sticks with the real item
forever.


On Thu, May 1, 2014 at 2:58 PM, Jason Etheridge ja...@esilibrary.com wrote:
 Kate, the circulation record still exists, but how it gets used (or
 not) depends on how you construct your reports.

 -- Jason



-- 
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] 2.6 Wrap Up and Awards [RM2.6]

[Mike Rylander]

I echo Dan's thanks to everyone who pitched in on 2.6.

Dan, I'm particularly honored by the HAAS medal ... I'm always happy
to fight a clog, and the plungers are perfect. ;)

--miker

On Fri, Apr 25, 2014 at 4:07 PM, Dan Wells d...@calvin.edu wrote:
 Hello all,

 With 2.6.0 cut 10 days ago, it is high time for me to give one final update
 before I pass the torch.  I haven’t given a formal email progress summary
 since the beta (though a verbal update was given at the conference), so
 we’ll be looking back at both the RC and the 2.6 “final” contribution
 periods.

 With 23 tickets committed for the RC and 15 for 2.6.0, the grand total for
 the 2.6 cycle comes to exactly 100 improvements committed.  You can see the
 latest two rounds of fixes here:

 https://launchpad.net/evergreen/2.6/2.6.0-rc1

 and here:

 https://launchpad.net/evergreen/2.6/2.6.0

 While Launchpad gives us a nuts and bolts view of things, with a final
 release comes a better way to look more broadly at the changes: release
 notes!  You can read the release notes for 2.6 here:

 http://evergreen-ils.org/documentation/release/RELEASE_NOTES_2_6.html

 Of course, the beat goes on, and a few important fixes have already been
 committed for what will be 2.6.1.  I encourage anyone looking at 2.6.0 to
 read up on these recent commits and decide whether they might affect your
 local use:

 https://bugs.launchpad.net/evergreen/+milestone/2.6.1

 My expectation is still that 2.6.1 will be cut relatively early (within the
 next week or two), and that normal monthly updates will begin with 2.6.2.


 Overall, I am proud of all that we have been able to accomplish these past
 two cycles.  With that in mind, I’d like to take another moment to recognize
 those who put forth the necessary effort to make 2.6 a reality.  Of course
 this means medals, and for this round, you will notice that the medals are
 now rimmed in maroon.  This is meant not only to distinguish these final
 medals from the rest, but also as a modest gesture to my employer Calvin
 College, without whom I would not be involved with Evergreen, and without
 whose support I could not have managed these last two releases.

 Here are the recipients of the final Evergreen Medals of Honour for the 2.6
 release (RC and 2.6.0 combined):

 A. HANCOCK Medal of Fortitude (for reviewing and signing off on another
 community member's code)
   1. GOLD Recipients (granted for signing off on at least 6 branches)

 http://www.calvin.edu/library/images/eg_medals/Hancock_Medal_2_6_Final_Gold.png
 Ben Shum
 Galen Charlton
 Remington Steed
   2. SILVER Recipients (at least 2 signoffs)

 http://www.calvin.edu/library/images/eg_medals/Hancock_Medal_2_6_Final_Silver.png
 Bill Erickson
 3. BRONZE Recipients (at least 1 signoff)

 http://www.calvin.edu/library/images/eg_medals/Hancock_Medal_2_6_Final_Bronze.png
 Doug Kyle
 Jason Stephenson
 Jeff Godin
 Kathy Lussier
 Mike Rylander

 B. BARTON Medal of Steadfastness (for contributing in general to the code
 review process)
   1. GOLD Recipients (granted for contributing to at least 7 bug reviews)

 http://www.calvin.edu/library/images/eg_medals/Barton_Medal_2_6_Final_Gold.png
 Ben Shum
 Bill Erickson
 Galen Charlton
 Mike Rylander
   2. SILVER Recipients (at least 3 bugs)

 http://www.calvin.edu/library/images/eg_medals/Barton_Medal_2_6_Final_Silver.png
 Chris Sharp
 Dan Scott
 Grace Dunbar
 Jason Etheridge
 Jason Stephenson
 Kathy Lussier
 Lebbeous Fogle-Weekley
 Remington Steed
   3. BRONZE Recipients (at least 1 bug)

 http://www.calvin.edu/library/images/eg_medals/Barton_Medal_2_6_Final_Bronze.png
 Christine Morgan
 Doug Kyle
 Elaine Hardy
 Elliot Voris
 Erica Rohlfs
 Holly Brennan
 Jeff Godin
 Jennifer Pringle
 Mark Cooper
 Michael Peters
 Michele Morgan
 Pasi Kallinen
 Rogan Hamby
 Sarah Childs
 Srey Seng
 Steve Callender
 Tim Spindler
 Tina Ji
 Tony Bandy
 Warren Layton
 Yamil Suarez

 C. ARMSTRONG Medal of Courage (for installing and testing a release tarball,
 and reporting back)
   1. GOLD Recipients (granted for simply doing this!)

 http://www.calvin.edu/library/images/eg_medals/Armstrong_Medal_2_6_Final_Gold.png
 Remington Steed

 As always, please contact me if I made any mistakes, as I want everyone to
 get the recognition they deserve!

 Along those lines, and in addition to the recognition given above, I’d like
 to give one more medal under the banner of “ask and you shall receive.”
 Mike Rylander single-handedly wrote code to fix a majority of the release
 blockers for 2.6, and mentioned in IRC the possibility of an extra medal as
 a source of motiviation.  Who am I to deny such a dream?  Here

Re: [OPEN-ILS-GENERAL] Call for vote: Release Manager 2.7

[Mike Rylander]

+1

On Mon, Apr 21, 2014 at 12:01 PM, Jeff Godin jgo...@tadl.org wrote:
 Greetings!

 I'd like to call for a vote on Ben Shum's proposal to be Release Manager for
 Evergreen 2.7.

 Ben's proposal can be found in the list archives:
 http://georgialibraries.markmail.org/thread/b23u62e6rhebjkhk
 or
 http://libmail.georgialibraries.org/pipermail/open-ils-general/2014-March/009738.html

 Shall we accept Ben Shum's proposal to be Release Manager for Evergreen 2.7?

 Please respond to the list as part of this thread with +1 for yes or -1 for
 no. Feel free to include any additional brief comments, as votes are not
 tallied by computer.

 Detailed questions or comments would probably be appropriate in their own
 thread, or in the existing thread surrounding the proposal itself.

 Thank you!

 -jeff



-- 
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

[OPEN-ILS-GENERAL] 2.4.7 Available for testing

[Mike Rylander]

Hot on the heals of the 2.6.0 release (thanks, Dan!), I offer you
2.4.7 for testing.  I'll move it to release status once I get back at
least one it worked, or we wait a week ... whichever comes first.

You can grab it from:

http://evergreen-ils.org/downloads/previews/Evergreen-ILS-2.4.7.tar.gz
http://evergreen-ils.org/downloads/previews/Evergreen-ILS-2.4.7.tar.gz.md5
http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.7_i686.tar.bz2
http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.7_i686.tar.bz2.md5
http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.7_x86_64.tar.bz2
http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.7_x86_64.tar.bz2.md5
http://evergreen-ils.org/downloads/previews/evergreen-setup-2.4.7.exe
http://evergreen-ils.org/downloads/previews/evergreen-setup-2.4.7.exe.md5
http://evergreen-ils.org/downloads/previews/ChangeLog-2.4.6-2.4.7

Thanks, all!

-- 
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] View Holds Screen

[Mike Rylander]

Ben,

You're recollecting correctly -- Sitka was the driver for the feature.
 I am not surprised that there are ways around the wall, which was
primarily intended for stopping direct access without a link, but
allowing it when there is one -- such as when a foreign patron
checks out a local item.  I'm fairly certain that development would
be required to lock down this particular visibility leak, and that
there's no setting to expressly prevent it.


On Wed, Apr 9, 2014 at 3:21 PM, Ben Shum bs...@biblio.org wrote:
 Hi Fiona,

 I'm not too familiar with this area of Evergreen (in our consortium,
 people share and want to see everything), but I remember in the old
 days there's opt-in settings for patrons to say whether or not they
 give permission to be viewed at different libraries within a system.
 My recollection was that Sitka, Conifer, or Michigan libraries made
 use of these features.

 I'll see what I can dig up, or maybe this reply with spark an idea
 with someone who knows more about the current state of patron opt-in
 functionality.

 -- Ben

 On Wed, Apr 9, 2014 at 10:25 AM, Borthwick, Fiona
 fiona.borthw...@ptfs-europe.com wrote:
 Hi,

 I really hope someone in the community can help with a problem that one of
 our customers has.  There are 2 specific issues with the View Holds screen.

 The consortium in question operate as 4 separate authorities when it comes
 to holds so there is no interlending between the different systems.  The
 Hold Policies are set up to retrospectively block holds from a different
 system.  As a result no hold weighting policies or equivalent have been
 configured.

 The Patron Opt-In Boundary and Patron Opt-In Default settings have a value
 of 1 (system) and I can confirm that this behaves as we would expect in a
 patron search - i.e. a search will only find patrons that have a home
 library within your org unit tree.

 Our customer's test server is at 2.5.3 where these scenarios persist:

 1)  There can be a large number of holds on a popular bestseller.  When you
 go to the View Holds screen, you see the list of all holds for the entire
 consortium.

 There is a filter option which allows you to filter on either pickup library
 or requesting library but this is a specific branch.  Our customer needs to
 be able to see the holds queue for their whole system at once.  It is not
 necessary to see the holds for the other systems in the consortium.

 2)  This is a more serious problem.  Due to the above scenario - i.e. the
 ability to see all consortium holds, it has become apparent that you can
 access a patron record from another system.  From the View Holds Screen,
 highlight a hold and then select 'Retrieve Patron' from the Actions menu.
 You are taken straight into the patron record even if this patron belongs to
 another system (different org unit hierarchy).

 Can anyone shed any light on how to control this please?  This customer only
 wants to be able to see their own local authority's holds and more
 importantly be prevented from being able to access a patron record that
 doesn't belong to them.

 Many thanks in advance for any help.

 Fiona

 --

 Fiona Borthwick
 Customer Services Consultant, PTFS Europe Limited
 Content Management and Library Solutions

 +44 (0) 800 756 6803 (phone)
 +44 (0) 7540 768230  (mobile)
 +44 (0) 131 2088578  (direct dial)
 +44 (0) 800 756 6384 (fax)
 fiona.borthw...@ptfs-europe.com
 skype: fionaborthwick1

 http://www.ptfs-europe.com



 --
 Benjamin Shum
 Evergreen Systems Manager
 Bibliomation, Inc.
 24 Wooster Ave.
 Waterbury, CT 06708
 203-577-4070, ext. 113



-- 
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] Do you trim database tables?

[Mike Rylander]

Martha,

Other than storage, the auditor tables won't impact performance --
they are insert-only in practice.  What process are you using for
loading patrons?  If you're using the staging tables, it may just be a
matter of creating some indexes.


On Thu, Mar 27, 2014 at 9:40 AM, Rogan Hamby rogan.ha...@yclibrary.net wrote:
 I've contemplated doing this but have been hesitant for a number of reasons.
 Moving storage to SSDs eliminated a lot of bottlenecks for us though.


 On Thu, Mar 27, 2014 at 9:35 AM, Tim Spindler tjspind...@gmail.com wrote:

 Martha,

 Not that I have anything to add but I would like to know what are some
 good practices also.  We also have similar issues where tables are getting
 quite large.

 Tim


 On Thu, Mar 27, 2014 at 9:33 AM, Martha Driscoll drisc...@noblenet.org
 wrote:

 We have been on Evergreen for nearly 2 years.  Recently it has been
 taking significantly longer to load patron records than it used to.  We load
 files just about weekly for our college libraries and the files contain
 thousands of records.

 I asked a few people at the conference about trimming tables and found
 that some delete data out of auditor tables.  Our actor_usr_history table is
 around 14 million rows and asset_copy_history is over 26 million rows.  We
 don't currently age the circulations and the actor.circulation table is up
 around 67 million rows.

 I'm wondering what system administrators do periodically to keep the
 database running efficiently and what the potential trade-offs are.

 --
 Martha Driscoll
 Systems Manager
 North of Boston Library Exchange
 Danvers, Massachusetts
 www.noblenet.org




 --
 Tim Spindler
 tjspind...@gmail.com

 P   Go Green - Save a tree! Please don't print this e-mail unless it's
 really necessary.






 --

 Rogan Hamby, MLS, CCNP, MIA
 Managers Headquarters Library and Reference Services,
 York County Library System

 You don't have to burn books to destroy a culture. Just get people to stop
 reading them.
 -- Ray Bradbury

 You can never get a cup of tea large enough or a book long enough to suit
 me.
 -- C.S. Lewis



-- 
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] Primary Barcode in Reports

[Mike Rylander]

Rogan,

Actually, Evergreen does track a single, current barcode from the
patron record perspective.  There's a field on the actor.usr table
called card which points to the current user barcode.  That's what's
labeled Current Card in the User reporting source.

When scanning a card we have to look at the actor.card table (where
all user barcodes live), so we are looking at things from another
direction -- one that doesn't readily tell us which the user record
considers primary.

I hope that helps clarify the ... duality ... of cards in Evergreen. :)


On Fri, Mar 7, 2014 at 2:13 PM, Rogan Hamby rogan.ha...@yclibrary.net wrote:
 Just a warning, Evergreen doesn't actually have a concept of current or
 not-current though it has active and inactive.  I'm not familiar with what
 the reporter is drawing on there but I'm assuming it's looking for active
 cards and it is possible for a patron to have multiple active cards.




 On Fri, Mar 7, 2014 at 1:56 PM, Jessica Venturo - Bibliomation
 jvent...@biblio.org wrote:

 Hi Rose,

 There are two barcode sources under the ILS User source - one called All
 Barcodes and one called Current Barcode.  Use the Current Barcode source
 instead of the All Barcode source and you should be all set.

 Hope that helps!
 Jessica

 Jessica Venturo
 Applications Support Specialist
 Bibliomation, Inc.
 24 Wooster Ave.
 Waterbury, CT 06708
 203-577-4070 ext. 105

 - Original Message -
 From: Rose Schooff (LVA) rose.scho...@lva.virginia.gov
 To: open-ils-general@list.georgialibraries.org
 Sent: Friday, March 7, 2014 1:40:38 PM
 Subject: [OPEN-ILS-GENERAL] Primary Barcode in Reports

 I'm running an overdue report (from reports menu) and its giving me all of
 the barcodes that a patron may have.  I only want their primary barcode.  I
 thought I had it when I said active = true, but I still get duplicates -
 maybe because the system seems they all as active but one is marked as
 primary.  Help.  I've looked for primary = true - haven't found it yet.

 Rose M. Schooff
 Evergreen Virginia Project Manager
 Technology Consultant
 The Library of Virginia
 800 E. Broad Street
 Richmond, VA  23219
 (804) 692-3772
 Cell (804) 310-7901
 Skype: rose.whitman57




 --

 Rogan Hamby, MLS, CCNP, MIA
 Managers Headquarters Library and Reference Services,
 York County Library System

 You don't have to burn books to destroy a culture. Just get people to stop
 reading them.
 -- Ray Bradbury

 You can never get a cup of tea large enough or a book long enough to suit
 me.
 -- C.S. Lewis



-- 
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] Negative balances and void payment types

[Mike Rylander]

 the state where billings have been
acknowledged by a payment and do something other than voiding them, if
that's what should happen to that type of billing.  This keeps the
history simple (unacknowledged billings go away, but something else
can happen to acknowledged billings to avoid, if desirable to the
site, any negative balance for the patron).

Finally you have a sequence like this, in the current code:

1) item is checked out
2) item goes overdue
3) overdue billings accrue
4) item is declared lost by staff or the system in staff's stead
4a) overdue billings are voided
4b) lost charges of various types are applied, which are larger in
total than the overdue fines
5) patron pays off the various billings
6) item is found
6a) various lost charges are voided
6b) overdue billings are reinstated
7) patron suddenly has a negative balance on the transaction

There are many variations on this theme -- partial payments of all the
various billing totals, etc -- but this is the simplest to analyze,
and is representative.  Working under my refined definition of void,
the simplest transaction history would be to not voiding any of the
billings (they've all been acknowledged by payment, and so fail our
new voidable test), and instead apply an adjustment payment to bring
the balance down to zero, but not past it.  It would look something
like this:

1) item is checked out
2) item goes overdue
3) overdue billings accrue
4) item is declared lost by staff or the system in staff's stead
4a) overdue billings are voided
4b) lost charges of various types are applied, which are larger in
total than the overdue fines
5) patron pays off the various lost billings
6) item is found
6a) lost charges are left in place, because they have been acknowledged
6b) overdue billings are reinstated, because they have been acknowledged
6c) if the balance would go negative by voiding the various lost
billings (a patron credit), which we can obviously detect, an
adjustment payment is applied for up to the amount of the
would-be-voided billings to bring the balance to zero
7) patron has a 0 balance on the transaction at this time
(disregarding possible future billings that may occur, which would
bring the balance positive)

Constraining adjustments in this way extends and refines existing
functionality and definitions, instead of attempting to replace them,
and is much easier to get right in the code.  Put another way, this
covers the corner case without changing the common case, presents the
information you want (as in your screenshots) to the user in those
cases where it is necessary, and avoids breaking other dependent
subsystems.

It is my understanding that this is what Dan Wells' branch aims to do.
 His branch also leverages the majority of Jason's logical changes --
when, how, and to what degree the system should apply a balancing
payment -- but modifies Jason's code just to the degree that it avoids
removing functionality that exists today.

To sum up, I'm concerned for three major reasons, in this order:

 - the risk and cost to all existing users that rely on reports that
have been build, laboriously, over years
 - the risk of not getting things quite right with a reimplementation
of voiding as opposed to a less invasive extension of existing logic
 - unforeseen negative consequences to areas of the code that are not
often touched and have proved stable under current definitions and
workflows

I think Dan's offered branch should really be given a chance, because
it actively avoids these risks, and it seems to me that the middle
ground he has found fits MassLNC's goals to the best of my
understanding, and remains based, to a very degree, on Jason's
implementation.  In short, it seems the safest way forward.

Thanks for bearing with me ... I know this is long, and I don't want
it to sound as if simply trying to negate your points, or that I'm
dismissing Jason's work or MassLNC's testing and the consideration
you've personally put into this feature.  I really do think that a
balancing payment is a good way to go in the cases where we would
otherwise cause a negative balance but should not, and I appreciate
all the time that everyone on the LP bug has been putting into this to
make sure that the end result is the best overall solution.

Now I need to go rest, because my brain is leaking out of my ear.

-- 
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] Negative balances and void payment types

[Mike Rylander]

Thanks, Dan.

I see where my thinking went astray.  I was imagining (as a final
implementation) a design where we leverage the payment-by-billing-type
code to walk backwards through the line items of a transaction,
voiding anything with no payments  (where appropriate) until we hit a
billing with a payment, at which point we have to start using
balancing credits.  So, I was jumping to a version of your (2),
basically.

I think I agree with your assertion about overdues being adjusted
instead of voided -- that really is a credit the patron situation
which is separate from both credit (not card) and forgive payment
types.  Un-adjusting those billings when the item is found would
probably be best done as a void of the adjustment from a logical
standpoint, but simply deleting them might be easier to deal with.
Obviously, credit-style payments are the only kind that should be
delete-able, so perhaps a new level in the inheritance hierarchy
would be in order, which could also serve as the level at which the
billing link might be added to those credit type payments.  And now
I've digressed far into implementation details and should stop (on
this thread, at least) ... but, suffice it to say, I do certainly see
an internally self-consistent and manageable path forward to address
not just the specific issue of negative patron balances, but a host of
currently-circuitous workarounds and oddities with complex billing
situations.

My misunderstanding (and belief that (2) would be the ideal) aside,
and addressing your branch specifically with regard to the core point
of this discussion, I maintain that reimplementing void is the
primary danger -- for the reasons I listed up-thread -- and I really
want to see if my belief that your adjustments to Jason's work fill
the needs of MassLNC.  I'm pretty confident that they will, even more
so now that you've clarified that the adjust behavior does
effectively replace the current void behavior.

Again, thanks, Dan and all!


On Wed, Mar 5, 2014 at 5:10 PM, Dan Wells d...@calvin.edu wrote:
 Mike and Kathy, thanks for taking the time it took to craft your thorough 
 responses.  It really helps outline many of the areas of contention.

 I want to point out, though, that my current branch doesn't do quite what is 
 stated in Mike's email.  There are really three ways we could go when 
 applying the new logic:

 1) Always* do voids (old way)
 2) Do voids where you can, adjust where you need to (mixed way)
 3) Always* do adjustments (new way)

 My current code lets you pick between 1 and 3, rather than go the extra mile 
 and try to be context sensitive (the mixed way).  (*It also lets you set a 
 different always-ness for lost vs overdue, if desired.)  Not saying we 
 can't or shouldn't work in a direction where the code is context sensitive, 
 but it seemed like early adopters were putting a high value on sameness of 
 the transactions, so the first crack went that route.

 Also, I want to highlight something else about my branch which I noted in one 
 of my long comments on the LP bug:

  c) * The one place where the code now always adjusts (never voids) is for 
 overdue-lost behavior. Overdue fines are adjusted to zero (if the option is 
 on), not voided. I think this makes sense logically (they still happened, we 
 are just not charging for them), and it makes it much easier to accurately 
 reinstate these fines if the lost item is returned (if *that* option is on).

 Basically, I believe that voiding overdues when marking an item lost is a 
 grey area for our technical definition of void (especially if plan to 
 possibly reinstate them), so I took it the other direction in that one case.  
 This is primarily an implementation choice, and not particular crucial to the 
 discussion, but since it is used in a couple of Mike's examples, I wanted to 
 point it out.

 Thanks again,
 Dan



-- 
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] Evergreen 508 compliance

[Mike Rylander]

Edward,

The code at https://bugs.launchpad.net/evergreen/+bug/1268636
(sponsored by Natural Resources Canada, developed by Bill Erickson at
Equinox Software) will bring AA-level WCAG compliance to the OPAC in
2.6, which is scheduled for release some time in the next 6 weeks or
so.  A quick google search suggests* that this will cover Section 508
pretty much completely, but IANAL, and 508 is a legal issue, not a
technology one.

* http://www.tomjewett.com/accessibility/508-WCAG2.html


On Fri, Feb 14, 2014 at 7:57 PM, Edward Roms edr...@gmail.com wrote:
 I've been searching for a list of Evergreen accessibility features. Would
 someone have such a list handy? Either post or send it off list. I'm
 interested in the staff client specifically, but also need general facts.

 Thank you!



-- 
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] Emerald Data Networks, Inc. - Vendor Submission for Evergreen Companies Wiki Entry

[Mike Rylander]

I certainly don't speak for the web team, nor the rest of the
community, but I'm not sure that a link in a press release that's
embedded in news scroll is quite in keeping with the spirit of the
link-back requirement.



On Wed, Jan 22, 2014 at 7:21 AM, Michael Peters mpet...@emeralddata.net wrote:
 Emerald Data Networks, Inc.
 Contact:  Darrell Rodgers (drodg...@emeralddata.net) / 678.302.3000
 Web:  http://www.emeralddata.net

 There are plenty of IT firms ready to be your provider. Emerald clients
 realize they need more than a provider, they need a trusted technology
 partner.   Emerald Data Networks is prepared to be your partner in your
 endeavor into the Evergreen ILS world.  Emerald Data Networks provides a
 combined 19 years of experience with Evergreen ILS and is prepared to be
 your partner in technical support, data migrations, custom feature
 development, software upgrades, capacity planning, and more!

 Link Back:  See the Solutions Showcase scrolled on our home page at
 http://www.emeralddata.net

 Michael Peters
 Senior Systems Analyst
 Emerald Data Networks, Inc.
 Phone: 678.302.3000 x1013
 Help Desk: 678.302.3000 x1500
 www.emeralddata.net



-- 
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] Inconsistent/wrong search results when searching by location in TPAC

[Mike Rylander]

Sarah,

There may be implementation-specific tuning that would improve the
situation for you.  I'd recommend having your support vendor look into
that.  There are cases where large data sets need an index and small
ones do not, and we can't always predict where those will be or how to
define large in every case.  I would not be surprised if this was
one such case, but it's not guaranteed either.


On Wed, Jan 22, 2014 at 12:23 PM, Sarah Childs
sar...@zionsville.lib.in.us wrote:
 We experience the same thing when we try to narrow a search to a particular
 shelving location. It generally just times out. I assume that approach works
 for single installations of Evergreen, and perhaps even small consortiums,
 but it's basically worthless for us.

 ---
 Sarah Childs
 Technical Services Department Head
 Hussey-Mayfield Memorial Public Library
 250 North Fifth Street
 Zionsville, IN 46077
 317-873-3149 x13330
 sar...@zionsville.lib.in.us


 On 2014-01-21 20:55, Mike Rylander wrote:

 Justin,

 The reason that search is slow is that you're effectively asking the
 system to return all bib records, then pull up all their copies, then
 pull up those copies' shelving locations, and finally filter out
 records that do not have copies that do not have shelving locations in
 your list.  That is exactly the reason I built the new items
 functionality.

 With a little elbow grease, one could certainly use one of the many
 XML format output options available for use with the new items list to
 re-sort them however one would like, and display them exactly as one
 would wish.  Just try replacing html-full with atom or rss2.

 In fact, you could even use the OPAC to do the heavy lifting for you
 if you were to extract the record IDs from the XML new item feed and
 built a search using the record_list() filter and the sort(titlesort)
 operator.

 Perhaps, with likely less total effort, an opac format could be added
 to the new item list, along with support for additional query
 components (such as sorting) in the case of the opac format.  A simple
 redirect would do.

 A wishlist bug sounds like a good idea.  Perhaps time or funding will
 materialize.


 On Tue, Jan 21, 2014 at 6:21 PM, Holly Brennan haderh...@ci.homer.ak.us
 wrote:

 This improves the presentation and allows for title sorting but the
 search
 takes *forever* to return and the results are always way off and
 frequently
 do not return any results at all. Having just tried it, TPAC claims there
 are no results whatsoever. Two or three page refreshes later it turns up
 353
 items. According to the DB we have 1951 distinct bibs with items in those
 locations.



 Has anyone else seen this behavior? Is there an open bug on it? Should
 there
 be?



 Weird. We, too, use New Books as a location for searching. I just
 pulled
 up the whole batch of new adult books in our library (5,070 records)
 without
 a problem. It took maybe one second to load the page.



 I didn't find a delay using your search method, either.



 I know this is sort of non-information, but it could be helpful so I
 chimed
 in. Let us know if you solve the problem!



 -Holly







 Holly Brennan

 Library Technology Specialist

 Homer Public Library

 907-235-3180 (main)

 907-435-3154 (direct)

 hbren...@cityofhomer-ak.gov







 -Original Message-
 From: open-ils-general-boun...@list.georgialibraries.org
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
 Justin Hopkins
 Sent: Tuesday, January 21, 2014 12:56 PM
 To: Evergreen Discussion Group
 Subject: [OPEN-ILS-GENERAL] Inconsistent/wrong search results when
 searching
 by location in TPAC



 Hi guys,



 Like probably many others, we have noticed that Evergreen is lacking a
 really good new books feature. We've explored this:



 http://missourievergreen.org/opac/extras/browse/html-full/item-age/SRLWA



 The presentation of this option isn't very good though, and ideally we'd
 have the ability to sort by title.



 It just so happens that our library who is most interested in this has a
 shelving location at each of their branches called New Books. So we tried
 this approach using search syntax:




 http://missourievergreen.org/eg/opac/results?fi:item_type=query=locations(1307,1308,1309,1310,1311,1558,1559)+qtype=keywordlocg=174sort=titlesort)



 This improves the presentation and allows for title sorting but the
 search
 takes *forever* to return and the results are always way off and
 frequently
 do not return any results at all. Having just tried it, TPAC claims there
 are no results whatsoever. Two or three page refreshes later it turns up
 353
 items. According to the DB we have 1951 distinct bibs with items in those
 locations.



 Has anyone else seen this behavior? Is there an open bug on it? Should
 there
 be?

 Regards,

 Justin







 --
 Mike Rylander
  | Director of Research and Development
  | Equinox Software, Inc. / Your Library's Guide to Open Source
  | phone:  1-877-OPEN-ILS (673-6457

Re: [OPEN-ILS-GENERAL] Inconsistent/wrong search results when searching by location in TPAC

[Mike Rylander]

Justin,

The reason that search is slow is that you're effectively asking the
system to return all bib records, then pull up all their copies, then
pull up those copies' shelving locations, and finally filter out
records that do not have copies that do not have shelving locations in
your list.  That is exactly the reason I built the new items
functionality.

With a little elbow grease, one could certainly use one of the many
XML format output options available for use with the new items list to
re-sort them however one would like, and display them exactly as one
would wish.  Just try replacing html-full with atom or rss2.

In fact, you could even use the OPAC to do the heavy lifting for you
if you were to extract the record IDs from the XML new item feed and
built a search using the record_list() filter and the sort(titlesort)
operator.

Perhaps, with likely less total effort, an opac format could be added
to the new item list, along with support for additional query
components (such as sorting) in the case of the opac format.  A simple
redirect would do.

A wishlist bug sounds like a good idea.  Perhaps time or funding will
materialize.


On Tue, Jan 21, 2014 at 6:21 PM, Holly Brennan haderh...@ci.homer.ak.us wrote:
 This improves the presentation and allows for title sorting but the search
 takes *forever* to return and the results are always way off and frequently
 do not return any results at all. Having just tried it, TPAC claims there
 are no results whatsoever. Two or three page refreshes later it turns up 353
 items. According to the DB we have 1951 distinct bibs with items in those
 locations.



 Has anyone else seen this behavior? Is there an open bug on it? Should there
 be?



 Weird. We, too, use New Books as a location for searching. I just pulled
 up the whole batch of new adult books in our library (5,070 records) without
 a problem. It took maybe one second to load the page.



 I didn't find a delay using your search method, either.



 I know this is sort of non-information, but it could be helpful so I chimed
 in. Let us know if you solve the problem!



 -Holly







 Holly Brennan

 Library Technology Specialist

 Homer Public Library

 907-235-3180 (main)

 907-435-3154 (direct)

 hbren...@cityofhomer-ak.gov







 -Original Message-
 From: open-ils-general-boun...@list.georgialibraries.org
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of
 Justin Hopkins
 Sent: Tuesday, January 21, 2014 12:56 PM
 To: Evergreen Discussion Group
 Subject: [OPEN-ILS-GENERAL] Inconsistent/wrong search results when searching
 by location in TPAC



 Hi guys,



 Like probably many others, we have noticed that Evergreen is lacking a
 really good new books feature. We've explored this:



 http://missourievergreen.org/opac/extras/browse/html-full/item-age/SRLWA



 The presentation of this option isn't very good though, and ideally we'd
 have the ability to sort by title.



 It just so happens that our library who is most interested in this has a
 shelving location at each of their branches called New Books. So we tried
 this approach using search syntax:



 http://missourievergreen.org/eg/opac/results?fi:item_type=query=locations(1307,1308,1309,1310,1311,1558,1559)+qtype=keywordlocg=174sort=titlesort)



 This improves the presentation and allows for title sorting but the search
 takes *forever* to return and the results are always way off and frequently
 do not return any results at all. Having just tried it, TPAC claims there
 are no results whatsoever. Two or three page refreshes later it turns up 353
 items. According to the DB we have 1951 distinct bibs with items in those
 locations.



 Has anyone else seen this behavior? Is there an open bug on it? Should there
 be?

 Regards,

 Justin







-- 
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] Copy holds on individual magazines from OPAC

[Mike Rylander]

Chauncey,

You might also want to look at this old thread
(http://comments.gmane.org/gmane.education.libraries.open-ils.general/6051)
which discusses using issuance holds.  Issuance holds are used in
concert with serial units (which are essentially copies, but are
created at serial receive time) to request a hold on an issue that can
be filled by any copy (normal hold rules allowing).


On Thu, Jan 16, 2014 at 3:53 PM, Tina Ji (Project Sitka)
t...@sitka.bclibraries.ca wrote:
 We allow volume holds on our OPAC. Copy hold should be the same. You grant
 perm COPY_HOLD to the user groups and provide a link to placing copy hold on
 OPAC. You may check our OPAC https://catalogue.libraries.coop.

 Other people can correct me if I missed anything.

 Tina





 Quoting Chauncey Montgomery montg...@oplin.org:

 Is there a way to place copy holds on individual issues of magazines
 through the OPAC, without creating a unique record for each issue?
 Thanks in advance for feedback.
 CM
 --
 Chauncey G. Montgomery, MLIS
 Director/Fiscal Officer | Community Library
 44 Burrer Drive | Sunbury, OH 43074
 740-965-3901 | http://community.lib.oh.us




 Tina Ji
 1-888-848-9250
 Trainer/Help Desk Specialist
 BC Libraries Cooperative/Sitka





-- 
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] IMPORTANT: Postgres bug affecting Streaming Replication

[Mike Rylander]

UPDATE HAT TRICK:

Chris Sharp was the first to notice and mention the release of the
Postgres updates mentioned below.  Thanks, Chris!

Here's where you can download the update:
http://www.postgresql.org/about/news/1492/

Happy upgrading, folks!


On Sat, Nov 23, 2013 at 4:46 PM, Mike Rylander mrylan...@gmail.com wrote:
 UPDATE THE SECOND:

 The Postgres team is planning to wrap releases to fix this issue on
 Dec 2, for release on Dec 5.  The PGDG apt repos should have the
 package at that time, and I expect the debian and ubuntu repositories
 to follow shortly thereafter.  Please mark your calendars, if you're
 affected by this bug, and plan downtime to upgrade your servers ASAP
 after the release.  For the announcement to the pgsql-hackers list
 see: http://markmail.org/thread/qnye6rk37ug52zox

 --miker


 On Thu, Nov 21, 2013 at 3:55 PM, Mike Rylander mrylan...@gmail.com wrote:
 UPDATE

 I need clarify and correct the information below: this is not
 restricted streaming-replication based hot-standby replicas, it is for
 all hot_standby-enabled replicas (regardless of the mechanism used to
 ship the WAL data) when there is a recovery.conf in place. This is
 per: http://markmail.org/message/p6bcdo5h2ll4kk3k


 On Thu, Nov 21, 2013 at 1:35 PM, Mike Rylander mrylan...@gmail.com wrote:
 THE BAD NEWS:

 If your site uses Postgres' streaming replication to create a
 read-only hot-standby, such as for reporting or to support search
 capacity needs, this message is for you.

 On Nov, 18, a bug was reported to the Postgres hackers list that can
 cause extreme corruption of hot-standby secondary servers.  Known
 affected versions include 9.2.5 and 9.3.1.  It is likely that this
 goes as far back as 9.1.

 The nature of the bug is such that it is somewhat hard to provoke.
 However, it can occur at any standby startup if the secondary is in
 hot-standby mode, and not only during the initial secondary creation.
 In other words, every restart of a hot-standby secondary instance of
 Postgres is another chance to run afoul of this bug.  It is most
 likely to occur under high write load or situations where there is
 significant lag during standby startup.

 Symptoms include: missing data; apparently-duplicated data; mismatch
 between index and heap data; impossible constraint violations
 (unique and fkey).

 The underlying cause of these symptoms is a loss of proper transaction
 visibility information on the hot-standby secondary.

 THE GOOD NEWS:

 There is an apparent fix being tested now by several large Postgres
 entities.  It is expected that a point release for all affected
 versions will be made available ASAP.  Additionally, if you have
 already been bitten by the corruption bug, there is a straight-forward
 procedure for recover, which I am sure will be detailed in the release
 notes for the upcoming point releases.

 You can read the full thread from the pgsql-hackers mailing list here:
 http://markmail.org/message/p54pqkykjtwvog3h

 --
 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



 --
 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



 --
 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



-- 
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] IMPORTANT: Postgres bug affecting Streaming Replication

[Mike Rylander]

UPDATE THE SECOND:

The Postgres team is planning to wrap releases to fix this issue on
Dec 2, for release on Dec 5.  The PGDG apt repos should have the
package at that time, and I expect the debian and ubuntu repositories
to follow shortly thereafter.  Please mark your calendars, if you're
affected by this bug, and plan downtime to upgrade your servers ASAP
after the release.  For the announcement to the pgsql-hackers list
see: http://markmail.org/thread/qnye6rk37ug52zox

--miker


On Thu, Nov 21, 2013 at 3:55 PM, Mike Rylander mrylan...@gmail.com wrote:
 UPDATE

 I need clarify and correct the information below: this is not
 restricted streaming-replication based hot-standby replicas, it is for
 all hot_standby-enabled replicas (regardless of the mechanism used to
 ship the WAL data) when there is a recovery.conf in place. This is
 per: http://markmail.org/message/p6bcdo5h2ll4kk3k


 On Thu, Nov 21, 2013 at 1:35 PM, Mike Rylander mrylan...@gmail.com wrote:
 THE BAD NEWS:

 If your site uses Postgres' streaming replication to create a
 read-only hot-standby, such as for reporting or to support search
 capacity needs, this message is for you.

 On Nov, 18, a bug was reported to the Postgres hackers list that can
 cause extreme corruption of hot-standby secondary servers.  Known
 affected versions include 9.2.5 and 9.3.1.  It is likely that this
 goes as far back as 9.1.

 The nature of the bug is such that it is somewhat hard to provoke.
 However, it can occur at any standby startup if the secondary is in
 hot-standby mode, and not only during the initial secondary creation.
 In other words, every restart of a hot-standby secondary instance of
 Postgres is another chance to run afoul of this bug.  It is most
 likely to occur under high write load or situations where there is
 significant lag during standby startup.

 Symptoms include: missing data; apparently-duplicated data; mismatch
 between index and heap data; impossible constraint violations
 (unique and fkey).

 The underlying cause of these symptoms is a loss of proper transaction
 visibility information on the hot-standby secondary.

 THE GOOD NEWS:

 There is an apparent fix being tested now by several large Postgres
 entities.  It is expected that a point release for all affected
 versions will be made available ASAP.  Additionally, if you have
 already been bitten by the corruption bug, there is a straight-forward
 procedure for recover, which I am sure will be detailed in the release
 notes for the upcoming point releases.

 You can read the full thread from the pgsql-hackers mailing list here:
 http://markmail.org/message/p54pqkykjtwvog3h

 --
 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



 --
 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



-- 
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

[OPEN-ILS-GENERAL] IMPORTANT: Postgres bug affecting Streaming Replication

[Mike Rylander]

THE BAD NEWS:

If your site uses Postgres' streaming replication to create a
read-only hot-standby, such as for reporting or to support search
capacity needs, this message is for you.

On Nov, 18, a bug was reported to the Postgres hackers list that can
cause extreme corruption of hot-standby secondary servers.  Known
affected versions include 9.2.5 and 9.3.1.  It is likely that this
goes as far back as 9.1.

The nature of the bug is such that it is somewhat hard to provoke.
However, it can occur at any standby startup if the secondary is in
hot-standby mode, and not only during the initial secondary creation.
In other words, every restart of a hot-standby secondary instance of
Postgres is another chance to run afoul of this bug.  It is most
likely to occur under high write load or situations where there is
significant lag during standby startup.

Symptoms include: missing data; apparently-duplicated data; mismatch
between index and heap data; impossible constraint violations
(unique and fkey).

The underlying cause of these symptoms is a loss of proper transaction
visibility information on the hot-standby secondary.

THE GOOD NEWS:

There is an apparent fix being tested now by several large Postgres
entities.  It is expected that a point release for all affected
versions will be made available ASAP.  Additionally, if you have
already been bitten by the corruption bug, there is a straight-forward
procedure for recover, which I am sure will be detailed in the release
notes for the upcoming point releases.

You can read the full thread from the pgsql-hackers mailing list here:
http://markmail.org/message/p54pqkykjtwvog3h

-- 
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] IMPORTANT: Postgres bug affecting Streaming Replication

[Mike Rylander]

UPDATE

I need clarify and correct the information below: this is not
restricted streaming-replication based hot-standby replicas, it is for
all hot_standby-enabled replicas (regardless of the mechanism used to
ship the WAL data) when there is a recovery.conf in place. This is
per: http://markmail.org/message/p6bcdo5h2ll4kk3k


On Thu, Nov 21, 2013 at 1:35 PM, Mike Rylander mrylan...@gmail.com wrote:
 THE BAD NEWS:

 If your site uses Postgres' streaming replication to create a
 read-only hot-standby, such as for reporting or to support search
 capacity needs, this message is for you.

 On Nov, 18, a bug was reported to the Postgres hackers list that can
 cause extreme corruption of hot-standby secondary servers.  Known
 affected versions include 9.2.5 and 9.3.1.  It is likely that this
 goes as far back as 9.1.

 The nature of the bug is such that it is somewhat hard to provoke.
 However, it can occur at any standby startup if the secondary is in
 hot-standby mode, and not only during the initial secondary creation.
 In other words, every restart of a hot-standby secondary instance of
 Postgres is another chance to run afoul of this bug.  It is most
 likely to occur under high write load or situations where there is
 significant lag during standby startup.

 Symptoms include: missing data; apparently-duplicated data; mismatch
 between index and heap data; impossible constraint violations
 (unique and fkey).

 The underlying cause of these symptoms is a loss of proper transaction
 visibility information on the hot-standby secondary.

 THE GOOD NEWS:

 There is an apparent fix being tested now by several large Postgres
 entities.  It is expected that a point release for all affected
 versions will be made available ASAP.  Additionally, if you have
 already been bitten by the corruption bug, there is a straight-forward
 procedure for recover, which I am sure will be detailed in the release
 notes for the upcoming point releases.

 You can read the full thread from the pgsql-hackers mailing list here:
 http://markmail.org/message/p54pqkykjtwvog3h

 --
 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



-- 
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

[OPEN-ILS-GENERAL] Evergreen 2.4.4 release candidate uploaded

[Mike Rylander]

Hi All,

The release candidate for Evergreen 2.4.4 is now available for download.

http://evergreen-ils.org/downloads/previews/Evergreen-ILS-2.4.4.tar.gz
http://evergreen-ils.org/downloads/previews/Evergreen-ILS-2.4.4.tar.gz.md5
http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.4_i686.tar.bz2
http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.4_i686.tar.bz2.md5
http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.4_x86_64.tar.bz2
http://evergreen-ils.org/downloads/previews/evergreen-client-2.4.4_x86_64.tar.bz2.md5
http://evergreen-ils.org/downloads/previews/evergreen-setup-2.4.4.exe
http://evergreen-ils.org/downloads/previews/evergreen-setup-2.4.4.exe.md5
http://evergreen-ils.org/downloads/previews/ChangeLog-2.4.3-2.4.4

There is a release branch in the working repo at user/miker/rel_2_4_4 .

Thanks,

-- 
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