- Koha - lists.katipo.co.nz

MARC Communications Format Records
by Larry Currie 20 Aug '02

20 Aug '02

Pasted below and also in an attachment to this message are 3 bibliographic records in MARC communications format. We have about 100,000 more just like these 3 that we would like to load into Koha. If you look closely, you will also see a "database control number" in the form of 3 letters followed by a dash and 4 digits right after the stream of numbers at the beginning of each record. It looks like we will have to convert this alphanumeric value into an integer in order to use it as the biblionumber in Koha. Can anyone suggest how we might load these records and convert the database control number? Larry Currie California Academy of Sciences 00952cam 2200229Ia 4500001001300000008004100013005001700054010001300071040001300084041001100097090001900108049005800127100002100185245027600206260004800482300006500530500001700595500003600612650001700648700002700665700003000692AAA-0002 831007m19831998gw abf 00010 eng d19840308194018.0 o09993282 aCAWcCAW0 aengger aQK495.O64bL83 a[folio]CAWFv1-20, 20alLI84-066, LI84-124, LI.85.03910aLuer, Carlyle A.10aThesaurus Masdevalliarum :beine Monographie der Gattung Masdevallia = A monograph of the genus Masdevallia /cvon C.A. Luer ; èUbersetzung ins Deutsche von W. Kèoniger ; Aquarelle von Anne Marie Trechslin ; Herausgeber und Mitarbeiter W. Kèoniger, B. Wèurstle, R. Jenny.0 aMèunchen :bVerlag H. Kèoniger,c1983-1998. a20 v. in 21 :bill., maps (some col., some folded) ;c42 cm. aCover title. aVol. <20a> also by W. Kèoniger. 0aMasdevallia.10aTrechslin, Anne Marie.10aKèoniger, W.q(Willibald) 01003cam 2200229Ia 4500001001300000008004100013005001700054010001300071040001300084090002200097049003200119100004700151245022600198260003600424300002600460500004300486533005300529590006900582650004700651650003700698650003800735AAA-0003 831007r19291797xx rc 00010 eng d19831007174953.0 o09993429 aCAWcCAW aQH70.F7bC3 1797x a[Geol]CAWI[copy2]c2l2468410aCalonne, Charles Alexandre de,d1734-1802.10aMuseum Calonnianum :bspecification of the various articles which compose the magnificent museum of natural history /ccollected by M. De Calonne in France ... exhibiting at Saville House ... previous to the sale thereof.0 aLondon :b[s.n.],cMay 1, 1797. aviii, 84 p. ;c22 cm. aOn last page: "End of the first part." aPhotocopy.eTwo pages on each leaf ; 22 x 25 cm. aCopy 1 positive photocopy dated 1930, c. 2. negative dated 1929. 0aNatural historyxCatalogs and collections. 0aNatural history museumszFrance. 0aShellsxCatalogs and collections. 00946cam 2200265 i 4500001001300000008004100013005001700054010002700071040002300098020004400121043002100165050002300186082001300209049003900222100002300261245012500284260005100409300003500460504003000495600004200525650002800567651003000595650003900625650001600664AAA-0004 760810s1976 meua b 00010 eng 19831007195035.0 a 76008090 o02401554 aDLCcDLCdOCLdCAW a0870271687 :c$12.50.a0870271679bpbk. an-us---ar------0 aQB36.P63bW54 1976 a919.8aB aCAWAlgift:Robert C. Miller:12sp8310aWillard, Berton C.00aRussell W. Porter, arctic explorer, artist, telescope maker /cby Berton C. Willard ; with a pref. by David O. Woodbury.0 aFreeport, Me. :bBond Wheelwright Co.,cc1976. axiii, 274 p. :bill. ;c24 cm. aBibliography: p. 269-274.10aPorter, Russell Williams,d1871-1949. 0aAstronomersxBiography. 0aPolar regionsxBiography. 0aArtistszUnited StatesxBiography. 0aTelescopes. -- Lawrence W. Currie User Services Librarian California Academy of Sciences Golden Gate Park San Francisco, CA 94118 lcurrie(a)calacademy.org (415) 750-7108 (415) 750-7106 fax http://www.calacademy.org/research/library/ 00952cam 2200229Ia 4500001001300000008004100013005001700054010001300071040001300084041001100097090001900108049005800127100002100185245027600206260004800482300006500530500001700595500003600612650001700648700002700665700003000692AAA-0002 831007m19831998gw abf 00010 eng d19840308194018.0 o09993282 aCAWcCAW0 aengger aQK495.O64bL83 a[folio]CAWFv1-20, 20alLI84-066, LI84-124, LI.85.03910aLuer, Carlyle A.10aThesaurus Masdevalliarum :beine Monographie der Gattung Masdevallia = A monograph of the genus Masdevallia /cvon C.A. Luer ; èUbersetzung ins Deutsche von W. Kèoniger ; Aquarelle von Anne Marie Trechslin ; Herausgeber und Mitarbeiter W. Kèoniger, B. Wèurstle, R. Jenny.0 aMèunchen :bVerlag H. Kèoniger,c1983-1998. a20 v. in 21 :bill., maps (some col., some folded) ;c42 cm. aCover title. aVol. <20a> also by W. Kèoniger. 0aMasdevallia.10aTrechslin, Anne Marie.10aKèoniger, W.q(Willibald) 01003cam 2200229Ia 4500001001300000008004100013005001700054010001300071040001300084090002200097049003200119100004700151245022600198260003600424300002600460500004300486533005300529590006900582650004700651650003700698650003800735AAA-0003 831007r19291797xx rc 00010 eng d19831007174953.0 o09993429 aCAWcCAW aQH70.F7bC3 1797x a[Geol]CAWI[copy2]c2l2468410aCalonne, Charles Alexandre de,d1734-1802.10aMuseum Calonnianum :bspecification of the various articles which compose the magnificent museum of natural history /ccollected by M. De Calonne in France ... exhibiting at Saville House ... previous to the sale thereof.0 aLondon :b[s.n.],cMay 1, 1797. aviii, 84 p. ;c22 cm. aOn last page: "End of the first part." aPhotocopy.eTwo pages on each leaf ; 22 x 25 cm. aCopy 1 positive photocopy dated 1930, c. 2. negative dated 1929. 0aNatural historyxCatalogs and collections. 0aNatural history museumszFrance. 0aShellsxCatalogs and collections. 00946cam 2200265 i 4500001001300000008004100013005001700054010002700071040002300098020004400121043002100165050002300186082001300209049003900222100002300261245012500284260005100409300003500460504003000495600004200525650002800567651003000595650003900625650001600664AAA-0004 760810s1976 meua b 00010 eng 19831007195035.0 a 76008090 o02401554 aDLCcDLCdOCLdCAW a0870271687 :c$12.50.a0870271679bpbk. an-us---ar------0 aQB36.P63bW54 1976 a919.8aB aCAWAlgift:Robert C. Miller:12sp8310aWillard, Berton C.00aRussell W. Porter, arctic explorer, artist, telescope maker /cby Berton C. Willard ; with a pref. by David O. Woodbury.0 aFreeport, Me. :bBond Wheelwright Co.,cc1976. axiii, 274 p. :bill. ;c24 cm. aBibliography: p. 269-274.10aPorter, Russell Williams,d1871-1949. 0aAstronomersxBiography. 0aPolar regionsxBiography. 0aArtistszUnited StatesxBiography. 0aTelescopes.

