- Koha - lists.katipo.co.nz

Re: [Koha] How to link Koha with another software
by mh_zalabany＠hotmail.com 26 Mar '13

26 Mar '13

Search for connecting to my sql database you will need to grant the set that will accsess the database mohamed zalabany Sent from my HTC ----- Reply message ----- From: "Sonia P." <sossolapro(a)hotmail.com> To: <koha(a)lists.katipo.co.nz> Subject: [Koha] How to link Koha with another software Date: Sat, Mar 23, 2013 3:03 am Dear all We have got a user database with lots of other things (invoices etc) on Filemaker Pro, in one part of our organisation. We would like to automatically link that user database with our Koha patrons database -- so when we update the user database on Filemaker it automatically updates our Koha patrons database. Does that exist? I tried to look for it in the manual (and other places online) but I probably don't look for the right words, I am not sure what to search... Cheers, Sonia. _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

3 2

Follett to Koha 3 Migration
by Hager Braham 25 Mar '13

25 Mar '13

Hi, I am looking for information in order to make a decision about our a new library system. I saw you were migrating from Follet to Koha. How was it the data transfer ? Which is Follet's product you want to change for Koha ? I am really interested to know it works now with you. Thanks in advance, Hager

4 3

control field input sequentially, how?
by Zahid Hossain Shoeb 25 Mar '13

25 Mar '13

Dear all, How to load/input koha control number (001) sequentially and automatically through koha cataloguing module? Regards, Md. Zahid Hossain Shoeb IUB Library

2 1

Re: [Koha] Koha 3.10 hosting in a shared webhosting environment
by mh_zalabany＠hotmail.com 25 Mar '13

25 Mar '13

Could you please tell us what is the name of the company that you deal with Sent from my HTC ----- Reply message ----- From: "Amir Seni" <amirseni(a)gmail.com> To: "Koha Mailing lists" <koha(a)lists.katipo.co.nz> Subject: [Koha] Koha 3.10 hosting in a shared webhosting environment Date: Mon, Mar 25, 2013 2:00 pm I currently have koha running on a "low end vps" 2 cpu cores with 512mb ram which is dynamic to 1gb. with an offloaded mysql hosted database. I currently pay 6.95US$ per month and maybe cheaper ones are available. Performance per dollar is acceptable. rebuilding an index with 45000 items takes about 15minutes. my local installation takes about 10mins. I think you should look up "low end vps box" and see what you can find. Amir _______________________________________________ Koha mailing list http://koha-community.org Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

1 0

Re: [Koha] Koha 3.10 hosting in a shared webhosting environment
by Amir Seni 25 Mar '13

25 Mar '13

I currently have koha running on a "low end vps" 2 cpu cores with 512mb ram which is dynamic to 1gb. with an offloaded mysql hosted database. I currently pay 6.95US$ per month and maybe cheaper ones are available. Performance per dollar is acceptable. rebuilding an index with 45000 items takes about 15minutes. my local installation takes about 10mins. I think you should look up "low end vps box" and see what you can find. Amir

1 0

ERROR 1064 (42000) at line 1004
by Vimal Kumar V. 25 Mar '13

25 Mar '13

Dear Friends, I got the following error at the step 3 of installation of Koha 3.12 alpha. My ububuntu version is 12.10. The following error occurred while importing the database structure: ERROR 1064 (42000) at line 1004: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`reservesallowed` smallint(6) NOT NULL default "0", `branchcode` varchar(10) ' at line 20 Please contact your system administrator How can I solve this error? -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1

590, 946 Fields Koha to MARC Mapping
by David Lyons 25 Mar '13

25 Mar '13

Hi, Our MARC records place local note data in both the 590 and 946 fields, but I'm having trouble figuring out what these two fields should map to in Koha. Right now I've got 946 mapping to "notes" under "biblioitems", but that leaves me with no idea where to map 590. As far I can tell, I can't change any of the "items" fields without the framework test getting irritated, and even then none of those are wholly appropriate. Anyone dealt with a similar dilemma? Dave *Dave Lyons *Assistant Librarian *Office/办公电话:* (8610)6449 6914 *Fax/传真:* (8610)6449 6925 *Email/电子邮件: *d.lyons(a)thebeijingcenter.org *Site/网站: *http://www.thebeijingcenter.org ― This message is a private communication. The information contained in this message or attached to this communication may be protected from disclosure and may contain information that is legally privileged, proprietary, and/or confidential. If you are not the intended recipient, please do not read, copy, use, or disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it and any attachments from your system. Thank you.

1 0

Person contact in KOHA
by Hager Braham 25 Mar '13

25 Mar '13

