- Koha - lists.katipo.co.nz

Can you direct me to any resources that might explain MARC import and uploading. I have been placing
by Tammi Moe 17 May '04

17 May '04

Can you direct me to any resources that might explain MARC import and uploading. I have been placing MARC records, both copy and manual, into the farm and when searching the catalog there are no return records. Thanks for your help, Tammi Moe

3 2

Newbie question - Installating KOHA on a share hosting
by Octavian, Yuan (CIFOR) 17 May '04

17 May '04

Dear all, I finally manage to install KOHA on my local PC using win.XP as the operating system. Right now I'm trying to install KOHA on a share hosting. Since I don't have the super user access I'm trying to install KOHA using the manual on how to install KOHA without root. There are several questions that I like to ask: 1. The share hosting did not have several perl modules which are needed by KOHA, is there a way to solve this problem? 2. The manual ask me to arrange for a user called opac and set the user in the OPAC virtual host. Could anyone explain what kind of user? Is it a mysql user or a user on the share hosting (linux user)? I can only access the hosting using Cpanel + FTP, I have no SSH access, so I don't think I have the access to create a user. Is there a way to solve this problem? 3. The manual ask me to Copy koha distro koha\* into /pathto/cgi-bin/oadmin (including C4 directory and its contents). I get confious because the manual never ask me to make /pathto/cgi-bin/oadmin, the manual ask me only to make /pathto/cgi-bin/koha and /pathto/cgi-bin/koha/C4. And what does it mean by distro koha\*, does it mean the whole directory and file extracted from the koha-1.2.3.tar? cheers, yuan

2 1

RE: [Koha] Koha in Linux Festival
by Han, Yan 12 May '04

12 May '04

Use the sampledata-1.2 with Koha2.0 package. The only thing that you should know is to update 3 records from line 2248 (for Table "borrowers"). (which mismatching the number of column). See my message before, YH -----Original Message----- From: Zeki Celikbas [mailto:celikbas@itu.edu.tr] Sent: Monday, May 10, 2004 5:27 AM To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha in Linux Festival Hi MJ Ray, Some friends contact me to supply sample data. I'm still waiting but manualy data entry options is always open for me :-) On 10 May 2004 at 10:44, MJ Ray wrote: > On 2004-05-06 15:27:56 +0100 Zeki Celikbas <celikbas(a)itu.edu.tr> > wrote: > > > 2. Some sample data (sql format). > > Sorry, I'm not going to do this in time. The database which I can use > for this still seems to be 1.9.x and doesn't import into 2.0.0 > cleanly. I don't have time to upgrade/investigate/fix just now. I hope > that someone else can help you. > > -- > MJR/slef > My Opinion Only and possibly not of any group I know. > http://mjr.towers.org.uk/ > http://www.ttllp.co.uk/ for creative copyleft computing > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha Zeki Celikbas ITU Ucak ve Uzay Bilimleri Fakultesi 34460 Maslak Istanbul celikbas(a)itu.edu.tr t:(0212)2853108 _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Question about bulkmarcimport.pl
by Gregory Garretson 11 May '04

11 May '04

Hello, all, I'm slowly getting my head around how 2.0 works, but I keep running into things that stump me. I hope someone can help. I am trying to import MARC records into the database; following Stephen Hedges' good advice, I've used bulkmarcimport.pl to import them. This is totally successful as far as the biblio information is concerned. However, I'm having a problem with holdings information. The problem is that, apparently, although each time the script (bulkmarcimport.pl) inputs a record, it creates *two* items. Well, actually it inserts only one entry into the 'items' table, as should be, but two sets of entries into the 'marc_subfield_table' corresponding to the holdings tags I've used. Here's an example: mysql> select subfieldid, bibid, tag, tagorder, subfieldcode, subfieldvalue from marc_subfield_table where bibid=2; +------------+-------+-----+----------+--------------+-----------------------------------------------------------------+ | subfieldid | bibid | tag | tagorder | subfieldcode | subfieldvalue | +------------+-------+-----+----------+--------------+-----------------------------------------------------------------+ | 177 | 2 | 300 | 9 | f | BOOK | | 176 | 2 | 260 | 8 | c | 1987 | | 175 | 2 | 245 | 7 | a | Reading and Writing Disorders in Different Orthographic Systems | | 14 | 2 | 952 | 6 | b | 1 | | 15 | 2 | 952 | 6 | d | 1 | | 174 | 2 | 100 | 6 | a | Aaron, P.G. (Ed.) | | 18 | 2 | 952 | 8 | b | 1 | | 19 | 2 | 952 | 8 | d | 1 | | 20 | 2 | 952 | 8 | u | 1 | | 178 | 2 | 852 | 14 | k | LB1050.5.N33 | | 179 | 2 | 090 | 15 | c | 2 | | 180 | 2 | 090 | 15 | d | 2 | +------------+-------+-----+----------+--------------+-----------------------------------------------------------------+ The result is that a catalog search shows each biblio having two items, (one with an itemnumber, and one without, I think). Unless someone else has noticed a problem with this script, I figure that I'm inputting my holdings information wrong. I've mapped tag 852 k (my call number) onto 'biblioitems.classification', and 952 b and d onto 'items.homebranch' and 'items.holdingbranch', respectively. (These last two each have a value of "1", the intent being to record that we have one copy in our main library.) Can anyone tell me what I'm doing wrong? Thanks, Gregory Garretson linguist-turned-bewildered-librarian Boston University