2 1

minor buuuug
by Md. Aftabuddin 18 Aug '02

18 Aug '02

1. If one has more than 10 entries for C++ in the koha database and if one is searching for C++ then in the search result he gets the first 10 results for C++ , but when he clicks on the next or 2, the search result shows for the keyword C. 2. When creating new member the confirmation page does not show the correct date of birth ,it is also not recording date of birth cottectly Md. Aftabuddin

1 0

Bangla , Hindi translation
by Md. Aftabuddin 17 Aug '02

17 Aug '02

INSTALL ----file translated in Bangla __________________________________________________________________ _________ Koha - Aabashyakata ebong drutho-aarombho pratisthapan niredeshaboli Otirikto tathaya jemon aaponar Configuration file kemon hobe, tar jonyo Hints file dehhoon. Proyojonio.... Sofolyer songe Koha byabohar korte hole kichu otirikto software proyojon: Ekti webserver ( Iha Apache-er sohit cholar jonyo gothito, kintu iha annyanya webserver byabohar kore na cholar kono karon nei ). Mysql ( Aaponi postgres athoba anayo sql dhormi database byabohar korte paren ). Perl (mod_perl er proyojoniota nei, jodio koha -r mod_perl er songe chola uchit -- drostobya je iha ekhono porikhito noy ). Perl Modules: Date::Manip DBI Set::Scalar DBD::mysql (ba onya je kono database ja aaponi byabohar koritechhen ) AuthenDBI (jodi aaponi Database jukto authentication byabohar korite chahen ) CDK (telnet interface er jonya proyojon kintu jodi aaponi web based circulation chhahen tobe nisproyojon) C CDK libraryguli o sthaponer proyojon http://www.vexus.ca/CDK.html ( CDKModule er sommasya aachhe ) -------------------------------------------------------------------------------- Druto - aarombho Protisthapan Nirdeshika 1. Ekti nuton mysql database toiaar koroon dhorun naam dilen Koha Nirdesh line hoite nirdesh likhun: mysqladmin -uroot -ppassword create Koha Koha bitoroner er sohit ekti database protisthaponer shell script deoa aachhe. 2. mysql e ekti Koha -r user ebong tar password toiaar koroon mysql e probesh koroon : mysql -uroot -ppassword jokhon "localhost" hoite nirdesh jari koritechhen "koha" namok ekti user "Koha" database e jar sompurno odhikar achhe toiaar korite , mysql nirdesh line e nimnolikhito nirdesh likhoon: grant all privileges on Koha.* to koha@localhost identified by 'kohapassword'; Enter teeponi tipoon, jodi aaaponi kono bibhanti na dekhen taha hoile \q likhia mysql hoite bahir hoiyaa jaan. 3. table guli toiaar korite mysql script byabohar koroon mysql -uusername -ppassword Koha < koha.mysql 4. koha.conf sompadona koroon database name er line e aaponar toiaar kora database er naam likhoon, hostname localhost hoyei thakbe ( jodi na aaponi database tee webserver chada annya kono machine e sthapon korite chaan ) user ebong password aaponar toiaar kora database er username ebong password er motoi hoibe. Output.pm file e path poriborton korar poriborte apponi koha.conf file e "includes= " ebong aaponar includes folder er path likhte paren - Hints file e udaharan dekhoon. 5. koha.conf fileteeke /etc/ te copy koroon koha.conf file er anumoti hoibe kothor, kenona fileteete datbase er password thake. compokhhe, apache user jeno iha podite pare, ebong annya je kono user jini circ run koriben. Aamar prostab je www-data.libadmins e others er kono rokom odhikaar thakbe na. libadmins e somostho koha byabohar karira thaken. (Jodi aaponi www-data ke owner koren tobe apache ke www-data hisabei chalate hoibe) 6. Aaponar database table guli update korun perl -I modules/ scripts/updater/updatedatabase 7. Scripts and html documents er jonya directory guli toiaar korun. Ekhane aaponake thik korite hoibe je kothay aaponar scripts ebong html file guli thakibe. Ebong seimoto modules/C4/Output.pm file teete poriborton korun. Set $path= jekhane aaponar includes aache' udaharon swarup: $path="/usr/local/www/koha/htdocs/includes"; Aaponake uha korite hoibena jodi aaponi etipurbei koha.conf file e includes er path nathi boddho koria thaken ( oporer udaharon dekhun) Tarpor C4 directory tike (modules/ er moddhey) aaponar perl path e kothao copy koroon jemon /usr/local/lib/site_perl/i386-linux/ Jodi aaponar default perl folder e file copy koribar porjapto odhikar na thake ( hoite pare je aaponi aaponar ISP er hosting server byabohar koritechen) tobe aaponi jekono sthane module guli copy koroon ebong apache.conf file e ekti line jogg koroon jemon : SetEnv PERL5LIB "/usr/local/www/koha/modules" C4 directory tike modules folder e copy koroon (Hints file e bistarito udahoron dekhoon) 8. Aaponar Online Public Access Catalogue (OPAC) gothon koroon OPAC er jonyo ekti webspace gothon koroon: udahoron sworup : Aaponi /usr/local/www/opac ... toiaar korite paren ebong apache te sei directory byabohar koribar jonyo ekti virtual host gothon korite paren Aaponar opac directory er moddhey htdocs name ekti directory toiaar koroon ebong opac-html/ er sobkichhu uhate copy koroon. Aabar aaponar opac directory er moddhey cgi-bin name ekti directory toiaar koroon ebong opac-cgi/ e .pl extension jokto file guli uhate copy koroon, jemon copy opac-cgi/*.pl /usr/local/www/opac/cgi-bin/koha/ Aaponar gothito virtualhost khanikti eirokom hobe: <VirtualHost opac.aaponar.site> ServerAdmin webmaster(a)aaponar.site DocumentRoot /usr/local/www/opac/htdocs ScriptAlias /cgi-bin/koha/ /usr/local/www/opac/cgi-bin/ ServerName opac.aaponar.site ErrorLog logs/opac-error_log TransferLog logs/opac-access_log </VirtualHost> Kora hoile, punoray apache aarombho koroon ebong browser e opac.aaponar.site er thikana likhoon ebong ihatei dekhite paowa uchit (kintu database e kono data na thakle bishes kichu dekhibar thakibe na !) Hints file e otirikto nirdesh ebong config udahoron guli dekhoon 9. intranet/librarian interface gothon koroon Anaya ekti webspace dhorun koha gothon korite notun directory guli toiyari koroon ebong httpd.conf file e otirickto poriborton guli koroon. Udhahoron swarup : Je directory ti aaponi ekhoni toiari koriachen tar moddhey ekti htdocs ebong ekti cgi-bin directory toiyari koroon intranet-html/ directory er somostho kichu htdocs directory te copy koroon intranet-cgi/ directory er somostho .pl file guli cgi-bin/koha directory te copy koroon Aaponar virtual host je ei somosto directory guli bayabohar korite paribe sei bayapar e nischito houn Punoray apache aarombho koroon ebong browser e koha.aaponar.site er thikana likhoon ebong ihatei dekhite paowa uchit 10. Librarians/Intranet Interface er SECURITY Configure koroon Jodi aaponi authentication er jonyo AuthenDBI bayabohar koritechen tahole, aaponake koha database er users table e kichu user jogg korite hoibe. ebong intranet site er jonyo jahate AuthenDBI bayabohar kora jai apache er conf file edit kotite hoibe. Annoyothay, koha/htdocs/ ebong koha/cgi-bin directory gulite htaccess file guli gothon koroon Aaponi sadharon .htaccess jonito surakhsha byabostha grahan korite paren. librarian er interface er jodio password jukto surakhsha byabostha er proyojon karon ei sthan hoite aaponi item guli jogg korite ba muchia felite paren, sadasyader jorimana mokub kirite paren ebong sadharon bhabe bipotti ghotate paren. 11. Prodan, Feroth ebong Telnet interface Jehetu aamora aagei scripts/C4 directory theke file guli aamader perl source tree te kothao copy korechi Aamader ekon sudhu matro proyojon scripts/telnet/ theke scripts ke perl er path jemon /usr/local/bin e copy kora Taha hoilei hoiya jaibe : circ type koroon ebong prodan o feroth er jonya prostut. Release 1.1.0 hoite tothay ekti web-based circulation module aache, sutorang prodan ebong feroth sekhan theke aothoba circ theke kora jaaibe. Aaponi kichu config udaharon Hints file e paaiben ____________________________________________________- Md. Aftabuddin