Hi, I am looking to have a contact person I can ask some questions about KOHA. I checked many discussions lists and it is difficult to find a person who is in charge. It seems KOHA's community can help which is very confusing and I have no idea where to start. Thank you, Hager

2 1

Koha 3.12 beta released (and you can help!)
by Jared Camins-Esakov 25 Mar '13

25 Mar '13

About an hour ago I cut a beta for Koha 3.12.0. The tarball is available at http://download.koha-community.org/koha-3.12.00-beta1.tar.gz and the release notes at http://git.koha-community.org/gitweb/?p=koha.git;a=blob_plain;f=misc/releas… Packages will follow in the squeeze-dev repository sometime at the beginning of the week. As a reminder, Koha 3.12 is in feature freeze so any features that are not in the beta will not be in Koha 3.12, and I will not respond to any complaints about features that didn't make the cut-off other than forwarding them to the Koha mailing lists. So, what now? Now, we seek out and destroy bugs! If you have a spare testing server, take the beta for a spin, and try to break it. "Sure," you say, "I know that I can do that. But what can I help with that deserved an exclamation mark in the subject line?" I'm glad you asked. Here is a list of some things that need to be done before May 22: * Koha has to be translated. I will be asking the Translation Manager to pull the latest strings into Pootle so that the translation teams can get a head start (and if you know any language other than American English, you can help translate! Head on over to http://translate.koha-community.org/ and get started) * Koha's documentation has to be updated. We have a Documentation Manager, but if you have any ideas about how to document a new feature, or an old feature, or clarify instructions, you, too, can write documentation. Take a look at http://wiki.koha-community.org/wiki/Editing_the_Koha_Manual if you want to work on this. * Koha's installation instructions need to be updated. Some of the installation instructions that are included in the tarball were last updated (for all practical purposes) in 2010. That's a long time ago in computer time. If you have some thoughts on how the various INSTALL.* files in the tarball might be updated to be more clear, open up a text editor and send in your corrections (preferably as a patch, but if you have suggestions and are not comfortable with git, an e-mail to koha-devel will work too). * Enhancement bugs need to be reclassified. During the 3.12 release cycle we added a new category of bug report: "New feature." However, a lot of the new features that are going into 3.12 are still listed as "enhancements" in Bugzilla, which means the automated release notes generator doesn't pick them up properly. Any time the RM spends fixing that is time the RM does not spend fixing problems with Koha. This is is a task that anyone can do. All it takes is a bit of critical thinking and an account on Bugzilla: http://bugs.koha-community.org/bugzilla3/ * Open bug reports need to be (re)confirmed. We have scads of bug reports in Bugzilla, and many of them probably report bugs that have been fixed for weeks, months, or years. If we can get all the bugs that are already fixed closed, it'll be easier to focus on the bugs that still exist. Head on over to Bugzilla, choose some old bugs, and start testing! * Bugs need to be fixed. This goes hand-in-hand with the testing that you've all heard me to talk to death, but once a bug has been found, it has to be fixed. If you know how to fix a bug, please do! * Bug fixes need to be tested. There are many bugfixes already on bugzilla, and there will be many more being written in the next two months. After a patch has been written, it has to be tested by at least one third party (i.e. not the developer and not me) in order to move through the QA process to inclusion in Koha. Even if you don't have a spare server, you can test patches in the sandboxes hosted by BibLibre: http://wiki.koha-community.org/wiki/Sandboxes * Volunteers must be found, recruited, and/or made for 3.14. If you want to be involved in 3.14, there's still time to volunteer for an open position. Just put your name on the ballot at http://wiki.koha-community.org/wiki/Roles_for_3.14 Regards, Jared Camins-Esakov -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins(a)cpbibliography.com (web) http://www.cpbibliography.com/

2 1

Koha 3.8.11 released
by Chris Cormack 24 Mar '13

24 Mar '13

