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..