IRC log for #koha, 2005-02-25

All times shown according to UTC.

Time S Nick Message
11:07 kados msg paul sorry ... is that the name of the library?
12:17 kados morning owen
12:17 owen Hi
12:17 kados early today ;-)
12:17 owen Yeah, I had to get dropped off because my car battery died.  So the scheulde wasn't up to me :)
12:18 kados doh!
12:37 kados paul still around?
12:37 paul yes (4PM in France)
12:37 kados I'd like your advice on something
12:37 kados we're trying to get our subtitles to display in initial search results
12:38 kados I'm thinking the best way to do this is to modify the query in catalogsearch around line 340 or so
12:38 kados currently it's:
12:38 kados "SELECT biblio.biblionumber as bn,biblio.*, biblioitems.*,marc_biblio.​bibid,itemtypes.notforloan
12:38 kados                                                        FROM biblio, marc_biblio
12:38 kados                                                        LEFT JOIN biblioitems on biblio.biblionumber = biblioitems.biblionumber
12:38 kados                                                        LEFT JOIN itemtypes on itemtypes.itemtype=biblioitems.itemtype
12:38 kados                                                        WHERE biblio.biblionumber = marc_biblio.biblionumber AND bibid = ?");
12:38 kados (I think this is the query that pulls out the title and author, etc right?
12:39 paul do you want ALL subtitles ? or is the 1st only acceptable ?
12:40 paul if you want all, then you must do another query.
12:40 kados we need to be able to construct a string of subtitles from marc (for instance, 245b, p, etc)
12:40 paul mmm... not a good idea imho. Better to look for bibliosubtitle table
12:41 kados our records store them in different places depending on the type of record (and also where we got it from;-))
12:41 paul yes, but subtitle are handled in differents places depending on MARC flavour
12:41 kados hmmm ... what's the reason we don't return the whole marc record to the initial search results page?
12:41 kados wouldn't that be a simpler process once we have bibids?
12:41 paul it's a perf reason !
12:42 kados really?
12:42 kados it would be one query just like we already have no?
12:42 paul yes. libraries with "complete" marc have BIG MARC biblios
12:42 paul (for example, sociology library i'm migrating at the moment has only 45000 biblios
12:43 paul but marc_word is +200MB !
12:43 kados ahh
12:43 paul in fact, I think we could have a redesign of the DB
12:43 paul and could store the MARC record in iso2709 format in marc_biblio
12:43 paul thus, it would be really quick to retrieve.
12:43 kados not a bad idea
12:43 paul but that's a long term idea !
12:43 kados I think we already do something like that
12:43 paul (like the marc_words one)
12:44 kados right
12:44 kados (that's brilliant ... can't wait for it ;-))
12:44 kados (we would have the fastest searches in the world)
12:44 kados (big selling point)
12:46 paul right owen, but my days have only 24 hours ;-)
12:46 paul (and we have no release manager for 2.4 now :-( )
12:47 kados paul ... can two tags be mapped to biblio.subtitle at the same time?
12:48 paul through the interface no
12:48 paul but through sql command directly, yes
12:48 paul and it COULD work
12:48 paul (note i don't write it should !)
12:48 kados :-)
12:48 kados so the mappings are done with symbolic links?
12:51 paul ???
13:00 paul re bonjour Sylvain
13:55 kados paul:  I've got subtitles working now ... should I commit that?
13:57 paul commit in 2.2 pls
13:58 paul i'll check is it's a right place
13:59 kados ok
14:03 kados ok paul I committed it
16:07 kados chris around?
16:07 kados I've got a tricky problem related to sorting hashes
16:13 kados nevermind ... damn perl for funky shit for text and integer comparisons
17:03 michael michael_sleepy,isnick
17:04 michael ... how sorry just trying to play with my nickname
17:04 michael --help
17:05 kados michael: try /help ;-)
17:06 michael i'm here too :[…]saging/chatzilla/... help is so big !!
17:06 kados hehe
17:06 kados I think you're looking for /nick
17:06 kados yep ... so type /nick michael_away
17:06 michael name michael_geekael
17:07 kados you need the /
17:07 owen Try this one michael:[…]utorial.html#cmds
17:09 owen You run out of characters fast when your name's too long! ;)
17:12 m_deadene oh... deadened is too long
06:00 paul monsieur lemaire, bienvenue (JYL57)
06:06 JYL57 Salut Paul
06:06 JYL57 roulement de tambours chez nous, on ouvre enfin !
06:15 paul ah ! voilà une excellente nouvelle.

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary