← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:05 | CGI500 left #koha | |
| 00:42 | cait left #koha | |
| 00:54 | davi left #koha | |
| 01:01 | davi joined #koha | |
| 01:22 | pianohacker left #koha | |
| 01:46 | davi left #koha | |
| 01:46 | davi_ joined #koha | |
| 02:01 | davi_ left #koha | |
| 02:09 | davi_ joined #koha | |
| 02:45 | wizzyrea_ left #koha | |
| 02:49 | Jo joined #koha | |
| 02:49 | Jo | afternoon all |
| 02:53 | thinking about barcodes for patron cards in Koha 3.2 does "Code 25 Interleaved 2 of 5" sound like the 'type' we are after | |
| 02:56 | Joann joined #koha | |
| 02:56 | Joann | or code 39 ... |
| 02:56 | and does it even matter :) | |
| 02:57 | chris_n2 | Joann: code39 most likely |
| 02:57 | although it can do coop25 | |
| 02:57 | which is what I think code25 is | |
| 02:58 | maybe | |
| 02:58 | Joann | Thanks Chris. |
| 02:58 | commercial printer is suggesting code 39 - just wanted to check. | |
| 02:58 | chris_n2 | code39 allows for the greatest breadth of chars |
| 02:58 | Joann | and the labelgenerator produces code39? |
| 02:59 | chris_n2 | 25 only allows digits 0-9 |
| 02:59 | yes | |
| 02:59 | indradg left #koha | |
| 02:59 | Joann | there you go then : we need an alpha character :) |
| 02:59 | 39 it is. | |
| 02:59 | Thanks for your help | |
| 02:59 | chris_n2 | we have cataloged nearly 7000 items printing our own code39 labels from koha |
| 03:00 | np | |
| 03:03 | Jo left #koha | |
| 03:05 | faski_is_a_cunt joined #koha | |
| 03:07 | faski_is_a_cunt left #koha | |
| 03:38 | Amit joined #koha | |
| 03:41 | Amit | heya brendan |
| 03:42 | good morning #koha | |
| 03:57 | SelfishMan_ joined #koha | |
| 04:06 | richard left #koha | |
| 04:10 | chris_n2 | howdy Amit |
| 04:10 | Amit | hi chris_n2 |
| 04:10 | SelfishMan_ left #koha | |
| 04:54 | Joann left #koha | |
| 05:15 | chris_n2 | g'night #koha |
| 06:17 | nicomo joined #koha | |
| 07:03 | Ropuch | Morning #koha |
| 07:35 | francharb joined #koha | |
| 07:45 | laurence joined #koha | |
| 07:54 | Amit | heya nicomo, Ropuch |
| 07:54 | nicomo | hi Amit, Ropuch |
| 08:02 | paul_p | hello #koha |
| 08:02 | Kivutar joined #koha | |
| 08:05 | toins | hello all |
| 08:26 | kf joined #koha | |
| 08:26 | kf | good morning #koha |
| 08:30 | magnus | good morning all |
| 08:34 | nicomo | morning magnus |
| 08:34 | and kf | |
| 08:34 | magnus | morning nicomo et al |
| 08:36 | kf | hi magnus and nicomo |
| 08:37 | magnus | hiya kf |
| 08:55 | Amit | heya kf, magnus |
| 08:55 | magnus | hi Amit |
| 08:56 | kf | hi Amit |
| 09:01 | chris | hi all |
| 09:05 | http://www.webinito.com/blogs/[…]management-system | |
| 09:12 | kf | hi chris |
| 09:12 | chris | hiya kf |
| 09:14 | toins left #koha | |
| 11:07 | Amit | heya chris |
| 11:29 | francharb left #koha | |
| 11:33 | francharb joined #koha | |
| 11:39 | zico left #koha | |
| 11:44 | Genji left #koha | |
| 11:52 | magnus | for those not on twitter: http://koha.web2learning.net/2[…]e-1-january-2010/ |
| 11:52 | nengard++ | |
| 11:56 | kf | nengard++ |
| 11:57 | reading it atm, great news :) | |
| 12:08 | Amit | happy weekend to all |
| 12:09 | chris_n2 | you too Amit |
| 12:10 | Amit left #koha | |
| 12:13 | chris_n2 | nengard++ |
| 12:22 | nengard joined #koha | |
| 12:42 | collum joined #koha | |
| 12:49 | gmcharlt left #koha | |
| 12:49 | jwagner joined #koha | |
| 12:51 | magnus | nengard: http://stats.workbuffer.org/ir[…]10-01-15#i_373568 |
| 12:51 | ;-) | |
| 12:52 | nengard | magnus - you know I was waiting all week for today to come so it would be published - and today I completely forgot!!! :) |
| 12:52 | glad you all like it | |
| 12:52 | Now i need ot send it out to the mailing list ;) | |
| 12:54 | gmcharlt joined #koha | |
| 12:55 | paul_p | nengard: ++ for the koha newspaper. Can I suggest to have the chapter titles in the document as well ? (Events, News from libraries, Tips & Tricks) |
| 12:55 | nengard | paul_p you can suggest anything!! :) And I will put them in :) |
| 12:56 | paul_p | nengard: so, I suggest that ;-) |
| 12:56 | jdavidb joined #koha | |
| 12:56 | nengard | hehe - I'll get right on that - however it won't be in the email which has already been sent ... |
| 12:56 | paul_p | mmm... someone from ptfs... hi jdavidb ! |
| 12:56 | good morning ! | |
| 12:57 | jdavidb | Bonjour, paul_p! :) Happy Friday. |
| 12:57 | jwagner | paul_p, I'm hurt! :-) |
| 12:57 | paul_p | oh ! jwagner, you're here too ! |
| 12:57 | jwagner | Bonjour! |
| 12:58 | magnus | good morning j-people ;-) |
| 13:00 | jdavidb | Hi, magnus. :) |
| 13:00 | hdl_laptop | hi |
| 13:00 | gmcharlt left #koha | |
| 13:00 | nengard | can you guys tell me how to update the topic for the channel? I remember chris saying that anyone can do it |
| 13:00 | jdavidb | The /topic command may be helpful, nengard. |
| 13:01 | nengard | jdavidb do i use that command and then the topic? |
| 13:01 | cause just that command shows me the topic :) | |
| 13:01 | jdavidb | (Here I am, doing reference work for a *librarian*....) I would suggest a quick google search for "+irc +topic". |
| 13:01 | ;-) | |
| 13:02 | kf | nengard: can you open the links to projects, libraries... in the newsletter in a new window? |
| 13:03 | nengard | kf - i can |
| 13:04 | jdavidb | (nengard: try /topic #koha <newtopicstring> ) |
| 13:05 | kf | nengard: sorry, just a suggestion, it really looks great |
| 13:05 | nengard | no prob at all - doing it now with paul_p's edits |
| 13:07 | kf | thx! |
| 13:10 | brendan | Later everyone - hopefully we see some of you in Boston. If not we'll be back :) |
| 13:11 | brendan left #koha | |
| 13:14 | davi_ left #koha | |
| 13:18 | davi joined #koha | |
| 13:18 | davi left #koha | |
| 13:19 | nengard | okay updates made |
| 13:19 | thanks all for submitting news!! you guys helped me make this great!! | |
| 13:20 | community++ :) | |
| 13:21 | magnus | nengard: i could do "koha in norway" for the next issue, if you are interested? won't be very long... ;-) |
| 13:21 | nengard | Yes Yes Yes :) |
| 13:21 | we don't need long | |
| 13:21 | I personally think shorter entries are better | |
| 13:21 | schuster joined #koha | |
| 13:23 | chris_n | g'morning |
| 13:25 | schuster | chris_n - was it you that indicated that you are printing barcodes for items? |
| 13:25 | chris_n | it sure was |
| 13:26 | nearly 7k so far without too much difficulty | |
| 13:26 | schuster | What type of printer are you using to print those just curuios. |
| 13:26 | * chris_n | is sure that is a small number for TX ;-) |
| 13:26 | chris_n | om |
| 13:26 | schuster | om is that a brand or? and it lets you print one at a time? |
| 13:26 | chris_n | a Ricoh AP400N |
| 13:26 | no | |
| 13:27 | this is a network laser | |
| 13:27 | we print sheets | |
| 13:28 | schuster | hm... Guess I should develop a printer that allows you to print labels one at a time and isn't heat sensative! We are using the Dymo labelwriters to print spine |
| 13:28 | chris_n | Avery 5160 |
| 13:28 | schuster | labels one at a time, but after about 5 years or so some of the labels are fading depending on the tape the librarian may have put on them. |
| 13:28 | chris_n | we use a clear book tape from 3M iirc |
| 13:29 | I'm not sure how they'll do in the long run | |
| 13:29 | schuster | We used to be using dot matrix printers but they were so big, these dymos are nice. We use JLAR-crystal clear which has been a great tape for over 14 years. |
| 13:29 | chris_n | but I would think that thermal labels might present that sort of problem over time |
| 13:29 | * chris_n | wonders if that tape is cheaper than 3M's |
| 13:30 | schuster | yes the thermal depending if the glue on the tape is a gas type adhesive accelerates the fading. |
| 13:30 | We even had some nock of labels that we put on books and after a week they all faded so we went back to the Dymo brand. | |
| 13:31 | chris_n | we had some issues with the type cracking on some of our labels |
| 13:31 | schuster | My test was to print labels and put different tapes on them and hang them in my car for a week in the summer to see which ones faded. |
| 13:31 | chris_n | but a new fuser unit corrected that |
| 13:32 | probably a good test considering that is where many books end up residing while check out I'm sure | |
| 13:32 | owen joined #koha | |
| 13:33 | chris_n | morning owen |
| 13:33 | owen | Hi |
| 13:35 | schuster | Hey owen! |
| 13:35 | owen | Good morning jdavidb and jwagner, nice to have you back :) |
| 13:35 | jwagner | Thanks owen. We missed you guys :-( |
| 13:36 | schuster | owen - have you had any brainstorms on my question the other day about an icon driven search? and limiting to a specific location? |
| 13:36 | (kidspac for k-3rd grade) | |
| 13:37 | You may not have given it any thought and that is ok too. | |
| 13:41 | owen | schuster: /msg'ing you. |
| 13:44 | Topic for #koha is now Koha Newsletter #1 Released: http://bit.ly/5fKZA5 | |
| 13:46 | owen | nengard++ # for the Koha newsletter! |
| 13:46 | nengard | thanks owen |
| 13:48 | bebbi joined #koha | |
| 13:51 | chris_n | shouldn't installer rewrite the zebra startup scripts even in dev mode? |
| 13:53 | :q | |
| 13:53 | opps :-) | |
| 13:55 | magnus | trying to close irc without saving? |
| 13:55 | :-) | |
| 13:55 | chris_n | heh |
| 13:55 | xchat does not seem to take vim commands well | |
| 13:59 | jdavidb | Chatzilla doesn't, either, chris_n. I've tried, repeatedly. |
| 13:59 | chris_n | lol |
| 14:09 | davi joined #koha | |
| 14:17 | jdavidb left #koha | |
| 14:18 | davi left #koha | |
| 14:20 | owen | Regarding the kudos discussion earlier, I'm wondering the same thing as brendan: "I don't see much incentive for a developer/"vendor" to join - if he's not consider a full member." |
| 14:22 | * chris_n | gave some feedback with the hope that there will be some clarification/reconsideration |
| 14:40 | wizzyrea | >.> http://wizzyrea.wordpress.com/[…]new-day-for-koha/ |
| 14:45 | chris_n | wizzyrea++ |
| 14:45 | very nicely said | |
| 14:46 | CGI226 joined #koha | |
| 14:46 | wizzyrea | ty, was tired of being quiet :/ |
| 14:46 | CGI226 left #koha | |
| 14:47 | magnus | wizzyrea++ # “coopetition” is good - did you come up with it or is it an established term? |
| 14:47 | wizzyrea | nope, I got it from gmcharlt, who got it from... somewhere else |
| 14:47 | he told me but I can't remember | |
| 14:48 | he said it at kohacon, stuck with me : | |
| 14:48 | :) | |
| 14:48 | magnus | ok, nice! |
| 14:52 | slef | coopetition is a fairly common idea among cooperatives |
| 14:52 | we have cooperation among cooperatives as a basic principle, but sometimes we are selling similar services | |
| 14:53 | wizzyrea | that was my understanding of the term |
| 14:54 | slef | am mildly amused by this week's machinations because I'm pretty sure at least one of those has asked if the co-op was for sale (which is a #coops comprehension #fail) |
| 14:54 | wizzyrea | it would be ok if you were wholly amused by this weeks machinations :) |
| 14:55 | it certainly triggered a certain amount of nervous, ironic, and gleeful giggling here | |
| 14:56 | slef | no, it's not wholly amusing when one foss player (at least in theory, even if it was going to be abandonware from now on) has been bought by a mixed proprietary+foss player |
| 14:56 | it's going to be good for our financial goals, but probably bad for our social goals | |
| 14:57 | Have the reasons for the merger been stated explicitly beyond the press release and letter to customers? I don't really buy that spin. | |
| 14:58 | owen | Not that I've heard. |
| 14:58 | Let the speculation run wild. | |
| 14:59 | I think it was getting on time to write off that player as a foss player, fwiw. | |
| 14:59 | slef | There's a classic line in the letter where Josh is "impressed by their resources" or something like that. |
| 14:59 | * chris_n | ducks |
| 14:59 | davi joined #koha | |
| 15:00 | wizzyrea | I"m with owen |
| 15:00 | yea well, that's fairly common post-acquisition butt-licking. | |
| 15:01 | erm, sorry | |
| 15:01 | owen | :P |
| 15:01 | chris_n | I'd say one company was in its death-spiral and another stepped in and caught it before it hit the deck |
| 15:01 | slef | That's my impression, based on the experiences that companies clam up as they start the spiral. |
| 15:02 | owen: like they say about the success of the French Revolution, it was too early to tell. | |
| 15:02 | biab | |
| 15:03 | nengard | wizzyrea++ YOU ROCK!!!! Thank you!! |
| 15:03 | * slef | basks in the lack of context |
| 15:09 | owen | I wonder if PTFS Europe's request to be listed on koha.org will be approved now? |
| 15:09 | slef | I wonder if Kyle's request will be approved now. |
| 15:11 | atz left #koha | |
| 15:12 | nengard | i wonder if the community's request to control the website will be approved so we can work together and decide what gets approved |
| 15:15 | chris_n | slef: the noise of the free-fall usually drowns out the ability to converse once things are nose down |
| 15:16 | slef | nengard: do you think PTFS is less worried about being sued by PTFS than LibLime were? |
| 15:16 | nengard | slef ... huh? |
| 15:17 | you mean librarians less worried? | |
| 15:18 | owen | slef is referring to past unpleasantness bewteen LL & PTFS |
| 15:19 | nengard | oh - i have no clue |
| 15:19 | slef | yes, owen++, fear of being sued for contraversial remarks about other vendors was ostensibly the reason for kick-banning all non-LL webmasters, wasn't it? |
| 15:20 | I'm not sure it was ever explicitly said that it was PTFS they feared, but that's my assumption because I think that's the only one ever criticised on the site. | |
| 15:20 | nengard | i thought it was just lack of trust for anyone else |
| 15:20 | slef | I'm sure I was told it was some legal advice. |
| 15:20 | Although I don't know who from. | |
| 15:20 | nengard | we were all told things ... |
| 15:21 | slef | ok, now to sort out a web shop |
| 15:24 | rhcl | just catching up on reading...looks like wizzyrea put a little bit of cayenne pepper on her bacon this morning |
| 15:33 | chris_n | heh |
| 15:39 | anybody about running pazpar2? | |
| 15:46 | kf | wizzyrea++ #blog post |
| 16:12 | davi left #koha | |
| 16:16 | Kivutar left #koha | |
| 16:17 | jwagner | Am I correct in believing there is no way to turn off holds overall in the system? There's a syspref for not allowing them in the OPAC, but there doesn't seem to be any way to turn them off in staff mode. Would such a switch be desirable? |
| 16:19 | owen | jwagner: Other than defining zero as the maximum number of holds, I don't think there's a global switch |
| 16:19 | A global switch would let you hide all the holds links and such | |
| 16:20 | jwagner | owen, yes, that's my problem. I can set the zero for max holds, but the links still show up. This is a specialized system that will never allow holds. I could do a screen change to remove the button, but I wondered if others would find a syspref switch useful. |
| 16:21 | owen | It's conceivable I suppose, but I've never heard a request for it |
| 16:21 | jwagner | It would only be applicable for special libraries, I think. I've never heard of a public/academic that didn't want to allow holds. |
| 16:23 | owen | One of these days I'm going to hear of a Koha using library that doesn't want to check out books, place holds, search for books, or anything at all. |
| 16:23 | It'll probably be one of your customers jwagner ;) | |
| 16:23 | jwagner | Quite likely -- we do get some very specialized requirements! |
| 16:23 | schuster, you online? | |
| 16:24 | Ropuch | Evening #koha |
| 16:24 | nengard left #koha | |
| 16:24 | owen | Hi Ropuch, how are things in your part of the world? |
| 16:25 | Ropuch | Good, thanks |
| 16:32 | nengard joined #koha | |
| 16:32 | kf | Guten Abend Ropuch :) |
| 16:38 | CGI120 joined #koha | |
| 16:38 | CGI120 | how can I found out my user name and password to start working with Koha? |
| 16:41 | owen | CGI120: Did you just install Koha? |
| 16:42 | CGI120 | yes |
| 16:42 | hdl_laptop | t'is your koha database user name and password |
| 16:44 | owen | ...which you can find in koha-conf.xml if you've forgotten it. |
| 16:44 | Ropuch | ...which is in /etc/koha ;> |
| 16:45 | owen | You'll want to immediately create a patron record with superlibrarian privileges to act as your administrative user. |
| 16:51 | * slef | merges koha with wordpress on one site, doing Very Evil Things to keep them isolated |
| 16:52 | slef | at least at a systems security level |
| 16:55 | * owen | is sifting through all his bug-fix branches trying to find out which have been merged with biblibre-community |
| 16:56 | * chris_n | wonders why people have a hard time following simple directions |
| 16:57 | hopes no patches get dropped during the great merge | |
| 16:58 | owen | chris_n: I'm trying to clean house so that I'll know if any of mine have been missed. |
| 16:59 | JLsoft^_^ joined #koha | |
| 16:59 | JLsoft^_^ left #koha | |
| 16:59 | * owen | is flexing his conflict-resolving muscles today |
| 17:00 | jwagner | owen, that sounds like an ...interesting... avocation. Or do you just limit it to code conflicts? |
| 17:01 | * jwagner | has vision of owen as general marriage, work, all-purpose counselor |
| 17:03 | chris_n | lol |
| 17:04 | hdl_laptop | owen some more coming soon |
| 17:04 | laurence left #koha | |
| 17:14 | owen | Do y'all use git-mergetool? Useful? If so, what tool do you use? |
| 17:23 | gmcharlt joined #koha | |
| 17:23 | nengard | owen - I went through my patches and fixed those that weren't merged into the community branch - so I too did some cleanup |
| 17:30 | kf | bye #koha and a have a nice weekend everybody |
| 17:30 | owen | bye kf |
| 17:30 | kf left #koha | |
| 17:30 | * owen | doesn't understand how Meld does one any good if you can't see the lines that are being compared |
| 17:31 | paul_p left #koha | |
| 17:32 | schuster | jwagner you need something? I've been busy working with Owen on a special project |
| 17:33 | owen | Mysterious. |
| 17:33 | jwagner | no, not really -- I'll catch up with you later. |
| 17:34 | schuster | OK - well that's all for me today I have meetings all afternoon and then it is a 3 day weekend!! Monday off! |
| 17:34 | schuster left #koha | |
| 17:42 | jwagner | Question for folks. The action_logs table records patron edits among other things, and I've used it to produce a list of patrons who had their records touched within X timespan. How can I get a list of patrons who HAVEN'T had their records touched within X timespan? There's no timestamp in the borrowers table, and if they haven't had any edits there wouldn't be an entry in action_logs. |
| 17:44 | chris_n | maybe you could script it and select all from borrowers who were not in action_logs |
| 17:44 | moodaepo | wizzyrea++ #blog post |
| 17:45 | jwagner | chris_n, that's vaguely what I was thinking, but couldn't quite grasp the logic I'd use. |
| 17:46 | * chris_n | thinks action_logs.user should have a fk constraint... |
| 17:50 | chris_n | jwagner: you might even be able to do it with a sql join |
| 17:51 | jwagner | Hrmmm. Will have to dig a bit. Thanks. |
| 17:52 | chris_n | you might be able join action_logs.user on borrowers.borrowernumber in a way that would allow you to retrieve records which did not join from the borrowers table |
| 17:52 | jwagner | I'll ask one of our SQL experts on that one. (I'm not an expert, I just play one on TV....) |
| 17:53 | But I wanted to make sure I wasn't missing something, like a timestamp in some other table or anything. | |
| 17:53 | It is the action_logs that I need? | |
| 17:53 | thd is now known as thd-away | |
| 17:55 | jwagner is now known as jwagner_lunch | |
| 17:55 | chris_n | borrowers does not have a timestamp field, but probably should have on on update timestamp |
| 17:55 | this would make such reporting much easier I'd think | |
| 17:56 | apart from that, I think you are right | |
| 17:56 | jwagner_lunch | Yes, I'd think so -- items & other things have a timestamp, it would be useful for patrons too. |
| 17:56 | Thanks. (lunch is calling....) | |
| 18:07 | chris_n | jwagner_lunch: actually, that is over simplified, but action_logs is the table you want I think |
| 18:08 | chris | yeah left join, and all the rows where the action_logs table is not null and the date there is after a certain time, that will do it |
| 18:10 | gmcharlt left #koha | |
| 18:15 | cait joined #koha | |
| 18:15 | cait | hi all |
| 18:19 | Genji joined #koha | |
| 18:22 | chris | hi cait |
| 18:22 | chris_n | hi christ |
| 18:22 | chris | lol |
| 18:23 | chris_n | jwagner_lunch: something like this might be workable for you: |
| 18:23 | owen | Now hang on chris_n, he's not RM yet |
| 18:23 | chris_n | SELECT surname, firstname FROM borrowers WHERE borrowernumber NOT IN (SELECT b.borrowernumber FROM borrowers AS b LEFT JOIN action_logs AS a ON b.borrowernumber = a.object WHERE a.action <> 'CREATE' AND a.timestamp < '2008-03-11') LIMIT 0,10; |
| 18:23 | opps | |
| 18:23 | chris, even | |
| 18:23 | jdavidb joined #koha | |
| 18:23 | cait | hi chris |
| 18:24 | jwagner_lunch is now known as jwagner | |
| 18:24 | jwagner | Thanks, chris_n -- I'll give that a try. |
| 18:24 | chris_n | you'd have to exclude create actions, because there will be one for every patron |
| 18:26 | jwagner | I'm trying to do it as a saved report, and it's complaining about the CREATE command. |
| 18:26 | chris_n | and drop the limit clause of course |
| 18:28 | wow, creating sql reports seems to be busted in HEAD, can anyone confirm that | |
| 18:28 | chris | it wasnt last time i tried |
| 18:29 | chris_n | om |
| 18:29 | k, it works | |
| 18:29 | * chris_n | was too quick on the trigger there |
| 18:30 | chris_n | jwagner: yeah, the "security" check is false triggering there |
| 18:30 | that module attempts to keep the user from executing malicious sql | |
| 18:31 | ie. DROP, CREATE, etc. | |
| 18:31 | jwagner | I tried stripping out the create section, and then it complained something about return of 1 |
| 18:32 | chris_n | it works here |
| 18:33 | except the limit clause for some reason | |
| 18:33 | jwagner | Just got a version of it to work too. I dunno.... |
| 18:34 | chris_n | hmm.... the query parser code needs work probably |
| 18:35 | * chris_n | did some work on that code a while back for the company you guys just acquired :-) |
| 18:35 | chris_n | it seems that reports wanted a good going over, though iirc |
| 18:35 | chris | there is patch for the limit |
| 18:35 | its in the queue | |
| 18:35 | to make the limit actually work | |
| 18:35 | chris_n | cool |
| 18:36 | * chris | did the initial reports module, when working at the acquired company too |
| 18:37 | * owen | 's library sponsored initial development of that module at said acquired company |
| 18:38 | chris | :) |
| 18:38 | jwagner | So that means we can call on all of you, right??? |
| 18:38 | * jdavidb | points at jwagner and says, "What she said!" |
| 18:39 | chris | the limit code should make it a lot more useful (the fix) |
| 18:39 | and that create one is a hard one | |
| 18:39 | because that could be a subquery | |
| 18:39 | jwagner | Hmmm. chris_n, I ran a version like this: SELECT borrowernumber, cardnumber, surname, firstname, dateenrolled FROM borrowers WHERE borrowernumber NOT IN (SELECT b.borrowernumber FROM borrowers AS b LEFT JOIN action_logs AS a ON b.borrowernumber = a.object WHERE a.timestamp < '2009-02-02') |
| 18:40 | Then I picked one of the borrower numbers from the results & queried the action_logs for that borrower # -- it's showing lots of transactions more recently than the date I used. | |
| 18:41 | timestamp is one of those date plus time fields, but I thought the <> operators would work with just a date input. | |
| 18:41 | chris | yep they do |
| 18:41 | its implicitly 00:00:00 | |
| 18:41 | chris_n | what he said |
| 18:42 | jwagner | It also occurs to me that if the date check worked, it would still pick up people who had log entries both before & after the date. Correct? |
| 18:42 | chris_n | we'd be in trouble if irc was connected directly to our brains ;-) |
| 18:42 | chris | yes |
| 18:42 | cos its saying not in | |
| 18:42 | so it drops on the transaction | |
| 18:43 | but not all transactions | |
| 18:43 | so if they have one before and one after, they will get counted, because of the after one | |
| 18:44 | or maybe not, its saturday morning and i havent had coffee | |
| 18:44 | so ignore me | |
| 18:44 | jwagner | Right, and I think that's the problem -- they only want to find records that have NO log entries after the specified date. I also think the where clause needs an extra and a.module = 'MEMBERS' -- the borrower number I picked turned out to match a biblio number |
| 18:46 | chris | yeah that could happen |
| 18:52 | davi joined #koha | |
| 18:57 | nicomo left #koha | |
| 19:04 | bebbi left #koha | |
| 19:07 | gmcharlt joined #koha | |
| 19:09 | chris_n | jwanger: that's right... the a.object may not always be a member |
| 19:09 | * chris_n | thought of that, but failed to mention it |
| 19:10 | chris_n | heya gmcharlt |
| 19:10 | gmcharlt | hi chris_n |
| 19:12 | chris | hows boston? had some um beans? |
| 19:13 | owen | Never has being at an ALA meeting been so appealing, and for entirely unproductive reasons :) |
| 19:14 | * jwagner | almost wishes my foot were well enough to let me travel -- I'm missing all the fun :-) |
| 19:17 | gmcharlt | I'm attending the RMG president's program now |
| 19:17 | chris: I've consumed no beans yet ;) | |
| 19:17 | matts_ left #koha | |
| 19:19 | chris | whats the other famous thing, clam chowder? |
| 19:19 | gmcharlt | yep |
| 19:20 | davi left #koha | |
| 19:20 | chris_n | clam_chowder++ |
| 19:20 | jwagner | chris, I lived in Boston for several years. It's pronounced CHOW-dah :-) |
| 19:21 | Of course, a lot of things are pronounced differently in Boston... | |
| 19:24 | owen | I thought it was pronounced BWAH-ston |
| 19:25 | * jdavidb | checked into rental of body armor, at the point when it looked like he was going to Boston... |
| 19:25 | chris | :) |
| 19:26 | i remember the traffic being particularly scary | |
| 19:26 | but the city itself was neat | |
| 19:26 | expensive as a tourist, but lots of neat stuff to see | |
| 19:27 | CGI120 left #koha | |
| 19:27 | gmcharlt | kados is not speaking on the panel; replaced by PTFS' John Yokley |
| 19:27 | chris | ohhh interesting |
| 19:29 | jdavidb | Rob McGee is an interesting individual. He consulted with the library consortium I was with several times, and the difficult relationships he has with ILS vendors is apparently the stuff of legends. |
| 19:29 | chris | sounds like marshall had the right info |
| 19:29 | davi joined #koha | |
| 19:29 | chris | heh |
| 19:29 | jdavidb | I thought Pat Sommers was gonna slug him once during our contract negotiations. |
| 19:31 | * owen | finishes sorting through his bugfix branches: 9 unfinished jobs, 8 possibly forgotten sent patches |
| 19:35 | chris_n | chris: so which pazpar2 package should I use? |
| 19:36 | chris | um, the newest one |
| 19:36 | chris_n | heh |
| 19:37 | there appear to be several variations on a theme of pazpar2 in there | |
| 19:39 | chris | ahh just the pazpar2 one .. near the bottom |
| 19:44 | nengard left #koha | |
| 19:46 | * chris_n | gets pazpar2 running |
| 19:46 | chris_n | tnx |
| 20:01 | owen | does anyone know if there is a pending patch that fixes batch item editing? |
| 20:02 | I can't even find a bug report now, maybe one doesn't exist. | |
| 20:03 | chris | hmm not sure owen |
| 20:04 | collum left #koha | |
| 20:07 | jdavidb left #koha | |
| 20:28 | owen | Damn I hate bugs that are hard to pin down! Batch item edit is behaving completely randomly. |
| 20:36 | nengard joined #koha | |
| 20:37 | hdl_laptop | owen: ? |
| 20:38 | owen | hdl_laptop: Sometimes when I try a batch item edit nothing changes, other times it changes some fields and not others. |
| 20:39 | hdl_laptop | mmm... is it really random ? |
| 20:40 | owen | That's what I'm trying to figure out |
| 20:40 | hdl_laptop | oh.... I guess I found what is making that bug. |
| 20:40 | it is because of frameworks. | |
| 20:41 | try out the one on Univ_Lyon3 branch to see if it works better. | |
| 20:41 | I think we fixed that bug on that branch | |
| 20:47 | In fact, koha2MARC links should be used only on default framework. | |
| 20:47 | And especially items fields linking have to be the same for all the frameworks, if not, you may have such problems. | |
| 20:48 | gmcharlt_ joined #koha | |
| 20:48 | gmcharlt left #koha | |
| 20:51 | jwagner left #koha | |
| 20:52 | nengard left #koha | |
| 20:55 | francharb left #koha | |
| 21:12 | chris_n | bbl |
| 21:12 | nengard joined #koha | |
| 21:12 | * chris | wonders if anything interesting came out of hte rmg session |
| 21:13 | gmcharlt_ left #koha | |
| 21:14 | chris | ill take that as no comment |
| 21:15 | nengard left #koha | |
| 21:15 | owen | hdl_laptop: Switching to Univ_Lyon3 is prompting me to update my database. Is that going to cause me problems when I switch back to 3.2_community? |
| 21:16 | hdl_laptop | could be. |
| 21:17 | chris | owen, what i would do |
| 21:17 | mysqldump the db | |
| 21:17 | do the upgrade | |
| 21:17 | when you switch back, reload the dump | |
| 21:18 | then you are back how you weer | |
| 21:18 | hdl_laptop | indeed. |
| 21:18 | chris | (i tend to do a mysqldump before any db upgrades, so i can roll back if needed) |
| 21:19 | hdl_laptop | We only add fields. so ***should*** not break anything. |
| 21:19 | owen | Do I need to pass any particular flag to mysqldump to make sure it includes "drop table if exists" etc.? |
| 21:19 | hdl_laptop | But you have to be cautious. |
| 21:20 | chris | i pass --opt |
| 21:20 | which does add-drop-table and a few other ones | |
| 21:20 | hdl_laptop | --add-drop-table |
| 21:22 | chris | --opt |
| 21:22 | This option is shorthand; it is the same as specifying --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset. It should give you a fast dump operation and produce a dump file that can be reloaded into a MySQL server quickly. | |
| 21:22 | thats what i use | |
| 21:26 | owen | hdl_laptop: No luck. I put in one barcode, chose a new collection code. The result was no change. |
| 21:27 | hdl_laptop | thanks for trying anyway. |
| 21:27 | looks strange though. We sucessfully tested on a 3000 items. | |
| 21:28 | owen | I'm about to quit for the day, but if you think of anything I can do to help test let me know |
| 21:29 | hdl_laptop | can you be so kind as to send me your database so that I can test ? |
| 21:44 | owen left #koha | |
| 22:28 | davi left #koha | |
| 22:32 | ianB joined #koha | |
| 22:35 | ian joined #koha | |
| 22:36 | ianB left #koha | |
| 22:36 | ian is now known as ianB | |
| 22:38 | ianB left #koha | |
| 22:39 | ianB joined #koha | |
| 22:40 | ianB left #koha | |
| 22:47 | cait left #koha | |
| 23:02 | indulcitor joined #koha | |
| 23:02 | davi joined #koha | |
| 23:03 | indulcitor left #koha | |
| 23:06 | CGI512 joined #koha | |
| 23:07 | moodaepo left #koha | |
| 23:07 | CGI512 left #koha | |
| 23:15 | Sharon left #koha | |
| 23:24 | magnus left #koha | |
| 23:35 | davi left #koha | |
| 23:57 | davi joined #koha |
← Previous day | Today | Next day → | Search | Index