- Koha - lists.katipo.co.nz

Creating a report for serials
by Peel Lisa 15 Mar '11

15 Mar '11

Hello all We have had our serials module live for about 6 months now so I thought it was about time I looked at the Claims - however, it does not tell me which library each subscription is for so it is difficult for me to know which missed/late serials to direct to which library. Could someone perhaps provide me with the SQL to run a report which will give me the information which Claims gives me but also with the added information of Library (Claims currently gives me Supplier, Title, Issue Number, Status, and Since). I normally try and tweak one of the reports in the SQL Reports Library but I cannot find any for the Serials module. Thanks in advance. Regards Lisa [Description: Description: Description: CR_logo_POS_COULEUR b] LISA PEEL, PGDip, MA. Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel(a)ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/>

2 3

check in date incorrect
by ksckemperman＠chartermi.net 15 Mar '11

15 Mar '11

When we check in a book and then go to the checkout history of that book, the check in date is always one day prior to the correct date. Ex - If I check in a book today (3-15 here), the history will show checkin on 3-14. How can I change that? Thanks, Shelley

3 2

KUDOScon Registration Available
by vtl＠scls.lib.wi.us 15 Mar '11

15 Mar '11

The registration form for the KUDOScon2011 conference is available. This will be a no registration fee conference, held in Madison, WI on May 2 and 3, 2011. We are asking that people register for the conference as we are limited in attendance. Please do not register if you do not plan on attending. http://kudos.koha-community.org/kudoscon2011/registration/ The Conference Planning Committee is finalizing the program. In addition to the regular program, there will be some fun ways for everyone to get involved with the conference. We will also have an evening sponsor reception at a local venue. Watch for more information on these soon. For more details on Madison, the conference center and the program, see the KUDOScon2011 site: http://kudos.koha-community.org/kudoscon2011/ We have one block of hotel rooms available at a nearby hotel and we are working on getting more. If you would like to book now, here is the link. If you are a government employee, we have some great rates. http://kudos.koha-community.org/kudoscon2011/accommodation-in-madison/ KUDOS Conference planning committee Nora Blake / Masscat nblake(a)masslibsystem.org M. Brooke Helman abesottedphoenix(a)yahoo.com Shannon O'Grady / Colorado Library Consortium (CLiC) SOGrady(a)clicweb.org Lisa Priebe / Colorado Library Consortium (CLiC) lpriebe(a)clicweb.org M. Brooke Helman abesottedphoenix(a)yahoo.com Liz Rea / NEKLS lrea(a)nekls.org David Schuster / Plano ISD dschust1(a)gmail.com Vicki Teal Lovely / South Central Library System vtl(a)scls.lib.wi.us Marie Wardall / Mountain Bay Elementary School mwardall(a)dce.k12.wi.us -- Vicki Teal Lovely Helping our 52 member libraries provide the best possible service to the public. ILS Project Manager South Central Library System Madison, WI vtl(a)scls.lib.wi.us (608)242-4713 ILS Help Desk (608)242-4720 Twitter: vickiteal Blog: http://scls.typepad.com/link2koha/

1 0

Consortia, what's the best way to set them up?
by Elaine Bradtke 15 Mar '11

15 Mar '11

Now that we've got our system up and running, we want to reach out to other small libraries with similar collections. Our idea is to build up a little online consortium based in Koha, with us providing filespace and managing the system. We would like the OPAC user to be able to search all libraries at once, or choose a specific library (or perhaps more than one, but not all). What is the best way to set these up? The libraries themselves would also have to be independent as far as patrons, loans, and other policies. I'd love to hear from other library consortia out there who could offer some pointers. Thanks -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 ext 36 -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

2 2

Corrupted PDF on Batch Export
by Fogg, Shawn (DPH) 15 Mar '11

15 Mar '11

On Koha 3.03.00.004 using the label creator I have create batches in the past that downloaded as PDFs fine. However the librarian recently added about 100 books to the system manually and in trying to print the labels for a new batch containing those books the PDF file that is downloaded in not valid. I get a message from my reader that the file is damaged. I have created other batches that download fine so it appears there is something in that batch which is causing the problem. Any ideas on where to look? I can download that batch as a CSV. Thanks, Shawn

2 3

How to Display text in Barcode ?
by Vimal Kumar 15 Mar '11

15 Mar '11

Dear Friends, I want to display my library name or CODE in Koha barcode. I know that its possible to display Library Code in barcode by including marc tag or Koha field. But my library code is MAIN. I want to display either MGUL or MGU Library in barcode. Is it possible? -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White My profiles: [image: Flickr] <http://www.flickr.com/people/vimal0212/> [image: Delicious] <http://www.delicious.com/vimal0212> [image: Facebook]<http://www.facebook.com/people/Vimal-Kumar/512044127> [image: Twitter] <http://www.twitter.com/vimal0212> [image: SlideShare]<http://www.slideshare.net/vimal0212> Signature powered by <http://www.wisestamp.com/email-install?utm_source=extension&utm_medium=emai…> WiseStamp<http://www.wisestamp.com/email-install?utm_source=extension&utm_medium=emai…>

1 0

how to upload data excel to koha
by Ashok Gangurde 15 Mar '11

15 Mar '11

Dear All I want to know the procedure of how to upload the Excel sheet data in to koha Please tell me the detail procedure for books , video cds etc Thanks & best Regards Ashok

3 2

RFC: control character in a MARC record?
by MJ Ray 14 Mar '11

14 Mar '11

I've been helping someone debug a problem saving records from the reservoir to their catalogue and it seems that one of their sources has subtle errors in their data. The source record contains some control characters. One of the MARC:: modules reacts badly to that and crashes Koha. Is there ever a reason to include a non-printing control character in a MARC record and could/should Koha filter them all out? Thanks for any pointers, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and LMS developer, statistician. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire for Koha work http://www.software.coop/products/koha

4 4

Split Call Numbers--Variation
by Anne (library) Warrington 14 Mar '11

14 Mar '11

Since splitting call numbers has come up, can anyone tell me what to do with a non-classification number call number? My Library of Congress numbers split mostly OK but my fiction just uses three letters of the author's surname, i.e. FIC SMI for "Fiction Collection" author "Smith." No matter what I do I can't get the spine labels to print as follows: FIC SMI Any suggestions? Anne Warrington

3 4

Rebuil cn_sort
by Stefano Bargioni 14 Mar '11

14 Mar '11

Is there in Koha a script to rebuild items.cn_sort? Thanks. Stefano

1 0