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