1 0

Bangla , Hindi translation
by Md. Aftabuddin 17 Aug '02

17 Aug '02

README ----file translated in Bangla ___________________________________________________________________________ 30/7/2002 aftab(a)cubmb.ernet.in Koha GPL licence er odhine bitorito hoi, bishod biboroner jonney doya koria LICENSE file porun. Jodi aaponi Linux systeme Koha sthapon korite chahen, taha hoile directory moddhey "installer.pl" script chalan. Aaponi INSTALL file porite paren jodi manual bhabe sthaponer nirdesh chaan. ____________________________________________________- README file translated to Hindi _____________________________________________________________________________ 30/7/00 aftab(a)cubmb.ernet.in Koha bitaran hota hai GPL lisence ke adhin, kripa karke bishad bibaran ke liye LICENCE nathi padhiye. Yadi aap Linux System per Koha sthapan karna chahatain hain, to yeh directory mai "installer.pl" run kijiae. Aap manually sthapana ke liye INSTALL nathi bhi padh saktain hain. ____________________________________________________________________________ Md.Aftabuddin

1 0

From the Kaitiaki
by Pat Eyler 17 Aug '02

17 Aug '02

Aug 17, 2002 To the Koha community; Hello all, No note last week, and a late note this week. My life has been a bit turbulent of late, and I'm afraid that this note is one of the things which has slipped. Given the slower pace of activity during the summer months and my own reduced amount of time to work on things Koha, I'm going to be writing this note on a bi-weekly basis going forward. 1.2 Steve has been pressing forward on the 1.2 tree and has just release RC10 of 1.2.3. This series represents quite a few pieces of new functionality and bear some good testing. If any of you have the time and resources to load it up and give it a try, your work would be appreciated. Community There's a nice new article about Koha in the offing. I've just seen a draft of it, and hope to see it in publication soon. If anyone else has the time and interest in writing about your experiences with Koha, I'd be happy to provide what help I'm able. I think that www.linuxgazette.com (or the Linux Journal, its 'big brother') would look kindly upon a well written submission. There are some interesting developments in the Library Free Software community. The most interesting to me has been the recent conversations in the MyLibrary project about how to proceed, how to set goals, and how to improve the quality of programming within the project. There are several ideas floating about, but I was intrigued at the idea of adding survey or logging to their software. This is obviously something that would need to be done very openly and very carefully to avoid any privacy or trust issues. My questions to you are: 1) What feedback should the Koha developers be getting to help steer future development of Koha? 2) How can we get that feedback frequently, but without causing undo work for our users or violating their privacy (or that of their patrons)? Translation As seen from recent postings to the Koha mailing list, our Hindi and Bengali translations have started. In addition, we now have two individuals in Germany who are working on translating Koha into German as well. Things are proceeding apace. As always, I'm excited to be a part of Koha's growing wave of success and popularity. I hope that everyone else is too. See you in two weeks. Thanks Pat Eyler Kaitiaki of the Koha Project

