Time Nick Message 00:27 koha-jenkins Project Koha_20.05_U2010 build #65: STILL UNSTABLE in 46 min: https://jenkins.koha-community.org/job/Koha_20.05_U2010/65/ 00:33 koha-jenkins Project Koha_20.05_D9 build #166: STILL UNSTABLE in 43 min: https://jenkins.koha-community.org/job/Koha_20.05_D9/166/ 08:09 cait1 good morning #koha 08:35 davewood hi, is there a prefered way to delete books from the koha database? 08:36 davewood im testing a catmandu fixer script and just want to wipe the DB 09:34 ashimema C4::Biblio::DelBiblio.. perhaps? 09:54 davewood bulkmrcimport.pl has a flag to delete 09:54 davewood -d Delete EVERYTHING related to biblio in koha-DB before import. 09:54 davewood Tables: biblio, biblioitems, items 09:56 davewood but that gives me foreign key constraing violation errors. my confidence in this script workin at all is not very high. 10:10 cait1 davewood: which version? 10:10 wahanui rumour has it which version is thiis 10:11 cait1 I believe bug 12488 should have fixed your issue 10:11 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12488 normal, P5 - low, ---, magnus, CLOSED FIXED, Make bulkmarcimport.pl -d use DELETE instead of TRUNCATE 10:15 cait1 davewood: depending on the number of records the bulk delete tool might also work for you - but it will move them to deletedbiblio etc. 10:36 davewood koha 20.11 10:39 davewood http://paste.scsys.co.uk/594293 10:41 cait1 hm can you file a bug report please? 10:41 cait1 we have tightened some things in the db, this might be a side effect 10:41 cait1 but basically... you have issues 10:41 cait1 Ausleihen 10:41 cait1 so it's correct in failing 10:41 cait1 if you truncate the issues first this is probably going to work better 10:42 cait1 the script is not supposed to be used once you have loaded other transactional data atm 10:42 cait1 for the same data... 10:43 magnuse \o/ 10:44 cait1 hi magnuse :) 10:44 cait1 has someone done very basic subscriptions in migration? 10:44 cait1 i basically need them for orders - they will have to be edited later 10:45 magnuse hiya cait1 10:45 cait1 i wonder if i need to go full way with the history table and serial table too or if i can cheat and do just a basic entry in subscripion 10:45 magnuse never tried it 10:46 cait1 thx for the honest answer :) 10:46 cait1 would you recommend against it? 10:47 cait1 the system we are migrating from has stnding order, normal orders and subscription orders... I'd like to do the same in Koha 10:47 cait1 but have been wondering 10:50 cait1 I*ll do some testing with manual imports 10:59 cait1 hm subscription.status - it's not the one to indicate if cancelled... so what is it? :) 10:59 cait1 no comment on schema 10:59 cait1 varchar 100 11:01 fridolin Bug 27310 11:01 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27310 minor, P5 - low, ---, fridolin.somers, Needs Signoff , Wrong CSS float on 'Visibility' in framework edition 11:01 fridolin staff interface needs to be perfect ;) 11:16 magnuse cait1: worth a try, i'd say 12:56 cait1 fist find: you need subsriptionhistory because GetSubscription is a little dumb 12:57 davewood cait1: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27313 12:57 huginn Bug 27313: enhancement, P5 - low, ---, koha-bugs, NEW , bulkmarcimport.pl -d foreign key constraint fails 12:57 davewood thanks for the help so far 13:21 magnuse should an atomicupdate file for just adding a syspref still be a .sql file, or is .perl preferred? 13:22 cait1 perl is always preferred afaik 13:22 cait1 i guess it makes sense, because it's easier to copy and paste for RM 13:33 magnuse yeah, that's what i thought too 13:42 cait1 Next find: serial is required because GetFullDescription is a little dumb too ;) 13:42 magnuse dumb and dumber... 13:42 cait1 kind of 13:42 cait1 WHERE serial.subscriptionid = 2 13:43 cait1 in GetFullSubscription 13:43 cait1 well it's based on serial so there is no way out really 13:44 cait1 it's also interesting that we have biblionumber in all tables 13:44 cait1 subscription, subscirpitonhistory and serial 13:46 SarahD Hello! Curious if anyone here has integrated MedlinePlus XML records into Koha? 13:47 cait1 hi Sarah 13:47 cait1 I assume these are an internal XML format, not MARCXML? 13:47 SarahD Correct 13:51 SarahD From here: https://medlineplus.gov/xml.html 13:52 cait1 Koha can only work with MARC data, so I think you wil have to convert it to import them into Koha 13:53 cait1 ashimema: have you seen data like that? 13:53 SarahD Ah, yes I knew that. Just wanted to see them in someone else's catalog to show to my supervisor what's possible. looking for an example. 13:54 ashimema I have migrated/imported similar authority data somewhere I think 13:55 ashimema classification/categorisation data isn't it? 13:55 ashimema I have very vague recollections though I'm afraid.. must have been at least 5 years ago 13:56 ashimema but it was around medical terms too 13:56 ashimema we've done similar for legal terms I believe 13:57 cait1 Sarah: there are some health related libraries on the mailing list I think - maybe worth trying there as well 13:58 SarahD I'll give that a shot. Thanks! 14:14 magnuse have fun #koha - see you next year! 15:02 tcohen What is needed, is a plugin that takes care of the conversion 15:03 tcohen and then, use the regular workflow for importing 15:06 cait1 true, would be a good case for an import plugin 15:06 cait1 but i think at the moment we don't have many examples for that type at all? 15:41 tcohen there's the CSV2MARC one 15:42 tcohen https://github.com/bywatersolutions/koha-plugin-csv2marc 15:42 tcohen we added some pretty awesome enhancements recently 15:42 tcohen we should port it into Koha 15:44 cait1 hm how do you mean? as a core feature? 15:44 cait1 i've only ever seen the CSV one 15:44 cait1 workign with XML like the medline woudl need a different base one as a model 15:52 tcohen I mean the CSV one could be a core feature 15:52 tcohen and yes, the XML would need a different piece of code, to handle XML instead of CSV, and the mappings could need to be different 16:19 ashimema k 16:19 ashimema are we allowed to use HAVING clauses yet? 16:20 * ashimema is trying to ressurect bug 11983 16:20 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11983 normal, P5 - low, ---, martin.renvoize, In Discussion , Code to select patrons to purge needs to be centralized (use of filter_by) 16:39 cait1 isn't HAVING standard? 16:39 ashimema it is.. 16:39 ashimema but mysql 5.5 and 5.6 had a broken implementation I believe 16:40 cait1 https://en.wikipedia.org/wiki/Having_(SQL) 16:40 cait1 ok, I don't know about that 16:40 cait1 I used it in my reports somewhat regularly 16:40 cait1 time to sign off - cya tomorrow! 16:41 ashimema for reference cait1: https://bugs.mysql.com/bug.php?id=80455 17:25 tuxayo ashimema: hi :) 17:25 tuxayo For reference, MySQL 5.6 EOL is Feb 2021 17:25 tuxayo https://en.wikipedia.org/wiki/MySQL#Release_history 17:26 tuxayo Like in 1 month ^^ 17:30 tuxayo It seems most distros jumped from 5.5 to 5.7 17:30 tuxayo https://pkgs.org/search/?q=mysql-server 19:43 tuxayo tcohen++ thanks for the review, I'll be able to write more UI tests now :D 19:44 tcohen tuxayo++ you did a gretat job 19:45 tuxayo tcohen: thanks, it was a good way to get the hands on the tooling :) 19:46 tcohen indeed 19:46 tcohen I always stayed away from selenium 19:47 tuxayo hehe, for me it's the unit and integration tests that I struggle with 19:47 * tcohen knows he will regret saying this, but 'I enjoy writing tests' 19:48 tuxayo For me it's UI test :P 19:48 tuxayo *tests 19:48 tcohen good team :-D 19:50 tuxayo :D 19:51 tuxayo I hope future selenium versions support will be there in our perl lib or that we will find an alternative before having too much perl Selenium tests to port. 19:52 tcohen we really need to find something else 19:53 tuxayo really? I'm lacking info on this so I don't know on which side to lean 19:54 tuxayo > really? 19:54 tuxayo Indeed the words or our lib maintainer aren't encouraging ^^" 19:57 tcohen we could keep doing Selenium, but not using the Perl library for that 19:59 tcohen there are JavaScript or Python libraries for that as well 20:23 tuxayo tcohen: Indeed that's a solution, moving to an official lib