Time Nick Message
00:47 mtj is kc.org slow for people?
00:48 mtj or just me :/
01:33 mtj hmm, looks like my interweb is glitchy today - prolly not kc.org
01:38 rangi hey NateC
01:38 NateC hey rangi
01:42 rangi http://www.youtube.com/watch?v=BhOlR4A-S9c&feature=related
01:42 rangi or if you prefer dubstep
01:42 rangi http://www.youtube.com/watch?v=-7IYOCUbpBA&feature=related
01:45 Leftmost I'm looking for a piece of software to cover three fairly sizeable and inter-related personal collections, consisting of VHS, vinyl, CDs, DVDs, print books, digital audio, digital video and ebooks. Ideal data entry would be done through services like MusicBrainz and OpenLibrary. Would koha be suitable for this? Or overkill? Or just plain wrong?
01:45 rangi overkill mostly
01:46 NateC priceless
01:49 Leftmost Hmm. I kind of figured. Kind of stuck, as smaller solutions don't seem to be suitable and Koha seems large (and like data entry would be difficult considering).
01:50 jcamins Leftmost: if nothing else is sufficient, Koha is a good choice.
02:14 pianohacker git.k-c.o broken?
02:15 rangi yep
02:15 rangi i think it needs more ram
02:15 wizzyrea hm
02:15 pianohacker mirrors?
02:15 rangi ah no
02:16 rangi git is fine
02:16 rangi its just gitweb
02:16 pianohacker sorry for terseness, just switched to colemak
02:16 rangi no worries
02:16 pianohacker really? git pull hangs w/ no output
02:16 rangi hmm git fetch just worked for me
02:17 rangi git fetch
02:17 rangi From git://git.koha-community.org/koha dcf5333..f2fa6c8 master -> kc/master
02:17 rangi rorohiko:[git/kcmaster-]:~/git/koha%
02:17 bg what's rorohiko mean?
02:17 rangi computer
02:17 bg duuh
02:17 rangi :)
02:20 library_systems_guy so anybody have a record for highest load on their server while reindexing zebra
02:20 * wizzyrea makes a bet that you do
02:20 library_systems_guy because i feel like im setting a record here
02:21 rangi did you forget to stop your cron jobs?
02:21 rangi ie do have a crapload running at once fighting each other?
02:21 rangi cos that will do it
02:21 library_systems_guy yes i do
02:21 library_systems_guy load average: 30.00, 29.37, 28.57
02:21 rangi yeah comment out the cronjob
02:21 library_systems_guy there are like 30 running
02:21 rangi it will only get worse otherwise
02:21 rangi and then you just have to wait for them to finish
02:21 rangi what id do
02:21 library_systems_guy will it ever just stop itself?
02:22 rangi if you stop telling it to start more
02:22 rangi yes ;)
02:22 rangi so comment out the cron job, let it finish then uncomment it
02:22 library_systems_guy gotcha
02:22 library_systems_guy done...thanks
02:22 rangi you can then find the oldest one running, and nice it up, so it gets priority
02:22 rangi then it will finish, and then do the next etc
02:22 library_systems_guy i left it running after doing a batchload
02:23 rangi or you can just wait .. either works
02:23 library_systems_guy well...at least i know cron is working :p
02:25 library_systems_guy rangi++ btw
04:36 Waylon Hey all. koha 3.0rc2 with Zebra. With zebraqueuedaemon depreciated, is ModZebra, that updates zebraqueue, even necessary?
04:40 Waylon reason i ask, in implementing rubyrep, to do multimaster replication where if one master disappears, doesn't affect the rest, found a strange bug... that zebraqueue 'authorityserver' inserts last_insert_id stick.. so when INSERT INTO biblio occurs, its inserting into authorityserver's last_insert_id... for some reason it fails.. and INSERT INTO biblioitems fails due to foreign key constraint or
04:40 Waylon something like that.
04:41 * Oak waves
04:47 Waylon though.. i did put a before insert trigger on zebraqueue.. why would that save the last_insert_id for the next insert into biblio though?
04:55 mtj Waylon: heya, i wanged a master/slave replication setup for a client - a while ago
04:56 mtj my twist was i added a 'done_slave' column to the zebraqueue table
04:57 * Waylon nods. "you still have the slave pull code handy?"
04:57 mtj it worked well...
04:58 mtj the only catch was the slave box needed to be manually switched to run as the master
04:59 mtj yep, somewhere
05:00 mtj ill put it out later tonight for you...
05:00 mtj it may suit your needs
05:00 mtj s/put/pull/
05:01 Waylon thanks.
05:02 Waylon what i don't get... is sometimes insert biblio just works... that is.. has worked... i think.. though i don't know any arabic to check.
05:02 mtj its a pretty clean mod to the zebq.pl daemon script
05:04 Waylon other times... a insert to biblioitems throws a foreign constraint.
05:04 mtj just test using western chars then?
05:04 Waylon im hoping that the time that it does work... the insert to biblio is giving the right last_insert_id to biblioitems..
05:05 mtj pass...
05:05 Waylon else.. two days of data entry will be down the drain.
05:06 mtj if you changed (busted?) some of the tables properties, weird stuff happens, imho
05:07 mtj ahh, and sorry! - i know nothing of 'rubyrep'
05:08 mtj i assume your db defs are unchanged-ish?
05:08 Waylon the biblionumber for biblioitems inserts always comes from last_insert_id?
05:09 mtj pass...
05:10 mtj its a pretty low-level bug, on an old-ish and db modified Koha
05:11 mtj Waylon: can you replicate your bug consistently?
05:13 Waylon yah... looking at my binlogs..
05:13 Waylon and twice i tried skipping over a position, and hit another foreign key constraint error.
05:13 Waylon maybe its something to do with triggers and old mysql.
05:14 mtj cool, and can you replicate that same bug on an upgraded 3.2 or 3.4 Koha ?
05:14 Waylon unknown.
05:14 mtj on *your* upgraded 3.2 or 3.4 Koha ;)
05:14 * Waylon sighs.... "don't have one."
05:15 mtj meaning...upgrade your system to a recent version- then test that very bug
05:16 mtj $ git clone git://git.koha-community.org/koha.git kohaclone :p
05:17 mtj set a test one up now - then have it sitting around for future handy testing
05:19 mtj or ... just dump your db, then 'git reset --hard v3.04.01' on your current Koha repo
05:19 mtj that will upgrade your codebase, etc
05:20 mtj ... then update fron the web-gui
05:21 * mtj goes back to his tax return
05:43 cait morning #koha
05:57 Leftmost There's no way to import a holding without at least a partial MARC, is there?
05:57 mtj tax return finished :)
05:57 mtj heya cait
05:57 cait hi mason :)
05:58 mtj Leftmost: all you need is an isbn or issn, via z39
05:58 mtj heya cait, i gotta scoot off now...
06:00 cait ok
06:00 cait have a nice evening :)
06:00 Leftmost Well, I have a fair few books which aren't catalogued by anyone with a Z39.50 interface (to my knowledge), and I'm also going to be cataloguing audio/video/digital holdings.
06:02 mtj ahh, there is an AV media equiv to that - a cataloguer will tell us
06:03 mtj but hey - you can import anything from any format , if the data is parseable
06:03 mtj and you have the need
06:04 mtj gotta scoot....
06:05 samerrill1 Leftmost: I catalog a lot of movies and have found the Amazon2Marc utilty quite useful: http://chopac.org/cgi-bin/tools/az2marc.pl
06:05 francharb hello all
06:09 Leftmost samerrill1, that looks very useful. Don't suppose you know if the author makes the source available anywhere.
06:11 samerrill He has a contact link on his site and he's been very responsive every time I've contacted him.
06:12 Leftmost Excellent, thanks. It would be great to be able to integrate that into a barcode scanning tool for rapid import.
06:12 samerrill The Firefox plugin or Greasemonkey script work the best for me. You can even add your holding data before exporting.
06:13 samerrill I scan the UPC into Amazon's search and the export MARC button appears on the page.
06:17 Leftmost Hmm. I have some improvements that could be made as well. :)
06:24 alex_a hi
06:24 wahanui what's up, alex_a
06:34 Leftmost Also don't suppose anyone knows how to get MARC/MAB data from Deutsche Nationalbibliothek.
06:36 reiveune hello*
07:00 Waylon figured out, one could use mysqlbinlog itself, to simulate replication.
07:07 Judit hello
07:07 wahanui que tal, Judit
07:07 Judit not much thanks for asking :)
07:08 Judit i have a question though if anyone around, and feels like to answer it
07:09 Judit how do you add a new authority record- personal name- from a z39.50 search
07:11 Judit in Home › Authorities i only have the option to choose from the authority types and add it manually
07:12 Judit in Home› Cataloging i have the option to search with z39.50, but i dont have the Personal name Framework available
07:22 kf morning #koha
07:34 paul_p hello world
07:35 kf hi paul_p
07:38 paul_p kf, do you have your new laptop ?
07:39 kf nope
07:39 kf still hoping for today
07:39 kf and that my neighbour will be at home
07:40 kf but trying to be there tomorrow
08:50 Judit hi koha people
08:50 alex_a hi Judit
08:51 Judit where can i read tge koha channel logs, do you know?
08:53 alex_a Judit: tge ?
08:53 Judit the
08:53 Judit sorry
08:53 alex_a :)
08:53 Judit :)
08:53 Judit yeah eating and typing
08:53 Judit no good
08:54 alex_a Judit: that is waht you want ? : http://stats.workbuffer.org/irclog/koha/
08:54 Judit i just had a questionon authoriries and want to see
08:55 Judit ok
08:55 Judit thanks alexa_a
08:55 Judit wow, nothing happened here since my question- i scared everyone off i guess
08:55 Judit :)
08:57 alex_a Judit: indeed :)
09:01 Judit you dont seem to be scared alex_a
09:02 Judit how abot a nice question on authorities? :) hm?
09:06 alex_a Judit: sorry i don't know
09:07 Judit :/
09:07 Judit that is ok, at least you are not scared:)
09:07 alex_a but indeed, it's a very nice question ;)
10:07 kf what is your question Judit?
10:07 * kf should perhaps be scared
10:08 Judit kf :)
10:08 Judit i will just copy paste ot again
10:08 Judit how do you add a new authority record- personal name- from a z39.50 search
10:08 Judit in  Home › Authorities i only have the option to choose from the authority types and add it manually
10:08 Judit in Home› Cataloging i have the option to search with z39.50, but i dont have the Personal name Framework available
10:09 Judit and look: http://stats.workbuffer.org/irclog/koha/2011-07-07#i_709173Judit left #koha
10:09 Judit http://stats.workbuffer.org/irclog/koha/2011-07-07#i_709174 kf joined #koha
10:11 kf ok
10:11 kf correct me if I am misunderstanding you :)
10:11 Judit ok? that is not and you run away?
10:11 Judit ah ok
10:11 kf no
10:11 Judit ask
10:11 kf not planning to run away
10:11 Judit :)
10:11 Judit even better
10:11 kf when you download a title record, there is an option I think to make koha create authority records on the fly (never used that)
10:12 kf and you can add themmanually
10:12 kf by using the ... plugin behind the fields of your downloaded record
10:12 Judit okay
10:12 kf there is no way to download an authority using z39.50
10:12 kf new authorities are added in the authorities module
10:12 Judit manually
10:12 Judit only
10:12 Judit ?
10:12 kf there you should have a framework for personal name
10:12 kf and the other possible types
10:13 kf current situation is manually only
10:13 kf yes
10:13 kf there is a command line option for importing authorities
10:13 Judit i have, but for example library of australia has z39.50 for authorities only
10:13 kf I think it would be a good feature to add download for authoriries perhaps
10:13 kf we use the command line option - but different situation here
10:14 kf all our records come from the same source (bibliographic and authorities) with all the right numbers for linking in place already
10:14 kf if you download from different sources and import into koha making them link is a problem afaik
10:14 kf does not work well automatically
10:14 Judit okay
10:14 Judit and
10:15 Judit your still-personal name- authority "database" will build on the records you already imported
10:16 kf sorry
10:16 kf can you explain?
10:16 Judit lets say you import a book from sylvia plath using lib of au
10:16 kf ok
10:16 Judit so next tie you want to add a book by her
10:16 Judit time
10:17 Judit you will have her name laready listed
10:17 Judit ok, so you wan to add a book by her, by original cataloging- not downloading, but typing it in yourself
10:18 Judit you go to http://calyxgroup.calyx.net.au:8080/cgi-bin/koha/mainpage.pl › http://calyxgroup.calyx.net.au:8080/cgi-bin/koha/cataloguing/addbooks.pl › Add MARC Record
10:18 Judit click on 100 a
10:19 kf and search for her name in authorities
10:19 Judit and if you search for sylvia plath- she will show up there
10:19 kf yes
10:19 kf and link her
10:19 Judit okay
10:19 Judit thank you very much
10:19 kf hope it helps! :)
10:20 Judit it did!
10:20 Judit it is not me being blind/stupid, but Koha
10:52 druthb o/
11:00 huginn New commit(s) needsignoff: [Bug 2505] enable Perl warnings in all modules and scripts <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2505>
11:12 huginn New commit(s) needsignoff: [Bug 6469] Remove compile time warnings introduced in patch to C4::Accounts <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6469>
11:46 huginn New commit(s) needsignoff: [Bug 6562] Reserve request generates unnecessary runtime errors <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6562>
12:54 hdl @later tell Judit : the reason why there is no facility to import authorites from z3950 servers is that z3950 authority servers are quite rare... If we imagined that Koha users would expose their authorities to the world, we would have implemented a z3950 search for authorities too :D
12:54 huginn hdl: The operation succeeded.
13:13 kf hm
13:14 kf searching a special koha catalog - the one |Lupin| did for the digital library
13:15 library_systems_guy so I've been killing off zebra cron processes that are backed up
13:15 kf hah
13:15 kf found it
13:15 kf http://www.bibliotheque-helene.org/
13:15 library_systems_guy should i also be killing off the zebraidx processes
13:16 sekjal library_systems_guy: how frequently do you do your rebuild_zebra.pl on cron?
13:17 library_systems_guy well i was importing our catalog and forgot to turn it off
13:17 kf hm something between 3-5 minutes I think
13:17 kf not sure
13:17 kf oh
13:17 kf ignoreme
13:17 library_systems_guy i think ours is set to 10 atm
13:18 library_systems_guy the load was at 30
13:18 library_systems_guy but i've killed enough rebuild processes that its back down to 3.5
13:19 sekjal library_systems_guy: I think you'll be okay
13:19 library_systems_guy ok cool
13:19 library_systems_guy it was bogging down the import...silly zebra
13:23 sekjal Silly Zebra, incremental indexing is for kids!
13:26 library_systems_guy i forgot about the cron running the incremental update and thought it was the bulkimport script
13:27 hdl library_systems_guy: you could also use a bash script to check that rebuild_zebra is not running before the cron launches a rebuildzebra
13:27 hdl ;)
13:27 library_systems_guy thats true...i never thought about that
13:34 oleonard Man, the JS in addbiblio.pl really brings IE to its knees.
13:47 slef better if rebuild_zebra checked for itself, rather than adding a bash script... lockfile or maybe something from man perlfaq or anything... sorry if that's scrolled off the top of my screen
13:50 oleonard Hi slef
13:51 slef hi all
13:51 slef hi oleonard
13:51 slef hi
13:51 slef wahanui dead?
13:52 slef details not on http://wiki.koha-community.org/wiki/Website_Administration
13:52 wizzyrea hm yea he's not here
13:52 oleonard wahanui left for some reason
13:52 wizzyrea but rangi runs that one
13:52 slef ran on bugs.koha-community.org
13:53 slef @later tell rangi where's wahanui?
13:53 huginn slef: The operation succeeded.
13:53 slef huginn: thanks
13:53 huginn slef: I suck
13:53 slef huginn: yeah, but you're still here, unlike that quitter.
13:53 huginn slef: I'll give you the answer just as soon as RDA is ready
13:53 slef huginn: when will RDA be ready?
13:53 huginn slef: I suck
13:54 oleonard I had not seen that page on the wiki before. That's awesome.
13:54 slef I suspect someone got bored with me bricking the wrong people when stuff broke.
13:55 wizzyrea nah, when we set it all up we documented it. ;)
13:55 wizzyrea well rangi, gmcharlt, nengard, and myself did
13:57 wizzyrea hmm, has anyone noticed that picking barcode on the labels prints the actual barcode, and not the numbers?
13:57 gmcharlt wizzyrea: handy, though :)
13:57 jcamins You've heard of superlibrarians? Well wizzyrea is a SuperAdmin, too! :D
13:57 wizzyrea !
13:57 wizzyrea thanks :)
13:58 jcamins wizzyrea: just reading from the Website Administration page.
13:58 wizzyrea oh dear
13:58 wizzyrea lol, oh that
14:00 wizzyrea we really ought to get contribs running again
14:00 wizzyrea i keep saying that
14:00 wizzyrea meaning to do something about it
14:00 wizzyrea it's currently at that *other* domain.
14:08 oleonard ...where I'm sure it gets loads of use, being actively promoted by its host
14:14 huginn New commit(s) needsignoff: [Bug 6531] clicking print button in opac causes 404 error <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6531>
14:36 swegner knock knock - anyone home and game to answer a koha barcode question?
14:37 oleonard Ask to find out!
14:37 wizzyrea @quote add Don't ask to ask, just ask!
14:37 huginn wizzyrea: The operation succeeded. Quote #145 added.
14:37 wizzyrea @quote get 145
14:37 huginn wizzyrea: Quote #145: "Don't ask to ask, just ask!" (added by wizzyrea at 02:37 PM, July 07, 2011)
14:38 * wizzyrea giggles
14:38 swegner heh - cool. Just got my koha install running... imported some data from WINNEBAGO - I have recrods...
14:38 oleonard huginn: ask is Don't ask to ask, just ask!
14:38 huginn oleonard: I'll give you the answer just as soon as RDA is ready
14:38 oleonard whoops
14:38 * oleonard checks his bot register
14:39 swegner and there is a MARC field called "Piece Designation" which is the barcode on my physical books...
14:39 kf very good question slef
14:39 swegner not sure how to make that number the koha barcode. :/
14:39 jcamins swegner: put it in the barcode field.
14:39 kf hm should scroll down -talking about wahanui
14:39 jcamins 952$p.
14:42 wizzyrea in the label creator, what are all of the item data keywords?
14:42 wizzyrea i know itemcallnumber, barcode, homebranch
14:43 wizzyrea but I'm having trouble getting the date acquired
14:43 wizzyrea and I've tried dateacquired, acqdate...
14:43 wizzyrea swegner: did that answer your question? To put the barcode in the 952$p?
14:44 hdl wizzyrea: dateaccessioned
14:44 wizzyrea hdl++ thanks!
14:45 wizzyrea hdl: perfect, thanks again
14:45 swegner ya - kind of makes sense ... just not sure at what stage I can/should do that. I have the data imported now... an SQL script could maybe copy that data from the current field to the 952$p marc field..
14:45 wizzyrea aha
14:46 hdl wizzyrea: np
14:46 swegner but ... maybe it would be best to tweek the data before it gets imported into koha.... :/
14:46 wizzyrea you probably want to use marcedit to move it from where it is to the proper spot in the 952$p pre import
14:46 wizzyrea ^^ that
14:46 wizzyrea :)
14:47 druthb o/
14:47 swegner ya - k - I'm familiar with MarcEdit a little.
14:47 swegner I'll mess with it.
14:49 wizzyrea gl :)_
14:51 slef or use any tool that can remap MARC
14:56 hdl hi druthb
14:57 druthb hi, hdl! :)
14:57 kf hdl: it seems your demo isntallation is broken: http://wiki.koha-community.org/wiki/Koha_Demo_Databases
14:58 hdl demo.biblibre.com is now on a 3.4
14:58 kf I think the links are wrong then
14:58 hdl But demo.koha-fr.org still has to point to that.
14:59 swegner is seems as though when I search various mail lists for a 852 to 952 'howto' - they all point to the now commercial koha site which says: "sorry sucker!" :)
14:59 swegner re: marcedit
14:59 kf hm
14:59 kf I think we have a table with the fields on the manual
15:15 wizzyrea quick!
15:15 wizzyrea check this out
15:15 wizzyrea go to additem
15:15 wizzyrea and try to add an item --
15:16 wizzyrea check out what shows up in your 952$8
15:16 swegner k
15:16 wizzyrea if you're like us
15:16 wizzyrea it will show you a branch code instead of a collection code
15:16 wizzyrea d'oh
15:17 wizzyrea 952$8 is collection code
15:18 swegner I don't even have the 952 field. only up to 942
15:19 wizzyrea add item
15:19 magnuse hey, global bug squashing day is already 5 hours old in Kiritimati, Christmas Island, Kiribati http://www.timeanddate.com/worldclock/city.html?n=274
15:19 wizzyrea magnuse: I have a great bug
15:19 wizzyrea see above
15:19 wizzyrea though I haven't filed a bug yet
15:19 wizzyrea but it's kindofabigdeal
15:20 magnuse ooh
15:20 wizzyrea it looks like the additem subfields are off by 1
15:21 wizzyrea http://screencast.com/t/zqjnU7NfWOvy
15:22 hdl wizzyrea: which version ?
15:22 wizzyrea this is pretty close to master
15:23 wizzyrea let me look super quick
15:23 wizzyrea nm that might be a bad bit of js
15:30 reiveune bye
15:33 wizzyrea ok yea, we had a bit of bad js in there -- sorry for the alarm yikes
15:33 * magnuse breathes a sigh of relief
15:33 kf ah
15:33 kf was about to suggest that
15:33 * kf is too slow today
15:38 wizzyrea kf that would have been a super suggestion
15:49 swegner using marcedit to copy 852 to 952 fields - any urls or howtos come to mind... I'm only finding bits and pieces with a google search.
15:58 slef swegner: I've URLs that explain the layout of 952 and the theoretical layout of 852 but every proprietary system seems to use 852 differently so you'd need to check it. Would they help?
15:59 slef @marc 852
15:59 huginn slef: Identifies the organization holding the item or from which it is available. May also contain detailed information about how to locate the item in a collection. (Repeatable) [a,b,c,e,f,g,h,i,j,k,l,m,n,p,q,s,t,u,x,z,2,3,6,8]
16:00 swegner ya - I'll take it. :)
16:01 slef I've added the 852 link to my 952 URL http://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) but I can't help you with marcedit because I usually use XSLTs to convert other systems to koha
16:02 swegner cool - thanks!
16:36 rhcl http://www.libraryjournal.com/lj/home/891230-264/hennepin_county_pl_loses_control.html.csp
16:37 wizzyrea oops
16:51 magnuse ouch
16:52 wizzyrea ?
16:54 magnuse the twitter thing (a bit slow...)
16:59 slef yeah well unknowable security and slow support is twitter for you (and facebook and ...)
17:01 slef until one of the open social networks takes off, this will keep repeating itself, with Hennepin County Library, with Fox News, with many more
17:05 oleonard Until then I reserve the right to hate it when it happens to Hennepin and like it when it happens to Fox News.
17:05 slef Libraries should take a bit of preventative medicine, use twitter a bit less and instead get involved with Diaspora, thimbl or one of the others and let them know what you think, to help them improve.
17:06 wizzyrea that kind of goes against the whole "be where your users are" movement
17:07 slef You need to both "be where your users are" and also "lead your users to where you'd like them to be"
17:07 wizzyrea yea, that really only works if Ashton Kutcher leads.
17:07 slef Users don't know everything. Hell, they don't value librarians enough.
17:08 slef 38degrees does OK without a celeb leader AFAICT
17:15 swegner thanks for the help all! loging out.
17:15 wizzyrea lat... bye
17:22 magnuse hiya cait
17:22 cait hi magnuse
17:25 magnuse will probably join the gbsd on nz time
17:26 cait oh
17:26 cait tonight?
17:26 cait thought about that too
17:26 cait no new laptop... *sighs*
17:26 cait but could be worse
17:26 jcamins cait: do you have a tracking number?
17:26 magnuse hehe
17:26 cait not on it's way yet... waiting for a small part that I ordered with it...
17:26 cait big mistake
17:27 jcamins Aww. I hate it when that happens.
17:27 * magnuse has been burned by that too
17:27 cait status in account is still the same, called the hotline almost every day this week...
17:27 cait ok
17:27 cait so why did you 2 - knowing that I was about to order my laptop - not tell me?
17:27 * cait glares
17:28 * magnuse hides
17:28 cait ;)
17:28 cait jcamins: you can stop me from glaring with cookies :)
17:29 * magnuse hands cait a milk chocolate cookie
17:29 druthb oooo
17:29 * druthb wants a cookie, too!
17:30 magnuse druthb: you have to frighten us first ;-)
17:30 * cait glares a little more at jcamins while nibbling on ther cookie
17:30 * jcamins offers a conciliatory cookie to cait and druthb, and a cheering cookie to magnuse.
17:31 druthb now...how to frighten magnuse....do I *want* to frighten him...?
17:32 magnuse moahaha
17:32 cait conciliatory?
17:32 hdl see ya
17:32 jcamins Yes, to make sure we're friends again.
17:32 cait hm, ok :)
17:33 * druthb waves an angry cat at magnuse, to see if that frightens him.
17:33 cait oh
17:33 cait why is captain midnight angry?
17:33 jcamins cait: probably because druthb won't give Captain Midnight a squirrel to play with?
17:34 magnuse oh no, not the cat, not the cat!
17:34 cait magnuse: seriously?
17:34 cait your achilles something is a cat?
17:34 * magnuse hands druthb a a cookie exactly like the one cait got
17:34 jcamins Speaking of cats, Myshkin knows they're the topic of discussion.
17:34 * cait thinks this feels like friday... perhaps because she is on vacation tomorrow :)
17:34 jcamins He's trying to knock me over.
17:35 cait hehe
17:35 * cait waves to myshkin
17:35 magnuse cait: nah, i'm fine with cats but being waved at with an angry one sounds scary
17:35 jcamins He just fell off the desk onto my lap.
17:35 magnuse hehe
17:36 wizzyrea http://www.youtube.com/watch?v=2J9epFCFkwI
17:36 magnuse cait: gbsd-vacataion?
17:36 cait testing-new-laptop-on-gbsd-vacation
17:36 cait but...
17:36 jcamins That is one angry cat.
17:36 cait now you are right
17:41 jcamins The Harry Potter movie is opening tonight?
17:42 wizzyrea I guess so
17:42 wizzyrea ya
17:42 jcamins Am I a bad twenty-something for not having known that previously?
17:42 wizzyrea newp
17:44 cait good
17:44 * cait didn't know it too
17:45 * magnuse didn't either, but isn't exactly twenty-something...
17:45 * druthb knew it, but only because the minion was telling me.
17:47 * magnuse needs better informers
17:49 * cait is still a twenty something :P
17:51 * druthb wishes she was a youngling like cait sometimes.
17:51 * druthb is an ooooold lady
17:51 cait no, you are not
17:51 cait a lady yes, but not old
17:54 cait :)
17:55 * druthb is feeling the old today...creaky out of shape ol body.
17:58 jcamins Wow, Myshkin is in rare form.
17:59 druthb ?
18:00 jcamins He is running back and forth from the floor to the other side of the desk, by way of my lap, arms, mouse, and keyboard.
18:00 druthb lol
18:06 magnuse go myshkin go!
18:06 library_systems_guy ahh i got a conflict :'(
18:07 cait hm solve it?
18:07 * cait hands library_systems_guy a cookie
18:07 library_systems_guy im not really sure how...should i delete the conflicting files and repull?
18:08 library_systems_guy i think it is because i have a patch in queue
18:12 cait hm, you have commited changes?
18:12 cait or only changed some files? without committing?
18:16 * magnuse takes the dogs for a walk, will be back to squash bugs in a bit
18:33 library_systems_guy cait: i commited some changes
18:39 cait does git status show you the conflicted files?
18:40 cait hm
18:40 library_systems_guy no, but it did show me when it was trying to rebase
18:40 cait I think you could do a git reset --soft HEAD^ to undo your commit and git stash to save your changes away before updating, or you can solve the conflict
18:41 library_systems_guy hmm...well my commit is an approved patch
18:41 library_systems_guy so i assume it will end up in head sometime
18:41 cait you can get it back later from the git stash
18:41 cait our you could make a patch, undo it and apply the patch later
18:41 cait solving the conflicts after rebasing
18:41 cait or rebase and resolve in one step
18:42 cait what I do is git rebase
18:42 cait and then git status to see the files with conflicts
18:42 cait open viles and search for <<< to find the conflict markers
18:42 cait delete them out and make the code work again
18:42 cait git add the files
18:42 library_systems_guy i think it was seeing patch files in my patches folder
18:42 cait and git rebase --resolve / --continue (it tells you, not sure which it is)
18:42 library_systems_guy and trying to apply them
18:43 cait hm no, it shouldn't do that
18:43 library_systems_guy hmm...regardless...i think it is fixed now
18:43 cait ok
18:43 library_systems_guy i tried to do a stash
18:43 library_systems_guy and it said there was nothing to save
18:43 cait yes
18:44 cait git stash will only save changed that are not commited afaik
18:44 library_systems_guy another random question
18:44 library_systems_guy ahh
18:44 library_systems_guy do you rerun make after doing a rebase?
18:44 cait I think you can do it but I normally don't
18:44 cait if you want to get changes to index and zebra files you have to copy them over or rerun it
18:45 cait because they live in koha-dev
18:45 library_systems_guy i just notice some cp lines among the skips when i run a make
18:45 cait I think I copied them over last time I did have to check something and it worked - being careful with file permissions
18:45 library_systems_guy ok...thanks cait
18:45 library_systems_guy cait++ :)
18:46 cait ugh hope it's all true what I told you :)
18:46 library_systems_guy haha well if its not it can be fixed
18:52 cait :)
19:00 wizzyrea oy what am I doing wrong here
19:00 wizzyrea i want records with ISBN's that have e-book in them
19:00 wizzyrea SELECT isbn, biblionumber FROM biblioitems WHERE isbn LIKE '%e-book%';
19:00 wizzyrea i know they exist
19:01 sekjal and you're getting empty set?
19:01 wizzyrea yea
19:01 wizzyrea without the limit it works
19:01 sekjal and are these ISBNs the first the MARC record, or do the non-ebook ISBNS come first?
19:02 wizzyrea that is a good question
19:02 wizzyrea I'd guess both
19:02 wizzyrea what's the difference?
19:02 sekjal the ISBN field in the database is only 20 char long
19:02 wizzyrea ooooo
19:02 sekjal so it'll get the first ISBN in the MARC record, and as much of the next as is possible
19:03 sekjal separated by " | "
19:03 wizzyrea and the rest are...
19:03 wizzyrea hidden away in the marcxms?
19:03 wizzyrea marcxml
19:03 sekjal yup
19:03 wizzyrea bother.
19:03 wizzyrea k I think I know what to do ;)
19:03 wizzyrea thx
19:03 library_systems_guy down with MARC...
19:03 wizzyrea sekjal++
19:03 library_systems_guy just saying
19:03 sekjal you'll need to use an Xpath to extract them
19:03 sekjal or use Zebra
19:05 wizzyrea k I think I get it
19:05 wizzyrea something like
19:05 wizzyrea SELECT CONCAT('',biblionumber,'')
19:05 wizzyrea AS bibnumber, ExtractValue(marcxml,
19:05 wizzyrea '//datafield[@tag="020"]/subfield[@code>="a"]') as isbn FROM biblioitems WHERE
19:05 wizzyrea (isbn LIKE '%ebook%') having isbn != ''
19:05 wizzyrea ew sorry paste
19:05 huginn New commit(s) needsignoff: [Bug 6534] Duplicate opac renew buttons at the top of the checkouts list <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6534>
19:12 cait wizzyrea++ :)
19:13 oleonard sekjal: Were you working on a patch for Bug 6484?
19:13 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6484 normal, P5, ---, oleonard, NEW , due date sorter on 'my summary' missing
19:13 sekjal oleonard: I was looking at it, but hadn't started coding yet
19:14 oleonard Just wondering if it should be assigned to you
19:14 wizzyrea dunno, i'm getting kind of weird results from that
19:16 sekjal oleonard: if you've got the time and inclination to tackle it, I wouldn't object (you're probably quicker to fix it than I would be)
19:17 * oleonard finds another bug while he's at it
19:20 cait oleonard creates more patches for gbsd :)
19:21 oleonard I was worried there weren't going to be enough to go around ;)
19:23 cait hehe
19:24 cait sometimes creating patches is more fun than testing them
19:24 cait more creative
19:25 jcamins cait: isn't it always?
19:28 cait hm yes
19:28 cait hm or not, some things I can't fix myself and it's fun to test them and know that's something I will not have to worry about any longer
20:21 rangi morning
20:22 magnuse kia ora rangi
20:23 cait morning rangi
20:32 rangi http://grooveshark.com/#/playlist/Squish+Dem+Bugs/56508714 <-- bug squishing music
20:32 wizzyrea ok, one more question
20:32 rangi ?
20:34 cait yay
20:35 cait squish dem bugs?
20:35 rangi heh
20:36 rangi oh and btw eythian looks after wahanui now, so ill get him to look when he pops up
20:38 * magnuse doesn't have enough bandwidth
20:38 rangi ah bummer
20:38 magnuse but i do have an ipod (eek) full of music...
20:40 * rangi is working on rebasing bug 1232
20:40 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1232 enhancement, PATCH-Sent, ---, gmcharlt, NEW , Add Invoice/Credit/Fines Payed For Day on Issues (Print Page) (Print Slip)
20:40 magnuse yay
20:41 rangi they are pretty old, no guarantees i can get them into a usable state
20:41 rangi but ill have a go
20:42 cait :)
20:43 cait go rangi go :)
20:43 * rangi cranks the bass
20:46 magnuse yay
20:46 * cait needs some coffee
20:48 cait I am going to look through some older bugs
20:48 cait checking status and such
20:49 rangi nope the patches dont do anything useful
20:49 * rangi moves on
20:49 magnuse i'm trying to figure out which bugs with "needs signoff" can't be signed off e.g. because they depend on some other bug that failed qa
20:49 rangi ah good idea
20:50 cait rangi: marked the bug?
20:50 magnuse 'cause there's no way to do that with a search or something, right?
20:50 rangi yep removed patch sent
20:51 cait k
20:51 cait waited for themail to show up
20:51 cait perhaps qa missing
20:51 rangi ah yeah could be
20:51 cait rangi: bug 4831?
20:51 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4831 critical, P5, ---, henridamien, NEW , Actual Price being ignored after receive
20:52 rangi yes?
20:52 cait only suggesting :P
20:52 rangi that doesnt even have a patch sent :)
20:52 cait I know
20:53 * cait starts the music
20:53 wizzyrea alright
20:53 wizzyrea this is elementary
20:53 wizzyrea here's my question
20:54 * cait is waiting for the ran
20:54 cait rain
20:54 cait http://meteo.sf.tv/sfmeteo/wetter_aktuell_niederschlag.php
20:54 wizzyrea we have instances of bibs that have items on them with both large print and any other ccode
20:54 wizzyrea I need to be able to identify them
20:54 cait the lake is in the right top corner... big clouds coming
20:54 wizzyrea but I'm not having any particular luck
20:54 wizzyrea well
20:54 wizzyrea i'm lacking in creativity
20:54 cait what is the question?
20:55 cait find bibs with ccode large print and another ccode?
20:55 wizzyrea and any other ccode
20:55 cait ok
20:55 cait hm
20:55 wizzyrea i know this should be easy!
20:56 cait select * from items where bib# in (select distinct bib# from items where ccode="large print") and ccode != "large print"
20:56 cait perhaps?
20:57 cait rangi++
20:57 * cait sends cookies
20:57 wizzyrea it runs at least :)
20:57 wizzyrea results to follow
20:57 wizzyrea I will... I don't know what, but that's been stumping me for a while.
20:57 wizzyrea if it works
20:58 cait hm
20:58 cait hope it doesn't kill it
20:58 wizzyrea it's the reporting server, no worries
20:59 * rangi marks one does not apply as resolved fixed, another bug already fixed it
21:02 magnuse yay!
21:04 cait confirming bug 3337 is still existing in master
21:04 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3337 minor, P5, ---, gmcharlt, NEW , RSS link is not correct
21:06 wizzyrea cait++
21:06 wizzyrea cait++
21:07 wizzyrea you deserve 2 for that
21:07 cait oh
21:07 cait thx :)
21:07 cait so I assume it worked?
21:07 druthb cait++
21:09 magnuse cait++
21:09 huginn New commit(s) needsignoff: [Bug 2809] Some search problems <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2809>
21:09 rangi kapow
21:09 magnuse heh
21:10 rangi 59 in does not apply now
21:10 cait :)
21:11 cait magnus: do you have the number we started with noted somewhereß
21:11 cait ?
21:12 magnuse on the wiki page i think, under numbers
21:15 cait ok
21:15 rangi yep
21:17 wizzyrea you can play this sound every time you squish one
21:17 wizzyrea http://www.soundsnap.com/node/48947
21:18 rangi 56
21:21 rangi all the ptfs ones wont ever apply, unless the person who wrote them rebases them on master (they are based on 3 year old code) and sends patches
21:21 rangi (they were based on 1.5 year old code when they were first submitted)
21:21 rangi so ill probably just mark them all as such
21:21 rangi skipping past them for now
21:22 cait +1
21:27 cait bug 3624 xhtml validiy patch needs to be redone for TT
21:27 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3624 blocker, PATCH-Sent, ---, paul.poulain, REOPENED , Basket group delivery place
21:28 sekjal_ i've got folks interested in bug4329, so I'm willing to rebase and expand it until it's acceptable to the community
21:28 wizzyrea bug 4329
21:28 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4329 enhancement, PATCH-Sent, ---, ian.walls, ASSIGNED , OPAC search by shelving location option
21:31 rangi cool
21:32 cait sekjal: I think we have a text search option in the pull downs now, have you seen that?
21:33 cait I think we need something better - but it's useful for now
21:33 cait hm
21:34 cait I seeseveral bugs about xss vulnerabilities
21:34 cait like bug 3652
21:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3652 critical, P1, ---, oleonard, ASSIGNED , XSS vulnerabilities
21:35 rangi yup i just moved that out of does not apply, it needs a rethink for template::toolkit
21:35 cait ah ok
21:35 cait thought about moving it to does not apply
21:36 cait so next bug
21:36 rangi heh, when the patch is so totally not right, it needs a total new one, not just rebasing/fixing
21:36 rangi so i remove patch sent status for those
21:37 cait ok :)
21:38 magnuse the table for claiming bugs for sign off is up now, IF we want to use it: http://wiki.koha-community.org/wiki/2011-07-08_Global_bug_squashing_day#Claim_a_bug_for_signoff.21 (based on templates this time)
21:39 cait failed qa = only for patches that have not been pushed yet?
21:39 rangi yes
21:39 cait ok
21:39 cait so I will reset 4857 to empty status and remove patch -sent?
21:40 rangi if they have been pushed, and still dont work, need to be noted as such, id reset the patch status too
21:40 rangi yes
21:40 cait bug 4857
21:40 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4857 critical, PATCH-Sent, ---, henridamien, ASSIGNED , aqplan.pl: consideration of Planning categories with authorised values
21:40 rangi hi Space_Librarian
21:40 Space_Librarian hey
21:40 cait hi Space_Librarian :)
21:40 Space_Librarian hi cait :)
21:44 sekjal goodnight, #koha! see you tomorrow for bug squashery!
21:50 huginn New commit(s) needsignoff: [Bug 3624] Basket group delivery place <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3624>
22:07 magnuse as far as i can see there are 6 bugs that have status "needs signoff", but which depends on other bugs that have failed qa: http://wiki.koha-community.org/wiki/2011-07-08_Global_bug_squashing_day#Claim_a_bug_for_signoff.21
22:07 rangi sounds plausible
22:10 cait magnuse++
22:12 huginn New commit(s) needsignoff: [Bug 5009] add autocomplete="off" to borrowernumbers and barcode forms <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5009>
22:15 magnuse updated this too, before that new one: http://wiki.koha-community.org/wiki/2011-07-08_Global_bug_squashing_day#Numbers
22:15 cait bug 5658 tested and resolved fixed
22:15 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5658 critical, PATCH-Sent, ---, fridolyn.somers, RESOLVED FIXED, can't delete subfields in frameworks
22:15 rangi thats utc time?
22:15 magnuse "needs signoff" has gone from 50 to 54
22:16 magnuse rangi: meant to be, yes
22:16 rangi yeah i fixed 4 does not apply ones
22:16 rangi that should keep going up for a while, until ppl start signing off
22:16 magnuse added a note about utc
22:16 rangi cool
22:16 magnuse yeah, keep em coming
22:19 cait mark resolved fix but keep patch pushed? or remove?
22:19 rangi keep patch pushed
22:20 cait ok
22:20 cait sorry, got confused
22:20 cait bug 5240 resolved fixed
22:20 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5240 minor, PATCH-Sent, ---, oleonard, RESOLVED FIXED, next link hidden on edit subfields
22:20 rangi np :)
22:21 cait rangi: what's the easiest way to check to with branches a patch was applied?
22:22 rangi ?
22:22 huginn New commit(s) needsignoff: [Bug 5263] Add support for including fields from the ISSUES table in advanced due notices <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5263>
22:22 cait looking at 5860 now - the stocknumber problem
22:22 cait there is only a note from you that it was pushed to master
22:22 cait but nothing about 3.4 or 3.2
22:22 rangi yeah i only ever push to master
22:22 rangi chris_n pulls to 3.4 or 3.2
22:23 cait I thought you perhaps know a trick to find out if it was also applied to those
22:25 rangi only if it was the same commit number
22:26 cait ok
22:26 * rangi gets yanked off to work on client work, will try to do some more squashing later
22:51 cait time to sleep -too tired to think
22:51 cait see you all tomorrow
22:51 rangi cya
22:52 magnuse signed off my first bug, 54 still needs signoff...
22:52 * magnuse will be back for some more after a bit of sleep
22:53 magnuse g'night #koha
22:53 rangi night magnuse
22:53 magnuse ta!
23:43 huginn New commit(s) needsignoff: [Bug 5511] Check for Change in Remote IP address for Session Security. Disable when remote ip address changes frequently. <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5511>
23:51 slef ok, can I object to a support provider listing request and how?
23:52 rangi last time this was discussed it was decided anyone could object and to do so on the mailing list
23:52 rangi im guessing this is the one that come through last night?
23:54 huginn New commit(s) needsignoff: [Bug 5621] Google Translation for indian languages. <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5621>
23:57 slef yeah :-(
23:58 rangi annoying