Re: [Koha] New Koha packages published

[Chrispin Simasiku Sitali]

Hi Robin,

Thank you very much for this. It will make our Koha experience more
enjoyable. I really appreciate this.

Kind Regards


On 4 June 2013 06:31, Robin Sheat  wrote:

> Hi all.
>
> I've just published new versions of both the 3.10 and 3.12 packages.
> Normally I wouldn't bother announcing this, nor doing it out of cycle
> like this, however there are two reasons sysadmins managing systems
> using these should be aware:
>
>  1. the packages should now work on Debian Wheezy (7.0) that was
> released exactly a month ago, with no messing around. They also
> will work on Debian Squeeze (6.0) and Ubuntu LTS (12.04) as
> before.
>  2. as a result of changes that adding this support required, when
> you next update Koha from the packages, it won't happen as part
> of normal system updates. Instead you'll have to force the
> upgrade by doing 'apt-get dist-upgrade'. This is because there
> will be a new dependency installed.
>
> Thanks,
> --
> Robin Sheat
> Catalyst IT Ltd.
> ✆ +64 4 803 2204
> GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Charles Lwanga College of Education,
P. O. Box 660193,
Monze,
ZAMBIA.

Mobile: +26 0979 869471
SKYPE: Libsitali
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] koha- "make test fails" - help

[satish]

Hello,

I have installed koha 3.12 on Debian Squeeze ( idzebra has been
installed manually)

It is failed duing make test, but many previous mails in this forum suggested to
skip this step (ignoring make test report), and go head with make install.

currently, make install was successful and koha is working fine.

Does this create any problem in specific in near future? since we are
on production system,
is it safe for me to continue?

kindly provide your advice.

make test report log.
-
t/Labels.t(Wstat: 11 Tests: 1 Failed: 0)
  Non-zero wait status: 11
  Parse errors: Bad plan.  You planned 6 tests but ran 1.
Files=93, Tests=8217, 26 wallclock secs ( 1.00 usr  0.07 sys + 21.98
cusr  1.28 csys = 24.33 CPU)
Result: FAIL
Failed 1/93 test programs. 0/8217 subtests failed.
make: *** [test_dynamic] Error 255

thank you
Satish.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] New Koha packages published

[Robin Sheat]

Hi all. 

I've just published new versions of both the 3.10 and 3.12 packages.
Normally I wouldn't bother announcing this, nor doing it out of cycle
like this, however there are two reasons sysadmins managing systems
using these should be aware:

 1. the packages should now work on Debian Wheezy (7.0) that was
released exactly a month ago, with no messing around. They also
will work on Debian Squeeze (6.0) and Ubuntu LTS (12.04) as
before.
 2. as a result of changes that adding this support required, when
you next update Koha from the packages, it won't happen as part
of normal system updates. Instead you'll have to force the
upgrade by doing 'apt-get dist-upgrade'. This is because there
will be a new dependency installed.

Thanks,
-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] need manual confirmation

[Nicole Engard]

On Mon, Jun 3, 2013 at 7:55 PM, Robin Sheat  wrote:

> Nicole Engard schreef op ma 03-06-2013 om 13:03 [-0400]:
> > This is what Jared recommended I do:
> >
> http://git.koha-community.org/gitweb/?p=kohadocs.git;a=commitdiff;h=ceca7766b638435aeba4cd87a4349d1d10addfc7
>
> This may still end up with permission errors on a packaged system.
> Galen's comment about having rebuild_zebra.pl being able to do this is
> the best method. We could also add it to koha-rebuild-zebra to make it
> easy for the packages.
>
> As an aside, probably the best way to do this at the moment with the
> packages would be to use koha-shell to get an environment set up for the

particular Koha instance.
>

Okay, that was mostly jibberish to me :) How (specifically) should I update
the manual to make this clear? :)

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] need manual confirmation

[Robin Sheat]

