- Koha - lists.katipo.co.nz

Happy Diwali !!!
by Koustubha Kale 01 Nov '13

01 Nov '13

Wishing a very happy Diwali to all wonderful folks of the Koha community!! May this Diwali light the lamps of happiness, peace and prosperity in your life!! Regards, Koustubha Kale

3 2

Re: [Koha] My favourite new feature coming in Pi - borrower lists!
by Joel Sasse 31 Oct '13

31 Oct '13

Gee, you really are excited. ;) Joel Sasse Plum Creek Library System Sent from my Verizon Wireless 4G LTE smartphone -------- Original message -------- From: Liz Rea <liz(a)catalyst.net.nz> Date: 10/31/2013 4:48 PM (GMT-06:00) To: Koha-Mailinglist <Koha(a)lists.katipo.co.nz> Subject: [Koha] My favourite new feature coming in Pi - borrower lists! I was just so excited I had to share - a new feature coming in version Pi is the addition of Borrower Lists. It works like this: Do a borrower search, tick off some borrowers. Just like adding books to a list, you pick Add to -> new list Give it a name Then, what you can do with it - is BATCH MODIFY based on that list - Tools -> Batch Modify Patrons -> From a List omg. Guys, that's so cool! What's your favourite new feature? Liz (sorry if this comes as a duplicate - didn't see my first message come through so sending again, because yes, I'm "just that excited (tm).") _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Yahoo's new set-up.
by Estel Porras 31 Oct '13

31 Oct '13

I would like to apply to the list using my other email, as Yahoo has become terribly confusing. My other email is dorothy63(a)hotmail.com Should I try accessing the list-serve through that email, or can you change me over? Thanks for your help. It is much appreciated! Have a great day, ~Estel~ Orland Free Library 333 Mill St. Orland CA. 95963 [530]865-1640

2 1

Report Help
by Nicole Engard 31 Oct '13

31 Oct '13

Hi all, I have a library that wants to alter this report to allow us to limit on the item's home branch: SELECT concat(b.title, ' ', ExtractValue(m.marcxml, '//datafield[@tag="245"]/subfield[@code="b"]')) AS title, b.author, count(h.reservedate) AS 'holds' FROM biblio b LEFT JOIN biblioitems m USING (biblionumber) LEFT JOIN reserves h ON (b.biblionumber=h.biblionumber) GROUP BY b.biblionumber HAVING count(h.reservedate) >= <<Min number of holds>> The problem as I see it is that the hold is placed on the bib level - not the item level most of the time. Can you tell me how to bring the items table in here even if the hold is on the bib level and get the right numbers? Nicole

1 0

008 Fixed length data elements: problems with imported records in 3.12
by Elaine Bradtke 31 Oct '13

31 Oct '13

