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