date:20180319


Hi,

at the moment authorised value categories cannot be deleted from the GUI:

*Bug 17355* 
 - 
Authorised value categories cannot be deleted


If you really want to remove it, you can do so with SQL. They are stored in
authorised_value_categories 
.


Hope this helps,

Katrin


On 19.03.2018 21:41, Narcis Garcia wrote:

(Koha 17.11)

In Administration -> Authorized values I've created a category with a
wrong name.
How can I remove it?

Thanks.
___
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] Customized MARC21 framework

Koha stores the MARC record as XML. Only the fields and subfields that 
are set in the record and additionally limited to the fields and 
subfields defined in the framework it belongs to.


On 19.03.2018 11:58, Narcis Garcia wrote:

Including whole MARC21 specification (hidden or not), does Koha write
the 4000 subtags for each item record in database?!


El 19/03/18 a les 07:46, Katrin Fischer ha escrit:

Hi Narcis,

better to hide the fields using the hidden values documented on the wiki
(https://wiki.koha-community.org/wiki/Hidden_values) than to delete the
fields and subfields you don't need. Deleting some of the fields like
000 and 999 can lead to errors. Also when you import data and the
records contain deleted fields, the information in them will be lost on
saving the item.

Hope this helps,

Katrin


On 14.03.2018 17:41, Narcis Garcia wrote:

As I understand, a valid way to have a customized framework (as most
compatible as possible) is:

1. Go to MARC frameworks

2. Esport "BASE" (default) framework to CSV format

3. Edit file with a text editor and remove all lines except:
- Headings
- Mask lines ("#-#")
- Desired subtags to be used finally
- The tags that have selected subtags

4. Create +New framework

5. Import edited file to new created framework.


Am I right to patrons use it for cataloguing?

Thanks.
___
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 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] Delete Authorized values category

2018-03-19 Thread Irma Birchall

Hi Narcis,

At the moment there is no possibility to delete a category from the staff
interface GUI.
Only from the command line.
Just leave / ignore the one with the wrong name and create a new category
with the correct name.

Hope this helps.
Irma
CALYX

On 20 March 2018 at 07:41, Narcis Garcia  wrote:

> (Koha 17.11)
>
> In Administration -> Authorized values I've created a category with a
> wrong name.
> How can I remove it?
>
> Thanks.
> ___
> 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] cataloguing in koha according to RDA

2018-03-19 Thread Hernandez, Heather

Coolness, Barton!  It's very gratifying when the data gets searched &
retrieved!

Cheerio,
h2
~~
Heather Hernandez
Technical Services Librarian
San Francisco Maritime National Historical Park Research Center
2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
415-561-7032, heather_hernan...@nps.gov
Library catalog: http://keys.bywatersolutions.com/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Delete Authorized values category

2018-03-19 Thread Narcis Garcia

(Koha 17.11)

In Administration -> Authorized values I've created a category with a
wrong name.
How can I remove it?

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

[Koha] Upgrading from Ubuntu 14.04 to 16.04

2018-03-19 Thread Tim Auld

Hi Everyone,
I am running Koha 16.05 on Ubuntu 14.04.  I'm planning on upgrading the OS
to Ubuntu 16.04.  Can anyone who has done this please share your
experiences with me?  Will I need to upgrade Koha at the same time for
everything to work?

Regards,

Tim Auld
Northern Philatelic Library.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] cataloguing in koha according to RDA

Ok, that's so awesome that I had to put it on the SQL Reports Library wiki
page:

https://wiki.koha-community.org/wiki/SQL_Reports_Library#Bibs_marked_as_RDA

Thanks Heather!

On Mon, Mar 19, 2018 at 12:38 PM, Hernandez, Heather <
heather_hernan...@nps.gov> wrote:

> Hi!
>
> Yes--you can use any cataloging rules that you like.
>
> If you are then using MARC21, RDA is most commonly indicated with "i" in
> the 000/Leader/position 18 ("Descriptive Cataloging Form" in Koha) and 040
> subfield e value of "rda," e.g.:
>
> 040 _ _ $e rda
>
> Cheerio,
> h2
> ~~
> Heather Hernandez
> Technical Services Librarian
> San Francisco Maritime National Historical Park Research Center
> 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
> 415-561-7032, heather_hernan...@nps.gov
> Library catalog: http://keys.bywatersolutions.com/
> ___
> 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] Title search caching oddity

I've been working with one of our partner libraries trying to explain the
difference between title search by phrase and title keyword search the
example that he gave me was

ti,phr: Little Women

This returned 39 results. Running the same search without using 'phr'

ti: Little Women

yielded the same 39 results.

After poking around at all of the possible marc fields indexed as title, I
determined that there were indeed exactly 39 records containing the exact
string "Little Women" -- it struck me as odd that there would not be more
results in the keyword search... so I reversed the search terms:

ti: Women Little returned 110 results

and

   ti,phr: Women LIttle

returned none. This is more like what I expected.

I went to file this as a bug, and on my next pass through, the keyword
search for 'LIttle Women' (in the original order) returned 110 results.

It's obvious that there's some sort of caching going on, but I have no idea
where.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report help

2018-03-19 Thread Eric Phetteplace

Hi Mutasem,

Can you clarify what you mean by "number of search book in koha"? I can
think of a few different interpretations, including:

1) number of times someone searched the OPAC for a book
2) number of books that be retrieved by a search

