- Koha - lists.katipo.co.nz

Login by Students in to Koha
by toreachdeepak 26 Aug '11

26 Aug '11

Hi, Is it possible by students whose accounts are created by kohaadmin to login into Koha to search for books ? Or only kohaadmin can login into the Koha ? Regards Deepak Bhatia -- View this message in context: http://koha.1045719.n5.nabble.com/Login-by-Students-in-to-Koha-tp4737448p47… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Request to be a added as a Koha Support Company
by benson Mugambi 26 Aug '11

26 Aug '11

Many libraries in Kenya are swiftly moving into Koha yet there is minimal technical support from people or firms that understand libraries and library technologies. For that reason, Busara Core Solutions, an ICT support firm that is backed up by a team of experienced and multi-skilled librarians has dedicated itself to provide all-round Koha Support for all kinds of Libraries. Company Name: Busara Core SolutionsContact Person: Benson Mugambi NjoniContact email: bmugambi(a)gmail.com, mugambi(a)busara.co.keWebsite: http://www.busara.co.keTelephone: +254-721618073, +254732414146, +254720090098Address: P.O Box 24252 -00502, Mukoyoti Road - Karen; Nairobi,Kenya.Short description of your services: Installation, customization, evaluation, testing, maintenance, migration and training in: - ERM Systems, - Learning Management Systems - Library Management Systems, - Cafe' Management Systems, - Financial Accounting Systems, - Office Automation Systems among others.

1 0

Fwd: Help with MarcEdit Delimited Text Translator
by Ashok Gangurde 26 Aug '11

26 Aug '11

Dear Sir I have same query about imort data in koha from excel file. I had follow the Marc edit method, after stage MARC RECORD in koha the result was disply all record import. While in searching in OPAC there were some problem " NO ITEM" only title appear but no item found is display in opac What to do in this regards? Please guide me Thanks and Regards Ashok 2011/8/6 Olugbenga Adara <gbengaadara(a)yahoo.com> > Hello Christine, > > Apart from mapping the fields you have in your excel file, you also need to > create some other fields like permanent location, holding branch, itemtype > and barcode if you need to circulate the items. Also note that the branch > code, location, itemtype has to match what you have in Koha. > > You may create this fields in excel before converting using marcedit or add > them in Marcedit after conversion. > > In addition to the link Nicole sent you, you can also read > > http://manual.koha-community.org/3.4/en/implementation.html#imp-migrationand > http://manual.koha-community.org/3.4/en/catguides.html#itemcatguide > > > Olugbenga Adara > > Mobile: 234 (0) 8033220288 > Home: 234 (2) 8721720 > Skype: gbengaadara > Blog: http://gbengaadara.blogspot.com > Twitter: http://twitter.com/gbengaadara > Profile: http://www.linkedin.com/in/gbengaadara > > --- On *Sat, 8/6/11, Christine Othitis <cothitis(a)telus.net>* wrote: > > > From: Christine Othitis <cothitis(a)telus.net> > Subject: [Koha] Help with MarcEdit Delimited Text Translator > To: koha(a)lists.katipo.co.nz > Date: Saturday, August 6, 2011, 5:45 AM > > > Hi group, > > > > I am volunteering with a non-profit organization who has decided to use > Koha to catalogue their collection. It exists as an Excel spreadsheet. > > > > Nicole, on this list, pointed me to these instructions for translating the > Excel file: > > > > http://manual.koha-community.org/3.4/en/marceditexcel.html > > > > I thought I made the MARC file correctly, but when I tried to import it > into Koha, I received an error that said something to the effect of 0 > records were imported, records don’t exist. > > > > I am looking at the tutorial again and I don’t think I mapped the fields > correctly as demonstrated in the tutorial. > > > > The spreadsheet contains these fields: > > > > Flag > > Title/Description > > Author(s)/Editor/Curator > > Artists Involved > > Pub. Year > > Gallery > > Category > > Location > > Notes > > Borrowed > > > > Do I need to change the column headings to something else? And if so, what > would the map to text be? I went to the LOC website, but I can’t understand > it :\ > > > > Thanks, > > Christine > > -----Inline Attachment Follows----- > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz <http://mc/compose?to=Koha@lists.katipo.co.nz> > http://lists.katipo.co.nz/mailman/listinfo/koha > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > >

2 4

Official Koha Newsletter : Volume 2, Issue 8: August 2011
by Daniel Grobani 26 Aug '11

26 Aug '11

[Below is the text of the newsletter. For active links and a more readable format, please visit http://koha-community.org/koha-newsletter-volume-2issue-8-august-2011] Official Koha Newsletter (ISSN 2153-8328) Volume 2, Issue 8: August 2011 Edited by Daniel Grobani, Koha Community Newsletter Editor. Table of Contents Koha Developments Koha 3.4.4 Available Koha 3.6 Update Koha 3.2 End-of-Life Koha Community New Koha Libraries Community Gossip Past Koha Events New Zealand Koha Users Group Meeting Global Bug Squashing Day #3 August General IRC Meeting Upcoming Koha Events Global Bug Squashing Day #4 September General IRC Meeting KohaCon11 KohaCon12 Koha Developments Koha 3.4.4 Available by Chris Nighswonger It is with pleasure that I announce the release of Koha 3.4.4. The package can be retrieved from: http://download.koha-community.org/koha-3.04.04.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.04.04.tar.gz.MD5 http://download.koha-community.org/koha-3.04.04.tar.gz.MD5.asc http://download.koha-community.org/koha-3.04.04.tar.gz.sig Release notes for 3.4.4 are below the fold. Come and get it! Continue reading “Koha 3.4.4 Available” Koha 3.6 Update by Chris Cormack We are rapidly closing in on the 3.6.0 release, so I thought it would be good remind everyone of the key dates. Feature freeze – 22 September 23:59 UTC – From this point on, no new features will be considered for inclusion into 3.6.0 String freeze – 8 October 23:59 UTC – no bugs that change templates accepted after this point. This allows the translators to translate without things changing on them Translations finished – 18 October 23:59 UTC – Translations submitted, so that they can be tested before release Release – 22 October Koha 3.2 End-of-Life It was decided at the August general IRC meeting that Koha 3.2 has reached the end of its life. Koha Community New Koha Libraries C.G. Jung Institute of New York (via ByWater Solutions) CAUSE (Comfort for America’s Uniformed Services) (via ByWater Solutions) Centenary College (via ByWater Solutions) Central Kansas Library System (via ByWater Solutions) All schools in the Canadian province of Prince Edward Island are now using Koha. Community Gossip Paul Poulain of BibLibre is assisting 3.6 Quality Assurance Manager Ian Walls in reducing the backlog of patches waiting for QA testing. Lori Bowen Ayre is working on a spreadsheet comparing Evergreen & Koha features. Brenda Chawner asked community members several years ago to complete a survey as part of her PhD research on factors affecting satisfaction with the experience of a free/libre open source software project. Brenda recently thanked the community and provided an abstract of her PhD thesis. For more info, see http://markmail.org/message/gdofvpmbgseao2vb. Joy Nelson joined ByWater Solutions as their Migration Support Specialist. Melia Meggs joined ByWater Solutions as their Operations Manager. Hal Bright reports that the Farmington Libraries has integrated its Koha database into a mobile app powered by the Boopsie company in cooperation with its vendor, ByWater Solutions. For more info and a demo, see http://flct.boopsie.com. Equinox Software is looking to hire a Library Data and Support Specialist. ByWater Solutions is looking to hire a Perl developer for their support desk. Past Koha Events New Zealand Koha Users Group Meeting by Chris Cormack Today I had the great fortune of attending the first New Zealand Koha users group meeting, in the birthplace of Koha, Horowhenua. There were 51 attendees and even road closures and snow didn’t stop people attending. There was a really good mix of Library types, I think 18 from Publics, 18 from specials, and the rest schools, corporate and academic. It was run as an unconference so the first task of the day was to decide what would be talked about the rest of the day. The programme that we came up with was: The community – How to get involved and make the most Installation/migration/training and why should we use Koha Features – what’s there, and what would we like added Serials, acquisitions, cataloguing Managing digital resources Consortia And one other I have forgotten The discussions went really well, with lots of participation. It definitely won’t be the last meeting, I think we are leaning towards 2 a year but that’s something that will be decided on the mailing lists. While we were busy plotting plans to take over the world, (or at least New Zealand) Koha 3.4.3 was released. Global Bug Squashing Day #3 by Magnus Enger Global bug squashing days are dedicated to getting bugs and patches moving toward resolution. The third GBSD coincided with holidays and other obligations for some people, but we still managed to move a fair number of bugs along. These numbers below show how many bugs were moved to a new status during the day: Needs Signoff: 13 Signed Off: 12 Passed QA: 6 Pushed: 11 Resolved: 30 For more info, see http://wiki.koha-community.org/wiki/2011-08-05_Global_bug_squashing_day. August General IRC Meeting The August general IRC meeting was held on 2 August 2011. Highlights from the meeting include: Koha 3.2 has reached its end of life. The bare minimum requirement for a vendor to be listed on the community website is a visible link to the community website on the main Koha page of the vendor’s website. Daniel Grobani is the new newsletter editor. Those interested in a role in 3.8 should express interest to the mailing list by 22 September for an October election. For more info, including links to the minutes, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_2_August_2011. Upcoming Koha Events Global Bug Squashing Day #4 The next GBSD will occur on Friday, 2 September 2011. For more info, see http://wiki.koha-community.org/wiki/2011-09-02_Global_bug_squashing_day. September General IRC Meeting The next general IRC meeting is 7 September 2011 1800 UTC. For more info, see http://wiki.koha-community.org/wiki/General_IRC_Meeting,_7_September_2011. KohaCon11 KohaCon11 will be held 31 October 2011 to 6 November 2011 in Thane, India. The organizers have extended the deadline for submitting papers from 15 August to 30 August 2011. For more info, see http://wiki.koha-community.org/wiki/Category:KohaCon11 or http://kohacon11.vpmthane.org/ocs/index.php/k/k11. KohaCon12 Proposals for KohaCon12 are being accepted until 1 September 2011. Voting will take place through 1 October 2011. Proposals have been made by software.coop in the UK and Washoe County Library System in Reno, Nevada, USA. For more info, see http://wiki.koha-community.org/wiki/Category:KohaCon12.

3 2

Problems with Hold in Koha 3.4
by Moyra McAllister 25 Aug '11

25 Aug '11

I am a very new user of Koha - and we are about to go live - we are a single library, no branches. I had been using 3.2.successfully in a trial situation and decided to upgrade to 3.4.2 before going live. However, when we try to place holds we get the following 'None of these items can normally be put on hold for this patron Place hold?' Clicking OK will place the hold This occurs for all item types and all borrowers. Using the OPAC to place holds does not work. Has anyone else had this problem? Hoping for an answer Moyra Moyra McAllister Melbourne Athenaeum Library Mob: 0409463663 email: moyrab(a)internode.on.net

5 4

Upgrade from Koha 3.00.01 to 3.4 on Debian
by David Whelchel 25 Aug '11

25 Aug '11

Hi All, Is here a direct upgrade path from Koha 3.00.01 to 3.4 on Debian? I know that the link http://koha-community.org/documentation/faq/installingupgrading/ does not contain any information. Also the INSTALL.debian file suggests running ./koha_perl_deps.pl that does not appear to exist in the 3.00.01 environment. A step-by-step upgrade guide would be very helpful. Thanks Dave ------------------------------------------------------------------------------- David L. Whelchel 725 SE Derby Street Pullman, WA 99163 whelchel(a)pullman.com<mailto:whelchel@pullman.com> http://www.dlwa.com

2 1

Issue in starting koha and apache
by deepak.bhatia 25 Aug '11

25 Aug '11

Hi, I followed all the steps in INSTALL.ubuntu for installing Koha. Then restarted the machine, then I following errors *koha@10:~/koha-3.2.10$ sudo -u koha zebrasrv -f /etc/koha/koha-conf.xml* 12:32:25-25/08 [log] zebra_start 2.0.44 419ad759807269fdfa379799a051ed3a551c6541 12:32:25-25/08 [log] config /etc/koha/zebradb/zebra-biblios.cfg 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-alvis.so 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-grs-xml.so 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-dom.so 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-grs-regx.so 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-grs-marc.so 12:32:25-25/08 [log] Loaded filter module /usr/lib/idzebra-2.0/modules/mod-text.so 12:32:25-25/08 [fatal] lock file /var/lock/koha/zebradb/biblios/zebrasrv.pid [No such file or directory] *koha@10:~/koha-3.2.10$ sudo apache2ctl restart* apache2: Could not reliably determine the server's fully qualified domain name, using 10.0.1.228 for ServerName -- View this message in context: http://koha.1045719.n5.nabble.com/Issue-in-starting-koha-and-apache-tp47340… Sent from the Koha - Discuss mailing list archive at Nabble.com.

3 2

Not able to installation of Koha on ubuntu
by toreachdeepak 25 Aug '11

25 Aug '11

Dear All, I am wondering, if it is difficult to install the Koha on Ubuntu or any other linux. I have been trying for the last one week and I am not getting the initial screen of the Koha. Please share with me the correct steps for installation. Regards Deepak Bhatia -- View this message in context: http://koha.1045719.n5.nabble.com/Not-able-to-installation-of-Koha-on-ubunt… Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 1

Migration from 2.2.5 to 3.4 - call numbers and item update
by Peter Thompson 25 Aug '11

25 Aug '11

Thanks to Everyone who replied - the system is now coming together . I upgraded to 3.00 and imported the database, and followed the processes outlined in the http://wiki.koha-community.org/wiki/Upgrading_2.2 document. I have two remaining issues: In the Mysql database (prior to running any scripts etc), the call numbers seemed to be in the 082 field, judging by the contents of the `tag` and `subfieldvalue` fields of the `marc_subfield_tag' file, not in the `itemcallnumber` field of the `items` file. After running the process detailed in the upgrade document, the call numbers dont' appear in the catalogue. They seem to have been moved to a file ' temp_upg_biblioitems_call_num. Any advice on how I can get these call numbers indexed properly? Also, when I try to add an item, the process fails with an error. In the error log, it refers to the record wrapper missing at /usr/local/share/perl/5.10.1/MARC/file/XML.pm. Thanks again, Peter Thompson Whenever I add an item Peter Thompson Database Administrator Information Technology & Communications Unit

1 0

Re: Report Help
by Msgr. Marion J. Makarewicz 25 Aug '11

25 Aug '11

Perhaps this can help set up where 5 is the number of years you choose. The YEAR() function trims the dates returned in the datelastborrowed field and NOW() gives the present date. CURDATE() also is a possible function to use. DATEDIFF() can give you the difference in days. SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber, i.barcode, i.datelastborrowed, i.issues as totalcheckouts, i.dateaccessioned FROM items i LEFT JOIN issues USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE i.itemnumber NOT IN (SELECT issues.itemnumber FROM issues) AND YEAR(NOW())-YEAR(i.datelastborrowed) > 5 UNION SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber, i.barcode, i.datelastborrowed, i.issues as totalcheckouts, i.dateaccessioned FROM items i LEFT JOIN issues USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE i.itemnumber NOT IN (SELECT old_issues.itemnumber FROM old_issues) AND YEAR(NOW())-YEAR(i.datelastborrowed) > 5; Marion > Can someone help me out here. I need to alter this to show only titles >that haven't circulated in X number of years.

2 1