Re: [OPEN-ILS-GENERAL] Hoopla SSH SIP setup
Hello, I just wanted to report back that we did get SIP2 tunneled over SSH setup with Hoopla. The only roadblock was that they don't support key auth for SSH. Once we allowed password ssh auth things fell into place. They do support the standard SSH forwarding. I used this article as a guide on setting up a forwarding only ssh user, and that worked fine for the setup on our end. https://askubuntu.com/questions/48129/how-to-create-a-restricted-ssh-user-for-port-forwarding Josh On Wed, Mar 11, 2020 at 7:36 PM Josh Stompro wrote: > Hello, I've been working with Hoopla staff to setup authentication via > sip2, and it seems like they support running the sip2 connections over > SSH. But they are stuck at telling me specifics of how they require the > SSH be setup. > > They say they don't support SSH forwarding, so I'm wondering if I'm > supposed to do something like use netcat as the shell to connect to the > sip2 port? > > They also say they don't support ssh key auth. So I'm hopeful another > Evergreen institution that has sip2 auth with them, running over SSH, can > tell me how to setup my end. > > Thanks > Josh > > -- > Josh Stompro - IT Director > Lake Agassiz Regional Library > Desk: 218-233-3757 Ext 139 > Cell: 218-790-2110 > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] Adding series info to brief display, along with moving it in summary
Hello, I just wanted to report back that Anna Goben showed me how they solved this issue at Evergreen Indiana. She said Jason Boyer authored the fix. Thanks to you both for you! I've put our changes in this working git repo in case others run into this and want to see examples. https://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/stompro/series_prominent_display This adds series info to the results screen and puts it up front on the record screen. We want to make it easy for customers to find the next book in a series, so we have been adding the series index number to the title, but we have wanted to get away from that by showing the series info more prominently. Thanks Josh On Mon, Mar 26, 2018 at 8:12 AM Josh Stompro wrote: > > 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, as anyone added the series information to the brief record display > or moved where the series info is in the record summary screen? We would > like to place the series info below the title on the brief record display > (search results) and move it from the bottom of the page to right below the > title in the record summary. > > 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 > > > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] HTML Email Notices
Hello, I believe I've heard of libraries sending out HTML formatted email notices (Hold pickup, Overdue, Courtesy, etc..). Could someone share one of their action_trigger templates with me to help me get started please. Are you sending out a text version and an html version of the message in the same email? Or is that not necessary anymore? Thanks Josh -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] Curbside Delivery Scheduling Ideas
Hello, has anyone come across a great system for scheduling curbside pickup slots that has some Evergreen integration? We have been looking at a couple of different wordpress[1] plugins to let customers sign up for pickup scheduling slots, but it would be great if there was something that tied the evergreen account & holds in with the scheduling. 1. WP Amelia (https://wpamelia.com/) and Simply Schedule Appointments ( https://simplyscheduleappointments.com/) Thanks Josh -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] Hold Targeter - Ignore Closing logic change?
Hello, we have been doing curbside pickup, along with using the emergency closing handler to mark all of our locations closed. I was just told that some holds have not been targeting the local copies... which led me to notice that the expected item was getting skipped with a log entry of "skipping copy X at closed org". That led me to see that we had the following Library Settings set. Target copies for a hold even if copy's circ lib is closed = True Target copies for a hold even if copy's circ lib is closed IF the circ lib is the hold's pickup lib = False Now, with the old targeter, this seemed to work fine because the second setting was checked, and if it was false the first setting was checked as a fallback. (Could someone check my interpretation of the old logic though.) https://github.com/evergreen-library-system/Evergreen/blob/7f48513889098e47ee4a9d1b7cdbf5d5fe2ca8bb/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm#L1362 The new targeter doesn't seem to have the same fallthrough logic. If the circ_lib matches the pickup lib then only the circ.holds.target_when_closed_if_at_pickup_lib setting is checked. https://github.com/evergreen-library-system/Evergreen/blob/47f5ddaa8b029d41c710255380260614ef7ea6ae/Open-ILS/src/perlmods/lib/OpenILS/Utils/HoldTargeter.pm#L705 I would think this would have caused more havok than it did, but I found that because of bug 1868837, in many cases the local copy was still being selected, so there were still quite a few items being pulled for customers at the same location. https://bugs.launchpad.net/evergreen/+bug/1868837 I don't know if this behavior change is really a bug or not. It made sense to me that the circ.holds.target_when_closed would take effect if the circ.holds.target_when_closed_if_at_pickup_lib setting was set to false, but the current way is perhaps clearer since you don't have to know about the fallthrough behavior. After I changed the circ.holds.target_when_closed_if_at_pickup_lib setting to true and reset all the holds and retargeted, everything again works as expected. Josh -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] Curbside Delivery & Similar - sharing ideas
Hello Everyone, I'm wondering if those of you that have tried curbside delivery & similar services, or those that have started planning for it but haven't tried yet could share your experiences and documents. It isn't something that we have ever done before, and I'm not sure if we will try it. But I want to try and be prepared in case it does come up. I'm curious if you rely on customers having cell phones to call when they drive up? Or if you have someone outside just taking orders? Anyone use something like a wireless intercom, baby monitor, ring camera, etc. We have many one person rural libraries, so I'm curious how things work with just having one person, vs having several employees. Thanks Josh -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] Hoopla SSH SIP setup
Hello, I've been working with Hoopla staff to setup authentication via sip2, and it seems like they support running the sip2 connections over SSH. But they are stuck at telling me specifics of how they require the SSH be setup. They say they don't support SSH forwarding, so I'm wondering if I'm supposed to do something like use netcat as the shell to connect to the sip2 port? They also say they don't support ssh key auth. So I'm hopeful another Evergreen institution that has sip2 auth with them, running over SSH, can tell me how to setup my end. Thanks Josh -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] Wordpress Bookshelf/cover art plugin with Evergreen support
Hello, a recent version of wordpress (5.3) fixed an issue that made it hard to use the wordpress rest API to update bookshelves, so now it is possible to update the library bookshelves with a simple http post request. So you can run a script on one of your evergreen servers that updates any number of new book lists on wordpress sites. An example of how we use it is at https://larl.org/books-movies-more/ Currently a few changes need to be made to the plugin (as of version 4.9), I've documented the changes, and added some setup notes, and the script we use the create new lists and submit them at https://gist.github.com/stompro/ffc3ad86cf7905b111dd7508882d936d The plugin can be found at https://wordpress.org/plugins/library-bookshelves/#developers My scripts assume you are using the Evergreen (Record) mode, so the lists are in bib.record.id format. My example script also tries to check to see if cover art exists, and excludes records that don't seem to have cover art. If you use "No Coverart" placeholder images, you may need to adjust the script to detect those. Josh On Thu, Nov 29, 2018 at 2:38 PM Josh Stompro wrote: > Hello, I just wanted to mention a wordpress plugin that we have been using > with our new web site that has support for Evergreen built in. If you need > to display book carousels on a wordpress site, please give it a look. We > are using it on our new releases page - > https://larl.org/books-movies-more/ > > > > The developer was able to quickly add Evergreen support when we enquired, > and the newly released version includes the ability to specify the > bookshelf items by evergreen bibid number. It also supports grabbing the > coverart directly from evergreen as well as grabbing it from the various > added content providers. > > > > https://wordpress.org/plugins/library-bookshelves/ > > > > This plugin currently requires that the lists of ISBNs/UPCs be entered for > each list, so we just update them once a week manually. I’m trying to get > the wordpress rest API working so we can push updates to the lists from our > evergreen server. It doesn’t support grabbing data via RSS. > > > > Josh > > > > Lake Agassiz Regional Library - Moorhead MN larl.org > > Josh Stompro | Office 218.233.3757 EXT-139 > > LARL IT Director | Cell 218.790.2110 > > > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] Holds / Circulation question
Hello Stuart, The checkout circ_lib gets set to the org unit of the workstation that performs the checkout. So in your example, the checkout circ_lib = LibraryB. The copy circ_lib and owning_lib can tell you where the copy is from, so you can also report where the copies came from in your reports. We use floating, so our copy circ_libs change when a copy lands at another branch that it floats to, but the copy owning_lib stays as the original location the copy was assigned to. Josh On Wed, Mar 4, 2020 at 8:11 AM Forrest, Stuart wrote: > Hi > > > > This may sound a simple question to some, but my brain seems unwilling to > compute! > > > > So if a book that has been placed on hold that has a Circulating Library > of ‘LibraryA’ is then transitted to ‘LibraryB’ where the hold is being > fulfilled. Does the circulating library temporarily change to ‘LibraryB’ so > that library gets the circulation? I’m thinking of circ reports now. Or > would it be better to use Checkout Library instead to capture all > circulations at ‘LibraryB’ > > > > Hopes this makes sense to someone as I am not quite understanding it. > > > > Thanks > > Much > > Stuart > > > > > -- > > Stuart Forrest, Library IT Manager/Analyst Beaufort County Library System > > 311 Scott Street, Beaufort, SC 29902 > > 843 255 6450 > > sforr...@bcgov.net > > beaufortcountylibrary.org > > > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] Self Check login
Hello Millissa, You can add the username and password as arguments to the URL, along with the workstation. Example: https:// [hostname]/eg/circ/selfcheck/main?ws=orgname-computer=selfcheck1=selfcheck1pw Note: you will want to make sure the URL bar is disabled in your browser, so users cannot see the initial URL. We use openKiosk for our self check and catalog stations. http://openkiosk.mozdevgroup.com/ There is going to be a self check round table at the conference this year. https://eg2020.sched.com/event/ZkPq/evergreen-self-check-round-table On Thu, Feb 13, 2020 at 7:09 PM Millissa Macomber < millis...@burlingtonwa.gov> wrote: > We are using the Evergreen self check. We have two touchscreen computers > that we are running in kiosk mode with the Edge browser. They auto start > and auto login to Windows. Unfortunately, they also still need us to type > in the login and password for Evergreen. Does anyone know a way to > eliminate the login screen? Or is there a way to have it auto login? My aim > is to not need to have a keyboard/mouse with the computer. > > > > I tried to set the Workstation Required setting under > Administration/Library setting to False but that didn’t seem to change it. > > > > Thanks in advance for any suggestions. > > > > *Millissa Macomber* > > *Technical Services Coordinator* > > Burlington Public Library > > 820 E. Washington Ave., > > Burlington, WA 98233 > > millis...@burlingtonwa.gov > > 360-755-0760 > > > > [image: resized for email signature line] > > > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] EG 3.3 and COPY_BAD_STATUS check-in popup?
Hello, I haven't found a bug report about this, and just want to confirm that others see this also. When we check in an item on our 3.3.4 system that has a non standard status like "Lib Use Only", we don't get any popup. In the old staff client, we get a "COPY_BAD_STATUS" override popup. I see mention in the following bug, that there was a popup like that in a 3.0.3 system. https://bugs.launchpad.net/evergreen/+bug/1745447 And I found another mention in Bug 1616170 that Kyle Huchins noticed that the popup was no longer showing up. https://bugs.launchpad.net/evergreen/+bug/1616170/comments/3 Has anyone else noticed this? Was this an intended behavior change? Our staff miss seeing that popup since they like to take a closer look at items with non standard statuses. Thanks Josh -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] 3.3 and copy/item alerts - mixed client use
Thanks for the suggestions Martha and Blake, After using the web client for a few days we discovered a few more things about how the old and new copy alerts act. The old (asset.copy(alert_message)) alerts will still pop up during check-in/checkout as long as there are no new style (asset.copy_alert) alerts. But there is no way to edit/remove them in the web client. Also, there is no way to display the new style alerts in a column during checkout, but it is possible to display the old style alerts. So to ease our transition I'm going to attempt to synchronize the two locations with database triggers (Like Blake suggested) until we are all on the web staff client. It won't be perfect, but for our basic needs it will keep staff from having to add and remove alerts in two different interfaces. Only the first new style alert will be copied back to the old location. But we are used to using just one alert field at this point, so that should work fine for the short term. Here is my attempt at creating the triggers to synchronize the two locations. https://gist.github.com/stompro/610693d2ae25de5b591a75bb587e610a Josh On Tue, Oct 15, 2019 at 2:01 PM Driscoll, Martha wrote: > Hi Josh, > When we upgraded to 3.1 we were not ready to implement the web client. We > commented out the part of the 3.0.6-3.1.0 upgrade script that clears the > legacy copy alerts so XUL still had access to the copy alerts. We did > training on the web client on 3.1 but nobody did production cataloging. > > When we upgraded to 3.2 six months later we went exclusively to the web > client. We deleted the new copy alerts (which were created during the 3.1 > upgrade) and then re-ran the part of the script from 3.0.6-3.1.0 that > converts the legacy copy alerts in asset.copy to asset.copy_alert and > deletes the old alerts. > > You could probably do something similar on a library-by-library basis, but > I don't think you can have circulation staff and tech services staff on two > different clients in the same library. Our 26 libraries came up on the web > client all at once after a few months of training and access to the web > client. It went smoothly and our support staff were not overwhelmed with > calls. > > Martha Driscoll, Systems Manager > North of Boston Library Exchange > www.noblenet.org > > > > > On Tue, Oct 15, 2019 at 11:58 AM Josh Stompro > wrote: > >> Hello, we are upgrading to 3.3 from an older version. And were planning >> on a phased change over to using the web client after the upgrade. >> >> I just noticed that the xul client cannot use the new item alerts, and >> all existing item alerts are migrated from asset.copy to the new >> asset.copy_alert during the database upgrade. >> >> So I'm wondering what others have done to re-add all the alerts back to >> the asset.copy alerts field so xul client users can still be alerted, and >> how you have dealt with synchronizing the alerts between the two locations >> during your transition period. >> >> Thanks >> Josh >> >> -- >> Josh Stompro - IT Director >> Lake Agassiz Regional Library >> Desk: 218-233-3757 Ext 139 >> Cell: 218-790-2110 >> > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] Printing vertical rotated text through hatch
Thanks Chris, that is much easier than rotating each letter, and works fine with hatch. The following gives me what I was looking for. {{patron.family_name | limitTo:4}}{{patron.first_given_name | limitTo:1}}{{patron.card.barcode | limitTo:2:-2}} This is for a hold slip that sticks out on the side for a self service holds shelf. [image: image.png] On Mon, Oct 28, 2019 at 2:23 PM Chris Burton wrote: > > > > We Use this div for our vertical text. We basically inflate the size to > have 1 character take the full width and use 'overflow-wrap: break-word' to > allow the characters to break off. It isn't pretty, but it works for us! We > print our Hold Shelf Slips daily with it. > > On Mon, 28 Oct 2019 at 14:47, Josh Stompro > wrote: > >> Thanks Lynn, It seems to be specifically the " text-orientation: >> upright" that doesn't work through hatch. When I add that to your >> template, the preview looks like it takes effect. But when printed through >> hatch, that css is ignored. While printing with hatch turned off does >> print correctly. >> >> Josh >> >> Josh >> >> >> On Thu, Oct 24, 2019 at 3:39 PM Floyd, Angelia Lynn < >> lflo...@library.in.gov> wrote: >> >>> Check out my receipts in my git hub: >>> https://github.com/alynn26/Evergreen-Receipts >>> >>> The hold_shelf_slip_vertical.html >>> <https://github.com/alynn26/Evergreen-Receipts/blob/master/hold_shelf_slip_vertical.html> >>> has >>> the Vertical hold slip printing in hatch, I know this because I tested it >>> in Hatch with a receipt printer. >>> >>> This is the div I used: >>> >>> >>> - >>> 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 >>> -- >>> *From:* Open-ils-general < >>> open-ils-general-boun...@list.georgialibraries.org> on behalf of Josh >>> Stompro >>> *Sent:* Thursday, October 24, 2019 4:18 PM >>> *To:* Evergreen Discussion Group < >>> open-ils-general@list.georgialibraries.org> >>> *Subject:* [OPEN-ILS-GENERAL] Printing vertical rotated text through >>> hatch >>> >>> This is an EXTERNAL email. Exercise caution. DO NOT open >>> attachments or click links from unknown senders or unexpected email. >>> -- >>> Hello, We just upgraded from 2.10 to 3.3 last weekend, and we are >>> currently working through all our documentation to get ready to switch to >>> the web client. >>> >>> I'm working on setting up our receipt templates for transit and hold >>> slips. And I'm noticing when I try to use the css "text-orientation: >>> upright ; writing-mode: vertical-rl;" to create vertical stacked text, it >>> is just ignored when printing, but only when I'm printing through hatch. >>> If I use browser printing, it works fine. >>> >>> So is hatch rendering the print jobs when it is used? And is there a >>> list of what CSS it doesn't support? >>> >>> Josh >>> >>> -- >>> Josh Stompro - IT Director >>> Lake Agassiz Regional Library >>> Desk: 218-233-3757 Ext 139 >>> Cell: 218-790-2110 >>> >> >> >> -- >> Josh Stompro - IT Director >> Lake Agassiz Regional Library >> Desk: 218-233-3757 Ext 139 >> Cell: 218-790-2110 >> > > > -- > Chris Burton > Computer Programmer Analyst > > *Technology Associate @* > *Niagara Falls Public Library* > 4848 Victoria Avenue, Niagara Falls, ON L2E 4C5 > Tel 905-356-8080 x 267 cbur...@nflibrary.ca > <https://my.nflibrary.ca> > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] Printing vertical rotated text through hatch
Thanks Lynn, It seems to be specifically the " text-orientation: upright" that doesn't work through hatch. When I add that to your template, the preview looks like it takes effect. But when printed through hatch, that css is ignored. While printing with hatch turned off does print correctly. Josh Josh On Thu, Oct 24, 2019 at 3:39 PM Floyd, Angelia Lynn wrote: > Check out my receipts in my git hub: > https://github.com/alynn26/Evergreen-Receipts > > The hold_shelf_slip_vertical.html > <https://github.com/alynn26/Evergreen-Receipts/blob/master/hold_shelf_slip_vertical.html> > has > the Vertical hold slip printing in hatch, I know this because I tested it > in Hatch with a receipt printer. > > This is the div I used: > > > - > 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 > -- > *From:* Open-ils-general < > open-ils-general-boun...@list.georgialibraries.org> on behalf of Josh > Stompro > *Sent:* Thursday, October 24, 2019 4:18 PM > *To:* Evergreen Discussion Group < > open-ils-general@list.georgialibraries.org> > *Subject:* [OPEN-ILS-GENERAL] Printing vertical rotated text through hatch > > This is an EXTERNAL email. Exercise caution. DO NOT open attachments > or click links from unknown senders or unexpected email. > -- > Hello, We just upgraded from 2.10 to 3.3 last weekend, and we are > currently working through all our documentation to get ready to switch to > the web client. > > I'm working on setting up our receipt templates for transit and hold > slips. And I'm noticing when I try to use the css "text-orientation: > upright ; writing-mode: vertical-rl;" to create vertical stacked text, it > is just ignored when printing, but only when I'm printing through hatch. > If I use browser printing, it works fine. > > So is hatch rendering the print jobs when it is used? And is there a list > of what CSS it doesn't support? > > Josh > > -- > Josh Stompro - IT Director > Lake Agassiz Regional Library > Desk: 218-233-3757 Ext 139 > Cell: 218-790-2110 > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] Printing vertical rotated text through hatch
Hello, We just upgraded from 2.10 to 3.3 last weekend, and we are currently working through all our documentation to get ready to switch to the web client. I'm working on setting up our receipt templates for transit and hold slips. And I'm noticing when I try to use the css "text-orientation: upright ; writing-mode: vertical-rl;" to create vertical stacked text, it is just ignored when printing, but only when I'm printing through hatch. If I use browser printing, it works fine. So is hatch rendering the print jobs when it is used? And is there a list of what CSS it doesn't support? Josh -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] 3.3 and copy/item alerts - mixed client use
Hello, we are upgrading to 3.3 from an older version. And were planning on a phased change over to using the web client after the upgrade. I just noticed that the xul client cannot use the new item alerts, and all existing item alerts are migrated from asset.copy to the new asset.copy_alert during the database upgrade. So I'm wondering what others have done to re-add all the alerts back to the asset.copy alerts field so xul client users can still be alerted, and how you have dealt with synchronizing the alerts between the two locations during your transition period. Thanks Josh -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] Evergreen Self-Check and locking media cases
Hello, 2 years later I did finally get my changes posted for the two bugs I mentioned. https://bugs.launchpad.net/evergreen/+bug/1560601 https://bugs.launchpad.net/evergreen/+bug/1555791 Our local CSS changes can be found at https://git.evergreen-ils.org/?p=working/Evergreen.git;a=commit;h=3b930ddc4194fea3672d8b4a8abb96c2f48f061e Josh On Wed, Jul 26, 2017 at 2:49 PM Josh Stompro wrote: > > 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> > > Joe, I have a fix for keeping the cursor focus always on the scan box. We > also use touch screens for our self checks and we were having trouble with > the fact that it was easy to move the focus, which would cause the next > scan to silently fail, and sometimes switch screens. > > I have a bug report on it, but haven’t actually posted the code there > yet. I’ll try and do that soon. > > https://bugs.launchpad.net/evergreen/+bug/1560601 > > > > We have also had trouble with the print list button that exists on the > checkout screen. Some significant portion of users would press that when > they were done, get a printout and then walk away. I guess they thought > that was the logout and print a receipt button. Then the next users would > walk up and sometime check out items on the first person’s account. > > https://bugs.launchpad.net/evergreen/+bug/1555791 > > > > I would love to collaborate with you on making the self check more touch > screen friendly. I can share the css changes I’ve made just to enlarge > everything to make it easier to see and to make the buttons easier to press. > > > > Josh Stompro - LARL IT Director > > > > *From:* Open-ils-general [mailto: > open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Joe > Knueven > *Sent:* Wednesday, July 26, 2017 10:58 AM > *To:* Evergreen Discussion Group > *Subject:* Re: [OPEN-ILS-GENERAL] Evergreen Self-Check and locking media > cases > > > > While we’re on the subject of user-friendliness of the built in > self-checkout, does anyone have any .tt2 modifications that they are > pleased with and would be willing to share? > > > > I’ve had tweaking the scripting to make the navigation links more button > like (ie touch screen friendly) on my to-do list, but it’s taken me an > especially long time to get around to the first step of teaching myself a > basic amount of tt2 scripting. > > > > Have a good day. > > > > Joe > > > > > > Joseph Knueven, Director > > Germantown Public Library > > 51 North Plum Street > > Germantown, OH 45327 > > 937-855-4001 > > > > *From:* Open-ils-general [ > mailto:open-ils-general-boun...@list.georgialibraries.org > ] *On Behalf Of *Terran > McCanna > *Sent:* Wednesday, July 26, 2017 11:16 AM > *To:* Evergreen Discussion Group < > open-ils-general@list.georgialibraries.org> > *Subject:* Re: [OPEN-ILS-GENERAL] Evergreen Self-Check and locking media > cases > > > > >>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.<< > > Interesting. There's nothing in the interface that tells the patron that > they can do that, or that tells them how. Patrons typically don't have > books in hand when they wish to renew, so they'd need to understand that > they could go to the Items out screen and copy and paste the barcodes. > Online instructions would help, but it still wouldn't as user friendly as > the method of renewal in My Account. > > > Terran McCanna > PINES Program Manager > Georgia Public Library Service > 1800 Century Place, Suite 150 > Atlanta, GA 30345 > 404-235-7138 > tmcca...@georgialibraries.org > > > > On Wed, Jul 26, 2017 at 10:26 AM, Mike Rylander > wrote: > > 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 functi
Re: [OPEN-ILS-GENERAL] 3.3.3 staff client receipt printing & defaults
Ben, I just want to be clear, the (Administration -> Workstation -> Stored User Preferences -> Server Workstation Prefs.) does just show you what prefs are set, you cannot edit them there. You could use that info to request that an org unit setting type be created by CW Mars for the preferences you want to control for your org. And then if you have access to changing library settings for your org, you could set the setting for your org. But you would need to be on 3.2+ for that to work. Josh On Thu, Sep 12, 2019 at 9:46 AM Benjamin Kalish wrote: > Thanks. At least with CW MARS current setup this allows you to view, but > not to change settings. John Amundson has indicated that this isn't > possible with CW MARS current setup. I do look forward to the day when I > can change all the templates in my library from one place! > > Benjamin Kalish > Forbes Library / 413-587-1012 / bkal...@forbeslibrary.org > > Support Forbes Library: > >- Consider giving a gift <http://www.forbeslibrary.org/giving> to >Forbes Library >- Vote for the Friends of Forbes in the Florence Bank Community Grant >Program <https://www.florencebank.com/vote>. >- Join the Friends the Forbes today ><https://forbeslibrary.org/friends/>! > > > Currently reading: *The Indian Clerk* by David Leavitt > Just Finished:* The Tombs of Atuan* by Ursula K. Le Guin > > For information about accessibility at the library, please see: > http://forbeslibrary.org/accessibility/ > > > > On Thu, Sep 12, 2019 at 9:25 AM Josh Stompro > wrote: > >> Wait, I just noticed that there is an easier way in the web staff client. >> >> In the web staff client, look under Administration -> Workstation -> >> Stored User Preferences -> Server Workstation Prefs. >> >> That will list all the preferences and their values for the current >> workstation preferences. >> >> [image: image.png] >> Josh >> >> On Thu, Sep 12, 2019 at 8:21 AM Josh Stompro >> wrote: >> >>> Ben, I think you have to go to the database or source. >>> >>> -- List all workstation setting types. >>> SELECT * FROM config.workstation_setting_type ORDER BY NAME; >>> >>> Look at the 950.data.seed-values.sql file (huge file though). Search for >>> config.workstation_setting_type starting around line 18475. >>> >>> https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/sql/Pg/950.data.seed-values.sql;h=daf37c36d36eb62f905fa75e8b1dc3ddc8b3d13e;hb=HEAD#l18475 >>> >>> >>> Once you know the name, I believe you would create an "Org Unit Setting >>> Type" with the same name. Then you can set values for it via the library >>> settings editor. >>> >>> Josh >>> >>> >>> On Wed, Sep 11, 2019 at 3:14 PM Benjamin Kalish < >>> bkal...@forbeslibrary.org> wrote: >>> >>>> This sounds amazing, but how does one find the settings related to a >>>> print template (all of ours are workstation settings now) so that one can >>>> make them a user setting or an org setting instead? >>>> >>>> Benjamin Kalish >>>> Forbes Library / 413-587-1012 / bkal...@forbeslibrary.org >>>> >>>> Support Forbes Library: >>>> >>>>- Consider giving a gift <http://www.forbeslibrary.org/giving> to >>>>Forbes Library >>>>- Vote for the Friends of Forbes in the Florence Bank Community >>>>Grant Program <https://www.florencebank.com/vote>. >>>>- Join the Friends the Forbes today >>>><https://forbeslibrary.org/friends/>! >>>> >>>> >>>> Currently reading: *The Indian Clerk* by David Leavitt >>>> Just Finished:* The Tombs of Atuan* by Ursula K. Le Guin >>>> >>>> For information about accessibility at the library, please see: >>>> http://forbeslibrary.org/accessibility/ >>>> >>>> >>>> >>>> On Tue, Sep 10, 2019 at 11:57 AM Josh Stompro >>>> wrote: >>>> >>>>> Morgan, thank you for this info. I totally missed the connection to >>>>> print templates when I read that message the first time around, and I >>>>> don't >>>>> think I'm the only one. When Bill posted his message about the server >>>>> side >>>>> processed print templates in April 2019 >>>>> <http://libmail.georgialibraries.org/pipermail/open-ils-dev/2019-April/010709.ht
Re: [OPEN-ILS-GENERAL] 3.3.3 staff client receipt printing & defaults
Wait, I just noticed that there is an easier way in the web staff client. In the web staff client, look under Administration -> Workstation -> Stored User Preferences -> Server Workstation Prefs. That will list all the preferences and their values for the current workstation preferences. [image: image.png] Josh On Thu, Sep 12, 2019 at 8:21 AM Josh Stompro wrote: > Ben, I think you have to go to the database or source. > > -- List all workstation setting types. > SELECT * FROM config.workstation_setting_type ORDER BY NAME; > > Look at the 950.data.seed-values.sql file (huge file though). Search for > config.workstation_setting_type starting around line 18475. > > https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/sql/Pg/950.data.seed-values.sql;h=daf37c36d36eb62f905fa75e8b1dc3ddc8b3d13e;hb=HEAD#l18475 > > > Once you know the name, I believe you would create an "Org Unit Setting > Type" with the same name. Then you can set values for it via the library > settings editor. > > Josh > > > On Wed, Sep 11, 2019 at 3:14 PM Benjamin Kalish > wrote: > >> This sounds amazing, but how does one find the settings related to a >> print template (all of ours are workstation settings now) so that one can >> make them a user setting or an org setting instead? >> >> Benjamin Kalish >> Forbes Library / 413-587-1012 / bkal...@forbeslibrary.org >> >> Support Forbes Library: >> >>- Consider giving a gift <http://www.forbeslibrary.org/giving> to >>Forbes Library >>- Vote for the Friends of Forbes in the Florence Bank Community Grant >>Program <https://www.florencebank.com/vote>. >>- Join the Friends the Forbes today >><https://forbeslibrary.org/friends/>! >> >> >> Currently reading: *The Indian Clerk* by David Leavitt >> Just Finished:* The Tombs of Atuan* by Ursula K. Le Guin >> >> For information about accessibility at the library, please see: >> http://forbeslibrary.org/accessibility/ >> >> >> >> On Tue, Sep 10, 2019 at 11:57 AM Josh Stompro >> wrote: >> >>> Morgan, thank you for this info. I totally missed the connection to >>> print templates when I read that message the first time around, and I don't >>> think I'm the only one. When Bill posted his message about the server side >>> processed print templates in April 2019 >>> <http://libmail.georgialibraries.org/pipermail/open-ils-dev/2019-April/010709.html>, >>> I commented (along with a few other people) that it would be great to have >>> a way to centrally manage print templates, not realizing that had been >>> added 8 months earlier. >>> >>> I started a bug report with notes on documenting this behavior in the >>> print templates section. >>> https://bugs.launchpad.net/evergreen/+bug/1843454 >>> >>> Josh >>> >>> On Mon, Sep 9, 2019 at 3:26 PM Morgan, Michele >>> wrote: >>> >>>> Hi Josh, >>>> >>>> Since moving to 3.2 where workstation settings were moved to the >>>> server, we've been making use of org unit settings to set default print >>>> templates. Any workstation setting can be turned into an org unit setting >>>> as Bill Erickson described here: >>>> >>>> https://markmail.org/message/hfaogumstphagscy >>>> >>>> We have set a number of default print templates at the consortium org >>>> unit level as consortium defaults, and upon request of a library, have >>>> copied print templates configured on a given workstation into org unit >>>> settings for that library so they don't need to be set on each workstation. >>>> We've left the workstation setting types so that individual workstations >>>> can override the org unit settings when necessary. >>>> >>>> This has been pretty successful, eliminating the need for library staff >>>> to move them from workstation to workstation on a flash drive. >>>> >>>> We've done this for many column settings as well. >>>> >>>> Hope this is helpful. >>>> Michele >>>> -- >>>> Michele M. Morgan, Technical Support Analyst >>>> North of Boston Library Exchange, Danvers Massachusetts >>>> mmor...@noblenet.org >>>> >>>> >>>> >>>> On Mon, Sep 9, 2019 at 2:25 PM Josh Stompro >>>> wrote: >>>> >>>>> Hello, I just want to make sure I have this correct
Re: [OPEN-ILS-GENERAL] 3.3.3 staff client receipt printing & defaults
Ben, I think you have to go to the database or source. -- List all workstation setting types. SELECT * FROM config.workstation_setting_type ORDER BY NAME; Look at the 950.data.seed-values.sql file (huge file though). Search for config.workstation_setting_type starting around line 18475. https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/sql/Pg/950.data.seed-values.sql;h=daf37c36d36eb62f905fa75e8b1dc3ddc8b3d13e;hb=HEAD#l18475 Once you know the name, I believe you would create an "Org Unit Setting Type" with the same name. Then you can set values for it via the library settings editor. Josh On Wed, Sep 11, 2019 at 3:14 PM Benjamin Kalish wrote: > This sounds amazing, but how does one find the settings related to a print > template (all of ours are workstation settings now) so that one can make > them a user setting or an org setting instead? > > Benjamin Kalish > Forbes Library / 413-587-1012 / bkal...@forbeslibrary.org > > Support Forbes Library: > >- Consider giving a gift <http://www.forbeslibrary.org/giving> to >Forbes Library >- Vote for the Friends of Forbes in the Florence Bank Community Grant >Program <https://www.florencebank.com/vote>. >- Join the Friends the Forbes today ><https://forbeslibrary.org/friends/>! > > > Currently reading: *The Indian Clerk* by David Leavitt > Just Finished:* The Tombs of Atuan* by Ursula K. Le Guin > > For information about accessibility at the library, please see: > http://forbeslibrary.org/accessibility/ > > > > On Tue, Sep 10, 2019 at 11:57 AM Josh Stompro > wrote: > >> Morgan, thank you for this info. I totally missed the connection to >> print templates when I read that message the first time around, and I don't >> think I'm the only one. When Bill posted his message about the server side >> processed print templates in April 2019 >> <http://libmail.georgialibraries.org/pipermail/open-ils-dev/2019-April/010709.html>, >> I commented (along with a few other people) that it would be great to have >> a way to centrally manage print templates, not realizing that had been >> added 8 months earlier. >> >> I started a bug report with notes on documenting this behavior in the >> print templates section. >> https://bugs.launchpad.net/evergreen/+bug/1843454 >> >> Josh >> >> On Mon, Sep 9, 2019 at 3:26 PM Morgan, Michele >> wrote: >> >>> Hi Josh, >>> >>> Since moving to 3.2 where workstation settings were moved to the server, >>> we've been making use of org unit settings to set default print templates. >>> Any workstation setting can be turned into an org unit setting as Bill >>> Erickson described here: >>> >>> https://markmail.org/message/hfaogumstphagscy >>> >>> We have set a number of default print templates at the consortium org >>> unit level as consortium defaults, and upon request of a library, have >>> copied print templates configured on a given workstation into org unit >>> settings for that library so they don't need to be set on each workstation. >>> We've left the workstation setting types so that individual workstations >>> can override the org unit settings when necessary. >>> >>> This has been pretty successful, eliminating the need for library staff >>> to move them from workstation to workstation on a flash drive. >>> >>> We've done this for many column settings as well. >>> >>> Hope this is helpful. >>> Michele >>> -- >>> Michele M. Morgan, Technical Support Analyst >>> North of Boston Library Exchange, Danvers Massachusetts >>> mmor...@noblenet.org >>> >>> >>> >>> On Mon, Sep 9, 2019 at 2:25 PM Josh Stompro >>> wrote: >>> >>>> Hello, I just want to make sure I have this correct while planning our >>>> upgrade to 3.3 >>>> >>>> If I want to set global printer templates in the staff client in 3.3.3 >>>> I can modify the templates at >>>> /openils/var/templates/staff/share/print_templates/ >>>> or if I have alternate TT2 template locations >>>> (/openils/var/templates_shared/) I can update them there. >>>> >>>> If I need to set per location defaults for the print templates, I'll >>>> need to enter data per workstation into actor.workstation_setting. >>>> >>>> In 3.4 there will be an admin gui for updating the print templates per >>>> org unit and locale. >>>> https://bugs.launchpad.net/evergreen/+bug/1825851 >>>> >>>> Thanks >>>> -- >>>> Josh Stompro - IT Director >>>> Lake Agassiz Regional Library >>>> Desk: 218-233-3757 Ext 139 >>>> Cell: 218-790-2110 >>>> >>> >> >> -- >> Josh Stompro - IT Director >> Lake Agassiz Regional Library >> Desk: 218-233-3757 Ext 139 >> Cell: 218-790-2110 >> > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] 3.3.3 staff client receipt printing & defaults
Morgan, thank you for this info. I totally missed the connection to print templates when I read that message the first time around, and I don't think I'm the only one. When Bill posted his message about the server side processed print templates in April 2019 <http://libmail.georgialibraries.org/pipermail/open-ils-dev/2019-April/010709.html>, I commented (along with a few other people) that it would be great to have a way to centrally manage print templates, not realizing that had been added 8 months earlier. I started a bug report with notes on documenting this behavior in the print templates section. https://bugs.launchpad.net/evergreen/+bug/1843454 Josh On Mon, Sep 9, 2019 at 3:26 PM Morgan, Michele wrote: > Hi Josh, > > Since moving to 3.2 where workstation settings were moved to the server, > we've been making use of org unit settings to set default print templates. > Any workstation setting can be turned into an org unit setting as Bill > Erickson described here: > > https://markmail.org/message/hfaogumstphagscy > > We have set a number of default print templates at the consortium org > unit level as consortium defaults, and upon request of a library, have > copied print templates configured on a given workstation into org unit > settings for that library so they don't need to be set on each workstation. > We've left the workstation setting types so that individual workstations > can override the org unit settings when necessary. > > This has been pretty successful, eliminating the need for library staff to > move them from workstation to workstation on a flash drive. > > We've done this for many column settings as well. > > Hope this is helpful. > Michele > -- > Michele M. Morgan, Technical Support Analyst > North of Boston Library Exchange, Danvers Massachusetts > mmor...@noblenet.org > > > > On Mon, Sep 9, 2019 at 2:25 PM Josh Stompro > wrote: > >> Hello, I just want to make sure I have this correct while planning our >> upgrade to 3.3 >> >> If I want to set global printer templates in the staff client in 3.3.3 I >> can modify the templates at >> /openils/var/templates/staff/share/print_templates/ >> or if I have alternate TT2 template locations >> (/openils/var/templates_shared/) I can update them there. >> >> If I need to set per location defaults for the print templates, I'll need >> to enter data per workstation into actor.workstation_setting. >> >> In 3.4 there will be an admin gui for updating the print templates per >> org unit and locale. >> https://bugs.launchpad.net/evergreen/+bug/1825851 >> >> Thanks >> -- >> Josh Stompro - IT Director >> Lake Agassiz Regional Library >> Desk: 218-233-3757 Ext 139 >> Cell: 218-790-2110 >> > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] 3.3.3 staff client receipt printing & defaults
Hello, I just want to make sure I have this correct while planning our upgrade to 3.3 If I want to set global printer templates in the staff client in 3.3.3 I can modify the templates at /openils/var/templates/staff/share/print_templates/ or if I have alternate TT2 template locations (/openils/var/templates_shared/) I can update them there. If I need to set per location defaults for the print templates, I'll need to enter data per workstation into actor.workstation_setting. In 3.4 there will be an admin gui for updating the print templates per org unit and locale. https://bugs.launchpad.net/evergreen/+bug/1825851 Thanks -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] 3.3.3 856 scoping to preferred library issue
Hello, I'm testing out 3.3.3 and I've noticed that I no longer see any ebook results when I search from our default catalog landing page. What seems to be happening is that the preferred lib setting no longer includes ebooks (scoped 856 URI's). For example: (Simple keyword search) [2019-09-06 07:49:36] /usr/sbin/apache2 [INFO:29303:Search.pm:211:15677691072930320] tpac: site=LARL_NWRL_CONSORTIUM, depth=0, user_query=harry potter, query=pref_ou(LARL) harry potter depth(0) This search on our old 2.10 system returns all normally visible copies + all ebook records scoped with an 856 that includes "‡9LARL", or for logged in users, the pref_ou gets set to the users home library which also includes the same scoped records. I've tried to find an existing bug report about the pref_ou no longer working with Located URI's, but haven't found anything that looks right. Could someone point me to where the search query gets parsed so I can see how the pref_ou is handled now. Is it 300.schema.staged_search.sql? Or is it perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm that I should be looking at. I see that pref_ou is mentioned in that file, but doesn't actually seem to be acted on. Or was the preferred lib functionality left out of the new searching from bug https://bugs.launchpad.net/evergreen/+bug/1698206 ? So the behavior that we want is for all users to always default to searching the consortium, but depending on the catalog domain, have the pref_lib set to the system associated with that domain for not logged in users. Logged in users have the pref_ou set to their home library. We always want users to see all physical copies since we share everything between our two systems, but have separate overdrive accounts. We use an apache rewrite to always add ?locg=1 to the initial catalog page load to set the search library to consortium. And then we use an apache directive in sites-enabled/eg.conf to set the preferred library per virtual host with a statement like "SetEnv physical_loc 101" I found this bug, but I don't think I'm performing a browse search so I'm not sure that it is related. Browse search not including scoped electronic bibs - https://bugs.launchpad.net/evergreen/+bug/1773479 Auto suggest not accounting for located URI (electronic) record visibility https://bugs.launchpad.net/evergreen/+bug/1802952 This bug seems somewhat similar, but I don't think it was related to the preferred library, just site scoping. https://bugs.launchpad.net/evergreen/+bug/1736419 -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] Web Client and Load Balancer
Martha, I just saw your post. We are also using pound proxy, and looking to upgrade to 3.3 and use the web staff client. Did you get it to work with pound. It looks like historically pound proxy has had trouble with websockets [1], but there was a release early this year with a fix perhaps [2]? What is everyone switching to from pound? HAproxy? Josh 1 - https://superuser.com/questions/542204/pound-configure-to-handle-websocket 2. - http://www.apsis.ch/pound/pound_list/archive/2019/2019-01/1547402746000#1547402746000 On Mon, Aug 6, 2018 at 8:41 AM Martha Driscoll wrote: > We are running release 3.0.9 and I can connect to the web client if I > browse directly to one of my application servers. When I try to login via > the load balancer I get the login screen but when I try to login it just > refreshes the login screen. > > Is there something that needs to be configured for the web client to work > through a load balancer? We are using the pound load balancer and I have > backends setup for port 443. > > Martha Driscoll, Systems Manager > North of Boston Library Exchange > www.noblenet.org > > > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
Re: [OPEN-ILS-GENERAL] Date format for the Hold "If suspended, activate on"
Hello, I just saw that Jason Stephenson has an open bug with some code to switch to the date input element. https://bugs.launchpad.net/evergreen/+bug/1723651 It looks like Safari support makes it more complicated, since Safari doesn't support the date element. Josh On Fri, Aug 23, 2019 at 9:48 AM Josh Stompro wrote: > Hello Eva, it looks like it would be possible to edit the date hint in the > edit.tt2 template > > https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/templates/opac/myopac/holds/edit.tt2;hb=5489249b535f2817a5da3e862dd59f1501434e87#l100 > and in the place_hold.tt2 template > > https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/templates/opac/parts/place_hold.tt2;hb=5489249b535f2817a5da3e862dd59f1501434e87#l281 > > And then in EGCatLoader/Account.pm change the regular expression that > parses the date out to match the format you use. > at > > https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l963 > and > > https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1106 > > 1106 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1106> > # TODO: Make this support other date formats, not just mm/dd/. > 1107 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1107> > # We should use a date input type on the forms once it is supported > by Firefox. > 1108 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1108> > # I didn't do that now because it is not available in a general > release. > 1109 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1109> > if ($cgi->param('thaw_date') =~ m:^(\d{2})/(\d{2})/(\d{4})$:){ > 1110 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1110> > eval { > > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l> > my $dt = > DateTime::Format::ISO8601->parse_datetime("$3-$1-$2"); > 1112 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1112> > $ctx->{thaw_date} = $dt->ymd; > 1113 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1113> > }; > 1114 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1114> > if ($@) { > 1115 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1115> > $logger->warn("ignoring invalid thaw_date when placing hold > request"); > 1116 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1116> > } > 1117 > <https://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/WWW/EGCatLoader/Account.pm;hb=HEAD#l1117> > } > > Also, see bug https://bugs.launchpad.net/evergreen/+bug/1189989 which > discusses the date issue at length. At that time (2 years ago, aug 2017) > the firefox date form element wasn't available, but now it is in both the > release and ESR versions. So you may want to try changing the input type > to date, and then updating the regular expressions to support the > -MM-DD format that the date input type sends. That would get you the > benefits of localized format and a date picker widget. Maybe it is time to > update the feature to support the date form element also? > > Reference: Suspend at time of placement feature commit: > <https://git.evergreen-ils.org/?p=Evergreen.git;a=commitdiff;h=fcdcab1d2904f46d2d9ff0e15087fad81efa90a1;hp=1c88f4cefa9a7945b3520b7249f7134d26f8fa4b> > > Josh > > On Mon, Aug 19, 2019 at 8:32 AM Cerninakova Eva wrote: > >> Hi, >> >> in Holds screen in My account in the OPAC, it is possible to enter the >> date for the "If suspended, activate on" and "Cancel unless filled by" >> only in the MM/DD/ format (no matter what date
Re: [OPEN-ILS-GENERAL] Date format for the Hold "If suspended, activate on"
ovna 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 > > > > <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> > Bez > virů. www.avast.com > <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail> > <#m_-7805326569781748773_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> > -- Josh Stompro - IT Director Lake Agassiz Regional Library Desk: 218-233-3757 Ext 139 Cell: 218-790-2110
[OPEN-ILS-GENERAL] Missing Item Tracking
Hello, does anyone have a good system setup for tracking missing items? I would like to know things like how often a certain workstation/login marks items missing, what the status and physical location was before it was marked missing, was it on the pull list, was it found later, etc. For copies that are marked missing off the holdshelf, what is the best way to track which holdshelf they were on when marked missing? I would like to be able send out a weekly/monthly report of what was marked missing from a particular location, for staff to take another look for. 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
[OPEN-ILS-GENERAL] Wordpress Bookshelf/cover art plugin with Evergreen support
Hello, I just wanted to mention a wordpress plugin that we have been using with our new web site that has support for Evergreen built in. If you need to display book carousels on a wordpress site, please give it a look. We are using it on our new releases page - https://larl.org/books-movies-more/ The developer was able to quickly add Evergreen support when we enquired, and the newly released version includes the ability to specify the bookshelf items by evergreen bibid number. It also supports grabbing the coverart directly from evergreen as well as grabbing it from the various added content providers. https://wordpress.org/plugins/library-bookshelves/ This plugin currently requires that the lists of ISBNs/UPCs be entered for each list, so we just update them once a week manually. I'm trying to get the wordpress rest API working so we can push updates to the lists from our evergreen server. It doesn't support grabbing data via RSS. 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] [OPEN-ILS-DEV] Cannot save authority record with a 155 field
Hello Mike, I've created a bug for this issue to get it in the queue. LP#1800871 Josh Stompro - LARL IT Director -Original Message- From: Open-ils-general On Behalf Of Mike Rylander Sent: Wednesday, October 31, 2018 10:09 AM To: Evergreen Development Discussion List Cc: Evergreen Discussion Group Subject: 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.x
Re: [OPEN-ILS-GENERAL] Cannot save authority record with a 155 field
Linda, I just noticed that the setAuthority template is called from the genre template also. So it also works to just remove the call to setAuthority at line 1085. Josh Stompro - LARL IT Director From: Josh Stompro Sent: Wednesday, October 31, 2018 8:23 AM To: Linda Jansova ; Evergreen Discussion Group ; Evergreen Development Discussion List Subject: RE: [OPEN-ILS-GENERAL] Cannot save authority record with a 155 field 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 mailto:skolk...@chello.cz>> Sent: Wednesday, October 31, 2018 7:16 AM To: Evergreen Discussion Group mailto:open-ils-general@list.georgialibraries.org>>; Josh Stompro mailto:stomp...@exchange.larl.org>>; Evergreen Development Discussion List mailto:open-ils-...@list.georgialibraries.org>> 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: 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 <mailto:open-ils-general-boun...@list.georgialibraries.org> On Behalf Of Linda Jansova Sent: Friday, October 26, 2018 5:29 AM To: Evergreen Discussion Group <mailto:open-ils-general@list.georgialibraries.org>; Evergreen Development Discussion List <mailto:open-ils-...@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] Cannot save authority record with a 155 field Hi, back in August we started investigating why we couldn't proceed with upgrade from 2.12.6 to 3.1.4 (for more details please see http://libmail.georgialibraries.org/pipermail/open-ils-general/2018-August/015298.html). After removing obviously invalid MARCXML records (which surprisingly made their way to our 2.12 installation) we still have some records which cannot be reingested (or saved). Attached is a sample record americke_romany.xml which is one of those troublesome ones. It is a genre/form term record with the main heading in the field 155. We have tried the SQL upgrade from 2.12.6 to 3.0.0 without authority records reingest (the particular lines were commented out) and, once we were at 3.1.4, used the web client to save this particular record (without actually making any changes in it). However, it appeared that it could not be saved: --- open-ils.pcrud 2018-10-26 09:33:37 [ERR :49144:oils_sql.c:6570:15405352984867814] open-ils.pcrud ERROR updating authority::record_entry object with id = 356: 56966976 56966976: ERROR: runtime error: file unknown-55cee6a934f0 element attribute xsl:attribute: Cannot add attributes to an element if children have been already added to the element. at line 31. CONTEXT: PL/Perl function "oils_xslt_process" --- Using this error message, we began to suspect a XSLT transformation being the culprit. We have taken XSL files from Evergreen (those from http://git.evergr
Re: [OPEN-ILS-GENERAL] Cannot save authority record with a 155 field
Hello Linda, I think the Authority ingest uses the MARC21slim2MADS.xsl transform file to convert the authority data into MADS format. Could you try manually processing your problem authority record using the MADS file instead of the MODS and see what you get. The MADS xsl does look like it references tag 155. Josh Stompro - LARL IT Director From: Open-ils-general On Behalf Of Linda Jansova Sent: Friday, October 26, 2018 5:29 AM To: Evergreen Discussion Group ; Evergreen Development Discussion List Subject: [OPEN-ILS-GENERAL] Cannot save authority record with a 155 field Hi, back in August we started investigating why we couldn't proceed with upgrade from 2.12.6 to 3.1.4 (for more details please see http://libmail.georgialibraries.org/pipermail/open-ils-general/2018-August/015298.html). After removing obviously invalid MARCXML records (which surprisingly made their way to our 2.12 installation) we still have some records which cannot be reingested (or saved). Attached is a sample record americke_romany.xml which is one of those troublesome ones. It is a genre/form term record with the main heading in the field 155. We have tried the SQL upgrade from 2.12.6 to 3.0.0 without authority records reingest (the particular lines were commented out) and, once we were at 3.1.4, used the web client to save this particular record (without actually making any changes in it). However, it appeared that it could not be saved: --- open-ils.pcrud 2018-10-26 09:33:37 [ERR :49144:oils_sql.c:6570:15405352984867814] open-ils.pcrud ERROR updating authority::record_entry object with id = 356: 56966976 56966976: ERROR: runtime error: file unknown-55cee6a934f0 element attribute xsl:attribute: Cannot add attributes to an element if children have been already added to the element. at line 31. CONTEXT: PL/Perl function "oils_xslt_process" --- Using this error message, we began to suspect a XSLT transformation being the culprit. We have taken XSL files from Evergreen (those from http://git.evergreen-ils.org/?p=Evergreen.git;a=tree;f=Open-ILS/xsl;h=68fd13ffb2ad01ef9ceacf9f18695f25d284df05;hb=HEAD). When they were used (xsltproc MARC21slim2MODS33.xsl americke_romany.xml > output.xml), the contents of the 155 field (which is a heading and therefore one of the most important parts of the record) was never included in the output (please see the attached output.xml file). Then we used a web client again to change the 155 tag to the 100 tag (and deleted another possible troublesome tag 755). After making these changes, the record could be saved. So the question is: Where should we add the 155 field (probably in which of the XSLT files) to make sure those records can be saved (or of course reingested)? Thank you in advance for any hints! Linda
[OPEN-ILS-GENERAL] Mobius Carousel - reducing number of requests?
Hello, We have been using the carousel from Mobius for a while now. And I just noticed how resource intensive it seems to be. Here are the slides from the presentation that Bake created about it. http://slides.mobiusconsortium.org/blake/bookcarousel/#/1 And the code https://github.com/mcoia/mobius_evergreen/tree/master/bookbag_update We have ~ 30 catalog machines that are set to reset every 5 minutes of idle time (since people don't always log themselves out.) When I watch our catalog page load which currently has 3 sliders, I see 483 requests made from the browser. ~450 of those requests are from the carousel, since it request each book bag, and then request info for each bookbag item. And then request images for the visible items. So our 30 catalog machines generate 162000 requests an hour. I'm wondering if anyone has tried pre-generating the bookbag json data on a schedule so the web page can do just one request for the titles? It also seems like the only info that is used is the title, while 1-2kb of data gets returned about each item. So a lot of unused data gets moved around. The script that generates the static data file could do things like randomize the order of the items, so a static bookbag list would show different titles whenever it is re-generated. It looks like open-ils.search.biblio.record.mods_slim.retrieve can accept an array of ID's, so that seems like it would reduce the number of requests, so that may be another way to reduce the number of requests. 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] Problem with upgrade script 2.12.6-3.0.0 on line 6839
Hello Vaclav, It looks like this error starts when you hit the authority reindex at the end of the upgrade script. It looks like the previous database updates have already been committed at that point, a new transaction runs for the authority reingest. So you may be able to try running small batches of authority records to reingest at once, instead of trying to do them all at once. That may help you narrow down the problem to being with a specific authority record vs being with the authority reindexing process as a whole. If you pick out one existing authority record, and change the update command to something like. UPDATE authority.record_entry SET id = id WHERE NOT DELETED and id=1234; -- where 1234= authority.record_entry.id that you want to target. Then you can try reindexing just one record and see if that succeeds. Create a new script that just contains the Reingest authority record section of the script (lines 6806-6852), and modify that and run it against your database. If one record succeeds, then it very well may be specific authority records that are causing the problems. You could try narrowing it down by running the update on groups of authority records. Here is a query that builds a query string to update 50 authority records at a time. select 'UPDATE authority.record_entry SET id = id WHERE NOT DELETED AND id BETWEEN '||min||' and '||max||' ;' from ( select min(id),max(id),chunkno from ( select id , ((ROW_NUMBER() over (ORDER BY id) - 1) / 50)+1 as chunkNo --change 50 to how many records you want in a group from authority.record_entry where not deleted and id>0 ) x group by 3 order by 1 ) y ; Also, if you echo the queries as they are executed it may be clearer which group the problem is in. (psql -a option). Once you narrow it down to a group, you can change the script to run one update per record, to find the specific record. You may also be able to modify the authority.extract_headings[1] function to spit out some debugging info. It looks to me like the " transformed_xml := oils_xslt_process(marc, xfrm.xslt);" line is where the error is coming up, when the authority marc data is passed to the oils_xslt_process, along with the config.xml_transform.xslt data for the index that is being processed. Maybe add a try block and then on catching an error output the marc data? (I'm not that familiar with stored procedures though, to know how to go about doing that. Looks like it is by using an EXCEPTION clause?) Josh Stompro - LARL IT Director 1 - http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/sql/Pg/version-upgrade/2.12.6-3.0.0-upgrade-db.sql;h=7a865a89db22c333e8da9e3e7750bc9d1fc8bb95;hb=HEAD#l4782 -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Václav Jansa Sent: Friday, August 17, 2018 7:04 AM To: Evergreen Discussion Group Subject: [OPEN-ILS-GENERAL] Problem with upgrade script 2.12.6-3.0.0 on line 6839 Hello Evergreeners, we are just trying to update our last production Evergreen installation (from 2.12 to 3.1), two are done without any issues, but with last one we encountered following error during first update step (2.12.6-3.0.0) psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6839: ERROR: runtime error: file unknown-55cee649a7a0 element attribute xsl:attribute: Cannot add attributes to an element if children have been already added to the element. at line 31. CONTEXT: PL/Perl function "oils_xslt_process" PL/pgSQL function authority.extract_headings(text,integer[]) line 36 at assignment PL/pgSQL function authority.simple_heading_set(text) line 77 at FOR over SELECT rows PL/pgSQL function authority.indexing_ingest_or_delete() line 46 at FOR over SELECT rows psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6841: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6842: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6843: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6844: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:version-upgrade/2.12.6-3.0.0-upgrade-db.sql:6850: ERROR: current transaction is aborted, commands ignored until end of transaction block I already try to check authority related scripts, but from my point of view, error is somewhere in our authority data in DB. Anybody else having the same experience? Do you have any idea how to find out what is causing the error? Do you have any tip, how to ad some debugging code into standard code, what will help us with finding probably failed data? Thanks for help and all recommendations Best regards Vaclav Jansa
[OPEN-ILS-GENERAL] Deleting/Purging Authority Records
Hello, we haven't worked on authority control for many years, and have been learning about Authority control in Evergreen. Once I started looking into it I noticed that we had a large percentage of unused/duplicate authority records in our system. I just wanted to share the steps I took to mark deleted and then fully purge the authority records that were not being used to clean up our database. There were about 100K out of 220K authority records in our system that were not being referenced by any bibs or other authority records. This should also significantly reduce the authority reingest time for our 2.12.6-3.0.0 upgrade step. I put the sql examples in a github gist. https://gist.github.com/stompro/d036829ff1fd4e0fe3dcddf8a75b4e77 Josh Lake Agassiz Regional Library - Moorhead MN larl.org Josh Stompro | Office 218.233.3757 EXT-139 LARL IT Director | Cell 218.790.2110
[OPEN-ILS-GENERAL] 3.0.6-3.1.0-upgrade-db.sql - item_lang attribute reingest redundant?
Hello, I'm curious if the item_lang attribute reingest in the 3.0.6-3.1.0 upgrade script is redundant since the script ends in a full reingest? Wouldn't the full reingest take care of all the attribute updates? 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] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish
Hello, I just noticed that the auditor table trigger is disabled during the visibility update, so that answers that question, it is something that is done. But it seem like it has a very small performance impact. On my test system reingest of 150 record batches takes 2.5% longer when the auditor table trigger is enabled. So my primary reason for doing it would just be to avoid audit table bloat. I’ve been trying out GNU parallel to run a bunch of ingest updates in parallel. I am seeing collisions on inserting into metabib.browse_entry, when two different queries each contain the same entry and are both trying to insert a new row. And I saw one deadlock detected also. But the joblog feature seems like it will take care of that, once the bulk of the queries are done, it can just resume running all the failed queries and just run them serially to finish up. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Wednesday, April 25, 2018 8:35 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish 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 again, does anyone disable the auditor table trigger for biblio.record_entry for updates like the 901 or a full reingest using the 1=1 method? I wonder if that would speed things up at all, and avoid some auditor table bloat. I also noticed that the auditor table for auditor.biblio_record_entry_history wasn’t updated with the new biblio.record_entry columns for vis_attr_vector, merge_date and merged_to. Is that something that I’m supposed to do manually whenever an audited table gets altered? Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Tuesday, April 24, 2018 9:03 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org>> Subject: Re: [OPEN-ILS-GENERAL] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish 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, Thank you all for the great info in this thread. I've been trying out some test upgrades from 2.10 -> 3.1 and have some questions that I thought I would just add here. I just want to make sure I understand which of the longer running updates do the same things as other updates for efficiency. My notes on the upgrade scripts are at https://docs.google.com/document/d/1Rh-ei7ffm3BVeMaJSDFte6LGgP4xt5VU16YZSOJ4uzg/edit?usp=sharing List of longer running updates 1. 2.10.7-2.11.0 – 901 field update via update set id=id method 2. 2.11.3-2.12.0 – Facet and Browse reingest via metabib.reingest_metabib_field_entries 3. 2.12.0-2.12.1 – Browse reingest via metabib.reingest_metabib_field_entries 4. 2.12.6-3.0.0 a. Display field reingest via metabib.reingest_metabib_field_entries b. Authority reingest via update set id=id method in a transaction 5. 3.0.6-3.1.0 – full reingest via update set id=id method in a function So from what I think I understand, these updates can all be completed by performing the 1. Authority reingest from 2.12.6-3.0.0. 2. Full reingest from 3.0.6-3.1.0. (should deal with all the indexes along with bre trigger updates for the 901 update). I’m looking into breaking these updates into smaller chunks and running them in parallel to speed them up and allow the system to function somewhat normally. I usually use the pingest.pl script, but I don’t think that script would take care of bre trigger based updates, since I think it calls metabib.reingest_metabib_field_entries to perform updates just on the indices. But I think I may run into trouble running multiple instances of each of these updates because of the transactions. I’m thinking that as is, the updating of the config.internal_flag and “alter table” will block other transactions. So maybe I’m better off using pingest.pl for the search re-indexing, which can be run in parallel, and then a simpler query for the “update set id=id on bre” bre trigger updates, which should skip the indexing updates. The authority update I should maybe just run serially, cut up into smaller chunks of records. Is there a pingest.pl script for authority reindexing? Also, could someone tell me the difference between using a “DO $FUNC$” for the 3.0.6-3.1.0 reingest verses how the 2.12.6-3.0.0 authority reingest uses commands in
Re: [OPEN-ILS-GENERAL] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish
Hello again, does anyone disable the auditor table trigger for biblio.record_entry for updates like the 901 or a full reingest using the 1=1 method? I wonder if that would speed things up at all, and avoid some auditor table bloat. I also noticed that the auditor table for auditor.biblio_record_entry_history wasn’t updated with the new biblio.record_entry columns for vis_attr_vector, merge_date and merged_to. Is that something that I’m supposed to do manually whenever an audited table gets altered? Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Tuesday, April 24, 2018 9:03 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish 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, Thank you all for the great info in this thread. I've been trying out some test upgrades from 2.10 -> 3.1 and have some questions that I thought I would just add here. I just want to make sure I understand which of the longer running updates do the same things as other updates for efficiency. My notes on the upgrade scripts are at https://docs.google.com/document/d/1Rh-ei7ffm3BVeMaJSDFte6LGgP4xt5VU16YZSOJ4uzg/edit?usp=sharing List of longer running updates 1. 2.10.7-2.11.0 – 901 field update via update set id=id method 2. 2.11.3-2.12.0 – Facet and Browse reingest via metabib.reingest_metabib_field_entries 3. 2.12.0-2.12.1 – Browse reingest via metabib.reingest_metabib_field_entries 4. 2.12.6-3.0.0 a. Display field reingest via metabib.reingest_metabib_field_entries b. Authority reingest via update set id=id method in a transaction 5. 3.0.6-3.1.0 – full reingest via update set id=id method in a function So from what I think I understand, these updates can all be completed by performing the 1. Authority reingest from 2.12.6-3.0.0. 2. Full reingest from 3.0.6-3.1.0. (should deal with all the indexes along with bre trigger updates for the 901 update). I’m looking into breaking these updates into smaller chunks and running them in parallel to speed them up and allow the system to function somewhat normally. I usually use the pingest.pl script, but I don’t think that script would take care of bre trigger based updates, since I think it calls metabib.reingest_metabib_field_entries to perform updates just on the indices. But I think I may run into trouble running multiple instances of each of these updates because of the transactions. I’m thinking that as is, the updating of the config.internal_flag and “alter table” will block other transactions. So maybe I’m better off using pingest.pl for the search re-indexing, which can be run in parallel, and then a simpler query for the “update set id=id on bre” bre trigger updates, which should skip the indexing updates. The authority update I should maybe just run serially, cut up into smaller chunks of records. Is there a pingest.pl script for authority reindexing? Also, could someone tell me the difference between using a “DO $FUNC$” for the 3.0.6-3.1.0 reingest verses how the 2.12.6-3.0.0 authority reingest uses commands in a transaction block? Is one method superior to another? Is the DO $FUNC$ method implicitly in a transaction? Thanks Josh Stompro - LARL IT Director -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jesse McCarty Sent: Wednesday, April 04, 2018 2:10 PM To: 'Evergreen Discussion Group' <open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org>> Subject: Re: [OPEN-ILS-GENERAL] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish Jason, If the authority reingest is the one that runs in the 2.12.0-2.12.1 script, it looks like between an hour/hour and a half on our test system this morning. I don't know how many bib records we have, but our Database sits about 24GB if that helps for comparison. Jesse McCarty City of Burlington Information Systems Technician -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Wednesday, April 04, 2018 11:58 AM To: open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish On 04/04/2018 02:46 PM, Jesse McCarty wrote: > Thank you Kathy, > > Those changes seemed to work great. What seemed to never end completed > in about a minute, and I
Re: [OPEN-ILS-GENERAL] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish
Hello, Thank you all for the great info in this thread. I've been trying out some test upgrades from 2.10 -> 3.1 and have some questions that I thought I would just add here. I just want to make sure I understand which of the longer running updates do the same things as other updates for efficiency. My notes on the upgrade scripts are at https://docs.google.com/document/d/1Rh-ei7ffm3BVeMaJSDFte6LGgP4xt5VU16YZSOJ4uzg/edit?usp=sharing List of longer running updates 1. 2.10.7-2.11.0 – 901 field update via update set id=id method 2. 2.11.3-2.12.0 – Facet and Browse reingest via metabib.reingest_metabib_field_entries 3. 2.12.0-2.12.1 – Browse reingest via metabib.reingest_metabib_field_entries 4. 2.12.6-3.0.0 a. Display field reingest via metabib.reingest_metabib_field_entries b. Authority reingest via update set id=id method in a transaction 5. 3.0.6-3.1.0 – full reingest via update set id=id method in a function So from what I think I understand, these updates can all be completed by performing the 1. Authority reingest from 2.12.6-3.0.0. 2. Full reingest from 3.0.6-3.1.0. (should deal with all the indexes along with bre trigger updates for the 901 update). I’m looking into breaking these updates into smaller chunks and running them in parallel to speed them up and allow the system to function somewhat normally. I usually use the pingest.pl script, but I don’t think that script would take care of bre trigger based updates, since I think it calls metabib.reingest_metabib_field_entries to perform updates just on the indices. But I think I may run into trouble running multiple instances of each of these updates because of the transactions. I’m thinking that as is, the updating of the config.internal_flag and “alter table” will block other transactions. So maybe I’m better off using pingest.pl for the search re-indexing, which can be run in parallel, and then a simpler query for the “update set id=id on bre” bre trigger updates, which should skip the indexing updates. The authority update I should maybe just run serially, cut up into smaller chunks of records. Is there a pingest.pl script for authority reindexing? Also, could someone tell me the difference between using a “DO $FUNC$” for the 3.0.6-3.1.0 reingest verses how the 2.12.6-3.0.0 authority reingest uses commands in a transaction block? Is one method superior to another? Is the DO $FUNC$ method implicitly in a transaction? Thanks Josh Stompro - LARL IT Director -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jesse McCarty Sent: Wednesday, April 04, 2018 2:10 PM To: 'Evergreen Discussion Group' <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish Jason, If the authority reingest is the one that runs in the 2.12.0-2.12.1 script, it looks like between an hour/hour and a half on our test system this morning. I don't know how many bib records we have, but our Database sits about 24GB if that helps for comparison. Jesse McCarty City of Burlington Information Systems Technician -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Wednesday, April 04, 2018 11:58 AM To: open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] 3.0.2-3.0.3 Upgrade DB script takes over a week to finish On 04/04/2018 02:46 PM, Jesse McCarty wrote: > Thank you Kathy, > > Those changes seemed to work great. What seemed to never end completed > in about a minute, and I was able to start up Evergreen and > search/renew and otherwise interact with the test system as expected > (in my limited IT testing role not being a library staff member that > fully utilizes the system). Is this to be expected to complete that > fast or should I be wondering if something didn't go as needed? Jesse, I think you're OK. That update went from never finishing on my test system to running in just 12 minutes. (We have several million bib records.) By never finishing, I mean I let it run for a few days before stopping it. If there were any problems, you should see error messages in the console where the script was running. I like to pipe the output to "tee" so it also goes to a file: psql -f upgrade_script.sql |& tee ~/upgrade_script.log The "|&" is a shortcut to send both standard output and errors to the file. Do you know how long the authority ingest part of the updrade scripts runs for you? That runs for over 30 hours on my test system, and it is already about as optimized as it can be. Cheers, Jason
Re: [OPEN-ILS-GENERAL] Change in DB action regarding SQL marc update
Jim, I wonder if this is a scope/search path issue? "oils_xpath" looks like it has no schema specified there. When I run "show search_path" I get show search_path; search_path --- evergreen, public, pg_catalog Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jim Taylor Sent: Monday, April 23, 2018 2:48 PM To: 'Evergreen Discussion Group' <open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] Change in DB action regarding SQL marc update I haven't done this for a while but just tried a straightforward SQL update of the "marc" field in the biblio.record_entry table and get the error below. Have done this 10's of thousands of times within the last year or so with no problem. Currently running version 2.12.6. Did something change which would purposely cause such an action to fail? Suggestions? Thanks. Jim ERROR: function oils_xpath(text, text, text[]) does not exist LINE 6: (oils_xpath( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. QUERY: SELECT COALESCE( naco_normalize( ARRAY_TO_STRING( oils_xpath( '//text()', (oils_xpath( idx.xpath, transformed_xml, ARRAY[ARRAY[xfrm.prefix, xfrm.namespace_uri]] ))[1] ), '' ) ), '' ) CONTEXT: PL/pgSQL function biblio.extract_fingerprint(text) line 34 at assignment PL/pgSQL function biblio.fingerprint_trigger() line 10 at assignment ** Error ** ERROR: function oils_xpath(text, text, text[]) does not exist SQL state: 42883 Hint: No function matches the given name and argument types. You might need to add explicit type casts. Context: PL/pgSQL function biblio.extract_fingerprint(text) line 34 at assignment PL/pgSQL function biblio.fingerprint_trigger() line 10 at assignment
Re: [OPEN-ILS-GENERAL] online registration and mobile app
Our previous ILS (Millennium) had this ability. The system would give the new self registration patron their internal database id number as their barcode. It was equivalent to the current patron pre-registration directly creating a patron with no staff review. And then staff could review the new accounts after they were created. We never really felt comfortable with that. I’m not sure that would really be compatible with our Overdrive contract if Overdrive wanted to take issue with it. Remember radical trust from a few years ago, I have a radical trust deficiency. Now Overdrive has their own self registration option, which is actually not compliant with our contract with them since it would willing give out cards to customers that are not in our service area. The most granular geographic boundary is by zip code, which cross county boundaries in several of our border cities. So maybe I shouldn’t worry so much about the few that might slip through. Here is a link to the wishlist bug report for patron self registration with immediate access. It would help if everyone that is interested in this feature would add comments about how they would like it to work and/or mark the bug as affecting you. https://bugs.launchpad.net/evergreen/+bug/1663295 Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Diane Disbro Sent: Thursday, April 19, 2018 1:17 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] online registration and mobile app This is what we will be doing as soon as we get the registration form the way I want it. :) What we REALLY want to be able to do is for patrons to register and be given an account number by the ILS. I've been told other ILSes (Is that a word?) perform this function. Diane Disbro Branch Manager/Circulation Coordinator Union Branch Scenic Regional Library 308 Hawthorne Drive Union, MO 63084 (636) 583-3224 ddis...@scenicregional.org<mailto:ddis...@scenicregional.org> On Thu, Apr 19, 2018 at 10:21 AM, Elizabeth Davis <eda...@albright.org<mailto:eda...@albright.org>> wrote: Shannon We use the mailing of the card as address confirmation. If the mail is returned, we update the record. Elizabeth From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org<mailto:open-ils-general-boun...@list.georgialibraries.org>] On Behalf Of Shannon Midyett Sent: Thursday, April 19, 2018 11:15 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org>> Subject: Re: [OPEN-ILS-GENERAL] online registration and mobile app Elizabeth, Do staff confirm address for patrons who receive cards via the online registration process? If so, how do they accomplish this? Thanks, Shannon Shannon Midyett Assistant Director [logosignature] Poplar Bluff Municipal Library 318 North Main Street | Poplar Bluff, MO 63901<https://maps.google.com/?q=318+North+Main+Street+%7C+Poplar+Bluff,+MO+63901=gmail=g> e: shan...@poplarbluff.org<mailto:shan...@poplarbluff.org> t: (573) 686 – 8639 | d: (573) 203 - 4676 website<http://poplarbluff.org/> | newsletter<http://poplarbluff.org/ots_issuu.html> | Annual Report<http://poplarbluff.org/annualreport.html> | Digital Library<http://poplarbluff.org/downloads.html> [Inline image 1]<http://www.facebook.com/poplarbluffpubliclibrary> [Inline image 2]<http://pbpl-genealogy.blogspot.com/> [Inline image 4]<http://pinterest.com/pbmld> [cid:image004.png@01D3D880.EA9F7A90]<http://instagram.com/poplarbluffmunicipallibrary> Poplar Bluff Municipal Library District with its community partners provides and promotes equal access to reading, information, cultural and intellectual resources. On Wed, Apr 18, 2018 at 6:05 PM, Elizabeth Davis <eda...@albright.org<mailto:eda...@albright.org>> wrote: We use the online registration form with a welcome email trigger. When staff process online applications, new card holders get a welcome email with their card number so that they can start using online resources. The physical card arrives a few days later via snail mail. It's not instant, but it's fairly quick. Elizabeth Davis Head of Digital Services Scranton Public Library From: Open-ils-general [open-ils-general-boun...@list.georgialibraries.org<mailto:open-ils-general-boun...@list.georgialibraries.org>] on behalf of Stroup, Meg [mstr...@statelibrary.sc.gov<mailto:mstr...@statelibrary.sc.gov>] Sent: Wednesday, April 18, 2018 6:29 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] online registration and mobile app >> We are interested in online registration that would allow patrons to use >> their accounts instant
Re: [OPEN-ILS-GENERAL] metabib.browse_entry unused cleanup?
Thanks Bill, is there any chance you have your checklist/script for what you cleanup shared anywhere? I would love to see what else you target when you clean things up once a year. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Bill Erickson Sent: Monday, April 02, 2018 3:31 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] metabib.browse_entry unused cleanup? Hi Josh, I clean these up about once a year. It's never been a problem, though. I just like cleaning things. -b On Mon, Apr 2, 2018 at 4:10 PM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello, I’ve been changing around some indexing rules and applied the fix to the full stop/rda relator code normalization issue and now just noticed that all the no longer used browse entries are sticking around in metabib.browse_entry. There are 175K entries out of 950K that are no longer used according to metabib.browse_entry_def_map and metabib.browse_entry_simple_heading_map. Has anyone found this to be an issue and removed those unused entries? I don’t think this is causing any issues, it just seems strange to hold on to that data. Any typo that was ever entered in a browse field and corrected is recorded there. Thanks Josh Lake Agassiz Regional Library - Moorhead MN larl.org<http://larl.org> Josh Stompro | Office 218.233.3757 EXT-139<tel:(218)%20233-3757> LARL IT Director | Cell 218.790.2110<tel:(218)%20790-2110>
[OPEN-ILS-GENERAL] metabib.browse_entry unused cleanup?
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
[OPEN-ILS-GENERAL] Adding series info to brief display, along with moving it in summary
Hello, as anyone added the series information to the brief record display or moved where the series info is in the record summary screen? We would like to place the series info below the title on the brief record display (search results) and move it from the bottom of the page to right below the title in the record summary. 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] HTML entities in MARC Record editor
Hello Dan, We are still on 2.10 using the XUL client, so maybe the 520 display anomaly has been fixed in a later version. I’ll make a note to check back once we are on a more modern version. Would it be accurate to say that characters like & in the marc editor are encoded as html entities in the biblio.record_entry.marc since they are stored as marc xml? The record that I was looking at was one of the free overdrive records, which are very very very rough, so it wouldn’t surprise me that they are grabbing the 520 from a web page and not being very careful with encoding. I just looked for occurrences of ‘amp’ and there are only 344 of them and all but 3 are from the free overdrive records. There are also quite a few instances(6000) of #8212; (em dash), again they are all the free overdrive records. I guess we get what we pay for. I’m tempted to just use regexp_replace against biblio.record_entry to try and clean these up, like the example here: https://wiki.evergreen-ils.org/doku.php?id=scratchpad:random_magic_spells#how_to_prune_a_tag_under_the_hood Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Dan Scott Sent: Tuesday, March 20, 2018 4:23 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] HTML entities in MARC Record editor Hi Josh: Quick question: XUL or web staff client? And version? In theory, what you see is what you should get - MARC has no idea what HTML entities are, so "" in the editor should be displayed as "" (properly escaped, of course) in the catalogue. If you see amp; in the biblio.record_entry.marc, it may be the result of corrupted catalogue enrichment efforts (e.g. grabbing the summary for a book from a website via a script with a bug), and thus should just be corrected directly to "&". Unless it's a deliberately torturous book title like "Escaping amp; other Secure Web Practices" :) If in the MARC shows up as just & in the 520 catalogue output, it sounds like there might be a bug for us to track down... Thanks, Dan On Tue, Mar 20, 2018 at 9:50 PM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello, could someone give me some pointers in regards to html entities in marc data? Sometimes I see used in 490a data and displayed as in the evergreen marc editor, and in the catalog it is displayed as and not as &. We also see things like a 520 that contains but it does get displayed as & in the catalog? And when I look at the biblio.record_entry.marc It looks like in the editor gets encoded as amp;, so is this a double encoding error? Should I ever see html entities when looking at marc data in the editor? If those should be cleaned up, anyone have any magic spells/queries for doing so? Thanks Josh Lake Agassiz Regional Library - Moorhead MN larl.org<http://larl.org> Josh Stompro | Office 218.233.3757 EXT-139<tel:(218)%20233-3757> LARL IT Director | Cell 218.790.2110<tel:(218)%20790-2110>
[OPEN-ILS-GENERAL] HTML entities in MARC Record editor
Hello, could someone give me some pointers in regards to html entities in marc data? Sometimes I see used in 490a data and displayed as in the evergreen marc editor, and in the catalog it is displayed as and not as &. We also see things like a 520 that contains but it does get displayed as & in the catalog? And when I look at the biblio.record_entry.marc It looks like in the editor gets encoded as amp;, so is this a double encoding error? Should I ever see html entities when looking at marc data in the editor? If those should be cleaned up, anyone have any magic spells/queries for doing so? 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] Normalizing full stops in personal author names
Hello Sarah, Kathy Lussier pointed me to the existing bug and fix for the issue I described. Looks like it was included in 2.12. https://bugs.launchpad.net/evergreen/+bug/1308090 It looks like it does follow the logic that you described, space then single letter then period, the period is kept. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Sarah Childs Sent: Wednesday, March 07, 2018 1:41 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Normalizing full stops in personal author names With the second approach, can it be a space and a single letter, regardless of case? In at least one example (k.d. lang), the authorized version is in lowercase, and there are probably others. On Wed, Mar 7, 2018 at 2:29 PM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello, I’m curious what the correct approach is for dealing with multiple entries in the browse and facet lists, when the difference is just the ending period/full stop. For example, Some of the records have =100 1\$aAdler-Olsen, Jussi,$eauthor. And some have =100 1\$aAdler-Olsen, Jussi. This results in two facet lines and two browse lines for the same author. Is the correct approach to normalize the data? Or would an index normalizer be appropriate here, something to remove periods when they are not preceded by a space and a single capital letter? Something like “r/([^ ][^A-Z])(\.)$/$1/” Thanks Lake Agassiz Regional Library - Moorhead MN larl.org<http://larl.org> Josh Stompro | Office 218.233.3757 EXT-139<tel:(218)%20233-3757> LARL IT Director | Cell 218.790.2110<tel:(218)%20790-2110> -- 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<mailto:sar...@zionsvillelibrary.org>
[OPEN-ILS-GENERAL] Normalizing full stops in personal author names
Hello, I'm curious what the correct approach is for dealing with multiple entries in the browse and facet lists, when the difference is just the ending period/full stop. For example, Some of the records have =100 1\$aAdler-Olsen, Jussi,$eauthor. And some have =100 1\$aAdler-Olsen, Jussi. This results in two facet lines and two browse lines for the same author. Is the correct approach to normalize the data? Or would an index normalizer be appropriate here, something to remove periods when they are not preceded by a space and a single capital letter? Something like "r/([^ ][^A-Z])(\.)$/$1/" Thanks 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] SIP authentication
Hello Diane, Our EG/SIPServer setup does include patron expiration info, and how much the user owes. That can be used by the vendor to block access based on the account being expired and owing more than a certain amount. But the vendor that is using SIP2 to authenticate has to handle that logic on their end. The sip response just sends the data about blocks in the message. It looks like the AF field also get set to blocked as well as the expiration date being sent in the PA field in the case of the account being expired. In the case of owing too much, the AF field again is set to "blocked" and the BV field has the total owed. So all they should have to do is look for AF = blocked and then refuse the authentication request. It seems like if you give them a few example test accounts they should be able to figure it out. That said, you may still run into vendors that refuse to handle things correctly on their end. You could also look into modifying the SIPServer software to short circuit the patron info/patron status responses. We just did something similar to keep patrons in certain profile groups from logging into certain services. OCLC refused our request for them to make use of the permission group info that gets sent along with the 64 patron status response, so we had to handle it on our end. I can give you details on the changes we made if you want to go down that route. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Diane Disbro Sent: Friday, March 02, 2018 10:59 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] SIP authentication Good morning - Do you block patrons with fines/expired accounts from using your online resources? How do you accomplish that? We recently found out that our patrons with fines/expired accounts are using our resources and neither our IT department nor the vendors we have contacted know how to prevent that from happening. Thank you. Diane Disbro Branch Manager/Circulation Coordinator Union Branch Scenic Regional Library 308 Hawthorne Drive Union, MO 63084 (636) 583-3224 www.scenicregional.org<http://www.scenicregional.org>
Re: [OPEN-ILS-GENERAL] Lost Materials Processing Fee - Option to not void on return
Ah, now I remember why I didn’t consider these. We only want to not void processing fees for lost and paid items. We want to void the processing fee for lost items. It is only when someone pays for something, indicating that they think they won’t be able to find it, that we may order a new copy and don’t want to refund the processing fee. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Andrea Buntz Neiman Sent: Tuesday, February 13, 2018 10:22 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Lost Materials Processing Fee - Option to not void on return Hi Josh, There are a few true/false library settings related to voiding processing fees: Void processing fee on lost item return Void lost item processing fee when claims returned Void processing fee on long-overdue item return Void longoverdue item processing fee when claims returned Would setting that first one to FALSE get you what you're looking for? Andrea On Tue, Feb 13, 2018 at 10:25 AM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello, I’m just curious if any other locations have this policy and how they have handled it. We currently have the policy of not refunding the Lost Materials processing fee when a lost and paid item is returned. Our thinking is that the lost processing fee covers some of the costs of re-ordering and processing a replacement item. So we don’t want to refund it since we could have already ordered a replacement copy. We are on 2.8 and I cannot currently see that there are any preferences related to not refunding the processing fee. So we have been handling it manually. I don’t see any future options that would allow this either. I’m curious if this policy is unique to us? If it isn’t, is anyone else interested in having an option to not refund processing fees? Thanks Josh Lake Agassiz Regional Library - Moorhead MN larl.org<http://larl.org> Josh Stompro | Office 218.233.3757 EXT-139<tel:(218)%20233-3757> LARL IT Director | Cell 218.790.2110<tel:(218)%20790-2110> -- Andrea Buntz Neiman Project Manager for Software Development Equinox Open Library Initiative abnei...@equinoxinitiative.org<mailto:abnei...@equinoxinitiative.org> 1-877-OPEN-ILS (673-6457) www.equinoxinitiative.org<http://www.equinoxinitiative.org>
Re: [OPEN-ILS-GENERAL] Hybrid Consortium: FIFO and Opportunistic
Yes, you have it correct. At checkin, the system uses the best hold sort order associated with the copies owning lib. Another side effect of using different best hold sort methods is that explaining it to staff gets convoluted. You can double check me also by looking at the code at http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/action.pm;hb=HEAD#l550 which shows the get_hold_sort_order being called using the copy owning lib as the only argument. And just a tip for testing, if you use soft hold stalling and you are placing a bunch of holds to test with, watch out for the effects of the soft stalling on the results. It may skip the hold you think should be picked because it isn't at the correct location. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of scott.tho...@sparkpa.org Sent: Tuesday, February 13, 2018 12:49 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Hybrid Consortium: FIFO and Opportunistic Hi Josh, This is very helpful. Just so I understand... Library System A uses FIFO and Library Systems B and C do not. There is resource sharing between all three library systems with 3 Month Age Protection. The item reaches the three month mark. At that time, the holds queue looks like this based on Request Time: 1. Patron Library B 2. Patron Library C 3. Patron Library B Assuming no other copies are making the rounds and the only copy available belongs to Library A, the holds will be filled exactly in this order even though libraries B and C are not FIFO? Thank you, Scott From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Tuesday, February 13, 2018 10:06 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org>> Subject: Re: [OPEN-ILS-GENERAL] Hybrid Consortium: FIFO and Opportunistic Hello Scott, we are much smaller than your organization, one system has 23 org units and the other has 10 org units. But we do have one system using request time as one of their primary sorts. They are not using pure FIFO, but request time is the determining sort for holds in the same system. They are using a modified hprox[1] sort that always prioritizes holds that are in the same system as the items owning location. So they will always fill all of their own holds first (in FIFO order) before the items will go to another system. And if another hold is placed for one of their patrons, their items will always come home to fill those next. Without using the modified hprox or without the age hold protection I don't think they would be very happy with FIFO. What they really wanted was FIFO for their own holds, not to fill the other system's holds first if they were newer. The best hold sort order is tied to the item's owning location. So the FIFO preference will follow their items when they get sent out to another system. So it could increase delivery load. In your case, If they just enabled FIFO with nothing else, then after the 3 month age hold protection is up, their items would start filling the oldest holds across the consortium. That is probably good for the other systems, but not ideal for their own patrons. This seems to work fine so far, but the same system that uses FIFO also is currently Age Hold Protecting their new items for 5 months. So not many of their new items ever get sent to the larger system anymore. So it is hard to know how it is really working out since the volume is so low. After switching to FIFO they haven't said anything about their delivery load being too high. And the larger system usually fills most of our high demand title holds before 5 months are up, so we don't have a large number of their FIFO items in delivery. When I look at how some of our high demand titles are operating, I do see situations where one or more locations get starved for items for months at a time because all the items are at other locations with many holds. It might actually help things out to have some fifo items in the mix, since those would help fill some of those holds that are older. We are also exploring turning off age hold protection as soon as an item has sat on the shelf for at least x number of days. One of the main reasons the smaller system uses the age hold protection is because they want their users to have a chance to browse and discover new items on the shelf before they go off to fill the larger system's holds for months at a time. As long as the item has been available on the shelf for a certain amount of time, they may be ok with the age hold protection getting turned off much sooner. 1 - https://bugs.launchpad.net/evergreen/+bug/173884
Re: [OPEN-ILS-GENERAL] Lost Materials Processing Fee - Option to not void on return
Thank you very much, sorry I missed seeing these in the first place. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Andrea Buntz Neiman Sent: Tuesday, February 13, 2018 10:22 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Lost Materials Processing Fee - Option to not void on return Hi Josh, There are a few true/false library settings related to voiding processing fees: Void processing fee on lost item return Void lost item processing fee when claims returned Void processing fee on long-overdue item return Void longoverdue item processing fee when claims returned Would setting that first one to FALSE get you what you're looking for? Andrea On Tue, Feb 13, 2018 at 10:25 AM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello, I’m just curious if any other locations have this policy and how they have handled it. We currently have the policy of not refunding the Lost Materials processing fee when a lost and paid item is returned. Our thinking is that the lost processing fee covers some of the costs of re-ordering and processing a replacement item. So we don’t want to refund it since we could have already ordered a replacement copy. We are on 2.8 and I cannot currently see that there are any preferences related to not refunding the processing fee. So we have been handling it manually. I don’t see any future options that would allow this either. I’m curious if this policy is unique to us? If it isn’t, is anyone else interested in having an option to not refund processing fees? Thanks Josh Lake Agassiz Regional Library - Moorhead MN larl.org<http://larl.org> Josh Stompro | Office 218.233.3757 EXT-139<tel:(218)%20233-3757> LARL IT Director | Cell 218.790.2110<tel:(218)%20790-2110> -- Andrea Buntz Neiman Project Manager for Software Development Equinox Open Library Initiative abnei...@equinoxinitiative.org<mailto:abnei...@equinoxinitiative.org> 1-877-OPEN-ILS (673-6457) www.equinoxinitiative.org<http://www.equinoxinitiative.org>
[OPEN-ILS-GENERAL] Lost Materials Processing Fee - Option to not void on return
Hello, I'm just curious if any other locations have this policy and how they have handled it. We currently have the policy of not refunding the Lost Materials processing fee when a lost and paid item is returned. Our thinking is that the lost processing fee covers some of the costs of re-ordering and processing a replacement item. So we don't want to refund it since we could have already ordered a replacement copy. We are on 2.8 and I cannot currently see that there are any preferences related to not refunding the processing fee. So we have been handling it manually. I don't see any future options that would allow this either. I'm curious if this policy is unique to us? If it isn't, is anyone else interested in having an option to not refund processing fees? 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] Hybrid Consortium: FIFO and Opportunistic
Hello Scott, we are much smaller than your organization, one system has 23 org units and the other has 10 org units. But we do have one system using request time as one of their primary sorts. They are not using pure FIFO, but request time is the determining sort for holds in the same system. They are using a modified hprox[1] sort that always prioritizes holds that are in the same system as the items owning location. So they will always fill all of their own holds first (in FIFO order) before the items will go to another system. And if another hold is placed for one of their patrons, their items will always come home to fill those next. Without using the modified hprox or without the age hold protection I don't think they would be very happy with FIFO. What they really wanted was FIFO for their own holds, not to fill the other system's holds first if they were newer. The best hold sort order is tied to the item's owning location. So the FIFO preference will follow their items when they get sent out to another system. So it could increase delivery load. In your case, If they just enabled FIFO with nothing else, then after the 3 month age hold protection is up, their items would start filling the oldest holds across the consortium. That is probably good for the other systems, but not ideal for their own patrons. This seems to work fine so far, but the same system that uses FIFO also is currently Age Hold Protecting their new items for 5 months. So not many of their new items ever get sent to the larger system anymore. So it is hard to know how it is really working out since the volume is so low. After switching to FIFO they haven't said anything about their delivery load being too high. And the larger system usually fills most of our high demand title holds before 5 months are up, so we don't have a large number of their FIFO items in delivery. When I look at how some of our high demand titles are operating, I do see situations where one or more locations get starved for items for months at a time because all the items are at other locations with many holds. It might actually help things out to have some fifo items in the mix, since those would help fill some of those holds that are older. We are also exploring turning off age hold protection as soon as an item has sat on the shelf for at least x number of days. One of the main reasons the smaller system uses the age hold protection is because they want their users to have a chance to browse and discover new items on the shelf before they go off to fill the larger system's holds for months at a time. As long as the item has been available on the shelf for a certain amount of time, they may be ok with the age hold protection getting turned off much sooner. 1 - https://bugs.launchpad.net/evergreen/+bug/1738844 - If anyone else would find this useful it would be good to get some feedback on it. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of scott.tho...@sparkpa.org Sent: Tuesday, February 13, 2018 6:53 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] Hybrid Consortium: FIFO and Opportunistic Hi, Our consortium is currently at 121 members and growing. While individual library systems practice resource sharing and we are in the midst of a resource sharing trial between three more distant libraries, we do not have consortium-wide resource sharing at this time. Holds consortium-wide are set to not use FIFO. This has not been a problem, but now one local system has requested to be switched to FIFO. I am not unsympathetic: they are a consolidated library system with two buildings both within a mile of each other. For them there is no intrinsic advantage to opportunistic holds, and the current method is unpopular with patrons. However, they resource share with two other nearby library systems that are not FIFO. If we were to switch this library to FIFO, what implications would it have for the other two non-FIFO libraries with whom they resource share? I am not sure if it matters, but they use 3 month age protection. Thank you, Scott Scott Thomas Executive Director PaILS / SPARK (717) 873-9461 scott.tho...@sparkpa.org<mailto:scott.tho...@sparkpa.org> Stay informed! Join the SPARK-User Email List: https://mail.palibrary.org/mailman/listinfo/spark-users [Description: Description: Training | SPARK - Pennsylvania's Statewide Library System]<http://www.palibrary.org/pails/>
Re: [OPEN-ILS-GENERAL] RSS to display OPAC lists on wordpress sites?
Hello Katie, was trying to do this a while back but never got it working. Here is the bug report I opened on it https://bugs.launchpad.net/evergreen/+bug/1674364 According to that bug, PINES did get it working, and includes their code changes. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Katie Greenleaf Martin Sent: Wednesday, January 31, 2018 10:49 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] RSS to display OPAC lists on wordpress sites? Hello Evergreen Community :) I have several libraries who want to use RSS to display their bookbags (either manually or automatically created) on their website. Does anyone know of a reliable Wordpress widget that would display the feed with the cover images? Looking forward to seeing some of you at ALA MW in a few weeks! -- Katie Greenleaf Martin, MLIS b...@blaircountylibraries.org<mailto:b...@blaircountylibraries.org> 814.946.0417x132 County Coordinator Blair County Library System
Re: [OPEN-ILS-GENERAL] Evergreen 3.1 Release Update
Dan, I’m curious if your comment coverage counts the Opensrf method documentation? The “__PACKAGE__->register_method(“ signature/notes => info? I’ve noticed that sometimes those are very complete<http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/Application/Actor/Container.pm;h=badb13482d2c31c0c7b42ec3d85d0be70bb40f2c;hb=HEAD#l327> with a description, notes, parameter dos, and return value docs, while others are very basic<http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/Application/Actor/Container.pm;h=badb13482d2c31c0c7b42ec3d85d0be70bb40f2c;hb=HEAD#l475>. That might be another aspect of the code documentation to evaluate and work on if someone is adding comments to a specific file. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Daniel Wells Sent: Thursday, January 25, 2018 11:28 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] Evergreen 3.1 Release Update Hello all, We are now entering the busy period of the release cycle, so I would like to take a moment to highlight a variety of efforts underway for the 3.1 release. 1) We are about two weeks away from "feature slush", currently set for Feb. 9. What does this mean? To quote from our "versioning" wiki page it means: "major planning for features is complete; at this point, all significant features should either have been merged or at least have LP bugs and pullrequests". Of course, the nature of slush is that it isn't very solid, so there is still some flexibility at this stage, but if this deadline isn't met, chances of getting a new feature into the release begin to diminish considerably. Please take note! 2) We are one month from feature freeze for 3.1 (Feb. 23). Updates to the roadmap continue to come in: https://wiki.evergreen-ils.org/doku.php?id=faqs:evergreen_roadmap:3.1 For example, an interesting new entry was added last week regarding more search improvements (https://bugs.launchpad.net/evergreen/+bug/1744385). Thank you, MassLNC and Equinox! To everyone, please continue to add to, update, and revise the roadmap throughout the feature slush period. 3) As part of my release goal to improve documentation and understanding for new developers, I have done some basic comment analysis of our Perl services code, and created a sign up matrix for anyone wishing to help nudge things forward. For more explanation, or to sign up, please see here: https://docs.google.com/spreadsheets/d/17XCFAxuLvYKdjk4uDhlzzAZC28AGyQV3vugTnBXBtzg/edit?usp=sharing 4) Bill Erickson in late December published his first set of notes regarding a transition from AngularJS to Angular: https://wiki.evergreen-ils.org/doku.php?id=dev:browser_staff:angular5 Moving fully over for 3.1 was always a stretch goal, but I think simpler changes like Bill's proposal to switch to Webpack are very doable in this release to help smooth the way. Thank you, Bill! 5) I have made a first pass at making sure the roadmap and the related bugs in LP are in sync, and also getting various bugs to their proper tags and targets. To help us all make use of LP more effectively, Remington and I have also made notable progress in getting usable results out of LaunchPad's web API, and are experimenting with generating simpler views as a release "dashboard" of sorts (nothing fancy at this stage). We hope to have something to show in the next week or so; please stay tuned. 6) Not directly 3.1 related, but worth mentioning as general release news. For the last point-releases, we did an initial trial run of using a signup sheet for splitting build tasks among the buildmaster volunteers. It is basic, but I do think it will help spread the load over time. You can see that sheet here: https://docs.google.com/spreadsheets/d/1gZayHfF7qK0zwLMEAXt-PbKBMiAM_F6EZguqzIYceBY/edit#gid=0 It is never too late to help out with builds; just join the ##eg-release channel on FreeNode and make some noise, and we'll find you a seat. Sincerely, Dan
Re: [OPEN-ILS-GENERAL] Reading History opt in on patron application
Hello Diane, this doesn’t change how the circ history can be accessed. It is still only available in the catalog when a customer logs into their account. It just allows staff to enable the feature in the patron registration screen, or patron edit screens. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Diane Disbro Sent: Friday, January 26, 2018 9:52 AM To: 'Evergreen Discussion Group' <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Reading History opt in on patron application Good morning – If the option of saving circ history is enabled during registration, is that history visible on the staff client or only on the OPAC? Thank you. Diane Disbro Circulation Coordinator/Branch Manager Union Branch Scenic Regional Library 308 Hawthorne Drive Union, MO 63084 (636) 583-3224 www.scenicregional.org<http://www.scenicregional.org> From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Friday, January 26, 2018 8:48 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Reading History opt in on patron application Hello, I just wanted to revisit this topic since I had a chance to look into the implementation side. We have discussed the “should we do this at all” on our end and have decided that it is something we want to offer. Specifically allowing staff to enable the circ history for customers. I want to thank everyone for sharing their thoughts on this issue. The feature mentioned by Eva, allowing staff to be alerted based on the users circ history at checkout was quite interesting. That would be very useful for some of our customers that seem to devour some genre fiction. I created bug #1745623 for that feature request. It was really easy to add it, and the enabling part just works. I should mention that we are still using the XUL client, I don’t know if this works with the web client yet. The circ history is controlled by a pair of user settings, history.circ.retention_age and history.circ.retention_start. If either of those exist for a user and have a non-blank value then the circ history is kept for that user. When enabling the circ history in the catalog, only history.circ.retention_start gets set, and gets set to the current date. But the value doesn’t actually matter, it just needs to be non-blank to be considered true. To trigger that preference to show up in the patron registration screen, you need to assign it as an opt in setting type of a dummy action_trigger event definition. I just created one based on the au.created hook, but I think that any passive hook would work. The event def doesn’t even need to be enabled for it to work. I also went into the user_settings type editor and changed the label for history.circ.retention_start so that it is called “Save my Checkout History”. We might change that in the future since that label isn’t exposed to customers in the catalog to something more staff focused. After those steps the preference will show up on the patron registration screen. The sorting of it seems to be based on the hidden name of the user setting, not the label. So in our case it puts that preference first. That isn’t ideal for us, but not that big of a deal. If the preference is set by staff during registration or afterwards, it changes the value of the user setting to ‘true’. Since the circ history just needs the setting to have a non-blank value this enables it. If customers then disable the feature from the catalog, the feature gets turned off correctly and the circ history is purged like normal. When staff turn off the feature the setting gets changed to ‘false’ and the circ history isn’t purged. The setting of ‘false’ is non blank, so the history stays on. So the one scheduled change we will run daily is to look for those situations and delete the setting and delete the circ history. We will just make it clear to staff that deleting the circ history is completed overnight. In some ways this is a nice safety feature. Customers get a confirmation dialog for removing their circ history. This give staff a chance to realize they checked the wrong box and undo their change. The batch query that we will run is at https://gist.github.com/stompro/e1f3a377ee6b7e044c285b482a1e0a50 The batch process could also add extra notifications to the user about this feature being enabled or disabled. We could add a message to the message center, send an email, send a text, etc. In the future, I think the settings for enabling the circ history will be moved to a single Boolean setting, which should integrate with the staff access better. The current two settings made sense back when the circ history was looking directly at circulation transactions, but now that it is stored separately it doesn’t make a
Re: [OPEN-ILS-GENERAL] Reading History opt in on patron application
Hello, I just wanted to revisit this topic since I had a chance to look into the implementation side. We have discussed the “should we do this at all” on our end and have decided that it is something we want to offer. Specifically allowing staff to enable the circ history for customers. I want to thank everyone for sharing their thoughts on this issue. The feature mentioned by Eva, allowing staff to be alerted based on the users circ history at checkout was quite interesting. That would be very useful for some of our customers that seem to devour some genre fiction. I created bug #1745623 for that feature request. It was really easy to add it, and the enabling part just works. I should mention that we are still using the XUL client, I don’t know if this works with the web client yet. The circ history is controlled by a pair of user settings, history.circ.retention_age and history.circ.retention_start. If either of those exist for a user and have a non-blank value then the circ history is kept for that user. When enabling the circ history in the catalog, only history.circ.retention_start gets set, and gets set to the current date. But the value doesn’t actually matter, it just needs to be non-blank to be considered true. To trigger that preference to show up in the patron registration screen, you need to assign it as an opt in setting type of a dummy action_trigger event definition. I just created one based on the au.created hook, but I think that any passive hook would work. The event def doesn’t even need to be enabled for it to work. I also went into the user_settings type editor and changed the label for history.circ.retention_start so that it is called “Save my Checkout History”. We might change that in the future since that label isn’t exposed to customers in the catalog to something more staff focused. After those steps the preference will show up on the patron registration screen. The sorting of it seems to be based on the hidden name of the user setting, not the label. So in our case it puts that preference first. That isn’t ideal for us, but not that big of a deal. If the preference is set by staff during registration or afterwards, it changes the value of the user setting to ‘true’. Since the circ history just needs the setting to have a non-blank value this enables it. If customers then disable the feature from the catalog, the feature gets turned off correctly and the circ history is purged like normal. When staff turn off the feature the setting gets changed to ‘false’ and the circ history isn’t purged. The setting of ‘false’ is non blank, so the history stays on. So the one scheduled change we will run daily is to look for those situations and delete the setting and delete the circ history. We will just make it clear to staff that deleting the circ history is completed overnight. In some ways this is a nice safety feature. Customers get a confirmation dialog for removing their circ history. This give staff a chance to realize they checked the wrong box and undo their change. The batch query that we will run is at https://gist.github.com/stompro/e1f3a377ee6b7e044c285b482a1e0a50 The batch process could also add extra notifications to the user about this feature being enabled or disabled. We could add a message to the message center, send an email, send a text, etc. In the future, I think the settings for enabling the circ history will be moved to a single Boolean setting, which should integrate with the staff access better. The current two settings made sense back when the circ history was looking directly at circulation transactions, but now that it is stored separately it doesn’t make as much sense. There is a comment in the circ history database function about changing it someday. bug #1745624 Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan Hamby Sent: Wednesday, October 18, 2017 5:06 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Reading History opt in on patron application There's a lot to think about here. I do like the idea of the setting being on the patron registration page so that staff can turn it on and off for patrons as an assistance. Actually, I think we should have had that for a long time now. If you're doing this as a local hack how you do it is certainly up to you but if it's an actual change to Evergreen code the idea of tying it to a nightly cron job unnecessary. There is a question about if older circs should get fed in but that might be tangential here and more about how the reading history works. I'm not fond of giving staff access to the history though. Staff trusted with reporter permissions can do that anyway, to the extent that you haven't aged out circulations anyway. It feels like an unnecessary thr
Re: [OPEN-ILS-GENERAL] Seeking Development Partners: Patron Requests
Scott, This is the feature that potentially collects patron/staff suggestions for titles to purchase, right? Is there currently a specification for this feature? I'm curious if any ability to limit number of requests per requestor are planned? Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of scott.tho...@sparkpa.org Sent: Thursday, January 18, 2018 12:34 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] Seeking Development Partners: Patron Requests Hi, Pennsylvania Integrated Library System (PaILS) is seeking funding partners for development of the Patron Request Module. The development will bring this module into the Angular framework so it is truly Web Client. It will add better support for editing requests, include infrastructure changes to fix known bugs, and enhance the tracking of Request Status. This module is little used due to many issues. When fully functional, it will prevent staff from having to record patron purchase requests in 3rd party, non-integrated solutions such as a spreadsheet. If you are interested, please contact me off-list. Thank you, Scott Scott Thomas Executive Director PaILS / SPARK (717) 873-9461 scott.tho...@sparkpa.org<mailto:scott.tho...@sparkpa.org> Stay informed! Join the SPARK-User Email List: https://mail.palibrary.org/mailman/listinfo/spark-users [Description: Description: Training | SPARK - Pennsylvania's Statewide Library System]<http://www.palibrary.org/pails/>
[OPEN-ILS-GENERAL] added content - content cafe - Premature end of data in tag JacketItem
Hello, starting substantially around December 26th, I've been seeing an increasing number of error entries in our osrferror logs having to do with cover art from content café. Has anyone else see this issue? I'm thinking I need to take a look at the xml file that Content Café is sending us for the added content data. 2018-01-03 10:29:23 virt-egapp2 osrf_http_translator: [perl:error] [pid 2604] [client 192.168.45.10:51318] :26: parser error : Premature end of data in tag Jacket line 26\n31061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A26\n ^\n:26: parser error : Premature end of data in tag JacketItem line 21\n31061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A26\n ^\n:26: parser error : Premature end of data in tag JacketItems line 20\n31061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A26\n ^\n:26: parser error : Premature end of data in tag RequestItem line 17\n31061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A26\n ^C ^\n:26: parser error : Premature end of data in tag RequestItems line 3\n31061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A26\n ^\n:26: parser error : Premature end of data in tag ContentCafe line 2\n31061241510761711322328108144291A1B1C109233352F0156272D10A162434E125F11718191A26\n ^\n, referer: https://egcatalog.larl.org/eg/opac/results?query=Snow;qtype=title;locg=1;detail_record_view=0;page=1 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] Reports - Simple Record Extracts
Hello Eva, I worked on a change to the Simple Record Extracts recently which was included in the 3.0 release, so I panicked when I saw your message, but then saw that you are not on 3.0. Even though I don’t think I caused the problem, it is fresh in my mind so here are some suggestions. The Simple Record Extracts data is from the table reporter.super_simple_record. So you could double check that table for entries for newer titles. There should be one row for each bib record in your system, including deleted bib records. That data is kept up to date by a trigger that could be disabled on your system. The following SQL should show you if that trigger exists for the biblio.record_entry table. select tgrelid::regclass, tgname from pg_trigger where tgname~'simple_rec'; If it doesn’t exist, then I would suggest you look through your database upgrade logs and scripts to see what might have gone wrong. There may have been an update to that trigger that didn’t fully complete during your upgrade. I just took a quick look at the 2.10->2.12 upgrade sql scripts and I couldn’t spot a likely spot, I don’t see super_simple_record mentioned anywhere, or the trigger. You can also perform some queries on the reporter.old_super_simple_record view, which is where the data actually comes from. If entries for newer titles shows up in that view, then I think you can try to just re-enable and rebuild the data. You can attempt to re-enable that trigger with the following SQL, there is a nice shortcut function that tries to delete the trigger, empty out reporter.super_simple_record and then re populates it and enables the trigger. Begin; Select reporter.refresh_materialized_simple_record(); --Check to see if data looks correct. select * from reporter.super_simple_record where id >= 26; -- use a bib id from after your upgrade. Then do a “Rollback;” to get rid of changes if things don’t look right, or do a “Commit;” if everything looks good. That command will take some time to work through all your bib records. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Cerninakova Eva Sent: Monday, January 01, 2018 1:56 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] Reports - Simple Record Extracts Hi, after upgrade from Evergreen 2.10 to 2.12 (currently we are on 2.12.4) we have discovered that some values extracted from the bibliographic record were not included to reports. This specifically applies to simple record extracts, particularly to these fields: Item -> Call Number/Volume -> Bib Record -> Simple Record Extracts -> Author (normalized) Item -> Call Number/Volume -> Bib Record -> Simple Record Extracts -> Title Proper (normalized) Item -> Call Number/Volume -> Bib Record -> Simple Record Extracts -> Publisher (normalized) Item -> Call Number/Volume -> Bib Record -> Simple Record Extracts -> Publication Year (normalized) Item -> Call Number/Volume -> Bib Record -> Simple Record Extracts -> ISBN The problem concerns not only "item" source (also "Invoice" and other sources using simple record extracts), however, applies only to records created after the upgrade - in cases when record had been created before upgrade and only new copy was added after the upgrade, the record extracts are included to report correctly, see example https://docs.google.com/spreadsheets/d/12KmF3jWjwWWFAzUt99HgF5rcWSh4Z8Bbj248iD1hn50/edit?usp=sharing (items added after upgrade are red). Could this be a bug? And is there a way how to get correct values in autor column, title column etc. to reports? Maybe there is any other way than using simple record extracts? Thanks a lot for any hint. Eva --- Mgr. Eva Cerniňáková cer...@jabok.cz<mailto:cer...@jabok.cz> Tel. +420 211 222 409<tel:+420%20211%20222%20409> Knihovna Jabok http:/knihovna.jabok.cz<http://knihovna.jabok.cz> Tel. +420 211 222 410<tel:+420%20211%20222%20410> Jabok - Vyšší odborná škola sociálně pedagogická a teologická Salmovská 8, 120 00 Praha 2 [https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png]<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail> Bez virů. www.avg.com<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
[OPEN-ILS-GENERAL] EG data backup retention policy
Hello, I'm curious how many systems have a policy for how long you keep evergreen data backups. And I'm also wondering how long you keep your backup snapshots? I heard a comment from leadership of another library system that they keep 2 tapes/copies. The one in the drive waiting to be written and the one copy that is off site. With the goal of minimizing historical data that can be seized by law enforcement. I've always been way more paranoid of any one backup being bad vs worrying about data being seized, so the idea of only having one or two backup snapshots of the database makes me nervous. 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
[OPEN-ILS-GENERAL] Best Hold Sort Order - System Level Proximity Option?
Hello, I'm just curious if this is currently possible. We have one system that wants to fill their holds in FIFO order, but also wants holds from any of their branches to have priority over holds from other systems. It seems to me that all the owning location aware proximity sort options would prioritize based on a specific owning location. What they don't want is any one hold for their patrons to be prioritized over another hold for one of their patrons. I think the hprox, htime and shtime would all give priority to holds that have the same pickup lib as the item owning location. They float all items, so the owning location doesn't really mean anything to them. We don't really want to use soft boundaries and the depth sort order because we don't want there to be restrictions set at the time the hold is placed. We want the system to be more flexible. But maybe I'm not understanding how that works, and it would do just what I'm asking? Maybe there could be a new sort option, hpprox , Owning Library parent to pickup library parent proximity with no adjustments? 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] SIP2 - Block certain patrons from authenticating for a particular login - Evergreen End
I think I found a way to hard code this sort of check into sipserver, once I found the correct spot to look. At the following locations I just added a check to not allow certain combinations of sip login accounts and patron types. This seems to short circuit the login check/info check correctly, just for the services that we want to restrict. http://git.evergreen-ils.org/?p=SIPServer.git;a=blob;f=Sip/MsgType.pm;h=bd7cb521beeda53787a64264a0f75a4364285d11;hb=HEAD#l458 http://git.evergreen-ils.org/?p=SIPServer.git;a=blob;f=Sip/MsgType.pm;h=bd7cb521beeda53787a64264a0f75a4364285d11;hb=HEAD#l1001 The patron type and login username was readily available. if ($patron && !($server->{account}='SIP_MNLINK' && $patron->ptype =~ m/LARL Temporary|LARL ND Reciprocal|LARL Fee|LARL ILL/)) { I love evergreen! And thanks to wolfram alpha for building me a truth table to make sure I had the logic correct. https://www.wolframalpha.com/input/?i=P+and+not+(+Q+and+Z+) Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Thursday, December 07, 2017 2:20 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] SIP2 - Block certain patrons from authenticating for a particular login - Evergreen End This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing> Feedback<http://aka.ms/SafetyTipsFeedback> I just realized that I was wrong about the patron info response not including the patron type, it does include it in the PC message, but I think it would still be nice to do this server side in some cases. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Thursday, December 07, 2017 11:47 AM To: 'Evergreen Discussion Group' <open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org>> Subject: [OPEN-ILS-GENERAL] SIP2 - Block certain patrons from authenticating for a particular login - Evergreen End This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing> Feedback<http://aka.ms/SafetyTipsFeedback> Hello, Has anyone come up with a way of controlling authentication via sip2 on the sip2 server side for particular users or types of users? We have various different services that authenticate via sip2, such as our patron management (cassie), Overdrive, and our state ILL system (MNLINK). The problem we are running into is that certain user groups (permission groups) shouldn't be able to access some of those services. For example, we have temporary users that have more limited capabilities since we cannot fully verify their info, or their residence status is in flux. We don't want those patrons to be able to request material from other libraries, but we do want them to be able to access public computers and overdrive. The patron permission group doesn't seem like it is something that is sent in the patron status response to the vendors, so I don't think there is a way for them to check it on their end. And it seems like it would be more fool proof to handle it on the server side, not trusting a vendor to take care of something. When we used the III patron API product the info was sent to the vendor (basically the entire patron record was sent which wasn't great), but it did take care of this issue for us. I'm wondering if something along the lines of a custom permission would work. Only allow users in a certain group to authenticate through a certain sip2 connection (identified by the sip2 login). So a patron had the permission SIP_AUTH_SIP_MNLINK allow their barcode to authenticate. This would probably also require a library setting to make it opt in since there would be setup required. Alternatively, add a standing penalty that includes a block in the form |SIP_AUTH_SIP_MNLINK to block authentication for those patrons. And then make sure we always add that block for users that we don't want. Then we could add the penalty manually or with a nightly query. The SIP code would look for a block in that form and deny auth if it shows up. I've been looking at Open-ILS/src/perlmods/lib/OpenILS/SIP/Patron.pm to see how ether of these might fit in. I'm not quite sure if the sip2 connection username is available to that code though. I'll keep looking. 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] SIP2 - Block certain patrons from authenticating for a particular login - Evergreen End
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' <open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] SIP2 - Block certain patrons from authenticating for a particular login - Evergreen End This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing> Feedback<http://aka.ms/SafetyTipsFeedback> Hello, Has anyone come up with a way of controlling authentication via sip2 on the sip2 server side for particular users or types of users? We have various different services that authenticate via sip2, such as our patron management (cassie), Overdrive, and our state ILL system (MNLINK). The problem we are running into is that certain user groups (permission groups) shouldn't be able to access some of those services. For example, we have temporary users that have more limited capabilities since we cannot fully verify their info, or their residence status is in flux. We don't want those patrons to be able to request material from other libraries, but we do want them to be able to access public computers and overdrive. The patron permission group doesn't seem like it is something that is sent in the patron status response to the vendors, so I don't think there is a way for them to check it on their end. And it seems like it would be more fool proof to handle it on the server side, not trusting a vendor to take care of something. When we used the III patron API product the info was sent to the vendor (basically the entire patron record was sent which wasn't great), but it did take care of this issue for us. I'm wondering if something along the lines of a custom permission would work. Only allow users in a certain group to authenticate through a certain sip2 connection (identified by the sip2 login). So a patron had the permission SIP_AUTH_SIP_MNLINK allow their barcode to authenticate. This would probably also require a library setting to make it opt in since there would be setup required. Alternatively, add a standing penalty that includes a block in the form |SIP_AUTH_SIP_MNLINK to block authentication for those patrons. And then make sure we always add that block for users that we don't want. Then we could add the penalty manually or with a nightly query. The SIP code would look for a block in that form and deny auth if it shows up. I've been looking at Open-ILS/src/perlmods/lib/OpenILS/SIP/Patron.pm to see how ether of these might fit in. I'm not quite sure if the sip2 connection username is available to that code though. I'll keep looking. 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
[OPEN-ILS-GENERAL] SIP2 - Block certain patrons from authenticating for a particular login - Evergreen End
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 issue for us. I'm wondering if something along the lines of a custom permission would work. Only allow users in a certain group to authenticate through a certain sip2 connection (identified by the sip2 login). So a patron had the permission SIP_AUTH_SIP_MNLINK allow their barcode to authenticate. This would probably also require a library setting to make it opt in since there would be setup required. Alternatively, add a standing penalty that includes a block in the form |SIP_AUTH_SIP_MNLINK to block authentication for those patrons. And then make sure we always add that block for users that we don't want. Then we could add the penalty manually or with a nightly query. The SIP code would look for a block in that form and deny auth if it shows up. I've been looking at Open-ILS/src/perlmods/lib/OpenILS/SIP/Patron.pm to see how ether of these might fit in. I'm not quite sure if the sip2 connection username is available to that code though. I'll keep looking. 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] Catalog holds status display - Hold queue and potential copies
Hello Scott, we do resource share. One of our systems is 3x larger than the other, so the smaller system uses age hold protection on their new items to keep them home for a while. Otherwise we were seeing 4x more holds placed by the larger system which was pulling a disproportionate share of new material from the smaller system. The smaller system also recently decided to use FIFO vs proximity for their holds, while the larger system is sticking with check-in proximity priority. Most of the highly sought after items that have lots of holds are new items in our experience, so the smaller system that is using FIFO will only fill their own customers holds in FIFO order until the age hold protection expires. Once it expires then there is a chance that the larger system’s holds will get priority if they are older than the remaining smaller systems holds. We don’t know if that is going to be a problem in actual usage yet. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of scott.tho...@sparkpa.org Sent: Tuesday, November 28, 2017 7:31 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Catalog holds status display - Hold queue and potential copies 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<mailto:scott.tho...@sparkpa.org> [Description: Description: Training | SPARK – Pennsylvania's Statewide Library System]<http://www.palibrary.org/pails/> From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Diane Disbro Sent: Monday, November 27, 2017 8:30 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org>>; ME list serv <evergr...@lists.mobiusconsortium.org<mailto:evergr...@lists.mobiusconsortium.org>> Subject: Re: [OPEN-ILS-GENERAL] Catalog holds status display - Hold queue and potential copies I am very interested to hear if someone has done something with this other than try to explain to disgruntled patrons why they see in their online account that they are next in the queue for an item but they wait weeks or months to get it. Thank you, Josh, for asking. Diane Disbro Circulation Coordinator/Branch Manager Union Branch Scenic Regional Library 308 Hawthorne Drive Union, MO 63084 (636) 583-3224 On Mon, Nov 27, 2017 at 4:28 PM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello, Those of you that use age hold protection and non FIFO best hold selection sort order, what have you done with the status column of holds in your catalog. We just noticed that it is showing the FIFO queue position for holds, along with all potential copies. This gives users bad info since for us holds are sometimes filled in FIFO order for some orgs, and are filled based on proximity for other locations. And since one org uses age hold protection, the total copy count isn’t accurate either since half the copies might be age hold protected so they cannot fill the users holds. Did you just remove that section from templates/opac/parts/hold_status.tt2? Did you modify it in some way? I would like to see examples of what you changed it to if you changed it. Should the potential copies count exclude copies that are age hold protected and cannot be captured for that hold? Right now it pulls from hold copy map, but it looks like restricting the copy count based on the age hold protection might be possible to add. Thanks Josh Lake Agassiz Regional Library - Moorhead MN larl.org<http://larl.org> Josh Stompro | Office 218.233.3757 EXT-139<tel:(218)%20233-3757> LARL IT Director | Cell 218.790.2110<tel:(218)%20790-2110>
[OPEN-ILS-GENERAL] Catalog holds status display - Hold queue and potential copies
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 LARL IT Director | Cell 218.790.2110
Re: [OPEN-ILS-GENERAL] Star receipt printer , self check, pause before cut
After sending this message I thought of one other critical difference between the selfcheck and administrator logins. We have openkiosk set to run directly as the shell, so explorer doesn't run. And that seems to be the culprit. When I launch openkiosk from the normal explorer shell, then the printing works fine, with no delay before cut. So I think this is solved. Sorry about the noise. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Friday, November 03, 2017 8:53 AM To: open-ils-general@list.georgialibraries.org Subject: [OPEN-ILS-GENERAL] Star receipt printer , self check, pause before cut 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, I'm curious if anyone has run into this and found a solution for it. We use Star TSP100 and TSP600 receipt printers. Our self check machines use the web based self check interface. We use the openkiosk browser to serve up the self check interface on our machines. When I'm logged in as administrator and test out the self check printing a receipt, the receipt prints and cuts all at once. But when using a non privileged user to run openkiosk, there is a 2 second delay at the end of the receipt, before the paper gets cut. This causes users to try and tear out the receipt before it cuts, which sometimes messes up the printer, causing future prints to misfeed back into the printer. It seems like the printer is waiting for more input before it times out and initiates a cut. I've tried giving the selfcheck user profile full permissions to the printer, no change. I've tried putting the selfcheck user in the administrator group, no change. Has anyone run into something like this? 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
[OPEN-ILS-GENERAL] Star receipt printer , self check, pause before cut
Hello, I'm curious if anyone has run into this and found a solution for it. We use Star TSP100 and TSP600 receipt printers. Our self check machines use the web based self check interface. We use the openkiosk browser to serve up the self check interface on our machines. When I'm logged in as administrator and test out the self check printing a receipt, the receipt prints and cuts all at once. But when using a non privileged user to run openkiosk, there is a 2 second delay at the end of the receipt, before the paper gets cut. This causes users to try and tear out the receipt before it cuts, which sometimes messes up the printer, causing future prints to misfeed back into the printer. It seems like the printer is waiting for more input before it times out and initiates a cut. I've tried giving the selfcheck user profile full permissions to the printer, no change. I've tried putting the selfcheck user in the administrator group, no change. Has anyone run into something like this? 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
[OPEN-ILS-GENERAL] Reading History opt in on patron application
Hello, we are running into the fact that many of our patrons that want to make use of a reading history, don't find out about it until long after they sign up for an account. Many of these patrons are also non computer/online catalog users, so there is no chance that they would ever find the option to enable it themselves, and even if they knew about it, they wouldn't be able to set it themselves. So they find out about it after talking with staff, and then get mad when they find out that it will only have their history starting at the point they sign up. Since they don't use computers, they need staff to walk them through (do it for them) logging into their account and finding the option, so it would be handy if staff could just do it for them. We could set the library setting to default the checkout history to being enabled, but we really don't want to make that decision for everyone, and then put the onus on them to figure out how to use the catalog to turn it off. So we are considering adding an opt in checkbox to the patron application, along with a user setting that staff can check, to allow staff to enable the circ history at patron registration time. The user setting being checked or unchecked would trigger a nightly process that would enable/disable the reading history for that account. In theory, this could result in a customer saying that they never signed up for the feature, saying that staff did it on their own. But since it is already trivially easy for staff to log into the catalog as a customer, it seems like that would already be a problem. (staff know what the default pin numbers are based on, or could just change the pin, a customer that never uses the catalog would never know that the pin was changed) Has anyone else done this or something like this? Is this a horrible idea? I think staff would also like to be able to access the patrons history from their staff stations, which would make readers advisory easier. "Which Louis L'Amour titles haven't I read yet". We have had problems in the past with patrons physically marking books that they have read before, to make it easier for them to find the ones they haven't read. 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] Label Printer Context and spine labels
I did finally get it to work. I had to completely deleted the %user%/appdata/roaming/openils folder and let the client re-create it. What I don't get is why creating a new xul profile didn't work (adding the -P argument to the evergreen client shortcut). I created a new testing xul profile alongside the existing one initially, but the problem continued even when I was using that new profile. I would think that the only thing shared between different xul profiles is the appdata/roaming/openils/profiles.ini file, which seems pretty simple, not many options in there. Although maybe profiles created after the first one inherit settings from the original one? I also tried deleting the windows user profile, but when I copied back the xul profile folder the problem continued. So I don't think it was something in the user profile. I couldn't see any evidence that firefox settings were used by the evergreen client in my testing, that was mentioned as something to try. I had no trouble using the silent print option after the printers were set correctly, but that might be a case of our workflow not needing other printers, whiles others do need to switch printers. Thanks for all the suggestions. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Friday, October 06, 2017 11:34 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Label Printer Context and spine labels 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> In our case it is a Zebra printer. I'll certainly try that out though if I cannot find any other solutions. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of David Daniels Sent: Thursday, October 05, 2017 10:02 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Label Printer Context and spine labels Josh: Is the printer a Dymo? If so I learned the only way to get it to print correctly to it, is to ensure it is installed first and then install any other printers. From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Thursday, October 05, 2017 10:58 AM To: open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] Label Printer Context and spine labels Hello, I've been having some problems setting up a spine label printer on one computer. Even though I go into the workstation printer settings editor and set the correct printer as the default printer for the label context, whenever I press the print page button on the spine label preview and print page, it aways defaults to sending the print job to the windows default printer. When I look at the config files in the client profile directory, it looks like the different printer contexts are setup correctly. We are running eg 2.10.6 right now. Has anyone run into this before? I about ready to delete the client profile and try setting it up again, but I thought I would ask first. 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 [SHRLS]<http://shrls.org>
Re: [OPEN-ILS-GENERAL] Label Printer Context and spine labels
In our case it is a Zebra printer. I'll certainly try that out though if I cannot find any other solutions. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of David Daniels Sent: Thursday, October 05, 2017 10:02 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Label Printer Context and spine labels Josh: Is the printer a Dymo? If so I learned the only way to get it to print correctly to it, is to ensure it is installed first and then install any other printers. From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Thursday, October 05, 2017 10:58 AM To: open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] Label Printer Context and spine labels Hello, I've been having some problems setting up a spine label printer on one computer. Even though I go into the workstation printer settings editor and set the correct printer as the default printer for the label context, whenever I press the print page button on the spine label preview and print page, it aways defaults to sending the print job to the windows default printer. When I look at the config files in the client profile directory, it looks like the different printer contexts are setup correctly. We are running eg 2.10.6 right now. Has anyone run into this before? I about ready to delete the client profile and try setting it up again, but I thought I would ask first. 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 [SHRLS]<http://shrls.org>
Re: [OPEN-ILS-GENERAL] Label Printer Context and spine labels
It looks like from looking the following file that there is an attempt to set printer_context = ‘label’ for spine label printing. http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/xul/staff_client/server/cat/spine_labels.js#l592 I looked at another machine that has the same printer, running the same version of windows (7), and it also has something strange going on. When I look at the label context defaults, it is set to a PDF generator/printer. But when the print button is pressed, it does default to the correct printer. It looks like it is maybe always printing to the xul default printer as specified by the print_printer user pref. So it doesn’t look like the label context is actually used to me. I also tried creating a new evergreen staff client profile on the machine, which had the same behavior as the original profile. I think I’ll try updating the driver next to see if something is off there. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Morgan, Michele Sent: Thursday, October 05, 2017 11:21 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Label Printer Context and spine labels Hi Josh, I haven't looked at this in a while, but have run into at least one place where printers configured under the contexts weren't used. This Launchpad bug is one example: https://bugs.launchpad.net/evergreen/+bug/1193405 I don't know if this is an issue with label printing. You could try going to about:config in the client and changing "print.printer" to point to your label printer to see if that's the issue. That's how we worked around the problem for the Simplified Pull List. Hope this helps, Michele -- Michele M. Morgan, Technical Support Analyst North of Boston Library Exchange, Danvers Massachusetts mmor...@noblenet.org<mailto:mmor...@noblenet.org> On Thu, Oct 5, 2017 at 10:58 AM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello, I’ve been having some problems setting up a spine label printer on one computer. Even though I go into the workstation printer settings editor and set the correct printer as the default printer for the label context, whenever I press the print page button on the spine label preview and print page, it aways defaults to sending the print job to the windows default printer. When I look at the config files in the client profile directory, it looks like the different printer contexts are setup correctly. We are running eg 2.10.6 right now. Has anyone run into this before? I about ready to delete the client profile and try setting it up again, but I thought I would ask first. Thanks Josh Lake Agassiz Regional Library - Moorhead MN larl.org<http://larl.org> Josh Stompro | Office 218.233.3757 EXT-139<tel:(218)%20233-3757> LARL IT Director | Cell 218.790.2110<tel:(218)%20790-2110>
[OPEN-ILS-GENERAL] Label Printer Context and spine labels
Hello, I've been having some problems setting up a spine label printer on one computer. Even though I go into the workstation printer settings editor and set the correct printer as the default printer for the label context, whenever I press the print page button on the spine label preview and print page, it aways defaults to sending the print job to the windows default printer. When I look at the config files in the client profile directory, it looks like the different printer contexts are setup correctly. We are running eg 2.10.6 right now. Has anyone run into this before? I about ready to delete the client profile and try setting it up again, but I thought I would ask first. 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] Zebra TLP2824 plus - output issue
Hello Garry, thanks for this info. I received a sample of the 1x1.5 labels from Computype and they worked perfectly, not shadowing on the bottom 1/3rd of the labels anymore. So the problem was because of the zebra brand label stock. We will be ordering more from them. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Garry Collum Sent: Tuesday, September 12, 2017 10:44 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Zebra TLP2824 plus - output issue We have some from Computype with a product number of 1038224. There's really no other markings on these, other than the size. We have also ordered wax ribbon from Amazon. https://www.amazon.com/gp/product/B009YBO4W6/ref=oh_aui_detailpage_o00_s00?ie=UTF8=1 We have had no problems with either. On Tue, Sep 12, 2017 at 11:25 AM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello Garry, do you use the wax ribbon or direct thermal? Could you also tell me the product numbers of your supplies please. Thanks Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org<mailto:open-ils-general-boun...@list.georgialibraries.org>] On Behalf Of Garry Collum Sent: Tuesday, September 12, 2017 9:08 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Zebra TLP2824 plus - output issue Hi Josh, We have never had this problem. We have 5 TLP2824 plus printers. But our labels are 1 x 1.5 Garry On Mon, Sep 11, 2017 at 3:48 PM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello, does anyone use the Zebra TLP2824 plus printer for your spine/pocket labels? We have two of them and they have this odd behavior of shading the bottom 1/3 of the first label that gets printed, like the print head is pre-heating and transferring the ribbon when it first starts. One of them has it very faintly, which we have just lived with, while the other has it worse off. They were manufactured months apart, not from the same batch. I just had the worse off one sent in for repair, and it was returned, and the repair sheet says that parts were replaced, but the same problem is there still. The testing labels that they printed out and included with it also show the problem. I’m just wondering if this is normal for this model… and if we should be looking at getting a different model printer? We are using 5319 wax ribbon and Zebra labels Z-Select 4000T 2.25x1.25. Thanks Josh Lake Agassiz Regional Library - Moorhead MN larl.org<http://larl.org> Josh Stompro | Office 218.233.3757 EXT-139 LARL IT Director | Cell 218.790.2110
Re: [OPEN-ILS-GENERAL] Zebra TLP2824 plus - output issue
Hello Garry, do you use the wax ribbon or direct thermal? Could you also tell me the product numbers of your supplies please. Thanks Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Garry Collum Sent: Tuesday, September 12, 2017 9:08 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Zebra TLP2824 plus - output issue Hi Josh, We have never had this problem. We have 5 TLP2824 plus printers. But our labels are 1 x 1.5 Garry On Mon, Sep 11, 2017 at 3:48 PM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello, does anyone use the Zebra TLP2824 plus printer for your spine/pocket labels? We have two of them and they have this odd behavior of shading the bottom 1/3 of the first label that gets printed, like the print head is pre-heating and transferring the ribbon when it first starts. One of them has it very faintly, which we have just lived with, while the other has it worse off. They were manufactured months apart, not from the same batch. I just had the worse off one sent in for repair, and it was returned, and the repair sheet says that parts were replaced, but the same problem is there still. The testing labels that they printed out and included with it also show the problem. I’m just wondering if this is normal for this model… and if we should be looking at getting a different model printer? We are using 5319 wax ribbon and Zebra labels Z-Select 4000T 2.25x1.25. Thanks Josh Lake Agassiz Regional Library - Moorhead MN larl.org<http://larl.org> Josh Stompro | Office 218.233.3757 EXT-139 LARL IT Director | Cell 218.790.2110
[OPEN-ILS-GENERAL] Zebra TLP2824 plus - output issue
Hello, does anyone use the Zebra TLP2824 plus printer for your spine/pocket labels? We have two of them and they have this odd behavior of shading the bottom 1/3 of the first label that gets printed, like the print head is pre-heating and transferring the ribbon when it first starts. One of them has it very faintly, which we have just lived with, while the other has it worse off. They were manufactured months apart, not from the same batch. I just had the worse off one sent in for repair, and it was returned, and the repair sheet says that parts were replaced, but the same problem is there still. The testing labels that they printed out and included with it also show the problem. I'm just wondering if this is normal for this model... and if we should be looking at getting a different model printer? We are using 5319 wax ribbon and Zebra labels Z-Select 4000T 2.25x1.25. 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
[OPEN-ILS-GENERAL] Z39.50 attributes for searching a Koha system
Hello, could someone please share with me their Z39.50 attributes for searching a Koha system. I'm assuming that there are defaults that are common to the Zebra Information Server. I'm trying to set one up but I've been having no luck finding out what the attribute values might possibly be. Guessing hasn't worked for me, and I haven't found how to list them via the yaz-client. The index data irspy database doesn't seem to list settings for format and truncation, or Record format and Transmission format. Any help would be appreciated. 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] Evergreen Self-Check and locking media cases
Joe, I have a fix for keeping the cursor focus always on the scan box. We also use touch screens for our self checks and we were having trouble with the fact that it was easy to move the focus, which would cause the next scan to silently fail, and sometimes switch screens. I have a bug report on it, but haven’t actually posted the code there yet. I’ll try and do that soon. https://bugs.launchpad.net/evergreen/+bug/1560601 We have also had trouble with the print list button that exists on the checkout screen. Some significant portion of users would press that when they were done, get a printout and then walk away. I guess they thought that was the logout and print a receipt button. Then the next users would walk up and sometime check out items on the first person’s account. https://bugs.launchpad.net/evergreen/+bug/1555791 I would love to collaborate with you on making the self check more touch screen friendly. I can share the css changes I’ve made just to enlarge everything to make it easier to see and to make the buttons easier to press. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Joe Knueven Sent: Wednesday, July 26, 2017 10:58 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Evergreen Self-Check and locking media cases While we’re on the subject of user-friendliness of the built in self-checkout, does anyone have any .tt2 modifications that they are pleased with and would be willing to share? I’ve had tweaking the scripting to make the navigation links more button like (ie touch screen friendly) on my to-do list, but it’s taken me an especially long time to get around to the first step of teaching myself a basic amount of tt2 scripting. Have a good day. Joe Joseph Knueven, Director Germantown Public Library 51 North Plum Street Germantown, OH 45327 937-855-4001 From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Terran McCanna Sent: Wednesday, July 26, 2017 11:16 AM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org>> Subject: Re: [OPEN-ILS-GENERAL] Evergreen Self-Check and locking media cases >>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.<< Interesting. There's nothing in the interface that tells the patron that they can do that, or that tells them how. Patrons typically don't have books in hand when they wish to renew, so they'd need to understand that they could go to the Items out screen and copy and paste the barcodes. Online instructions would help, but it still wouldn't as user friendly as the method of renewal in My Account. Terran McCanna PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 404-235-7138 tmcca...@georgialibraries.org<mailto:tmcca...@georgialibraries.org> On Wed, Jul 26, 2017 at 10:26 AM, Mike Rylander <mrylan...@gmail.com<mailto:mrylan...@gmail.com>> wrote: 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<mailto:mi...@equinoxinitiative.org> | web: http://equinoxinitiative.org On Wed, Jul 26, 2017 at 9:51 AM, Terran McCanna <tmcca...@georgialibraries.org<mailto:tmcca...@georgialibraries.org>> wrote: > Hi Jesse, > > I just wanted to chime in that I'm not aware of anyone who is working on > developing functionality like that. The self-check interface hasn't gotten a > lot of attention in the past few years, possibly because not a lot of > libraries are using it. (Only 2 or 3 libraries out of our 285 total > libraries that have opted to use it.) There are a number of things that > could be done to improve it which would encourage more people to adopt it, > like adding the ability to pay fines through the same functionality that the > OPAC uses, and to allow patrons to renew books through it. > > > > Terran McCanna > PINES Program Manager > Georgia Public Library Service > 1800 Century Place, Suite 150 > Atlanta, GA 30345 > 404-235-7138 > tmcca...@georgialibraries.org<mailto:tmcca...@georgialibraries.org> > > > On Tue, Jul 25, 2017 at 4:16 PM, Jesse McCarty > <jes...@burlingtonwa.gov<mailto:jes...@burlingtonwa.gov>> > wrote: >> >> Hello Everyone, >> >> >> >> Currently we are running
Re: [OPEN-ILS-GENERAL] Evergreen Self-Check and locking media cases
Here are links to the bugs for the issues mentioned by Terran: 1. #1512171 Wishlist: Self Check Item Renewal without item present<https://bugs.launchpad.net/evergreen/+bug/1512171> 2. #1528685 Self-check - pay fines doesn't work with Stripe<https://bugs.launchpad.net/evergreen/+bug/1528685> Please comment and mark the bugs as affecting you. Also, if you have an internal process for choosing which development projects to fund, you could add some of the self check bugs to the list of items to consider. We are one of the sites that heavily use the self check feature, it handles between 50% and 90% of the checkouts at our sites. This discussion reminds me that we need to put some time and money into improving it. Josh Stompro - LARL From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Terran McCanna Sent: Wednesday, July 26, 2017 10:16 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Evergreen Self-Check and locking media cases >>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.<< Interesting. There's nothing in the interface that tells the patron that they can do that, or that tells them how. Patrons typically don't have books in hand when they wish to renew, so they'd need to understand that they could go to the Items out screen and copy and paste the barcodes. Online instructions would help, but it still wouldn't as user friendly as the method of renewal in My Account. Terran McCanna PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 404-235-7138 tmcca...@georgialibraries.org<mailto:tmcca...@georgialibraries.org> On Wed, Jul 26, 2017 at 10:26 AM, Mike Rylander <mrylan...@gmail.com<mailto:mrylan...@gmail.com>> wrote: 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<mailto:mi...@equinoxinitiative.org> | web: http://equinoxinitiative.org On Wed, Jul 26, 2017 at 9:51 AM, Terran McCanna <tmcca...@georgialibraries.org<mailto:tmcca...@georgialibraries.org>> wrote: > Hi Jesse, > > I just wanted to chime in that I'm not aware of anyone who is working on > developing functionality like that. The self-check interface hasn't gotten a > lot of attention in the past few years, possibly because not a lot of > libraries are using it. (Only 2 or 3 libraries out of our 285 total > libraries that have opted to use it.) There are a number of things that > could be done to improve it which would encourage more people to adopt it, > like adding the ability to pay fines through the same functionality that the > OPAC uses, and to allow patrons to renew books through it. > > > > Terran McCanna > PINES Program Manager > Georgia Public Library Service > 1800 Century Place, Suite 150 > Atlanta, GA 30345 > 404-235-7138 > tmcca...@georgialibraries.org<mailto:tmcca...@georgialibraries.org> > > > On Tue, Jul 25, 2017 at 4:16 PM, Jesse McCarty > <jes...@burlingtonwa.gov<mailto:jes...@burlingtonwa.gov>> > wrote: >> >> Hello Everyone, >> >> >> >> Currently we are running an ITG self-check system that utilizes magnetic >> locking cases for DVDs and CDs. I know the documentation references no >> security mechanisms in Evergreen self-check, but I was wondering if there is >> a way for the Evergreen self-check to interact/activate the magnetic >> unlockers for security cases? Is this a sought after feature/planned >> possibility? Or is the built in self-check designed to be nothing more than >> its current basic form? >> >> >> >> Thanks in advance, >> >> >> >> Jesse McCarty >> >> City of Burlington >> >> IT Technical Assistant >> >> > >
[OPEN-ILS-GENERAL] Billing / Pay Bills UI
We see enough errors with applying payments that I'm wondering if a different interface would work better. We are on 2.10 and are using the XUL staff client. The problem seems to be with the payment type dropdown. For some reason the wrong options gets selected occasionally, and the payment is submitted with the wrong type. I think the drop down is just hard for some staff to see, and the level of accuracy required to select the correct option is high. Also, I suspect that the interface just has too much going on when you first look at it, and sometimes staff are at a loss on where to start the process. Also, there is no confirmation step before the payment is applied. I think a summary of the payment about to be applied would be useful for staff to double check the options that they have selected. Another error we see is having the wrong items selected to pay the bills on, or more specifically not selecting a specific item when that is wanted, and going with the default we have set of all bills being selected. This also might be helped if there was a confirmation process. I've seen the interfaces that some POS(Point of sale) systems use and one style that I've seen used is to show all the payment options as a grid of buttons, with unique icons for each method. I think this would be more touch screen friendly also, which isn't something that we use now, but with the web staff client there is more of a possibility of staff using devices with touch screens to help customers. So what if instead of the pay bill ui being on the bills page, there is a "Pay Bill" button at the bottom of the screen that brings up a separate interface for selecting the payment type, annotation, amount, etc, along with showing which items were selected and the distribution of payment on those items, and then a final confirmation screen? Example screenshots of other POS interfaces: https://help.shopify.com/assets/images/pos/operating/checkout/checkout-screen-fixed.png?1438282125 https://s-media-cache-ak0.pinimg.com/originals/4f/ec/8f/4fec8f6c1cb803e614f0dd0994972f11.jpg http://blog.ignify.com/wp-content/uploads/2014/06/customizable-pos-interface-b.jpg I would also like to hear if others don't have a problem with how it currently works. Maybe we just need more training, or just a font size change for the drop down. 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] Synonym Dictionary - Numbers,
Mike, thanks for the tips, I hadn't thought about stacking dictionaries, that works great. I'm trying out using 4 dictionaries in two config groups now. Group 1 - 1 - Normal text synonyms (Roman numeral to text) Group 1 - 2 - INT to text Group 2 - 3 - Roman Numeral Int to text Gropu 2 - 4 - Roman Numeral text to Int So if the cataloger enters - "Scary Movie 5" it is indexed with "V" and "Five" - "Scary Movie V" it is indexed with "5" and "Five" - "Scary Movie Five" it is indexed with "5" and "V" This could really cut down on the need to add variations of the title (246) tags. Now I need to see what I can do about hyphenated numbers. We have about 500 titles like "A history of America in thirty-six postage stamps". The above setup adds "30","6","xxx","vi" to the index since thirty-six is treated as two separate words. I don't know if that is going to be a problem yet in real life usage. And while it is possible to have a synonym dictionary with 36 -> thirty-six, it doesn't work because I believe the search subsystem would never send "thirty-six", it will break it up into two words. For your suggestion about handling & and other special characters there is one thing that I don't understand. Would the normalizer translate & into ☃,and then the synonym dictionary would map ☃ to & along with ☃ to ‘and’ ? Or would this method not be using the synonym dictionaries at all? Josh Stompro - LARL IT Director -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Mike Rylander Sent: Thursday, May 25, 2017 11:19 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Synonym Dictionary - Numbers, & 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<mailto:mi...@equinoxinitiative.org> | web: http://equinoxinitiative.org On Thu, May 25, 2017 at 11:05 AM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: > Hello, I’ve followed the steps in the following wiki pages to enable a > synonym dictionary but I’m not getting the results I expect. > > > > https://wiki.evergreen-ils.org/doku.php?id=scratchpad:brush_up_search# > synonym_dictionary > > > > Spelled out numbers do get translated to digits (six -> 6) but digits > don’t get translated ( 6 -> six). > > > > When I test the synonym dictionary with something like the following > it looks like it works: > > select ts_lexize('synonym_larl', '6'); > > ts_lexize > > --- > > {six} > > (1 row) > > > > But when I look at the the metabib.title_field_entry for a record that > has been reindexed I see the following. > > select * from metabib.title_field_entry where source=102449 limit 100; > >id| source | field | value > | > index_vector > > -++---+--+- > > 2402931 | 102449 | 6 | Little house on the prairie Season 6 [disc 2] > test seven | '2':9A,13C,20C '6':7A,12C,18C '7':14C 'disc':8A,19C > 'hous':13C 'house':2A 'littl':12C 'little':1A 'on':3A,14C 'prairi':16C > 'prairie':5A 'season':6A,17C 'seven':11A,22C 'test':10A,21C > 'the':4A,15C > > > > Seven gets added as ‘seven’ and ‘7’, but the ‘2’ and ‘6’ do not. > > > > So I’m wondering if the search configuration needs to cover numeric > tokens to make that work? > > > > select * from ts_debug('synonym_larl', '6'); > > alias | description| token | dictionaries | dictionary | lexemes > > ---+--+---+--++--- > ---+--+---+--++-- > > uint | Unsigned integer | 6 | {simple} | simple | {6} > > > > \dF+ s
Re: [OPEN-ILS-GENERAL] Added Content Reviews Visibility - Record Detail
Hello Terran, I wanted to try to get away from the expanders since only one type of added content was shown at once. So we removed that expander and added the added content inline below the Content descriptions. http://egcatalog.larl.org/eg/opac/record/32155?query=a%20clash%20of%20kings;qtype=keyword;locg=1;detail_record_view=0 http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/stompro/added_content_inline_larl I don’t notice any problems performance wise, but we are only using a few types of added content, all provided by Content Café, which delivers it all to us in one request and then caches it in memcache. Since I know that we are only getting reviews and author notes, I set Record.pm and addedcontentinline.tt2 to only try to fetch those two to cut down on extra request that will never have content. Could you send me a link to the commit you were referring to again, in the link you sent I’m not having any luck spotting which changes you made to show the expander open by default. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Terran McCanna Sent: Friday, May 12, 2017 10:48 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Added Content Reviews Visibility - Record Detail Hi Josh, Similar problem here - we have NoveList Select and I tweaked the logic a little to force the 'awards' section that it appears in to be always expanded when the page first loads. It's still clunky because now if you expand a different section and then go back to that section, it loses the NoveList added content, so I need to work on it some more. I'm curious to see what you come up with as a good solution. Here's what I have so far: http://gapines.org/eg/opac/record/5602301?query=game%20of%20thrones;qtype=keyword;locg=1;detail_record_view=0 http://git.evergreen-ils.org/?p=evergreen/pines.git;a=blob;f=Open-ILS/src/templates/opac/parts/record/extras.tt2;h=b35cf5471dc50c566888a6c6bd499e05df6a0240;hb=HEAD Terran McCanna PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 404-235-7138 tmcca...@georgialibraries.org<mailto:tmcca...@georgialibraries.org>
Re: [OPEN-ILS-GENERAL] Credit Card - Stripe Vs Paypal & PCI
Jason, that did help, thank you. I'm going to try commenting out the 'Process Internally' menu item in bill_cc_info.xul, so staff will still have the option to register an externally processed CC payment. We do use a few tablets with the stripe readers at a few places, so I think this would allow staff to register those payments in EG easily. http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/xul/staff_client/server/patron/bill_cc_info.xul;h=8cb4804267f0ca8c36c9ffa86f0aea2b62324cac;hb=HEAD#l175 Josh Stompro - LARL IT Director -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Tuesday, May 09, 2017 4:15 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Credit Card - Stripe Vs Paypal & PCI Josh, Using PayPal is similar to Stripe, since the transaction is completed via PayPal and the CC data is not stored in Evergreen. We disabled the staff client credit card interface by commenting out the relevant menuitem in Open-ILS/xul/staff_client/server/patron/bill2.xul. (IANM, that relevant menuitem is on line 107.) We have not made a similar change to the web staff client because we are not using it, yet. HtH, Jason On 05/09/2017 04:48 PM, Josh Stompro wrote: > Hello, we are currently using payflow pro, which I think means that > our evergreen server handles the CC data and puts it in PCI scope. > From what I'm reading, if we switched over to using Stripe, which uses > a javascript library client side to submit the payment, then it would > take our server out of scope. Does the Paypal code work the same way? > > > > It looks like the tpac supports Stripe, but the web based self check > does not. How about the staff client/web staff client payment > interface. Does that support Stripe? > > > > Along the same lines, is there a way to disable the staff client > credit card interface. We don't want staff handling credit cards with > that interface, since they have to type in the code and info, which I > believe isn't PCI compliant, but I haven't found a setting to disable > that but allow tpac payments. > > > > 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 > > >
[OPEN-ILS-GENERAL] Added Content Reviews Visibility - Record Detail
Hello, we recently purchased a subscription to booklist reviews from Content Café, and now we are seeing how the information is hidden in the added content tab by default when the record detail page is opened. I've been looking at how we can customize the view so that the review data is shown by default, and is shown higher up in the page. I'm wondering if any other sites have seen this as an issue and addressed it? Right now our system is stock 2.10, it can take multiple clicks and page loads to access the review data. One click on "Added Content" and a page load, then another click on the reviews subheading if it doesn't happen to be the first added content item. We just don't think users will go through the trouble to do this, or even know that they can. I've looked at simply including the addedcontent.tt2 further up in the page, but it looks to me like the data is only included in the page context when the proper ac=reviews cgi variable is set. It looks to me like I would need to adjust '/WWW/EGCatLoader/Record.pm' to always request(get instead of head) review data to get that to work. Has anyone gone down that route? 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
[OPEN-ILS-GENERAL] Credit Card - Stripe Vs Paypal & PCI
Hello, we are currently using payflow pro, which I think means that our evergreen server handles the CC data and puts it in PCI scope. From what I'm reading, if we switched over to using Stripe, which uses a javascript library client side to submit the payment, then it would take our server out of scope. Does the Paypal code work the same way? It looks like the tpac supports Stripe, but the web based self check does not. How about the staff client/web staff client payment interface. Does that support Stripe? Along the same lines, is there a way to disable the staff client credit card interface. We don't want staff handling credit cards with that interface, since they have to type in the code and info, which I believe isn't PCI compliant, but I haven't found a setting to disable that but allow tpac payments. 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] Upgrading from 2.10 to 2.11 error questions
Jason, I would be interested in seeing your script. I wonder if your pingest.pl script that many people use for reingest could be extended with an option to trigger the maintain_901 function as another method? Some sort of "trigger bib update" option? That could handle spreading out the load/locks also. Maybe that wouldn't allow the user to see the encoding errors though? Maybe the encoding errors should be tested for a different way though, instead of trying to combine that with this update? Josh Stompro - LARL IT Director -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Thursday, April 20, 2017 7:20 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Upgrading from 2.10 to 2.11 error questions Hi, Jesse. I won't repeat what Dan said, but I'll add that with a change to an internal flag or two this update will also take care of any ingests required. I think there's a browse or facet ingest required for 2.11. I'm preparing to upgrade from 2.10 to 2.12, and I've run into a similar issue as you with the maintain_901 function and some records with "bad" characters. I'm working on a Perl script to pull the MARC out of the database and do the maintain_901 work in a function in the script. The advantage of this is two fold: #1 I can trap any errors that occur and output a warning message with the record id that causes the error so it can later be fixed. #2 By modifying the MARC and then updating the record in the database, I can get the ingests to trigger without altering any database flags. It won't be fast, but it won't have the downside of potentially locking significant portions of the biblio.record_entry table. Updating 1 row at a time should keep it at row locks, or page locks at worst. If there is enough interest expressed on the list, I could share this code on github or elsewhere. Cheers, Jason On 04/19/2017 04:22 PM, Jesse McCarty wrote: > Hello Everyone, > > > > We are preparing for our spring upgrade to Evergreen, moving from > 2.10.3 to 2.11.3 and ran into one little bump. As part of the DB > upgrade, there is an update setting the 901$s for bib records. First > question, as seen in the attached screen shot, this threw a bunch of > 'no mapping found for' Errors. Can this be safely ignored and > proceed with running the system after upgrading with no issues (we > haven't seen any issue in our testing)? > > > > The second, this update seem to take longer than 24 hours. With that > in mind would we be able to process the entire upgrade, then use > Evergreen in daily production while this DB update finishes in the > background? Or does this need to be 100% complete before allowing > library's connection to the system? > > > > Thanks in advance, > > > > Jesse McCarty > > City of Burlington > > IT Technical Assistant > > >
[OPEN-ILS-GENERAL] Meta Records/holds and electronic records
Hello, we just started adding marc records for our overdrive and EbooksMN (biblioboard) collections and now I'm noticing that meta holds will apply to these records. I'm wondering if there is some way to exclude titles that cannot have copies (set in the bib source) from being included in a meta record grouping. I thought that the main reason to use metarecords was to take advantage of meta holds, so it would seem to make sense to not include titles that cannot have copies. Here is an example of what I'm seeing. When I do a search for "Fantastic Beasts and where to find them" and group formats and editions, out catalog groups 4 titles together, two books and two electronic records. https://egcatalog.larl.org/eg/opac/results?query=Fantastic+beasts+and+where+to+find+them=title%3Asearch_format==1_record_view=0==metabib The display shows (2) copies, but also shows the icons for the electronic copies. But if you click on the metarecord, only the two physical copy records are shown. So it basically hides the electronic records from view/use. If I place a meta hold on that metarecord, and leave the format unselected, one of the electronic copies has been chosen as the master record, so the hold looks like it is on one of the electronic records, and the electronic record title is shown to the customer in the holds screen. I tried to find a discussion about this, or any related bugs but I didn't have any luck. Any tips on how I can adjust this behavior would be appreciated. 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
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<mailto:ro...@equinoxinitiative.org> web: http://EquinoxInitiative.org On Thu, Mar 30, 2017 at 10:00 AM, Jason Stephenson <ja...@sigio.com<mailto:ja...@sigio.com>> wrote: I should add that the staff client requires SSL and there's no easy way to chagne that, so you can't completely disable SSL and expect things to still function properly. On 03/30/2017 09:23 AM, Jason Stephenson wrote: > Jayaraj, > > It would be done via the Apache configuration files. You'd move > everything from the SSL enabled vhost configurations to the non-SSL > vhosts, i.e everything from the port 443 configuration sections to the > port 80 configuration. Some of that configuration is duplicated, so only > the unique things need to go. > > There may also be some directives to force SSL on some locations. You'll > want to remove those also. > > I'm writing this from memory without looking at the files, which is > alway a bad thing to do, but I think that covers it. > > HtH, > Jason > > On 03/30/2017 04:16 AM, Jayaraj JR wrote: >> Hello, >> >> Greetings of the day ! >> >> SSL or https is a better option as far as security is concerned. But the >> heightened security level may not be necessary at many times especially >> while using Evergreen in Intranet. Besides the browser often warns the >> user that entering to my account in evergreen catalog is dangerous if >> purchased SSL is not implemented. This may often create confusion for >> childern and beginning users who are not well versed with computers. >> They are very often advised to add security exception for accessing the >> library catalog. >> >> It would appreciable, if any option or configuration is available to >> disable the SSL and to use the full library catalog via http. >> Kindly advice the configuration to use my account in Evergreen catalog >> via http itself and not https >> >> -- >> Thanks in Advance, >> >> Jayaraj J R >> Library Information Assistant >> IISER Thiruvananthapuram
Re: [OPEN-ILS-GENERAL] Series index, only first entry getting indexed
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 <open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org>> Subject: Re: [OPEN-ILS-GENERAL] Series index, only first entry getting indexed This is an EXTERNAL email. Exercise caution. DO NOT open attachments or click links from unknown senders or unexpected email. Removing the regex replace normalizer did take care of it, sorry I didn't try that before posting. I think my regex will have to be more selective, only getting rid of the number and the ';' so it doesn't clear out too much data. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Wednesday, March 01, 2017 9:19 AM To: open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] Series index, only first entry getting indexed Hello, we have noticed that only the first 490 get indexed for our series search index. But all 490's get added to the series facet entry. For example, here is a title with two 490's in mods32 format. https://egcatalog.larl.org/opac/extras/unapi?id=tag::U2@bre/237592=mods32 The second 490 of "Felicity classic" isn't searchable. When I look at the metabib.combined_series_field_entry I see the following for this record. record metabib_field index_vector 237592 'american' 'beforev' 'beforever' 'felic' 'felicity' 'girl' 237592 1 'american' 'beforev' 'beforever' 'felic' 'felicity' 'girl' metabib.series_field_entry id source field Value index_vector 430451 237592 1 American Girl Beforever Felicity 'american':1A,5C 'beforev':7C 'beforever':3A 'felic':8C 'felicity':4A 'girl':2A,6C Metabib.facet_entry value count bibid American Girl Beforever Felicity 1 237592 Felicity classic 1 237592 The one thing that I have done is to add a search normalizer to get rid of the series numbering from the facet entry. Unfortunately I don't remember if this issue came up before I added the normalizer. Maybe when used on the index version the regex replace is actually acting on all the 490 info concatenated together, so by getting rid of everything after the first ' ;' I'm clearing the second 490 entry data? But it does work correctly on the facet data? There is a note on https://wiki.evergreen-ils.org/doku.php?id=documentation:indexing#field_normalization_settings "Note: Only normalizations with a negative pos value are applied to the facet version of indexed terms!" But that must not mean that the normalizer only acts on the facet when there is a negative pos value? This is going to be wide, but here is our normalizer setup and our series metabib field info. id field norm params pos id field_class name label xpath weight format search_field facet_field browse_field browse_xpath browse_sort_xpath facet_xpath authority_xpath joiner restrict id name description func param_count 51 32 2 0 32 series brow
Re: [OPEN-ILS-GENERAL] Series index, only first entry getting indexed
Jason, I would really like to leave the series index info in the search index. It would be nice if staff/customers could do a series search like "Harry Potter 1" to get all the titles for the first harry potter book. It seems like the issue is that one config.metabib_field entry for Series Title is set to both search_field and facet_field. If I turn off the facet_field flag for that entry and create a new entry for a series title facet, and then just apply the normalizer to that field, I wonder if that would do it? So the facet entries would get cleaned up, but the index entries would be left alone. 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 <open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org>> Subject: Re: [OPEN-ILS-GENERAL] Series index, only first entry getting indexed This is an EXTERNAL email. Exercise caution. DO NOT open attachments or click links from unknown senders or unexpected email. Removing the regex replace normalizer did take care of it, sorry I didn't try that before posting. I think my regex will have to be more selective, only getting rid of the number and the ';' so it doesn't clear out too much data. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Wednesday, March 01, 2017 9:19 AM To: open-ils-general@list.georgialibraries.org<mailto:open-ils-general@list.georgialibraries.org> Subject: [OPEN-ILS-GENERAL] Series index, only first entry getting indexed Hello, we have noticed that only the first 490 get indexed for our series search index. But all 490's get added to the series facet entry. For example, here is a title with two 490's in mods32 format. https://egcatalog.larl.org/opac/extras/unapi?id=tag::U2@bre/237592=mods32 The second 490 of "Felicity classic" isn't searchable. When I look at the metabib.combined_series_field_entry I see the following for this record. record metabib_field index_vector 237592 'american' 'beforev' 'beforever' 'felic' 'felicity' 'girl' 237592 1 'american' 'beforev' 'beforever' 'felic' 'felicity' 'girl' metabib.series_field_entry id source field Value index_vector 430451 237592 1 American Girl Beforever Felicity 'american':1A,5C 'beforev':7C 'beforever':3A 'felic':8C 'felicity':4A 'girl':2A,6C Metabib.facet_entry value count bibid American Girl Beforever Felicity 1 237592 Felicity classic 1 237592 The one thing that I have done is to add a search normalizer to get rid of the series numbering from the facet entry. Unfortunately I don't remember if this issue came up before I added the normalizer. Maybe when used on the index version the regex replace is actually acting on all the 490 info concatenated together, so by getting rid of everything after the first ' ;' I'm clearing the second 490 entry data? But it does work correctly on the facet data? There is a note on https://wiki.evergreen-ils.org/doku.php?id=documentation:indexing#field_normalization_settings "Note: Only normalizations with a negative pos value are applied to the facet version of indexed terms!" But that must not mean that the normalizer only acts on the facet when there is a negative pos value? This is going to be wide, but here is our normalizer setup and our series metabib field info. id field norm params pos id field_class name label xpath weight format search_field facet_field browse_field browse_xpath browse_sort_xpath facet_xpath authority_xpath joiner restrict id name description func param_count 51 32 2 0 32 series browse Series Title (Browse)
Re: [OPEN-ILS-GENERAL] Series index, only first entry getting indexed
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] Series index, only first entry getting indexed Hello, we have noticed that only the first 490 get indexed for our series search index. But all 490's get added to the series facet entry. For example, here is a title with two 490's in mods32 format. https://egcatalog.larl.org/opac/extras/unapi?id=tag::U2@bre/237592=mods32 The second 490 of "Felicity classic" isn't searchable. When I look at the metabib.combined_series_field_entry I see the following for this record. record metabib_field index_vector 237592 'american' 'beforev' 'beforever' 'felic' 'felicity' 'girl' 237592 1 'american' 'beforev' 'beforever' 'felic' 'felicity' 'girl' metabib.series_field_entry id source field Value index_vector 430451 237592 1 American Girl Beforever Felicity 'american':1A,5C 'beforev':7C 'beforever':3A 'felic':8C 'felicity':4A 'girl':2A,6C Metabib.facet_entry value count bibid American Girl Beforever Felicity 1 237592 Felicity classic 1 237592 The one thing that I have done is to add a search normalizer to get rid of the series numbering from the facet entry. Unfortunately I don't remember if this issue came up before I added the normalizer. Maybe when used on the index version the regex replace is actually acting on all the 490 info concatenated together, so by getting rid of everything after the first ' ;' I'm clearing the second 490 entry data? But it does work correctly on the facet data? There is a note on https://wiki.evergreen-ils.org/doku.php?id=documentation:indexing#field_normalization_settings "Note: Only normalizations with a negative pos value are applied to the facet version of indexed terms!" But that must not mean that the normalizer only acts on the facet when there is a negative pos value? This is going to be wide, but here is our normalizer setup and our series metabib field info. id field norm params pos id field_class name label xpath weight format search_field facet_field browse_field browse_xpath browse_sort_xpath facet_xpath authority_xpath joiner restrict id name description func param_count 51 32 2 0 32 series browse Series Title (Browse) //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[@type="nfi"] 1 mods32 false false true *[local-name() != "nonSort"] //@xlink:href false 2 Normalize date range Split date ranges in the form of "-" into " " for proper index. split_date_range 0 1 1 2 0 1 series seriestitle Series Title //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not(@type="nfi")] 1 mods32 true true false //@xlink:href false 2 Normalize date range Split date ranges in the form of "-" into " " for proper index. split_date_range 0 62 1 13 ["[",""] -1 1 series seriestitle Series Title //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not(@type="nfi")] 1 mods32 true true false //@xlink:href false 13 Replace Replace all occurences of first parameter in the string with the second parameter. replace 2 61 1 13 ["]",""] -1 1 series seriestitle Series Title //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not(@type="nfi")] 1 mods32 true true false //@xlink:href false 13 Replace Replace all occurences of first parameter in the string with the second parameter. replace 2 52 32 17 0 32 series browse Series Title (Browse) //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[@type="nfi"] 1 mods32 false false true *[local-name() != "nonSort"] //@xlink:href false 17 Search Normalize Apply search normalization rules to the extracted text. A less extreme version of NACO normalization. search_normalize 0 2 1 17 0 1 series seriestitle Series Title //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not(@type="nfi")] 1 mods32 true true false //@xlink:href false 17 Search Normalize Apply search normalization rules to the extracted text. A less extreme version of NACO normalization. search_normalize 0 64 1 18 [" *;.*",""] -1 1 series seriestitle Series Title //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not
[OPEN-ILS-GENERAL] Series index, only first entry getting indexed
Hello, we have noticed that only the first 490 get indexed for our series search index. But all 490's get added to the series facet entry. For example, here is a title with two 490's in mods32 format. https://egcatalog.larl.org/opac/extras/unapi?id=tag::U2@bre/237592=mods32 The second 490 of "Felicity classic" isn't searchable. When I look at the metabib.combined_series_field_entry I see the following for this record. record metabib_field index_vector 237592 'american' 'beforev' 'beforever' 'felic' 'felicity' 'girl' 237592 1 'american' 'beforev' 'beforever' 'felic' 'felicity' 'girl' metabib.series_field_entry id source field Value index_vector 430451 237592 1 American Girl Beforever Felicity 'american':1A,5C 'beforev':7C 'beforever':3A 'felic':8C 'felicity':4A 'girl':2A,6C Metabib.facet_entry value count bibid American Girl Beforever Felicity 1 237592 Felicity classic 1 237592 The one thing that I have done is to add a search normalizer to get rid of the series numbering from the facet entry. Unfortunately I don't remember if this issue came up before I added the normalizer. Maybe when used on the index version the regex replace is actually acting on all the 490 info concatenated together, so by getting rid of everything after the first ' ;' I'm clearing the second 490 entry data? But it does work correctly on the facet data? There is a note on https://wiki.evergreen-ils.org/doku.php?id=documentation:indexing#field_normalization_settings "Note: Only normalizations with a negative pos value are applied to the facet version of indexed terms!" But that must not mean that the normalizer only acts on the facet when there is a negative pos value? This is going to be wide, but here is our normalizer setup and our series metabib field info. id field norm params pos id field_class name label xpath weight format search_field facet_field browse_field browse_xpath browse_sort_xpath facet_xpath authority_xpath joiner restrict id name description func param_count 51 32 2 0 32 series browse Series Title (Browse) //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[@type="nfi"] 1 mods32 false false true *[local-name() != "nonSort"] //@xlink:href false 2 Normalize date range Split date ranges in the form of "-" into " " for proper index. split_date_range 0 1 1 2 0 1 series seriestitle Series Title //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not(@type="nfi")] 1 mods32 true true false //@xlink:href false 2 Normalize date range Split date ranges in the form of "-" into " " for proper index. split_date_range 0 62 1 13 ["[",""] -1 1 series seriestitle Series Title //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not(@type="nfi")] 1 mods32 true true false //@xlink:href false 13 Replace Replace all occurences of first parameter in the string with the second parameter. replace 2 61 1 13 ["]",""] -1 1 series seriestitle Series Title //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not(@type="nfi")] 1 mods32 true true false //@xlink:href false 13 Replace Replace all occurences of first parameter in the string with the second parameter. replace 2 52 32 17 0 32 series browse Series Title (Browse) //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[@type="nfi"] 1 mods32 false false true *[local-name() != "nonSort"] //@xlink:href false 17 Search Normalize Apply search normalization rules to the extracted text. A less extreme version of NACO normalization. search_normalize 0 2 1 17 0 1 series seriestitle Series Title //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not(@type="nfi")] 1 mods32 true true false //@xlink:href false 17 Search Normalize Apply search normalization rules to the extracted text. A less extreme version of NACO normalization. search_normalize 0 64 1 18 [" *;.*",""] -1 1 series seriestitle Series Title //mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo[not(@type="nfi")] 1 mods32 true true false //@xlink:href false 18 Replace by regular expression regexp_replace 2 Thanks for any ideas you might have. Josh Lake Agassiz Regional Library - Moorhead MN larl.org Josh Stompro | Office 218.233.3757 EXT-139 LARL IT Director | Cell 218.790.2110
[OPEN-ILS-GENERAL] Duplicate Patron Check Reports
Hello, I just created a quick report to look for patron's with duplicate family_name, first_given_name and dob to find possible accounts to merge. I'm curious if anyone out there has some more sophisticated strategies that they can share for looking for duplicate patron records. We don't use any sort of primary identification so we don't have that to use. 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] Slowness/freezing with XUL staff client
I've seen issues with using the patron search vs checkout. Patron search seems to leak memory. So I've seen issues where staff always go to patron search, even if they have a patron barcode, after a while the client will get unresponsive. Josh Stompro - LARL IT Director -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jeff Davis Sent: Wednesday, February 01, 2017 3:43 PM To: open-ils-general@list.georgialibraries.org Subject: [OPEN-ILS-GENERAL] Slowness/freezing with XUL staff client 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
[OPEN-ILS-GENERAL] Looking for Self Check errors
Hello, I just started working on setting up a process to try and find instances where patrons attempt to checkout items at the self check, the checkout is denied, but they take the item home with them anyways since they don't realized it was denied. (I'm referring to the web based self check interface BTW). Currently the road I'm going down is to search the osrfsys.log for instances of "circulator: do_permit()" that are for our self check staff users. Then looking up the status for all copies listed and taking a look at all those that are not currently checked out, or those that don't have a check in time after the do_permit call timestamp. Has anyone else gone down this road before? Could I see how you have your checks setup? My hope is to be able to have a better feedback loop to try and talk to and educate customers that do this. Right now the only time we realize it happens is when items on the holdshelf get marked missing when they expire, and then the customer gets another copy send to them, and they say that they just checked it out. I think we also need to work on the self check interface to give users a better chance at seeing blocked checkout messages. Does anyone know of a usb connected caution light that we could stick on the top of the self check, to flash when an error occurs, and a way to plumb it in to the process. Maybe a strobe light or confetti dropper or smoke machine! 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] Missing item check-in - handling holds
Michele, I’ve been thinking about your recommendation off and on, and now a year later I’m looking back into making this change, but I want to make sure I understand all the issues created from this change. · Pull list shouldn’t be effected; only available/reshelving items should show up on the pull list. · Missing items could still be hidden from the catalog, so public users wouldn’t place holds on titles that have no visible copies. · Patrons may be able to place holds on titles that have non-holdable visible copies along with invisible holdable copies. · Staff will be able to place holds on titles that have only missing copies. · Any reports that make use of config.copy_status.holdable may need to manually exclude missing status, for purchase alert/high demand holds reports for instance. We wouldn’t want a missing copy to count towards a hold/copy ratio. It may not be possible to use the built in reporter hold/copy ratio data sources at all since they would consider all Missing copies holdable and count them as holdable copies. · We already have a report that goes twice a month with lists of holds on titles that have no holdable copies so staff can deal with them, so that should cover the ones that slip through. Does that seem to cover it? Could you also let me know what the other statuses were that you changed. How about lost status? We move things to lost fairly quickly (14 days overdue) so we have quite a few lost items. I wonder if there has ever been any thought on having a new copy status flag, something like ‘capture allowed’. Something that would allow copies to be captured to fill holds, but wouldn’t count as holdable. Maybe action.hold_copy map could have a flag so when targeting or looking for holdable copies only holdable copies would be considered, but during check in captureable copies would be considered for opportunistic capture. That way certain statuses (lost/missing/long overdue/cataloging) might work a little smoother at check in. Thanks Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Josh Stompro Sent: Thursday, March 31, 2016 1:45 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Missing item check-in - handling holds Michele, Thanks for the suggestion. We will look into trying this out. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Morgan, Michele Sent: Wednesday, March 30, 2016 10:05 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Missing item check-in - handling holds Josh, To avoid the issues with Missing copies not capturing holds, we changed the config.copy_status.holdable flag for the Missing status to TRUE. This means that items with status Missing get entries in the hold_copy_map and can be captured when checked in. We did this with a handful of the more transient statuses that were not holdable by default and that has worked well to help with the checkin issues. It's true that making these statuses holdable can result in holds being placed on records with no items currently available, but we provide reports to help our libraries follow up on these. That said, I like your idea of attacking the problem based on the copy that's being checked in without forcing all that retargeting. Hope this helps, Michele -- Michele M. Morgan, Technical Assistant North of Boston Library Exchange, Danvers Massachusetts mmor...@noblenet.org<mailto:mmor...@noblenet.org> On Fri, Mar 25, 2016 at 11:48 AM, Josh Stompro <stomp...@exchange.larl.org<mailto:stomp...@exchange.larl.org>> wrote: Hello, does anyone have any suggestions with how to best handle missing/lost items with holds at check-in? What I think is happening is that the missing items don’t have any entries in action.hold_copy_map since they were not holdable. Now that they are available again, there will be no entries in the hold copy map until the first hold gets retargeted. So the check-in either sends the item to re-shelving or in-transit back to the circ lib, even though there may be holds waiting locally or at a closer location than the circ lib. The copy will show up on the pull list after at least one of the holds gets retargeted, but it won’t necessarily be the correct hold that is next in line until 24 hours later. The work arounds that I know of are to use the Retarget Local Holds & Retarget all statuses check in modifiers, which will help if there are any local holds. But if there are no local holds then this won’t address the issue. The second work around is to manually select holds to retarget from the holds list. Has anyone worked out a way for this to happen automatically, so that at a status change from a non-holdable to holdable status the copy gets added to the hold c
Re: [OPEN-ILS-GENERAL] Fines conundrum
John, do you mean that the summary balance under the bills tab shows nothing? [cid:image001.png@01D24C8F.F0680970] I’ve seen this happen when I’ve changed values in the money.payments table instead of the table the corresponds with the payment type. There are materialized views (a summary table that is kept in sync with triggers instead of pulling live data) that can get out of sync with reality. It could be that the triggers that keep the summary tables up to date have been broken. I think you need someone to take a look at the money.* tables and triggers to make sure they match up with your releases setting. The summary tables can be re-created from the systems current state to get the values back in line. You can check on this by choosing a patron that shows the symptoms, and looking at a few tables for that patron. You need sql access for this. · money.usr_summary should show that users balance totals. · Money.billable_xact_summary should show a summary for each bill for that customer. If they should have a fine, but it shows a zero balance for that bill, then the money.billable_xact_summary is out of sync. · Money.billings for the same bill should show the fine. Josh Stompro - LARL IT Director -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of John Clark Sent: Friday, December 02, 2016 9:03 AM To: Evergreen Discussion Group Subject: [OPEN-ILS-GENERAL] Fines conundrum Hi folks, At least two of our member libraries in the Maine Balsam Consortium are perplexed and vexed. I've copied their problem below in hopes someone in the Evergreen world might have experienced (and solved) a similar issue. I thank all in advance for any shared wisdom. Regards, John R. Clark-treasurer, Maine Balsam Library consortium Evergreen no longer adds fines to a patron’s account. When an item is returned and checked in it shows that a fine has accrued, but when we go to that patron’s account there is nothing under bills……But click on bills and overdues are there! It started at first just on movies and now its books as well. How can we get accrued fines to show? -- Retired librarian, author, freelance editor, book reviewer https://www.facebook.com/wizardofhartland http://cmldbookreviews.com/
Re: [OPEN-ILS-GENERAL] Holds ratio report
Hello Karen, if you are talking about a report that shows titles with a hold to copy ratio over a certain threshold then yes we have one. I'm not sure if that is the same thing as "generate holds ratios for circulation activity". Circulation activity to me means checkouts, so I'm not sure what kind of report would involve both. But I'll answer like you mean the hold/copy ratio. If you are ok with the ratio being global(All holds at every pickup location and all copies) there has been a built in data source for this for a while. See the Hold/Copy Ratio per Bib reporter data source. Screenshot of example report at: http://imgur.com/a/x3Hh4 If you are in a consortium where each branch stands alone, federated model, there was a new data source added in 2.10 that allows you to break down the report by pickup library and circ lib. Look for Hold/Copy Ratio per Bib and Pickup Library (and Descendants). I tried to use this but there are gotchas that make it unsuitable for us. Mainly the fact that only holds at pickup locations with holdable copies are counted, so if a branch has 10 holds, but no holdable copies, those holds are not counted in the report when looking at a system level report. Meta-holds cause some strange numbers also. I made note of the issues I found at https://bugs.launchpad.net/evergreen/+bug/1627231 I can give you screenshots of this also if you want to see my test reports. I created a custom sql query to create the report that we needed. Our organization has two regional systems. It takes into account several situations that are specific to our environment, such as: * We will normally never purchase more than 10 copies of a title no matter what the ratio is, so when we hit 10 or more copies, the title is no longer shown in the report. * We have non-holdable Express copies that we count as holdable since many of them end up filling related holds. * Don't count suspended holds since we don't want to purchase copies for those that may never activate those holds. If someone is delaying their hold for several months, the ratio may change by the time their hold is active since holds will get filled in the meantime. * Holds are divided by the patron's home library, not the pickup location. We don't want to purchase copies for patrons from other systems that use our branches as pickup locations. * Summary of holds (Oldest hold age, Average hold age, Holds placed in last 7 days, 30 days, Frozen Holds) * Summary of Items (Lost Items, Missing Items, Damaged Items, On Order Items) * Summary of hold pickup locations, to tell where new copies should be allocated. Query is at https://gist.github.com/stompro/e794d0e65356ff619edc9930e6ef7373 Sample report: num title author bib_record type holdable_copies express Total Copies holds hold_copy_ratio Hold Counts LongLost ShortLost missing damaged onorder 1 the wrong side of goodbye connelly, michael 204437 book 3 2 5 28 5.6 Oldest:(5 mons 1 day) Average:(39 days) 7_Days:5 30_Days:21 Frozen:1 0 0 1 0 0 2 the out of sync child kranowitz, carol stock 65808 book 1 0 1 5 5 Oldest:(3 mons 10 days) Average:(37 days) 7_Days:1 30_Days:3 Frozen:0 0 0 0 0 0 3 a holiday to remember 153500 dvd 0 4 Infinity Oldest:(12 days) Average:(10 days) 7_Days:0 30_Days:4 Frozen:0 num title author bib_record type holdable_copies express Total Copies holds hold_copy_ratio Hold Counts LongLost ShortLost missing damaged onorder Hold Pickup Summary 1 turbo twenty three evanovich, janet 201895 book 5 0 5 26 5.2 Oldest:(7 mons 21 days) Average:(2 mons 31 days) 7_Days:1 30_Days:2 Frozen:0 0 0 0 0 0 GODEL:(1), HALLOCK:(5), RED_LAKE_FALLS:(2), ROSEAU:(4), THIEF_RIVER_FALLS:(10), WARROAD:(4) 2 the whole towns talking flagg, fannie 207896 book 0 4 Infinity Oldest:(3 mons 6 days) Average:(2 mons 11 days) 7_Days:1 30_Days:1 Frozen:0 GREENBUSH:(1), HALLOCK:(1), RED_LAKE_FALLS:(1), THIEF_RIVER_FALLS:(1) Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Karen Prasse Sent: Wednesday, November 30, 2016 2:48 PM To: open-ils-general@list.georgialibraries.org Subject: [OPEN-ILS-GENERAL] Holds ratio report Hello, Has anyone created a template or written a report that will generate holds ratios for circulation activity in Evergreen? Karen Prasse Reference Librarian Burlington Public Library 820 E. Washington Ave Burlington, WA 98233 360-755-0760 kar...@burlingtonwa.gov<mailto:kar...@burlingtonwa.gov> http://www.burlingtonwa.gov/library
Re: [OPEN-ILS-GENERAL] opposite of force/recall hold
Holly, I'm late to the conversation, but here is what I think I would do in this situation. I would place all the holds and then suspend any that were currently checked out. I'm assuming they would all be copy holds since you want to evaluate specific copies. I don't believe a suspended hold would block a renewal. There is a bug open about adding back the ability to suspend at time of hold placement that would streamline this part a little bit. Bug 1189989<https://bugs.launchpad.net/evergreen/+bug/1189989> Then on a regular basis I would run a report showing which of the copies that I have suspended holds on are now (available/reshelving/checked out with no other holds and no more renewals allowed) and activate those holds. I would probably do that for a certain amount of time and then throw up my hands and activate the rest, just to get done with the process in a bounded time period. Or just set a specific activation date when suspending, so they would go live after 2 months, no matter what. An sql query could do the work of checking for availability and activating the holds. If you caught the copy at the stage that it has no other holds and all renewals had been used, then it would be pretty seamless, when activated against available items you will cause more staff work by adding items to the pull list. Josh Stompro - LARL IT Director From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Holly Brennan Sent: Friday, October 07, 2016 7:40 PM To: Evergreen Discussion Group (open-ils-general@list.georgialibraries.org) Subject: [OPEN-ILS-GENERAL] opposite of force/recall hold A staff member needs to put a lot of DVDs on hold to assess the physical condition, but is in no rush. We don't want to prevent patrons from renewing items they have just because of our staff hold. In other words, we're looking for something that's the opposite of the force/recall hold types. A "timid" holda pushover that's okay with being sent to the back of the line until absolutely no one else cares about the item. It would speak up only after the item is checked in and moves to Available status. Anyone else feel this would be a useful addition? Or maybe there's a way to make this process work with the existing ILS functions? Thanks! -Holly Holly Brennan Technology Specialist Homer Public Library Homer, Alaska hbren...@cityofhomer-ak.gov<mailto:hbren...@cityofhomer-ak.gov> 907-435-3154 (direct) 907-235-3180 (main desk)