gmane.education.libraries.koha.devel

[DISCUSSION] Database schema & coding guidelines

Paul Poulain — 2012-05-25T16:00:22

In the wiki page http://wiki.koha-community.org/wiki/DB_schema_bugs, an
insconsistency has been noticed:
primary keys column name can be: id (in authorised_values table), xxxid
(cityid), xxx_id (label_id), xxxId (limitId), xxxcode (branchcode),
xxxnumber (borrowernumber) => choose how to name PK and update schema
accordingly

The bug 7065 add a foreign key to the reserves table, so I think it's
time to clearly choose how we name primary keys.

The possible options are below, my opinion:

 1- id alone => will result in complexity & mistakes, this option must
be discarded
 2- xxxxid => short option, may result in hard readability.
 3- xxxxId => we haven't decided if we want UC in field names. I won't
discard this option, but does not favour it.
 4- xxx_id => _ still undecided in field names, I'm not sure it's much
better than the xxxid one
 5- xxxxnumber => number is quite long, and may result in very long
field names, which is not good. I does not like this option.

Let's start the discussion

Koha 3.6.5 released

Jared Camins-Esakov — 2012-05-25T14:12:26

The Koha release team is happy to announce the release of Koha 3.6.5

This is a stable release and contains bugfixes as well as updated
translations.

You can download it at

http://download.koha-community.org/

Go forth, download, and enjoy :)

RELEASE NOTES FOR KOHA 3.6.5
24 May 2012
========================================================================

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.6.5 can be downloaded from:

    http://download.koha-community.org/koha-3.06.05.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.6.5 is a bugfix/maintenance release.

Highlights of 3.6.5
======================

3916    critical    Batch Modify tool

Official Koha Newsletter: Volume 3, Issue 5: May 2012

Daniel Grobani — 2012-05-24T22:36:26

Official Koha Newsletter: Volume 3, Issue 5: May 2012

