- Koha - lists.katipo.co.nz

Data Migration
by Swamynm 30 Mar '10

30 Mar '10

Dear Sir/Madam, I am using Koha on windows version 2.9, I have installed Koha on windows xp with prerequisites Apache, Active Perl and Mysql. I have data so I have uploaded data thru mysql to the table biblio, biblioitems, additionalautors, items & itemtypes, all went essay. Hence, I open http://opac to search the data which I have uploaded, but getting no records matching. Kindly help me in this regard. Thanks in advance. Regards, M. Swamy Swamy_nm(a)rediffmail.com -- View this message in context: http://old.nabble.com/Data-Migration-tp28078479p28078479.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Ratnagiri (Dist.) Nagar Vachanalaya joins Granthalaya.org
by Koustubha Kale 30 Mar '10

30 Mar '10

Dear All, Ratnagiri (Dist.) Nagar Vachanalaya has joined Granthalaya.org With this the Granthalaya.org union catalouge has crossed the half million mark with over 5,36,600 books catalouged so far.. Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2

2 2

Question
by Paula Corman 29 Mar '10

29 Mar '10

Hello I am a new user of KOHA who is trying to set up a research library for a new museum opening in Phoenix, Arizona, USA. My problems are multiple: 1. I am untrained in MARC since MARC was not around when I graduated from library school although I have been valiantly reading MARC how-tos. 2. I do not have KOHA presently available to me. 3. I am encountering many questions about both MARC and KOHA as I work and so I am hoping that you kind people can give me answers. One of my questions is this: I have encountered a few Library of Congress records that contain typos. How would I correct those records for my own library? PF Corman

1 0

Re: [Koha] Journal articles and analytical records
by camins＠numismatics.org 29 Mar '10

29 Mar '10

