Time  Nick             Message
22:53 caroline_catlady good night!
20:14 caroline_catlady glad it worked :)
20:14 cait             caroline_catlady++ again
20:14 Templeton        Thank you for all your help! Have a good day everyone!
20:14 Templeton        Oh, I see. That makes more sense.
20:14 caroline_catlady you only needed the statistics table and the items table for the barcode and callnumber info
20:13 caroline_catlady I just cleaned it up a bit. It was using the borrowers table for an obscure reason
20:13 Templeton        Caroline_catlady - That worked! Thank you so much! What did you do?
20:13 cait             hm and some more here: https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Local_Use
20:12 cait             hm seearch for local use
20:12 cait             this one from the wiki looks interesting too https://wiki.koha-community.org/wiki/SQL_Reports_Library
20:12 pastebot         "caroline_catlady" at 127.0.0.1 pasted "Templeton, can you try this?" (1 line) at http://paste.koha-community.org/3438
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: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 cait             heh
20:10 rangi            (under protest I might add)
20:10 rangi            and I wrote the horrible mess that it is
20:09 rangi            i would like to remove the guided reports bit entirely
20:08 cait             yeah i usually tend to start over
20:08 caroline_catlady The guided reports make such messy queries...
20:08 cait             caroline_catlady++
20:08 caroline_catlady yeah it's in statistics
20:07 cait             i think local use is recorded in statitics or action logs
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: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:06 Templeton        Thank you!
20:05 caroline_catlady I'll take a look
20:05 caroline_catlady Hi Templeton! Could you copy the SQL query that the guided report gave you here http://paste.koha-community.org/
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?
19:45 corilynn         thanks, caroline_catlady!
19:45 corilynn         well, that seems to be working ;)
19:42 caroline_catlady yeah, sorry! I always write bulk and then hit tab, so I didn't know the rest ;/
19:41 corilynn         thx
19:41 corilynn         AH! that made the find find it ;)
19:40 caroline_catlady and the name is bulkmarcimport.pl (no underscore)
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:38 corilynn         i can't find it in /etc/koha
19:37 corilynn         where should i look for misc?
19:37 caroline_catlady do you want me to copy it for you?
19:35 corilynn         i'm looking for it
19:35 caroline_catlady oh, can you open the script? The parameters are kind of explained
19:34 corilynn         right, but are there, like, instructions?
19:34 caroline_catlady its misc/migration_tools/bulk_marc_import
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:32 corilynn         np
19:25 caroline_catlady thanks for your help!
19:21 caroline_catlady I guess I'll put them in 362$a and hope it's ok
19:21 caroline_catlady The info I have to work with is only like "closed" or "some issues available on the Internet"
19:20 corilynn         so glad I don't do serials :)
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:19 corilynn         yup, that looks right!
19:19 caroline_catlady I think it's 362 from the examples I see in my RDA book
19:17 corilynn         https://www.loc.gov/marc/bibliographic/bd260.html (search "For serials" under the $c subfield)
19:17 corilynn         weird, the documentation for 260 has stuff about the end date, but not 264
19:14 caroline_catlady ok thanks, I'll keep looking
19:13 corilynn         there should be... but I haven't done serials since my internship
19:13 caroline_catlady so there is not free text field?
19:12 corilynn         i thought it was in the leader
19:12 caroline_catlady I've been looking in 3XX and 5XX and not finding anything
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:11 corilynn         I know a lot of cataloging stuff
19:11 corilynn         ummm "expert" is a interesting word
19:11 caroline_catlady corilynn: are you a cataloguing expert?
18:59 oleonard         See y'all later
17:41 kidclamp         I had, incorrectly, assumed we just grabbed anything in that dir
17:41 kidclamp         yeah, we are just missing that script listed in C4/Installer
17:41 corilynn         you also updated the bug
17:41 oleonard         ...I assume, based on your conversation with kidclamp
17:41 corilynn         thanks, man
17:40 oleonard         http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/mandatory/keyboard_shortcuts.sql;h=604fc6ff94f97964123a56293102a6c1faca3fa7;hb=HEAD
17:37 corilynn         oleonard, can you point me to a script to populate the missing data for 19.05?
16:13 tcohen           has anyone used Test::NoWarnings
15:44 corilynn         http://sb1.sandboxes.bywatersolutions.com/
15:44 corilynn         also, kidclamp, I don't know if you saw this, but the Sandboxes appear to be broken as well :(
15:35 huginn`          Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23396 major, P5 - low, ---, koha-bugs, NEW , Rancor fails to load: insert_copyright is not defined
15:35 corilynn         bug 23396
15:34 corilynn         i created a bug
15:34 kidclamp         yeah, that's bad
15:30 corilynn         (kidclamp)
15:30 corilynn         empty set
15:28 kidclamp         SELECT * FROM keyboard_shortcuts
15:28 corilynn         ok, i didn't uncheck anything
15:28 kidclamp         it should be intserted with manadatory data in 19.05
15:27 corilynn         i didn't upgrade
15:27 corilynn         i created a new 19.05
15:27 kidclamp         when upgraed to 19.05?
15:27 corilynn         did the database get updated when?
15:26 kidclamp         did the database get updated?
15:26 kidclamp         check the keyboard shortcuts table, is it there?
15:20 corilynn         at X.<anonymous> (require_19.0502000.js:23)
15:20 corilynn         at X.check (require_19.0502000.js:19)
15:20 corilynn         at X.emit (require_19.0502000.js:23)
15:20 corilynn         at y (require_19.0502000.js:7)
15:20 corilynn         at require_19.0502000.js:23
15:20 corilynn         at require_19.0502000.js:8
15:20 corilynn         at X.<anonymous> (require_19.0502000.js:23)
15:20 corilynn         at X.check (require_19.0502000.js:18)
15:20 corilynn         at Object.execCb (require_19.0502000.js:29)
15:20 corilynn         at marc-editor.js:140
15:20 corilynn         Uncaught ReferenceError: insert_copyright is not defined
15:20 corilynn         i have a 19.05 version that won't load the advanced cataloging editor at all
15:19 corilynn         ugh,
15:11 cait             bye all
15:06 corilynn         i was trying to get "master" working on a sandbox, that had 16232 installed
15:06 corilynn         i was, yes
15:06 alex_a           You are trying on a sandbox ?
15:06 corilynn         ok
15:06 alex_a           corilynn, you don't need to add 16232, it is already in master
15:05 corilynn         yes, that's what I've been saying, so you have to adjust 18823 to account for this
15:05 alex_a           corilynn, the editor loads after 16232. But it adds a undefined save backend that conflict with 18823
15:04 wahanui          i heard probably was too hard.
15:04 corilynn         probably
15:03 cait             it might be a sandbox issue, not sure
15:03 cait             hm
15:03 corilynn         i did not
15:03 cait             maybe did you do a 'clear database' action?
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:02 cait             I am not sure why it didn#t create the sample data as it usually does
15:01 corilynn         there's some thought that after 16232 that advanced cataloging doesn't load
15:01 reiveune         bye
15:00 corilynn         i entered nothing
15:00 cait             what did you enter on setting it up? a branch?
14:59 corilynn         what I'd like is a post- 18.05.xx installation
14:59 corilynn         "Web installer › Set up database"
14:58 cait             khall: around?
14:58 cait             which step?
14:58 cait             oh
14:58 corilynn         error: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' bytes at /usr/share/perl5/DBIx/RunSQL.pm line 273.
14:57 corilynn         i've never had that happen before
14:57 corilynn         weird
14:57 cait             that's the 'db user'
14:57 cait             try koha_<nameofinstance> /password
14:56 cait             i think you seleted without sample data or something
14:56 cait             you need a different logi/pass to run the web installer
14:56 cait             ah right
14:56 corilynn         please
14:56 cait             may i try?
14:56 cait             ah interesting
14:56 corilynn         yeah, it's not even letting me login
14:56 cait             http://sb1.sandboxes.bywatersolutions.com/git_log/cori
14:55 cait             on the one you got currently it looks like plain master
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 wahanui          the last one is pretty new
14:55 cait             the last one
14:55 cait             Logs > koha git log
14:54 cait             look for the git log
14:54 cait             one of the new ones?
14:54 corilynn         sandbox
14:53 cait             one of the sandboxes or your own?
14:53 corilynn         isn't there a way to see what bugs have been applied to a koha instance?
14:42 huginn`          Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23013 enhancement, P5 - low, ---, oleonard, Needs Signoff , Upgrade DataTables in the staff client
14:42 oleonard         Oh hey Bug 23013 still applies... Good to know...
14:04 cait             thx a lot
13:50 huginn`          Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23143 major, P5 - low, ---, koha-bugs, Needs Signoff , [18.11] Filter paid transactions not working
13:50 oleonard         cait: Bug 23143 patch sent
13:44 wizzyrea         it was not hot when i started but that could quicklly change
13:40 * cait           waves
13:39 caroline_catlady Hi wizzyrea!
13:39 oleonard         I arrived at work before it got hot and I don't want to know if that has changed.
13:38 wizzyrea         how is everyone
13:38 wizzyrea         good morning
13:35 caroline_catlady How's everyone?
13:34 caroline_catlady It's a bright and sunny morning here in Montreal, a bit hot, but so far tolerable
13:34 caroline_catlady Good morning everyone!
13:31 oleonard         Hi wizzyrea
13:18 kidclamp         oleonard++
13:08 tcohen           hi cait!
13:08 tcohen           ashimema: did we agree to make 18.05.x require Stretch as well?
13:08 cait             mornign tcohen
13:08 tcohen           morning #koha
13:03 huginn`          Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23385 enhancement, P5 - low, ---, nick, Needs Signoff , Hide default value fields by default on patron import
13:03 oleonard         kidclamp: I added a very small follow-up to Bug 23385
12:22 cait             we had an issue in master too, but not sure how to resolve
12:22 cait             i think it's somethign to do with a backport maybe
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:20 cait             I'd love that
12:20 magnuse          yeah, i was sorry to miss community day too. maybe we could have another one?
12:19 huginn`          Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23143 major, P5 - low, ---, koha-bugs, NEW , [18.11] Filter paid transactions not working
12:19 cait             oleonard: coudl you help fix bug 23143 maybe?
12:18 cait             I saw that Holly submitted some manual updates and I know catalyst ran projects the whole day
12:18 cait             I wante dto ask people to update the wiki maybe with their projects?
12:18 cait             i missed it too
12:17 oleonard         Sorry I missed Community Day. Any thoughts on whether it was "successful?"
11:43 wahanui          hi oleopard
11:43 calire           hi oleonard
11:32 * magnuse        waves to oleonard and kidclamp
11:28 oleonard         Thanks, it's been a nice month-long vacation
11:28 kidclamp         welcome back oleonard
11:21 oleonard         Hi all
10:54 huginn`          magnuse: Error: Failed to load Wunderground API. Check the logs for more information.
10:54 magnuse          @wunder bodo, norway
10:54 huginn`          magnuse: Error: I could not find a valid location for: bodø, norway
10:54 magnuse          @wunder bodø, norway
10:53 magnuse          hiya marcelr
10:11 marcelr          hi magnuse
09:59 magnuse          huh, isn't there a bug about hiding "finished" ill requests?
09:43 * magnuse        tries to get back in the groove after 5 weeks off
09:43 magnuse          hiya #koha!
08:45 vfernandes       hi #koha
07:16 marcelr          o/
07:14 cait             hi marcelr
07:11 marcelr          hi #koha
06:56 alex_a           bonjour
06:37 reiveune         hello
06:30 cait             hi #koha
06:30 cait             hi #kolha
06:05 fridolin         hi