#1 cannot be answered with a report, as far as I know, but would instead
require web analytics that track how often a search URL is visited. If you
have Google Analytics set up for your catalog, you can see how often URLs
like "cgi-bin/koha/opac-search.pl?q=" were accessed.

2) can be very simply or rather lengthy depending on what you want to
include. At its simplest, you can just count the number of bibliographic
records in your Koha database:

SELECT COUNT(*)
FROM biblio

If you want something a bit more refined, for instance only biblios that
have attached items or perhaps the number items with a "BOOK" type, then
that has to be modified but it's hard to know what you want based on your
original message.

Best,

ERIC PHETTEPLACE

Systems Librarian


libraries.cca.edu | vault.cca.edu | 510.594.3660

5212 Broadway, Oakland, CA 94618

 8th St., San Francisco, CA 94107

Preferred Pronoun(s): he/him

:(){ :|: & };:

2018-03-19 0:04 GMT-07:00 Mutasem Al Shami :

> Hi,
>
> any one can help me, i need report to count number of search book in koha.
>
> thank,
> Mutasem
>
> --
>
>
> --
>
> Disclaimer: This message and its attachment, if any, are confidential and
> may contain legally privileged information. If you are not the intended
> recipient, please contact the sender immediately and delete this message
> and its attachment, if any, from your system. You should not copy this
> message or disclose its contents to any other person or use it for any
> purpose. Statements and opinions expressed in this e-mail are those of the
> sender, and do not necessarily reflect those of Al Maarefa College (MCST).
> All opinions and/or views expressed in this email are solely those of the
> author and do not necessarily represent those of MCST, MCSTaccepts no
> liability for damage caused by any virus transmitted by this email.
>
>   تنويه: هذه الرسالة ومرفقاتها (إن وجدت) تمثل وثيقة سرية قد تحتوي على
> معلومات تتمتع بحماية وحصانة قانونية. إذا لم تكن الشخص المعني بهذه الرسالة
> يجب عليك تنبيه المُرسل بخطأ وصولها إليك، وحذف الرسالة ومرفقاتها. ولا يجوز
> لك نسخ هذه الرسالة أو مرفقاتها أو أي جزء منها، أو البوح بمحتوياتها لأي شخص
> أو استعمالها لأي غرض. علماً بأن الآراء والإفادات التي تحويها هذه الرسالة
> تعبر فقط عن رأي المُرسل وليس بالضرورة رأي كلية المعرفة، ولا تتحمل كلية
> المعرفة أي مسئولية عن الأضرار الناتجة عن أي فيروسات قد يحملها هذا البريد.
>
>
> ___
> 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] koha-sitemap

2018-03-19 Thread Rubeno Fernández

Hello all,

I'm trying to have crawl bots keep off my catalogue. Has anybody ever used the 
command koha-sitemap? On Koha 17.11 for Debian it seems to be broken:

root@biblioteko:~# koha-sitemap --generate biblioteko
Sitemap directory for biblioteko doesn't exist. Creating.
Can't locate Koha/Exceptions/Exception.pm:   ./Koha/Exceptions/Exception.pm: 
Permission denied at /usr/share/perl/5.22/base.pm line 97.
...propagated at /usr/share/perl/5.22/base.pm line 106.
BEGIN failed--compilation aborted at (eval 16) line 3.
BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Exceptions.pm 
line 69.
Compilation failed in require at /usr/share/koha/lib/Koha/DateUtils.pm line 
22.
BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/DateUtils.pm 
line 22.
Compilation failed in require at /usr/share/koha/lib/C4/Log.pm line 30.
BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Log.pm line 30.
Compilation failed in require at /usr/share/koha/lib/Koha/Config/SysPref.pm 
line 26.
BEGIN failed--compilation aborted at /usr/share/koha/lib/Koha/Config/
SysPref.pm line 26.
Compilation failed in require at /usr/share/koha/lib/C4/Context.pm line 105.
BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Context.pm line 
105.
Compilation failed in require at /usr/share/koha/lib/C4/Koha.pm line 26.
BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Koha.pm line 26.
Compilation failed in require at /usr/share/koha/lib/C4/Biblio.pm line 32.
BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Biblio.pm line 32.
Compilation failed in require at /usr/share/koha/bin/cronjobs/sitemap.pl line 
26.
BEGIN failed--compilation aborted at /usr/share/koha/bin/cronjobs/sitemap.pl 
line 26.

I tried to run the script sitemap.pl by hand, without success:

perl -I /usr/share/koha/lib /usr/share/koha/bin/cronjobs/sitemap.pl --url 
biblioteko.esperanto.cat
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
Use of uninitialized value in concatenation (.) or string at /usr/share/koha/
lib/C4/Templates.pm line 154.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
Use of uninitialized value in concatenation (.) or string at /usr/share/koha/
lib/C4/Auth_with_cas.pm line 42.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/
C4/Context.pm line 243.
Can't call method "config" on unblessed reference at /usr/share/koha/lib/Koha/
Database.pm line 56.

The config file it doesn't find may be the one located at /etc/koha/sites/
biblioteko/koha-conf.xml.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Anyone using OCLC Connexion?

2018-03-19 Thread Hernandez, Heather

Hi, Agnes--

We're using OCLC Connexion Client (and very occasionally the Connexion web
interface), but I've never used OCLC CatExpress--I'd be happy to help you
if I can with exporting from Connexion Client or Connexion web interface if
I can.

(The Connexion Client interface hasn't changed at all in years, so that one
is stable & still resembles the Koha Manual screenshots.)