Nicole Engard schreef op ma 03-06-2013 om 13:03 [-0400]:
> This is what Jared recommended I do:
> http://git.koha-community.org/gitweb/?p=kohadocs.git;a=commitdiff;h=ceca7766b638435aeba4cd87a4349d1d10addfc7

This may still end up with permission errors on a packaged system.
Galen's comment about having rebuild_zebra.pl being able to do this is
the best method. We could also add it to koha-rebuild-zebra to make it
easy for the packages.

As an aside, probably the best way to do this at the moment with the
packages would be to use koha-shell to get an environment set up for the
particular Koha instance.

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Zebra Indexing problem with upgrade

[Robin Sheat]

Paul Poulain schreef op vr 31-05-2013 om 13:56 [+0200]:
> Could you share the script you've made to check that ? We're also using
> nagios to monitor, and that would be useful.

Of course. They're pretty straight forward. You can find our nagios
stuff in the catalyst Koha git repo, in the 'nagios' branch. Or you can
browse them here:

http://git.catalyst.net.nz/gw?p=koha.git;a=tree;f=nagios;h=d69b65e3cb957f4efdef183d3865c3895a1f70dc;hb=refs/heads/nagios

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Need reports help

[Elaine Bradtke]

Thanks,
I was patching together two reports into one and missed that crucial bit!
Elaine

On Mon, Jun 3, 2013 at 7:02 PM, Bernardo Gonzalez Kriegel <
bgkrie...@gmail.com> wrote:

> Elaine,
> I have the following report:
>
>>
>>
>> SELECT  biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated
>> FROM items LEFT JOIN biblioitems on
>> (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
>> on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
>> items.homebranch='VWML' AND DATE_SUB(CURDATE(),INTERVAL 7 DAY) <=
>> biblio.datecreated
>>   ORDER BY biblio.title ASC
>>
>>
>> But it only returns information if there are item records attached,  what
>> I
>> really want is a list of everything catalogued.
>>
>
> It does that because you begin you query with items table.
> Perhaps this modified query could help you, but without homebranch
> information
>
> SELECT
>   biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated
> FROM
>   biblioitems
>   LEFT JOIN
>   biblio on (biblioitems.biblionumber=biblio.biblionumber)
> WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= biblio.datecreated
> ORDER BY biblio.title ASC;
>
> Regards,
> Bernardo
>



-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Need reports help

[Bernardo Gonzalez Kriegel]

Elaine,
I have the following report:

>
>
> SELECT  biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated
> FROM items LEFT JOIN biblioitems on
> (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
> on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
> items.homebranch='VWML' AND DATE_SUB(CURDATE(),INTERVAL 7 DAY) <=
> biblio.datecreated
>   ORDER BY biblio.title ASC
>
>
> But it only returns information if there are item records attached,  what I
> really want is a list of everything catalogued.
>

It does that because you begin you query with items table.
Perhaps this modified query could help you, but without homebranch
information

SELECT
  biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated
FROM
  biblioitems
  LEFT JOIN
  biblio on (biblioitems.biblionumber=biblio.biblionumber)
WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= biblio.datecreated
ORDER BY biblio.title ASC;

Regards,
Bernardo
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Need reports help

[Elaine Bradtke]

I have the following report:


SELECT  biblio.biblionumber,biblio.author,biblio.title,biblio.datecreated
FROM items LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
items.homebranch='VWML' AND DATE_SUB(CURDATE(),INTERVAL 7 DAY) <=
biblio.datecreated
  ORDER BY biblio.title ASC



But it only returns information if there are item records attached,  what I
really want is a list of everything catalogued.  A lot of our biblios don't
have items attached.
What's the best way to do this?

-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] new fiscal year

[Jared Camins-Esakov]

Karen and Nicole,

Well Karen - I felt I should reply :) but it's not good news.  There is no
> way to roll over orders or budgets at this time.  The only thing I can
> think to do is edit each order line and choose a new budget before
> receiving.  That means reopening each basket to modify each line.  I do
> hope that someone else has a less time consuming solution.
>

I do not have a solution for right this moment, but I am pleased to report
that C & P will be developing the ability to modify the budget at receipt
time, which will make this process a whole lot less painful. I will be
reporting a bug soon, and then you'll be able to follow along on the
development process there.

Regards,
Jared

-- 
Jared Camins-Esakov
Bibliographer, C & P Bibliography Services, LLC
(phone) +1 (917) 727-3445
(e-mail) jcam...@cpbibliography.com
(web) http://www.cpbibliography.com/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] new fiscal year

[Nicole Engard]

Well Karen - I felt I should reply :) but it's not good news.  There is no
way to roll over orders or budgets at this time.  The only thing I can
think to do is edit each order line and choose a new budget before
receiving.  That means reopening each basket to modify each line.  I do
hope that someone else has a less time consuming solution.

Nicole


On Mon, Jun 3, 2013 at 11:34 AM, Kohn, Karen  wrote:

> Hello,
> I'm having trouble remembering how to create a new fiscal year and copy our
> open orders from the old year into the new one.  We do get support from
> ByWater, so I'm sure Nicole will respond quickly, but I figured I'd hit
> more people by posting it to the list.  I duplicated one budget to create a
> new one but don't see how to copy the orders.
> Thanks in advance.
>
> --
> *Karen Kohn*
> Collection Development Manager
> Education and Sociology Librarian
> Landman Library
> Arcadia University
> 450 S. Easton Road
> Glenside, PA  19038
> ph: 215-572-8528
> fax: 215-572-0240
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] need manual confirmation

[Nicole Engard]

This is what Jared recommended I do:
http://git.koha-community.org/gitweb/?p=kohadocs.git;a=commitdiff;h=ceca7766b638435aeba4cd87a4349d1d10addfc7

Nicole

On Mon, Jun 3, 2013 at 12:05 PM, Galen Charlton  wrote:

> Hi,
>
> On Mon, Jun 3, 2013 at 4:46 AM, Nicole Engard  wrote:
> > Can I get some confirmation that this is how it is for everyone and not
> > just a local setup thing?
>
> It's ultimately a local setup thing.  The directories in the new
> version you were given conform to how the Debian packages lay things
> out, so it's a *common* local setup nowadays.  However, the new
> version still isn't quite right for Debian packages, as the reset
> shouldn't be run as root but as the user that owns the Koha instance's
> files.
>
> I think the simplest thing to do would be teaching rebuld_zebra.pl how
> to reset the indexes, which in turn means that the documentation
> wouldn't have to cite the specific path to zebra-biblios.cfg and
> zebra-authorities.cfg.
>
> Regards,
>
> Galen
> --
> Galen Charlton
> Manager of Implementation
> Equinox Software, Inc. / The Open Source Experts
> email:  g...@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
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] need manual confirmation

[Galen Charlton]

Hi,

On Mon, Jun 3, 2013 at 4:46 AM, Nicole Engard  wrote:
> Can I get some confirmation that this is how it is for everyone and not
> just a local setup thing?

It's ultimately a local setup thing.  The directories in the new
version you were given conform to how the Debian packages lay things
out, so it's a *common* local setup nowadays.  However, the new
version still isn't quite right for Debian packages, as the reset
shouldn't be run as root but as the user that owns the Koha instance's
files.

I think the simplest thing to do would be teaching rebuld_zebra.pl how
to reset the indexes, which in turn means that the documentation
wouldn't have to cite the specific path to zebra-biblios.cfg and
zebra-authorities.cfg.

Regards,

Galen
--
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email:  g...@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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] new fiscal year

[Kohn, Karen]

Hello,
I'm having trouble remembering how to create a new fiscal year and copy our
open orders from the old year into the new one.  We do get support from
ByWater, so I'm sure Nicole will respond quickly, but I figured I'd hit
more people by posting it to the list.  I duplicated one budget to create a
new one but don't see how to copy the orders.
Thanks in advance.

-- 
*Karen Kohn*
Collection Development Manager
Education and Sociology Librarian
Landman Library
Arcadia University
450 S. Easton Road
Glenside, PA  19038
ph: 215-572-8528
fax: 215-572-0240
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] URL link checker

[Nicole Engard]

Koha has a broken link checker cron job that can be run on a schedule to
check links for you.

More here:
http://manual.koha-community.org/3.10/en/cronjobsch.html#checkurlcron

Nicole


On Mon, Jun 3, 2013 at 8:47 AM, Tomas Cohen Arazi wrote:

> On Mon, Jun 3, 2013 at 8:53 AM, Maria Okonska  >wrote:
>
> > Hi there,
> > We would like to install a URL link checker in our OPAC. Could anyone
> > recommend us one that works well.
> >
>
> Can u elaborate on what you want to do? What type of integration?
>
> Regards
> To+
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] URL link checker

[Tomas Cohen Arazi]

On Mon, Jun 3, 2013 at 8:53 AM, Maria Okonska wrote:

> Hi there,
> We would like to install a URL link checker in our OPAC. Could anyone
> recommend us one that works well.
>

Can u elaborate on what you want to do? What type of integration?

Regards
To+
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] URL link checker

[Maria Okonska]

Hi there,
We would like to install a URL link checker in our OPAC. Could anyone recommend 
us one that works well.
Thanks,

Maria


Maria Okonska
Manager of Bibliographic Operations
Brooklyn Law School Library
250 Joralemon Street
Brooklyn, NY 11201
tel.: 718-780-7977
fax.: 718-780-0369
e-mail: maria.okon...@brooklaw.edu

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] need manual confirmation

[Nicole Engard]

Hello all,

I have never done this before, but I got an email telling me to update this:

$ zebraidx -c /etc/koha/zebradb/zebra-authorities-dom.cfg -g iso2709
-d authorities init
$ zebraidx -c /etc/koha/zebradb/zebra-biblios.cfg -g iso2709 -d biblios init


on this page: http://manual.koha-community.org/3.12/en/resetzebra.html

to this:

$ sudo zebraidx -c /etc/koha/sites/*library*/zebra-authorities-dom.cfg  -g
iso2709 -d authorities init
$  sudo zebraidx -c /etc/koha/sites/*library*/zebra-biblios.cfg  -g iso2709
-d biblios init

where *library* was the koha site (installation) name.


Can I get some confirmation that this is how it is for everyone and not
just a local setup thing?

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Zebra Indexing problem with upgrade

[Martin Renvoize]

We'de also be interesting in that zebra monitoring script...

I imagine many of the community are using Nagios for monitoring and this
isn't something I'de got round to implementing myself (and sharing) yet
either.

Cheers


On 31 May 2013 12:56, Paul Poulain  wrote:

> Le 31/05/2013 00:51, Robin Sheat a écrit :
> > Elaine Bradtke schreef op do 30-05-2013 om 16:59 [+0100]:
> >> The indexing process seems to be a weak spot in Koha.
> >
> > When we set up nagios monitoring for Koha instances, one of the things
> > we include is checking that there is nothing in the zebra queue more
> > than about an hour old. This ensures that the zebra reindexing is
> > happening.
> Could you share the script you've made to check that ? We're also using
> nagios to monitor, and that would be useful.
>
> thx
>
>
> --
> Paul POULAIN - Associé-gérant
> Tel : (33) 4 91 81 35 08
> http://www.biblibre.com
> Logiciels Libres pour les bibliothèques et les centres de documentation
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Martin Renvoize
Software Engineer, PTFS Europe Ltd
Content Management and Library Solutions
Skype:
Landline: 0203 286 8685
Mobile: 07725985636

http://www.ptfs-europe.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha