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

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

Call for Development news - February Newsletter
by Koha Newsletter 27 Feb '14

27 Feb '14

Koha Developers ~ We'd like to improve our coverage of Koha developments in the monthly newsletter. We'll be checking the feeds, wiki and IRC minutes, however ... If you have any suggestions for us or projects/items/features/fixes you think are important [ or interesting ] for the community to know about we'd appreciate your input and knowledge. k o h a news AT gmail dot com Thank you! [ I'll send this email out sooner next month ...sorry for the late notice! CR ] -- Chad Roseburg Joanne Dillon Editors, Koha Newsletter

1 0

DataTables - using class names in aTargets
by Galen Charlton 27 Feb '14

27 Feb '14

Hi, There have been a fair number of bugs filed for fixing table sorting as columns get added to or removed from tables. At root, they stem from our current habit of referring to columns by numeric position in aoColumns and aoColumnDefs/aTargets, e.g., { "aTargets": [ 1, 2 ], "sType": "natural" } and "aoColumns": [ { "sType": "title-string" },{ "sType": "html" },null,{ "sType": "title-string" },null,null,null,null,null,null[% IF ( exports_enabled ) %],null[% END %] ], However, the documentation for DataTables says that aTargets doesn't have to be just an array of integers; it can also be "a string - class name will be matched on the TH for the column". To reduce the risk of silly columns-sorting bugs, I suggest that we adopt a practice of using descriptive CSS class names for table headers and using the class names in aoColumnsDefs/aTarget specifications, and dropping the use of aoColumns. Thoughts? Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

3 3

Re: [Koha-devel] DataTables - using class names in aTargets
by David Cook 27 Feb '14

27 Feb '14

+1 -----Original Message----- Date: Tue, 25 Feb 2014 09:34:55 -0800 From: Galen Charlton <gmc(a)esilibrary.com> To: "koha-devel(a)lists.koha-community.org" <koha-devel(a)lists.koha-community.org> Subject: [Koha-devel] DataTables - using class names in aTargets Message-ID: <CAPLnt64r5EfNogfH2Q=_RWux=f3E9BuALOS5Ggnft_FkrqQH_g(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Hi, There have been a fair number of bugs filed for fixing table sorting as columns get added to or removed from tables. At root, they stem from our current habit of referring to columns by numeric position in aoColumns and aoColumnDefs/aTargets, e.g., { "aTargets": [ 1, 2 ], "sType": "natural" } and "aoColumns": [ { "sType": "title-string" },{ "sType": "html" },null,{ "sType": "title-string" },null,null,null,null,null,null[% IF ( exports_enabled ) %],null[% END %] ], However, the documentation for DataTables says that aTargets doesn't have to be just an array of integers; it can also be "a string - class name will be matched on the TH for the column". To reduce the risk of silly columns-sorting bugs, I suggest that we adopt a practice of using descriptive CSS class names for table headers and using the class names in aoColumnsDefs/aTarget specifications, and dropping the use of aoColumns. Thoughts? Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc(a)esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org

3 2

Feedback requested
by Mark Tompsett 26 Feb '14

26 Feb '14

Greetings, I was wondering if other developers would care to comment on recommended disk space sizes for a git install on Bug 11830. Thank you! GPML, Mark Tompsett

3 2