1 0

Koha translation to Spanish
by J0se 11 May '04

11 May '04

Hi all, I'm doing the translation by myself, since i'm in a hurry about this. I've finished translating the .tmpl archives(templates no?) in OPAC and Intranet html directories I hope this is the way to do it, and I would like to know what is next, how do I make 'em visible or how do I use this new templates, I think I have to put them in the same directory where "en", "fr", etc, directories goes. Isn't it? Another thing...while I'm editing the text, the images aren't shown, I know that I have to change/translate them too, I thing Fireworks program will be okay for that. Will images be displayed as normal when I finish the job? OK thanx J0se

1 0

koha setup: problems, information request for barcode
by vijay.kankipati＠tcs.com 10 May '04

10 May '04

Dear Koha-Community, First of all, thank you very much for a wonderful open-source library automation software. We are setting up 'koha' in our office library. As part of this, we installed 'Koha 2.0' and the DB being mySQL on RedHat 9.0. Here, we're having few concerns: 1. Is there a screen through which, we can 'Issue a book?'. We tried and found a screen like that. But, has not been able to figure out, how exactly, we say 'issue a book' 2. Is it mandatory to use 'barcode system' to issue books?. If yes, could you please provide any links/resources from which we can have technical specifications of the barcode to be acquired for the s/w setup. Thanks, Vijay "The oppressive atmosphere in most large companies resembles downtown Calcutta in summer. We intellectualise a lot in management. But if you walk into a factory or a unit , within the first 15 minutes you get a smell of the place." - late Sumantra Ghosal _____________________________________ Vijay Kankipati, II-N2-24, CSG-SPICE, Tata Consultancy Services, 1, Software Units Layout, Madhapur, HYDERABAD - 500 081, India. Phone: +91-40-5567-2227/30; Mailto: vijay.kankipati(a)tcs.com; Website: http://www.tcs.com

2 1

News from the CVS (future Koha 2.2)
by paul POULAIN 10 May '04

10 May '04

Hi everybody, Some news of the CVS version, that will become version 2.2 (in September, wait for december for libraries that want something heavily tested). What's already done : * MARC search merged with non-MARC search. It's really more easy to use with 1 form only ! You can also order the result (by title, author, dewey, publisher, publicationyear) * Search tools have been reworked. Search on Nelsonville DB (140 000 biblios, 290 000 items) is instantaneous for searchs with a few results. The search needs some seconds when there is a lot of results. We will probably limit the number of results to 200. * The OPAC search and the librarian search have been merged. In 2.0, we sometimes had differents results, that was really not funny ;-) * Some improvements have been realised in members interface. It's mostly code reorganizing, the user should see only a few differences. * Nelsonville did a few changes on z3950 servers. * Issuing rules : the code for issuing has been completly reorganized/rewritten. The 1st goal is to be able to have issuing max & length defined for a given branch / item type / borrower type. The 2nd goal is to have a clear & documented code to be able to modify it easily. So a library with really specific rules should be able to add it's own in Koha. * The librarian interface produces better HTML code. Almost XHMLT compliant. What is decided & affected : * Cataloguing framework : a great improvement !!! In 2.2, the library will be able to define a MARC framework for each itemtype. You will be able to define a MARC form for monography, one for serials, one for CD, multimedia... Each framework will have it's own cataloguing rules. Really a great improvement !!! And fully compatible with 2.0 database * MARC authority : in Koha 2.0, authorities are poorly handled. In 2.2, full MARC support will be provided. * export of biblios in OPAC in iso2709 or human readable form, to a mail address, or by http download. * Serial module : subscribing, cataloguing... serials. important notes : * for MARC authority, functionnal needs are specified for UNIMARC. We will need some help to validate it for MARC21 too. * all the decided & affected feature described in this mail are funded by "Ecole des Mines de Paris". Either by direct funding, or through a developper they have hired, since May, 1st, for 4-6 months. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Koha in Linux Festival
by Zeki Celikbas 10 May '04