1 0

RE: [Koha] File definitions and Process - Checked by Vexira DEMO versio
by Williams, Olwen - SAL 16 Aug '02

16 Aug '02

I'm here and mostly lurking. I did reply before I came to work this morning, but didn't check where the message was going and it went privately. I wrote extracts to create files ready to import to Koha from the existing database. We managed to get it pretty clean after a few iterations. I just did tab delimited files. Branch transfers are for movements between branches. I may still have the diagrams I did for the original system. Time is a limited commodity at the moment, but ask if you have any questions and I may know the answer. -----Original Message----- From: Rachel Hamilton-Williams [mailto:rachel@katipo.co.nz] Sent: Friday, August 16, 2002 2:55 PM To: Owen Leonard; koha(a)lists.katipo.co.nz Subject: Re: [Koha] File definitions and Process - Checked by Vexira DEMO versio Hi - Just a quick message as I'm about to head off on holiday, we certainly have transfered information from a "full" library system, including reserves, members details, fines etc not just the biblio information. Hopefully Olwen who did this work is watching and may be able to share with you, otherwise please feel free to drop me a line and I'll pass it on.

1 0

File definitions and Process - Checked by Vexira DEMO version -
by Lauren Miller 16 Aug '02

16 Aug '02

Hi Everyone, Several weeks ago my co-worker Owen Leonard posted a message to the list asking for methodologies pertaining to the transition from one database to the KOHA database. In other words did you sit down and go through file printouts of each database and fit the puzzle together? Did you actually electronically dump the original database into KOHA and looked @ the results of what was missing? Or did you use another process. (Keep in mind I am not a techie--thanks!) Also, if you look at the index of all the KOHA files, for example -- branchtransfers--what is branchtransfers--what does that mean? There are many file names that we don't know what they mean--therefore we don't know if that file is important to us. Any help you can give us is appreciated greatly! Thank you and take care. Lauren Miller Librarian Athens County Library Services

