Time Nick Message 23:59 chris i wouldnt download them as either 23:59 wasabi mib_yjs7r: you should ask your vendor to install php-myadmin on your koha-server 23:59 mib_yjs7r should i download as comma or tab separated text? 23:58 mib_yjs7r i guess the liblime people created them 23:58 mib_yjs7r i notice there are some reports saved alreadt 23:57 chris go back to reports, choose use saved 23:57 mib_yjs7r now how do I run it? :p 23:57 chris try running it now 23:57 chris cool 23:56 mib_yjs7r ok i saved it 23:56 chris :) 23:56 mib_yjs7r i guess i'm blind 23:56 mib_yjs7r i saw the sql box! 23:55 mib_yjs7r sorry 23:55 chris cant hurt :) 23:55 chris try putting it in the notes 23:54 chris maybe there is another screen after 23:54 mib_yjs7r there is no sql box, just a box that says "notes:" to the upper left 23:52 chris (this is what i mean by being hard, this is different to koha, in koha there is a box called sql) 23:52 chris no 23:52 mib_yjs7r ok i guess that's the "notes:" box 23:52 chris changing the_number to the number that you took a note of before 23:52 chris cut and paste that in, into the big box for sql 23:51 mib_yjs7r i don't understand this part: "select * from message_queue where borrowernumber=the_number" 23:50 chris put a name in then, and you can leave the others blank 23:50 mib_yjs7r report name i guess i can name it whatever 23:50 mib_yjs7r yes i clicked on it and asks for above 23:50 chris is there a link create from sql? 23:49 mib_yjs7r or should i have clicked on "build new"? 23:49 mib_yjs7r asks for a report name, notes, type 23:46 chris that should be fine :) 23:46 mib_yjs7r break 23:46 mib_yjs7r never created or ran a sql report, hope i don't breake anything :-) 23:45 mib_yjs7r ok, i'll try that... thanks! 23:44 chris that sould hopefully tell you 23:44 chris save that, and then run that report 23:44 chris select * from message_queue where borrowernumber=the_number 23:44 LBA hi chris and all....just lurking 23:44 chris type into the sql box 23:43 chris choose create from sql 23:43 chris the go to reports 23:43 chris take a note of that 23:42 chris ok, in the url you see the borrower number? 23:42 mib_yjs7r Nope 23:41 chris is there a notices tab? 23:40 mib_yjs7r but it does nothing 23:40 mib_yjs7r in the borrower's account there is a "messaging" tab 23:39 chris yell out when you get there :) 23:39 chris and get to the details page 23:39 chris and do a search for the borrower 23:39 chris if you go to the staff interface 23:38 chris mib_yjs7r: its useful to be aware that liblime are actively hostile to the community, and while we do our best to help their users, sometimes due to the fact they do things different to everyone else we cant 23:38 mib_yjs7r I guess I don't 23:37 chris its in the database, do you get database access with liblime express? 23:36 mib_yjs7r which is where? 23:36 chris mib_yjs7r: if you had db access you could also look at the message_queue table 23:35 chris not sure how the liblime fork looks anymore 23:35 chris in the messaging or notices tab (on the left hand side) 23:35 chris in official koha yes, you can see that in the members screen 23:34 mib_yjs7r say a student has an overdue item, and I've set it up so that she receives an overdue notice -- is there a way to know if the notice has been sent? 23:34 chris but have a try, we might be able to 23:34 chris is that a liblime product? we probably cant help with that, they are running a really old version of koha 23:33 mib_yjs7r koha express 23:33 mib_yjs7r i need help with some basic stuff 23:33 mib_yjs7r Hello all 23:31 chris hi LBA 23:19 wasabi biab 23:16 jransom Chris: ta 23:16 chris public logging 23:16 jransom by golly :) 23:16 chris hey guys 23:16 jransom you havn't done it yet ... 23:15 jransom what! 23:14 jransom tell Paul I said hi 23:13 chris yup :) 23:13 jransom how exciting :) 23:13 jransom thats great news 23:13 chris yeah going well 23:13 wasabi ahh, hauraki - good stuff 23:12 chris im back up after to do circulation 23:12 chris well paul is doing the members, i just did opac 23:11 chris doing the staff traning now 23:11 chris hauraki go live in a few weeks 23:11 jransom although space is very limited ... lol 23:11 chris work 23:11 jransom we should all register 23:10 wasabi chris, werk or holiday in paeroa? 23:09 wasabi ah, thats old spam of mine.. 23:09 chris ok back into it 23:09 chris its tiny 23:08 richard getting a photo of the big l&p bottle? 23:08 wasabi 'Maria Thangaraj' ? 23:08 chris training, but at tea break 23:08 * chris is in paeroa 23:08 chris ill forward 23:08 chris had it forwarded to me 23:08 jransom deleted it unread 23:08 jransom actually i might have 23:08 jransom did you 23:08 jransom no 23:07 chris did you get it? 23:07 chris yeah 23:07 jransom spam .... 23:05 chris *sigh* 22:08 munin brendan: The current temperature in Northwest Goleta, Goleta, California is 20.5�C (3:04 PM PDT on September 07, 2010). Conditions: Overcast. Humidity: 70%. Dew Point: 15.0�C. Pressure: 29.86 in 1011.1 hPa (Falling). 22:08 brendan @wunder 93117 20:46 wizzyrea you bring up a good point though, that it could be clearer 20:45 richard didn't actually notice the link 20:45 richard ah 20:45 wizzyrea now, that may not be entirely clear. 20:45 wizzyrea :) 20:44 wizzyrea richard: http://screencast.com/t/MzRkNzkxMWI 20:44 Braedon fair thee well 20:43 jcamins Night, all. 20:43 jcamins Time to close up. 20:43 richard there's a link to the katipo website but not to http://lists.katipo.co.nz/mailman/listinfo/koha 20:42 jcamins I live in New York City. ;) 20:42 richard wizzyrea: just noticed there isn't a link to the main koha list on http://koha-community.org/support/koha-mailing-lists/ 20:42 Braedon :P 20:42 jcamins Speak for yourself. 20:41 Braedon and only ask of us our souls 20:41 jcamins :) 20:41 Braedon they provide us with the answers 20:41 Braedon thanks be to our overlords 20:41 wizzyrea :) 20:40 wizzyrea thank teh googlez 20:40 jcamins Ooh! It even works on the basic search screen! 20:40 wizzyrea ^.^ 20:40 jcamins wizzyrea++ 20:40 jcamins Woohoo! It works! 20:40 Braedon or rather, what did we do before stackoverflow 20:40 Braedon what would we do without stackoverflow? 20:39 jcamins Ah. Nifty. Thanks! 20:39 wizzyrea might help 20:39 wizzyrea http://stackoverflow.com/questions/317095/how-do-i-add-options-to-a-dropdownlist-using-jquery 20:38 wizzyrea (I think) 20:38 wizzyrea now... adding the option... 20:38 wizzyrea $("select[name='idx']") would get you the select dropdown 20:38 jcamins I think someone was talking about doing this back before I knew what jquery was. 20:38 Braedon fair enough 20:38 Braedon haha 20:37 wizzyrea ;) 20:37 wizzyrea so it's ez to test with 20:37 wizzyrea no, it's just a search that 1. always has items and 2. has lots of them and 3. has lots of holds 20:37 Braedon twilight? Don't tell me you are one of THOSE people wizzyrea :P 20:36 wizzyrea hm. lessee. 20:35 jcamins Right. 20:35 wizzyrea so your query would be like opac-search.pl?idx=kw&q=twilight&sort_by=pubdate_dsc&adate=<somedate> 20:35 jcamins Ideally, it should be an option in the dropdowns with "Keywords," etc. 20:35 jcamins adate: 20:35 jcamins On our catalog you can. 20:35 wizzyrea I mean, can you limit by that at all anyway? 20:34 jcamins Oh, let me try that question again with the key word included: 20:34 wizzyrea is that indexed? 20:34 jcamins Auction date, in this case. 20:34 wizzyrea what are you specifically trying to add? 20:34 wizzyrea owen's the real expert, but go ahead and ask 20:33 jcamins Is there some convenient jquery that can add a choice to the Advanced Search screen? 20:28 cait bye all 20:28 cait bed time 20:26 munin 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5203 minor, P5, ---, cnighswonger, NEW, Creating a label template causes fatal error if description field is empty 20:26 wizzyrea bug 5203 20:15 chris ok better go get ready, bbl 20:15 wizzyrea these videos are so sad. :( 20:13 wizzyrea :( indeed 20:13 cait :( 20:12 wizzyrea omgosh, that security video of the quake in a supermarket is wild 20:12 chris or there isnt going to be much christchurch left 20:12 chris usually there is one, that is 1 magnitude less, hopefully that was it 20:12 munin 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4473 enhancement, P5, ---, oleonard, NEW, Recent comments view for the OPAC 20:12 * owen is trying to fix Bug 4473, thus thinking about opac comments 20:12 chris yeah 20:11 Braedon chris: there was a geologist on the news last night saying the 5 aftershock the night before was definitely the biggest they would get. Thought it was a risky statement at the time. 20:11 wizzyrea chris: oh my@ 20:11 wizzyrea hardly at all 20:09 owen wizzyrea: You've got comments enabled, do your patrons use it? 20:09 chris http://geonet.org.nz/earthquake/drums/mqz-drum.html 20:08 cait owen: hm yes 20:08 chris http://www.stuff.co.nz/national/canterbury-earthquake/4105730/Quake-Major-aftershock-hits-Canterbury 20:08 owen Anyone else worry about the fact that the opac displays patron first and last name on comments? 20:08 wizzyrea ooh 20:08 cait cool :) 20:08 chris yeah, opac, members and circulation today 20:07 cait what do you train? koha? 20:07 cait :) 20:07 chris hiya cait 20:07 cait morning chris 19:58 chris and hammer it 19:58 chris using curl or the like, its easier to bring it up on a local interface, with insecure set 19:58 chris if you want to run 50000 issues through the system 19:58 jcamins Okay, that makes sense. 19:58 jcamins Ah. 19:58 chris jcamins: automated testing 19:55 jcamins There must be quite a story behind the insecure syspref. 19:49 * chris is catching up on emails before heading off to do some more training 19:49 chris morning 18:44 jcamins It would seem it is linked to the authorities. Never mind. 18:44 jcamins Hm. 18:43 jcamins If I wanted to link, say, 690 fields to authorities, could I do it? 18:38 jcamins Oh, well, you can pass my greetings on when you see them next. :) 18:38 nengard but thanks for saying hi anyway :) hehe 18:38 nengard jcamins - nope that's done :) 18:38 jcamins nengard: training? Hi librarians! 18:37 nengard k 18:37 nengard LOL 18:36 * owen does not love Perl's "something's wrong" warning 18:31 jcamins Has anyone used FastCGI with Koha, successfully? 18:26 cait thx :) 18:26 cait ah 18:25 wizzyrea ;) 18:25 wizzyrea as in, you give it bad data, who knows what you'll get out 18:25 jcamins I was just worrying that I had done something bad to my formerly-at-HEAD installation. 18:25 wizzyrea garbage in, garbage out 18:25 cait GIGO? 18:25 wizzyrea now that I'm looking at it 18:25 jcamins Good. 18:25 jcamins Oh. 18:25 jcamins Okay, that's what I have too. 18:25 cait yeah, I meant 61 :( 18:25 wizzyrea well I'm actually wondering if it's a case of GIGO 18:24 cait wizzyrea: have you checked the coded fields of those records? 18:24 owen 3.01.00.145 is what I'm seeing 18:24 jcamins What version is HEAD at? 18:24 wizzyrea http://screencast.com/t/MDFiZmFlMTU 18:23 cait search is one of the coded fields, 007 008 one of those 18:23 jcamins Something that makes me weep every time I remember. 18:23 cait no 18:23 cait ah, sort 18:23 cait yep 18:22 owen Anyone remember what Koha is looking at for the pubdate sort? 18:22 cait looks ok to me in 3.1.161 18:22 wizzyrea though 18:22 jcamins pubdate search works on my demo catalog. 18:22 wizzyrea if there are any 18:22 wizzyrea hmm. my 3.2 seems to allow that but I dont have the newest patches 18:21 owen wizzyrea: Specifically, I can't *re-sort* from the results screen. I can specify a sort from the advanced search form and get sorted results 18:21 jcamins I meant sorting, not searching, sorry. 18:21 cait let me check 18:21 cait we have pretty good data for pub date 18:20 wizzyrea sorting and searching 18:20 cait pub date sorting or searching? 18:20 jcamins (for testing pubdate searching) 18:20 jcamins We don't have any acquisition dates, and our database is too full of garbage to be of use. 18:20 wizzyrea EW 18:20 owen I don't even get results, I get sent back to the advanced search screen 18:20 wizzyrea (i recognize it's hard to tell with pubdate) 18:19 wizzyrea I was wondering if the sort actually, you know, sorted. 18:19 wizzyrea well, lol, no 18:19 owen Ah, do you mean "working" as in, "doesn't just redirect you to the advanced search page?" 18:17 wizzyrea < same 18:17 owen Unfortunately for our garbage-filled catalog 18:17 wizzyrea but since acqdate is system generated it works better 18:17 owen Right 18:17 wizzyrea the pubdate sort is as good as the data you give it > gigo 18:17 owen I've never trusted Koha's publication date sort, but have usually found the acquisition sort to work well 18:17 wizzyrea yep 18:16 owen publication and acquisition sorts are very different 18:16 wizzyrea pretty please 18:16 wizzyrea int he opac 18:16 wizzyrea can someone verify that publication/acquisition date sorting is working in 3.2? 17:27 jcamins Is there any way to merge authorities in the Staff client? 17:27 munin 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5201 major, P5, ---, kyle.m.hall, NEW, Patron last name dropped when record edited 17:27 rhcl bug 5201 17:26 owen rhcl: Yes, I'd say that's a pretty bug clue right there :) 17:25 rhcl I guess I should file a bug report. 17:24 rhcl yes, if you turn on that syspref, the problem appears, turn it off and it disappears 17:22 owen-away rhcl: Turning on uppercasesurnames is what leads to the problem? 17:19 munin 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5148 normal, P5, ---, gmcharlt, NEW, Definition with surname won't work 17:19 rhcl hey munin, fetch me bug 5148 17:14 rhcl turning off uppercasesurnames system preference fixes the problem 17:09 cait we dont use the uppercasename pref and never had problems so far 17:09 jcamins Never encountered it, sorry. 17:08 jcamins Wow, that's really weird. 17:07 rhcl http://www.screencast.com/t/ZTJmZWIz 17:06 rhcl Anybody else have problems with disappearing names? sekjal thinks possibly related to uppercasesurnames system preference. 16:07 cait link? ;) 16:07 chris_n hehe 16:07 * owen fears his exclusive fishing blog has been discovered 16:07 owen Sorry, tell 'em to get their butts back in the library! 16:06 chris_n owen++ # for helping me teach my librarian's to fish 16:03 aarkerio ok, I will print the PDF, thanks all for your patience!! 16:02 cait if you want to generate barcodes try to turn on the syspref 16:01 cait the ... indicate there is one linked to the field 16:01 cait so not really external 16:01 cait perl files, but they come with koha 16:01 cait you can link so called plugins to fields in cataloging 16:00 aarkerio hi cait, is barcode an external plugin? 15:59 cait it means a plugin can be linked to this field - there is a sys pref for barcode generation, I think it does not work until you turn it on 15:58 aarkerio in "p - Barcode" y see tree dots "..." 15:58 cait hi #koha 15:58 aarkerio thanks! 15:52 owen Cataloging -> Search for your book -> Add/Edit items/holdings 15:51 owen http://koha-community.org/documentation/ 15:51 owen Yes 15:50 aarkerio this is too old: http://www.kohadocs.org/usersguide/ch01s04.html right? 15:46 aarkerio mm, how can I create the barcodes for books? "Cataloging" 15:44 aarkerio mmm, or number item? 15:43 wizzyrea o, that's rough. 15:43 aarkerio I see "Enter item barcode" but I don't have any, can I type ISBN manually? 15:42 aarkerio mm, cool! 15:41 owen Staff go to "Circulation," find the user (or scan their library card) and make the checkout 15:40 aarkerio so, staff go to "Patrons", found the user and made the checkout? 15:39 wizzyrea yes 15:39 aarkerio or if I as student found a book, what is the next step? go to desk and show my library card to staff? 15:39 wizzyrea (charged) 15:39 wizzyrea that is a list of items that library staff has checked out for you (issued) 15:38 aarkerio and "Checked Out" text, what I am checking out? 15:38 aarkerio ok, in OPAC I can see "my summary" tab 15:37 wizzyrea adn you can place holds on the books in your cart so the library staff can pull them and have them ready for you 15:37 wizzyrea right. It's mostly for your reference, so you can keep track of books you might want to check out 15:37 aarkerio I can add the book to my cart 15:37 wizzyrea put holds on them 15:36 aarkerio then what I do with items in my cart? 15:36 jcamins No, Koha is a library system, not an ecommerce system. 15:35 aarkerio mmmm, so if I add a book to my cart is for buy it? 15:34 jcamins aarkerio: You can only check out books from the staff interface. 15:34 aarkerio I mean in OPAC interface 15:33 aarkerio how can I ask for borrow it? 15:32 aarkerio Hi! I am newbie in Koha. I importes a MARC and the create an Item. In OPAC I can found the book but 15:04 jcamins Woohoo! LLC name has seemingly been fixed! 15:04 kf bye all 14:37 wizzyrea it's a pita 14:37 wizzyrea I don't recommend prism 14:37 jcamins Yeah, I've been thinking that might be a good idea. 14:36 jcamins wizzyrea: We do that too. But it looks kind of like this <p>First paragraph</p><br/><br/><br/></br><p>Second paragraph</p><br/><br/><br/><hr/><br/><p>Third paragraph</p> 14:36 wizzyrea so that we can tie it to the receipt printer and still let "big" firefox use whatever printer it likes 14:36 wizzyrea we made an install of portable firefox for use with the NEKLS koha install 14:36 wizzyrea we did something kind of clever 14:33 wizzyrea jcamins: you could just wrap your blocks in <p> 14:32 kf :) 14:32 kf the web standard police? 14:29 jcamins Are the web standard police going to come and arrest me for ignoring the fact that we use <br/>s (a lot of them) in OpacMainUserBlock? 14:27 kf that would be great, thank you 14:26 chris_n kf: I'll try to take a look later today or tomorrow for you 14:26 wizzyrea they were excessively challenging 14:26 wizzyrea then I did it successfully on ubuntu :P 14:25 jcamins wizzyrea: Both of those sound excessively challenging. 14:25 kf chris_n: perhaps you can confirm that my patch will not break something 14:25 wizzyrea then again on OSX 14:25 kf but nobody else has my problem :( 14:25 wizzyrea I tried to install it once on OpenBSD 14:25 munin 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4904 major, PATCH-Sent, ---, katrin.fischer, ASSIGNED, Problem with printing fines in overdue notices 14:25 kf chris_n: can you perhaps take a look at bug 4904? I think it's a double encoding problem and send a patch for it... 14:24 jcamins Heck, I have enough trouble with Koha under Debian! 14:24 kf I can understand that 14:24 kf :) 14:24 jcamins I want nothing to do with Win32. 14:24 jcamins Not me. I had enough trouble getting Koha to run under FreeBSD. 14:23 kf is someone subscribed tot he win-32 list? 14:23 chris_n just impractical 14:23 chris_n as I say, it's not impossible 14:23 kf jcamins: I think he was asking where to put a tutorial for installing under windoes 14:23 chris_n on second read, it seems you're right 14:22 jcamins Of course, I may have been mistaken. 14:22 jcamins I don't think so. I understood him to be reporting that he had gotten it working, and was wondering why there didn't seem to be much about successfully running Koha on Windows. 14:22 chris_n 3.1.x that is 14:21 chris_n and lots of gray hair to show for it :-) 14:21 * chris_n has a perfectly fine working install of 3.whatever on XP at home 14:21 chris_n jcamins: I saw that, but wasn't he asking "how to" rather? 14:20 wizzyrea that is a special sort of insanity 14:20 jcamins chris_n: yesterday someone reported getting Koha 3.something to run under Windows. 14:20 munin moodaepo: The current temperature in MSU Physics Dept, Mankato, Minnesota is 12.5�C (9:21 AM CDT on September 07, 2010). Conditions: Overcast. Humidity: 87%. Dew Point: 10.0�C. Pressure: 28.81 in 975.5 hPa (Rising). Wind Advisory in effect until 3 PM CDT this afternoon... 14:20 moodaepo @wunder 56001 14:15 chris_n interesting, but no 14:14 wizzyrea and good morning everybody 14:14 wizzyrea http://screencast.com/t/OTM4Y2NkN 14:14 wizzyrea have you ever seen a message like this re: the label maker? 14:13 wizzyrea :) 14:13 wizzyrea double list consultation fail. 14:13 wizzyrea ... 14:13 * chris_n greets wizzyrea 14:13 kf hi wizzyrea 14:13 wizzyrea lol, nm, list consultation fail. 14:13 wizzyrea chris_n: about? 14:06 kf thx magnus :) 13:59 magnus kf++ # for signing off on a patch ;-) 13:26 nengard be back later 13:26 nengard time to go teach koha 13:24 nengard was testing something ... oh well 13:23 magnus oops? 13:23 nengard hmmm 13:23 nengard login nengard indigo 13:21 nengard thanks schuster! 13:19 schuster nengard - I just sent you an email about quick spine label setup - use it or not... 13:07 kf hi jcamins 13:05 jcamins Good morning, #koha 13:02 nengard reminder: send me koha newsletter articles/tips/tricket/news/ etc ASAP! 12:49 kf at least you can say neflin 12:49 owen Librarians love their acronyms 12:48 * kf googles now too to find out if she said something really stupid 12:47 kf NEFLIN reminds me of GREMLINs 12:44 kf hi owen and schuster 12:41 owen Thanks schuster 12:41 schuster WELCOME BACK owen! 12:41 * owen googles NEFLIN 12:34 nengard hi all 12:29 * owen wonders if slef got any response to his NISO CORE proporsal 12:25 magnus hi owen 12:24 owen Hi #koha 11:59 magnus yup 11:58 kf semantic web sparql? 11:56 * magnus is trying to wrap his head around sparql 11:55 magnus hiya kf - i was trapped then ;-) 11:55 kf it was a trap... was feeling lonely ;) 11:55 kf hi magnus :) 11:43 magnus thanks! 11:02 * kf shares some chocolate cookies 07:05 kf good morning #koha 06:56 magnus Morning ;-) 06:45 chris Evening 05:20 munin cait: The current temperature in Konstanz, Germany is 12.0�C (7:00 AM CEST on September 07, 2010). Conditions: Light Rain. Humidity: 93%. Dew Point: 11.0�C. Pressure: 29.77 in 1008 hPa (Falling). 05:20 cait @wunder Konstanz 05:04 cait hi #koha 03:05 Amit heya chris 02:06 munin brendan: The current temperature in Northwest Goleta, Goleta, California is 17.1�C (7:04 PM PDT on September 06, 2010). Conditions: Haze. Humidity: 75%. Dew Point: 13.0�C. Pressure: 29.75 in 1007.3 hPa (Steady). 02:06 brendan @wunder 93117 00:59 brendan hello all :) 00:53 irma heya wassabi :) 00:50 wasabi heya irma 00:47 irma hi all 00:10 aarkerio I added the book to my Cart 00:06 aarkerio need I change some permission to teacher rol ? 00:06 aarkerio HI! I can add a book to my cart but I don't see the "Check out" option