[Below is the text of the newsletter. For active links and a more
readable format, please visit
http://koha-community.org/koha-newsletter-volume-3-issue-5-may-2012]

Official Koha Newsletter (ISSN 2153-8328)
Volume 3, Issue 5: May 2012

Edited by Daniel Grobani, Koha Community Newsletter Editor.

Please submit news items to danielg.koha-Re5JQEeQqe9fmgfxC/sS/w< at >public.gmane.org

Table of Contents

    Koha Development
        Koha 3.8.1 Released
        Koha 3.6.5 Release Imminent
        Koha Statistics
        Database Schema Documentation Updated
    Koha Community
        New Koha Libraries
        Community Gossip
    Past Koha Events
        May General IRC Meeting
        New Zealand Koha User Group Day 2012
    Upcoming Koha Events
        June General IRC Meeting
        KohaCon12
        KohaCon13

Koha Development

Koha 3.8.1 Released
by Chris Cormack

The Koha release team is happy to announce the release of Koha 3.8.1.
This is a stable release

DateTime::Format::MySQL

Chris Nighswonger — 2012-05-24T13:50:33

Hi all,

The QOTD work recently committed to master adds DateTime::Format::MySQL as
a core dependency thereby extending DateTime objects to handle proper
formatting of datetime strings for MySQL.

While Koha::DateUtils will parse ISO formatted datetime strings, the POD
notes that the module is intended to be a temporary aid
to demystify DateTime foo while we are transitioning fully to DateTime:

"Koha has historically only used dates not datetimes and been content to
40
handle these as strings. It also has confused formatting with actual dates
41
this is a temporary module for wrappers to hide the complexity of
switch to DateTime"

There are similar DateTime::Format::<db> plugins for Pg, Oracle, and
friends which may be implemented in Koha as support for those db's is added.

Basically DateTime::Format::MySQL will parse a correctly MySQL formatted
datetime and return a DateTime object for your morphing pleasure.

It will also format a DateTime object and return a MySQL datetime string.

Read more here: http:

KOCT pushed on contrib repo

Paul Poulain — 2012-05-22T21:07:21

Hello,

I just pushed a few minuts ago a patch with KOCT on the contrib repository
(http://git.koha-community.org/gitweb/?p=contrib/global.git;a=summary)

Print page - Firefox, etc

Paul — 2012-05-22T15:49:56

Our cataloguers are having a local problem that I was unaware of. This is 
probably Koha bug 7199 which appears to be a tad inactive; I'd be happy to 
assist, but have no knowledge whatsoever of how browsers render 
CSS|templates for printing.

Trying to "print page" after a staff screen listing such as 
<http://koha-admin/cgi-bin/koha/catalogue/search.pl?q=lambert%2C+andrew> 
(the page itself is perfect) gives an oddball output with the "Results" and 
"Location" columns squeezed down to very narrow columns on the right hand 
side of the page. The "check box" column (normally very narrow) expands to 
well over 50% of page width.

This happens (for us at least) in Firefox (v. 12.0), Chrome (build 16.0), 
Safari (5.1) and MSIE (6.0 - we don't have anything more recent in our Win 
machine.)

A quick review of "equivalent" OPAC search pages (rather than staff-admin) 
shows no problems.

Koha 3.06.01.000, on Linux 2.6.38, Perl 5.010001, Apache 2.2.17, mysql Ver 
14.14 Distrib 5.1.54, for debian-linux-gnu

Thanks

Koha 3.8.1 released

Chris Cormack — 2012-05-21T21:32:25

The Koha release team is happy to announce the release of Koha 3.8.1

This is a stable release and contains bugfixes as well as updated translations.

You can download it at

http://download.koha-community.org/

Go forth, download, and enjoy :)


RELEASE NOTES FOR KOHA 3.8.1
21 May 2012
========================================================================

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.1 can be downloaded from:

    http://download.koha-community.org/koha-3.08.01.tar.gz

Installation instructions can be found:

   in the INSTALL files that come in the tarball

Koha 3.8.1 is a bugfix/maintenance release.

Highlights of 3.8.1
======================

7924criticalFix handling of command line arguments in koha-remove
7998critical3.8 UI cleanup, tweaks to new

Proposed QA Enhancements

Chris Nighswonger — 2012-05-21T17:38:58

I am making two proposals that will help "tighten" up our QA procedures a
bit in order to facilitate clarity and transparency in our patch
submission/acceptance workflow. Currently the workflow is described in the
wiki here:

http://wiki.koha-community.org/wiki/Bug-enhancement-patch_Workflow#Steps

1. I propose that we modify step 5 to read:

"The patch is checked and signed-off by the QA team member. Then the bug
status is set to Passed QA"

This will ensure that we have clarity that the patch was, indeed, touched
by a member of the QA team, as well as increasing the accuracy of QA stats
in git.

2. I propose that the RM be the QA of last resort. At present the stats
show that the RM is doing the majority of the QA'ing. "Last resort" is a
condition evoked by all members of the current QA team acknowledging that
no one among them has the time, etc. to do QA on a particular patch the RM
feels needs to be pushed OR by a bug remaining in the "Signed Off" status
beyond a fixed time period of four weeks. This mec

Koha Calendar

Elliott Davis — 2012-05-16T16:00:11

As I'm sure everybody running master has realized, bug 5549 introduced a new module Koha::Calendar.  After digging around in the module I realized that the table special_holidays had separate columns for year, month, and date.  I am wondering what the rationale is behind this decision.  If it was simply I preference I would like to propose that we move it to replace the 3 current columns with a timestamp so that the calendar can take advantage of setting open and closed hours and fining for hourly based items accordingly.


      Elliott Davis
      Library Systems Analyst
      Robert R. Muntz Library
[Description: Telephone]903.565.5542<tel:903.565.5542>
[Description: Envelope]tdavis-Zkq3jaIVT4KVc3sceRu5cw< at >public.gmane.org
[Description: Chrome]http://library.uttyler.edu<http://library.uttyler.edu/>

_______________________________________________
Koha-devel mailing list
Koha-devel-yy2XUMoudrGBeeJdjao7tfCrwMbev77B< at >public.gmane.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website :

sandbox system

Paul Poulain — 2012-05-16T12:27:36

Hello koha-devel,

I just pushed a few minuts ago the 1st version of the sandbox scripts
I've developped and that is available to facilitate testing of Koha patches.
You'll find everything, including some installation notes at
http://git.koha-community.org/gitweb/?p=contrib/global.git;a=summary
(git clone git://git.koha-community.org/contrib/global.git contrib, in
the sandbox directory)

PS: if you want to improve my scripts, you're welcomed !

Call for News for the May Newsletter

Daniel Grobani — 2012-05-15T19:26:52

Dear Koha Kommunitarians,

I'm harvesting news for the May newsletter. Please send me by the
25th anything you think your fellow community members might like to
know about.

"News" can be as short as a sentence or as long as a paper. I
especially encourage you to send me a line or two for the
gossip/society column about what you're currently working on. And if
you know of a go-live not announced on the list, please be sure to let
me know about it.

Thanks,
Daniel Grobani
_______________________________________________
Koha-devel mailing list
Koha-devel-yy2XUMoudrGBeeJdjao7tfCrwMbev77B< at >public.gmane.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Koha 3.8.1 entering string freeze

Chris Cormack — 2012-05-14T21:56:37

Hi All

As promised, the 3.8.x branch has entered string freeze in preparation
for the 3.8.1 release next week.

"So?" you ask, "What does this mean for me?"

Are you a developer? - If so just be aware I will only be pushing
patches that do not contain changes to any of the translatable strings
from now until the release.
Are you a translator? - Once the translation manager emails to say the
po files are updated, you are clear to translate your hearts out.
Are you a Koha user? - If you have the skills or know someone who
does, check out the 3.8.x and do some testing on it, that would be
awesome.
Are you a brewer? - I quite like a nice IPA

Chris
_______________________________________________
Koha-devel mailing list
Koha-devel-yy2XUMoudrGBeeJdjao7tfCrwMbev77B< at >public.gmane.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Localization of Perl strings in Koha

Julian Maurice — 2012-05-11T10:17:14

Hi,

a discussion has started in bug 8044 
(http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8044) about 
localization in Koha. But I want to include in this discussion the 
maximum number of people.

Summary of the discussion:
     I proposed a patch that uses Locale::Maketext.
     You can see an example of use in the 2nd patch attached to the bug, 
but here is a code sample:

       use Koha::I18N;
       use CGI;
       my $cgi = new CGI;
       my $lh = Koha::I18N->get_handle_from_context($cgi, 'intranet');
       $lh->maketext("A localized string with parameter: [_1]", 
$some_scalar);

     Then, Frédéric Démians suggested to use Locale::TextDomain instead 
of Locale::Maketext (some advantages are listed in bug comments)

     There is also a discussion about how we can handle templates 
translation with a translation framework like Locale::Maketext or 
Locale::TextDomain. This is not the topic of bug 8044, but a global 
discussion now is certainly better than choosing a direction now and 
t

jquery upgraded on master branch

Paul Poulain — 2012-05-11T09:11:52

Hello koha-devel,

I just pushed a patch to upgrade jquery to version 1.7.2 (from 1.3.2)

It has been tested, but some side effect are always possible. So if you
find strange javascript behaviour, go to bug 5184, or think of this
upgrade !

Multi-branch SCO [Was: Re: Branch Specific SystemPreferences]

Chris Nighswonger — 2012-05-10T19:43:14

Hi David,

On Thu, May 10, 2012 at 12:38 PM, David Schuster <dschust1-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

 I'm not sure what version you're using, but in the current master the
following sysprefs define the user for the SCO module:

AutoSelfCheckAllowed
AutoSelfCheckID
AutoSelfCheckPass

Unfortunately there is only room there for a single user tied to a single
branch. This results (for us at least) in all books checked out in the SCO
module appearing under the branch of the user listed in these sysprefs.

If there is workaround, I'd love to know it while we are in the process of
making the SCO module truly multi-branch.

Kind Regards,
Chris
_______________________________________________
Koha-devel mailing list
Koha-devel-yy2XUMoudrGBeeJdjao7tfCrwMbev77B< at >public.gmane.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Guided report in Koha 3.8.0

Partha Mukhopadhyay — 2012-05-10T14:15:25

_______________________________________________
Koha-devel mailing list
Koha-devel-yy2XUMoudrGBeeJdjao7tfCrwMbev77B< at >public.gmane.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

marc import/need help

Samuel Desseaux — 2012-05-10T08:43:27

Hello


I'm trying to convert data in marc format ( a big challenge because our  
old ILS doesn't respect unimarc): in marc edit, when i have this error 
"undefined error reported, error number -99" what does it means ?

I join to this mail an excel file of my data.

Best regards

samuel
_______________________________________________
Koha-devel mailing list
Koha-devel-yy2XUMoudrGBeeJdjao7tfCrwMbev77B< at >public.gmane.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

error while creating notices

Samuel desseaux — 2012-05-09T09:41:47

Hi,

Something strange: i creat my notice, my examplar and when i want to  
record, i've the following error


  Software error:

Can't call method "subfield" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 2919








So, i try to understand

*problem of encoding in the title tag ? Maybe but, just before, i've 
added a record without any problems and when i look parameters for 
encoding characters (mysql and apache), it's ok.

*problem of version ? I use debian package (as we are in a period of 
tests) and my version is 3.07



I join the logs of koha, if it can help

Best regards

samuel
[Wed Apr 04 12:10:43 2012] [error] [client 138.195.48.69] [Wed Apr  4 12:10:43 2012] Auth.pm: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha/lib/C4/Context.pm line 542.
[Wed Apr 04 12:10:43 2012] [error] [client 138.195.48.69] [Wed Apr  4 12:10:43 2012] Auth.pm: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr

Sharing news about KohaCon12

Paul Poulain — 2012-05-09T08:33:10

Hello koha-devel,

Just to share: 6 ppl of BibLibre comes at the KohaCon. We should arrive
on monday 4th and leave on tuesday, 12th.
We will stay at

KohaCon 2013 Wiki Reminder

BWS Johnson — 2012-05-08T17:32:29

Salvete!

    A while back, a mess of folks expressed interest over the listserv in bidding for KohaCon 2013. This is great. :) What is not great is that the folks that proclaimed their love of hosting over the listserv do not match with this wiki page:

http://wiki.koha-community.org/wiki/Kohacon2013

    So if you're earnest, please edit it, and soonish that way we can generate a proper ballot.

Cheers,
Brooke

_______________________________________________
Koha-devel mailing list
Koha-devel-yy2XUMoudrGBeeJdjao7tfCrwMbev77B< at >public.gmane.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Koha 3.6 string freeze

Jared Camins-Esakov — 2012-05-08T16:29:15

Greetings, international Koha community!

As you may know, I was elected as Release Maintainer for the 3.6.x branch
for the Koha 3.10 release cycle. Well, the time has come to do some
releasing! Over the weekend I cherry-picked all candidates for inclusion in
the 3.6.x into a new branch: 3.6.x-maint/testing. I encourage you to test
that branch out, and try to shake out any bugs that there may be. Tomorrow
I will be cherry-picking commits into the existing 3.6.x branch for the
Koha 3.6.5 release. With the exception of high priority patches, only those
commits that were incorporated into Master on or before April 12 will be
considered for inclusion. The 3.6.x branch will then enter string freeze on
May 10 at 16:00 UTC to give the translation teams time to work their magic.
Koha 3.6.5 will be released on May 24.

Regards,
Jared Camins-Esakov