Time Nick Message 00:01 * jcamins_away peeks in to #koha 00:05 pianohacker hola, jcamins 00:05 * jcamins_away waves feebly 00:06 rangi heya jwagner_away 00:07 rangi gah 00:07 rangi heya jcamins_away 00:07 jcamins_away Heh. I guess there are too many j{something}_away's, huh? ;) 00:07 rangi yep 00:07 rangi tab completion fail 00:08 pianohacker jcamins_away_actuallyhere_butnotreallywentoutfordinner_thenloggedinwithmyphonesobackagain 00:08 jcamins_away Basicallyl. 00:09 jcamins_away Except for dinner. 00:11 pianohacker dinner sounds really good 00:11 pianohacker why are you waving feebly, btw? sick? 00:12 jcamins_away Training this week. 00:12 jcamins_away Again. 00:13 pianohacker ouch. teaching is work 00:13 pianohacker who are you training? 00:13 jcamins_away New Koha library. 00:13 jcamins_away Thankfully here in the city. 00:15 pianohacker so convenient at least 00:16 jcamins_away Yes. 00:16 jcamins_away But tiring. 00:16 jcamins_away I just have to write a few reports tonight. 00:16 jcamins_away If I can think coherently. 00:17 pianohacker reports-- 00:20 jcamins_away Meh. Generally they're fine. 00:25 pianohacker bye, all 00:26 oleonard rangi: I'm just catching up on the git-bz lesson 00:26 rangi sweet 00:26 rangi hopefully the log makes sense? 00:26 oleonard I'm getting "git: 'bz' is not a git-command. 00:27 oleonard Did the Python version turn out to be a red herring or do I need to be higher than 2.5.2? 00:27 rangi i think a red herring 00:28 rangi how about git-bz ? 00:29 oleonard git-bz: command not found 00:30 rangi you did the symlink bit? 00:30 oleonard Yes 00:30 rangi what does 00:30 wahanui rumour has it does is calculate the discount on this price or the tax is removed before to calculte the discount on the price before taxes 00:30 rangi ls -l /usr/sbin/git-bz 00:30 rangi look like? 00:31 oleonard lrwxrwxrwx 1 root root 28 2011-05-24 20:17 /usr/sbin/git-bz -> /home/oleonard/git-bz/git-bz 00:31 rangi i wonder if that isnt in your path 00:31 rangi echo $PATH 00:32 oleonard Ah: usr/sbin is not listed 00:32 rangi if you run 00:32 rangi is /usr/local/sbin ? 00:32 eythian sbin is not usually in your path 00:32 eythian put in in /usr/(local/)bin 00:33 oleonard Thanks guys, that got it working 00:34 oleonard Does it work with chrome? Seems to be offering it as an option 00:34 oleonard So it does 00:34 oleonard Awesome 00:34 rangi sweet 00:35 oleonard rangi++ 00:35 jcamins_away logs? 00:35 wahanui logs are at http://stats.workbuffer.org/irclog/koha/ 00:35 jcamins_away Thanks, wahanui. 00:35 wahanui jcamins_away: de nada 00:35 oleonard eythian++ 00:35 * oleonard has to go read books to some bedtime kids now 00:49 jcamins_away Does anyone have time for some quick report help? 00:58 jcamins_away Never mind. I just discovered biblio.datecreated. 01:43 eythian http://aggiesprite.files.wordpress.com/2011/05/rednekwine.jpg <-- mtj 02:20 glernil hello #koha 02:30 rangi hey glernil 02:30 rangi did you ever get your cronjob running? 02:39 glernil nope not yet 02:39 rangi take a look in misc/cronjobs 02:39 rangi there is a crontab.example file 02:40 glernil got to look on that.. but what i did was to reinstall the system and start all over again since it is easy to do cause i'm using virtualbox... 02:41 rangi cool 02:41 rangi i use the koha-common debian package, cos it does the cron stuff for me 02:42 glernil there's another issue in my installation i want to clarify... when i rebuilt the index the following errors occurred>>> 02:42 glernil Unknown register type: 0 02:42 glernil Unknown register type: n 02:42 glernil Unknown register type: y 02:42 glernil Unknown register type: d 02:42 rangi never seen those before 02:42 glernil any idea? 02:42 rangi none at all 02:43 glernil by the way.. i'm using ubuntu as my OS 02:59 glernil is it possible to use the common debian package in Ubuntu? 02:59 rangi yes 02:59 rangi but it does take a bit of knowing what you are doing 03:00 rangi you have to combine this 03:00 rangi http://wiki.koha-community.org/wiki/Koha_3.2_on_Debian_Squeeze 03:00 rangi with 03:00 rangi http://wiki.koha-community.org/wiki/Koha_on_Lucid_using_Koha_packages 03:01 rangi http://wiki.koha-community.org/wiki/Koha_3.2_on_Debian_Squeeze#Quick_Start 03:01 rangi making sure you install koha-common not just koha 03:03 glernil ok.. i think i have to try that.. 03:13 Brooke kia ora! 03:13 Space_Librarian tena koe! :D 03:14 rangi hi Brooke 03:15 * Brooke salutes rangi. 03:33 Brooke joy on earlier? she asked, hopefullly. 04:11 rangi not that i saw 04:11 * Brooke crosses her fingers. 04:11 Brooke DFW got hammered. 04:12 rangi schuster is down there too 04:12 Brooke a yep 04:55 Brooke 0/ 04:56 Oak \o/ Brooke !!! 04:56 Oak how are you today? 04:56 Brooke good enough for gummint woik 04:56 Brooke you? 04:56 Oak good 04:57 * Oak googles 'gummint woik' 04:57 Brooke won't find it 04:57 Brooke it's a localised expression that's been mangled for spelling 04:58 Brooke good enough for government work is like passable. 04:59 Oak ah 04:59 * Oak is enlightened 05:00 Brooke would that that were enough for nibbana 05:00 * Oak googles 'nibbana' 05:01 Oak hmm 05:02 Space_Librarian catch'ya'll later! 05:03 Oak catch'ya'll later! and poof! sure was a space librarian... 05:15 Brooke 0/ 05:15 cait hi Brooke 05:15 cait morning #koha 05:16 Brooke guten tag 05:19 Oak ich liebe dich cait for being here on time. good. 05:20 cait on time? 05:20 cait and hi Oak ) 05:20 Oak :) hi 05:21 eythian hiya 05:22 cait hi eythian :) 05:40 Brooke 0/ 05:48 Brooke tossing and turning time! 06:04 glernil hello 06:14 glernil anyone here familiar in the installation procedure for debian squeeze? 06:14 cait hi glernil 06:15 glernil i downloaded and installed the package koha-common everything went fine 06:15 glernil yet i'm stucked in the koha-sites.conf 06:16 glernil do i have to create that file? even if the installation won't be live online? 06:16 cait I am sorry, I have no experience with the packages 06:16 glernil oops.. ok 06:16 cait eythian? 06:16 wahanui i think eythian is in NZ. ;) or a good influence 06:17 eythian cait: yes? 06:18 alex_a good morning ! 06:18 glernil i tried to skip that part and go directly in issuing the command koha-create.. but with no luck... 06:19 eythian oh 06:19 eythian glernil: yes, you do need to create it 06:19 cait I summoned you 06:19 cait hi alex_a 06:20 eythian glernil: you don't have to put a whole lot in there really, but I think it complains if it's not there. 06:20 glernil i got an error "awk: cannot open /etc/mysql/koha-common.cnf" 06:20 eythian you probably need to install mysql-server then 06:20 glernil i skipped that part since i can't understand what should be included there 06:20 glernil oops.. i'll check my mysql first 06:21 eythian you can't skip having a database I'm afraid :) 06:21 eythian oh, or a sites configuration 06:21 glernil wat i mean the .conf part 06:21 glernil aw... ok.. ;) 06:21 eythian I think you can leave the bulk of the fields blank. 06:21 glernil got to try that... 06:22 eythian you'll want to have an intrasuffix though, so when you set up DNS on your network the server knows what you're asking for. 06:24 glernil sorry.. i'm a noob.. so what should i put there? 06:25 eythian http://wiki.koha-community.org/wiki/Koha_3.2_on_Debian_Squeeze#Quick_Start <-- it gives you an example here. 06:25 eythian I'd leave the DOMAIN blank if it's not going on the internet 06:30 francharb hello all 06:31 rangi hi francharb 06:33 clrh hi 06:33 wahanui hi, clrh 06:33 rangi hi clrh 06:35 cait hi francharb and clrh 07:03 rangi hi julian and hdl and matts 07:03 julian hello rangi 07:04 matts hello #koha ! 07:06 hdl hi rangi 07:20 kf hi #koha 07:21 rangi wb kf 07:22 kf thx rangi :) 07:24 rangi hi Guillaume, sophie_m and paul_p 07:25 rangi paul_p: not in the office today? 07:25 sophie_m hi rangi, hi #koha 07:25 paul_p hi everybody. 07:25 paul_p rangi, nope, working from home 07:25 Guillaume Hi Rangi and everybody 07:26 rangi ahh 07:31 glernil eythian: i created the .conf file and inserted basic site conf in ref. to the link you gave. But when i created a koha instance there is a syntax error 07:32 glernil syntax error line 69 of /etc/koha/apache-shared.conf 07:32 eythian is there more to it than that? 07:33 glernil invalid command 'RewriteEngine', perhaps misspelled or defined by a module not included in the server configuration 07:33 rangi its probably you havent done a2enmod rewrite 07:33 rangi (or whatever the right command is) 07:33 eythian you didn't do 'sudo a2enmod rewrite' 07:33 eythian yeah, that 07:33 wahanui yeah, that is probably cool - a way to enhance the OPAC without bloating Koha... 07:34 glernil that's not on the list in the wiki.. i'll try 07:35 magnuse kia ora, #koha 07:36 rangi heya magnuse 07:36 wahanui well, magnuse is afraid that we added another 10000 bugs while he was eating pizza. 07:36 glernil got it! 07:36 magnuse i built my first .deb with build-git-snapshot, what's the best way to install it? apt-get? dpkg? others? 07:37 rangi dpkg -i 07:37 rangi easiest way 07:37 eythian glernil: sweet 07:37 rangi and then apt-get -f install if you need to pull in dependencies 07:37 magnuse rangi: thanks! and that will install all the dependencies too? 07:37 kf hi magnuse :) 07:37 kf magnuse++ 07:37 magnuse ah ha 07:37 kf how is alta? 07:37 magnuse hi kf 07:38 glernil yet there's no koha interface when i check it in the browser 07:38 magnuse alta is good - getting to talk to new people about koha 07:38 glernil eythian: but there's no koha interface when i check it in the browser.. maybe its in the apache config 07:39 eythian glernil: what is there when you check it in the browser? 07:39 eythian and do you have your DNS set up properly? 07:39 glernil eythian: the default page.. It works! 07:39 eythian oh 07:39 eythian sudo a2dissite default 07:40 glernil is it secure to do it that way? 07:40 eythian (or maybe 000-default) 07:40 eythian what do you mean? 07:40 glernil a read something about that in the apache docu... but i'll try to do it first 07:43 glernil eythian: it worked. in the localhost:80 perhaps.. but when i check localhost:8080 is says "unable to load page" 07:47 eythian it doesn't put it on 8080, it puts them both on :80, but with different server names, so you need your DNS or hosts set up so you can access it using the correct names. 07:48 glernil what if i will not be deploying it in production yet? can i set it to 8080? 07:50 eythian you can, you'll need to add Listen 8080 to your ports.conf (I think it is in apache) and change the config in the intranet section of the site to be :8080 08:00 magnuse @wunder alf 08:00 huginn` magnuse: The current temperature in Alta Lufthavn, Norway is 10.0�C (9:50 AM CEST on May 25, 2011). Conditions: Mostly Cloudy. Humidity: 71%. Dew Point: 5.0�C. Pressure: 29.24 in 990 hPa (Steady). 08:01 kf @wunder Konstanz 08:01 huginn` kf: The current temperature in Konstanz, Germany is 18.0�C (10:00 AM CEST on May 25, 2011). Conditions: Clear. Humidity: 29%. Dew Point: 4.0�C. Pressure: 30.31 in 1026 hPa (Falling). 08:07 rangi @wunder wellington nz 08:07 huginn` rangi: The current temperature in Wellington, New Zealand is 16.0�C (8:00 PM NZST on May 25, 2011). Conditions: Light Rain Showers. Humidity: 82%. Dew Point: 13.0�C. Pressure: 29.74 in 1007 hPa (Falling). 08:09 magnuse i loose... 08:10 rangi oh newsletter is out 08:10 glernil eythian: it worked! finally using 8080 as the intranet port 08:11 glernil eythian++ 08:11 eythian glernil: awesome :) 08:11 magnuse http://www.flickr.com/photos/enger/5757338711/in/photostream ;-) 08:15 glernil eythian: got to test this tomorrow. you're such a great help specially in situation (here in the Philippines) where help is nowhere but in this channel. ;) 08:16 eythian glernil: cool :) glad to help. 08:17 glernil by the way.. what's the default username and password...? 08:18 magnuse bbl 08:23 eythian glernil: to log in the first time, use the database credentials, which are near the bottom of the koha-conf.xml that was created 08:23 eythian (in /etc/koha/sites/whatever/ 08:23 eythian ) 08:23 eythian then use that to create a staff account. 08:25 glernil wonderful... got it 08:26 eythian awesome 08:30 eythian two new green lights in my newborn Koha monitoring nagios configuration. That means it's time to go home. 08:31 rangi yay 08:38 glernil GTG! 08:40 mib_sun hi koha 08:42 mib_sun is there any option to list the details of books in ISBD view? I have to take the print out of all the books in ISBD view. 09:01 mib_sun hello.. is anyone there to help me.. 09:03 kf have you tried editing the ibsdview? 09:03 kf I am not sure if you can make it show the contents of 952 and when they will probably be not nicely formatted 09:04 kf what do you need to do? 09:05 mib_sun I have to take the print out of list of books in ISBD view. 09:05 mib_sun now only one book can view in ISBD view 09:06 kf ok 09:07 kf I don't think what you want to do is possible right now 09:09 mib_sun :( 09:10 mib_sun ok 09:10 kf you could try and experiment with the data formats you can export from koha 09:12 mib_sun thanks <kf>. i will try 09:15 rangi hey SpaceLibrarian_home 09:15 SpaceLibrarian_home evening rangi 09:16 kf hi SpaceLibrarian_home 09:16 SpaceLibrarian_home hey kf :) 09:21 mib_sun <kf>: one more doubt . how to take the print out of list of books and its details? only using 'Reports'? 09:23 mib_sun is there any other option to take the print out?? 09:27 kf you could make a report 09:27 kf there are also print options for single lists 09:28 kf and you can use the card and lists functions to get different lists 09:28 kf there are some possibilities, butnot from isbd 09:31 mib_sun for generating a report the person must have to know about the table fields. so it is very difficult for a librarian to generate the report 09:33 mib_sun what you mean by this card and lists functions?? 09:35 mib_sun When I am creating a list only Title,Author, and Date Added is displaying. How can I display more details in alist?? 09:37 kf in 3.4 there is more information 09:37 kf have you tried the opac cart? 09:37 kf there are different views too 09:43 mib_sun I have tried the cart too. but in this also price and other details is not coming. Shall I customize the fields displayed in the cart?? 09:48 SpaceLibrarian_home hey druthb 09:49 rangi heya druthb 09:52 kf hi druthb :) 09:52 druthb hi Shelley and Chris and Kaitlin. *hugs all round* 09:54 SpaceLibrarian_home :) 09:54 * kf feels ignored 09:54 kf ;) 09:55 * SpaceLibrarian_home gives kf a cookie 09:55 kf yay! 09:55 kf thx SpaceLibrarian_home :) 09:55 SpaceLibrarian_home my pleasure. :) 09:56 * druthb apparrently cannot type today, can she Katrin? 09:57 kf I got a cookie for you typo :) 09:57 * kf shares with druthb 10:00 * SpaceLibrarian_home hands out cookies 10:06 rangi im not liking your chances SpaceLibrarian_home 10:06 SpaceLibrarian_home my chances? For Origin? 10:07 rangi yep 10:07 rangi i usually cheer for the blues, cos they have the most maori in the team 10:07 rangi but its a thankless task 10:08 SpaceLibrarian_home I will be genuinely amazed and astounded if the Blues win 10:08 rangi yeah 10:08 SpaceLibrarian_home I've had five years to get used to the feeling of losing 10:08 SpaceLibrarian_home At least my football team wins consistently. It all balances out in the end. :) 10:18 * kf has no idea what rangi and SpaceLibrarian_home are talking about 10:18 * kf nibbles some more on her cookie 10:19 SpaceLibrarian_home It's a mad game of rugby league, played by two states in Australia 10:19 magnuse ah, sports... 10:20 magnuse cool message from finland on the devel-list! 10:20 SpaceLibrarian_home kf: http://en.wikipedia.org/wiki/Rugby_League_State_of_Origin 10:23 kf thx :) 10:26 huginn` New commit(s) needsignoff: [Bug 6406] double space in query result in no result <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6406> 10:30 magnuse the finns have the coolest librarians - we better help them make a good decision :-) 10:47 slef yengh 10:51 kf yengh? 10:51 kf hi slef :) 10:57 rangi shaugh 11:04 magnuse kia ora Irma 11:06 Irma Hi magnuse! I should have answered your email by now ... 11:06 Irma Sorry, really busy 11:06 magnuse Irma: no worries! it was just a shot in the dark... :-) 11:07 Irma I Well there are some new library building but they are scattered in the various States and Territories. 11:07 rangi magnuse: oh yeah 11:07 rangi i had one 11:07 Irma Where is the delegation going ... only Sydney? Other cities? 11:07 Irma hi rangi ... one in NZ? 11:08 Irma Or are you thinking of the new City of Sydney building in Surry Hills? 11:08 Irma We held a Kete workshop there last year 11:08 magnuse Irma: they havn't decided yet, they wanted tips before they plan where to go 11:08 rangi http://www.pukeariki.com/VisitUs/VisitUs.aspx 11:10 Irma My brother is an architect (and lives in Sydney) I will ask him and put the question to the members of the few ALIA e-lists I subscribe to 11:10 magnuse way cool! 11:10 magnuse sweet as! 11:12 magnuse hm, mysql is not installed as a dependency of koha-common? 11:12 rangi the server? nope 11:12 rangi cos your db server might be a different server 11:12 magnuse yeah, i guess that is a good point ;-) 11:13 magnuse and we might support more then on db in the future... 11:14 rangi yes that is still a goal 11:15 Irma Puke Ariki library information The Library has a relationship with Shell who have provided much of the information about the oil business. Many of the children have parents who work out on the rig. 11:15 Irma interesting merge of museum and library 11:16 Irma magnuse: I will get back with a few suggestions before toooo long :-) 11:17 rangi its a good building too, big exhibition space 11:18 Irma g'night #koha friends! 11:18 magnuse g'night Irma 11:18 magnuse rangi: i have passed on the link to puke ariki 11:18 rangi cool 11:21 magnuse it would be cool to get them to go to nz - could maybe get them to look at koha in its native habitat at the same time... :-) 11:21 rangi :) 11:57 SpaceLibrarian_home good evening #koha - I'll see you in a few. :) 12:08 NurAhammad Hi everybody good afternoon 13:06 * druthb peeks in for a moment. 13:07 oleonard Hi druthb. Just for a moment? 13:08 druthb yep. Ears-deep in some really wild n wooly data from a custom catalog app. Needed to get eyes off it for a moment, to solve a puzzle. 13:10 oleonard woolly_data-- 13:10 * oleonard threatens to instruct wahanui that druthb is a data-tamer and -shaver 13:10 druthb If this works out like I'm hoping, it's gonna be really nice. 13:11 druthb when my father was teaching me woodworking, he said, "if you're going to get the prettiest, most-figured grains, and the most beautiful results, you have to be ready to handle some wild wood." (which, natch, gave me my love for wandering in the woods to find downed wild wood--as opposed to lumberyards.) 13:11 druthb this is actually much the same. 13:15 * oleonard gets git-bz set up on his work machine 13:15 oleonard git-bz++ 13:21 kmkale Namaskar #koha 13:24 druthb Namaste, kmkale. :) 13:24 kmkale Namaste druthb :) 13:46 oleonard paul_p around? I can't reproduce bug 6406 13:46 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6406 minor, PATCH-Sent, ---, paul.poulain, ASSIGNED , double space in query result in no result 13:47 paul_p oleonard, yes, i'm here 13:48 paul_p do you mean that when you do a query with 2 words and 2 spaces between them, you get a result ? 13:48 danmc druthb: what part of the world do you live in (I was reading your wandering looking for wood comment) 13:48 oleonard paul_p: Yes. Same result as with only one space. 13:49 oleonard paul_p: I wonder if it could be a difference in zebra configurations? 13:49 paul_p wow. Not for me :( (although tested only on biblibre/master. There may be a little difference. Or it's marc21/unimarc or some other parameter...) 13:49 * oleonard hasn't touched his 13:50 druthb danmc: I live in suburban Washington, DC, now, but used to live in east Texas. 13:57 library_systems_guy morning #Koha 13:58 oleonard Hi library_systems_guy 13:59 library_systems_guy oleonard, you commit a lot of stuff, is there anyway to check and see if my commit wen't through? I think email isn't working on the server i sent it from 13:59 oleonard Do you mean check to see if a patch which you submitted went through? 13:59 library_systems_guy yes 13:59 oleonard If a patch goes through it shows up on the patches mailing list 14:00 library_systems_guy dang... 14:00 oleonard http://lists.koha-community.org/pipermail/koha-patches/ 14:01 library_systems_guy yeah definitly not 14:01 library_systems_guy is there another way to submit a patch other than email? 14:02 oleonard You could email it to the patches list as an attachment. And of course the patch should be attached to the bug report too 14:02 library_systems_guy gotcha 14:08 reiveune hello 14:09 library_systems_guy Hi reiveune 14:36 NCARMichael hey gang 14:37 library_systems_guy hey NCARMichael 14:39 NCARMichael question...i'm trying to get the 866a field(s) to show up as a column in a report. 14:40 NCARMichael is there a list somewhere of all the code words? 14:41 NCARMichael (biblio.title, biblio.biblionumber, etc) 14:41 library_systems_guy oh like the database schema 14:41 NCARMichael i'm guessing the one i'm looking for would likely be something like biblio.holdings 14:42 library_systems_guy somebody else may be able to give you a better answer but you should be able to do a desc on the biblio table if you have access to your mysql database 14:43 francharb hey all 14:43 francharb how is it doing today 14:43 library_systems_guy hey francharb 14:43 francharb ? 14:43 francharb hey library_systems_guy 14:44 library_systems_guy NCARMichael, is looking for a more satisfactory answer than what i can provide 14:44 library_systems_guy lol 14:44 francharb i really like your nickname 14:44 francharb ;) 14:44 library_systems_guy thanks :) 14:45 francharb is there anyone who know what on circulation.pl "material" column is used for? 14:45 francharb wooo, sorry for the broken english 14:46 francharb is it meant to be mapped with items.material? 14:46 francharb there is a total at the end of the column? what for? 14:46 oleonard francharb: Where do you see "material" ? 14:47 francharb when you check out, oleonard 14:47 francharb there are informations about what you check out, right 14:47 francharb ? 14:47 francharb due date 14:47 francharb title 14:47 francharb item type 14:47 francharb brnach 14:47 francharb checked out on 14:47 francharb charge 14:48 francharb AND 14:48 francharb material 14:48 francharb see? 14:48 oleonard The columns I have in 3.4.x: due date, title, item type, checked out on, call no., charge, price 14:48 kf no 14:48 kf same here as owen 14:48 francharb OMG 14:48 kf hehe 14:49 kf which version are you looking at francharb? 14:49 francharb kf: it's 3.06.00.029 but it's on biblibre branch 14:49 kf 2 reasons why we might not see it :( 14:50 francharb so i dont know if everything is on the community branch... 14:50 francharb :/ 14:50 kf I would imagine it could be a column for ... "beilagen"... like a cd goes with that book 14:50 francharb kf: but i thought it was from the community branch 14:50 kf can you look at the source code? 14:50 francharb kf: i think to 14:50 francharb too 14:50 francharb kf: i'm using it that way 14:51 francharb but sophie_m asked me why there is a total row for this column 14:51 francharb and i dont know... 14:51 francharb ;) 14:51 kf hm 14:51 kf the only lines with total we have is prive and charge 14:51 kf perhaps something related to an rfid development? 14:52 kf guessing wildly 14:52 francharb héhé 14:52 francharb hopefully 14:52 francharb but i guess not 14:52 francharb ;) 14:53 francharb we are working to get our branch integrated in the community branch. hope it will be done soon!! 14:53 francharb thanks all 14:54 magnuse francharb: we hope so too ;-) 14:54 francharb :) 14:56 kf yep 14:56 kf tryting to sign-off on the acq things 14:56 kf trying 14:57 kf francharb: a counter for the number of cd's you should have lying around on the desk after all is checked in? :) 14:59 huginn` New commit(s) needsignoff: [Bug 6357] Items (un)availability not displayed correctly (OPAC) <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6357> 15:00 hdl NCARMichael: biblio.holdings ??? are you looking for items ? 15:01 kf hdl? 15:01 wahanui hdl is, like, sure that Croswalking records in zebra is also ram demanding 15:03 hdl kf: in fact we reused the replacement price to put material information ... And the total is still there. 15:05 kf ah, riddle solved then 15:05 kf my questionmark was referring to your biblio.holdings comment 15:08 NCARMichael I'm looking for the coding for the 866a field. 15:08 NCARMichael biblio.holdings didn't work 15:08 NCARMichael it's a serials report that i'm working on 15:10 NCARMichael maybe it's serials.holdings 15:10 sekjal NCARMichael: 866a isn't parsed into the Koha database 15:10 NCARMichael oh 15:11 sekjal if it was in your incoming MARC records when you imported, you can look at biblioitems.marcxml 15:11 reiveune bye 15:11 sekjal and if you're on MySQL 5.1 or greater, there is way to query the XML 15:11 sekjal so you can search the MARC directly 15:11 NCARMichael okay 15:11 sekjal but Koha doesn't deal with MFHD at all at this time 15:12 sekjal I'm actually dealing with MFHD and serials holdings right now 15:12 sekjal Evergreen has a few Perl modules that can handle the parsing of MFHD; I'd be interested in finding a way to import them into Koha 15:13 magnuse mfhd? 15:13 sekjal MARC Format for Holdings Data 15:13 sekjal I think it's only MARC21 15:13 sekjal not sure if there is a UNIMARC equivalent 15:13 magnuse ah yes 15:14 magnuse MFHD is MARC Format for Holdings Data 15:14 magnuse mfhd? 15:14 wahanui hmmm... mfhd is MARC Format for Holdings Data 15:15 * oleonard whispers to wahanui that MFHD = Muppets Favor Hairy Data 15:15 hdl and he is quite right 15:16 sekjal the nightmare is compounded for me today; not only do I have to deal with MFHD, but I've got to do all kinds of crazy stuff to even GET the data in the first place 15:16 sekjal it involves screen scraping and XSLT 15:17 hdl the 'koha' management of serials seq is quite efficient.... Or has been before we added that javascript on top. 15:18 * magnuse shudders at the mention of screen scraping... 15:19 sekjal somewhere between 5000 and 20000 pages, I think 15:20 Cybermon hi all 15:24 magnuse hm what should i set ServerName to in the apache config when i'm setting up an installation that only has an ip yet, and no domain name? the ip address? 15:25 gmcharlt magnuse: that works 15:27 kf bye #koha .) 15:28 magnuse gmcharlt: alas, it does not ;-) 15:29 hdl NameVirtualHost IP 15:29 hdl ServerName nameyouwant 15:29 magnuse i get "File does not exist: /etc/apache2/htdocs" in error.log even though koha is the only active site and the koha config file makes no mention of that location 15:31 magnuse hdl: but i don't have a name for it yet... 15:32 hdl can't you create one ? 15:33 hdl ServerName has to be an fqdn iirc in /etc/apache2/apache2.conf 15:36 magnuse "ServerName koha" ad "ServerName <ip>" does not work, there is no fqdn yet, and i'm not responsible for setting it up 15:36 magnuse s/ ad / and / 15:49 rhcl I think slef is master of the little barbs, and Nicole and Wizzyrea master of the big barbs. 15:50 slef I do not own a barbie. 15:51 slef rhcl: what was that about anyway? 15:51 * slef is getting cross with daemon again 15:52 schuster druthb about? 15:52 rhcl your most recent post to the koha list 15:53 rhcl correction koha-devel list 15:53 slef ah, grumbling about libwebcats 15:53 slef well, it bloody annoys me 15:53 slef seeing libraries weakened to advantage vendors 15:54 slef it's unethical 15:54 slef but that's why I work for who I do 15:54 slef because that matters to me 15:54 rhcl apparently as much as overdrive annoys me 15:54 slef ah, don't get me started on that 15:54 rhcl yea, I went off on that yesterday a little 15:54 slef I liked a diveintomark/glynmoody tweet today 15:55 slef oh I've seen this before. I just don't remember where. 15:55 slef zebrasrv taking ages to start up 15:56 slef then printing something which confuses the terminal 15:56 slef yaz-client segfaulting on connect 15:56 slef hrm 15:56 slef aha, I think I've got it 15:58 slef no, I haven't. zebrasrv runs OK from command line now but not from daemon, "exited with 1 status" 16:00 cait hi #koha 16:00 slef hi cait. You can't remember what zebrasrv "exited with 1 status" means, can you? 16:00 cait um 16:00 cait never seen that I think 16:05 cait sekjal++ 16:07 NCARMichael How to display a particular marc field as a column in report results? 16:07 cait there is a hint on the wiki 16:07 cait how you can parse the marcxml field 16:07 cait sql library? 16:07 cait reports library? 16:07 wahanui somebody said reports library was found at http://wiki.koha-community.org/wiki/SQL_Reports_Library 16:09 NCARMichael yes, i've been scanning the reports library for clues. 16:09 NCARMichael so far all i see are things like this: IF( LOCATE('<datafield tag="020"', (etc) 16:11 NCARMichael I'm still trying to understand how SQL reports are structured. 16:11 NCARMichael Sometimes there are codings for a field (items.itemcallnumber), 16:11 cait hm 16:11 cait no 16:11 cait you are loooking for something else 16:11 NCARMichael but not all fields have such a coding 16:11 cait let em find it 16:12 cait http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC 16:13 NCARMichael right, i was just reading that section. 16:14 NCARMichael i'll play around with this for awhile. perhaps it will educate me in the reports dept. 16:14 NCARMichael thx 16:50 NCARMichael okay, more reports questions. :) 16:50 NCARMichael anyone? 16:54 NCARMichael http://paste.koha-community.org/59?tx=on&submit=Format+it! 16:54 NCARMichael it's not working, but i think i'm on the right track 17:02 pastebot "gmcharlt" at 68.101.78.67 pasted "for NCARMichael" (5 lines) at http://paste.koha-community.org/60 17:03 NCARMichael beautiful! 17:04 NCARMichael Thanks Galen! 17:04 gmcharlt you're welcome 17:05 NCARMichael This very basic report should prove quite versatile, methinks. 17:06 NCARMichael Now to add more columns to my results...title, for example. 17:08 NCARMichael where can I put "biblio.title"? 17:09 NCARMichael or perhaps add another extract (for 245a)? 17:16 NCARMichael http://paste.koha-community.org/61 17:17 NCARMichael That's what I've got so far...obviously it's wrong. 17:37 Brooke kia ora! 17:37 pastebot "gmcharlt" at 68.101.78.67 pasted "NCARMichael: variant 1" (6 lines) at http://paste.koha-community.org/62 17:38 pastebot "gmcharlt" at 68.101.78.67 pasted "NCARMichael: variant 2" (7 lines) at http://paste.koha-community.org/63 17:38 gmcharlt so first one is using another extractvalue, just adding a comma and a column alias name change 17:39 gmcharlt second is joining the biblio table to get access to biblio.title 17:48 NCARMichael thx galen 17:48 Brooke galen++ 17:49 Brooke If I had had comp sci profs like gmcharlt, I'd know how to code. 17:51 Brooke 0/ 17:56 NCARMichael Galen, using http://paste.koha-community.org/62 17:56 NCARMichael When I try to go to Page 2 of results, it reruns the report... 17:58 Brooke 0/ 17:58 NCARMichael (going to lunch...back later) 18:21 hdl going home 18:22 gmcharlt NCARMichael: it's a bug; working on fix 18:24 Brooke 0/ 18:24 pianohacker Hey brooke 18:25 Brooke how are things? 18:25 pianohacker Pretty good! 18:25 Brooke awesome 18:25 Brooke hooray for school winding down :D 18:25 pianohacker amen 18:25 pianohacker So glad to be on summer vacation 18:38 gmcharlt NCARMichael: @bug 6409 18:38 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6409 normal, P5, ---, gmcharlt, ASSIGNED , pagination bar for guided report output does not work if report has parameters 18:39 wizzyrea *nod* that one bugs me too ;) 18:44 gmcharlt wizzyrea: in that case, mind testing the patch I just submitted? 18:44 gmcharlt it also needs the patch for 6340 that cait did 18:44 cait thx for your sign-off on that :) 18:45 wizzyrea ah k ... lemme see 18:46 * Brooke wishes that the wiki fairy would come and sort things out for categories and uploads. 18:46 gmcharlt :( sorry 18:47 cait mails fixed? 18:48 gmcharlt NCARMichael: that fix is applied on your database. enjoy 18:48 cait I think Space_Librarian and some others tried to register 18:50 huginn` New commit(s) needsignoff: [Bug 6409] pagination bar for guided report output does not work if report has parameters <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6409> 18:59 Brooke 0/ 19:01 NCARMichael it works! thx galen. 19:07 pianohacker Welp, I think I'm about fed up with unity 19:07 pianohacker one crash too many 19:08 * Brooke comforts pianohacker. 19:09 pianohacker *sniff* 19:15 rhcl Unity is better now than the first iteration; the first was really flakey, but with some recent updates and a better working knowledge of it it seems to be better. 19:17 pianohacker I really like the feel of it. Either it or the other changes to compiz have made the whole system a bit fragile, though 19:17 pianohacker If you want to customize compiz at all, things get very twitchy 19:19 rangi just join eythian and I and use xmonad pianohacker :) 19:20 rhcl Yea, I've tried various settings with compiz, but a lot of the effects are annoying so I go back to some very basic things like transparency, which is helpful sometimes. I'm not completely decided on how well I <dis>like Unity. It seems OK on my netbook, but I really like multiple screens. 19:20 pianohacker rhcl: Unity almost had a heart attack when I dared put something in my VGA port 19:20 pianohacker rangi: I... dunno. I like some of the more interesting eyecandy compiz can do 19:20 pianohacker But i'll have to check xmonad out 19:21 rhcl Yes Yes! forgot about that. It totally locked up my netbook when I tried that. 19:21 rhcl I had to set the resolution to 800 X 600 _before_ connecting the vga cable. 19:22 pianohacker probably some issue with the 2048x2048 max screenbuffer size on most intel cards 19:22 pianohacker but not the most user-friendly way of showing it 19:23 rhcl yep 19:23 * cait waves 19:23 cait trying to set up git-bz now :) 19:23 rhcl hihi cait 19:24 pianohacker hey, this looks really cool. I thought this was some unholy combo of git and bazaar, but bugzilla integration sounds really useful 19:27 adnc hello koha 19:27 cait hi adnc :) 19:27 Brooke howdy 19:27 wahanui hey, Brooke 19:28 rangi pianohacker: have a look back in the logs 19:28 wizzyrea ph, i also have pretty good notes on it 19:29 rangi there is a little bug in the upstream, which ive sent a patch for, but until then if you clone from my repo it works 19:29 rangi (it works for standard bz, but our path is slightly different, and the bug is in setting hte path variable) 19:30 rangi wizzyrea is going to put her notes on the wiki i am sure 19:30 wizzyrea *nod* when I get back to work proper tomorrow 19:30 rangi :) 19:31 rangi off to catch the bus 19:31 rangi bbiab 19:32 adnc rangi any news about koha 3.4 for debian? 19:36 cait adnc: I think there is apatch that needs to be tested for the packages 19:37 cait wizzyrea++ 19:37 adnc hi cait 19:37 adnc thanks for the info 19:37 cait bug 6361 19:37 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6361 enhancement, PATCH-Sent, ---, robin, ASSIGNED , Packages need support for the 3.4 upgrade 19:37 cait perhaps you want to try :) 19:39 adnc ;) 19:39 bg @wunder 93109 19:39 huginn` bg: The current temperature in K6LCM - Westside / Mesa, Santa Barbara, California is 19.7�C (12:43 PM PDT on May 25, 2011). Conditions: Clear. Humidity: 59%. Dew Point: 11.0�C. Pressure: 30.00 in 1015.8 hPa (Steady). 19:40 cait @wunder Konstanz 19:40 huginn` cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 17.2�C (9:40 PM CEST on May 25, 2011). Conditions: Clear. Humidity: 68%. Dew Point: 11.0�C. Pressure: 30.08 in 1018.5 hPa (Steady). 19:40 bg heya cait 19:42 cait hi bg :) 19:43 cait almost as warm as in california - I bet we had 19.7 at your time :) 19:43 wizzyrea @wunder lawrence ks 19:43 huginn` wizzyrea: The current temperature in Channel 6 Downtown, Lawrence, Kansas is 17.6�C (2:47 PM CDT on May 25, 2011). Conditions: Scattered Clouds. Humidity: 84%. Dew Point: 15.0�C. Pressure: 29.41 in 995.8 hPa (Steady). 19:45 rangi its rainy out there 19:46 rangi @wunder wellington nz 19:46 huginn` rangi: The current temperature in Wellington, New Zealand is 17.0�C (7:35 AM NZST on May 26, 2011). Conditions: Rain. Humidity: 94%. Dew Point: 16.0�C. Pressure: 29.56 in 1001 hPa (Rising). 19:46 sekjal @wunder 01373 19:46 huginn` sekjal: The current temperature in Plain Road East, South Deerfield, Massachusetts is 25.0�C (3:35 PM EDT on May 25, 2011). Conditions: Partly Cloudy. Humidity: 51%. Dew Point: 14.0�C. Pressure: 29.92 in 1013.1 hPa (Steady). 19:47 sekjal bg: I think I have you beat, amazingly 19:48 bg yeah 25 is too hot 19:49 sekjal what?! it's GORGEOUS outside 19:51 slef oops I did it again 19:53 rangi ? 19:54 slef tweaked mbreeding 19:54 slef he winds me up 19:55 slef can he really not have realised libwebcats is a huge conman's streetmap? 19:55 * sekjal struggles not to insert a Britney Spears joke here... the time for such things is passed 19:55 rangi I think he probably hasn't 19:55 slef sekjal: yeah, I know people who wanted to insert Britney Spears, but think the time for such things is passed. 19:55 rangi I do think he thinks he is doing good 19:56 slef ...paved with good intentions :( 19:57 slef Anyway, after trying to send my most patient explanation (I failed), I then got bad news about OCLC's adoption of ODC-By 19:57 rangi they did? 19:57 slef They're going to adopt ODC-BY for WorldCat *alongside* the current usage policy, according to latest emails. 19:57 rangi gah 19:57 slef That makes little sense. 19:58 cait odc-by? 19:58 slef If ODC-BY is WorldCat-clickwrap-(AIUI)-compatible, that seems like a bug to me. 19:58 slef odc-by is http://www.opendatacommons.org/licenses/by/ 19:58 slef odc-by? 19:58 wahanui i guess odc-by is http://www.opendatacommons.org/licenses/by/ 19:58 slef :) 19:59 slef just checking 20:01 sekjal slef: I think I get where you're going with the Social Engineering concerns, but I'm missing the crucial piece of being worried. do you have any cases yet of bad guys attempting to use the info on libwebcats to steal patron data? 20:02 slef sekjal: people tend not to be open about successful security exploits. 20:02 slef sekjal: IOW no, not yet. 20:02 cait I think it's perhaps important how much information you have there 20:02 cait everybody can find out a library address 20:03 cait and someone from the field can findout the software you are using by looking at the opac pretty easily 20:03 slef cait: but library director names, support provider names? 20:03 cait for the proprietary systems support provider = software 20:03 sekjal so would the exploit be to call the library director and claim to be from the support company, asking for passwords? 20:03 cait and library directors are listed on homepages 20:04 cait sure it makes it easier to have the information already in a nice database, but it's not hard to get that info for someone who wants it 20:04 slef sekjal: no, to call a library worker, claiming to be from the support company, invoking the library director's name if they doubt it. 20:05 rangi done well, breach would never be noticed/reported 20:05 sekjal slef: yes, better exploit 20:05 slef cait: library directors are not listed on homepages in many cases here AIUI. If you are lucky, one librarian may be named. I'm surprised it's different for you: I thought we shared the same privacy laws? 20:05 rangi it happens a lot more than ppl think 20:05 sekjal would only work if the library worker knew who the support company was 20:05 sekjal I don't have stats on how often that's true... 20:05 cait slef: it's normal here that the team with names and work areas are listed 20:06 rangi sekjal: thats where a nice big list is handy 20:06 cait I think some big libraries do it different, but the small ones all do afaik 20:06 rangi one doesn't work, u have thousands more to try 20:07 slef I've just checked 3 of our libraries: 2 name one librarian (not the director) and 1 names no-one. 20:07 sekjal and then you'd be able to extract patron reading history 20:07 rangi but my main issue isn't the social engineering bit 20:07 rangi its the terms of use 20:07 slef sekjal: home address, payment details, ... 20:08 sekjal slef: I consider addresses, phone numbers and emails to be public knowledge 20:08 rangi and the fact it conflates vendor with software 20:08 rangi and only 1 vendor per lib etc 20:08 slef sekjal: EU laws disagree. 20:09 cait sekjal: um no 20:09 slef rangi: yeah, those were some other things I waved at quickly (things like...) and ran away from this time ;-) 20:09 cait not of patrons 20:09 sekjal slef: ok, that definitely overrules my considerations for a very large geographical area 20:09 cait a lot of people here do not list their phone numbers publicly 20:09 slef now you see, this is why it's a criminal offence to transfer personal data from the EU to the USA without safeguards ;-) 20:09 cait and a whole lot of existing email addresses... you can even sell that for good money 20:10 rangi ok my stop back soon 20:10 cait and a reason why people here don't get excited about web scale 20:10 cait having patron data somewhere in the cloud 20:10 slef also, the cloud = USA often = out of our laws 20:12 cait yep, exactly 20:12 slef UK privacy is http://www.ico.gov.uk/for_organisations/data_protection/the_guide/the_principles.aspx 20:12 sekjal is it any harder to find European folks addresses than Americans'? 20:12 cait the paperwork for privacy laws is driving me insane. but I understand why we do it 20:12 cait and once we have some templates it will get easier I hope 20:13 Ropuch Evening #koha 20:13 slef sekjal: it depends. For someone like me, the Distance Selling Regulations and so on means I'm findable. 20:13 cait sekjal: there are phone books, but you don't have to get listed 20:13 slef heh, yeah, my personal phone numbers aren't listed 20:13 slef oh wait, one is because I'm a councillor 20:13 cait I had mine deleted some time ago, should check again 20:14 * Brooke rings slef up angrily with a zoning dispute. 20:14 sekjal how often do you have to provide address/phone/email info to sign up for services in the EU? 20:14 slef Brooke: next council up. I'm only advisory on zoning. 20:14 sekjal and is that data always protected under the law? 20:15 Brooke "Oh, this is abuse? I wanted an argument!" 20:15 Brooke our info is technically protected to under your jurisdiction 20:16 Brooke be damned if you can't find duplicated info elsewhere, minus the checkout data, of course. 20:16 slef sekjal: mainly for things that give credit or hold money I think. And yes, always protected as default. 20:16 slef sekjal: try to find Cait. 20:16 * slef tries to find sekjal 20:16 cait huh? 20:16 sekjal slef: I think you'll have an easy time of it 20:17 * cait feels weird 20:17 slef bah it would help if I remembered which state you're in :) 20:17 cait sekjal: yes, they are not allowed to give data out to a third party and the person giving the data can make a request to see all the data they have saved 20:18 slef I think you're hiding by having a common name! 20:18 cait same for me I fear :) 20:18 Brooke oi, that's my gig. 20:18 sekjal slef: I think there are only two of me in the US... the third is recently deceased (the author of gardening books) 20:20 wizzyrea there are several of my short name, not sure how many in long form 20:21 rangi here xero got in trouble for storing peoples data overseas 20:22 rangi the tax department wasnt happy with them 20:22 rangi http://computerworld.co.nz/news.nsf/news/ird-cloud-alert-no-issue-were-talking-says-xero?Opendocument&HighLight=2,IRD 20:24 slef sekjal: yeah, search engines keep singularising your name, I see now :-/ 20:24 slef wizzyrea: what's rea short for? 20:24 slef dinnertime bbl 20:25 wizzyrea elizabeth vs. liz 20:25 wizzyrea ;) 20:25 wizzyrea rea is just short 20:25 rhcl Well, I'm finding info on Katrin Fisher, including work contact info, but maybe I'm missing the point 20:25 cait on our institution's hp? 20:25 rhcl yea 20:26 cait yep 20:26 cait I had to sign a paper 20:27 Brooke it's two different worlds if you put in just my first and last name versus the name I publish under. 20:27 cait for our new homepage anyway and which information I wanted to show there 20:27 sekjal slef: dropping the 's' at the end of my name gives much worse results, in my finding. more common, that iteration of the name 20:27 pianohacker routers-- # one hell of a day for tech 20:28 slef rhcl: and home? 20:28 rhcl but there is a lot of data associating your nick with your real name...but my thought is that we generally regard contact info (official business info) for things like library directors as open knowledge here in the US. 20:29 Brooke you'd be amazed at how buried some duhrectors can make things 20:29 rangi heh sekjal and I both replied at the same time to bev 20:29 slef and urgh, someone reply to mbreeding before I do please... he's comparing libwebcats with the wiki instead of the suggested optionally-anonymised popcon. 20:29 rhcl slef: no, but I'm not a very persistent peep. I'm not really making any effort to really look up personal info on her. 20:29 slef now really dinner :) 20:29 rangi sekjal: i have a question for ya 20:30 rangi rhcl: all security is target reduction, not absolutes 20:30 rangi you dont have to run faster than the lion 20:30 sekjal rangi: shoot 20:30 rangi just faster than the guy next to you 20:30 rhcl shoot the lion? 20:30 cait rangi: don#t see yourmail? 20:30 rhcl that's real target reduction 20:30 slef outlaw the lion biting people... that's the EU solution :-S 20:30 rhcl hehe 20:31 rangi sekjal: i was going to jump into the signed off queue and grab any of the little TT bugs 20:31 Brooke hey, mebbe I like biting lions. 20:31 rangi sekjal: sound like an ok idea? 20:31 sekjal rangi: sounds great. working on bug 6359 right now 20:31 slef Brooke: what would you make of a flat roofing contractor? 20:31 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6359 minor, P5, ---, cnighswonger, NEW , number one printing on quick label page 20:31 sekjal wait 20:31 sekjal that's not the right number 20:31 rangi :) 20:32 slef bug -1 20:32 rhcl slef isn't going to get anything to eat...stays on irc 20:32 rhcl :) 20:32 sekjal bug 6395 20:32 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6395 critical, PATCH-Sent, ---, oleonard, ASSIGNED , cannot create routing list - template error? 20:32 slef yeaaaaah 20:32 rangi ill clear my passed qa queue first 20:32 sekjal apparently, I'm dyslexic for bug numbers 20:32 cait go and greetings to S :) 20:32 rangi then grab any simple ones out of signed off (one line TT changes and the like) 20:32 rangi cool 20:33 cait rangi: see your mail no 20:33 cait w 20:34 NCARMichael allo again. more reports... 20:34 NCARMichael http://paste.koha-community.org/65?tx=on&submit=Format+it! 20:35 NCARMichael question: how to order results by title (asc) 20:36 NCARMichael anyone? Bueller? 20:36 pianohacker I think you should be able to just tack on an ORDER BY TITLE to the end of that 20:36 Brooke 0/ 20:37 rangi heya larryb 20:37 larryb Hi there. 20:38 NCARMichael oh. duh. thx! 20:39 pianohacker np 20:40 NCARMichael uh oh. now it gives me only one page. 20:41 NCARMichael i wonder if this has anything to do with galen's recent patch for the pages bug... 20:41 wizzyrea actually no, probably not 20:41 wizzyrea that's been a bug for a while 20:41 wizzyrea I just download those :P 20:42 sekjal cait++ 20:42 cait there were 2 bugs, the pagination bar in 3.4.1 is still broken I think 20:42 cait does never show up 20:42 slef dinner still cooking :) 20:42 cait sekjal? 20:42 wahanui sekjal is a wonderful geek. 20:42 Brooke tee hee! 20:43 cait yeah, wahanui - I KNOW - but why is he giving mekarma? 20:43 wizzyrea well you're awesome of course 20:43 sekjal cait: for the test plan included with bug 6340 20:43 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6340 major, PATCH-Sent, ---, katrin.fischer, ASSIGNED , Pagination bar on guided reports result page broken 20:43 sekjal (pushing through QA right now) 20:44 NCARMichael pages only disappeared once i added "ORDER BY TITLE" 20:44 cait oh 20:44 cait I try :) 20:45 pianohacker NCARMichael: accursed thing. This is being run through the custom SQL part of the guided reports wizard, right? 20:45 cait sekjal: better to note on bug in the commit message or in bugzilla? 20:45 sekjal either place is fine by me 20:45 sekjal I'll see both in the QA process 20:47 rangi heh 20:47 rangi bug 6401 20:47 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6401 enhancement, PATCH-Sent, ---, nengard, NEW , Give Ian Walls credit in the history file. 20:47 rangi thats an easy push :) 20:47 sekjal rangi: most of the ones in the Passed QA queue right now are easy... I started with ones I could do by reading 20:48 rangi sounds like a good plan to me 20:52 NCARMichael yes, custom SQL. 20:53 cait rangi: got git-bz working with liz help :) 20:53 cait wizzyrea++ 20:53 rangi yay 20:53 wizzyrea was there more to do for pushing up patches 20:54 wizzyrea ? 20:55 cait wizzyrea ? :) 20:55 slef I need more servers again :( 20:55 wizzyrea you can use gitbz to attach patches to bugs as well 20:55 gmcharlt slef: what happened? 20:56 huginn` New commit(s) kohagit: Bug 6401 fix to the history file <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=59e9137d8339de68f2cc4c7dcc60f4e2d7fbea43> / Bug 3580 Sort the facets categories so they don't move every search. <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=0d4ab0ecb65dd92f785b062e2dbe920bc8e1bfcf> 20:57 rangi so what you do 20:57 rangi is on your branch 20:57 rangi you make a commit 20:57 slef gmcharlt: too many customers... need more space for dev work... nothing to worry about... just need the research server to come online in a few days 20:57 rangi git attach bz bugnumber HEAD 20:57 NCARMichael pianohacker: r u sure it's a bug? pages work fine on custom report UNLESS i add "order by title" 20:58 rangi sorry git bz attach 20:58 wizzyrea how does it know who you are? based on firrefox cookie? 20:58 rangi that will attach the latest commit, to the bug 20:58 rangi yes 20:58 wizzyrea kool 20:58 rangi this is cool too 20:58 pianohacker NCARMichael: Adding ORDER BY TITLE is valid SQL 20:58 rangi you can use -e 20:59 pianohacker the guided reports wizard is likely adding its own ORDER BY, which doesn't work 20:59 rangi to edit the patch 21:00 NCARMichael but i'm not using guided reports... 21:01 rhcl speaking of servers, we got one of these and are using it for our Koha test machine. Very happy with it so far. 'cept they've raised the price, our's was $69. 21:01 rhcl https://www.andovercg.com/store/Sun-SunFire-Fire-V20z-Dual-2-2Ghz-4GB-Server-p1136.html 21:01 gmcharlt pianohacker: it isn't adding an order by automatically to SQL reports. how would it even guess? 21:02 pianohacker gmcharlt: you're right, it doesn't make sense 21:02 pianohacker looking at the code now 21:03 rhcl oh, and it looks like the current batch only has 4gb, ours has 8. Looks like we bought at the right time. 21:03 slef rhcl: does buying that fund oracle? ;) 21:03 rhcl no, it's used, surely no money to Oracle, and we even used Deb instead of Solaris 21:04 rangi i wonder if i could bring a couple back in my suitcase 21:04 rangi rhcl: noisy? 21:05 rhcl My poor tech assistant, a college student, bought one for himself in all his excitement over such a great find. He can't use it since he has to keep it in his bedroom and it's too noisy for anyone in the house to stand. :) 21:05 slef sounds like the suns I remember 21:05 rangi yeah 21:07 rhcl yep, absolutely the best hardware known to humankind, but noisy. Sad situation now that Sun has departed. 21:07 pianohacker NCARMichael: I'm really not sure why that's breaking it, sorry 21:07 Space_Librarian morning #koha 21:09 rangi hi sekjal 21:09 rangi gah 21:09 rangi Space_Librarian even 21:09 Space_Librarian hehehe. :) 21:09 sekjal 'bye sekjal' is more appropriate now... I've got to dash 21:10 Space_Librarian ciao sekjal 21:10 Space_Librarian :) 21:10 rangi cya 21:10 sekjal later Space_Librarian, rangi, #koha! 21:10 pianohacker NCARMichael: Is it feasible for you to check your error log? 21:15 gmcharlt NCARMichael: turns out it didn't like the aliasing of 'title' in the order by clause 21:16 pastebot "gmcharlt" at 68.101.78.67 pasted "NCARMichael: this version works" (1 line) at http://paste.koha-community.org/67 21:16 * wizzyrea is happy to see joins instead of left joins 21:18 pianohacker gmcharlt: So there's specifically a problem with aliasing the results of functions? That's frustrating, thanks for figuring it out 21:19 cait you could try order by 1 21:20 pianohacker cait++ # Never heard of that before, but it works 21:20 cait for first colum 21:20 cait n 21:20 cait does work for me 21:20 cait hehe 21:20 cait distance_study_sql_course++ 21:23 gmcharlt cait: indeed; for some reason I was under the mistaken impression that mysql didn't support that yet 21:23 gmcharlt ... 21:23 gmcharlt now I remember, I think it's group by 1 that mysql doesn't do 21:23 cait I think you are right about htat 21:24 gmcharlt no, I'm still wrong, it likes that 21:24 gmcharlt at least in 5.1 21:25 NCARMichael it works! yet another thanks, galen. (and pianohacker!) 21:27 cait gmcharlt: good to know! 21:29 jenkins_koha Project Koha_master build #256: ABORTED in 3 mn 38 s: http://jenkins.koha-community.org/job/Koha_master/256/ 21:31 jenkins_koha Starting build 257 for job Koha_master (previous build: ABORTED -- last SUCCESS #255 1 j 19 h ago) 21:35 cait unhappy jenkins? 21:35 rangi yeah 21:35 rangi java 21:35 rangi oh look you have ram, let me use ALL OF IT 21:36 rangi i think its under control again now 21:36 huginn` New commit(s) kohagit: Fix for Bug 6395, Cannot create routing list <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5984520211337750fbae0fe5a5fcba7cb85bf212> / Bug 6343: TT issues in label creator <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f515052d6e2a41f0a84b2999204691a84ebe78e1> / Bug 5658 can't delete subfields in frameworks <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=fafbff9018ecc4030983ca14 21:39 cait hungry jenkins 21:40 cait !jenkins botsnack lots of cookies 21:40 jenkins_koha cait: you're so kind to me! I could eat lots of cookies all day long 21:43 pianohacker !jenkins botsnack RAM 21:43 jenkins_koha pianohacker: great! yum yum. I just love RAM! 21:44 Space_Librarian did I not feed jenkins enough cookies last night? sorry. ;) 21:45 wizzyrea h its nice to haveph around again :) 21:48 pianohacker thanks wizzy :) 21:48 pianohacker good to be back 21:56 huginn` New commit(s) kohagit: Fix for Bug 3140 - It is possible to email someone else's private list <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b65f6d0a99dc13e73aed5058a44a72895c829b32> 22:14 jenkins_koha Project Koha_master build #257: SUCCESS in 43 mn: http://jenkins.koha-community.org/job/Koha_master/257/ 22:14 jenkins_koha * Frédérick Capovilla: Bug 3580 Sort the facets categories so they don't move every search. 22:14 jenkins_koha * ruth@bywatersolutions.com: Bug 6401 fix to the history file 22:14 jenkins_koha * Fridolyn SOMERS: Bug 5658 can't delete subfields in frameworks 22:14 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3580 enhancement, PATCH-Sent, ---, gmcharlt, NEW , Control order in which facet categories display 22:14 jenkins_koha * Katrin Fischer: Bug 6343: TT issues in label creator 22:14 jenkins_koha * Owen Leonard: Fix for Bug 6395, Cannot create routing list 22:14 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6401 trivial, PATCH-Sent, ---, nengard, NEW , Give Ian Walls credit in the history file. 22:14 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5658 critical, PATCH-Sent, ---, fridolyn.somers, ASSIGNED , can't delete subfields in frameworks 22:14 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6343 critical, PATCH-Sent, ---, katrin.fischer, ASSIGNED , Label Creator not working , Current Branch: NULL 22:14 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6395 critical, PATCH-Sent, ---, oleonard, ASSIGNED , cannot create routing list - template error? 22:14 jenkins_koha Starting build 258 for job Koha_master (previous build: SUCCESS) 22:15 rangi yay 22:16 cait :) 22:46 cait good night #koha 22:47 rhcl who wrote Makefile.PL? 22:48 rhcl It seems to do a heck of a lot of stuff for a non-compiled language 22:49 pianohacker rhcl: according to git log Makefile.PL, slef started it, and he's the local perl wizard 22:52 rangi its moving templtaes round, populating config files etc 22:52 eythian it's probably started with MakeMaker 22:53 eythian (disclaimer: I haven't the foggiest idea of how MakeMaker works, just that it exists) 22:53 rhcl the next kohacon I go to I want somebody to do a full 1 hour presentation on what it's doing. 22:54 eythian 1 hour is a bit short. It seems like a 1 week presentation would start to fit most of it :) 22:54 rhcl makefile is apparently just a list of all the perl modules and stuff included (images, etc) in the final Koha build 22:55 rhcl Oh, after one hour I'm sure I'd walk out... :) 22:57 jenkins_koha Project Koha_master build #258: SUCCESS in 42 mn: http://jenkins.koha-community.org/job/Koha_master/258/ 22:57 jenkins_koha Owen Leonard: Fix for Bug 3140 - It is possible to email someone else's private list 22:57 huginn` 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3140 major, PATCH-Sent, ---, oleonard, ASSIGNED , It is possible to email someone else's private list 23:28 jenkins_koha Starting build 259 for job Koha_master (previous build: SUCCESS) 23:29 huginn` New commit(s) kohagit: Bug 6258 - Guided reports wizard 'Build new' brings up empty page <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=14364d9866dd65abb737a59e49f297328edde83d> 23:34 Soup oh :D hello 23:35 Soupermanito well hello 23:35 wahanui hola, Soupermanito 23:35 Soupermanito hola! 23:35 Soupermanito :D hablan espa�ol? 23:36 rangi wahanui is a bot, it doesnt really speak any language 23:37 Soupermanito oh :D ok, ahm hello people then, I am a library science student and i wanted to learn to use and configure koha 23:37 Soupermanito to add that to my resum� XD 23:38 Soupermanito so i was hoping to learn to install it and configure it using a simple network i have at this box, whit some virtual machines as clients and stuff like that 23:42 pianohacker Soupermanito: that's very doable. You don't even need virtual machines as clients, since a Koha client is just a web browser 23:42 Soupermanito :) 23:42 Soupermanito yes i noticed that 23:43 eythian http://wiki.koha-community.org/wiki/Setting_Up_Koha_in_Virtual_Environment_%2B_Using_That_as_a_Development_Environment <-- Soupermanito, maybe this'll get you somewhere. 23:43 Soupermanito i've also found this http://hubpages.com/hub/Install-Koha-on-Ubuntu 23:48 rangi http://access2011.library.ubc.ca/schedule/#day1 23:50 Soupermanito :) a lot of universities in argentina are starting to use koha 23:51 Soupermanito :D thats why i want to learn about it :D