IRC log for #koha, 2016-06-14

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
00:09 Francesca joined #koha
00:49 jzairo joined #koha
01:13 JoshB joined #koha
02:40 mario joined #koha
03:25 geek_cl joined #koha
03:45 irma joined #koha
04:11 mario joined #koha
04:51 taa joined #koha
04:52 taa we wish to import bound volumes excel data in koha how to map multiple records with one biblio
04:52 especially vol, no, acc no
05:06 Oak joined #koha
05:06 Oak Ahoy me hearties!
05:09 cait joined #koha
05:12 magnuse Oak
05:12 paul_p joined #koha
05:13 magnuse bonjour paul_p
05:45 * cait waves
05:46 * magnuse waves back
05:50 laurence joined #koha
05:54 kathryn joined #koha
05:54 mveron joined #koha
05:54 mveron Good morning / daytime #koha
06:00 Oak magnuse
06:00 hello cait, #koha!
06:03 jajm hello
06:03 wahanui what's up, jajm
06:11 LibraryClaire joined #koha
06:15 * LibraryClaire waves
06:17 BobB joined #koha
06:20 LibraryClaire1 joined #koha
06:21 Francesca joined #koha
06:25 cait left #koha
06:26 irma joined #koha
06:49 fridolin joined #koha
06:49 fridolin hie
06:53 gaetan_B joined #koha
06:54 gaetan_B hello
06:55 reiveune joined #koha
06:56 reiveune hello
06:56 wahanui salut, reiveune
06:59 wilfrid joined #koha
07:01 alex_a joined #koha
07:01 alex_a bonjour
07:02 drojf joined #koha
07:05 drojf morning #koha
07:07 * LibraryClaire waves to everyone
07:15 sophie_m1 joined #koha
07:23 cait joined #koha
07:35 brinxmat joined #koha
07:35 brinxmat Hey folks
07:35 From sunny Oslo
07:36 drojf hi brinxmat
07:36 @wunder berlin, germany
07:36 huginn` drojf: The current temperature in Berlin Tegel, Germany is 16.0°C (9:20 AM CEST on June 14, 2016). Conditions: Mostly Cloudy. Humidity: 82%. Dew Point: 13.0°C. Pressure: 29.53 in 1000 hPa (Steady).
07:36 drojf from that :/
07:36 brinxmat @wunder oslo, norway
07:36 huginn` brinxmat: The current temperature in Oslo Airport, Norway is 17.0°C (9:20 AM CEST on June 14, 2016). Conditions: Clear. Humidity: 42%. Dew Point: 4.0°C. Pressure: 29.68 in 1005 hPa (Steady).
07:36 * liw waves from a boat in the Helsinki archipelago (4G is a bit weak, but if you see it, it works)
07:37 drojf hi liw
07:37 * drojf wants to be on a boat
07:37 brinxmat Wondering if anyone can help me with a problem we're having with setting hard cap for fines per patron
07:40 drojf what is the problem? did you try MaxFine?
07:40 LibraryClaire joined #koha
07:41 brinxmat drojf: yes, we set 100 in this
07:43 I wonder if our setting for the smart rule for adults is causing the issue
07:46 All material types, fine 50, interval 3, grace 0, fine cap 100
07:47 May even be how we're testing this (setting the return date to x minutes after it has been borrowed)
08:05 paul_p joined #koha
08:12 magnuse brinxmat: how is it not working for you?
08:16 brinxmat magnuse: it may just be the way we're testing — the maxfine is not observed
08:19 drojf brinxmat: do you run the cronjobs manually then?
08:21 brinxmat drojf: they're set to run every minute
08:37 atheia joined #koha
08:38 atheia G'morn :-)
08:43 LibraryClaire morning atheia :)
08:56 ashimema mornin' #koha
08:58 LibraryClaire hey ashimema!
08:58 wahanui somebody said ashimema was on qa now .)
09:04 * atheia waves at ashimema
09:06 Joubu ashimema: good to know you are on qa now :p
09:08 ashimema lol
09:12 LibraryClaire hi Joubu! :)
09:12 Joubu hi LibraryClaire
09:13 Francesca joined #koha
09:14 * LibraryClaire needs coffee...
09:21 paul_p joined #koha
09:48 Francesca joined #koha
10:12 ashimema_ joined #koha
10:29 fridolin joined #koha
10:50 ashimema joined #koha
11:05 magnuse wow, all those db tables related to massaging is kind of confusing...
11:05 anyone got a clue how i would go about finding that one person who wants DUEDGST sent via sms?
11:11 liw @wunder helsinki
11:11 huginn` liw: The current temperature in Helsinki, Finland is 19.0°C (1:50 PM EEST on June 14, 2016). Conditions: Clear. Humidity: 40%. Dew Point: 5.0°C. Pressure: 29.77 in 1008 hPa (Steady).
11:15 magnuse @wunder boo
11:15 huginn` magnuse: The current temperature in Bodo, Norway is 10.0°C (12:50 PM CEST on June 14, 2016). Conditions: Scattered Clouds. Humidity: 71%. Dew Point: 5.0°C. Pressure: 29.77 in 1008 hPa (Steady).
11:16 LibraryClaire @wunder LCY
11:16 huginn` LibraryClaire: The current temperature in London City, United Kingdom is 17.0°C (11:50 AM BST on June 14, 2016). Conditions: Mostly Cloudy. Humidity: 77%. Dew Point: 13.0°C. Pressure: 29.42 in 996 hPa (Steady).
11:17 LibraryClaire mostly cloudy = raining and wet
11:33 LibraryClaire joined #koha
11:45 meliss joined #koha
11:48 oleonard joined #koha
11:49 oleonard Hi #koha
11:49 magnuse hi oleonard
11:50 LibraryClaire Hi oleonard
11:52 ericar joined #koha
11:56 alex_a_ joined #koha
12:00 kidclamp joined #koha
12:06 vfernandes joined #koha
12:06 vfernandes hi #koha
12:06 kidclamp joined #koha
12:07 vfernandes one strange problem: after updating one koha from 3.12 to 3.22.06 the fines calculation is very slowing
12:07 * is very slow
12:08 also when returning an item with fines the operation is also very slow
12:09 there is any reason to that?
12:15 kidclamp do you have many special holidays?
12:16 unique holidays vfernandes? (special_holidays is the db table name)
12:22 cait hm yeah holidays could make a difference
12:22 also dates far int he future or far in the past
12:25 Dyrcona joined #koha
12:25 LibraryClaire joined #koha
12:27 geek_cl joined #koha
12:33 oleonard_ joined #koha
12:46 oleonard_ joined #koha
12:48 edveal joined #koha
13:06 JoshB joined #koha
13:09 meliss joined #koha
13:12 NateC joined #koha
13:14 nengard joined #koha
13:16 vfernandes kidclamp: some holidays
13:17 but the fines script is running for about 1 hour and it didn't even finished
13:21 kidclamp vfernandes I think pianohacker has seen this and worked on some imrpovement, but I don't know the details. eh should be in later
13:21 vfernandes kidclamp: i found out what the problem is
13:21 kidclamp what was it?
13:22 vfernandes debarred was being set to '9999-12-31' in the older version
13:22 kidclamp :-)
13:22 or rather :-(
13:22 vfernandes by some reason the date calculation between now and that date takes many time...
13:25 but in the new version is also set to that date
13:27 tcohen joined #koha
13:28 mario joined #koha
13:32 tcohen bonjour
13:33 Joubu: around?
13:39 vfernandes the time calculating the days between a date in 2014 and now is huge....
13:39 get_chargeable_units takes a long time
13:40 cait vfernandes: have you defined a maxfine?
13:40 vfernandes no
13:40 there is no maxfine
13:40 tcohen hi cait
13:41 deb-CSPL joined #koha
13:42 tcohen i've received two reports from 3.22 users, about zebra "dying" every day
13:42 but the logs make me think it i srelated to log rotation, because zebrasrv is gettting a signal 15
13:42 vfernandes after some tests the problem is in days_between of Koha::Calendar
13:44 cait hm did we change that?
13:49 vfernandes cait: the problem is that for every day between 2011 and 2016 the calendar checks if is a holiday
13:49 and that is super slow!!!!
13:51 drojf tcohen: i have heard one saying mysql keeps dying. when i checked their zebra was dead too. but not my clients, no server access, can't look into it
13:52 kidclamp tcohen - maybe ping larryb when he gets in, I think we have seen similar
13:53 tcohen drojf: i experienced that too
13:53 drojf it's 3.22 and the problem seems to be relatively new
13:53 they also reported high cpu load
13:53 tcohen i mitigated it by banning bots, but didn't have the time to dig into it
13:54 jajm: around?
13:54 vfernandes_ joined #koha
13:54 jajm tcohen, yep, hi!
13:58 vfernandes this is a problem with cache
13:58 cait: do you use cache on your system?
13:59 amyk joined #koha
14:00 drojf tcohen: if bots manage to bring it down, we might have a problem :P
14:00 Karl_H joined #koha
14:01 tcohen drojf: sure
14:01 jajm: users are reporting that zebra "started dying every day" (logrotate?) and mysql dies (memory leak or smth?)
14:02 it seems to be recent
14:02 something changed recently and introduced it
14:02 talking about 3.22
14:07 jajm tcohen, users of 3.22.7 ?
14:08 cait vfernandes:  not yet, but we only have a few quite small 3.22 so far
14:10 vfernandes thanks cait
14:12 how can I set Koha cache?
14:13 tcohen jajm: that's my scenario at least, drojf and kidclamp mentioned they had some too, not sure the specifics
14:15 kidclamp 3.22.06 on the site I know of, usually is plack that goes down, but sometimes zebra, and a diffsite was having just zebra, but I don't know htose detai;s
14:15 drojf i assume it started before 3.22.7 for the library that told me. 3.22.6ish maybe
14:18 vfernandes Koha::Calendar for each overdue day is doing a query to the database...
14:19 reiveune1 joined #koha
14:21 kidclamp vfernandes that is what pianohacker had to do I think, make calendar use cache, but I don't know bugnumbers
14:21 talljoy joined #koha
14:23 pastebot "vfernandes" at 127.0.0.1 pasted "Koha::Calendar single holidays" (52 lines) at http://paste.koha-community.org/20
14:24 vfernandes kidclamp: checking the code, Koha::Calendar uses cache
14:27 kidclamp yeah, I don't knwo details it just sounds very similar
14:27 vfernandes Koha shouldn't have a default cache service when memcached of fastmmap aren't set?
14:29 reiveune joined #koha
14:38 oleonard Anyone around who is using EDIFACT?
14:38 Whoops, never mind I am not here.
14:39 tcohen joined #koha
14:40 cait oh
14:40 a oleonard-away ghost
14:42 pianohacker joined #koha
14:54 oleonard Hi cait
14:56 tcohen hi oleonard
14:58 oleonard I thought I remembered there being a discussion before previous KohaCons about what was okay for sponsors to do, i.e. don't spam anyone.
14:58 We should probably make sure it's an official part of the process.
15:00 drojf yes. i did not expect anything like that to happen. and there were a lot of other sponsors that did not do that (luckily)
15:01 the argumentation is… funny at least
15:03 rocio joined #koha
15:06 gaetan_B bye
15:06 drojf hi rocio
15:06 Joubu oleonard: How the 2 lines you modified in your last patch of bug 6148 are useful?
15:06 huginn` 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6148 enhancement, P5 - low, ---, oleonard, CLOSED FIXED, Strange Language in opac-authorities-home
15:07 Joubu +    window.modaction_legend_innerhtml = $("#modaction_legend").text();
15:07 +    window.action_submit_value = $("#action_submit").text()
15:07 What do they do?
15:07 rocio morning!
15:07 oleonard Joubu: Using jQuery instead of document.getElementById() avoids an error if the element doesn't exist
15:08 alex_a joined #koha
15:08 drojf i would appreciate if irc could show the local time of everyone
15:08 Joubu oleonard: yep, but what do they do? :)
15:09 rocio that would be nice
15:09 drojf oleonard should do a jquery workshop in marseille :P
15:09 oleonard Joubu: The variables are used to change the legend/button text of the add/edit form
15:09 nengard left #koha
15:10 oleonard Joubu: The form is reused for multiple actions, and the JS populates the values in it
15:12 Joubu oleonard: ok got it. All this code looks uselessly complicated
15:13 oleonard: the change does not work
15:13 LibraryClaire hi rocio :)
15:13 oleonard Joubu: :( Okay, back to the drawing board.
15:13 rocio hey LibraryClaire!
15:13 wahanui i think libraryclaire is the monster under my bed
15:13 nengard joined #koha
15:13 Joubu oleonard: clicking on "new action" will show the form but the submit button does not have any text
15:13 drojf hehe wahanui is not dropping that :P
15:15 Joubu oleonard: ha, the second line should be .val() instead of .text()
15:15 * oleonard should just go mow the lawn instead
15:17 drojf oleonard: i bet jquery can do that for you
15:18 fridolin left #koha
15:21 Joubu Did anybody upgrade from 3.22 to 16.05 using the packages?
15:22 2 different guys got the same error about the DB schema, that's odd
15:23 cait Joubu: didn't try
15:24 drojf Joubu: i upgraded my test instances (>20 on one server) and did not have a problem afair
15:24 oleonard I'll ask again now that I'm really here:  Is anyone around who is using EDIFACT?
15:24 drojf but that is still running on wheezy, maybe that is related?
15:24 Joubu drojf: ok thanks
15:24 drojf s/related/important/
15:25 oleonard I keep trying to look at the EDIFACT messages template, but I don't really understand how it is used.
15:25 cait oleonard: maybe khall could help or bag
15:25 vfernandes cait and kidclamp: I solved my problem
15:25 cait i didn't test it, but i know they shoudl ahve :)
15:25 vfernandes: yay
15:25 what was it?
15:26 khall oleonard: what's up?
15:26 which template file?
15:26 cait i summoned a khall!
15:26 khall lol
15:26 true ; )
15:27 oleonard Hi khall. I'm trying to do some cleanup on edifactmsgs.tt but I'm not really sure how it is used. Right now I'm just inserting random data into the db so something shows up.
15:27 vfernandes by some reason in Koha 3.22.06, Koha::Cache is using the nocache attribute on method can_load for Memory::Cache perl module
15:27 this line:     if ( can_load( modules => { 'Cache::Memory' => undef, nocache => 1 } ) ) {
15:27 should be:     if ( can_load( modules => { 'Cache::Memory' => undef } ) ) {
15:27 oleonard khall: Maybe random is fine, but I thought I'd ask if someone had examples of real data.
15:28 khall: I'm interested in particular in what kind of "message" one might see.
15:28 Joubu vfernandes: yes, it's fixed
15:28 on master
15:28 khall oleonard: one sec
15:28 oleonard It's weird that messages are displayed all by themselves on a separate full page.
15:28 Seems like a modal would be a good solution for that.
15:29 vfernandes Joubu: yes, i've checked master to see if the bug was there
15:29 kidclamp++ cait++ Joubu++
15:29 thanks for the help
15:30 khall oleonard: http://content.screencast.com/[…]0a64/00000017.png
15:30 does that help?
15:31 cait khall: do you know if nengard is writing up soemthing about how to use edifact?
15:31 oleonard Yes, thanks khall. I suppose the data in "type" and "status" columns is untranslatable
15:31 cait i got not much of an idea right now too
15:32 hm status would be nice if we could made it translatable
15:32 khall cait: not sure, I know she can though
15:32 status "should" be translatable
15:32 oleonard khall: Could you show me a couple examples of what the "view message" link shows?
15:32 khall the value is created by Koha, not the user
15:32 cait so we can do order and receivenow with edifact - is taht a good summary?
15:32 khall oleonard: sure!
15:33 cait do you order form the vendor site and it's imported or does koha create the order and sends it to the vendor somehow?
15:33 khall oleonard: http://content.screencast.com/[…]d87e/00000018.png
15:34 that's about as readable as edifact gets
15:34 I'm not sure how we could improve it, I guess the bullet points aren't really necessary
15:34 oleonard khall: Do you know why a human would want to read that?
15:34 cait hm maybe the lined display we have in some other spots?
15:34 drojf @later tell nengard when looking at 15929 i found that the syspref MaxSearchResultsItemsPerRecordStatusCheck is not documented in the manual (or at least i could not find it), could you have a look please?
15:34 huginn` drojf: The operation succeeded.
15:34 khall humans shoudl not, reading edifact causes brain damange
15:34 cait might look a little nicer
15:35 or similar to the marc view plain text
15:35 khall which explains alot about me
15:35 oleonard cait: I was thinking of the marc view plain text as well
15:35 * cait sends khall cookies
15:35 khall ; )
15:36 cait khall: did you see my question above about where the ordering happens?
15:36 oleonard khall: I'll submit a patch and hopefully you can test and make sure my changes make sense with real data :)
15:36 khall excellent! can do!
15:36 cait: I don't think so, what was it?
15:36 cait (17:33:10) cait: do you order form the vendor site and it's imported or does koha create the order and sends it to the vendor somehow?
15:36 :)
15:39 khall cait, here's the basic process:
15:40 1) Create a basket of stuff on the vendor site
15:40 2) Download the marc order file that gets created
15:40 3) In Koha, stage that order marc file
15:40 4) Create a basket for the vendor for that order
15:41 5) Import from staged file
15:41 6) Hit the send edifact order button
15:41 that are other workflows, but they don't really work with Koha yet.
15:41 nengard I need to get that in to the manual - It's on my list
15:42 cait ah
15:43 but the invoices are get in automatically?
15:43 or do youneed to do something there as well?
15:51 LibraryClaire joined #koha
15:59 Joubu khall: the schema is not up-to-date, borrowers.updated_on is not there
16:00 khall Joubu: ack! I'll take a look at fixing that!
16:01 mveron-away joined #koha
16:05 laurence left #koha
16:05 mveron-away Hi again #koha
16:06 mveron @wunder Allschwil
16:06 huginn` mveron: The current temperature in Basel, Switzerland is 16.0°C (6:00 PM CEST on June 14, 2016). Conditions: Mostly Cloudy. Humidity: 77%. Dew Point: 12.0°C. Pressure: 29.65 in 1004 hPa (Steady).
16:06 drojf hi mveron
16:06 mveron hi drojf
16:09 oleonard @wunder 45701
16:09 huginn` oleonard: The current temperature in Longview Hts, Athens, Ohio is 31.0°C (12:09 PM EDT on June 14, 2016). Conditions: Clear. Humidity: 35%. Dew Point: 14.0°C. Pressure: 30.00 in 1016 hPa (Steady).
16:12 reiveune bye
16:12 reiveune left #koha
16:27 Shane-S joined #koha
16:28 Shane-S I have version 3.20.02 and I wanted to do an update this summer. However, I have done many and it seems to slowly be an issue. So, I thought I would spin up a new VM and then migrate. Can I do 3.20 ->16.05 with the sql backups?
16:30 drojf what is an issue?
16:30 wahanui well, an issue is more like "what information do I want to show on jcamins's screenshot." :P
16:33 vfernandes why community decided to call koha 16.05 and not koha 3.24? :)
16:33 nengard Year.Month
16:33 cause we'd be on 3.x forever otherwise :)
16:34 vfernandes nengard: so the following releases will be 16.06 and so on?
16:34 nengard no
16:35 the next will be 16.11 (Nov 2016)
16:35 and then 17.05
16:35 et cetc
16:35 vfernandes 16.05.01, 16.05.02 for minor changes and bugs?
16:36 nengard Yes
16:36 I believe so
16:36 bag can confirm
16:36 vfernandes thanks nengard for the explaination
16:38 geek_cl joined #koha
16:43 huginn` New commit(s) kohagit: Bug 10459 - Update Schema <http://git.koha-community.org/[…]51e275e70c8bf9249>
16:44 bag yes that is correct
16:51 eythian drojf: CTCP TIME
16:53 drojf: doesn't seem to work for you, maybe your client is terrible.
16:53 pianohacker well huh
16:53 drojf its pidgin, so yes
16:54 hi pianohacker
16:54 pianohacker hi drojf !
16:55 recovered from that crazy jetlag yet?
16:55 eythian pianohacker: his client responded in GMT so I assume not
16:56 drojf got an excellent cold, all is laggy ;)
16:57 LibraryClaire joined #koha
16:57 drojf eythian: GMT is not so far off :D
16:57 LibraryClaire evening
16:57 eythian Two hours.
16:58 drojf wow i hate excel
16:58 eythian That's natural
16:58 drojf yes
16:58 LibraryClaire lol
16:58 eythian It costs the global economy trillions
16:58 Per year, due to errors
16:58 drojf hehe
16:58 eythian Because you can't unit test a spreadsheet
16:58 liw yes you can
16:59 but you'll end up implementing Excel in your test runner
16:59 eythian Hmm
16:59 That sounds awful
17:00 Oh yes, in previous lives, I've been given some seriously impressive spreadsheets try turn into code.
17:01 liw I implemented an accounting to system for my own use as a spreadsheet once. Not in Excel, though, but in gnumeric.
17:11 eythian I used gnucash when I wanted an accounting thing, because that's its job.
17:19 drojf worse than excel is excel with colour coded stuff. i mean, really? :/
17:19 LibraryClaire yay colours :D
17:20 drojf argh
17:23 phette23 joined #koha
17:31 tcohen joined #koha
17:33 tiosam joined #koha
17:34 tiosam hola
17:56 oleonard khall still around? I wonder if you get an error when trying to delete an EDIFACT message
17:57 khall oleonard: I let me test that
18:02 oleonard: yep, I get an error as well.
18:03 oleonard: do you want to file a bug while I write a patch?
18:03 oleonard Thanks for testing. I wanted to make sure it wasn't an artifact of the dummy data I was working with
18:03 Sure, can do
18:04 rocioj joined #koha
18:05 oleonard Bug 16737
18:05 huginn` 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=16737 normal, P5 - low, ---, kyle, ASSIGNED , Error when deleting EDIFACT message
18:05 khall thanks! it was an easy fix, will be up in a moment
18:09 meliss joined #koha
18:13 magnuse joined #koha
18:14 cait left #koha
18:38 nengard what version was MaxSearchResultsItemsPerRecordStatusCheck introduced in?
18:38 cait joined #koha
18:40 drojf nengard: 3.22.2 / 3.20.8
18:40 nengard thanks, uploading manual now :)
18:41 Joubu nengard: 3.23.00.012
18:41 ha
18:41 drojf thanks :)
18:41 nengard I don't see it in the release notes for either that's how i missed it
18:41 drojf https://koha-community.org/koha-3-22-2-released/
18:41 https://koha-community.org/koha-3-20-8-released/
18:41 under new sysprefs
18:43 nengard yeah, I read the main ones at the time of release - usually a new sys pref isn't added mid stream
18:43 drojf yes that is odd
18:43 nengard so I looked at 20.0 and 22.0
18:46 drojf http://git.koha-community.org/[…]7f72efe581d2c3de4 done
18:46 will show in the web tomorrow
18:46 drojf nengard++
18:47 oleonard nengard++
18:47 drojf oh nengard, could you use the new text maybe? it was changed in 15929
18:47 i think that is the old one
18:48 oleonard It'd be nice if every time someone got positive karma the food dispenser in their cage gave them an extra food pellet.
18:48 drojf or maybe i am confused
18:48 bug 15929
18:48 huginn` 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=15929 trivial, P5 - low, ---, c.gravely, Signed Off , typo in explanation for MaxSearchResultsItemsPerRecordStatusCheck
18:48 drojf ah its not done yet
18:48 so no idea, the new one is not valid yet :P
18:49 eythian oleonard: I scripted it so mine does
18:50 Planning on making it order a pizza soon
18:50 drojf let us know when it's done, there will be a lot of pizza
18:50 it uses your credit card, right?
18:50 cait :)
18:50 * LibraryClaire likes free pizza
18:50 nengard I copied that text from my sys prefs in master drojf
18:51 oh i see
18:51 there is a typo
18:51 okay
18:51 drojf nengard: yeah i thought it had passed already. maybe khall can have a look if he's fine with the change
18:51 oleonard Heck, if I get to script my own positive reinforcement I guess I'll pick something else too. Positive karma? Get to go home early!
18:53 nengard drojf fixed
18:54 magnuse pizza?
18:54 wahanui it has been said that pizza is in the oven.
18:54 magnuse nice!
18:54 LibraryClaire :D
18:59 oleonard Bye #koha
20:12 cdickinson_ joined #koha
20:31 magnuse joined #koha
20:54 nengard left #koha
21:06 JoshB left #koha
23:12 papa joined #koha
23:15 Francesca joined #koha

← Previous day | Today | Next day → | Search | Index

koha1