January 2011 - Koha-devel - lists.koha-community.org

Softlink Alice import to koha
by Cybermon 26 Jan '11

26 Jan '11

Dear koha developer, I would like to ask 2 questions from you. 1. I would like to import catalog information from the Softlink Alice/library software/ to koha ILS. Could you help me that how can i import our book catalog with items and barcodes to Koha. 2. How can i install other additional languages/Mongolian/ after installed Koha on server? When I following the wiki guide than i have following error. Install templates 'opac From: /usr/share/koha/opac/htdocs/opac-tmpl/prog/en/ To : /usr/share/koha/opac/htdocs/opac-tmpl/prog/mon With: /usr/share/koha/intranet/cgi-bin/misc/translator/po/mon-i-opac-t-prog-v-3002000.po Can't exec "/usr/share/koha/intranet/cgi-bin/misc/translator/ tmpl_process3.pl": No such file or directory at LangInstaller.pm line 286. Install templates 'intranet From: /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/ To : /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/mon With: /usr/share/koha/intranet/cgi-bin/misc/translator/po/mon-i-staff-t-prog-v-3002000.po Can't exec "/usr/share/koha/intranet/cgi-bin/misc/translator/ tmpl_process3.pl": No such file or directory at LangInstaller.pm line 286. Koha directories hierarchy for mon must be created first root@UBPLServer:/usr/share/koha/misc/translator# perl translate install mon readdir() attempted on invalid dirhandle $fh at LangInstaller.pm line 62. closedir() attempted on invalid dirhandle $fh at LangInstaller.pm line 63. Install templates Best regards, Gana

1 0

Koha 2 to Koha 3
by Charl 24 Jan '11

24 Jan '11

?I am upgrading one of our sites from 2.9 to 3. I cannot find the procedure anywhere. Can anyone please help with the procedure? Thank you.

2 1

GIT repository Lyon 2 University
by Fridolyn SOMERS 24 Jan '11

24 Jan '11

Hie, Progilone has finished the Koha project for Lyon 2 University (France). You can find all features developed on our GIT repository http://git.progilone.com/. Each feature is in a branch started from 3.2.0 master revision from koha-community. Feel free to ask for details. Best regards, -- Fridolyn SOMERS ICT engineer PROGILONE - Lyon - France fridolyn.somers(a)gmail.com

3 3

Koha 3.2.3 is now available
by Chris Nighswonger 23 Jan '11

23 Jan '11

