Time Nick Message 02:20 chris_n @wunder 28334 02:20 munin chris_n: The current temperature in Erwin, North Carolina is -1.0�C (9:01 PM EST on February 16, 2010). Conditions: Clear. Humidity: 44%. Dew Point: -12.0�C. Windchill: -4.0�C. Pressure: 29.88 in 1012 hPa (Falling). 02:23 chris @wunder wellington nz 02:23 munin chris: The current temperature in Wellington, New Zealand is 17.0�C (3:00 PM NZDT on February 17, 2010). Conditions: Light Rain. Humidity: 94%. Dew Point: 16.0�C. Pressure: 29.98 in 1015 hPa (Steady). 02:24 braedon|work @wunder tauranga nz 02:24 munin braedon|work: The current temperature in Tauranga Aerodrome Aws, New Zealand is 23.0�C (1:00 PM NZDT on February 17, 2010). Conditions: . Humidity: 75%. Dew Point: 19.0�C. Pressure: 30.00 in 1016 hPa (Falling). 02:28 chris_n it appears that Near Eastern University has several desirable features in their custom koha work 02:28 chris_n location mapping, hourly loans 02:28 chris tumer was always good about committing back, but i think they might still be on cvs 02:29 chris im sure if someone emailed he would give them the code 02:29 chris_n I wonder how impossible of a job it would be to merge them in 02:29 chris_n I have 02:29 chris cool 02:29 chris_n I did it with the thought that it might be possible to at least merge in the features we want 02:29 chris_n if not all of the work 02:30 chris yep 02:31 chris_n the git repo goes back pretty far does it not? 02:31 chris_n 1.2.x maybe? 02:31 chris heck no 02:31 chris only 2007 02:31 chris_n hmm 02:31 chris well the repo goes back that far 02:31 chris_n what is the tag 'version-1-2-1' 02:31 chris cos we converted from cvs 02:32 gmcharlt forward-porting would be a challenge - I'd rather see a de novo implementation of hourly loans unless Tumer has been keeping up with HEAD 02:32 chris yeah 02:32 chris hourly loans isnt actually that hard 02:32 chris it needs a database change returndate needs to be a datetime 02:32 chris_n the mapping stuff was my primary thought 02:32 chris instead of a date 02:32 chris chris_n: thats pretty localised 02:33 chris im not sure it would be generalisable in an easy way 02:33 gmcharlt that's ignoring the functionality consequences, which aren't nearly so trivial 02:33 chris_n yeah, but the logic and techique might be useful 02:33 chris gmcharlt: its pretty well defined tho, is this datetime greater than this datetime 02:34 chris its not like having to do something with search, or cataloguing :) 02:34 chris_n lol 02:34 gmcharlt if the circ code were better organized, I might agree with you 02:34 chris cant possibly be worse than Search.pm 02:35 chris_n the mapping is animated gifs 02:36 chris_n probably overlayed on the fly with a graphics module 02:36 chris_n actually, it would probably not be too hard to impliment from scratch 02:37 gmcharlt library mapping is much easier than hourly loans :) 02:37 chris_n but in any case, the images would be very localized 02:37 * chris_n imagines 'click here for the street view' 02:38 gmcharlt the old LL RFC on hourly loans is still pretty comprehensive 02:38 gmcharlt http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_hourly_circ&s[]=hourly&s[]=loans 02:38 chris yep 02:38 chris its probably still all in someones brain too 02:38 chris the actual implementation 02:38 gmcharlt not saying that you'd have to address *all* of that, but there's definitely more to it than just changing issues.date_due to a timestamp 02:39 chris_n did LL never impliment this even in LEK? 02:39 chris they say its in LLEK 02:40 gmcharlt the whole list of things claimed to be in it: http://www.liblime.com/products/koha/liblime-enterprise-koha/llek-release-notes 02:40 chris_n Tumer's work looks nice 02:41 chris_n mapping: http://library.neu.edu.tr/cgi-bin/koha/opac-location.pl?location=HQ1991.95&lib=%20NEU%20Library[Cyprus%20Section]%20%282%29%3Cbr%3E 02:41 chris heh you get a credit chris_n 02:41 chris_n how so? 02:41 chris Add Quick Spine Label Printer (Chris Nighswonger). 02:41 chris thats why people thought it was you 02:42 chris_n ah ha 02:42 * gmcharlt pulls off the mask from chris_n to reveal Kyle? 02:43 * chris_n is caught in the telephone booth :-) 02:43 chris so yeah, LLEK has hourly loans apparently 02:45 chris_n hmm: Performance enhancement: Do not embed item data in internally stored MARC data. 02:46 chris yeah that we need for 3.4 02:46 chris it slows circ down something mental 02:47 chris we can embed it there if we want, but not at the point of circulation, it could be done as a batch process, like the zebra indexing 02:47 chris or we could just leave it out, and create it when needed (export or z3950 query etc) 02:47 gmcharlt chris: I think there's any number of volunteers, myself included, lined up to work on that for 3.4 02:47 chris awesome 02:48 gmcharlt and preferably, I'd leave it out entirely excpept for export and indexing 02:48 chris *nod* 02:49 chris as long as we do search right, so it knows to query the items table, then that would be fine 02:51 ebegin gmcharlt, about the dependencies (sorry, I had to step out :) )... do you know which part of Makefile.PL look if they are installed? 02:51 gmcharlt ebegin: it's part of what ExtUtils::MakeMaker handles 02:52 chris_n gmcharlt: it seems one might be able to setup a target just to test for deps 02:52 gmcharlt the list of dependencies is the PREREQ_PM list, of course 02:52 gmcharlt chris_n: I'm not stopping you 02:53 ebegin ok, and WriteMakeFile is a function of MakeMaker? 02:53 chris make deps 02:53 * chris_n adds it to his LIRO buffer 02:53 chris_n last in, random out 02:53 chris course you would have had to run perl Makefile.PL at least once for that to work though 02:54 chris_n chris: right, but that's the idea 02:54 gmcharlt which gives you the list of unmet deps, rendering make deps superfluous 02:54 chris_n then you can verify remaining deps 02:54 chris i guess you could use make deps if you forgot 02:54 chris or it scrolled off your screen 02:54 gmcharlt EU::MM doesn't create a deps target 02:54 * chris_n has at times had problems with various version, along with forgetting 02:55 chris i think taking about.pl 02:55 chris_n of course constructing a small script would be easier probably 02:55 chris abstracting the list of dependencies out 02:55 chris_n about.pl is missing version #'s 02:55 chris so that about.pl and what_perl_modules_am_i_missing.pl 02:55 chris can use it 02:55 gmcharlt Makefile.PL has the best list 02:55 chris *nod* 02:56 chris about.pl should use the same list as Makefile.PL 02:56 chris_n maybe C4::Constants 02:56 chris it should be maintained in one place 02:56 gmcharlt chris_n: I don't like C4::Constants as the name, but certainly C4::Something 02:57 chris_n the labels/pcards code uses several constants which would be nice to centralize 02:57 gmcharlt whatever it's called, can also be used to track which modules are required for optional features 02:57 chris *nod* 02:57 chris_n true 02:58 chris and lets put an export_list_in_html method in it 02:58 ebegin What about create a simple function that tells you which dependencies are missing? This function could be called independently of the Makefile. There is something similar when installing druapl. 02:58 chris so we can run that and put it somewhere 02:58 chris each release 02:59 gmcharlt ebegin: that woudl be part and parcel of what we're discussing 02:59 gmcharlt but the last thing I want to see is Yet Another Separate List of Dependent Perl Modules 03:00 chris yep it has to be used by all things 03:00 gmcharlt while we're talking about this sort of housekeeping 03:00 ebegin I agree that we must have a single list. 03:00 gmcharlt one thing I'd like to do for 3.4 is rearrange the directories 03:00 chris_n housekeeping++ 03:00 gmcharlt at the very list, to stick the staff cgi directories under a top-level staff or intranet 03:01 chris_n yup 03:01 chris yep 03:04 chris_n I'd like to implement Locale::Currency::Format to handle currency issues for 3.4 03:05 chris sounds better than the current hodgepodge 03:07 chris_n it works pretty nice actually 03:08 gmcharlt chris: would you have time to test and sign off on fredericd's new translation wrapper? 03:09 chris ill give it a whirl tonight 03:10 chris_n we could add a syspref for the ISO4217 currency identifier, keep track of the numbers, and convert them per the syspref for display. 03:10 gmcharlt s/currency/currencies/ 03:11 gmcharlt chris: thanks 03:12 chris thats his trans branch eh? 03:12 gmcharlt yep 03:13 * chris sets up a remote and does the pull 03:13 chris didn't explode, so thats a good start 03:14 gmcharlt only issue my eyeball has with it thus far is the "GPL 2.1" 03:14 chris yeah it looks a lot cleaner, i like having all the code in a module 03:20 chris trying a test translation 03:22 chris bunch of warns .. but seems to be doing what it should 03:23 chris perl -I ../../ translate create test-TEST 03:23 chris and i end up with 03:23 chris -rw-r--r-- 1 chrisc chrisc 293532 2010-02-17 16:20 test-TEST-i-opac-t-prog-v-3002000.po 03:24 chris -rw-r--r-- 1 chrisc chrisc 2348870 2010-02-17 16:20 test-TEST-i-staff-t-prog-v-3002000.po 03:24 chris -rw-r--r-- 1 chrisc chrisc 84010 2010-02-17 16:20 test-TEST-pref.po 03:25 chris poedit tells me they are valid 03:25 chris perl -I ../../ translate install test-TEST 03:25 chris chrisc@stuffdev:~/koha/misc/translator$ ls ../../koha-tmpl/opac-tmpl/prog/ 03:25 chris en en-NZ famfamfam images itemtypeimg test-TEST 03:25 chris so far so good 03:27 chris ./koha-tmpl/intranet-tmpl/prog/test-TEST/modules/admin/preferences/creators.pref 03:27 chris seems to work just fine 03:27 braedon|work random question, but does anyone know anything about managing launchpad ppa's? I'm setting up a ppa with all the perl dependencies not in the ubuntu repos, and i have hit a bit of a snag with one 03:28 chris_n it would be nice to add some ajax to avoid full page refreshes in the staff client 03:28 chris not me sorry braedon|work 03:29 braedon|work i really don't have a clue what i am doing - making it up as i go with help from assorted guides and tools 03:29 chris_n it might actually speed up circulation a bit 03:30 chris yup 03:31 Amit hi all 03:31 chris_n heya Amit 03:31 Amit heya chris_n 03:32 chris hi Amit 03:32 Amit hi chris 03:37 walter chris, you about? have a quick question about http://git.catalyst.net.nz/gw?p=koha.git;a=commitdiff;h=ab54038816e4bab44b14baa945fce8a2d4452d7a 03:38 chris yep 03:38 walter setting it up for a demo site and i'm not familiar where those files eventually end up on debian box 03:38 walter i.e. i'm not a koha guy and don't know its usual filesystem layout 03:39 chris youll want to do dev install 03:39 walter hmm 03:39 chris then it will be running out of hte git repo 03:39 walter it's a running install already 03:39 chris and you can cherry-pick that in 03:39 walter yeah, i would normally... but these guys aren't a git shop quite yet 03:39 chris ahh, well it will totally depend on where the person installing it decided to put the files 03:39 chris try /usr/share/koha 03:39 walter ok, cool 03:40 walter looks like a winner for that 03:40 walter think i can see where the opac stuff lives there 03:40 chris cool 03:40 walter but template lives? 03:41 walter i.e. koha-tmpl/opac-tmpl/prog/en/modules/opac-results.tmpl 03:41 chris is there a koha-tmpl dir there? or opac-tmpl? 03:41 chris if you check the koha apache conf 03:42 walter ls /usr/share/koha 03:42 walter bin doc intranet lib man misc opac 03:42 walter 03:42 * walter checks 03:42 chris check the docroot there 03:42 chris that should have it 03:43 walter htdocs, cool 04:14 * chris_n messes with Finance::Quote which could make the exchange rate code in koha real-time 04:14 chris_n it even grabs stock quote 07:12 Ropuch Morning #koha 07:12 Ropuch Hi chris_n 07:13 Ropuch ..& chris_without_n 07:13 Ropuch ;> 07:13 chris :) 07:27 wajasu i've staged and imported my marc records with 925 items. if i don't have a barcode, is there a script that will generate one for all items without one? 07:29 Ropuch Hm 07:31 Ropuch 1. Grab the biggest existing barcode, assign it to variable, grab & update first record without barcode with variable, increase variable, grab another 07:31 Ropuch I think it can be done from sql 07:32 brendan first patch for 3.4 signed off on? anyways that's cool 07:32 chris it'll probably actually go into 3.2 07:33 brendan well almost then 07:33 chris it makes the sysprefs translatable, and makes the templates translation work better 07:33 brendan I'll save that comment for the first patch then 07:33 chris :) 07:33 brendan :) yes just reading through it -- pretty cool 07:33 chris i won't actually sign off anything for 3.4 until we branch 3.2 07:34 brendan do we have a git.koha-community.org started yet? 07:34 chris nope, but wouldnt be hard to do 07:35 brendan would be cool to have all the developers switch there git.configs to that 07:35 chris i can push to git.koha.org .. so we dont actually need it just yet 07:36 chris unless that changes 07:36 brendan I don't know the correct saying here 07:36 brendan something like in for a penny 07:37 brendan but, good call "so we dont actually need it just yet" 08:02 chris hi paul_p 08:02 paul_p hi chris 08:16 kf good morning #koha 08:17 chris hiya kf 08:18 kf hi chris 09:50 kf ok, translation question - chris? still awake? 09:54 gmcharlt greetings #koha 09:56 kf @later tell chris many submit buttons (i.e. make payment, add credit, renew all, return all, add item, add & duplicate...) are still English in my translation, I cant find the text in pootle - is this a template problem or does pootle need an update? 09:56 munin kf: The operation succeeded. 09:56 kf good morning gmcharlt 09:58 gmcharlt kf: translation glitch - the CGI scripts that consume some of those submit buttons currently rely on the exact English wording of the submit value 09:59 kf sure? I thought we had them in German in an earlier version 10:00 kf this is what my librarian told me too - she is unhappy that they are in enlgish now, after we did an update of the translation :( 10:02 kf hm, how can that be fixed? perhaps I can work on it? 10:08 Amit heya nicomo 10:08 Amit hi kf 10:08 nicomo hi Amit 10:09 gmcharlt kf: can you give me an example of a specific button? 10:13 kf patron account: all buttons for fnies (credit, payment) all buttons in edit item 10:15 kf additem.pl: buttons under form 10:15 gmcharlt thanks 10:17 kf and moremember.pl / circulation.pl : buttons under checkouts: return all, renew all, renew or return checked items 10:18 kf I think there are more, but these are prominent places 10:43 kf gmcharlt: write a bug report? I can add more examples there 10:43 gmcharlt kf: please do 10:43 kf ok 10:49 kf gmcharlt: will do later, my colleague is updating our test installation now to latest head (we are only some patches behind but will look for examples when he is done) 11:32 Ropuch Hello kf, gma 11:32 Ropuch gmcharlt ;> 11:33 gmcharlt hi Ropuch 11:33 Ropuch Is there a simple way to have items in label batch ordered by barcode? 11:33 chris_n g'morning 11:33 chris_n Ropuch: not atm 11:33 gmcharlt Ropuch: amazing - all you have to do is ask a question about labels to make chris_n appear 11:33 chris_n hehe 11:34 Ropuch :)) 11:34 chris_n Ropuch: some code could be added to order them that way 11:35 chris_n if you'll open an enhancement bug for it, I'll look into it in the next few days 11:37 Ropuch chris_n: we have enough bug for now I guess - I was hoping for "add ordered by barcode in X line of label-manager.pl" tip 11:37 Ropuch ;> 11:38 * chris_n looks 11:41 chris_n Ropuch: as a hack you could add some code here: 11:41 chris_n http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=labels/label-create-pdf.pl;h=6f6de6252343375e08a64d39b06b7c21c05a3ebe;hb=HEAD#l91 11:41 chris_n just after line 91 11:41 chris_n $items is a hashref 11:43 chris_n arrayref rather 11:43 chris_n to an array of hashes 11:44 Ropuch Ok, I;m tryingm thanks for lightspeed response :) 11:45 chris_n you can sort on the 'item_number' key of the hash 11:45 chris_n iirc 11:49 chris_n sorry Ropuch, here is where you want to be: 11:49 chris_n http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=C4/Labels/Label.pm;h=a6b7aa2b56585df5397cae2760fccfa81920f5d5;hb=HEAD#l475 11:49 chris_n this line is where the barcode data is retrieved 11:49 chris_n but that might be too late to do the sort 11:50 chris_n so it may be better to do it at the point mentioned above with more code 11:51 chris_n the long term solution is to add an item_sort method to C4::Creators::Batch 11:51 Ropuch Huh 11:52 Ropuch I'll look into it after work 11:52 chris_n the the method could be invoked at label generation time 11:52 chris_n based on a checkbox in label-print.pl 11:53 * chris_n wanders off to find breakfast 12:10 kf reboot 12:30 hdl_laptop hi gmcharlt 12:30 gmcharlt hi hdl_laptop 12:30 hdl_laptop just saw your email on koha-devel 12:33 gmcharlt yep 12:33 hdl_laptop about translations, it is just the way it was before. 12:33 hdl_laptop not worse 12:33 gmcharlt not really an excuse not to improve it if you're going to the trouble of changing it in the first palce 12:34 hdl_laptop (and not better) 12:35 hdl_laptop I agree. But since ppl are more willing to be able to use a customized stylesheet rather than a stylesheet name adapted to languages, I thought this would be ok. 12:36 hdl_laptop I can revert that. 12:37 gmcharlt in the short term, I don't think a revert is necessary unless you're out of time - a quick patch to update it to not need the full path, look for it relative to the active language, and have a fallback (to the default English stylsheet or to no XSLT at all) 12:37 gmcharlt would do it 12:37 hdl_laptop Note that the patch I sent for 3.2 uses XSLTResultsDisplay and XSLTDetailsDisplay as boolean and then uses "sub" system preferences for names 12:38 gmcharlt that's a better way of doing it 12:38 gmcharlt but if we do that for 3.2, either 3.0.x shoudl do exactly that 12:38 gmcharlt or leave the sysprefs alone 12:39 gmcharlt as the upgrade path of boolean -> free -> boolean + new sub sysprefs would be unwieldy for somebody going from 3.0.6 to 3.2.0 12:40 hdl_laptop mmm... 12:40 hdl_laptop no. 12:40 hdl_laptop OPACXSLResultsDisplay stay path or url 12:41 hdl_laptop (same as XSLOPACDisplay) 12:41 hdl_laptop But XSLResultsDisplay and XSLDetails desplay is Boolean. 12:42 gmcharlt well, that's no good (the inconsistency) 12:42 gmcharlt keeping the prefs as boolean, then adding four sub prefs seems better 12:44 hdl_laptop gmcharlt: ok 12:48 gmcharlt hdl_laptop: thanks 13:16 jwagner Good morning folks. 13:16 jwagner @wunder 20817 13:16 munin jwagner: The current temperature in Langley Fork Park, McLean, Virginia is -1.6�C (8:13 AM EST on February 17, 2010). Conditions: Overcast. Humidity: 69%. Dew Point: -7.0�C. Windchill: -2.0�C. Pressure: 29.76 in 1007.7 hPa (Rising). 13:20 kf hi jwagner 13:20 kf @wunder Konstanz 13:20 munin kf: The current temperature in Konstanz, Germany is 3.0�C (2:00 PM CET on February 17, 2010). Conditions: Mostly Cloudy. Humidity: 52%. Dew Point: -4.0�C. Pressure: 29.38 in 995 hPa (Falling). 13:22 jwagner Good morning, kf. You're warmer than we are, at least. In theory, things are supposed to warm up by the weekend.... 13:23 kf snow it melting here - im happy about it :) 13:23 Ropuch @wunder Wroclaw 13:23 munin Ropuch: The current temperature in Wroclaw, Poland is -1.0�C (2:00 PM CET on February 17, 2010). Conditions: Mostly Cloudy. Humidity: 86%. Dew Point: -3.0�C. Windchill: -6.0�C. Pressure: 29.56 in 1001 hPa (Steady). 13:24 jwagner I wish our snow would melt. Most of the major highways are still missing one lane, where all the snow got plowed. Since the roads aren't big enough in normal conditions to handle all the traffic, this means rush hour is REALLY a mess. 13:29 kf sounds bad, its not that bad here 14:03 jdavidb Harrrrumph! 14:05 jwagner That's my line. 14:11 * owen looks for owen_ and owen__ to help him with his work load 14:12 owen New dependency in HEAD? Locale::Currency::Format? 14:12 owen___ here I am! 14:13 owen gmcharlt you narrowly escaped the crack of my whip 14:13 gmcharlt :) 14:13 gmcharlt yep, a new dep 14:13 owen Does Locale::Currency::Format have a Debian package? 14:13 gmcharlt not atm 14:13 jwagner Another new one? Is there a complete list somewhere of ALL the new ones? 14:14 gmcharlt jwagner: they're being accumulated in bug 4151 and will be in release notes, etc. 14:14 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4151 blocker, P5, ---, gmcharlt@gmail.com, ASSIGNED, Document new perl modules for those upgrading 14:15 jwagner Thanks, that will help. Is that Magick one in there? Didn't see it.... 14:15 jwagner Never mind, it's there. Been a snake, it would have bit me. 14:17 owen Good morning nengard 14:18 nengard hiya owen 14:32 sekjal I think my code and my database have gotten out of sync. Should Koha version 3.00.05.003 correspond to DB version 3.0100039? 14:43 owen sekjal: I'm not sure if there's a correct way to check that, but I see that DB rev 3.00.00.039 was added to updatedateabase.pl on 2007-12-29 14:48 gmcharlt sekjal: are you trying to compare specific DBrevs between 3.0.x and 3.2.x ? 14:48 sekjal googling "koha 3.01000039" I found one other library's error page that had it corresponding to code version 3.01.00.039 14:49 sekjal gmcharlt: I just upgraded my code from 3.0.3 to 3.0.5 14:50 sekjal now I'm getting all kinds of weird problems that remind me of the time I tried to maintain my own template (instead of using prog) between versions 14:53 hdl_laptop have you updated your translations ? 14:53 hdl_laptop misc/translator 14:54 hdl_laptop ./install-code.pl LANGUAGECODE 14:57 sekjal hadn't done that, but just did, got no response... 14:57 sekjal well, more accurately, the machine accepted my command and didn't give me any feedback 15:02 ebegin How can I know where my perl modules are installed? It seems that I have a conflict (2 versions installed) for Compress::Raw::Zlib :( 15:03 hilongo sekjal: after the upgrade, do your reserves/holds still work? 15:17 sekjal hilongo: not really sure; haven't gotten reports from my people one way or the other 15:19 hilongo sekjal: hmm.. I upgraded from 3.0.1 to 3.0.5 and reserves stopped working, reporting that none of the items were "available" for reserve .. I upgraded againt to 3.0.6 but to no use... 15:20 * hilongo wonders if it is something wrong with the database update... 15:20 gmcharlt hdl_laptop: ^^ any ideas? 15:24 hdl_laptop Should be working. 15:25 wizzyrea_ bbs ,swtiching computers 15:30 chris_n wizzyrea: nick morphing indecision? ;) 15:31 wizzyrea ha, more like butter fingers 15:41 nahuel hilongo, did you defined hold policies ? 15:41 kf bug Bug 4208 15:41 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4208 critical, P1, ---, chris@bigballofwax.co.nz, NEW, Many submit buttons are not translatable in 3.2 15:41 nahuel hilongo, are your document issued ? 15:42 jdavidb Hm....can anyone think of a better way to say this: 15:42 jdavidb SELECT issues.*,items.*,biblio.title FROM issues, items,biblio WHERE issues.itemnumber=items.itemnumber and issues.itemnumber=? and items.biblionumber=biblio.biblionumber 15:43 jdavidb Accounts.pm has an itty-bitty bug at 286, in that it's not getting the title, which is then referenced on line 309. That fix *works*, but is there a tidier way to say that? 15:44 chris_n left join maybe? 15:44 jdavidb possibly. Two left-handed JOINs is not something I've fiddled with much, but it should work. 15:46 gmcharlt chris_n: I'd say a regular join, actually - no 'LEFT' need apply 15:46 gmcharlt left joins are actually overused in C4 - properly speaking, they should be used only if you're not sure if there will be corresponding rows in the table that you're joining 15:47 gmcharlt so in full 15:48 jdavidb SELECT issues.*, items.*, biblio.title 15:48 jdavidb FROM issues 15:48 jdavidb JOIN items ON issues.itemnumber=items.itemnumber 15:48 jdavidb JOIN biblio ON items.biblionumber=biblio.biblionumber 15:48 jdavidb WHERE issues.itemnumber=? 15:48 jdavidb Like that, gmcharlt? 15:49 jdavidb Seems to work right, when I run it by hand! :) 15:50 gmcharlt yes, that works; more compactly, can also do SELECT issues.*,items.*,biblio.title FROM issues, items,biblio JOIN issues USING (biblionumber, itemnumber); 15:50 gmcharlt err, make that 15:50 gmcharlt SELECT issues.*,items.*,biblio.title FROM issues JOIN items USING (itemnumber) JOIN biblio USING (biblionumber); 15:51 jdavidb Sure 'nuf. that works nicely, too. I'll see if there's a bugzilla on this one, and submit a patch; I've checked, and HEAD-as-of-now still has this one. 15:53 * jdavidb snorts 15:54 jdavidb It has been a rough few months. I have already solved this one, and submitted the patch in November: Bug 3775 15:54 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3775 normal, PATCH-Sent, ---, dbavousett@ptfs.com, ASSIGNED, Accounts::chargelostitem uses title, but title not available to it 15:54 * jdavidb looks around for dead kitties. 15:56 jdavidb Would you like me to resubmit that, with this more-elegant way of saying that SQL, gmcharlt? 15:57 gmcharlt sure 15:57 jdavidb Willdo! :) Have it to you shortly. :) 16:00 nengard started documenting the OPAC - so no changing things around on me!! :) hehe 16:02 * chris_n runs off to make misc small improvements on OPAC ;) 16:07 hilongo nahuel: I tested with issued documents and on shelf documents... always the same ... hold policies are defined AFAIK ... I checked the tables with phpmyadmin and there are rules for my borrowertype with holdsallowed=2 and the same for itemtypes and branchcodes 16:08 nahuel hilongo, a bit hard to debug by irc :) 16:08 nahuel hilongo, are you a geek ? :) 16:08 jdavidb i 16:09 hilongo nahuel: haha .. not as geek as I would like :P 16:09 nahuel hehe 16:10 nahuel so you're not able to make some warn in the code ? 16:10 hilongo nahuel: I have sent a mail to the list ... trying to explain my problem... with the error-log output and the contents of the various tables... had no response yet... so I think I'm the only one with this problem 16:11 nahuel amha it's only a settings problem 16:11 hilongo nahuel : I could ... just point me in the right direction :) 16:11 nahuel in smart-rules.pl, how did you set hold policies in the bottom of the page 16:12 nahuel afaik, "all item types" does not work 16:12 nahuel you must make a rule by item type 16:16 biglego Its a little off topic but it is related to my switching to koha. I'm writing a perl script that parses a log file. I'm trying to pull out some values with the following code. It prints the $stamp and the comma and newline character but it does not print the $itemlocation. I know its evaluating it but I'm clueless on how to get it to print the contents of the match. 16:16 biglego while (<IN>) { 16:16 biglego chomp; 16:16 biglego $stamp = substr $_, 0,19; # extract the time stamp field 16:16 biglego $itemlocation = $_ =~ m/^UT(.*?)^/; 16:16 biglego print "$stamp,$itemlocation\n"; 16:16 biglego } 16:16 biglego Ideas thoughts admonishments? 16:18 hilongo nahuel: itemtype = IMP (this are printed books for us) hold policies = from any library 16:19 sekjal anyone know where I can find which indexes are supposed to be on the koha.sessions table? 16:19 * imp thinks: imps shall not be hold ;) 16:19 kf hilongo: have you checked your maxreserves setting? (if its still there in your installation) 16:21 hilongo kf: my maxreserves has a value of 10 16:22 jdavidb My new patch attached to Bug 3775, and send to the list, gmcharlt. Thanks! 16:22 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3775 normal, PATCH-Sent, ---, dbavousett@ptfs.com, ASSIGNED, Accounts::chargelostitem uses title, but title not available to it 16:27 hilongo nahuel: take a look at this ... maybe you can figure out what's the problem http://pastebin.com/m675bb49b 16:28 gmcharlt jdavidb: Franken-kitty lives 16:29 kf lol 16:29 jdavidb I prefer killing bugs, not kitties. 16:30 nahuel hilongo, ... like this I don't know... 16:30 jdavidb gmcharlt++ ;I see it in HEAD already. w00t! 16:34 hilongo nahuel: yep... I'm out of ideas too ... I'm one step from reinstalling from scratch 16:36 wizzyrea_ zoinks, gmcharlt you've been busy! 16:37 * jdavidb debates a Quote Add on wizzyrea saying "zoinks".. 16:38 wizzyrea_ lol 16:38 wizzyrea_ oh jdavidb you are back from the depths of the great snowstorm of 2010 16:39 jdavidb We have piles of snow as big as very large cars around here; some piles may, in fact, conceal cars. 16:39 kf :) 16:39 wizzyrea_ oh we need to update the sample news to point to the new documentation 16:39 kf time to go home here - bye #koha :) 16:39 wizzyrea_ bye cait 16:39 wizzyrea_ :) 16:40 kf pssst! ;) 16:41 wizzyrea_ that stuff is in installer/data right? 16:41 gmcharlt @quote add jdavidb> I prefer killing bugs, not kitties. 16:41 munin gmcharlt: The operation succeeded. Quote #57 added. 16:41 gmcharlt @quote remove 57 16:41 munin gmcharlt: The operation succeeded. 16:41 gmcharlt @quote add <jdavidb> I prefer killing bugs, not kitties. 16:41 munin gmcharlt: The operation succeeded. Quote #58 added. 16:41 jdavidb :) 16:43 chris_n wizzyrea_: correct 16:43 jdavidb @quote random 16:43 munin jdavidb: Quote #32: "<wizzyrea> oh, things are not right in the world .... oh good, that makes me feel better. it's just the govt" (added by jdavidb at 09:56 AM, September 09, 2009) 16:44 wizzyrea_ lol! 16:44 wizzyrea_ I do not remember the context of that, but I'm sure it was funny 16:45 jdavidb :) 16:45 chris_n anyone using self-checkout? 16:45 joetho_away @quote random 16:45 munin joetho_away: Quote #43: "< Ropuch> Uh - beware of tea: it can burn your throat" (added by chris at 04:35 AM, October 30, 2009) 16:45 chris_n lol 16:45 chris_n @quote random 16:45 munin chris_n: Quote #15: "<|Lupin|>ricardo: you are like the Portuguese Hitchcock!!" (added by wizzyrea at 10:58 AM, July 10, 2009) 16:52 jdavidb @quote random 16:52 munin jdavidb: Quote #27: "<jdavidb> ("A helicopter does not fly; it is a collection of quasi-unrelated parts moving in close formation, beating the sky into submission.")" (added by gmcharlt at 05:21 PM, August 22, 2009) 16:56 wajasu i staged and imported about 16000 marc records with 925 items about 10 hours ago. Should I still be seeing manage-marc-import.pl running as a process? Its using 10% of the CPU time in top. I'm in a nozebra test installation. 16:58 gmcharlt wajasu: 16,000 bibs with nonzebra? yeah, it could still be running; to check its proccess, you can go to the mysql prompt and do a count(*) on biblio; 16:58 wajasu i'm on a fast i7 archlinux box. 16:59 wajasu will check. 17:02 jwagner chris_n, I'm catching up on things -- I've done a little bit with selfcheckout. What did you want to know/do? 17:04 chris_n self-checkout seems to imply that one may scan the barcode to either checkout or return an item 17:05 chris_n scanning an item already issued the requires keyboard/mouse intervention 17:05 chris_n is this expected behavior or should an item issued and scanned be checked in automatically? 17:09 wajasu my select count(*) from biblio; shows 24000 and its growing. select count(*) from items; shows 19000 and growing; What is going on? Shouldn't this all be done in less than a minute? 17:11 gmcharlt wajasu: nozebra has some inefficiences when adding records one at a time, like happens in a staged bib import 17:11 gmcharlt how many bibs do you have left to go? 17:13 jwagner chris_n, I'm a little fuzzy on that area. I seem to remember that if you scan an item that you already have checked out, it will prompt you to renew or return. Not sure unless I set up a test. I may squeeze some time for that later if you want. 17:14 chris_n jwagner: no need to test as that is how it works presently; it just seems a bit "hands-on" for returns 17:14 chris_n ie. If I'm scanning an item already checked out to me, I am probably returning it 17:14 jwagner I have never understood why the self-check allows returns anyway.... 17:14 chris_n so why ask 17:15 jwagner I would think it should only do renews. If you're returning, then put it in the bookdrop or in the "return" box or something. 17:15 wizzyrea_ yea, returning seems like something a staff person would do 17:15 wajasu i had staged, imported 2-3 times yesterday, and even shutdown the db because I had staged and then clicked import and had both batches running, so my numbers are off. 17:15 chris_n wizzyrea_ jwager: so if a book is in the return box at the start of the workday the day after it is due, it is considered returned on time? 17:16 wizzyrea_ our libraries use the drop box mode 17:16 jwagner If you check it in using bookdrop mode -- that backs up the fines etc. to the day before. 17:16 collum Yet. Most self-cko's have this option, I don't know why, but it is usually configurable. (checkin on/off) 17:16 wizzyrea_ for that. They assume if it's in the drop box before start of business on the day after due, it's on time 17:16 wizzyrea_ collum: I agree it's weird 17:16 wizzyrea_ brb 17:17 chris_n tnx, that helped 17:18 gmcharlt chris_n: although I can imagine a use case - self-service points at corporate libraries 17:18 wajasu is there a way to log and trace what statements are taking so long? 17:18 wizzyrea_ ...it ought to be a syspref!! 17:19 * wizzyrea_ ducks 17:19 * chris_n runs off screaming.... "Not another syspref!!!!" 17:21 jwagner But I _LIKE_ sysprefs! They give the individual library so much more control over things, without having to locally customize code. 17:22 wajasu i'm going to install a newer koha in a fresh chroot. mine is from last september. 17:22 * chris_n groans... 17:23 chris_n another LLEK question 17:24 owen "limits to what we can change through LLEK" I thought the point was there weren't limits :P 17:24 wizzyrea man, those people are up shit creek without a paddle 17:24 wizzyrea seriously 17:24 wizzyrea LL won't help them with community stuff, and the community won't help them with community stuff 17:24 Ropuch heh 17:24 wizzyrea (no lie, LL tells them it's community, go ask them)( 17:24 wajasu i got items. i got biblios. what are authority records? what are they for? where/how should i get them? what value do they add? 17:25 * collum went to get more coffee. 17:25 collum I can see checkin on self-cko used in a school situation as well. 17:25 wizzyrea just sayin, a little bit of... "well here's how we would fix it if you were on community" might go a long way 17:26 wizzyrea because you don't want to alienate those people, they're in a bad place. 17:26 wizzyrea and the welcoming arms of the community is a good place to be 17:26 owen wizzyrea I think we're pretty good about doing that aren't we? 17:26 Ropuch wajasu: http://www.loc.gov/marc/uma/ 17:26 wizzyrea usually 17:26 wajasu thanks. 17:27 wizzyrea [off] there's been some tittering on the LL list about how nobody will help LL customers 17:28 Ropuch I don't know details of their contracts, but if I were them, I would sue LL ;> 17:28 Ropuch Of course blaming community is easier 17:28 wizzyrea of course it is. 17:28 Ropuch Bad Koha! 17:28 Ropuch ;> 17:28 owen The trouble with the mailing list is that it's hit-or-miss for anyone, not just LL customers. 17:28 wizzyrea true 17:29 wizzyrea i don't mean to get shouty 17:31 * chris_n tries to answer kindly yet truthfully :) 17:32 chris_n of course, I could give a bit of personal testimony, but resisted the urge 17:33 wizzyrea chris_n: the people on LEK don't have the label creator yet, that I know of, and that's why it's all broken and stupid. 17:36 sekjal my database version and code version are out of sync (db ahead of code) 17:37 wizzyrea !! 17:37 sekjal should I try rolling back the database changes between where I am now and where I want to be (v3.00.05), or try to move forward to 3.2 alpha? 17:38 chris_n sekjal: what db version? 17:38 sekjal 3.01.00.039 17:39 chris_n I'd move forward 17:39 sekjal I think there would be fewer jagged edges riding 3.2 alpha than staying where we are 17:39 chris_n that's probably true 17:40 sekjal I'd just need to train up my colleagues on how to do frequent git pulls and upgrades to production 17:40 sekjal since I won't be around to help them after this week ends 17:41 jwagner sekjal, are you going somewhere??? 17:42 chris_n sekjal: that's not hard 17:42 sekjal my wife got a new job in Massachusetts, so we've moved too far away from NYC for me to continue as faculty at NYUHSL 17:43 chris_n and it could stop once 3.2 reached stable if they did not want to run bleeding edge code 17:43 jwagner sekjal, I hope you're staying around Koha, at any rate! 17:43 sekjal we desperately need the enhanced acquisitions, so I'm tempted. 17:43 sekjal jwagner: yes, I'm staying in the community. I hope to be more involved, in fact 17:44 sekjal s/hope/plan/ 17:44 brendan sekjal++ 17:44 sekjal s/plan/will/ 17:44 jdavidb sekjal++ 17:46 sekjal I've got most of the steps already on our wiki on how to do an upgrade. I should just make sure it's polished and detailed, and carried out regularly until 3.2 is stable 17:47 jwagner Glad to hear it! 17:49 chris_n sekjal: at some slight risk to stability, the git pull part could be automated with cron 17:50 chris_n risk = if some bad bug suddenly appeared in HEAD 17:50 brendan chris_n are you doing any such thing right now? 17:50 chris_n contemplating it every day I have to pull for multiple dev branches and my production box 17:50 brendan I guess I always watch my merge issues.. so I don't think I could do such a thing 17:51 brendan but maybe for the demo's - where it's just straight HEAD... that could be useful 17:51 * brendan ponders 17:51 chris_n but if one were simply running on a strictly production clone, it should not be a problem 17:51 chris_n except as noted 17:52 chris_n the only other issue is db updates 17:52 sekjal we have our test install (dev) pulling from git, and then our production install (prod) gets upgraded when we feel ready 17:52 chris_n which require the web installer 17:52 sekjal right 17:52 chris_n but in reality that could be automated too with a separate script to call updatedatabase.pl 17:53 sekjal I should have been more concerned when my upgrade from 3.0.3 to 3.0.5 didn't bring up the web installer. 17:54 chris_n sekjal: was that on your dev install? 17:54 sekjal prod 17:54 chris_n do you pull your prod from your dev? 17:55 sekjal yes, the dev install is from git, then we make to production 17:55 chris_n so the mess up probably happened on the dev install 17:55 chris i wonder if i should follow up chris_n and say, "what everyone is trying to say diplomatically is that because you are running a fork of Koha, not actual Koha, we have no idea what your code looks like, and that any change we make is at the mercy of your vendor who is openly hostile to the Koha community" 17:56 wizzyrea not sure there's a nice way to say it. 17:56 wizzyrea the truth hurts. 17:56 chris_n sometimes the truth is raw 17:56 chris_n <snap> 17:56 wizzyrea JINX 17:57 sekjal chris_n: the mistake is mine; I'm just not sure where I made it. perhaps when I thought I upgraded to 3.0.3, I was actually upgrading to 3.01.00.039 17:57 wizzyrea ok afk 17:57 chris_n sekjal: I made the mistake of rebasing on the wrong branch once and had a similar db issue 17:58 sekjal well, at least I'm running into all these problems while I still have time to throw at fixing them. 17:59 sekjal if I can get them stabilized before I depart, and have documentation up on how to maintain, I think it'll all work out okay 18:02 * chris_n has a nasty db issue atm 18:03 chris_n some how my prod db tables are MyISAM rather tha InnoDB 18:09 chris done 18:28 jwagner owen, online? 18:38 brendan @wunder 93117 18:38 munin brendan: The current temperature in Northwest Goleta, Goleta, California is 18.4�C (10:34 AM PST on February 17, 2010). Conditions: Clear. Humidity: 57%. Dew Point: 10.0�C. Pressure: 29.97 in 1014.8 hPa (Rising). 18:43 jwagner @wunder bethesda, md 18:43 munin jwagner: The current temperature in Langley Fork Park, McLean, Virginia is 1.3�C (1:40 PM EST on February 17, 2010). Conditions: Overcast. Humidity: 62%. Dew Point: -5.0�C. Windchill: 1.0�C. Pressure: 29.68 in 1005.0 hPa (Falling). 19:06 owen jwagner: Back, what's up? 19:08 jwagner I had a jquery question for you, but I solved it myself. (Much gloating ensued -- it was something I didn't even know was possible) 19:08 owen :D 19:09 jwagner Got one other one for you, though. In patron add/edit screen, I did a jquery that turned off the data entry box for Street Number, but so far I haven't been able to turn off the label itself. Any ideas? 19:10 owen $("#streetnumber").parent().remove(); 19:10 owen takes care of them both 19:11 owen Even more specifically: $("#entryform #streetnumber").parent().remove(); 19:11 jwagner So it does. Genius! 19:11 owen That limits the action to the patron entry form (in case that ID is used elsewhere in the staff client) 19:12 jwagner owen++ 19:12 chris_n @wunder 28334 19:12 munin chris_n: The current temperature in Erwin, North Carolina is 6.0�C (2:01 PM EST on February 17, 2010). Conditions: Scattered Clouds. Humidity: 23%. Dew Point: -14.0�C. Windchill: 3.0�C. Pressure: 29.78 in 1008 hPa (Steady). 19:12 jwagner Thanks, owen. I'm trying to back out a lot of local screen changes & do them as jquery statements. The fewer actual code changes, the better! 19:13 owen I'm no fan of setting up MARC frameworks, but it'd be neat if there were some kind of "patron framework" 19:13 jwagner Yep. I'd love to be able to relabel/hide/whatever the various patron fields. 19:14 jdavidb *perks up at owen's idea 19:14 sekjal owen, jwagner: YES! I think that would make things much smoother in the long run 19:14 gmcharlt heh - patron_frameworks++, but let's not do what Mandarin does and literally store the patron records as MARC records :) 19:14 sekjal gmcharlt: egad! 19:14 jwagner Somebody (hdl maybe?) had a patch that let you specify patron fields to omit from the edit screen, but I don't think it ever went anywhere. 19:15 jwagner This particular site had also relabeled some of the patron fields, but I got those done with a jquery OK. 19:16 jdavidb I was piddling with the conceptual model of a data silo, with everything being kept in XML, then allowing the user to manipulate the DTD somehow. 19:18 sekjal jdavidb: I've been thinking about that kinda thing, too 19:19 jdavidb Let's mind-meld some time, sekjal; I see long-term possibilities for such a structure. 19:20 sekjal jdavidb: absolutely. 19:20 liz-nekls I nth the patron field hiding 19:20 liz-nekls prefs 19:20 wizzyrea_laptop we do it with jquery 19:20 jdavidb Easy cases are things like biblios, items, borrowers, but I even extended my model to things like borrowing rules, serials predictions, and user privilege sets. 19:20 * owen 's staff complained after our recent upgrade about the addition of "country" to the patron entry form 19:21 wizzyrea_laptop since everybody in our libraries uses javascript it works ok 19:21 wizzyrea_laptop but patron frameworks would be win 19:23 sekjal jdavidb: right, the Major Entities in the system are pretty easy to model with XML; the transactions between them could be, as well, but would need to be tested for efficiency vs. a relational model 19:23 sekjal somethings fit better in a table, others in a tree 19:23 sekjal but with the right forethought and indexing, I think it could work 19:24 wizzyrea_laptop you know, I wonder if it would be better to hide the Alternate Data fields if they are empty 19:24 wizzyrea_laptop in the patron details 19:24 wizzyrea_laptop or click to expand 19:25 jdavidb sekjal: Sure. I come at it from a mixed-type consortium background, and so a really flexible tree-based system of privilege and borrowing-rules management would be super-nice. For the XML, my thinking is some sort of native-XML db tool, like eXist, maybe. 19:26 jwagner I had to do some MAJOR hacking on the patron add/edit page for one site -- government library which is forbidden to collect personal info such as home address. I ended up chopping out most of the data fields altogether. It would have been much easier to check off a bunch of boxes that say "don't display this field" 19:26 sekjal jdavidb: we're on the same wavelength, I think. I was thinking Berkeley DB XML, but that's just because it was the one I used in grad school 19:27 wizzyrea_laptop jwagner: agreed 19:28 wizzyrea_laptop being able to change the text of the labels would be nice, but not a requirement, as well 19:33 richard hi 19:33 * owen is confident that will be no trouble for jdavidb 19:34 jdavidb heh. owen, my biggest problems revolve around the fact that I can only function for 20 hours a day, on the good days, and must necessarily sleep at least part of the other four, and that I am not psychic. 19:35 jwagner That's what he says. Don't let him fool you.... 19:35 * owen would kill for 20 good hours in his day, must settle for 16 or so 19:36 * jwagner can usually only manage 8-10 19:36 jdavidb Most days, I have to settle for 12-14. Gettin' old. 19:47 jwagner nengard doesn't seem to be online -- anyone else done any testing with latest head and acquisitions? Specifically suggestions? 19:49 chris back, at work now 19:49 owen I've done some testing of suggestions jwagner 19:49 cait hi chris 19:49 jwagner See Bug 4210 19:49 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4210 minor, P5, ---, jwagner@ptfs.com, ASSIGNED, Acquisitions suggestion templates have library name field, but data is not passed 19:50 jwagner The bug itself is an old one -- we fixed it on one of our sites but apparently never submitted. In the process of doing the fix against current head, I found that the system didn't seem to want to email the suggestion responses (accept, reject, whatever). Have you gotten those? 19:51 jwagner On an earlier code version, whenever I updated a pending suggestion, the email went right out. On current head, nada. 19:51 cait jwagner: oh, never got a mail when working with suggestions 19:52 jwagner Maybe I'm missing a syspref or something, but it should have worked. 19:53 * owen accepts some suggestions, waits for an email 19:54 jwagner suggestions don't seem to go through message queue, so I can't even see if they're hanging around in limbo. Just ...silence 19:55 owen Yeah, I'm not getting anything. Other email functions have worked for me, like sending lists or carts 19:55 jwagner And I verified manually (with jdavidb's help) that email is going out from this box. 19:55 jwagner Sounds like a new bug? 19:55 owen No errors in the Koha log 19:56 jwagner And you got emails under earlier code on this box? 19:59 owen I don't remember if it was this installation or a different one 20:01 sekjal I'm playing with my test system (which is current with git.koha.org) and I'm having problems with the new Label Creator tool 20:01 braedon|work gmcharlt: which version of Locale::Currency::Format? 20:01 jwagner owen, I'll go ahead & open a bug report. Thanks for checking. 20:02 wizzyrea_laptop sekjal: what problem? 20:02 sekjal every time I try to work with the labels, either as Layout, Templates, Profiles or Batches, I get an error on label_manage.pl 20:02 sekjal Can't use string ("-1") as an ARRAY ref while "strict refs" in use at /home/koha/koha_from_git/C4/Creators/Lib.pm line 537. 20:02 gmcharlt braedon|work: 1.28 20:03 sekjal looking at Lib.pm, that's part of the html_table subroutine 20:04 ebegin I'm facing a strange problem with my perl modules. It seems that the location where CPAN places packages is not the place where perl reads them... any idea? 20:04 schuster I know this is a bit off topic, but anyone else having trouble with worldcat? 20:05 braedon|work gmcharlt: ok. doesn't looks like it is in the ubuntu repos 20:05 gmcharlt braedon|work: nor Debian AFAICT 20:05 braedon|work gmcharlt: I will add it to my ppa 20:05 jwagner owen, Bug 4211 20:05 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4211 major, P2, ---, henridamien@koha-fr.org, NEW, Acquisitions actions on suggestions don't generate email 20:06 chris_n sekjal: did you load any sample data? 20:06 sekjal chris_n: not specifically. I had whatever profiles were in my system from before. 20:06 sekjal do I need to populate the database with something to start? 20:07 chris_n did upgradedatabase.pl run without incident? 20:07 jwagner By the way... 20:07 sekjal chris_n: yes 20:07 jwagner jdavidb++ # for getting me an updated sandbox with current head! 20:08 schuster jdavidb++ take care of her... come on... about time sheesh... ;) 20:09 chris jdavidb++ 20:09 jwagner schuster, not his fault (although don't tell him I said so!) We had to freeze our development boxes for a while, just getting them thawed out, so to speak. 20:09 * jwagner asks jdavidb if he's happy with all the karma, since he was complaining yesterday :-) 20:10 schuster Great start pushing those new enhancements our way!! 20:10 jdavidb Very! 20:10 chris_n jdavidb++ 20:11 jwagner schuster, yes, getting an updated codeset is the first step on pushing out the new code :-) 20:14 wizzyrea_laptop can't wait for the ptfs stuff 20:15 * wizzyrea_laptop is stupid excited. 20:16 jwagner Don't hold your breath -- it's going to take a while to get everything rebased & ready now. And there are several features that other folks have done parallel devel on, which beat us into head. We have some sorting out to do. 20:16 jwagner But we are working on it.... 20:18 schuster Tell jdavidb to hurry up... ;) 20:18 * gmcharlt offers to officiate at the thumb-wrestling contest to sort out the parallel developments 20:18 schuster The users are waiting... 20:19 jwagner gmcharlt, we may call on you :-) On at least one of the parallel items, we have a little extra functionality than what's in head now, so we might just snip out that extra bit & submit. But I need to do a side-by-side look at everything to see where the problems are. 20:19 chris i think jdavidb and jwagner could be cut some slack, i meant they have at least sent patches since march 2009 .... 20:19 jwagner A few.... 20:20 schuster Just have to prod them some all in jest... jdavidb knows that of me at least... ;) 20:21 jwagner So do I :-) 20:21 jdavidb :) 20:21 owen Speaking of March 2009, when was the last time someone from LibLime answered questions on the mailing list? cfouts++ 20:22 chris [off] when liblime implodes in a month or 2 we must try to keep cfouts in the koha community 20:22 gmcharlt jest? JEST? /me was perfectly serious about the thumb-wrestling contest 20:23 gmcharlt ;) 20:24 jwagner So long as it's not MY thumbs in question! 20:25 jwagner I do still have a dozen or so features that aren't in bugzilla yet -- hope to get those entries created maybe tomorrow. 20:25 jwagner But when we DO start sending out code, it's gonna hit hard. gmcharlt, be warned :-) 20:27 owen gmcharlt is hoping chris will be the target by then! 20:27 gmcharlt unwisely, I'm still going to be exposing myself as the the target for the cataloging and search parts of it :) 20:29 chris :-) 20:29 chris thats great to hear 20:29 chris cos i hate those parts :-) 20:30 nengard so i left the house at 11:30am for 1 dr appt that lasted 20 minutes - but I just got home now - at 3:30pm cause the Dr didn't see me on time and Philadelphia sucks!! 20:31 chris hehe 20:31 chris has good cheese steaks tho 20:31 nengard chris - actually I had a chicken cheese steatk for lunch since I was there 20:32 nengard but still not worth the hassle 20:33 nengard unfortunatly my dr is THE doctor if you have this condition and I'm lucky enough to live only an hour away - but still!! 20:34 jwagner nengard, see Bug 4211 -- have you run into that one? 20:34 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4211 major, P2, ---, henridamien@koha-fr.org, NEW, Acquisitions actions on suggestions don't generate email 20:34 nengard jwagner - i don't have email running on my test machine - so i can't test that one 20:35 jwagner @later tell hdl_laptop see Bug 4211 -- can you test/verify? 20:35 munin jwagner: The operation succeeded. 20:35 hdl_laptop jwagner: will test 20:36 jwagner Oh, I thought you were asleep by now :-) 20:36 hdl_laptop I should ;) 20:36 * chris_n hands hdl_laptop a pillow and blanket 20:44 Lee Chris are you around? 20:44 chris heya lee, sup? 20:44 wizzyrea_laptop hey lee 20:45 Lee hey Liz 20:45 Lee I thought I would share my farewell to LL with you 20:46 Lee Sara was contacting our county saying their check was "LOST" and how could they get another issued 20:46 owen Hi Lee 20:46 chris orly? 20:46 Lee Josh knew I was waiting to talk to PTFS 20:46 wizzyrea_laptop lee! 20:46 Lee hey owen 20:47 gmcharlt hi Lee - and ouch! 20:47 Lee I sent Sara an email saying that we were done screwing with them now that the merger failed 20:47 wizzyrea_laptop you are hard core my friend 20:47 Lee I sent "the letter" yesterday to Josh with our check and said "cash it and we are done" 20:47 joetho_away you go girl 20:47 brendan hi lee 20:48 joetho_away did you get an attorney to look at your contract? 20:48 Lee hey brendan and galen 20:49 Lee I haven't gotten a reply so I would guess that they will cash the check for 7K and we will just move on 20:49 Lee no 20:49 Lee he can get his attorney to look at it 20:49 Lee I think he'll take the money and be done with us 20:50 brendan Lee++ 20:50 chris_n Lee++ 20:50 wizzyrea_laptop sucks that you lose the money 20:50 Lee our contract said they would support our appliance install 20:50 Lee we have server logs 20:51 Lee they haven't bothered with us in 9 months 20:51 Lee no patches no updates no nothing 20:51 chris yeah, thats fairly cut and dry for any lawyer worth his salt 20:51 Lee I think so too 20:52 ebegin chris++ it work! 20:52 Lee So i guess we are free of LL (I hope) and it feels great 20:52 chris ebegin: yay!! 20:52 ebegin s/work/works 20:53 Lee Just thought you all would appreciate the news 20:53 chris thanks for sharing Lee :) 20:53 Lee even tho we are a wee library 20:54 Lee On another topic- as soon as I confirm my flights...I would be happy to volunteer to help w/Kohacon 20:54 chris montana++ 20:54 chris sweet 20:54 chris have you seen this page? 20:54 Lee :) 20:55 gmcharlt Lee++ 20:55 sekjal Lee: very inspiring news 20:55 chris http://kohacon.appspot.com/2010/travel/US.html 20:56 chris any things you find out when booking your travel, would be great to add to that 20:56 jwagner owen, still online? 20:56 Lee okay will do...i have been looking at Orbitz they have some great deals 20:56 joetho_away i practice speaking in Newzealandish with chris 20:56 joetho_away he is very patient 20:56 owen jwagner: Yes 20:57 jwagner opac.css controls the opac -- what's the stylesheet that controls the staff client? Or is it the same one? 20:57 owen staff-global.css 20:57 Lee just wanna say thanks again to the community for all the morale support 20:58 jwagner thanks, owen. I thought I'd copied all the css files, but I bet this lives under intranet-tmpl tree, right? 20:58 owen Yes 20:58 Lee I'll let you all get back to work- Cheers and see you in NZ 20:58 jwagner Thanks, & good night! 21:10 cait can someone help me with git? Im working on translation of installer sql files and treid my first rebase to get the new notice templates. 21:10 ebegin can Graphics::Magick be install using cpan? 21:11 sekjal ebegin: I found not 21:11 sekjal (just did it 5 minutes ago) 21:11 ebegin :) 21:11 sekjal ebegin: I used the debian package; not sure if that applies for your install or not 21:12 ebegin sekjal, you installed it manually? 21:12 sekjal apt-get install libgraphics-magick-perl 21:14 ebegin I always wonder which way is the best. Using apt-get or downloading the source and ./configure + make + make install... 21:14 chris apt-get 21:14 chris because then you get the benefit of the debian security team 21:15 sekjal I like apt-get because it's easier. I'm lazy 21:15 ebegin hehe :) 21:15 ebegin good point chris 21:15 chris unless there is a compelling reason to do otherwise, using the debian package is easier and safer 21:15 chris manual installs end up with unpatched modules that you forget about 21:23 ebegin any suggestion of good mirror to use with debian lenny? 21:24 ebegin (for apt-get) 21:24 chris dunno for canada, the debian site should ahve a list of them 21:24 chris or you could use apt-spy 21:25 chris http://packages.debian.org/lenny/apt-spy 21:26 ebegin I wasn't aware of apt-spy... thanks for that 22:02 sekjal I'm looking to compare my test install's database structure against the latest kohastructure.sql. What mysqldump options should I use to get as similar an sql output as possible? 22:03 cait good night #koha 22:29 chris sekjal: good question 22:29 chris i dont have a good answer im afraid 22:34 sekjal did a dump with --no-data and --add-drop-tables, and it got pretty close. The order of the tables is different, though, since kohastructure.sql isn't completely alphabetical 22:35 chris yeah, we should make it be 22:35 chris maybe that can be a 3.4 thing 22:37 sekjal would reordering the table definitions be trivial, or have implications? 22:37 sekjal I would think it wouldn't matter, but I'm used to being wrong 22:37 chris well, it makes diffs harder to read 22:37 chris (as does any whitespace changes) 22:38 chris if i wanted to see what changed between some version and some other one, moving stuff around makes that much harder to see 22:39 sekjal right, so we'd be making it easier to compare to alphabetized mysqldumps, but that much harder to compare to previous versions of the file 22:39 sekjal perhaps a quick script to alphabetize on demand, creating a kohastructureA-Z.sql 22:42 gmcharlt sekjal: there's been some effort to keep the column names in the same order - note the add column ... after in various updatedatabase.pl DBrevs 22:45 sekjal gmcharlt: and it seems to be working pretty well. Once I got the tables reordered from my dump to match the order in kohastructure.sql, a text diff was pretty easy to read 22:46 sekjal as far as I can tell, there are no major differences in my DB structure from what it's supposed to be 22:47 gmcharlt sekjal: if you can write up your DB dump compare script into something to plop into xt/author, I'll be eternally grateful 22:48 sekjal gmcharlt: I'll see what I can do. this week is a little hectic, with my departure from NYUHSL and Code4Lib prep, but I'll make sure it's on my list for after that 22:48 wizzyrea_laptop is there circ data in the default data? 22:48 wizzyrea_laptop and if I wanted to dump all circ data, which table would I empty 22:48 wizzyrea_laptop and how :P 22:49 gmcharlt wizzyrea_laptop: no 22:49 wizzyrea_laptop because I'm not feeling plucky enough to figure it out at the moment 22:49 gmcharlt issues, old_issues, reserves, old_reserves 22:49 wizzyrea_laptop (don't worry, this is test data, nothing important) 22:49 gmcharlt and accountlines 22:49 gmcharlt will get you most of it 22:50 gmcharlt and mysqldump would be the means 22:50 gmcharlt or guided reports 22:51 wizzyrea_laptop I want to clear it 22:55 sekjal alright, time to head home for the night. get to see my wife for a little while, if only via webcam 22:56 chris ws 11 22:56 chris gah 23:13 chris_n @later tell sekjal: I did a compare to day and can probably give you a good idea of what needs to be changed 23:13 munin chris_n: The operation succeeded. 23:13 moodaepo @wunder 56001 23:13 munin moodaepo: The current temperature in Mankato, Minnesota is -6.0�C (4:55 PM CST on February 17, 2010). Conditions: Clear. Humidity: 63%. Dew Point: -12.0�C. Windchill: -11.0�C. Pressure: 30.09 in 1019 hPa (Steady). 23:13 collum_ Oh 23:14 collum_ opac_search.pl doesn't have a license statement. 23:14 gmcharlt @wunder 30071 23:14 munin gmcharlt: The current temperature in Historic District, Norcross, Georgia is 4.1�C (6:11 PM EST on February 17, 2010). Conditions: Clear. Humidity: 46%. Dew Point: -6.0�C. Windchill: 2.0�C. Pressure: 29.97 in 1014.8 hPa (Rising). 23:14 collum_ just a note that says 'mostly copied from search.pl' 23:14 collum_ Is that kosher? 23:14 chris nope 23:14 chris it needs a license statement 23:14 chris if you could add that, that would be great 23:14 collum_ will do 23:15 chris make it copyright something sensible 23:15 gmcharlt yep - in that case, safe to assume the standard 23:15 chris like yourself :) 23:15 collum_ OK 23:16 gmcharlt just please don't blindly copy "Copyright 2000-2002 Katipo Communications" :) 23:17 collum_ I'll try to refrain. 23:17 gmcharlt and since opac-search.pl is truly a case of joint copyright, better make that 'Garry Collum and the Koha Dev Team', as a few other fies do 23:24 braedon|work I have created a PPA with perl modules not available from the standard Ubuntu repositories 23:25 gmcharlt cool 23:25 gmcharlt bbiab 23:25 braedon|work i don't really know what i am doing in that regard, but i just tested it, and they seem to be working, so if someone else wants to test it, it would be great 23:25 braedon|work the ppa is braedon-vickers/kohaperl 23:26 braedon|work if people want it, perhaps we could create a koha project/team on launchpad, and copy them to a more official PPA there? 23:35 braedon|work In web installer: 23:35 braedon|work sample_notices.sql 23:35 braedon|work ERROR 1054 (42S22) at line 1: Unknown column 'biblio.title' in 'field list' 23:36 braedon|work can't find a bug - who is handling database changes/standard data import? 23:41 brendan @wunder 93117 23:41 munin brendan: The current temperature in Northwest Goleta, Goleta, California is 19.6�C (3:34 PM PST on February 17, 2010). Conditions: Clear. Humidity: 46%. Dew Point: 8.0�C. Pressure: 29.90 in 1012.4 hPa (Falling).