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