It is with pleasure that I announce the release of Koha 3.2.3. The package can be retrieved from: http://download.koha-community.org/koha-3.02.03.tar.gz You can use the following checksum and signature files to verify the download: http://download.koha-community.org/koha-3.02.03.tar.gz.MD5 http://download.koha-community.org/koha-3.02.03.tar.gz.MD5.asc http://download.koha-community.org/koha-3.02.03.tar.gz.sig Release notes for 3.2.3 are below the fold. Come and get it! [More...] RELEASE NOTES FOR KOHA 3.2.3 - 22 January 2011 ======================================================================== 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.2.3 can be downloaded from: http://download.koha-community.org/koha-3.02.03.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation Koha 3.2.3 is a bugfix/maintenance release. Highlights of 3.2.3 ====================== Some of the higher profile bugs addressed in this release are: 4286 Subscription expired at its creation 4438 incorrect "Budget total exceeds period allocation" error when editing fund 4945 Patron search is limited by default to the currently logged-in library 5480 Some usual UNIMARC cataloguing plugins doesn't work anymore 5542 Limit to availability not working 5611 can't add comments and tags in the OPAC when mod_perl is activated This release also contains a variety of minor enhancements improving Koha's interface and underlying scripts. Bugs fixed in 3.2.3 ====================== 3153 'maxoutstanding' syspref does not disallow placing holds on staff side 3199 batchRebuildBiblioTables.pl failed due to missing argument 3262 OPAC needs syspref to show homebranch instead of current location on detail page 3347 Inconsistencies with tables in opac-shelves.tmpl 3459 topissues doesn't take care of ccode. 3550 Use GetRecordValue to get the subtitle 3737 search order title should me more fuzzy 3743 Acquisition stats ordering by month 3859 Attach Item Clarification 3918 Add to order lists inconsistent 3987 New Sys Prefs Branch - Alphabetize prefs in sections 4131 link on subscripton page says 'create routing' even when one exists 4473 Recent comments view for the OPAC 4826 Choose either 'new basket' or 'add basket' 4885 Only 1 ISBN shows in non-XSL detail view 4891 Order facets in left sidebar of search results 4908 OPAC patron details page doesn't show patron's home library 4942 When a new patron is created and the expiry date is left blank, it comes up with an invalid date 4946 hold warning needs rewording 4950 checkbox should be removed when can't place a hold 4984 Invalid XHTML in staff client search results 4997 More searches menu not on OPAC MARC and ISBD detail pages 5006 Invalid XHTML in record matching rules template 5040 "Distance" misspelled in default framework 5045 The help doesn't work if something strips the referrers 5055 crontab.example should use standard file paths 5143 Subtitles not showing on view_holdsqueue.pl 5294 Vendor name shows with '%20' 5327 Unit tests required for all C4 modules 5374 Update date/time last transaction (MARC 005) when saving biblio record 5375 Update date/time last transaction (MARC 005) when saving authority record 5398 several pages in the staff interface do not obey noItemTypeImages 5399 remove useless eval 'use C4::Foo' 5403 C4::Koha::DisplayISBN should be wrapper for Business::ISBN->as_string 5419 account fees not showing as reason to not check out 5446 Item creation in Acquisition module doesn't control mandatory fields 5451 can add tags with userlogin turned off 5470 improvements to results display in the staff client 5486 HomeOrHoldingBranch description inaccurate 5489 Send hold email to branch email address if it exists instead of koha email address 5492 import patrons page title reads 'cataloging' 5497 add option to supply library phone #, address, and other fields to circ receipts 5510 Hard to tell what instance a cron error comes from 5518 Add to shelf icon doesn't appear in OPAC results page 5526 List of lists should be in alphabetical order by list name 5531 Missing sysprefs in language specific files 5550 Wrong file name in package-installed docs 5556 OPAC does not display the type of authority 5557 Logs cannot be viewed by user with granular permission view_system_logs 5562 circ history says 'issues' instead of 'checkouts' 5563 note on enhanced content about cover images inaccurate 5570 item types not showing on other editions 5571 tags as bulleted list too long 5582 MARC Field Documentation links incorrect on tags < 080 5583 Rename variable to reflect what it is 5585 today's date does not display on receipts and slips 5589 Duplicate Code in Suggestions 5601 SIP Due dates miscalculated via DateTime 5603 advance_notices.pl generating "uninitialized value in hash element" 5604 additional icons for the Seshat set Commits in 3.2.3 without a referenced bug report: * Added more unit tests to check when JSONStream should fail. * Added unit tests to test all of get_amazon_tld in Amazon.pm. * Added unit tests for Biblio and moved it to db_dependent as it requires the database. * Added unit tests using a test database for XISBN. * Created unit testing using the testdatabase for XISBN. * Added extra unit tests to Debug.t * Adding new developers to the history * Removing OPACNoResultsFound Enhancement Syspref * Deleted old sample budget sql-data for Ukrainian and Russian System requirements ====================== Changes since 3.0: * The minimum version of Perl required is now 5.8.8. * There are a number of new Perl module dependencies. Run ./koha_perl_deps.pl -u -m to get a list of any new modules to install during upgrade. Upgrades ====================== The structure of the acquisitions tables have changed significantly from 3.0.x. In particular, the budget hierarchy is quite different. During an upgrade, a new database table is created called fundmapping that contains a record of how budgets were mapped. It is strongly recommended that users of Koha 3.0.x acquisitions carefully review the results of the upgrade before resuming ordering in Koha 3.2.x. 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, several translations of the Koha manual are available: English: http://koha-community.org/documentation/3-2-manual/ Spanish: http://koha-community.org/documentation/3-2-manual-es/ French: http://koha-community.org/documentation/3-2-manual-fr/ 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: * Chinese * Danish * English (New Zealand) * English (USA) * French (France) * French (Canada) * German * Greek * Hindi * Italian * Norwegian * Portuguese * Spanish * Turkish Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://www.kohadocs.org/usersguide/apb.html 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.2 is Release Manager: Galen Charlton <gmcharlt(a)gmail.com> Documentation Manager: Nicole Engard <nengard(a)gmail.com> Translation Manager: Chris Cormack <chris(a)bigallofwax.co.nz> Release Maintainer (3.0.x): Henri-Damien Laurent <henridamien.laurent(a)biblibre.com> Release Maintainer (3.2.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Credits ====================== We thank the following individuals who contributed patches to Koha 3.2.3: Nahuel Angelinetti Claudia Colin Campbell Galen Charlton Chris Cormack Frédéric Demians Johnboy Marcel de Rooy Serhij Dubyk {Сергій Дубик} Nicole Engard Magnus Enger Amit Gupta Srdjan Jankovic Henri-Damien Laurent Owen Leonard Chris Nighswonger Liz Rea Bryce Sanchez Robin Sheat Spartaness Zach Sim Ian Walls We regret any omissions. If a contributor has been inadvertantly missed, please send patch against these release notes to koha-patches(a)lists.koha-community.org. The 3.2.x Release Maintainer especially thanks the 3.4 Release Team and all who participated in QA for their diligent labors in testing and pushing well over 287 patches since the 3.2.0 relese. Their continued work very much makes possible the release of 3.2.3 on its announced schedule. 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 Koha 3.2.x (i.e., this version of Koha and future bugfix releases) is 3.2.x. The next major feature release of Koha will be Koha 3.4.0. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Naku te rourou, nau te rourou, ka ora ai te iwi.