4 3

Translation into German
by Sebastian Krieg 15 Aug '02

15 Aug '02

Hi Koha-list, I am from Germany and I want use Koha in a little library with over 6,000 media. That's why, I want translate Koha into German. Who can tell me, what's essential during translation. How can I translate the images? Thanks Sebastian -- Sebastian Krieg m@ilto: sebastian.krieg(a)tuz-eisenach.de

4 3

RE: [Koha] File definitions and Process - Checked by Vexira DEMO version -
by Bigwood, David 15 Aug '02

15 Aug '02

Lauren, When dealing with a file of MARC records there are some tools to find what fields have been used. MarcEdit will let you know which fields are used and how many times. You can also select a field and see what subfields are used in your file. http://ucs.orst.edu/~reeset/marcedit/html/index.html It is free. MARC RTP is also free and gives a more detailed report. It shows which fields and subfields in those fields are used in your file. It also shows the largest number of characters in each field. http://marc.ise.canberra.edu.au/ It is a good idea to run these on your database every so often, even if not moving it. It does show errors. For example, if 1 field 244 shows up and the number of records with field 245 is less than the total then that 244 most likely should be 245. Obsolete fields can be identified and either deleted or moved to another field. Sincerely, David Bigwood bigwood(a)lpi.usra.edu Lunar & Planetary Institute Cataloging news: http://www.catalogablog.blogspot.com -----Original Message----- From: Lauren Miller [mailto:lmiller@athenscounty.lib.oh.us] Sent: Thursday, August 15, 2002 10:41 AM To: koha(a)lists.katipo.co.nz Subject: [Koha] File definitions and Process - Checked by Vexira DEMO version - Hi Everyone, Several weeks ago my co-worker Owen Leonard posted a message to the list asking for methodologies pertaining to the transition from one database to the KOHA database. In other words did you sit down and go through file printouts of each database and fit the puzzle together? Did you actually electronically dump the original database into KOHA and looked @ the results of what was missing? Or did you use another process. (Keep in mind I am not a techie--thanks!) Also, if you look at the index of all the KOHA files, for example -- branchtransfers--what is branchtransfers--what does that mean? There are many file names that we don't know what they mean--therefore we don't know if that file is important to us. Any help you can give us is appreciated greatly! Thank you and take care. Lauren Miller Librarian Athens County Library Services _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Koha status
by Larry Currie 11 Aug '02

