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

Reminder: General IRC meeting is 5 March 2014 at 19:00 UTC
by Owen Leonard 05 Mar '14

05 Mar '14

This is a reminder that the next general IRC meeting is 5 March 2014 at 19:00 UTC (in about 4 hours as of this writing) Koha community members are encouraged to attend. To find out what time the meeting is in your time zone go to: http://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+IRC+General+M… Please add any items that you have to the agenda at: http://wiki.koha-community.org/wiki/General_IRC_meeting_5_March_2014 Information about IRC - if you are new to IRC see http://koha-community.org/get-involved/irc/ and http://www.wikihow.com/Get-Started-with-IRC-%28Internet-Relay-Chat%29 -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

4 4

Koha Community Newsletter: February 2014
by Koha Newsletter 05 Mar '14

05 Mar '14

Fellow Koha users: The Koha Community Newsletter for February 2014 is here: http://koha-community.org/koha-community-newsletter-february-2014/<http://koha-community.org/koha-community-newsletter-january-2014/> We hope to improve the the development section in the next newsletter. Stay tuned. Thanks!

1 0

Invitation to Survey on Design patterns
by Bouwers, P. 04 Mar '14

04 Mar '14

Dear Koha Developer, We are two students from the University of Groningen doing research on the impact of design patterns on software quality attributes. As part of this research we are conducting a survey among software developers. We would like to include your perspective on this subject and hope you would be willing to participate in this survey. The survey will take approximately 10 to 15 minutes. To complete the survey, please go to the following link: https://www.surveymonkey.com/s/Y9XCWHB. Thank you in advance; your input is very valuable to us. Thanks for your time, P. Bouwers (p.bouwers(a)student.rug.nl) W. Visser (w.m.visser.1(a)student.rug.nl)

1 0

Re: [Koha-devel] File sizes
by Paul A 04 Mar '14

04 Mar '14