10 May '04

Hi All, There will be a linux festival (http://senlik.linux.org.tr/2004/) in the Ankara the capital of Turkey next week at 13-16 May . a linux association organizing this festival every year and this will be the third and will be held in the national library. They have contacted with me to speak about the Koha Library Automation System. I'm working with this associations sometimes about the free softwares in library world like koha or greenstone. I've setup the koha and preparing some document to tell them. They will build an internet cafee in the festival area and I'm planning to set up Koha one of this computers to online demo to participants who wants to play. But I need some helps blow: 1. The name of the institutes using Koha for examples. 2. Some sample data (sql format). 3. If possible some sample marc data to import. 4. If possible it will be good to see me some presentation about Koha. If somebody reply me to sending some of this things it will be very nice for me. Zeki Celikbas Librarian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Istanbul Technical University e:mailto:celikbas@itu.edu.tr Faculty of Aero. & Astro. w:http://www2.itu.edu.tr/~celikbas 80626 Maslak Istanbul Turkey t:(212)2853108 f: (212)2853139 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 4

Daemon
by Roger Horne 08 May '04

08 May '04

I am an inexperienced linux user and sometimes get floored by permissions. Last week my system got corrupted and on the advice of my supplier I reinstalled (Suse 9) Linux having first backed up all data onto CD. I reinstalled Koha by using the instaler but with the version of the tables saved using mysqldump substituted for the original. I then substituted the version of the main Koha files saved on disc for those in /ust/local. Everything works fine save for one thing. The files saved to CD had, I think, different permissions to those given to them by the installer. This applies in particular to the z* daemon. I have changed the permissions of those files to wwwrun and www (user and group used by Apache2). The daemon is running and when I log into Koha from the admin a/c (which is set not to requre a pw) from the machine on which Koha runs but from my main user a/c I can get biblios completed via the remote servers. That a/c is a member of the www group. When however I run Koha admin from a remote machine the daemon does not work, ie I constantly get ??? pages. Is this a permision problem and if so what should I run the daemon as? Should all the z* files and the directory they are in have the same permissions? Roger -- Roger Horne, 11 New Square, Lincoln's Inn, London WC2A 3QB mailto:roger@hrothgar.co.uk

3 2

how to use perl scrips and perl modules in koha
by François Patte 07 May '04

07 May '04

When you try to modify some links in the Koha database you are warned to ask your system administrator to run some script... 1- Which system administrator: Un*X/Linux one? 2- MySQL one? 3 Koha administrator? Anyway, I was asked to run the script misc/rebuildnonmarc.pl This is a strange way to indicate which script it is... I have found it: /opt/koha/intranet/scripts/misc/rebuildnonmarc.pl But after that it is impossible to run this script because perl is unable to find some modules: here is the error message: Can't locate C4/Context.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/5.8.3 /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/5.8.2 /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/5.8.1 /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/5.8.0 /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/5.8.3 /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/5.8.2 /usr/lib/perl5/site_perl/5.8.3/5.8.1 /usr/lib/perl5/site_perl/5.8.3/5.8.0 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/5.8.3/i386-linux-thread-multi /usr/lib/perl5/5.8.3 /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl/5.8.2 /usr/lib/perl5/site_perl/5.8.1 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.2/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl/5.8.2 /usr/lib/perl5/vendor_perl/5.8.1 /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl .) at ./rebuildnonmarc.pl line 10. BEGIN failed--compilation aborted at ./rebuildnonmarc.pl line 10. Well, of course, the Contex.pm modules is in /usr/local/koha/intranet/modules/C4/ Try to run with -I command line option: same result! I would like to know if it is a mistake I did during the installation of Koha? A bug in the installer.pl script which I used to install? Or is there a way to run these koha scripts from the web interface? Thank you for a quick answer, I'm stymied! -- François Patte Inde : Ecole française d'Extrême-Orient Deccan College Pune 411006 Tél : (00 91) (0) 20 26 69 39 04 France : Université René Descartes - Paris 5 UFR de mathématiques et informatique http://www.math-info.univ-paris5.fr/~patte

4 4