| Time |
S |
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 |
|
koha-jenkins |
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 |
|
davewood |
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 |
|
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. |
| 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 |
|
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: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 |
|
cait1 |
no comment on schema |
| 10:59 |
|
cait1 |
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 |
|
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: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 |
|
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: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 |
|
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! |
| 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 |
|
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:11 |
|
|
deb-CSPL joined #koha |
| 15:41 |
|
tcohen |
there's the CSV2MARC one |
| 15:42 |
|
tcohen |
https://github.com/bywatersolu[…]a-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:47 |
|
|
liliputech_asu joined #koha |
| 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 |
| 15:59 |
|
|
inlibro joined #koha |
| 16:05 |
|
|
fridolin left #koha |
| 16:11 |
|
|
lisettelatah joined #koha |
| 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[…]_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 |
|
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 |
|
|
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 |
|
tuxayo |
For reference, MySQL 5.6 EOL is Feb 2021 |
| 17:25 |
|
tuxayo |
https://en.wikipedia.org/wiki/[…]L#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 |
| 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 |
|
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 |
|
|
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 |
|
tuxayo |
*tests |
| 19:48 |
|
tcohen |
good team :-D |
| 19:50 |
|
|
paul_p joined #koha |
| 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: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 |
|
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 |
|
|
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 |
