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/