← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 12:00 | kyle | I really don't want to create merge tables and have to make everyone who uses my reports create them also, so I'd much rather do it the way you suggest. |
| 12:01 | so how would I combine 'items' and 'deleteditems' with 'statistics' | |
| 12:02 | hdl | Select IF(items.itemnumber IS NOT NULL, items.itemnumber, deleted_items.itemnumber) itemnumber WHERE issues left join items on issues.itemnumber=items.itemnumber left join deleteditems on issues.itemnumber=deleted_items.itemnumber |
| 12:03 | Sorry. | |
| 12:03 | kyle | wow, I wish koha would just use the MERGE tables instead ; ) |
| 12:03 | hdl | Change WHERE into FROM. |
| 12:03 | dewey | hdl: that doesn't look right |
| 12:06 | hdl | kyle. |
| 12:07 | kyle | yes hdl |
| 12:07 | hdl | Looking at merge tables, maybe you are right to use this. |
| 12:07 | BUT. | |
| 12:07 | kyle | ... |
| 12:07 | hdl | I hope taht other sqlengine can have the same facility. |
| 12:07 | kyle | you mean like postgresql? |
| 12:08 | or you mean like myisam? | |
| 12:10 | hdl | postgresql... |
| 12:14 | kyle | yes, it appears that postgresql supports a similar functionality |
| 12:14 | may I ask why? | |
| 12:18 | has there been thought of switching koha from mysql to postgres? | |
| 13:15 | hdl | kyle : thought of being sql manager independant is always present. Even though none of devs or clients are about to implement such a change in the next few months. |
| 13:15 | But thinking about it can be of great help. | |
| 13:15 | kyle | that's what I figured, try to keep one's options open |
| 13:16 | for the most part, mysql is the least feature rich dbms out there, so we have that on our side. | |
| 13:16 | has anyone had a chance to take a look at the ClubsAndServices stuff I committed? | |
| 13:17 | I was hoping to get some feedback. | |
| 13:17 | I should really make some npl templates for it, right now there are only ccfls templates. | |
| 13:17 | I thought I should talk to owen first. | |
| 13:18 | owen | kyle, I certainly don't mind if you want to make some npl templates |
| 13:18 | kyle | good to know, thanks owen. |
| 13:18 | owen | I'm so busy with another project right now that I don't much time to work on Koha |
| 13:18 | kyle | : / |
| 13:19 | Cindy and I are going to work on making a Koha virtual appliance this summer, after we've switched meadville to koha | |
| 13:19 | that would make for a nice way to have a test service in minutes. | |
| 15:08 | cm | hey owen, i just committed a modification to Members.pm that might help you out. |
| 15:08 | owen | Oh yeah? You found the problem with the blank expiry dates? |
| 15:09 | cm | sort of. |
| 15:09 | it calculates an expiry date if it doesn't exist when you're modifying a record. | |
| 15:09 | before it only did if you were adding a new one. | |
| 15:10 | it's in the modmember sub. | |
| 15:10 | still don't know why it's occuring initially, though. | |
| 15:11 | aack! i've got to go to a meeting. be back here later. | |
| 15:27 | hdl | cm |
| 15:27 | When you are back; I have a little remark on your commit. | |
| 15:28 | It looks that you are relying on Date::Manip and not Date::Calc. | |
| 15:28 | Which is not the standard we chose to use. | |
| 15:29 | I agree that you committed on dev_week and not rel_2_2... But The more we do standard dev. | |
| 15:29 | The less integration will be painfull. | |
| 16:03 | rch | owen: you around? |
| 16:03 | owen | yes |
| 16:03 | rch | got a javascript Q |
| 16:03 | owen | I'll do my best :) |
| 16:03 | rch | Stow reports the intranet is working well and fast in Opera |
| 16:04 | except for request.pl | |
| 16:04 | <input type="submit" name="submit" value="Place New Request" class="submit" onclick="if (this.form.member.value=='') { alert('Borrower Card Number Required'); return false; } else { this.value='Please wait...'; this.disabled=true;return true;}" /> | |
| 16:05 | The page hangs, form not submitted when you click this button. | |
| 16:05 | (i added the return true) | |
| 16:05 | owen | I'll check it out right now. They're Opera users hunh? |
| 16:06 | rch | well, the tech guy claims significant speed difference from FF. |
| 16:09 | owen | Yeah, definitely not working in Opera. I'll see what I can come up with. It was kind of a hack to begin with, but Koha doesn't prevent duplicate reserves. |
| 16:10 | Although librarians sometimes /want/ to be able to reserve multiple copies at a time... | |
| 16:11 | kyle | Does anyone know why the choice was made to have the catalog search display the homebranch of an item instead of the holdingbranch? |
| 16:11 | Under 'Location' in the intranet catalog search | |
| 16:12 | owen | kyle, I don't like that either. kados says I told him to do it that way in dev_week, but I deny it :) |
| 16:12 | It needs to be changed ASAP | |
| 16:12 | kyle | I just changed it, should I commit the change? |
| 16:12 | owen | I'd say so |
| 16:12 | kyle | ok, will do. |
| 16:14 | also under location, koha lists the call numbers after the location, but it lists *all* the call numbers at *every* location for *each* item | |
| 16:15 | owen | kyle, I'm not sure what you mean. do you have an example? |
| 16:15 | kyle | it seems that it should lists the call numbers for only the items held at each library. |
| 16:15 | Stone Memorial Library (1), (ECLS Coll. 4 | ECLS Coll. 1) | |
| 16:15 | Meadville Public Library (1), (ECLS Coll. 4 | ECLS Coll. 1) | |
| 16:16 | Call number ECLS Coll. 1 is held at Stone Memorial, ECLS Coll.4 is held at Meadville Public Library | |
| 16:16 | owen | Are you talking about the search results screen? |
| 16:16 | kyle | yes |
| 16:19 | owen | Ours doesn't display that way... I'm not sure why |
| 16:20 | kyle | interesting...I'll have to dig further. Which version are you running? |
| 16:20 | owen | dev_week from CVS, not updated in a while |
| 16:21 | kyle | ok, we're running dev_week too. I'll have to do some digging I guess. |
| 16:41 | hdl | kyle rel_2_2 display as such : |
| 16:41 | 11 | |
| 16:41 | ||
| 16:41 | CPPM (2) (EC1-ACC-91) | |
| 16:41 | ||
| 16:41 | IPNL (CERN11 - Bib) | |
| 16:41 | ||
| 16:41 | IPNO (EC 458-NOO 1) | |
| 16:41 | ||
| 16:41 | LAL (210.60-24-A) | |
| 16:41 | ||
| 16:41 | LAL (210.60-24-B) | |
| 16:42 | ||
| 16:42 | LAPP (CERN RJ) | |
| 16:42 | ||
| 16:42 | LPCC (RAP) | |
| 16:42 | ||
| 16:42 | LPCC (CERN) | |
| 16:42 | ||
| 16:42 | LPNH (300 NOO 1) | |
| 16:42 | ||
| 16:42 | LPSC (09) | |
| 16:42 | (When more than 1 item, put item count in 1st ()) | |
| 16:42 | CPPM LAL is a branchcode. | |
| 16:46 | toins | hi all |
| 16:46 | rch | hi toins |
| 17:00 | owen | rch, I just committed modified version of request.tmpl and common.js.inc that should fix the Opera problem. Works for me now in Opera 9 |
| 17:01 | rch | great! thx owen |
| 17:02 | cm | kyle, ours has all of them because we're using itemcallnumber instead of callnumber or dewey or whatever it is normally. |
| 17:03 | we often don't have callnumber in our records, but we always have itemcallnumber. | |
| 17:03 | hdl, you're right about using date:calc. i'll look into converting it. | |
| 17:03 | yeah owen, you're right. | |
| 17:05 | hdl, i just copied & pasted some code from the newmember sub. I guess Members.pm hasn't been converted to use Date:Calc in dev_week yet. | |
| 18:20 | hdl | kados around ? |
| 18:21 | cm in rel_2_2 it was. | |
| 19:10 | cm | hdl: rel_2_2 uses Date:Calc? |
| 20:15 | hdl, nevermind, I see that it does. I changed dev_week so it uses Date::Calc too. Someone might want to have a glance at it to be sure I didn't miss anything, though. | |
| 20:38 | hdl | cm : I cannot test dev_week. We donot have time enough. |
| 20:38 | will kados come around ? | |
| 20:45 | cm | hdl, that's okay. i can relate. ;) |
| 20:46 | hdl | cm thanks for your understanding. |
← Previous day | Today | Next day → | Search | Index