Time Nick Message
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).
23:41 brendan @wunder 93117
23:36 braedon|work can't find a bug - who is handling database changes/standard data import?
23:35 braedon|work ERROR 1054 (42S22) at line 1: Unknown column 'biblio.title' in 'field list'
23:35 braedon|work sample_notices.sql
23:35 braedon|work In web installer:
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:25 braedon|work the ppa is braedon-vickers/kohaperl
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 gmcharlt bbiab
23:25 gmcharlt cool
23:24 braedon|work I have created a PPA with perl modules not available from the standard Ubuntu repositories
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:17 collum_ I'll try to refrain.
23:16 gmcharlt just please don't blindly copy "Copyright 2000-2002 Katipo Communications" :)
23:15 collum_ OK
23:15 chris like yourself :)
23:15 gmcharlt yep - in that case, safe to assume the standard
23:15 chris make it copyright something sensible
23:14 collum_ will do
23:14 chris if you could add that, that would be great
23:14 chris it needs a license statement
23:14 chris nope
23:14 collum_ Is that kosher?
23:14 collum_ just a note that says 'mostly copied from search.pl'
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 gmcharlt @wunder 30071
23:14 collum_ opac_search.pl doesn't have a license statement.
23:13 collum_ Oh
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 moodaepo @wunder 56001
23:13 munin chris_n: The operation succeeded.
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
22:56 chris gah
22:56 chris ws 11
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:51 wizzyrea_laptop I want to clear it
22:50 gmcharlt or guided reports
22:50 gmcharlt and mysqldump would be the means
22:49 gmcharlt will get you most of it
22:49 gmcharlt and accountlines
22:49 wizzyrea_laptop (don't worry, this is test data, nothing important)
22:49 gmcharlt issues, old_issues, reserves, old_reserves
22:49 wizzyrea_laptop because I'm not feeling plucky enough to figure it out at the moment
22:49 gmcharlt wizzyrea_laptop: no
22:48 wizzyrea_laptop and how :P
22:48 wizzyrea_laptop and if I wanted to dump all circ data, which table would I empty
22:48 wizzyrea_laptop is there circ data in the default data?
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: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: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: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: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:39 sekjal perhaps a quick script to alphabetize on demand, creating a kohastructureA-Z.sql
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: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:37 chris (as does any whitespace changes)
22:37 chris well, it makes diffs harder to read
22:37 sekjal I would think it wouldn't matter, but I'm used to being wrong
22:37 sekjal would reordering the table definitions be trivial, or have implications?
22:35 chris maybe that can be a 3.4 thing
22:35 chris yeah, we should make it be
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:29 chris i dont have a good answer im afraid
22:29 chris sekjal: good question
22:03 cait good night #koha
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?
21:26 ebegin I wasn't aware of apt-spy... thanks for that
21:25 chris http://packages.debian.org/lenny/apt-spy
21:24 chris or you could use apt-spy
21:24 chris dunno for canada, the debian site should ahve a list of them
21:24 ebegin (for apt-get)
21:23 ebegin any suggestion of good mirror to use with debian lenny?
21:15 chris manual installs end up with unpatched modules that you forget about
21:15 chris unless there is a compelling reason to do otherwise, using the debian package is easier and safer
21:15 ebegin good point chris
21:15 ebegin hehe :)
21:15 sekjal I like apt-get because it's easier. I'm lazy
21:14 chris because then you get the benefit of the debian security team
21:14 chris apt-get
21:14 ebegin I always wonder which way is the best. Using apt-get or downloading the source and ./configure + make + make install...
21:12 sekjal apt-get install libgraphics-magick-perl
21:12 ebegin sekjal, you installed it manually?
21:11 sekjal ebegin: I used the debian package; not sure if that applies for your install or not
21:11 ebegin :)
21:11 sekjal (just did it 5 minutes ago)
21:11 sekjal ebegin: I found not
21:10 ebegin can Graphics::Magick be install using cpan?
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.
20:58 jwagner Thanks, & good night!
20:58 Lee I'll let you all get back to work- Cheers and see you in NZ
20:58 owen Yes
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:57 Lee just wanna say thanks again to the community for all the morale support
20:57 owen staff-global.css
20:57 jwagner opac.css controls the opac -- what's the stylesheet that controls the staff client? Or is it the same one?
20:56 owen jwagner: Yes
20:56 joetho_away he is very patient
20:56 joetho_away i practice speaking in Newzealandish with chris
20:56 Lee okay will do...i have been looking at Orbitz they have some great deals
20:56 jwagner owen, still online?
20:56 chris any things you find out when booking your travel, would be great to add to that
20:55 chris http://kohacon.appspot.com/2010/travel/US.html
20:55 sekjal Lee: very inspiring news
20:55 gmcharlt Lee++
20:54 Lee :)
20:54 chris have you seen this page?
20:54 chris sweet
20:54 chris montana++
20:54 Lee On another topic- as soon as I confirm my flights...I would be happy to volunteer to help w/Kohacon
20:53 Lee even tho we are a wee library
20:53 chris thanks for sharing Lee :)
20:53 Lee Just thought you all would appreciate the news
20:52 ebegin s/work/works
20:52 chris ebegin: yay!!
20:52 Lee So i guess we are free of LL (I hope) and it feels great
20:52 ebegin chris++ it work!
20:51 Lee I think so too
20:51 chris yeah, thats fairly cut and dry for any lawyer worth his salt
20:51 Lee no patches no updates no nothing
20:51 Lee they haven't bothered with us in 9 months
20:50 Lee we have server logs
20:50 Lee our contract said they would support our appliance install
20:50 wizzyrea_laptop sucks that you lose the money
20:50 chris_n Lee++
20:50 brendan Lee++
20:49 Lee I think he'll take the money and be done with us
20:49 Lee he can get his attorney to look at it
20:49 Lee no
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:48 Lee hey brendan and galen
20:48 joetho_away did you get an attorney to look at your contract?
20:47 brendan hi lee
20:47 joetho_away you go girl
20:47 Lee I sent "the letter" yesterday to Josh with our check and said "cash it and we are done"
20:47 wizzyrea_laptop you are hard core my friend
20:47 Lee I sent Sara an email saying that we were done screwing with them now that the merger failed
20:47 gmcharlt hi Lee - and ouch!
20:46 Lee hey owen
20:46 wizzyrea_laptop lee!
20:46 Lee Josh knew I was waiting to talk to PTFS
20:46 chris orly?
20:46 owen Hi Lee
20:46 Lee Sara was contacting our county saying their check was "LOST" and how could they get another issued
20:45 Lee I thought I would share my farewell to LL with you
20:45 Lee hey Liz
20:44 wizzyrea_laptop hey lee
20:44 chris heya lee, sup?
20:44 Lee Chris are you around?
20:36 * chris_n hands hdl_laptop a pillow and blanket
20:36 hdl_laptop I should ;)
20:36 jwagner Oh, I thought you were asleep by now :-)
20:35 hdl_laptop jwagner: will test
20:35 munin jwagner: The operation succeeded.
20:35 jwagner @later tell hdl_laptop see Bug 4211 -- can you test/verify?
20:34 nengard jwagner - i don't have email running on my test machine - so i can't test 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 jwagner nengard, see Bug 4211 -- have you run into that one?
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:32 nengard but still not worth the hassle
20:31 nengard chris - actually I had a chicken cheese steatk for lunch since I was there
20:31 chris has good cheese steaks tho
20:31 chris hehe
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:29 chris cos i hate those parts :-)
20:29 chris thats great to hear
20:29 chris :-)
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:27 owen gmcharlt is hoping chris will be the target by then!
20:25 jwagner But when we DO start sending out code, it's gonna hit hard. gmcharlt, be warned :-)
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:24 jwagner So long as it's not MY thumbs in question!
20:23 gmcharlt ;)
20:22 gmcharlt jest? JEST? /me was perfectly serious about the thumb-wrestling contest
20:22 chris [off] when liblime implodes in a month or 2 we must try to keep cfouts in the koha community
20:21 owen Speaking of March 2009, when was the last time someone from LibLime answered questions on the mailing list? cfouts++
20:21 jdavidb :)
20:21 jwagner So do I :-)
20:20 schuster Just have to prod them some all in jest... jdavidb knows that of me at least... ;)
20:19 jwagner A few....
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 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:18 schuster The users are waiting...
20:18 * gmcharlt offers to officiate at the thumb-wrestling contest to sort out the parallel developments
20:18 schuster Tell jdavidb to hurry up... ;)
20:16 jwagner But we are working on it....
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:15 * wizzyrea_laptop is stupid excited.
20:14 wizzyrea_laptop can't wait for the ptfs stuff
20:11 jwagner schuster, yes, getting an updated codeset is the first step on pushing out the new code :-)
20:10 chris_n jdavidb++
20:10 jdavidb Very!
20:10 schuster Great start pushing those new enhancements our way!!
20:09 * jwagner asks jdavidb if he's happy with all the karma, since he was complaining yesterday :-)
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 chris jdavidb++
20:08 schuster jdavidb++ take care of her... come on... about time sheesh... ;)
20:07 jwagner jdavidb++ # for getting me an updated sandbox with current head!
20:07 sekjal chris_n: yes
20:07 jwagner By the way...
20:07 chris_n did upgradedatabase.pl run without incident?
20:06 sekjal do I need to populate the database with something to start?
20:06 sekjal chris_n: not specifically. I had whatever profiles were in my system from before.
20:06 chris_n sekjal: did you load any sample data?
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:05 jwagner owen, Bug 4211
20:05 braedon|work gmcharlt: I will add it to my ppa
20:05 gmcharlt braedon|work: nor Debian AFAICT
20:05 braedon|work gmcharlt: ok. doesn't looks like it is in the ubuntu repos
20:04 schuster I know this is a bit off topic, but anyone else having trouble with worldcat?
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:03 sekjal looking at Lib.pm, that's part of the html_table subroutine
20:02 gmcharlt braedon|work: 1.28
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 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 wizzyrea_laptop sekjal: what problem?
20:01 jwagner owen, I'll go ahead & open a bug report. Thanks for checking.
20:01 braedon|work gmcharlt: which version of Locale::Currency::Format?
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
19:59 owen I don't remember if it was this installation or a different one
19:56 jwagner And you got emails under earlier code on this box?
19:55 owen No errors in the Koha log
19:55 jwagner Sounds like a new bug?
19:55 jwagner And I verified manually (with jdavidb's help) that email is going out from this box.
19:55 owen Yeah, I'm not getting anything. Other email functions have worked for me, like sending lists or carts
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:53 * owen accepts some suggestions, waits for an email
19:52 jwagner Maybe I'm missing a syspref or something, but it should have worked.
19:51 cait jwagner: oh, never got a mail when working with suggestions
19:51 jwagner On an earlier code version, whenever I updated a pending suggestion, the email went right out. On current head, nada.
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: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:49 jwagner See Bug 4210
19:49 cait hi chris
19:49 owen I've done some testing of suggestions jwagner
19:49 chris back, at work now
19:47 jwagner nengard doesn't seem to be online -- anyone else done any testing with latest head and acquisitions? Specifically suggestions?
19:36 jdavidb Most days, I have to settle for 12-14. Gettin' old.
19:36 * jwagner can usually only manage 8-10
19:35 * owen would kill for 20 good hours in his day, must settle for 16 or so
19:35 jwagner That's what he says. Don't let him fool you....
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:33 * owen is confident that will be no trouble for jdavidb
19:33 richard hi
19:28 wizzyrea_laptop being able to change the text of the labels would be nice, but not a requirement, as well
19:27 wizzyrea_laptop jwagner: agreed
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: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: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:24 wizzyrea_laptop or click to expand
19:24 wizzyrea_laptop in the patron details
19:24 wizzyrea_laptop you know, I wonder if it would be better to hide the Alternate Data fields if they are empty
19:23 sekjal but with the right forethought and indexing, I think it could work
19:23 sekjal somethings fit better in a table, others in a tree
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:21 wizzyrea_laptop but patron frameworks would be win
19:21 wizzyrea_laptop since everybody in our libraries uses javascript it works ok
19:20 * owen 's staff complained after our recent upgrade about the addition of "country" to the patron entry form
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 wizzyrea_laptop we do it with jquery
19:20 liz-nekls prefs
19:20 liz-nekls I nth the patron field hiding
19:20 sekjal jdavidb: absolutely.
19:19 jdavidb Let's mind-meld some time, sekjal; I see long-term possibilities for such a structure.
19:18 sekjal jdavidb: I've been thinking about that kinda thing, too
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:15 jwagner This particular site had also relabeled some of the patron fields, but I got those done with a jquery OK.
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:14 sekjal gmcharlt: egad!
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 owen, jwagner: YES! I think that would make things much smoother in the long run
19:14 jdavidb *perks up at owen's idea
19:13 jwagner Yep. I'd love to be able to relabel/hide/whatever the various patron fields.
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: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: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 chris_n @wunder 28334
19:12 jwagner owen++
19:11 owen That limits the action to the patron entry form (in case that ID is used elsewhere in the staff client)
19:11 jwagner So it does. Genius!
19:11 owen Even more specifically: $("#entryform #streetnumber").parent().remove();
19:10 owen takes care of them both
19:10 owen $("#streetnumber").parent().remove();
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:08 owen :D
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:06 owen jwagner: Back, what's up?
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).
18:43 jwagner @wunder bethesda, md
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:38 brendan @wunder 93117
18:28 jwagner owen, online?
18:09 chris done
18:03 chris_n some how my prod db tables are MyISAM rather tha InnoDB
18:02 * chris_n has a nasty db issue atm
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
17:58 sekjal well, at least I'm running into all these problems while I still have time to throw at fixing them.
17:57 chris_n sekjal: I made the mistake of rebasing on the wrong branch once and had a similar db issue
17:57 wizzyrea ok afk
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:56 wizzyrea JINX
17:56 chris_n <snap>
17:56 chris_n sometimes the truth is raw
17:56 wizzyrea the truth hurts.
17:56 wizzyrea not sure there's a nice way to say it.
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:55 chris_n so the mess up probably happened on the dev install
17:55 sekjal yes, the dev install is from git, then we make to production
17:54 chris_n do you pull your prod from your dev?
17:54 sekjal prod
17:54 chris_n sekjal: was that on your dev install?
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:52 chris_n but in reality that could be automated too with a separate script to call updatedatabase.pl
17:52 sekjal right
17:52 chris_n which require the web installer
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 the only other issue is db updates
17:51 chris_n except as noted
17:51 chris_n but if one were simply running on a strictly production clone, it should not be a problem
17:51 * brendan ponders
17:51 brendan but maybe for the demo's - where it's just straight HEAD... that could be useful
17:50 brendan I guess I always watch my merge issues.. so I don't think I could do such a thing
17:50 chris_n contemplating it every day I have to pull for multiple dev branches and my production box
17:50 brendan chris_n are you doing any such thing right now?
17:50 chris_n risk = if some bad bug suddenly appeared in HEAD
17:49 chris_n sekjal: at some slight risk to stability, the git pull part could be automated with cron
17:47 jwagner Glad to hear it!
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:44 jdavidb sekjal++
17:44 sekjal s/plan/will/
17:44 brendan sekjal++
17:44 sekjal s/hope/plan/
17:43 sekjal jwagner: yes, I'm staying in the community. I hope to be more involved, in fact
17:43 sekjal we desperately need the enhanced acquisitions, so I'm tempted.
17:43 jwagner sekjal, I hope you're staying around Koha, at any rate!
17:43 chris_n and it could stop once 3.2 reached stable if they did not want to run bleeding edge code
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:42 chris_n sekjal: that's not hard
17:41 jwagner sekjal, are you going somewhere???
17:40 sekjal since I won't be around to help them after this week ends
17:40 sekjal I'd just need to train up my colleagues on how to do frequent git pulls and upgrades to production
17:39 chris_n that's probably true
17:39 sekjal I think there would be fewer jagged edges riding 3.2 alpha than staying where we are
17:39 chris_n I'd move forward
17:38 sekjal 3.01.00.039
17:38 chris_n sekjal: what db version?
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:37 wizzyrea !!
17:36 sekjal my database version and code version are out of sync (db ahead of code)
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:32 chris_n of course, I could give a bit of personal testimony, but resisted the urge
17:31 * chris_n tries to answer kindly yet truthfully :)
17:29 wizzyrea i don't mean to get shouty
17:28 wizzyrea true
17:28 owen The trouble with the mailing list is that it's hit-or-miss for anyone, not just LL customers.
17:28 Ropuch ;>
17:28 Ropuch Bad Koha!
17:28 wizzyrea of course it is.
17:28 Ropuch Of course blaming community is easier
17:28 Ropuch I don't know details of their contracts, but if I were them, I would sue LL ;>
17:27 wizzyrea [off] there's been some tittering on the LL list about how nobody will help LL customers
17:26 wajasu thanks.
17:26 wizzyrea usually
17:26 Ropuch wajasu: http://www.loc.gov/marc/uma/
17:26 owen wizzyrea I think we're pretty good about doing that aren't we?
17:26 wizzyrea and the welcoming arms of the community is a good place to be
17:26 wizzyrea because you don't want to alienate those people, they're in a bad place.
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:25 collum I can see checkin on self-cko used in a school situation as well.
17:25 * collum went to get more coffee.
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:24 wizzyrea (no lie, LL tells them it's community, go ask them)(
17:24 Ropuch heh
17:24 wizzyrea LL won't help them with community stuff, and the community won't help them with community stuff
17:24 wizzyrea seriously
17:24 wizzyrea man, those people are up shit creek without a paddle
17:24 owen "limits to what we can change through LLEK" I thought the point was there weren't limits :P
17:23 chris_n another LLEK question
17:22 * chris_n groans...
17:22 wajasu i'm going to install a newer koha in a fresh chroot. mine is from last september.
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:19 * chris_n runs off screaming.... "Not another syspref!!!!"
17:19 * wizzyrea_ ducks
17:18 wizzyrea_ ...it ought to be a syspref!!
17:18 wajasu is there a way to log and trace what statements are taking so long?
17:18 gmcharlt chris_n: although I can imagine a use case - self-service points at corporate libraries
17:17 chris_n tnx, that helped
17:16 wizzyrea_ brb
17:16 wizzyrea_ collum: I agree it's weird
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 collum Yet. Most self-cko's have this option, I don't know why, but it is usually configurable. (checkin on/off)
17:16 jwagner If you check it in using bookdrop mode -- that backs up the fines etc. to the day before.
17:16 wizzyrea_ our libraries use the drop box mode
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: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 wizzyrea_ yea, returning seems like something a staff person would do
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:14 chris_n so why ask
17:14 jwagner I have never understood why the self-check allows returns anyway....
17:14 chris_n ie. If I'm scanning an item already checked out to me, I am probably returning it
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: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:11 gmcharlt how many bibs do you have left to go?
17:11 gmcharlt wajasu: nozebra has some inefficiences when adding records one at a time, like happens in a staged bib import
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:05 chris_n is this expected behavior or should an item issued and scanned be checked in automatically?
17:05 chris_n scanning an item already issued the requires keyboard/mouse intervention
17:04 chris_n self-checkout seems to imply that one may scan the barcode to either checkout or return an item
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?
16:59 wajasu will check.
16:58 wajasu i'm on a fast i7 archlinux box.
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: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: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:52 jdavidb @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:45 chris_n @quote random
16:45 chris_n lol
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 joetho_away @quote random
16:45 chris_n anyone using self-checkout?
16:45 jdavidb :)
16:44 wizzyrea_ I do not remember the context of that, but I'm sure it was funny
16:44 wizzyrea_ lol!
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:43 jdavidb @quote random
16:43 chris_n wizzyrea_: correct
16:41 jdavidb :)
16:41 munin gmcharlt: The operation succeeded. Quote #58 added.
16:41 gmcharlt @quote add <jdavidb> I prefer killing bugs, not kitties.
16:41 munin gmcharlt: The operation succeeded.
16:41 gmcharlt @quote remove 57
16:41 munin gmcharlt: The operation succeeded. Quote #57 added.
16:41 gmcharlt @quote add jdavidb> I prefer killing bugs, not kitties.
16:41 wizzyrea_ that stuff is in installer/data right?
16:40 kf pssst! ;)
16:39 wizzyrea_ :)
16:39 wizzyrea_ bye cait
16:39 kf time to go home here - bye #koha :)
16:39 wizzyrea_ oh we need to update the sample news to point to the new documentation
16:39 kf :)
16:39 jdavidb We have piles of snow as big as very large cars around here; some piles may, in fact, conceal cars.
16:38 wizzyrea_ oh jdavidb you are back from the depths of the great snowstorm of 2010
16:38 wizzyrea_ lol
16:37 * jdavidb debates a Quote Add on wizzyrea saying "zoinks"..
16:36 wizzyrea_ zoinks, gmcharlt you've been busy!
16:34 hilongo nahuel: yep... I'm out of ideas too ... I'm one step from reinstalling from scratch
16:30 jdavidb gmcharlt++ ;I see it in HEAD already. w00t!
16:30 nahuel hilongo, ... like this I don't know...
16:29 jdavidb I prefer killing bugs, not kitties.
16:29 kf lol
16:28 gmcharlt jdavidb: Franken-kitty lives
16:27 hilongo nahuel: take a look at this ... maybe you can figure out what's the problem http://pastebin.com/m675bb49b
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:22 jdavidb My new patch attached to Bug 3775, and send to the list, gmcharlt. Thanks!
16:21 hilongo kf: my maxreserves has a value of 10
16:19 kf hilongo: have you checked your maxreserves setting? (if its still there in your installation)
16:19 * imp thinks: imps shall not be hold ;)
16:19 sekjal anyone know where I can find which indexes are supposed to be on the koha.sessions table?
16:18 hilongo nahuel: itemtype = IMP (this are printed books for us) hold policies = from any library
16:16 biglego Ideas thoughts admonishments?
16:16 biglego }
16:16 biglego print "$stamp,$itemlocation\n";
16:16 biglego $itemlocation = $_ =~ m/^UT(.*?)^/;
16:16 biglego $stamp = substr $_, 0,19; # extract the time stamp field
16:16 biglego chomp;
16:16 biglego while (<IN>) {
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:12 nahuel you must make a rule by item type
16:12 nahuel afaik, "all item types" does not work
16:11 nahuel in smart-rules.pl, how did you set hold policies in the bottom of the page
16:11 hilongo nahuel : I could ... just point me in the right direction :)
16:11 nahuel amha it's only a settings problem
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:10 nahuel so you're not able to make some warn in the code ?
16:09 nahuel hehe
16:09 hilongo nahuel: haha .. not as geek as I would like :P
16:08 jdavidb i
16:08 nahuel hilongo, are you a geek ? :)
16:08 nahuel hilongo, a bit hard to debug by irc :)
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:02 * chris_n runs off to make misc small improvements on OPAC ;)
16:00 nengard started documenting the OPAC - so no changing things around on me!! :) hehe
15:57 jdavidb Willdo! :) Have it to you shortly. :)
15:57 gmcharlt sure
15:56 jdavidb Would you like me to resubmit that, with this more-elegant way of saying that SQL, gmcharlt?
15:54 * jdavidb looks around for dead kitties.
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 It has been a rough few months. I have already solved this one, and submitted the patch in November: Bug 3775
15:53 * jdavidb snorts
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:50 gmcharlt SELECT issues.*,items.*,biblio.title FROM issues JOIN items USING (itemnumber) JOIN biblio USING (biblionumber);
15:50 gmcharlt err, make that
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:49 jdavidb Seems to work right, when I run it by hand! :)
15:48 jdavidb Like that, gmcharlt?
15:48 jdavidb WHERE issues.itemnumber=?
15:48 jdavidb JOIN biblio ON items.biblionumber=biblio.biblionumber
15:48 jdavidb JOIN items ON issues.itemnumber=items.itemnumber
15:48 jdavidb FROM issues
15:48 jdavidb SELECT issues.*, items.*, biblio.title
15:47 gmcharlt so in full
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:46 gmcharlt chris_n: I'd say a regular join, actually - no 'LEFT' need apply
15:44 jdavidb possibly. Two left-handed JOINs is not something I've fiddled with much, but it should work.
15:44 chris_n left join maybe?
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: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:42 jdavidb Hm....can anyone think of a better way to say this:
15:41 nahuel hilongo, are your document issued ?
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 kf bug Bug 4208
15:41 nahuel hilongo, did you defined hold policies ?
15:31 wizzyrea ha, more like butter fingers
15:30 chris_n wizzyrea: nick morphing indecision? ;)
15:25 wizzyrea_ bbs ,swtiching computers
15:24 hdl_laptop Should be working.
15:20 gmcharlt hdl_laptop: ^^ any ideas?
15:20 * hilongo wonders if it is something wrong with the database update...
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:17 sekjal hilongo: not really sure; haven't gotten reports from my people one way or the other
15:03 hilongo sekjal: after the upgrade, do your reserves/holds still work?
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 :(
14:57 sekjal well, more accurately, the machine accepted my command and didn't give me any feedback
14:57 sekjal hadn't done that, but just did, got no response...
14:54 hdl_laptop ./install-code.pl LANGUAGECODE
14:53 hdl_laptop misc/translator
14:53 hdl_laptop have you updated your translations ?
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:49 sekjal gmcharlt: I just upgraded my code from 3.0.3 to 3.0.5
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:48 gmcharlt sekjal: are you trying to compare specific DBrevs between 3.0.x and 3.2.x ?
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: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:18 nengard hiya owen
14:17 owen Good morning nengard
14:15 jwagner Never mind, it's there. Been a snake, it would have bit me.
14:15 jwagner Thanks, that will help. Is that Magick one in there? Didn't see it....
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:14 gmcharlt jwagner: they're being accumulated in bug 4151 and will be in release notes, etc.
14:13 jwagner Another new one? Is there a complete list somewhere of ALL the new ones?
14:13 gmcharlt not atm
14:13 owen Does Locale::Currency::Format have a Debian package?
14:13 gmcharlt yep, a new dep
14:13 gmcharlt :)
14:13 owen gmcharlt you narrowly escaped the crack of my whip
14:12 owen___ here I am!
14:12 owen New dependency in HEAD? Locale::Currency::Format?
14:11 * owen looks for owen_ and owen__ to help him with his work load
14:05 jwagner That's my line.
14:03 jdavidb Harrrrumph!
13:29 kf sounds bad, its not that bad here
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: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:23 Ropuch @wunder Wroclaw
13:23 kf snow it melting here - im happy about it :)
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: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:20 kf @wunder Konstanz
13:20 kf hi jwagner
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:16 jwagner @wunder 20817
13:16 jwagner Good morning folks.
12:48 gmcharlt hdl_laptop: thanks
12:44 hdl_laptop gmcharlt: ok
12:42 gmcharlt keeping the prefs as boolean, then adding four sub prefs seems better
12:42 gmcharlt well, that's no good (the inconsistency)
12:41 hdl_laptop But XSLResultsDisplay and XSLDetails desplay is Boolean.
12:41 hdl_laptop (same as XSLOPACDisplay)
12:40 hdl_laptop OPACXSLResultsDisplay stay path or url
12:40 hdl_laptop no.
12:40 hdl_laptop mmm...
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:38 gmcharlt or leave the sysprefs alone
12:38 gmcharlt but if we do that for 3.2, either 3.0.x shoudl do exactly that
12:38 gmcharlt that's a better way of doing 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:37 gmcharlt would do it
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:36 hdl_laptop I can revert that.
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:34 hdl_laptop (and not better)
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:33 hdl_laptop not worse
12:33 hdl_laptop about translations, it is just the way it was before.
12:33 gmcharlt yep
12:30 hdl_laptop just saw your email on koha-devel
12:30 gmcharlt hi hdl_laptop
12:30 hdl_laptop hi gmcharlt
12:10 kf reboot
11:53 * chris_n wanders off to find breakfast
11:52 chris_n based on a checkbox in label-print.pl
11:52 chris_n the the method could be invoked at label generation time
11:52 Ropuch I'll look into it after work
11:51 Ropuch Huh
11:51 chris_n the long term solution is to add an item_sort method to C4::Creators::Batch
11:50 chris_n so it may be better to do it at the point mentioned above with more code
11:49 chris_n but that might be too late to do the sort
11:49 chris_n this line is where the barcode data is retrieved
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 sorry Ropuch, here is where you want to be:
11:45 chris_n iirc
11:45 chris_n you can sort on the 'item_number' key of the hash
11:44 Ropuch Ok, I;m tryingm thanks for lightspeed response :)
11:43 chris_n to an array of hashes
11:43 chris_n arrayref rather
11:41 chris_n $items is a hashref
11:41 chris_n just after line 91
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 Ropuch: as a hack you could add some code here:
11:38 * chris_n looks
11:37 Ropuch ;>
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:35 chris_n if you'll open an enhancement bug for it, I'll look into it in the next few days
11:34 chris_n Ropuch: some code could be added to order them that way
11:34 Ropuch :))
11:33 chris_n hehe
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 Ropuch: not atm
11:33 chris_n g'morning
11:33 Ropuch Is there a simple way to have items in label batch ordered by barcode?
11:33 gmcharlt hi Ropuch
11:32 Ropuch gmcharlt ;>
11:32 Ropuch Hello kf, gma
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)
10:43 kf ok
10:43 gmcharlt kf: please do
10:43 kf gmcharlt: write a bug report? I can add more examples there
10:18 kf I think there are more, but these are prominent places
10:17 kf and moremember.pl / circulation.pl : buttons under checkouts: return all, renew all, renew or return checked items
10:15 gmcharlt thanks
10:15 kf additem.pl: buttons under form
10:13 kf patron account: all buttons for fnies (credit, payment) all buttons in edit item
10:09 gmcharlt kf: can you give me an example of a specific button?
10:08 nicomo hi Amit
10:08 Amit hi kf
10:08 Amit heya nicomo
10:02 kf hm, how can that be fixed? perhaps I can work on it?
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 :(
09:59 kf sure? I thought we had them in German in an earlier version
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:56 kf good morning gmcharlt
09:56 munin kf: The operation succeeded.
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:54 gmcharlt greetings #koha
09:50 kf ok, translation question - chris? still awake?
08:18 kf hi chris
08:17 chris hiya kf
08:16 kf good morning #koha
08:02 paul_p hi chris
08:02 chris hi paul_p
07:37 brendan but, good call "so we dont actually need it just yet"
07:36 brendan something like in for a penny
07:36 brendan I don't know the correct saying here
07:36 chris unless that changes
07:35 chris i can push to git.koha.org .. so we dont actually need it just yet
07:35 brendan would be cool to have all the developers switch there git.configs to that
07:34 chris nope, but wouldnt be hard to do
07:34 brendan do we have a git.koha-community.org started yet?
07:33 chris i won't actually sign off anything for 3.4 until we branch 3.2
07:33 brendan :) yes just reading through it -- pretty cool
07:33 chris :)
07:33 brendan I'll save that comment for the first patch then
07:33 chris it makes the sysprefs translatable, and makes the templates translation work better
07:33 brendan well almost then
07:32 chris it'll probably actually go into 3.2
07:32 brendan first patch for 3.4 signed off on? anyways that's cool
07:31 Ropuch I think it can be done from sql
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:29 Ropuch Hm
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:13 chris :)
07:13 Ropuch ;>
07:13 Ropuch ..& chris_without_n
07:12 Ropuch Hi chris_n
07:12 Ropuch Morning #koha
04:14 chris_n it even grabs stock quote
04:14 * chris_n messes with Finance::Quote which could make the exchange rate code in koha real-time
03:43 walter htdocs, cool
03:42 chris that should have it
03:42 chris check the docroot there
03:42 * walter checks
03:42 walter
03:42 walter bin doc intranet lib man misc opac
03:42 walter ls /usr/share/koha
03:41 chris if you check the koha apache conf
03:41 chris is there a koha-tmpl dir there? or opac-tmpl?
03:41 walter i.e. koha-tmpl/opac-tmpl/prog/en/modules/opac-results.tmpl
03:40 walter but template lives?
03:40 chris cool
03:40 walter think i can see where the opac stuff lives there
03:40 walter looks like a winner for that
03:39 walter ok, cool
03:39 chris try /usr/share/koha
03:39 chris ahh, well it will totally depend on where the person installing it decided to put the files
03:39 walter yeah, i would normally... but these guys aren't a git shop quite yet
03:39 chris and you can cherry-pick that in
03:39 walter it's a running install already
03:39 chris then it will be running out of hte git repo
03:39 walter hmm
03:39 chris youll want to do dev install
03:38 walter i.e. i'm not a koha guy and don't know its usual filesystem layout
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 chris yep
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:32 Amit hi chris
03:32 chris hi Amit
03:31 Amit heya chris_n
03:31 chris_n heya Amit
03:31 Amit hi all
03:30 chris yup
03:29 chris_n it might actually speed up circulation a bit
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:28 chris not me sorry braedon|work
03:28 chris_n it would be nice to add some ajax to avoid full page refreshes in the staff client
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:27 chris seems to work just fine
03:27 chris ./koha-tmpl/intranet-tmpl/prog/test-TEST/modules/admin/preferences/creators.pref
03:25 chris so far so good
03:25 chris en en-NZ famfamfam images itemtypeimg test-TEST
03:25 chris chrisc@stuffdev:~/koha/misc/translator$ ls ../../koha-tmpl/opac-tmpl/prog/
03:25 chris perl -I ../../ translate install test-TEST
03:25 chris poedit tells me they are valid
03:24 chris -rw-r--r-- 1 chrisc chrisc 84010 2010-02-17 16:20 test-TEST-pref.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:23 chris -rw-r--r-- 1 chrisc chrisc 293532 2010-02-17 16:20 test-TEST-i-opac-t-prog-v-3002000.po
03:23 chris and i end up with
03:23 chris perl -I ../../ translate create test-TEST
03:22 chris bunch of warns .. but seems to be doing what it should
03:20 chris trying a test translation
03:14 chris yeah it looks a lot cleaner, i like having all the code in a module
03:14 gmcharlt only issue my eyeball has with it thus far is the "GPL 2.1"
03:13 chris didn't explode, so thats a good start
03:13 * chris sets up a remote and does the pull
03:12 gmcharlt yep
03:12 chris thats his trans branch eh?
03:11 gmcharlt chris: thanks
03:10 gmcharlt s/currency/currencies/
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:09 chris ill give it a whirl tonight
03:08 gmcharlt chris: would you have time to test and sign off on fredericd's new translation wrapper?
03:07 chris_n it works pretty nice actually
03:05 chris sounds better than the current hodgepodge
03:04 chris_n I'd like to implement Locale::Currency::Format to handle currency issues for 3.4
03:01 chris yep
03:01 chris_n yup
03:00 gmcharlt at the very list, to stick the staff cgi directories under a top-level staff or intranet
03:00 chris_n housekeeping++
03:00 gmcharlt one thing I'd like to do for 3.4 is rearrange the directories
03:00 ebegin I agree that we must have a single list.
03:00 gmcharlt while we're talking about this sort of housekeeping
03:00 chris yep it has to be used by all things
02:59 gmcharlt but the last thing I want to see is Yet Another Separate List of Dependent Perl Modules
02:59 gmcharlt ebegin: that woudl be part and parcel of what we're discussing
02:58 chris each release
02:58 chris so we can run that and put it somewhere
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 and lets put an export_list_in_html method in it
02:57 chris_n true
02:57 chris *nod*
02:57 gmcharlt whatever it's called, can also be used to track which modules are required for optional features
02:57 chris_n the labels/pcards code uses several constants which would be nice to centralize
02:56 gmcharlt chris_n: I don't like C4::Constants as the name, but certainly C4::Something
02:56 chris it should be maintained in one place
02:56 chris_n maybe C4::Constants
02:56 chris about.pl should use the same list as Makefile.PL
02:55 chris *nod*
02:55 gmcharlt Makefile.PL has the best list
02:55 chris can use it
02:55 chris so that about.pl and what_perl_modules_am_i_missing.pl
02:55 chris_n about.pl is missing version #'s
02:55 chris abstracting the list of dependencies out
02:55 chris_n of course constructing a small script would be easier probably
02:55 chris i think taking about.pl
02:54 * chris_n has at times had problems with various version, along with forgetting
02:54 gmcharlt EU::MM doesn't create a deps target
02:54 chris or it scrolled off your screen
02:54 chris i guess you could use make deps if you forgot
02:54 chris_n then you can verify remaining deps
02:54 gmcharlt which gives you the list of unmet deps, rendering make deps superfluous
02:54 chris_n chris: right, but that's the idea
02:53 chris course you would have had to run perl Makefile.PL at least once for that to work though
02:53 chris_n last in, random out
02:53 * chris_n adds it to his LIRO buffer
02:53 chris make deps
02:53 ebegin ok, and WriteMakeFile is a function of MakeMaker?
02:52 gmcharlt chris_n: I'm not stopping you
02:52 gmcharlt the list of dependencies is the PREREQ_PM list, of course
02:52 chris_n gmcharlt: it seems one might be able to setup a target just to test for deps
02:51 gmcharlt ebegin: it's part of what ExtUtils::MakeMaker handles
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:49 chris as long as we do search right, so it knows to query the items table, then that would be fine
02:48 chris *nod*
02:48 gmcharlt and preferably, I'd leave it out entirely excpept for export and indexing
02:47 chris awesome
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 or we could just leave it out, and create it when needed (export or z3950 query etc)
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:46 chris it slows circ down something mental
02:46 chris yeah that we need for 3.4
02:45 chris_n hmm: Performance enhancement: Do not embed item data in internally stored MARC data.
02:43 chris so yeah, LLEK has hourly loans apparently
02:43 * chris_n is caught in the telephone booth :-)
02:42 * gmcharlt pulls off the mask from chris_n to reveal Kyle?
02:42 chris_n ah ha
02:41 chris thats why people thought it was you
02:41 chris Add Quick Spine Label Printer (Chris Nighswonger).
02:41 chris_n how so?
02:41 chris heh you get a credit chris_n
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:40 chris_n Tumer's work looks nice
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:39 chris they say its in LLEK
02:39 chris_n did LL never impliment this even in LEK?
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:38 chris the actual implementation
02:38 chris its probably still all in someones brain too
02:38 chris yep
02:38 gmcharlt http://wiki.koha.org/doku.php?id=en:development:rfcs3.2:rfc32_hourly_circ&s[]=hourly&s[]=loans
02:38 gmcharlt the old LL RFC on hourly loans is still pretty comprehensive
02:37 * chris_n imagines 'click here for the street view'
02:37 chris_n but in any case, the images would be very localized
02:37 gmcharlt library mapping is much easier than hourly loans :)
02:36 chris_n actually, it would probably not be too hard to impliment from scratch
02:36 chris_n probably overlayed on the fly with a graphics module
02:35 chris_n the mapping is animated gifs
02:34 chris cant possibly be worse than Search.pm
02:34 gmcharlt if the circ code were better organized, I might agree with you
02:34 chris_n lol
02:34 chris its not like having to do something with search, or cataloguing :)
02:33 chris gmcharlt: its pretty well defined tho, is this datetime greater than this datetime
02:33 chris_n yeah, but the logic and techique might be useful
02:33 gmcharlt that's ignoring the functionality consequences, which aren't nearly so trivial
02:33 chris im not sure it would be generalisable in an easy way
02:32 chris chris_n: thats pretty localised
02:32 chris instead of a date
02:32 chris_n the mapping stuff was my primary thought
02:32 chris it needs a database change returndate needs to be a datetime
02:32 chris hourly loans isnt actually that hard
02:32 chris yeah
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:31 chris cos we converted from cvs
02:31 chris_n what is the tag 'version-1-2-1'
02:31 chris well the repo goes back that far
02:31 chris_n hmm
02:31 chris only 2007
02:31 chris heck no
02:31 chris_n 1.2.x maybe?
02:31 chris_n the git repo goes back pretty far does it not?
02:30 chris yep
02:29 chris_n if not all of the work
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 cool
02:29 chris_n I have
02:29 chris_n I wonder how impossible of a job it would be to merge them in
02:29 chris im sure if someone emailed he would give them the code
02:28 chris tumer was always good about committing back, but i think they might still be on cvs
02:28 chris_n location mapping, hourly loans
02:28 chris_n it appears that Near Eastern University has several desirable features in their custom koha work
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:24 braedon|work @wunder tauranga 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:23 chris @wunder wellington nz
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:20 chris_n @wunder 28334