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).