At 12:59 PM 2/28/2014 -0800, Galen Charlton wrote: >Hi, > >On Fri, Feb 28, 2014 at 12:37 PM, Michael Hafen ><michael.hafen(a)washk12.org> wrote: >[snip] > > -rw-rw---- 1 mysql mysql 1551892480 Feb 28 12:53 import_records.ibd >[snip] > > -rw-rw---- 1 mysql mysql 490733568 Feb 28 13:30 zebraqueue.ibd > >One thing to note is that if you use cleanup_database.pl to do things >like trim the zebraqueue table or purge old staged import records, We've found that it's the 'sessions' that accumulate. We cron it every morning at 3am, but I just ran it manually now (13.5 hours later) and get: whoever@nelson:/usr/share/koha$ ./bin/cronjobs/cleanup_database.pl --sessions -v Session purge triggered. 55203 entries will be deleted. Done with session purge. [This is maybe [???] due to some bots that don't respect the robots.txt (baidu? I'm getting close to blocking them at router level)] zebraqueue (same 13.5 hours) only gave me '602 records were deleted.' and whoever@nelson:/usr/share/koha$ ./bin/cronjobs/cleanup_database.pl --import 1 -v Purging records from import tables. Done with purging import tables. is not 'verbose' despite the -v ;={ Best - Paul

3 2

Signoff request bug 9972
by Mirko 04 Mar '14

04 Mar '14

Dear list, I would like to ask for a signoff for a patch I did a few months ago. It is crucial for the library I work for. My employment is going to end in March and it would be nice to leave a clean situation (ie. not building their own packages forever). I have done most of my work on Koha in my spare time. Due to my exams I have not been very active during the last months but I am sure I did a lot more testing for others than I required for my own patches altogether (and I plan to continue once I have more time on my hands). I have just rebased it and it would be nice if somebody could take a look and either signoff or comment on problems (if any). The bug number is 9972. http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9972 Thank you, Mirko / drojf

2 2

Take Koha Backup and Restore the same without Command
by DP Tripathi 03 Mar '14

03 Mar '14

Dear colleagues, Take the backup and restore the same in Koha without Command. Download the ISO image from the link given below and install the latest Koha version with an option to take Koha backup & restore with GUI using phpMyadmin. ISO Image: http://librarianguide.in/wp-content/uploads/2013/10/Koha-3.14.iso How to take backup & restore video: http://librarianguide.in/library-automation/koha-with-1-command/koha-backup… How to take backup & restore instructions: (PDF File): http://librarianguide.in/wp-content/uploads/2013/10/howtotakebackupandresto… Feel free to write at dptkvs(a)gmail.com Thanks with kind regards, -- ********************* D. P. Tripathi Assistant Librarian Biju Patnaik Central Library NIT Rourkela Odisha - 769008 www.librarianguide.in **********************

1 0

File sizes
by Paul A 28 Feb '14

28 Feb '14

Recent exchanges on "how big a hard disk do you need" (associated possibly with bug 11830) prompted me to have a look for "big" files on our production box. The worst offender appears to be /var/lib/mysql with the "oracle bug" for ibdata: -rw-rw---- 1 mysql mysql 1335885824 Feb 28 18:41 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Feb 28 18:41 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 Feb 28 18:41 ib_logfile1 This has been running for 437 days, so I had a look at the sandbox (last completely rebuilt less than two months ago when I looked into git), and the results are not much better: -rw-rw---- 1 mysql mysql 1117782016 Feb 28 18:43 ibdata1 [log files identical] Two questions if I may. First, are my numbers typical? Second, has MariaDB been shelved permanently? Thanks and best regards, Paul

3 3

Re: [Koha-devel] File sizes
by Paul A 28 Feb '14

28 Feb '14

At 11:29 AM 2/28/2014 -0800, Galen Charlton wrote: >Hi, > >On Fri, Feb 28, 2014 at 10:52 AM, Paul A <paul.a(a)navalmarinearchive.com> >wrote: >[snip] > > -rw-rw---- 1 mysql mysql 1117782016 Feb 28 18:43 ibdata1 > > [log files identical] > > > > Two questions if I may. First, are my numbers typical? > >Hard to say without knowing how many bibs you have. Thanks Galen -- ~35k bibs , but (probably atypically because of serials) more than 150k items. >Regardless, if you're not using the innodb_file_per_table option, [snip] No -- we're not at the moment. Next upgrade (May/June this year), we intend (but see MariaDB below) to use mysql 5.6 which defaults to per_table. > > Second, has MariaDB been shelved permanently? >Far from it. At present, I've seen no issues using MariaDB 5.5 as a >drop-in replacement for MySQL, either on my personal development boxes >or in production use. Sounds good (particularly the "production use" part) -- I had seen Bug 5366 which doesn't appear to be signed off. Is there a Koha write-up anywhere on implementing MariaDB? I've never even played with it, but understand that the Oracle/ibdata problem is non-existent. tnx and br -- paul

1 0

Tax in acquisitions (again..)
by BOUIS Sonia 28 Feb '14

28 Feb '14

I'm still trying to find a solution for the way to handle the tax in acquisitions. I have made some tests in the master : Here are my notes : 1. Prices are saved like it's defined in the vendor : for example if List item price includes tax is set to "no", prices is saved with no recalculation, so tax exclusive. Why not. 2. Prices rrp and ecost are changing after receipt : it has the same value than listprice before receipt but the same value than unitprice after receipt. Why not, I'm not sure it's a good idea to change ecost but it's not a big problem. 3. When the tax isn't taking into account as the same way (example: list price is tax inclusive and invoice price is tax exclusive and vice versa), after receipt prices displayed in invoice.pl and parcel.pl are wrong. Tax is added or subtracted one more time. But values are good in database. I'll test this bug (http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10613) or fill a new bug. 4. In order, gstrate is not the one defined in the vendor but 0 by default. I can complete this bug (http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3980) or fill a new bug for this. 5. In the budget summary, in the home acquisition page, if prices are filled tax exclusive, tax isn't added. But library pay the tax so it should be added in the count. See this bug for this : http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10613 I see only 2 responses at the list of questions in the koha list : I'm not sure we can do conclusions with this ? What do you think about those points ? Best Regards Sonia BOUIS ------------------------------------------------------ Responsable du Système intégré de gestion des bibliothèques SERVICE COMMUN DE LA DOCUMENTATION Université Jean Moulin Lyon 3 6 Cours Albert Thomas - B.P. 8242 - 69355 Lyon Cedex 08 ligne directe : +33 (0)4 78 78 79 03 | Fax : +33 (0)4 78 78 79 89 ------------------------------------------------------ http://scd.univ-lyon3.fr<http://scd.univ-lyon3.fr/> L'Université Jean Moulin est membre fondateur de l'Université de Lyon

1 0

3.14 Koha (Pie)
by Brendan Gallagher 28 Feb '14

28 Feb '14

Hello All - I just wanted to let you all know - that we've order a pie from a bakery in Seattle, Washington - to be delivered to Galen Charlton's (the fearless RM of 3.14) house. We've ordered it to be signed by the Koha Dev team. Thanks for the hard work Galen - I thought it was about time that you got that Pie that you released. Cheers, Brendan --------------------------------------------------------------------------------------------------------------- Brendan A. Gallagher ByWater Solutions CEO

2 1