IRC log for #koha, 2009-01-10

← Previous day | Today | Search | Index

All times shown according to UTC.

Time Nick Message
11:22 soul9 hi
12:56 hdl_laptop hi
13:32 kf hi hdl
13:38 danny good morning #koha
13:53 paul_p 'morning danny
13:54 (not really the morning here although ;-) )
14:08 hdl_laptop hi
14:08 hi kf.
14:34 soul9 lg
15:25 feh
15:51 :-D :-D
15:51 i'm sorry, my irc client has a very weird focus behaviour
16:04 nahuel gmcharlt, can you way me why mail::sendmail was choosen ?
16:05 paul_p nahuel: not sure he can, as it's a old decision.
16:05 and I don't think there was a true reason
16:06 nahuel I think it's really bad, because koha should generate himself the mail... and for the moment, the sendbacket does not work with too large baskets
16:09 danny hmm no owen today?
16:30 atz nahuel: you need some module to find the local mailer for you
16:30 koha cannot count on having sendmail installed in the same place on every system
16:31 nahuel atz, ?
16:31 the error do not depend of the mailer
16:32 well I have to go, see you monday :)
16:32 I think I find the solution
16:32 gmcharlt nahuel: MIME::Lite may be a better alternative
16:33 although I wonder how many users can actually make anything of an attached MARC record in the first place
16:33 also, see http://git.koha.org/cgi-bin/gi[…]8adab85b680b3c191
16:34 there used to be a function in C4::Koha that handled exactly the sort of encoding that Joe discussed
16:34 was removed because disused
16:34 but could be put in again
18:47 rhcl woo hoo! My lime green Koha t-shirt just arrived in the mail.
19:44 liz hehehehe
19:45 oh sorry. autoBarcode... is it supposed to increment when adding items? I assumed this was how it worked but ours doesn't seem to work that way
19:45 atz liz: if it is set to "incremental", yes
19:46 but it breaks easily when people add "freestyle" barcodes
19:46 liz atz: can you define
19:46 freestyle barcodes?
19:46 atz all it does is take the MAX barcode and try to add 1 to it
19:46 liz i see, so if you normally just scan the barcode in
19:46 atz if somebody adds a barcode like LOST_BOOK_05
19:46 liz ic
19:46 atz then it fails b/c it can't add 1 to a string
19:47 unfortunately, this is all too common
19:47 liz makes sense... there is also the setting hbyymmincr, which presumably has the same issue?
19:47 atz yeah, what happens is ppl set to hbyymmincr and then try to set back to incremental
19:48 but they now have strings in their barcodes and effectively have broken incremental
19:48 liz oh neat
19:48 is there a way to "reset" it?
19:48 atz i wish hbyymmincr would go away and die.
19:48 liz lol tell us how you really feel
19:49 atz or at least carry a big warning like "thou shalt never return from the land of hbyymincr"
19:50 so the fix in any case is to figure out make sure the max barcode is a valid number
19:50 select barcode from items order by barcode desc LIMIT 20;
19:50 see what junk in the top 20 barcodes, for example
19:51 also sometimes ppl make all-whitespace barcodes which is even trickier
19:51 b/c they don't see anything wrong
19:51 liz >.< fail
19:52 so, if you WANT hbmmyyincr
19:52 atz then you are wrong.  
19:52 j/k
19:52 liz ah, at least you're honest
19:52 see, I don't think it would work in our system anyway
19:52 atz the main thing is that you can print arbitrary stuff on barcode *labels* including branch and date_added
19:53 they don't have to be *in* the barcode
19:53 liz because 99.999999 percent of the time they are scanning in the barcodes they are attaching to the items
19:53 not using koha to generate the barcodes
19:53 atz ah, that's good
19:53 you shouldn't have any trouble then
19:53 liz the only time this becomes an issue is when say, monthly they are adding magazines
19:54 and they don't want to "waste" a pennies cost barcode on the item
19:54 kados for those of you with too much spare time on your hands, the beta test period for ‡biblios has been extended until next Friday, and the Winter 09 Update has just been pushed out ... head over to https://beta.biblios.net to check it out
19:54 Winter 09 Release Notes: https://sites.google.com/a/lib[…]ws/winter09update
19:54 liz and then they want it to increment hbmmyyincr
19:54 >.<
19:55 tyvm for the info atz
19:55 atz the way I think about it, the barcode is the one machine identifier on the item.  you should let the machine have it's one little identifier in perfect sacrosanct machine-speak.
19:56 np liz
20:29 liz ug, what's the syntax for finding all items with an empty itype?
20:30 er, mysql syntax >.<
20:31 brb colloquy update
20:32 back
20:34 mason heh, me updates from colloqy too ;)
20:34 select * from items where itype = '';
20:36 danny or where itype IS NULL
20:37 liz I did this in the reports module: SELECT items.homebranch,items.barco​de,items.itype,biblio.title FROM items WHERE items.itype IS NULL
20:37 and that gave an error
20:37 I don't have access to the mysql client :/
20:37 (hosted)
20:38 mason biblio.title is yr error
20:38 liz ah ty, I shall remove it
20:39 The following fatal error has occurred:
20:39 Can't use an undefined value as an ARRAY reference at /home/neklstest/kohaclone/C4/Reports/Guided.pm line 412.
20:39 urgle burgle
20:40 i removed all of the fluffy and just did *
20:40 and that gave me some results
20:40 ty
20:41 mason SELECT items.homebranch,items.barco​de,items.itype,biblio.title FROM items join biblio on (biblio.biblionumber = items.biblionumber )  WHERE items.itype IS ''
20:41 to get the title too..
20:49 liz man, ok, BMW for a moment... why can't I just put valid sql into the guided reports and have it work >.<
20:50 mason: that gives the same undefined value as array error
20:51 ryan liz: there are a couple patches that may not be applied for you that resolve some problems with export.
20:51 liz:  don't put a semicolon in there.
20:51 mason heya ryan
20:51 yep
20:51 ryan hi mason
20:51 mason the sql itself is correct
20:52 liz sorry chums, i don't see any semicolons :/
20:53 mason cool, its not that then...
20:54 liz this works... I want to limit it by homebranch, or order it by homebranch
20:54 SELECT * FROM items WHERE items.itype IS NULL
20:54 ryan liz: double quotes are also bad
20:54 but single quotes should work.
20:54 liz k, no double quotes either :/
20:56 ryan your exact query ?   select count(*) from items where itype=''  ?
20:57 liz: oh, i see backreading now.
20:57 you need a join on that query.
20:57 liz ahh
20:58 ryan FROM items JOIN biblio ON items.biblionumber=biblio.biblionumber WHERE ...
21:22 liz man, i'm trying to learn to fish here, I really am... the guided reports create from sql doesn't like that either
21:22 i've tried it 20 ways from sunday
21:23 the only thing I can get to work is SELECT * FROM items WHERE items.itype IS NULL
21:23 if I add anything to it it dies
21:23 er, adding anything to it makes it die
21:29 kados liz: SELECT * from items WHERE items.itype IS NULL AND items.homebranch='NEKLS' AND items.homebranch='NEKLS2';
21:29 liz: you can also nest with ( ) if you need to
21:30 SELECT * from items WHERE items.itype IS NULL AND ( items.homebranch='NEKLS' OR items.homebranch='NEKLS2' );
21:30 (which is correct because the first query does an AND on something that only has one value, so it will result in no results
21:31 just showing it for syntax purposes
21:33 liz: btw: have you checked out ‡biblios yet?
21:34 liz kados: I will try that, thanks. I haven't had a chance to look at it and I know I really need to.
21:35 ryan liz: are you getting an error or are you just not getting results ?
21:36 you should not get results on itype = '' .
21:38 liz i'm getting errors
21:38 I get the right kind of results with SELECT * FROM items WHERE items.itype IS NULL  
21:38 I just want to limit by holdingbranch
21:39 ryan liz: actually, expanding my window a bit and reading further back, it looks like mason and i both had errors in our syntaxes.
21:39 liz Actually it looks like kados got it
21:39 SELECT * from items WHERE items.itype IS NULL AND items.homebranch='NEKLS'
21:40 ryan for the title, add FROM items join biblio on (biblio.biblionumber = items.biblionumber )  WHERE items.itype IS NULL
21:44 liz SELECT FROM items join biblio on (biblio.biblionumber = items.biblionumber ) WHERE items.itype IS NULL AND items.homebranch='ATCHISON'
21:44 this fails with error
21:45 mason you need a mysql prompt liz
21:45 liz iknorite
21:45 :)
21:46 we're hosted though... just trying to save our support staff some overhead
21:46 mason ahh
21:47 well, even a local koha3 for playing on would help here..
21:48 liz truth, and easy enough to do really if I could get a copy of our data... may have to look into that
21:48 some other issues that might necessitate such a testing environment as well
21:49 er, wow, friday afternoon english suck there sorry... "there are some other issues that might necessitate such a testing environment as well"
21:50 mason girl this is IRC, we all type like monkeys on here ;)
21:50 liz lol wtfpwnt
21:50 SelfishMan heh...monkeys
21:50 mason or me do at least
21:51 liz hee me too
21:51 SelfishMan Wait, go back
21:51 It's Friday afternoon?
21:51 liz or saturday morning, depending
21:51 ^.^
21:52 ORLY
21:52 SelfishMan I thought today was Thursday
21:52 danny liz, do you have ftp access to the box?
21:52 your hosted box that is
21:52 liz only to the template
21:52 templates*
21:53 danny ah ok
21:57 i was gonna suggest you can use something like phpmyadmin (web based mysql client) but you'd need the server to have php installed
21:59 liz yea, even that would be a bonus
21:59 is a very good idea
22:04 SelfishMan: bad or good that you're a day behind?
22:05 SelfishMan Both and neither.  I'm early on one project and late for another
22:12 liz for those of you following the saga, this worked (finally):
22:12 SELECT * FROM items join biblio on (biblio.biblionumber = items.biblionumber ) WHERE items.itype IS NULL AND items.homebranch='WIlLIAMSBG'
22:12 and thank you all very much for your patience and assistance
22:13 i'll learn to fish yet
22:35 question: I'm looking at the pay fines interface, what is the Account Type there
22:35 ?
22:35 I see Account Type F, and account type FU, but we're not sure what that means exactly
22:35 (lol, FU)
22:38 mason FU = fines unpaid, i think..
22:39 liz well... all of the items have fines unpaid
22:39 maybe fines unreturned?
22:39 mason ah, much better
22:39 liz as in he still has the book?
22:39 if we figure it out I'll report back
22:44 We believe it's Fines unreturned
22:44 funny abbreviation though :)
22:45 atz liz: fines is ugly on the inside
22:46 wait a month or two for allens patch bomb to make it better
22:46 liz oh, so it stands for FINES UGLY
22:46 I truly value your unrelenting honesty, atz
22:47 atz it's funny your topics are all my pet kvetching issues
22:47 liz ^.^
22:48 ryan liz: btw, iirc from code comments, it's 'Fine Updating'.
22:48 mason ive a css Q for all..
22:48 ryan but, yes, it means it's still accruing charges.
22:48 mason <div> moo moo </div>
22:49 how to make text in an element not display?
22:49 ryan $().remove() ?
22:49 liz AH! ryan++
22:49 ryan jquery++
22:49 mason <div style="display:none;" > moo moo </div> ?
22:50 atz mason: right
22:50 or style="visibility:hidden;"
22:50 display none is the more common
22:51 mason ta, i had a typo..
22:51 thanks guys
22:57 liz everybody, thanks again for the help, have a good weekend
22:57 atz mason: for jquery, see also the $().hide, $().show and (most useful) $().toggle
22:57 ttyl, liz
09:24 chris hi cait
09:25 cait hi chris :)
09:27 chris ready for the weekend?
09:30 cait saturday morning here - definitely yes

← Previous day | Today | Search | Index

koha1