Dear Zeno, > but do you create a record for every issue ? > Do you add TOC and abstratcs in every issue ? We do not create separate bib records for each _issue_, although in principle we create a separate bib record for at least one article in each issue of our "core" journals. In practice, I'm not even sure that we do that. The search I proposed would give a list of every single article in a given journal. A refinement would be to provide a list of years, for example: <a href="opac-search.pl?q=issn:022&limit-yr=2004">Search for child records from 2004</a> I can't imagine how we could reasonably go about limiting our search to a specific issue (one could imagine using some sort of volume-issue-date number stored 952$x, although, as you point out, that's not a good solution...). > Because the standard, for me, is to create only one bibliographic record, > add an item for every issue during the year and after one year I > collapse all items of the year > into only one item. > > But I don't lend the issues of journals. What you describe is exactly what we want to do with our item records. My feeling is that any improved searching we can offer to our users is a good thing, even if it's non-ideal like the solution I suggested above. Regards, Jared Camins-Esakov P.S. In an earlier e-mail, it was suggested that perhaps there should be a wiki for Koha/analytic issues. I will look into setting one up.

1 0

Re: [Koha] Journal articles and analytical records
by Zeno Tajoli 29 Mar '10

29 Mar '10

Dear Jared Camins-Esakov, >Like so: > >Child record: >=773 \\$tCataloging & Classification Quarterly$x0163-9374$gVol. 38, no. 1 >(2004) > >Parent record (the 997$x is ANS local-use): >=022 \\$a0163-9374 >=245 \\$aCataloging & Classification Quarterly >=997 \\$x1 > >In the OPAC: >If 997$x==1 Then: <a href="opac-search.pl?q=issn:022">Search for child >records</a> but do you create a record for every issue ? Do you add TOC and abstratcs in every issue ? Because the standard, for me, is to create only one bibliographic record, add an item for every issue during the year and after one year I collapse all items of the year into only one item. But I don't lend the issues of journals. Bye Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)

1 0

Journal articles
by Andrew Buxton 29 Mar '10

29 Mar '10

Is there anyone who includes journal articles in their catalogue and uses MARC21 format? I'd like to compare notes about what MARC fields to use - especially anyone who has a Z39.50 server. Thank you. --- Andrew Buxton, Library Web and Information Systems Manager Direct line: 01273 915795 - International +44 1273 915795 IDS website: http://www.ids.ac.uk/ Library website: http://blds.ids.ac.uk<http://blds.ids.ac.uk/>/ This message is for the addressee only and may contain privileged or confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any views or opinions expressed are solely those of the author and do not necessarily represent those of IDS. Institute of Development Studies at the University of Sussex, Brighton BN1 9RE Tel: +44 (0)1273 606261; Fax: +44 (0)1273 621202 IDS, a charitable company limited by guarantee: Registered Charity No. 306371; Registered in England 877338; VAT No. GB 350 899914

6 5

Koha Open Day, London
by Andrea Chandler 29 Mar '10

29 Mar '10

1 0

KohaCon 2010 road trip.
by Joann Ransom 29 Mar '10

29 Mar '10

Hi all, Just received a quotation for $267 per person including accommodation, van hire plus luggage trailer, and the cultural show and dinner. This is heaps cheaper than I advised earlier. Extras on that price would be a bit of petrol (maybe $20 each) plus whatever food and extras you wanted - (like bungy jumping or the flying fox which is fantastic :). This is looking really cost effective. Next step would be to start taking names of people who are definitely wanting to do this road trip with us. So start thinking and scheming because I will be taking bookings in the next few weeks :) Cheers Jo. ---------- Forwarded message ---------- From: Kylie Henare <kylie.henare(a)harveyworld.co.nz> Date: Mon, Mar 29, 2010 at 4:56 PM Subject: Travel Quotation To: hfields19(a)gmail.com Hi Joann Thanks for your enquiry. I have attached a quote for you above. The minimum hire if taking a one way rental is 3 days so I have included this cost in the quote for you above. Please let me know if you have any queries and I will be more than happy to help. J Kind Regards *Kylie Henare* Travel Consultant *Harvey World Travel* 103 Broadway Avenue Palmerston North 4410 Phone: 06 357 4605 Fax: 06 359 3279 Email: kylie.henare(a)harveyworld.co.nz Web: www.harveyworld.co.nz Go to www.govouchergo.co.nz to see new travel discount vouchers. Bring these in with your booking & take advantage of these exclusive deals! -- Joann Ransom RLIANZA Head of Libraries, Horowhenua Library Trust.

1 0

SQL Report Help
by Sharon Jackson 29 Mar '10

29 Mar '10

Hi, I'm trying to run a report that gives me a list of the most popular DVDs for the current month. When I run the report, I get a list of DVDs that all have an issue count of one,(which I know is not the case). And when I look at the checkout history for DVDs that I know are popular - some don't appear on the list at all, and all have an issue count much higher than one for that time period. Any ideas/help would be much appreciated SELECT biblio.title,biblio.author,COUNT(*) AS issuecount FROM issues,biblio,items WHERE items.biblionumber = biblio.biblionumber AND issues.itemnumber= items.itemnumber AND issues.issuedate > '2010-02-28' AND items.itype='DVD' GROUP BY biblio.biblionumber ORDER BY issuecount DESC LIMIT 20 thanks Sharon -- Sharon Jackson Librarian RLIANZA Albany Senior High School P O Box 300-380 Albany 0752 Phone. (09)451 9065 Fax. (09)451 9209 Mobile 021 020 60451

2 1

Patron Deletions
by Kay Smith 29 Mar '10

29 Mar '10

We use Koha in a Prison Library in the Education Unit managed by Tafe staff, and have been unable to delete patrons from the patron file once these people have left. We are currently using Version 2.2 We select the patron record, select delete and select OK to the message Are you sure you want to delete this patron. This unfortunately does not remove the patron - they are still listed, even though the patron has nothing outstanding. Has anyone else experienced this problem, or are we missing a basic step??? Kay Smith Regional Services Librarian Bendigo TAFE

1 0