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