Re: [OPEN-ILS-GENERAL] Scannable barcode font in web client receipts
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
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
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
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
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
Re: [OPEN-ILS-GENERAL] Bills Paid by Staff Login
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
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
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
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 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?
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 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
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 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&show=all&search=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&show=all&search=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 : >> >> 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 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 on
Re: [OPEN-ILS-GENERAL] Fixed-field elements mnemonic names translations
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 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.
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 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
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
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 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
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
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 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
> ] *On Behalf Of *Josh
> Stompro
> *Sent:* Thursday, December 07, 2017 11:47 AM
> *To:* 'Evergreen Discussion Group' 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 was sent to the vendor
> (basically the entire patron record was sent which wasn’t great), but it
> did take care of this iss
Re: [OPEN-ILS-GENERAL] Catalog holds status display - Hold queue and potential copies
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 georgialibraries.org>; ME list serv > *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&entry=gmail&source=g> > > Union, MO > <https://maps.google.com/?q=308+Hawthorne+Drive%0D+%0D+%0D+Union,+MO+%C2%A0+%C2%A0+63084&entry=gmail&source=g> > 63084 > <https://maps.google.com/?q=308+Hawthorne+Drive%0D+%0D+%0D+Union,+MO+%C2%A0+%C2%A0+63084&entry=gmail&source=g> > > (636) 583-3224 > > > > On Mon, Nov 27, 2017 at 4:28 PM, Josh Stompro > 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
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 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
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 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 > 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
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 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
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 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
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 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
Terran, Hrm... Renewal seems to work fine. You just scan an item that's already checked out and it figures out that a renewal is in order and available. Also, just as a note, the UI got a nice update about a year ago to add the ability to email receipts, including using patron defaults for that. HTH, -- 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:51 AM, Terran McCanna 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 > 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] Evergreen Self-Check and locking media cases
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 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 > 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 >> 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
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 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
open-ils-general@list.georgialibraries.org
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
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
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 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 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
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 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
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 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 > ] *On Behalf Of *Josh > Stompro > *Sent:* Wednesday, March 01, 2017 10:41 AM > *To:* Evergreen Discussion Group 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 > ] *On Behalf Of *Josh > Stompro > *Sent:* Wednesday, March 01, 2017 9:19 AM > *To:* open-ils-general@list.georgialibraries.org > *Subject:* [OPEN-ILS-GENERAL]
Re: [OPEN-ILS-GENERAL] Slowness/freezing with XUL staff client
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 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
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 > >
[OPEN-ILS-GENERAL] Evergreen 2.11 is here!
On behalf of the build-master team and myself, I am pleased to announce the release of Evergreen 2.11.0. Included in Evergreen 2.11.0 are the following new features: * Add Date Header to Action Trigger Email/SMS Templates * Support for Ubuntu 16.04 * Purge User Activity * Authority Record Import Updates Editor, Edit Date. * Authority Propagation Updates Bib Editor, Edit Date * Bibliographic Record Source Now Copied to 901$s * Option to Update Bib Source and Edit Details on Record Import * Staff Client Honors Aged Circulations * "Canceled Transit" Item Status * Copy Status "Is Available" Flag * Email Checkout Receipts * Set Per-OU Limits on Allowed Payment Amounts * Additional Fields Available for Display in Some Interfaces * Merge Notification Preferences Tables in TPAC * Improved Holds Screens in My Account * Popularity Boost for Ranking Search Results * Badge Configuration * Removal of Advanced Hold Options link when part holds are expected * SIP Renewals * Treat SIP Location Field as Login Workstation These, along with dozens of bug fixes and updates to documentation, are the result of work by more than thirty individuals at over 15 organizations. Please see the Evergreen download page[1] for source and staff client packages. [1] https://evergreen-ils.org/egdownloads/ -- 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] Evergreen 2.11 proposed release schedule
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 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 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
[OPEN-ILS-GENERAL] Evergreen 2.11 beta
All, Dan Wells, build master extraordinaire, has put together a fresh tarball containing the beta effort of Evergreen 2.11, and it is available for download[1] now. The 2.11 release includes many bug fixes and enhancements, and several cool new features, the full details of which you can see in the release notes[2] and change log[3]. Some highlights are: * Improved email date handling * Authority update improvements * The result of remote transit abort is now less confusing for staff * Ability to email receipts at desk checkout and self-checkout * Lots of My Account UI improvements * Record Badges (popularity ranking) * SIP driver improvements * Massive updates to translations Thanks to everyone working to make the 2.11 release great. Keep up the good work. Committers, don't hesitate to merge signed-off bug fixes. If there's any question as to whether something is a bug fix or a feature, please ask! Those of you without the commit bit, there's much you can do as well. If you'd like to help out over the next weeks as we march toward 2.11.0, please download the tarball and give it a test drive! If you can also test and sign-off fixes, that is extremely helpful. Next Wednesday marks our cut off for Release Candidate, so if you have new bug fixes to create, you have a week and a day to get them tested and committed. After that, it will be critical bug fixes only! Thanks, everyone! [1] https://evergreen-ils.org/egdownloads/ [2] https://evergreen-ils.org/documentation/release/RELEASE_NOTES_2_11.html [3] https://evergreen-ils.org/downloads/ChangeLog-2.10.6-2.11.beta -- 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] Evergreen 2.11 proposed release schedule
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 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
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 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 > 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 > 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
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" 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 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
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
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 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 > 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
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 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 > 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] Searchable Copy Notes
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
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" 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 > 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 > 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
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 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
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 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 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
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 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 o
Re: [OPEN-ILS-GENERAL] Custom Org Unit Trees
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 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?
On Mon, Jan 18, 2016 at 9:19 AM, Galen Charlton wrote: > Hi, > > On Sun, Jan 17, 2016 at 1:19 PM, Ken Cox 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&T 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?
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 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 > 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
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 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 > > 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" : > > > 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 : > > > >> 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.org<mailto: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?
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 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=author&locg=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 > > Subject: Re: [OPEN-ILS-GENERAL] Full author date on individual titles? > > Hi, > > On Wed, Jul 29, 2015 at 12:19 PM, Tony Bandy 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
Josh, When you see this happen again, please try `lsof -n -P -p ` (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 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 ) > > > > /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?
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 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 int
Re: [OPEN-ILS-GENERAL] bookbagupdate.pl
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 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=2&ik=5c407d8536&view=att&th=14e535e0a96451ed&attid=0.2.3.0.1&disp=safe&realattid=f_ibng8sen0&zw>
>
> 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 RECORD>0 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 RECORD>0 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 RECORD>0 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
> RECORD>0 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
Hi Johnnie, On Wed, Jul 1, 2015 at 4:22 PM, Pippin, Johnnie 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 > To: Evergreen Discussion Group > > 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 > 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 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 > >>
Re: [OPEN-ILS-GENERAL] GOKb
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" 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] OpenSearch Question
Jim, Kathy is correct. The "-" is a placeholder for an org unit ID. I believe an org shortname will work there, too. Regards, Mike Rylander -- Sent from my phone, please pardon my thumbs. On Jun 19, 2015 4:57 PM, "Jim Taylor" wrote: > Will give it a go. Thanks. > > > > Jim > > > > *From:* Open-ils-general [mailto: > open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Kathy > Lussier > *Sent:* Friday, June 19, 2015 3:52 PM > *To:* open-ils-general@list.georgialibraries.org > *Subject:* Re: [OPEN-ILS-GENERAL] OpenSearch Question > > > > Hi Jim, > > I think if you can do so in this format: > > > http://evergreen.server.xxx/opac/extras/opensearch/1.1/ORGID/marcxml-full/title/faith+hope+love?count=100 > <http://evergreen.server.xxx/opac/extras/opensearch/1.1/-/marcxml-full/title/faith+hope+love?count=100> > > where ORGID is the id of the org unit you are restricting to. > > It seemed to work on one of our systems. > > Kathy > > On 06/19/2015 04:37 PM, Jim Taylor wrote: > > Before I give up, after much searching and reading, and assume the answer > is “No”…Is there a way to restrict a search like the one below to a > particular library or library Node? > > > > > http://evergreen.server.xxx/opac/extras/opensearch/1.1/-/marcxml-full/title/faith+hope+love?count=100 > > > > Thanks. > > > > Jim > > > > -- > > Kathy Lussier > > Project Coordinator > > Massachusetts Library Network Cooperative > > (508) 343-0128 > > kluss...@masslnc.org > > Twitter: http://www.twitter.com/kmlussier > >
Re: [OPEN-ILS-GENERAL] Multi-Valued Fields in the wild
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 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
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 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
+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 wrote: > +1 > > On Sat, May 16, 2015 at 1:57 PM, Bill Erickson wrote: > > +1 > > > > On Sat, May 16, 2015 at 1:18 PM, Galen Charlton > wrote: > >> > >> Hi, > >> > >> On Sat, May 16, 2015 at 8:45 AM, Kathy Lussier > >> 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
On Fri, Mar 13, 2015 at 4:00 PM, Ben Shum 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 > 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" > >> 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
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 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" > > 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
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 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
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 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 > 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
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 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 > 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 >> 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 >> wrote: >> >> >> >> >> >> *From:* Open-ils-general [ >> mailto: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
Re: [OPEN-ILS-GENERAL] Displaying patron information for checked out books
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 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 > wrote: > >> Hi, >> >> On Wed, Feb 4, 2015 at 9:55 AM, Rogan Hamby >> 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
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 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=keyword&locg=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 > 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=and&qtype=keyword&contains=contains&query=*&bool=and&qtype=title&contains=contains&query=&bool=and&qtype=author&contains=contains&query=&_adv=1&locg=4%3A2&pubdate=is&date1=&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
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 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=and&qtype=keyword&contains=contains&query=&bool=and&qtype=title&contains=contains&query=&bool=and&qtype=author&contains=contains&query=weber%2C+david&_adv=1&fi%3Aaudience=+%2Ce%2Cf%2Cg&locg=1&pubdate=is&date1=&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=and&qtype=keyword&contains=contains&query=&bool=and&qtype=title&contains=contains&query=&bool=and&qtype=author&contains=contains&query=weber%2C+david&fi%3Aaudience=+%2Ce%2Cf%2Cg&locg=1&pubdate=is&date1=&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=and&qtype=keyword&contains=contains&query=&bool=and&qtype=title&contains=contains&query=&bool=and&qtype=author&contains=contains&query=weber%2C+david&_adv=1&fi%3Aaudience=e&locg=1&pubdate=is&date1=&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
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=keyword&locg=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 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=and&qtype=keyword&contains=contains&query=*&bool=and&qtype=title&contains=contains&query=&bool=and&qtype=author&contains=contains&query=&_adv=1&locg=4%3A2&pubdate=is&date1=&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
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 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, 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
Re: [OPEN-ILS-GENERAL] Results list of the "Call Number (Shelf Browse)" list
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 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 > ] *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 > ] *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
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
On Thu, Dec 18, 2014 at 4:42 PM, Bill Erickson wrote: > > On Thu, Dec 18, 2014 at 2:20 PM, Mike Rylander > wrote: >> >> On Thu, Dec 18, 2014 at 12:11 PM, Bill Erickson >> wrote: >>> >>> >>> On Thu, Dec 18, 2014 at 8:29 AM, Mike Rylander >>> 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
On Thu, Dec 18, 2014 at 12:11 PM, Bill Erickson wrote: > > > On Thu, Dec 18, 2014 at 8:29 AM, Mike Rylander > 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 >> 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 >>> t
Re: [OPEN-ILS-GENERAL] 2.8 release scheduling
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? 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... 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 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] Acq - Copy location UI scoped to registered workstation
Blake, I didn't see if this was already asked and answered elsewhere and I don't know if it will help in the ACQ interfaces, but, did you give the user in question multiple working locations via the user permission editor? 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, Dec 11, 2014 at 11:19 AM, Blake Henderson < bl...@mobiusconsortium.org> wrote: > Hello all, > > I apologize for the duplicate email, I sent this to the dev list and it > was suggested that I send it to the general list: > > I couldn't find a bug on this. We are using acq for the first time and I > don't want to jump to any conclusions. When creating a PO and assigning > the copies to their branches and copy locations, we noticed that the UI > only shows the copy locations for the branch that you happen to be > registered to. We have a scenario where a single branch is doing all of > the PO's for all of the sibling branches. Are we doing something wrong? > During some experimenting, I found that if you register the user to the > system level instead of the branch level, it will show all of the copy > locations for each branch. That, of course, is not a good idea for other > reasons. We ruled permissions out by assigning the EVERYTHING^consortium > to the user. > > It seems like if the software allows the copies to be assigned to > different branches, it should also allow copies to get assigned to the > respective shelving location in that branch. > > -- > -Blake- > Conducting Magic > MOBIUS > > >
Re: [OPEN-ILS-GENERAL] Retrieving no results using Bib Call Number search
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 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" > > 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
On Thu, Oct 2, 2014 at 1:58 PM, Kathy Lussier 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 SC
Re: [OPEN-ILS-GENERAL] [OPEN-ILS-DEV] Web Client (Sprint 1) demo - initial testing results
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
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 wrote: > > > On Tue, Sep 16, 2014 at 2:22 AM, Liam Whalen < > liam.wha...@bc.libraries.coop> wrote: > > > > >> 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
en vendor listing >> just because he/she doesn't have an Evergreen services page? >> >> Admittedly, I was one of the first people to say "required" when the EOB >> had the required vs. suggested discussion, but, at this time, I'm leaning >> towards not requiring. Many thanks to Chris for sharing his thoughts and >> making me look at the question in another light. >> >> 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 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 >> 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
Re: [OPEN-ILS-GENERAL] [OPEN-ILS-DEV] Web Client (Sprint 1) demo server
Terran, Grace is out for the next few days, so in the interest of avoiding duplication of work, I'll ask that we hold off picking a particular direction until she can weigh in next week. More broadly, while they are certainly "ESI's to fix", we'd be overjoyed if folks outside ESI wanted to jump in and attack some of these! The existing launchpad bug where Bill published the main branch would be the place for folks to post fix branches. Since there's still discussion to be had around several (and email seems a good way for that to happen in the short term) we'll wait for some more feedback before moving on some of them. We (ESI) use internal tools for tracking work in development and PM areas that fit our needs better than launchpad, so we'll continue to use those tools (along side launchpad, where appropriate) for both these and any future bugs we need to address in the web staff client and then expose the output of that in a straightforward way as it progresses, much the way Bill did during the main body of Sprint 1. Rest assured, I've got this thread starred and marked "unread" in my inbox, so these are not going anywhere. ;-) Thanks, On Thu, Aug 28, 2014 at 1:13 PM, McCanna, Terran < tmcca...@georgialibraries.org> wrote: > This sounds good to me, Kathy. > > Grace, will that work for the developers? And if so, should I work on > entering the ones I already pinpointed, or just new ones from here on out? > > > Terran McCanna > PINES Program Manager > Georgia Public Library Service > 1800 Century Place, Suite 150 > Atlanta, GA 30345 > 404-235-7138 > tmcca...@georgialibraries.org > > - Original Message - > From: "Kathy Lussier" > To: "Evergreen Development Discussion List" < > open-ils-...@list.georgialibraries.org>, "Evergreen General Discussion > List" > Sent: Wednesday, August 27, 2014 2:25:42 PM > Subject: Re: [OPEN-ILS-DEV] Web Client (Sprint 1) demo server > > > We've had some great discussion and feedback on the web client over the > past few days. > > To help the developers track the issues with the web client, would it be > better if we submit these issues via Launchpad as we do with other bug > reports? Maybe we can use a webclient tag so that they are easily findable. > > Kathy > Kathy Lussier > Project Coordinator > Massachusetts Library Network Cooperative > (508) 343-0128 kluss...@masslnc.org Twitter: > http://www.twitter.com/kmlussier #evergreen IRC: kmlussier On 8/27/2014 > 1:00 PM, James Keenan wrote: > > > > > > Re: display of the patron edit screen. > > > > The frame that the patron edit screen is displayed in can cause the Save > and Clone box to cover other buttons or parts of textboxes. > > > > Jim > > > > > Jim Keenan > > Library Applications Supervisor > > jkee...@cwmars.org > > 508-755-3323 x23 > > > > C/W MARS > > 67 Millbrook St., Suite 201 > > Worcester, MA 01606 > > > > P Save a tree! Please don't print this e-mail unless it's really necessary. > > Currently reading Mistress Bradstreet by Charlotte Gordon > -- 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)
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 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
0128kluss...@masslnc.org > Twitter: http://www.twitter.com/kmlussier > > On 7/29/2014 8:25 AM, Donald Butterworth 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 > > > > -- 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
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. > > 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] Installation question / comments
gt; My comments and questions. Bear in mind I'm not a linux expert. >> >> 1) Without Blake's guides I would not gotten past step 2 Installing >> Prerequisites. >> Step by step commands are very helpful. >> >> 2) Any idea why Ubuntu 12.04 gave so many problems ? >> >> 3) Did the 'precise' substitution work ? >> Will (or should) the install file have 'trusty' added ? >> >> 4) Why is a file looking for the apache version when, I think, apache is >> really installed with evergreen ? >> Or did the precise substitution cause this ? >> >> 5) Any suggestions? >> >> Thanks for your support >> >> -- >> R. W. (Bob) Neeper >> Community Library <http://sunbury.cool-cat.org> >> 44 Burrer Dr. Map <http://maps.google.com/maps?q=40.243961,+-82.863007> >> Sunbury, Oh 43074 >> Tel: (740)-965-3901 >> >> cool-cat.org <http://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
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 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
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 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 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 p
Re: [OPEN-ILS-GENERAL] 2.5.2 Subject Browse Index
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
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
iors. > Doing so would create a tremendous opportunity for improving the overall > usability of the staff client as a whole. > > > > I could say more, but I’ve said a lot already. I’d love to hear reactions > to what I’ve said so far (which I know is very uneven given the time and > space limitations). Am I way 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 > () 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
On Thu, May 15, 2014 at 9:37 AM, Martha Driscoll 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
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 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
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 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]
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 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
[OPEN-ILS-GENERAL] 2.4.7 Available for testing
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] Call for vote: Release Manager 2.7
+1 On Mon, Apr 21, 2014 at 12:01 PM, Jeff Godin 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
Re: [OPEN-ILS-GENERAL] View Holds Screen
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 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 > 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?
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 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 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 >> 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
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 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 > 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)" >> 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
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 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] Negative balances and void payment types
uot;void" as follows: * A billing event should never have been recorded, because it does not match reality, AND the billing event has not been acknowledged as valid by virtue of the existence of payments against it. However, even though it is not acknowledged by payments, we will retain the fact that we recorded it while ignoring its effect. This presents a problem, because there is no hard link between a billing and the payment that acknowledges it. This is partially addressed from a logical perspective in some code Jeff Godin and I have offered, but that is not in the mainline, so we can't rely on it (without incorporating it) in development. Let's assume, though, for a moment in this thought experiment that it is in place. That code would allow us to identify 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] Evergreen 508 compliance
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 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
