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?