[Koha] Wrong/Truncate Calculation in Acquisition

2017-09-15 Thread vinod mishra
Dear All,

Probably i am facing problem related to bug
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18471 in Koha
16.11.07 but even after upgrading to on my test machine to 16.11.11 and
restored the database, previous calculation does not get corrected and
still showing the same first 1/2 digit of entire numerical value if more
than 1000.

Please suggest.

With Regards,

Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela,
Sundergadh-769008,
Odisha,
India.
Mob:91+9439420860
Website: http://mishravk.com/
ORCID ID: http://orcid.org/-0003-4666-7874

*"Spiritual relationship is far more precious than physical. Physical
relationship divorced from spiritual is body without soul" -- Mahatma
Gandhi*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Internal server error when trying to open Budget or Funds

2017-09-15 Thread Michael Kuhn

Am 15.09.2017 um 22:34 schrieb Jonathan Druart:

So yes, it's a bug, please open a bug report :)


OK, I have added Bug 19328 - Internal server error because of missing 
currency

* https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19328

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Internal server error when trying to open Budget or Funds

2017-09-15 Thread Jonathan Druart
So yes, it's a bug, please open a bug report :)

On Fri, 15 Sep 2017 at 16:47 Michael Kuhn  wrote:

> Hi Jonathan
>
> > But now I also found an error message in
> > "plack-error.log".
> >
> > When clicking "Budgets" it says:
> >
> > Can't call method "symbol" on an undefined value at
> > /usr/share/koha/intranet/cgi-bin/admin/aqbudgetperiods.pl line 94.
> >
> > When clicking "Funds" it says:
> >
> > Can't call method "symbol" on an undefined value at
> > /usr/share/koha/intranet/cgi-bin/admin/aqbudgets.pl line 53.
> >
> > It's the same in both my installations with Koha 17.05.1 (
> > http://koha.adminkuhn.ch:8080/?userid=demo=demo ) and also on
> > another installation with Koha 16.11.1.
>
>
> Well, I found the problem... line 94 says:
>
> $template->param( symbol => $active_currency->symbol,
>currency => $active_currency->currency
>
> I then checked if there was a currency defined and and activated - there
> wasn't. This is probably because I didn't load any example values (?).
>
> However, I then entered a new currency and activated it - now it works
> as expected.
>
> Many thanks & have a good weekend! Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 <+41%2061%20261%2055%2061> · E m...@adminkuhn.ch ·
> W www.adminkuhn.ch
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Changing user password

2017-09-15 Thread Michael Kuhn

Hi Luis


We are creating user with generic password,
Does koha can allow user to change, inmediataly the user log in, to change
the password?



If you set "OpacPasswordChange" to "Allow" users will be allowed to 
change their password after logging on into the OPAC.


Hope this helps.

Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Changing user password

2017-09-15 Thread Luis Moises Rojas
Hello everybody,

We are creating user with generic password,
Does koha can allow user to change, inmediataly the user log in, to change
the password?

Thanks

-- 
*Luis Moisés Rojas P.*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Internal server error when trying to open Budget or Funds

2017-09-15 Thread Michael Kuhn

Hi Jonathan

But now I also found an error message in 
"plack-error.log".


When clicking "Budgets" it says:

Can't call method "symbol" on an undefined value at 
/usr/share/koha/intranet/cgi-bin/admin/aqbudgetperiods.pl line 94.


When clicking "Funds" it says:

Can't call method "symbol" on an undefined value at 
/usr/share/koha/intranet/cgi-bin/admin/aqbudgets.pl line 53.


It's the same in both my installations with Koha 17.05.1 ( 
http://koha.adminkuhn.ch:8080/?userid=demo=demo ) and also on 
another installation with Koha 16.11.1.



Well, I found the problem... line 94 says:

$template->param( symbol => $active_currency->symbol,
  currency => $active_currency->currency

I then checked if there was a currency defined and and activated - there 
wasn't. This is probably because I didn't load any example values (?).


However, I then entered a new currency and activated it - now it works 
as expected.


Many thanks & have a good weekend! Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Internal server error when trying to open Budget or Funds

2017-09-15 Thread Michael Kuhn

Hi Jonathan


It works for me on 17.05.01.

Check the logs, if you see something like:
Template process failed: undef error - round() overflow. Try smaller 
precision or use Math::BigFloat at /home/koha/src/Koha/Number/Price.pm 
line 44


It's a known bug: Bug 15770 - Number::Format issues with large numbers


I can reproduce the error as described in Bug 15770 (Koha menu 
"Administratuion > Patron categories > New category") - including the 
given error message.

* https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15770

But I don't see no connection with clicking "Budget" resp. "Funds" 
because they won't even OPEN, instead the browser says "Internal Server 
Error". Since it's not possible to open these menus I can of course not 
enter a high number there... But now I also found an error message in 
"plack-error.log".


When clicking "Budgets" it says:

Can't call method "symbol" on an undefined value at 
/usr/share/koha/intranet/cgi-bin/admin/aqbudgetperiods.pl line 94.


When clicking "Funds" it says:

Can't call method "symbol" on an undefined value at 
/usr/share/koha/intranet/cgi-bin/admin/aqbudgets.pl line 53.


It's the same in both my installations with Koha 17.05.1 ( 
http://koha.adminkuhn.ch:8080/?userid=demo=demo ) and also on 
another installation with Koha 16.11.1.


Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Data not found

2017-09-15 Thread Mark Alexander
Excerpts from Luis Moises Rojas's message of 2017-09-15 09:23:17 -0400:
> Everyday in the morning, i have to run this script:
> Koha-rebuild-zebra -f -v -b -r {Koha instance}
> 
> if i do not do this: we can not see any data, not search is found, etc.
> Why?

It could be that the zebra server is not running.  Try this:

https://wiki.koha-community.org/wiki/Koha_on_Debian#Anacron
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Internal server error when trying to open Budget or Funds

2017-09-15 Thread Jonathan Druart
Hello Michael,

It works for me on 17.05.01.

Check the logs, if you see something like:
Template process failed: undef error - round() overflow. Try smaller
precision or use Math::BigFloat at /home/koha/src/Koha/Number/Price.pm line
44

It's a known bug: Bug 15770 - Number::Format issues with large numbers

Regards,
Jonathan

On Fri, 15 Sep 2017 at 15:28 Michael Kuhn  wrote:

> Hi
>
> When trying to click "Budgets" or "Funds" in Koha menu "Administration >
> Acquisition parameters" just a blank page appears, saying "Internal
> server error". Like this, of course, no new budget or fund can be added.
>
> I am experiencing this on Koha 16.11.1 as well as on Koha 17.05.1 (but
> not on Koha 16.11.4). I tried this as a user with the rights of a
> "superlibrarian" as well as with a user with fewer permissions.
>
> Has anyone experienced the same and can help, or should I maybe open a
> bug case?
>
> Best wishes: Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 <+41%2061%20261%2055%2061> · E m...@adminkuhn.ch ·
> W www.adminkuhn.ch
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Internal server error when trying to open Budget or Funds

2017-09-15 Thread Michael Kuhn

Hi

When trying to click "Budgets" or "Funds" in Koha menu "Administration > 
Acquisition parameters" just a blank page appears, saying "Internal 
server error". Like this, of course, no new budget or fund can be added.


I am experiencing this on Koha 16.11.1 as well as on Koha 17.05.1 (but 
not on Koha 16.11.4). I tried this as a user with the rights of a 
"superlibrarian" as well as with a user with fewer permissions.


Has anyone experienced the same and can help, or should I maybe open a 
bug case?


Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem with migration from KOHA 3.20 to 16.11.11

2017-09-15 Thread Jonathan Druart
Paul,

I am sure you understood what I meant: the Koha debian packages are based
on Jessie (and so Ubuntu 16.04).
We had problems with Apache versions (2.4) and other Perl libs that were
not packaged/packagable easily for Wheezy.
Debian packages are generated by only 1 guy (Mirko) and developers are
(almost) all working on the same system. Same for the CI, we only run tests
on Ubuntu 16.04 and Jessie. If someone need Wheezy support (or any other
linux distro support), they can contact us and propose their help.

From the wiki page:
"""
As of November 2016, the Debian packages for Koha are based on Jessie
(Debian 8). Xenial (Ubuntu 16.04 LTS) is based on Jessie.
That means Ubuntu 14.04 LTS is no longer supported.
"""
+ http://lists.koha-community.org/pipermail/koha-devel/2016-July/042874.html

Regards,
Jonathan

On Thu, 14 Sep 2017 at 20:38 Paul A  wrote:

> On 2017-09-14 09:51 AM, someone wrote:
>
> > Note that Ubuntu 14.04 is not longer supported.
>
> Please note that Ubuntu 14.04 LTS is supported until April 2019 --
> . Koha tends to be very
> pro-active with enhancements (a potentially marvelous thing) but
> possibly might leave stable operating systems in the dust.
> --
> Paul
> Tired old sys-admin
> [just celebrated 78 years of life, 62 years of FORTRAN, and 58 years of
> COBOL]
> [now ducking the inevitable flames]
> [ ;=} ]
> [still running Koha 3.8.24 on 14.04LTS as a reference, non-lending,
> library at very respectable speeds on copper wire]
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Data not found

2017-09-15 Thread Luis Moises Rojas
Hello everybody,

Everyday in the morning, i have to run this script:
Koha-rebuild-zebra -f -v -b -r {Koha instance}

if i do not do this: we can not see any data, not search is found, etc.
Why?


-- 
*Luis Moisés Rojas P.*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha Data Migration and cover Image

2017-09-15 Thread Indranil Das Gupta
Hi,

Right now I'm not able to find out the document where I read about the
tentative date of Q1 2018. It came up during one of the post on the
PCC. activities.

What I can share right now is -
http://alcts.ala.org/ccdablog/wp-content/uploads/2017/06/PCC-2017-06.pdf

See the section "The PCC is moving forward to implement the
recommendations of the PCC ISBD and MARC Task Group, which call for
eliminating ISBD punctuation that coincides with MARC coding. As a
first step, OCLC and LC are creating test sets of records and a small
group is being formed to track the testing and analyze results."

The details of what punctuation to remove / replace is available here
- http://www.loc.gov/aba/pcc/documents/isbdmarc2016.pdf

cheers
idg
--
Indranil Das Gupta
L2C2 Technologies

Phone : +91-98300-20971
WWW  : http://www.l2c2.co.in
Blog: http://blog.l2c2.co.in
IRC : indradg on irc://irc.freenode.net
Twitter : indradg


On Fri, Sep 15, 2017 at 4:40 AM, Paul A  wrote:
> On 2017-09-14 04:09 AM, Indranil Das Gupta wrote:
> /snip/
>>
>> Come Q1 2018 there is expected to start a pilot program to remove
>> punctuation from MARC records
>
>
> Could you please give some references to this? I'll be happy to believe that
> it's a "good thing", but it sounds more like a catastrophe and/or an IT
> nightmare. Remove punctuation from records, add them back in templates or
> whatever to make them human readable; retrain all cataloguers; demolish tens
> of millions LoC, BL, NLF, LAC records?
>
> I'd like to read more...
>
> Best -- P.
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha Data Migration and cover Image

2017-09-15 Thread Indranil Das Gupta
Chinmoy:

If you want a feature to come in into Koha the first step is to file a
bug report in the Koha bugzilla -
https://bugs.koha-community.org/bugzilla3/

Most features make it into Koha because some user institution
somewhere is funding the development of the feature. Development does
not happen out of thin air by developers who live and survive only on
adulation and the glory of writing Free Software. ;-)

