Time Nick Message 06:37 chris cya later paul 06:36 chris right, bedtime for me i think 06:23 chris :) 06:22 chris thats great 06:22 chris woo excellent 06:22 paul 3 are OK for sure. 06:22 paul another cool thing : i've 9 RFP on my desk to install Koha ;-) 06:22 chris thats cool 06:22 chris right 06:21 paul free software => economic development 06:21 paul librarian soft => culture 06:20 paul so he's interested for both reasons ! 06:20 paul * librarian software 06:20 paul * free software 06:20 paul and Koha is very interesting here : 06:20 paul it's about culture/developpement 06:19 chris what is the conference for? 06:18 paul of course !!! 06:18 chris euro, and nz$ has good buying power in south america .. so would be less expensive for us to travel to there, than for them to travel 06:18 paul i'm invited in a conference in Ouagadougou (burkina faso) in January/February 06:17 chris yes that would be good too 06:17 paul if emiliano & he's team want to make some noise around Koha in Argentina 06:17 paul of maybe in South america. 06:17 paul yes, good idea. 06:16 chris perhaps sometime in 2005, maybe 2006 we could have a koha europe conference 06:15 chris true 06:14 paul not the best quarter to visit France 06:14 chris :-) 06:14 paul no problems. january is cold/snowy anyway 06:14 chris i think i wont be able to come this january, (no money after the wedding/honeymoon) :) 06:13 chris return 06:13 chris 1899$nz to paris at the moment 06:11 chris i visited munich, and paris that way 06:11 chris when united airlines flew from nz, you could get a good value fare to europe 06:10 chris just for a vacation 06:10 chris id love to have an excuse to go back 06:10 paul for soccer world cup ? 06:10 chris i visited paris in 1998 06:10 chris excellent 06:09 paul to have a brainstorming on Koha future. 06:09 paul I plan to organize a meeting in Paris, in January, with french libraries interested by Koha 06:09 paul yes, of course. But maybe we could find a good Koha reason to meet. 06:08 chris the same if you ever come to nz 06:08 chris :) 06:08 paul (and maybe/probably to give you a bed to sleep) 06:08 chris cool 06:08 paul don't forget to tell me when you come. I'll be happy to meet you 06:07 chris its on my list of places to visit 06:04 paul oh, yes Marseille is a VERY cool place. 06:04 chris paul: i saw a tv program on sunday about a chef school in marsielle .. it looks like a beautiful place 06:03 rach nite 06:03 rach thanks 06:02 paul go to bed quickly then 06:01 rach so I chat again in a few hours 06:01 rach and the builders arrive at 6am tommorrow morning! 06:01 paul ;-) 06:01 paul bed is not now 06:01 rach 10pm now for me 06:01 paul 9AM for me... 06:01 rach thanks paul - and good night :-) 06:00 paul yes for me. good night 05:59 chris quite 05:59 chris i think fixing the lock_tables_priv will fix quit a few bugs 05:59 paul mostly bugfixes. 05:58 rach sorry loosing the plot a bit 05:58 paul but cvs has changed (a little) since 2.1.3 05:58 chris rach: 2.1.3 is the latest release 05:58 paul yes chris. 05:58 chris but still, no lock_tables_priv 05:58 rach ok so first we need a new one? 05:58 paul yep 05:58 chris so maybe its a bit different in cvs 05:57 rach doh 05:57 chris ah this is 2.1.3 05:57 paul (1765) 05:57 rach gives people something to work on 05:57 paul for me it's 1762 05:57 rach yes I think so 05:57 paul releasing a 2.2.0RC1 could help ppl trying & testing 05:57 chris system("$mysqldir/bin/mysql -u$mysqluser mysql -e \"insert into db (Host,Db,User,Select_priv,Insert_priv, 05:57 rach I think that there might be bugs that haven't been reported :-) 05:57 paul yep. 05:57 rach yes that is what worried me 05:56 paul the list is empty on bugzilla 05:56 paul for me it's a comment ??? 05:56 rach if there are any 05:56 rach so paul, do we need to get busy on a list of blockers basically? 05:56 paul 1790 ? what does it contain for you ? 05:56 chris right, we should fix that before dec 1 :-) 05:56 chris that will only work with older mysqls 05:56 paul (that's what i wanted to say) 05:55 paul yep ;-) 05:55 chris is the problem i think 05:55 chris line 1790 of install.pm 05:55 paul in Install.pm 05:54 rach which now I come to say that would actually have been a good idea 05:52 rach so I didn't actually try and turn marc on and see if it magically worked 05:52 chris havent tried, can u check the permissions for the user in a mysql there? 05:52 rach we didn't actually verify that by turning Marc on I think 05:52 rach does it work with marc on? 05:51 paul what's strange is : why does it works with MARC=ON ??? 05:51 chris i think it might be a problem in Install.pm , not setting the right permissions in mysql 05:50 chris | N | 05:50 chris | Lock_tables_priv | 05:50 chris found the problem paul 05:46 rach we are doing some training with a new koha client next week though, which is great :-) 05:46 paul my opinion is that the problem is in newbiblio 05:46 paul chris, in Biblio.pm, with MARC=OFF, MARCaddbiblio is called by "sub newbiblio" 05:46 paul yes rach 05:45 rach ok - so basically, chris might need some pointers from you I think paul? 05:45 chris i dont think so, since it works for the rest of koha 05:45 chris thats whats its grizzling on 05:45 chris ahh the lock 05:45 paul I bet EUR10 that $dbh is wrong in parameters 05:44 chris i can work on fixing the non-marc acquisition bugs 05:43 chris line 330 05:43 chris C4::Biblio 05:43 paul which script/line ? 05:43 chris yep, its the 'do' that is failing 05:43 paul that should be enough to get a working handler 05:43 paul my $dbh = C4::Context->dbh 05:42 chris something to do with do 05:42 paul unless there's a bug, ALL db delarations should use 05:42 chris i think its a mysql permissions thing 05:42 rach here = where 05:42 rach and I wasn't sure here the problem might be - wether we'd need your help 05:42 chris which is weird 05:42 chris is whats happening 05:41 paul so i'm OK to let you hunt then kill ;-) 05:41 chris DBD::mysql::db do failed: Access denied for user: 'qaadmin@localhost' 05:41 rach I was going to start with hunting them :-) 05:41 paul i'm not sure to be able to fix them 05:41 rach we can do both 05:41 paul or just report them ? 05:41 paul do you plan to hunt bugs for this ? 05:40 rach Just getting an internal server error unfortunatly 05:40 rach that is with acquisitions set to simple 05:40 rach we're not getting past the first screen of data entry, if you try to do one without a reseviore record to help 05:39 rach http://koha.qa.katipo.co.nz/cgi-bin/koha/acqui.simple/addbiblio-nomarc.pl?isbn= 05:39 paul (in french : ami = friend ;-) ) 05:39 chris a miss 05:39 paul amis ? 05:38 rach with marc off there is somethign fairly basic amis with acquisitions 05:38 paul that i haven't done. 05:38 paul I agree there are some tests to do with MARC=off 05:38 rach yes that is true 05:38 paul but a 2.2.0RC1 could help translators to speed up the translation process ;-) 05:37 rach but haven't got far with it 05:37 rach we have a copy up and running 05:37 paul just misses some translations (turkish...) 05:37 paul nelsonville seems to be able to play with it too. 05:37 paul 2.1.3 works fine at EMN 05:37 rach :-) 05:37 paul (unless too many problems with RC1. but i'm not afraid of this) 05:36 paul then an official 2.2.0 at dec, 1 05:36 rach that is great 05:36 paul i planned to have a 2.2.0RC1 at the end of this week. 05:36 rach certainly 05:36 paul do you have a few minuts to speak of release date ? 05:35 paul hi rach 05:35 rach hello 05:35 si wool going into the walls 05:35 si ahh, todays photos are up 05:35 paul (i remember seeing the gallery/rennovation link a few days before. 05:34 chris im using a laptop in my lounge watching tv at the moment 05:34 si it's really loud when the builders start up 05:34 si I'm thiking about it 05:34 chris irc at home 05:34 si http://pure-guava.org.nz/gallery/rennovation 05:34 paul so you sleep at work ? 05:34 si paul: we're getting our house renovated at the moment 05:33 si I've just walked the dogs 05:33 si it's hardly work 05:33 paul so it's a bot that writes for you ? 05:33 si and contemplating playing with asterisk 05:33 si maybe chris is working 05:33 paul what are usual work hours in NZ ? 05:32 paul 9PM and you're all 3 still at work... 05:32 paul exactly 12H differences ;-) 05:32 si so you're a simple am<->pm shift away 05:32 si that's easy, we're +13 05:32 paul ok, i stay close. I want to speak of 2.2 release date 05:31 si paul: she's a few minutes away from her pc 05:31 paul (i'm GMT+1 for 5 months : it's 9:30AM here) 05:31 paul good evening chris (morning for me) 05:31 paul (ok, thanks) 05:31 chris hi paul 05:31 si (shouts) 05:31 paul Hollers ??? 05:31 paul Hi simon 05:31 si she's about somewhere 05:30 si hiya paul 05:30 paul (chris, same question) 05:30 paul rach, are u here ? 21:41 tungsten time to reload... 21:40 tungsten thanks 21:40 tungsten I'll ask the list 21:39 chris im not sure how people have been doing it, it would be a good question to ask 21:39 chris you could do it all with RFID without having to even move :-) 21:38 chris ahhh right 21:38 tungsten notwithstanding the item count thingy being goofy 21:37 tungsten is it done on a palm? laptop with a barcode reader practical things like that 21:37 chris inventory? 21:36 tungsten also of interest is the inventory method 21:35 chris also, joshua and owen from Ohio might be able to take some pictures also 21:35 tungsten great 21:35 chris im fairly sure she'll let me wander around with my digital camera :) 21:35 chris ill ask rosalie what she thinks, (rosalie is the head librarian at HLT, the first Koha install ever) 21:34 tungsten what kind of reader etc. 21:34 chris right 21:34 tungsten I'm interested in the barcode reader set up i.e. pictures of the computer and where the barcode reader hooks in 21:34 chris we could do something like that, there are lots of opacs around, but we could probably take some screen shots of the librarian interface 21:34 chris of the librarian interface? 21:33 tungsten it might be nice to show pictures of a system which is running koha 21:32 chris no, im in new zealand 21:31 tungsten are you in ohio? 21:31 chris yes? 21:31 tungsten one more thing 21:30 tungsten I need to drop 123 and change my 852's to 952's load 2.0.1 and then I can repotr 21:30 tungsten I need to drop 123 and change my 852's to 952's and then I can repotr 21:29 chris works fine? 21:29 chris select * from itemtypes where itemtype='AF'; 21:29 chris so 21:28 chris ahh ok 21:28 tungsten no branch MAIN itemtype AF 21:28 chris ie there will need to be an entry in the itemtypes table for AF 21:27 tungsten and look at the database 21:27 chris and a branch AF? 21:27 chris do you have an itemtype AF set? 21:27 tungsten I'll run it again 21:27 tungsten however no item count 21:26 tungsten I set the holding brach and item type to AF I then run marc check all is well 21:25 chris if it is empty, then either the parameters arent set right, or bulkmarcimport has a bug 21:24 chris one thing to check is after you have run the import, is biblioitems.itemtype not empty ie is it getting set 21:24 tungsten be patient 21:23 tungsten do I need to look at this anohter way 21:23 chris no, just i didnt write bulkmarcimport .. so i cant answer 21:23 tungsten then my question is wrong? 21:22 chris i dont know 21:22 tungsten what tag is the bulkmacr import looking for 21:21 tungsten there was just another post today on help list about this item type not working I know types are defined in my 008 tag 21:21 chris does that help? 21:21 chris and those branches should match something in the branch table also 21:20 chris | L | C | 21:20 chris | L | L | 21:20 chris +---------------+------------+ 21:20 chris | holdingbranch | homebranch | 21:19 chris +----------+--------------+------------+-----------------+--------------+------------+------------+ 21:19 chris | BF | Free Fiction | 21 | 1 | 0.0000 | NULL | book | 21:19 chris +----------+--------------+------------+-----------------+--------------+------------+------------+ 21:19 chris | itemtype | description | loanlength | renewalsallowed | rentalcharge | notforloan | publictype | 21:19 chris +----------+--------------+------------+-----------------+--------------+------------+------------+ 21:19 chris select * from itemtypes where itemtype='BF'; 21:18 chris | BF | 11 | 21:18 chris | BF | 5 | 21:18 chris +----------+------------------+ 21:18 chris | itemtype | biblioitemnumber | 21:18 chris +----------+------------------+ 21:16 chris for eg 21:16 chris also check the itemtypes table .. to make sure that what is in biblioitems.itemtype matches something there 21:16 chris and check items.holdingbranch 21:16 chris then check the items table 21:16 chris check that they all have something set in biblioitems.itemtype 21:15 chris then look at the biblioitems table in koha 21:15 chris is a bulkimport 21:15 chris so what i would try to do 21:15 chris there is no bulkimport for nonmarc tho 21:15 tungsten could I take my marcs and transform them into non-marc using xml 21:14 chris in that install anyway 21:14 chris just the non-marc acquisitions 21:14 tungsten what then 21:14 chris we dont use marc 21:13 tungsten are item types in your marc and of so what tag 21:13 tungsten nice 21:13 chris that was just a page showing the itemcount working 21:12 tungsten I opened the url there a re two pages of docs which one? 21:10 chris i think so, it may be a bug in C4::Biblio that isnt setting the holdingbranch though 21:10 tungsten is that done in parameters and marc-tag struture 21:10 chris http://library.katipo.co.nz/cgi-bin/koha/opac-searchresults.pl?author=Terry%20Pratchett thats a 2.0.1 install 21:09 tungsten I then use marc2xml and do bulk import 21:09 chris the count in 2.0.1 depends on the itemtype and the holdingbranch being set in koha 21:09 tungsten I'm pretty facile in using macr2xml then sed for search and replace 21:08 chris 1.2.3 also set the holdingbranch properly 21:08 chris yep 21:07 tungsten 123 gets around this by using if then else on the deweys in 852 holding if numeric JNF if not fic 21:07 chris then the itemcount wont work 21:07 chris you could look in your items table, and if items.holdingbranch is null 21:06 tungsten my marc does not support item types 21:06 chris i suspect the no itemcount is because holdingbranch isnt being set 21:06 tungsten really I'd like to go with 2.0.1 but same thing as six months ago I can't get around the no item count number 21:05 chris actually i lie, i dont think any is templated in 1.2.3 21:04 tungsten no koha-devl 21:04 chris only the opac is fully templated in 1.2.3 21:04 emiliano ok 21:03 tungsten where is the template in 123 21:03 chris thats cool, are you on the koha-devel list tungsten? 21:03 tungsten I read the license user account or regisration is not required 21:02 chris right, so its just a template change? 21:02 tungsten http://www.amazon.com/exec/obidos/ASIN/<!--TMPL_VARNAME="isbn"--> 21:02 emiliano Chris, for using this Amazon's API you need an Amazon account isn't it or it's access free? 21:01 chris cool, you'll need to talk to paul poulain, (the 2.2.x release manager about that) 21:00 tungsten I'd like to add own's script to add amazon to opac search 20:59 chris hi tungsten 20:59 chris id offer to help, but i know very little spanish 20:59 emiliano hi tungsten 20:59 tungsten hi 20:59 emiliano :-( 20:59 emiliano we modified many things 20:58 emiliano we need to start english translation for 2.4 templates 20:58 emiliano yep 20:58 chris just need to make a different set of html::templates 20:58 emiliano wonderfull! 20:58 chris ie, instead of maori, it could be WAP .. or no graphics .. or something so ppl can look at it on their cellphone 20:57 chris ah yes, we've only translated a little bit of it, that was to show how its possible to let the patron choose their language .. or their theme 20:57 emiliano :-) 20:57 emiliano how many K's!) 20:56 emiliano (I was looking Katipo's OPAC in maori 20:56 emiliano :-( 20:55 emiliano but today, no success 20:54 emiliano I've tried to interest our local editor organizations 20:54 chris i think only amazon and barnes and noble have accessible API's 20:54 chris nope, you would have to screen scrape 20:53 emiliano but not implemented over SOAP isn't it? 20:53 chris or http://www.dymocks.com.au/ in australia 20:53 chris those are certainly the big two, .. some smaller bookstores in new zealand have some of their catalogue online .. whitcoulls.co.nz is one 20:51 chris hmm 20:49 emiliano today I've only found Amazon & Barnes-Noble 20:49 emiliano ...if any editor has implemented... 20:48 chris yes i think you are right 20:48 emiliano I was thinking that could be done via webservices 20:48 chris that would be a very useful thing 20:48 chris ahh yes 20:48 emiliano for adquisitions module 20:48 emiliano was about obtaining price lists 20:47 emiliano one of their requirements 20:47 chris cool 20:47 emiliano talking about MARC21 and Koha 20:46 emiliano I was there about a month ago 20:46 emiliano yep! 20:46 chris then it will be time to start a south america koha users group :-) 20:45 chris ohh cool 20:45 emiliano from Bolivia 20:45 emiliano us 20:45 emiliano another SouthAmerican institution will join 20:45 chris cool, i think we can extend this quite easily ... the worldcat idea sounds great too 20:45 emiliano I think next year 20:44 emiliano it's wonderfull 20:44 emiliano I have seen it 20:44 emiliano Yes 20:44 chris i have a script that fetches the average rating from amazon and stores it in koha, that you can run as a cron job 20:43 chris http://library.katipo.co.nz/cgi-bin/koha/opac-detail.pl?bib=50 20:43 chris speaking of the webservices 20:43 chris yeah, i dont think it lets you map more than one field currently 20:43 emiliano but 110,111,710 or 711 20:42 emiliano for example 20:42 emiliano 700$a 20:42 emiliano and aditionallauthor 20:42 emiliano 100$a 20:42 emiliano sorry 20:42 emiliano 100^a 20:42 emiliano I mean biblio.author could be 20:42 chris yeah 20:42 emiliano but the problem is that you could map only one subfield 20:42 chris so i think it would be possible, just isnt currently 20:42 emiliano yep 20:42 chris thats how koha stores more than one author 20:41 chris | Wolfe, Ralph | 9 | 20:41 chris | Loveday, Evelyn V. | 9 | 20:41 chris +------------------------+--------------+ 20:41 chris | author | biblionumber | 20:41 emiliano Amazon, Barnes & Noble and so on 20:41 emiliano I find very interesting the actual discussion related to webservices 20:40 chris ahh right 20:40 emiliano we made a turnaround making local MARC fields 20:39 emiliano but want to be sure 20:39 emiliano I have seen the database but could not find, think it's impossible 20:39 chris so it should be possible, but i dont think its been set up 20:38 chris i dont think there is, paul will know for sure, additionalauthor is a repeatable field in the koha db 20:38 emiliano and so on 20:38 emiliano 100 or 110 20:38 emiliano (I have records with 100,110,111,700,710,711 that should be mapped to biblio.author or biblioaditional) 20:37 emiliano to a Koha field? 20:37 emiliano Chris, do you know if is there a way to map more than one MARC subfield 20:36 chris :-) 20:36 emiliano needing vacations!!! 20:35 chris doing good thanks, getting back into work still after my months vacation .. how are you? 20:35 emiliano Hi Chris how're you? 20:34 chris hiya emiliano :) 20:34 emiliano Hi everybody 20:15 chris back now joshua, so whenever u get time 18:23 kados I'd like to discuss amazon/worldcat/gutenberg possibilities if possible 18:23 kados chris I will be around a bit later today 17:16 rosa may your day be caffeine enriched 17:15 chris right, i must go drink coffee before my meeting at 10 now, back later .. have a good evening ohioites and a good morning rosalie :) 17:15 chris ohh, good idea also 17:15 owen Joshua and I were talking this morning about how to provide links to available Gutenberg online texts from Koha 17:14 chris i think the worldcat idea is a good one also 17:13 chris i was just showing joshua and owen this http://library.katipo.co.nz/cgi-bin/koha/opac-detail.pl?bib=50 17:13 rosa hi chris 17:13 chris morning rosa 17:12 chris thanks :) 17:11 owen Works in Firefox 1.0, IE6, and Opera 7 on my PC 17:09 chris work ok in ur browsers? 17:08 chris http://library.katipo.co.nz/cgi-bin/koha/opac-detail.pl?bib=50 17:08 chris just the amazon ratings thingy, bob did some tricky html stuff i dont quite understand, with divs to make the right number of stars show 17:05 chris http://library.katipo.co.nz/cgi-bin/koha/opac-detail.pl?bib=35 17:03 chris joshua/owen either of u about? 14:08 owen Makes sense to me. It should be fairly simple to break it down to MARC fields. You'll have to figure out what the gamut of headings are, and how they match to MARC. 14:04 kados and we could build it into Koha to automatically do this nightly :-) 14:03 kados the gutenberg catalog that is (not netlib) 14:03 kados it won't have everything but it should work 14:03 kados I bet I can write a script to parse through their catalog and build a bulk marc import file 14:02 kados right and they've only got 3400 titles 14:02 owen But that's for *their* catalog. 14:01 kados hmmm : http://www.netlibraryebooktoolkit.com/marc/marc_publicsets.asp 13:58 owen I'll bet someone out there has already cataloged them. 13:58 kados I thought there were more than that 13:58 kados actually 13,000 isn't bad either 13:57 kados wow ... 13 items isn't bad ;-) 13:57 owen "more than 13.000" items 13:57 owen Create a MARC record for it. 13:57 kados but the database is HUGE 13:57 owen I guess you could catalog each of their e-texts as a www resource 13:57 kados right I thought about that 13:56 owen Unless you want to actually merge their catalog with ours. 13:56 owen Well, that's where the link on the search results page could come in 13:55 kados it'd be nice to offer items that we don't have in the library in electronic format 13:54 kados right 13:54 owen Multiple isbn's could relate to a single e-text 13:54 kados hmmm 13:54 kados yea that's true 13:54 kados er ... EText-no 13:54 owen The trouble is that isbn is edition-specific. 13:53 kados that's e-book # 13:52 owen wow, they even have digitized sheet music! 13:52 kados there's no keyword search 13:52 kados again, for title and author searches 13:52 kados we could also display a "perform this search on project gutenberg to find relevant e-book results" link on our main opac search results page 13:50 owen http://www.gutenberg.org/feeds/today.rss 13:50 kados so we could add a link to the details page for items that queries project gutenburg based on title and author 13:50 owen Hey, Gutenberg even has an RSS feed for adds and updates 13:08 kados will do 13:08 paul good idea. Tell me the answer if you get one, and if amazon.fr may be concerned 13:07 owen I don't know anything about it, paul 13:07 paul you speak of cpan search::amazon package ? 13:07 kados I emailed amazon to find out about legal ramifications of grabbing images, etc. 13:07 kados yea it's interesting stuff 13:07 owen The Amazon question sure got lots of attention. 13:06 paul hi owen 13:06 owen Hi 13:06 kados hey owen