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