The Koha release team, in association with the multitude of Koha libraries, librarians, support companies, developers and users, are proud to announce the release of the latest stable release of the 3.8.x branch, 3.8.11. This maintenance release contains code from 12 people from 9 different organisations, making it once again a great example of international and inter company collaboration. Making the official and community supported Koha live up to its’ promise of no single vendor lock in. As always you can download the tarball at download.koha-community.org, or wait for a day or 2 until the packages at debian.koha-community.org are updated. Please read below for the release notes RELEASE NOTES FOR KOHA 3.8.11 22 Mar 2013 ======================================================================== Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.8.11 can be downloaded from: http://download.koha-community.org/koha-3.08.11.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.8.11 is a bugfix/maintenance release. Major fixes of 3.8.11 ====================== Acquisitions ---------- 4266 major encumbrance and expenditure not used in code Cataloging ---------- 7253 major fast cataloging not always checking out Searching ---------- 8620 critical Barcode searching not working correctly Bugs fixed in 3.8.11 ====================== Cataloging ---------- 9377 normal itemtype in duplicate biblio search 9207 minor Improve z39.50 speed slowdowns for sites with many records Circulation ---------- 8054 normal can hit submit twice when paying fines 8682 normal quick slip: renewals do not appear on quick slips Documentation ---------- 9267 normal Ubuntu 12.04 install docs broken MARC Bibliographic record staging/import ---------- 5333 normal Undefined value stops import from z39.50 OPAC ---------- 9585 minor Fix spelling mistake in default tab conditional for opac-detail Packaging ---------- 9784 minor koha-shell missing from koha-common man page Staff Client ---------- 9663 normal Individual bibliographic record "Save" option requires export permission 9658 trivial Breadcrumb wrong on reports dictionary System Administration ---------- 7596 normal System preferences editor JavaScript contains untranslatable English string Templates ---------- 9695 normal Use alphabet system preference on page used to browse patrons for patron card batches 9385 minor patron add labels right aligned in chrome 9545 minor Fix Import Marc Bibliographic Framework Text Label 9586 minor Remove $ENV{DEBUG} info from Member Template 9651 minor When deleting a fund, button is wrongly labelled with 'Delete this budget' Z39.50 / SRU / OpenSearch Servers ---------- 9520 minor Update default LOC Z39.50 target Enhancements in 3.8.11 ====================== Templates ---------- 9650 Show message if there are no notices 9765 Remove unused include file: budgetperiods-admin.inc New sysprefs in 3.8.11 ====================== System requirements ====================== Important notes: * Perl 5.10 is required * Zebra is required Documentation ====================== As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the English version of the Koha manual is available: http://manual.koha-community.org/3.8.11/en/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations ====================== Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * English (USA) * Arabic (99%) * Armenian (99%) * Chinese (Taiwan) (75%) * Danish (74%) * English (New Zealand) (99%) * French (99%) * French (Canada) (76%) * German (99%) * German (Switzerland) (99%) * Greek (74%) * Italian (100%) * Norwegian Bokmål (67%) * Portuguese (100%) * Portuguese (Brazil) (99%) * Slovak (100%) * Spanish (100%) * Turkish (100%) Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team ====================== The release team for Koha 3.8.11 is Release Manager: Paul Poulain <paul.poulain(a)biblibre.com> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: Frédéric Demians <frederic(a)tamil.fr> QA Manager: Ian Walls <koha.sekjal(a)gmail.com> QA team: Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl>, Jonathan Druart <jonathan.druart(a)biblibre.com> Mason James <mason(a)kohaaloha.com> Bug Wranglers: Katrin Fischer, Magnus Enger Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.6.x): Jared Camins-Esakov <jcamins(a)cpbibliography.com> Release Maintainer (3.8.x): Chris Cormack <chrisc(a)catalyst.net.nz> Credits ====================== We thank the following libraries who are known to have sponsored new features in Koha 3.8.11: We thank the following individuals who contributed patches to Koha 3.8.11. * 2 Tomas Cohen Arazi * 1 D Ruth Bavousett * 2 Jared Camins-Esakov * 2 David Cook * 3 Chris Cormack * 1 Jonathan Druart * 1 Kyle M Hall * 2 Bernardo Gonzalez Kriegel * 7 Owen Leonard * 3 Liz Rea * 3 Fridolyn SOMERS * 1 Mathieu Saby We thank the following companies who contributed patches to Koha 3.8.11 * 7 ACPL * 4 Biblibre * 2 BigBallOfWax * 1 ByWater-Solutions * 2 C & P Bibliography * 4 Catalyst * 2 Prosentient Systems * 1 Université Rennes 2 * 5 unidentified We also especially thank the following individuals who tested patches for Koha 3.8.11. * 24 Jared Camins-Esakov * 3 Galen Charlton * 2 David Cook * 26 Chris Cormack * 2 Elliott Davis * 14 Jonathan Druart * 1 Jonathan Druarth * 2 Nicole C. Engard * 4 Katrin Fischer * 5 Kyle M Hall * 3 Bernardo Gonzalez Kriegel * 2 Owen Leonard * 1 Liz Rea * 1 Martin Renvoize * 3 Marcel de Rooy * 1 Robin Sheat * 2 koha.aixmarseille We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for this version of Koha and future bugfixes in this release line is 3.8.x. The last Koha release was 3.6.11, which was released on December 27, 2012. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini

3 2