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

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

Running Koha 3.2 and 3.4
by Nicole Engard 17 Jan '11

17 Jan '11

Hi all, I have seen a bunch of messages from chris_n saying that we need to test our patched on Koh 3.2.x as well as the current HEAD. So my question is how do you all do that? I have one local virtual machine with HEAD on it - I have no clue how to have both 3.2.x and HEAD. I tried copying my VM and while it looks like that went okay, I have no idea how to access that VM via the browser to actually test Koha. So I guess I'm looking for a tutorial and/or guidance on how to keep two installs up to date. Nicole

2 1

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

15 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

2 1

3.2.3 Release Schedule
by Chris Nighswonger 15 Jan '11

15 Jan '11

Hi all, 3.2.3 is on track to be released on January 22, 2010, however, there is another important date between now and then which I wanted to point out. On January 15, 2011, 3.2.3 will enter a string freeze to facilitate finalization of translation updates. After this date the only patches introducing string changes which will be pushed for 3.2.3 will be those addressing blocker bugs or security issues. All others will be pushed to 3.2.4. Patches not introducing string changes will be pushed up to the time of the release. Keep up the good work! Kind Regards, Chris Nighswonger 3.2 Release Maintainer

1 2

Koha - Advanced cataloging search RFC on 001
by Linda Culberson 14 Jan '11

14 Jan '11

In the wiki, it has that Howard County Library was proposing an RFC to allow searching on the 001. http://wiki.koha-community.org/wiki/Advanced_cataloging_search_RFC In the old documentation that is on LibLime's site, it says "field 001 is a special field that you cannot map data to in Koha" We need to be able to link to that number. Does anyone have any ideas about how to do so, since we cannot seem to keep our current id's when migrating to Koha 3.2? Thanks. -- Linda Culberson lculber(a)mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824

3 5