1 0

January Newsletter: Call for Articles
by Nicole Engard 22 Jan '11

22 Jan '11

Hi all, After our IRC meeting this month I am going to try and keep doing this monthly. The new publication date for 2011 will be the 25th of the month. I need all your articles (preferably short - with links to longer articles if there is more to share) sent to me by the 23rd your local time. Thanks in advance for all contributions, Nicole C. Engard Documentation Manager

1 2

Charting/Analysis for Koha
by savitra sirohi 19 Jan '11

19 Jan '11

Folks, I am looking for suggestions on the best long term, architectural solution to add charting for Koha reports. Do we use: - Google visualization API - Perl module Chart - Perl module GD - something else? Also any input on adding Business Intelligence capabilities? - Perl module Business::Intelligenece::Microstrategy - Integrate with other open source BI tool like Pentaho, Jaspersoft - something else? Thanks! Savitra

8 12

Out of the Office
by adrea＠moablibrary.org 19 Jan '11

19 Jan '11

I will be on vacation from Saturday 1/8/11 to Wednesday 2/2/11. I apologize for any inconvenience! For immediate assistance during regular library hours, please call the library information desk at 435-259-1111 ext0. I will respond to your email as soon as possible when I return to work. Thank you, Adrea Adrea Lund Head of Adult Services Grand County Public Library 257 E. Center St. Moab, UT 84532 435-259-1111 ext11 www.moablibrary.org

4 3

Out of the Office
by adrea＠moablibrary.org 19 Jan '11

19 Jan '11

I will be on vacation from Saturday 1/8/11 to Wednesday 2/2/11. I apologize for any inconvenience! For immediate assistance during regular library hours, please call the library information desk at 435-259-1111 ext0. I will respond to your email as soon as possible when I return to work. Thank you, Adrea Adrea Lund Head of Adult Services Grand County Public Library 257 E. Center St. Moab, UT 84532 435-259-1111 ext11 www.moablibrary.org

1 0

Re: [Koha-devel] [Koha] Flood recovery in Brisbane - pulling data from Koha
by Joann Ransom 19 Jan '11

19 Jan '11

