Time Nick Message 00:16 jcamins_away Woohoo! Shari's here! And we're going for pizza! 00:16 jcamins_away Bye! 06:11 rangi @wunder wellington nz 06:11 huginn rangi: The current temperature in Wellington, New Zealand is 5.0�C (6:00 PM NZST on August 14, 2011). Conditions: Rain. Humidity: 87%. Dew Point: 3.0�C. Windchill: -1.0�C. Pressure: 29.47 in 998 hPa (Steady). 06:12 rangi and its snowing, or was at least 06:16 chrisdothall the snow is sadly coming to an end at my house :( 07:21 kmkale Namaskar #koha 08:05 huginn New commit(s) kohagit: Merge remote-tracking branch 'kc/new/bug_6476' into kcmaster <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8f21144fb154b68747d004eecca53fe84a020f22> / Bug 6476: Baker & Taylor Content Cafe link not showing <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=16cf1ed60e137a8513b5e9964d9a099061f97557> / Bug 6692: Small template change: Set > Set library <http://git.koha-community.org/gitweb/?p=k 08:06 jenkins_koha Starting build 377 for job Koha_master (previous build: SUCCESS) 08:17 huginn New commit(s) kohagit: Bug 2629: add char-with-stroke support to word-phrase-utf.chr <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=eda85ccc2afd136d34da89dc242b8cbcf2c8cc3b> / Bug 5252 - Phone labels on patron creation <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=0a71367dc2113de860ca25f735a4996e170e44d6> / Bug 6706 : Add Crystal Clear Icon Set <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c 08:38 huginn New commit(s) kohagit: Bug #6139 Automatic incrementation of call number does not work if prefix contains ' <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1d0c85a4a865caf82e69919b2110382be8c4539b> / Bug 6181: Remove CGI Scolling lists from C4::Budgets <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1a03a8a38eb07b9bf55e3e2afeb4f2cb4e954f66> / Fix for Bug 6309, subscription table sorter in the opac <http://git.koh 08:39 kmkale hi cairt 08:39 kmkale hi cait 08:39 cait hi kmkale :) 08:40 kmkale we have 157 registrations and 16 paper proposals for kohacon11 + one keynote 08:40 kmkale :) 08:42 kmkale I think VPM people would like to do one welcome address and one closing / thanksgiving address plus one or two koha related presentations. 08:42 kmkale Plus the panel discussions would mean we will have a full program for the three days. 08:49 jenkins_koha Project Koha_master build #377: SUCCESS in 43 mn: http://jenkins.koha-community.org/job/Koha_master/377/ 08:49 jenkins_koha * f.demians: Bug 6150 UNIMARC field 225 plugin: allow $a value data entry 08:49 jenkins_koha * robin: Bug 6626 - add sudo as a package dependency 08:49 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6150 enhancement, PATCH-Sent, ---, frederic, NEW , UNIMARC field 225 plugin: allow $a value data entry 08:49 jenkins_koha * nengard: bug 6702 update typo in BiblioAddsAuthorities preference 08:49 jenkins_koha * katrin.fischer: Bug 6692: Small template change: Set > Set library 08:49 jenkins_koha * ian.walls: Bug 6476: Baker & Taylor Content Cafe link not showing 08:49 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6626 minor, PATCH-Sent, ---, robin, ASSIGNED , Packages require sudo to work, but it's not a dependency. 08:49 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6702 trivial, PATCH-Sent, ---, nengard, ASSIGNED , BiblioAddsAuthorities pref says too instead of to 08:49 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6692 enhancement, PATCH-Sent, ---, katrin.fischer, NEW , Change 'Set' to 'Set library' 08:49 jenkins_koha Starting build 378 for job Koha_master (previous build: SUCCESS) 08:49 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6476 major, PATCH-Sent, ---, ian.walls, ASSIGNED , Baker & Taylor Content Not Working after Upgrade 09:31 rangi @wunder wellington nz 09:31 huginn rangi: The current temperature in Wellington, New Zealand is 6.0�C (9:00 PM NZST on August 14, 2011). Conditions: Light Rain Showers. Humidity: 81%. Dew Point: 3.0�C. Windchill: 0.0�C. Pressure: 29.47 in 998 hPa (Steady). 09:31 cait @wunder Konstanz 09:31 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 21.6�C (11:29 AM CEST on August 14, 2011). Conditions: Clear. Humidity: 77%. Dew Point: 17.0�C. Pressure: 29.79 in 1008.7 hPa (Steady). 09:32 jenkins_koha Project Koha_master build #378: SUCCESS in 42 mn: http://jenkins.koha-community.org/job/Koha_master/378/ 09:32 jenkins_koha * nengard: Bug 6706 : Add Crystal Clear Icon Set 09:32 jenkins_koha * nengard: Bug 5252 - Phone labels on patron creation 09:32 jenkins_koha * ian.walls: Bug 2629: add char-with-stroke support to word-phrase-utf.chr 09:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6706 enhancement, PATCH-Sent, ---, nengard, ASSIGNED , integrate crystal icon set 09:32 jenkins_koha * oleonard: Fix for Bug 6309, subscription table sorter in the opac 09:32 jenkins_koha * colin.campbell: Bug 6181: Remove CGI Scolling lists from C4::Budgets 09:32 jenkins_koha * sophie.meynieux: Bug #6139 Automatic incrementation of call number does not work if prefix contains ' 09:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5252 enhancement, PATCH-Sent, ---, nengard, ASSIGNED , Emails & Phones On Patron Add/Edit form 09:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2629 major, PATCH-Sent, ---, gmcharlt, NEW , Diacritics not being ignored when searching 09:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6309 enhancement, PATCH-Sent, ---, oleonard, ASSIGNED , subscription table sorter in the opac 09:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6181 normal, PATCH-Sent, ---, colin.campbell, ASSIGNED , Remove CGI::scrolling_list from C4:Budgets 09:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6139 normal, PATCH-Sent, ---, gmcharlt, NEW , Automatic incrementation of call number does not work if given prefix contains a ' 09:45 rangi hmm lots of hail 09:46 cait ouch 10:33 druthb o/ 13:37 cait @wunder Konstanz 13:37 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 27.6�C (3:34 PM CEST on August 14, 2011). Conditions: Clear. Humidity: 52%. Dew Point: 17.0�C. Pressure: 29.77 in 1008.0 hPa (Falling). 14:13 cait silent sunday 14:30 druthb o/ 14:35 druthb cait++ #signoffs 14:35 cait1 thx :) 15:28 cait1 someone around who could help me testing something on current head? 15:29 libsysguy @Koha migration day...round 2 15:29 huginn libsysguy: I suck 15:30 druthb hi, libsysguy! 15:30 libsysguy hey druthb 15:30 libsysguy what are you up to today 15:31 druthb this and that...data mashing, and laying and listening to the rain 15:31 libsysguy nothing like mashing some data 15:31 libsysguy but the rain bit would put me to sleep 15:33 libsysguy seen jcamins_away 15:33 wahanui jcamins_away was last seen on #koha 15 hours, 17 minutes and 9 seconds ago, saying: Bye! [Sun Aug 14 00:15:32 2011] 15:33 cait1 hi libsysguy :) 15:33 libsysguy hey cait1 15:34 libsysguy druthb...remember me asking you about the staging script yesterday? 15:40 druthb yah 15:40 cait1 yah 15:40 libsysguy well i think i messed it up...so im retrying it with a different match rule 15:41 libsysguy but if it doesn't work 15:41 cait have you seen the problems with matching rules on the list? 15:41 libsysguy no? 15:41 libsysguy is there some patch? 15:41 cait you might want to pull that patch when working with matching rules - or make sure the rule is ok in your database 15:42 libsysguy do you know if it was bug 5847 15:42 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5847 critical, P1, ---, gmcharlt, NEW , Manage Staged MARC Records stuck at 0% if isbn matching rule selected. 15:43 cait bug 6713 15:43 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6713 critical, PATCH-Sent, ---, chris, ASSIGNED , marc import not matching 15:43 cait was searching for the bug number 15:44 libsysguy hehe its ok 15:44 libsysguy i figured it was one of those two 15:47 libsysguy patched and restarted 15:47 libsysguy ill see if it works now 15:47 libsysguy thanks cait for catching that 15:47 libsysguy i've really got to pay closer attention to the bug list 15:49 cait the lists are always a good read, but time consuming 15:49 libsysguy indeed 15:51 libsysguy hey druthb can I aska favor? 15:52 libsysguy the file i sent you...can you send it back to me with a .txt extension...outlook won't let me open it and my old Koha instance died... 15:54 druthb hm. sure...two shakes 15:55 libsysguy thank you...druthb++ 15:56 cait druthb++ 15:56 cait :P 16:01 libsysguy druthb how would you select everyone out of the koha db? 16:02 libsysguy using koha's built in functions \ 16:02 libsysguy i tried this my @kohaMembers = GetMember('%'); 16:02 libsysguy but thats failing in a fantastic way 16:03 libsysguy for trade of this well kept secret I offer you this http://i.imgur.com/H3fAZ.gif 16:03 druthb hm...not sure; I can't imagine why I'd ever need to 16:03 cait hm 16:04 cait it looks like GetMember is for looking up one 16:04 cait not a lit 16:04 cait not a list 16:04 libsysguy well i was wanting to do that compare script that we talked about 16:04 cait like using it with a borrowernumber 16:04 libsysguy ahh 16:04 libsysguy hmm 16:04 cait I think SearchMember is pehraps better 16:04 cait http://perldoc.koha-community.org/C4/Members.html#GetMember 16:05 cait http://perldoc.koha-community.org/C4/Members.html 16:05 libsysguy this is helpful 16:05 libsysguy i wish i had known about his page before :'( 16:06 cait :( 16:06 cait it's all in the code 16:06 libsysguy hehe 16:06 cait it's generated from the pod 16:06 * libsysguy feels like a perl newb 16:08 cait I can't help - I am a newb myself 16:08 cait :( 16:08 libsysguy haha whatever cait...i see you patching like crazy 16:08 cait patching is not writing your own perl code 16:08 cait it's only spotting errors 16:08 libsysguy haha thats true...but writing is just an enhanced form of spotting 16:09 cait I hope to get there :) 16:09 libsysguy and a lot of knowing how to use the API 16:09 libsysguy well in java it is anyway :p 16:09 cait I think it's good to know the API for koha too 16:09 cait the perldoc page is perhaps an easier way to browse it 16:09 cait than checking the files 16:09 libsysguy i think so too 16:10 cait and patching like crazy... seems you confused me with owen! :) 16:10 libsysguy haha whatever you are my last 6 patches 16:11 libsysguy btw remember bug 5079 16:11 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5079 enhancement, PATCH-Sent, ---, tdavis, ASSIGNED , Make display of shelving location and call number in XSLT results controlled by sysprefs 16:11 libsysguy i patched that...but I think there is some hold up getting it into master 16:11 cait libsysguy: only sign-off - means testing, not patching :) 16:12 libsysguy i think sign-offs are just as important as patching 16:12 druthb libsysguy++ 16:13 cait I think keeping things moving forward is good 16:13 libsysguy exactly 16:13 * libsysguy should test more 16:13 cait yep 16:13 cait we need more testers 16:13 cait really 16:14 libsysguy right now im testing hourly and partial payments 16:14 libsysguy but those are really big 16:14 libsysguy and 16:14 cait write down your test plans and findings somewhere - is also helping 16:14 libsysguy I want to do a thorough job of testing them before i sign off 16:14 cait yes, that is good 16:15 libsysguy well...i just put it in production...so I have a whole staff doing the testing for me :p 16:17 cait and I am still worried - because it will greatly conflict with 5872 16:17 libsysguy bug 5872 16:17 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5872 enhancement, PATCH-Sent, ---, paul.poulain, ASSIGNED , Enhancements to circulation (see comment 23 for details) 16:18 libsysguy whoa 16:18 libsysguy that is going to be a mess... 16:18 cait yep 16:19 libsysguy I would not want to be Ian 16:21 cait I don't think it's Ian's resposibility now 16:21 cait it's still waiting for an initial sign off 16:21 cait and I have no idea where to start 16:22 cait reimplementing it step by step would be good :( 16:22 libsysguy that is a really big bug...I don't see why they can't break it into smaller testable pieces 16:22 libsysguy yeah incremental patches 16:22 druthb fancy that... 16:53 libsysguy druthb when you call a function in perl and don't want to pass in all the arguments...do you seperate with ,'s 16:54 libsysguy ex : Search($filter,,,$columns_out); 16:57 druthb yep. 16:58 * druthb is gonna take a lil nap...back shortly 16:58 libsysguy later druthb 17:00 cait and now she is gone 17:00 libsysguy druthb zzzzzzzzzzzz 17:07 cait yes 17:10 libsysguy grr 17:10 libsysguy so search in Member asks for a hashref 17:11 libsysguy but then it passes the hasref to Attribute.pm that is looking for an array 17:27 cait you lost me there 17:27 libsysguy its ok...i was just frustrated and ranting 17:34 cait sometimes it helps 17:38 libsysguy phew i got it working 17:38 libsysguy it was an arrayref to a hashref 17:38 libsysguy somebody hates me lol 17:41 cait no 17:42 cait libsysguy++ 17:42 libsysguy aww thanks cait 17:42 cait you figured it out :) 17:42 libsysguy finally :) 17:44 libsysguy man I need rangi to peek in here and set me up with some good music today 17:45 kmkale hi cait & libsysguy 17:45 libsysguy hey kmkale 17:45 cait hi kmkale 17:45 cait you might get lucky soon 17:46 libsysguy yeah its getting about time for him to wander in 17:46 cait hm 17:46 kmkale is it monday for you already? 17:46 cait nah, probably a bit too early still 17:46 cait 4 am in nz if I am doing the math correctly 17:46 kmkale Its our independence day holiday tomorrow :) 17:46 libsysguy well thats about what time i go run 17:46 cait ah nice 17:46 libsysguy jk jk 17:46 cait n, still sunday here 17:47 libsysguy and lucky... 17:47 kmkale yah had a long weekend after a LONG time 17:47 libsysguy i wish it was our independence day and i got another day of peace and quiet to work 17:47 kmkale I managed to lost together all papers offered for Kohacon11 17:47 cait ! 17:47 cait oh :( 17:47 kmkale will prepare a tentative schedule tomorrow and send to the liats 17:47 libsysguy kmkale: how could you 17:47 libsysguy lol 17:48 kmkale :) did I just say lost? 17:48 libsysguy yes 17:48 cait you did 17:48 kmkale aahh its 11.15pm so pl excuse me 17:48 kmkale :) 17:48 cait list? 17:48 wahanui rumour has it list is still empty 17:48 kmkale s/lost/get 17:48 cait wahanui: forget list 17:48 wahanui cait: I forgot list 17:48 kmkale yah list is better 17:49 kmkale ;) 17:51 jenkins_koha Starting build 32 for job Koha_3.4.x (previous build: SUCCESS) 17:52 kmkale better get some sleep before I mistype some more Good night all 17:56 libsysguy what is the difference between debarred and blocked in Koha? 17:57 cait libsysguy: should be the same 17:57 libsysguy hmm ok 17:57 cait libsysguy: but to make sure- where have you seen the terms? 17:57 libsysguy http://perldoc.koha-community.org/C4/Members.html#GetMember 17:57 libsysguy IsMemberBlocked 17:58 libsysguy and DebarMember 18:01 cait hm 18:01 cait probably the same 18:01 libsysguy ok cool :) 18:01 cait there will be a change to debar member 18:01 cait when the fines in days feature passes qa 18:02 cait at the moment it's boolean, will be a date then 18:02 libsysguy ok ill make sure and keep an eye out for that then so my script doesn't break 18:03 cait :) 18:30 jcamins_away libsysguy: you wanted me? 18:30 libsysguy well that stage didn't work 18:31 libsysguy so i was reindexing 18:31 libsysguy to see if that had anything to do with it 18:31 jcamins_away Channeling my standard troubleshooting suggestions, are we? :) 18:31 libsysguy and i also changed my matching rule 18:31 libsysguy haha basically 18:31 jenkins_koha Project Koha_3.4.x build #32: SUCCESS in 40 mn: http://jenkins.koha-community.org/job/Koha_3.4.x/32/ 18:31 jenkins_koha * Chris Cormack: Bug 6553 : Fixing authentication issue, there is no reason we should be able to use these without authentication 18:31 jenkins_koha * Chris Cormack: Bug 6553 : Follow up adding license statements 18:31 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6553 enhancement, P5, ---, jcamins, NEW , Parentheses in corporate author break tracings 18:31 jenkins_koha * m.de.rooy: 5663: Show control number without organization code in staff URLs 18:31 jenkins_koha * Chris Cormack: Bug 6713, editing matching rules broken 18:31 jenkins_koha * f.demians: Bug 6150 UNIMARC field 225 plugin: allow $a value data entry 18:31 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6713 critical, PATCH-Sent, ---, chris, ASSIGNED , marc import not matching 18:31 jenkins_koha * robin: Bug 6626 - add sudo as a package dependency 18:31 jenkins_koha * nengard: bug 6702 update typo in BiblioAddsAuthorities preference 18:31 jenkins_koha * katrin.fischer: Bug 6692: Small template change: Set > Set library 18:31 jenkins_koha * ian.walls: Bug 6476: Baker & Taylor Content Cafe link not showing 18:31 jenkins_koha * ian.walls: Bug 2629: add char-with-stroke support to word-phrase-utf.chr 18:31 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6150 enhancement, PATCH-Sent, ---, frederic, NEW , UNIMARC field 225 plugin: allow $a value data entry 18:31 jenkins_koha * oleonard: Fix for Bug 6309, subscription table sorter in the opac 18:31 jenkins_koha * colin.campbell: Bug 6181: Remove CGI Scolling lists from C4::Budgets 18:31 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6626 minor, PATCH-Sent, ---, robin, ASSIGNED , Packages require sudo to work, but it's not a dependency. 18:31 jenkins_koha * sophie.meynieux: Bug #6139 Automatic incrementation of call number does not work if prefix contains ' 18:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6702 trivial, PATCH-Sent, ---, nengard, ASSIGNED , BiblioAddsAuthorities pref says too instead of to 18:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6692 enhancement, PATCH-Sent, ---, katrin.fischer, NEW , Change 'Set' to 'Set library' 18:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6476 major, PATCH-Sent, ---, ian.walls, ASSIGNED , Baker & Taylor Content Not Working after Upgrade 18:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2629 major, PATCH-Sent, ---, gmcharlt, NEW , Diacritics not being ignored when searching 18:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6309 enhancement, PATCH-Sent, ---, oleonard, ASSIGNED , subscription table sorter in the opac 18:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6181 normal, PATCH-Sent, ---, colin.campbell, ASSIGNED , Remove CGI::scrolling_list from C4:Budgets 18:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6139 normal, PATCH-Sent, ---, gmcharlt, NEW , Automatic incrementation of call number does not work if given prefix contains a ' 18:32 libsysguy wow... 18:32 jcamins_away Wow, indeed. 18:32 jcamins_away Did changing the matching rule help? 18:33 libsysguy well i just added the bit at the bottom of the page 18:33 libsysguy where it asked you what you wanted to match in the db on 18:33 libsysguy i thought since it was asking the same things as in the previous box it couldn't hurt 18:33 libsysguy but it didn't really help either 18:33 jcamins_away Hrm. 18:34 jcamins_away Here's a thought: rangi just fixed a bug with the matching rule editor. 18:34 libsysguy i applied it 18:34 libsysguy :'( 18:34 jcamins_away Before you created the rule in the first place? 18:34 libsysguy oh...no 18:34 libsysguy so delete that rule and make a new one 18:35 jcamins_away That might be necessary, yes. 18:35 libsysguy ok ill give that a go after my reindex finishes 18:35 jcamins_away I wasn't around so much during that particular bugfixing session. 18:36 libsysguy ok I think something is definitely wrong 18:36 libsysguy i should have around 450K biblios 18:37 libsysguy and i am showing a count of 924670 18:37 jcamins_away i.e., twice as many? 18:37 libsysguy basically 18:37 jcamins_away Yeah... that's not good. 18:37 jcamins_away Where are you seeing that? MySQL? 18:37 libsysguy which kind of makes sense...i've run the stage 3 times and it has 250K records in it 18:37 libsysguy yes 18:38 libsysguy i just did a count * on biblio 18:38 libsysguy and im assuming that is why zebras performance is sucking right now 18:38 jcamins_away Yes. 18:38 jcamins_away That sounds right. 18:38 jcamins_away So you need to revert each stage, and then clean them after reverting. 18:38 jcamins_away Then reindex. 18:38 libsysguy ok... 18:39 jcamins_away What are the specs on your server, BTW? 18:39 libsysguy where is revert? 18:39 jcamins_away In the Manage staged batches page, go to each batch. 18:39 libsysguy umm i think i just bumped it to 8 gigs of ram with 2 2.6 ghz xeons 18:39 jcamins_away There should be a button for each back that says "Undo import into catalogue." 18:39 jcamins_away Okay, good. 18:40 jcamins_away I was hoping you weren't going to say "2gb RAM, why?" :) 18:40 libsysguy lmao 18:40 libsysguy not quire 18:40 libsysguy quite 18:40 libsysguy i could push it up if i needed to...its just a fm 18:40 libsysguy vm* 18:40 libsysguy hmm i don't see that option 18:41 jcamins_away What does the button right above the list of records say? 18:41 libsysguy import this batch into the catalog 18:41 cait hi jared :) 18:41 jcamins_away Hello. 18:42 jcamins_away libsysguy: that's what it would say if you had already undone the batch. 18:42 libsysguy ahh 18:42 libsysguy ok 18:43 jcamins_away libsysguy: this may be a problem... you probably have two copies of every record, and I don't suppose it would be safe for you to truncate the table and reimport everything? 18:43 jcamins_away cait: how are things on the other side of the pond? 18:43 jcamins_away :) 18:43 libsysguy yeah it is...kind of...i mean i have my backup 18:43 cait I smell rain :) 18:43 libsysguy so i can just import from there 18:44 libsysguy do you know if i can run koha biblio < koha.sql and just get the biblios table out of that whole dump? 18:44 jcamins_away No, you'll need to use some sort of script to process the dump file. 18:44 jcamins_away You need more than just the biblio table, though. 18:45 libsysguy right...items 18:45 libsysguy and 18:45 libsysguy umm 18:45 jcamins_away You also need biblioitems, items, and possibly circulation data. 18:45 libsysguy no circulation data should be empty 18:45 libsysguy it was a fresh import 18:45 jcamins_away That's good. 18:45 libsysguy yeah i suppose i can just put the patrons back in after and just do the whole catalog import 18:45 libsysguy that would be faster i think 18:46 jcamins_away Have you changed sysprefs, though? 18:46 libsysguy nope nothing like that 18:46 libsysguy it all came over from the other dump 18:46 jcamins_away That's good. :) 18:46 libsysguy ok here goes 18:47 jcamins_away In that case, yeah, I'd just reimport patrons after reloading. 18:47 libsysguy yeah i wrote a script to do it so its no biggie 18:48 libsysguy Would it be better instead of staging to remove the biblios/items from what i exported and just use the biblioimport tool 18:49 jcamins_away What do you mean? 18:49 jcamins_away Do you mean you have an option that doesn't include overlaying? 18:49 libsysguy yes 18:49 libsysguy basically 18:49 jcamins_away Hell yeah! 18:49 libsysguy excellent because this is a pain in the you know what 18:50 jcamins_away It's a problem that overlaying doesn't work, no doubt, but you could troubleshoot it at your leisure with small files. :) 18:50 libsysguy yeah...small files...none of my 2 gig files lol 18:50 jcamins_away Right. 18:50 jcamins_away I'd suggest... 100 records? Nice 'n' simple. No need for the command line. 18:51 libsysguy exactly 18:51 libsysguy ok so my best bet for this monster file is to remove all the records that are "electronic" 18:51 libsysguy and just reimport 18:51 libsysguy and i need to clear it out of items, biblio, and biblioitems 18:53 jcamins_away That makes sense. 18:53 libsysguy ok cool...*crosses fingers* 18:54 * libsysguy is off to slay some ebook records 18:54 cait happy hunting 19:07 rangi @wunder wellington nz 19:07 huginn rangi: The current temperature in Wellington, New Zealand is 5.0�C (6:00 AM NZST on August 15, 2011). Conditions: Scattered Clouds. Humidity: 65%. Dew Point: -1.0�C. Windchill: -2.0�C. Pressure: 29.47 in 998 hPa (Steady). 19:07 rangi bbrrrrr 19:07 * rangi goes to start the day 19:07 cait brrr 19:07 cait morning rangi 19:11 libsysguy delete biblio, biblioitems, items from items join biblio on items.biblionumber = biblio.biblionumber join biblioitems on biblio.biblionumber = biblioitems.biblionumber where items.itype = 'EBOOK'; 19:11 libsysguy how does that look to you guys? 19:11 jcamins_away Wrong. 19:11 libsysguy crap 19:12 libsysguy i was afraid to actually run it 19:12 libsysguy what looks bad to you jcamins_away 19:13 jcamins_away Are you sure that will actually delete the records from biblio and biblioitems? 19:13 cait I never tried deleting more than one table at once 19:13 cait hi Ropuch 19:14 jcamins_away My initial reaction from that is that the first "biblio, biblioitems, items" bit is a syntax error, and the rest will just do a join, then delete items only. 19:14 jcamins_away I don't suppose you have biblioitems.itemtype set/ 19:15 libsysguy well i looked up the multiple delete syntax here http://dev.mysql.com/doc/refman/5.0/en/delete.html 19:15 libsysguy yes I do 19:16 libsysguy oh wait 19:16 libsysguy i misread that 19:16 libsysguy ugh mysql is crawling 19:16 jcamins_away libsysguy: if biblioitems.itemtype is accurate, just do a delete from biblioitems where itemtype='EBOOK'. 19:16 jcamins_away It'll cascade. :) 19:16 libsysguy ahh 19:18 libsysguy good ol cascades 19:18 libsysguy well I am running a count on that item type now from there...if i get around 250K we are golden 19:18 libsysguy ugh except people are searching... 19:22 jcamins_away libsysguy: aren't you down for migration? 19:23 libsysguy technically i migrated yesterday...i just took the opac down again 19:23 libsysguy err put it in maintenance mode 19:27 cait rangi around? 19:46 cait rangi: it's ok, jared had the answer :) 19:46 cait jcamins++ 19:56 huginn New commit(s) needsignoff: [Bug 6690] If multiple issues are received in serials-edit.pl, changing the status of any issue changes the date of the first issue. <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6690> 20:13 libsysguy ok so I have an LDAP issue 20:14 libsysguy i have the principal name set to CN=%s,OU=Students,OU=Accounts,DC=patriots,DC=uttyler,DC=edu 20:14 libsysguy but i need it to search CN=%s,OU=Accounts,DC=patriots,DC=uttyler,DC=edu 20:14 libsysguy so when i just take out that OU it dies 20:14 cait sorry, no idea about ldap 20:15 libsysguy aww its ok cait 20:15 libsysguy i think its a dying art 20:15 * jcamins_away sincerely hopes so. 20:15 libsysguy me dos 20:20 huginn New commit(s) needsignoff: [Bug 6716] Database Documentation <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716> 20:28 libsysguy jcamins_away: just for the record that sql statement works 20:30 jcamins_away libsysguy: hooray! 20:30 druthb hi. 20:31 libsysguy yeah I had to run it after the cascades didn't get all the items 20:31 libsysguy hey miss sleepy druthb 20:31 druthb :) 20:34 druthb need to think about doing some laundry, but don wanna 20:35 libsysguy doing the laundry isn't the hard part...but somehow folding the laundry always gets lumped into "doing the laundry" 20:35 libsysguy and that is the tricky part 20:36 druthb this is mostly bedding,that I'll put right back on the bed. but yeah. 20:36 druthb foldin' my t-shirts seems to take ferever. 20:36 libsysguy i generally hang up all my stuff...minus my workout clothes 20:38 * druthb gave up closets, when she gave up her apartment. 20:38 druthb don't have *that* much--no room. 20:46 druthb hi, nengard 20:47 nengard hi 20:47 wahanui hello, nengard 20:49 Agent_Dani Hi 20:49 wahanui privet, Agent_Dani 20:49 * Agent_Dani is increasingly reminded of the days when she ran an Infobot. 20:52 nengard sending in db documentation patches 20:53 nengard from corpus christi, tx 20:53 nengard am wishing my stomach was strong enough for two pain pills at a time .... 20:57 cait :( 20:57 cait your hip making trouble? 20:59 nengard very much so 20:59 nengard it's not happy about me flying 5 hours and then driving 2 20:59 nengard and i couldn't take pain meds before all that cause it would knock me out 21:00 cait ouch :( 21:01 nengard yup 21:01 nengard so much so that the pain meds aren't knocking me out like they usually do 21:01 nengard so i'm writing patches :) 21:01 nengard thanks for the sign off cait 21:01 nengard glad that it's all formatted right 21:02 cait you are welcome 21:04 libsysguy can anybody tell me really quickly where the koha logs are kept on a dev install? 21:04 cait koha-dev/var/logs 21:04 libsysguy cait++ 21:11 druthb cait++ 21:11 cait :) 21:13 nengard does anyone know if branches.issuing is actually used by Koha? 21:13 nengard It's NULL for all of my branches 21:16 nengard cait what was that tip you gave the other day to create a patch and do something else in one command ... 21:16 cait git send-email --format-patch origin 21:16 nengard thanks 21:16 cait nengard: not as far as I know 21:17 cait np 21:18 nengard so cool! :) 21:18 nengard love it 21:18 nengard do you just add a -s before origin if it's a sign off? 21:20 cait i haven't tried it yet but I think that should work 21:21 rangi nengard: 21:21 rangi do a commit --amend -s 21:21 rangi then do you send patch 21:21 rangi and git bz attach 21:21 rangi and they will both end up signed off 21:22 nengard awesome! 21:23 cait right 21:23 cait :) 21:25 nengard notes added to my collection of git notes :) 21:25 nengard now i need a patch to sign off on and test that with :) hehe 21:26 nengard who wants to come get me dinner so I don't have to move from this bed? 21:26 cait I would -b ut fear your dinner would get cold until I make it 21:26 cait and a very hungry nicole 21:26 * libsysguy is raging at LDAP and xml files 21:26 nengard hehe 21:26 nengard :( 21:27 cait i reformatted a nice patch for serials 21:27 nengard sorry libsysguy, maybe you should come bring me dinner - that will make you feel better and you're the closest one :) 21:27 cait if you want to sign off on something 21:27 libsysguy haha are you even in texas? 21:27 nengard corpus christi 21:27 nengard that's why i said you were the closest 21:27 libsysguy ohh how is it? 21:27 nengard otherwise if i was home druthb would be closest 21:27 cait bug 6690 21:27 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6690 normal, PATCH-Sent, ---, fcapovilla, ASSIGNED , If multiple issues are received in serials-edit.pl, changing the status of any issue changes the date of the first issue. 21:27 libsysguy humid? 21:27 druthb :) 21:27 nengard don't know how it is - walked from car to hotel room - seemed fine out there for the 1 minute i was out there 21:28 libsysguy haha well you just didn't let all the water in the air soak in 21:28 libsysguy you have to go back outside 21:28 nengard think i'll pass 21:28 nengard humidity plus the existing joint pain i'm dealing with are a bad combo 21:29 libsysguy aww 21:29 libsysguy noo nengard 21:29 nengard the count down has begun 21:29 nengard less than a month to go 21:30 libsysguy w00t 21:30 * libsysguy wonders what we are counting down to 21:30 rangi @wunder wellington nz 21:30 huginn rangi: The current temperature in Wellington, New Zealand is 5.0�C (9:00 AM NZST on August 15, 2011). Conditions: Mostly Cloudy. Humidity: 65%. Dew Point: -1.0�C. Windchill: -2.0�C. Pressure: 29.53 in 1000 hPa (Steady). 21:30 rangi its not warming up 21:30 rangi stupid winter 21:30 libsysguy it is here 21:30 druthb brr! 21:30 libsysguy come on over 21:30 druthb @wunder intercourse, pa 21:30 huginn druthb: The current temperature in http://www.nhpaweather.com, New Holland, Pennsylvania is 22.3�C (5:30 PM EDT on August 14, 2011). Conditions: Overcast. Humidity: 91%. Dew Point: 21.0�C. Pressure: 29.73 in 1006.7 hPa (Steady). 21:30 chilts I don't mind it, reminds me of the UK (without having to live there) 21:31 nengard libsysguy we're counting down to my hip replacement 21:31 libsysguy anybody know what log file ldap login warns go in? 21:31 libsysguy ohh...for some reason I thought you already had that 21:31 nengard nope 21:31 nengard am still waiting 21:31 * cait sends rangi hot tea 21:31 cait ah sorry 21:31 * cait sends hot coffee 21:31 nengard had to get me some new meds cause the old ones weren't cutting it anymore 21:31 rangi chilts: you probably had decent insulation :) 21:31 chilts definitely 21:32 nengard @wunder corpus christi, tx 21:32 huginn nengard: The current temperature in Corpus Christi, Texas is 36.0�C (3:51 PM CDT on August 14, 2011). Conditions: Partly Cloudy. Humidity: 43%. Dew Point: 21.0�C. Pressure: 29.89 in 1012 hPa (Falling). Heat advisory in effect until 7 PM CDT this evening... 21:32 nengard oh boy 21:32 nengard that's not good 21:32 chilts so does my current place (lucky my partner had it all insulated last summer) :) 21:32 cait @wunder konstanz 21:32 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 19.6�C (11:29 PM CEST on August 14, 2011). Conditions: Light Rain Showers. Humidity: 77%. Dew Point: 15.0�C. Pressure: 29.87 in 1011.4 hPa (Rising). 21:32 nengard at home there is major rain and flooding 21:32 nengard do you have that druthb? 21:32 nengard last night sounded like hail it was so loud 21:32 druthb it rained hard here, earlier, but no hail. cloudy now, but quiet 21:32 nengard and this morning was kinda hard to drive to the airport 21:33 nengard I don't know that it was hail - it was just super loud 21:33 nengard we have these metal awnings over our bedroom windows 21:34 nengard so .. this is my last trip before surgery! the next trip i take i'll be able to run for the plane :) hehe 21:34 druthb lol 21:34 nengard yeah it is kinda funny - i've never been able to run .... 21:36 chilts good luck with the op! :) 21:36 rangi this is kinda crazy 21:37 rangi they are gettins snow as far north as nearly hamilton! 21:38 chilts heh, they also talked about snow being in Northland (down to 300m anyway) 21:38 chilts "Once in a lifetime Antarctic Blast" :) 21:38 chilts (or whatever they're calling it) 21:38 rangi you get it out at your place ? 21:38 rangi we only got flurries, too windy at our house for it to make it to the ground 21:39 nengard why is it crazy to get snow in winter? 21:39 nengard thanks chilts 21:39 rangi because it doesnt ever happen her 21:39 rangi e 21:40 nengard hubby will be live blogging the surgery (well his part in the waiting room) for you all on September 12th at http://web2learning.net 21:40 chilts yeah, the snowflakes were the biggest I've ever seen (including in the UK), it stuck pretty well and there is still snow on the grass around the house 21:40 nengard global warming 21:40 rangi MetService described the storm as a once-in-a-lifetime experience that would affect the entire country. The cold snap was expected to last till Thursday. 21:41 chilts gah, my current workplace is so cold - nose isn't warming up ... so I might go home around lunchtime again (like I did when it was cold last month_) 21:42 chilts I know that sounds bad, but just sitting here you can't warm up 21:42 rangi you at cwa? 21:42 chilts yeah, and have a draft over my head somewhere! 21:42 chilts heh 21:43 chilts we're moving offices at the end of August (to the BNZ centre) 21:48 rangi ahhh nice and close! 21:48 rangi i was thinking to do something like the oaks for lunch today, nice hot soup or laksa, if you are walking past there on your way home? 21:53 chilts yeah, I could do that ... will keep my sangers for tomorrow :) 21:54 chilts what time ... closer to 12:30 or 1 would suit me better than 12, but up to you? 21:55 rangi yeah that works better for me too 21:55 rangi its busy in there right on 12, shall we go for 1? 21:56 chilts sounds like a plan Stan 21:56 rangi sweet 21:58 nengard okay i need to go out and find some food ... maybe a grocery store and something microwavable 21:59 cait could you order something? 21:59 nengard trying so hard to stay healthy and delivery is usually pizza or chinese food 22:00 nengard got one month and 20lbs to go - i'll never make that but i want to get as close as possible 22:00 nengard it's better for recovery 22:00 nengard i'll be back all - enjoy all my patches :) cait when I get back I"ll look at yours 22:01 cait ok :) 22:01 cait hope you find something healthy close then 22:23 rangi anyone with IE8 about? 22:24 libsysguy i am 22:24 rangi http://ils.stdc.govt.nz/cgi-bin/koha/opac-search.pl?q=fish 22:24 rangi do the select all and clear all buttons work for you there? 22:25 libsysguy looks like it 22:28 rangi thanks 22:28 rangi i hate errors i cant replicate :) 22:31 libsysguy those are rather annoying 22:31 libsysguy i have one of those right now acutally 23:07 eythian oh god it's pouring with snow outside 23:07 eythian I don't like snow 23:07 enngard soup and sandwich 23:08 enngard and ice cream :) 23:19 chilts outside my window: http://wixcam.citylink.co.nz/courtenay/ 23:21 eythian GUYS, FROZEN WATER IS LITERALLY FALLING FROM THE SKY 23:21 chilts shocker 23:23 rangi hehe 23:29 mtj http://www.wn.co.nz/camera.php?cameraid=6 23:29 mtj thats a wild pic.... 23:29 mtj ... cheers again citytlink 23:30 chilts doesn't seem to be loading for me 23:30 chilts ah, doing it now 23:51 rangi @wunder wellington nz 23:51 huginn rangi: The current temperature in Wellington, New Zealand is 3.0�C (11:15 AM NZST on August 15, 2011). Conditions: Snow Showers. Humidity: 81%. Dew Point: 0.0�C. Windchill: -4.0�C. Pressure: 29.56 in 1001 hPa (Steady). 23:51 rangi (for the log) 23:53 nengard hehe