| Time |
Nick |
Message |
| 01:32 |
|
bwicksall joined #evergreen |
| 02:21 |
|
sandbergja joined #evergreen |
| 05:15 |
|
gsams__ joined #evergreen |
| 06:30 |
pinesol_green |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 07:02 |
|
agoben joined #evergreen |
| 07:10 |
|
rjackson_isl joined #evergreen |
| 07:16 |
|
kmlussier joined #evergreen |
| 07:24 |
|
dwgreen joined #evergreen |
| 08:12 |
pinesol_green |
[evergreen|Adam Bowling] LP#1778268: Fix incorrect close tag for label on line 58 of - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=b613f59> |
| 08:28 |
pinesol_green |
[evergreen|Cesar Velez] LP#1781473 - fix cosmetic issue with circ Id column - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=9888fb6> |
| 08:35 |
|
collum joined #evergreen |
| 08:36 |
|
mmorgan joined #evergreen |
| 08:44 |
pinesol_green |
[evergreen|Kathy Lussier] LP#1738249: Fix Circulation Library in Item Status Column Picker - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=dae9d1b> |
| 09:02 |
|
idjit joined #evergreen |
| 09:06 |
|
rlefaive joined #evergreen |
| 09:14 |
|
lsach joined #evergreen |
| 09:42 |
|
yboston joined #evergreen |
| 09:45 |
kmlussier |
dbwells: Do I have time to merge a couple more fixes or should I hold off until the next release? |
| 09:46 |
dbwells |
kmlussier: I'd say there is time. |
| 09:47 |
|
sandbergja joined #evergreen |
| 09:53 |
Bmagic |
dbwells++ # release wrangling |
| 10:03 |
dbwells |
Heads up, all: cutoff for commits for today's releases is 2:00pm eastern. Thanks! |
| 10:04 |
|
jvwoolf joined #evergreen |
| 10:14 |
csharp |
dbwells++ |
| 10:24 |
kmlussier |
dbwells++ |
| 10:26 |
pinesol_green |
[evergreen|Dan Wells] LP#1414197 Serial Item Delete Improvements - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=949a9af> |
| 10:29 |
|
BAMkubasa joined #evergreen |
| 10:30 |
BAMkubasa |
could I get you all's sanity check on a SQL query? |
| 10:31 |
BAMkubasa |
I'm trying to compare the number of holds fulfilled by another branch within a system compared to another system within the consortium |
| 10:32 |
BAMkubasa |
So, here's the query for holds fulfilled by branches with the same parent OU: |
| 10:32 |
BAMkubasa |
select (EXTRACT(YEAR FROM action.hold_request.fulfillment_time) || '-' || LPAD(EXTRACT(MONTH FROM action.hold_request.fulfillment_time)::text,2,'0')) AS YR_MO, count(*) as CNT from action.hold_request left join actor.org_unit AS ORG_REQ on (ORG_REQ.id = action.hold_request.request_lib) left join actor.org_unit AS ORG_FUL on (ORG_FUL.id = action.hold_request.fulfillment_lib) where action.hold_request.fulfillment_time is not null |
| 10:33 |
BAMkubasa |
got cut off |
| 10:33 |
BAMkubasa |
where action.hold_request.fulfillment_time is not null and ORG_REQ.parent_ou = ORG_FUL.parent_ou group by YR_MO |
| 10:33 |
BAMkubasa |
so the key part being 'and ORG_REQ.parent_ou = ORG_FUL.parent_ou' |
| 10:33 |
BAMkubasa |
or the converse 'and ORG_REQ.parent_ou != ORG_FUL.parent_ou' |
| 10:35 |
BAMkubasa |
the numbers for 'and ORG_REQ.parent_ou != ORG_FUL.parent_ou' are so much lower that I'm doubting their accuracy |
| 10:38 |
berick |
BAMkubasa: hey, might be easier for people to read the query if you paste it somewhere. here's a good spot: http://paste.evergreen-ils.org/ |
| 10:39 |
BAMkubasa |
on it @berick |
| 10:39 |
pastebot |
"BAMkubasa" at 64.57.241.14 pasted "I'm trying to compare the number of holds fulfilled by another branch within a system compared to another system within the consortium" (7 lines) at http://paste.evergreen-ils.org/13747 |
| 10:40 |
jeff |
when i'm seeing counts that don't match expectations, I generally drop the aggregate and examine the rows, sometimes adding more output columns as needed. |
| 10:40 |
jeff |
is your org hierarchy pretty much no more than three deep? |
| 10:40 |
jeff |
cons -> system -> branch? |
| 10:41 |
BAMkubasa |
@jeff yep, branch system and consortium |
| 10:41 |
pinesol_green |
BAMkubasa: http://xkcd.com/1739/ |
| 10:41 |
jeff |
there are a variety of functions that would be handy / more accurate if you needed to include sublibraries under branches or the like, but that sounds like it's not the case here. |
| 10:41 |
BAMkubasa |
@pinesol_green yeah, right? |
| 10:41 |
pinesol_green |
BAMkubasa: https://i.imgur.com/m8EySrW.gifv |
| 10:42 |
jeff |
are the numbers more in like with what you expect if you pay attention to pickup_lib instead of request_lib? |
| 10:42 |
kmlussier |
BAMkubasa: Don't mind pinesol_green. It's just a bot that thought you were trying to type a command because you used @. |
| 10:42 |
dbwells |
That darn cheeky bot. |
| 10:42 |
kmlussier |
BAMkubasa: No need to use the @ when typing a name. |
| 10:42 |
jeff |
I tend to favor pickup_lib for many of these types of reports, so I'm not sure what pitfalls you might encounter with reuest_lib in terms of OPAC placed requests vs staff placed requests, etc. |
| 10:42 |
BAMkubasa |
yeah that's what happens when you don't take the time to figure out how to address people by username |
| 10:43 |
kmlussier |
@blame Twitter |
| 10:43 |
pinesol_green |
kmlussier: Twitter is really just another name for autogen |
| 10:43 |
BAMkubasa |
kmlussier: here we go |
| 10:44 |
bshum |
Run Twitter and restart apache? :D |
| 10:44 |
BAMkubasa |
jeff: I'm going to try pickup_lib |
| 10:45 |
|
Christineb joined #evergreen |
| 10:50 |
jeff |
for the tiny slice of my data I looked at, request_lib matches pickup_lib more often than not. No obvious differences between hold requests where usr and requestor do/don't match. ymmc. |
| 10:50 |
jeff |
ymmv, even. |
| 10:51 |
mmorgan |
BAMkubasa: I'm not quite sure I understand the question you're trying to answer. But FWIW, pickup_lib should mostly match fulfillment_lib, since most items that fulfill holds are checked out at the pickup point. |
| 10:52 |
jeff |
oh. |
| 10:52 |
jeff |
heh. |
| 10:52 |
jeff |
yeah, sanity check is good. you're not paying any attention to the copy data on these holds. |
| 10:53 |
jeff |
you'll want to look at the circ_lib of the copy or the owning_lib of the volume/call_number |
| 10:53 |
jeff |
if I understand your original intent correctly. |
| 10:53 |
BAMkubasa |
mmorgan: I'm trying to figure out, for holds that are placed, how many were filled by other libraries in that same system, versus filled by libraries outside that system in the larger consortium |
| 10:53 |
jeff |
yeah. |
| 10:53 |
jeff |
you'll need to join asset.copy on action.hold_request.current_copy = asset.copy.id |
| 10:53 |
mmorgan |
Ok, so other libraries' *items* filling a library's hold |
| 10:54 |
BAMkubasa |
yeah, I'm trying to scrutinize transits within a system, compared to outside a system, based on where the holds are placed and where they end up |
| 10:55 |
jeff |
but you're going to want to determine if you care about things like floating copies, and things like a SYS1 item being returned to a SYS3 branch and transiting to a SYS2 branch to fill a hold there, vs the SYS1 item being shipped from SYS1, etc. |
| 10:55 |
BAMkubasa |
jeff: thanks, will do |
| 10:57 |
BAMkubasa |
jeff: at this stage of the game it doesn't need to be too subtle |
| 11:13 |
pastebot |
"BAMkubasa" at 64.57.241.14 pasted "Comparing the circ_lib of the copy to the pickup_lib of the hold" (9 lines) at http://paste.evergreen-ils.org/13748 |
| 11:13 |
* jeff |
idly wonders about the handful of ahr rows where current_copy is null but fulfillment_time is not null. |
| 11:13 |
BAMkubasa |
ok, this looks a bit more like I'd expect |
| 11:20 |
Bmagic |
It doesn't seem that Evergreen apache configs redirect EVERYTHING to ssl? I am considering RewriteRule (.*) https://mydomain.org$1 [R=301,L] inside of the :80 block |
| 11:21 |
berick |
Bmagic: I think we were waiting on bug 1507013 |
| 11:21 |
pinesol_green |
Launchpad bug 1507013 in Evergreen "Forcing HTTPS breaks some functionality in staff client" [Undecided,Won't fix] https://launchpad.net/bugs/1507013 |
| 11:22 |
Bmagic |
ah nice! |
| 11:26 |
|
foobarrel joined #evergreen |
| 11:28 |
Bmagic |
berick: only affects XUL? |
| 11:28 |
mmorgan |
jeff: Checkout fills related hold? |
| 11:29 |
berick |
Bmagic: as far as I know, yes. on my VMs I set nginx to redirect SSL and I've not had any problems in recent memory. |
| 11:30 |
berick |
of course, a VM is not a production site, where a lot more stuff happens |
| 11:30 |
berick |
i suspect mileage will vary |
| 11:46 |
miker |
BAMkubasa: if you really care about inter-system transits, you may want to just look at action.hold_transit_copy, and compare source and dest parents. that table is only "outbound" transits to fill holds |
| 11:46 |
yboston |
Hello folks, can someone create for me a EG mac client for 3.1 test server of version = master? (that is how this Ansible built server set the verison number) |
| 11:47 |
yboston |
I know that I can do some directory soft link trickery in xul/ to make my version be any one I want, but I need to track down my old notes |
| 11:48 |
berick |
yboston: something like: ln -s /openils/var/web/xul/master /openils/var/web/xul/rel_3_1 |
| 11:49 |
JBoyer |
cd xul |
| 11:49 |
JBoyer |
you're in a maze of twisty softlinks, all alike. |
| 11:49 |
yboston |
berick: first of all ¡Muchas gracias! for the Ansible scripts you shared with the world |
| 11:50 |
berick |
yboston: oh, i was going to ask... so you set the eg_git_branch to rel_3_1 and it created a XUL directory for 'master' ? |
| 11:50 |
yboston |
berick: now thanks for helping me refresh my memory. I last ran that trtick a long time ago |
| 11:50 |
yboston |
berick: yes, that is what I think happened, but I may need to confirm |
| 11:51 |
berick |
yboston: for future reference, see the eg_stamp_id variable in settings.yml |
| 11:51 |
* berick |
adds a few docs to clarify that |
| 11:52 |
yboston |
berick: can you also add that your scripts use BOTH Apache and nginx :) I wasted too many hours only restarting nginx becasue I somehow thought there would not be Apache in your set up. I blame myself |
| 11:53 |
berick |
ah, well, Apache is very much an Evergreen requirement, but yes, I'll add a note that nginx is not an apache replacement |
| 11:55 |
yboston |
berick: yes, I misread something you wrote in the repo, and thought that you managed to only use nginx. I need to start thinking less of you :) |
| 11:56 |
yboston |
berick: I really thoguht you had pulled off a miracle replacing apache |
| 11:56 |
berick |
my favorite Halmark card ;) |
| 11:56 |
berick |
(re: previous comment) |
| 11:57 |
berick |
yboston: that would be quite a feat |
| 12:00 |
* kmlussier |
waves to yboston |
| 12:00 |
yboston |
kmlussier: I still owe you that flan :( |
| 12:01 |
kmlussier |
yboston: We'll figure it out at some point. |
| 12:02 |
kmlussier |
yboston: We're probably going to schedule a local meetup during the next Bug Squashing week. Maybe we can entice you to join us! |
| 12:02 |
* kmlussier |
doesn't even remember now what she did to deserve a flan. |
| 12:04 |
yboston |
kmlussier: a couple of years ago you did me the favor of asking one of the confernece committess to book time for DIG meeting(?) |
| 12:08 |
berick |
yboston: i pushed some doc updates https://github.com/berick/evergreen-ansible-installer/commit/76a0c5aca8ba68f8fc22b2c6bfaa1826d6b2f423 |
| 12:23 |
yboston |
berick: yes that looks great! |
| 12:24 |
yboston |
berick: thanks again for building and sharign this!!! |
| 12:30 |
|
jihpringle joined #evergreen |
| 12:47 |
|
yboston joined #evergreen |
| 12:55 |
|
beanjammin joined #evergreen |
| 13:13 |
|
rlefaive joined #evergreen |
| 13:38 |
BAMkubasa |
miker: just seeing your message. thanks. will do |
| 14:46 |
|
sandbergja joined #evergreen |
| 15:11 |
pinesol_green |
[evergreen|Jane Sandberg] Docs: Adding 3.0.10 release notes - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=ab73eef> |
| 15:15 |
pinesol_green |
[evergreen|Jane Sandberg] Docs: starting 3.1.4 release notes - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=52a038f> |
| 15:15 |
pinesol_green |
[evergreen|Jane Sandberg] Docs: adding to 3.0.10 release notes - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=b67fbcf> |
| 15:29 |
pinesol_green |
[evergreen|Jane Sandberg] Docs: completing 3.1.4 release notes - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=6acb7f2> |
| 15:38 |
|
rlefaive joined #evergreen |
| 16:09 |
mmorgan |
Looking at the action.circulation table, is there a way to count actual checkins? That is, excluding rows that are renewals? |
| 16:12 |
jeff |
exclude rows where any of the renewal columns are true? desk_renewal, opac_renewal, phone_renewal... |
| 16:13 |
mmorgan |
jeff: the last circ in the chain that finally gets checked in will have one of those set to true :-( |
| 16:14 |
mmorgan |
I thought of using stop_fines != 'RENEW', but if the circ reaches MAXFINES, then gets renewed, the stop_fines doesn't change. |
| 16:14 |
jeff |
oh, you need to ... |
| 16:15 |
jeff |
yeah, that approach only works for limiting to checkouts-not-renewals. |
| 16:18 |
jihpringle |
mmorgan: we have a report that counts based on item status being changed by a selected staff account |
| 16:18 |
jihpringle |
and staff at the libraries that want to count this way on use that staff account for check in |
| 16:19 |
jihpringle |
items that weren't checked out but are scanned into check in do get included in the counts (since their status changes) |
| 16:23 |
mmorgan |
jihpringle: interesting. So that means all checkins they want counted have to happen at a workstation logged in as that staff account. |
| 16:24 |
jihpringle |
yes |
| 16:24 |
mmorgan |
We have many libraries that do checkin/checkout on the same workstation. |
| 16:24 |
jihpringle |
I'm not sure how many of libraries are actually doing it |
| 16:24 |
jeff |
mmorgan: you can use something like this: https://gist.github.com/jeff/dce623f349c74b714ee160e66803bdfe |
| 16:24 |
jeff |
mmorgan: using WHERE NOT EXISTS to eliminate any circs that have a "child" circ. |
| 16:25 |
jeff |
and you can spot check a bit with SELECT * FROM action.summarize_circ_chain(circ_id_here); |
| 16:25 |
jeff |
(perhaps not needed, but a useful function to keep handy sometimes) |
| 16:26 |
mmorgan |
jeff: Thanks, that's useful. We were coming around to checking that the id was not the parent_circ of any other row, but hoping there was a better way. |
| 16:26 |
jeff |
yeah, that's exactly what that query in the link above does. |
| 16:26 |
jeff |
and since there's an index on action.circulation.parent_circ, it's reasonably fast. |
| 16:27 |
mmorgan |
Ok, good to know. Thanks. |
| 16:27 |
mmorgan |
jeff++ |
| 16:35 |
jeff |
HAH |
| 16:35 |
jeff |
i was wondering about some VERY LONG AGO checkin times at some locations. |
| 16:35 |
jeff |
first thought was migrated data, but the other aspects of the rows ruled that out. |
| 16:36 |
mmorgan |
Extreme backdating? |
| 16:36 |
jeff |
second thing i noticed was that the years match a pattern found in our barcodes. |
| 16:36 |
jeff |
yes, backdating date entered by barcode scanner / rfid pad. :-) |
| 16:36 |
mmorgan |
Heh. |
| 16:38 |
mmorgan |
We once had a barcode get scanned into the number of copies field of Receipt options in bill payment. |
| 16:40 |
jeff |
wondering about the large number of circs with a checkin_staff of the usr from 2011 and before... |
| 16:40 |
jeff |
not sure if that's "before circ chains" or "before checkin_staff" |
| 16:40 |
jeff |
probably the former. looking. |
| 16:43 |
jeff |
yeah, looks like it. |
| 16:44 |
jeff |
so, you'll only be able to rely on that technique for circulations post-2.0 |
| 16:58 |
jeff |
(which depending on a number of things may not matter much for you) |
| 16:58 |
|
jvwoolf left #evergreen |
| 17:02 |
BAMkubasa |
I'm trying to figure out the best way to get .tt2 files to show up in Notepad++. Template Toolkit isn't a default "Language" offered, and I tried a few other languages to see if I could get the comments to show up clearly but haven't stumbled on something that makes the code display nicely like you can do with most other languages |
| 17:03 |
BAMkubasa |
I see "User Defined" is an option, but haven't messed with that yet. |
| 17:05 |
|
mmorgan left #evergreen |
| 17:05 |
BAMkubasa |
ah Google, I think I answered my own question: http://notepad-plus.sourceforge.net/commun/userDefinedLang/userDefineLang_TT.xml |
| 17:08 |
|
idjit left #evergreen |
| 17:08 |
|
idjit joined #evergreen |
| 18:32 |
pinesol_green |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 19:49 |
|
beanjammin joined #evergreen |
| 20:46 |
|
sandbergja joined #evergreen |
| 22:04 |
|
RBecker joined #evergreen |
