Evergreen ILS Website

IRC log for #evergreen, 2021-05-21

| 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
06:01 pinesol News from qatests: Testing Success <http://testing.evergreen-ils.org/~live>
07:18 rjackson_isl_hom joined #evergreen
08:18 collum joined #evergreen
08:41 mmorgan joined #evergreen
08:55 Dyrcona joined #evergreen
08:58 Dyrcona Acting Library Director: I'm not a library director, but I play one at work. :)
08:59 Dyrcona Also, why is a select statement with a long "IN" of barcodes (maybe 2,100) taking so long to run. Hmm.. probably the order by.
09:01 mmorgan Dyrcona++
09:01 Dyrcona Oh, sure. There are scheduled reports running....
09:01 Dyrcona Maybe I'll try the other database.
09:02 Dyrcona mmorgan: To follow up on something from the Zoom meeting yesterday. I really like that your list editor can put things in buckets.
09:03 mmorgan Dyrcona: Yes, it
09:03 mmorgan 's very popular among our users
09:03 Dyrcona We don't do that with metabase because it talks to our read only reports database. I won't connect it the live transaction database for now.
09:04 Dyrcona Also, that query ran a bit more quickly without the order by, so I don't have to switch databases. :)
09:05 Dyrcona And, I'm mistaken.... Case of glancing at the wrong tab and being distracted...
09:05 mmorgan Makes sense, we're wary about scripts making changes to the db, but inserting is less scary than updating :)
09:05 mmorgan Dyrcona: I'm impressed how quickly the queries ran in metabase.
09:07 Dyrcona John is pretty good with SQL. Also, I've generally found JDBC to be efficient. When doing MVLC's migration, the fastest way that I found to load bibs was a bunch of BatchStatements. Faster than parallel COPY.
09:07 Dyrcona I have to step away for a bit.
09:09 Dyrcona And, I don't. It has already been a confusing day, and I'm just getting started.
09:09 jeff was this a community call, or other?
09:10 csharp Dyrcona: sometimes EXISTS/NOT EXISTS is better than IN for certain queries
09:11 mmorgan jeff: other, neighbor networks :)
09:12 jeff guessed, but wanted to make sure i hadn't missed an opportunity. :-)
09:15 sandbergja joined #evergreen
09:17 rfrasur joined #evergreen
09:18 Dyrcona jeff: Yeah, just NOBLE and CWMARS chatting for the first time in over a year.
09:18 Dyrcona csharp: I was just dumping some copy data, so the straightforward query seemed to make the most sense.
09:22 Dyrcona Might have been faster to just read the barcodes line by line and dump the data row by row to a file using Perl or Python.
09:27 Dyrcona I was just trying to figure why only 1,855 copies from a spreadsheet listing 2,100 updated. Turns out the others were deleted after the spreadsheet was put together.
12:15 jihpringle joined #evergreen
12:34 collum joined #evergreen
12:49 collum joined #evergreen
13:55 jeffdavis Is it ok for me to commit code I wrote if other people have signed off on it?
13:56 jeffdavis I assume yes, but a bit hesitant
14:04 Dyrcona Yes, it is OK.
14:18 jeffdavis makes sense, thank you
15:27 mmorgan1 joined #evergreen
15:46 Bmagic Is there a wiki page somewhere that contains our roadmap for angularizing the dojo interfaces?
15:49 Bmagic I found: https://wiki.evergreen-ils.org/​doku.php?id=cataloging:angular and https://wiki.evergreen-ils.org/doku​.php?id=faqs:evergreen_roadmap:3.4
15:51 Dyrcona There isn't a road map for eliminating Dojo AFAIK, but there is a Lp bug.
15:53 Bmagic I'm looking for something for the acq invoice interface
15:55 Dyrcona Acq is being reimplemented by EOLI.
15:56 Bmagic groovy
15:57 Bmagic 3.7 has the search interfaces upgraded. But not the invoice interface
15:57 Bmagic maybe 3.8? eh?
15:57 Bmagic bug 1917482 is annoying
15:57 pinesol Launchpad bug 1917482 in Evergreen "Invoice UI fails to load completely" [Undecided,Confirmed] https://launchpad.net/bugs/1917482
16:01 tsadok Quick question about this channel:  is keeping it here (on the old Freenode network) a conscious decision, or has the question just not come up yet?
16:06 JBoyer Hasn't come up yet, though I know at least a few of us are aware.
16:23 tsadok Ok, just curious.
16:25 jihpringle joined #evergreen
16:59 pinesol News from qatests: Failed Installing OpenSRF pre-requisites <http://testing.evergreen-ils.org/~live//arch​ive/2021-05/2021-05-21_16:00:03/test.7.html>
17:04 mmorgan1 left #evergreen

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