Time  Nick         Message
00:36 fridolin     here i am
01:32 koha-jenkins Project Koha_20.11_U20 build #106: SUCCESS in 34 min: https://jenkins.koha-community.org/job/Koha_20.11_U20/106/
01:43 koha-jenkins Project Koha_20.11_D9 build #112: SUCCESS in 43 min: https://jenkins.koha-community.org/job/Koha_20.11_D9/112/
01:49 koha-jenkins Project Koha_20.11_U_Stable build #14: SUCCESS in 53 min: https://jenkins.koha-community.org/job/Koha_20.11_U_Stable/14/
02:00 koha-jenkins Project Koha_20.11_U16 build #96: SUCCESS in 1 hr 4 min: https://jenkins.koha-community.org/job/Koha_20.11_U16/96/
02:03 koha-jenkins Project Koha_20.11_D10 build #122: SUCCESS in 1 hr 5 min: https://jenkins.koha-community.org/job/Koha_20.11_D10/122/
02:05 koha-jenkins Project Koha_20.11_D11 build #132: SUCCESS in 50 min: https://jenkins.koha-community.org/job/Koha_20.11_D11/132/
02:20 koha-jenkins Project Koha_20.11_U18 build #98: SUCCESS in 1 hr 22 min: https://jenkins.koha-community.org/job/Koha_20.11_U18/98/
02:34 koha-jenkins Project Koha_19.11_U20 build #229: SUCCESS in 23 min: https://jenkins.koha-community.org/job/Koha_19.11_U20/229/
02:42 koha-jenkins Project Koha_19.11_D9 build #345: SUCCESS in 31 min: https://jenkins.koha-community.org/job/Koha_19.11_D9/345/
02:44 koha-jenkins Project Koha_19.11_D8 build #403: SUCCESS in 34 min: https://jenkins.koha-community.org/job/Koha_19.11_D8/403/
02:51 koha-jenkins Project Koha_19.11_U18 build #330: SUCCESS in 41 min: https://jenkins.koha-community.org/job/Koha_19.11_U18/330/
02:54 koha-jenkins Project Koha_19.11_U16 build #91: SUCCESS in 44 min: https://jenkins.koha-community.org/job/Koha_19.11_U16/91/
02:56 koha-jenkins Project Koha_19.11_U2010 build #28: SUCCESS in 42 min: https://jenkins.koha-community.org/job/Koha_19.11_U2010/28/
03:45 koha-jenkins Project Koha_19.11_D10 build #181: UNSTABLE in 51 min: https://jenkins.koha-community.org/job/Koha_19.11_D10/181/
05:38 reiveune     hello
05:55 marcelr      hi #koha
06:46 alex_a       Bonjour
07:44 cait1        hello #koha
08:37 Nemo_bis     huomenta
10:33 jazeel       hi
10:33 jazeel       Hello
10:37 jazeel       Hello
10:37 Joubu        hi jazeel
10:38 jazeel       I would like to know how to use elasticsearch insead of solr on koha
10:39 jazeel       Now we are using zebra
10:39 Joubu        which version of Koha are you using?
10:40 jazeel       Instead of zebra we want to use elasticsearch
10:42 jazeel       koha version : 20.05.01.000
10:42 Joubu        have a look at the syspref "SearchEngine"
10:43 jazeel       Yes.
10:43 Joubu        you will need to build the elastic index, there is a koha-elasticsearch shall command
10:43 Joubu        shell*
10:45 jazeel       Thats only need?
10:45 jazeel       Need to do any other ?
10:46 Joubu        did you install Koha using the debian packages?
10:47 jazeel       Yes.
10:48 jazeel       Hello
10:49 jazeel       Hello
10:49 Joubu        Nothing else should be needed. Did you do that?
10:49 Joubu        if you have problems have a look at the about page, "system information" tab
10:52 jazeel       could please share the file name for elastic index ( i mean perl file)
10:53 Joubu        you need to use the koha-elasticsearch shell command
10:55 jazeel       it will take any issues for current zebra files after running the command koha-elasticsearch?
10:56 jazeel       currently indexd all records under zebra
11:03 kidclamp     you can perform a full ES reindex, then it should do both for any future record changes
11:03 kidclamp     ES does not have a daemon, indexes are updated immediately
11:06 jazeel       Ok
11:09 jazeel       I reindex all records using shell commad koha-elasticsearch and switched into elasticsearch. However i cant able to get result.
11:16 jazeel       Hello
11:30 tcohen       morning
11:31 jazeel       please check my quries
11:32 Joubu        then check the answers please
11:32 Joubu        if you have problems have a look at the about page, "system information" tab
11:33 Joubu        as well as "server information", there should be a "elastic search" entry there with some infos
11:34 jazeel       Yes that i can see under server information (elasticsearch)
11:36 jazeel       When i search a topic using elasticsearch via staff interface
11:37 jazeel       search is not working
11:40 tcohen       no messages when doing the full reindex?
11:41 tcohen       how long did it take?
12:03 marcelr      kidclamp: if 001 and 003 go together for LOC, i wouldnt call it scope creep per se
12:04 kidclamp     I do see your point, but 001 to biblionumber isn't LOC - so is the 0003 tied to this pref? or is it always going to be reset? I think there are more questions (also I have made enough mistakes on this one already)
12:09 tcohen       what is the bug #?
12:09 kidclamp     bug 27981
12:09 huginn       Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27981 enhancement, P5 - low, ---, nick, Needs Signoff , Add option to automatically set the 001 control number to the biblionumber
12:09 tcohen       this is something I've always made wrong assumptions about too, so intrigued
12:10 kidclamp     hmm...maybe I do agree marcelr...considering
12:14 kidclamp     but this will be a big change - there are many mad schemes and I think it needs a pref  - even bug 28491 concerns me - libraries invent mad schemes when we have let them for so long
12:14 huginn       Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28491 normal, P5 - low, ---, m.de.rooy, Signed Off , Field 003 in authority records not updated after import
12:18 marcelr      big change? hmm
12:36 kidclamp     The 040 (or 035) should contain similar data, but I think some libraries use 003 to determine source of record - changing it automatically can remove that
12:37 marcelr      well maybe we should be pragmatical (as always :)
12:37 marcelr      bad habits are ok when time passes?
12:37 kidclamp     bugs become features :-)
12:38 kidclamp     new syspref - off for existing and default to on for new?
12:38 marcelr      you want 1000 sysprefs?
12:38 kidclamp     indeed I do
12:38 marcelr      just create a few hundred :)
12:39 marcelr      we re almost there
12:39 kidclamp     let me ask our educators if I am overreacting - maybe it is not a large deal
12:42 marcelr      Joubu: have  a look at bug 27944 please ?
12:42 huginn       Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27944 enhancement, P5 - low, ---, agustinmoyano, Failed QA , Add new stages to the article request process
12:42 marcelr      the Template/Plugin/Biblio stuff
12:45 Joubu        marcelr: l.206 of which files?
12:49 marcelr      Template.pm of TT
12:49 marcelr      standard perl dir
13:03 kidclamp     marcelr: they agree a syspref is better here - for both bibs and auths
13:18 tuxayo       hi #koha :)
13:21 marcelr      hi tuxayo
13:25 marcelr      kidclamp: you must have bribed them ;)
13:27 * kidclamp   takes the cookies out of the oven
13:30 tuxayo       he he, send some to Amsterdam also ;)
13:30 marcelr      right
13:31 tuxayo       (bug is over my head so no idea about the actual choices to make)
13:36 marcelr      kidclamp: will signoff on this first part, but would be nice to include modify
13:37 kidclamp     you mean override existing values?
13:38 marcelr      yeah
13:38 marcelr      see bz
13:38 marcelr      the commit message is confusing
13:40 marcelr      kidclamp: now I need your signoff somewhere :)
13:40 kidclamp     where?
13:40 marcelr      28620 eg
13:41 marcelr      or a qa signoff
14:09 Joubu        Asking again for the Xth times "Do we need bug 17600 (Standardize the EXPORT) or not?"
14:09 huginn       Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17600 enhancement, P5 - low, ---, jonathan.druart+koha, Needs Signoff , Standardize the EXPORT
14:09 ashimema     I like it
14:09 ashimema     and have tested..
14:10 Joubu        It's now or never, basically
14:10 ashimema     I'm underwater with work at the minute though.. so can't easily commit to further testing QA
14:10 ashimema     I'd go for it
14:10 ashimema     personally
14:10 Joubu        I don't need stamps on it, only a "go for it" is enough :)
14:11 Joubu        "I will push it at the beginning of July, regardless of its status, if there is no objection before."
14:11 Joubu        this is what I actually sent to the QA team a couple of weeks ago
14:11 Joubu        but I am feeling a bit ashamed to push such big changes with a NSO status
14:13 Joubu        marcelr, kidclamp, khall, jajm, tcohen, you all agree with that, right? ^
14:13 marcelr      Joubu you promised it
14:13 marcelr      wait and begin of July takes another year
14:13 khall        go for it
14:13 marcelr      we have 4 months for cleanup haha
14:14 Joubu        Thanks, I didn't need more. A short "go" is better than silence ;)
14:14 marcelr      kidclamp++ thx
14:15 marcelr      Joubu can you push a few other NSOs too ?
14:15 marcelr      :)
14:16 jajm         Joubu, go go go!
14:16 Joubu        I will quote you all on the bug :D
14:19 ashimema     go :)
14:20 ashimema     I did do a chunk of testing so take my SO
14:21 tcohen       Joubu add my stamp
14:21 tcohen       I tested it in the early ages
14:21 tcohen       and am sure we can fix whatever arises
14:23 Joubu        There is a missing bit, we need a QA safety net. But it can be done a bit later.
15:35 tcohen       tuxayo what you mean by 'prefill'?
15:36 tcohen       I've just added 'ASD' as default value on the 952$3 configuration (marc framework)
15:36 tcohen       and it works
15:38 tuxayo       tcohen: PrefillItem on SubfieldsToUseWhenPrefill = "e f g h"
15:38 tcohen       ah, a syspref
15:40 jim          hello
15:40 jim          anyone here
15:40 jim          need help for SQl report
15:41 tcohen       I didn't know the feature, tuxayo, looking
15:42 jim          ?
15:42 tcohen       shoot
15:42 tcohen       someone will probably look at your question
15:43 tcohen       tuxayo that thing you're mentioning is related to a use of cookies
15:43 jim          I want to create report using 041 Languiage wise
15:44 jim          where I can search Language to fetch the records
15:45 tcohen       so the 041 is not mapped to a column by default
15:45 tuxayo       tcohen: thanks for the tip. Ok so mystery solved about the part where I rollback the change.
15:46 tcohen       I'm trying the issue myself
15:46 tcohen       I wasn't aware of that feature/behavior
15:46 tcohen       jim https://wiki.koha-community.org/wiki/3.2_SQL_Reports_Library#Query_MARC
15:47 tcohen       ^^ there you can find how to query MARC
15:47 tcohen       No
15:47 tcohen       https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC
15:47 reiveune     bye
15:47 tcohen       ^^ thar one
15:49 jim          i have tried to understand it but I am not getting
15:55 tuxayo       jim: what is puzzling you?
16:08 jim          not able to fetch records
16:08 jim          from 041 search
16:08 jim          i created authorized value on it
16:15 tuxayo       jim: so it would be getting all the record with 041 equal to some value?
16:17 jim          Authorized value is language
16:26 tuxayo       odd, the report library doesn't have a case of getting record with a given value of a field
16:28 tuxayo       I was curious and tried some things. Here is how to get the records that contain 'spa' (for spanish) in their 041
16:28 tuxayo       SELECT biblionumber, ExtractValue(metadata,'//datafield[@tag="041"]/*')
16:28 tuxayo       FROM biblio_metadata
16:28 tuxayo       WHERE ExtractValue(metadata,'//datafield[@tag="041"]/*') LIKE '%spa%';
16:28 tuxayo       i don't know if there is something more relevant to do using authorized values
16:30 jim          Oww great
16:30 tuxayo       And I don't know about the above query if it query 041 or all it's subfields.
16:30 jim          subfield is a
16:31 tuxayo       The aim is to only query $a ?
16:33 jim          yes because i put language in that
16:33 jim          like hindi
16:33 jim          or english
16:42 tuxayo       That's interesting to learn about that in order to complete the library.
16:42 tuxayo       Here is how to get record with $a = eo
16:42 tuxayo       SELECT biblionumber
16:42 tuxayo       FROM biblio_metadata
16:42 tuxayo       WHERE ExtractValue(metadata,'//datafield[@tag="041"]/subfield[@code="a"]') LIKE '%eo%';
16:52 tuxayo       jim: here are the queries documented.
16:52 tuxayo       https://wiki.koha-community.org/wiki/SQL_Reports_Library#Getting_records_based_on_their_subfield_values
16:52 tuxayo       Can you proofread how I phrased in english what the queries do? As I'm not a librarian.
16:56 jim          proofread?
17:00 jim          thank you for your format now I can get my desired result
17:00 jim          Another thing I wanted to know how to add serial number in the reports
17:32 tuxayo       jim: proofread => check if what I wrote as the description of the queries makes sense. e.g. at some point I didn't know the difference between field and subfield. So stuff like that
17:32 tuxayo       «add serial number in the reports» what do you mean?
17:51 jim          like 1 , 2 3
18:33 Hector       Hello everybody
18:34 Hector       may somone answer a question
18:34 Hector       Koha, doesn't run on windows? right?
18:34 Hector       NeedI install LINUX as OS base?
18:35 Hector       ok that are three questions :)
18:43 jim          yes Koha needs the server to be on Ubuntu or Debian or anyother flavor of Linux
18:44 Hector       ok thanks for your kind answer
18:44 Hector       have a nice day
18:44 tuxayo       you too :)
18:45 tuxayo       jim: «add serial number in the reports» Is that numbering the returned lines from 1 to 30 if the query returned 30 results?
18:47 tuxayo       Hector: here you can find documentation about installing Koha on Debian https://wiki.koha-community.org/wiki/Koha_on_Debian
18:59 tuxayo       kidclamp , khall hi :) can you test if bug 28675 affects 21.05 ? Just go to the quote editor and click on "add quote". If nothing horrible happens then you're good :)
18:59 huginn       Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28675 normal, P5 - low, ---, koha-bugs, ASSIGNED , QOTD broken in 20.05
19:11 khall_       tuxayo seems to be working on 21.05.x!
19:11 tuxayo       khall_: thanks :)
19:20 khall_       np!
19:25 jim          like you get the report with serial number 1,2,3
23:17 Carolina     hi
23:18 Carolina     Add a Koha login form to your web site in koha21   Thank you
23:23 tuxayo       Hi Carolina , what do you mean?