Your requirement for punctuation and handling repeated fields are
already served by user specific XSLT mods supported by Koha since many
versions. See https://wiki.koha-community.org/wiki/XSLT_Library

cheers
-idg

--
Indranil Das Gupta
L2C2 Technologies

Phone : +91-98300-20971
WWW  : http://www.l2c2.co.in
Blog: http://blog.l2c2.co.in
IRC : indradg on irc://irc.freenode.net
Twitter : indradg


On Thu, Sep 14, 2017 at 9:18 PM, Chinmoy Ghosh
 wrote:
> Thanks a lot. "Betterment" word which I use to say my suggestions may be
> included in next version. Koha developers from various countries all over
> the world always do the job sincerely thats why we get 17.05 version from
> 1.00 version. But at the time of beginning of koha all the features of
> 17.05 version definitely was not present in the first version. Requirements
> from various users and ideas from developers achieve in latest koha version.
> Developers give their valuable time as well as their knowledge for library
> users thats why we get FOSS koha . I think anyone can suggest anything for
> improvement but that suggestions may or may not be approved. I use this word
> "Betterment" not to hurt anybody.
>
> On Sep 14, 2017 1:39 PM, "Indranil Das Gupta"  wrote:
>>
>> Hi Chinmoy,
>>
>> On Thu, Sep 14, 2017 at 11:41 AM, Chinmoy 
>> wrote:
>> > 1. How to migrate data from koha to excel format marc tagwise like 020a,
>> > 020c, 041a, 082a,082b, 100, 245a, 245b, 245c, 250, 260a,260b, 260c,
>> > 300a,440a, 500a, 650a, 700a,700b,700c,700d,700-4,942c etc.
>>
>> Koha -> Export to marc -> MarcEdit -> Export to delimited text ->
>> Import to excel.
>>
>> However, you will need to additionally handle the repeated fields once
>> the data is in Excel. Otherwise when you export back, you might end up
>> with garbled, invalid MARC data
>>
>> > 2. If a book not available in www.amazon.com but available in Amazon
>> > India(www.amazon.in) then how can I get cover image of that book. In
>> > koha
>> > there is no option to select Amazon India services from Amazon Locale
>> > because here only American, British, Japanese, French, German and
>> > Canadian
>> > are available. In India various languages are there so various language
>> > books are available in www.amazon.in site but we cannot obtain the book
>> > cover in koha for local language books.
>>
>> This is an enhancement which currently does not exist in Koha. IMHO
>> Its a fairly simple enhancement. But someone has to write it. Which
>> means either (a) you write it yourself (b) you find a volunteer to
>> write it for you or (c) you sponsor a Koha developer to write it for
>> you.
>>
>> > 3. Another point is when we search a book in catalogue first shows the
>> > normal view and in normal view sequence is Title(245a), Subtitle(245b),
>> > Statement of Responsibility (245c) then By: Main Entry Personal
>> > name(100a),
>> > Contributor(s): (700a), (700b), (700c), Relator code(700-4). In normal
>> > view
>> > mode there is no punctuation mark i.e (: colon) between Title (245a) and
>> > Subtitle (245b). Also Statement of Responsibility (245c) and By: Main
>> > Entry
>> > Personal name(100), Contributor(s): (700a), (700b), (700c), Relator
>> > code(700-4) both i.e 245c and 700abc are meaningless because same thing
>> > appears two times. I think (245c) is not required to display in Normal
>> > view.
>> > When we setup ISBD Template we put there punctuation mark and at the
>> > time of
>> > data entry we do not add punctuation mark as a result in Normal view
>> > mode
>> > Title , Subtitle, SOR are coming without punctuation mark and it is very
>> > confusing to a new user. Maximum Library authority do the data entry job
>> > by
>> > non Librarian worker and they do not know the punctuation mark so it is
>> > better to setup with punctuation mark at the time of display page
>> > designing.
>> > Also after (260a) :colon; (260b) ,comma ; (260c).dot and after
>> > pagination
>> > (300a) p. may be inserted.  It is my earnest request to the concern
>> > persons
>> > to look into the matter for betterment of koha services.
>>
>> Yes, the Koha community looks forward to suggestions for improvement,
>> but please try to learn how Koha works and why it does what it does
>> before asking for "betterment".
>>
>> You already have the option to change your display to use the ISBD tab
>> as the default display, so that your users will see the data with the
>> punctuation you desire. The other option is that you modify the
>> necessary XSLT