- Koha - lists.katipo.co.nz

Data Migration
by Zewar Khan 15 Dec '11

15 Dec '11

Dear Colleagues, I am using Koha 341(Fedora) on trail bases and planning to import my Access data to koha with the help of MarcEdit. I have mapped all data except the repeatable fields such as Keywords etc. I wonder if any one can help me how a repeatable field is mapped using MarcEdit software. Thank you for your time and consideration Zewar Khan

2 1

KOHA for windows
by Chauhan 15 Dec '11

15 Dec '11

Hi Professionals, Do we have any latest version of Koha for Windows around? Hope to hear you soon. Regards, Suresh K chauhan

2 1

Re: [Koha] Koha Digest, Vol 74, Issue 25
by Thippeswamy G.N 15 Dec '11

15 Dec '11

Sir, How can i take dataBack and restore the database. Even I took Data Backup from PHPmyAdmin, but when i try to restore that, it showing the Back file is too big, because through PHPMYADMIN we can restore max(2MB) file. Please give me the proper solution for this. Thank you On Mon, Dec 12, 2011 at 4:30 AM, <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. Please shutdown the site of Koha Windows version (Vimal Kumar) > 2. Re: Please shutdown the site of Koha Windows version (Mirko) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 11 Dec 2011 21:19:03 +0530 > From: Vimal Kumar <vimal0212(a)gmail.com> > To: Koha-List <koha(a)lists.katipo.co.nz> > Subject: [Koha] Please shutdown the site of Koha Windows version > Message-ID: > <CAEaJrwV8gcRfvTn6WOneAuDmc2VZ7Jw8wTLuHumHkv5QxVwH4w(a)mail.gmail.com > > > Content-Type: text/plain; charset="utf-8" > > Dear Friends, > Many people are downloading Koha Windows version from > www.koha.rwjr.comsite and installed in their library and send many > query regarding about it. > They are newbies to Koha and don't know windows version is obsoleted one. > My humble request to Koha Windows version developer is that either shut > down the site or give proper message to visitors that development of > Windows version is stopped. > Installation of Koha in Windows is troublesome and can break anytime. > Many librarians entered their whole data in Koha Windows version and after > that they know that the version is not updated. > They feel difficult to convert their data to latest version of Koha. > Windows is not a good platform for Koha production system. > > Regards, > > -- > Vimal Kumar V. > Mahatma Gandhi University Library > Kottayam, Kerala- 686 560 > Web: www.vimalkumar.org > Blog: http://linuxhalwa.blogspot.com > --------------------------------------------------------------------------- > "I forget what I was taught. I only remember what I have learnt" > -Patrick White >

2 1

Re: [Koha] Koha Digest, Vol 74, Issue 30
by Jagadish jagadish mn 15 Dec '11

15 Dec '11

how to change bakgrowand colour in Koha On 12/15/11, koha-request(a)lists.katipo.co.nz <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. Re: how can i view all the contents of the libary, Please > make it more clear (Stefano Bargioni) > 2. Error in Guided Report (Vimal Kumar) > 3. Update on link resolver + Koha? (Amy Schuler) > 4. Re: Update on link resolver + Koha? (Owen Leonard) > 5. Checkout fails (Perch) > 6. Call for News for the December Newsletter (Daniel Grobani) > 7. Equinox offering two scholarships for the 2012 Code4Lib > conference (Galen Charlton) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 14 Dec 2011 09:22:00 +0100 > From: Stefano Bargioni <bargioni(a)pusc.it> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] how can i view all the contents of the libary, > Please make it more clear > Message-ID: <21A847B4-4888-4A3C-AA50-E476933F623F(a)pusc.it> > Content-Type: text/plain; charset=us-ascii > > Maybe the select suggested in the wiki > > SELECT > items.price,items.replacementprice,biblio.title,biblio.author,items.itemcallnumber > FROM items > LEFT JOIN biblioitems ON > (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.homebranch=<<Home branch|branches>> > ORDER BY items.itemcallnumber ASC > > could be enhanced using the cn_sort field, that cointains the sort form of > itemcallnumber, changing the ORDER BY clause into > ORDER BY items.cn_sort ASC > Stefano > >> There is a report for a complete shelf list on the wiki - >> http://wiki.koha-community.org/wiki/SQL_Reports_Library#Complete_Shelf_list >> >> You should be able to use that as a starting place to get what you're >> looking for. >> >> Liz Rea > > > ------------------------------ > > Message: 2 > Date: Wed, 14 Dec 2011 14:59:02 +0530 > From: Vimal Kumar <vimal0212(a)gmail.com> > To: Koha-List <koha(a)lists.katipo.co.nz> > Subject: [Koha] Error in Guided Report > Message-ID: > <CAEaJrwUCEkcj4Mp3YYC_je_xWin8xDxu9zKLAFCmYgicjD=-pw(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Dear Friends,I got the following message when try to create report from > > Reports > Guided Reports > Build New > > in the second step "Pick a report Type", Tabular. > > My koha version is 3.4.7 > > Software error: > > Undefined subroutine &C4::Reports::Guided::themelanguage called at > /usr/share/koha/lib/C4/Reports/Guided.pm line 714. > > For help, please send mail to the webmaster (webmaster@comp), giving this > error message and the time and date of the error. > > > -- > Vimal Kumar V. > Mahatma Gandhi University Library > Kottayam, Kerala- 686 560 > Web: www.vimalkumar.org > Blog: http://linuxhalwa.blogspot.com > --------------------------------------------------------------------------- > "I forget what I was taught. I only remember what I have learnt" > -Patrick White >

1 0

942 c searching and generating reports
by Chris Cormack 15 Dec '11

15 Dec '11

On 15 December 2011 14:39, Elaine Bradtke <eb(a)efdss.org> wrote: > Nope, that didn't work. How about something that will give me the > biblio number and the contents of the associated 942$c? > I can sort those in a spreadsheet and it might also give me a clue as > to what's going on. > Elaine What didn't work about it? You got no results? or not the right amount? SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag="942"]/subfield[@code="c"]') AS comp FROM biblioitems Will give you biblionumber and the contents of 942c .. again only if your mysql server its 5.1.5 or greater Chris

