Evergreen ILS Website

IRC log for #evergreen, 2016-12-15

| 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
01:56 Stompro joined #evergreen
02:12 StomproJ joined #evergreen
02:45 Stompro joined #evergreen
02:53 StomproJ joined #evergreen
04:56 Stompro joined #evergreen
05:00 pinesol_green News from qatests: Test Success <http://testing.evergreen-ils.org/~live>
06:40 rlefaive joined #evergreen
07:06 StomproJ joined #evergreen
07:07 sard_ joined #evergreen
07:12 rjackson_isl joined #evergreen
07:15 agoben joined #evergreen
07:42 remingtron joined #evergreen
07:58 kmlussier joined #evergreen
08:16 bshum @weather
08:16 pinesol_green bshum: Danbury, CT :: Partly Cloudy :: 23F/-5C | Wind Chill: 10F/-12C | Thursday: Partly cloudy and windy. High 24F. Winds WNW at 20 to 30 mph. Winds could occasionally gust over 40 mph. Thursday Night: Some passing clouds. Low 6F. Winds WNW at 10 to 20 mph.
08:22 bshum "And don't forget your booties, cause it's cooooold out there!"
08:35 Dyrcona joined #evergreen
08:39 mmorgan joined #evergreen
08:39 kmlussier @weather
08:39 pinesol_green kmlussier: Seekonk, MA :: Clear :: 28F/-2C | Wind Chill: 16F/-9C | Thursday: Windy with a mix of clouds and sun. High 28F. Winds WNW at 25 to 35 mph. Winds could occasionally gust over 40 mph. Thursday Night: A few clouds. Low near 5F. Winds WNW at 15 to 25 mph. Winds could occasionally gust over 40 mph.
08:40 Dyrcona @weather
08:40 pinesol_green Dyrcona: Methuen, MA :: Clear :: 25F/-4C | Wind Chill: 13F/-10C | Thursday: Windy with a mix of clouds and sun. High near 25F. Winds W at 25 to 35 mph. Winds could occasionally gust over 40 mph. Thursday Night: Partly cloudy skies. Low 2F. Winds WNW at 15 to 25 mph. Winds could occasionally gust over 40 mph.
08:41 kmlussier @weather 01060
08:41 pinesol_green kmlussier: Northampton, MA :: Partly Cloudy :: 20F/-6C | Wind Chill: 5F/-15C | Thursday: Partly cloudy and windy. High 22F. Winds WNW at 20 to 30 mph. Winds could occasionally gust over 40 mph. Thursday Night: Partly cloudy. Low 3F. Winds WNW at 15 to 25 mph. Winds could occasionally gust over 40 mph.
08:41 kmlussier That's where I'll be heading in a few hours.
08:41 kmlussier I think I'll bring an extra cup of hot coffee with me.
08:42 Dyrcona Sounds like a plan.
08:42 * mmorgan suggests wool socks.
08:44 kmlussier All of my wool socks have holes in them. :(
08:45 mmorgan Maybe 2 pairs? One pair will cover the holes in the other?
08:47 kmlussier mmorgan: You're very resourceful.
08:47 * mmorgan has plenty of wool yarn, but is not sure pre-socks will help ;-)
08:47 mdriscoll joined #evergreen
09:07 Dyrcona I wonder if anyone has considered using the 856$w to hold an identifier for the vendor and vendor's record id.
09:08 Dyrcona I'm thinking that this could make managing URLs that get scattered over records from different sources a bit easier.
09:22 Dyrcona So, turns out that the speed increase I got from a query change last week was likely due to a bug.
09:23 Dyrcona I had "=" where I needed "like."
09:23 Dyrcona Guess the like is what was making the query be slow.
09:24 Dyrcona I think I'm going to have to split this into two queries and put the results together in someway in the perl.
09:24 rlefaive_ joined #evergreen
09:25 yboston joined #evergreen
09:26 Dyrcona A rough guess is it's taking 15 seconds to process a record on my test db system.
09:44 miker Dyrcona: is your slow query stock, or a local thing?
09:44 Dyrcona miker: It's a local thing.
09:44 Dyrcona tsbere gave me a suggestion of how I might use a tsquery to speed it up.
09:45 Dyrcona I did get tsquery working, but when I had nothing for a certain search string, the query seemed to just fail, rather than return a null.
09:46 miker in that case, you might want to look into the pg_trgm. adding that extension and then using it for indexing can speed LIKE queries: https://www.postgresql.org/​docs/9.2/static/pgtrgm.html
09:52 Dyrcona miker thanks. I'm going to try this: and case when length($4) then index_vector @@ $4 else false end
09:52 Dyrcona Assuming length() is the right function...
09:52 * Dyrcona looks it up.
09:56 Dyrcona yeah. length() is what I want.
09:57 Newziky joined #evergreen
09:57 Newziky left #evergreen
10:10 Dyrcona OK... "and case when length($4) > 0 then index_vector @@ $4 else false end" :)
10:12 tsbere heh
10:12 Dyrcona hah. One more adjustment needed. Pg apparently couldn't figure out that $4 was a tsquery string in that context.
10:13 Dyrcona It could when I just "and index_vector @@ $4"
10:13 collum joined #evergreen
10:13 tsbere Yea, that would be a problem as the length($4) would make it think text, not tsquery
10:13 Dyrcona But now it wants ::tsquery after $4.
10:13 tsbere At least on the second one, right?
10:14 Dyrcona Right.
10:14 Dyrcona I started this about 3 minutes ago, we'll see how long it takes to process 100 or so records.
10:14 miker Dyrcona: no chance to just skip the query if whatever's in $4 is empty, rather than using a case?
10:14 Dyrcona miker: I don't want to do that, 'cause it complicates the program logic.
10:16 Dyrcona right now I have "with q1 as (...), q2 as (...) select ... from this, that, q1, q2 where ..... and (q1 is not null or q2 is not null)"
10:18 Dyrcona I want where either or both match and I calculate a score based on what comes back.
10:39 rlefaive joined #evergreen
10:45 bos20k joined #evergreen
10:58 Christineb joined #evergreen
11:02 pastebot "Stompro" at 64.57.241.14 pasted "Add notification to forced holds where possible" (48 lines) at http://paste.evergreen-ils.org/37
11:02 Stompro Could someone help me spot the syntax error in this query?
11:03 Stompro I just get "ERROR:  syntax error at or near "where"
11:03 Stompro "
11:04 tsbere Stompro: You have no "on whatever" clause on the actor.usr join
11:04 rlefaive joined #evergreen
11:05 tsbere Stompro: Also you have issues elsewhere, but I bet that is your first major issue ;)
11:05 Stompro Ah, so if I remove the "join" in front of actor.usr, it will use the condition in the where... I got an error with that on clause, it said it couldn't use the ahr in that on clause.
11:05 tsbere Stompro: "on true" is a perfectly valid "on" clause ;)
11:06 afterl joined #evergreen
11:07 Dyrcona Stompro: ahr is not in the from/join part of the query.
11:07 Stompro tsbere, thanks, that got me past that.
11:07 Stompro On to missmatched types in the case statements.
11:08 Dyrcona Stompro: Also, when I join like that I tend to do put the "where" condition for the join in the join clause.
11:08 Dyrcona left join actor.usr_setting aus on on au.id = aus.usr and aus.name='opac.hold_notify'
11:09 Dyrcona Otherwise, I'd put it all in the where clause. ---Just a point of style. :)
11:09 tsbere Dyrcona: Regarding the ahr not in the from/join part of the query, that is perfectly fine with update statements. If annoying in that all the joins to the table being updated *have* to be in the where clause.
11:09 Dyrcona Oh, sorry missed it being an update statement, even. :)
11:09 tsbere Or maybe that is what you meant. I dunno, I keep getting interrupted.
11:10 Dyrcona My eyes when straight for the join clauses. :)
11:10 Stompro Ah, I was joining off of ahr.usr, which cannot be referenced in the from clause because it is the update table,  it makes sense to only do that once, thanks.
11:11 Dyrcona But yeah, I'd have probably move the ahr.usr = au.id and other lines into the join claues, too.
11:12 Stompro Dyrcona, I don't think you can, I get an error if I try to reference ahr in the from expression.
11:14 Dyrcona Hmm... That is probably the case. Updates and deletes are weird like that.
11:14 Dyrcona Anyway, I've got my own query problems to sort out. :)
11:14 Stompro tsbere++ Dyrcona++ thanks for taking a look
11:14 Dyrcona I *should* be working on setting up new servers for production, but I don't want it to take a month to load these records.
11:16 jvwoolf joined #evergreen
11:18 bmills joined #evergreen
11:26 Stompro It now works, thanks again tsbere and Dyrcona... I used a trim to remove the quotes from the sms carrier user setting so it would cast to an int, do you think that is a reasonable solution?
11:26 pastebot "Stompro" at 64.57.241.14 pasted "Working - Add notification to forced holds where possible" (46 lines) at http://paste.evergreen-ils.org/38
11:26 Dyrcona If you want it to be an int, yes.
11:47 brahmina joined #evergreen
12:01 rlefaive joined #evergreen
12:02 mmorgan joined #evergreen
12:13 jvwoolf joined #evergreen
12:56 ohiojoe joined #evergreen
12:59 collum joined #evergreen
13:00 collum joined #evergreen
13:18 Newziky joined #evergreen
13:18 Newziky left #evergreen
13:18 rfrasur joined #evergreen
13:43 rgagnon joined #evergreen
13:52 terran joined #evergreen
13:56 graced EOB meeting in five minutes
13:57 rlefaive joined #evergreen
13:58 tspindler joined #evergreen
14:01 graced #startmeeting Evergreen Oversight Board Meeting, December 15, 2016
14:01 pinesol_green Meeting started Thu Dec 15 14:01:47 2016 US/Eastern.  The chair is graced. Information about MeetBot at http://wiki.debian.org/MeetBot.
14:01 pinesol_green Useful Commands: #action #agreed #help #info #idea #link #topic #startvote.
14:01 pinesol_green The meeting name has been set to 'evergreen_oversight_board_​meeting__december_15__2016'
14:01 sherbertbc joined #evergreen
14:01 graced #link https://wiki.evergreen-ils.org/doku.​php?id=governance:minutes:2016-11-17  Agenda
14:02 graced #link  http://wiki.evergreen-ils.org/dok​u.php?id=community:using-meetbot  Meetbot command cheatsheet
14:02 graced #topic Introductions
14:02 graced Oversight Board members, please introduce yourself with #info
14:02 graced #info graced is Grace Dunbar, Equinox
14:02 afterl #info afterl is Amy Terlaga, Bibliomation
14:02 collum #info collum is Garry Collum, Kenton County Public Library
14:02 sherbertbc #info sherbertbc is Sharon Herbert, Sitka/BCLC
14:02 tspindler #info tspindler is Tim Spindler, C/W MARS
14:03 rgagnon #info rgagnon is Ron Gagnon, North Of Boston Library Exchange (NOBLE)
14:03 rfrasur #info rfrasur is Ruth Frasur, Hagerstown Library, Evergreen Indiana
14:03 terran #info terran is Terran McCanna, PINES
14:04 graced We have a quorum.
14:04 graced Anyone that comes in late, please introduce yourself
14:04 graced #topic Approve Minutes from last meeting
14:04 graced The minutes have been up for review since our last meeting.
14:04 graced #link http://evergreen-ils.org/meetings/evergr​een/2016/evergreen.2016-11-17-14.01.html
14:04 graced Are there any corrections?
14:05 graced Hearing no requests for corrections...
14:05 graced #agreed The EOB accepted the minutes from the November 17 meeting
14:05 graced #topic Old Business and Action items
14:05 graced #info  graced to request SFC reimbursement for Amy's Hackaway EOB meeting travel
14:06 graced #info I did this.
14:06 graced afterl: reimbursement received yet?
14:06 afterl graced:  not that I am aware of
14:06 graced let me know if you don't get it in a few weeks and I'll follow up
14:07 afterl thank you
14:07 graced np
14:07 graced #info afterl to Follow up with the SFC on the NC check issue
14:07 graced afterl: how's that coming?
14:07 afterl graced:  last I heard, it was imminent
14:07 afterl let me check the final deadline they gave
14:08 miker #info miker is Mike Rylander, Equinox
14:08 graced Well, skipping ahead and perusing the financial report, it's clear it hasn't hit the ledger yet
14:09 graced curious to hear their "final deadline" though
14:09 afterl graced:  supposed to have been received by 12-12
14:09 graced well.
14:09 afterl three days ago
14:09 afterl graced: so not received?
14:09 graced I'll have gmchalrt pull another update next week and if it's not there will you follow up again then?
14:09 afterl of course
14:10 graced #action graced to have gmcharlt pull financial update next week and look for NC pmt credit
14:10 maryj joined #evergreen
14:10 graced #info graced to put forth (via email) final Officer election wording for voting.
14:10 graced #link http://list.evergreen-ils.org/pipermail/eg​-oversight-board/2016-December/001636.html
14:11 graced Any further discussion or should we move to vote?
14:11 rfrasur I move to vote
14:11 miker I move we...
14:11 rfrasur miker, it's all you, and then I'll second.
14:11 graced is there a second?
14:11 tspindler second
14:11 miker I sec...
14:11 miker bah! :)
14:12 rfrasur hah!
14:12 tspindler too slow
14:12 graced voting it is then, one sec
14:12 graced #startvote Shall the Board agree to amend the Rules of Governance section 2.4 (Term) and add section 2.4.1 (Elections) with the specific changes set forth in the above referenced email? Yes, No, Abstain
14:12 pinesol_green Begin voting on: Shall the Board agree to amend the Rules of Governance section 2.4 (Term) and add section 2.4.1 (Elections) with the specific changes set forth in the above referenced email? Valid vote options are Yes, No, Abstain.
14:12 pinesol_green Vote using '#vote OPTION'. Only your last vote counts.
14:12 graced #vote yes
14:12 miker #vote yes
14:12 afterl #vote YES
14:12 tspindler #vote yes
14:12 sherbertbc #vote yes
14:12 rfrasur #vote yes
14:12 collum #vote yes
14:13 rgagnon #vote yes
14:13 terran #vote yes
14:13 graced #endvote
14:13 pinesol_green Voted on "Shall the Board agree to amend the Rules of Governance section 2.4 (Term) and add section 2.4.1 (Elections) with the specific changes set forth in the above referenced email?" Results are
14:13 pinesol_green Yes (9): afterl, tspindler, miker, rgagnon, graced, collum, rfrasur, terran, sherbertbc
14:13 graced #agreed The Board agrees to amend the Rules of Governance section 2.4 and include section 2.4.1.
14:13 graced Do I have a volunteer to update the docs in the git repo and web site?
14:13 miker I can do that again
14:14 graced #action miker volunteered to update the git repo and web site with the 2.4 and 2.4.1 changes.
14:14 graced miker++
14:14 afterl miker++
14:14 graced thank you
14:14 graced Are there any other outstanding action items?
14:15 graced okay, moving on
14:15 graced #topic Other Old Business
14:15 graced #info At the Hackaway we created a Task Force to look at our options and assess our needs as an organization/project.  tspindler is there an update from the Task Force?
14:15 tspindler yes, we met a week or two ago
14:16 tspindler discussed some of the ongoing issues such as customer services and responsiveness to our needs and also what we need
14:17 tspindler rogan and sharon are looking into alternative organizations and I am looking at costs and issues for setting up our own non-profit
14:17 tspindler the next meeting is January 11 when everyone is to report back with findings, Galen is helping rogan and sharon to pull together info
14:18 tspindler any questions?
14:18 graced #info task force met and discussed how well our current needs are being met and are looking into alternatives - next meeting is 1/11
14:18 terran tspindler++
14:18 graced (recapping for meetbot sorry)
14:18 tspindler np
14:19 graced tspindler++
14:19 graced if there are no questions we'll move on
14:19 rfrasur tspindler++
14:20 graced #info We have two other proposals for wording changes/additions for the ROG (officer limitations and special elections).
14:20 graced #link http://list.evergreen-ils.org/pipermail/eg​-oversight-board/2016-December/001632.html
14:20 graced I think the concepts have general approval… do we have a volunteer for drafting the final wording revisions?
14:20 rgagnon I can try that.
14:21 graced #action rgagnon volunteered to draft the wording for the officer limitations and special elections.
14:21 afterl rgagnon++
14:21 graced rgagnon++ thank you!
14:21 tspindler rgagnon++
14:21 rfrasur rgagnon++
14:21 graced okay, any other old business?
14:22 graced #topic Financial Update
14:22 graced #link https://wiki.evergreen-ils.org/doku.php?i​d=governance:financials:update_2016_12_15
14:22 graced #info Our balance with Conservancy is $29,248.61
14:23 graced No major changes and, as noted, we're still not seeing the NC check that's outstanding from the April conference
14:23 graced Questions or comments?
14:23 afterl Okay, I know what to do
14:24 rfrasur I don't want to spend time on this, but just saying...it's ridiculous that SFC hasn't resolved this yet.
14:24 maryj_ joined #evergreen
14:24 graced It certainly dims the confidence a bit
14:25 graced okay moving on
14:25 graced #topic Committee Reports
14:25 graced #topic Conference Committee
14:25 graced #info Conference Registration is live.  The web site is 95% complete.  Hotel registration is live.
14:25 graced #info Keynote and pre-conference announcements should come next week.  We have two registrations and three sponsorships.
14:25 graced Things are humming along.
14:26 graced Kudos to the conference committee members for their hard work!
14:26 graced Questions?
14:26 rfrasur graced++ joe++ et_al++
14:27 rgagnon ditto
14:27 graced Oh!  There will likely be a revised budget to vote on next week so watch your email. :)
14:27 graced #topic Outreach Committee Business
14:27 graced #info The chair indicated that there was no update this month.
14:28 graced #topic Release Manager's Report
14:28 graced kmlussier isn't present but she emailed her report
14:28 graced #info The 2.12 schedule is set  #link http://markmail.org/message/4jmxknraen6k7nqr
14:28 graced #info We have a 2.12 roadmap at #link https://wiki.evergreen-ils.org/doku​.php?id=faqs:evergreen_roadmap:2.12
14:28 graced If you have questions you're out of luck.   ;-)
14:28 * rfrasur has no questions.
14:28 gmcharlt rfrasur is lucky
14:29 rfrasur oh, it's only because I'm too ignorant and distracted to know what to ask.
14:29 graced And there's no one here to give you answers so it all works out
14:29 rfrasur bonus?
14:29 graced Anything else before we move to New Business?
14:30 graced #topic New Business
14:30 graced Is there any new business?
14:30 * graced had nothing on the agenda
14:31 graced we have time enough for ideas/thoughts/discussions/questions if anyone has an itch to scratch
14:31 rfrasur already itched mine.
14:32 sherbertbc egg nog - love or hate? - discuss
14:32 afterl love
14:32 terran homemade egg nog = love, storebought = hate
14:32 graced <3 eggnog if homemade
14:32 graced terran++
14:32 tspindler comme ci comme ca
14:32 rfrasur I do love eggnog...homemade
14:32 afterl love all forms
14:32 rfrasur terran++
14:33 rfrasur now I want rum
14:33 rgagnon love the nog but not the lactose
14:33 afterl love all forms of that too
14:33 graced Speaking of rum, I do want to mention we should put together the EOB election task force next month
14:33 terran I once got to see someone spit-take eggnog. I swear it went in slow motion.
14:33 * rfrasur laughs
14:34 rfrasur graced, so we should and shall
14:34 rfrasur terran - I don't even know
14:34 graced So, we'll need some volunteers to take on the emailing / prodding / set up and carryout of elections
14:34 afterl okay
14:34 rfrasur if you're taking volunteers before taking volunteers, I'll volunteer to volunteer.
14:34 graced Super!
14:35 afterl that was my okay
14:35 afterl volunteer to volunteer
14:35 rfrasur hehe
14:35 rfrasur after the first of the year, please and thank you
14:35 graced #action rfrasur volunteers to asssit with EOB election process on task force
14:35 graced *assist
14:35 graced well, on that typo should we call it done?
14:36 rfrasur graced....I'm great at asssiting, too
14:36 rfrasur (I think we should)
14:36 graced Okay, thank you everyone, appreciate all your hard work and "see" you next year!
14:36 afterl bye!
14:36 graced #endmeeting
14:36 tspindler graced++
14:36 pinesol_green Meeting ended Thu Dec 15 14:36:57 2016 US/Eastern.  Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4)
14:36 pinesol_green Minutes:        http://evergreen-ils.org/meetings/evergr​een/2016/evergreen.2016-12-15-14.01.html
14:36 pinesol_green Minutes (text): http://evergreen-ils.org/meetings/evergr​een/2016/evergreen.2016-12-15-14.01.txt
14:36 pinesol_green Log:            http://evergreen-ils.org/meetings/evergree​n/2016/evergreen.2016-12-15-14.01.log.html
14:36 rfrasur graced++ thank you
14:37 collum graced++
14:37 graced you guys++
14:37 miker graced++
14:37 rgagnon Happy New Year!
14:37 terran Cheers!
14:37 tspindler Happy New year!
14:37 tspindler left #evergreen
15:04 mmorgan1 joined #evergreen
15:04 Dyrcona /me wishes he could copy and past a barcode from a screenshot.
15:05 tsbere Dyrcona: I have played with "Point my phone with Google Goggles running at my computer screen showing the screenshot" before. Was still faster and easier to type the thing.
15:05 Dyrcona Yeah. Faster to type it than to save it and ocr it, too. :)
15:11 abowling joined #evergreen
15:39 jvwoolf joined #evergreen
15:41 mmorgan joined #evergreen
15:58 bmills joined #evergreen
16:46 jvwoolf left #evergreen
16:58 afterl left #evergreen
17:00 pinesol_green News from qatests: Test Failure <http://testing.evergreen-ils.org/~live>
17:02 mmorgan left #evergreen
17:34 bshum Failure?  NOOOOO
17:35 bshum Jabber problem in the test :(
17:35 bshum At least the rest looks okay
17:35 * bshum wanders off to find his dinner
17:39 berick sounds like a self-help book... Find Your Dinner
17:39 berick @band add Your Inner Dinner
17:39 pinesol_green berick: Fire BAD! Reading GOOD!
17:40 berick maybe we need to create a @title add instead of @band add
21:54 StomproJ joined #evergreen

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