![http://microfinancement.cirad.[…]ages/afrique3.gif](http://microfinancement.cirad.fr/fr/biblio/images/afrique3.gif){kind=link}
← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 19:27 | mason | ok |
| 19:28 | chris | ok mason, itemtypes |
| 19:28 | mason | so the general question, is there are some misc fields in some of the fred.hollows tables, and im wondering the best place for them.. |
| 19:29 | which fields are more 'item descriptions' and which are itemtypes | |
| 19:30 | eg the cd table has 2 fields 'type' and 'format' | |
| 19:30 | heres an example | |
| 19:30 | <Row> | |
| 19:30 | <Cell><Data ss:Type="String">1</Data></Cell> | |
| 19:30 | <Cell><Data ss:Type="String">Ear Toilet </Data></Cell> | |
| 19:30 | <Cell><Data ss:Type="String">1</Data></Cell> | |
| 19:30 | <Cell><Data ss:Type="String"> </Data></Cell> | |
| 19:30 | <Cell><Data ss:Type="String"> </Data></Cell> | |
| 19:30 | <Cell><Data ss:Type="String">Modified 27/10/2003</Data></Cell> | |
| 19:30 | <Cell><Data ss:Type="String">Three Powerpoint Presentations by Dr Keith N. Edwards : - Ear Toilet (76 Slides), Ear Toilet Plus (89 Slides), Ear Toilet Plus Plus (99 Slides) </Data></Cell> | |
| 19:30 | <Cell><Data ss:Type="String">Australia </Data></Cell> | |
| 19:30 | <Cell><Data ss:Type="String"> </Data></Cell> | |
| 19:30 | <Cell><Data ss:Type="String">Medical Training </Data></Cell> | |
| 19:30 | <Cell><Data ss:Type="String">CD </Data></Cell> | |
| 19:30 | </Row> | |
| 19:30 | chris | right |
| 19:30 | mason | 'Med training' is type |
| 19:31 | chris | CD = itemtype |
| 19:31 | mason | sure |
| 19:31 | the med training field? | |
| 19:32 | other values are 'promotional', and 'presentation' | |
| 19:32 | chris | that looks more like a subject to me |
| 19:32 | mason | ah |
| 19:33 | field 5 is ' CD duration', where does he go? | |
| 19:33 | the field on that example is blank, ill get another | |
| 19:34 | <Row> | |
| 19:34 | <Cell><Data ss:Type="String">29</Data></Cell> | |
| 19:34 | <Cell><Data ss:Type="String">Press Ads for OSN - July Edition FH Technologies </Data></Cell> | |
| 19:34 | <Cell><Data ss:Type="String">1</Data></Cell> | |
| 19:34 | <Cell><Data ss:Type="String"> </Data></Cell> | |
| 19:34 | <Cell><Data ss:Type="String"> </Data></Cell> | |
| 19:34 | <Cell><Data ss:Type="String">May-03</Data></Cell> | |
| 19:34 | <Cell><Data ss:Type="String">Advertisements </Data></Cell> | |
| 19:34 | <Cell><Data ss:Type="String">Australia </Data></Cell> | |
| 19:34 | <Cell><Data ss:Type="String"> </Data></Cell> | |
| 19:34 | <Cell><Data ss:Type="String">Advertisement</Data></Cell> | |
| 19:34 | <Cell><Data ss:Type="String">CD </Data></Cell> | |
| 19:34 | </Row> | |
| 19:34 | thats blank too! | |
| 19:34 | <Cell><Data ss:Type="String">25 mins 05 secs </Data></Cell> | |
| 19:34 | chris | ok i tell you what |
| 19:35 | id use CD as itemtype | |
| 19:35 | and Advertisements as subject | |
| 19:35 | and perhaps Advertisement as dewey | |
| 19:35 | dewey is what shows up as classification, ill find an example | |
| 19:36 | mason | great stuff... |
| 19:37 | chris | http://opac.eeo.katipo.co.nz/c[…]etail.pl?bib=4747 |
| 19:39 | mason | another question, some of the records have a 'copies' field, ie: the number of copies, do we create a new 'item' record for each of these copies? |
| 19:39 | chris | yep |
| 19:39 | mason | ok |
| 19:39 | chris | that would be the best solution |
| 19:40 | we may have to just make up barcodes for them, since they dont have a library yet | |
| 19:40 | mason | ok |
| 19:41 | next, one table is a list of videos, there are lots of video types eg: | |
| 19:41 | | "Betacam" | | |
| 19:41 | | "Betacam SP Metal tape" | | |
| 19:41 | | "KSP20" | | |
| 19:41 | | "Betacam SP Metal tape" | | |
| 19:41 | | "Umatic?" | | |
| 19:41 | | "Hi 8" | | |
| 19:41 | | "Digital Betacam" | | |
| 19:41 | | "DVCAM 32" | | |
| 19:41 | | "DVCAM 124" | | |
| 19:41 | | "Dvcam 40" | | |
| 19:41 | chris | right |
| 19:41 | mason | | "Dvcam 60" | |
| 19:41 | | "Mini DV" | | |
| 19:41 | | "Betacam SP" | | |
| 19:41 | | "Digital Betacam" | | |
| 19:41 | chris | id stick those in dewey |
| 19:41 | mason | are each of these an itemtype? |
| 19:41 | chris | id class them all itemtype video |
| 19:41 | and have that being their classification | |
| 19:42 | itemtypes are basically what you use for your issuing rules | |
| 19:42 | you dont want to have to define a rule for every type of video | |
| 19:43 | mason | click |
| 19:44 | chris | so as long as we store that info in the classification they can then search for all items of type video, that have dvcam 40 as their classification |
| 19:44 | mason | so those values would be in biblioitems table, in dewey AND classification fields? |
| 19:45 | chris | there is a bug with dewey (its fixed for the new release) |
| 19:45 | its currently set to a float | |
| 19:45 | so what id do | |
| 19:45 | is | |
| 19:45 | alter table biblioitems change dewey dewey varchar(100); | |
| 19:45 | and then store those values in dewey | |
| 19:46 | (which is badly named, it should just be called class or something) | |
| 19:47 | because thats how koha treats it | |
| 19:54 | mason | chris: another quessy, russ has sent me another xls table from FH, its a database of press incidences |
| 19:55 | chris | k |
| 19:55 | mason | can we put these as items in koha, they arnt items as such, what fudges will we need to do to get them in? |
| 19:56 | heres a xml field desc. ... | |
| 19:56 | chris | hmm |
| 19:56 | mason | <Row> |
| 19:56 | <Cell><Data ss:Type="String">Date</Data></Cell> | |
| 19:56 | <Cell><Data ss:Type="String">Publication</Data></Cell> | |
| 19:56 | <Cell><Data ss:Type="String">Page No.</Data></Cell> | |
| 19:56 | <Cell><Data ss:Type="String">Headline</Data></Cell> | |
| 19:56 | <Cell><Data ss:Type="String">Journalist/Author</Data></Cell> | |
| 19:56 | <Cell><Data ss:Type="String">Topic</Data></Cell> | |
| 19:56 | <Cell><Data ss:Type="String">Type</Data></Cell> | |
| 19:56 | <Cell><Data ss:Type="String">Source</Data></Cell> | |
| 19:56 | <Cell><Data ss:Type="String">Fundraising Campaign</Data></Cell> | |
| 19:56 | <Cell><Data ss:Type="String">Corporate/Editorial</Data></Cell> | |
| 19:56 | <Cell><Data ss:Type="String">Remarks</Data></Cell> | |
| 19:56 | </Row> | |
| 19:56 | chris | id load them in |
| 19:57 | make them pressrelease itemtype or something | |
| 19:57 | mason | heres a record example |
| 19:57 | <Row> | |
| 19:57 | <Cell><Data ss:Type="String">7/07/2005</Data></Cell> | |
| 19:57 | <Cell><Data ss:Type="String">Sydney Morning Herald</Data></Cell> | |
| 19:57 | <Cell><Data ss:Type="String">8</Data></Cell> | |
| 19:57 | <Cell><Data ss:Type="String">On the job: Irene Fisher</Data></Cell> | |
| 19:57 | <Cell><Data ss:Type="String">Sharon Lindsay</Data></Cell> | |
| 19:57 | <Cell><Data ss:Type="String">Interview with Irene Fisher of Sunrise Health Service.</Data></Cell> | |
| 19:57 | <Cell><Data ss:Type="String">Feature</Data></Cell> | |
| 19:57 | <Cell><Data ss:Type="String">Staff member</Data></Cell> | |
| 19:57 | <Cell><Data ss:Type="String"> </Data></Cell> | |
| 19:57 | <Cell><Data ss:Type="String"> </Data></Cell> | |
| 19:57 | <Cell><Data ss:Type="String">Does not mention The Foundation</Data></Cell> | |
| 19:58 | </Row> | |
| 19:58 | do-able? | |
| 19:58 | chris | yeah id just make a blank item for them |
| 19:58 | mason | without a biblio, or biblioitem record |
| 19:58 | ? | |
| 20:00 | chris | a biblio and a biblioitem |
| 20:00 | id make the headline be the title | |
| 20:00 | publisher = paper | |
| 20:01 | mason | sorry , ive got another one, when calling the newbiblioitem(), and newitems() subroutines in uploadbib.pl, does an existing itemtype have to exist in the itemtypes table, for the routine to be successfull? |
| 20:02 | gotcha | |
| 20:02 | chris | it doesnt have to |
| 20:03 | mason | ok, just checking |
| 20:03 | chris | but the search wont work if it doesnt |
| 20:03 | so i load the data | |
| 20:03 | then make the itemtypes | |
| 20:03 | then check a search | |
| 20:03 | mason | sure, just wondering if there was a dependency, or an order |
| 20:04 | chris | it shouldnt matter |
| 20:05 | actually it would be good if it didnt let you add one if the itemtype didnt exist | |
| 20:06 | or at least warn | |
| 20:06 | mason | ok one last thing.., could you just refresh my memory on the relationship between an item's biblio and biblioitem records, (and i guess its items record too) |
| 20:06 | chris | ahh there is a good diagram rach did that illustrates this |
| 20:07 | mason | yup, ive seen it, and forgotten it? |
| 20:07 | chris | http://katipo.co.nz/gallery/ko[…]how_cat_works_001 |
| 20:07 | mason | ;) |
| 20:07 | ta | |
| 20:07 | chris | biblio's own biblioitems, biblioitems own items |
| 20:07 | mason | ah |
| 20:07 | ahhhhhhhhhh | |
| 20:08 | chris | all makes sense now? |
| 20:08 | mason | much better |
| 20:08 | chris | cool |
| 20:09 | mason | i general little issues ive got are where to stick a random misc. FH field into koha |
| 20:10 | chris | id use the notes field |
| 20:10 | mason | things like 'video running time'..., the easy way would be to plonk them in itemnotes, or comments or whatever..., but there probably is a better place for them |
| 20:10 | chris | biblioitems |
| 20:11 | mason | anyway, back in 20 - 30 minutes |
| 20:11 | thanks for all of that | |
| 20:11 | chris | no problem |
| 20:25 | Genji | hiya all. |
| 20:25 | any coder active? | |
| 21:08 | chris | cool, kadmin has sudo |
| 03:43 | paul | hi js |
| 03:43 | osmoze | hello :) |
| 03:44 | de retour de vacances :( | |
| 03:44 | rach | bonjour |
| 03:45 | paul | hi rach. Not yet in bed ? |
| 03:45 | rach | not quite :-) |
| 03:46 | si flys to sydney v early tommorrow so I've been frantically looking for his passport | |
| 03:46 | found eventually in the basement | |
| 03:46 | paul | good luck. |
| 03:46 | rach | so we're having a calming cup of tea :-) |
| 03:47 | where is that? | |
| 03:47 | paul | OK, got it ;-) |
| 03:47 | Burkina Faso capital. | |
| 03:47 | (in Africa) | |
| 03:47 | rach | ah very cool |
| 03:47 | or perhaps in september quite hot | |
| 03:47 | paul | for a meeting about "développement durable & savoir & bibliothèques" |
| 03:48 | (don't know how to translate "développement durable") | |
| 03:48 | rach | ah so not on holiday |
| 03:48 | paul | no. |
| 03:48 | rach | long term development of libraries |
| 03:48 | paul | long terme development of countries. |
| 03:48 | knowledge & libraries being a piece of developpment. | |
| 03:49 | (however, i'm not sure Burkina Faso is a country interesting for holidays...) | |
| 03:50 | rach | ah well - not an african country with long sandy beaches then |
| 03:50 | paul | look on a map ;-) |
| 03:50 | (=> burkina is one of the countries with NO sea access) | |
| 03:51 | http://microfinancement.cirad.[…]ages/afrique3.gif | |
| 03:53 | rach | ah - I think sustainable development might be the translation we're after |
| 03:54 | paul | that's it. |
| 03:55 | rach | hmm I searched in google for Burkina Faso holiday |
| 03:56 | and I get things like "A Wolf in Sheeps Clothing? A Closer Look at Medical Tourism" | |
| 03:56 | which doesn't sound that positive | |
| 03:57 | hdl | Burkina is one of the poorest countries in the world. |
| 03:58 | paul | (ppl : remember hdl has a wife coming from Ivory coast ;-) ) |
| 03:58 | (so he knows africa very well) | |
| 03:59 | hdl | Its debt should have been reliefed. |
| 03:59 | But Still undergoes some development pb. | |
| 03:59 | rach | but we hear more about the south pacific countries and aisa here than africa |
| 03:59 | hdl | With Cote d'Ivoire in particuliar, which has borders with it. |
| 04:00 | Cote d'Ivoire was one of the most developped countries in West Africa... before 3 years' crisis. | |
| 04:01 | But now West Africa has to find a new balance. | |
| 04:02 | Ivorian nationalism leads to troubles with borders countries. | |
| 04:07 | rach | paul has flavio zeni been in contact with you? |
| 04:07 | paul | no |
| 04:07 | rach | he's Chief Technical Adviser |
| 04:07 | Strengthening Parliaments' Information Systems in Africa | |
| 04:07 | UNDESA | |
| 04:07 | Nairobi - Kenya | |
| 04:07 | paul | I don't remember reading anything from him |
| 04:07 | rach | no he has sent stuff only to me maybe |
| 04:08 | I'll forward it to you as well | |
| 04:09 | but he has koha set up on windows so you might be not much help either | |
| 04:36 | chris | and i have an uncle working in botswana |
| 04:37 | but i still know very little africa geography and history | |
| 04:43 | hdl | hi chris. I only knows a little because I have lived there for years :) |
| 04:43 | Have you committed some works on Context.pm ? | |
| 04:44 | chris | hmm not recently, not that i remember |
| 04:44 | i may have in the past | |
| 04:44 | let me just check | |
| 04:44 | hdl | My concern is to know how connexctions are managed in Context.pm. |
| 04:45 | chris | ahh nope i havent |
| 04:45 | hdl | Indeed, I would like to put in there User information... But wonders how things would go in a multi-connected environnment. |
| 04:45 | Especially with mod_perl on. | |
| 04:47 | chris | sub _new_dbh |
| 04:47 | is the sub that actually creates it | |
| 04:47 | hdl | It is to avoid API modifications... But can't figure out how to achieve that. |
| 04:47 | chris | but its only called if there isnt a connection already available |
| 04:47 | hdl | Yes... I saw. |
| 04:48 | But it is a connection context-free vraiable. | |
| 04:48 | Mine would be "based" on a connection context. | |
| 04:49 | chris | ahh so that yuo could have a database handle for the opac, one for the intranet etc > |
| 04:49 | >=? | |
| 04:49 | hdl | Quite like a cookie in fact, but I would like it to be available in C4 packages. |
| 04:50 | Not Only in Auth.pm | |
| 04:50 | chris | hmm |
| 04:50 | paul | in fact, hdl needs to know simply what is the branch of the connected user. |
| 04:50 | hdl | Chris : Nope, this would be only for Userinformation. |
| 04:51 | paul | and he needs the information everywhere in Koha. So he needs to be able to get it simply. |
| 04:51 | chris | ohh |
| 04:51 | paul | and when you are inside a sub in a .pm package, you don't have any cookie/CGI or thing like this. |
| 04:51 | so my suggestion would be to : | |
| 04:51 | chris | right |
| 04:51 | how about an environment variable | |
| 04:51 | paul | * create a variable in C4::Context to store the info during auth |
| 04:51 | * read it after. | |
| 04:52 | chris | actually sorry the environment variable will only work for mod_perl |
| 04:52 | hdl | I began work in this direction, but wonders how would things function with many connections on. |
| 04:52 | chris | yeah |
| 05:06 | back | |
| 05:10 | hmmmm $value = C4::Context->config("config_variable"); | |
| 05:11 | presumably you could do | |
| 05:13 | i was thinking to set something .. but we want it to be persistent | |
| 05:15 | i wonder if Apache::Session would be worht looking at | |
| 05:18 | or CGI::Session | |
| 05:18 | http://search.cpan.org/~sherzo[…]5/Session/File.pm | |
| 05:39 | hdl | chris : I think it might be a solution. |
| 05:39 | But still, this would need more investigation and a major change in installation : Adding a Package. | |
| 05:39 | I don't think this would be recommended for a minor version 2.2.4. | |
| 05:39 | But may be great for 3.0, Don't you think ? | |
| 05:39 | chris | yeah i think so |
| 05:46 | well i think its bedtime for me | |
| 06:41 | paul | hdl, i've the solution to your problem |
| 06:41 | in C4::Context, you should add 2 variables | |
| 06:42 | your hash, $userinfo->{$userid}->{*} | |
| 06:42 | and a $activeuser, that you set in Auth.pm. always | |
| 06:42 | so, to get userinfo, you just have to read : | |
| 06:43 | $userinfo->{$activeuser} | |
| 06:43 | and get : | |
| 06:43 | $activeuser=$parameter_sent_by_auth | |
| 06:43 | unless ($userinfo->{$activeuser}) " | |
| 06:44 | (oups, {) | |
| 06:44 | # sql read user info | |
| 06:44 | # set $userinfo->{$activeuser} | |
| 06:44 | } | |
| 06:44 | return ($userinfo->{$activeuser}->{whatever_you_need} | |
| 06:44 | HTH | |
| 07:21 | hdl | ok. |
| 07:21 | But may be not the right activeuser with mod_perl, may it ? | |
| 07:21 | paul | no risk. |
| 07:21 | I explain : | |
| 07:21 | when the html call is done, the CGI gate is opened. | |
| 07:21 | in mod_perl, the script is already here & running. | |
| 07:21 | BUT it begins at 1st line anyway. | |
| 07:22 | and at the very beginning, we read the cookie of the user. | |
| 07:22 | so we get the correct userinformations here. | |
| 07:22 | whatever mod_perl or not | |
| 07:22 | ;-) | |
| 07:22 | then we instanciate $activeuser that is correct. | |
| 07:22 | then we use $userinfo->{} | |
| 07:22 | that can be filled for $activeuser or not. | |
| 07:23 | if not filled, then we fill it for future use & speed improvement | |
| 07:23 | if filled, then we just read it from here. | |
| 07:24 | hdl | You're the BEST. ;) |
| 07:24 | paul | no, I just eat lemon pies ;-) |
| 07:25 | (I mean the solution came when eating a own-made lemon pie) | |
| 07:25 | everybody should eat lemon pies when he has a problem. | |
| 07:26 | hdl | Send me one via e-mail ;) |
| 07:35 | kados | hi all |
| 07:35 | paul | 'morning joshua |
| 07:52 | Genji | hiya all |
| 07:52 | any coders active? | |
| 07:53 | paul | kados should be around & i am too |
| 07:53 | (as well as hdl unless it's wanadoo connexion is down) | |
| 07:54 | Genji | k. how do i delete using a join? |
| 07:54 | hdl | I am here. |
| 07:54 | Genji | in other words, im wanting to delete an item from a shelf, based on itemnumber and owner. |
| 07:55 | would 'delete from shelfcontents, bookshelf where itemnumber=? and bookshelf.owner=?' work? | |
| 07:59 | or 'delete from shelfcontents, bookshelf where shelfcontents.shelfnumber=bookshelf.shelfnumber and itemnumber=? and owner=?'? | |
| 07:59 | paul | no. |
| 07:59 | what version of mysql do you have ? | |
| 07:59 | Genji | how to do then? |
| 07:59 | ummm. | |
| 08:00 | paul | (if >=4.1, then it's possible. otherwise impossible) |
| 08:00 | Genji | 4.0.20a... |
| 08:00 | paul | sorry, it's not possible. |
| 08:00 | Genji | so i need to upgrade. |
| 08:00 | should be easy enough. | |
| 08:00 | paul | maybe |
| 08:01 | and that should do what you want : | |
| 08:01 | delete from shelfcontent where shelfnumber in (select shelfnumber from bookshelf where itemnumber=? and owner=?) | |
| 08:01 | Genji | think i might actually create a physicalshelf table, so the end user doesn't need >=4.1. |
| 08:04 | means putting another subroutine in bookshelves.pm. | |
| 08:11 | eh.. would mean two tables... one to keep the names of shelfs, and owners, and the other to keep contents... so.... | |
| 08:14 | hmm.. | |
| 08:16 | would be the easiest way, since a physical book cannot exist in two places at once.... | |
| 09:45 | hdl | hi owen |
| 09:45 | owen | Hi hdl |
| 09:45 | What's new? | |
| 09:46 | paul | 'morning owen, a question about PROG templates : do you plan to take care of 2.2 => head synchros that will be done in default/css templates ? |
| 09:46 | that would be fine. | |
| 09:46 | (as you're already tracking them for NPL, would be easy for you I think) | |
| 09:46 | owen | yes |
| 09:51 | kados | hi owen |
| 09:51 | owen | Hi kados |
| 10:13 | kados | paul: does the bug in 2.2.3 affect only UNIMARC ? |
| 10:13 | paul | no |
| 11:00 | beeping kados / owen (for a translation problem) | |
| 11:00 | look at this page : | |
| 11:01 | http://bureau.paulpoulain.com:[…]detail.pl?bib=108 | |
| 11:01 | (on the right. | |
| 11:01 | ) | |
| 11:01 | I need your help for | |
| 11:01 | This is a serial subscription (There are 1 subscriptions associated with this title). | |
| 11:01 | Here comes a list of the three latest issues related to those subscription(s) : | |
| 11:01 | For more information :Click here to look for Issues we have or don't have | |
| 11:01 | I'm not sure at all it's correct english | |
| 11:01 | I want to say : | |
| 11:02 | "this is not a monography but a subscription" | |
| 11:02 | "we can have more than 1 subscription" | |
| 11:02 | "here is the list of the last 3 issues for each subscription | |
| 11:02 | "click here for more details" | |
| 11:02 | thx for your suggestions. | |
| 11:03 | owen | Instead of "Here comes a list of the three latest issues" you might say "Following is a list of the three latest issues" or "Below is a list of the three latest issues" |
| 11:03 | Nice template design, by the way | |
| 11:04 | paul | (it's css templates) |
| 11:04 | (with a nice css stylesheet. but otherwise 100% pure css template) | |
| 11:04 | owen | That's great. |
| 11:04 | paul | right. I thought you already saw this before. |
| 11:33 | owen & kados : did you try your getMARCnotes, getMARCsubjects & getMARCurls subs ? | |
| 11:34 | because they have a $dbh->disconnect at the end that makes | |
| 11:34 | "mysql server has gone away" | |
| 11:34 | kados | yea ... we do have that prob I think |
| 11:34 | paul: what's the solution? | |
| 11:34 | paul | it's C4::Context & perl that is responsible for dbh disconnects |
| 11:34 | just remove the line ;-) | |
| 11:34 | (works like a charm for me now. will commit the stuff soon) | |
| 11:35 | kados | cool |
| 11:35 | paul | when i'll have solved the other problem : |
| 11:35 | MARCnotes not shown in css templates | |
| 11:35 | (because they are inside the TMPL_LOOP name="BIBLIO_RESULT") | |
| 11:36 | I also don't want to get notes & subjects twice ;-) | |
| 11:36 | kados | :-) |
| 11:45 | thd | kados: Did you find how to assign a damaged item to itemtype 'damaged too fragile to circulate' or something similar that you and owen seemed to be concerned with last week? |
| 11:52 | Genji: are you still there? |
← Previous day | Today | Next day → | Search | Index