IRC log for #koha, 2019-07-29

All times shown according to UTC.

Time S Nick Message
00:44 inlibro joined #koha
01:44 inlibro joined #koha
02:44 inlibro joined #koha
03:44 inlibro joined #koha
04:44 inlibro joined #koha
05:05 chris joined #koha
05:44 inlibro joined #koha
05:54 calire joined #koha
06:04 fridolin joined #koha
06:05 fridolin hi
06:20 cait joined #koha
06:30 cait hi #kolha
06:30 cait hi #koha
06:31 laurence joined #koha
06:37 reiveune joined #koha
06:37 reiveune hello
06:45 inlibro joined #koha
06:49 alexbuckley joined #koha
06:56 alex_a joined #koha
06:56 alex_a bonjour
07:10 marcelr joined #koha
07:11 marcelr hi #koha
07:14 cait hi marcelr
07:16 marcelr o/
07:45 inlibro joined #koha
08:23 AnkeB joined #koha
08:34 greenjimll joined #koha
08:45 vfernandes joined #koha
08:45 vfernandes hi #koha
08:45 inlibro joined #koha
09:43 magnuse hiya #koha!
09:43 * magnuse tries to get back in the groove after 5 weeks off
09:45 inlibro joined #koha
09:50 khall joined #koha
09:59 magnuse huh, isn't there a bug about hiding "finished" ill requests?
10:11 marcelr hi magnuse
10:45 inlibro joined #koha
10:53 magnuse hiya marcelr
10:54 magnuse @wunder bodø, norway
10:54 huginn` magnuse: Error: I could not find a valid location for: bodø, norway
10:54 magnuse @wunder bodo, norway
10:54 huginn` magnuse: Error: Failed to load Wunderground API. Check the logs for more information.
11:15 khall joined #koha
11:20 oleonard joined #koha
11:21 oleonard Hi all
11:28 kidclamp welcome back oleonard
11:28 jzairo joined #koha
11:28 oleonard Thanks, it's been a nice month-long vacation
11:32 * magnuse waves to oleonard and kidclamp
11:43 calire hi oleonard
11:43 wahanui hi oleopard
11:45 inlibro joined #koha
11:52 khall joined #koha
12:17 oleonard Sorry I missed Community Day. Any thoughts on whether it was "successful?"
12:18 cait i missed it too
12:18 cait I wante dto ask people to update the wiki maybe with their projects?
12:18 cait I saw that Holly submitted some manual updates and I know catalyst ran projects the whole day
12:19 cait oleonard: coudl you help fix bug 23143 maybe?
12:19 huginn` Bug[…]_bug.cgi?id=23143 major, P5 - low, ---, koha-bugs, NEW , [18.11] Filter paid transactions not working
12:20 magnuse yeah, i was sorry to miss community day too. maybe we could have another one?
12:20 cait I'd love that
12:20 oleonard cait: I'll have to dig out of this week-high pile of emails, but I'll give it a go
12:22 cait i think it's somethign to do with a backport maybe
12:22 cait we had an issue in master too, but not sure how to resolve
12:31 khall joined #koha
12:33 khall joined #koha
12:46 inlibro joined #koha
13:03 oleonard kidclamp: I added a very small follow-up to Bug 23385
13:03 huginn` Bug[…]_bug.cgi?id=23385 enhancement, P5 - low, ---, nick, Needs Signoff , Hide default value fields by default on patron import
13:08 tcohen morning #koha
13:08 cait mornign tcohen
13:08 tcohen ashimema: did we agree to make 18.05.x require Stretch as well?
13:08 tcohen hi cait!
13:18 kidclamp oleonard++
13:30 wizzyrea joined #koha
13:31 oleonard Hi wizzyrea
13:31 caroline_catlady joined #koha
13:34 caroline_catlady Good morning everyone!
13:34 caroline_catlady It's a bright and sunny morning here in Montreal, a bit hot, but so far tolerable
13:35 caroline_catlady How's everyone?
13:38 wizzyrea good morning
13:38 wizzyrea how is everyone
13:39 khall joined #koha
13:39 oleonard I arrived at work before it got hot and I don't want to know if that has changed.
13:39 caroline_catlady Hi wizzyrea!
13:40 * cait waves
13:44 wizzyrea it was not hot when i started but that could quicklly change
13:46 inlibro joined #koha
13:50 oleonard cait: Bug 23143 patch sent
13:50 huginn` Bug[…]_bug.cgi?id=23143 major, P5 - low, ---, koha-bugs, Needs Signoff , [18.11] Filter paid transactions not working
14:04 cait thx a lot
14:14 calire left #koha
14:19 corilynn joined #koha
14:22 caroline_catlady joined #koha
14:42 oleonard Oh hey Bug 23013 still applies... Good to know...
14:42 huginn` Bug[…]_bug.cgi?id=23013 enhancement, P5 - low, ---, oleonard, Needs Signoff , Upgrade DataTables in the staff client
14:46 inlibro joined #koha
14:53 corilynn isn't there a way to see what bugs have been applied to a koha instance?
14:53 cait one of the sandboxes or your own?
14:54 corilynn sandbox
14:54 cait one of the new ones?
14:54 cait look for the git log
14:55 cait Logs > koha git log
14:55 cait the last one
14:55 wahanui the last one is pretty new
14:55 cait when martin pushes, he adds a sign-off line... so all the patches that don't have that shoudl be the ones appleid by you
14:55 cait on the one you got currently it looks like plain master
14:56 cait http://sb1.sandboxes.bywaterso[…].com/git_log/cori
14:56 corilynn yeah, it's not even letting me login
14:56 cait ah interesting
14:56 cait may i try?
14:56 corilynn please
14:56 cait ah right
14:56 cait you need a different logi/pass to run the web installer
14:56 cait i think you seleted without sample data or something
14:57 cait try koha_<nameofinstance> /password
14:57 cait that's the 'db user'
14:57 corilynn weird
14:57 corilynn i've never had that happen before
14:58 corilynn error: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/share/perl5/DBIx/ line 273.
14:58 cait oh
14:58 cait which step?
14:58 cait khall: around?
14:59 corilynn "Web installer › Set up database"
14:59 corilynn what I'd like is a post- 18.05.xx installation
15:00 cait what did you enter on setting it up? a branch?
15:00 corilynn i entered nothing
15:01 reiveune bye
15:01 reiveune left #koha
15:01 corilynn there's some thought that after 16232 that advanced cataloging doesn't load
15:02 cait I am not sure why it didn#t create the sample data as it usually does
15:02 corilynn when I put 16232 in the bug #, then the sandbox doesn't work, and if I leave it blank (current master) it has the db installation issue as above
15:03 cait maybe did you do a 'clear database' action?
15:03 corilynn i did not
15:03 cait hm
15:03 cait it might be a sandbox issue, not sure
15:04 corilynn probably
15:04 wahanui i heard probably was too hard.
15:05 alex_a corilynn, the editor loads after 16232. But it adds a undefined save backend that conflict with 18823
15:05 corilynn yes, that's what I've been saying, so you have to adjust 18823 to account for this
15:06 alex_a corilynn, you don't need to add 16232, it is already in master
15:06 corilynn ok
15:06 alex_a You are trying on a sandbox ?
15:06 corilynn i was, yes
15:06 corilynn i was trying to get "master" working on a sandbox, that had 16232 installed
15:09 kellym joined #koha
15:10 fridolin left #koha
15:11 cait bye all
15:11 cait left #koha
15:19 corilynn ugh,
15:20 corilynn i have a 19.05 version that won't load the advanced cataloging editor at all
15:20 corilynn Uncaught ReferenceError: insert_copyright is not defined
15:20 corilynn at marc-editor.js:140
15:20 corilynn at Object.execCb (require_19.0502000.js:29)
15:20 corilynn at X.check (require_19.0502000.js:18)
15:20 corilynn at X.<anonymous> (require_19.0502000.js:23)
15:20 corilynn at require_19.0502000.js:8
15:20 corilynn at require_19.0502000.js:23
15:20 corilynn at y (require_19.0502000.js:7)
15:20 corilynn at X.emit (require_19.0502000.js:23)
15:20 corilynn at X.check (require_19.0502000.js:19)
15:20 corilynn at X.<anonymous> (require_19.0502000.js:23)
15:26 kidclamp check the keyboard shortcuts table, is it there?
15:26 kidclamp did the database get updated?
15:27 corilynn did the database get updated when?
15:27 kidclamp when upgraed to 19.05?
15:27 corilynn i created a new 19.05
15:27 corilynn i didn't upgrade
15:28 kidclamp it should be intserted with manadatory data in 19.05
15:28 corilynn ok, i didn't uncheck anything
15:28 kidclamp SELECT * FROM keyboard_shortcuts
15:30 caroline_catlady joined #koha
15:30 corilynn empty set
15:30 corilynn (kidclamp)
15:33 kellym joined #koha
15:34 kidclamp yeah, that's bad
15:34 corilynn i created a bug
15:35 corilynn bug 23396
15:35 huginn` Bug[…]_bug.cgi?id=23396 major, P5 - low, ---, koha-bugs, NEW , Rancor fails to load: insert_copyright is not defined
15:43 laurence left #koha
15:44 corilynn also, kidclamp, I don't know if you saw this, but the Sandboxes appear to be broken as well :(
15:44 corilynn
15:46 inlibro joined #koha
15:50 kellym_ joined #koha
15:53 kellym_ left #koha
16:13 tcohen has anyone used Test::NoWarnings
16:16 cait joined #koha
16:46 inlibro joined #koha
17:37 corilynn oleonard, can you point me to a script to populate the missing data for 19.05?
17:40 oleonard[…]1faca3fa7;hb=HEAD
17:41 corilynn thanks, man
17:41 oleonard ...I assume, based on your conversation with kidclamp
17:41 corilynn you also updated the bug
17:41 kidclamp yeah, we are just missing that script listed in C4/Installer
17:41 kidclamp I had, incorrectly, assumed we just grabbed anything in that dir
17:41 kellym joined #koha
17:46 inlibro joined #koha
18:02 cait joined #koha
18:47 inlibro joined #koha
18:59 oleonard See y'all later
19:09 lukeG joined #koha
19:11 caroline_catlady corilynn: are you a cataloguing expert?
19:11 corilynn ummm "expert" is a interesting word
19:11 corilynn I know a lot of cataloging stuff
19:12 caroline_catlady hehe! I was just wondering if you knew if there was a marc field to indicate that a serial is not published anymore
19:12 caroline_catlady I've been looking in 3XX and 5XX and not finding anything
19:12 corilynn i thought it was in the leader
19:13 caroline_catlady so there is not free text field?
19:13 corilynn there should be... but I haven't done serials since my internship
19:14 caroline_catlady ok thanks, I'll keep looking
19:17 corilynn weird, the documentation for 260 has stuff about the end date, but not 264
19:17 corilynn (search "For serials" under the $c subfield)
19:19 caroline_catlady I think it's 362 from the examples I see in my RDA book
19:19 corilynn yup, that looks right!
19:20 corilynn "If the serial is complete, use subfield Ç‚a for the designation of the first issue followed by the designation of the last issue."
19:20 corilynn so glad I don't do serials :)
19:21 caroline_catlady The info I have to work with is only like "closed" or "some issues available on the Internet"
19:21 caroline_catlady I guess I'll put them in 362$a and hope it's ok
19:25 caroline_catlady thanks for your help!
19:32 corilynn np
19:33 corilynn I'm getting errors for "Stage MARC for import" can anyone point me to the directions for using the non-gui tool?
19:34 caroline_catlady its misc/migration_tools/bulk_marc_import
19:34 corilynn right, but are there, like, instructions?
19:35 caroline_catlady oh, can you open the script? The parameters are kind of explained
19:35 corilynn i'm looking for it
19:36 lukeG1 joined #koha
19:37 caroline_catlady do you want me to copy it for you?
19:37 corilynn where should i look for misc?
19:38 corilynn i can't find it in /etc/koha
19:38 caroline_catlady uh, I don't think my structure is the same, but it's right at the root (where there's C4 and koha-tmpl, etc)
19:40 caroline_catlady and the name is (no underscore)
19:41 corilynn AH! that made the find find it ;)
19:41 corilynn thx
19:42 caroline_catlady yeah, sorry! I always write bulk and then hit tab, so I didn't know the rest ;/
19:45 corilynn well, that seems to be working ;)
19:45 corilynn thanks, caroline_catlady!
19:47 inlibro joined #koha
20:01 Templeton joined #koha
20:04 Templeton Hello, I have recently started tracking Local Use in my library. I would like to pull a report from KOHA circulation about which books have been logged as "Local Use". I have already set the Global Preferences in the Administration to "Record" Local Use, but the reports I have tried to create via the "Guided Report" option have not resulted with the data I want, or the book that I just checked in via Local Use is not appearing. Could you please help me?
20:05 caroline_catlady Hi Templeton! Could you copy the SQL query that the guided report gave you here
20:05 caroline_catlady I'll take a look
20:06 Templeton Thank you!
20:06 Templeton SELECT  items.barcode,items.datelastseen,items.location FROM borrowers LEFT JOIN statistics on (statistics.borrowernumber​=borrowers.borrowernumber) LEFT JOIN items on (items.itemnumber = statistics.itemnumber) LEFT JOIN biblioitems on (biblioitems.biblioitemnumber = items.biblioitemnumber)   WHERE items.itype=<<itype|itemtypes>> AND statistics.type='localuse'
20:07 Templeton I would like it to produce a spreadsheet of barcodes and call numbers that have been logged in Local Use. I'm not familiar enough with this system to do this. I appreciate your help!
20:07 cait i think local use is recorded in statitics or action logs
20:08 caroline_catlady yeah it's in statistics
20:08 cait caroline_catlady++
20:08 caroline_catlady The guided reports make such messy queries...
20:08 cait yeah i usually tend to start over
20:09 rangi i would like to remove the guided reports bit entirely
20:10 rangi and I wrote the horrible mess that it is
20:10 rangi (under protest I might add)
20:10 cait heh
20:10 cait one issue is it adds more tables than you need, so usually a cleaned up one is faster on big db
20:10 Templeton That's good to know. So, if I were to re-create this, which statistics column should I select? Would it fall under "Type of Procedure" or something else?
20:12 pastebot "caroline_catlady" at pasted "Templeton, can you try this?" (1 line) at
20:12 cait this one from the wiki looks interesting too https://wiki.koha-community.or[…]L_Reports_Library
20:12 cait hm seearch for local use
20:13 cait hm and some more here: https://wiki.koha-community.or[…]ulation#Local_Use
20:13 Templeton Caroline_catlady - That worked! Thank you so much! What did you do?
20:13 caroline_catlady I just cleaned it up a bit. It was using the borrowers table for an obscure reason
20:14 caroline_catlady you only needed the statistics table and the items table for the barcode and callnumber info
20:14 Templeton Oh, I see. That makes more sense.
20:14 Templeton Thank you for all your help! Have a good day everyone!
20:14 cait caroline_catlady++ again
20:14 caroline_catlady glad it worked :)
20:38 lukeG joined #koha
20:43 khall joined #koha
20:47 inlibro joined #koha
21:03 alexbuckley joined #koha
21:47 inlibro joined #koha
21:59 lukeG1 joined #koha
22:47 inlibro joined #koha
22:53 caroline_catlady good night!
23:02 papa joined #koha
23:16 lukeG joined #koha
23:48 inlibro joined #koha
23:52 jzairo joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary