← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 12:37 | paul | g'morning owen |
| 12:37 | owen | hi paul. |
| 12:37 | I see lots of bug activity from you! I'll try to get Joshua to update our test machine today so I can confirm those. | |
| 12:37 | kados: are you online? | |
| 12:37 | JYL57 | hello paul, owen |
| 12:37 | paul | joshua was here at 3AM (your hour) |
| 12:38 | so i think he's sleeping ;-) | |
| 12:38 | owen | I hope so! |
| 12:38 | paul | salut jean yves, j'ai vu ton patch |
| 12:38 | JYL57 | yep |
| 12:40 | paul | c'est quel fichier exactement ? |
| 12:40 | ok, j'ai trouvé | |
| 12:41 | memberentry.tmpl | |
| 12:41 | JYL57 | oui, c'est �� |
| 12:41 | paul | c'est quoi la modif, parce que là, il y a bcp de lignes |
| 12:41 | à cause de l'indentation | |
| 12:41 | JYL57 | autre bug suspecté dans Rapport 'Issues by borrower categeory' |
| 12:42 | cherche 'categorie' | |
| 12:43 | paul | ?? pas trouvé ?? |
| 12:43 | JYL57 | ligne 112 |
| 12:43 | le search ne marche pas chez moi non plus... ?! | |
| 12:43 | paul | pardon ? |
| 12:43 | JYL57 | sorry :catégorie |
| 12:44 | ajouter <!-- TMPL_VAR NAME="catcodepopup" --> | |
| 12:46 | c'est ok ?! | |
| 12:47 | paul | ok, en fait, c'est une erreur de traduction |
| 12:47 | je viens de corriger | |
| 12:47 | dans kartouche. | |
| 12:47 | c'est quoi l'autre bug dans issues by borrower category ? | |
| 12:47 | JYL57 | compris |
| 12:48 | les valeurs sont dans (colonne-1) | |
| 12:49 | paul | tu veux dire pas dans la bonne colonne ? |
| 12:49 | JYL57 | exactement |
| 12:49 | paul | mmm... sur la base de l'EMN ca m'a l'air tout à fait bon |
| 12:49 | JYL57 | je vérifie en ce moment... |
| 12:50 | paul | (en tous cas, c'est pareil en FR et en EN, donc c'est pas un pb de traduction !) |
| 12:50 | JYL57 | right, j'ai vérifié |
| 12:53 | paul | ok j'ai aussi corrigé le pb de additem |
| 12:53 | JYL57 | good ! |
| 12:53 | paul | owen, your opinion : release a RC5 today |
| 12:53 | JYL57 | on va pouvoir revenir au français alors ! |
| 12:53 | paul | (with 4 bugfixes only, but important in french) |
| 12:53 | or wait a little to have more ? | |
| 12:54 | JYL57 | Paul, I'm sure about problems in the 'Issues by borrower category' report ! |
| 12:54 | owen | I think yes, because it sounds like other people on the list are having problems with searching similar to us. |
| 12:54 | JYL57 | the values aren't in the good columns |
| 12:54 | paul | JYL57 : you can fix the pb in template additem.tmpl |
| 12:54 | replace Confirmez-vous la suppression de l'ouvrage | |
| 12:55 | by Confirmez-vous la suppression de l exemplaire (REMOVE the ') | |
| 12:55 | JYL57 | Yes, Paul we can wait on here |
| 12:55 | Ok, thanks | |
| 13:04 | Paul, another one... In the category admin in parameters, koha asks for a categorycode = I (I for Institutions) should we keep a I category ?! | |
| 13:16 | paul | JYL57 : no |
| 13:17 | mais I est utilisé pour les entreprises qui ont des salariés qui ont des cartes d'entreprise | |
| 15:59 | kados | paul around? |
| 16:00 | owen aroudn? | |
| 16:00 | around even? | |
| 16:00 | looks like your connection is a bit better today | |
| 16:02 | owen | Yeah, did you hear about what work they did last night? |
| 16:03 | kados | they? you mean me? |
| 16:03 | hehe | |
| 16:03 | there was a distributed attack on your subnet | |
| 16:03 | owen | Oh, they said THEY did it |
| 16:03 | kados | hehe |
| 16:03 | well we did it together | |
| 16:03 | they have a nifty network monitor to watch packets on | |
| 16:04 | so we closed up some of the ports on our 1600 router | |
| 16:04 | so the attack won't get through | |
| 16:04 | so are things fast now? | |
| 16:05 | owen | Much better |
| 16:06 | kados | cool ... there are still a few attacks on that subnet ... |
| 16:06 | so it might even get better | |
| 16:06 | owen | The bandwidth test they used on Monday when they were here shows my current throughput at 146 K, which is better than I'v ever seen it. |
| 16:07 | kados | once I clean up those |
| 16:07 | sweet | |
| 16:07 | yea I guess it wouldn't be that big of a deal except that wireless doesn't do well with small packets like the ones being routed | |
| 16:08 | owen | My connection is looking good just in time for me to go on vacation! |
| 16:08 | kados | hehe |
| 16:09 | owen | Have you done an update on 101 today? |
| 16:10 | Paul's done some bug-fixing and some bug-reviewing and I'd like to confirm some of his changes | |
| 16:14 | kados | I haven't ...actually I was about to ask you if it was ok |
| 16:14 | I'll go ahead and do it | |
| 16:14 | owen | Hold on just a sec |
| 16:14 | kados | righto |
| 16:15 | owen | Okay, all set. I just remembered I wanted to grab a backup of some stuff. Go ahead. |
| 16:28 | kados | ok ... the update's done ... let's test it out (/me crosses his fingers) |
| 16:28 | yay! title's working | |
| 16:28 | looks like we're all good | |
| 16:30 | owen | Great. |
| 16:41 | chris | hi all |
| 16:41 | owen | hi chris |
| 16:45 | kados | hithere chris |
| 16:45 | just in time ... I've a quick question ;-) | |
| 16:45 | chris | :) |
| 16:46 | kados | still working on my secret project ;-) |
| 16:47 | this script isn't working: | |
| 16:47 | http://kados.org/make_suggest.pl | |
| 16:47 | I'm trying to pull out the distinct marc_word words and put them in a seperate datbase | |
| 16:48 | chris | right |
| 16:48 | try values (?,?,?) however many there are | |
| 16:48 | then | |
| 16:49 | kados | well there are 5,000,000 of them ;-) |
| 16:49 | or actually only about 250,000 distinct values | |
| 16:49 | chris | INSERT INTO word (word) VALUES(?) |
| 16:49 | looks ok | |
| 16:49 | but | |
| 16:49 | (my ($word)=$sth->fetchrow_array) | |
| 16:50 | well i guess taht oughta work too | |
| 16:50 | whats the error you are getting? | |
| 16:50 | kados | no error |
| 16:50 | it runs fine | |
| 16:50 | but nothing happens | |
| 16:51 | chris | if you put a print "$word\n"; in ur loop |
| 16:51 | it prints out a pile of words? | |
| 16:51 | (might wanna pipe it to a file) | |
| 16:51 | ./make_suggest.pl > log | |
| 16:52 | kados | no words |
| 16:52 | the script executes in like half-a sec | |
| 16:52 | it should take about 8 mins for the first query | |
| 16:53 | in mysql that's how long the distinct query takes anyway | |
| 16:53 | chris | that means the first query must be wrong :) |
| 16:53 | kados | hehe |
| 16:53 | chris | try select distinct(word) from marc_word |
| 16:54 | kados | ok |
| 16:54 | (it runs from the mysql command line without that line) | |
| 16:55 | chris | hmm |
| 16:55 | kados | nope ... still just exits |
| 16:56 | chris | my $sth=$dbh->prepare($query) || die "cant prepare query"; |
| 16:56 | try that | |
| 16:59 | kados | ahh ... the dbh using context wasn't working |
| 16:59 | I changed it to a tcp connect and it worked | |
| 16:59 | that's weird | |
| 17:00 | chris | permissions thing |
| 17:00 | the user wont be able to read /etc/koha.conf probably | |
| 17:00 | so cant set up properly under context | |
| 17:00 | thats my guess | |
| 17:01 | kados | ahh |
| 17:01 | well when this database is finished my diabolical plans will almost be finished | |
| 17:01 | my brilliant but possibly stupid idea will come to fruition | |
| 17:11 | oh ... it's coming ... just you wait ... | |
| 17:13 | ok ... well it's not done yet ... but I"ve got the demo working | |
| 17:13 | heheheheh | |
| 17:14 | https://opac.athenscounty.lib.oh.us/suggest.html | |
| 17:14 | type a partial word in the box | |
| 17:14 | wait a few seconds | |
| 17:14 | and valla! | |
| 17:15 | the top twenty words in our database that start like that | |
| 17:15 | it's a dumb version of Google Suggest for Koha | |
| 17:15 | chris | hehe cool |
| 17:15 | kados | (but none of the code is based on google suggest) |
| 17:15 | I"ve got several bugs to work out | |
| 17:16 | like instead of the data I'd like to have the times it occurs in the database | |
| 17:16 | etc. | |
| 17:16 | chris | right |
| 17:16 | kados | and I want to limit it to beginnings of words that are greater than three chars |
| 17:16 | chris | makes sense |
| 17:16 | kados | and it'd have to run on a seperate machine |
| 17:17 | (the datbase that is) | |
| 17:17 | like some old 486 or p1 somewhere | |
| 17:17 | no sense wasting good processing time on something this silly | |
| 17:18 | chris | :-) |
| 17:18 | kados | and I need to make it start over when you put a space after the first word |
| 17:18 | chris | right, its silly but neat |
| 17:18 | kados | so it will search for words next to each other in the database |
| 17:18 | that'd take some doing | |
| 17:18 | chris | yeah, that'd be hella tricky |
| 17:18 | kados | maybe just search for more words in the database at first |
| 17:19 | thanks for your help chris | |
| 17:19 | chris | no worries |
| 17:19 | ill expect some stupid pictures for my site in return :-) | |
| 17:19 | kados | owen, wanna try it before I break it trying to add more features? |
| 17:19 | hehe | |
| 17:20 | ok ... when I get it working better I'll email you som escreenshots | |
| 17:20 | owen | Seems to work... Is it picking the top 20 according to ascii order? |
| 17:20 | kados | should be alphabetical ... |
| 17:21 | and it ignores case | |
| 17:21 | owen | Could it show the top 20 most common? |
| 17:21 | kados | sure |
| 17:21 | owen | (actually 20 may be too many) |
| 17:21 | kados | but not yet |
| 17:21 | I need to add a frequency count in the database | |
| 17:21 | that's coming in version 0.000000002 | |
| 17:21 | hehe | |
| 17:22 | owen | It'd be neat to see the hit count like Google has, next to the term. |
| 17:22 | kados | is frequency in the database or frequency of search better? ... the second would be tricky |
| 17:22 | owen | I think you'd have to go with frequency in the database. |
| 17:22 | kados | we'd have to keep track of how many times each marc_word entry was queried |
| 17:23 | owen | Then you'd probably use that data to build up a list of stop-words to start excluding. |
| 17:23 | kados | possible, but we really need better hardware and load balancing to handle that kind of things |
| 17:23 | yep | |
| 17:25 | owen | that XMLHttpRequest stuff is neat. |
| 17:26 | Of course it would be really unusable on a slow connection, but at least it degrades well (if you don't want to wait you don't have to) | |
| 17:27 | kados | right |
| 17:27 | hey chris ... been talking to Ryan Higgins? | |
| 17:28 | chris | nope |
| 17:28 | kados | ahh |
| 17:28 | chris | just saw they had joined the list |
| 17:28 | kados | right ... he's a friend of mine who's interested in Koha |
| 17:28 | chris | cool |
| 17:29 | owen | Is he at O.U.? |
| 17:29 | kados | yea ... he works for the Physics department |
| 17:32 | owen | We'll have to start having Koha Meetups in Athens ;) |
| 17:33 | kados | that'd be sweet |
| 17:47 | owen | So Joshua, now that you're an expert at XMLHttpRequest you can design us a new circ page that doesn't have to reload on every check-out! |
| 17:51 | kados | chris hehe |
| 17:51 | oops sorry chris | |
| 17:51 | I'm not an expert in any way ... that script is a complete hack | |
| 17:52 | but yea ... that should be possible | |
| 17:52 | I'll give it some thought (my brain is fried at the moment) | |
| 17:53 | owen | Something for the furthest burner back |
| 17:59 | Yay, Paul fixed Bug 858! | |
| 17:59 | That was one of the biggies. | |
| 18:01 | And Bug 841, too | |
| 18:08 | Looks like I'll have to revise my top 5 list | |
| 18:32 | kados | 851 too, eh? |
| 18:33 | owen | Yeah, 'cause you fixed it ;) |
| 18:34 | kados | oh... I got my numbers switched up |
| 18:34 | :-) | |
| 18:45 | rach | hello |
| 18:45 | owen | hi rach |
| 19:16 | ambrose|w | hi. does anyone know whether the koha wiki non-public now? or is there a config problem? |
| 19:18 | chris | nope its still public |
| 19:18 | u just get a login prompt | |
| 19:18 | which tells you the username and password to use | |
| 19:18 | it was getting spam attacked on a constant basis | |
| 19:19 | having the http auth stops that | |
| 19:19 | ambrose|w | oh |
| 19:19 | thanks | |
| 19:19 | i guess i should stop being lazy and start to catch up with the translation now :D | |
| 19:19 | kados | my $query = "select DISTINCT(word),count(DISTINCT(word)) FROM marc_word group by word"; |
| 19:19 | ambrose|w | are we still using cvs? |
| 19:19 | chris | for 2.2 yep |
| 19:20 | kados | my $sth=$dbh->prepare($query) || die "cant prepare query";; |
| 19:20 | $sth->execute(); | |
| 19:20 | ambrose|w | good :) |
| 19:20 | kados | while (my ($word)=$sth->fetchrow_array) { |
| 19:20 | $sth2->execute($word,$count); | |
| 19:20 | what's wrong with this picture :-) | |
| 19:20 | chris | select DISTINCT(word),count(DISTINCT(word)) FROM |
| 19:20 | marc_word group by word | |
| 19:20 | should be | |
| 19:20 | ambrose|w | if i can translate in time (or maybe not), perhaps i have a small chance to convince my manager to use koha |
| 19:20 | kados | hmmm, the query is working ok ... it's the fetchrow array I'm worried about |
| 19:21 | chris | ahh you dont need to do the distinct stuff |
| 19:21 | grouping does it for ya | |
| 19:21 | kados | ahh |
| 19:21 | chris | select count(*),word from marc_word group by word; |
| 19:22 | kados | well how about fetchrow array, how do I pass both values through? |
| 19:22 | chris | my @array = |
| 19:23 | sth->execute($array[0],$array[1]); | |
| 19:23 | or my ($count,$word) = | |
| 19:24 | that make sense? | |
| 19:24 | kados | yep |
| 19:24 | thanks | |
| 19:24 | chris | personally i never use arrays to return results |
| 19:24 | because not all databases return them in the order you ask for them | |
| 19:24 | so its a bad habit to get into | |
| 19:24 | kados | what's the alternative? |
| 19:24 | chris | i pretty much always use a hashref |
| 19:25 | my $data=$sth->fetchrow_hashref() | |
| 19:25 | then $data->{'word'} etc | |
| 19:25 | kados | ahh |
| 19:25 | chris | but for this little script array is fine |
| 19:25 | cos mysql behaves nicely | |
| 19:26 | kados | :-) |
| 19:26 | chris | and gives you columns in the order you specify |
| 22:12 | kados | hey chris: I've got counts working: |
| 22:12 | https://opac.athenscounty.lib.oh.us/ | |
| 22:14 | now it's on to multiple words | |
| 22:15 | actually, I'm thinking that the best application for this is the borrower search on the intranet | |
| 22:15 | the dataset is really small | |
| 22:15 | so it would be fast | |
| 22:15 | you could do firstname lastname | |
| 22:15 | and lastname firstname | |
| 22:15 | strip out the commas | |
| 22:15 | and ' | |
| 22:17 | for searching it might be better to have a list of the most popular searches | |
| 22:17 | chris | yeah |
| 22:17 | kados | that shouldn't be too tricky to pull off |
| 22:18 | the searches that succeed in reults get stored in a table somewhere | |
| 22:19 | and a background process tallies them and dumps them into the non-production machine's database | |
| 22:19 | it only needs to keep a few thousand I'd think | |
| 22:20 | just the most popular ones | |
| 22:21 | chris | and as byproduct |
| 22:21 | you are collecting the most popular searches | |
| 22:21 | which is a good stat in determining what new books to buy | |
| 22:21 | kados | yep ... actually it might be useful to collect failed results too |
| 22:22 | chris | yep |
| 22:22 | kados | so I need a table with three columns: term, resultcount, success |
| 22:22 | this is actually getting easier ;-) | |
| 22:23 | thanks for all the ongoing help and advice chris! | |
| 22:26 | chris | no worries |
| 05:08 | paul_away | /nick paul |
| 05:09 | paul | hello world (i mean kados, chris, rach, si and our friend logbot ;-) ) |
| 05:09 | chris | hi paul |
| 05:11 | paul | what were you speaking of with kados ? i'm not sure i understand well |
| 05:11 | chris | have you seen google suggest? |
| 05:12 | http://www.google.com/webhp?complete=1&hl=en | |
| 05:12 | start typing and google will give you some words | |
| 05:12 | joshua did something to do the same for koha | |
| 07:08 | paul | 'lut |
| 07:39 | JYL57 | hello paul & others ! |
| 07:40 | paul | hello, si ta cnx tient bon ;-) |
| 07:40 | JYL57 | configuring Kerio firewall this morning with many config stuff... ;-) |
| 10:51 | jmlongo | hello there... :) |
| 10:54 | anyone can tell me how 'printing' works in Koha? | |
| 10:56 | I would like the system to print something everytime a borrower borrows a book... | |
| 10:56 | paul | hi jm |
| 10:56 | those questions must be asked to katipo | |
| 10:56 | afaik, they are the only ones that prints slips on issues | |
| 10:56 | jmlongo | hi Paul :) |
| 10:57 | paul | no library here in france prints such a slip |
| 10:57 | (at least none that are my customers ;-) ) | |
| 10:57 | jmlongo | i see :-P |
| 10:58 | so... you say I should ask this via the mailing list? | |
| 10:58 | paul | probably yes. |
| 10:58 | (for instance, kiwis are in bed. should be back in 8-10 hours) | |
| 10:59 | jmlongo | ok Paul... thanks! |
← Previous day | Today | Next day → | Search | Index