1 0

942 c searching and generating reports
by Elaine Bradtke 15 Dec '11

15 Dec '11

The problem: I need to batch edit a group of biblios, but first I have to find them and extract a list of their biblio numbers. All the biblios in question have a common trait: their 942$c is Components They also do not have item records But I can't seem to create a report that will do this (my grasp of the whole report function is rather feeble). Any advice? Now for the inevitable weirdness: I know there are over 70 biblios with Components in the 942$c field. I created a report that lists all the biblionumbers and itemtypes. The only Components that report produced were ones that had been manually entered. Not the 70+ that came in via a bulk import. If I search for the items individually by title, etc. they are there and appear to be normal records. If I try to limit an advance search to Components, it draws a blank. Which makes me think there's something fishy going on somewhere. But where to look? Thanks for any help! Elaine

2 2

Equinox offering two scholarships for the 2012 Code4Lib conference
by Galen Charlton 14 Dec '11

14 Dec '11

[Please excuse the cross-posting. Potential applicants should be aware of a new piece of information since the initial announcement: as part of our overall sponsorship of the conference, Equinox had one attendance slot that was reserved for an Equinox employee. We are now using that slot in order to make the scholarship of benefit to somebody who would otherwise not be able to attend the conference. If you meet the eligibility criteria and either didn't register for the conference yet or are on the waiting list, we encourage you to apply for the scholarship.] Equinox Software is offering 2 scholarships to the code4lib conference in February. The scholarships will reimburse travel and accommodation expenses up to $750.00 USD for a full-time employee from public libraries using either Evergreen or Koha to attend the Code4Lib Conference in Seattle, Washington, USA, from February 6-9, 2012. The awardees will also receive (depending on their circumstances) free registration to Code4Lib or reimbursement of an already-paid registration. ELIGIBILITY The applicants must be presently working in a public library that is currently using or is actively committed to moving to either Evergreen or Koha as their ILS. The applicants must indicate any amount and source of additional funding which, combined with the Scholarship, will permit them to cover their expenses to attend the Conference. (This will not reduce the amount of the award.) Preference will be given to underfunded libraries or libraries in budget crisis. DEADLINE FOR APPLICATION December 31, 2011 The email application should include a current resume, including all contact information, education, and experience, along with an essay as described below. The applicants will write up to 750 words of narrative in English to address the following: • Description of the library’s mission and commitment to open source solutions • How attendance may benefit the applicant • How the applicant intends to share the benefit of the experience with colleagues • Description of funding constraints, budgetary limitations, or travel/hiring freezes pertinent to the applicant’s situation APPLICATION ADDRESS: Please send resumes and essays to Grace Dunbar before December 31, 2011 by email attachment to c4lgrant(a)esilibrary.com NOTIFICATION: The successful applicants will be notified by January 5, 2012. Feel free to re-post this announcement and/or our press release (http://esilibrary.com/esi/newsitem.php?id=2182) Regards, Galen -- Galen Charlton Director of Support and Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

1 0

Call for News for the December Newsletter
by Daniel Grobani 14 Dec '11

14 Dec '11

Dear Koha Kommunitarians, I'm harvesting news for the December newsletter. Please send me by the 25th anything you think your fellow community members might like to know about. "News" can be as short as a sentence or as long as a paper. I especially encourage you to send me a line or two about what you're currently working on for publication in the gossip/society column. And if you know of a go-live not announced on the list, please be sure to let me know about it. Please note that it's not too late to send in your reports or reminiscences of KohaCon11! Happy holidays, Daniel Grobani

1 0

Error in Guided Report
by Vimal Kumar 14 Dec '11

14 Dec '11

Dear Friends,I got the following message when try to create report from Reports > Guided Reports > Build New in the second step "Pick a report Type", Tabular. My koha version is 3.4.7 Software error: Undefined subroutine &C4::Reports::Guided::themelanguage called at /usr/share/koha/lib/C4/Reports/Guided.pm line 714. For help, please send mail to the webmaster (webmaster@comp), giving this error message and the time and date of the error. -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Re: [Koha] how can i view all the contents of the libary, Please make it more clear
by Stefano Bargioni 14 Dec '11

14 Dec '11

Maybe the select suggested in the wiki SELECT items.price,items.replacementprice,biblio.title,biblio.author,items.itemcallnumber FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch=<<Home branch|branches>> ORDER BY items.itemcallnumber ASC could be enhanced using the cn_sort field, that cointains the sort form of itemcallnumber, changing the ORDER BY clause into ORDER BY items.cn_sort ASC Stefano > There is a report for a complete shelf list on the wiki - > http://wiki.koha-community.org/wiki/SQL_Reports_Library#Complete_Shelf_list > > You should be able to use that as a starting place to get what you're > looking for. > > Liz Rea

1 0