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