Time Nick Message 23:04 * CrispyBran waves goodbye 22:45 caroline have a good weekend all! 20:56 caroline I never paid attention to be honest, other than when it broke everything and suddenly my order was 3999$ instead of 39.99$ 20:54 tuxayo we can see that on unfocus. 20:54 tuxayo caroline (IRC): In fines, some of field work with both but It's JavaScript that replaces commas with dots 20:53 tuxayo caroline (IRC): Maybe in aquision actually, I don't know it enough 20:37 caroline you mean other than fines and acquisitions? 20:36 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21507 major, P5 - low, ---, koha-bugs, NEW , Decimal separators issues in patrons payments/fines, simplified 20:36 tuxayo This is to mutualize the server side code handling this. Because that's what I need for bug 21507 20:36 tuxayo caroline (IRC) Do you know areas in Koha where decimal numbers can be written with both «.» or «,» ? (or maybe follow the CurrencyFormat syspref) Because i'm sure I have found such a thing. 20:36 tuxayo ^_^ 20:31 caroline friendly test plans get tested :) 20:31 caroline very important point! 20:30 tuxayo Also the test plan will be less scary :) 20:30 tuxayo I thinks that a good idea because we might have to do at once many decimal fields in acquisitions and it's difficult to test. So wanting to fix acquisitions at the same time might cause payement/fines fix to take longer to be merged 20:29 caroline ok 20:29 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12310 major, P5 - low, ---, victor.grousset, BLOCKED , Decimal separators issues in patrons payments/fines 20:28 tuxayo caroline (IRC): QA feedback on bug 12310 (it's predecessor) made me scope it only on fines. So I prefer to keep that. 20:26 caroline won't 21507 fix 18723? 20:26 tuxayo My plan after bug 21507 is to do the same for 18723 20:26 tuxayo I coundln't find time until the last few days for this :( 20:25 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21507 major, P5 - low, ---, koha-bugs, NEW , Decimal separators issues in patrons payments/fines, simplified 20:25 tuxayo caroline (IRC): bug 21507 18:56 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18723 critical, P5 - low, ---, josef.moravec, Failed QA , Dot not recognized as decimal separator on receive 18:56 caroline yes there it is bug 18723 18:54 caroline I think so... That needs to be fixed before the release 18:54 caroline Did we talk about the decimal dot multiplying the actual cost upon receiving? 18:53 ashimema Now I just need to find a QA in the remaining hours 18:53 caroline :D 18:53 ashimema caroline++ 18:47 CrispyBran Anyone know what makes an item consigned? 18:44 ashimema Have a good one #koha 18:44 * ashimema is tired and take a well earned weekend 18:43 ashimema Slushy slush slush 18:26 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21758 enhancement, P5 - low, ---, koha-bugs, NEW , Navigation in Z39.50 result pages not working in Acquisitions 18:26 caroline Could someone check bug 21758 and tell me if it's just my system that's broken? 17:58 lukeG Has anyone expereinced problems with audio-alerts not sounding/playing in 18.05.05? 17:56 huginn mtompset: tuxayo was last seen in #koha 2 hours, 56 minutes, and 25 seconds ago: <tuxayo> mtompset (IRC) around for a chat? 17:56 mtompset @seen tuxayo 17:56 mtompset Oops... 16:04 reiveune bye 15:56 josef_moravec oleonard++ 15:28 oleonard See y'all later 15:23 caroline Your MARC record will have 5 x 852 (or 952) fields 15:22 caroline it's like if you have a record of Harry potter and the philosopher's stone, but you have 5 copies of that book. You will have one record describing the title, author, publisher, etc. and 5 items with each their barcode, their status, etc. 15:21 oleonard All this data is in the MARC record, but the item information is separated in this display 15:20 oleonard The table at the bottom lists the items 15:20 oleonard Archie^: Look at the MARC view of this book in our catalog: https://search.myacpl.org/cgi-bin/koha/opac-MARCdetail.pl?biblionumber=543826 15:20 Archie^ ahh i think i got it 15:19 caroline the book itself is th item 15:19 Archie^ so basically if a person checks out a book, then this record of checking the book out is considered an item? 15:10 oleonard The item has an identifier like a barcode, and it is associated with a particular library 15:10 oleonard An item is the part of the record which identifies the physical instance of that record 15:09 Archie^ sorry for all the confusion, still fairly new to Library game ;D 15:09 Archie^ im not sure what items is in this context 15:08 caroline Then you can tell it to import only the items from the records that are duplicates 15:08 caroline in Administration > Record matching rules https://koha-community.org/manual/18.11/en/html/administration.html#record-matching-rules 15:07 caroline or multiple fields 15:07 oleonard Archie^: The import process can check for duplicates based on a unique field of your choice 15:06 Archie^ i'm fairly comfused myself :S 15:06 Archie^ i had in my mind something like.. im adding books from alis and koha checks for duplicates, sees that it is already in Koha but adds some sort of .. + 1 that it is available in this new library 15:05 Archie^ so ok we have to systems here, one is Aleph and one is Alis, the aleph one is master system that pretty much holds all catalogue of books in country and alis is little libraries etc. so if i get full dump of alpeh into koha (onlythe books, nothing else interests me from aleph) and i want to add books into from alis libraries it will just find it as a duplicate and dismiss? 15:03 Archie^ ok then i have another issue :D 15:02 caroline if you need help with the mapping, I can help you, that's pretty much what I do all day these days :) 15:01 caroline You'll have to check the records for item information and map them to Koha's item fields https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) 15:00 caroline Archie^: the official MARC field for items is 852, but it varies from system to system http://www.loc.gov/marc/bibliographic/bd852.html 14:59 tuxayo mtompset (IRC) around for a chat? 14:55 eythian it's very likely you'll have to do something to convert the item records you have to the form that koha expects - every system does that bit differently. 14:52 Archie^ it's an old legacy system created specifically for my country called Alis 14:50 caroline What system are you migrating from? 14:49 caroline For homelibrary, it's 952$a 14:48 caroline Archie^: items in Koha are in fields 952. Make sure your records have that information 14:48 oleonard I don't know what kind of record you're getting out of the old system, but ideally it would already contain item information 14:47 Archie^ so that's not something that should be added in MARC21 file? i mean ... does that mean i have to take different approach into migrating the data rathen then marc21xml upload that already exists in KOHA 14:46 oleonard Archie^: To show that a book is available at a particular library you must add an item record specific to that library. Multiple item records can be added to a single bibliographic record. 14:44 Archie^ what i dont understand is, if i upload these books into koha via marc21xml upload then there is no option to link these books that they are available in this certain library 14:44 Archie^ Right so basically we just got access to database of another library. The plan is to create Master Koha with a bunch of different libraries being able to connet to it.So i have access to DB and they have all the books they store in access as MARC21XML. So we are in a stage that we want to migrate all data to koha as a proof of concept that koha is better solution etc 14:42 oleonard Ask away Archie^, and if someone can they'll answer 14:41 Archie^ Hey guys, so im having an issue with migrating to Koha. does anyone have a couple of minutes? 14:26 wahanui wish i knew, oleonard 14:26 oleonard wahanui: Bro do you even nerd? 14:16 wahanui fridolin: huh? 14:16 fridolin wahanui: Obi-Wan Kenobi 14:15 wahanui fridolin: huh? 14:15 fridolin wahanui: watts 14:15 wahanui fridolin: what? 14:15 fridolin wahanui ba bene 14:15 fridolin ve bene wahanui 14:15 fridolin va bene 14:15 wahanui que tal, fridolin 14:15 fridolin hi 14:15 tcohen hi 14:14 mtompset Greetings, fridolin 14:14 mtompset Nope... not with IPv6 here. 14:14 mtompset Greetings, #koha ashimema Joubu caroline oleonard tcohen 13:52 fridolin k 13:28 tcohen morning 13:27 Joubu Anybody around is connected with an IPv6 address? 13:20 oleonard Hi caroline 13:10 caroline hi #koha! 13:07 Joubu 19185 is waiting for a SO as well 13:07 ashimema in fact.. I thought I had signed it off 13:06 ashimema I can sign it off.. as I've already tested it.. 13:06 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19821 enhancement, P5 - low, ---, julian.maurice, Needs Signoff , Run tests on a separate database 13:06 ashimema I thought it was pretty much blocked by bug 19821 Joubu 13:04 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19185 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , Web installer and onboarding tool selenium test 13:04 Joubu #koha - I know I asked it a dozen of times already but as today it's ft slush I must ask again. I really believe that bug 19185 must be part of 18.11. We need more tests! 13:00 ere (also the common settings affect harvesting) 12:59 ere oleonard: If you happen to need anything for reference, there's always RecordManager that I've written. Wrong programming language, though, but e.g. the configuration might be of use: https://github.com/NatLibFi/RecordManager/wiki/Data-Source-Configuration#oai-pmh-harvesting-specific-settings 12:58 oleonard Joubu: I guess we should consider ourselves lucky that this kind of issue happens so infrequently 12:57 Joubu oleonard: I think the last changes were quite good :) The problem is that browsers do not interpret/implement the specs identically... 12:57 oleonard Sounds typical for library data exchange... 12:57 ere oleonard: In practice you typically need two config options for the format: the format you request using the metadataPrefix, and the actual format the provider returns. Some servers don't follow the guidelines, and there are no standard prefixes for all formats, so what you call it and they call it may not match.. 12:56 * oleonard is disappointed that fixFloat is so fragile 12:55 oleonard Thanks ere. I'll leave it for now and bring it up with dcook 12:55 ere oleonard: I haven't really, so this is simply theoretical about the protocol. But usually metadataPrefix is part of harvesting source configuration and resumptionToken is only used internally by the harvester. However, the harsh reality is that sometimes you need to restart harveting from a given resumptionToken to avoid reharvesting everything you already got before something glitched. 12:48 oleonard I would like to put as much client-side validation into that form as we can, but I'm not familiar with the requirements 12:46 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10662 new feature, P3, ---, dcook, Signed Off , Build OAI-PMH Harvesting Client 12:46 oleonard ere: Have you looked at Bug 10662? I don't see an input for resumptionToken in the "new request" form so I wonder if that case needs to be considered. 12:45 ashimema me too 12:45 ashimema mm 12:44 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20996 normal, P5 - low, ---, andrew.isherwood, Pushed to Master , Fix API response time on ILL request endpoint 12:44 Joubu ashimema: I bet it is caused by bug 20996 12:44 ere oleonard: with resumptionToken you must not send metadataPrefix (nor with verb=Identify etc.). so it's not always mandatory 12:44 ashimema and AndrewIsh is on leave today 12:44 ashimema which as much as I should be.. I'm no expert in at the moment 12:43 ashimema I was about to take a look.. seems like it's ILL :( 12:43 ashimema kidclamp is at training 12:43 Joubu Who's fixing Jenkings? ashimema, kidclamp? 12:42 ere apart from when using a resumptionToken 12:34 oleonard (client-side) 12:34 oleonard Okay, so making it a required field makes sense 12:34 josef_moravec it is required by OAI-PMH standard 12:34 oleonard The error messages implies that it is, "[metadataPrefix is a required field for an OAI-PMH request.]" 12:33 oleonard josef_moravec: Do you know if metadataPrefix is always required? 12:10 oleonard Thanks josef_moravec 12:09 josef_moravec and remove line 11 - unique key 12:08 josef_moravec oleonard: for workaround you could edit /installer/data/mysql/atomicupdate/bug_10662.sql 12:08 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21273 major, P5 - low, ---, koha-bugs, NEW , After upgrade from 17.11.08 to 18.05.02 intra not working, Software error: Template process failed 12:08 Joubu ok it's not the exact same error as bug 21273 12:07 josef_moravec ah, looks like dcook does not submit tha patch for this yet 12:07 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10662 new feature, P3, ---, dcook, Signed Off , Build OAI-PMH Harvesting Client 12:07 oleonard Joubu: Trying to test Bug 10662 12:07 Joubu what are you doing? 12:06 Joubu haaa! 12:05 oleonard josef_moravec: Did you encounter that too? 12:04 oleonard josef_moravec: I get an error when I try to run the database update. "Specified key was too long; max key length is 767 bytes" 12:03 Joubu How is going the feature slush? 12:03 Joubu hi #koha 11:59 * oleonard was just trying to wrap his head around whether we need both Select2 and jquery.multiple.select.js 11:59 oleonard Sure 11:59 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10662 new feature, P3, ---, dcook, Signed Off , Build OAI-PMH Harvesting Client 11:59 josef_moravec oleonard: could I ask you to have a look at bug 10662? There are some datatable styling issues 11:58 wahanui hi oleopard 11:58 josef_moravec hi oleonard 11:25 marcelr htg bye #koha 11:23 ashimema ta 11:23 ashimema I shall go take a look 11:23 ashimema :9 11:23 marcelr ashimema: ill request tests are sick ;_ 11:20 Guest1933 Project Koha_Master_D8 build #89: UNSTABLE in 37 min: https://jenkins.koha-community.org/job/Koha_Master_D8/89/ 11:18 wahanui hi oleopard 11:18 marcelr hi oleonard 11:17 oleonard Hi #koha 11:14 Guest1933 Project Koha_Master_U18 build #83: UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_Master_U18/83/ 11:13 Guest1933 Project Koha_Master_D9 build #594: UNSTABLE in 29 min: https://jenkins.koha-community.org/job/Koha_Master_D9/594/ 10:59 ashimema have fun 10:59 kidclamp Things are good, heading to do a training today so can look at that but when back 10:55 ashimema hows things otherwise? 10:55 ashimema ;) 10:55 ashimema any chance you could add 19066 to the pushed pile pretty please.. I'd like to start rebasing some bits I'm working on atop it. 10:46 kidclamp Out most of today, so wanted to keep the queue from getting too big :-) 10:45 marcelr hey kidclamp woke up 10:43 josef_moravec kidclamp++ 10:42 huginn News from kohagit: Bug 14385: Extend OpacHiddenItems to allow specifying exempt borrower categories <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5e4e10c4ca558180137bf5a4ff5a68495efa0ec7> 10:42 huginn News from kohagit: Bug 14385: (follow-up) C4::Borrowers not found <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8b7a7a2bb34609c402117933625e06e1b8e2cd69> 10:42 huginn News from kohagit: Bug 14385: (follow-up) Changes to sysprefs.sql and atomicupdate <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e31e0e5daa764892dfb7878696cb1159d27c3a1c> 10:42 huginn News from kohagit: Bug 14385: Squash of a lot of patches rebased <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e1b5fa657de843a177fb4bf57947a1376152d021> 10:42 huginn News from kohagit: Bug 20968: Add hooks into cat-toolbar.inc to display buttons <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=741f17e916a3f64d71b55fd87065136307e3bae7> 10:42 huginn News from kohagit: Bug 20968: (follow-up) Respond to feedback <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7910a530b85b6ee42307d41cba57b95ced2aca27> 10:42 huginn News from kohagit: Bug 20968: Add unit tests <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=60ca17c616e6026fbd271fb3f99473f3ef7edf00> 10:42 huginn News from kohagit: Bug 20968: Rename method get_intranet_catalog_toolbar_button to intranet_catalog_bibl... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e87fa069dc3d10284a2bd31b7c7913132fed5d06> 10:42 huginn News from kohagit: Bug 20968: (follow-up) Replace tabs with spaces <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9783773ada4dec115342a4f8f16b29eb5b98cc2f> 10:42 huginn News from kohagit: Bug 20996: Further enhance performance <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3fb44a8bd63663fb7c4d93e85c30d58d9b2ce08f> 10:42 huginn News from kohagit: Bug 20996: (follow-up) Add <branch> to conf tpl <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8e8f26f2cb2195f1e07136898320875dc055aad4> 10:42 huginn News from kohagit: Bug 20996: (follow-up) Fix column name expectation <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4ffd2d3b347072f6422adb98608859264ba269d6> 10:42 huginn News from kohagit: Bug 21501: Remove dead code from course reserves module <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=84857caaef467b7c3dfa82404143de8dc41fc858> 10:42 huginn News from kohagit: Bug 14385: (QA follow-up) Additional changes and fixes <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=70651422a7517338a68e22321d9918757746ef33> 10:42 huginn News from kohagit: Bug 21606: [sql_modes] Fix matching rules insert <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=32c4dbfd6814f01ae2b430e88f13b89bd374f34f> 10:42 huginn News from kohagit: Bug 21640: Enable output to STDOUT for Itiva outbound script <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=12ed04eabb32cb957acd9f88d94ccada0ac09d07> 10:42 huginn News from kohagit: Bug 20996: (follow-up) Fix merge problems <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f947655862abc813df685d51edbfbe7b34027178> 10:42 huginn News from kohagit: Bug 20996: (QA follow-up) Fix pod <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ce6a27b0d287f14eb0d515db6b2a5e1f5d278381> 10:42 huginn News from kohagit: Bug 14385: DBRev 18.06.00.050 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7a1641cd41bf51a992cb07dff58d320c49f15b68> 10:42 huginn News from kohagit: Bug 20968: (RM follow-up) Add missing filter <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1a0172a253e5432e5eef862768aaacb3463501f2> 10:27 huginn marcelr: The operation succeeded. 10:27 marcelr @later tell kidclamp bug 14385 ? 09:34 ashimema hehe 09:33 matts a loooong time ago :) 09:33 ashimema sure it was usefull once upon a time 09:33 ashimema one to put to the mailing list then nuke from high orbit I reckon ;) 09:32 matts I don't know if anyone still uses it 09:31 cait matts might know :) 09:30 ashimema I wonder if anyone actually uses it. 09:28 ashimema no idea what that means 09:28 ashimema ok 09:28 ashimema erm 09:27 cait This patch allows to apply only one fine for a given borrower, no matter how many items are late, based on a given delay, which applies to the most late item. 09:27 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6858 normal, P5 - low, ---, matthias.meusburger, CLOSED FIXED, Adds staticfines.pl for static fines processing 09:27 cait bug 6858 09:26 cait sadly not very well documented, let me find the bug 09:26 cait it's a special kind of fine calculation 09:26 ashimema I've always used /fines.pl 09:26 ashimema anyone know what misc/crontjobs/staticfines.pl is for? 09:16 * cait waves 09:01 ashimema grr 09:01 ashimema perlcritic missed it here.. perhaps I just missed pushing a followup up 09:01 ashimema oops 09:01 ashimema ack yeah.. can't believe I missed the sprintf horrors when rebasing.. alex sassmanshausen wrote those in the first place.. really surprises me now I look back 09:00 marcelr perlcritic is your friend ;) 09:00 marcelr you once leave the parentheses and there you go 09:00 ashimema even as a secondary bug perhaps if we're keen on getting it through 09:00 marcelr nice sprintf bug btw 09:00 ashimema you suggested what I was going to suggest next 08:59 ashimema yeah.. baby steps ;) 08:59 marcelr i would not object to using exactly the same locking as in rebuild_zebra but not duplicate it 08:59 ashimema locks can cause a massive performance issue sometimes too 08:59 marcelr it is not trivial too 08:59 ashimema yeah.. exactly 08:58 marcelr ashimema: we had some struggles about database locking too already 08:58 ashimema Jonathans comment threw me.. I hadn't even considered locking at the db level as an alternative 08:55 ashimema cool.. I got stuck there 08:55 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15529 normal, P5 - low, ---, alexbuckley, Failed QA , Process Message Queue may send duplicate emails if process is launched twice 08:55 ashimema ooh, your looking at bug 15529 too. 08:53 ashimema definitely 08:53 marcelr yeah we should push it early for 19.05 08:53 ashimema oh definitely 08:53 ashimema yeah.. I'm working through recalls still.. my aim is now to work hard with alexbuckley beggning of next cycle to get it in early in a cycle rather than let it slip in this cycle 08:53 marcelr even more about teaching submitters.. 08:53 marcelr yeah but qa is not only for teaching you :) 08:52 ashimema it's teaching me allot about how to submit stuff cleaner 08:52 ashimema I don't blame anyone.. I'm having a right nightmare with some big feature QA's lately (from the qaing side not the submitting side) 08:52 marcelr just too large to get in without bugs 08:52 marcelr same for recalls now 08:52 ashimema indeed 08:52 ashimema more people getting involved.. I think it's slowly becomeing a much more polished and usable feature 08:52 marcelr hard to break such stuff in handleable pieces 08:51 ashimema it's getting better now though 08:51 ashimema ILL in it's original form in Koha core has the same sort of issue really.. the original stuff that got in worked.. but was not at all polished because it ended up so parred down 08:51 ashimema invariably feature creep and bugs creep in 08:51 ashimema yeah.. it's hard to keep something up to date for that long :( 08:50 ashimema we have more plans for ILL.. lots more polishing to do there to make it more refined. Bywater are jumping on board too to help us convert backends to plugins 08:50 marcelr 5 years aarg 08:49 ashimema especially as immediately after push the sql strict stufff was push which also broke it and added to the fix patches 08:49 ashimema it got rebased for like 5 years and unfortunately not everything was caught at the last qa before push.. 08:49 marcelr i will pick the other one now 08:49 ashimema it's basically rebase pain 08:48 ashimema mm.. the stock rotation stuff is annoying.. 08:48 marcelr oops and critical stock rotation stuff.. 08:48 ashimema this is only around 2/3rds of pahse 2 08:48 ashimema nah.. we always had a phase 2 and phase 3 planned 08:48 ashimema lol 08:48 marcelr was ill a bit sick? 08:47 ashimema huh 08:47 marcelr ashimema: why am i seeing so much ill patches ? 08:42 alexbuckley no worries, super keen to try to get that in as it seems pretty important that when item marked as lost things like transfers are dealt with 08:41 ashimema thanks for all the perserverance though :) 08:41 ashimema that's the problem with Koha now.. it's got so much history and so much code pre-existing that when you try to do even the simplest looking things you end up finding it touches way more than you originally thought 08:40 ashimema nothings ever easy is it ;) 08:39 alexbuckley yeah 08:39 ashimema now we're just left to see if we get any replies to me queries on the mailing lists 08:39 ashimema thanks alexbuckley (IRC) 08:27 marcelr hi #koha 08:16 Archie^ right, thank you 08:14 fridolin hi there 08:10 huginn Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21754 enhancement, P5 - low, ---, alexbuckley, Needs Signoff , If an item is marked as lost, any outstanding transfers upon it should be automatically cancelled 08:10 alexbuckley Hey ashimema did you see I wrote a patch (bug 21754) as an alternative to 21732 as it automatically cancels outstanding holds on lost items 08:09 wahanui hola, matts 08:09 matts hi 08:08 alexbuckley hey archie they are in the borrowers table 08:06 Archie^ hey remind me what table patron records are stored in? 07:59 alexbuckley hi all 07:36 ashimema that's gotta be a bit of a record 07:36 * ashimema first challenge of the days.. fix a 10 year old FIXME 07:35 reiveune hello 07:24 ashimema Lots of reading back 07:24 ashimema OAI fun aye dcook 07:12 magnuse yo yo yo dcook 07:12 dcook yo magnuse 07:12 magnuse \o/ 07:08 dcook Some pressing non-Koha stuff early next week 07:07 dcook I probably won't get a chance to follow up for a little while anyway 07:06 dcook Hopefully it's just a case of needing to add a CSS class or something 07:06 josef_moravec no problem, submit what you have, I'll try to catch oleonard and we could probably do something with datatable styling... 07:05 josef_moravec dcook: enjoy ;) 07:05 dcook heh 07:05 dcook Once these patches go up, I am going to get cold beers 07:05 dcook But I'm out of time O_O 07:05 dcook I think I've fixed most things. I think there are 3 outstanding things: the SQL statement, the datatable styling, and the foreign key. I think I might be wrong in my response about the foreign key though... 07:04 josef_moravec dcook: great! 07:04 dcook One last QA test tool run then I'll upload.. 07:01 * dcook apologizes for the heat-induced rant :p 06:57 dcook josef_moravec: I really do appreciate all the work that you're putting into this too :) 06:56 dcook But on that note, I almost have my commits ready ;) 06:55 dcook I don't know that it really has a chance of getting in, so I think it may have to just be a plugin 06:55 dcook And now I don't want to give up, but... 06:54 dcook I'd given up before andreashm contacted me 06:54 dcook I've been working on this for like 5.5 years at this point :/ 06:54 dcook That a catch-all won't work 06:54 dcook Sometimes I think OAI-PMH harvesting is better implemented instance by instance... 06:53 dcook The only way to get half-decent performance was to closely couple with Koha :/ 06:53 dcook Or used to be 06:53 dcook But the web services for importing into Koha are suuuper slow 06:52 dcook Other than the UI for comms 06:52 dcook Once upon a time, I had an iteration that was totally separate to Koha 06:52 dcook And then the daemon could do everything on its own 06:52 dcook The web ui would communicate with the daemon 06:52 dcook With the harvester, it wouldn't need any hooks really 06:51 josef_moravec Hi ashimema 06:51 josef_moravec like dependencies as you say, and better hooks handling 06:51 dcook allo ashimema 06:51 ashimema Mornin' #koha 06:51 dcook So that the only parts of Koha I need are a web UI (easy with a plugin in theory) and a record importer 06:51 josef_moravec I like plugins, and probably it will be the way in the future that many things will be as plugin, but i think the plugin system would need many improvements to make such a think possible 06:51 dcook I've been thinking of keeping a separate database 06:50 dcook The reliance on third-party dependencies makes it not great as a plugin though.. 06:50 dcook Although I hear that plugins these days update the schema too 06:50 dcook The tricky part would be the database... 06:50 dcook For web users, I think it would look all right as a plugin 06:49 dcook Yeah 06:49 josef_moravec dcook: whole harvester? 06:48 dcook I'm thinking this one might actually be better rewritten as a plugin 06:46 dcook At Kohacon, fridolin actually raised some good points, which makes me think my entire design is no good anyway 06:46 josef_moravec dcook: absolutely understand ;) 06:46 dcook And didn't want to have to rewrite all the tests hah 06:46 dcook In all honesty, I was waiting to write those, because I had a feeling that things were going to change 06:45 dcook <_< 06:45 dcook >_> 06:45 josef_moravec dcook: by the way, what about tests? 06:45 dcook So I added some explicit encoding functions so that it knew when things were bytes vs characters and that did the trick 06:45 dcook I think Perl was getting confused on one end of the socket between the harvester and the web ui 06:44 dcook The data in mysql was ok 06:44 dcook In this case... actually I don't know what the encoding issue was 06:44 josef_moravec I always have to google it to understand what thay mean 06:44 josef_moravec and error messages from mysql are usually horrible 06:43 josef_moravec it is sometimes tricky 06:42 dcook Can't believe it took me so long to work out the encoding bug today.. heh 06:42 josef_moravec exactly 06:42 dcook There may be other hurdles along the way that are more important 06:42 dcook I think the same 06:42 josef_moravec we could enhance it on another report in the future 06:41 josef_moravec for now, i am for constrain it, as i most cases it would be ok 06:41 dcook Or remove the constraint and handle it a different way 06:41 dcook By that token, I should have separate tables for both identifiers and repositories :/ 06:41 dcook Hmm 06:40 josef_moravec but usually the idntifier is prefixed and sometimes the prefix could be really long, lik oai:some-very-old-url.com:systemprefix-systemid 06:40 dcook So I'm already restricting it by saying 255.. 06:40 dcook I mean technically I think a url could be like 2083 characters 06:40 dcook But in practice I don't think that would actually happen 06:40 dcook I only include both because technically you could have duplicate identifiers across different repositories... 06:39 dcook Yeah the identifier is first, so even if it did get truncated it would still be ok 06:39 josef_moravec dcook: the identifier is the first? isn't it? Then it could be OK... 06:38 dcook It is unlikely that I'll hit that limit 06:38 dcook Actually 191 is pretty long... 06:38 * dcook waves 06:34 kohaputti dcook, hi! 06:30 dcook I wonder if I even need that unique key.. 06:28 kohaputti like can sysprefs be used other than user customizable things or should in this case new table be created / something else? 06:28 dcook josef_moravec: probably would've been a worthwhile change anyway 06:28 huginn Bug 19893: enhancement, P1 - high, ---, glasklas, Needs Signoff , Alternative optimized indexing for Elasticsearch 06:28 kohaputti Hi, coding help needed! https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19893#c197 is it good idea to put a syspref that store search index status, e.g. INDEX_STATUS_OK, INDEX_STATUS_REINDEX_REQUIRED, INDEX_STATUS_RECREATE_REQUIRED? 06:26 * dcook checks the thermostat. Apparently it's only 28C indoors ;) 06:25 dcook Well not irreparably per se.. 06:25 dcook And now it's irreparably broken for now :/ 06:24 dcook I've already spent all day working on this when I probably should've spent 0 hours on it :( 06:24 * dcook sighs 06:24 dcook yeah I was just thinking that :/ 06:24 josef_moravec but it is relatively big change :( 06:23 josef_moravec so then maybe have table oai_harvester_repositories and oai_harvester_biblios.oai_repository foreign key to it? 06:20 dcook josef_moravec: yeah that's the one I'm looking at 06:20 josef_moravec ? 06:20 josef_moravec dcook: do you mean oai_record key in oai_harvester_biblios 06:20 * dcook ponders 06:19 dcook km: I have 06:19 km please answer 06:19 dcook The key is a compound key of two varchar(255) fields :'( 06:18 dcook km: I'm going to say no 06:18 josef_moravec yes, when it is not key, it is not problem 06:18 dcook It must mean the unique key I'm making 06:18 km hi dcook 06:18 dcook Ah but since it's a key.. 06:17 josef_moravec dcook: unfortunately :( 06:17 dcook josef_moravec: The error doesn't really tell me anything other than the table is the problem 06:17 josef_moravec see authorised_values table definition 06:17 km It is actually inserting images into a spreadsheet 06:17 josef_moravec dcook: or you can just make the key of length 191 06:16 dcook I guess we'll see 06:16 km Hi dcook 06:16 dcook hopefully varchar(191) will be enough 06:16 dcook I must not be looking far enough 06:15 dcook heh I was trying to find those as examples 06:15 josef_moravec if you look to kohastructure.sql you will see many varchar(191) columns 06:15 dcook km: I'm afraid I still don't understand what you're trying to ask. Maybe someone else will understand better. 06:15 dcook josef_moravec: It doesn't say but yeah I think that's the issue 06:15 km okay. I wanted to export Bibliographic details from KOHA in to Excel file.Can get the cover page images of each book in the exported Excel file? 06:15 josef_moravec dcook: is this error on varchar(255) type of column? Then change it to VARCHAR(191) 06:14 dcook Or actually inserting images into a spreadsheet? 06:14 dcook You mean URLs to cover images? 06:13 dcook km: I am afraid I don't understand the question 06:13 dcook josef_moravec: Are there any tips on avoiding the error? 06:13 km Can we export catalogue details in to Excel from KOHA with cover page images of books? 06:13 josef_moravec urf8mb4 related 06:13 dcook I think it's because of the 4 byte utf8 collation.. 06:13 dcook josef_moravec: any ideas about "ERROR 1071 (42000) at line 4326: Specified key was too long; max key length is 767 bytes"? 06:12 dcook hi km 06:12 huginn josef_moravec: Prague, Czech Republic :: Clear :: 39F/4C | Wind Chill: 35F/2C | Friday: Partly cloudy this morning. Increasing clouds with periods of showers this afternoon. High 56F. Winds light and variable. Chance of rain 50%. Friday Night: Showers early, then cloudy overnight. Low 46F. Winds NNW at 5 to 10 mph. Chance of rain 60%. 06:12 josef_moravec @wunder Prague 06:12 * dcook is grumpy and not in a good mood for talking to humans heh 06:12 km Hi 06:12 huginn dcook: Sydney, Australia :: Partly Cloudy :: 100F/38C | Friday: Showers and thunderstorms early. Lows overnight in the mid 70s. Friday Night: Scattered thunderstorms during the evening. Partly cloudy skies after midnight. Low 76F. Winds NW at 15 to 25 mph. Chance of rain 40%. Winds could occasionally gust over 40 mph. 06:12 dcook @wunder syd 06:12 dcook I've been all day in an office without air conditioning 06:12 josef_moravec when you have Koha::Objects based class, it should not be needed 06:12 dcook Actually I shouldn't be on IRC>. 06:12 dcook That's why I added it :S 06:11 dcook Hmm I think I tried without it and it didn't work? 06:11 dcook Running into an unrelated/related problem 06:11 josef_moravec dcook: one more comment come to my mind: you do not need to use ->new before ->find and ->search 06:11 dcook 早上好 ;) 06:10 josef_moravec ;) 06:10 josef_moravec 下åˆå¥½ dcook 06:10 dcook Almost resolved most things :p 06:10 wahanui josef_moravec is using this "manual" when building packages: https://wiki.koha-community.org/wiki/Building_Debian_Packages_-_The_Easy_Way 06:10 dcook heya josef_moravec 06:10 dcook Ahh I see 06:05 dcook Ah but I changed it.. 06:05 dcook Didn't have a problem loading this schema in yesterday... 06:04 dcook ERROR 1071 (42000) at line 4325: Specified key was too long; max key length is 767 bytes 06:04 dcook Hmm 05:19 dcook And decoding characters to get octets.. 05:19 dcook I think about it as encoding octets to get characters... 05:18 dcook decode = octets -> characters, encode = characters -> octets 05:18 dcook I was reversing the Encode functions >_< 05:18 dcook Woohoo. Solved it. 05:06 dcook Ahhh not quite 05:05 dcook So obvious in the end... 05:05 dcook Silly me 05:05 dcook Ohhh yeah I think I've nearly got it 04:18 dcook Oh yeah. I try to send Chinese and it's batshit again 04:17 dcook It worked because it's encoded as Latin-1 and I'm guessing Chrome is showing everything as Latin-1... 04:06 dcook Wtf.. 04:05 dcook But the invalid UTF8 bytes show right on Koha... 04:05 dcook So the valid UTF8 bytes show wrong on Koha 04:01 dcook But have to decode it on the client side.. 04:00 dcook Or on the output of the server.. gahh 04:00 dcook Yep looks like something on the Koha end... 03:47 dcook Ok then.. 03:47 dcook The only valid UTF-8 strings are those that Perl isn't marking internally 03:36 dcook Thought I fixed it and made it much worse >_< 03:24 dcook Oh wait I'm using a different terminal.. 03:24 dcook I thought I had my head around encodings... 03:13 dcook Except not... so confused 03:12 dcook As netcat looks like it's getting the same badness 03:12 dcook Oh jeez I'm so confused but it looks like the server 03:08 dcook netcat-openbsd++ 03:07 dcook I should know soon enough I think 03:07 lavamind I wouldn't know, never listen to them 03:06 dcook Or that 03:06 lavamind one direction is both good and bad? 03:05 dcook Hmm I should be able to use netcat as a client.. 03:05 dcook One direction is good and one direction is bad.. 03:05 dcook Hrm 03:04 dcook Or the output on my server.. 03:03 dcook Must be something we're doing for utf8 handling elsewhere in Koha I reckon.. 03:02 dcook Leaves the client OK, arrives at the server OK, leaves the server OK... arrives at the client BAD 03:00 dcook wizzyrea: It's my own code which makes this worse... heh 03:00 dcook Hmm today is Friday... this is a suitable Friday problem 02:58 dcook I think I'm narrowing it down.. 02:57 wizzyrea ah 02:57 dcook This is an issue of Koha sending data over a UNIX socket and then getting the same data back... but it being double encoded 02:57 dcook Definitely 02:56 wizzyrea is your database in the utf-8 character set? 02:56 dcook Hmm valid UTF-8 on the server... 02:50 dcook Or maybe it's the socket connection on the client end too.. 02:49 dcook Even though the log makes it look like it's valid.. 02:49 dcook So I'm getting valid UTF-8 from my client... but then my server is screwing it up.. 02:48 lavamind well there you go 02:47 dcook lavamind: Both big use cases for Koha heh 02:47 * dcook doesn't love being wedded to a particular framework... but controllers should be thin anyway... 02:47 lavamind multitenancy is great for a) enabling SaaS deployments and b) education 02:46 dcook Slowly start replacing CGI scripts with routes in Mojolicious... 02:46 dcook Actually, I was thinking how the Mojolicious patches could help ease into that 02:46 dcook Although rewriting Koha to be more MVC would be great 02:45 dcook lavamind: Yeah I think to really support multiple instances it's the way to go 02:45 dcook I know "Knihovna \x{da}st\x{ed}" is right. Curious what "Knihovna \303\232st\303\255" means though.. 02:44 dcook PV = 0xa6029c0 "Knihovna \303\232st\303\255"\0 [UTF8 "Knihovna \x{da}st\x{ed}"] 02:44 lavamind but this, it's another game, it's so much faster 02:44 lavamind it got us far enough, until we had to move away from 3.08 heheh 02:44 dcook Pseudo-multitenant 02:44 dcook Just lots of little instances 02:44 dcook Even with the packages, I guess it was never really multitenant 02:43 dcook Mm 02:43 lavamind one big fat instance 02:43 dcook Traditional outside of Koha maybe 02:43 lavamind deploying one instance per site 02:43 * dcook is wondering what on earth is double-encoding his strings.. 02:43 dcook How do you mean? 02:42 lavamind right right... doesn't make much sense for traditional deployments to be sure 02:42 dcook I'm sure many of us would 02:42 dcook So please post about your experiences on Bugzilla. I'd love to hear how you go. 02:42 dcook I'd love to use the Mojolicious patches but... time and risk :/ 02:42 dcook Nah, I find it super interesting 02:42 lavamind dcook: sorry to bother you :P 02:42 dcook And good on you for using the Mojolicious patches 02:42 dcook That's cool 02:41 dcook I don't use the debian packages so I'm not super familiar with the debian commands 02:41 lavamind it does the iterations itself 02:41 dcook Ahhh 02:41 lavamind dcook: I run one /usr/sbin/koha-rebuild-zebra command for all the instances that need indexing 02:41 dcook Now back to my actual problem heh 02:41 dcook Of course, if we had a message queue... 02:40 * dcook is not a big fan of polling 02:40 dcook Oh I see what mine does. Mine doens't run every 5 seconds. Rather, it checks the counts for all instances, and forks off an indexer for anything that needs indexing done, and then waits 5 seconds before it starts all over.. 02:38 * dcook reads more 02:38 dcook I might be missing something but why don't you have koha-rebuild-zebra in your loop? 02:36 lavamind you can see I put the sessions files in /run so it's all in memory 02:35 lavamind I want to see how it goes with 40 students hitting it all at once :P 02:35 lavamind I have it at 2 minutes right now 02:34 dcook Every 5 seconds 02:34 lavamind dcook: http://paste.debian.net/1050058/ 02:34 dcook Oh my bad 02:34 dcook But my servers are also waaaaay more powerful 02:34 * dcook checks 02:34 dcook Or maybe it's every 5 minutes 02:33 dcook I'm probably doing about 70 every minute and don't notice a thing 02:33 dcook And use file locking to make sure I don't retry to index the same index too often 02:33 lavamind dcook: right, you want to avoid having to run 119 queries every minute 02:33 dcook Then I fork off an indexing process per instance 02:33 dcook It goes pretty fast but still not as many as 119 databases.. 02:33 dcook I do a count query for each database's zebra queue 02:32 dcook Iiinteresting 02:32 dcook A few months ago I wrote a small script to manage indexing too heh 02:32 lavamind by using file-based sessions I can check for active web sessions before hitting the database to look for pending records 02:32 lavamind I wrote an small script to manage the indexing 02:31 dcook Cooool 02:26 wahanui 41212 02:26 lavamind 20582 and 20630 02:25 dcook What's the bug number again? 02:25 lavamind where to start lol 02:25 dcook Tell me more heh 02:24 dcook O_o 02:24 lavamind (and you all of course heh) 02:24 lavamind thanks to mojolicious 02:23 lavamind this is on a VM with 4 GB of RAM 02:23 lavamind ^ and that is how you teach an ILS to students :D 02:22 lavamind 119 02:22 lavamind # koha-list | wc -l 02:04 dcook Now onto encoding issues which are much more time consuming >_< 01:06 dcook Well I'm not getting that part of my life back 01:06 dcook 32 minutes O_O 01:06 * dcook doesn't want to count the number of minutes just wasted... 01:05 dcook Obviously :p 01:05 dcook But if you just tack on a .dataTable().api() to the end of the KohaTable return value, then you're all right 01:05 dcook Basically yeah... diferent return values 01:05 wizzyrea yay! 01:03 dcook Hurray! 01:03 dcook Think I may have figured it out... 00:55 dcook I think KohaTable uses the legacy API.. 00:52 * dcook sighs 00:52 dcook oh Yes DataTable and KohaTable return very very different results... 00:47 dcook Should be on DataTables 1.10.10... 00:43 dcook Here's what I was using: https://datatables.net/reference/api/ajax.reload() 00:43 dcook Oh or maybe KohaTable is older 00:42 dcook checkouts.js here we go.. 00:41 dcook Can't find any ajax examples with KohaTable... 00:40 dcook Which is fair enough but just unexpected 00:40 dcook But with KohaTable... I think maybe it uses a different version of datatables 00:39 dcook it worked fine with DataTable 00:39 dcook Today it's ajax with KohaTable 00:39 dcook That drove me a bit nuts 00:39 dcook That was yesterday heh 00:39 wizzyrea is this the thing that makes it so you can have configurable table columns? 00:38 dcook Me being out of touch I'm sure 00:38 dcook Meee too heh 00:38 * Francesca is curious 00:35 * dcook curses profusely 00:35 dcook Ahh I see 00:34 dcook Or rather.. different attributes I guess. Oh.. I wonder.. 00:34 dcook Now to figure out why KohaTable and DataTable are giving me a result with different methods..