11 Aug '02

My systems administrator is trying to set up our Apache server from scratch, and he has run into difficulties as outlined below. Can anyone give him a hand with some troublshooting? I am also going to give him instructions for getting onto the koha support irc channel, so he may be going online to seek further assistance that way. His name is Stan Blum and his email address is sblum(a)calacademy.org. Larry Currie I did all the setup stuff for apache, but can't get it to start. I'm trying to run it on the second network card, which is 198.31.79.74 and has the name informatics.calacademy.org. There should be no other applications using this address. The apache error_log gives the following : getpeername: Socket operation on non-socket getsockname: Socket operation on non-socket Error getting local address I think this might mean that the second card is not "registered" in the appropriate configuration file for the operating system (it hasn't been used before). However, it does appear to be functioning because I can ping the IP address successfully from another machine (although I haven't yet tried unplugging the network cable and seeing if that disables ping-ability -- something I should probably test to ensure this ping response is from the right source.) When I run netstat -tnlc, I don't get any listings for the 198.31.79.74 IP address; just ...73 and the localhost. I'm not sure that's the right thing to check, but I thought I'd try it. BTW, no one will be able to see ...74 from the outside, or ping anything else, because of the firewall. If you could pass this info on to someone with redhat - apache experience, I think we could sort it out pretty quickly -- or at least get to the next step, the apache configuration file, which confuses me because it has separate entries for Listen (IP address:port) BindAddress, and Port I'm also not sure about the inetd versus standalone setting and the owner and group settings. -Stan

2 1