Time  Nick            Message
04:52 taa             we wish to import bound volumes excel data in koha how to map multiple records with one biblio
04:52 taa             especially vol, no, acc no
05:06 Oak             Ahoy me hearties!
05:12 magnuse         Oak
05:13 magnuse         bonjour paul_p
05:45 * cait          waves
05:46 * magnuse       waves back
05:54 mveron          Good morning / daytime #koha
06:00 Oak             magnuse
06:00 Oak             hello cait, #koha!
06:03 jajm            hello
06:03 wahanui         what's up, jajm
06:15 * LibraryClaire waves
06:49 fridolin        hie
06:54 gaetan_B        hello
06:56 reiveune        hello
06:56 wahanui         salut, reiveune
07:01 alex_a          bonjour
07:05 drojf           morning #koha
07:07 * LibraryClaire waves to everyone
07:35 brinxmat        Hey folks
07:35 brinxmat        From sunny Oslo
07:36 drojf           hi brinxmat
07:36 drojf           @wunder berlin, germany
07:36 huginn`         drojf: The current temperature in Berlin Tegel, Germany is 16.0°C (9:20 AM CEST on June 14, 2016). Conditions: Mostly Cloudy. Humidity: 82%. Dew Point: 13.0°C. Pressure: 29.53 in 1000 hPa (Steady).
07:36 drojf           from that :/
07:36 brinxmat        @wunder oslo, norway
07:36 huginn`         brinxmat: The current temperature in Oslo Airport, Norway is 17.0°C (9:20 AM CEST on June 14, 2016). Conditions: Clear. Humidity: 42%. Dew Point: 4.0°C. Pressure: 29.68 in 1005 hPa (Steady).
07:36 * liw           waves from a boat in the Helsinki archipelago (4G is a bit weak, but if you see it, it works)
07:37 drojf           hi liw
07:37 * drojf         wants to be on a boat
07:37 brinxmat        Wondering if anyone can help me with a problem we're having with setting hard cap for fines per patron
07:40 drojf           what is the problem? did you try MaxFine?
07:41 brinxmat        drojf: yes, we set 100 in this
07:43 brinxmat        I wonder if our setting for the smart rule for adults is causing the issue
07:46 brinxmat        All material types, fine 50, interval 3, grace 0, fine cap 100
07:47 brinxmat        May even be how we're testing this (setting the return date to x minutes after it has been borrowed)
08:12 magnuse         brinxmat: how is it not working for you?
08:16 brinxmat        magnuse: it may just be the way we're testing — the maxfine is not observed
08:19 drojf           brinxmat: do you run the cronjobs manually then?
08:21 brinxmat        drojf: they're set to run every minute
08:38 atheia          G'morn :-)
08:43 LibraryClaire   morning atheia :)
08:56 ashimema        mornin' #koha
08:58 LibraryClaire   hey ashimema!
08:58 wahanui         somebody said ashimema was on qa now .)
09:04 * atheia        waves at ashimema
09:06 Joubu           ashimema: good to know you are on qa now :p
09:08 ashimema        lol
09:12 LibraryClaire   hi Joubu! :)
09:12 Joubu           hi LibraryClaire
09:14 * LibraryClaire needs coffee...
11:05 magnuse         wow, all those db tables related to massaging is kind of confusing...
11:05 magnuse         anyone got a clue how i would go about finding that one person who wants DUEDGST sent via sms?
11:11 liw             @wunder helsinki
11:11 huginn`         liw: The current temperature in Helsinki, Finland is 19.0°C (1:50 PM EEST on June 14, 2016). Conditions: Clear. Humidity: 40%. Dew Point: 5.0°C. Pressure: 29.77 in 1008 hPa (Steady).
11:15 magnuse         @wunder boo
11:15 huginn`         magnuse: The current temperature in Bodo, Norway is 10.0°C (12:50 PM CEST on June 14, 2016). Conditions: Scattered Clouds. Humidity: 71%. Dew Point: 5.0°C. Pressure: 29.77 in 1008 hPa (Steady).
11:16 LibraryClaire   @wunder LCY
11:16 huginn`         LibraryClaire: The current temperature in London City, United Kingdom is 17.0°C (11:50 AM BST on June 14, 2016). Conditions: Mostly Cloudy. Humidity: 77%. Dew Point: 13.0°C. Pressure: 29.42 in 996 hPa (Steady).
11:17 LibraryClaire   mostly cloudy = raining and wet
11:49 oleonard        Hi #koha
11:49 magnuse         hi oleonard
11:50 LibraryClaire   Hi oleonard
12:06 vfernandes      hi #koha
12:07 vfernandes      one strange problem: after updating one koha from 3.12 to 3.22.06 the fines calculation is very slowing
12:07 vfernandes      * is very slow
12:08 vfernandes      also when returning an item with fines the operation is also very slow
12:09 vfernandes      there is any reason to that?
12:15 kidclamp        do you have many special holidays?
12:16 kidclamp        unique holidays vfernandes? (special_holidays is the db table name)
12:22 cait            hm yeah holidays could make a difference
12:22 cait            also dates far int he future or far in the past
13:16 vfernandes      kidclamp: some holidays
13:17 vfernandes      but the fines script is running for about 1 hour and it didn't even finished
13:21 kidclamp        vfernandes I think pianohacker has seen this and worked on some imrpovement, but I don't know the details. eh should be in later
13:21 vfernandes      kidclamp: i found out what the problem is
13:21 kidclamp        what was it?
13:22 vfernandes      debarred was being set to '9999-12-31' in the older version
13:22 kidclamp        :-)
13:22 kidclamp        or rather :-(
13:22 vfernandes      by some reason the date calculation between now and that date takes many time...
13:25 vfernandes      but in the new version is also set to that date
13:32 tcohen          bonjour
13:33 tcohen          Joubu: around?
13:39 vfernandes      the time calculating the days between a date in 2014 and now is huge....
13:39 vfernandes      get_chargeable_units takes a long time
13:40 cait            vfernandes: have you defined a maxfine?
13:40 vfernandes      no
13:40 vfernandes      there is no maxfine
13:40 tcohen          hi cait
13:42 tcohen          i've received two reports from 3.22 users, about zebra "dying" every day
13:42 tcohen          but the logs make me think it i srelated to log rotation, because zebrasrv is gettting a signal 15
13:42 vfernandes      after some tests the problem is in days_between of Koha::Calendar
13:44 cait            hm did we change that?
13:49 vfernandes      cait: the problem is that for every day between 2011 and 2016 the calendar checks if is a holiday
13:49 vfernandes      and that is super slow!!!!
13:51 drojf           tcohen: i have heard one saying mysql keeps dying. when i checked their zebra was dead too. but not my clients, no server access, can't look into it
13:52 kidclamp        tcohen - maybe ping larryb when he gets in, I think we have seen similar
13:53 tcohen          drojf: i experienced that too
13:53 drojf           it's 3.22 and the problem seems to be relatively new
13:53 drojf           they also reported high cpu load
13:53 tcohen          i mitigated it by banning bots, but didn't have the time to dig into it
13:54 tcohen          jajm: around?
13:54 jajm            tcohen, yep, hi!
13:58 vfernandes      this is a problem with cache
13:58 vfernandes      cait: do you use cache on your system?
14:00 drojf           tcohen: if bots manage to bring it down, we might have a problem :P
14:01 tcohen          drojf: sure
14:01 tcohen          jajm: users are reporting that zebra "started dying every day" (logrotate?) and mysql dies (memory leak or smth?)
14:02 tcohen          it seems to be recent
14:02 tcohen          something changed recently and introduced it
14:02 tcohen          talking about 3.22
14:07 jajm            tcohen, users of 3.22.7 ?
14:08 cait            vfernandes:  not yet, but we only have a few quite small 3.22 so far
14:10 vfernandes      thanks cait
14:12 vfernandes      how can I set Koha cache?
14:13 tcohen          jajm: that's my scenario at least, drojf and kidclamp mentioned they had some too, not sure the specifics
14:15 kidclamp        3.22.06 on the site I know of, usually is plack that goes down, but sometimes zebra, and a diffsite was having just zebra, but I don't know htose detai;s
14:15 drojf           i assume it started before 3.22.7 for the library that told me. 3.22.6ish maybe
14:18 vfernandes      Koha::Calendar for each overdue day is doing a query to the database...
14:21 kidclamp        vfernandes that is what pianohacker had to do I think, make calendar use cache, but I don't know bugnumbers
14:23 pastebot        "vfernandes" at pasted "Koha::Calendar single holidays" (52 lines) at http://paste.koha-community.org/20
14:24 vfernandes      kidclamp: checking the code, Koha::Calendar uses cache
14:27 kidclamp        yeah, I don't knwo details it just sounds very similar
14:27 vfernandes      Koha shouldn't have a default cache service when memcached of fastmmap aren't set?
14:38 oleonard        Anyone around who is using EDIFACT?
14:38 oleonard        Whoops, never mind I am not here.
14:40 cait            oh
14:40 cait            a oleonard-away ghost
14:54 oleonard        Hi cait
14:56 tcohen          hi oleonard
14:57 drojf           [off] oleonard:  when i asked the spammers to take me from their list, they said "since we met at KohaCon, we sent you a follow up newsletter. We are not going to send you anything else."
14:57 drojf           [off] "met" as in "we were in the same building" i guess, i have no idea who they are and don't think italked to anyone of them
14:58 oleonard        I thought I remembered there being a discussion before previous KohaCons about what was okay for sponsors to do, i.e. don't spam anyone.
14:58 oleonard        We should probably make sure it's an official part of the process.
15:00 drojf           yes. i did not expect anything like that to happen. and there were a lot of other sponsors that did not do that (luckily)
15:01 drojf           the argumentation is… funny at least
15:06 gaetan_B        bye
15:06 drojf           hi rocio
15:06 Joubu           oleonard: How the 2 lines you modified in your last patch of bug 6148 are useful?
15:06 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6148 enhancement, P5 - low, ---, oleonard, CLOSED FIXED, Strange Language in opac-authorities-home
15:07 Joubu           +    window.modaction_legend_innerhtml = $("#modaction_legend").text();
15:07 Joubu           +    window.action_submit_value = $("#action_submit").text()
15:07 Joubu           What do they do?
15:07 rocio           morning!
15:07 oleonard        Joubu: Using jQuery instead of document.getElementById() avoids an error if the element doesn't exist
15:08 drojf           i would appreciate if irc could show the local time of everyone
15:08 Joubu           oleonard: yep, but what do they do? :)
15:09 rocio           that would be nice
15:09 drojf           oleonard should do a jquery workshop in marseille :P
15:09 oleonard        Joubu: The variables are used to change the legend/button text of the add/edit form
15:10 oleonard        Joubu: The form is reused for multiple actions, and the JS populates the values in it
15:12 Joubu           oleonard: ok got it. All this code looks uselessly complicated
15:13 Joubu           oleonard: the change does not work
15:13 LibraryClaire   hi rocio :)
15:13 oleonard        Joubu: :( Okay, back to the drawing board.
15:13 rocio           hey LibraryClaire!
15:13 wahanui         i think libraryclaire is the monster under my bed
15:13 Joubu           oleonard: clicking on "new action" will show the form but the submit button does not have any text
15:13 drojf           hehe wahanui is not dropping that :P
15:15 Joubu           oleonard: ha, the second line should be .val() instead of .text()
15:15 * oleonard      should just go mow the lawn instead
15:17 drojf           oleonard: i bet jquery can do that for you
15:21 Joubu           Did anybody upgrade from 3.22 to 16.05 using the packages?
15:22 Joubu           2 different guys got the same error about the DB schema, that's odd
15:23 cait            Joubu: didn't try
15:24 drojf           Joubu: i upgraded my test instances (>20 on one server) and did not have a problem afair
15:24 oleonard        I'll ask again now that I'm really here:  Is anyone around who is using EDIFACT?
15:24 drojf           but that is still running on wheezy, maybe that is related?
15:24 Joubu           drojf: ok thanks
15:24 drojf           s/related/important/
15:25 oleonard        I keep trying to look at the EDIFACT messages template, but I don't really understand how it is used.
15:25 cait            oleonard: maybe khall could help or bag
15:25 vfernandes      cait and kidclamp: I solved my problem
15:25 cait            i didn't test it, but i know they shoudl ahve :)
15:25 cait            vfernandes: yay
15:25 cait            what was it?
15:26 khall           oleonard: what's up?
15:26 khall           which template file?
15:26 cait            i summoned a khall!
15:26 khall           lol
15:26 khall           true ; )
15:27 oleonard        Hi khall. I'm trying to do some cleanup on edifactmsgs.tt but I'm not really sure how it is used. Right now I'm just inserting random data into the db so something shows up.
15:27 vfernandes      by some reason in Koha 3.22.06, Koha::Cache is using the nocache attribute on method can_load for Memory::Cache perl module
15:27 vfernandes      this line:     if ( can_load( modules => { 'Cache::Memory' => undef, nocache => 1 } ) ) {
15:27 vfernandes      should be:     if ( can_load( modules => { 'Cache::Memory' => undef } ) ) {
15:27 oleonard        khall: Maybe random is fine, but I thought I'd ask if someone had examples of real data.
15:28 oleonard        khall: I'm interested in particular in what kind of "message" one might see.
15:28 Joubu           vfernandes: yes, it's fixed
15:28 Joubu           on master
15:28 khall           oleonard: one sec
15:28 oleonard        It's weird that messages are displayed all by themselves on a separate full page.
15:28 oleonard        Seems like a modal would be a good solution for that.
15:29 vfernandes      Joubu: yes, i've checked master to see if the bug was there
15:29 vfernandes      kidclamp++ cait++ Joubu++
15:29 vfernandes      thanks for the help
15:30 khall           oleonard: http://content.screencast.com/users/kylemhall/folders/Jing/media/60cdcc31-0535-4179-bd3d-f215577c0a64/00000017.png
15:30 khall           does that help?
15:31 cait            khall: do you know if nengard is writing up soemthing about how to use edifact?
15:31 oleonard        Yes, thanks khall. I suppose the data in "type" and "status" columns is untranslatable
15:31 cait            i got not much of an idea right now too
15:32 cait            hm status would be nice if we could made it translatable
15:32 khall           cait: not sure, I know she can though
15:32 khall           status "should" be translatable
15:32 oleonard        khall: Could you show me a couple examples of what the "view message" link shows?
15:32 khall           the value is created by Koha, not the user
15:32 cait            so we can do order and receivenow with edifact - is taht a good summary?
15:32 khall           oleonard: sure!
15:33 cait            do you order form the vendor site and it's imported or does koha create the order and sends it to the vendor somehow?
15:33 khall           oleonard: http://content.screencast.com/users/kylemhall/folders/Jing/media/1492bbba-d91d-4014-b418-60f4e47dd87e/00000018.png
15:34 khall           that's about as readable as edifact gets
15:34 khall           I'm not sure how we could improve it, I guess the bullet points aren't really necessary
15:34 oleonard        khall: Do you know why a human would want to read that?
15:34 cait            hm maybe the lined display we have in some other spots?
15:34 drojf           @later tell nengard when looking at 15929 i found that the syspref MaxSearchResultsItemsPerRecordStatusCheck is not documented in the manual (or at least i could not find it), could you have a look please?
15:34 huginn`         drojf: The operation succeeded.
15:34 khall           humans shoudl not, reading edifact causes brain damange
15:34 cait            might look a little nicer
15:35 cait            or similar to the marc view plain text
15:35 khall           which explains alot about me
15:35 oleonard        cait: I was thinking of the marc view plain text as well
15:35 * cait          sends khall cookies
15:35 khall           ; )
15:36 cait            khall: did you see my question above about where the ordering happens?
15:36 oleonard        khall: I'll submit a patch and hopefully you can test and make sure my changes make sense with real data :)
15:36 khall           excellent! can do!
15:36 khall           cait: I don't think so, what was it?
15:36 cait            (17:33:10) cait: do you order form the vendor site and it's imported or does koha create the order and sends it to the vendor somehow?
15:36 cait            :)
15:39 khall           cait, here's the basic process:
15:40 khall           1) Create a basket of stuff on the vendor site
15:40 khall           2) Download the marc order file that gets created
15:40 khall           3) In Koha, stage that order marc file
15:40 khall           4) Create a basket for the vendor for that order
15:41 khall           5) Import from staged file
15:41 khall           6) Hit the send edifact order button
15:41 khall           that are other workflows, but they don't really work with Koha yet.
15:41 nengard         I need to get that in to the manual - It's on my list
15:42 cait            ah
15:43 cait            but the invoices are get in automatically?
15:43 cait            or do youneed to do something there as well?
15:59 Joubu           khall: the schema is not up-to-date, borrowers.updated_on is not there
16:00 khall           Joubu: ack! I'll take a look at fixing that!
16:05 mveron-away     Hi again #koha
16:06 mveron          @wunder Allschwil
16:06 huginn`         mveron: The current temperature in Basel, Switzerland is 16.0°C (6:00 PM CEST on June 14, 2016). Conditions: Mostly Cloudy. Humidity: 77%. Dew Point: 12.0°C. Pressure: 29.65 in 1004 hPa (Steady).
16:06 drojf           hi mveron
16:06 mveron          hi drojf
16:09 oleonard        @wunder 45701
16:09 huginn`         oleonard: The current temperature in Longview Hts, Athens, Ohio is 31.0°C (12:09 PM EDT on June 14, 2016). Conditions: Clear. Humidity: 35%. Dew Point: 14.0°C. Pressure: 30.00 in 1016 hPa (Steady).
16:12 reiveune        bye
16:28 Shane-S         I have version 3.20.02 and I wanted to do an update this summer. However, I have done many and it seems to slowly be an issue. So, I thought I would spin up a new VM and then migrate. Can I do 3.20 ->16.05 with the sql backups?
16:30 drojf           what is an issue?
16:30 wahanui         well, an issue is more like "what information do I want to show on jcamins's screenshot." :P
16:33 vfernandes      why community decided to call koha 16.05 and not koha 3.24? :)
16:33 nengard         Year.Month
16:33 nengard         cause we'd be on 3.x forever otherwise :)
16:34 vfernandes      nengard: so the following releases will be 16.06 and so on?
16:34 nengard         no
16:35 nengard         the next will be 16.11 (Nov 2016)
16:35 nengard         and then 17.05
16:35 nengard         et cetc
16:35 vfernandes      16.05.01, 16.05.02 for minor changes and bugs?
16:36 nengard         Yes
16:36 nengard         I believe so
16:36 nengard         bag can confirm
16:36 vfernandes      thanks nengard for the explaination
16:43 huginn`         New commit(s) kohagit: Bug 10459 - Update Schema <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=42cd9ca1447f4d576d9f1ad51e275e70c8bf9249>
16:44 bag             yes that is correct
16:51 eythian         drojf: CTCP TIME
16:53 eythian         drojf: doesn't seem to work for you, maybe your client is terrible.
16:53 pianohacker     well huh
16:53 drojf           its pidgin, so yes
16:54 drojf           hi pianohacker
16:54 pianohacker     hi drojf !
16:55 pianohacker     recovered from that crazy jetlag yet?
16:55 eythian         pianohacker: his client responded in GMT so I assume not
16:56 drojf           got an excellent cold, all is laggy ;)
16:57 drojf           eythian: GMT is not so far off :D
16:57 LibraryClaire   evening
16:57 eythian         Two hours.
16:58 drojf           wow i hate excel
16:58 eythian         That's natural
16:58 drojf           yes
16:58 LibraryClaire   lol
16:58 eythian         It costs the global economy trillions
16:58 eythian         Per year, due to errors
16:58 drojf           hehe
16:58 eythian         Because you can't unit test a spreadsheet
16:58 liw             yes you can
16:59 liw             but you'll end up implementing Excel in your test runner
16:59 eythian         Hmm
16:59 eythian         That sounds awful
16:59 drojf           [off] a friend said he's going to work for some online marketing things. so he is learning excel. they do all their whatever they do with that. that explains a lot
17:00 eythian         Oh yes, in previous lives, I've been given some seriously impressive spreadsheets try turn into code.
17:01 liw             I implemented an accounting to system for my own use as a spreadsheet once. Not in Excel, though, but in gnumeric.
17:02 drojf           [off] working with ads and excel. blergh. don't get kids, you may have to do really ugly things to provide for them
17:11 eythian         I used gnucash when I wanted an accounting thing, because that's its job.
17:19 drojf           worse than excel is excel with colour coded stuff. i mean, really? :/
17:19 LibraryClaire   yay colours :D
17:20 drojf           argh
17:34 tiosam          hola
17:56 oleonard        khall still around? I wonder if you get an error when trying to delete an EDIFACT message
17:57 khall           oleonard: I let me test that
18:02 khall           oleonard: yep, I get an error as well.
18:03 khall           oleonard: do you want to file a bug while I write a patch?
18:03 oleonard        Thanks for testing. I wanted to make sure it wasn't an artifact of the dummy data I was working with
18:03 oleonard        Sure, can do
18:05 oleonard        Bug 16737
18:05 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16737 normal, P5 - low, ---, kyle, ASSIGNED , Error when deleting EDIFACT message
18:05 khall           thanks! it was an easy fix, will be up in a moment
18:38 nengard         what version was MaxSearchResultsItemsPerRecordStatusCheck introduced in?
18:40 drojf           nengard: 3.22.2 / 3.20.8
18:40 nengard         thanks, uploading manual now :)
18:41 Joubu           nengard:
18:41 Joubu           ha
18:41 drojf           thanks :)
18:41 nengard         I don't see it in the release notes for either that's how i missed it
18:41 drojf           https://koha-community.org/koha-3-22-2-released/
18:41 drojf           https://koha-community.org/koha-3-20-8-released/
18:41 drojf           under new sysprefs
18:43 nengard         yeah, I read the main ones at the time of release - usually a new sys pref isn't added mid stream
18:43 drojf           yes that is odd
18:43 nengard         so I looked at 20.0 and 22.0
18:46 nengard         drojf http://git.koha-community.org/gitweb/?p=kohadocs.git;a=commitdiff;h=0f71a01c7b79c08de0a0f6a7f72efe581d2c3de4 done
18:46 nengard         will show in the web tomorrow
18:46 drojf           nengard++
18:47 oleonard        nengard++
18:47 drojf           oh nengard, could you use the new text maybe? it was changed in 15929
18:47 drojf           i think that is the old one
18:48 oleonard        It'd be nice if every time someone got positive karma the food dispenser in their cage gave them an extra food pellet.
18:48 drojf           or maybe i am confused
18:48 drojf           bug 15929
18:48 huginn`         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15929 trivial, P5 - low, ---, c.gravely, Signed Off , typo in explanation for MaxSearchResultsItemsPerRecordStatusCheck
18:48 drojf           ah its not done yet
18:48 drojf           so no idea, the new one is not valid yet :P
18:49 eythian         oleonard: I scripted it so mine does
18:50 eythian         Planning on making it order a pizza soon
18:50 drojf           let us know when it's done, there will be a lot of pizza
18:50 drojf           it uses your credit card, right?
18:50 cait            :)
18:50 * LibraryClaire likes free pizza
18:50 nengard         I copied that text from my sys prefs in master drojf
18:51 nengard         oh i see
18:51 nengard         there is a typo
18:51 nengard         okay
18:51 drojf           nengard: yeah i thought it had passed already. maybe khall can have a look if he's fine with the change
18:51 oleonard        Heck, if I get to script my own positive reinforcement I guess I'll pick something else too. Positive karma? Get to go home early!
18:53 nengard         drojf fixed
18:54 magnuse         pizza?
18:54 wahanui         it has been said that pizza is in the oven.
18:54 magnuse         nice!
18:54 LibraryClaire   :D
18:59 oleonard        Bye #koha