IRC log for #koha, 2020-12-29

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
00:27 koha-jenkins Project Koha_20.05_U2010 build #65: STILL UNSTABLE in 46 min: https://jenkins.koha-community[…]a_20.05_U2010/65/
00:33 Project Koha_20.05_D9 build #166: STILL UNSTABLE in 43 min: https://jenkins.koha-community[…]oha_20.05_D9/166/
00:56 inlibro joined #koha
01:56 inlibro joined #koha
02:35 khall joined #koha
02:57 inlibro joined #koha
03:55 khall joined #koha
03:57 inlibro joined #koha
04:57 inlibro joined #koha
04:57 Oak joined #koha
05:57 inlibro joined #koha
06:08 josef_moravec joined #koha
06:57 inlibro joined #koha
07:29 josef_moravec joined #koha
07:37 did joined #koha
07:58 inlibro joined #koha
08:01 lds joined #koha
08:03 cait joined #koha
08:09 cait1 joined #koha
08:09 cait1 good morning #koha
08:18 liliputech_asu joined #koha
08:20 fridolin joined #koha
08:24 davewood joined #koha
08:29 davewood_ joined #koha
08:30 davewood joined #koha
08:35 davewood hi, is there a prefered way to delete books from the koha database?
08:36 im testing a catmandu fixer script and just want to wipe the DB
08:46 liliputech_asu joined #koha
08:58 inlibro joined #koha
09:34 ashimema C4::Biblio::DelBiblio.. perhaps?
09:54 davewood bulkmrcimport.pl has a flag to delete
09:54 -d  Delete EVERYTHING related to biblio in koha-DB before import.
09:54 Tables: biblio, biblioitems, items
09:56 but that gives me foreign key constraing violation errors. my confidence in this script workin at all is not very high.
09:58 inlibro joined #koha
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[…]_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 http://paste.scsys.co.uk/594293
10:41 cait1 hm can you file a bug report please?
10:41 we have tightened some things in the db, this might be a side effect
10:41 but basically... you have issues
10:41 Ausleihen
10:41 so it's correct in failing
10:41 if you truncate the issues first this is probably going to work better
10:42 the script is not supposed to be used once you have loaded other transactional data atm
10:42 for the same data...
10:43 magnuse \o/
10:44 cait1 hi magnuse :)
10:44 has someone done very basic subscriptions in migration?
10:44 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 would you recommend against it?
10:47 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 but have been wondering
10:50 I*ll do some testing with manual imports
10:58 inlibro joined #koha
10:59 cait1 hm subscription.status - it's not the one to indicate if cancelled... so what is it? :)
10:59 no comment on schema
10:59 varchar 100
11:01 fridolin Bug 27310
11:01 huginn Bug http://bugs.koha-community.org[…]_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
11:29 fridolin joined #koha
11:31 kidclamp joined #koha
11:41 josef_moravec joined #koha
11:58 inlibro joined #koha
12:11 did joined #koha
12:56 cait1 fist find: you need subsriptionhistory because GetSubscription is a little dumb
12:57 davewood cait1: https://bugs.koha-community.or[…]_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
12:58 inlibro joined #koha
13:09 liliputech_asu joined #koha
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 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:34 did joined #koha
13:42 cait1 Next find: serial is required because GetFullDescription is a little dumb too ;)
13:42 SarahD joined #koha
13:42 magnuse dumb and dumber...
13:42 bdonnahue1 joined #koha
13:42 cait1 kind of
13:42 WHERE     serial.subscriptionid = 2
13:43 in GetFullSubscription
13:43 well it's based on serial so there is no way out really
13:44 it's also interesting that we have biblionumber in all tables
13:44 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 I assume these are an internal XML format, not MARCXML?
13:47 SarahD Correct
13:51 From here: https://medlineplus.gov/xml.html
13:51 fridolin joined #koha
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 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 classification/categorisation data isn't it?
13:55 I have very vague recollections though I'm afraid.. must have been at least 5 years ago
13:56 but it was around medical terms too
13:56 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!
13:59 inlibro joined #koha
14:14 magnuse have fun #koha - see you next year!
14:43 liliputech_asu joined #koha
14:59 inlibro joined #koha
15:02 tcohen What is needed, is a plugin that takes care of the conversion
15:03 and then, use the regular workflow for importing
15:06 cait1 true, would be a good case for an import plugin
15:06 but i think at the moment we don't have many examples for that type at all?
15:11 deb-CSPL joined #koha
15:41 tcohen there's the CSV2MARC one
15:42 https://github.com/bywatersolu[…]a-plugin-csv2marc
15:42 we added some pretty awesome enhancements recently
15:42 we should port it into Koha
15:44 cait1 hm how do you mean? as a core feature?
15:44 i've only ever seen the CSV one
15:44 workign with XML like the medline woudl need a different base one as a model
15:47 liliputech_asu joined #koha
15:52 tcohen I mean the CSV one could be a core feature
15:52 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
15:59 inlibro joined #koha
16:05 fridolin left #koha
16:11 lisettelatah joined #koha
16:19 ashimema k
16:19 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[…]_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:37 lukeG joined #koha
16:39 cait1 isn't HAVING standard?
16:39 ashimema it is..
16:39 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 ok, I don't know about that
16:40 I used it in my reports somewhat regularly
16:40 time to sign off - cya tomorrow!
16:41 cait1 left #koha
16:41 ashimema for reference cait1: https://bugs.mysql.com/bug.php?id=80455
16:49 lukeG joined #koha
16:59 inlibro joined #koha
17:22 Oak joined #koha
17:25 tuxayo ashimema: hi :)
17:25 For reference, MySQL 5.6 EOL is Feb 2021
17:25 https://en.wikipedia.org/wiki/[…]L#Release_history
17:26 Like in 1 month ^^
17:30 It seems most distros jumped from 5.5 to 5.7
17:30 https://pkgs.org/search/?q=mysql-server
17:52 paul_p joined #koha
17:59 inlibro joined #koha
18:32 Oak joined #koha
18:59 inlibro joined #koha
19:36 paul_p joined #koha
19:39 paul_p joined #koha
19:43 paul_p joined #koha
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 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 paul_p joined #koha
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 *tests
19:48 tcohen good team :-D
19:50 paul_p joined #koha
19:50 tuxayo :D
19:51 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:52 paul_p joined #koha
19:53 tuxayo really? I'm lacking info on this so I don't know on which side to lean
19:54 > really?
19:54 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 paul_p joined #koha
19:59 tcohen there are JavaScript or Python libraries for that as well
20:00 inlibro joined #koha
20:09 paul_p joined #koha
20:17 paul_p joined #koha
20:21 paul_p joined #koha
20:23 tuxayo tcohen: Indeed that's a solution, moving to an official lib
20:23 paul_p joined #koha
20:24 paul_p joined #koha
20:28 paul_p joined #koha
20:32 paul_p joined #koha
21:00 inlibro joined #koha
21:07 paul_p joined #koha
21:56 sarahd joined #koha
22:00 inlibro joined #koha
23:00 inlibro joined #koha

← Previous day | Today | Next day → | Search | Index

koha1