- Koha - lists.katipo.co.nz

Importing biblio fields from CSV
by Marty Jongepier 18 Feb '06

18 Feb '06

Hi all, I am trying to import biblio items (biblionumber, author and title is all I have) into Koha. It is in .dbf format and I can play around with it in Excel and change it into a CSV format. So far, so good. I imported 800 borrowers straight into MySql this way without a hitch, using LOAD DATA INFILE. All information shows up nicely in Koha. Now I tried the same thing with the only 3 fields I have for books, (biblionumber, author and title) but absolutely nothing shows up in Koha. It is present in MySql, I entered it into the biblio table. Did I miss something? I appreciate any help, I do not want to enter 6200 records by hand... Thanks, Marty Jongepier Blue Jay Design and Drafting

2 1

Getting there, but...
by Lenora Oftedahl 17 Feb '06

17 Feb '06

Hello all. I've been getting through the setup process and have actually managed to function in Koha for a week. Now, how do I localize catalog displays? Specifically, how can I get the call number to show up in record displays? Thanx. Lenora -- *************************************** Lenora A. Oftedahl, StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission 729 NE Oregon St, Ste 190 Portland, OR 97232 503-736-3581 / ARIEL: 207.173.155.8 503-731-1260 FAX OFTL(a)critfc.org http://www.fishlib.org ************************************* "One by one, the penguins are stealing my sanity" ************************************** "Don't worry about the world coming to an end today. It's already tomorrow in Australia." --(Charles Schultz) ************************************** "The problem with adults is that they are contaminated by experience." --Kumi Naidoo, General Secretary and CEO of CIVICUS **************************************

1 0

Re: Re: [Koha] Re: Advice on MARC21 fields
by Steven F.Baljkas 17 Feb '06

17 Feb '06