Something is happening to our 008 fields, when we edit the 008 field of an imported record (converted from our old database - this doesn't seem to be a problem with Z39.50 downloads). I don't know if it's always been a problem, or if it's just come up since we moved to 3.12. Our cataloguer only recently reported it , but we don't often need to edit 008 fields. Here's an example of the imported 008: 130515s2006####stka###gr#####000#0#eng#d If I edit the record and open the 008 editing window Koha automatically changes it to: 130515s2006 And this is what it looks like after clearing the field and entering the information manually: 131030s2006 stka gr 000 0 eng d The problem seems to be with the # characters in the imported 008. Koha slots the information it has into the spaces, working from left to right. When it gets to the first # something happens. It skips over the # character(s) and continues to slot in information, redistributing the other characters in the remaining spaces from left to right. Once the data is redistributed, if the information in a given position doesn't match what is allowed in that position then Koha uses the default (usually blank which is what happened in the above example). If a character does match what's allowed, then Koha uses it. . . which can make for some bizarre entries because 'a' in one position means something very different in another. But it also seems to hold on to these incorrect characters, even when you think you have changed them using the editing window. While the field editor displays the corrected information, after you click OK and return to the MARC display, the characters are still in the wrong positions. In order to properly correct the faulty 008 field, I have to manually delete all the incorrect information from the main MARC display (rather than using the field editor) and then enter the correct information either in the MARC display or using the field editor. I think I need to file a bug report . . .? or is it two bugs? - 1) the # character and 2) the field editor not correctly updating the information??? Aside from the quirks described above, I have a couple questions: How important is the 008 field in the long term? I know it does influence a few display and search functions in Koha. Is it worth the effort to export the whole catalogue and try to fix this with batch edits? How do I avoid this problem with the next set of uploads? -- 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 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- 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)

3 5

Advice for manipulating the patron database with code
by magmatic 31 Oct '13

31 Oct '13

We have a separate database of users that we want to sync (one way) with Koha. Since I have experience working with databases, I plan to add a column to the Koha MySQL patron table that I will use as a reference to the record in the other database. Then everyday I'm going to run a cron job that makes sure the Koha database of patrons all have the correct email address, name, address, etc, based on our other database. I'm pretty sure this will work. The reason I'm saying all this is just so that if anyone out there has any advice for me before I begin, I would take it. Perhaps there are pitfalls to guard against, or perhaps there is some feature of Koha I don't know about since I'm not all that familiar with it yet. Thank you. p.s. this other database we have lives on a different server that we only have limited api access into, so I don't think it will work to use it as some sort of active directory server. -- Tim -- View this message in context: http://koha.1045719.n5.nabble.com/Advice-for-manipulating-the-patron-databa… Sent from the Koha-general mailing list archive at Nabble.com.

2 1

October 2013 Koha Community Newsletter has been published
by Daniel Grobani 30 Oct '13

30 Oct '13

Hi, The October 2013 edition of the Koha Community Newsletter has been posted to http://koha-community.org/koha-community-newsletter-october-2013/. Cheers, Daniel Grobani Koha Community Newsletter Editor

1 0

Analytics records import
by akhlaq ahmed 30 Oct '13

30 Oct '13

Dear Friends, I have some books with their analytic records in WinISIS and I want to import them in koha and link all analytic record with their referenced book record. please guide me. Akhlaq Ahmed, New Delhi, India

3 2

Re: [Koha] [Dspace-tech] Customise Dspace Side News
by Chrispin Simasiku Sitali 30 Oct '13

30 Oct '13

wow Suzuki thanks worked like a charm. Really appreciate On 30 October 2013 14:31, Lighton Phiri <lighton.phiri(a)gmail.com> wrote: > Hello Sitali, > > Saw your post and got interested. Does your institution have an > publicly accessible DSpace-based repository? What's the URL? > > Lighton Phiri > http://lightonphiri.org > > > On 30 October 2013 10:44, Chrispin Simasiku Sitali <libsitali(a)gmail.com> > wrote: > > Each time I customise the Side News, run ant update; the news is lost. > Only > > the default site news remains. How can I edit the news so that the > changes > > remain even after ant update. > > Thank you > > > > Sitali CS > > > > -- > > Charles Lwanga College of Education, > > P. O. Box 660193, > > Monze, > > ZAMBIA. > > > > Mobile: +26 0979 869471 > > SKYPE: Libsitali > > > > > ------------------------------------------------------------------------------ > > Android is increasing in popularity, but the open development platform > that > > developers love is also attractive to malware creators. Download this > white > > paper to learn more about secure code signing practices that can help > keep > > Android apps secure. > > > http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk > > _______________________________________________ > > DSpace-tech mailing list > > DSpace-tech(a)lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/dspace-tech > > List Etiquette: > > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > -- Charles Lwanga College of Education, P. O. Box 660193, Monze, ZAMBIA. Mobile: +26 0979 869471 +26 0966 869471 SKYPE: Libsitali

1 0

Importing books from a csv file, including bar codes
by magmatic 30 Oct '13

30 Oct '13

I'm trying to import books into Koha. We have a few thousand books with bar code stickers stuck onto them and we don't want to change them. If I got a csv file with the authors, titles, and bar codes, how can I import this? I looked around at how to set the bar code of a book in Koha, but I couldn't find it. It doesn't look like it is a part of MARC. And since it is not a part of MARC, I can't really just import a MARC file, can I? Help! -- Tim -- View this message in context: http://koha.1045719.n5.nabble.com/Importing-books-from-a-csv-file-including… Sent from the Koha-general mailing list archive at Nabble.com.

2 3