Time  Nick           Message
00:00 bag            heh
00:00 libsysguy      I'm trolling koha aloha
00:00 libsysguy      but can't seem to find it
00:02 eythian        "kohaaloha is bad and mtj should feel bad!" -- that sort of trolling?
00:02 libsysguy      oh no, trolling like a motor
00:02 libsysguy      not like trolololol
00:03 libsysguy      logs?
00:03 wahanui        hmmm... logs is http://irc.koha-community.org/irclog/koha/
00:03 eythian        http://youtu.be/v1PBptSDIh8 <-- so more like this?
00:04 libsysguy      LOL
00:05 libsysguy      http://www.youtube.com/watch?v=boh92DrYEWs
00:06 eythian        http://www.thebestdamnpoll.com/Portals/4/images/ForumImages/roflmao.gif
00:17 libsysguy      lol
00:17 libsysguy      i found mtj's git repo
00:17 libsysguy      we're good now
00:18 jcamins        Someone from Luxembourg, of all places, is spidering one of my clients' entire catalogs.
00:22 eythian        do you think anyone would object to a patch making quick slips include the address? This is actually already implemented, it's just when you select quick slip, it takes you to the slightly less detailed one.
00:22 eythian        It just seems too small to make a syspref for
00:23 eythian        I might make the patch anyway, see if anyone complains and if they do, deal with it then.
00:25 wizzyrea       eythian: don't the customizable slips - can't you add that there
00:25 eythian        oh, when do/did they come about?
00:25 wizzyrea       3.8
00:26 wizzyrea       if you can't get a proper address now, the right place to add that is probably notices
00:26 eythian        hmm yes
00:26 eythian        I shall have a look.
00:26 wizzyrea       \o/
00:26 wizzyrea       :D
00:32 eythian        wizzyrea: I think you're exactly right with that notices thing.
00:41 wizzyrea       ask srdjan about how much he loves bug 7001 ;)
00:41 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7001 enhancement, P3, ---, srdjan, Pushed to Master , User Configurable Slips
01:19 jcamins        My god I hate MARC-8.
01:22 jcamins        It's like someone said "I know, let's take rule 123, combine it with incompetence, stupidity, and malice, and turn that into something we'll call a 'character set' that really isn't."
01:23 rangi          yup
01:29 wizzyrea       MARC-8 is let's take rule 123, combine it with incompetence, stupidity, and malice, and turn that into something we'll call a 'character set' that really isn't.
01:29 wizzyrea       MARC-8?
01:29 wahanui        MARC-8 is let's take rule 123, combine it with incompetence, stupidity, and malice, and turn that into something we'll call a 'character set' that really isn't.
01:32 jcamins        lol
01:39 jcamins        Also, has anyone ever noticed that "export records in utf-8"... doesn't?
01:47 jcamins        Actually, I take that back.
01:47 jcamins        The records are in UTF-8, but the leader is set to MARC-8 on export.
01:49 eythian        Heh, I had a lot of records that were the reverse of that
01:51 jcamins        eythian: I'm used to the other way around.
01:51 jcamins        It irritates me no end, but I'm used to it.
01:54 jcamins        OPAC?
01:54 wahanui        OPAC is for patrons
02:19 jcamins        I have a TT puzzle.
02:19 jcamins        I have a variable stored in an array.
02:19 jcamins        [% FOREACH fmo IN fmos %] works exactly as you'd expect.
02:19 jcamins        However, I would like to know that there is at least one member of fmos before I print the label.
02:20 jcamins        Anyone know how to do that?
02:25 jcamins        Right, figured it out.
02:25 jcamins        fmos.defined(0)
03:27 mtj            hmm, i wonder if libsys found my bootstap repo ok...
03:28 mtj            atm, i cant remember where i put it, even
03:29 mtj            jcamins_away, thanks for posting this interesting list -> http://paste.koha-community.org/298
03:53 mtj            wow, great topic on /.  -> http://developers.slashdot.org/story/12/12/03/2312241/auto-threading-compiler-could-restore-moores-law-gains
03:56 mtj            "I've been in the industry for decades, and every couple of years someone comes out with yet another programming language or technique that is supposed to revolutionize application parallelization. This is just another one, and many years behind the rest of the industry from what I can tell."
04:58 vkm            hello all, may i know is it necessary to keep accession series separate while managing multiple library
05:16 cait           hi #koha
05:19 vkm            hi
05:19 wahanui        privet, vkm
05:20 vkm            privet means
05:22 cait           privet is hello in russian - don't mind the bot :)
05:23 vkm            oh thz i learn russian one word privet
05:24 vkm            in managing multiple branch is it necessary to keep accession number/series separate to avoid duplicate number
05:24 cait           hi clrh :)
05:24 cait           vkm: do you imean inventory numbers ($i) or barcodes?
05:24 vkm            yes
05:25 vkm            barcodes
05:25 wahanui        barcodes are all in weird places
05:25 cait           have you looked into the autobarcode settings?
05:25 cait           koha should never allow you to add duplicate barcodes
05:26 cait           it also depends, if you are using preprinted barcodes or want koha to generate them
05:26 vkm            suppose i have many branch exist but at present their accession/barcode is same, so is it possible to manage them in koha without changing barcodes
05:28 cait           oh
05:28 cait           i think there was done some development in this direction
05:28 cait           but it's not available in koha right now
05:28 cait           maybe search bugzilla for barcode prefixes
05:29 cait           bug 7676
05:29 vkm            i thing in multiple libraries case it should be like that
05:29 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7676 enhancement, P5 - low, ---, kyle.m.hall, In Discussion , Barcode Prefixes
05:29 vkm            to accept same barcode/accession number because of different brances
05:30 cait           yes, look into the bug description
05:30 cait           vkm: the prefixes are 'virtual'
05:30 cait           the barcodes in the books can be duplicate, the prefix is by branch
05:31 cait           to make it unique for the database, as far as I unerstand
05:34 vkm            thx i will check
07:18 * magnuse      waves
07:23 * cait         waves back
07:24 magnuse        yay! :-)
07:48 reiveune       hello
07:48 wahanui        what's up, reiveune
07:51 alex_a         bonjour
08:01 Joubu          hello #koha
08:23 clrh           hello clrh
08:23 clrh           hello Caitttt :)
08:26 alex_a         hello clrh !!
08:26 alex_a         :)
08:26 alex_a         and cait :)
08:47 kf             hi #koha
10:10 vfernandes     hi :)
10:28 gerundio       oi vfernandes :)
10:28 gerundio       tudo bem?
10:31 vfernandes     sim... português?
10:43 gerundio       sim, sou o Rolando :)
10:44 gerundio       can anyone explain to me the LDAP auth workflow after the 1st login?
10:44 gerundio       is a user supposed to be able to log in using his card number as his username?
11:11 vfernandes     there is any perl method in any pm that check if the patron has any item of the record?
11:35 tcohen__       morning #koha
11:35 vfernandes     good morning tcohen
12:15 gerundio       I just noticed I'm able to login with my LDAP credentials even after turning LDAP auth off
12:15 gerundio       looking at the borrowers table I find that there's and hash value on the password field for my uid
12:18 gerundio       is this standard behavior?
12:27 kf             gerundio: of course
12:27 kf             gerundio: password fields are encrypted in the database for security reasons
12:28 vfernandes     kf: here is any perl method in any pm that check if the patron has any item of the record?
12:30 kf             I would think yes
12:31 kf             but I can't tell you which
12:31 kf             when you delete a patron such things are checked, maybe you can trace it from there
12:31 kf             hi drojf
12:31 drojf          hi #koha
12:31 drojf          hi kf :)
12:31 vfernandes     i need it for bug 9206
12:31 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9206 enhancement, P1 - high, ---, vfernandes, NEW , Only allow place holds in records that the patron don't have in his possession
12:35 drojf          has the account registration email problem with the wiki never been solved or is it back again?
12:38 vfernandes     kf the method I need doesn't seems to exist... where should I create it?
12:38 vfernandes     C4::Members or C4::Circulation?
12:58 kf             vfernandes: maybe ask jcamins_away
13:19 jcamins        vfernandes: what does the method need to do exactly?
13:33 koyauni        hi guys, my server has stopped working and the Apache web server is not responding, can you please tell me how I backup my library os at least have thatcoverd
13:35 jcamins        Use the koha-dump program.
13:36 jcamins        Hasn't this happened before at least once and possibly twice?
13:38 huginn         New commit(s) kohagit: Merge branch 'bug_8945' into 3.12-master <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5c52ab34d01471a6e8f88f22c8c53e2f91863bc2> / Bug 8945: Did you mean help file <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e22d26266844015586c6a8baf420be5a1cfb0234>
13:41 koyauni        Once yes :(
13:41 koyauni        in Oct
13:41 koyauni        this bloody Plesk is soooooooooo damn
13:42 koyauni        how do I access this koha dump please
13:42 jcamins        You run `koha-dump library` and copy the files out of /var/spool/koha/library.
13:42 jcamins        `man koha-dump` may be useful to you.
13:43 jcamins        There are also nightly backups stored in that directory if you haven't made any changes since last night.
13:45 jenkins_koha   Starting build #966 for job Koha_master (previous build: SUCCESS)
13:47 koyauni        root@koyauniversity ~ # koha-dump library -bash: koha-dump: command not found
13:47 jcamins        You will have to locate that command.
13:48 jcamins        Hey, didn't we go through this exact thing before when you uninstalled Koha by accident?
13:49 jcamins        Look in /var/spool/koha/library.
13:49 jcamins        If the backups are there, use those.
13:50 koyauni        no last time was exactly the same thing, bloody Plesk did auto update and wipped files so appache had isntuction to buidl them but coud not find them, so I installed Koha again and that solved issue
13:50 jcamins        logs?
13:50 wahanui        hmmm... logs is http://irc.koha-community.org/irclog/koha/
13:51 jcamins        ^^ if you look in there you should be able to find the instructions from when we did this last time.
13:52 koyauni        I see the back ups in spool and I did created one today by  mysqldump -u koha_library -p koha_library > myKohaLibrary.sql
13:53 jcamins        Good, that should be everything you need.
13:53 koyauni        and it has created that, I guess I have to reinstalll Koha now, Sorry would you please tell me where I find koha-dump
13:54 gerundio       kf, back from lunch
13:54 koyauni        so I can install that for next time
13:54 jcamins        It's part of the Koha package.
13:54 koyauni        so I just install it,
13:54 jcamins        Right.
13:54 koyauni        or it should already be on my system
13:54 gerundio       just saw your answer to my earlier question regarding the LDAP authentication method and a password being cyphered and stored in the DB
13:54 jcamins        This is, of course, a perfect example to why everyone told you not to use Plesk.
13:55 koyauni        I have not, this is server hosting pack we bough an dit was on it,
13:55 gerundio       thanks for the reply
13:56 koyauni        so we have many sites, and now all of them are not accessible, since Apache is not reposnding
13:56 gerundio       even though it's not clear to me why there's need to store the user pass on the DB when we're dealing with LDAP auth
13:57 jcamins        gerundio: there's a patch to disable that.
13:58 gerundio       now we're talking jcamins :)
13:58 gerundio       can you point me to it?
13:58 jcamins        gerundio: I can try.
13:58 magnuse        gerundio: bug 9165
13:58 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9165 enhancement, P4, ---, robin, Needs Signoff , Allow preventing passwords from being stored locally when using LDAP
13:58 jcamins        Bug 9165
13:58 jcamins        Oh.
13:58 jcamins        magnuse already said it.
13:59 jcamins        You should sign off. :)
14:09 libsysguy      heh
14:15 gerundio       jcamins, btw, any good reason to store the LDAP password in the BD?
14:15 jcamins        gerundio: maybe if your LDAP connection is iffy?
14:15 * jcamins      is grasping.
14:16 jcamins        libsysguy: any ideas?
14:16 wahanui        any ideas are welcome :)
14:16 koyauni        This installed Koha 3.10.00.000
14:16 libsysguy      BD?
14:16 jcamins        We have 139 bugs at "Needs Signoff"
14:16 jcamins        libsysguy: DB
14:17 libsysguy      oh, you mean users passwords from LDAP?
14:17 libsysguy      I actually think its a terrible idea to store it
14:17 koyauni        but my domain with extended :8080 works, do I have re run any configuration command please
14:18 jcamins        koyauni: not unless you set up something strangely.
14:19 gerundio       libsysguy, my thoughts too
14:19 jcamins        koyauni: as a note, this is going to happen again in exactly two months. You should learn to troubleshoot these problems, since you're going to have them every two months until you stop using the server.
14:20 koyauni        I just disabled any out installation in Plesk
14:21 gerundio       since it only gets stored after the 1st update (2nd login) I have a mix set of meaningful and stub password hashes stored in the DB
14:21 koyauni        well I had configured that library.koyauniversity.org be my main domain and now it is not accessable
14:21 gerundio       I think I'll just overide the meaningful ones with the stub one too
14:21 koyauni        I guess the rebuilding of that config has been lost as well
14:22 libsysguy      my issue was wiht password changes
14:22 jcamins        koyauni: perhaps you need to run `koha-upgrade-schema library`
14:22 gerundio       so when a user changed his password he could login with 2 different passwords?
14:23 libsysguy      for the first time
14:23 libsysguy      until it gets updated
14:23 gerundio       btw, the admin user doesn't have any record in the burrowers table, right?
14:23 gerundio       he just exists on the koha-conf.xml file, correct?
14:23 libsysguy      correct
14:23 jcamins        koyauni: however, I would like to point out again the benefits of reading the documentation and learning how the software works, if you intend to run Koha without paying anyone for support.
14:24 gerundio       so it's safe to preform a blind update on the burrowers table password field, right?
14:24 koyauni        even my main domain is not reachable http://koyauniversity.org/ but library.koyauniversity.org:8080 works
14:24 koyauni        do I need to run this maybe /usr/local/psa/admin/sbin/httpdmng --reconfigure-all
14:25 jcamins        No idea.
14:25 jcamins        You're using Plack.
14:25 jcamins        Seems probable.
14:25 jcamins        However, I can't offer any more help, sorry.
14:25 koyauni        you guys get paid via card, and we have no banking system in Iraq yet, all have been vanished with war, so people and bank does not work here
14:26 libsysguy      gerundio well as safe as possibly destroying passwords in the db
14:26 jcamins        That is unfortunate, but I do not like repeating myself.
14:28 koyauni        the /usr/local/psa/admin/sbin/httpdmng --reconfigure-all did it and now it is working
14:28 jcamins        I'm glad to hear that. Write down detailed notes, or save the chat logs, so that you can do this on February 2.
14:29 koyauni        sorry, I wish we could hire an admin, but we do not have any, and as someone want to bring new way to education in Uni I have to do it myself the hard way, really sorry to bother you guys,
14:30 jcamins        I am happy to answer questions. It's just when I am asked the same thing three times that I get annoyed. I'm sure you can understand why.
14:30 koyauni        at least we got latest Koha :)  does this has problem with ICU and Zebra for non latin as well ?
14:30 jcamins        Yes.
14:31 koyauni        I have now made a file of the instruction and I keep that for next time:)
14:31 jcamins        Good.
14:32 koyauni        do you have any instruction some where so I get this dump thing so I us eit regularly
14:32 jcamins        It is run automatically every night.
14:35 koyauni        do I need to set it up
14:35 jcamins        Nope.
14:35 jcamins        It's all automatic.
14:46 koyauni        you mean in this version this is a inbuild process
14:54 jenkins_koha   Project Koha_master build #966: SUCCESS in 1 hr 9 min: http://jenkins.koha-community.org/job/Koha_master/966/
14:54 jenkins_koha   nengard: Bug 8945: Did you mean help file
14:54 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8945 normal, P5 - low, ---, nengard, Pushed to Master , Koha 3.10 Help Files Update
15:29 drojf          nobody knows about the wiki confirmation email?
15:41 tcohen         libsysguy
15:41 wahanui        libsysguy is, like, Koha's hottest developer or partying with swedes on his deck or koha's youngest developer
15:41 libsysguy      si?
15:41 tcohen         he
15:42 tcohen         i've almost finished my Calendar.t rewrite, using DBD::Mock
15:42 libsysguy      sweet
15:42 tcohen         including what was on db_dependent/Holidays.t
15:42 libsysguy      I've been working on creating Circulation.t
15:43 tcohen         oh, you are a step ahead, that was my next step
15:43 tcohen         perfect
15:43 tcohen         i'm about to create a bug for the new Calendar.t
15:43 libsysguy      I may look at your work on calendar
15:44 tcohen         if u remember any test we could add, just tell me
15:44 libsysguy      oh there are a lot lol
15:44 libsysguy      so many tests, so little time
15:44 tcohen         another question
15:44 libsysguy      k
15:45 tcohen         or, the first one i was about to ask:
15:45 tcohen         what do u think of that code that exists just for testing like _mockinit, or add_holiday
15:45 tcohen         i vote for removal
15:45 libsysguy      hmm
15:45 libsysguy      I would personally agree
15:45 libsysguy      but you might want to ask the RM
15:45 tcohen         as it was used only on Calendar.t
15:46 jcamins        If it has no practical use outside of unit tests, I'd remove it.
15:46 tcohen         you mean jcamins?
15:46 libsysguy      yup
15:46 tcohen         exactly
15:46 libsysguy      RM jcamins
15:46 jcamins        However, if it would be useful for quickly populating data structures with baseline data, I'd keep it.
15:47 tcohen         Koha::Calendar reads what C4::Calendar put on the DB
15:47 tcohen         and puts it in its own data structures
15:47 tcohen         those methods are for volatile data
15:47 tcohen         and mocking makes them useless
15:52 tcohen         ok
15:53 tcohen         i'll leave Koha/Calendar.pm almost untouched for this bug
15:54 tcohen         and create a new one to discuss this removal
16:02 gerundio       sometime ago, while setting up my koha instance I changed the Default value of the "a" subfield on tag 100 in the mark framework
16:02 gerundio       I then imported a lot of records
16:02 gerundio       I was now told that those records have the default koha value for that subfield
16:03 gerundio       is there any way to update this for all the records in my catalog?
16:05 drojf          sql
16:05 drojf          but it is also a way to destroy everything in seconds, so take a backup ;)
16:05 wahanui        okay, drojf.
16:06 jcamins        No, SQL won't work.
16:06 drojf          it won't?
16:06 jcamins        Well...
16:07 jcamins        it'll change the field.
16:07 jcamins        It'll also corrupt all the records.
16:07 kf             but not the marcxml and marc...
16:07 jcamins        You'll need to write a script to do it.
16:07 jcamins        You can use touch_all_biblios.pl as a base.
16:08 drojf          ah sorry no, i was not paying enough attention and just remembered how i changed fields in all frameworks. which is something entirely different of course. sorry, ignore me, i'm tired and confused
16:08 gerundio       jcamins, is this a standard behavior or should the imported records reflect my change in the 1st place?
16:09 * drojf        goes to sit in a corner
16:09 jcamins        gerundio: if you set a default, it will be automatically filled in whenever anyone opens a record that doesn't have that field populated.
16:10 gerundio       I see that on new records
16:10 gerundio       I expected it to happen too on imported ones
16:11 reiveune       bye
16:11 jcamins        If you set the default value for the framework the imported records will use, it'll get automatically populated when someone opens up those records, too.
16:18 gerundio       jcamins, I'm looking at the Manage staged MARC records Batch
16:19 gerundio       and the 100 field value is showing the default Koha value
16:21 gerundio       a full catalog export, find and replace of the value of the field 100 on a MARC editor and full import could do the trick?
16:26 jcamins        Should do, yes.
16:26 gerundio       since this is still in pre-production environment maybe it's the best solution for this
16:27 gerundio       jcamins, thanks again, you're always a great help :)
16:27 jcamins        Depending how many records there are, it might be better to write a script, though.
16:28 gerundio       somewhat around 60k records so far
16:28 jcamins        Probably it would be faster to script it.
16:30 vfernandes     gerundio I've submitted a bug fix for that problem bug 8347
16:30 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8347 enhancement, P1 - high, ---, vfernandes, Needs Signoff , Koha forces UNIMARC 100 field code language to 'fre'
16:30 gerundio       hmmm, vfernandes nice
16:31 jcamins        gerundio: oh, if it's the bug that vfernandes reported, I think it is impossible to fix without his patch.
16:31 gerundio       because I was just about to say my colleague just told me that he edited one record and the value remained the same
16:31 gerundio       so probably it's that bug vfernandes mentioned
16:31 gerundio       I'm going to take a look
16:32 Joubu          goodbye
16:32 vfernandes     resolves two problems: the default language is fre when importing/editing biblio and the default value on the field 100 plugin is also fre...
16:32 vfernandes     in koha 3.8.X you can't edit UNIMARC field 100 language
16:33 vfernandes     if editing a record to change language to "por" it won't work
16:37 mib            i wish to get a multiple branch libraries data into koha through marc records import. when i run stage marc records i am getting only single library data but my mrc file contains multiple branches along with their accession numbers
16:37 mib            how to get all these libraries data into single koha installation where each branch has its own accession series
16:46 drojf          mib: have you set up the branches in koha and do branch codes in koha and your marc file match?
16:47 mib            branches are set up in koha
16:47 mib            when i stage records it says 33000 records are staged
16:47 mib            but after import it says 10000 records were not added due to duplicate barcodes
16:47 mib            but these duplicate barcodes are from each branches
16:48 mib            yes branch codes do match in koha and mrc file
16:48 jcamins        mib: you can't have duplicate barcodes at all, even if the items are at different branches.
16:49 mib            oh what could be the solution then
16:52 * chris_n      hates it when he knows more than the tech support at the service provider he is paying good money to >:(
16:52 chris_n        maybe I should be paying myself instead
16:53 rambutan       and I would add, they are making more money than I am by far...
16:53 jcamins        mib: unfortunately I don't think there's really a work-around to make barcodes unique.
16:53 libsysguy      mib you could delete all the barcodes but that isn't really a satisfactory solution
16:54 drojf          you could use instances instead of branches. but that is probably not what you want
16:54 libsysguy      that barcode thing is really a pita
16:54 mib            we want to have single installation with multiple branch data uploaded on single server
16:55 libsysguy      right, you can do that
16:55 libsysguy      you just can't have duplicate barcodes across those branches
16:56 jcamins        Did the barcode prefix stuff ever get into Koha?
16:56 jcamins        bag would know.
16:56 mib            i had one more problem if i attach one alphabet before numeric accession number when i run excel to marc in marcedit marcedit delete alphanumeric numbers from 952
16:57 bag            no it hasn't yet
16:57 jcamins        mib: where are the barcodes coming from?
16:57 mib            from excel sheet
16:58 mib            i am running marcedit to convert excel data
16:58 jcamins        Let me rephrase that: are there barcode labels on the books?
16:58 mib            no barcoding is actually not yet done
16:59 mib            only books are accessioned
16:59 jcamins        In that case, you should assign unique barcode ranges to each library.
17:00 mib            if i assign in excel sheet before each numeric number any alphabet say A1, B1, C1 will that be imported successfully
17:00 jcamins        That should work.
17:00 jcamins        It will work fine with Koha.
17:00 jcamins        I don't know anything about MarcEdit.
17:01 * drojf        heads home
17:01 mib            i dont knw any other tool to get data from excel to mrc format
17:01 jcamins        I presume it would work fine with MarcEdit.
17:01 mib            i have been only using marcedit but apparantly it was not taking alphanumeric numbers while coverting data
17:02 jcamins        There's a MarcEdit mailing list where you could ask for help with that particular step.
17:02 mib            ok
17:02 mib            i will do that
17:03 jcamins        However, if you're able to get the data converted by MarcEdit, Koha will handle it just fine. :)
17:03 mib            ok tx
17:14 libsysguy      anybody have thoughts on using a service like disqus or livefyre as koha's commenting system?
17:21 jcamins        libsysguy: none.
17:21 libsysguy      heh, it was just a thought
17:21 libsysguy      nothing too serious
17:22 * jcamins      has never even heard of those things.
17:22 libsysguy      they are pretty useful services imo
17:24 jcamins        But not open source?
17:24 libsysguy      heh no, it'd be the equivalent of the bookjacket stuff
17:25 jcamins        Oh, it doesn't require you to incorporate the code?
17:25 libsysguy      I don't think it'd be more than a library
17:30 cait           h i#koha
17:38 gerundio       trick question: is it normal to perform an advanced search for a given title and most of the records that show up in the result set don't even have that word in the title?
17:40 sophie_m       hi cait and #koha
17:40 sophie_m       cait I have written some comments on Bug 6030 on overdue notices
17:40 vfernandes     search on title search in different subfields
17:40 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6030 critical, P3, ---, stephane.delaune, Needs Signoff , Allow for html in letters in overdue notices
17:41 sophie_m       cait and have done some other patches linked to it that are waiting for signoff ;-)
17:41 vfernandes     gerundio: in UNIMARC search on title search in many 200 subfields
17:42 jcamins        gerundio: yes.
17:43 gerundio       I'm looking at the /etc/koha/zebradb/marc_defs/unimarc/biblios/record.abs file
17:43 vfernandes     it also search 4XX and 5XX fields
17:43 gerundio       and the indexes for the Title field show a lot of 200 subfields
17:44 cait           sophie_m: I will try to take alook , but have to work on something else tonight
17:44 gerundio       4xx and 5xx refer to Authoroties titles, right?
17:44 sophie_m       thank you cait. And if somone else want to test...
17:45 vfernandes     4xx are serial titles I think...
17:46 vfernandes     5xx are notes
17:48 cait           I think you are talking aobut different things
17:48 cait           bibliographic and authority records
17:48 jcamins        cait: UNIMARC... crazy, eh?
17:49 cait           ah and that too?
17:49 cait           yeah
18:07 libsysguy      @later tell cindy thanks for getting my retirement stuff cleared up
18:07 huginn         libsysguy: The operation succeeded.
18:08 cait           wrong chan?
18:08 libsysguy      oh yup
18:08 libsysguy      heh
18:08 libsysguy      just so everybody knows I have a 401k :p
18:08 cait           sounds like a good idea
18:20 tcohen         jcamins
18:21 kathryn        morning all, I thought I was late for the meeting!
18:21 tcohen         bug 8486 has been pushed, BUT
18:21 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8486 blocker, P5 - low, ---, colin.campbell, Pushed to Master , Critical error in Koha::Calendar::days_between calculation
18:21 tcohen         there's still an open bug noted in the comments
18:21 tcohen         i found it in my tests rewrite
18:22 tcohen         should I fill a new bug and leave that bug as is?
18:22 jcamins        Yes please.
18:22 vfernandes     there is any bug open with refine authors display problem? there is a extra comma
18:23 jcamins        vfernandes: that does not ring any bells for me.
18:24 vfernandes     on the refine search results there is a extra comma... in OPAC and Staff client
18:26 jcamins        I'd say file a bug.
18:26 vfernandes     ok :)
18:27 magnuse        the meeting is in 24 hours - 27 minutes, right?
18:28 jcamins        magnuse: sounds right.
18:28 magnuse        yay
18:29 kathryn        hehe thanks magnuse I've been doing my math! see yas later...whoever at Catalyst told me the meeting was the morning after the staff Christmas party is in trouble!
18:30 magnuse        go get 'em kathryn :-)
18:31 kathryn        :) magnuse I'll blame it on the new girl
18:32 kathryn        (not true)
18:33 * magnuse      isn't sure that is a good idea :-)
18:34 kathryn        it was probably a team effort ;)
18:35 kathryn        apart from everyone else worked out we were wrong!
18:35 kathryn        bye for now!
18:38 tcohen         jcamins, bug 9209 and bug 9211
18:38 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9209 normal, P5 - low, ---, tomascohen, Needs Signoff , Mocked Koha::Calendar tests
18:38 huginn         04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9211 normal, P5 - low, ---, tomascohen, Needs Signoff , days_between wrong behaviour
18:39 tcohen         the second is a tiny patch, the first the tests rewrite using DBD:Mock
18:40 tcohen         libsysguy, i attached the dbd:mock patches
18:40 libsysguy      i saw that
18:41 libsysguy      kudos tcohen++
18:44 magnuse        kia ora JDatTeTakere
18:44 cait           hi JDatTeTakere - in case you are here for the meeting -it's tomorrow :
18:44 cait           :)
18:45 JDatTeTakere   Morning...ahh...wrong day :-)
18:45 rangi          Morning
18:45 wahanui        hmmm... Morning is a state of mind. or whenever the cat wants breakfast.
18:45 cait           morning rangi
18:45 magnuse        has cait become psychic? ;-)
18:45 magnuse        morning rangi
18:46 JDatTeTakere   I had the meeting in my diary for 5 Dec.
18:46 cait           magnuse: who knows...
18:46 rangi          Yep it is,  but UTC time :)
18:46 rangi          We live in the future
18:47 drojf          look its those future people again ;)
18:47 drojf          heh
18:47 drojf          hi rangi
18:47 JDatTeTakere   Does that mean I can go back to bed?
18:47 cait           yep
18:47 cait           but hopefully you will be back tomorrow?:)
18:47 JDatTeTakere   I will #cait
18:48 JDatTeTakere   Drat...not so good at my IRC yet
18:50 tcohen         ok, libsysguy, let me know if i can help with more tests
18:50 tcohen         leaving right now
18:50 tcohen         bye #koha
18:51 libsysguy      later tcohen
19:03 gml            hello everyone.
19:03 gml            what's the treatment on non-ascii characters in borrowers.password? until now, I know it's not UTF-8 or ISO-8859-1
19:03 cait           gml: what are you triyng to do?
19:03 cait           first question?
19:03 wahanui        "What are you trying to do?" or "What is the goal?"
19:04 gml            authentication from third-party application using Koha DB
19:04 cait           you are aware that the password is encrypted in koha?
19:05 gml            I've succeeded with MD5 and base64,
19:05 cait           a better way to do things like that is using sip2
19:05 cait           for authentication
19:05 rangi          Or ilsdi
19:05 cait           yep
19:05 cait           using an interface, not accessing the database directly
19:05 gml            but results are not equal when I'm entering non-ascii characters in plaintext password
19:06 rangi          We will be changing the password hashing in the near future
19:07 rangi          Direct db access will then need to be redone, but any of the 3 api will still work
19:09 cait           LDAP and CAS are also things you could look at - depending on what exactly you want to do and integrate
19:10 cait           @wunder Konstanz
19:10 huginn         cait: The current temperature in Konstanz, Germany is 2.0°C (8:00 PM CET on December 04, 2012). Conditions: Light Rain. Humidity: 85%. Dew Point: 1.0°C. Pressure: 29.74 in 1007 hPa (Rising).
19:12 gml            thanks for the suggestions
19:12 rangi          @wunder nzwn
19:12 huginn         rangi: The current temperature in Wellington, New Zealand is 17.0°C (8:00 AM NZDT on December 05, 2012). Conditions: Mostly Cloudy. Humidity: 82%. Dew Point: 14.0°C. Pressure: 29.50 in 999 hPa (Steady).
19:13 cait           rangi: wish I could come and visit :)
19:13 rangi          :)
19:15 drojf          @wunder berlin, germany
19:15 huginn         drojf: The current temperature in Prenzlauer Berg, Berlin, Germany is 4.1°C (8:13 PM CET on December 04, 2012). Conditions: Mostly Cloudy. Humidity: 73%. Dew Point: -0.0°C. Windchill: -1.0°C. Pressure: 29.30 in 992 hPa (Steady).
19:16 druthb         @wunder 66046
19:17 magnuse        @wunder boo
19:17 huginn         druthb: The current temperature in Near Lawrence High School, Lawrence, Kansas is 17.0°C (1:14 PM CST on December 04, 2012). Conditions: Clear. Humidity: 16%. Dew Point: -9.0°C. Pressure: 30.27 in 1025 hPa (Falling).
19:17 huginn         magnuse: The current temperature in Bodo, Norway is -7.0°C (7:50 PM CET on December 04, 2012). Conditions: Clear. Humidity: 80%. Dew Point: -10.0°C. Windchill: -14.0°C. Pressure: 29.74 in 1007 hPa (Steady).
19:17 magnuse        jinx!
19:17 magnuse        @wunder geilo, norway
19:17 huginn         magnuse: The current temperature in Aal Skisenter bunnstasjon, Aal, Norway is -19.8°C (8:16 PM CET on December 04, 2012). Conditions: Scattered Clouds. Humidity: 60%. Dew Point: -26.0°C. Windchill: -20.0°C. Pressure: 29.44 in 997 hPa (Steady).
19:17 magnuse        @wunder kautokeino
19:17 druthb         brr!
19:17 huginn         magnuse: The current temperature in Kautokeino, Norway is -8.0°C (7:00 PM CET on December 04, 2012). Conditions: Partly Cloudy. Humidity: 85%. Dew Point: -10.0°C. Pressure: 29.73 in 1007 hPa (Rising).
19:18 * magnuse      goes to the canary isles in a week and a day... :-)
19:18 druthb         @wunder iqaluit
19:18 huginn         druthb: The current temperature in Iqaluit, Nunavut is -22.0°C (2:00 PM EST on December 04, 2012). Conditions: Mostly Cloudy. Humidity: 71%. Dew Point: -26.0°C. Windchill: -28.0°C. Pressure: 30.01 in 1016 hPa (Rising).
19:20 magnuse        windchill--
19:32 jcamins_away   rangi: I am confused about SAML support as well. I thought Koha didn't have it, but the newsletter the guy on the mailing list links to would seem to indicate that you've been using SAML for Koha authentication at Catalyst.
19:33 jcamins_away   Incidentally, windows--
19:34 rangi          jcamins_away: thats all on the moodle side
19:34 rangi          koha doesnt have it
19:34 jcamins_away   Ah. That explains it.
19:34 jcamins_away   Thanks.
19:34 rangi          no worries
19:34 * jcamins_away returns to being vaguely hopeful that he has some idea what's going on around him.
19:35 rangi          :)
19:35 libsysguy      every time I see the word catalyst I get a little excited then I realize that its where rangi works
19:35 rangi          heh
19:35 libsysguy      also, I can't have anything related to libraries and catalyst in my google searches
19:35 rangi          and eythian and wizzyrea too now :)
19:35 libsysguy      thanks...
19:35 libsysguy      :p
19:35 rangi          we had the name first .. cant help it if ppl want to copy :)
19:36 rangi          there's another company catalyst in teh US doing evergreen stuff now
19:36 rangi          how's that for confusing
19:36 libsysguy      yeah there is a lot of name copying now...boo
19:36 libsysguy      poor google
19:36 jcamins_away   If only there was something to disambiguate names.
19:37 jcamins_away   Something with authority.
19:37 jcamins_away   Maybe an electronic file.
19:37 rangi          that's crazy talk
19:38 rangi          that could only possibly work if we came up with our own character encryption to store it in
19:38 jcamins_away   lol
19:38 cait           tcohen++
19:44 magnuse        uris ftw!
19:47 rangi          uris?
19:48 magnuse        URIs
19:48 rangi          ahh :)
19:48 magnuse        as in linked data ;-)
19:48 * jcamins_away thought we were celebrating the author of Exodus and The Haj.
19:48 rangi          yup :)
19:49 magnuse        leon uris?
19:49 jcamins_away   Yes.
19:49 magnuse        not this time, at least
19:50 jcamins_away   Or, as I might say if there were some sort of file with authoritative information about names: Uris, Leon, 1924-2003. :)
19:50 cait           GND!
19:50 magnuse        http://dbpedia.org/resource/Leon_Uris
19:51 jcamins_away   cait: was that you gnashing your teeth? ;)
19:51 slc0274        I would like to ask a question but I am by no means an expert. We are experimenting with KOHA to see if we want to use it for our school library.  We have put all of our patrons in and I have imported my records.  However no holdings were imported.  Is there an easy way to import the holdings all at once?
19:52 jcamins_away   slc0274: it depends what format your holdings information is in.
19:52 jcamins_away   Usually it's easiest to import the holdings information with the bib records.
19:52 jcamins_away   Also, Koha is a name not an acronym. :)
19:52 slc0274        The file I imported was a CSV file that I exported from our current library system Winnebago Spectrum
19:53 slc0274        I exported everything at once records and holdings
19:53 jcamins_away   In that case you should import the holdings as item records. It's just a matter of mapping Spectrum holdings information into Koha holdings information.
19:53 jcamins_away   @marc 952
19:53 wahanui        The 952 field is used by Koha to store item data in MARC21 and is described at http://wiki.koha-community.org/wiki/Holdings_data_fields_%289xx%29
19:53 huginn         jcamins_away: unknown tag 952
19:54 jcamins_away   That page on the wiki lists which subfields are used for what piece of information.
19:54 slc0274        so if it didn't automatically do it something is not right on the file I imported
19:55 slc0274        or not matching
19:55 cait           slc0274: which version of koha are you using?
19:56 slc0274        3.8
19:56 jcamins_away   Well, Koha doesn't understand Winnebago's format at all, so it's not that there was an error with the file so much as the file didn't have the information in the places it needed to go.
19:56 jcamins_away   How did you convert your records to MARC?
19:56 slc0274        actually I was wrong it was a MARC file not a CSV file
19:56 slc0274        the patrons were a CSV file
19:59 jcamins_away   Right, so you'll need to convert the holdings information that you got out of Winnebago Spectrum into Koha item reccords.
20:00 slc0274        Is there somewhere I can go to find out more about exactly how to do that?
20:00 slc0274        I have looked and looked
20:00 jcamins_away   Probably Spectrum stuck the information somewhere in the 8xx or 9xx range, and you just have to move it.
20:00 jcamins_away   You have two options for that sort of thing: MarcEdit, which has a graphical user interface, and command-line scripts.
20:00 jcamins_away   migration toolbox?
20:00 wahanui        i guess migration toolbox is https://www.gitorious.org/koha-toolbox/
20:00 cait           @marc 952
20:00 wahanui        The 952 field is used by Koha to store item data in MARC21 and is described at http://wiki.koha-community.org/wiki/Holdings_data_fields_%289xx%29
20:00 huginn         cait: unknown tag 952
20:00 jcamins_away   ^^ that's where you would find the best command-line scripts.
20:01 jcamins_away   At the migration toolbox link, not the holdings data link, which is of course where you find information about how Koha stores holdings data. :)
20:02 slc0274        Ok thank you for the information.  I will get with my tech people and see if we can get this working.  I appreciate the help.
20:04 tweetbot`      [off] twitter: @ranginui: "@tararobertson @mbreeding it's the same with #kohails it's a tricky one to solve, 61 across 11 vendors (not counting the 15 sporks)"
20:04 rangi          i crack myself up
20:04 jcamins_away   lol
20:05 jcamins_away   What are you discussing? Evergreen's representation in the database?
20:06 rangi          evergreen and koha .. in the turnover report, how its hard to see as its spread over multiple vendor
20:06 rangi          s
20:06 jcamins_away   Ah.
20:06 jcamins_away   Has he released a new dataset?
20:06 rangi          its pretty much realtime .. he's just been tweeting it
20:06 rangi          http://www.librarytechnology.org/ils-turnover.pl?Year=2012
20:07 rangi          as its getting to the end of the year
20:07 jcamins_away   Cool, I didn't know that.
20:07 rangi          http://www.librarytechnology.org/ils-turnover-reverse.pl?Year=2012
20:08 cait           evergren has some nice numbers
20:09 rangi          yeah they had a big year this year
20:09 rangi          koha had a big one last year
20:09 rangi          and will again next year
20:09 rangi          :)
20:15 rangi          not touching that email
20:15 tcohen         bye #koha
20:17 cait           me neither
20:22 * jcamins_away either.
20:22 jcamins_away   I thought about it, but decided against it.
20:23 rangi          yeah
20:24 jcamins_away   I see no benefit to be gained from "unfortunately the license prohibits that."
20:25 cait           hm
20:26 cait           talking about things we could do.... what about senidng our 3.10 announcement to marshall breeding?
20:26 * cait         wanders off
20:26 jcamins_away   cait: nengard volunteered to do that.
20:26 cait           ah good!
20:26 jcamins_away   I'm not sure if she has yet. I don't really follow librarytechnology.org.
20:27 cait           I think it wuld have showed up on twitter
20:27 cait           brb
20:28 * chris_n      either
20:32 drojf          jcamins_away: you know what i am going to say
20:32 * jcamins_away does.
20:32 drojf          we should include google MAPS also!
20:33 jcamins_away   Oh.
20:33 jcamins_away   I thought you were going to say "he should ask that on a Google group."
20:33 drojf          ha1 a twist :D
20:33 drojf          ha! even
20:34 drojf          nobody expects the google inquisition
20:37 cait           lol
20:39 rambutan       I hadn't been aware until now that NH had such an apparently large <independent?> Koha dev effort.  (Trying to use enough vague qualifiers in my statement)
20:39 wizzyrea       rambutan: they are waldo, the people who spawned LLEK
20:40 rambutan       yea. Apparently they are sill on LLEK?
20:40 wizzyrea       yep.
20:40 wizzyrea       also they apparently want to be apple.
20:40 rambutan       things that make you go "hummm"
20:40 jcamins_away   wizzyrea: in NH? I always thought WALDO was based in Westchester.
20:40 wizzyrea       waldo is huuuge
20:41 wizzyrea       many institutions
20:41 jcamins_away   (hence the "Westchester" in the name
20:41 wizzyrea       NH is just one
20:41 jcamins_away   )
20:41 jcamins_away   Ohh.
20:41 jcamins_away   Right.
20:41 jcamins_away   I thought you were talking about the state.
20:41 wizzyrea       nah
20:42 cait           wizzyrea: apple?
20:42 wizzyrea       that site from the email
20:42 wizzyrea       it looks like an apple website
20:42 cait           oh ok
20:42 wizzyrea       using apple fonts etc.
20:42 rambutan       I'm guessing this organization is probably a main life-support contributor for LLEK? Sine qua non?
20:44 cait           they put a lot of money towards it I think
20:45 * jcamins_away had an intern who worked in the library there.
20:46 cait           and?
20:46 wahanui        and is that patch only for "$" or for "$ CAD" ?
20:48 jcamins_away   She was very pleasant.
20:48 jcamins_away   A hard worker, though much less experienced than my other interns.
20:49 rambutan       per ibrarytechnology stats: EG took a big a* bite out of Millennium last year.
20:49 jcamins_away   rambutan: I noticed that. I figure it must've been a consortium.
20:49 cait           jcamins_away: oh, I wondered if she said somehting about both ILS in comparison :)
20:50 jcamins_away   Not really.
20:50 mveron         hi #koha
20:50 drojf          hi mveron
20:50 cait           hi mveron
20:50 rambutan       same for Polaris taking market share from Unicorn/Dynix/Horizon
20:51 mveron         hi drojf, how was your Koha party?
20:51 mveron         and hi cait
20:52 drojf          mveron: good! about 12 kohas installed. everybody that stayed managed to install. two librarians run off after half an hour though :/
20:52 jcamins_away   mveron: I was talking about getting a food sealer the other day. I thought about you. :)
20:52 drojf          s/run/ran
20:52 jcamins_away   We're not going to, I was just talking about it.
20:53 mveron         jcamins_away: for the dishwasher?  great!
20:53 jcamins_away   mveron: yeah, the vacuum packer machines. :)
20:53 mveron         I did not yet try with the vacuum - but i plan to do so with some veal.
20:54 mveron         Swiss media about Open Source: www.netzwoche.ch/de-CH/News/2012/12/04  (in German)
20:54 cait           hm site not found :(
20:55 mveron         Sorry, try this:
20:55 mveron         http://www.netzwoche.ch/de-CH/News/2012/12/04/Das-Open-Source-Prinzip-Kooperieren-und-teilen-statt-Geheimniskraemerei-betreiben.aspx
20:55 drojf          http://www.netzwoche.ch/de-CH/News/2012/12/04/Das-Open-Source-Prinzip-Kooperieren-und-teilen-statt-Geheimniskraemerei-betreiben.aspx
20:55 mveron         drojf +
20:57 rangi          can i get a paraphrase?
20:58 cait           hmmmm
20:58 cait           I am going to try and embarass myself
20:58 cait           the open source principle
20:58 cait           cooperation and sharing instead of secretiveness
20:59 cait           that's the headline anyway
20:59 rambutan       translate.google.com  -- even preserves the page formatting
21:00 cait           the article is long
21:01 rambutan       rangi: I have my tech installing deb on a Sun Fire V240 for a test run. It was happily running Solaris, but thought you might prefer deb or something.
21:01 rambutan       Still haven't asked for permission though. :)
21:01 rangi          rambutan: deb would make my life easier yes :)
21:01 rambutan       oh, you'd love Solaris!
21:02 rangi          open solaris, if it still existed maybe :-)
22:43 eythian        hi
22:48 rambutan       hi eythian
23:01 drojf          meh. 'i should install limesurvey to let people evaluate my workshop … let's see how to install it … cool, it works on my webspace … that wasn't complicated at all, what now … oh no, i'm too lazy to think about questions, maybe i find another survey tool to install …'