IRC log for #koha, 2012-12-04

All times shown according to UTC.

Time S 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[…]mages/roflmao.gif
00:13 rambutan left #koha
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:25 maximep left #koha
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 Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7001 enhancement, P3, ---, srdjan, Pushed to Master , User Configurable Slips
01:04 libsysguy joined #koha
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:41 libsysguy joined #koha
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:03 trea left #koha
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[…]-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:09 libsysguy joined #koha
04:55 vkm joined #koha
04:58 vkm hello all, may i know is it necessary to keep accession series separate while managing multiple library
05:09 thd-away` joined #koha
05:12 cait joined #koha
05:16 cait hi #koha
05:18 chris_n joined #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 clrh joined #koha
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 Bug http://bugs.koha-community.org[…]w_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
06:33 bg joined #koha
06:47 laurence joined #koha
07:18 * magnuse waves
07:23 * cait waves back
07:24 magnuse yay! :-)
07:39 julian_m joined #koha
07:47 reiveune joined #koha
07:48 reiveune hello
07:48 wahanui what's up, reiveune
07:51 alex_a bonjour
08:00 lds joined #koha
08:01 Joubu joined #koha
08:01 Joubu hello #koha
08:07 asaurat joined #koha
08:23 clrh hello clrh
08:23 clrh hello Caitttt :)
08:23 sophie_m joined #koha
08:24 asaurat left #koha
08:26 alex_a hello clrh !!
08:26 alex_a :)
08:26 alex_a and cait :)
08:26 gaetan_B joined #koha
08:32 kf joined #koha
08:47 lds joined #koha
08:47 asaurat joined #koha
08:47 kf hi #koha
09:11 gerundio joined #koha
10:10 vfernandes joined #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:07 thd-away joined #koha
11:11 vfernandes there is any perl method in any pm that check if the patron has any item of the record?
11:19 tcohen joined #koha
11:21 tcohen_ joined #koha
11:34 tcohen__ joined #koha
11:35 tcohen__ morning #koha
11:35 vfernandes good morning tcohen
11:53 lds1 joined #koha
12:14 talljoy joined #koha
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 asaurat joined #koha
12:30 kf I would think yes
12:31 kf but I can't tell you which
12:31 drojf joined #koha
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 Bug http://bugs.koha-community.org[…]w_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:36 lds joined #koha
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:40 jwagner joined #koha
12:52 talljoy1 joined #koha
12:52 NateC joined #koha
12:55 talljoy2 joined #koha
12:58 kf vfernandes: maybe ask jcamins_away
13:01 talljoy joined #koha
13:09 asaurat joined #koha
13:19 jcamins vfernandes: what does the method need to do exactly?
13:31 koyauni joined #koha
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/[…]2c8c53e2f91863bc2> / Bug 8945: Did you mean help file <http://git.koha-community.org/[…]af420be5a1cfb0234>
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:44 libsysguy joined #koha
13:44 edveal joined #koha
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 Bug http://bugs.koha-community.org[…]w_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:08 logbot joined #koha
14:08 Topic for #koha is now Welcome to #koha this channel is for discussion of the Koha project and software http://koha-community.org The next general meeting is 5 December 2012 18:00 UTC
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 oleonard joined #koha
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:47 fredy joined #koha
14:49 ericar joined #koha
14:51 maximep joined #koha
14:54 jenkins_koha Project Koha_master build #966: SUCCESS in 1 hr 9 min: http://jenkins.koha-community.[…]/Koha_master/966/
14:54 jenkins_koha nengard: Bug 8945: Did you mean help file
14:54 huginn Bug http://bugs.koha-community.org[…]w_bug.cgi?id=8945 normal, P5 - low, ---, nengard, Pushed to Master , Koha 3.10 Help Files Update
15:02 francharb joined #koha
15:24 tcohen joined #koha
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 asaurat joined #koha
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 rambutan joined #koha
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 reiveune left #koha
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:16 asaurat left #koha
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 Bug http://bugs.koha-community.org[…]w_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 Joubu left #koha
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:36 mib joined #koha
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:42 mib joined #koha
16:44 kf left #koha
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 juan-sieira joined #koha
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.
16:59 sekjal joined #koha
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 sekjal left #koha
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:08 thd-away` joined #koha
17:11 melia joined #koha
17:14 libsysguy anybody have thoughts on using a service like disqus or livefyre as koha's commenting system?
17:18 blinc joined #koha
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:29 cait joined #koha
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 Bug http://bugs.koha-community.org[…]w_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 tcohen joined #koha
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:01 drojf joined #koha
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:14 kathryn joined #koha
18:17 kathryn joined #koha
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 Bug http://bugs.koha-community.org[…]w_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 Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9209 normal, P5 - low, ---, tomascohen, Needs Signoff , Mocked Koha::Calendar tests
18:38 huginn Bug http://bugs.koha-community.org[…]w_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 davidnind joined #koha
18:40 libsysguy i saw that
18:41 libsysguy kudos tcohen++
18:41 davidnind left #koha
18:42 JDatTeTakere joined #koha
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:01 gml joined #koha
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:22 rambutan joined #koha
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 tcohen joined #koha
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 slc0274 joined #koha
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[…]_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[…]_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 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.o[…]over.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.o[…]erse.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:18 kathryn joined #koha
20:18 hankbank joined #koha
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 mveron joined #koha
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/[…]ei-betreiben.aspx
20:55 drojf http://www.netzwoche.ch/de-CH/[…]ei-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 :-)
21:35 cait left #koha
21:47 rambutan joined #koha
22:12 laurence left #koha
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 …'
23:07 thd-away joined #koha
23:08 edveal left #koha
23:26 maximep left #koha

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