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