Time |
Nick |
Message |
01:43 |
|
RBecker joined #evergreen |
03:43 |
|
Mark__T joined #evergreen |
07:28 |
|
collum joined #evergreen |
07:36 |
|
Dyrcona joined #evergreen |
07:50 |
|
timlaptop joined #evergreen |
07:52 |
|
jboyer-isl joined #evergreen |
08:07 |
|
csharp joined #evergreen |
08:18 |
|
adbowling-isl joined #evergreen |
08:19 |
|
akilsdonk_ joined #evergreen |
08:21 |
|
jboyer_isl joined #evergreen |
08:32 |
|
RoganH joined #evergreen |
08:43 |
|
mmorgan1 joined #evergreen |
09:09 |
|
ericar joined #evergreen |
09:13 |
|
kmlussier joined #evergreen |
09:24 |
kmlussier |
Happy Monday all! |
09:25 |
mmorgan1 |
Happy Monday :) |
09:25 |
|
mmorgan1 left #evergreen |
09:26 |
|
mllewellyn joined #evergreen |
09:27 |
|
mmorgan joined #evergreen |
09:33 |
|
yboston joined #evergreen |
09:46 |
dbwells |
Dyrcona: Just got your chats, was on vacation Friday afternoon. Room reservations will be handled through me, as I have arranged to provide a rooming list to the hotel. I'll try to make some changes to the form, and send out a notice to make this more clear. Thanks for asking. |
09:47 |
|
kayals joined #evergreen |
09:47 |
Dyrcona |
dbwells: I've already made a room reservation. I spoke with Erica who said that the notes on the event were conflicting. |
09:48 |
Dyrcona |
dbwells: One said you'd provide a list of attendees and another said that attendees would pay for their own rooms, which she took to mean that we make our own reservations. |
09:51 |
dbwells |
Dyrcona: Well, that's fine. Both those things are true, but her conclusion was not. |
09:52 |
Dyrcona |
dbwells: Anyway, I should be all set and hope I have not messed things up. |
09:52 |
berick |
dbwells: curious if you have any thought on bug #1203753 (just opened) |
09:52 |
pinesol_green |
Launchpad bug 1203753 in Evergreen "AuthProxy support for barcode-based login" (affected: 1, heat: 6) [Undecided,New] https://launchpad.net/bugs/1203753 |
09:54 |
dbwells |
berick: Hadn't seen it yet, but now I notice that it was posted 44 seconds ago :) I'll check it out and reply on it. |
09:55 |
* berick |
thinks dbwells missed my (just opened) comment |
09:55 |
berick |
dbwells++ |
09:55 |
berick |
thanks for looking |
09:56 |
dbwells |
berick: yep, missed that. Got no time for parenthetical statements this morning! |
09:58 |
berick |
hah. running at peak efficiency! |
09:58 |
|
BigRig joined #evergreen |
10:05 |
|
gsams___ joined #evergreen |
10:05 |
|
CarrieC joined #evergreen |
10:06 |
dbwells |
Dyrcona: No worries, you didn't mess anything up. There's been an apparent uptick in Hack-a-way interest since the survey two months ago, so I am trying to keep a watchful eye on the reserved accommodations, that's all. |
10:06 |
|
gmcharlt joined #evergreen |
10:07 |
|
mrpeters joined #evergreen |
10:09 |
|
gsams___ joined #evergreen |
10:12 |
|
dboyle joined #evergreen |
10:31 |
|
mcooper joined #evergreen |
10:52 |
dbs |
calling 0812 |
10:52 |
paxed |
"Please leave a message after the beep!" |
10:53 |
jeff_ |
paxed++ |
10:53 |
jeff_ |
(i grinned) |
10:58 |
kmlussier |
dbs++ |
10:58 |
pinesol_green |
[evergreen|Dan Scott] Support linking to library info from copy display - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=256229c> |
10:58 |
pinesol_green |
[evergreen|Dan Scott] Wrap upgrade script for TPAC library name links - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=d0604db> |
11:01 |
|
dboyle joined #evergreen |
11:07 |
paxed |
dboyle: perhaps the 4 lines, starting from lib_url = .... could be a MACRO? |
11:08 |
paxed |
ergh. |
11:08 |
paxed |
sorry, that was got dbs |
11:08 |
paxed |
got? for. |
11:08 |
paxed |
i ca'nt has no typikn toady. |
11:10 |
senator |
i would like a typing toady |
11:10 |
senator |
could just drink coffee and dictate all day |
11:11 |
paxed |
i think you'll have to settle for a minion. |
11:15 |
dbs |
paxed: yes, it probably could be |
11:17 |
jeff |
metabib.record_attr.attrs->'pubdate' is certainly not unique in that it contains a lot of... interesting data. :P |
11:21 |
berick |
oops, thanks for the pullreq eeevil (1193473) |
11:21 |
eeevil |
:) |
11:21 |
eeevil |
berick: is there an LP bug related to sigterm-graceful-shutdown? |
11:22 |
jeff |
i need a "do your best to cast this to an int with fallback to null" -- does postgres have something along those lines, or am i thinking of this the wrong way? |
11:22 |
|
Pibbits joined #evergreen |
11:22 |
eeevil |
also, a propos: http://devopsreactions.tumblr.com/post/56132626265/crap-i-have-no-idea-which-branch-im-working-on |
11:22 |
eeevil |
jeff: in what situation? |
11:23 |
gmcharlt |
jeff: something like this, perhaps? http://git.esilibrary.com/?p=migration-tools.git;a=blob;f=sql/base/base.sql;h=751ce72fdca2634b431de6cd1c0d251f3f4eaf4f;hb=HEAD#l630 |
11:23 |
berick |
eeevil: not yet. still need to do the C bits. i'll open a ticket, though |
11:24 |
gmcharlt |
eeevil++ |
11:28 |
jeff |
gmcharlt: exactly like that -- thanks! |
11:29 |
jeff |
eeevil: situation is "want to exclude records from a select where one of pubdate, date1, or date2 is >= 2013 |
11:29 |
jeff |
special snowflake bib/holding export script |
11:29 |
eeevil |
jeff: you have something against time travelers? |
11:30 |
gmcharlt |
jeff: regex_matches may be better in that case, though, e.g., to allow "c2012" |
11:30 |
|
_zerick_ joined #evergreen |
11:30 |
gmcharlt |
eeevil: no service for them unless they pay current library taxes, not just future ones |
11:30 |
|
zerick joined #evergreen |
11:32 |
eeevil |
:) |
11:37 |
jeff |
gmcharlt: thankfully, evergreen already has me covered in terms of c2013 and friends in the 260$c -- by the time it gets to mra.attrs, pubdate is never longer than 4 characters. |
11:37 |
eeevil |
interestingly, there's an index normalizer to do most of what you want: Open-ILS/src/sql/Pg/002.schema.config.sql:655, integer_or_null(TEXT) returns TEXT ... mat be faster since it's optimizable |
11:37 |
jeff |
gmcharlt: and i could explicitly exclude 2013, 2014, and 2015, but then i'd miss 2016 :-) |
11:40 |
jeff |
eeevil: ah, perfect! |
11:40 |
jeff |
eeevil++ |
11:41 |
jeff |
gmcharlt++ |
11:42 |
Dyrcona |
À propos a migration from TLC: If you have a column called "TOTALINHOUSEUSES" you should also have "TOTALOUTHOUSEUSES" for symmetry's sake. |
11:44 |
phasefx |
wipe db |
11:47 |
csharp |
I've found a problem with circ counts and archived circs in the alternate copy display: http://pastebin.com/bVbmzVG5 |
11:48 |
csharp |
I'd appreciate a sanity check if an SQL person is around before I file a bug report with my proposed solution |
11:48 |
csharp |
I don't know enough about UNION vs UNION ALL to know the ramifications in EG |
11:48 |
berick |
both_jasons++ |
11:49 |
csharp |
@quote add < Dyrcona> À propos a migration from TLC: If you have a column called "TOTALINHOUSEUSES" you should also have "TOTALOUTHOUSEUSES" for symmetry's sake. |
11:49 |
pinesol_green |
csharp: The operation succeeded. Quote #62 added. |
11:49 |
tsbere |
csharp: I think you are right on that |
11:49 |
csharp |
tsbere: excellent - thank you |
11:53 |
|
jdouma joined #evergreen |
11:54 |
|
ElliotFriend joined #evergreen |
11:54 |
ElliotFriend |
I'm trying to get my cronjobs to run, using some of the examples here: http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/examples/crontab.example;h=1cd1db3d7d0658ce53757beafd23694103d37500;hb=HEAD |
11:55 |
ElliotFriend |
commands run fine if I perform them from shell, but not as a cronjob. Anyone ever run into that? |
11:55 |
ElliotFriend |
I'm running them from the opensrf crontab, btw |
11:55 |
paxed |
ElliotFriend: you cron shell is probably not bash, and it cannot execute ~/.bashrc due to the shell differences. |
11:55 |
paxed |
your* |
11:57 |
Dyrcona |
ElliotFriend: Sometimes even when your cron shell is bash, you need to specifically source your profile on the command in crontab. |
11:57 |
Dyrcona |
Here's an example from one of my crontabs: |
11:57 |
Dyrcona |
0 3 15 * * . /home/jason/.bash_profile && java -jar /home/jason/bin/NovelistUpdate.jar mvlc |
11:58 |
paxed |
(i just removed the ~/.bashrc sourcing altogether) |
11:58 |
ElliotFriend |
that makes total sense! do I change the cron shell in the crontab, or somewhere else? |
11:59 |
Dyrcona |
ElliotFriend: You can change the shell in crontab near the top. man 5 crontab should tell you all about it. |
11:59 |
Dyrcona |
paxed: Note that I am sourcing .bash_profile, the login script, and not .bashrc the environment script. I don't think crontab always get a login shell. |
12:00 |
paxed |
Dyrcona: right - i was just commenting what i did |
12:00 |
Dyrcona |
paxed: OK. Just trying to make sure there is no confusion. You never who will read the logs later. :) |
12:01 |
paxed |
whooops. humongous thungerstorm heading my way. i'd better shut down for a bit. |
12:01 |
Dyrcona |
ElliotFriend: Add this at the top of your crontab: SHELL=/bin/bash |
12:01 |
Dyrcona |
or wherever bash is on your system. |
12:03 |
ElliotFriend |
did that, and it sure works now! Thanks! |
12:03 |
|
acoomes joined #evergreen |
12:08 |
|
jihpringle joined #evergreen |
12:41 |
|
b_bonner joined #evergreen |
12:43 |
|
linuxpoet left #evergreen |
12:47 |
bshum |
@hate office printer |
12:47 |
pinesol_green |
bshum: The operation succeeded. bshum hates office printer. |
12:47 |
csharp |
PC LOAD LETTER!!? |
12:47 |
|
b_bonner joined #evergreen |
12:48 |
|
ldwhalen joined #evergreen |
12:48 |
* tsbere |
once changed a language string in a printer so that "FEED ME" came up instead of "PC LOAD LETTER" <_< |
12:48 |
csharp |
tsbere++ |
12:48 |
gsams___ |
tsbere++ |
12:48 |
bshum |
csharp: For some reason, my linux laptop never works right and prints garbage to all the office printers :( |
12:49 |
bshum |
Or periodically decides to do so. |
12:49 |
bshum |
But anyways....... |
12:49 |
Dyrcona |
bshum: PS vs PCL most likely. |
12:49 |
csharp |
bshum: hmm - I use the gutenprint drivers for our HP and Canon printers with no issue |
12:50 |
Dyrcona |
bshum: Does the garbage start something like %!PS on the first page? |
12:50 |
bshum |
Dyrcona: It's actually mostly blank pages it spit back to me. |
12:50 |
|
b_bonner_ joined #evergreen |
12:51 |
Dyrcona |
Right. That's a typical symptom of postscript going to a non-postscript printer. If you see what I mentioned above on the first page, that clinches it. |
12:53 |
Dyrcona |
I have fun with the Konica Minolta if no one else has used it or I don't go wake it up, it refuses to print my jobs, although it accepts them. |
13:07 |
|
stevenyvr2 joined #evergreen |
13:07 |
* csharp |
*hates* our Konica Minolta printer |
13:12 |
bshum |
Hmm |
13:12 |
bshum |
Dyrcona: Isn't https://bugs.launchpad.net/evergreen/+bug/1203822 a result of settings? |
13:12 |
pinesol_green |
Launchpad bug 1203822 in Evergreen "eg2.4 paying lost bills does not close circ" (affected: 1, heat: 6) [Undecided,New] |
13:13 |
* bshum |
vaguely recalls library settings to change this behavior |
13:13 |
Dyrcona |
bshum: Yes, most likely the settings. |
13:14 |
bshum |
Ah, setting, right. "Close transaction when lost balance equals zero" |
13:14 |
Dyrcona |
There are, IIRC, several related bugs, though, most of them fixed. |
13:14 |
bshum |
Or "Leave transaction open when lost balance equals zero" |
13:20 |
Dyrcona |
Right, but the circ may stay open if the copy has not been checked in, or maybe that is what the setting was supposed to resolve? |
13:21 |
Dyrcona |
Been too long since I looked at it last. |
13:27 |
bshum |
Yeah I can't remember either. |
13:27 |
bshum |
I would expect it to stay open till it was checked in. |
13:27 |
bshum |
I guess I could test it. Maybe after I get lunch. |
14:02 |
ElliotFriend |
Is it possible in Evergreen to make the "max_number_of_holds" equal to "max_number_checked_out - number_checked_out"? |
14:03 |
Dyrcona |
ElliotFriend: Not without programming, if I understand your question correctly. |
14:03 |
ElliotFriend |
Dyrcona: I suspected that would be the case. I also suspect you understood the question :) |
14:04 |
ElliotFriend |
basically, my librarian wants a checked out limit of (we'll say) 10. If a patron has 6 checked out already, they could place holds on 4 books. |
14:05 |
ElliotFriend |
I'd imagine it would be much simpler to set them to different/non-dependent numbers |
14:07 |
Dyrcona |
ElliotFriend: Right. The way it is done now is they are set as independent numbers. It would take programming to do the calculations on the fly. |
14:07 |
ElliotFriend |
Dyrcona: That's what I figured. Thanks for the confirmation! |
14:08 |
Dyrcona |
yw |
14:12 |
bshum |
So tsbere tells me I screwed up bug 1079041 and all the stuff was loaded as "au" instead of "aua" and therefore not working. |
14:12 |
pinesol_green |
Launchpad bug 1079041 in Evergreen ""state" field in patron registration is always required" (affected: 2, heat: 10) [Medium,Fix committed] https://launchpad.net/bugs/1079041 |
14:12 |
bshum |
The question is, do we fix the upgrade script directly? Or should we apply a new upgrade script to replace the bad entries. |
14:15 |
bshum |
Personally I would have done a new upgrade script to fix the issue I unfortunately introduced. But then that got me wondering about the final upgrade script when we construct the path from 2.4 to 2.5. |
14:15 |
tsbere |
We also have to update register.js, but that is easy ;) |
14:15 |
bshum |
tsbere++ for telling me about my screwups :( |
14:16 |
tsbere |
change the original update script, then add a new one that does the re-name. If the entries aren't already there the new one won't matter? |
14:16 |
b_bonner |
G'day folks. I have a question about an Action Trigger template. I've been asked to include the item barcode on the receipt printed when a user chooses to reprint their receipt from the OPAC account page. Can't seem to retrieve it. Relevant bits of action trigger here: |
14:16 |
pastebot |
"b_bonner" at 204.193.129.146 pasted "Action Trigger - payment receipt printing" (14 lines) at http://paste.evergreen-ils.org/11 |
14:19 |
eeevil |
bshum: IMO, a new script only ... the only time I personally feel OK about modifying an update script is when it's the highest numbered ... this is also why we need to find some community tuits to implement the supersedes/deprecates stuff ... that will obviate version upgrade scripts and make these situations both simple and self-documenting |
14:20 |
tsbere |
b_bonner: barcode isn't a bib_basics thing. You just want xact.circulation.target_copy.barcode, I believe...unless target_copy is an id. Then you need to tell it to flesh that out to get the barcode field, and target_copy in the bib_basics will need .id added to it, I think... |
14:21 |
bshum |
eeevil: Sounds reasonable. Thanks! |
14:30 |
b_bonner |
tsbere: whoops. didn't mean to include the bib_basics barcode in that paste, that was a remnant of me trying different things. I've tried various combinations of xact.circulation.target_copy.barcode with no results. |
14:31 |
tsbere |
b_bonner: Then target_copy is likely just an ID right now. In the environment, I think it is, you need to change (or add) one of the circulation entries to include target_copy, then change any bare target_copy entries in the template to include .id because that is what they likely expect. |
14:31 |
tsbere |
then .barcode should work |
14:32 |
|
linuxpoet joined #evergreen |
14:32 |
paxed |
is there a way to get the current locale in canonical (xx-YY) format in opac? |
14:32 |
paxed |
ctx.locale is xx_yy |
14:33 |
paxed |
... i guess i could mangle it in the tt2. |
14:38 |
Phenol |
With a fresh DB. Why can I not remove Org units from staff client? |
14:39 |
tsbere |
Addresses, I assume. <_< |
14:40 |
Phenol |
can they be removed (addresses) from Staff client? |
14:40 |
* tsbere |
has never tried |
14:45 |
Phenol |
This is kind of stupid that with a fresh DB you can't delete Org units because of linked Address and can't removed the address from the DB because they are linked to the Org Units |
14:47 |
tsbere |
cascade delete! ;) |
14:48 |
Phenol |
isn't that going to cause more harm |
14:48 |
Phenol |
from all the other tables |
14:49 |
tsbere |
what other tables? Don't delete the consortia entry and you should be fine, I think... |
14:50 |
Phenol |
I can't delete anything.. other than a Cascade |
14:50 |
Phenol |
but thats going to wipe all tables that ref org_unit? correct? |
14:51 |
Phenol |
http://docs.evergreen-ils.org/2.3/_organizational_units.html#_remove_or_edit_default_organizational_units |
14:51 |
Phenol |
thats a little misleading considering it tells you about removing them throught the staff client but then you can't |
14:51 |
tsbere |
Phenol: Start a transaction, delete from both tables? I haven't had to do this for a while....if ever. |
14:52 |
Phenol |
I can't delete from the tables without deleting from all tables that ref org_unit... so you left the default Org setup in place? |
14:53 |
tsbere |
No, I didn't set our org units up. Ask Dyrcona how he did it for us. ;) |
14:54 |
b_bonner |
tsbere++ for helping with my action trigger confusion. |
14:54 |
mcooper |
Phenol: set the org addresses to null if that's a problem |
14:56 |
Dyrcona |
Phenol: http://evergreen-ils.org/dokuwiki/doku.php?id=scratchpad:setup |
15:00 |
Phenol |
Thanks |
16:00 |
dbwells |
berick: regarding the new AuthProxy code, I think the idea seems fine and an intial review of the code looks good as well. I'll try to find some time to actually test it and get it pushed. Thanks for adding it! |
16:00 |
berick |
dbwells++ |
16:00 |
berick |
thanks |
16:08 |
|
SimonHM joined #evergreen |
16:08 |
|
SimonHM joined #evergreen |
16:08 |
ElliotFriend |
All of the items we checkout to patrons (currently) have a due-time of 11:59 PM. Is there a setting to change that to 1 minute prior to the library's closing time on the due-date? |
16:08 |
paxed |
i don't think the time is shown on the receipts ...? |
16:09 |
ElliotFriend |
it is on the default template |
16:09 |
paxed |
huh |
16:09 |
ElliotFriend |
even if it weren't wouldn't eg calculate late fines as though the due-time were 11:59 pm? |
16:09 |
tsbere |
ElliotFriend: I believe that is only for durations that are multiples of 1 day |
16:10 |
tsbere |
So if your durations are, say, hourly it won't tweak them that way |
16:11 |
Dyrcona |
ElliotFriend: I would not be surprised if changing the due time messed with fine calculation in some subtle and unexpected way. |
16:12 |
ElliotFriend |
good point. easiest solution for us would probably be just to remove it from the receipt :) |
16:15 |
ElliotFriend |
can i view a user's circulation history from within the staff client (without them having opted in through TPAC)? |
16:15 |
* paxed |
slays a 3 year old bug. |
16:17 |
phasefx |
ElliotFriend: you can run a report, but you can't view the circ history as if you were the patron with the same UI |
16:19 |
ElliotFriend |
phasefx: cool, thanks! |
16:22 |
ElliotFriend |
for reporting: is it general practice to run clark-kent.pl continually, or to turn it off and on when needed? |
16:22 |
Dyrcona |
ElliotFriend: continually for larger sites. I have no idea what single instances would do, but I imagine the same. |
16:23 |
Dyrcona |
ElliotFriend: Are you setting up a consortium, a single system with branches, or a single library? |
16:23 |
ElliotFriend |
Dyrcona: single library. |
16:24 |
Dyrcona |
ElliotFriend: Thanks. I thought so, but wanted to make sure. |
16:24 |
Dyrcona |
I would probably run clark-kent.pl all the time even in that case. |
16:24 |
ElliotFriend |
I was thinking that's what I'd do. |
16:24 |
ElliotFriend |
i've got a consortium & system set up, though. mostly because that's how the structure was setup as default |
16:25 |
ElliotFriend |
though everything really is taking place at the branch level |
16:25 |
Dyrcona |
ElliotFriend: Yes, that keeps things simple. I've run into trouble when messing wit the various levels of the hierarchy. |
16:26 |
Dyrcona |
It is probably better now than it was 3 years ago in that respect. |
16:26 |
ElliotFriend |
i was really excited when I saw that TPAC allowed a custom org unit tree! |
16:58 |
|
acoomes_ joined #evergreen |
17:05 |
|
mmorgan left #evergreen |
17:52 |
|
kayals joined #evergreen |
18:03 |
|
CarrieC left #evergreen |
18:06 |
|
kayals joined #evergreen |
18:34 |
|
sseng_ joined #evergreen |
18:36 |
|
fparks_ joined #evergreen |
18:37 |
|
fparks joined #evergreen |
18:52 |
|
BigRig_ joined #evergreen |
18:56 |
|
dboyle_ joined #evergreen |
19:03 |
|
sseng joined #evergreen |
19:18 |
|
dboyle joined #evergreen |
19:48 |
|
gsams___ left #evergreen |
22:31 |
|
b_bonner_ joined #evergreen |
22:41 |
|
stevenyvr2 joined #evergreen |
22:41 |
|
stevenyvr2 left #evergreen |
23:31 |
|
stevenyvr2 joined #evergreen |
23:31 |
|
stevenyvr2 left #evergreen |