← 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.barcode,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.barcode,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