Thursday, February 16, 2006 19:21 CST Greetings again, Rodica, Just a quick addendum to Stephen Hedge's answer (I actually haven't received your original message quoted in Stephen's reply on the listserv, which is kinda weird since I did get your other message okay) ... > From: "Stephen Hedges" <shedges(a)skemotah.com> > Date: 2006/02/15 Wed AM 11:55:26 CST > To: "Balasa Rodica" <rodica.balasa(a)nemesisit.ro> > CC: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Re: Advice on MARC21 fields > > Basically, USMARC is the "old" MARC 21. See > http://www.loc.gov/marc/annmarc21.html The official party-line is that MARC21 represents the harmonization of USMARC and CAN/MARC. (Actually, Stephen, there is a lot more of CAN/MARC in MARC21 then you would find pure USMARC. But that's only visible in minutia.) Also note, that UKMARC is coming together with it, too. Whatever Australians called their national version of MARC was already so close to the harmonized achievement as to make no significant difference (one of the benefits doubtless of being the Aussies being the only folks actually to use AACR as it is written without trying to write themselves permissions for archaic, institutionalised, idiosyncratic practices as "Babylon on the Potomac" is wont to, copied in smaller part by whatever we're supposed to call the NLC this week ;-) ). In any case, MARC21 is emerging as a global standard, one that will likely surpass internationalist efforts at maintaining UNIMARC. As for standards for MARC21, Rodica, there may be Romanian national conventions for coding in various fields, etc. Your national library's cataloguing department/service should be able to advise you on that. They should also have information on any definitions of terminologies that may not be immediately familiar to you. You should feel free to ask on this listserv, too, or better yet subscribe to a cataloguing listserv and try there. And Google is great for finding relevant library science terminology. If you need information on MARC21 standards, there are, of course the volumes that you can purchase from the Cataloguing Services Directorate at LC. However, you can access a good deal of the same information, including examples of application, online for free. For Bibliographic Format (what you need to describe monographs, etc.), surf to URL <http://www.loc.gov/marc/bibliographic/ecbdhome.html> If you have specific questions, feel free to e-mail me on or off listserv as you like (off listserv is probably better as the Koha listserv is not really for cataloguing questions per se). Hope this addendum helps a bit. Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ========================================================================== Balasa Rodica said: > > Hello, > > I come back with more specific questions. > > I corresponded with another university in Romania, that has implemented > another system (MicroVTLS.), and the information is stored in USMARC. > Are there differences between USMARC and MARC21? Maybe there are chances > that for Romanian books, to import some of the definitions from this > source. > > Generally at Koha installation, everybody uses the default Koha > configuration for MARC21, or are some changes required? > > Thank you, > > Rodica Balasa ____________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ============================================================

1 0

Re: [Koha] Advice on MARC21 fields
by Steven F.Baljkas 16 Feb '06

16 Feb '06

Thursday, February 16, 2006 13:16 CST Greetings, Rodica, Sorry for the delay in responding to your message. Below you will find response to your original question/s as well as some advice on cataloguing matters I felt were related and worthy of your attention at this phase of your Koha automation. Since you are using MARC21 records, your most likely sources will be North American libraries, particularly the Library of Congress. MIT would also probably be a very good source. Given that many books published in the U.S.A. are simultaneously published in Canada, Canada's national library also has them in our national union catalogue, which may facilitate cataloguing for you at your institute. The reason for that is that, unlike LC, Canada's national library allows for batch searching for individual records via its free (registered) AMICUS service. That is, you can search for each record individually, but keep the results for download and further editing/adjustment in batches. Although some Koha-ites would recommend using computer scripts to locate books by ISBNs, as a cataloguing purist I would continue to hold that you are best served by ensuring that you have found a correct and quality record for each title in your collection. AMICUS helps with that by allowing you to see the actual MARC cataloguing copy before ultimate selection of the record. Using a script, at best, you may have the first though not often the best record. At worst, you may get false negative returns (i.e. if the ISBN has been omitted or miscoded for some reason -- and it does happen more often than people would choose to admit freely -- the search will say the book record does not exist when in fact it does and only requires that field be added) and false positive ones (where an incorrect edition or even incorrect work is retrieved: and yes, it does happen that the supposedly unique ISBNs are accidentally assigned to different works). In any case, that is my little (partially self-serving but genuinely sincere) promotion for 'traditional' catalogue record searching. As for AMICUS, if you want to find out more about how it might help you at IMAR, you can surf to URL <http://www.collectionscanada.ca/amicus/006002-122-e.html> to learn about it and sign up if you so choose. (Regarding the requirement to sign-up, I can tell you honestly that in the several years I have belonged, they have never bothered me with any unwanted mailings; in fact, the only contact has been to advise of service upgrade downtimes and otherwise unscheduled service downtimes, and that only 2 times so far). In terms of cataloguing issues, I should mention that with mathematical works -- and scientific monographs in general -- ***you need to consider carefully whether you will be using the LC subject headings (LCSH) or a specialised thesaurus.*** It is likely that LC and other libraries (CISTI, MIT, e.g.) have MARC cataloguing your works; it may be much less likely that they have used anything other than LCSH for subject analysis. Although the terminologies may be similar, you may find it better to structure your own thesaurus for local use. Given Koha's present problems with understanding any subfields beyond the initial 650$a properly (and Paul Poulain's suggested work around is not valid: it violates MARC standards by including perforce two $a's - a Non-Repeating Subfield -- in a given 650), ***you may want to make use of your time to add to your records keyword terms that will be meaningful and useful to your library patrons and have those linked to Koha for searchability***. This is just a suggestion but you may find it helpful in the long run. Finally, while it is important to configure Koha carefully (MARC on/off, MARC21 or UNIMARC flavour, and so on), I was unsure what you meant about "control fields". ***At present, Koha does not make use of what are commonly called control fields (in cataloguing terminology, Leader to 008 inclusive). That is something still coming in the future. As things stand now, any info in those fields is effectively lost to Koha.*** In terms of things you would want to configure carefully, though, if you are using the visually appealing NPL template of Koha, be aware that you will need to set up your ItemTypes very carefully, decide on/design appropriate icons for the graphic display, and ***code 942 fields in each MARC record as appropriate for the item in hand.*** That will add to your cataloguing work time but you may find it well work the extra effort. I hope that this information has helped somewhat. If you would like me to run a test of AMICUS to see what kind of success it would have in retrieving suitable records for you, please feel free to contact me off listserv so we can set up a test base. In the meantime, welcome to the Koha community and best of luck with your efforts in automating your library at IMAR using Koha! Cheers, Steven F. Baljkas library tech at large Koha neophyte Winnipeg, MB, Canada ============================================================ From: Balasa Rodica <rodica.balasa(a)nemesisit.ro> Date: 2006/02/09 Thu AM 08:00:12 CST To: koha(a)lists.katipo.co.nz Subject: [Koha] Advice on MARC21 fields Hello everybody, I write hoping that you could help us with advice about MARC21 configuration. My name is Rodica Balasa, Project Manager at Nemesis IT from Bucharest, Romania. We are helping IMAR (Romanian Institute of Mathematics) to install Koha for library management. Currently the library catalog is recorded in writing (no database), so it is important that the MARC description of most of the books to be downloaded from the z39.50 public servers. We arrived at the point of configuring the MARC21 control fields, and as I understand that the choices we make are very important, I thought of asking for advice other libraries that have more experience with Koha. Thank you very much! Rodica Balasa ______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ============================================================

1 0

Member number is not auto-calculated
by Tarek Mehrem 16 Feb '06

16 Feb '06

Hi every one, My name is Tarek Mehrem, Egyptian. I've been using Koha since 2003 and i find it a very good system. I have this problem: I'm using Koha 2.2.4, but whenever i add a new member i find the auto-caculated number is not working although it is on and i have to put any number. Does any one know the solution? Best regards Tarek Mehrem BUE Librarian

1 0

Question
by David Ochieng 16 Feb '06

16 Feb '06

Hi Chris, I have KOHA 2.2.5; I would like users to log in with their details in active directory. Do you have any ideas? Regards, David Ochieng Strathmore University

1 0

Advice on MARC21 fields
by Balasa Rodica 15 Feb '06

15 Feb '06

Hello everybody, I write hoping that you could help us with advice about MARC21 configuration. My name is Rodica Balasa, Project Manager at Nemesis IT from Bucharest, Romania. We are helping IMAR (Romanian Institute of Mathematics) to install Koha for library management. Currently the library catalog is recorded in writing (no database), so it is important that the MARC description of most of the books to be downloaded from the z39.50 public servers. We arrived at the point of configuring the MARC21 control fields, and as I understand that the choices we make are very important, I thought of asking for advice other libraries that have more experience with Koha. Thank you very much! Rodica Balasa

2 2

Koha httpd.conf for Windows
by Amzari Abu Bakar 15 Feb '06

15 Feb '06

If you have set Koha in windows, first try check your Apache version. You can use version 2.0.54. As I have no problem with this version. Before this, I have try with later version, and find out it didn't work. You should also use mysql version 4.0.15. I assume you have install perl module, and install Koha from Koha for windows setup. If you have do so, you can add following lines to your httpd.conf under VirtualHost section (This one, works for me): #Listen to port 8080 Listen 8080 #Set VirtualHost for OPAC and INTRANET NameVirtualHost localhost NameVirtualHost localhost:8080 #KOHA OPAC 224 Virtual Host <VirtualHost localhost> ServerAdmin webmaster@dummy-opac DocumentRoot /usr/koha224/opac/htdocs ScriptAlias /cgi-bin/ /usr/koha224/opac/cgi-bin/ ServerName localhost ErrorLog logs/opac224-error_log CustomLog logs/opac224-access_log common SetEnv PERL5LIB "c:/usr/koha224/intranet/modules" </VirtualHost> #KOHA INTRANET 224 Virtual Host <VirtualHost localhost:8080> ServerAdmin webmaster@dummy-opac DocumentRoot /usr/koha225/intranet/htdocs ScriptAlias /cgi-bin/ /usr/koha224/intranet/cgi-bin/ ServerName localhost:8080 ErrorLog logs/intranet224-error_log CustomLog logs/intranet224-access_log common SetEnv PERL5LIB "c:/usr/koha224/intranet/modules" </VirtualHost> Change Listen 127.0.0.1:80 TO Listen 80 Good Luck. Amzari FingerClcik Solutions --- koha-request(a)lists.katipo.co.nz wrote: > Send Koha mailing list submissions to > koha(a)lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, > visit > http://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body > 'help' to > koha-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)lists.katipo.co.nz > > When replying, please edit your Subject line so it > is more specific > than "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Issues with Koha 2.2.4 Installation on windows > (Juvenal Sahiri) > 2. Subject-problem (Unni Knutsen) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 1 Feb 2006 20:20:26 -0800 (PST) > From: Juvenal Sahiri <jsahiri(a)yahoo.com> > Subject: [Koha] Issues with Koha 2.2.4 Installation > on windows > To: koha(a)lists.katipo.co.nz > Message-ID: > <20060202042026.18962.qmail(a)web30810.mail.mud.yahoo.com> > Content-Type: text/plain; charset=iso-8859-1 > > I just sent this message to Amzari Abu Bakar > amzari79(a)yahoo.com after reading the posting on > upgrading from 2.2.4 to 2.2.5. May be you can help: > > Quote" > In the course of trying to get my Koha 2.2.4 > installation to work, I came across your posting on > [Koha] Koha Installation Upgrade 2.2.4 to 2.2.5 > Windows > Amzari Abu Bakar amzari79 at yahoo.com > Mon Jan 23 23:26:38 NZDT 2006 > > The problem I was trying to solve is that entering > opac in the url gives me blank "page not found" > while > http://localhost:8080/ gives me the OPAC library > visitor > page where I can submit a search. > > But I never succeeded in getting the intranet page, > no > matter what I tried. > > Here is the content of my koha.config in etc and and > httpd.config in apache. > > koha.config: > database=blank224 > hostname=localhost > user=koha > pass=koha > intranetdir=c:\usr\koha224\intranet > opacdir=c:\usr\koha224\opac > kohaversion=2.2.4 > opachtdocs=c:\usr\koha224\opac\htdocs\opac-tmpl > intrahtdocs=c:\usr\koha224\intranet\htdocs\intranet-tmpl > includes=c:\usr\koha224\intranet\htdocs\intranet-tmpl\default\en\includes > > ==== > httpd.config in apache: > Listen 127.0.0.1:8080 > > NameVirtualHost * > > <VirtualHost _default_:*> > ServerAdmin webmaster@dummy-opac > DocumentRoot /usr/koha224/opac/htdocs > ScriptAlias /cgi-bin/ > /usr/koha224/opac/cgi-bin/ > ServerName opac > ErrorLog logs/opac-error_log > CustomLog logs/opac-access_log common > SetEnv PERL5LIB > "c:/usr/koha224/intranet/modules" > </VirtualHost> > > <VirtualHost *> > ServerAdmin webmaster@dummy-opac > DocumentRoot /usr/koha224/opac/htdocs > ScriptAlias /cgi-bin/ > /usr/koha224/opac/cgi-bin/ > ServerName opac > ErrorLog logs/opac-error_log > CustomLog logs/opac-access_log common > SetEnv PERL5LIB > "c:/usr/koha224/intranet/modules" > </VirtualHost> > > <VirtualHost *> > ServerAdmin webmaster@dummy-opac > DocumentRoot /usr/koha224/intranet/htdocs > ScriptAlias /cgi-bin/ > /usr/koha224/intranet/cgi-bin/ > ServerName intranet > ErrorLog logs/intranet-error_log > CustomLog logs/intranet-access_log common > SetEnv PERL5LIB > "c:/usr/koha224/intranet/modules" > </VirtualHost> > > I changed these values to those in your posting on > the > discussion list except for 2.2.5 which I kept as > 2.2.4 > > It didn't make a difference. > > Appreciate your help > > Best regards > Juvenal __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

Making Koha Live using Free DynDNS (Windows Installation)
by Amzari Abu Bakar 15 Feb '06

15 Feb '06

Ok, next you need to add the following lines to httpd.conf (you can find it in c:\Program Files\Apache Group\Apache2\conf\ directory-default installation). Add the following lines under Virtual Host Section. #Listen to port 8080 Listen 8080 #Set VirtualHost for OPAC and INTRANET NameVirtualHost muthamizh.mine.nu NameVirtualHost muthamizh.mine.nu #KOHA OPAC 224 Virtual Host <VirtualHost muthamizh.mine.nu> ServerAdmin webmaster@dummy-opac DocumentRoot /usr/koha224/opac/htdocs ScriptAlias /cgi-bin/ /usr/koha224/opac/cgi-bin/ ServerName muthamizh.mine.nu ErrorLog logs/opac224-error_log CustomLog logs/opac224-access_log common SetEnv PERL5LIB "c:/usr/koha224/intranet/modules" </VirtualHost> #KOHA INTRANET 224 Virtual Host <VirtualHost muthamizh.mine.nu:8080> ServerAdmin webmaster@dummy-opac DocumentRoot /usr/koha225/intranet/htdocs ScriptAlias /cgi-bin/ /usr/koha224/intranet/cgi-bin/ ServerName muthamizh.mine.nu:8080 ErrorLog logs/intranet224-error_log CustomLog logs/intranet224-access_log common SetEnv PERL5LIB "c:/usr/koha224/intranet/modules" </VirtualHost> Save httpd.conf and restart your Apache. Run your DynDNS Updater. Then try to access your OPAC at http://muthamizh.mine.nu and INTRANET at http://muthamizh.mine.nu:8080 Make sure you enable your windows firewall with exception on port 80 and 8080 to minimize outside attacks. Good Luck. Amzari Abu Bakar FingerClick Solutions. --- Elanjelian Venugopal <tamiliam(a)gmail.com> wrote: > Hey Amzari, > > Thanks for your instructions. I have apache 2.0.54 > installed. And, as > you have asked, I've registered with dyndns folks, > created a domain > name: muthamizh.mine.nu and downloaded the updater. > What should I do > next. > > Thanks in advance. > elan. > > On 10/02/06, Amzari Abu Bakar <amzari79(a)yahoo.com> > wrote: > > Elan, > > > > Sorry for late reply. Got a bit bz several days. I > > have got your earlier email. The instruction for > > making your OPAC live a bit long. But I try to > make > > it simpler. > > > > 1st. I assume you have install Koha, Apache and > MySQL > > especially Apache 2.0.54. You need to do some > changes > > to httpd.conf. If you have install Apache 1.3.33, > the > > configuration is a bit difference especially in > > virtual host configuration. > > > > 2nd. For a start, you can register an account with > > www.dyndns.org and download the update client. It > is > > free. You can also register for dynamic dns. eg: > > myopacname.dyndns.org. Tell me if you have do so. > I'll > > give you the following instruction. > > > > Amzari. > > FingerClick Solutions. > > > > --- Elanjelian Venugopal <tamiliam(a)gmail.com> > wrote: > > > > > Amzari, > > > > > > did you get my earlier email to you (attached > > > below)? Just checking... > > > > > > elan > > > > > > > > > On 04/02/06, Amzari Abu Bakar > <amzari79(a)yahoo.com> > > > wrote: > > > > > > I am also planning to make Koha Malay > translation. > > > And > > > Arabic translation if I have more resources. > Maybe, > > > if > > > the time arrived, we can put into workshop and > > > invite > > > you to share the experience with us (ofcourse > with > > > some payment). Anyway, it's depend on time and > > > resources. > > > > > > Sure. I'd be more than happy to share my > > > experiences. Don't worry > > > about the payment, etc. I am Open Source junkie > of > > > sorts. Having been > > > using Open Source stuff since PhpNuke 5.0. > Anyway, > > > translating Koha to > > > Malay should be very easy, as there is no > encoding > > > problem. Arabic, > > > however, could be tricky, as I think, it can > only be > > > viewed in UTF-8. > > > There are MARC related problems. > > > > > > There are two options: 1) using tmpl_process3.pl > to > > > create the .po > > > files that could be translated using PoEdit; 2) > > > going directly to the > > > invidial Opac and Intranet files and translating > the > > > strings. (For > > > Arabic, you'd need the BabelPad.) > > > > > > Option 1 is better for the long term, as > migration / > > > upgrade is easily > > > accomplished, as you may use auto translating > > > features of PoEdit. > > > Option 2, however, is somewhat easier, and the > > > traslation outcome tend > > > be better as you would have a better sense of > the > > > context. Plus in > > > Windows environment tmpl_process3.pl doesn't > seem to > > > work quite right > > > :( > > > > > > > > > > > > I would be glad to assist you in server > > > installation. > > > What kind of server and network infrastructure > do > > > you > > > have? OSes? If you are have installed Koha on > > > Win2k/XP/2003 platform, I can propose for you to > use > > > dynamic DNS. It is free. You just need at least > > > dedicated Broadband for your site to become > alive. > > > (For linux, I still figuring how to make DynDNS > > > work). > > > Email me if you are interested. > > > > > > It's an XP machine. No broadband connection, > yet, > > > but that could be > > > arranged. If you could provide me the steps -- > or > > > the procedures -- > > > involved, I'd be greatly delighted. > > > > > > My contact: 012-337 5709. Just in case :) > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

Setting of renewal period
by vimal kumar 15 Feb '06

15 Feb '06

Dear users, I am using Koha 2.2.4 version in Linux platform. In present situation Koha can only renew the item for default loan length. How can I set renewal period to days I want? Is it possible in this version (2.2.4)? If not, I expect this facility in coming 3.0 version. Vimal Kumar Asian School of Business Technopark Trivandrum-695 581 vimal0212(a)yahoo.com --------------------------------- Yahoo! Mail Use Photomail to share photos without annoying attachments.

1 0