Hi Amanda, I can't even begin to imagine what turmoil your brain is coping with kudos to you for asking for help. I see Bob Birchall has contacted you - that is great and I love that they are offering to help for free :D You may not even need the backend; if the catalogue is up then you can haul out what you need from a web browser. If you want to chat through / bounce off ideas working through this please feel to sing out. Chin up - you will get through this. Cheers Jo. On Wed, Jan 19, 2011 at 5:45 PM, Amanda and Hugh Gardner < hagardner(a)bigpond.com> wrote: > Thanks Jo, > > I did wonder about pulling out the info on cost and I hadn't thought about > last seen, on loan and purchase date. Thanks! I was too busy trying to > work out how to do it. I'll update my process to include. At the moment I > can't access the backend but am hoping to be able to do that tomorrow. IT > is having huge difficulties providing me with remote access. > > Cheers, > > Amanda > ------------------------------ > *From:* hfields19(a)gmail.com [mailto:hfields19@gmail.com] *On Behalf Of *Joann > Ransom > *Sent:* Wednesday, 19 January 2011 2:36 PM > *To:* Amanda and Hugh Gardner > *Cc:* koha(a)lists.katipo.co.nz > *Subject:* Re: [Koha] Flood recovery in Brisbane - pulling data from Koha > > Hi Amanda, > > I should think you will be able to run any number of reports over the Koha > data to haul out whatever 'results' you need so long as the backend data is > available. It is easy to manipulate reports data in excel but the 64,000 > line limit is a trap for young players (Access is better). > > You will probably also want to know the stock which was not currently on > issue or loan. A last seen date might be useful too if you need to justify > that the stock list is current ie not 'lost'. > > You may also want to extract the data about cost and list prices and date > of purchase in order to get a sense of the value of the lost stock. You may > need to sort by purchase date and claim 90% of the value of stock less than > 1 year old but only 10% of stock 9 years old etc. > > Good luck > > Cheers Jo. > > 2011/1/19 Amanda and Hugh Gardner <hagardner(a)bigpond.com> > >> Hi All, >> >> I'm hoping I can get some advice with regard to pulling data from Koha. >> >> My library has recently been completely inundated during the Brisbane >> floods and nothing was saved except the library catalogue on Koha! I am the >> current librarian, however, I have only been in the position for four weeks >> and have not had a chance to learn the ins and outs of Koha. I am also not >> a techie so am relying on IT staff to assist with my queries which has not >> proved successful as they are off recovering other parts of the >> organisation's network. >> >> In order to create an inventory of the library collection for insurance >> purposes I would like to export data from the following fields and dump them >> into an Excel create an spreadsheet. >> >> The data I need are from the following fields: >> >> Item type >> Title >> Publisher >> Date >> ISBN >> ISSN >> Item count >> Location >> Barcode >> >> Can this be done from the back end of Koha and if so, how do I do it? >> >> Any advice would be greatly appreciated, keeping in mind I am not familiar >> with this database at all and will have no IT support. >> >> Many thanks, >> >> Amanda >> >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> > > > -- > Joann Ransom RLIANZA > Head of Libraries, > Horowhenua Library Trust. > > *Q: Why is this email three sentences or less? > A: http://three.sentenc.es* > > -- Joann Ransom RLIANZA Head of Libraries, Horowhenua Library Trust. *Q: Why is this email three sentences or less? A: http://three.sentenc.es*

1 0

Perl // operator
by Marcel de Rooy 18 Jan '11

18 Jan '11

Hi, I came across the new Perl 5.10 // defined-or operator in Koha code. (See below) The INSTALL doc says that we still run under Perl 5.8.8. Should we still refrain from using it? Regards, Marcel For instance in commit 8e5ee007db451f62fe17c456215013e422f25bec Author: Robin Sheat robin(a)catalyst.net.nz<mailto:robin@catalyst.net.nz> Bug 5186 - allow tax rates to be set to zero (master) Two examples: --- a/acqui/addorderiso2709.pl +++ b/acqui/addorderiso2709.pl - my $gst = $bookseller->{gstrate} || C4::Context->preference(" + # '//' is like '||' but tests for defined, rather than true + my $gst = $bookseller->{gstrate} // C4::Context->preference(" --- a/acqui/basketgroup.pl +++ b/acqui/basketgroup.pl @@ -137,8 +137,8 @@ sub BasketTotal { my @orders = GetOrders($basketno); for my $order (@orders){ $total = $total + ( $order->{ecost} * $order->{quantity} ); - if ($bookseller->{invoiceincgst} && ! $bookseller->{listincgst} && ( $b - my $gst = $bookseller->{gstrate} || C4::Context->preference("gist") + if ($bookseller->{invoiceincgst} && ! $bookseller->{listincgst} && ( $b + my $gst = $bookseller->{gstrate} // C4::Context->preference("gist")

6 8