Evergreen ILS Website

IRC log for #evergreen, 2020-08-06

| 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
00:05 jvwoolf joined #evergreen
00:11 jvwoolf joined #evergreen
00:25 jvwoolf joined #evergreen
00:30 jvwoolf joined #evergreen
00:35 jvwoolf joined #evergreen
00:41 jvwoolf joined #evergreen
00:45 jvwoolf joined #evergreen
00:50 jvwoolf joined #evergreen
00:55 jvwoolf joined #evergreen
01:00 jvwoolf joined #evergreen
01:05 alynn26_away joined #evergreen
01:05 jvwoolf joined #evergreen
01:10 jvwoolf joined #evergreen
01:15 jvwoolf joined #evergreen
01:20 jvwoolf joined #evergreen
01:25 jvwoolf joined #evergreen
01:30 jvwoolf joined #evergreen
01:35 jvwoolf joined #evergreen
01:40 jvwoolf joined #evergreen
01:45 jvwoolf joined #evergreen
01:57 jvwoolf joined #evergreen
06:02 pinesol News from qatests: Failed Installing Angular web client <http://testing.evergreen-ils.org/~live//arch​ive/2020-08/2020-08-06_04:00:16/test.29.html>
06:34 agoben joined #evergreen
07:25 rjackson_isl_hom joined #evergreen
07:53 mantis1 joined #evergreen
07:57 rfrasur joined #evergreen
08:02 mantis1 joined #evergreen
08:14 rhamby csharp : reason hack-a-way dates only one person marked themselves not available on that date and no one marked themselves as able to attend but bad for it.  did you mark yourself not availble for those dates, I don't see a response for you on the poll at all.
08:20 angelo joined #evergreen
08:23 angelo hey Bmagic
08:24 angelo we talked the other day about using data from another system export tool and importing it into a staging DB in postgre
08:41 mmorgan joined #evergreen
08:57 csharp rhamby: sorry - I missed the poll announcement - Terran told me she let you know of the conflict
09:01 rhamby csharp: yeah, it was announced several times and ran three weeks, looking back we had two responses from pines folks and one of them marked themselves available during that time; if you had responded too and that person had marked themselves unavailable it would have ended up with tying with one other and if there had been four pines responses it would have dropped out
09:02 csharp ok, well, what's done is done - I guess we're in a pickle
09:03 dbwells joined #evergreen
09:03 rhamby if pines folks are availalbe at some times we definitely want to try to schedule discussions to allow you to participate so if there's any scheduling information you can send me that might help at least for those events
09:07 Bmagic angelo: hey!
09:08 Bmagic sorry - I was sleeping. Just got to work
09:08 Bmagic @coffee angelo
09:08 * pinesol brews and pours a cup of Panama Esmeralda Especial, and sends it sliding down the bar to angelo
09:11 Dyrcona joined #evergreen
09:11 rhamby Bmagic the patch for the collectionhq stuff is merged
09:12 Bmagic rhamby++
09:12 Bmagic what game did you play?
09:12 rhamby last night we did an rpg called Honey Heist
09:12 angelo Bmagic, no worries, i was just going to ask some follow up questions
09:13 Bmagic haven't played that one - is it a multi-night epic? Rolling toon sheets and whatnot?
09:13 Bmagic angelo: fire away
09:13 rhamby Bmagic : a one page, very simple but fun https://gshowitt.itch.io/honey-heist
09:13 Bmagic rhamby: lol, I love it already
09:14 angelo so i got all but 1 table imported (actor.usr) i thought maybe it was a DB structure change since we're upgrading versions but it looks like the DB hasnt changed much recently
09:14 Bmagic angelo: it sounds like you are opting to import the data directly into production tables?
09:15 angelo looking at the data in excel it looks like there is a column missing somewhere, yet all the data seems to line up except when it gets to alias, it seems everything is shifted to the left
09:15 angelo correct
09:15 angelo that way i can work with it like you suggested
09:16 angelo my next question was now that i have the data in the tables, how do i get it into the proper DB with the existing constraints and triggers
09:16 Dyrcona When were preferred names added? They were in 3.2, weren't they?
09:16 Dyrcona We have them, at least, and we're on 3.2, but I backport stuff all the time.
09:17 Bmagic You are going to have a hard time I'm afraid. To answer your question though, it sounds like you turned off the contraints? In theory, you should just be able to turn them back on... But I am positive you will have trouble with that as the forign keys will be missing... so -
09:17 angelo they have them
09:17 angelo i dropped the constraints
09:18 mmorgan Dyrcona: Yep, preferred names was new in 3.2, added several fields to actor.usr
09:18 angelo yeah i saw that
09:19 angelo is there a way i can check the version of the data from the export they gave me?
09:19 Dyrcona angelo: It's probably the parent/guardian field.
09:19 Bmagic You will end up needing to satisfy the foreign key issues, one by one. And get the contraints back on the database. No matter how you do it (copy DB-without-constraints -> DB with constraints) or iof you just add the constraints back onto the DB as is
09:20 Bmagic angelo: does the data contain a table called: config.upgrade_log ?
09:20 angelo negative
09:21 Bmagic angelo: it would be sweet if you could import the data into the production tables. If you can do it and do it where you can put "humpty dumpty" back together again (getting the constraints) - then you would probably be the first
09:22 angelo i have the same number of columns in my export
09:23 Dyrcona angelo: Are you trying to load data into the 3.4 database or a 3.2 database?
09:23 angelo 3.4, i was going to do a 3.2 but it didnt look like any of the fields changed
09:24 angelo but im not 100% they were on 3.2 thats just what the library staff thought
09:24 Bmagic and you're not sure which version of EG this data came from?
09:24 angelo but like i said, i have the same column count in my export as the 3.4 DB
09:24 Bmagic for this one table though right?
09:24 angelo yeah
09:24 Bmagic does your action.circulation table have a column for "auto_renewal" ?
09:24 angelo all the other tables imported fine
09:25 Bmagic you've imported ALL of the data into their respective tables?
09:25 Dyrcona angelo: There was a parent/guardian field added to actor.usr in 3.3.0.
09:25 angelo yes to auto renewal
09:26 angelo and yes to imported all tables
09:26 Dyrcona That's your data looks off by 1 field.
09:26 angelo atleast the ones i have TSV files for
09:26 Bmagic you've loaded action.circulation? asset.copy, biblio.record_entry, asset.call_number ?
09:27 angelo yeah
09:28 Bmagic actor.usr_address, actor.card, config.circ_matrix_matchpoint... I have a query for you
09:29 angelo im not familiar with the git interface for the evergreen site, is there a 3.2 version i can just pull?
09:29 angelo or clone
09:29 Bmagic select * from actor.usr au left join permission.grp_tree pgt on (au.profile = pgt.id) where pgt.id is null
09:30 Bmagic do you get any rows from that query?
09:30 angelo no
09:31 Dyrcona angelo: You need to adjust your actor.usr data for a new column that was added in 3.3.0, otherwise you can get 3.2 via git.
09:31 angelo ok, let me try something
09:32 Bmagic try this one: select * from asset.call_number acn left join biblio.record_entry bre  on (acn.record=bre.id) where bre.id is null
09:34 angelo yes, plenty of results
09:34 Bmagic angelo: that's a bad thing
09:34 angelo what does it mean
09:35 Bmagic broken database links - when a staff member looks up a book, they scan the barcode and the will probably be shown a title that doesn't match the thing they have in their hand (assuming you fix the bad links somehow)
09:35 Dyrcona Or, waste your time running queries from Bmagic. ;)
09:36 angelo ugh
09:37 angelo how is the data from this migration tool suppose to work?
09:37 Dyrcona angelo: You said earlier that actor.usr wouldn't load and it looked like the data was off by 1 column. It is because you're missing data for the new parent/guardian field added in 3.3.0.
09:38 rhamby angelo : the extraction migration tool?
09:38 Bmagic the integrity of the asset.copy -> asset.call_number -> biblio.record_entry forieign keys need to be maintained. What method did you use to load biblio.record_entry. How many rows are in there?
09:38 angelo if i remove that field i get an error saying there is more data than the column count in the input file
09:38 angelo i loaded data from the TSV files with the copy command
09:39 phasefx_ directly into production tables?
09:39 angelo yes
09:39 rhamby the extraction assumes the data isn't being used to populate a new evergreen instance but either an entirely different ILS or ane existing instance but either way that it will go through a  process like I described the other day
09:39 angelo rhamby someone said the format of my data export looks like it came from that tool
09:40 rhamby angelo : I said that, I'm familiar with it
09:40 angelo oh lol ok
09:40 rhamby angelo : you can use the data to populate a new instance but it will be a fair bit of work
09:40 angelo i see so this isnt meant for EG -> EG
09:40 Bmagic angelo: You're going to wish you had spent your time solving proper migration (with constraits) instead of dealing with these disconnected tables and trying to hook them back up
09:41 rhamby angelo : it's not really meant to be a fire and forget solution, it gives you the data and the table definitions so you can reconstruct it
09:41 angelo is there an order in which i should import data to satisfy the constraints?
09:41 angelo i thought about scripting it to import in random orders and letting it run overnight
09:41 rhamby yes, roughly, bibs, org units, users, call numbers, copies, then other stuff
09:41 Bmagic all of this data needs to be loaded into non-production tables, into pre-created tables in a non-production schema
09:42 angelo bmagic i just scripted the removal of all constrains and triggers in order to get the data to load
09:42 angelo into my staging DB
09:43 angelo so i didnt need to create the tables by hand
09:44 Bmagic angelo: understood, but the constraints DO need to be put back in. I'm starting to feel like we've not done a good job explaining this process. It's complexity probably has something to do with it. But the first step is to load the database with this data into dummy tables.
09:45 angelo ok, whats the next step?
09:45 Bmagic drop database evergreen;
09:45 angelo ok
09:45 Bmagic create it again from the git repo
09:45 angelo ok
09:46 Bmagic for each file that you have - figure out the column names and do these things:
09:46 Bmagic create schema m_staging
09:47 Bmagic create table m_staging.actor_usr_legacy (column names.......) inherits (actor.usr)
09:47 Bmagic repeat that command for each file you have (make sure you don't name the columns the same as the production table)
09:48 phasefx if it helps, here's a broad overview of the staging table strategy: http://tinyurl.com/EGmigrations2  If you do stuff like this a lot, there are tools that can automate a lot of it
09:49 Bmagic The column names can* be easier to deal with if you name them something very close to the column names in production. Like prefixing the names with "l_"
09:50 Bmagic angelo: that perl script automates this table creation and data import into those tables
09:50 Bmagic it needs to be taught to read files though
09:51 Dyrcona Why can't the column names be the same? Is there some technical reason for that? I can't think of any.
09:51 * Dyrcona decides to shut up an let Bmagic lead the show. Don't mind me....
09:52 angelo is it because of the inherits?
09:52 angelo im new to PGSQL so the object oriented is new
09:52 angelo im familair with inherts in progamming toh
09:53 angelo wow, let me try that again
09:53 angelo im familiar with inherits in programming though**
09:54 Dyrcona Inheritance in Pg is very different from inheritance in class-based OO. Rows in child tables also exist in the parent table.
09:55 angelo oh
09:55 angelo idk if i like that at all lol
09:55 Bmagic select * from an inherited table will show the columns that you created in the table PLUS the columns from the parent table
09:56 Bmagic You need this in order to make those foreign key mappings from old ID number -> new ID number for each table
09:56 angelo sounds like a join statement
09:56 Bmagic yeah, sort of
09:57 angelo waiiitttt
09:57 Bmagic it will make our lives much easier.. Inherited tables are sweet
09:57 angelo when you say new ID number
09:57 phasefx the general strategy for migration-tools is create a "base" staging table that mirrors a production table via LIKE.  They're shaped the same and share a sequence.  You _could_ just use that.  But for there are advantages to going further than creating a "legacy" staging table that is a child of the base staging table.  Then you use UPDATE to massage the data, copying legacy columns into base columns.  When you're satisfied, you can simply insert
09:57 phasefx from the base staging table into the production table
09:57 angelo are the current IDs going to be some sort of auto incremented ID and now that im re-importing them they are no longer going to match
09:57 phasefx some bad English there, but that's the gist :)
09:58 Bmagic what phasefx said - I missed a step - you do need to run a couple of queries at the top of that migrate_evergreen.sql file I linked the other day
10:01 angelo ok, first things first, how can i git clone the 3.2 repo? i have this link https://git.evergreen-ils.org/?p=Evergreen.git;a​=tree;h=refs/heads/rel_3_2;hb=refs/heads/rel_3_2
10:01 phasefx mig has changed a bit since that slideshow too.. we prefix staging tables with m_ just to be extra careful when working with tables (say, when using tab-completion in psql)
10:01 angelo let me see if i can even migrate the usr into a table with those columns
10:13 angelo nvm i figured it out
10:16 Bmagic angelo++
10:27 sandbergja joined #evergreen
10:28 angelo so i got the 3.2 but how can i generate the eg_db_config file, right now i only have the .in file
10:28 angelo do i need to run the make install?
10:29 sandbergja_ joined #evergreen
10:31 sandbergja_ joined #evergreen
10:31 csharp angelo: yes - follow https://evergreen-ils.org/documentation/install/​README_3_4.html#_preamble_developer_instructions (this is for 3.4 but nothing much changed between those)
10:55 sandbergja joined #evergreen
11:10 sandbergja_ joined #evergreen
11:16 sandbergja_ joined #evergreen
11:49 berick i'm planning to merge bug 1864371 (ang 10) to master soon unless i hear drums, drums in the deep.
11:49 pinesol Launchpad bug 1864371 in Evergreen "Upgrade to Angular 10" [Wishlist,Confirmed] https://launchpad.net/bugs/1864371
11:54 sandbergja joined #evergreen
11:59 * csharp knocks skull down well and is called a fool by Gandalf
12:02 phasefx what are you doing in Moria?
12:04 jihpringle joined #evergreen
12:05 Dyrcona phasefx: Just passin' through.
12:05 berick Dyrcona++
12:06 * phasefx hears drums
12:08 berick the fellowhip runs as John Bonham pops out of the ground
12:11 * Dyrcona has been listening to Led Zeppelin this morning.
12:11 phasefx caching seems more aggressive than usual for me; incognito works to get all my org units to show in a register workstation dropdown, but my normal window, shift+reload doesn't, dev console with no caching setting doesn't work
12:12 berick phasefx: org tree is session cached.  opening in a new tab should reset it
12:12 phasefx berick++
12:12 phasefx that did the trick
12:13 berick cool
12:13 Dyrcona Yeah, Chromium/Chrome in particular seems to be more aggressive with cache. Even when starting up with a previous session.
12:14 phasefx I think yesterday I tried clearing everything out of the dev console Application tab and it still didn't work :)
12:16 sandbergja_ joined #evergreen
12:17 Dyrcona Next up: Bonzo's Montreux, a John Bonham drum solo with accompaniment added by Jimmy Page.
12:19 berick \m/
12:24 sandbergja_ joined #evergreen
12:27 Bmagic \m/ indeed
12:30 mrisher joined #evergreen
12:47 pinesol Showing latest 5 of 11 commits to Evergreen...
12:47 pinesol [evergreen|Bill Erickson] LP1864371 Remove extra match set data source - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=e5b1d76>
12:47 pinesol [evergreen|Bill Erickson] LP1864371 Angular 10 deps - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=f4d6e44>
12:47 pinesol [evergreen|Bill Erickson] LP1864371 Angular 10 deps - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=6d462ca>
12:47 pinesol [evergreen|Galen Charlton] LP#1864371: (follow-up) fix lint - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=1a51824>
12:47 pinesol [evergreen|Galen Charlton] LP#1864371: bump up ng-bootstrap to 7.0.0 - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=0ebbd2f>
12:48 gmcharlt berick++ sandbergja++
12:49 sandbergja_ Anybody else having trouble running this pgtap live test: lp1145213_test_func_asset.merge_record_assets.pg ?
12:49 sandbergja_ testing.evergreen-ils.org has no problems with it, but it fails every time I try it on recent branches
12:50 sandbergja_ every other pgtap live test runs fine -- just that one
12:50 sandbergja_ either I get 3 instead of 4, or it complains about the prefix fkey (which makes sense to me)
12:51 phasefx that one broke before and I thought I fixed it
12:52 sandbergja_ phasefx: let me check; maybe I have the broken version
12:52 phasefx bbe8a9295e8e309b3c240808ba7e2ad491dbf82c
12:52 pinesol phasefx: [evergreen|Jason Etheridge] lp1145213 avoid race condition in bib merge test - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=bbe8a92>
13:04 Bmagic berick++
13:04 Bmagic sandbergja++
13:33 JBoyer berick++
13:33 JBoyer sandbergja++
13:40 mrisher joined #evergreen
13:50 dluch DIG Meeting will be starting in 10 minutes
14:00 dluch #startmeeting 2020-08-06 - Documentation Interest Group Meeting
14:00 pinesol Meeting started Thu Aug  6 14:00:10 2020 US/Eastern.  The chair is dluch. Information about MeetBot at http://wiki.debian.org/MeetBot.
14:00 pinesol Useful Commands: #action #agreed #help #info #idea #link #topic #startvote.
14:00 Topic for #evergreen is now  (Meeting topic: 2020-08-06 - Documentation Interest Group Meeting)
14:00 pinesol The meeting name has been set to '2020_08_06___documentatio​n_interest_group_meeting'
14:00 dluch #topic Agenda
14:00 Topic for #evergreen is now Agenda (Meeting topic: 2020-08-06 - Documentation Interest Group Meeting)
14:00 dluch #info The agenda can be found here:  https://wiki.evergreen-ils.org/doku.php?id=​evergreen-docs:dig_meetings:20200806-agenda
14:00 dluch Welcome everyone!  Today's meeting will be a little bit of discussion but will mostly be time for collaboration and working on documentation.
14:00 dluch #topic Introductions
14:00 dluch Please paste "#info <username> is <name>, <affiliation>" to identify who you are and what organization, if any, you represent.
14:00 dluch #info dluch is Debbie Luchenbill, MOBIUS
14:00 Topic for #evergreen is now Introductions (Meeting topic: 2020-08-06 - Documentation Interest Group Meeting)
14:01 Bmagic #info Bmagic is Blake GH, MOBIUS
14:01 rhamby #info rhamby is Rogan Hamby, Equinox
14:01 abneiman #info abneiman is Andrea Buntz Neiman, Equinox
14:01 jihpringle #info jihpringle is Jennifer Pringle, BC Libraries Cooperative (Sitka)
14:03 dluch Thank you all for coming! If you join in later, feel free to introduce yourself when you arrive.
14:03 dluch #topic Helpful Information: Documentation contributions and collaboration
14:03 dluch #info You can find the Documentation Needs List at https://wiki.evergreen-ils.org/doku.php​?id=evergreen-docs:documentation_needs
14:03 dluch #info DIG Roles can be found at https://wiki.evergreen-ils.org/doku.p​hp?id=evergreen-docs:digparticipants
14:03 Topic for #evergreen is now Helpful Information: Documentation contributions and collaboration (Meeting topic: 2020-08-06 - Documentation Interest Group Meeting)
14:03 dluch We are going to do some quick business items...
14:03 jweston #info jweston is Jennifer Weston, Equinox
14:04 dluch #topic Business
14:04 dluch #info Check-in
14:04 dluch First off, how is everyone doing?
14:04 dluch How are things where you are?
14:04 Topic for #evergreen is now Business (Meeting topic: 2020-08-06 - Documentation Interest Group Meeting)
14:04 Bmagic Kicking it freestyle! Doing great! Healthy, working from home.
14:04 rhamby very hot and humid but ... it's the south so to be expected
14:04 dluch ha, yes
14:05 abneiman Doing ok in MD, my house was spared from Tropical Storm Isaisis (or however you spell it) for the most part
14:05 dluch We have been experiencing October-like weather the last couple of days. It's been awesome--all my windows are open! Back to heat and humidity tomorrow, though
14:05 dluch abneiman: Good!
14:06 dluch Anyone else affected by Isaias?
14:06 jweston safe in this part of NC just loud thunderstorms
14:06 dluch jweston: Good!
14:07 dluch #info Quick report on Antora progress
14:08 dluch Anything to report on Antora?
14:09 abneiman I have a couple questions about Antora/docs server move
14:09 abneiman (I know it's not a full biz meeting but I think we should talk about them today, given where we are in the release cycle)
14:09 dluch Sure, go ahead
14:10 adurrence joined #evergreen
14:10 abneiman caveat: I know I missed the last two meetings, and I did read the notes, but if I'm covering ground that's already been covered please tell me!
14:10 Bmagic The state of it is the same as last meeting - though something to note: I've merged the upstream changes but haven't heard back from gmcharlt or sandbergja
14:10 rfrasur #info rfrasur is Ruth Frasur, Indiana (popping in and out)
14:10 Bmagic https://git.evergreen-ils.org/?p=worki​ng/eg-antora.git;a=shortlog;h=refs/hea​ds/user/blake/antora-ui-upstream-sync
14:11 abneiman so I talked to gmcharlt earlier today abotu what was needed to push Antora to completion - step one is merging the Antora branch
14:11 abneiman Bmagic, do you think that's ready for a pullrequest?
14:11 adurrence April Durrence, NC Cardinal (lurking)
14:11 gmcharlt #info gmcharlt = Galen Charlton, EOLI
14:11 abneiman And DIG, are we collectively OK with giving our blessing to its merge?
14:11 Bmagic the git link I just pasted is ready and needs to go to master asap. Though - it's not the Antora branch for the Evergreen repo
14:12 gmcharlt so, two branches
14:12 gmcharlt the eg-antora one above
14:12 gmcharlt and the bug 1848524 one
14:12 pinesol Launchpad bug 1848524 in Evergreen "wishlist: Antora-ize docs " [Undecided,New] https://launchpad.net/bugs/1848524
14:12 Bmagic eg-antora repo will get updatse as time goes on. Mostly to incorporate the new UI features from upstream. Which is the case here
14:12 dluch We have agreed in previous DIG meetings about wanting to go forward with the merge
14:13 gmcharlt is there any bar to a committer merging 1848524?
14:13 abneiman dluch: excellent! As DIG chair, do you mind tossing a comment on 1848524 to that effect?
14:13 dluch Sure!
14:13 abneiman dluch++
14:13 Bmagic Right before we merge 1848524 - we will want to rm docs; mv docs-antora docs
14:13 Bmagic gmcharlt ^^
14:14 gmcharlt Bmagic: OK, that answsers another question I had in mind
14:14 gmcharlt if the docs-antora branch is otherwise up to date, I can commit to merging that in the next day or two and replacing docs/
14:15 gmcharlt (in the master branch, to start)
14:15 Bmagic Couple of outstanding things are: generation of the PG schemas -> HTML and PDF generation of the docs (and epub if we still want to support that)
14:15 abneiman relatedly, rather than having to do the commit-docs-to-both-branches thing (is that still a thing? my last notes indicates that's still a thing), I propose that we pick a cutoff (like 3.4 since it's still in support) and antoraize everything back to 3.4, and don't worry about updating anything from 3.3 and prior
14:16 abneiman Bmagic: can those outstanding things be (relatively easily) added post-antorization?
14:16 Bmagic abneiman: At some point we talked about back porting and we sort of decided that we didn't want to take on the back porting project. Just going forward with Antora after it's merged to master
14:17 Bmagic and yes, right now, without it merged, documentation writers will need to make their changes in master AND in this branch
14:17 abneiman my not-so-secret agenda here as a docs committer is to be able to put 3.6 docs in the right place :)
14:17 abneiman (and one place)
14:17 Bmagic one_place++
14:17 dluch abneiman++
14:18 abneiman so, if DIG & Bmagic agree that that branch is ready, and gmcharlt is willing to merge, it sounds like we're all in agreement?
14:18 Bmagic gmcharlt might be able to speak to the relative easyness for those last outstanding things
14:18 dluch Sounds like it to me!
14:18 dluch Do folks feel like DIG should make a formal vote, or are we just in consensus?
14:18 Bmagic I didn't find a tool online for converting a PG database schema to HTML. Though I only spent 10 minutes or so looking
14:19 gmcharlt but not really a dependency for Antora
14:19 gmcharlt we can direct more eyes on finding something
14:19 abneiman Bmagic: I guess my thought is that, while the pg schema is helpful, I don't really want it to hold up moving this forward
14:19 Bmagic I totally agree
14:19 Bmagic The PDF generation on the other hand, might* be more important
14:20 abneiman important enough to be a blocker? what are people's thoughts there?
14:20 Bmagic Antora is suppose to be including this functionality: https://docs.antora.org/an​tora/2.1/project/roadmap/
14:20 dluch What version are we on now?
14:20 Bmagic https://gitlab.com/antora/antora/-/issues/349
14:20 dluch I would say it's not a blocker, especially if it's coming in the near future
14:21 Bmagic we are on 2.3
14:21 abneiman Bmagic what's involved with upgrading?
14:22 Bmagic Antora 2.3 is the latest, but upgrading to a new version of Antora is a piece of cake. It's included in the generate_docs.pl script
14:22 abneiman sweet
14:22 dluch awesome
14:22 abneiman so then I agree with dluch that this is not a blocker
14:23 Bmagic gmcharlt - if/when you get time to work on this merge, I can be available for any sort of questions
14:23 dluch Does anyone else have comments/concerns?
14:24 abneiman there's the question of moving to the new server but I can toss that to the listserv in the interest of time
14:24 Bmagic We do have a "new" docs server.... which is not currently being used for production links from evergreen-ils.org. What's the plan on that?
14:24 Bmagic abneiman: jynx!
14:25 Bmagic yeah, talking about that here could soak up a bunch of time - listerv
14:25 abneiman will do
14:25 dluch Sounds great, thanks
14:25 dluch Big thanks again to Bmagic and remingtron for all their work getting Antora set up and to devted for finding it and everyone in DIG who tested and made suggestions!
14:25 dluch Bmagic++ remingtron++ devted++
14:26 Bmagic and the link again for anyone: http://eg-docs.georgialibraries.org/prod/
14:26 dluch gmcharlt++ abneiman++ for getting it all wrangled in!
14:26 dluch Antora++
14:26 dluch Okay, really quickly...
14:26 dluch #info Docs Launchpad Bugs need signoffs: 1642023, 1487123
14:26 devted Bmagic++ remingtron++
14:27 abneiman I can look at 1642023
14:27 alynn26 bmagic++
14:27 dluch Terran emailed yesterday that these two launchpad tickets need signoffs to proceed. Those two have pull requests but need signoffs first. Can I have a couple of volunteers to check on them and/or sign off?
14:27 alynn26 #info alynn26 is Lynn Floyd, Evergreen Indiana
14:27 dluch abneiman++ Thanks!
14:27 devted dluch++ gmcharlt++ abneiman++
14:27 abneiman alynn26: do you have more to do on 1642023 before I review it?
14:29 dluch Also, I don't know her nick, but terran++ for finding these!
14:29 alynn26 I'll look at it.
14:29 dluch Any volunteers for 1487123?
14:30 dluch I'll put it out on the listserv, then
14:30 dluch Related to that, as I was looking through all the tickets on Launchpad with the tag "documentation," I noticed a bunch that are super-old and/or no longer relevant. I made going through them a suggestion for a possible thing to work on during working time, unless this seems like a project that DIG should work on together.
14:31 dluch Thoughts/Questions?
14:31 alynn26 as to LP# 1642023 There is more work to be done, but those can be added later.
14:31 abneiman dluch: the PR on 1487123 is a couple years old and there's a pending question from gmcharlt about it - and I'm not sure if it will still play nicely with Antora - so taht might need deeper review than just a test/signoff?
14:32 dluch abneiman: Okay, sounds good. That was one I hadn't really have time to look over.
14:32 jweston dluch: review of old doc bugs sounds great - I don't think it needs to be a group DIG project; just as individual time allows
14:32 gmcharlt yeah, my gut feeling is that will need to be looked at afresh post-Antora
14:32 dluch jweston: great, thanks!
14:33 dluch gmcharlt: Okay, sounds good. We can table that one for a while
14:33 abneiman re 1487123, I'll remove the PR and note that it needs discussion. +1 to reviewing old LP bugs.
14:33 dluch abneiman: thanks!
14:33 dluch #info We will catch up on other action items and business at the next meeting
14:33 dluch #info Anything else pressing?
14:34 dluch Thanks, everyone!
14:34 dluch Today's meeting is intended to be for collaboration/working time, so let's move on to that!
14:34 dluch #topic Collaboration time
14:34 dluch What is everyone planning to work on today?  Please let us know here, and feel free to talk and work with each other.  If you'd like extra accountability, I can make an action item to show up in the minutes, but it's not necessary.
14:34 Topic for #evergreen is now Collaboration time (Meeting topic: 2020-08-06 - Documentation Interest Group Meeting)
14:35 dluch I know it's a little overwhelming for some folks what to start with, so I made a list of ideas you could work on (alone or with others) if you don't already have something.
14:35 abneiman If we all start looking at old LPs for docs, I bet we can knock a lot of them out
14:35 dluch -your own priority projects
14:35 dluch -finishing 3.5 docs
14:35 dluch -experimental catalog docs
14:35 dluch -cleaning up old docs tickets on Launchpad
14:35 dluch -finding docs tickets on Launchpad to work on
14:35 dluch -easy tasks from Documentation Needs List
14:35 dluch -auditing and removing finished or irrelevant items from the Documentation Needs List and/or adding 3.5 documentation needs
14:35 dluch -still-relevant items from the Documentation Needs List (be sure to assign yourself to it so we don't duplicate work)
14:35 dluch -documentation-related short videos for the community YouTube channel
14:35 gmcharlt to anticipate some of the server move discussion, rhamby and I are working on copying the 3.2 and earlier stuff from the old website to the new one quite soon
14:35 dluch -looking through existing docs for things that need updating - text and/or images
14:35 dluch abneiman++
14:36 dluch gmcharlt: Awesome!
14:36 dluch gmcharlt++ rhamby++
14:36 jweston previously discussed with alynn26 - working on Library Settings and documenting defaults
14:37 rhamby I have an older download already but I'm refreshing it.  I am running into a few errors but I will check those to see if they are red herrings  and make sure internal links are relative so it's ready to move.
14:37 dluch jweston++ alynn26++
14:37 angelo joined #evergreen
14:37 angelo Bmagic i made up the m_ tables per the slides and im at the import step but when i try and run "INSERT INTO actor.usr SELECT * FROM m_actor.usr;" i get the following error "ERROR:  column "name_kw_tsvector" is of type tsvector but expression is of type text" both columns are tsvector
14:38 abneiman this.... doesn't seem like a docs issue? LP 1076582
14:38 pinesol Launchpad bug 1076582 in Evergreen "Documentation explaining openils_dojo.js" [Low,Confirmed] https://launchpad.net/bugs/1076582
14:39 jihpringle I'm going to continue working on the experimental catalogue docs - we've started documenting it in our Sitka docs
14:39 jihpringle http://docs.libraries.coop/sitk​a/_experimental_catalogue.html (EG 3.5)
14:39 dluch hi angelo: We're having a documentation interest group meeting here right now, and will be done in about 20 minutes
14:39 jweston jihpringle++ also on my to-do list is start reviewing what you've done and touch base on how I can contribute (will reach out in email)
14:40 jvwoolf joined #evergreen
14:40 angelo dluch sorry to interrupt
14:40 jihpringle sounds good jweston
14:40 dluch angelo: No worries!
14:40 dluch jihpringle++
14:41 dluch abneiman: I agree
14:41 abneiman dluch: yeah I'm going to pull the docs tag from that
14:41 dluch Can we remove the documentation tag?
14:41 dluch lol, great!
14:41 abneiman GMTA :)
14:41 dluch :-)
14:43 adurrence I am working on circ training with brief videos, so can work on suitable versions for EG community, if that would be helpful?
14:43 abneiman I think bug 1192699 can be set to won't fix since it refers to the old Receipt Template Editor
14:43 pinesol Launchpad bug 1192699 in Evergreen "Various Patron-centric Macros Don't Work with Checkin Receipt Template" [Undecided,Confirmed] https://launchpad.net/bugs/1192699
14:44 abneiman adurrence: +1 that sounds great! (cc rhamby ^^ since we talked about this in Outreach yesterday)
14:44 rhamby adurrence: +1 sounds awesome, we can host them on the evergreen community youtube channel
14:44 adurrence Okay, once I have them ready, I will be posting on our YouTube channel, but can send files to rhamby?
14:44 rhamby adurrence sure
14:44 dluch How about LP 701208? Doesn't seem relevant anymore
14:45 pinesol Launchpad bug 701208 in Evergreen "Browse Hold Shelf crashes with "large" number of copies" [Low,Confirmed] https://launchpad.net/bugs/701208
14:45 rhamby adurrence: I'll send you an easy upload link to send large files to me
14:45 adurrence perfect!
14:45 dluch adurrence++ That would be awesome!
14:46 jweston adurrence++ +1 to videos; last month we discussed future project of embedding videos in doc -- longer term goals :-)
14:47 adurrence Yes, was planning to do that with ours, so win/win!
14:49 dluch Also, LP 791225 doesn't seem to be docs related at all?
14:49 pinesol Launchpad bug 791225 in Evergreen "Apache Log error - missing CSS files" [Low,Confirmed] https://launchpad.net/bugs/791225
14:49 dluch (also it's old)
14:51 abneiman dluch: re 701208, I suspect there still might be a need for OpenSRF documentation in that area, per comment #8
14:51 dluch Okay
14:51 dluch We can leave that one :-)
14:53 abneiman the other one...... it looks like that's more of an aspirational use of the docs tag? And I'm not sure if this is still part of the install process.... Bmagic or any other developery person want to weigh in there?
14:54 abneiman ooh this one might be good to get eyes on for feedback fest: bug 1374483 - looks like remingtron put a branch on it during last year's Hack-a-wat
14:54 pinesol Launchpad bug 1374483 in Trove Integration "Gate blocker. trove-manage command failing while `kick-start`ing" [Critical,Invalid] https://launchpad.net/bugs/1374483
14:54 dluch Same with this one: LP 1035347  I have no idea what the chart is showing or if it's still even accurate
14:54 pinesol Launchpad bug 1035347 in Evergreen "HTTP request handling sequence diagram" [Undecided,Triaged] https://launchpad.net/bugs/1035347
14:54 abneiman nope wrong number, I meant bug 1375543
14:54 pinesol Launchpad bug 1375543 in libreoffice (Ubuntu) "package libreoffice-common 1:4.2.4-0ubuntu2 failed to install/upgrade: unable to stat `./usr/lib/libreoffice/program​/wizards/web/ProcessErrors.py' (which I was about to install): Input/output error" [Undecided,Won't fix] https://launchpad.net/bugs/1375543
14:55 abneiman NO DAMMIT why can't I type ..... bug 1374453 and this time I mean it
14:55 pinesol Launchpad bug 1374453 in Evergreen "Documentation: Image file cleanup" [Undecided,New] https://launchpad.net/bugs/1374453
14:55 dluch I was going to say, where's the docs part, lol
14:55 abneiman there we go
14:56 dluch abneiman: ooo, yes! That does look like a good one for feedback fest
14:57 abneiman99 joined #evergreen
14:57 abneiman99 sorry, quassel fell over
14:57 Bmagic remingtron and I did some of this image juggling for the antora branch
14:57 alynn26 This is diffently one some one needs eyes on.
14:58 miker joined #evergreen
14:58 dluch This one doesn't look relevant or docs-related, either: LP 1108852
14:58 jweston joined #evergreen
14:58 pinesol Launchpad bug 1108852 in Evergreen "datasets needs up-to-date README" [Medium,Confirmed] https://launchpad.net/bugs/1108852
14:58 Bmagic Pretty sure the docs-antora folder only received images that were referenced
14:59 abneiman99 dluch: not sure if my last msg made it, but, the diagram in bug 1035347 might be helpful if it's still accurate
14:59 pinesol Launchpad bug 1035347 in Evergreen "HTTP request handling sequence diagram" [Undecided,Triaged] https://launchpad.net/bugs/1035347
14:59 jgoodson joined #evergreen
14:59 felicia joined #evergreen
14:59 abneiman joined #evergreen
14:59 dluch abneiman: Thanks, it didn't. Bmagic, could you take a look at that one and see if it is?
15:00 dluch (or any other dev-type)
15:00 drigney joined #evergreen
15:00 rhamby joined #evergreen
15:00 lbarry joined #evergreen
15:00 ericar joined #evergreen
15:00 jyorio joined #evergreen
15:00 dluch We are at time.  Thanks for all the great work, everyone!  Feel free to keep going after the meeting!
15:00 phasefx_ joined #evergreen
15:00 lisacarlucci joined #evergreen
15:00 dluch The next meeting will be September 3. Same time, same place. Business meeting first then collaboration time (if there's time).
15:00 dluch Please continue using the email list and/or Launchpad for questions and other things that come up in between meetings.
15:00 dluch Thanks for coming!
15:00 jweston dluch++
15:00 abneiman dluch++
15:00 dluch #endmeeting
15:00 Topic for #evergreen is now Welcome to the #evergreen library system channel! | We are publicly logged: http://irc.evergreen-ils.org/evergreen | Large pastes at http://paste.evergreen-ils.org | Can't speak? Make sure your nickname is registered and that you are identified to freenode services: https://freenode.net/kb/answer/registration
15:00 pinesol Meeting ended Thu Aug  6 15:00:56 2020 US/Eastern.  Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4)
15:00 pinesol Minutes:        http://evergreen-ils.org/meetings/evergr​een/2020/evergreen.2020-08-06-14.00.html
15:00 pinesol Minutes (text): http://evergreen-ils.org/meetings/evergr​een/2020/evergreen.2020-08-06-14.00.txt
15:00 pinesol Log:            http://evergreen-ils.org/meetings/evergree​n/2020/evergreen.2020-08-06-14.00.log.html
15:02 Bmagic re: bug 1035347 - This is documentation to be included? The work here is to take this image and put it into a documentation page? Maybe alynn26 knows where it belongs best?
15:02 pinesol Launchpad bug 1035347 in Evergreen "HTTP request handling sequence diagram" [Undecided,Triaged] https://launchpad.net/bugs/1035347
15:03 dluch Bmagic: Yeah, is the information still valid? It's from a long time ago, but if the things it addresses are still relevant, we can move it into docs
15:04 Bmagic Yes I believe it's still the same fundamental way that Evergreen processes requests
15:06 dluch Okay, cool. We'll keep it open, then
15:07 Bmagic Though, dbwells did a more in-depth presentation on this and created a fuller documentation... though, their presentation is not online. Can't find it here: https://evergreen-ils.org/conference/20​17-evergreen-international-conference/2​017-conference-programs-and-schedule/
15:07 abowling joined #evergreen
15:08 Bmagic Their presentation was called "Evergreen in HD" - listed in this PDF: https://evergreen-ils.org/wp-content/uploads/2016​/12/2017EvergreenConferenceProgram-LetterSize.pdf
15:12 Bmagic angelo: alrighty - the error you posted. Something is amiss for sure. One thing that jumps out at me is the name of the schema (though not technically an issue) - did you end up making a schema for each table?
15:12 angelo ok so i got around that issue
15:12 angelo but i still get constraint errors when i try and do the insert
15:13 Bmagic the "create schema" command could be issued just once. and you can put all of your staging tables in that same schema - but it's not a deal breaker
15:13 Bmagic angelo: gotcha - contraint errors, that is most likely because the ID numbers for things like mailing_address are not correct
15:14 angelo i made the m_ schemas per the slides
15:14 Bmagic do you have an exported file for actor.usr_address ?
15:15 angelo yeah
15:15 angelo but if i try and import that i get errors the other way around
15:16 Bmagic right, this is solvable. You have to update the ID's in the staging table, such that they point to the correct ID number in the production tables. There are tons of examples of this in that migrate_evergreen.sql file
15:16 Bmagic https://github.com/mcoia/mobius_evergreen​/blob/master/Random/migrate_evergreen.sql
15:17 Bmagic starting on line 1159 or so
15:17 Bmagic as a guide for you. You can see how you would want to update the column "profile" for example. And "home_ou" for example
15:19 Bmagic In this example, the table with the suffix "_legacy" is an inherited table from m_staging.actor_usr, which is inherited from actor.usr (production table)
15:20 Bmagic the legacy table is where all of the original data is imported. Into columns with the same names as the production column names, but prefixed with "l_" - the procedure outlined here is to copy all of the data from the l_* columns into the production columns, with some exceptions
15:21 Bmagic the exceptions (for the actor.usr table) are: profile, home_ou, card, mailing_address, billing_address
15:22 Bmagic You will find a query that updates those columns specifically, instead of just copying the data from the legacy columns.
15:23 Bmagic You will also notice that there are UPDATE statements for some of the related tables along the way: m_staging_schema.actor_usr_address_legacy, m_staging_schema.patron_passwd
15:30 angelo ok, ill see what i can do with that
16:10 berick Bmagic: FYI ES7 was pretty easy to get working.  rebased es7 branch here: https://github.com/berick/Eve​rgreen/tree/elasticsearch-es7
16:14 * csharp read ES7 as "ECMAScript 7"
16:14 * JBoyer too
16:33 Bmagic berick++
16:40 mantis1 left #evergreen
16:48 pinesol News from qatests: Failed Installing OpenSRF pre-requisites <http://testing.evergreen-ils.org/~live//arch​ive/2020-08/2020-08-06_16:00:03/test.7.html>
17:05 mmorgan left #evergreen
17:59 abowling1 joined #evergreen
18:10 abowling joined #evergreen
18:37 sandbergja joined #evergreen
18:41 sandbergja Okay, we have some items with a status of checked out, but the most recent circ has a check in date (and my staff member remembers checking it in)
18:41 sandbergja I'm 101% sure that it's due to some weird pandemic due-date extensions that I did
18:42 sandbergja :-( :-( :-( this is why I like cataloging, not circulation
18:43 Bmagic sandbergja: what happens when you check one in?
18:44 sandbergja Bmagic: let's find out!
18:44 sandbergja Goes to reshelving, thank goodness
18:44 Bmagic Are they still in circulation physically?
18:46 sandbergja kinda? It was a laptop that a patron said they left with campus security.  We believe them, but haven't actually good to the security office to look.  The staff member just checked it in without the physical item. :-)
18:47 Bmagic In not aware of a circumstance that could cause an item to keep the checkout status when its checked in. Maybe a drone died during the process?
18:50 sandbergja That could be.  I also wonder if I botched some SQL while extending due dates.
18:50 sandbergja joined #evergreen
18:54 Bmagic Perhaps. But hey, we know that checking them in fixes it :)
18:54 sandbergja True!  That made my stress level go way down!
18:54 sandbergja Bmagic++
19:19 sandbergja_ joined #evergreen
19:37 sandbergja_ joined #evergreen
19:39 sandbergja_ joined #evergreen
19:51 sandbergja_ joined #evergreen
19:53 sandbergja_ joined #evergreen
20:09 sandbergja_ joined #evergreen
20:16 sandbergja joined #evergreen
21:07 sandbergja joined #evergreen
21:13 sandbergja joined #evergreen
21:32 gmcharlt joined #evergreen
21:33 sandbergja joined #evergreen
21:39 sandbergja joined #evergreen
21:59 sandbergja joined #evergreen
22:32 sandbergja joined #evergreen
23:09 pinesol [evergreen|Terran McCanna] LP#1839369 Accessibility for Search Box - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=d3fb539>
23:09 pinesol [evergreen|Galen Charlton] LP#1839369: (follow-up) tweak button and styles - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=06e2236>
23:25 mrisher joined #evergreen

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