Time Nick Message 07:35 reiveune hello 07:41 alex_a bonjour 07:41 wahanui privet, alex_a 07:56 marcelr hi #koha 08:27 tuxayo hi koha o/ 08:27 * magnuse waves 08:28 marcelr o/ 08:37 eythian https://community.letsencrypt.org/t/important-what-you-need-to-know-about-tls-sni-validation-issues/50811 <-- things to be aware of if you're using letsencrypt for SSL 08:40 tuxayo eythian++ 08:57 * cait waves from a train 09:14 josef_moravec morning #koha 09:15 marcelr hi josef_moravec 09:15 josef_moravec hi marcelr 09:17 * cait1 waves 09:17 cait1 josef_moravec++ thx for QA :) 09:17 josef_moravec cait1: not at all 09:18 josef_moravec But today everything failed qa till now 09:18 cait1 sometimes it is like htat 09:18 cait1 but if it's a fail it's a fail. another time everything will pass :) 09:18 josef_moravec ;) 09:19 marcelr josef_moravec: i can give you some number you should pass :) 09:19 cait1 hm? 09:20 josef_moravec marcelr: would like to ;) 09:33 fridolin hi herte 09:35 eythian how did that t get all the way over there? :) 09:37 cait josef_moravec: commented on bug 19360 09:37 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19360 enhancement, P5 - low, ---, alexbuckley, Failed QA , Give items URL a link text 09:37 cait i think we need to think if we really want to use up our last free subfield :) 09:37 josef_moravec cait: I understand ;) 09:38 josef_moravec but then we need another aproach 09:38 cait yeah 09:38 josef_moravec probably via cataloguing plugin? 09:39 cait i'd like a way to store both together, maybe with a plugin for easier use 09:39 cait also nicer if you want to have multiple urls 09:39 josef_moravec cait: that I am thinking of 09:39 cait with k and u separate, much harder 09:39 josef_moravec true 09:39 cait my suggestion of | is probably bad, because we use that for repeatable, but we could think of another way 09:40 paxed lxc-attach -n "$CONTNAME" -- cpanm -i Data::Format::Pretty::Console 09:40 paxed oops 09:44 paxed cait: at least | isn't a valid url character 10:02 magnuse any known negative side effects of running /usr/share/koha/bin/cronjobs/holds/build_holds_queue.pl more often than hourly? 11:25 jenkins Yippee, build fixed! 11:25 wahanui o/ '`'`'`'`'`'`'`'`'` 11:25 jenkins Project Koha_17.05_D8 build #77: FIXED in 39 min: https://jenkins.koha-community.org/job/Koha_17.05_D8/77/ 11:25 jenkins * fridolin.somers: Revert "Bug 19669: (QA follow-up) Remove itemstypes.plugin" 11:25 jenkins * Jonathan Druart: Bug 19705: Try to fix random failures from DecreaseLoanHighHolds.t 11:25 jenkins * Nick Clemens: Bug 19596: Don't try to get hold or items count for non-existent biblios 11:25 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19669 minor, P5 - low, ---, oleonard, Pushed to Stable , Remove deprecated checkouts by patron category report 11:25 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19705 normal, P5 - low, ---, jonathan.druart, Pushed to Stable , DecreaseLoanHighHolds.t is still failing randomly 11:25 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19596 major, P5 - low, ---, nick, Pushed to Stable , Internal server error if open order with deleted biblio / null biblionumber 11:26 fridolin you did it ;) 11:38 Joubu cait: about the Modern::Perl patches: they do not do what they advertise: "use Modern::Perl should be used instead of use strict; use warnings;" 11:39 Joubu but in some cases they use warnings when it was not 11:39 marcelr Joubu: i was afraid for that 11:39 eythian there was a push a long time ago to add 'use warnings' to things that didn't have it. Perhaps this is a chance to resume it :) 11:39 marcelr les fill our logs 11:40 marcelr lets 11:40 eythian marcelr: at Catalyst we had a dashboard that showed the most common warnings, and would periodically go fix some of them. Sometimes they indicate problems that should be fixed anyway. 11:41 Joubu I am ok with enabling it, but then I would have prefered a separate patch to list the files with this change 11:41 Joubu I also wanted to know if strict has not been enabled in some scripts 11:43 Joubu josef_moravec: did you see bug 19290? 11:43 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19290 new feature, P5 - low, ---, jonathan.druart, Signed Off , Add the ability to filter a result list on staff client 11:44 josef_moravec Joubu: not yet, will take a look, thanks 12:21 magnuse bug 2505 12:21 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2505 major, P1 - high, ---, gmcharlt, NEW , Omnibus: Enable Perl warnings in all modules and scripts 12:22 oleonard Hi all 12:23 magnuse kia ora oleonard 12:26 eythian hi oleopard 12:36 tcohen morning 12:50 huginn` News from kohagit: Bug 19996: (QA follow-up) Remove commented use warnings; <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f477c078d86fab112c1ecf26e68dc869bf0fef54> 12:50 huginn` News from kohagit: Bug 20124: Make "Save configuration" translatable on "did you mean?" config <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2ff5482c973eb2f1835a3e372bcee6f16c4a9445> 12:50 huginn` News from kohagit: Bug 20110: Adding same user multiple times to same budget <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3c2cd21cc35fdb5a048c042add0087ebedbca44e> 12:50 huginn` News from kohagit: Bug 20109: Make "Remove" translatable when adding a fund <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=127da0e35c5117e4c6ad7a208087cf191745b49b> 12:50 huginn` News from kohagit: Bug 20098: Inventory tool: CVS export: fix itemlost column <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=458c8c1ae1d27cd4099328b4035fb236458fcd67> 12:50 huginn` News from kohagit: Bug 20062: Remove support for Internet Explorer 7 in the staff client <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=60efdccafd40de43a4917a80fc96d3f6e63626a7> 12:50 huginn` News from kohagit: Bug 20060: Resolve uninitialized warn from Koha::Template::Plugin::Branches <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e3d0bc24c97ed35653130cdc55f0da3271d958e9> 12:50 huginn` News from kohagit: Bug 20019: use Modern::Perl in misc perl scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d10513dfc0d47846fdb874b0a62ce9c8c7107644> 12:50 huginn` News from kohagit: Bug 20010: use Modern::Perl in Patroncards perl scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=3ded637bc51227acc9b107da09ba8d0f2a39862d> 12:50 huginn` News from kohagit: Bug 20009: use Modern::Perl in Members perl scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f2502c94998c5a60e6ec038e64decc5fb64e5b6a> 12:50 huginn` News from kohagit: Bug 20018: use Modern::Perl in offline_circ scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=484fd322abd36bba61a8c2fa40e3902e909438c3> 12:50 huginn` News from kohagit: Bug 20020: use Modern::Perl in XT scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e1b4b53765da4088483a7255b657b1a4c98db694> 12:50 huginn` News from kohagit: Bug 20016: use Modern::Perl in svc scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2bde680e0b7cb0a91731bd9a9475e3460e4b6fec> 12:50 huginn` News from kohagit: Bug 19998: use Modern::Perl in error perl scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b4458e71e56aaa79c80b695aa9c7945a29211584> 12:50 huginn` News from kohagit: Bug 20011: use Modern::Perl in plugins perl scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b0216c7ca0c78c9fbb866950562632315b588e36> 12:50 huginn` News from kohagit: Bug 20012: use Modern::Perl in Reports perl scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5d9348ffa22ecf8cf2a2cf2f953d4e18930c2669> 12:50 huginn` News from kohagit: Bug 20017: use Modern::Perl in Tools perl scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=cad2db6016fb154049a030f0d8a74a6b539cb7a4> 12:50 huginn` News from kohagit: Bug 19997: use Modern::Perl in Circulation perl scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f9b93e07fd3259d2c8c795ee220d27a8a1251cd4> 12:50 huginn` News from kohagit: Bug 20015: use Modern::Perl in Serials perl script <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=eb5aa286126d204c3bfb52a2d774eeaf7bfe9b68> 12:50 huginn` News from kohagit: Bug 20013: use Modern::Perl in Reserve perl script <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7b3470ca3f5df7af683e916b35880e674dd200bb> 12:50 huginn` News from kohagit: Bug 19999: use Modern::Perl in label scripts <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=165c56de29b259c0607d5e3000045ae5fe481af0> 12:52 Joubu Could someone make the DBMS_auto_increment_fix wiki page more understandable? 13:00 huginn` News from kohagit: Bug 11827: (follow-up) Use double quote instead of simple-quote <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=a49cc5a5850a2ba70e274c389ceee63d8396fbdb> 13:00 huginn` News from kohagit: Bug 20109: (follow-up) Use double quote instead of simple-quote <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1e2f88990da0747ea7164b98060fb82bac24670f> 13:02 jenkins Project Koha_Master_D8 build #345: ABORTED in 9 min 29 sec: https://jenkins.koha-community.org/job/Koha_Master_D8/345/ 13:02 jenkins * pasi.kallinen: Bug 11827: Make "Cancel Rating" translatable in jQuery rating plugin 13:02 jenkins * mtompset: Bug 12932: Check the Perl version even if all modules installed 13:02 jenkins * zoebennett1308: Bug 19989: Use Koha::Patron::Modifications->delete instead of loop 13:02 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11827 minor, P5 - low, ---, pasi.kallinen, Pushed to Master , Untranslatable "Cancel Rating" in jQuery rating plugin 13:02 jenkins * Jonathan Druart: Bug 19989: remove confusing variable 13:02 jenkins * jwayway: Bug 19992: use Modern::Perl in Admin perl scripts 13:02 jenkins * charlotte.cordwell123: Bug 19993: use Modern::Perl in Acquisition perl scripts 13:02 jenkins * zoebennett1308: Bug 19995: use Modern::Perl in Catalogue perl scripts 13:02 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12932 normal, P5 - low, ---, mtompset, Pushed to Master , Web installer's Perl version check will not raise errors if all modules are installed 13:02 jenkins * gracesmythh: Bug 19996: use Modern::Perl in cataloguing perl scripts 13:02 jenkins * katrin.fischer: Bug 19996: (QA follow-up) Remove commented use warnings; 13:02 jenkins * charlotte.cordwell123: Bug 19997: use Modern::Perl in Circulation perl scripts 13:02 jenkins * terauhina.jackson: Bug 19998: use Modern::Perl in error perl scripts 13:02 jenkins * zoebennett1308: Bug 19999: use Modern::Perl in label scripts 13:02 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19989 enhancement, P5 - low, ---, zoebennett1308, Pushed to Master , opac-memberentry.pl has a FIXME that can be fixed 13:02 jenkins * terauhina.jackson: Bug 20009: use Modern::Perl in Members perl scripts 13:02 jenkins * gracesmythh: Bug 20010: use Modern::Perl in Patroncards perl scripts 13:02 jenkins * zoebennett1308: Bug 20011: use Modern::Perl in plugins perl scripts 13:02 jenkins * charlotte.cordwell123: Bug 20012: use Modern::Perl in Reports perl scripts 13:02 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19992 enhancement, P5 - low, ---, jwayway, Pushed to Master , use Modern::Perl in Admin perl scripts 13:02 jenkins * jwayway: Bug 20013: use Modern::Perl in Reserve perl script 13:02 jenkins * jwayway: Bug 20015: use Modern::Perl in Serials perl script 13:02 jenkins * zoebennett1308: Bug 20016: use Modern::Perl in svc scripts 13:02 jenkins * jwayway: Bug 20017: use Modern::Perl in Tools perl scripts 13:02 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19993 enhancement, P5 - low, ---, charlotte.cordwell123, Pushed to Master , use Modern::Perl in Acquisition perl scripts 13:02 jenkins * zoebennett1308: Bug 20018: use Modern::Perl in offline_circ scripts 13:02 jenkins * terauhina.jackson: Bug 20019: use Modern::Perl in misc perl scripts 13:02 jenkins * charlotte.cordwell123: Bug 20020: use Modern::Perl in XT scripts 13:02 jenkins * m.de.rooy: Bug 20060: Resolve uninitialized warn from 13:02 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19995 enhancement, P5 - low, ---, zoebennett1308, Pushed to Master , use Modern::Perl in Catalogue perl scripts 13:03 jenkins * oleonard: Bug 20062: Remove support for Internet Explorer 7 in the staff client 13:03 jenkins * victor.grousset: Bug 20098: Inventory tool: CVS export: fix itemlost column 13:03 jenkins * pasi.kallinen: Bug 20109: Make "Remove" translatable when adding a fund 13:03 jenkins * pasi.kallinen: Bug 20110: Adding same user multiple times to same budget 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19996 enhancement, P5 - low, ---, gracesmythh, Pushed to Master , use Modern::Perl in cataloguing perl scripts 13:03 jenkins * pasi.kallinen: Bug 20124: Make "Save configuration" translatable on "did you mean?" 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19997 enhancement, P5 - low, ---, charlotte.cordwell123, Pushed to Master , use Modern::Perl in Circulation perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19998 enhancement, P5 - low, ---, terauhina.jackson, Pushed to Master , use Modern::Perl in error perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19999 enhancement, P5 - low, ---, zoebennett1308, Pushed to Master , use Modern::Perl in Labels perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20009 enhancement, P5 - low, ---, terauhina.jackson, Pushed to Master , use Modern::Perl in Members perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20010 enhancement, P5 - low, ---, gracesmythh, Pushed to Master , use Modern::Perl in Patroncards perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20011 enhancement, P5 - low, ---, zoebennett1308, Pushed to Master , use Modern::Perl in plugins perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20012 enhancement, P5 - low, ---, charlotte.cordwell123, Pushed to Master , use Modern::Perl in Reports perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20013 enhancement, P5 - low, ---, jwayway, Pushed to Master , use Modern::Perl in Reserves perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20015 enhancement, P5 - low, ---, jwayway, Pushed to Master , use Modern::Perl in Serials perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20016 enhancement, P5 - low, ---, zoebennett1308, Pushed to Master , use Modern::Perl in svc scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20017 enhancement, P5 - low, ---, jwayway, Pushed to Master , use Modern::Perl in Tools perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20018 enhancement, P5 - low, ---, zoebennett1308, Pushed to Master , use Modern::Perl in offline circulation perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20019 enhancement, P5 - low, ---, terauhina.jackson, Pushed to Master , use Modern::Perl in miscellaneous perl scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20020 enhancement, P5 - low, ---, charlotte.cordwell123, Pushed to Master , use Modern::Perl in XT scripts 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20060 trivial, P5 - low, ---, m.de.rooy, Pushed to Master , Uninitialized warn from Koha::Template::Plugin::Branches 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20062 enhancement, P5 - low, ---, oleonard, Pushed to Master , Remove support for Internet Explorer 7 in the staff client 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20098 minor, P5 - low, ---, victor.grousset, Pushed to Master , Inventory: CSV export: itemlost column is always empty 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20109 trivial, P5 - low, ---, pasi.kallinen, Pushed to Master , Allow translating "Remove" in Add Fund 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20110 minor, P5 - low, ---, pasi.kallinen, Pushed to Master , Adding same user multiple times to same budget fund 13:03 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20124 trivial, P5 - low, ---, pasi.kallinen, Pushed to Master , Allow translating did you mean config save message 13:03 jenkins Project Koha_Master_D8 build #346: ABORTED in 54 sec: https://jenkins.koha-community.org/job/Koha_Master_D8/346/ 13:03 jenkins * Jonathan Druart: Bug 20109: (follow-up) Use double quote instead of simple-quote 13:03 jenkins * Jonathan Druart: Bug 11827: (follow-up) Use double quote instead of simple-quote 13:07 Joubu josef_moravec, cait, tcohen: For www tests, you need to export some env vars 13:08 Joubu the koha user, pwd, and url 13:08 Joubu (maybe not on kohadevbox) 13:09 tcohen not on kohadevbox 13:09 tcohen but the current www tests are very sensible to the inserted records showing on the first results page 13:09 oleonard Joubu: Was your comment on Bug 19980 intended for a different bug? 13:09 tcohen and I bet that's the problme 13:09 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19980 enhancement, P5 - low, ---, oleonard, ASSIGNED , Omnibus: Update single-column templates to use Bootstrap grid 13:09 Joubu oleonard: nope 13:10 oleonard In that case I don't understand the question 13:10 huginn` News from kohagit: Bug 7143: Update about page for new dev - Jenny Way <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e6f8059a04144bf9247a6f43e19f83ba2c4f7f9a> 13:10 Joubu oleonard: can you explain what you are going to do in the dependent bugs 13:11 oleonard Yes 13:11 Joubu technically, like: 13:11 Joubu - <div id="bd"> 13:11 Joubu - <div id="yui-main"> 13:11 Joubu + <div class="col-md-10 col-md-offset-1 col-lg-8 col-lg-offset-2"> 13:11 Joubu why these new classes? Will they be always the same? In this case why not 1 of our class (more readable) 13:12 Joubu How can we make sure removing db and yui-main will not introduce regressions? 13:12 Joubu Do we need something new in the QA tools and/or coding guidelines? 13:47 Joubu oleonard: https://screenshots.firefox.com/MkjR9BT2p9qssLDI/pro.kohadev.org 13:47 Joubu do you know if this bug has already been reported? 13:47 Joubu It remembers me something 13:48 oleonard Not that I know of. Do you know if it only happens under certain circumstances? 13:48 jenkins Project Koha_Master_D8 build #347: SUCCESS in 44 min: https://jenkins.koha-community.org/job/Koha_Master_D8/347/ 13:48 jenkins Jonathan Druart: Bug 7143: Update about page for new dev - Jenny Way 13:48 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7143 trivial, P5 - low, ---, koha-bugs, Pushed to Master , Bug for tracking changes to the about page 13:48 Joubu oleonard: when the first "language block" is multiple 13:49 Joubu only staff side 14:12 narcisgarcia Hello, I'm new to Koha, and I'm trying to setup a new installation for non-librarian users 14:13 narcisgarcia They will basically need to register book acquisitions with title, author, and few more tags. 14:14 narcisgarcia I'm cleaning own MARC framework to avoid most of 300 default tags taken from MARC21 defaults. 14:15 narcisgarcia Koha(intra) interface is really slow because, for each tag, I need to select "Delete", and a page after confirm "Yes", and a page after confirm "Ok", and at next page move view to next row. 14:17 narcisgarcia Does anybody know if there is a quicker way to remove many tags/entries from this template called "MARC bibliographic frameworks" ? 14:17 narcisgarcia Thanks 14:17 oleonard narcisgarcia: Not within Koha unfortunately, but you can import and export frameworks, so you could edit them outside of Koha if that would be easier for you 14:17 narcisgarcia Aha 14:18 narcisgarcia Okay, I'm tring now with a text editor fro CSV exported. 14:18 narcisgarcia *for 14:19 pastebot "oleonard" at 127.0.0.1 pasted "Error when updating database in master" (27 lines) at http://paste.koha-community.org/10 14:20 oleonard I get this error every time I try to update my test system's database, and then I'm stuck in a webinstaller loop. 14:20 oleonard Anyone know what's going on? 14:20 oleonard Web installer says "We are upgrading from Koha 3.09.00.050 to 17.12.00.006" :| 14:21 narcisgarcia "999" MARC21 tags are necessary to be kept in MARC Framework? 14:23 oleonard narcisgarcia: don't know, but if the tag is labeled "KOHA" in the framework it's a good indication that you should leave it 14:24 narcisgarcia I've exported to CSV, removed many rows wit a text editor (left only) 24, and imported to a test framework; but Koha says "Error importing" 14:24 narcisgarcia (this test was leaving Koha tags) 14:28 narcisgarcia Is there some guide or published notes about exporting/importing MARC frameworks? 14:34 oleonard narcisgarcia: There is information in the manual but I don't think it has guidance for diagnosing errors 14:34 oleonard http://manual.koha-community.org/17.05/en/catadmin.html#marcbibframeworks 14:38 narcisgarcia Thanks http://manual.koha-community.org/17.11/en/catadmin.html#marcbibframeworks 14:38 narcisgarcia Maybe there are some required tags, because I've imported an edited framework with 266 rows, and no error message. 14:39 narcisgarcia Required MARC/Koha tags dn't seem to be documented. 14:41 narcisgarcia ...or perhaps the previous test failed because I removed subtags (?) 14:43 narcisgarcia ...or perhaps for presence of 999 subtags without main 999 tag (?) 14:45 oleonard Yes I don't imagine it works if you remove the tag but keep the subfields. 14:46 narcisgarcia OMG, what a complex structure... I need to clean any tag with subtags, to keep ultra-simple structure. 14:47 narcisgarcia I might create some Calc formula to mark this detection with ODS exported format 14:47 Joubu oleonard: does the DB originaly come from 3.09? 14:48 oleonard No 14:49 oleonard It's a db dump from about a month ago 14:50 Joubu oleonard: restarted memcached then plack? 14:50 oleonard Oh maybe not >:( 14:51 Joubu narcisgarcia: delete from marc_subfield_structure where frameworkcode="FRAMEWORK_CODE" and tagfield=TAG; # This will delete the field TAG for the FRAMEWORK_CODE framework 14:51 Joubu ^ wrong, one sec 14:52 oleonard it's good to get your stupid mistakes out of the way earlier on Monday morning so the rest of the day is smooth sailing. 14:52 Joubu narcisgarcia: delete from marc_tag_structure where tagfield=TAG and frameworkcode="FRAMEWORKCODE"; # This will delete the field TAG for the FRAMEWORK_CODE framework 14:53 Joubu narcisgarcia: delete from marc_subfield_structure where frameworkcode="FRAMEWORK_CODE" and tagfield=TAG; # This will delete the subfields for the field TAG and the FRAMEWORK_CODE framework 14:59 narcisgarcia Do you mean an SQL instruction? 15:00 narcisgarcia (I want to delete whole tags that have subfields, and only keem simple tags) 15:00 narcisgarcia *keep 15:03 Joubu Are you familiar with SQL queries? 15:05 narcisgarcia Only a bit 15:06 narcisgarcia Are you sure that this kind of direct SQL rows removal will not leave inconsistent relations for Koha? 15:07 Joubu if you are not familiar with them it is better to use the import/export feature 15:17 narcisgarcia I'm trying now with a ShellScript over a CSV export 15:21 narcisgarcia Is it possible that ALL tags have subfields? Or subfields are only specifications of tags behaviour instead of subtags? 15:25 Joubu hum? I do not get it 15:28 narcisgarcia It seems that all tags have subfields, and I understood at first that subfields were subtags (worng) 15:28 narcisgarcia *wrong 15:31 Joubu tag==field, subtag==subfield, they are synonyms 15:33 andreashm gah, no timestamp in borrowers table. 15:33 andreashm is there any way to check when last changes where made? 15:34 Joubu borrowerlogs? 15:35 Joubu the pref is named "BorrowersLog" 15:36 andreashm joubu: ah! 15:40 andreashm Joubu++ 15:41 andreashm does the borrower log only track changes made by the staff interface? or any interaction? 15:46 Joubu add, edit, delete, password changed, membership renewed and also the add/deletion of a circulation message 15:47 oleonard Hi cait 15:47 oleonard cait++ # Lots of QA 15:48 andreashm Joubu: yes, but I mean also if changes are introduced via api, scripts etc. not only interface interactions by staff 15:50 Joubu they all should call AddMember and ModMember, so yes 15:52 andreashm ok, good, thanks! 15:52 cait oleonard: cheated a little - oyurs were nice to work on :) 15:55 Joubu It would be good to continue the effort on that btw :) I would like to push them all very soon 15:55 andreashm bye #koha 15:56 cait hm? 15:56 cait sorry, just got on 15:56 * oleonard has some QA fixes to do 15:56 cait ... and on a train so ont sure how long I can old onto internet :) 15:57 Freddy_Enrique Bom dia gente 15:59 cait oleonard: hope comments made sense - and sory for the blocked ones - hope they can be resolved soon 16:02 narcisgarcia MARC framework doesn't export right 16:02 narcisgarcia (sory) MARC framework administration doesn't import right 16:07 Joubu could you be more specific? Do you have something in the logs? 16:07 reiveune bye 16:08 Joubu bug 10538 ? 16:08 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10538 normal, P5 - low, ---, mtj, Failed QA , Improve importation of .CSV framework files 16:09 narcisgarcia Looking... 16:12 narcisgarcia That bug report seems to talk about LibreOffice conversions, but I'm processing with ShellScript and verifying with text editor 16:13 cait what is wrong? 16:13 wahanui I only know what you teach me. 16:13 narcisgarcia Subfield constraints are imported within tags names 16:13 cait some necoding issue maybe? 16:14 narcisgarcia Oh, okay! I see default framework shows subfields description too. 16:16 narcisgarcia I see I'll need to make many user tests before entering definitive bibliography data 16:16 narcisgarcia As far as I understood, MARC frameworks are "templates" for catalogation form 16:17 narcisgarcia If I delete framework tags, this has the simple effect to not recording that bibliography data. 16:18 narcisgarcia And Koha to MARC mapping is only a translation for form fields presentation. 16:19 narcisgarcia Then: Librarian uses a form <- Koha to MARC mapping <- MARC framework -> Koha database 16:19 narcisgarcia Am I right? 16:20 cait the mappings fill additional tables with basic data 16:20 cait to be used for reports and some displays 16:20 cait you would normall ynot want to change them 16:20 cait i'd recommend hiding a tag usually over deleting it 16:20 cait when you import data and the tags/subfields are not defined, the data is lost on saving the record 16:20 cait this can be a wanted or an unwanted effect 16:21 cait you are on a much safer side just hiding fields you don't use 16:21 narcisgarcia Am I right about forms structure (independently it's applied to more objects) ?? 16:22 narcisgarcia Using a form <- Koha to MARC mapping <- MARC framework -> Koha database 16:23 narcisgarcia Cataloging form <- Koha to MARC mapping <- MARC framework -> Koha database 16:24 narcisgarcia How can I hide a tag to not delete it? 16:28 narcisgarcia When I import data, I suppose default framework can be selected for that, right? 16:29 narcisgarcia In the meanwhile, specific framework with really few tags seems to be the solution for us. 16:30 itemnumber hello 16:30 wahanui kia ora, itemnumber 16:31 itemnumber i have a question 16:31 narcisgarcia [Thanks to everyone who answered my questions] 16:31 itemnumber im doing and export/import from my koha 16:31 itemnumber im trying to import 952$p 16:32 itemnumber and i can't do it 16:32 itemnumber i have 2 books with diferent barcode number 16:32 itemnumber how can i do it? 16:33 oleonard How are you doing the import, itemnumber? 16:34 cait you need 2 952 fields 16:35 cait narcisgarcia: look at the hidden column - the possible numeric values are explained on the wiki 16:35 cait sorry, on a train, can't find the page for you 16:35 itemnumber first i export my data 16:36 itemnumber with all the information 16:37 narcisgarcia In CSV I see: "tagfield","liblibrarian","libopac","repeatable","mandatory","authorised_value","frameworkcode" 16:37 cait hm 16:37 cait ah 16:37 cait only for subfields 16:37 itemnumber then i click on import 16:37 cait if you hide all subfields the field wil go 16:38 narcisgarcia Okay. I'll try 16:39 itemnumber i have that 952$p field 16:39 itemnumber but is not showing barcode number on my opac 16:39 oleonard itemnumber: Does it show in the staff client? 16:40 itemnumber nope 16:40 itemnumber i just have this msg "No physical items for this record" 16:42 oleonard itemnumber: You say first you export your data. From Koha? Are you modifying the data outside of Koha before importing it? 16:43 itemnumber no 16:44 itemnumber from koha yes. im not modifying anything outside before importing it 16:47 itemnumber i have to modify something? 16:47 oleonard Can you confirm that the export has item data in it? 16:48 itemnumber yes 16:48 itemnumber its all there 16:49 itemnumber even 952$p 16:49 itemnumber but is not showing on opac 16:50 oleonard itemnumber: What about when you edit the record in the staff client? Are the items there? 16:50 itemnumber yes 16:50 itemnumber i can see all of it 16:53 cait train delayed... trying to get an impossible connection - cross fingers plz #koha 16:55 itemnumber i dont know what to do 17:06 itemnumber any ideas 17:06 wahanui any ideas are welcome :) 17:06 itemnumber ? 17:15 tuxayo damn you wahanui ! 17:16 tuxayo I hope itemnumber didn't left for that... 17:16 tuxayo see you all! 17:17 Freddy_Enrique itemnumber? are you using csv or excel to migrate? 17:17 oleonard We lost them, Freddy_Enrique. 17:17 Freddy_Enrique them? 17:17 wahanui them is *sigils* dammit! 17:18 oleonard itemnumber. 17:18 wahanui somebody said itemnumber was the primary key for the items table 17:18 oleonard wahanui you are full of sass today. 17:18 wahanui ...but wahanui is a bot|a repository of important and useful and accurate information or at least partially slow.|a little bit creepy.|right sometimes|a strange duck|a bot...|rumoured to be a sentient bot with sass|<reply> an extremely creepy stalker bot.... you have been warned|a parrot|<reply> wrong|<reply> on fire|<reply> gaining knowledge faster than sustainable|canadian|google|<reply> wahanui couldn't be bothered to show up|laser kiwi of the bo 17:18 Freddy_Enrique wahanui is a bot right? whats up with it? 17:19 oleonard manual? 17:19 wahanui manual is probably at http://www.koha-community.org/documentation 17:19 oleonard wahanui sometimes provides useful information :) 17:19 wahanui oleonard: sorry... 17:20 Freddy_Enrique Uhm... I thought it responded when we use commands 17:21 oleonard @later tell Freddy_Enrique It's huginn` who does that. 17:21 huginn` oleonard: The operation succeeded. 17:21 Freddy_Enrique oh!!! jajaja 17:22 Freddy_Enrique so wahanui could be considered AI? 17:22 Freddy_Enrique this is new for me 17:22 oleonard I'm not going to argue with that because wahanui can hear me. 17:22 Freddy_Enrique wahanui acts like a person.... I wonder if it makes jokes too :) 17:22 wahanui Freddy_Enrique: what? 17:23 * Freddy_Enrique leaves rapidly 20:28 magnuse next meeting? 20:28 wahanui next meeting is probably https://wiki.koha-community.org/wiki/Next_IRC_meetings 21:36 cait @later tell Joubu was aware of the change with activating warnings - left a comment on the 'superbug' where i linked them too - of course RM is making the decision :) 21:36 huginn` cait: The operation succeeded. 21:37 Joubu cait: yep, I pushed them :)