Time  Nick         Message
07:47 * ashimema   giggles after reading last night's scrollback
07:47 ashimema     Morning all
07:48 ashimema     +1 for removing guided reports.. and perhaps pushing for better support in mana reports.. i.e. all the enhancements we suggested last hackfest starting to move
07:51 reiveune     hello
07:55 alex_a       Bonjour
08:10 magnuse      \o/
09:32 ashimema     anyone know of any documentation on our existing timezone handling?
09:33 ashimema     as in.. what level of support we suggest we have.. can a library have branches in multiple timezones for example.. are we consistently supporting the library being in one timezone and their server being in another
09:33 ashimema     the code around it is cryptic
09:37 Joubu        ashimema: there is the 'timezone' config
09:37 ashimema     indeed..
09:37 ashimema     but what is it's intention ;)
09:37 eythian      cait: https://www.youtube.com/watch?v=Utdtv4RbHgE&feature=youtu.be
09:37 Joubu        So theorically you can have several instances on the same server
09:37 ashimema     I'm not seeing any documentation about it.
09:37 Joubu        with different tz
09:38 ashimema     we have allot of places where you can type in datetime when only the date resolution is really used..
09:41 Joubu        https://wiki.koha-community.org/wiki/Time_Zone_Configuration
09:41 Joubu        https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20123
09:41 huginn       Bug 20123: new feature, P5 - low, ---, kyle, CLOSED FIXED, Allow multiple instances of Koha to have different timezones on the same server
09:41 Joubu        that's all we have
09:41 ashimema     aha.. thanks
10:16 ashimema     offline_circ/service.pl seems to be the only place where timezone is sent to dt_from_string
10:17 ashimema     feels like we should drop that use and kill off the param to me
10:19 ashimema     interestingly it does the fix I was aiming to put into DateUtils..
10:20 ashimema     converting from 'client' time (which is always UTC in KOCT) into the configured instance time
10:32 koha-jenkins Yippee, build fixed!
10:32 koha-jenkins Project Koha_Master_D9 build #1212: FIXED in 34 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1212/
10:34 cait         ashimema: sorry, not sure i can contribute anything to that line of thought
10:37 koha-jenkins Project Koha_Master_D8 build #756: STILL UNSTABLE in 40 min: https://jenkins.koha-community.org/job/Koha_Master_D8/756/
10:45 ashimema     now I can't seem to get an hourly loan to work
10:45 ashimema     grr
10:47 cait         breath
10:47 cait         what''s the issue?
10:48 ashimema     I wasn't specific enough in my circ rule
10:48 ashimema     think I've got it now.. just testing
10:49 ashimema     aha.. there we go :)
10:49 koha-jenkins Yippee, build fixed!
10:49 koha-jenkins Project Koha_Master_U18 build #677: FIXED in 52 min: https://jenkins.koha-community.org/job/Koha_Master_U18/677/
10:50 ashimema     for extenting due dates, bug 24608..
10:50 huginn       Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24608 enhancement, P5 - low, ---, andrew.isherwood, Failed QA , Allow modification of checkout due date
10:51 ashimema     should you be able to specify a time due for a daily loan..
10:51 ashimema     that makes no sense to me
10:51 cait         i think you should
10:51 cait         as you can do that when you use specify due date
10:57 ashimema     but when you specify a due date at checkout you don't yet know the circ rule that's going to apply so you don't know if it's an hourly loan or a daily loan yet..
10:57 cait         ?
10:58 ashimema     so you can't limit the due date input picker at checkout.. but you can at renewal and update because you already know the loan time.. hourly or daily
10:58 cait         i might be misunderstnading the bug you work on... but specify due date allows you to set a date before checkout and this allows you to modify after
10:58 cait         in both cases we don't check circ rules, don't we?
10:58 cait         why would you want to limit?
10:58 ashimema     do we just pass in whatevr time they put in then...
10:58 ashimema     wow
10:59 cait         well it has to be a valid date/time
10:59 cait         and it can be in the past, which is intentional and gerat for testing
10:59 ashimema     mmm
10:59 ashimema     except for a 'daily' loan anything except 23:59 should be invalid ;)
11:00 ashimema     interesting...
11:00 ashimema     this bug doesn't allow you to set a date before the original due date.. and I think that's right for this bug
11:00 ashimema     but that's another thing entirely
11:01 ashimema     what I'm trying to fix is Joubu's comment regarding having his timezone differnt in the client compared to the server..
11:01 ashimema     but actually.. what I've found is that for API use we always destroy timezone data which is weird
11:06 cait         timezones?
11:06 cait         oh wahanui, you disappoint
11:06 cait         ... because you are nothere
12:30 tcohen       hola
12:33 cait         hola
12:47 magnuse      wizzyrea!
12:47 oleonard     Hello
13:00 oleonard     If I were to change the way report groups and subgroups were selected, what would be a reasonable amount of subgroups to expect to accommodate? Anyone know of any extreme examples?
13:01 cait         not for us
13:01 cait         we only got a handful, maybe you need someone consortia
13:54 magnuse      oleonard: i have never seen anyone use subgroups
13:58 oleonard     Ha. Maybe I can make them more usable
14:00 oleonard     Thinking about (roughly) something like this: https://zivotdesign.com/p/view.php?p=15844535677735
14:03 magnuse      yeah, that looks good!
14:04 magnuse      ashimema: after doing "git pull" for the first time in a while i got complaints about a missing libemail-messageid-perl and had to install it myself. is that to be expected?
14:06 ashimema     what apt repo are you tracking?
14:06 ashimema     unstable or nightly?
14:06 ashimema     the nightlies are broken.. mirko's server is out of space so they've not been building properly in many months
14:06 ashimema     and how do you manage your dependancies when you do a git pull
14:06 ashimema     do you apt install koha-perldeps?
14:07 ashimema     or koha-common or anything..
14:07 ashimema     only using those to update packages will pull all the listed dependancies
14:07 cait         oleonard: i like it :)
14:07 cait         maybe ... if more than x
14:07 cait         ?
14:07 cait         but could be a lot more
14:08 ashimema     nice
14:12 cait         oleonard: it would be nice to test with a bit longer 'group names'
14:12 cait         the english ones tend to be all very short, but our gemran ones can get longer
14:12 cait         Serials = Zeitschriftenverwaltung (worst case)
14:18 oleonard     https://www.thoughtco.com/longest-german-word-in-the-world-4061494
14:22 magnuse      Krankenhaus!
14:23 magnuse      ashimema: sorry, guess i didn't do apt-get upgrade. nm
14:29 ashimema     no worries
15:10 ashimema     is anyone qaing bug 24846
15:10 huginn       Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24846 new feature, P5 - low, ---, jonathan.druart, Signed Off , Add a tool to bulk edit due dates
15:13 andrew__     I can't QA it, @ashimema, but I saw it and it's great! nice thinking, very timely
15:16 ashimema     indeed..
15:16 ashimema     I'll QA it quickly as I'd love to see it in the next release
15:17 ashimema     but only if no-one else can take a look.. I like to keep the qa step in there as much as I can..
15:17 ashimema     else we're removing checks.. and I know I'm not perfect.. the more eyes on these things the better
15:18 * ashimema   runs to get kids from school
15:18 ashimema     oops
15:19 Joubu        I'd like someone that had to deal with that in a real-life situation
15:19 Joubu        to make sure it deals with the different cases
15:26 caroline     for real life situation, maybe ask vfernandes. they asked for that last week because all libraries in portugal are closed for two weeks
15:35 cait         we update issues.date_due and items.on_loan
15:36 cait         2 questions we had were about renewal notices (some want to send, others don't) and incrementing the renewal counter (we don't, but didn't get asked)
15:37 cait         also people only want to get updates on due dates between x and y (nto the real old ones with fines and not the super future ones )
15:37 cait         i think when renewing items with fines, you need to do more things, we have avoided that (only updating iissues due today or in the future)
15:38 cait         but it hink your feature probably uses internal functions?
15:38 cait         ashimema: / Joubu - ^ hope that's helpful
15:41 cait         all librareis closing now here i think
15:42 Joubu        cait: the feature only update the due date in the DB, without dealing with fines or anything else
15:43 cait         i am not sure of the consequences if you have an verdue item with an fu fine
15:43 cait         then change the due date ... it gets overdue again
15:43 cait         but it might keep updating the fu fine instead of the f fine?
15:43 cait         hm
15:43 cait         that was not quite right
15:43 cait         i mean we are missing what usually happens on rnew - fu > f (or wahtever they are called now in master)
15:44 cait         to avoid issues we have asked the libraries to update already overdue manually
15:44 cait         got to go now - will be back from home tomorrow
15:45 cait         or later :)
15:46 oleonard     hash tag nofines
15:49 caroline     +1 ^
15:50 ashimema     I'll take a look.. we have also been doing this already in real life and that's where our original description of the bug came from ;)
16:18 reiveune     bye
16:50 ashimema     bug 24722
16:50 huginn       Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24722 normal, P5 - low, ---, jonathan.druart, Passed QA , reserves.priority must be NOT NULL
16:50 ashimema     do we not need to catch and update existing NULLs before it'll allow us to conver to NOT NULL
16:50 ashimema     Joubu ^
18:28 Joubu        ashimema: we could, but that should not exist
18:31 ashimema     shouldn't.. but iy bet it does ;)
18:31 ashimema     * shouldn't.. but it bet it does ;)
18:32 ashimema     I'm sure there was a SIP bug recently that put reserves in with NULLs
18:32 ashimema     maybe I'm mis-remembering
18:32 cait         hm no i seem to remember that too
18:34 lisettelatah Was that bug 24680
18:34 huginn       Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24680 minor, P5 - low, ---, ere.maijala, Pushed to master , Hold modification endpoints don't always work properly
18:35 ashimema     bug 24705 perhaps
18:35 huginn       Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24705 normal, P5 - low, ---, kyle, Pushed to master , Holds placed via SIP will be given first priority
18:36 ashimema     Prior to that patch SIP called AddReserve without a priority at all
18:38 ashimema     yup.. looking at AddReserve it looks like we could have ended up with NULLs in there before now.
18:38 ashimema     so we should deal with them
18:38 ashimema     fancy doing a followup or I can have a go later this evening once I've walked the dog and got the girls to bed
18:39 ashimema     thanks team
19:59 corilynn     oleonard, are you here?
20:01 corilynn     or, anyone that can help me with kohadevbox ?
20:02 corilynn     I'm getting a failure message on this step: kohadevbox : Install Koha | Add official Koha repository (repo)
20:12 cait         hm it looks like the https on git.koha-community.org might not be ok right now
20:12 cait         maybe that could cause it?
20:12 cait         hm ok, that might be a wrong lead
20:12 cait         my link was odd
20:12 cait         doe sit just hang or is there some error?
20:13 oleonard     corilynn, I'm here now
20:13 * cait       will leave it to oleonard
20:13 * oleonard   has had good luck with koha-testing-docker lately after kohadevbox started failing again
20:39 mja          Hey everyone, I got this report from the SQL reports library: it's supposed to find records with a specific MARC field. Is there a way to change it so it grabs bib records WITHOUT a specific MARC field? Even better, without several given MARC fields?
20:39 mja          SELECT     biblionumber,     CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=', biblionumber, '\">', biblionumber, '</a>' ) AS link FROM     biblio_metadata WHERE     ExtractValue(metadata,'//datafield/@tag') REGEXP <<MARC field>>
20:44 cait         mja: i usually use something like =""
20:44 cait         ExtractValue(metadata,'//datafield/@tag' = ""
20:45 cait         that is 'not exists' as it will come back with an empty string
20:45 cait         ExtractValue(metadata,'//datafield/@tag' is not quite right, you need to fix that
20:45 cait         examples are in the library
20:45 mja          Thanks. I did pull this directly from the library, though.. maybe it's an older one?
20:46 cait         maybe it's meant as an example
20:46 cait         so you are supposed to change the extractvalue bit
20:48 corilynn     sorry, oleonard, boss lady called
20:48 corilynn     is there anyway to get kohadevbox working? something about ansible?
20:48 oleonard     Sounds like a hilarious Dilbert scenario if I ever heard one
20:49 corilynn     I could go on...
20:49 oleonard     corilynn: Paste the output that shows the failure? http://paste.koha-community.org/
20:49 corilynn     I'm getting an error for vagrant up at kohadevbox : Install Koha | Add official
20:49 corilynn     yes
20:51 corilynn     did that work?
20:51 corilynn     http://paste.koha-community.org/19076
20:53 oleonard     corilynn are you on Windows?
20:53 corilynn     no, ubuntu
20:53 corilynn     with no UI (don't ask, it's a long story)
20:54 oleonard     Sorry corilynn I've dealt with a number of kohadevbox issues before but this one doesn't look familiar
20:55 corilynn     where would "apt cache update" be?
22:15 koha-jenkins Project Koha_18.11_D9 build #269: SUCCESS in 26 min: https://jenkins.koha-community.org/job/Koha_18.11_D9/269/
22:22 koha-jenkins Yippee, build fixed!
22:22 koha-jenkins Project Koha_18.11_D8 build #268: FIXED in 32 min: https://jenkins.koha-community.org/job/Koha_18.11_D8/268/
22:25 koha-jenkins Project Koha_18.11_U18 build #258: STILL UNSTABLE in 34 min: https://jenkins.koha-community.org/job/Koha_18.11_U18/258/