← 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