Time  Nick  Message
12:32 paul  g'morning owen
12:32 owen  hi paul
12:32 owen  Congratulations on your latest release!
12:43 owen  I'm looking at the OPAC in Internet Explorer today.  I'll be filing some bugs for me to look at later.
12:43 owen  So far it looks pretty good.
13:10 kados hey owen
13:11 owen  Hi
13:11 paul  hi kados
13:11 kados hi paul
13:11 owen  Did you do an update this morning, joshua?
13:11 kados no but I was working on 101 quite a bit yesterday
13:11 kados I wrote an amazon module Amazon.pm
13:12 kados have you done any searches lately?
13:12 kados check out the details page
13:12 kados hmmm
13:12 owen  I was just looking at the css templates in Internet Explorer, so I probably didn't see what you were doing--you were using the npl templates?
13:13 kados erp ... no actually I had replaced the css templates with the npl templates temporarily
13:13 kados did you overwrite them this morning?
13:13 owen  So that's why 'css' looks like npl, and css.old has the the css templates?
13:13 kados yep
13:14 kados http://66.213.78.101/cgi-bin/koha/opac-detail.pl?bib=16595
13:14 kados all that amazon stuff is generated on-the-fly ...
13:15 kados I've still got a few features to add (like book reviews)
13:15 kados I was going to work on that this morning ...
13:15 owen  So what part of it is Amazon?  The list price, obviously, and what, all of the description information?
13:16 kados yea list price, image, description, and the link to the amazon detail page for that item (it's in two places, the image links there and the Amazon link too)
13:17 kados the image is no-longer served up by our server
13:17 paul  do you know if such a package is amazon.fr compatible ?
13:17 kados paul when I've finished the rest of the variables I will MAKE it amazon.fr compatible ;-)
13:17 kados but it should be by default
13:18 kados yep ...
13:20 owen  There's a specific format for Amazon associates links, by the way, if we're going to be setting that up for the library.
13:21 owen  Here's an example from my site:
13:21 owen  http://www.amazon.com/exec/obidos/ASIN/0415161347/thelittleczechpr
13:21 kados yep ... that's actually already done ...
13:21 kados except that I'm pulling stuff out in xml
13:21 kados oops I misread
13:22 kados no i haven't done that yet
13:22 kados the link isn't quite there yet ...
13:22 owen  The last part of that url is the Amazon Associates id
13:22 kados right ...
13:22 kados I've got bigger probs atm ... like references to hashes to arrays :-)
13:26 paul  oups..
13:26 paul  sorry.
15:28 kados pauldiner around?
15:28 kados or paul? :-)
15:33 kados how about chris?
15:33 kados I have a data structure like this: $VAR1 = {'Details' =>
15:33 kados                [{'SimilarProducts' => {'Product' => [
15:33 kados                '0553380958','0380977427', etc.
15:34 kados and I need to get Product into a TMPL_LOOP
16:03 tim   I just set up a different system yesterday and it gives me a 500 Internal Server Error after the Koha splash screen.
16:03 owen  What does the error log say?
16:04 owen  look at /usr/local/koha/log/koha-error_log
16:05 tim   [Wed Dec  8 12:38:10 2004] [error] [client 192.168.1.152] Premature end of script headers: /usr/local/koha/intranet/cgi-bin/mainpage.pl
16:06 owen  Anything above that?  That's the generic message that is tagged on to most error messages.
16:06 tim   Just the error saying it can't find favicon.ico
16:07 owen  Brand new install?  No parameters set yet?
16:07 tim   I haven't messed with permissions yet.
16:10 tim   Permissions are 755.  What should they be?
16:10 tim   Owner and group are both www-data
16:11 owen  I think that sounds right.
16:11 owen  Are you sure there's nothing else in the log?
16:11 tim   That's all in the Koha logs.  I'll check the apache logs...
16:13 tim   I just have errors from starting apache.
16:13 tim   [Wed Dec  8 12:36:44 2004] [error] (2)No such file or directory: mod_mime_magic: can't read magic file /etc/apache/share/magic
16:13 tim   [Wed Dec  8 12:36:45 2004] [error] (2)No such file or directory: mod_mime_magic: can't read magic file /etc/apache/share/magic
16:13 tim   and some notices.
16:24 tim   mysql wasn't started, but that wasn't the only problem because it's still not working.  I forgot how to get it to start on boot.
16:24 tim   I thought I had that in my notes.
16:25 paul  kados, i'm back
16:26 paul  salut JYL57
16:28 tim   I think I got that problem fixed.  Rebooting to test it.
16:34 kados paul here's my problem:
16:34 kados http://www.inkdroid.org:8888/244
16:34 kados (this is a pastebot)
16:35 kados if you could take a look I'd be eternally grateful :-)
16:46 paul  (was with wife on phone)
16:48 paul  kados, what's your problem ? it does not work ?
16:51 paul  kados, i think you miss the 'SimilarProduct' level.
16:52 paul  it's a hash-array-hash-hash-array
16:52 paul  and you loop on
16:52 paul  hash-array-hash-array !
16:52 paul  misses 1 hash, SimilarProduct
16:52 paul  HTH
16:53 kados ok ...
16:53 kados I'm working on it now
17:00 owen  tim, any luck?
17:01 tim   Nope.  Still trying to get mysql to start on boot.  Then I'll work from there.
17:06 kados hehe ... check this out:
17:06 kados http://66.213.78.101/cgi-bin/koha/opac-detail.pl?bib=16595
17:06 paul  great !
17:06 kados check the "similar products" section ... those are isbns just waiting to be tweaked into a search url :-)
17:07 kados or passed to opac-detail.pl
17:07 paul  just searching in the catalogue if you have similar products isbn
17:07 paul  and add a link to them if yes !
17:07 kados yep
17:07 kados hehe
17:07 kados now to get those reviews ...
17:07 paul  do you know how search.marc works ?
17:08 paul  owen want to know how search marc works  ?
17:08 owen  yes!
17:08 paul  koha/opac-search.pl?op=do_search&marclist=bibliosubject.subject&and_or=and&operator=contains&value=ENFANT
17:08 paul  op=do_search is to tell you want to search
17:08 paul  marclist=XXXX contains a MARC or a non MARC field (like biblio.title or 245f)
17:09 owen  just one?
17:09 paul  and_or should always be and
17:09 paul  in a GET http request yes
17:09 paul  (maybe could be done in another way. anyway, you can pass an array of marclist, and_or, operator...)
17:09 paul  let me continue :
17:10 paul  operator can be : =, >,<,<=,>=,start, contains
17:10 paul  value is the value you want to search
17:10 paul  and that's all !
17:10 paul  so for amazon, it's :
17:10 paul  marclist=biblioitems.isbn&and_or=and&operator==&value=<TMPL_VAR name="amazonisbn">
17:11 kados hehe put a <TMPL_IF> in front of that and we're good to go :-)
17:11 paul  yep
17:11 kados sweetness!
17:11 paul  kados : did you test Koha with mod_perl or plan to ?
17:12 kados paul: our next server is running mod_perl
17:12 paul  next is ?
17:12 kados but I haven't tested it yet ... too busy with stuff
17:12 kados 2.2
17:12 paul  ok
17:12 kados opac.athenscounty.lib.oh.us
17:12 kados it's working but no data yet
17:13 kados (and ssl certs too :-))
17:13 paul  but anyway, i think the best perf improvement will be reached with marc_words index of index table
17:13 kados right ... so one instance of each marc_word with an array of bibids with that word and where .. is that what you mean?
17:14 paul  yes
17:14 paul  (will also solve FindDuplicate perf problem)
17:14 kados right ...
17:14 kados is that slated for 2.4?
17:14 paul  yep
17:14 kados cool
17:14 paul  but i'm a little afraid : i've too much succes here in France
17:14 kados I'll commit our self-checkout, Amazon.pm for 2.4 too
17:15 paul  & will be overwhelmed soon...
17:15 kados hehe
17:15 paul  i'm trying to hire a friend
17:15 kados maybe time to charge more :-)
17:15 paul  (henri damien laurent, that works on Koha a little 2 years ago)
17:15 paul  in fact, i've 2 libraries to migrate (40000 & 13000 items)
17:16 paul  + SAN Provence & my travel to npl in january probably
17:16 paul  + a travel in ouagadougou in februrary
17:16 paul  + the stat module for EMN
17:16 paul  + a BIG RFP with another company : 300 000¤ budgeted, 35000 for me
17:16 paul  + 4 other RFPs on the way
17:17 paul  + 2 RFP that are 100% sure but libraries are waiting for budget...
17:17 paul  Burkina faso capital
17:17 kados wow!
17:17 paul  i forget to add : change my www.koha-fr.org server !
17:43 tim   I got mysql to start on boot.  Now I just need to track down the error on the Koha pages.
17:51 tim   Here are some errors from /var/log/apache/suexec.log
17:51 tim   [2004-12-08 14:50:05]: info: (target/actual) uid: (nobody/nobody) gid: (nogroup/nogroup) cmd: opac-main.pl
17:51 tim   [2004-12-08 14:50:05]: error: command not in docroot (/usr/local/koha/opac/cgi-bin/opac-main.pl)
17:52 tim   [2004-12-08 14:50:14]: info: (target/actual) uid: (nobody/nobody) gid: (nogroup/nogroup) cmd: opac-main.pl
17:52 tim   [2004-12-08 14:50:14]: error: command not in docroot (/usr/local/koha/opac/cgi-bin/opac-main.pl)
17:52 chris ahhh you are running it under suexec tim?
17:52 chris that will be why its not liking it
17:52 tim   heh.  idunno.  I just installed Debian and did a dist-upgrade.
17:52 chris command not in docroot
17:53 chris right
17:53 chris probably fastest fix is to turn suexec off
17:54 tim   How do I do that?
17:54 rach  anyone here from canada?
17:54 chris umm i dunno :-) ill go look at the apache manual
17:55 chris either that or we change the docroot, but that might just cause more problems
17:55 chris :)
17:56 kados hehe check this out!
17:56 kados http://66.213.78.101/cgi-bin/koha/opac-detail.pl?bib=16595
17:56 kados or any item on our catalog
17:56 kados "read inside this book"
17:56 kados hehe
17:56 chris cool joshua
17:57 tim   I can check the apache manual.  Just figured it would be easier to ask if you already knew.
17:57 kados :-)
17:57 chris i think u need to move the suexec binary, and restart apache
17:57 kados paul still around?
17:57 paul  yep
17:58 paul  10PM in France, so not here for a long time...
17:58 kados I'd like to put together that TMPL_IF for the similar items
17:58 kados here's what I have currently:
17:58 kados <!-- TMPL_IF NAME="SIMILAR_PRODUCTS" -->
17:58 kados <tr><th>Similar Items:</th><td><ul><!-- TMPL_LOOP NAME="SIMILAR_PRODUCTS" -->
17:58 kados <li><!-- TMPL_VAR NAME="Product" --></li><!-- /TMPL_LOOP --></ul></td></tr>
17:58 kados <!-- /TMPL_IF -->
17:58 rach  hi paul
17:58 rach  sorry about last week
17:59 paul  hello kaitiaky
17:59 rach  it all fell apart a bit here
17:59 kados so I only want them to display if we have the isbn in the catalog
18:01 paul  what is your question exactly ?
18:01 paul  to do that, you need to do a select count(*) from biblioitems where isbn=?
18:02 paul  count if there is a result
18:02 owen  that means querying the database for each of them before the page loads--seems like that would be a drag!
18:02 kados yea might be ...
18:02 paul  if you don't add an index on isbn, you're right
18:03 paul  otherwise, i don't think it would be too cpu consuming
18:03 paul  (BUT : for instance, no index on isbn !!!)
18:03 paul  i don't see another possibility !
18:03 paul  you improve the cpu usage doing
18:04 paul  select isbn from biblioitems where isbn in [isbn1,isbn2...]
18:04 rach  are you wanting to just display that text, only if there are similar items?
18:04 paul  the idea rach, is to show similar items that are on amazon.com, but only if they are available in the library
18:04 rach  ah I see
18:05 paul  really a killer feature...
18:05 rach  tricky
18:05 paul  look at the link below (66.213...)
18:05 paul  works fine with all isbns returned by amazon
18:05 rach  http://66.213.78.101/cgi-bin/koha/opac-detail.pl?bib=17071
18:05 rach  that's the one I was lookinga t
18:05 paul  in fact, i think the slowest thing is the time to query amazon.com !!!
18:06 rach  you would think so
18:06 rach  that's an html thing I suspect?
18:09 kados this module only grabs one file per details page from amazon
18:09 kados then it uses xml::simple to parse and display that file
18:09 kados I need to add a timeout but I'm not sure how
18:10 kados my $content = get($url);
18:10 paul  yes kados, but querying a webserver requires at least some dozens of ms
18:10 paul  so, much more than a sql query !
18:10 kados ahh
18:11 chris its very dependent on ur connection too
18:12 kados right ... well since we have a T1 it's not too bad ... but I should expand the module to cache data locally
18:12 kados problem is the terms of use for cacheing data is pretty complex
18:12 chris yeah
18:12 chris what you might need to do is make it a 2 step process
18:12 kados when I finish making all the variables available I'll need to do
18:12 chris 1/ show plain opac-detail page
18:12 kados a small config file that has
18:13 chris with a button the user can click, that says fetch me amazon data
18:13 chris and some help to say this might be slow
18:13 chris then they click that and get the same page again, but with the amazon data
18:13 paul  'morning chris
18:13 kados dev id, associate id, light or heavy, data desired array,
18:13 chris morning paul congrats on c4
18:13 paul  good idea from chris
18:13 kados chris: right
18:13 paul  ('night for me chris ;-) )
18:13 chris :-)
18:14 paul  (going to bed really soon : 10:30 in a quarter)
18:14 kados so basically I could just copy a opac_detail.pl with extra data
18:14 chris yeah
18:14 kados so opac_amazon_detail.pl
18:14 kados and tmpl
18:14 paul  no need to copy :
18:14 kados and then have a link on opac_detail.pl
18:14 chris or call opac_detail.pl with another param
18:14 paul  just add a <!-- TMPL_IF name="amazon_datas" --> link
18:15 kados ahh good idea
18:15 chris eg opac_detail.pl?amazon=yes&bib=etc
18:15 kados ok ... I'll think on it but for now Ive gotta get the rest of these variables out there
18:15 kados I"m still slow on the refs of hashes of arrays of hashes :-)
18:16 paul  of hashes ;-)
18:16 chris of arrays
18:16 chris :)
18:17 tim   I deleted /usr/lib/apache/suexec and restarted apache and the logs say it still loaded suexec ok.
18:18 chris how mad
18:26 tim   It must've cached the file.  How would I fix that without rebooting?
18:26 tim   I already rebooted, but would like to know for next time.
18:34 chris try a full stop then start of apache, not just a restart
18:39 kados does our current search model allow that?
18:39 kados oops
18:39 kados :-)
18:40 kados so I'd like to do a search on multiple isbns in koha ... is that possible?
18:42 kados something like:
18:42 kados marclist=biblioitems.isbn&and_or=or&operator==&value=0553380958&value=0380977427
19:09 JYL57  Paul still awake ?!
19:10 JYL57 Ok, chat with you tomorrow...
19:10 JYL57 bye !
19:11 JYL57 And nice RC4 as far as I can see... :-D
19:14 tim   thanks chris.  I'll try that next time.
19:14 tim   If I remember.
19:18 kados chris:
19:19 kados http://kados.org/struct.txt
19:20 kados I'm trying to parse that data, specifically AvgCustomerRating
19:20 kados for now
19:20 kados foreach my $result (@{$amazon_details->{Details}}){
19:20 kados         $template->param(rating => $result->{AvgCustomerRating}->{ 0 });
19:20 kados }
19:20 kados $amazon_details = $VAR1
19:29 kados sweet I got the amazon item rating working:
19:30 kados http://66.213.78.101/cgi-bin/koha/opac-detail.pl?bib=16595
19:32 owen  I wonder how chris handled that?  I'd guess round it up or down and use it to build an img tag
19:43 kados owen I also added a link to the "see inside this book" and changed the image appropriately
19:44 kados erp I took away the link and made the book link there
19:44 kados s/book/book image/
19:54 owen  :( Hate the way the Amazon graphic looks on our page.  But I'm being to negative! :)
20:12 kados chris could you take a look at this:
20:12 kados http://kados.org/struct.txt
20:12 kados my @reviews;
20:12 kados for my $details( @{ $amazon_details->{ Details } } ) {
20:13 kados next unless $details->{ Reviews };
20:13 kados  for my $reviews ( @{ $details->{ Reviews }->{ CustomerReview } } ) {
20:13 kados                 push @reviews, +{ CustomerReview => $reviews->{ Comment }};
20:13 kados         }
20:13 kados }
20:13 kados $template->param( REVIEWS => \@reviews );
20:13 kados it's driving me nuts!
20:14 kados http://kados.org/struct.txt is the data dumper for this object ... I'd like to be able to loop through each customer review awith summary, comment and rating
20:29 kados chris and everyone: add <img src="http://images.amazon.com/images/P/<!-- TMPL_VAR name="isbn" -->.01.THUMBZZZ.jpg" /> to the opac-searchresults.tmpl to display a small graphic for each result!
20:30 kados http://66.213.78.101/cgi-bin/koha/opac-search.pl
21:57 kados clickable gutenberg e-texts make their way into NPLs catalog:
21:57 kados http://66.213.78.101/cgi-bin/koha/opac-detail.pl?bib=147526
04:54 paul  monsieur lemaire, mes salutations du matin
04:58 JYL57 salut Paul
04:58 JYL57 Suis au téléphone...
05:09 JYL57 Paul, I'm back
05:09 paul  et moi je suis tjs là