Cheerio,
h2
~~
Heather Hernandez
Technical Services Librarian
San Francisco Maritime National Historical Park Research Center
2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
415-561-7032, heather_hernan...@nps.gov
Library catalog: http://keys.bywatersolutions.com/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] cataloguing in koha according to RDA

2018-03-19 Thread Hernandez, Heather

Hi!

Yes--you can use any cataloging rules that you like.

If you are then using MARC21, RDA is most commonly indicated with "i" in
the 000/Leader/position 18 ("Descriptive Cataloging Form" in Koha) and 040
subfield e value of "rda," e.g.:

040 _ _ $e rda

Cheerio,
h2
~~
Heather Hernandez
Technical Services Librarian
San Francisco Maritime National Historical Park Research Center
2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
415-561-7032, heather_hernan...@nps.gov
Library catalog: http://keys.bywatersolutions.com/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Performance

El lun., 19 mar. 2018 a las 11:35, JanM ()
escribió:

> MySQL-Version:  mysql Ver 15.1 Distrib 10.0.34-MariaDB, for
> debian-linux-gnu
> (x86_64) using readline 5.2
> Apache-Version: Server version: Apache/2.4.18 (Ubuntu)
> Memcached:  Server: Nicht definiert | Namespace: koha | Status:
> unbekannt |
> Konfiguration gelesen aus: Nirgendwo Bitte beachten Sie, dass die
> Memcached-Konfiguration in Iher $KOHA_CONF-Datei erfolgen sollte. Aktuell
> gibt es keine gültige Memcached-Konfiguration. | Aktive Caching-Methode:
> Cache::Memory/
>

You are not running Plack (or is not configured correctly. To enable it you
need to run:

 $ sudo koha-plack --enable 
 $ sudo koha-plack --restart 
 $ sudo systemctl restart apache2

If it is already enabled, chances are you havent restarted apache2 or
launched the koha-plack process.

Good luck!

-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Performance

2018-03-19 Thread JanM

Activated Memcached and now I gained about 2 Seconds. So a request takes
about 6 Seconds.
I also made a request to add another CPU Core to the system. Hope this
helps. 

I took a look at another Koha Setup:
http://catalogue.demo1711-koha.test.biblibre.eu/cgi-bin/koha/opac-search.pl?idx==Forschung

This is my Setup:
https://www.testothek.uni-hamburg.de

The Performance difference is huge, hope I'll get there...

I'll keep you updated, thanks for now!
Jan



--
Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Out of memory

Heh. You're so right.

https://www.youtube.com/watch?v=RVnrpBROMkQ=youtu.be=69


On Mon, Mar 19, 2018 at 11:15 AM, Chris Brown  wrote:

> Barton et al,
>
> The output from the "free" command in Rubeno's original post shows that he
> has no swap space.
>
> Chris Brown
>
>
> On Mon, Mar 19, 2018 at 2:55 PM, Barton Chittenden <
> bar...@bywatersolutions.com> wrote:
>
>> How much swap space do you have allocated?
>>
>> There are probably a lot of libraries loaded where Koha is only using a
>> function or two, and I believe that MySQL is very aggressive about loading
>> data into memory, not all of which is used.
>>
>> Conventional wisdom is that swap will slow down the system because you
>> have
>> to page things back into memory... but conventional wisdom doesn't take
>> into account the fact that there are a lot of things that get loaded into
>> memory but not used. Swap is good, folks!
>>
>> --Barton
>>
>> On Mon, Mar 19, 2018 at 10:04 AM, Mark Alexander  wrote:
>>
>> > Excerpts from Rubeno Fernández's message of 2018-03-19 07:12:29 +0100:
>> > > How much memory do you need to run Koha?
>> > > I run a database with about 22000 records on a virtual server on
>> Digital
>> > Ocean
>> > > with 1GB memory and very low usage, but the server is crashing very
>> > often.
>> >
>> > We're running Koha 17.11.02 on Linode (Debian 8) with 2 GB of RAM, and
>> > our library has about 25000 item records.  So far we haven't had any out
>> > of memory problems.
>> > ___
>> > 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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Out of memory

2018-03-19 Thread Chris Brown

Barton et al,

The output from the "free" command in Rubeno's original post shows that he
has no swap space.

Chris Brown


On Mon, Mar 19, 2018 at 2:55 PM, Barton Chittenden <
bar...@bywatersolutions.com> wrote:

> How much swap space do you have allocated?
>
> There are probably a lot of libraries loaded where Koha is only using a
> function or two, and I believe that MySQL is very aggressive about loading
> data into memory, not all of which is used.
>
> Conventional wisdom is that swap will slow down the system because you have
> to page things back into memory... but conventional wisdom doesn't take
> into account the fact that there are a lot of things that get loaded into
> memory but not used. Swap is good, folks!
>
> --Barton
>
> On Mon, Mar 19, 2018 at 10:04 AM, Mark Alexander  wrote:
>
> > Excerpts from Rubeno Fernández's message of 2018-03-19 07:12:29 +0100:
> > > How much memory do you need to run Koha?
> > > I run a database with about 22000 records on a virtual server on
> Digital
> > Ocean
> > > with 1GB memory and very low usage, but the server is crashing very
> > often.
> >
> > We're running Koha 17.11.02 on Linode (Debian 8) with 2 GB of RAM, and
> > our library has about 25000 item records.  So far we haven't had any out
> > of memory problems.
> > ___
> > 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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] cataloguing in koha according to RDA

2018-03-19 Thread Javed Sahil

