Time Nick Message 04:33 dcook Is it just me or is the web installer broken for fresh installs when using Plack? 04:33 dcook non-Plack works fine 04:33 dcook koha-schema-upgrade is also no good.. 05:15 tuxayo :o 05:15 tuxayo Which step? 05:43 tuxayo dcook: I just speedran the installer and logged into Koha. Nothing unusual, what was the issue? 05:43 tuxayo (i'm on a plack install) 05:46 dcook tuxayo: Well, this is an unusual case i suppose 05:46 dcook It's taking an existing instance, upgrading, and then starting over with an empty database 05:47 dcook Perhaps there is some koha-create option or something I could've used. I find that command is almost unusable except for creating from scratch though 05:47 dcook Doesn't matter too much but good to know you didn't have issues 05:49 tuxayo dcook: «It's taking an existing instance, upgrading, and then starting over with an empty database» 05:49 tuxayo In which case it's doing that? 05:50 dcook testing an upgrade 05:50 dcook and don't have a prod backup so just trying to use a sample db 05:50 dcook Doesn't matter. I'll work it out. 05:51 dcook Working OK in CGI mode 05:51 dcook Although now having issues with the onboarding.pl.. 05:53 dcook Although it worked fine in koha-testing-docker i thought.. 05:55 dcook I guess I didn't need onboarding.pl there.. 05:57 dcook Hmm don't know what was going on there but working now.. 06:00 reiveune hello 06:01 dcook hola reiveune 06:01 tuxayo Hi reiveune :) 06:01 dcook Man.. working fine in koha-testing-docker but not in a package install.. 06:01 tuxayo «but working now» 06:01 tuxayo It's magic 06:01 reiveune \o_ 06:02 tuxayo :D 06:06 dcook Nah, just something different broke 06:06 dcook In an even more perplexing way 06:09 dcook Ah I was comparing apples to oranges 06:10 dcook I think onboarding.pl might be a little broken in 21.05.. 06:11 saa i am trying to configure elasticsearch in latest version of koha but it is throwing following error [NoNodes] ** No nodes are available: [http://127.0.0.1:9200], called from sub Search::Elasticsearch::Role::Client::Direct::__ANON__ at /usr/share/koha/lib/Koha/SearchEngine/Elasticsearch/Indexer.pm line 416.root@linux:/usr/share/koha/bin 06:12 saa which version of elastic search should be insalled on ubuntu 21.01 and koha 21.05.01 06:12 saa can anyone help to guide properly 06:12 saa i tried installing 7.x as well as 6.x but above error is there 06:19 tuxayo saa: no support for ES7 as of now 06:19 saa ok 06:19 tuxayo > as well as 6.x 06:19 saa oh 06:19 saa so should i install 5.x 06:19 tuxayo I'm just quoting your message 06:20 tuxayo About that, that's should work. Are you able to query ES directly on 127.0.0.1:9200 ? 06:20 saa no 06:21 saa when i run rebuild_elasticsearch -v it throws above error 06:21 saa have i done any wrong configuration 06:21 dcook Ah looks like the Board patron type is the reason I as having issues.. 06:22 tuxayo saa: can you check without Koha that ES is up and reachable from Koha's machine? 06:22 saa should i open browser and check 127.0.0.1:9200 06:23 saa or can u tell me the way to check 06:23 tuxayo I don't know much about ES but that would be my way to go to troubleshoot this. Querying directly 06:24 saa k 06:25 tuxayo I just tried on my koha the following: 06:25 tuxayo curl 127.0.0.1:9200 06:25 tuxayo And I got an output with various stuff from ES 06:26 tuxayo Testing in a browser should work. 06:26 saa let me chk reinstalling again 06:38 saa i install elasticsearch 5.x and when i ran curl 127.0.0.1:9200 { "name" : "fMSAqU8", "cluster_name" : "elasticsearch", "cluster_uuid" : "rMHtCwDjRBSWkDgJoTGMwg", "version" : { "number" : "5.6.16", "build_hash" : "3a740d1", "build_date" : "2019-03-13T15:33:36.565Z", "build_snapshot" : false, "lucene_version" : "6.6.1" }, "tagline" : "You Know, for Search" 06:38 saa it gave above 06:39 saa so elasticsearch is installed 06:39 saa now when i run rebuild_elasticsearch.pl -v it gives error Can't open '/etc/koha/sites/ncl/searchengine/elasticsearch/index_config.yaml' for input: No such file or directory at /usr/lib/x86_64-linux-gnu/perl5/5.30/YAML/XS.pm line 48. 06:45 jase Hello 06:46 jase I have updated my koha from 3.14 to 20.05 06:47 jase I have 150000 records under my biblio so want to migrate with same biblionumber with new koha. 06:47 jase I used bulkmarcimport.pl for updating but creating new biblionumber instead of old biblionumber in marc file. 06:48 jase Please help how to update same biblio number with new sysytem. 06:50 Nemo_bis congratulations for your update! I hope someone with experience in migrations will be able to point to some documentation 06:50 jase i used koha-upgrade-schema instance name which is also failed. 06:50 Nemo_bis (the last time I searched for such documentation was several years ago, I'm quite out of date) 06:51 jase Please help me if anyone know more about these issues. 06:56 tuxayo saa: ES5 isn't supported anymore I think. So ES6 only 06:57 saa oh 06:57 tuxayo retry with ES6. The last error index_config.yaml isn't related to ES5 I think so that's puzzeling 06:58 saa but when installed 5.x and tried installing analysis-icu it installed without any trouble 06:58 saa let me do again quickly with 6 and show u error 06:58 saa give me a sec 06:58 alex_a Bonjour 06:59 jase I am using ES6 07:01 saa i tried installing elasticsearch 6.x and installed analysis-icu after doing this when I ran rebuild_elasticsearch.pl it threw error Can't open '/etc/koha/sites/ncl/searchengine/elasticsearch/index_config.yaml' for input: No such file or directory at /usr/lib/x86_64-linux-gnu/perl5/5.30/YAML/XS.pm line 48. 07:01 saa do i need to do any change in any file 07:03 tuxayo saa: that not the same error as when you first tried rebuild_elasticsearch.pl right? Which was also with ES6 07:03 saa right 07:04 saa earlier i had done many changes in Cxn.pm etc as well as in /etc/eleasticsearch/elasticsearch.yml but now i have not changed anything 07:04 saa i have just installed elasticsearch, restarted service and tried using rebuild_elasticsearch command in koha 07:05 jase You need to enable /etc/koha/sites/ncl/searchengine/elasticsearch/index_config.yaml in config file. 07:05 saa i have enabled that in koha_conf.xml 07:06 jase check file permision also 07:08 saa rw-r----- 1 root ncl-koha 20K Jul 14 16:22 koha-conf.xml -rw-r----- 1 ncl-koha ncl-koha 2.8K Jul 14 12:16 log4perl.conf -rw-r----- 1 root ncl-koha 2.0K Jul 14 12:16 zebra-authorities-dom.cfg -rw-r----- 1 root ncl-koha 2.3K Jul 14 12:16 zebra-biblios-dom.cfg -rw-r----- 1 root ncl-koha 26 Jul 14 12:16 zebra.passwd 07:08 tuxayo jase: indeed bulkmarcimport should allow to keep the biblionumbers. Since you use a marc export that doesn't contain the biblionumbers. I don't know what would be a clean way to do this. 07:09 tuxayo Ideally there would be a way for you to not have the constraint of keeping the biblionumbers. But that would be too easy right? ^^" 07:10 tuxayo saa: ls -l /etc/koha/sites/ncl/searchengine/elasticsearch/index_config.yaml 07:10 tuxayo But it's already known that it's not there 07:10 saa yes searchengine folder itself is not there 07:10 tuxayo I don't know how is that file created, could it be somewhere else? Or with just a typo 07:10 saa how to create it 07:11 dcook Boo metacpan is down.. 07:11 saa it available in usr/share/koha/intranet/cgi-bin/admin/searchengine 07:15 saa i commented out all lines where overwrite option was there and again tried command and now it is indexing data 07:15 saa tx 07:15 saa let me finish this process and come back if there is still any error 07:15 saa tuxayo tx 07:18 jase If anyone know, how to keep same same bibblionumber while migrating from version 3.14 to 20.05 07:19 jase I tried many ways but still not get the results 07:19 tuxayo saa: IIUC the index_config.yaml in /usr/share should be the default file. So it should have been copied in the config directory of your Koha instance. 07:20 tuxayo I don't know how it's supposed to be done. But there was something missing in the setup of your Koha instance and using the file from /usr/share is a circumvention. 07:20 saa should i recreate my instance 07:21 tuxayo Also, IIRC this file can be edited via Koha, but it won't work. As this file in /usr/share won't be writable for Koha. And if you manually edit it as root. When updating Koha, that will conflict is the default file is changed. 07:22 saa so what is correct way to get it 07:23 tuxayo > recreate my instance 07:23 tuxayo Yes, at least try a parallel one. Recheck carefully the instructions and check if the files in /etc/koha/sites/INSTANCE_NAME/ are there 07:23 saa ok tx 07:24 saa why i am trying elasticsearch is koha takes lot of time in searching records if we use zebra 07:24 saa do u have any answer on this 07:24 saa if zebra works fine we would stick to zebra only 07:25 tuxayo jase: is there a way for you to not need to keep the bibblionumbers? 07:25 tuxayo If on a test 3.14 install, you load you production data, and try a direct upgrade (no exporting and importing) is the result working? 07:26 tuxayo saa: I'm not sure to understand. So you need ES because Zebra is too slow for your usecase right? 07:26 tuxayo About redoing you install, which instructions did you use? 07:26 tuxayo *your install 07:29 saa <tuxayo> saa: I'm not sure to understand. So you need ES because Zebra is too slow for your usecase right? YES 07:29 saa <tuxayo> About redoing you install, which instructions did you use? I simply downloaded ES 6.x deb file and installed and koha was installed through wiki instructions 07:31 jase I want to keep biblio numbers beacuse all records updated in DOI 07:34 tuxayo saa: so, these ones? https://wiki.koha-community.org/wiki/Debian#Elasticsearch 07:34 tuxayo Just to be sure. 07:34 saa yes correct 07:38 tuxayo Anyway, that's a far as I can stay. Good luck you two. If still stuck, ask again in hours so there will be people from different timezones/moments of their day. 07:38 tuxayo Next step will be to ask in the general mailing-list: https://koha-community.org/support/koha-mailing-lists/ 07:39 tuxayo So, good night all, see you at the IRC meeting for those who will attend :) 07:44 saa tx a lot tuxayo 07:51 jase Please check my quries. 07:53 * tuxayo gives a last peak at the chat 07:54 tuxayo jase: You should ask in the general mailing list, it's a tricky migration case. There are more people there with migration experience 08:00 jase share any contact in general mailing list for checking my quries. 08:09 ashimema cait around ? 08:09 tuxayo jase: https://koha-community.org/support/koha-mailing-lists/ 08:55 severine_q Hello Koha :) 09:29 cait1 hi severine_q :) 09:29 cait1 ashimema: kind of around now, what's up? 09:48 ashimema I was going to ask how much you understand about 'Holdings' records? 09:49 * ashimema is seeing lots of parallels in bug 20447 and bug 24857 in terms of overall targets.. 09:49 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20447 new feature, P5 - low, ---, ere.maijala, Signed Off , Add support for MARC holdings records 09:49 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24857 enhancement, P5 - low, ---, kyle, Signed Off , Add ability to create "Volumes" for records, and assign items to volumes 09:49 ashimema but they take two very different approaches 09:50 ashimema also been thinking again about the 'Bundles' bug and how we might be able to make it work from both perspectives.. in MARC and in DB.. both or just one. 10:22 cait1 hm i know some about Holdings 10:22 cait1 we process MARC Holdings when importing data into Koha 10:23 cait1 so I have seeen quite a bit of them - but I haven't tested the patch for Koha 10:23 cait1 I thin i give initial feedback on the RFC - it's on the wiki 10:23 cait1 ashimema: ^ 10:23 ashimema yeah, I read the RFC 10:23 ashimema indeed 10:23 cait1 i think the idea usually is not for "bundles2... but it could be helpful 10:24 ashimema I think it looks like a reasonable addition, especially given they've made it entirely optional 10:24 cait1 yes 10:24 cait1 we have been missing this "level" 10:24 cait1 at the moment waht we do is writing information from the holdings into the bibliographic records before importing into Koha 10:24 ashimema well.. I SO'd.. so it's awaiting QA now 10:24 cait1 I am curious to see how we might be able to improve workflows long term 10:24 cait1 time... :( 10:24 ashimema mm 10:25 cait1 just preparing for another meeting and trying to have a bite before it 10:25 ashimema I'm still interested in how it fits with Kyles Volumes work 10:25 ashimema that also sorta introduces the same level.. but in an entirely different way 10:25 ashimema hugs 10:49 cait1 MARC holdings is maybe too complicated for some - unless we have tools to make the linkings/entries more automatic/comfortable maybe 10:50 paxed the marc holdings change is in use in the finnish national library and they absolutely need it 10:51 paxed and it's marc format stuff 10:51 paxed unlike the (rather cryptically named, imo) volume level holds? 10:53 cait1 paxed: not disagreeing with you at all 10:53 cait1 just talking about how it might relate to other proposed features 10:53 cait1 like the volumn one ashimema mentioned 10:54 cait1 using the holdings for that purpose might be a little overkill - or might require some nice to handle helpers 10:54 cait1 it's totally MARC standard and I think we shoudl have them :) 10:55 paxed ah. i thought it was an either-or situation 10:55 ashimema Indeed.. I was looking at it from he perspective of how do we use Holdings records but still make it simple enough to achieve the stuff 'Volumes' does 10:55 ashimema well.. I personally think it's really confusing to have such similar functionality both make it in ;) 10:56 ashimema but I'm keen for 'Holdings' to win.. I wasn't really aware how similar they are until yesterday though 10:56 paxed i'm not at the national library, so can't really say for sure (i'm at the public libraries), but we have a long-standing ticket for holds where any of multiple copies fulfill it 10:57 ashimema such a shame when things like this happen.. would have been great to see Kyle test/qa Holdings rather than write a 'simpler' competing piece 10:57 paxed (not just a "volume", but for example a different course material books) 10:57 ashimema there's a 'hold groups' feature somewhere isn't there.. 10:57 ashimema I've lost track honestly. 10:58 paxed we're running an old koha fork, so not for us. haven't kept up to community, because resources. 10:58 ashimema I'm basically re-investigating all this stuff as we have a contract to add 'boxes' or 'collections' or 'bundles' or whatever at the other end of the structure. 10:58 paxed ahh 10:59 ashimema with the same time we need to add 'bookings' so rather than just reserving an item for next in queue when it comes back.. people can actually book a time slot for it. 11:29 ashimema hope the floods haven't affected you at all cait 11:32 marcelr hi #koha 11:33 ashimema hi marcelr 11:33 ashimema just about to head out for a bit, but may catch you later for a chat 11:34 ashimema also wondered if you might be a good candidate to QA bug 20447.. think it needs some librarian perspective.. the code looks reasonable so far.. and in my understanding all seems sane enough.. but I'm by no means a cataloguer 11:34 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20447 new feature, P5 - low, ---, ere.maijala, Signed Off , Add support for MARC holdings records 11:36 marcelr could have a look, no cataloger too ;) 12:22 oleonard-away cait1: I was able to reproduce Bug 27081...and then I wasn't. 12:22 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27081 minor, P5 - low, ---, oleonard, NEW , Notes missing from lost items report column configuration 12:33 paxed ashimema: not knowing what you mean by "'boxes' or 'collections' or 'bundles'", couldn't those be catalogued as "kits"? 12:34 oleonard I wonder if the original intention of the add item form is that if you leave an "important" field empty you're supposed to be able to continue after confirming. 12:36 Joubu oleonard: yes 12:45 oleonard It doesn't work that way :) 12:47 Joubu only on the add item form 12:47 Joubu additem.pl 12:47 Joubu bug 28690 12:47 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28690 normal, P5 - low, ---, koha-bugs, NEW , Important and mandatory not checked on all item forms 12:50 oleonard Haha you discovered the bug after filing 28689 just as I did after working on 28689 12:52 oleonard Our cataloging-related JS is spread out over so many files 12:56 Joubu oleonard: I found it after bug 27526 actually. Its mid-term goal is to refactor/centralize the code for the add/mod item forms 12:56 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27526 enhancement, P5 - low, ---, jonathan.druart+koha, Signed Off , Remove Mod/AddItemFromMarc from additem.pl 12:56 Joubu which will fix those inconsistencies hopefully 12:57 oleonard Let me know if there's anything I can do to help 12:57 oleonard I was playing around with changing out such errors are displayed in Bug 28694 12:57 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28694 enhancement, P5 - low, ---, oleonard, NEW , Check alert in cataloguing should be a modal 13:02 Joubu oleonard: working your patch on top of 27526 to prevent conflicts will be help a lot :) 13:02 Joubu s/working/writing 13:03 oleonard I will do that... I'm not sure that my current proposal is the correct one. 13:07 oleonard Joubu++ 13:07 oleonard 27526 looks like a lot of work 13:09 Joubu not much, yet. But it's the start of something bigger :) If we have the different item forms all using the same code that would be great 13:09 Joubu They have been made unecessarily too complex 13:12 * oleonard biab 13:42 oleonard Oh dangit, patched the wrong bug report :( 13:53 Joubu oleonard: Does my comment on bug 28694 make sense? 13:53 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28694 enhancement, P5 - low, ---, oleonard, NEW , Check alert in cataloguing should be a modal 13:55 marcelr ashimema: i would be bit hesitant to qa 20447 as long as its base is still pending in PQA 13:56 ashimema fair enough 13:56 tuxayo meeting in 5 min! 13:56 ashimema it's in Joubu queue to push so I'm sure it'll happen soon enough 13:56 ashimema dang.. meeting 13:56 ashimema I'm so bad at this 13:56 tuxayo qa_team? rmaints? 13:57 tuxayo qa_team is cait, dcook, amoyano, ashimema, marcelr, kohaputti, jajm, tcohen, kidclamp, khall, tuxayo, petrova, nugged 13:57 tuxayo rmaints is probably fridolin, khall, kidclamp, wainui and tuxayo 14:00 nugged o/ 14:02 ashimema #startmeeting Development IRC meeting 15 July 2021 14:02 huginn Meeting started Thu Jul 15 14:02:41 2021 UTC. The chair is ashimema. Information about MeetBot at http://wiki.debian.org/MeetBot. 14:02 huginn Useful Commands: #action #agreed #help #info #idea #link #topic #startvote. 14:02 huginn The meeting name has been set to 'development_irc_meeting_15_july_2021' 14:02 ashimema #link https://wiki.koha-community.org/wiki/Development_IRC_meeting_15_July_2021 Agenda 14:03 ashimema #topic Introductions 14:03 oleonard #info Owen Leonard, Athens County Public Libraries, Ohio, USA 14:03 ashimema #info please use "#info" in front of your introduction to have it show up in the automatic minutes 14:03 petrova #info Peter (Petro) Vashchuk, National Library of Finland, Helsinki 14:03 ashimema #info Martin Renvoize, PTFS Europe, UK 14:03 tuxayo #info tuxayo/Victor Grousset, France 14:03 Joubu #info Jonathan Druart 14:03 marcelr #info Marcel de Rooy 14:03 thd #info 14:03 Joubu (I might disappear in the middle of the meeting) 14:04 thd #info Thomas Dukleth, Agogme, New York City 14:04 ashimema #chair Joubu 14:04 huginn Current chairs: Joubu ashimema 14:04 ashimema #chair tuxayo 14:04 huginn Current chairs: Joubu ashimema tuxayo 14:04 tuxayo :D 14:04 ashimema #topic Announcements 14:04 ashimema Anyone have anything to announce? 14:05 ashimema did I imagine hackfest dates have come out? 14:05 tuxayo no, it happened 14:06 * tuxayo digs 14:06 Joubu Next year: march 28th - april 1st. 14:06 Joubu " PS : it's not an april fool" 14:06 ashimema #info The next Marseille Hackfest has been announced: March 28th - April 1st. 14:06 ashimema Get those hotels booked :) 14:06 tuxayo thanks Joubu 14:07 Joubu be all there, it will be fun! 14:07 ashimema Paul also suggested that that's the new dates generally going forward didn't he.. 14:07 * oleonard will move mountains to make it 14:07 ashimema so people can plan way ahead now :) 14:08 ashimema moving on 14:08 ashimema #topic Update from the Release manager 14:08 ashimema over to you Joubu 14:08 Joubu I am very slow at everything, sorry about that 14:09 Joubu Bug 17600 is going to be pushed very soon (for real), like tomorrow. It took me way more time than expected. 14:09 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17600 enhancement, P5 - low, ---, jonathan.druart+koha, Passed QA , Standardize the EXPORT 14:09 tuxayo found! https://lists.koha-community.org/pipermail/koha-devel/2021-July/046602.html 14:09 tuxayo #link next hackfest announcement https://lists.koha-community.org/pipermail/koha-devel/2021-July/046602.html 14:09 Joubu I will be back to process the PQA queue beginning of next week and I will deal with the conflicts (on those ones) caused by 17600. 14:10 tuxayo #info and fixed dates for futures ones: 4th week of March 14:10 Joubu that's all :D 14:10 Joubu ha 14:10 ashimema Joubu++ 14:10 ashimema #topic Updates from the Release Maintainers 14:10 Joubu bug 12561, bug 3142, bug 27829, bug 25078 14:10 Joubu and bug 27526 14:10 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12561 enhancement, P5 - low, ---, jonathan.druart+koha, Needs Signoff , Remove non-XSLT views 14:10 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3142 normal, P5 - low, ---, jonathan.druart+koha, Needs Signoff , Standardize how OPAC and staff determine requestability 14:11 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27829 enhancement, P5 - low, ---, koha-bugs, NEW , [OMNIBUS] Remove specific LANG installer data 14:11 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25078 enhancement, P5 - low, ---, jonathan.druart+koha, Signed Off , Update DB process - wrap each DBRev inside a transaction and better error handling 14:11 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27526 enhancement, P5 - low, ---, jonathan.druart+koha, Signed Off , Remove Mod/AddItemFromMarc from additem.pl 14:11 Joubu is my top priority list 14:11 nugged #info Andrew Nugged, National Library of Finland, HELSINKI 14:11 ashimema :) 14:11 nugged ( 🤷â€â™‚ï¸ ) 14:12 ashimema anything to say tuxayo.. think you're the only rmaint here 14:12 tuxayo right! missed the topic 14:13 ashimema well it looks like rmaint has been ticking along ot me 14:13 ashimema so lets move on 14:13 ashimema #topic Updates from the QA team 14:13 ashimema cait 14:13 tuxayo #info RMaint: few backports, one regression found in vairous releases and someone submitted a fix, do all good 14:14 marcelr cait1 14:15 * Joubu disappears 14:15 tuxayo :o 14:15 tuxayo Minimal QA from me in the form of following up on stuff that I tested. 14:16 ashimema #info QA is running OK. Please keep an eye on your emails QA team, cait gives good direction. 14:16 tuxayo indeed! 14:16 ashimema #topic Status of roadmap projects 14:17 ashimema I've not kept up at all this month.. has anything moved on the roadmap? 14:17 ashimema #info Bug 17600 is about to be pushed! :) 14:17 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17600 enhancement, P5 - low, ---, jonathan.druart+koha, Passed QA , Standardize the EXPORT 14:18 ashimema #info Bug 27526 is nearing the top of the RM's priorities again, lets get testing/qaing asap. 14:18 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27526 enhancement, P5 - low, ---, jonathan.druart+koha, Signed Off , Remove Mod/AddItemFromMarc from additem.pl 14:18 ashimema #info Bug 25078 is in good shape, needs a QA eye. 14:18 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25078 enhancement, P5 - low, ---, jonathan.druart+koha, Signed Off , Update DB process - wrap each DBRev inside a transaction and better error handling 14:19 thd I resent an email to people in the wiki group where Joubu had not seen messages from me. 14:19 tuxayo yep, it's greap! 14:19 tuxayo *great 14:19 ashimema #info Accessibility improvements - Bugs attached to bug 28188 - Please help them move forward by testing. 14:19 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28188 minor, P5 - low, ---, bolshawh, ASSIGNED , Accessibility: OPAC - the contrast ratio for text is insufficient [OMNIBUS] 14:20 ashimema #info Wiki migration - Email sent to the wiki group, please reply as necessary. 14:20 thd Gmail treats messages from my mail server as unauthenticated likely junk. 14:20 oleonard ashimema: Wrong bug number? I don't see dependent bugs on 28188 14:20 ashimema #info Bug 22544 is moving forward rapidly, needs a final QA and then next steps 14:20 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22544 enhancement, P5 - low, ---, jonathan.druart+koha, RESOLVED FIXED, Move C4:NewsChannels to Koha namespace 14:20 thd The important thing to know is merely whether someone did not receive a message from me last week. 14:21 ashimema humm.. that's the bug number listed on the roadmap.. seems they've not actually added bugs to it yet :( 14:21 marcelr pushed 14:21 ashimema I did.. but it went to spam again 14:21 ashimema ooh.. pushed now.. damn 14:21 ashimema I can't keep up :) 14:22 marcelr redundancy 14:22 ashimema #info News - I meant bug 24387 14:22 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24387 enhancement, P5 - low, ---, jonathan.druart+koha, Patch doesn't apply , Rename News tool 14:22 ashimema Joubu ^ I couldn't resolve the merge conflict there.. it confused me 14:22 thd ashimema: If you whitelist my domain agogme.com as Joubu did, I promise never to send any actual spam. 14:23 tuxayo ^^ 14:23 ashimema I think the rest of them are further off.. I will send some chaser emails out asap. 14:24 ashimema #topic Actions from last meeting 14:24 thd Part of the issue for acceptance of my mail server is that my mail system actually runs on agogme.net and merely pretends to send from agogme.com . 14:24 ashimema #action ashimema Talk to key players about message passing for alerts 14:24 ashimema I didn't manage to get to that.. too many things on my plate :( 14:25 ashimema #topic General development discussion 14:25 ashimema I don't see any topic listed on the agenda, so we can move on unless anyone has anything they'd like to raise? 14:25 ashimema #topic Review of coding guidelines 14:25 ashimema #info Nothing to discus 14:26 ashimema #topic Set time of next meeting 14:26 nugged Victor wanted to discuss something about action_log and unblessed? 14:26 nugged (Petro?) 14:26 tuxayo oh right! 14:27 ashimema ok.. go for it. 14:27 tuxayo to follow up on the petrova email 14:28 ashimema I don't see an email from petrova 14:29 tuxayo I don't have anything myself to say on the topic but I can relay some things from http://irc.koha-community.org/koha/2021-07-12#i_2364995 14:29 tuxayo email => irc actually 14:29 tuxayo they found there action_logs table grow from 4g to 35g in weeks 14:29 nugged yes 14:30 tuxayo due to some perl blessing thing that caused date ending up in the DB in a very verbose form 14:30 nugged and it was because item MODIFY log entries was 370Kb each 14:30 nugged because two things: indented dumps with lot of spaces (370Kb -> 48Kb not indented) 14:31 marcelr there are some bugs in the queue now for that ? 14:31 tuxayo #info if anyone have a massive increase of action_logs, check out bug 28700 and 28692 14:31 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28700 enhancement, P5 - low, ---, stalkernoid, Needs Signoff , "Unblessed" method in Object.pm has blessed values for keys in some cases 14:32 tuxayo #info and eyes and opinions are needed for the proposed solutions 14:32 nugged and because Object.pm ->unblessed returns DateTime objects inside unblessed results (sometimes and for explained in the ticket reason reason) 14:32 marcelr there is also another one for whitespace 14:32 ashimema #info See bug 28700 and bug 28692 for details around action_logs growth and unblessed. 14:32 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28692 enhancement, P5 - low, ---, stalkernoid, Needs Signoff , Reduce DB action_log table size 14:32 ashimema too slow :) 14:33 nugged yes, these two tickets 14:33 ashimema ok.. lets take a look and get back later on those 14:33 tuxayo So that's the sums of the things. 14:33 tuxayo *sum up 14:33 * ashimema has to go collect kids from school 14:33 ashimema #info Next meeting: 21 July 2021, 14 UTC 14:33 ashimema seem OK to people? 14:33 marcelr huh 6 days 14:33 nugged our libraries started inventory check and get out of space on hosting :). 14:33 tuxayo in 6 days? 14:33 nugged ok then. 14:34 ashimema ack 14:34 ashimema I emant 28th 14:34 ashimema #info Next meeting: 28 July 2021, 14 UTC 14:34 ashimema my bad 14:34 ashimema thanks# 14:34 tuxayo good to me :) 14:34 * ashimema will not be around for 28th, but I'm sure someone can run it for us ;) 14:34 ashimema #endmeeting 14:34 huginn Meeting ended Thu Jul 15 14:34:51 2021 UTC. Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4) 14:34 huginn Minutes: https://meetings.koha-community.org/2021/development_irc_meeting_15_july_2021.2021-07-15-14.02.html 14:34 huginn Minutes (text): https://meetings.koha-community.org/2021/development_irc_meeting_15_july_2021.2021-07-15-14.02.txt 14:34 huginn Log: https://meetings.koha-community.org/2021/development_irc_meeting_15_july_2021.2021-07-15-14.02.log.html 14:34 tuxayo ashimema++ 14:34 ashimema thanks chaps 14:35 tuxayo See you all. 14:35 * tuxayo runs for groceries 14:58 jim_ anyone here 14:58 oleonard jim_: Whether anyone is here depends on what your question is ;) 15:00 jim_ Sir I have barcoades which are 7 digits but I want to make it 6 15:00 jim_ what are ways I can edit 15:03 oleonard You can change item barcodes in the Cataloging module using the item edit form. 15:05 jim_ that is individually I have around a 100 such barcodes to edit 15:05 jim_ so I want to edit in a range or in bulk 15:07 oleonard I don't believe Koha offers any way to do that. You could export your records, manipulate them outside of Koha, and then re-import them. 15:07 caroline_catlady I agree with oleonard I don't think you can do that inside Koha 15:07 oleonard Barcodes are generally assumed to be a physical label on an item, so bulk changes of barcodes involves physical alteration of the items. It's not usually an automated process. 15:08 caroline_catlady maybe it could be possible in the db directly 15:08 caroline_catlady something like update items set barcode = right(barcode, 6); 15:08 caroline_catlady I haven't tried it so test it first 15:11 jim_ Caroline if this could be tried I think it would be of great help 15:11 jim_ to others also if someone face such an issue 15:13 caroline_catlady jim_: can you give me an example of a barcode that you have and what you want it to be? 15:14 caroline_catlady like 1234567 -> 234567 15:16 reiveune bye 15:17 jim_ yes for example i have a barcode 5801 I want a 0 to it and another barcode I000898 with an extra 0 15:18 jim_ So I want them to be modified as per 6 digit 15:18 jim_ 5801 in this it should be 05801 15:19 jim_ 5801 sorry i mean 005801 15:28 caroline_catlady jim_: ok for this case (where the barcode is shorter than 6 digits) you can do this command in the db 15:28 caroline_catlady update items set barcode = lpad(barcode,6,0) where length(barcode) <= 6; 15:29 caroline_catlady I just tried it and it gave me 15:29 caroline_catlady MariaDB [koha_v20_dev_inlibro]> select barcode from items where barcode like "%5801%"; 15:29 caroline_catlady +---------+ 15:29 caroline_catlady | barcode | 15:29 caroline_catlady +---------+ 15:29 caroline_catlady | 005801 | 15:29 caroline_catlady +---------+ 15:29 jim_ this command I need to put in SQl right 15:29 caroline_catlady yes exactly 15:29 jim_ Wo great 15:29 caroline_catlady try it on a test db first if you can 15:30 caroline_catlady or at least backup your db 15:30 jim_ yes I have a test one at home 15:30 caroline_catlady great 15:32 jim_ i saw a SQL report can I share here can that be modified to achieve the other issue I wonder 15:33 caroline_catlady the other issue being the longer barcodes? 15:33 jim_ yes 15:34 caroline_catlady what shoudl I000898 become? 15:34 jim_ where the 0 is extra within a barcode 15:34 jim_ yes it has an extra 0 15:34 caroline_catlady so the end result should be I00898? 15:35 jim_ correct 15:35 caroline_catlady hm, this one is harder... 15:36 caroline_catlady I don't think it's possible to change those in bulk, at least I don't have the knowledge for it 15:36 jim_ Oww 15:37 caroline_catlady maybe you can try asking on the mailing list https://koha-community.org/support/koha-mailing-lists/ 15:38 jim_ Thank you for your help 15:38 jim_ and sorry for the trouble 15:57 jim_ can we map 852 data to 952 16:11 jim_ anyone here 17:38 cait1 @later tell jim_: you could, but don't do it. The indexing is set up for 952, much easier to change your data than to adapt all necessary configuration 17:38 huginn cait1: The operation succeeded. 18:34 tuxayo @later tell jim : you could, but don't do it. The indexing is set up for 952, much easier to change your data than to adapt all necessary configuration 18:34 huginn tuxayo: The operation succeeded. 18:35 tuxayo We are covered whether their nickname will be jim or jim_ 23:55 dcook I love how Paul Evans wants people to use Object::Pad in their code and yet it's experimental so who is going to actually do that...