Time Nick Message 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.org/job/Koha_3.8.x/215/ 02:05 jenkins_koha * mtompset: Bug 8910 - silent warnings triggered in about.pl 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 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8910 minor, P5 - low, ---, mtompset, Pushed to Stable , silent warnings triggered in about.pl 02:05 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8234 minor, P5 - low, ---, adrien.saurat, Pushed to Stable , Dates are not well sorted on Transfers to receive 02:05 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8888 normal, P5 - low, ---, koha, Pushed to Stable , question marks in series title facet links 02:05 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_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.org/job/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 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8958 normal, P5 - low, ---, mathieu.saby, Pushed to Stable , Facets are not fully UNIMARC compliant 02:44 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8939 major, P5 - low, ---, koha-bugs, Pushed to Stable , Fines Charged During Grace Period 12:41 cait quiet saturday 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: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: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 minute...how 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 127.0.0.1 pasted "TestFines" (7 lines) at http://paste.koha-community.org/252 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 http://paste.koha-community.org/253 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 koha...so the syntax gets me quite often... 17:08 cait look at the different joins here: 17:08 cait http://www.w3schools.com/sql/sql_join.asp 17:09 YoungPublicLibrary Hmm...so 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:30 YoungPublicLibrary Whew, got it to work right. Would you like to see Cait? 17:30 cait sure :) 17:32 pastebot "YoungPublicLibrary" at 127.0.0.1 pasted "TestFines" (7 lines) at http://paste.koha-community.org/254 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 one...lol 17:35 cait ah 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 Alaska...my 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:52 cait1 mveron++ drojf++ #translations, translations, translations! 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:41 tweetbot` [off] twitter: @kohails: "#kohails Koha Community Newsletter: October 2012 http://t.co/CB8w3hKC" 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.'