IRC log for #koha, 2008-02-22

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
11:24 Fallor hello paul
12:16 gmcharlt Fallor: to answer your question, for 3.0 you could do a SQL 'delete from import_batches' to delete everything; for 2.2.9 you could 'delete from marc_breeding'
12:16 I'm not aware of a way to do it from the staff interface
13:20 paul 'morning gmcharlt & nengard
13:20 gmcharlt hi paul
13:21 nengard morning
13:27 owen Hello #koha
13:27 paul hello owen
13:35 nengard Hi owen
13:39 paul does anyone around know what is the "items.enumchron" column done for? (added by mason yesterday)
14:00 gmcharlt paul: volume and chronology statements for an item, e.g., vol. 1 (1990)
14:01 paul is there a link with the serials module ?
14:02 gmcharlt not yet (the immediate reason for adding the field is to support a migration from a Voyager database), but would be logically to integrate that field with serials
14:03 paul thx
14:07 owen paul, is tools/inventory.pl something your libraries use?
14:07 paul yep
14:07 owen I have a couple of questions for you, then
14:08 first, would it make sense to you to hide the form after you've submitted a search? I was thinking it made sense to give the whole page to the search results instead of redisplaying the form each time
14:09 kados_ g'morning all
14:09 owen Hi kados_
14:09 kados_ paul: did you have some OAI patches you want in the beta?
14:09 gmcharlt hi kados_
14:10 paul (on phone, sorry)
14:10 kados scheduled ones anyway :-)
14:10 gmcharlt: got a sec?
14:11 gmcharlt kados: sure -- I can call you if you want a phone call before 1 pm ;-)
14:11 kados hehe
14:11 so ... I was playing around with the installer yesterday, particilarly the web portion, and installing with other languages
14:12 so starting in the misc/translator dir I did:
14:12 mkdir ../../koha-tmpl/intranet-tmpl/prog/de-DE
14:12 ./tmpl_process3.pl install -i ../../koha-tmpl/intranet-tmpl/prog/en/ -o ../../koha-tmpl/intranet-tmpl/prog/de-DE/ -s po/de-DE-i-staf
14:12 f-t-prog-v-3000000.po -r
14:12 oops, that didn't paste in quite right
14:12 mkdir ../../koha-tmpl/intranet-tmpl/prog/de-DE
14:12 ./tmpl_process3.pl install -i ../../koha-tmpl/intranet-tmpl/prog/en/ -o ../../koha-tmpl/intranet-tmpl/prog/de-DE/ -s po/de-DE-i-staff-t-prog-v-3000000.po -r
14:12 so that will install the German staff templates
14:12 gmcharlt with you so far
14:13 kados when I installed from German, after the install completed, mainpage.pl failed witht he following:
14:13 Can't call method "delete" on an undefined value at /home/jmf/koha/lib/C4/Auth.pm line 499.
14:13 something wonked up about the session handling I think
14:15 gmcharlt yeah -- does it then work OK if you go to the main page directly (i.e., not following the link you get from the installer?)
14:15 kados no
14:19 paul: you around?
14:19 paul (still on phone)
14:19 kados k
14:23 paul back
14:24 kados : about OAI patches. There is a problem in encoding, that Ecole des mines want to solve, so that will be for later.
14:25 kados paul: later as in next week? or two months?
14:25 paul next week I think
14:25 kados OK
14:25 paul (quickly I mean)
14:26 about installer : maybe you're facing the problem I had and resulted in the patch including yaml that you've reverted.
14:26 not sure, but it remind me something
14:28 kados ahh, interesting
14:28 it looked like a good patch, but it broke stuff and I didn't have time to figure out why :-)
14:43 gmcharlt kados: re installing in de-DE: no MARC flavour is currently defined -- did you just skip that when you did the install?
14:43 kados hmmm
14:43 I guess so!
14:43 gmcharlt anyway, I've now been able to reproduce the problem
14:45 paul mmm... the problem that resulted in the reversed patch was in InstallerAuth.pm, not in Auth.pm so maybe your problem is not related to that.
14:45 another idea : do you have mysql or /tmp as session storage ?
14:45 gmcharlt mysql
14:47 paul kados : when do you plan to release the beta (pascale nalon is working on french translation to tune & complete some strings)
14:50 kados paul: well, we're getting closer, have to resolve this install prob, and I have some aditional testing to do
14:50 gmcharlt kados: here's what I found so far
14:51 kados paul: when can Pascale submit improvements to french translation?
14:51 gmcharlt de-DE has no marcflavour and no default data to load
14:51 in particular, it has no sysprefs
14:51 since there's no SessionStorage syspref, it defaults to file
14:51 kados gmcharlt: ahh, right ... we overlooked that I guess
14:51 gmcharlt it tries to read from the session file created during install
14:51 but can't read it (so paul's YAML patch is relevant)
14:51 kados which I assume has been deleted
14:52 gmcharlt I will see if deleting the session before handing over to mainpage at least avoids the carp
14:53 but I think for translations that do not have MARC frameworks and sample data
14:53 we either need to default to 'en'
14:53 paul gmcharlt: ++
14:53 gmcharlt or at the very least, load the en sysprefs
15:00 paul the french translation team faces problems to translate "matchpoint"... we can't find a french term...
15:01 kados gmcharlt: I agree
15:02 paul could english-speaking ppl give me some synonyms for "matchpoints" in the Koha context ?
15:03 kados well, matchpoints could also be 'match points'
15:03 gmcharlt paul: so when a French library is loading a batch of records, and during the load wants to deduplicate the incoming records against the already loaded records on (say) ISBN or national bibliography number, what do the call the concept of using the ISBN or standard number index
15:03 for that matching?
15:04 paul: 'match index' ? 'mathcing index'? 'deduplication index'?
15:14 atz perhaps "match criteria"?
15:14 (no semantic overlap with tennis)
15:15 kados hehe
15:16 gmcharlt atz++
15:46 fbcit hi koha
15:48 kados hey fbcit
15:51 paul: re: OAI ... do you have some specs for that feature yet?
15:52 paul kados: what kind of specs do you expect ? the script just makes Koha OAI harvestable.
15:53 (not sure it's correct english...)
15:53 kados it's correct
15:53 atz correct english is overrated  :)
15:53 kados paul: a full implementation of OAI?
15:56 paul the following methods are implemented (POD doc) :
15:56 =item B<new>: initialization step,
15:56 =item B<dispose>: clean up step,
15:56 =item B<Archive_ListSets>: return list of defined sets,
15:56 =item B<Archive_GetRecord>: return a record,
15:56 =item B<Archive_ListRecords>: return a list of records,
15:56 =item B<Archive_ListIdentifiers>: return a list of record identifiers,
15:57 kados paul: can you add this to the wiki?
15:57 paul which page ?
15:57 kados sec
15:59 paul: http://wiki.koha.org/doku.php?[…]opment:qanotes3.0
16:00 paul: under the APIs section for now
16:00 paul: add OAI link please
16:00 and I'll make sure to add it to the release notes
16:08 paul kados : done
16:09 kados paul++
16:09 gmcharlt paul, kados: I'm going to signoff on Paul's YAML patch, make another patch to correct an issue with it, then submit set of install patches
16:09 kados gmcharlt: sounds good
16:10 gmcharlt: might want to CC me directly at rm@koha.org for the install ones so I can push them up unmediated and continue RM testing
16:10 gmcharlt ok
16:15 fbcit heh
16:16 gmcharlt fbcit++
16:17 kados fbcit: wow, that's awesome
16:17 fbcit question for owen, atz, and anyone else interested...
16:17 should we restrict image types to jpeg only?
16:17 or allow other formats?
16:17 paul nope, we should also allow png imho
16:17 atz png and probably gif even
16:17 owen And we're just talking about patron images, right?
16:18 fbcit right now, yes
16:19 atz this would simplify the "small logo" kind of stuff in sysprefs too
16:19 fbcit also the restriction on pixel dimensions may become important as images can get pretty big
16:19 kados: what is the largest number of patrons currently served on a Koha install?
16:19 or anyone else who knows
16:20 paul SANOP is something like 20 000 patrons.
16:20 (active)
16:20 atz that physics institute had tens of thousands, at least
16:21 owen NPL has 53500 total
16:21 atz your backup gets to be a serious pain in the ass
16:21 owen ...but we'll probably never use the feature
16:21 fbcit atz: actually, you have to backup the data one way or the other, but I can see your point.
16:22 kados fbcit: I suspect only the small libraries will store images
16:22 paul yep, I suspect too
16:22 fbcit I am hoping to add the ability to print patron cards from inside koha and would like to have photo on them
16:22 atz i didn't backup pix when I ran k-12 servers (the most reliable users of patron photos)
16:22 paul unless we let the user upload a picture itself from OPAC.
16:23 atz mainly because I received all the images on disc media
16:23 fbcit paul: I had thought of that too.
16:23 atz so the original is the backup
16:24 fbcit paul: the only problem I see there is image restrictions such as pixel dimensions.
16:24 kados: it would still be wise IMO to benchmark against a large number of records *just-in-case*
16:26 ok, I'll simply refactor the current patronimage functionality to store images in the db and other changes/improvements can be made from there
16:27 atz does YUI have any image upload tools?
16:27 fbcit I'll also allow for png, gif, and jpeg
16:27 I'm not sure
16:28 pianohacker Supposing I wanted to submit the necessary patches for my smart rules and issuing specificity ideas, how would I go about doing that?
16:28 kados pianohacker: hiya
16:28 pianohacker: are you working on the 3.0 codebase?
16:29 pianohacker Yes
16:30 I'll probably backport any patches to my workplace's 2.2.9 install, but yes
16:30 kados sweet, so submitting patches is a snap
16:30 here's a guide:
16:30 http://wiki.koha.org/doku.php?[…]lopment:git_usage
16:30 pianohacker kados: Ahh, thanks
16:30 kados and if you have questions after reading that shout out, we're all here to help :-)
16:31 gmcharlt pianohacker: I'm glad that you're working on 3.0 -- there's a lot of interest in the smart rules desgin
16:31 pianohacker Well, cool
16:31 kados smart_rules_design++
16:31 gmcharlt: pushed up the patches you sent
16:32 pianohacker For some godforsaken reason, our library has roughly 30 itemtypes, so a replacement for the 256 cell matrix came about by necessity
16:33 qiqo hi may i know who's incharge of the windows releases?
16:33 i couldnt see 2.2.9 anymore
16:36 kados qiqo: I believe fbcit is working on a windows installer that's native to koha 3
16:36 pianohacker: *nod*
16:37 fbcit qiqo: still aways to go on Koha 3 on win32
16:38 qiqo: I'm not familiar with the 2.2.9 win32 release
16:38 qiqo: but see http://www.koha.rwjr.com/
16:39 paul kados : i've an updated french translation. Should I send it directly to rm@koha.org or patches@koha.org ?
16:39 kados paul: send through patches
16:39 fbcit atz: YUI does have an uploader, but it's marked experimental currently.
16:39 paul done
16:40 qiqoqo when i create an adobe file, all that i can see in that file are the barcodes
16:41 no spinelabels and titles even i set the parameters correctly
16:41 fbcit atz:http://developer.yahoo.com/yui/uploader/
16:42 qiqoqo: is this on win32?
16:42 qiqoqo yup
16:43 fbcit I'm not sure there, sorry.
16:43 qiqoqo no problem
16:43 fbcit qiqoqo: there is a win32 list
16:43 qiqoqo: see http://lists.nongnu.org/mailma[…]stinfo/koha-win32
16:43 qiqoqo but i suspect that it's the items and biblioitems tables which is causing the problem
16:43 yeah im on with that list actually
16:45 ive searched the mailing list.. no luck
16:45 atz fbcit: interesting... flash player upload control
16:45 pianohacker I can see why they did; input type
16:46 =file is somewhat crippled
16:46 atz yeah, being able to set a bigger SEND buffer is pretty cool too
16:46 fbcit atz: maybe I'll give it a closer look once I'm done with the other mods
16:47 qiqoqo i just want to ask,, i saw that my itemnumber column in my items table does not have anything,. so you think that's the problem?
16:47 atz isn't itemnumber the primary index?
16:48 that would be a problem.
16:48 kados yep
16:48 fbcit bbiab
16:54 qiqoqo hmm
16:59 sorry it was itemcallnumber
16:59 it's blank
17:00 nul
17:01 pianohacker qiqoqo: I can't see that being a huge problem
17:01 How about biblioitems.itemtype?
17:02 qiqoqo biblioitems.itemtype is populated
17:13 ohh gosh..
17:18 hmm..
17:18 it really seems that it does not connect to biblioitems
17:20 paul to anyone having a git setup : is tools/hotlidays working for you ?
17:21 it's no more working for me (when I click on a day, the "Library" field is empty)
17:22 owen: " first, would it make sense to you to hide the form after you've submitted a search? I was thinking it made sense to give the whole page to the search results instead of redisplaying the form each time" ?
17:22 :
17:22 yes, it could be OK for me (if you have the breadcrumb)
17:23 pls if you're working on inventory, also try to understand why the printing display only 1st page (and thus only a small part of the list)
17:25 strange : it seems holidays.pl works fine with opera, but not with firefox
17:27 gmcharlt paul: I think I touched tools/holidays.pl last -- I'll take a lok
17:27 look
17:28 paul thx
17:32 gmcharlt paul: seems OK to me -- when I click on a day, I see the branch code in the 'library' field (although I suppose as an enhancment it ought to display the name, not hte code)
17:32 paul are your superlibrarian ?
17:33 kados shouldn't it also have a 'default holidays' for all libraries?
17:33 paul kados : an other idea would be to be able to copy holidays from one branch to another
17:34 gmcharlt paul: yes
17:35 paul could you try without being (as i'm not)
17:35 note also that it works with Opera, so it's a dirty problem i'm afraid
17:36 kados paul: in the french translation, staff client, do you have 'Set' properly wrapped by two parentheses (Set) ?
17:36 paul: I'm just noticing that the german translation is missing the )
17:36 paul yes i do
17:36 (Définir)
17:36 kados strange
17:37 paul gmcharlt: when i'm superlibrarian, it works fine as well
17:37 kados I'm also seeing a few stray strings like the occassional \t
17:39 gmcharlt paul: still works as a non-superlibrarian user
17:40 paul :-(
17:40 gmcharlt paul: are you using the French templates -- might be a small XHTML error that's cropping in during tmpl_process or something
17:40 paul nope, I did the test in english
17:41 (I always work in english when testing, as I already have discovered that translation ADD problems ;-) )
17:57 time to leave for me. i'm in paris tomorrow, see you on monday (for a complete week at the office !!!!)
17:58 kados cya paul
17:58 paul (oups, no i've a meeting on thursday ;-) )
17:58 paul_away kados & all liblimer : have a good week at code4lib.
17:58 atz thx
17:58 paul_away "veinards" ;-)
18:12 atz there appears to be a ton of overdues related detritus in the codebase still
18:17 pianohacker I'm going to try to submit a template for the default set along with smart-rules; is there any style guide for that?
18:25 gmcharlt pianohacker: I can e-mail you the template I made when I updated your 2.2 template to 3.0 for my testing -- that should give you an idea
18:27 pianohac1er: (since it looks like you may have dropped out for a moment) I can e-mail you the template I made when I updated your 2.2 template to 3.0 for my testing -- that should give you an idea
18:27 pianohac1er Woops, wrong button
18:28 gmcharlt: Ahh, thank you
18:29 gmcharlt pianohac1er: email sent
18:40 qiqoqo it really seems that it does not connect to biblioitems
18:43 pianohacker Hmm. Only connection I can see is items.biblioitemnumber
18:43 Is _that_ filled?
19:11 qiqoqo yup
19:11 it is
19:13 so which perl script does the job of forwarding data to the label-print-pdf
19:14 almost going crazy
19:23 kados hey tim
19:28 qiqoqo oh gosh,, going crazy over this
19:28 tim Hey kados
19:39 atz warn (length($var) > 100 ? "\$var is too big to display" : $var);    # cheap workaround
20:29 kados atz: got a sec to brainstorm?
20:29 atz ok
20:29 kados atz: I'm trying to overcome the problem where zebraqueue wails on C4::Context-dbh before the db is created
20:29 my thinking was an internal sub in zebraqueue_daemin.pl
20:29 that manages the dbh ...
20:30 ie, when it's invalid, it sleeps 20 seconds and tries agin or something
20:30 atz i haven't looked inside zebraqueue much at all
20:32 probably should just do   my $dbh = C4::Context->dbh or sleep/warn /whatever
20:33 kados that would work once
20:33 atz my $sth = $dbh->prepare ("blahblah")   or  sleep/warn/whatever
20:33 kados woudln't it also throw an error with my ?
20:34 if that variable is used later?
20:34 atz it should declare the variable somewhere, if it uses it
20:35 it doesn't matter (to me) what scope it does the declaration in.  the Context call failing is the important thing to catch.
20:35 kados zebraqueue is a deamon, so it's persistant
20:35 we don't want it dieing
20:36 atz i didn't say die anywhere
20:36 kados well, if I go:
20:36 my $dbh = C4::Context->dbh or sleep 3;
20:36 $dbh->prepare(something)
20:36 that will kill the script if  C4::Context->dbh doesn't evaluate as true
20:36 atz you would need to kick out to redo the loop
20:37 kados because $dbh woudln't exist
20:37 atz right, see above
20:37 kados what loop?
20:37 I think that's just it, we need a loop
20:37 atz whatever block
20:37 kados every time there's a dbh call
20:37 so I'm thinking maybe an internal function for managing all dbhes?
20:38 does that make sense?
20:38 but then I begin wondering if that should, in fact be handled by ->dbh :-)
20:38 atz you can do      unless ($dbh = C4::Context->dbh )   { sleep 30;  warn "hey!~"; &some_log_function();}
20:39 there are many references to dbh, but only 1 connection
20:39 (per session)
20:39 so there is nothing to manage any further, as far as that goes
20:40 you might do something like C4::Daemon
20:40 and add the loopified, conditionally sleepy dbh stuff there
20:41 but I don't think it's much worth it, just for this
20:42 kados the alternative is 34,000 lines in your error logs every hour :-)
20:42 atz any problem w/ the unless version?
20:42 kados so that version still needs a loop
20:43 because what happens is after 30 seconds it logs the error and proceeds normally
20:43 what I think we need, is to capture the dbh call and make it sleepy every time it's called in this script
20:43 and re-try when it times out
20:44 ie, after 30 seconds, we want it to try again
20:44 and then wait another 30 seconds
20:44 atz while (!$dbh) {  the_rest_of_it }
20:44 kados and so-on
20:44 make sense?
20:44 atz this isn't that hard
20:44 kados my $dbh;
20:44 while (!$dbh) { $dbh = C4::Context->dbh }
20:44 like that?
20:46 atz while (!$dbh) { $dbh = C4::Context->dbh;  ($dbh) or warn/sleep/log;}
20:48 or you can do   while (1){ ... ;  $dbh and last;   warn;sleep;log;}
20:49 kados *nod*
20:49 atz i'd recommend the escalating kind of delay like TCP does.      
20:50 having already declared:   my $minsleep = 30;  my $maxsleep = 5000;
20:51 the sleep line becomes like:
20:51 sleep $minsleep *= 2;
20:52 sleep ($minsleep *= 2 > $maxsleep) ? $maxsleep : $minsleep;
20:53 kados I like it
20:53 thanks
20:53 atz yeah, that kind of thing is reasonable machine (or protocol) behavior
20:54 it's like, "well, you've been broken 6 times in  a row now, maybe I shouldn't still  be expecting you to be online in next second"
20:54 kados *nod*
20:58 atz someday, i might like to get deeper into zebra/zebraqueue code
20:59 look at benchmarking it (inside vs. ouside a VM), optimize caching, etc.
01:02 thd Is there a problem with git.koha.org or is it just me?
01:03 kados thd: working for me
01:03 thd: long time no see!
01:03 qiqoqo wow so you guys are releasing beta?
01:03 coool!
01:04 kados qiqoqo: soon my friend, soon
01:05 hopefully in time for Code4libCon
01:05 qiqoqo hehe wow great job guys
01:05 thd kados: I have remote: aborting due to possible repository corruption on the remote site
01:06 qiqo i can see the release notes for beta
01:06 i always get that error when i use the git repository,, sorta like with the indexing or stuff
01:06 kados qiqo: yep, they're not completely done
01:07 qiqo so excited.. our university launched it's own ils.. i dont like it.. it's over priced and they wont opensource it. hehe
01:07 thd qiqo: If you get that error, how do you use git?
01:08 qiqo i just folow the installation instruction on debian..
01:08 sorry i just merely forgot how to do that, im on a windows server machine at the moment,
01:09 copied and pasted the one which is in debianinstall which is option one..
01:10 anyway i never get successful with it so i always use option two
01:11 which is to download koha manually..
01:17 thd kados: when did you last fetch from git?
01:17 kados thd: this morning IIRC
01:18 thd: I'll try right now
01:18 thd: working fine for me thusfar
01:19 thd Yet I have this fatal error
01:19 for the past 3 hours
01:19 kados :(
01:22 pianohacker Hello there
01:23 How should I add smart-rules to the admin-home page?
01:24 gmcharlt pianohacker:  add links to koha-tmpl/intranet-tmpl/prog/en​/modules/admin/admin-home.tmpl
01:24 and koha-tmpl/intranet-tmpl/prog​/en/includes/admin-menu.inc
01:24 pianohacker Okay, cool
01:24 gmcharlt in same fashion as links to issuingrules.pl
01:25 pianohacker How to deal with the overlap of functionality, though?
01:25 Call it Circulation and Fines Rules (NEW) ?
01:27 gmcharlt Circulation and Fines Rules (alternative interface), perhaps
01:27 title can be changed later once everybody is comfortable with it and ready to remove (or deemphasize) the existing issuingrules.pl
01:29 pianohacker You guys use 4-space indentation, right?
01:30 bbl
01:30 pianohacker|foo Engfeh
01:34 gmcharlt pianohacker|afk: 4-space indents in Perl code
01:34 pianohacker|afk: in practice, less disciplined indented in the HTML templates ;)
01:34 kados indenting html templates consistently is hard
01:36 gmcharlt hmm, is http://wiki.koha.org/doku.php?[…]oding%20standards all there is on the wiki -- could stand a little more meat, if so
01:39 kados there's also a page on the kohadocs.org site
01:39 http://www.kohadocs.org/codingguidelines.html
01:39 that unfortunately isn't easy to edit
01:39 until we move to plone
01:53 fbcit g'night koha. I'm off to sleep.
01:55 thd kados: what does git --version report for you?
01:56 kados git --version
01:56 git version 1.5.3.7
01:57 thd I have the same so that cannot be the problem
01:57 kados try a fresh clone
01:57 thd :(
01:57 qiqo is there a way to recheck the database of koha? it seems that my problem is about the database.. i really cannot print spinelabels, i only get barcodes and item type, no call number
01:59 thd qiqo: did you create items for your bibiographic records with ca numbers?
02:00 s/ca/call/
02:01 qiqo yeah
02:01 082, 900 series right?
02:01 both of them are filled up
02:03 thd qiqo: I do not mean the MARC 21 standard location for call numbers but the one specific for Koha items
02:04 qiqo where is that?
02:04 because i only see "null" on the itemcallnumber field on the items table
02:04 thd ]qiqo: I should know immediately but let me verify
02:04 qiqo that field is never populated
02:05 thd qiqo: which version are you testing
02:05 ?
02:05 qiqo 2.2.8 on windows
02:05 win 2003 server sp2
02:06 will it be fine if the cardinality of records from items table is not equal to the number of records in biblioitems?
02:09 thd qiqo: Koha should manage the incrementation for you and if it has done that should not be a problem
02:10 qiqo ahh ok
02:10 thd qiqo: Koha items should be in 952 for rel_2_2
02:11 qiqo let me check
02:11 thd and also for 3.0
02:11 qiqo it's 942 in mine
02:14 thd qiqo: I suspect that you are confusing 952 and 942
02:15 qiqo: 942 call numbers are only used for sorting
02:15 a result set
02:16 qiqo: of course you may have changed the defaults but unless you remember changing them you probably did not
02:17 qiqo: have you followed the step for some test records of adding items (copies) to your biblio records?
02:17 qiqoqo sorry bout that
02:17 got disconnected
02:18 darn isp
02:18 thd qiqo: have you followed the step for some test records of adding items (copies) to your biblio records?
02:18 qiqoqo nope.. i started from a blank db
02:18 previously i was on linux
02:19 and it's like i was printing spine labels manually
02:20 thd qiqooqo: well you cannot expect good results with an empty db but I expect that you did not mean to say that your DB is empty :)
02:20 qiqoqo ah.. only the framework
02:20 hehe
02:20 hmm.. i already have 300 records.. aww..
02:21 is started with 2.2.7, there was no spine label printing then
02:21 thd qiqoqo: and do those records have items (copies) attached for holdings?
02:22 qiqoqo yup
02:22 i use koha for my library
02:23 thd qiqoqo: in the same field as the one holding the barcode, probably 952 on a Koha MARC 21 system, do you have call numbers?
02:23 qiqoqo i started up with it.. so im in the middle of cataloguing things
02:25 field on the database?
02:26 as far as im concerned,  the field that only has the call number is biblioitems.classification
02:26 nothing for items.itemcallnumber, it's empty
02:26 thd qiqoqo: items.itemcallnumber
02:26 qiqoqo and if i put something on items.itemcallnumber it prints to the pdf
02:27 thd qiqoqo: hooray
02:28 qiqoqo but the problem is, i cant paste data from biblioitems.classification to items.itemcallnumber
02:28 they dont have the same cardinality
02:28 and the titles wont also print
02:29 thd qiqoqo: if you edit your items manually and add call numbers to each item then you should be fine
02:29 qiqoqo aww..
02:29 that's 300 records.. a
02:29 hehe
02:29 atz you can script yourself a mysql update
02:29 might be easier
02:30 qiqoqo haha,, i only have a limited knowledge on mysql
02:30 but hmm.
02:30 thd atz: qiqoqo is worried about a difference in cardinality
02:31 qiqoqo: there is something that can help
02:31 qiqoqo: what classification scheme are you using?
02:31 qiqoqo also the title is not printing im suspecting that its a miscommunication between items and biblioitems tables
02:31 DDC
02:32 thd qiqoqo: is 082 populated for your records?
02:32 qiqoqo 082 and 942
02:34 OMG i really dont want to startr over again, books are already on the shelves.
02:34 thd qiqoqo: can you export your records successfully in MARC 21?
02:35 qiqoqo hold on i'll try
02:35 ok i exported it
02:36 thd qiqoqo: are you more comfortable with Perl than SQL?
02:37 qiqoqo neither of them hehe..
02:37 i actually check the perlscripts.. label-print.pl
02:38 the sql statements there seem to be fine
02:38 i really think it's with my database structure which causes the problem
02:39 thd qiqoqo: items.itemcallnumber is not filled automatically
02:39 qiqoqo well i havent tested this on 3.0 because im getting a "frey 50" thing on field 100
02:40 thd frey 50?
02:40 atz that's a marc21 error
02:40 i thought it was fixed though...
02:41 thd atz: qiqoqo is using 2.2.8
02:41 qiqoqo oh i already reported it
02:41 thd when does that error occur?
02:42 qiqoqo yeah when i exported 2.2.8, then it goes successfully
02:42 when i search the opac.. it has 'frey 50' after the author
02:42 and if a title does not have an author, system replaces it with a date in YYYYMMDD format + frey 50
02:43 tried it on zebra and non zebra
02:43 edjarima good night
02:43 qiqoqo gmcharlt already saw this.. and he said you're fixing it
02:43 we were on remote desktop connection last time
02:43 :)
02:43 edjarima good night
02:43 thd good night edjarima
02:44 qiqoqo nyty edjarima
02:46 so this problem was already fixed?
02:46 i can try it again..
02:48 thd qiqoqo: I assume that the fix requires updating to a CVS version of Koha
02:49 qiqoqp: but maybe you could merely copy one file which fixed the issue
02:52 qiqoqo: do you care what your barcodes are or anything else already in your items?
02:52 qiqoqo barcodes are printing fine
02:53 my only concern is the title and the call number..
02:53 i really cant do the manual thing anymore,, causes me stress.
02:54 thd qiqoqo: So you do not care about retaining some particular barcodes as long as they are unique?
02:54 qiqoqo hmm.. what do you mean..
02:55 i have to retain barcodes actually
02:55 because some of the stuff, merely 200 items already have their barcodes
02:55 and are on the shelves already
02:55 thd qiqoqo: OK
02:55 qiqoqo sorry if i dont understand it right..
02:56 thd you understood
02:56 qiqoqo oh cool.. hehe
02:56 my only frustration is that.. it's an ILS, automation, i should not go on with the manual thing
02:59 thd qiqoqo: there is some automation for adding call numbers in 2.2.8 but it is limited to adding something like 082 $a but misses $b so you would miss the cutter number
02:59 qiqoqo ohhh..
02:59 so can this be seen on 3.0?
03:00 thd qiqoqo: this feature in 2.2.8 also only works if you configure it and operates as part of the manual process for adding items
03:01 qiqoqo: your records could most easily be fixed from an exported set of records
03:01 qiqoqo uhuh
03:01 but will mess up my barcode right?
03:01 thd qiqoqo: no
03:01 qiqoqo ahh ok
03:02 pianohacker|afk Hrmfrgldammit
03:02 I can't get postfix to send correctly
03:02 thd the current version of my script would move them but you do not want that either
03:02 pianohacker|afk Is there some other way to get patches to the right place?
03:02 qiqoqo hmmm..
03:02 so im really traped..
03:03 thd qiqoqo: no I could fix the script
03:03 qiqoqo really?
03:03 but ill be shifting to 3.0 soon..
03:03 so.. i guess i'll have to wait until the frey 50 thing is fixed
03:03 thd qiqoqo: are you issuing items on loan already?
03:04 qiqoqo nope not yet
03:04 i'll be going to thailand and india to enter data from there
03:04 after that i'll open this library
03:04 my server is located here in manila
03:05 thd pianohacker: you could email an attachment to the correct address
03:05 pianohacker thd: That won't cause any problems?
03:06 Cause if it would make their lives easier, I'll try to get this godforsaken thing working
03:06 thd pianohacker: you need the special magic word in the subject line to pass the spam filter
03:06 qiqoqo lol
03:06 thd pianohacker: do try to fix postfix of course
03:07 pianohacker thd: Weird thing is, it doesn't seem to be postfix; I can't telnet to any of gmail's incoming SMTP servers. Ah well
03:08 thd pioanohacker: add [patch] to the subject line of a manual message with the patch attached and the appropriate comment about its function in the subject and or body
03:09 qiqoqo hey i'll try 3.0 and see if things will get fixed
03:09 pianohacker Well, hope that worked
03:11 thd qiqoqo: call numbers are poorly automated in Koha record creation because of a lack of understanding by most of the programmers working on Koha about how they are used.
03:11 qiqoqo the last time gmcharlt screenshared with me, he saw some irregularities with my marc records and i think he fixed it
03:12 yeah thd, that's what my professor thinks about koha..
03:12 but anyway, he is also waiting for version 3.0 since they are going to deploy it in our National Library
03:13 thd qiqoqo: If you know someone who wants to sponsor much improved automation of adding call numbers it is not difficult to achieve but just time consuming to generalise properly.
03:13 qiqoqo he already sent some staff to learn perl
03:13 thd qiqoqo: which nation?
03:13 qiqoqo Philippines
03:14 hold on ill be transfering to my macbook
03:14 brb
03:16 pianohacker Night all
03:17 kados thd:  you may want to look more closely at call number handling in 3.0
03:17 thd: it's improved considerabley
03:17 thd kados: you did what you said there was no time to do? :)
03:17 kados thd: no, but gmcharlt did :-
03:18 )
03:18 though I will point out that apparantly call numbers are less and less important to libraries
03:19 for instance, worldcat local doesn't even support searching by call numbers
03:19 qiqo hmm then how do you search for the physical location of items?
03:20 well we're still old school here.. "location, co location"
03:20 thd kados: only ignorant librarians like the WorldCat who manage the WorldCat local project believe that
03:20 s/like the /like the ones/
03:21 qiqo @thd i dunno about worldcat, never heard it in library school
03:21 thd qiqo: WorldCat is the name of the OCLC union catalogue
03:22 qiqo ahh ok
03:22 oclc.. i get it
03:22 it may have been the name
03:22 we still rely on lc though..
03:22 well it's a part of the curiculum
03:23 thd qiqo: WorldCat local is OCLC's new OPAC which does not have other ILS features
03:23 qiqo well gonna research on that, i might teach at the university
03:24 thd qiqo: kados just told me that 3.0 development has some call number management features which I have not seen
03:24 qiqo ohh that's good
03:24 im installing debian at the moment.. etch right?
03:25 i already changed servers so i have no choice but to install it again
03:25 thd qiqo: If you can wait until 3.0 is usable you would be much better off than migrating from 2.2.X
03:25 qiqo hmmm... when would that be?
03:26 kados 3.0 is usable now
03:26 qiqo it's fine for me to test it anyways..
03:26 yeah i think 3.0 is usable
03:26 kados several libraries are in production with 3.0
03:26 thd kados: are there no terrifying bugs left?
03:26 qiqo i mean, the most important thing for us here is opac
03:26 kados thd: nope, only one annoying one with zebra
03:27 zebraqueue specifically
03:27 thd kados: I will have to file some ;)
03:27 kados but nothing that doesn't have a workaround to my knowledge
03:27 thd: :-)
03:28 qiqo aw..
03:28 thd qiqo: is the Philippine national library also the largest library in the Philippines?
03:28 qiqo nope,, the second one
03:29 the largest library is my university: University of the philippines
03:29 1.5Million records
03:29 national lib i think only has 260,000
03:29 more or less
03:29 thd qiqo: is the University library also a copyright depository library for the Philippines?
03:30 qiqo when you publish a book in the philippines, you have to send a copy to national library and UP
03:31 thd qiqo: do you have the Z39.50 server parameters for those libraries?
03:31 qiqo hmmm i think there's none
03:31 they dont invest on those things
03:32 no z3950 servers here in the philippines to the best of my knowledge
03:32 atz wow, that's remarkable
03:32 thd qiqo: what classification and subject heading thesauri do they use?
03:32 qiqo libraries here rely on manual copycat from lc or ohio
03:33 UP is using LC classification and LC subject heading
03:33 kados qiqo: you will have a Z-server if you instal 3.0 :-)
03:33 qiqo wow!
03:33 hahaha
03:33 atz ohio?   (i live in ohio)
03:33 kados as will the national library
03:33 qiqo ohiolink
03:33 cool!
03:33 kados qiqo: a SRU server too
03:33 atz i used to work w/ INFOhio (the k12 version of OhioLink)
03:34 qiqo cool
03:34 yeah... but they have to customize things in the national lib
03:34 thd qiqo: what is done for cataloguing locally published material not in LC or OCLC?
03:35 qiqo LC SH and LC C is very limited for the US.. so they designed a customized LC SH and LC C
03:35 and sometimes we produce our own local theusaurus
03:36 as for the national library, it's DDC which they use
03:36 i dunno why? hehe
03:36 well gotta invite you guys to go to manila sometime..
03:36 haha
03:36 thd qiqo: what are the titles of the published standard for Philippine thesauri?
03:37 s/standard/standards/
03:38 qiqo well we have thesauri on local languages.. like we have 80 languages and dialects here in the philippines
03:38 we also have philippine medical thesaurus
03:38 and i tell you guys, if our asian neighbours here in the philippines see that the national library is using koha, they might follow us
03:39 we have thesaurus for women studies
03:40 thd qiqo: can you send me a list of the titles of those thesauri?
03:40 qiqo hold on ill check
03:41 thd what is your email?
03:41 or can i just post here?
03:41 thd qiqo: koha AT agogme.com
03:41 qiqo: but you could post it here
03:42 qiqo: after all everyone should want to know
03:43 qiqo: you should have a little help migrating your exported 2.2.X records to Koha 3.0
03:44 qiqo ahmm yeah i think so
03:44 like indexing zebra and stuff
03:45 thd qiqo: Koha specific default fields and subfields have been rearranged so the records should be changed accordingly.
03:46 qiqo ohh what does that ean
03:46 mean
03:46 thd qiqo: If you have no patrons, loans, etc. to migrate then the task should be fairly easy.
03:47 qiqo ahh nope, dont have that yet
03:47 i have a question, since im only the librarian here in our organization..
03:48 thd qiqo: EAN? European Article Number or standard barcode symbology for products
03:49 qiqo and the task for the national library is to deploy koha as replacement for TLC
03:49 since there is division of work there.. my professor asks if they could like assign priviledges?
03:50 thd,, im using code39
03:50 like for the ones who only catalogues... or on the circulation desk
03:50 kados qiqo: has the national library considered getting support from a koha vendor?
03:51 qiqo: or your university even?
03:51 thd qiqo: yes, Koha has a very flexible system for restricting different librarians to different types of privileges
03:51 qiqo oh ok
03:52 @kados we are thinking about that, but at the moment, i guess they need training first
03:52 thd qiqo: privileges are documented very well in one or more of the documents on setting up Koha http:www.kohadocs.org
03:52 qiqo oh ok
03:53 ill talk to my professor one of this days,, we will have a beer session or something
03:53 well i need to tell him to request from one of you guys to go here in manila
03:54 thd qiqo: migrating any large collection should have assistance
03:54 qiqo because they are actually fed up paying $30,000 every year for a lousy ILS
03:54 yeah,, ill be telling him about that
03:54 atz amen!
03:55 thd qiqo: even with only 300 books so far in the database that you have been using, fixing something simple is more work than you want to undertake manually
03:56 qiqo hehe
03:57 look at their opac: http://basilio.nlp.gov.ph/
03:59 thd kados: I think I found the answer
03:59 qiqo brb i'll take a shower
03:59 thd kados: "Trying again somewhat later went through flawlessly [not for me]. Might have been git running out of memory."
04:00 kados: I no longer have enough free RAM to update my git repository even in console mode
04:12 qiqo back..
04:19 mygosh you a daemon killer... you're archangel lolz
04:30 thd apparently I did not kill enough daemons
04:40 git is working so far now hooray
04:41 kados: do you have any spare RAM cards for me?
04:42 qiqo how much ram do you have thd?
04:43 thd qiqo: 256 MB with many daemons running
04:43 git finally failed although at a much later point
04:44 qiqo ohh ok
04:44 ddr or ddr2?
04:45 thd qiqo: pre DDR SDRAM
04:47 qiqo: my money always goes to pay for non-computer necessities each month with nothing remaining to fix these little problems
04:48 qiqo awww..
04:48 wish i could help you ther
04:48 i have spare here, but shipping might have been a lot more expensive than buying a new one
04:48 :)
04:50 thd qiqo: RAM is very cheap now but my landlord is very expensive :)
04:52 s/cheap now/cheap now compared to even 2 years ago/
04:53 qiqo yeah
04:54 like ddr2 is a lot cheaper
04:54 if could fit 4GB in my macbook id love to do that
04:54 but im only limited with 2
04:55 hmm brb lunck
04:55 hmm brb lunch

← Previous day | Today | Next day → | Search | Index

koha1