Hi all,

 Can we make catalogue entries in koha according to RDA?

  if yes plz guide where to select or chooseRDA in koha?

Regards,
Javed Shoukat
Lahore University of Management Sciences (LUMS),
Lahore,
Pakistan.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Out of memory

How much swap space do you have allocated?

There are probably a lot of libraries loaded where Koha is only using a
function or two, and I believe that MySQL is very aggressive about loading
data into memory, not all of which is used.

Conventional wisdom is that swap will slow down the system because you have
to page things back into memory... but conventional wisdom doesn't take
into account the fact that there are a lot of things that get loaded into
memory but not used. Swap is good, folks!

--Barton

On Mon, Mar 19, 2018 at 10:04 AM, Mark Alexander  wrote:

> Excerpts from Rubeno Fernández's message of 2018-03-19 07:12:29 +0100:
> > How much memory do you need to run Koha?
> > I run a database with about 22000 records on a virtual server on Digital
> Ocean
> > with 1GB memory and very low usage, but the server is crashing very
> often.
>
> We're running Koha 17.11.02 on Linode (Debian 8) with 2 GB of RAM, and
> our library has about 25000 item records.  So far we haven't had any out
> of memory problems.
> ___
> 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 Performance

I would raise the cores count (two cores) and make sure memcached is
installed and configured.

To install memcached (on te Koha server):

$ sudo apt install memcached

To configure memcached to be used by Koha, make sure the relevant
koha-conf.xml file contains something that looks like this:

 127.0.0.1:11211
 koha_koha

Tell us how it goes!

El lun., 19 mar. 2018 a las 11:35, JanM ()
escribió:

> /Koha-Version:  17.11.03.000
> OS Version ('uname -a'):Linux www2 4.4.0-96-generic #119-Ubuntu
> SMP Tue
> Sep 12 14:59:54 UTC 2017 x86_64
> Perl Interpreter:   /usr/bin/perl
> Perl-Version:   5.022001
> Perl @INC:  /usr/share/koha/lib
> /etc/perl
> /usr/local/lib/x86_64-linux-gnu/perl/5.22.1
> /usr/local/share/perl/5.22.1
> /usr/lib/x86_64-linux-gnu/perl5/5.22
> /usr/share/perl5
> /usr/lib/x86_64-linux-gnu/perl/5.22
> /usr/share/perl/5.22
> /usr/local/lib/site_perl
> /usr/lib/x86_64-linux-gnu/perl-base
> .
> MySQL-Version:  mysql Ver 15.1 Distrib 10.0.34-MariaDB, for
> debian-linux-gnu
> (x86_64) using readline 5.2
> Apache-Version: Server version: Apache/2.4.18 (Ubuntu)
> Memcached:  Server: Nicht definiert | Namespace: koha | Status:
> unbekannt |
> Konfiguration gelesen aus: Nirgendwo Bitte beachten Sie, dass die
> Memcached-Konfiguration in Iher $KOHA_CONF-Datei erfolgen sollte. Aktuell
> gibt es keine gültige Memcached-Konfiguration. | Aktive Caching-Methode:
> Cache::Memory/
>
>
>
> Running on an Intel Xeon X6550. Virtual Machine (VMWare) with 1 Core. 16Gb
> Ram.
> Memcache is not enabled. I have no information about the DB Server, it is
> provided from our computer center. We trace the request from the webserver
> an had about 2ms process time per request. So at 4000 querys we talk about
> 8
> Seconds. That would explain much of the 10 Seconds delay (4000Querys * 2ms
> =
> 8 Seconds.)
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Performance

2018-03-19 Thread JanM

/Koha-Version:  17.11.03.000
OS Version ('uname -a'):Linux www2 4.4.0-96-generic #119-Ubuntu SMP Tue
Sep 12 14:59:54 UTC 2017 x86_64
Perl Interpreter:   /usr/bin/perl
Perl-Version:   5.022001
Perl @INC:  /usr/share/koha/lib
/etc/perl
/usr/local/lib/x86_64-linux-gnu/perl/5.22.1
/usr/local/share/perl/5.22.1
/usr/lib/x86_64-linux-gnu/perl5/5.22
/usr/share/perl5
/usr/lib/x86_64-linux-gnu/perl/5.22
/usr/share/perl/5.22
/usr/local/lib/site_perl
/usr/lib/x86_64-linux-gnu/perl-base
.
MySQL-Version:  mysql Ver 15.1 Distrib 10.0.34-MariaDB, for debian-linux-gnu
(x86_64) using readline 5.2
Apache-Version: Server version: Apache/2.4.18 (Ubuntu)
Memcached:  Server: Nicht definiert | Namespace: koha | Status: unbekannt |
Konfiguration gelesen aus: Nirgendwo Bitte beachten Sie, dass die
Memcached-Konfiguration in Iher $KOHA_CONF-Datei erfolgen sollte. Aktuell
gibt es keine gültige Memcached-Konfiguration. | Aktive Caching-Methode:
Cache::Memory/



Running on an Intel Xeon X6550. Virtual Machine (VMWare) with 1 Core. 16Gb
Ram. 
Memcache is not enabled. I have no information about the DB Server, it is
provided from our computer center. We trace the request from the webserver
an had about 2ms process time per request. So at 4000 querys we talk about 8
Seconds. That would explain much of the 10 Seconds delay (4000Querys * 2ms =
8 Seconds.) 



--
Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha Performance

Hi Jan, could you tell us more about your setup?

- Koha version?
- Is memcached enabled and functional? More > About > System information
- Any other problems reported in About page?
- Specs for the server
- External DB server?

Regards

El lun., 19 mar. 2018 a las 7:12, JanM ()
escribió:

> Hi,
>
> i'm new to Koha and at the university i'm working at we have a small
> library
> with about 50 items.
> We have a small server where Koha is running on. Plack is also enabled. We
> are running a Mariadb on an other server.
>
> The problem is, that it takes about 10 seconds for a request to be
> answered.
> In example a User is searching for "Alters-Konzentrations-Test" and the
> result takes about 10 seconds. Also the whole navigation on the page feels
> slow.
>
> Per search request there are about 4000 queries sent to the database
> server,
> is this normal? What else can I check?
>
> Kind regards
> Jan
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] ebook report

2018-03-19 Thread Martha Fuerst

I cobbled together something quickly by Frankensteining some of our other 
digital resources reports. We use a different item type for ebooks and 
downloadable audio, so if you do the same, that would be a way to aggregate 
them.

SELECT bi.biblioitemnumber as 'Item Number’,
bi.isbn as 'ISBN’,
publicationyear as 'Pub Year’,
b.title as 'Title’,
b.author as 'Author’,
i.dateaccessioned as "Added”,
bi.itemtype as 'Type'
FROM biblioitems bi
LEFT JOIN biblio b USING (biblionumber)
LEFT JOIN items i ON (bi.biblioitemnumber = i.itemnumber)
WHERE bi.itemtype IN ('EBOOK','AUDIOBOOK')

Alternatively, your where statement could be:

WHERE bi.isbn IS NOT NULL
AND i.barcode IS NULL

Happy reporting!

Best,

Marti Fuerst
Systems Librarian
Huntsville-Madison County Public Library
915 Monroe St, Huntsville, AL 35801
http://hmcpl.org/ — mfue...@hmcpl.org

> On Mar 19, 2018, at 1:55 AM, Katrin Fischer  wrote:
> 
> Hi Amy,
> 
> can you share what you have so far?
> 
> I haven't tested, but you could try something like:
> 
> WHERE biblioitems.isbn is NOT NULL and biblioitems.isbn != ""
> 
> Hope this helps,
> 
> Katrin
> 
> On 16.03.2018 21:32, Amy Schuler wrote:
>> Hello,
>> does anyone have an ebook report they are willing to share?  I need a
>> report that will generate a list (with titles) of all ebooks in my
>> catalog.  This means barcode would be null but ISBN would NOT be null.
>> It's the ISBN part that I'm having trouble with in my attempts to build an
>> SQL report.  If you can help, I'd appreciate it.
>> I did not find any ebook reports at all in the Koha reports library.  Weird?
>> 
>> Thanks!
>> Amy
>> 
>> 
>> 
> 
> ___
> 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] Out of memory

2018-03-19 Thread Mark Alexander

Excerpts from Rubeno Fernández's message of 2018-03-19 07:12:29 +0100:
> How much memory do you need to run Koha?
> I run a database with about 22000 records on a virtual server on Digital 
> Ocean 
> with 1GB memory and very low usage, but the server is crashing very often.

We're running Koha 17.11.02 on Linode (Debian 8) with 2 GB of RAM, and
our library has about 25000 item records.  So far we haven't had any out
of memory problems.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Out of memory

2018-03-19 Thread King, Fred

I had a similar experience. I was running a test installation on a Digital 
Ocean server with 512MB RAM where I was the *only* user. The production site 
has much more and is a lot happier.

Fred King
Medical Librarian, MedStar Washington Hospital Center
fred.k...@medstar.net
202-877-6670
ORCID -0001-5266-0279
MedStar Authors Catalog: http://medstarauthors.org

Sometimes I wake up from a dream and then go back to it in disguise so I can 
find out what they’re saying about me behind my back.
--Bill in Portland


-Original Message-
From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Chris Brown
Sent: Monday, March 19, 2018 3:28 AM
To: Rubeno Fernández
Cc: koha
Subject: Re: [Koha] Out of memory

Hi Rubeno,

We have less biblio records than you (about 5000) and initially we hosted Koha 
on a VPS with just 1Gb of memory, also from Digital Ocean, as it happens. With 
six staff users logged in (during training sessions) were getting a variety of 
software errors, though I don't think mysqld ever crashed. Memory usage was 
pretty high, and upgrading to a droplet with 2Gb of memory gave a big 
improvement. It's certainly worth a try.  Running "top" may give you a more 
fine-grained picture of memory usage, particularly if you sort on the %MEM 
column.

Hope this helps,

Best Regards,

Chris Brown


On Mon, Mar 19, 2018 at 6:12 AM, Rubeno Fernández 
wrote:

> Hi all,
>
> How much memory do you need to run Koha?
> I run a database with about 22000 records on a virtual server on 
> Digital Ocean with 1GB memory and very low usage, but the server is 
> crashing very often.
>
> With dmesg I find this kind of messages several times a day:
>
> [Sun Mar 18 16:10:10 2018] 
> https://urldefense.proofpoint.com/v2/url?u=http-3A__addbiblio.pl=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=_CAkvYy8a_k5aiwJyQiQqtxn5XZudWCc-7c9qWutA44=Pr97cNpNijeEtvP2zz_V-3RB5qcZ1D5NoouUxkbV6CA=
>  invoked oom-killer:
> gfp_mask=0x24201ca, order=0, oom_score_adj=0 [Sun Mar 18 16:10:10 
> 2018] 
> https://urldefense.proofpoint.com/v2/url?u=http-3A__addbiblio.pl=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=_CAkvYy8a_k5aiwJyQiQqtxn5XZudWCc-7c9qWutA44=Pr97cNpNijeEtvP2zz_V-3RB5qcZ1D5NoouUxkbV6CA=
>  cpuset=/ mems_allowed=0 And then MySQL crashes and restarts:
> Sun Mar 18 16:10:10 2018] Out of memory: Kill process 6539 (mysqld) 
> score
> 222
> or sacrifice child
> [Sun Mar 18 16:10:10 2018] Killed process 6539 (mysqld) 
> total-vm:1538124kB, anon-rss:224948kB, file-rss:0kB
>
> From /var/log/syslog:
> Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Main process 
> exited, code=killed, status=9/KILL Mar 18 16:10:11 biblioteko 
> systemd[1]: mysql.service: Unit entered failed state.
> Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Failed with 
> result 'signal'.
> Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Service hold-off 
> time over, scheduling restart.
> Mar 18 16:10:11 biblioteko systemd[1]: Stopped MySQL Community Server.
> Mar 18 16:10:11 biblioteko systemd[1]: Starting MySQL Community Server...
>
> Just yesterday the killed process was rebuild_zebra.p, which didn't 
> restart, and Koha was retrieving no results for searches.
>
> The strange thing is that Digital Ocean's own monitoring tool never 
> reports such memory spikes: usage is usually high but never more than 
> 80%. Maybe the spikes are too short? What would you recommend for a 
> more fine-grained monitoring of memory?
>
> Right now my memory is this:
> root@biblioteko:~# free
>   totalusedfree  shared  buff/cache
> available
> Mem:1016056  555304  266328   14936  194424
> 292164
> Swap: 0   0   0
>
> On file /etc/mysql/mysql.conf.d/mysqld.cnf the value of 
> "innodb_buffer_pool_size" is 385M, if that's of any help.
>
> Do I really need more physical memory on my server?
> ___
> Koha mailing list  
> https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.o
> rg=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjy
> C51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=_CAkvYy8a_k5aiwJyQiQqtxn5XZudWCc-7
> c9qWutA44=tnQspFRCDDxEBJblf-_FcsZhDDeWhlcF6WhHYxtZDgo=
> Koha@lists.katipo.co.nz
> https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.n
> z_mailman_listinfo_koha=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVx
> j8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=_CAkvYy8a_k5a
> iwJyQiQqtxn5XZudWCc-7c9qWutA44=x97u-EzVBbonN7yFavnLDjNXL8LhF7E3kf82U
> Nc9pUg=
>
___
Koha mailing list  
https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=_CAkvYy8a_k5aiwJyQiQqtxn5XZudWCc-7c9qWutA44=tnQspFRCDDxEBJblf-_FcsZhDDeWhlcF6WhHYxtZDgo=

Re: [Koha] Customized MARC21 framework

Of course not!

El lun., 19 de mar. de 2018 7:59 a. m., Narcis Garcia 
escribió:

> Including whole MARC21 specification (hidden or not), does Koha write
> the 4000 subtags for each item record in database?!
>
>
> El 19/03/18 a les 07:46, Katrin Fischer ha escrit:
> > Hi Narcis,
> >
> > better to hide the fields using the hidden values documented on the wiki
> > (https://wiki.koha-community.org/wiki/Hidden_values) than to delete the
> > fields and subfields you don't need. Deleting some of the fields like
> > 000 and 999 can lead to errors. Also when you import data and the
> > records contain deleted fields, the information in them will be lost on
> > saving the item.
> >
> > Hope this helps,
> >
> > Katrin
> >
> >
> > On 14.03.2018 17:41, Narcis Garcia wrote:
> >> As I understand, a valid way to have a customized framework (as most
> >> compatible as possible) is:
> >>
> >> 1. Go to MARC frameworks
> >>
> >> 2. Esport "BASE" (default) framework to CSV format
> >>
> >> 3. Edit file with a text editor and remove all lines except:
> >> - Headings
> >> - Mask lines ("#-#")
> >> - Desired subtags to be used finally
> >> - The tags that have selected subtags
> >>
> >> 4. Create +New framework
> >>
> >> 5. Import edited file to new created framework.
> >>
> >>
> >> Am I right to patrons use it for cataloguing?
> >>
> >> Thanks.
> >> ___
> >> 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 mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Customized MARC21 framework

2018-03-19 Thread Narcis Garcia

Including whole MARC21 specification (hidden or not), does Koha write
the 4000 subtags for each item record in database?!


El 19/03/18 a les 07:46, Katrin Fischer ha escrit:
> Hi Narcis,
> 
> better to hide the fields using the hidden values documented on the wiki
> (https://wiki.koha-community.org/wiki/Hidden_values) than to delete the
> fields and subfields you don't need. Deleting some of the fields like
> 000 and 999 can lead to errors. Also when you import data and the
> records contain deleted fields, the information in them will be lost on
> saving the item.
> 
> Hope this helps,
> 
> Katrin
> 
> 
> On 14.03.2018 17:41, Narcis Garcia wrote:
>> As I understand, a valid way to have a customized framework (as most
>> compatible as possible) is:
>>
>> 1. Go to MARC frameworks
>>
>> 2. Esport "BASE" (default) framework to CSV format
>>
>> 3. Edit file with a text editor and remove all lines except:
>> - Headings
>> - Mask lines ("#-#")
>> - Desired subtags to be used finally
>> - The tags that have selected subtags
>>
>> 4. Create +New framework
>>
>> 5. Import edited file to new created framework.
>>
>>
>> Am I right to patrons use it for cataloguing?
>>
>> Thanks.
>> ___
>> 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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Need to change the pickup location of the hold

2018-03-19 Thread Kyle Hall

So, are you forcing patron's to select an item to place a hold on? That is,
are you dis-allowing record level holds? That would be the first step in
getting to what you want.

Kyle



http://www.kylehall.info
ByWater Solutions ( http://bywatersolutions.com )
Meadville Public Library ( http://www.meadvillelibrary.org )
Crawford County Federated Library System ( http://www.ccfls.org )

On Tue, Mar 13, 2018 at 9:40 AM, Anne-Marie Mana Deweerdt <
anne-marie.dewee...@uclouvain.be> wrote:

> Hello,
>
> We are configuring the "holds" functionality in Koha and we disabled the
> possibility for the user to chose the pickup location, to suspend the hold
> etc.
> However when we place a hold it takes the patron home library as the
> pickup location.
> We would like to know if it is possible to configure that and have the
> item's home library in place of the patron's home library.
>
> In our libraries once a patron makes a request on an available item he has
> to pick it up by himself from the shelves.
> We prepare the item only for "closed stack request".
> If the request was placed on a checked out book he receives an alert that
> the item is ready to pickup at the circulation desk.
>
> Kind regards,
>
> --
> Mana Deweerdt
>
> ___
> 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] Koha Performance

2018-03-19 Thread JanM

Hi, 

i'm new to Koha and at the university i'm working at we have a small library
with about 50 items. 
We have a small server where Koha is running on. Plack is also enabled. We
are running a Mariadb on an other server.

The problem is, that it takes about 10 seconds for a request to be answered.
In example a User is searching for "Alters-Konzentrations-Test" and the
result takes about 10 seconds. Also the whole navigation on the page feels
slow. 

Per search request there are about 4000 queries sent to the database server,
is this normal? What else can I check?

Kind regards
Jan



--
Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Out of memory

2018-03-19 Thread Chris Brown

Hi Rubeno,

We have less biblio records than you (about 5000) and initially we hosted
Koha on a VPS with just 1Gb of memory, also from Digital Ocean, as it
happens. With six staff users logged in (during training sessions) were
getting a variety of software errors, though I don't think mysqld ever
crashed. Memory usage was pretty high, and upgrading to a droplet with 2Gb
of memory gave a big improvement. It's certainly worth a try.  Running
"top" may give you a more fine-grained picture of memory usage,
particularly if you sort on the %MEM column.

Hope this helps,

Best Regards,

Chris Brown


On Mon, Mar 19, 2018 at 6:12 AM, Rubeno Fernández 
wrote:

> Hi all,
>
> How much memory do you need to run Koha?
> I run a database with about 22000 records on a virtual server on Digital
> Ocean
> with 1GB memory and very low usage, but the server is crashing very often.
>
> With dmesg I find this kind of messages several times a day:
>
> [Sun Mar 18 16:10:10 2018] addbiblio.pl invoked oom-killer:
> gfp_mask=0x24201ca, order=0, oom_score_adj=0
> [Sun Mar 18 16:10:10 2018] addbiblio.pl cpuset=/ mems_allowed=0
> And then MySQL crashes and restarts:
> Sun Mar 18 16:10:10 2018] Out of memory: Kill process 6539 (mysqld) score
> 222
> or sacrifice child
> [Sun Mar 18 16:10:10 2018] Killed process 6539 (mysqld) total-vm:1538124kB,
> anon-rss:224948kB, file-rss:0kB
>
> From /var/log/syslog:
> Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Main process exited,
> code=killed, status=9/KILL
> Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Unit entered failed
> state.
> Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Failed with result
> 'signal'.
> Mar 18 16:10:11 biblioteko systemd[1]: mysql.service: Service hold-off time
> over, scheduling restart.
> Mar 18 16:10:11 biblioteko systemd[1]: Stopped MySQL Community Server.
> Mar 18 16:10:11 biblioteko systemd[1]: Starting MySQL Community Server...
>
> Just yesterday the killed process was rebuild_zebra.p, which didn't
> restart,
> and Koha was retrieving no results for searches.
>
> The strange thing is that Digital Ocean's own monitoring tool never reports
> such memory spikes: usage is usually high but never more than 80%. Maybe
> the
> spikes are too short? What would you recommend for a more fine-grained
> monitoring of memory?
>
> Right now my memory is this:
> root@biblioteko:~# free
>   totalusedfree  shared  buff/cache
> available
> Mem:1016056  555304  266328   14936  194424
> 292164
> Swap: 0   0   0
>
> On file /etc/mysql/mysql.conf.d/mysqld.cnf the value of
> "innodb_buffer_pool_size" is 385M, if that's of any help.
>
> Do I really need more physical memory on my server?
> ___
> 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] Report help

2018-03-19 Thread Mutasem Al Shami

Hi,

any one can help me, i need report to count number of search book in koha.

thank,
Mutasem

Disclaimer: This message and its attachment, if any, are confidential and
may contain legally privileged information. If you are not the intended
recipient, please contact the sender immediately and delete this message
and its attachment, if any, from your system. You should not copy this
message or disclose its contents to any other person or use it for any
purpose. Statements and opinions expressed in this e-mail are those of the
sender, and do not necessarily reflect those of Al Maarefa College (MCST).
All opinions and/or views expressed in this email are solely those of the
author and do not necessarily represent those of MCST, MCSTaccepts no
liability for damage caused by any virus transmitted by this email.

تنويه: هذه الرسالة ومرفقاتها (إن وجدت) تمثل وثيقة سرية قد تحتوي على
معلومات تتمتع بحماية وحصانة قانونية. إذا لم تكن الشخص المعني بهذه الرسالة
يجب عليك تنبيه المُرسل بخطأ وصولها إليك، وحذف الرسالة ومرفقاتها. ولا يجوز
لك نسخ هذه الرسالة أو مرفقاتها أو أي جزء منها، أو البوح بمحتوياتها لأي شخص
أو استعمالها لأي غرض. علماً بأن الآراء والإفادات التي تحويها هذه الرسالة
تعبر فقط عن رأي المُرسل وليس بالضرورة رأي كلية المعرفة، ولا تتحمل كلية
المعرفة أي مسئولية عن الأضرار الناتجة عن أي فيروسات قد يحملها هذا البريد.

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

Re: [Koha] ebook report


Hi Amy,

can you share what you have so far?

I haven't tested, but you could try something like:

WHERE biblioitems.isbn is NOT NULL and biblioitems.isbn != ""

Hope this helps,

Katrin

On 16.03.2018 21:32, Amy Schuler wrote:

Hello,
does anyone have an ebook report they are willing to share?  I need a
report that will generate a list (with titles) of all ebooks in my
catalog.  This means barcode would be null but ISBN would NOT be null.
It's the ISBN part that I'm having trouble with in my attempts to build an
SQL report.  If you can help, I'd appreciate it.
I did not find any ebook reports at all in the Koha reports library.  Weird?

Thanks!
Amy





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

Re: [Koha] Customized MARC21 framework


Hi Narcis,

better to hide the fields using the hidden values documented on the wiki 
(https://wiki.koha-community.org/wiki/Hidden_values) than to delete the 
fields and subfields you don't need. Deleting some of the fields like 
000 and 999 can lead to errors. Also when you import data and the 
records contain deleted fields, the information in them will be lost on 
saving the item.


Hope this helps,

Katrin


On 14.03.2018 17:41, Narcis Garcia wrote:

As I understand, a valid way to have a customized framework (as most
compatible as possible) is:

1. Go to MARC frameworks

2. Esport "BASE" (default) framework to CSV format

3. Edit file with a text editor and remove all lines except:
- Headings
- Mask lines ("#-#")
- Desired subtags to be used finally
- The tags that have selected subtags

4. Create +New framework

5. Import edited file to new created framework.


Am I right to patrons use it for cataloguing?

Thanks.
___
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] zebra indexing


Hi Erlanda,

it looks like you have a few items in your database that have no item 
type set in the item. If you fix them, the warnings shown below should 
disappear.


A report like this should help you locating them:

SELECT itemnumber, barcode, itemcallnumber FROM items WHERE itype is 
NULL or itype = "";


Hope this helps,

Katrin


On 18.03.2018 09:40, Erlanda Simonyan wrote:

HI!
Please, help to solve this problem. We are using koha 3.22 tarball. Zebra 
couldn't index some part of records and brought such result ... (It exported 
1167825 records, but indexing only 1151630 }
Thanks

1139801...item-level_itypes set but no itemtype set for item (5665862) at 
/usr/share/koha/lib/Koha/Schema/Result/Item.pm line 654.
item-level_itypes set but no itemtype set for item (5665863) at 
/usr/share/koha/lib/Koha/Schema/Result/Item.pm line 654.
item-level_itypes set but no itemtype set for item (5665864) at 
/usr/share/koha/lib/Koha/Schema/Result/Item.pm line 654.
item-level_itypes
 set but no itemtype set for item (5671206) at 
/usr/share/koha/lib/Koha/Schema/Result/Item.pm line 654.
item-level_itypes set but no itemtype set for item (5671207) at 
/usr/share/koha/lib/Koha/Schema/Result/Item.pm line 654.
1154001.item-level_itypes 
set but no itemtype set for item (5785581) at 
/usr/share/koha/lib/Koha/Schema/Result/Item.pm line 654.
1167801
Records exported: 1167825

REINDEXING zebra

zebraidx: reckeys.c:271: zebra_rec_keys_read: Assertion `keys->fetch_offset < 
keys->buf_used' failed.
04:19:42-18/03 zebraidx(126032) [warn] previous transaction didn't reach commit
___
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 not allowing renewals, help needed


Hi Chris,

have you been able to resolve this issue?

Some other things you could check:

- Check there is no specific rule for a library overwriting the rule for 
all libraries

- Did you set a renewal period in circulation conditions?
- OpacRenewalAllowed

Hope this helps,

Katrin


On 12.03.2018 17:18, Chris Brown wrote:

Gentle Reader,

I am having a problem with a Koha system I've set up for training.
For all books and all patrons the "Renew" column of the checkout table
shows "Not renewable (0 of 0 renewals remaining)"

I have only one circulation rule; it has the number of renewals set to 3.
The "No renewal before" field is blank.

Some other potentially relevant sysprefs are as follows:

OverduesBlockRenewing  is set to "allow renewing"
RestrictionsBlockRenewing is set to "Allow"

A training system for another library that is hosted on the same server, and
which is identically configured as far as I can see, is working fine.

Any suggestions on what could be preventing renewals would be appreciated!

Using Koha 17.05 installed from debian packages on Debian 9

Best Regards,

Chris Brown
___
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] Fw: Koha creating budget error