Evergreen ILS Website

IRC log for #evergreen, 2015-01-08

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat

All times shown according to the server's local time.

Time Nick Message
05:09 pinesol_green Incoming from qatests: Test Failure - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
05:44 tsbere_ joined #evergreen
06:14 mtate joined #evergreen
06:14 eeevil joined #evergreen
06:14 phasefx joined #evergreen
06:15 Callender joined #evergreen
06:15 BigRig joined #evergreen
06:15 TaraC joined #evergreen
06:15 maryj joined #evergreen
06:16 graced joined #evergreen
07:14 csharp jeff: we would definitely be interested in a way to detect duplicate patrons - we just did a massive dedupe effort with the help of UMS
07:15 csharp my thought is to have an interface similar to Admin -> Local Administration -> Transit List that would allow library staff to input various parameters (matchpoints) to find dupes
07:17 csharp e.g., "match patrons registered in the last day/week/month/arbitrary date range at my library against the full patron set on first name, middle name, last name, DOB, etc."
07:23 jboyer-isl joined #evergreen
07:53 julialima_ joined #evergreen
07:54 Shae joined #evergreen
07:57 csharp @weather 30345
07:57 pinesol_green csharp: The current temperature in Lakeside, Atlanta, Georgia is 10.9°F (7:45 AM EST on January 08, 2015). Conditions: Clear. Humidity: 68%. Dew Point: 3.2°F. Windchill: 10.4°F. Pressure: 30.67 in 1038 hPa (Falling).  Wind Chill Advisory in effect until 10 am EST this morning...
07:57 csharp dayum that's cold
07:57 eeevil @weather 30101
07:58 eeevil I think I broke it...
07:59 csharp I think it's a whitespace issue :-P
07:59 eeevil ha!
07:59 eeevil @weather 30101
07:59 pinesol_green eeevil: The current temperature in Mars Hill Acres, Acworth, Georgia is 7.2°F (7:58 AM EST on January 08, 2015). Conditions: Clear. Humidity: 86%. Dew Point: 3.2°F. Windchill: 6.8°F. Pressure: 30.58 in 1035 hPa (Rising).  Wind Chill Advisory in effect until 10 am EST this morning...
07:59 csharp yowza
07:59 * eeevil switches to monospace font in quassel
08:03 collum joined #evergreen
08:13 gmcharlt @wunder 99507
08:13 pinesol_green gmcharlt: The current temperature in APRSWXNET Anchorage AK US, Anchorage, Alaska is 19.9°F (3:38 AM AKST on January 08, 2015). Conditions: Overcast. Humidity: 81%. Dew Point: 15.8°F. Windchill: 19.4°F. Pressure: 30.07 in 1018 hPa (Falling).  Freezing Rain Advisory in effect from 4 am to noon akst Thursday...
08:13 gmcharlt @wunder 30097
08:13 pinesol_green gmcharlt: The current temperature in Norman Downes, Duluth, Georgia is 9.5°F (8:11 AM EST on January 08, 2015). Conditions: Clear. Humidity: 68%. Dew Point: 1.4°F. Windchill: 10.4°F. Pressure: 30.67 in 1038 hPa (Falling).  Wind Chill Advisory in effect until 10 am EST this morning...
08:13 csharp haha
08:14 * csharp asks to borrow hbrennan's coat
08:14 Dyrcona joined #evergreen
08:14 gmcharlt csharp++
08:20 ericar joined #evergreen
08:28 mrpeters joined #evergreen
08:29 kmlussier @wunder 02771
08:29 pinesol_green kmlussier: The current temperature in Rumford, East Providence, Rhode Island is 2.5°F (8:25 AM EST on January 08, 2015). Conditions: Partly Cloudy. Humidity: 53%. Dew Point: -11.2°F. Windchill: -9.4°F. Pressure: 30.35 in 1028 hPa (Rising).  Wind Chill Advisory in effect until 11 am EST this morning...
08:32 bshum @weather 06776
08:32 pinesol_green bshum: The current temperature in Parkwood, New Milford, Connecticut is 1.0°F (8:32 AM EST on January 08, 2015). Conditions: Clear. Humidity: 73%. Dew Point: -5.8°F. Windchill: 1.4°F. Pressure: 30.38 in 1028 hPa (Rising).  Wind Chill Advisory in effect until 10 am EST this morning...
08:39 mmorgan joined #evergreen
08:46 abowling joined #evergreen
08:51 bshum dbs: Aha, I found the bug I filed about the conflicting SIP config files
08:51 bshum https://bugs.launchpad.net/evergreen/+bug/1399790
08:51 pinesol_green Launchpad bug 1399790 in Evergreen "deprecate oils_sip.xml.example" (affected: 1, heat: 6) [Wishlist,Triaged]
08:54 jwoodard joined #evergreen
09:03 pinesol_green [evergreen|Jason Stephenson] LP#1396359: Add tooltips for 264, 344, & 347 tags to en-US/marcedit-tooltips.xml. - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=605bce0>
09:03 pinesol_green [evergreen|Jason Stephenson] LP#1396359: Add entries for 345 and 346 tags to en-US/marcedit-tooltips.xml. - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=f3a031f>
09:04 Dyrcona bshum++
09:09 kmlussier mmorgan: Do you want me to update your MassLNC Sandbox with the latest code from bug 1210541?
09:09 pinesol_green Launchpad bug 1210541 in Evergreen "Copy locations table should have a 'deleted' flag" (affected: 9, heat: 52) [Wishlist,Confirmed] https://launchpad.net/bugs/1210541 - Assigned to Michele Morgan (mmorgan)
09:09 kmlussier It would be nice to see that one make it into 2.8
09:10 mmorgan kmlussier: Yes, please!
09:24 rjackson-isl joined #evergreen
09:33 * csharp makes the red alert noise LOUDER
09:36 bshum Oh gods why?
09:36 bshum :)
09:36 * csharp likes keeping PINES staff on their toes
09:36 bshum I still want to replace all the sounds on my Evergreen system with Super Mario clips
09:36 csharp bshum: that would be awesome
09:36 csharp each book checkin would be the coin sound!
09:37 bshum "Thank you for capturing this hold, but your item is needed in another library."
09:37 Dyrcona heh
09:37 csharp hold succesfully placed = mushroom noise
09:37 * csharp LOLs
09:37 bshum Hehe
09:39 sarabee joined #evergreen
09:39 csharp you could even have the theme music play constantly as long as the staff client is on
09:39 * csharp rubs hands together evilly
09:40 collum http://themushroomkingdom.net/media/smw/wav
09:41 csharp collum++
09:41 bshum I remember that site
09:42 bshum I borrowed clips from there to experiment once on one of my test servers :)
09:45 bshum Hmm
09:45 bshum https://bugs.launchpad.net/evergreen/+bug/638509
09:45 pinesol_green Launchpad bug 638509 in Evergreen 2.4 "renewing lost items fails unintuitively" (affected: 6, heat: 30) [Medium,Confirmed]
09:45 bshum Dyrcona has some code on that bug
09:45 bshum Maybe we should pull it out of the dark
09:46 kmlussier No, that's not ready.
09:46 kmlussier I don't think that one can be worked on until dbwells is done tackling the fine generator changes he's been working on.
09:47 bshum Oh boy, gotcha.  So many interlinked bugs...
09:49 dbwells There are already two incompatible fine changes in master.  The negative balances bug is cursed.
09:49 Dyrcona 638509 doesn't depend on negative balance work.
09:50 * Dyrcona thinks billing is cursed. Everyone should just not charge fines. :)
09:53 kmlussier It doesn't depend on the negative balance work, but one of the remaining bugs was related to the generation of fines when the generate new fines for lost item return setting is enables.
09:53 kmlussier Which is similar to the bug that we came across with the negative balance bug.
09:54 kmlussier dbwells: Really? That makes me very sad. :(
09:56 dbwells Well, they aren't tear-your-hair-out changes, but they are another small roadblock on the road to integration.
10:00 Sally joined #evergreen
10:27 * dbs has had three heated discussions over the past few days about "Grocery" bills
10:28 dbs All coming down to "Why is it called "Grocery"? We don't sell groceries!"
10:28 dbs *sigh*
10:28 bshum Sounds like my libraries.
10:28 kmlussier dbs: Yes, we hear that here too.
10:28 bshum Maybe that should be a 2.8 feature
10:28 dbs The best alternative I've been able to come up with, as a human-generated bill, is "Staff"
10:28 kmlussier To rename groceries?
10:28 bshum "Evergreeners, we hear you.  Nobody wants groceries, so in 2.8, we are renaming them!"
10:29 bshum Best Evergreen release ever.
10:29 jboyer-isl PEAS AND CARROTS.
10:29 jeff "non-circ"
10:29 jboyer-isl And books.
10:29 dbs jeff: but it is circ.
10:29 jeff "bill not tied to any circ"?
10:29 berick i always referred to them as "miscellaneous"
10:30 dbs Yeah. Except for when we create bills because a bill was voided or forgiven and we want to tie it back to the circ through the note.
10:30 jeff that gets confusing when you have a Misc/Miscellaneous billing type (which staff are forbidden to use! ;-)
10:30 mmorgan So, where did the "grocery" term come from? Inquiring minds want to know ;-)
10:30 kmlussier Staff makes sense to me.
10:30 berick jeff: hah, goog point.
10:30 dbs The main difference from my perspective is that one is system generated, one is human generated.
10:31 kmlussier It's similar to hold cancel reasons. Most are system-generated, but the ones that are done by staff are called "staff forced."
10:31 dbs mmorgan: Like a bag of groceries, it can contain many different items
10:31 kmlussier If you use the word "staff", you're providing a bit of consistency.
10:31 jeff dbs: i've seen migrations where the patron alert messages say "patron still owes on paid transactions for books X and Y", because in the old system you couldn't remove a book from public view (and holds) unless it was first checked in, and checking it in closed the 'lost item' bill...
10:32 dbs I've been saying that I don't want to put in the work to carry a local patch to customize it here for release after release, because of drift from core documentation etc
10:32 berick mmorgan: it came from.. when you buy something at the store and the machine has no designation for what you bought.  so, instead of saying "hotdogs", it just "grocery"  (IOW miscellanous)
10:32 dbs but if there's willingness to accept a change to "Staff" in 2.8, I would be willing to make that happen
10:32 jeff heh
10:32 dbs But then we have the sub-categories of Grocery that let you call it a hot dog again.
10:33 dbs Or at least "Heavily processed meat substances"
10:33 jeff i'd favor removing the distinction (and thus the need for any term) completely, as far as the staff interfaces are concerned -- backend and api and reporting are something else.
10:33 kmlussier Maybe a poll is in order?
10:34 jeff from a UI sense, transactions are transactions, and some have a circulation tied to them, and some don't.
10:34 jeff you pay them all the same way.
10:34 berick yeah, the 'grocery' analogy was quickly outgrown in the code.
10:34 dbs changing a label is relatively easy, I'm not sure how hard removing the distinction would be
10:35 * dbs isn't even sure if he understands what jeff is suggesting
10:35 jeff i'm opening the billing interface to make sure i understand what i'm suggesting.
10:35 * mmorgan is not totally comfortable removing the distinction between charges assessed by the system and those added by staff.
10:35 jeff mmorgan: i'm not advocating that.
10:36 mmorgan ok, good :)
10:36 jeff (i know that much without the interface having loaded yet :-)
10:36 dbs The problem for us isn't when the bill is being created (because you really only have the choice to add a Grocery bill)
10:37 dbs It's when people look at it after in a list of bills and their eyes boggle at Grocery.
10:38 dbs Transaction type: Grocery (only valid option) vs. Circulation (greyed out)
10:38 jeff so right now, to create a "grocery" transaction, you hit Bill Patron, and under Transaction Type the only option you can pick is Grocery (the same Bill Patron Wizard interface is used for Add Billing on an existing transaction)
10:38 dbs Billing type: Damaged item, Other, blah blah
10:38 jeff right, you just said all that as I was typing. :-)
10:39 mmorgan The "Last Billing Type" and "Last Billing Note" columns are more informative for staff. We advocate turning these two on.
10:40 jeff the "Type" column could go away and Title could contain N/A when the transaction isn't tied to a circ, etc.
10:40 jeff and yes, mmorgan said what I was going to say next.
10:41 jeff bad news: i'm slow at expressing myself this morning using my keyboard. good news: i don't seem to be saying oddball things that nobody else is saying/thinking either? :-)
10:42 eeevil jeff: problem is, that's much simpler said than done, in both UIs ... the shape of the data is different, so there are layers of abstraction needed
10:42 * jeff nods
10:43 eeevil I'm totally +1 for relabeling for 2.8, though
10:43 jeff i agree with dbs' statement that "changing a label is relatively easy, I'm not sure how hard removing the distinction would be" :-)
10:44 dbs And patrons don't see "Grocery" in the Fines -> Other fees section, they just see the billing type.
10:44 * dbs totally typed "grocery -r Grocery" to see where the label would need to be changed.
10:44 dbs malkovich malkovich malkovich
10:45 kmlussier heh
10:46 dbs It looks like it could be as simple as one line (3 if we include fm_IDL.xml) to change the human visible occurrences.
10:47 * kmlussier is in favor of changing the label in 2.8 as long as the decision isn't made after a brief discussion in IRC among people from just a few Evergreen sites.
10:47 dbs "Other fees" to align with the category that we show to patrons? Or "Staff" to distinguish between human-generated and system-generated bills and align with the staff client cancel reasons like kmlussier
10:47 eeevil kmlussier++
10:47 dbs noted?
10:47 * dbs too, will create a bug and a patch and point at it on the mailing list
10:48 dbs Sorry, 8 more references in the docs.
10:48 eeevil interestingly, there's a third transaction type not represented on the refrerenced dropdowns (Booking) ... not that we need to add another greyed-out option, mind ;)
10:48 dbs heh
10:49 kmlussier dbs++
10:49 dbs I like "Staff" best, I think, because it captures the human-generated distinction
10:49 eeevil but the list has (at least in the backend) grown before, and I wouldn't say it never will again, and with an xact type that would be staff-selectable
10:49 kmlussier This all sounds good.
10:49 * kmlussier concurs with "staff."
10:50 * eeevil mumbles something about 640k of RAM
10:50 dbs eeevil: Cross that bridge when we get to it?
10:52 eeevil dbs: of course. I just don't want to see us rip out a bunch of code and replace it with abstractions that we later have to de-abstract ... assuming that a label change makes a significant improvement, which (IMO) it would
10:54 dbs oh damn, it looks like the raw label (lowercase version of "grocery") is used in the "Type" display of the patron bills
10:55 dbs That's bad for both i18n and for making this a clean change :/
10:57 jeff I don't think "staff" makes sense, since staff can and do manually add billings to circulation transactions.
10:57 jeff And A/T can automatically add "grocery" transactions (iirc).
10:58 dbs Well, sure, you can create grocery bills via sql too (and I did when we migrated)
10:58 dbs I think Staff makes sense in the context of the interfaces in which it appears.
10:59 jeff I just mean that in a setup where "the system" is configured to automatically generate grocery transactions for something like postal overdue notices, saying "this is a staff transaction, and not a system transaction" seems wrong.
11:00 jeff "circ" and "other"? *shrug*
11:00 * mmorgan sees jeff's point
11:01 mmorgan "miscellaneous"?
11:02 kmlussier Quote from the meeting I'm sitting in on ATM: "[acq] is a charm."
11:02 dbs Everything is miscellaneous, quoth David Weinberger.
11:02 dbs "Other fees" would match the patron perspective, then.
11:03 kmlussier I would say any of the suggestions that have been raised so far is a more fitting description than grocery.
11:03 eeevil +1 to "Other fees" ... or maybe "General fees and fines"
11:04 bshum +1 "Other fees" then.  (shorter is better)
11:04 jeff Other is even shorter. ;-)
11:04 dbs X
11:04 bshum :)
11:06 jeff (since they might not all be "fees") :-)
11:06 dbs Oh? So we shouldn't call them fees in the OPAC Patron -> Fines section?
11:08 dbs Other Fines? and change the patron OPAC section to match?
11:10 * dbs is stepping back into the staff client XUL + JavaScript to try and figure out how to i18n-ize the xact_type properly and... ugh.
11:11 jeff yeah. i did have a moment of "shouldn't i be looking at the web interface and not xul" a few minutes ago.
11:21 * dbs should get the web staff client running some day
11:22 * dbs bad evergreen developer
11:26 * kmlussier wonders if we have any documentation on reshelving
11:27 bshum It would probably have fallen in the same area as setting up cronjobs.
11:27 bshum Which wasn't written
11:29 bshum It's not in the Book of Evergreen anyways :)
11:29 kmlussier Yeah, I don't see it. But I think it goes beyond cron jobs.
11:30 bshum I suppose so
11:30 Dyrcona IIRC there's a wiki page about cron jobs. I know I've seen something somewhere. Maybe just comments in the sample crontab.
11:30 bshum Someone can probably cobble a new section out of the random snippets I keep writing in my replies to the list :)
11:31 kmlussier It should also address how the cron job interacts with those OU settings and the recommendations on not running the process during the day.
11:31 kmlussier bshum: Yeah, that's what I was thinking.
11:31 Dyrcona This is a case of, "We expect you to know something about Linux before you install Evergreen." ;)
11:31 kmlussier I'm filing an LP bug. I'll work on it if I have time, but it will be there in case somebody else has the tuits to do it.
11:32 * dbs looks at the "20 * * * *" he has had running in production for the past five years and wonders why he hasn't seen problems
11:32 bshum kmlussier: Well not running it during the day may not be a problem for long if we tested tsbere's fix for https://bugs.launchpad.net/evergreen/+bug/1018011 and found it to solve the issue.
11:32 pinesol_green Launchpad bug 1018011 in Evergreen "Incorrect copy status caused by reshelving process colliding with item checkout" (affected: 5, heat: 24) [Medium,Confirmed]
11:33 dbs Ah, academics don't tend to be busy relative to publics, but yes, those symptoms sound familiar.
11:34 bshum dbs: I think Bmagic included a query for the auditor table to identify items that go through these bad transitions.
11:34 bshum It's in the bug comments
11:35 Bmagic bshum: ah yes, that was a fun query
11:35 dbs Hmm. 0 rows here.
11:36 bshum Just lucky I guess.
11:36 bshum :)
11:37 Bmagic dbs: do you purge the auditor table?
11:37 bshum I've got 20 in mine.  And that's even with purging our tables over the years and not running the script that often.  So maybe there's other reasons it can happen too.
11:38 dbs Bmagic: naw, there's 1104218 total rows in there
11:39 dbs Our last purge left everything from 2013-01-01 on
11:39 Bmagic dbs: lucky for sure! Or specifically, none of the circ staff are in the habbit of checking out items immediately after checking in
11:40 dbs I think the number of items we have to reshelve are so minimal that the race condition is unlikely to occur with us.
11:41 * bshum likes reading how many items get changed from reshelving every night in his nightly email notification of the completed cron job.
11:41 bshum It still boggles me to think that we had 142 reshelved things on the Christmas run
11:42 bshum Who used the library on Christmas day for crying out loud
11:44 dbs The most we've ever had reshelved at once was 65 items.
11:44 dbs (at least since June)
11:44 bshum Yeah
11:44 dbs Running the reshelving cron job more often might actually help us.
11:44 dbs This is why documentation is hard.
11:46 dbs "time" says that the reshelving script takes less than a tenth of a second to run when there are 0 items to reshelve, I guess I'll try changing the cronjob to see what happens with more items
11:46 Bmagic It seems like tsbere's solution to the problem would work
11:46 Bmagic It's so simple!
11:47 bshum It definitely should take longer, the more you have to reshelve
11:48 bshum If I believe the output, we took 43.844167 seconds for reshelving 11510 items last night.
11:49 dbs Sure, that makes sense.
11:51 dbs We've had a total of 18688 circ transactions since July 2014. Hah.
11:51 dbs "we" being just my library. include all of conifer, and that brings you up to a total of 27,000.
11:52 dbs This is why we need an academic library group I guess :)
11:52 bshum Heh
11:53 Dyrcona WE had 17,615 checkouts yesterday.
11:54 tsbere 3035375 overall circulations (including renewals) since midnight on july 1st for us. <_<
11:55 bshum Dyrcona: Only 13433 for us.
11:55 bshum Guess you guys were busier :)
11:55 Dyrcona :)
11:55 dbs wow
11:56 Dyrcona Well, with 36 libraries.... I wonder how many PINES or CW/MARS do in a day.
11:57 berick had to check.. kcls did 55330 yesterday
11:58 * berick is curious about pines and cw/mars too
12:00 kmlussier Ha ha. dbs' busiest reshelving day was still less busy than Christmas at Biblio.
12:00 dbs Small wonder public libraries freak out about how slow the staff client can be
12:00 dbs kmlussier: that was our busiest reshelving hour, but probably still less busy :)
12:01 kmlussier dbs: Ah, that's right. One hour.
12:02 kmlussier Not as stark of a difference as I thought. It would be a better story if that were your daily total.
12:06 csharp PINES did 7,785,770 since 7/1/2014 and 35,027 yesterday
12:07 csharp we did 63,464 on 1/5
12:13 bshum This would make a very fun infographic.
12:13 bshum Evergreen circ stats for the world!
12:13 csharp might be good for the State of Evergreen
12:13 Dyrcona Reshelving complete from last night was 15171, just for the sake of throwing that out there.
12:13 bshum A day in the life of Evergreeners everywhere.
12:13 jeff i've been (saying, not doing) that kind of thing for a while now. i'm pretty sure koha recently started doing similar.
12:14 jeff (so i'm not totally nuts)
12:14 jeff (though i suppose that relies on certain assumptions...)
12:15 jihpringle joined #evergreen
12:15 kmlussier Now I'm curious about what C/W MARS' numbers are too. It's too bad tspindler isn't in here anymore.
12:17 Dyrcona @eightball Does is scale?
12:17 pinesol_green Dyrcona: Come again?
12:19 jeffdavis huh, 14,157 circs at Sitka yesterday (11,726 excluding renewals), and just over 2M since Jul 1
12:21 buzzy joined #evergreen
12:23 phasefx you guys just counting all action.circulation rows with a given xact_start date or range?  Just thinking about fun with renewals, and whether they should count (I'd say so)
12:23 csharp phasefx: that's what I'm doing, yeah
12:23 csharp we count renewals as circs in all of our official stats
12:24 phasefx how about non-cats?
12:24 * phasefx really would love infographics for this stuff
12:29 hopkinsju Did someone say 'non-cat'? http://bit.ly/NMq9jn
12:30 phasefx hopkinsju++
12:36 csharp hopkinsju++
12:37 csharp phasefx: we record them, but in a separate stat.  I think the libraries add them up.
12:39 kmlussier hopkinsju++
12:41 kmlussier acq++ #It's getting rave reviews from MVLC's 2 acq pilot libraries. :)
12:42 hopkinsju kmlussier: Our first acq library just went live this week. We haven't heard back from them because their key folks are on vacation, but we're hopeful. Training went well apparently.
12:43 Dyrcona hopkinsju++
12:43 kmlussier hopkinsju: There were a few bumps in implementing it, but once it's set up, it seems to have gone smoothly for them.
12:43 * hopkinsju has discovered the secret of gaining karma on the internet: cat pictures.
12:43 dbs yay! we're supposed to start using acq for realz soon now. lessons learned would be very welcome :)
12:44 kmlussier hopkinsju: It works every time!
12:44 hopkinsju ikr!
12:45 kmlussier dbs: One lesson learned is paying attention to bug 1297967 and doing what it says.
12:45 pinesol_green Launchpad bug 1297967 in Evergreen "document openils-mapper code for enriched EDI" (affected: 1, heat: 6) [Undecided,New] https://launchpad.net/bugs/1297967
12:45 hopkinsju dbs: Bmagic probably has some lessons to share. We ran into a few bugs/problems that he had to fix.
12:47 dbs We're probably a long way from implementing EDI
12:48 dbs as I'm certain Coutts isn't one of the out-of-the-box supported EDI configs :)
12:53 csharp we're going live with a pilot library next month, I think
12:54 csharp either next month or the following
12:54 * csharp just wants the Ruby stuff to disappear before we do :-)
12:55 dbs rub out the ruby!
13:18 jeff pretty sure this 500$a came from oclc: ``Gift of Kappa Delta Pi, Alpha Delta Omega Chapter International Honor Society in Education''
13:25 * dbs searches through local ticket history, finds a 3 year old bug complaining about "Grocery" where his response was effectively mmorgan's (to display "Last billing type" and "Last billing note")
13:26 * dbs adds a new comment to the long-ago closed ticket, doesn't mention forgetting history or being doomed to repeat it
13:26 bshum Heh
13:27 * bshum is probably just doomed
13:33 csharp dbs: beware bug 1206936 when dealing with last billing type/last billing note
13:33 pinesol_green Launchpad bug 1206936 in Evergreen "money.transaction_billing_summary view displays incorrect billing_type and billing_note for the actual last transaction" (affected: 1, heat: 6) [Medium,Triaged] https://launchpad.net/bugs/1206936
13:35 dbs csharp: oh, seriously? Damn
13:35 * csharp was working that fix a while back but got bogged down when trying to incorporate PG window functions into money.billable_xact_summary
13:38 csharp wow - August was the last time I looked at it?!  time she is a flying
13:47 collum Better late than never. 5,347 ckos for yesterday.  However, the busiest of our 3 branches is getting some renovation done.  New carpet.
13:50 csharp okay... google-fu is failing... wasn't there a fix for the repeating format icons issue when grouping formats & editions?
13:50 dbs csharp: turning off grouping fixed the problem for us. heh.
13:50 csharp heh - I wish ;-)
13:52 bshum There was a fix for that yes.
13:52 csharp bshum: thank god you remember - I'm on another wild goose chase ;-)
13:52 bshum It's probably associated with the 2.7.2
13:53 dbs csharp: umm, did you compare the performance difference of the corrected windowed view vs. the one that returns incorrect info?
13:53 * csharp remembers kmlussier being in on the discussion
13:53 dbs 'cause on our tiny system, the results seem to be painful
13:53 bshum Yep: https://bugs.launchpad.net/evergreen/+bug/1401177
13:53 pinesol_green Launchpad bug 1401177 in Evergreen 2.6 "Results of a metarecord search will display duplicate format icons" (affected: 5, heat: 26) [Medium,Fix committed]
13:54 dbs Seq Scan on billing, yay
13:54 bshum csharp: See above
13:54 csharp dbs: when I tested long ago on our test server with real PINES data, it was speedy to acceptable
13:54 csharp dbs: but it's been a while
13:55 csharp bshum++ # thanks
13:56 * dbs throws in CREATE INDEX CONCURRENTLY m_b_xact_time_idx ON money.billing (xact, billing_ts); and gets an index scan instead
13:59 dbs Still 8600 ms
14:00 dbs But better than the 16500ms without the index
14:00 dbs But nobody wants to wait 8 seconds to retrieve each bill. *sigh*
14:01 * dbs suspects that despite our low circulation, our money.billing table is abnormally high due to some libraries that instituted fines that accumulate every 5 minutes.
14:02 dbs Yeah, the non-indexed version was resulting in a disk sort
14:03 * bshum is hopeful that PG 9.4's newly resized indexes will be beautiful.
14:03 * bshum plans to try that sometime in the coming months.
14:04 dbs 0.5 ms with the old-but-incorrect view. heh.
14:04 dbs SELECT COUNT(*) FROM money.billing; -- says 2681879 rows
14:12 csharp dbs: eeevil was advising me along the way - he may have some opinions about the overall approach in light of your findings
15:23 abowling just making a note that I pushed a patch to working that corrects the "Add Search Row" on the Advanced Search tab that creates a new blank input, rather than a pre-populated one with the value from the second row. i bring it up here, because the LP bug already had a pullrequest tag assigned to it.
15:23 abowling https://bugs.launchpad.net/evergreen/+bug/1154656
15:23 pinesol_green Launchpad bug 1154656 in Evergreen 2.4 "MARC Expert Search "Add Rows" adds duplicate row" (affected: 5, heat: 22) [Medium,Confirmed]
15:24 bshum abowling: Cool, when you set the comment, if you can include a link to your patch, it'll make it easier for those of us who get LP notifications on new comments, etc. for bugs
15:24 bshum The "pullrequest" tag is mainly for searchability or filtering in LP.
15:25 bshum By itself, it doesn't mean we'll know where to look for your branch.  Though I did find it easily enough... just good practice to link to your git changes :D
15:26 abowling np, bshum
15:39 eeevil dbs/csharp: I wonder if we can use the mat view instead there? (that's my opinion ... haven't looked at the perl/js in question to confirm it's possible)
15:47 dbs eeevil: mmm, something like CREATE OR REPLACE VIEW money.transaction_billing_summary AS SELECT id AS xact, last_billing_type, last_billing_note, last_billing_t2, total_owed FROM money.materialized_billable_xact_summary;
15:47 dbs ts, not t2. no metal men.
15:51 eeevil dbs: seems legit ... from my phone
15:53 eeevil dbs: unless the mat view triggers use that view ;)
15:54 * jeff grins
16:00 dbs eeevil: I looked at the triggers before suggesting that; doesn't seem to be a problem.
16:00 dbs And the materialized view serves up the correct data, too :)
16:00 csharp dbs++
16:01 dbs Total runtime: 0.094 ms
16:01 dbs me likes.
16:01 bshum Pretty...
16:14 * dbs needs to figure out why "Stay logged in?" prevents users from successfully logging in. Might be due to HTTPS-only mode, might be due to LDAP auth. FUN
16:22 dbwells dbs: That sounds familiar.  Let me see if we had to do something about that.
16:24 dbwells dbs: I think we had to add <type>persist</type> to the <login_types> in the auth_proxy settings.
16:26 julialima_ left #evergreen
16:31 dbs dbwells: ah, interesting
16:31 dbwells dbs: I am making a bug about it now, to at least get it in the sample config.
16:32 bshum dbwells++
16:34 dbs dbwells++
16:35 * dbs suspects fellow devs hate it when we finally catch up to a current version of evergreen :)
16:36 bshum Nah, just the RMs :)
16:38 * bshum likes dbs' patches anyways
16:39 * kmlussier loves it when Conifer catches up. :)
16:41 wjr joined #evergreen
16:51 pinesol_green Incoming from qatests: Test Failure - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
17:11 mmorgan left #evergreen
17:29 mrpeters left #evergreen
20:36 buzzy joined #evergreen
20:54 dbs Aww, you guys are too nice
20:55 * dbs glares at [ERR :32299:action.pm:1856:] Processing of hold failed:  Can't locate object method "workstation" via package "action::circulation" at /usr/local/share/perl/5.14.2/Ope​nILS/Application/Storage/CDBI.pm line 181.
20:57 buzzy joined #evergreen
21:02 dbs I guess "workstation" should be in the Essential list for CDBI/action.pm's circulation definition?
21:02 * dbs is rusty
21:19 kmlussier joined #evergreen
21:21 bshum joined #evergreen

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat