Time Nick Message 11:58 nengard slef yeah - i imagine it would be 11:58 slef nengard: it's a frequent source of debate, on planet.debian.org in particular 11:54 nengard hiya slef - i've seen organizations do it both ways - i'd say if the developer is talking about developing at least some of the time it should be on the page ... but if all they talk about is movies or something unrelated I might not include it 11:51 slef should I put developer personal blogs onto the koha blogs page, or just their koha topics? 11:50 slef hi all 21:20 gmcharlt hdl: got a moment for a question? 21:16 chris bbiab 21:13 chris yeah, flu immunisation 21:13 gmcharlt to a good purpose, I hope 21:13 gmcharlt ouch 21:10 gmcharlt hi chris 21:08 chris morning 21:00 hdl have a nice flight 21:00 hdl OK. 21:00 hdl already done. 21:00 kados I"ll be back later 21:00 kados hdl: sure ... can you send me the patch without the updatedatabase part? 20:59 hdl Can you add manually the RenewalAddsSuggestion to updatedatabase.pl ? 20:57 kados that's my solution :-) 20:56 hdl I will get a brand new clone 20:53 kados odd 20:51 kados and made a new commit 20:51 kados hdl: I manually added the updatedatabase 20:50 kados hdl: I've just pushed up 083 20:50 kados hdl: now would be a good time 20:48 kados I will manually apply 20:48 hdl But it still added some lines. 20:48 kados but it will probably cause you problems 20:48 kados I can manually do it 20:48 kados hdl: yea, it's strange, it failes and I can't apply it at all 20:48 hdl I tried to checkout updatedatabase. 20:47 kados hdl: so something is still different 20:47 kados hdl: updatedatabase change failes 20:45 kados oh, nm, found it 20:45 kados hdl: all I have is sysprefs change and updatedatabase ... what about the code changes? :-) 20:45 kados hdl: receied, thanks 20:43 hdl kados: yuipath sent. 20:21 kados :) 20:21 hdl (If i still can type a little.) 20:21 kados (ie, as a separate patch) 20:21 kados hdl: please submit all changes to updatedatabase.pl, kohastructure.sql and kohaversion.pl separately from code changes 20:19 hdl I will try to re-submit. 20:18 kados also doesn't apply correctly 20:18 kados and change in yuipath management 20:18 kados RenewSerialAddsSuggestion needs to be re-submitted 20:18 kados hdl: I'd like to get my queue wrapped up, but I have two issues from you still 20:18 hdl eys 20:18 hdl YES 20:18 kados hdl still around? 20:12 nengard thanks kados & hdl 20:11 nengard k 20:11 kados nengard: I did a search on transfer in system preferences and turned up a couple hits 20:05 hdl but not 100% sure. 20:05 nengard ooo - thanks hdl - do you know which one? 20:05 hdl nengard: you have a syspref for that. 19:54 owen :) 19:53 nengard owen - hmmm - mine have disappeared 19:53 owen ...but don't know for sure, nengard 19:53 tim kados: I think I updated last week. The version is 3.00.00.078 19:52 owen I suspect not 19:51 nengard does anyone know if the items in the transfers reports (to do and to receive) expire? 19:51 kados (you can check from the admin interface in 'About' section) 19:51 kados tim: when's the last time you upgraded, what version are you running? 18:40 tim Of course I woldn't have the errors in the logs to show me that the itemtype field wasn't getting filled if it was set that way. 18:33 tim Also, is statistics.itemtypes supposed to be set to NOT NULL? Mine was set that way, but kohastructure.sql has it default to NULL. 18:30 tim Issues and renews aren't filling the itemtype field in statistecs. I'm not sure if there are other things missing, but that's all I noticed in the error logs. 18:29 tim I'm having problems with returns, but I think it could be because issues aren' t recorded correctly. 17:22 hdl But would this be OK for anyone ? 17:21 hdl adding a third base for staged records. 17:21 hdl kados : this would be a good idea i think (had the same... thinking of all the search facilities). 17:20 hdl kados : why don't we just put the staged records into a zebra db? 17:19 hdl kados : my patch for Renew or for yuipath 16:10 paul bye kados 16:10 kados bbiab 16:09 kados hdl: I'd suggest sending the patch and database updates separately 16:08 kados hdl: your version of updatedatabase.pl started different than git it seems 16:08 kados hdl: your patch doesn't apply ... 16:04 gmcharlt gotcha 16:04 kados *shrug* 16:04 kados but I'd prefer a library sponsor that one 16:04 kados gmcharlt: yea, I've got the price tag on that, we may be able to afford it in Q3 :-) 16:03 gmcharlt kados: not unless ID implements pass-through of full CQL queries 16:02 kados in place of my hackery 16:02 kados probably we should switch to pazpar2 as our search client in 3.2 or a future version 16:01 kados pazpar2 could though 16:01 gmcharlt though of course YAZ can do Z39.50-session-specific caching afaik 16:01 gmcharlt fbcit: that may be going a bit too far - zebra isn't fast enough for inserts and updates to serve as a search results cache IMO 16:00 gmcharlt kados: yeah, that's probably a better way of doing it 16:00 fbcit why not stage all search results of any type in zebra? 16:00 fbcit kados++ 15:59 kados why don't we just put the staged records into a zebra db? 15:59 kados so this search searches all available staged records? 15:59 gmcharlt kados: just two different modes of access 15:58 gmcharlt kados: they occupy the same DB tables 15:57 kados so we still have a breeding farm separate from the staging areas? 15:50 hdl But still, it is better than the one we have now. 15:48 gmcharlt hdl: also more options to purge z39.50 result caches (and staged import_batches, which occupy the same table) to avoid infinitely ballooning the DB 15:47 hdl It would require a page facility. 15:46 hdl and it is not really good for big and plentyful breeding. 15:45 hdl I agree it is a BAD hack. 15:45 hdl (and there is a problem with quotes too) 15:44 hdl (try to find a title you are sure to have in your base by anything but the first exact words..... you won't find it.) 15:43 gmcharlt hdl: agree that it would be nice to be able to do a Z39.50 search directly w/o having to go to bib editor 15:43 hdl kados : also, at the moment, Breeding is just useless, since it is not searchable. 15:42 paul hdl++ 15:42 hdl kados : my opinion is that Breeding Search and z3950 searches should eventually converge on one page. 15:40 kados I haven't had a chance to test it yet 15:40 kados the RenewSerialAddsSuggestion 15:40 kados hdl: especially since it prepends terms with a wildcard, which is hard for mysql 15:40 kados hdl: I'm quite certain it will fail badly if there are a lot of entries in breeding 15:38 kados the first has an extra warn ... plus I feel it requires some heavy testing 15:38 kados change in yuipath management 15:38 kados Adds a new SystemPreference : RenewSerialAddsSuggestion 15:38 kados Improving Breeding search 15:38 kados I have three now: 15:38 hdl And which other patch of mine do you have on your queue ? 15:37 hdl Why was RenewSerialAddsSuggestion rejected ? 15:36 hdl patch yuipath resent 15:36 hdl (it tells duplicate authorisedvalues.... and it doesnot update) 15:35 kados ok 15:35 hdl Since it fixes a problem when you edit authorisedvalues 15:35 kados yep, I'm wrong 15:35 hdl kados : my patch is really needed. 15:35 kados maybe I'm confused 15:35 kados hmmm 15:34 kados hdl: yes, and it's been approved 15:34 hdl I cant see it. 15:33 hdl kados : has andrew sent his patch on the koha-patches list ? 15:29 kados hdl: I have only 4 patches in my queue, all from you, and have open questions :-) 15:28 kados hdl: OK, let me know 15:28 hdl not yet. 15:28 kados though I suspect there may be a database issue there ... should we have a unique key for authorised_values table somewhere ? 15:28 kados hdl: if it's acceptable I'll also skip your patch 15:28 kados hdl: also, did you see andrew's patch to 2081? 15:28 kados hdl++ 15:27 hdl I will email the koha-devel list to say that. 15:26 kados hdl: much easier to troubleshoot that way 15:26 kados hdl: in the future I'd suggest submitting code and database updates separately 15:25 kados hdl: and it has a database update 15:25 kados hdl: as i haven't pushed that one yet 15:25 kados hdl: your RenewSerialAddsSuggestion patch might be the cause of your grief 15:22 kados except for the JS prob 15:22 kados hmmm, seems to be OK now 15:21 kados hdl: OK, I'll try to track down who changed it last :-) 15:21 kados and the JS doesn't work on neworderempty.pl for populating price 15:21 hdl But it 's been a long time I did not change an acquisition file. 15:21 gmcharlt owen: yes 15:19 kados hdl: also have bugs in acquisitions to address I'm afraid ... can't any longer receive an order 15:17 owen hdl, git checkout <file> reverts a file to the last commit, doesn't it? 15:15 kados I'll respond to Mc 15:15 kados cool, thanks 15:15 kados gmcharlt: that's what I thought about the MM::EU prompt 15:14 gmcharlt kados: in any event, even if it is needed, I object to the gratuitous goto 15:14 gmcharlt kados: not sure it's actually needed - the underlying MM::EU prompt() should detect when Makefile.PL is not being run interactively and plug in the supplied default 15:14 hdl git checkout is for changing branche. 15:13 hdl anyone : how to get the git original copy of a file ? 15:11 owen Cool, I wasn't aware of it 15:11 kados paul: great! 15:11 kados owen: there's a syspref called globalDueDate :-) 15:11 paul he should submit it soon. 15:11 paul kados : mc also has written a full sh script to install koha from a fresh debian etch in 1 script. 15:10 kados installer guys, mostly gmcharlt and acmoore, have you guys looked at the patch from Marc: added TRUST_ENV ? 15:08 paul OK, great. 15:08 kados paul: patches pushed 15:05 hdl then I may have already applied your first DB reconciliation 15:02 gmcharlt hdl: just rebased - not seeing double 080 15:01 hdl mmm... maybe the way rebase works produces those conflicts. 15:00 kados hdl: but I did have to adjust versions from patches as there were soe conflicts 15:00 kados hdl: only one in git 14:59 kados hdl: http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=blob;f=installer/data/mysql/updatedatabase.pl;h=ce3c094277c59ed79eb7af9ab8c2a2cfdb107063;hb=HEAD 14:59 kados yep, only one 14:58 kados I only have one 14:57 kados hmmm 14:57 hdl 2 revision 80 14:57 kados hmmm 14:57 hdl on updatedatabase.pl 14:57 kados hdl: conflicts? 14:57 hdl there seem to be conflicts. 14:52 kados hdl: should be at revision 082 14:52 kados hdl: OK, you can update from git now 14:51 kados hdl: about to 14:51 hdl or edit udpatedatabase.pl since it won't apply if I edit my updatedatabase 14:49 hdl kados : pls commit all your stuff to updatedatabase before I resend yuipath 14:45 kados hdl: ok 14:44 hdl I also will cope with kohaversion. 14:44 kados hdl: goodnews, your patch works :-) 14:44 hdl Since I will add to updatedatabase.pl 14:44 kados hdl: or leave kohaversion.pl to me 14:44 kados hdl: yes, exactly, along with kohaversion increment from 082 to 083 (about to push up 082 now) 14:43 hdl updatedatabase as such ? 14:43 hdl update systempreferences set value="locale" where variable="yuipath" and value like "%/intranet-tmpl/prog/%" ? 14:41 kados hdl: it should be re-sent with an updatedatabase to fix existing installations 14:41 kados hdl: change in yuipath management patch introduces a dangerous condition 14:41 kados yes, now I do 14:40 hdl I sent it to you and koha-patches. 14:39 hdl can you see it now ? 14:39 kados hdl: ? 14:37 kados hdl: all I see is: change in yuipath management : 14:37 kados hdl: you sure you sent it to patches@? 14:35 kados hdl: looking now 14:26 hdl patch sent 14:16 acmoore thanks! 14:16 acmoore Yep, that's it. installer/data/mysql/en/optional/sample_labels.sql 14:15 gmcharlt acmoore: sure (couple failures related to specific SQL scripts are known, by the way - working on patches for that) 14:15 acmoore gmcharlt, the new installer code causes test failures for me. Do you have a second? 14:11 hdl :D 14:11 gmcharlt hdl: of course - wasn't thinking of whipping that one up for 3.0 ;) 14:10 hdl or find a way to improve API so that filtering and ordering should be applied. 14:09 gmcharlt hdl: this is where a switch to a DB access layer like DBIx::Class may help, ultimately - remove the need to hand-code all of the accessors 14:08 hdl we have to write many routines. 14:08 gmcharlt hdl: well, if the agreement already exists, good :) 14:08 hdl But the fact is taht as soon as you want to filter or order results, 14:07 gmcharlt also, I hope, becoming a bit more strict about using the API instead of using quick-and-dirty SQL in the scripts 14:07 hdl I thought we already agreed on that point. 14:06 gmcharlt hdl: true, some conventions on DB accessor routines are needed (perhaps a general agreement to keep most SQL in C4 instead of the scripts) 14:06 acmoore getKohaAuthorisedValues... 14:05 hdl ve have GetAuthorisedValueDesc, .... 14:05 paul & the less easy it's to maintain 14:05 hdl (GetAuthorisedValues stands for an exemple)... 14:05 hdl Problem also is that the more routines we have, the less they are used 14:04 gmcharlt hdl: thanks 14:04 hdl So I am creating a new routine. 14:04 hdl OK. 14:04 hdl s/chacking/checking 14:04 gmcharlt yeah it's possible, but as we all discovered, this can complicate the client code that has to deal with such a routine - I'd prefer a separate, named function that indicates that you want a list 14:03 hdl But having functions without chacking if they have correct parameters is also a problem 14:03 hdl This can be source of problem. 14:02 hdl I spoke with a monger who saw no peculiar problem to send back hashes or arrays depending on the parameters. 14:01 hdl But still overloading. 14:01 gmcharlt hdl: ok 14:01 hdl Was about to send a complete fix for it. 14:01 hdl I worked on it. 14:00 gmcharlt kados mentioned that you were working on a fix, so wanted to avoid duplicate effort 14:00 gmcharlt I think the overloading should be removed, and a new function written that provides the list of categories 14:00 gmcharlt wanted to touch base with you about GetBorrowerCategory 13:59 hdl yes 13:59 gmcharlt hdl: about? 13:36 lloyd_ kados, around? 13:35 danny that is great, thank you 13:35 owen I'm going to forward the relevant files to Liblime so they can get it up on your test server as soon as possible 13:35 danny ah ok 13:35 danny I noticed it isn't at that url anymore 13:35 owen I had to take that offline do I could work on "core" Koha today 13:34 danny do you still have that template that you showed me last week somewhere? 13:34 owen Hi Danny 13:34 danny hey owen 13:30 owen The tab on moremember.pl only displays a summary of fines: a total due, or "no outstanding charges" 13:28 hdl So I donot even know if both fines display look alike. 13:27 hdl I have never used fines. 13:26 owen hi gmcharlt 13:26 owen hdl, what do you propose to do about the duplicated fines information on moremember.pl? 13:25 gmcharlt greetings #koha 13:23 hdl maybe some little change on information display. 13:22 hdl it would not add more loading on the page. 13:22 hdl look at the tab of one member which has current check out 13:21 hdl multiple return renewal date. 13:21 owen What features have you added to moremember.pl? 13:20 hdl ... 13:18 owen I think if we load circulation.pl with any more stuff it's going to be even slower than it is now 13:17 hdl (multiple return, renewal date ...) 13:16 hdl I say : if you/we remove tabs from moremember, it would be good to port things that were done on moremember checkout tab into circulation page. 13:15 owen I don't understand what you're trying to say. You're saying No, don't remove the lower tab because you're adding more features to moremember? 13:15 hdl (only a little performance concern) 13:14 hdl + then many data loaded in moremember wouldnot be used. 13:14 hdl + this would mean more overhead to get all the information when it was previously on the same page. 13:12 hdl And I would like them to be ported to circulation.pl 13:12 hdl I have added some features to moremember.pl page. 13:11 owen hdl, I think that's a valid concern. What if we removed the tab below, leaving only the left-hand one? 13:06 hdl kados : about moremember page, I think that this page is quite confused with the fact that it has issues and fines tabs on it "same" as left hand tabs but data are differently displayed. 13:02 Danny good morning 12:58 fbcit g'morning #koha 12:57 paul kados : done. 4 patches sent 12:56 nengard does this report: koha/reports/bor_issues_top.pl work? I get no results ... but it may be something to do with my system 12:56 paul OK. there are 2 other, but i think i didn't mail them yet. 12:55 kados and moredetail and item edition 12:55 kados paul: I have two from you, having to do with onloan field in items table 12:54 paul you should have some patches from me in your queue. any problem with them (you haven't pushed them yesterday, when you pushed 20) ? 12:54 paul hello kados. 12:53 kados OK 12:53 hdl sending them asap. 12:53 hdl hi 12:53 kados hdl: trying to plan around what to push up next, but don't want to create additional conflicts 12:52 kados hdl: any time frame on the fixes for bugs introduced recently? 12:52 owen Hi kados 12:52 kados morning all 12:39 paul daily reco = list the money you've got today (or yesterday) to check that physical purse is equal to "Koha purse" 12:39 nengard paul - that makes sense! thanks so much for this info!! 12:38 paul (mainly, it's for blockbuster I think) 12:38 paul Hold ratios = don't know how it works, but displays how many reserve you had for a given biblio, to help you choose if you have to buy more items 12:38 paul Holds awaiting pickup = list the reserves that are ready & await for the patron to take them at the library 12:37 paul only applicable if ReserveNeedReturn syspref=ON I think 12:37 paul Holds to pull => list the reserves you have to find in the shelves and do a return on to validate the hold. 12:37 paul Billing, I don't know. the others I know 12:36 nengard <nengard> Daily reconciliation 12:36 nengard <nengard> Billing 12:36 nengard <nengard> Hold ratios 12:36 nengard <nengard> Holds awaiting pickup 12:36 nengard nengard> Holds to pull 12:36 nengard circulation report question - I have these reports that I get no results for on my test system - it may be because I don't have enough data yet - can you tell me what they do? 12:34 paul hello nengard 12:34 nengard or good afternoon paul ;) 12:34 nengard morning owen and paul 12:33 paul (it's a holiday day today in France. I work, and the phone & mail is really quiet. good to be efficient ;-) ) 12:32 paul hello owen 12:32 owen Hi #koha