Time Nick Message 05:21 |hdl| 2) link biblio with authority : you can use authoritysearch and input the $9 from that. 05:20 |hdl| 1) Import the authority data (it is a mere bulmarcimport) 05:19 |hdl| But the problem with such an import would be divided into 2 parts : 05:18 |hdl| You are right : it doesnot import auhtority file. 05:18 |hdl| thd: I saw your question : Indeed, it is an authority creation from existing biblio. 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. 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:17 root they have 5000 books and stuff maybe more that is a good question 00:14 thd root: how many records are there? 00:14 chris for less than $1000 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:13 chris the toss up will be 00:13 chris gotta love vendors that charge you for your own data 00:12 root records that could be exported to marc at about $1000 price 23:50 thd root: what sort of digital record do they have already with the company to which they pay a lot of money? 23:48 root I just set them up for using Z395 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:47 root so 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:38 chris im assuming this is for a library that has no library system already? 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:34 russ the library doesn't have any digital records? 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? 20:21 kados right 20:21 chris to catch owen or stephen 20:21 chris i said their best bet was between 9-5 EST 20:21 kados I'll have to follow up on that 20:20 chris ahh, it'll be in the log, they were quite interested to talk to someon from NPL 20:20 kados no I missed it 20:20 chris did you see yesterday that someone was in here asking about public libraries and koha 20:17 chris sweet 20:17 kados I'll commit it right away 20:17 kados nice catch ... thanks 20:17 chris cool 20:17 kados that did it 20:16 chris biblioitems.biblioitemnumber=items.biblioitemnumber 20:16 kados heh 20:16 chris that should be 20:15 chris BZZT wrong 20:15 chris biblioitems.biblioitemnumber=items.itemnumber 20:15 chris see this line 20:15 chris look at the overdues query 20:15 chris i see the problem 20:15 chris ah ha 20:15 chris do a select * from items,biblioitems,biblio where 20:14 kados let me find the other 20:14 kados well, one of them 20:14 kados yea 20:14 chris the itemnumbers or barcodes? 20:14 chris do we know the 2 that arent showing? 20:14 chris right 20:13 kados 12 20:13 chris but the overdue report says how many? 20:13 chris right 20:13 kados yep 20:13 kados which is right according to the member page 20:13 chris and thats what circ reckons? 20:13 kados select count(*) from above gives me 14 20:13 chris id try a select * from issues where borrowernumber=whatever and returndate is null 20:12 chris or even 20:12 kados k 20:12 chris and just see what they look like 20:12 chris id try a select * from issues where borrowernumber=whatever 20:12 chris do you know the borrowernumber? 20:11 kados I'm confused :-) 20:11 kados right ... 20:11 chris then the book isnt on issue 20:11 chris returndate is null if the book hasnt been returned, if returndate has a value 20:11 kados no idea 20:10 chris what do you reckon it is then? 20:10 chris hmm 20:07 kados I recon returndate isn't null 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:06 kados chris: here's the query overdue.pl is running: 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. 19:12 kados thd: no ... but I've been trying to use them whenever I have opportunity 19:09 thd kados: or does Open-ILS use awk and sed much in preference to Perl or something else? 19:07 thd kados: you use sed. Perl is too powerful and consistent in implementation for you? :) 19:06 kados heh 19:05 thd kados: As if I were also not busy enough already still catching up from my long absence. 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:04 kados thd: here, this should keep you busy :-): 19:03 kados but noone has time right now 19:03 kados thd: I suppose some day we could nab some stuff from them 19:03 kados thd: no, they are just perl methods within open-ils 19:03 thd kados: The Open-ILS methods could be used to interface between Koha and an Open-ILS system? 19:01 thd kados: I think he may have confused building with importing unless he sent me something different from you by mistake ;) 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 :-) 18:59 kados but I have not had a chance to peek at it today 18:59 kados he did in fact send me a file 18:59 kados hehe 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:53 kados russ: ? 18:35 kados russ: yep 18:34 russ kados are you around? 15:55 thd |hdl|: Are you still there? 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. 13:16 |hdl| or Irak War ? 13:16 |hdl| Could it be Catrina's fault ? 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:12 |hdl| thd: a shame 13:12 |hdl| root : ok 13:11 |hdl| thd: sent 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: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:03 root though I thought that the Koha install had this setup from default....I got this in a local Koha doc 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:00 |hdl| root: didnt understand you latest sentences. 13:00 root hdl I will write more later but it looks like it is working thanks for pushing me along 12:59 |hdl| thd: could be. 12:59 root I changed the setting from Marc21 to unimarc and not the search brought it up??? 12:59 root I went and clicked wait something just happened for the better 12:58 root then after that 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:57 thd |hdl|: Will it be in CVS any time soon? 12:56 |hdl| Nope : It was a specific script for a client. 12:55 thd |hdl|: Is the bulkauthimport.pl that you sent kados in CVS? 12:52 root alright one moment I will try it 12:49 |hdl| try with ISBN will be better. 12:49 |hdl| you will probably have too many answers. 12:49 root Am I wrong that this should search the Congress database for books with this word? 12:48 root then there is the z395 search though it still sais nothing found 12:48 root duh 12:48 root bibliois in reservoir none 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:46 |hdl| or edition 12:46 |hdl| root : bibliocreation 12:44 root also it seems I had a button somewhere for z3950 search but now??? 12:43 |hdl| hi owen 12:43 kados morning owen 12:42 |hdl| root: should be 12:42 |hdl| and then try z3950 search on biblio you DONOT have 12:42 root what is the best way to stop it and relaunch it is not /etc/init.d/??? 12:42 |hdl| relaunch the z3950daemon 12:41 |hdl| ok 12:40 root syntax marc21 12:40 root I added this Library of Congress z3950.loc.gov 7090 voyager checker=1 rank=1 12:39 |hdl| what do you see 12:39 root alright 12:39 |hdl| get to z3950servers page 12:38 root alright 12:38 |hdl| get to parameters page 12:38 |hdl| go into intranet 12:38 root alright 12:38 |hdl| launch koha 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:37 root Two things one where is parameters module and two 12:37 |hdl| (see parameters module) 12:36 |hdl| Have you set z3950 servers data in Koha ? 12:36 |hdl| ok. 12:36 |hdl| in /path/to/koha/intranet/scripts/z3960 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:35 |hdl| Verify you have a z3950-daemon-options file. 12:35 |hdl| to achieve this : export KOHA_CONF=/path/to/your/koha.conf and PERL5LIB=/path/to/module 12:34 |hdl| root: have you launched z3950daemon 12:33 |hdl| thd: the bulkauthimport I sent kados I used for an import. 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:09 thd s/bulkauthorityimport/bulkauthimport/ 12:04 thd kados: bulkauthorityimport.pl is not even close to functional. bulkauthorityimport.pl was initiated for an experiment that was abandoned. 11:26 |hdl| file sent. 11:20 kados thanks 11:17 |hdl| basic process is a bulkauthimport into the authority needed. 11:17 kados |hdl|: can I bulkimport a MARC authority file into Koha? 11:16 kados |hdl|: could you go over the basic process for importing title/subject authority files?