IRC log for #koha, 2018-02-05

All times shown according to UTC.

Time S Nick Message
00:09 Kafilini joined #koha
01:15 Kafilini joined #koha
02:12 JoshB left #koha
02:21 rocio_afk joined #koha
02:29 rocio_afk joined #koha
04:11 Kafilini joined #koha
04:21 rocio_afk joined #koha
04:28 indradg_ joined #koha
05:23 cait joined #koha
06:47 indradg joined #koha
07:20 laurence joined #koha
07:35 reiveune joined #koha
07:35 reiveune hello
07:38 indradg_ joined #koha
07:41 alex_a joined #koha
07:41 Infra_3600 joined #koha
07:41 alex_a bonjour
07:41 wahanui privet, alex_a
07:42 paul_p joined #koha
07:56 marcelr joined #koha
07:56 marcelr hi #koha
08:00 AndrewIsh joined #koha
08:16 laurence joined #koha
08:21 laurence joined #koha
08:24 cait1 joined #koha
08:27 tuxayo hi koha o/
08:27 * magnuse waves
08:28 marcelr o/
08:34 sophie_m joined #koha
08:37 sophie_m joined #koha
08:37 eythian https://community.letsencrypt.[…]tion-issues/50811 <-- things to be aware of if you're using letsencrypt for SSL
08:39 cait joined #koha
08:40 tuxayo eythian++
08:57 * cait waves from a train
09:07 cait1 joined #koha
09:14 josef_moravec joined #koha
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:22 cait joined #koha
09:32 fridolin joined #koha
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[…]_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
09:45 cait1 joined #koha
10:02 magnuse any known negative side effects of running /usr/share/koha/bin/cronjobs​/holds/build_holds_queue.pl more often than hourly?
10:18 cait joined #koha
10:21 cait2 joined #koha
10:24 cait1 joined #koha
10:39 cait1 left #koha
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[…]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[…]_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[…]_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[…]_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:28 marcelr joined #koha
11:33 Kafilini joined #koha
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[…]_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
11:54 papa1 joined #koha
12:20 oleonard joined #koha
12:21 magnuse bug 2505
12:21 huginn` Bug http://bugs.koha-community.org[…]w_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:33 meliss joined #koha
12:35 tcohen joined #koha
12:36 tcohen morning
12:50 huginn` News from kohagit: Bug 19996: (QA follow-up) Remove commented use warnings; <http://git.koha-community.org/[…]6e68dc869bf0fef54>
12:50 huginn` News from kohagit: Bug 20124: Make "Save configuration" translatable on "did you mean?" config <http://git.koha-community.org/[…]72bcee6f16c4a9445>
12:50 huginn` News from kohagit: Bug 20110: Adding same user multiple times to same budget <http://git.koha-community.org/[…]add0087ebedbca44e>
12:50 huginn` News from kohagit: Bug 20109: Make "Remove" translatable when adding a fund <http://git.koha-community.org/[…]08087cf191745b49b>
12:50 huginn` News from kohagit: Bug 20098: Inventory tool: CVS export: fix itemlost column <http://git.koha-community.org/[…]4035fb236458fcd67>
12:50 huginn` News from kohagit: Bug 20062: Remove support for Internet Explorer 7 in the staff client <http://git.koha-community.org/[…]0fc96d3f6e63626a7>
12:50 huginn` News from kohagit: Bug 20060: Resolve uninitialized warn from Koha::Template::Plugin::Branches <http://git.koha-community.org/[…]c55f0da3271d958e9>
12:50 huginn` News from kohagit: Bug 20019: use Modern::Perl in misc perl scripts <http://git.koha-community.org/[…]0a62ce9c8c7107644>
12:50 huginn` News from kohagit: Bug 20010: use Modern::Perl in Patroncards perl scripts <http://git.koha-community.org/[…]a09ba8d0f2a39862d>
12:50 huginn` News from kohagit: Bug 20009: use Modern::Perl in Members perl scripts <http://git.koha-community.org/[…]e64decc5fb64e5b6a>
12:50 huginn` News from kohagit: Bug 20018: use Modern::Perl in offline_circ scripts <http://git.koha-community.org/[…]a40e3902e909438c3>
12:50 huginn` News from kohagit: Bug 20020: use Modern::Perl in XT scripts <http://git.koha-community.org/[…]5b657b1a4c98db694>
12:50 huginn` News from kohagit: Bug 20016: use Modern::Perl in svc scripts <http://git.koha-community.org/[…]a9475e3460e4b6fec>
12:50 huginn` News from kohagit: Bug 19998: use Modern::Perl in error perl scripts <http://git.koha-community.org/[…]aa9c7945a29211584>
12:50 huginn` News from kohagit: Bug 20011: use Modern::Perl in plugins perl scripts <http://git.koha-community.org/[…]0562632315b588e36>
12:50 huginn` News from kohagit: Bug 20012: use Modern::Perl in Reports perl scripts <http://git.koha-community.org/[…]f953d4e18930c2669>
12:50 huginn` News from kohagit: Bug 20017: use Modern::Perl in Tools perl scripts <http://git.koha-community.org/[…]0d8a74a6b539cb7a4>
12:50 huginn` News from kohagit: Bug 19997: use Modern::Perl in Circulation perl scripts <http://git.koha-community.org/[…]e220d27a8a1251cd4>
12:50 huginn` News from kohagit: Bug 20015: use Modern::Perl in Serials perl script <http://git.koha-community.org/[…]2d774eeaf7bfe9b68>
12:50 huginn` News from kohagit: Bug 20013: use Modern::Perl in Reserve perl script <http://git.koha-community.org/[…]b35880e674dd200bb>
12:50 huginn` News from kohagit: Bug 19999: use Modern::Perl in label scripts <http://git.koha-community.org/[…]000045ae5fe481af0>
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/[…]89ceee63d8396fbdb>
13:00 huginn` News from kohagit: Bug 20109: (follow-up) Use double quote instead of simple-quote <http://git.koha-community.org/[…]8060fb82bac24670f>
13:02 jenkins Project Koha_Master_D8 build #345: ABORTED in 9 min 29 sec: https://jenkins.koha-community[…]ha_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]_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[…]ha_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[…]_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 Margaret joined #koha
13:10 huginn` News from kohagit: Bug 7143: Update about page for new dev - Jenny Way <http://git.koha-community.org/[…]3e19f83ba2c4f7f9a>
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:31 Dyrcona joined #koha
13:35 kellym joined #koha
13:47 Joubu oleonard: https://screenshots.firefox.co[…]I/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[…]ha_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[…]w_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
13:51 andreashm joined #koha
13:52 pvkrogh joined #koha
13:53 nengard joined #koha
14:03 meliss joined #koha
14:04 andrewfh joined #koha
14:11 NateC joined #koha
14:11 narcisgarcia joined #koha
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 Bmagic joined #koha
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:27 JoshB joined #koha
14:28 narcisgarcia Is there some guide or published notes about exporting/importing MARC frameworks?
14:28 talljoy joined #koha
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.o[…]marcbibframeworks
14:38 narcisgarcia Thanks http://manual.koha-community.o[…]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:42 indradg_ joined #koha
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:50 tallerjoy joined #koha
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:01 donnabachowski joined #koha
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:12 donnabachowski left #koha
15:15 DonnaB joined #koha
15:15 indradg_ joined #koha
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:27 andreashm joined #koha
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:29 laurence left #koha
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:46 cait joined #koha
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:56 Freddy_Enrique joined #koha
15:57 Freddy_Enrique Bom dia gente
15:57 DonnaB joined #koha
15:57 donnabachowski joined #koha
15:59 TGoat joined #koha
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 DonnaB joined #koha
16:07 Joubu could you be more specific? Do you have something in the logs?
16:07 reiveune bye
16:07 reiveune left #koha
16:08 Joubu bug 10538 ?
16:08 huginn` Bug http://bugs.koha-community.org[…]_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:15 DonnaB joined #koha
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:18 jbeno joined #koha
16:19 narcisgarcia Then: Librarian uses a form <- Koha to MARC mapping <- MARC framework -> Koha database
16:19 rocio_afk joined #koha
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:26 Prueba joined #koha
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 joined #koha
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:40 cait1 joined #koha
16:42 kmlussier joined #koha
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:47 cait joined #koha
16:48 itemnumber yes
16:48 itemnumber its all there
16:49 alex_a joined #koha
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 DonnaB joined #koha
16:53 cait train delayed... trying to get an impossible connection - cross fingers plz #koha
16:53 cait left #koha
16:55 itemnumber i dont know what to do
17:01 DonnaB joined #koha
17:06 itemnumber any ideas
17:06 wahanui any ideas are welcome :)
17:06 itemnumber ?
17:11 fridolin left #koha
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
17:51 kmlussier joined #koha
18:04 tcohen joined #koha
18:59 DonnaB joined #koha
20:08 cait joined #koha
20:28 magnuse next meeting?
20:28 wahanui next meeting is probably https://wiki.koha-community.or[…]Next_IRC_meetings
20:33 indradg_ joined #koha
20:42 ashimema joined #koha
20:52 Kafilini joined #koha
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 :)
22:32 Kafilini joined #koha
22:35 dilan joined #koha
22:45 papa1 joined #koha
23:23 JoshB left #koha
23:51 jzairo joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary