IRC log for #koha, 2012-10-27

All times shown according to UTC.

Time S Nick Message
00:24 melia left #koha
01:26 jenkins_koha Starting build #215 for job Koha_3.8.x (previous build: SUCCESS)
02:05 jenkins_koha Project Koha_3.8.x build #215: SUCCESS in 38 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/215/
02:05 jenkins_koha * mtompset: Bug 8910 - silent warnings triggered in
02:05 jenkins_koha * adrien.saurat: Bug 8234: fixes date sort on 'Transfers to receive' page
02:05 jenkins_koha * koha: Bug 8888 : Question marks in series title facet links
02:05 jenkins_koha * kyle: Bug 8213 - "Cancel All" button on holds over tab cancels both holds over and holds waiting
02:05 huginn Bug[…]w_bug.cgi?id=8910 minor, P5 - low, ---, mtompset, Pushed to Stable , silent warnings triggered in
02:05 huginn Bug[…]w_bug.cgi?id=8234 minor, P5 - low, ---, adrien.saurat, Pushed to Stable , Dates are not well sorted on Transfers to receive
02:05 huginn Bug[…]w_bug.cgi?id=8888 normal, P5 - low, ---, koha, Pushed to Stable , question marks in series title facet links
02:05 huginn Bug[…]w_bug.cgi?id=8213 major, P5 - low, ---, kyle.m.hall, Pushed to Master , "Cancel All" button on holds over tab cancels both holds over and holds waiting
02:05 jenkins_koha Starting build #216 for job Koha_3.8.x (previous build: SUCCESS)
02:44 jenkins_koha Project Koha_3.8.x build #216: SUCCESS in 38 min: http://jenkins.koha-community.[…]b/Koha_3.8.x/216/
02:44 jenkins_koha * mathieu.saby: Bug 8958: Make facets more UNIMARC compliant (revision 1)
02:44 jenkins_koha * williams: Bug 8939 : Fines being charged during the grace period
02:44 jenkins_koha * Paul Poulain: Bug 8939 follow-up welcome to Robert Williams 194th contributor
02:44 huginn Bug[…]w_bug.cgi?id=8958 normal, P5 - low, ---, mathieu.saby, Pushed to Stable , Facets are not fully UNIMARC compliant
02:44 huginn Bug[…]w_bug.cgi?id=8939 major, P5 - low, ---, koha-bugs, Pushed to Stable , Fines Charged During Grace Period
03:06 talljoy left #koha
03:28 brylie joined #koha
05:44 cait joined #koha
06:37 druthb joined #koha
07:50 druthb joined #koha
10:14 mveron joined #koha
11:19 drojf1 joined #koha
12:41 cait quiet saturday
12:46 tcohen joined #koha
13:37 mbalmer joined #koha
13:37 mbalmer left #koha
14:00 cait @wunder Konstanz
14:00 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 1.7°C (4:00 PM CEST on October 27, 2012). Conditions: Light Snow. Humidity: 95%. Dew Point: 1.0°C. Windchill: 2.0°C. Pressure: 29.50 in 999 hPa (Rising).
14:23 cait @wunder BER
14:23 huginn cait: Error: No such location could be found.
14:23 cait @wunder BOO
14:23 huginn cait: The current temperature in Bodo, Norway is 3.0°C (3:50 PM CEST on October 27, 2012). Conditions: Scattered Clouds. Humidity: 65%. Dew Point: -3.0°C. Windchill: -2.0°C. Pressure: 29.62 in 1003 hPa (Steady).
14:23 cait @wunder Oslo
14:23 huginn cait: Error: No such location could be found.
15:05 Oak joined #koha
15:06 * Oak waves
15:06 cait hi Oak :)
15:06 Oak hello cait :)
15:06 Oak how is marcus?
15:07 cait heh
15:07 cait I will see him next weekend
15:07 cait looks like a happy baby on the latest pictures
15:08 Oak cool. good :)
15:08 Oak how are you?
15:09 cait I am good too :)
15:09 cait and you?
15:09 Oak good.
15:09 Oak i'm okay.
15:10 Oak @wunder konstanz
15:10 huginn Oak: The current temperature in Konstanz, Germany is 1.0°C (5:00 PM CEST on October 27, 2012). Conditions: Heavy Snow. Humidity: 97%. Dew Point: 1.0°C. Pressure: 29.61 in 1003 hPa (Rising).
15:10 Oak cold weather in europe i heard on news
15:11 cait yeah, fist bt of snow here
15:11 cait but it's really not heavy snow
15:11 cait and not sticking to the ground yet, too warm
15:11 Oak hmm
16:10 YoungPublicLibrary joined #koha
16:11 YoungPublicLibrary Same question as before, anyone know the right schema field for the "Other Librarians" messages?
16:18 cait it's another table
16:18 cait messages or similar I think
16:20 YoungPublicLibrary messages.message is the only thing close, and it gives the "Patron" messages instead of the "Other Librarians" messages...
16:26 cait it's both, depending on another field
16:26 cait YoungPublicLibrary: check the columns of the messages tables
16:26 cait in the schema
16:28 YoungPublicLibrary yeah, I see that now. I'm working on making a join now...I'm just not very good at it...
16:28 cait why do you want to join?
16:29 YoungPublicLibrary the messages table and the accountlines table. So that I can get the message to print out as 'L' or "Other Librarians"
16:29 cait oh hm
16:42 YoungPublicLibrary okay, lets forget the join for a would I specify the message type. There is the field messages.message_type, but how would I specify 'L' instead of 'B', which it seems to default to
16:43 cait I am not sure what your question is
16:44 cait if you only want to see the L instead of the B type
16:44 cait you would use a condition
16:44 cait where messages.message_type = "B"
16:44 cait hm "L"
16:45 YoungPublicLibrary specifically with double quotation marks or does that matter? cuz I tried that and it didn't work, but I used single quotation marks...
16:45 cait that shouldn't matter
16:45 cait you need the quotes for strings, number don't need quotes
16:45 cait are you sure oyu have messages like that?
16:46 YoungPublicLibrary hmm...I must have the join wrong then....would you mind if I pasted the report here so you could see if you see anything wrong with it...
16:46 cait I can try
16:47 YoungPublicLibrary okay...thanks I'll have it posted momentarily
16:51 pastebot "YoungPublicLibrary" at pasted "TestFines" (7 lines) at
16:53 cait i will have to add some data to my database to see
16:54 YoungPublicLibrary if its too much trouble don't worry about it. I'm sure I'll figure it out at some point. Just gotta wait for one of those brilliant moments of insight to hit me smack dab in the forehead...
16:54 cait it's ok
16:54 cait let me give it one try
16:55 cait oook
16:55 cait it doesn't look bad
16:56 cait ok
16:56 cait it works for me
16:56 cait your statement, as you posted it
16:56 cait I am not sure why it wouldn't work for you - do you have a patron with outstanding fines AND a message to other librairans to test with?
16:57 cait your pull down for branches shows up correctly when you start the report?
16:57 YoungPublicLibrary Yes, I do have a test subject. That is weird...
16:58 cait this worked for me, I only took out the branchs thing, because I was testing it in mysql directly
16:58 cait
16:59 YoungPublicLibrary Yes, the pull down comes up first, once you select a library it goes to a blank screen with the code up top...
17:00 cait it's the only change I made - I am sorry, not sure why it wouldn't work for you
17:00 cait what happens if you leave the and .... with the branches out?
17:01 cait I would always try a simple query first and then refine it step by step
17:01 YoungPublicLibrary okay, got it to work now...but I have a different problem...
17:02 YoungPublicLibrary Maybe the system had a hickup or something the first time I tried to run it...but this time it popped right up...
17:02 YoungPublicLibrary The only problem now is that it is only showing me patron's with text in the messages.message field. If they don't have text there they don't come up. I need them to show up whether there is a message there or not...
17:04 cait YoungPublicLibrary: there is a couple of problems with your query I think
17:04 cait one being that there can be more than one message
17:05 cait for librarians
17:05 cait on one patron record
17:05 cait what you want can be done, but I always struggle a bit with the right syntax myself
17:05 YoungPublicLibrary I am wanting that. The results give a list of the messages
17:06 YoungPublicLibrary yeah, I've never really done anything with SQL. I took one class in college and then never used it until we moved to the syntax gets me quite often...
17:08 cait look at the different joins here:
17:08 cait
17:09 YoungPublicLibrary maybe I should try a FULL JOIN
17:10 cait I don't have enough data in my database
17:10 cait to really teast
17:11 cait test
17:11 cait w3c school pages are often quite helpful, there are more examples about joins there
17:11 cait at the next pages
17:11 cait I think you want that there is amatching borrower line, but not necessarily one in messages
17:11 YoungPublicLibrary okay, I'll take a look at it. Thanks for all your help!
17:11 cait hope you can figure it out
17:12 YoungPublicLibrary I'm sure I will now. You got me headed in the right direction. Thanks!
17:13 cait you were almost there from the beginning :)
17:19 brylie joined #koha
17:29 brylie joined #koha
17:30 YoungPublicLibrary Whew, got it to work right. Would you like to see Cait?
17:30 cait sure :)
17:32 pastebot "YoungPublicLibrary" at pasted "TestFines" (7 lines) at
17:32 cait aaah
17:32 cait the or is an clever idea :)
17:32 cait a clever idea
17:33 cait hmm
17:33 YoungPublicLibrary thank you, it was a combination effort of another programmer and myself...
17:33 cait but does it always work? even for a new borrower without any messages?
17:34 cait hm, if you say it does it will :)
17:34 YoungPublicLibrary Hmm...that I don't know. And I don't have permissions to delete a borrower, so can't really test that
17:35 cait ah
17:38 brylie_ joined #koha
17:46 drojf1 joined #koha
17:49 brylie joined #koha
18:11 brylie joined #koha
18:18 brylie joined #koha
18:19 cait @wunder Konstanz
18:19 huginn cait: The current temperature in Konstanz, Germany is 1.0°C (8:00 PM CEST on October 27, 2012). Conditions: Snow. Humidity: 100%. Dew Point: 1.0°C. Pressure: 29.71 in 1006 hPa (Rising).
18:29 YoungPublicLibrary @wunder Fairbanks
18:29 huginn YoungPublicLibrary: Error: No such location could be found.
18:29 YoungPublicLibrary lol, fail...
18:34 cait YoungPublicLibrary: try an airport code if you have one
18:34 cait @wunder BOO
18:34 huginn cait: The current temperature in Bodo, Norway is 3.0°C (8:20 PM CEST on October 27, 2012). Conditions: Scattered Clouds. Humidity: 65%. Dew Point: -3.0°C. Windchill: -1.0°C. Pressure: 29.65 in 1004 hPa (Steady).
18:34 cait hm or zipcode maybe
18:46 YoungPublicLibrary lol, I'm not even sure that's how the town name is spelled. Its the farthest north settlement in cousin coaches football there. They literally have guard towers around the football field to watch for polarbears...
18:46 cait oh wow
18:58 YoungPublicLibrary Yeah, on average its like 10 degrees there. Last winter the temperatures hit -32 degrees...and he likes it there!
18:58 cait heh
18:58 cait maybe your brother is a polar bear? :)
19:00 YoungPublicLibrary lol, that may very well be...
19:14 bgkriegel joined #koha
19:22 cait joined #koha
19:24 cait joined #koha
19:26 cait1 joined #koha
19:52 cait1 mveron++ drojf++ #translations, translations, translations!
19:58 slef joined #koha
20:02 cait1 left #koha
20:21 Brooke joined #koha
20:27 slefpet joined #koha
20:40 mib_o0y3qm joined #koha
20:40 mib_o0y3qm hi
20:40 wahanui salut, mib_o0y3qm
20:40 mib_o0y3qm need some help
20:40 mib_o0y3qm can anyone help me
20:48 drojf goodness. from what year is that newsletter??
20:48 drojf 'Ryan Terrenal of the National Library of the  Philippines reports: "We are still in the building stage of the Koha  community in the Philippines. We have installed 297 computers with Koha  2.29 running on Fedora Linux.'
23:14 JesseM joined #koha
23:14 JesseM left #koha

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