Time Nick Message 11:16 kados |hdl|: could you go over the basic process for importing title/subject authority files? 11:17 kados |hdl|: can I bulkimport a MARC authority file into Koha? 11:17 |hdl| basic process is a bulkauthimport into the authority needed. 11:20 kados thanks 11:26 |hdl| file sent. 12:04 thd kados: bulkauthorityimport.pl is not even close to functional. bulkauthorityimport.pl was initiated for an experiment that was abandoned. 12:09 thd s/bulkauthorityimport/bulkauthimport/ 12:21 root Help: I am sure this is somewhere and I've probably looked right at it. My Debian Sarge Install seems good BUT z39.5 just does not seem to show up anywhere. It is started in the background but how can I test it? Search? Maybe I am wrong in thinking that it should help me in adding books etc? 12:33 |hdl| thd: the bulkauthimport I sent kados I used for an import. 12:34 |hdl| root: have you launched z3950daemon 12:35 |hdl| to achieve this : export KOHA_CONF=/path/to/your/koha.conf and PERL5LIB=/path/to/module 12:35 |hdl| Verify you have a z3950-daemon-options file. 12:36 root Yes I did launch it via /etc/rc2.d/S99z39 which has this /usr/local/koha/intranet/scripts/z3950daemon/z3950-daemon-launch.sh and a ps aux shows it is running as this www-data 16659 0.0 3.2 13232 8388 tty2 S 10:00 0:01 /usr/bin/perl /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue /usr/local/koha/log 12:36 |hdl| in /path/to/koha/intranet/scripts/z3960 12:36 |hdl| ok. 12:36 |hdl| Have you set z3950 servers data in Koha ? 12:37 |hdl| (see parameters module) 12:37 root Two things one where is parameters module and two 12:38 root i thought it came preinstalled with congress link but since nothing worked I added two other places and marked them 1 to make sure they are searched 12:38 |hdl| launch koha 12:38 root alright 12:38 |hdl| go into intranet 12:38 |hdl| get to parameters page 12:38 root alright 12:39 |hdl| get to z3950servers page 12:39 root alright 12:39 |hdl| what do you see 12:40 root I added this Library of Congress z3950.loc.gov 7090 voyager checker=1 rank=1 12:40 root syntax marc21 12:41 |hdl| ok 12:42 |hdl| relaunch the z3950daemon 12:42 root what is the best way to stop it and relaunch it is not /etc/init.d/??? 12:42 |hdl| and then try z3950 search on biblio you DONOT have 12:42 |hdl| root: should be 12:43 kados morning owen 12:43 |hdl| hi owen 12:44 root also it seems I had a button somewhere for z3950 search but now??? 12:46 |hdl| root : bibliocreation 12:46 |hdl| or edition 12:47 root okay it sais title or isbn now if I enter a title word say garden that is not in the local database it sais bibios in koha none 12:48 root bibliois in reservoir none 12:48 root duh 12:48 root then there is the z395 search though it still sais nothing found 12:49 root Am I wrong that this should search the Congress database for books with this word? 12:49 |hdl| you will probably have too many answers. 12:49 |hdl| try with ISBN will be better. 12:52 root alright one moment I will try it 12:55 thd |hdl|: Is the bulkauthimport.pl that you sent kados in CVS? 12:56 |hdl| Nope : It was a specific script for a client. 12:57 thd |hdl|: Will it be in CVS any time soon? 12:58 root |hdl|so here is what i did...I went to the congress site and searched the isdn and it worked so then I entered that same isdn in the first page of Catalog-->Add Biblio -->ISBN 12:58 root then after that 12:59 root I went and clicked wait something just happened for the better 12:59 root I changed the setting from Marc21 to unimarc and not the search brought it up??? 12:59 |hdl| thd: could be. 13:00 root hdl I will write more later but it looks like it is working thanks for pushing me along 13:00 |hdl| root: didnt understand you latest sentences. 13:01 root well in Parameters --> Z359 --> I edited the Syntax from Marc to Unimarc (from the pull down menu) and now it worked 13:03 root though I thought that the Koha install had this setup from default....I got this in a local Koha doc 13:05 thd |hdl|: If it is not otherwise in CVS, I would be very happy if you would send a copy to koha@agogme.com 13:11 thd |hdl| kados: the LOC Cataloging and Distribution Service, primary source of MARC file distribution in the US, just lost 40% of their staff. 13:11 |hdl| thd: sent 13:12 |hdl| root : ok 13:12 |hdl| thd: a shame 13:15 thd |hdl|: Thank you for the file. Apparently, the money for the national Library in the US is now going to some other cause.. 13:16 |hdl| Could it be Catrina's fault ? 13:16 |hdl| or Irak War ? 13:25 thd |hdl|: I am not certain of the cause and actually the LC budget may not have been reduced. However, MARC file distribution has definitely been downgraded within LC. I am not certain what the consequence is except for a much smaller staff to administer the distribution of MARC files. This just happened last month as part of unreplaced employee retirement. 15:55 thd |hdl|: Are you still there? 18:34 russ kados are you around? 18:35 kados russ: yep 18:53 kados russ: ? 18:58 thd kados: If russ is not present, could you explain about whether hdl sent you a file for building authority records from bibliographic records in Koha or for actually importing pre-existing authority records from an external source as might be done with a working bulkauthimport.pl? 18:59 kados hehe 18:59 kados he did in fact send me a file 18:59 kados but I have not had a chance to peek at it today 19:00 kados I spent the better part of the afternoon crafting a lovely little command-line report that checks for unused yet registered methods in the open-ils CVS repository :-) 19:01 thd kados: I think he may have confused building with importing unless he sent me something different from you by mistake ;) 19:03 thd kados: The Open-ILS methods could be used to interface between Koha and an Open-ILS system? 19:03 kados thd: no, they are just perl methods within open-ils 19:03 kados thd: I suppose some day we could nab some stuff from them 19:03 kados but noone has time right now 19:04 kados thd: here, this should keep you busy :-): 19:04 kados for x in `grep -r "api_name.*=>.*" ILS/Open-ILS/src/perlmods/OpenILS/Application |awk '{print $4}'| sed "s/\"\|,\|)\|\;\|'//g"`; do echo " Method: $x "; grep "$x" ILS/Open-ILS/xul/staff_client/chrome/content/main/constants.js| wc -l| tr -d '\n'; echo -n " : "; grep "$x" ILS/Open-ILS/web/opac/common/js/config.js |wc -l| tr -d '\n'; echo -n " : "; grep -r "$x" ILS/Open-ILS/xul/staff_client/server/admin/ |wc -l|tr -d '\n'; done 19:05 thd kados: As if I were also not busy enough already still catching up from my long absence. 19:06 kados heh 19:07 thd kados: you use sed. Perl is too powerful and consistent in implementation for you? :) 19:09 thd kados: or does Open-ILS use awk and sed much in preference to Perl or something else? 19:12 kados thd: no ... but I've been trying to use them whenever I have opportunity 19:16 thd kados: I can never remember what needs what type of quoting or escaping across languages. However, sed has not been very consistent over time and between different implementations. Yet, it still requires much less resources than a complete language such as Perl. 20:06 kados chris: here's the query overdue.pl is running: 20:06 kados select date_due,concat(firstname,' ',surname) as borrower, borrowers.phone, borrowers.emailaddress,issues.itemnumber, biblio.title, biblio.author from issues, borrowers,items,biblioitems, biblio where isnull(returndate) && date_due<'2006-02-07' && issues.borrowernumber=borrowers.borrowernumber && issues.itemnumber=items.itemnumber && biblioitems.biblioitemnumber=items.itemnumber && biblio.biblionumber=items.biblionumber && (borrowers.firstname like '010-40203%' or 20:07 kados I recon returndate isn't null 20:10 chris hmm 20:10 chris what do you reckon it is then? 20:11 kados no idea 20:11 chris returndate is null if the book hasnt been returned, if returndate has a value 20:11 chris then the book isnt on issue 20:11 kados right ... 20:11 kados I'm confused :-) 20:12 chris do you know the borrowernumber? 20:12 chris id try a select * from issues where borrowernumber=whatever 20:12 chris and just see what they look like 20:12 kados k 20:12 chris or even 20:13 chris id try a select * from issues where borrowernumber=whatever and returndate is null 20:13 kados select count(*) from above gives me 14 20:13 chris and thats what circ reckons? 20:13 kados which is right according to the member page 20:13 kados yep 20:13 chris right 20:13 chris but the overdue report says how many? 20:13 kados 12 20:14 chris right 20:14 chris do we know the 2 that arent showing? 20:14 chris the itemnumbers or barcodes? 20:14 kados yea 20:14 kados well, one of them 20:14 kados let me find the other 20:15 chris do a select * from items,biblioitems,biblio where 20:15 chris ah ha 20:15 chris i see the problem 20:15 chris look at the overdues query 20:15 chris see this line 20:15 chris biblioitems.biblioitemnumber=items.itemnumber 20:15 chris BZZT wrong 20:16 chris that should be 20:16 kados heh 20:16 chris biblioitems.biblioitemnumber=items.biblioitemnumber 20:17 kados that did it 20:17 chris cool 20:17 kados nice catch ... thanks 20:17 kados I'll commit it right away 20:17 chris sweet 20:20 chris did you see yesterday that someone was in here asking about public libraries and koha 20:20 kados no I missed it 20:20 chris ahh, it'll be in the log, they were quite interested to talk to someon from NPL 20:21 kados I'll have to follow up on that 20:21 chris i said their best bet was between 9-5 EST 20:21 chris to catch owen or stephen 20:21 kados right 23:33 root ISBN Import question: How possible is it for a library to scan all their book's ISBN to a text file and then pass that info to a script that would One match the isbn number to the wanted book info and two import that bibio info into koha? 23:34 russ the library doesn't have any digital records? 23:38 chris its possible, wouldnt be too useful without some item data like barcode as well, so that koha can make items to attach to the biblio 23:38 chris im assuming this is for a library that has no library system already? 23:47 root They have no digital record other then the company they pay alot of money too but now they want to go independent 23:47 root so 23:48 root I was thinking they could quickly scan to a text file and then I would run the import at the end of the effort. Later 23:48 root I just set them up for using Z395 23:50 thd root: what sort of digital record do they have already with the company to which they pay a lot of money? 00:12 root records that could be exported to marc at about $1000 price 00:13 chris gotta love vendors that charge you for your own data 00:13 chris the toss up will be 00:14 chris can someone write a script and scan all the isbns, and load them in plus the other info it needs, like shelf location, branch location etc 00:14 chris for less than $1000 00:14 thd root: how many records are there? 00:17 root they have 5000 books and stuff maybe more that is a good question 00:20 thd root: chris put the economics quite well. It is certainly a shame that your vendor would charge you for your own records as many do. 00:24 thd root: If $1000 is the price for all of your over 5000 records at less than $ 0.20 per record I doubt that you could do the work necessary to replicate them for less unless you consider your labour costs to be already paid in advance with time to spare for new record capture and editing. 05:18 |hdl| thd: I saw your question : Indeed, it is an authority creation from existing biblio. 05:18 |hdl| You are right : it doesnot import auhtority file. 05:19 |hdl| But the problem with such an import would be divided into 2 parts : 05:20 |hdl| 1) Import the authority data (it is a mere bulmarcimport) 05:21 |hdl| 2) link biblio with authority : you can use authoritysearch and input the $9 from that.