← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 11:07 | kados | msg paul sorry ... is that the name of the library? |
| 12:17 | 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 | paul still around? | |
| 12:37 | paul | yes (4PM in France) |
| 12:37 | kados | I'd like your advice on something |
| 12:37 | we're trying to get our subtitles to display in initial search results | |
| 12:38 | I'm thinking the best way to do this is to modify the query in catalogsearch around line 340 or so | |
| 12:38 | currently it's: | |
| 12:38 | "SELECT biblio.biblionumber as bn,biblio.*, biblioitems.*,marc_biblio.bibid,itemtypes.notforloan | |
| 12:38 | FROM biblio, marc_biblio | |
| 12:38 | LEFT JOIN biblioitems on biblio.biblionumber = biblioitems.biblionumber | |
| 12:38 | LEFT JOIN itemtypes on itemtypes.itemtype=biblioitems.itemtype | |
| 12:38 | WHERE biblio.biblionumber = marc_biblio.biblionumber AND bibid = ?"); | |
| 12:38 | (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 | 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 | 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 | 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 | (for example, sociology library i'm migrating at the moment has only 45000 biblios | |
| 12:43 | 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 | and could store the MARC record in iso2709 format in marc_biblio | |
| 12:43 | 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 | (that's brilliant ... can't wait for it ;-)) | |
| 12:44 | (we would have the fastest searches in the world) | |
| 12:44 | (big selling point) | |
| 12:46 | paul | right owen, but my days have only 24 hours ;-) |
| 12:46 | (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 | but through sql command directly, yes | |
| 12:48 | and it COULD work | |
| 12:48 | (note i don't write it should !) | |
| 12:48 | kados | :-) |
| 12:48 | so the mappings are done with symbolic links? | |
| 12:51 | paul | ??? |
| 13:00 | 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 | i'll check is it's a right place | |
| 13:59 | kados | ok |
| 14:03 | ok paul I committed it | |
| 16:07 | chris around? | |
| 16:07 | I've got a tricky problem related to sorting hashes | |
| 16:13 | nevermind ... damn perl for funky shit for text and integer comparisons | |
| 17:03 | michael | michael_sleepy,isnick |
| 17:04 | ... how sorry just trying to play with my nickname | |
| 17:04 | --help | |
| 17:05 | kados | michael: try /help ;-) |
| 17:06 | michael | i'm here too : http://www.mozilla.org/project[…]saging/chatzilla/... help is so big !! |
| 17:06 | kados | hehe |
| 17:06 | I think you're looking for /nick | |
| 17:06 | 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: http://www.irchelp.org/irchelp[…]utorial.html#cmds |
| 17:09 | 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 | roulement de tambours chez nous, on ouvre enfin ! | |
| 06:15 | paul | ah ! voilà une excellente nouvelle. |
← Previous day | Today | Next day → | Search | Index