IRC log for #koha, 2011-05-25

All times shown according to UTC.

Time S 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 hdl left #koha
00:08 pianohacker jcamins_away_actuallyhere_butnotreallywentout​fordinner_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:24 oleonard joined #koha
00:25 pianohacker bye, all
00:25 pianohacker left #koha
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:30 glernil joined #koha
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:35 oleonard is now known as owen-away
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:07 glernil left #koha
01:19 hankbank left #koha
01:22 owen-away left #koha
01:23 hdl joined #koha
01:35 SteveJ joined #koha
01:40 SteveJ left #koha
01:43 eythian http://aggiesprite.files.wordp[…]05/rednekwine.jpg <-- mtj
01:58 druthb left #koha
02:19 glernil joined #koha
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[…]on_Debian_Squeeze
03:00 rangi with
03:00 rangi http://wiki.koha-community.org[…]ing_Koha_packages
03:01 rangi http://wiki.koha-community.org[…]ueeze#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:12 Brooke joined #koha
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 Oak joined #koha
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:02 Space_Librarian left #koha
05:03 Oak catch'ya'll later! and poof! sure was a space librarian...
05:15 cait joined #koha
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 jransom joined #koha
05:20 cait on time?
05:20 jransom left #koha
05:20 cait and hi Oak )
05:20 Oak :) hi
05:21 eythian hiya
05:22 cait hi eythian :)
05:40 Ahmuck-Sr joined #koha
05:40 Brooke 0/
05:47 Ahmuck left #koha
05:48 Brooke tossing and turning time!
05:48 Brooke left #koha
05:53 hdl left #koha
05:56 ronald joined #koha
06:01 clrh joined #koha
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[…]ueeze#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:29 francharb joined #koha
06:30 francharb hello all
06:31 rangi hi francharb
06:32 clrh left #koha
06:32 clrh joined #koha
06:33 clrh hi
06:33 wahanui hi, clrh
06:33 rangi hi clrh
06:35 cait hi francharb and clrh
06:37 julian joined #koha
06:41 cait left #koha
06:46 hdl joined #koha
07:03 matts_away is now known as matts
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:10 Guillaume joined #koha
07:18 sophie_m joined #koha
07:18 paul_p joined #koha
07:20 Irma left #koha
07:20 kf joined #koha
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:29 magnus_away is now known as magnuse
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/e[…]11/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:19 magnuse is now known as magnus_away
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:35 mib_sun joined #koha
08:38 glernil GTG!
08:38 glernil left #koha
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 SpaceLibrarian_home joined #koha
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:24 Guillaume left #koha
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 druthb joined #koha
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:03 Oak left #koha
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:11 ronald left #koha
10:16 magnus_away is now known as magnuse
10:18 matts is now known as matts_away
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/R[…]e_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[…]w_bug.cgi?id=6406>
10:30 magnuse the finns have the coolest librarians - we better help them make a good decision :-)
10:35 druthb left #koha
10:44 mib_sun left #koha
10:47 slef yengh
10:51 kf yengh?
10:51 kf hi slef :)
10:57 rangi shaugh
11:02 Irma joined #koha
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:17 Guillaume joined #koha
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:18 Irma left #koha
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:30 jwagner_away is now known as jwagner
11:31 jwagner left #koha
11:31 jwagner joined #koha
11:41 JesseM joined #koha
11:47 matts_away is now known as matts
11:57 SpaceLibrarian_home good evening #koha - I'll see you in a few. :)
11:57 SpaceLibrarian_home left #koha
11:58 magnuse is now known as magnus_away
12:07 NurAhammad joined #koha
12:08 NateC joined #koha
12:08 NurAhammad Hi everybody good afternoon
12:09 NateC left #koha
12:09 NateC joined #koha
12:09 sekjal joined #koha
12:11 oleonard joined #koha
12:17 BobB left #koha
12:49 NurAhammad left #koha
12:58 Guillaume left #koha
13:06 druthb joined #koha
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:19 coryj_away left #koha
13:21 kmkale joined #koha
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` Bug http://bugs.koha-community.org[…]w_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 joined #koha
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.or[…]ail/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 joined #koha
14:08 reiveune hello
14:09 library_systems_guy Hi reiveune
14:12 kmkale left #koha
14:21 NurAhammad joined #koha
14:22 druthb left #koha
14:36 NCARMichael joined #koha
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 magnus_away is now known as magnuse
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 rhcl_away is now known as rhcl
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 Johnindy joined #koha
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 NurAhammad left #koha
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[…]w_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 reiveune left #koha
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 sophie_m left #koha
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:19 Cybermon joined #koha
15:20 Cybermon hi all
15:22 Cybermon left #koha
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:27 kf left #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:29 matts is now known as matts_away
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 oleonard left #koha
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 schuster joined #koha
15:51 slef rhcl: what was that about anyway?
15:51 * slef is getting cross with daemon again
15:52 julian left #koha
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:56 talljoy joined #koha
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 joined #koha
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:05 clrh left #koha
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[…]L_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[…]ibrary#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:25 paul_p left #koha
16:50 NCARMichael okay, more reports questions. :)
16:50 NCARMichael anyone?
16:54 NCARMichael http://paste.koha-community.or[…]submit=Format+it!
16:54 NCARMichael it's not working, but i think i'm on the right track
16:59 cait left #koha
17:00 Guillaume joined #koha
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 joined #koha
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:40 Guillaume left #koha
17:46 magnuse is now known as magnus_away
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 aogle joined #koha
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 cait joined #koha
17:58 Brooke 0/
17:58 NCARMichael (going to lunch...back later)
18:05 jwagner is now known as jwagner_away
18:06 Ahmuck-Sr left #koha
18:19 jwagner_away left #koha
18:21 hdl going home
18:21 jwagner joined #koha
18:21 jwagner is now known as jwagner_away
18:22 gmcharlt NCARMichael: it's a bug; working on fix
18:22 pianohacker joined #koha
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` Bug http://bugs.koha-community.org[…]w_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 hdl left #koha
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[…]w_bug.cgi?id=6409>
18:58 coryj joined #koha
18:59 Brooke 0/
19:01 NCARMichael it works! thx galen.
19:06 pianohacker left #koha
19:07 pianohacker joined #koha
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:10 jwagner_away left #koha
19:12 NCARMichael left #koha
19:13 schuster left #koha
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:25 adnc joined #koha
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:33 pianohacker left #koha
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` Bug http://bugs.koha-community.org[…]w_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:50 Ahmuck joined #koha
19:51 slef oops I did it again
19:52 Guillaume joined #koha
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
19:59 francharb left #koha
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 adnc left #koha
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 Guillaume left #koha
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_orga[…]e_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 NCARMichael joined #koha
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 coryj is now known as coryj_away
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/new[…]t&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 pianohacker joined #koha
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` Bug http://bugs.koha-community.org[…]w_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` Bug http://bugs.koha-community.org[…]w_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.or[…]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 larryb joined #koha
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` Bug http://bugs.koha-community.org[…]w_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` Bug http://bugs.koha-community.org[…]w_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 moodaepo left #koha
20:53 wizzyrea was there more to do for pushing up patches
20:54 wizzyrea ?
20:54 Brooke left #koha
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/[…]dcc60f4e2d7fbea43> / Bug 3580 Sort the facets categories so they don't move every search. <http://git.koha-community.org/[…]e2dbe920bc8e1bfcf>
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/stor[…]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:06 Space_Librarian joined #koha
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:10 sekjal left #koha
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 Irma joined #koha
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.[…]/Koha_master/256/
21:29 jenkins_koha left #koha
21:30 jenkins_koha joined #koha
21:30 NCARMichael left #koha
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/[…]5a5fcba7cb85bf212> / Bug 6343: TT issues in label creator <http://git.koha-community.org/[…]9204691a84ebe78e1> / Bug 5658 can't delete subfields in frameworks <http://git.koha-community.org/[…]018ecc4030983ca14
21:37 NateC left #koha
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 larryb left #koha
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:49 moodaepo joined #koha
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/[…]8a44a72895c829b32>
22:14 jenkins_koha Project Koha_master build #257: SUCCESS in 43 mn: http://jenkins.koha-community.[…]/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` Bug http://bugs.koha-community.org[…]w_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` Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6401 trivial, PATCH-Sent, ---, nengard, NEW , Give Ian Walls credit in the history file.
22:14 huginn` Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5658 critical, PATCH-Sent, ---, fridolyn.somers, ASSIGNED , can't delete subfields in frameworks
22:14 huginn` Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6343 critical, PATCH-Sent, ---, katrin.fischer, ASSIGNED , Label Creator not working , Current Branch: NULL
22:14 huginn` Bug http://bugs.koha-community.org[…]w_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:15 talljoy left #koha
22:16 cait :)
22:22 coryj_away left #koha
22:39 hankbank joined #koha
22:46 cait left #koha
22:46 cait joined #koha
22:46 cait good night #koha
22:46 cait left #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.[…]/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` Bug http://bugs.koha-community.org[…]w_bug.cgi?id=3140 major, PATCH-Sent, ---, oleonard, ASSIGNED , It is possible to email someone else's private list
23:00 aogle left #koha
23:16 skushner joined #koha
23:24 hankbank left #koha
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/[…]e49f297328edde83d>
23:33 Soup joined #koha
23:34 Soup oh :D hello
23:34 Soup is now known as Soupermanito
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[…]pment_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

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary