[Koha] Request for Solution

[Tahir Jan, Assistant Librarian, Central Library, UoP]

Dear All
I hide field 650 in the default framework. Now I want to unhide the same.
Can anyone help me in this regard?

-- 
Dr. Tahir Jan
Assistant Librarian
University of Peshawar
Office: +92-91-907
Contact: +92-310-9985164
E-Mail: tahir...@uop.edu.pk
___

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

[Koha] Conversion of WinISIS data to Koha

[Tahir Jan, Assistant Librarian, Central Library, UoP]

Dear All
I have WinISIS data and want to convert it into Koha. Can anyone help me
this regard.
___

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

[Koha] How to reinstate the field 650 in default framework

[Tahir Jan, Assistant Librarian, Central Library, UoP]

Dear All
Hope you this email finds you well.
I deleted 650 field in the default framework.
Now I need this field again to make enteries in same. Please help in this
matter.
___

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

[Koha] Koha login error

[MASTeR Library]

Dear sri, koha when logging in the following error is coming what should be
done to fix this.
n error has occurred!*Error 500*This message may have been caused by any of
the following reasons:

   - You made use of an external link to an item that is no longer available
   - You followed an outdated link e.g. from a search engine or a bookmark
   - You tried to access a page that needs authentication
   - An internal link in the client is broken and the page does not exist

What's next?

   - Use top menu bar to navigate to another part of Koha.
   - To report a broken link or any other issue, please contact the Koha
   administrator. Send email 
___

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

[Koha] Koha 23.05.05 advanced editor interface hanging on editing existing catalogue record

[Rosewood Farm Library]

Dear all,

I am running Koha 23.05.05 and using Google Chrome as the browser.

Does anyone else have trouble editing an existing catalogue record using
the advanced editor?

After we switched to the Advanced Editor from the basic editor, the screen
just showed "Loading, please wait ...".  Pressed F12 and I noticed there
are two page errors of "Incorrect use of .

Kind regards,

Iming Chan (Mr.)
Manager


*Rosewood Farm Library*


*ROSEWOOD FARM GROUP PTY. LTD.*
ACN 621 676 711 | ATF Bullas Chan Trust (ABN 95 696 171 924)
20 Research Road (PO Box 363), Lara, Victoria, 3212, Australia
(03) 5275 2939 | https://rosewoodfarm.com.au <http://rosewoodfarm.com.au>

Cat Boarding | Secured Storage | Canine Fitness
___

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

Re: [Koha] Question on MARC Frameworks and Staging/Importing records

[MoFP Library]

Hi Anke,

If your records were imported into the default framework, there are couple 
other options to get them into the ones configured by the library.
1. Click on 'Edit Record' to open the imported record
2. On the top right, click on the 'Settings' tab and choose from the configured 
framework

OR

1. Go to Tools and select 'Batch record modification' under the 'Catalog' column
2. Choose from the list the modification template you want to change the MARC 
record to (ensure that your library configured modification templates)

Hope this helps.

From: Koha  on behalf of Katrin Fischer 

Sent: Saturday, November 4, 2023 6:50 AM
To: koha@lists.katipo.co.nz
Subject: Re: [Koha] Question on MARC Frameworks and Staging/Importing records

Hi Anke,

we only use the default framework usually, apart from locally catalogued
items, so there might be other tricks I am missing.

The framework use for a record is stored in biblio.frameworkcode. And
you could update it with SQL. Not sure if it's cached and if that would
take effect immediately, but that's easy to find out.

Hope this helps,

Katrin

On 03.11.23 14:24, Bruns, Anke wrote:
> Hi,
>
> as I inadvertently imported some batches of records with the standard
> framework instead of the library's configured one, I think about how this
> can be corrected without having to repeat the imports.
>
> Can one
> a) recognize and
> b) batch change the MARC framework with which records have been imported via
> the WWW interface?
>
> Thanks in advance and best regards,
> Anke
>
>
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. 
Please note that any views or opinions presented in this email are solely those 
of the author and do not necessarily represent those of the Ministry of 
Finance. Finally, the recipient should check this email and any attachments for 
the presence of viruses. The Ministry accepts no liability for any damage 
caused by any virus transmitted by this email.
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. 
Please note that any views or opinions presented in this email are solely those 
of the author and do not necessarily represent those of the Ministry of 
Finance. Finally, the recipient should check this email and any attachments for 
the presence of viruses. The Ministry accepts no liability for any damage 
caused by any virus transmitted by this email.
___

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

[Koha] Import data from excel to koha and Cover image using Manual data entry

[Tahir Jan, Assistant Librarian, Central Library, UoP]

Dear All
I am facing problem in importing excel data to koha. Is anyone help me in
this regards.
Secondly when we are doing manual entry in koha then how can we upload
cover image of book.
Regards
Dt Jan
___

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

Re: [Koha] Where would I put the OpenLibrary ID in the MARC record

[Tahir Jan, Assistant Librarian, Central Library, UoP]

Dear
Good Morning
If you know the method that how to import books data from open library
please let me know.

Regards
Dr. Jan

On Thu, Jul 20, 2023 at 3:21 PM Nigel Titley  wrote:

> Just to give an example of an OpenLibrary record that I created earlier
> today
>
> https://openlibrary.org/books/OL49198571M/Analogue_Men#details
>
> If at all possible I'd like to be able to display the cover using the
> OLID (OL49198571M) but I'm not sure where to put it.
>
> Thanks
>
> Nigel
>
> On 20/07/2023 22:43, Nigel Titley wrote:
> > Gentlefolk
> >
> > I'm using the Openlibrary cover facility to display covers in my OPAC
> > and it generally works very well (in the case where the cover doesn't
> > exist in Openlibrary I scan and upload it). However, if the Biblio
> > record doesn't have an ISBN or LCCN the cover lookup fails (obviously).
> > Is there any way of recording the Openlibrary ID (OLID) in a Biblio
> > record so that the cover lookup will work, even if there is no ISBN or
> > LCCN?
> >
> > I've done a (fairly cursory) scan of the documentation but can't find
> > and reference to where I should put the OLID so that Koha will look up
> > the cover even if there is no ISBN or LCCN. Of course the facility may
> > not exist, in which case I'd be grateful for confirmation from Someone
> > Who Knows.
> >
> > Many thanks
> >
> > Nigel Titley
> >
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Dr. Tahir Jan
Assistant Librarian
University of Peshawar
Office: +92-91-907
Contact: +92-310-9985164
E-Mail: tahir...@uop.edu.pk
___

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

Re: [Koha] SQL report for URL

[MASTeR Library]

Visit item type wise collection SQL report
https://libpowertech.blogspot.com/2019/05/department-wise-number-of-books-in-your.html?m=1

On Thu, 20 Jul 2023, 2:32 pm Dr. Prajeesh Bhaskaran, 
wrote:

> Hi
> Please, can anyone help me to create a SQL report for getting the URL of
> all the items based on the collections in Koha.
>
> --
> With Regards
> Prajeesh Bhaskaran
> Reference Assistant (Library)
> Mahatma Gandhi University, Kerala, India.
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] hourly fines not calculating

[MASTeR Library]

Fine and rules/"overdue fines Cap", enter your maximum penalty calculation
amount and replace 0. For example, change 0 to 6000, which is the maximum
penalty amount to calculate.

On Wed, 5 Jul 2023, 1:28 am Hector Gonzalez Jaime,  wrote:

> Tom, you should check your circulation rules, and verify "overdue fines
> cap" is not zero (the default), as it would limit your fines to nothing.
>
> Make sure you have "CalculateFinesOnReturn" on, and "FinesMode" set to
> "Calculate and Charge"
>
> On 7/4/23 10:24, Tom Obrien wrote:
> > Hi all,
> > I installed koha 22 on ubuntu 22. Everything works except that Koha is
> not
> > calculating hourly fines. The long loan is working very well.
> > Kindly assist.
> > Tom
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
> --
> Hector Gonzalez
> ca...@genac.org
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] updating database Structure Error

[MASTeR Library]

Glad to hear it! Thank u.

On Wed, 21 Jun 2023, 1:14 pm Mr. Sitali C. S.,  wrote:

> Thanks a lot. It has worked like a charm. After adding the lines all I
> needed to do was to restart.
> Thank a lot for pointing me in the right direction. Much appreciated
>
> On Wed, 21 Jun 2023 at 07:38, MASTeR Library 
> wrote:
>
>> Hi!
>>
>> I added the lines:
>>  
>>  __ENCRYPTION_KEY__
>>
>> The update went through without a problem.
>>
>> https://github.com/Koha-Community/Koha/blob/master/etc/koha-conf.xml
>>
>> Good Luck!
>>
>> On Wed, 21 Jun 2023, 1:04 am Mr. Sitali C. S., 
>> wrote:
>>
>>> Greetings,
>>>
>>> I need help with the following error;
>>>
>>>- Upgrade to 22.12.00.041 [21:28:28]: Bug 30649 - Increase the vendor
>>>EDI account password field to 256 characters
>>>ERROR: Exception 'Koha::Exceptions::MissingParameter' thrown 'No
>>>encryption_key in koha-conf.xml'
>>>
>>> I installed Koha using the following;
>>>
>>> https://wiki.koha-community.org/wiki/Koha_on_Debian
>>> using ubuntu 22.04
>>>
>>> Thank you
>>> --
>>> Sitali Chrispin Simasiku,
>>> P. O. Box 660193,
>>> Monze,
>>> ZAMBIA.
>>>
>>> Mobile: +26 0979 869471
>>> +26 0966 869471
>>> SKYPE: Libsitali
>>> ___
>>>
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>
> --
> Sitali Chrispin Simasiku,
> P. O. Box 660193,
> Monze,
> ZAMBIA.
>
> Mobile: +26 0979 869471
> +26 0966 869471
> SKYPE: Libsitali
>
___

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

Re: [Koha] updating database Structure Error

[MASTeR Library]

Hi!

I added the lines:
 
 __ENCRYPTION_KEY__

The update went through without a problem.

https://github.com/Koha-Community/Koha/blob/master/etc/koha-conf.xml

Good Luck!

On Wed, 21 Jun 2023, 1:04 am Mr. Sitali C. S.,  wrote:

> Greetings,
>
> I need help with the following error;
>
>- Upgrade to 22.12.00.041 [21:28:28]: Bug 30649 - Increase the vendor
>EDI account password field to 256 characters
>ERROR: Exception 'Koha::Exceptions::MissingParameter' thrown 'No
>encryption_key in koha-conf.xml'
>
> I installed Koha using the following;
>
> https://wiki.koha-community.org/wiki/Koha_on_Debian
> using ubuntu 22.04
>
> Thank you
> --
> Sitali Chrispin Simasiku,
> P. O. Box 660193,
> Monze,
> ZAMBIA.
>
> Mobile: +26 0979 869471
> +26 0966 869471
> SKYPE: Libsitali
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Local covers and the Coverflow plugin

[MASTeR Library]

Copy and paste the above SQL code.
Save the report follow error,
*The following error was encountered:*
The database returned the following error:
Table 'koha_library.biblioimages' doesn't exist
Please check the log for further details.

On Tue, 20 Jun 2023, 1:09 pm libr...@ssst.edu.ba, 
wrote:

> Hi Alvaro,
>
> What do you mean by discard items with no covers? I don’t want to discard
> them; I want them to use the cover I upload for those records that don’t
> have Amazon covers (mostly because they are titles published in my country
> and are not available via big distributors). Or is that not what “discard”
> means in this context?
>
> Best regards
>
> Aida Đikić
>
>
> From: Alvaro Cornejo 
> Sent: Monday, June 19, 2023 4:34 PM
> To: libr...@ssst.edu.ba
> Cc: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Local covers and the Coverflow plugin
>
> Hi
>
> You need to "discard" items with no covers from your query.
>
> We use this:
>
> SELECT DISTINCT biblio.title, biblio.biblionumber, c.imagenumber AS
> localcover
> FROM items i
> LEFT JOIN biblioitems USING (biblioitemnumber)
> LEFT JOIN biblio ON (i.biblionumber=biblio.biblionumber)
> LEFT JOIN biblioimages c ON (i.biblionumber=c.biblionumber)
>   WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= i.dateaccessioned AND
> biblioitems.isbn IS NOT NULL  AND c.imagenumber != ''
>   ORDER BY rand()
> LIMIT  50
>
> Hope helps
>
> Regards
>
> Alvaro
>
>
>
> ||
> [
> https://ci3.googleusercontent.com/mail-sig/AIorK4zO0f8Z21m2X0jK3RWGktD8bapLQbsF7Zq7ukeIuapEB3QMlgOXKzxbFPpUQzsex8cwRRihwVw]
> Stay safe / Cuídate/  Reste sécurisé
> 7 Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
> mesure.
>  q Recycle always / Recicla siempre / Recyclez toujours
>  P Print only if absolutely necessary / Imprime solo si es necesario /
> Imprimez seulement si nécessaire
>
>
> Le lun. 19 juin 2023 à 02:16, libr...@ssst.edu.ba libr...@ssst.edu.ba> mailto:libr...@ssst.edu.ba>> a
> écrit :
> Hello Alvaro,
>
> I don't know how to do that, since I never even touched SQL before. I can
> copy and paste code from the SQL list, but don’t really understand what it
> does and how to change it to do what I need.
>
> I just checked the report, it is public. The code I'm using is from the
> plugin configuration:
>
> SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title
>   FROM items i
>   LEFT JOIN biblioitems m USING (biblioitemnumber)
>   LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
>   WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= i.dateaccessioned AND
> m.isbn IS NOT NULL AND m.isbn != ''
>   GROUP BY biblionumber
>   HAVING isbn != ""
>   ORDER BY rand()
>   LIMIT 30
>
> The instructions then go on to say:
>
> Note: You can add an additional column 'localcover' - this should be blank
> if the biblio doesn't have a localcover and can contain any other data if
> it does. If this column is populated a local cover will be used. Example
> below:
>
> SELECT DISTINCT biblio.title, biblio.biblionumber,
> SUBSTRING_INDEX(biblioitems.isbn, ' ', 1) AS isbn, c.imagenumber AS
> localcover
> FROM items
> LEFT JOIN biblioitems USING (biblioitemnumber)
> LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
> LEFT JOIN cover_images c ON (items.biblionumber=c.biblionumber)
> WHERE biblioitems.isbn IS NOT NULL AND biblioitems.isbn !=''
> ORDER BY RAND()
> LIMIT 15;
>
>
> But when I tried replacing the first code with the second, I didn't get
> any results. Right now I'm back to the original code, and have turned the
> local covers option off, so I have several "No image available" images.
> Where do I change what to get local covers?
>
> Best regards
>
> Aida Đikić
>
>
> From: Alvaro Cornejo  cornejo.alv...@gmail.com>>
> Sent: Friday, June 16, 2023 4:27 PM
> To: libr...@ssst.edu.ba
> Cc: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Local covers and the Coverflow plugin
>
> Hi Aida
>
> You only need to change/edit the report that pulls information for
> coverflow. Also remember to define the report as public.
>
> Regards
>
> Alvaro
>
>
> ||
>  Stay safe / Cuídate/  Reste sécurisé
> • Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
> mesure.
>  • Recycle always / Recicla siempre / Recyclez toujours
>  • Print only if absolutely necessary / Imprime solo si es necesario /
> Imprimez seulement si nécessaire
>
>
> Le ven. 16 juin 2023 à 03:41, mailto:libr...@ssst.edu.ba libr...@ssst.edu.ba> > a écrit :
> Hello again,
>
> I'm trying to find a way to have local covers show in the Coverflow plugin
> on the OPAC page for titles not added via Z39.50.
>
> I had originally set it up using the first example in the configuration
> (items added in the last 30 days), but 

Re: [Koha] Koha upgrade 22.11.6 to 23.5.00 upgrade-schema error

[MASTeR Library]

It working,
Thanks you Jonathan and all supports .

On Wed, 7 Jun 2023, 12:48 pm Jonathan Druart, <
jonathan.dru...@bugs.koha-community.org> wrote:

> Hey, put a proper key there! Not "__ENCRYPTION_KEY__"!
> It can be generated using the following command `pwgen 32`
>
> Le mer. 7 juin 2023 à 07:41, Сычев Игорь Алексеевич  a écrit :
>
> > Hi!
> >
> > I added the lines:
> >  
> >  __ENCRYPTION_KEY__
> >
> > The update went through without a problem.
> >
> > https://github.com/Koha-Community/Koha/blob/master/etc/koha-conf.xml
> >
> > Good Luck!
> >
> > Igor A. Sychev
> > Tomsk Polytechnic University
> > https://lib.tpu.ru
> >
> >
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

[Koha] Koha upgrade 22.11.6 to 23.5.00 upgrade-schema error

[MASTeR Library]

Hi All

Just upgraded tonight from Koha 212.11.06.000 to 23.05.00
That all went fine.

The About Koha page now says:
"Warning:


   - Upgrade to 22.12.00.041 [09:43:21]: Bug 30649 - Increase the vendor
   EDI account password field to 256 characters
   ERROR: Exception 'Koha::Exceptions::MissingParameter' thrown 'No
   encryption_key in koha-conf.xml'

Please help.

 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] Koha Fines script not running.

[MASTeR Library]

Hi
all jobs should always be run as your koha user. You can use 'sudo
koha-shell instance' to switch to that user and then try to run the job
again.

Some other things to make sure of:

system preference finesmode is set to "Calculate and charge"
today is not a holiday in the calendar of the library
the maxfine setting in circulation rules is > 0
Hope this helps,

On Mon, 5 Jun 2023, 7:04 pm Rupinder Singh,  wrote:

> HI,
> I configured my Circulation and Fine rules, and also did the settings in
> koha administration for fines.
> But when I tried to run my cronjob manually, it gave following error.
>
> /bin/sh: 1: misc/cronjobs/fines.pl: not found
>
>
> I figured out my fines.pl file is located in "/usr/share/koha/bin/cronjob"
> directory. I tried running it from there, and the terminal threw the
> following error.
>
> Can't locate Koha/Script.pm in @INC (you may need to install the
> Koha::Script module) (@INC contains: /usr/share/webmin /etc/perl
> /usr/local/lib/x86_64-linux-gnu/perl/5.34.0
> /usr/local/share/perl/5.34.0 /usr/lib/x86_64-linux-gnu/perl5/5.34
> /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base
> /usr/lib/x86_64-linux-gnu/perl/5.34 /usr/share/perl/5.34
> /usr/local/lib/site_perl) at /usr/share/koha/bin/cronjobs/fines.pl
> line 33.
> BEGIN failed--compilation aborted at
> /usr/share/koha/bin/cronjobs/fines.pl line 33.
>
>
> I tried installing "Koha::Scrip" from CPAN modules but couldn't find
> anything. However, I was able to install another Cpan package. By the name
> "Koha::Contrib::Tamil", but this was of no help too.
>
> Please suggest. How do I configure my Ubutnu 22.04 server to automatically
> run these fines.pl script. Am i doing something wrong?
>
> Thank you
> Rupinder Singh
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Koha 23.05 released

[MASTeR Library]

Super !!!  to the entire Koha Team!

On Thu, 1 Jun 2023, 2:14 am Kelly McElligott, 
wrote:

> Yahoo!!! Congrats to the entire Koha Team!
>
>
> Kelly McElligott, MLIS
> (she/her)
> Library Accounts Coordinator
> ByWater Solutions <http://bywatersolutions.com/>
> Koha <https://bywatersolutions.com/projects/koha>  |  Aspen Discovery
> <https://bywatersolutions.com/projects/aspen-discovery>
> Phone:(888)900-8944 <(888)%20900-8944>
> Follow us:
> <https://www.facebook.com/ByWaterSolutions/>
> <https://www.instagram.com/bywatersolutions/>
> <https://www.youtube.com/user/bywatersolutions>
> <https://twitter.com/ByWaterSolution>
>
> Currently Reading
> <
> https://www.goodreads.com/user/email_signature_destination/2645311?utm_medium=reading_link_source=email_signature
> >
> [image: Book Cover]
> <
> https://www.goodreads.com/user/email_signature_destination/2645311?utm_medium=cover_source=email_signature
> >
> [image: Goodreads Logo]
> <https://www.goodreads.com/?utm_medium=gr_logo_source=email_signature
> >Get
> your own email signature
> <
> https://www.goodreads.com/user/email_signature_instructions?utm_medium=gyo_link_source=email_signature
> >
>
>
> On Wed, May 31, 2023 at 3:50 PM Tomas Cohen Arazi 
> wrote:
>
> > The Koha community is proud to announce the release of Koha 23.05.00.
> >
> > Koha 23.05.00 is a major release, that comes with many new features.
> >
> > It includes 26 new features, 145 enhancements, 701 bugfixes.
> >
> > The full release notes are available here:
> > https://koha-community.org/koha-23-05-released/
> >
> > Debian packages should be available soon
> >
> > Best regards
> >
> > --
> > Tomás Cohen Arazi
> > Theke Solutions (http://theke.io)
> > ✆ +54 9351 3513384
> > GPG: B2F3C15F
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Koha 22.11.5v Fine amount did not Calculate

[MASTeR Library]

Katrin Fischer sir,

koha until 22.11.3 Fine calculation was calculated perfectly. But fine
doesn't calculate since upgrade Koha 22.11.5 and 22.11.6
My Koha failed to calculate fines despite setting all preferences
correctly. I get the following errors when running the ./fines.pl manually.

Can't locate Koha.pm in @INC (you may need to install the Koha module)
(@INC con tains: /etc/perl /usr/local/lib/perl/5.18.2
/usr/local/share/perl/5.18.2 /usr/li b/perl5 /usr/share/perl5
/usr/lib/perl/5.18 /usr/share/perl/5.18 /usr/local/lib/ site_perl .) at
/etc/perl/C4/Context.pm line 115.
BEGIN failed--compilation aborted at /etc/perl/C4/Context.pm line 115.
Compilation failed in require at ./fines.pl line 33.
BEGIN failed--compilation aborted at ./fines.pl line 33.

Please help and reply.

On Tue, 30 May 2023, 4:24 pm Katrin Fischer, 
wrote:

> Hi,
>
> all jobs should always be run as your koha user. You can use 'sudo
> koha-shell instance' to switch to that user and then try to run the job
> again.
>
> Some other things to make sure of:
>
>- system preference finesmode is set to "Calculate and charge"
>- today is not a holiday in the calendar of the library
>- the maxfine setting in circulation rules is > 0
>
> Hope this helps,
>
> Katrin
> On 30.05.23 10:32, MASTeR Library wrote:
>
> Katrin Fischer sir,
> I have Enclosed fines.pl error Screen link.
> https://i.ibb.co/K2Qzy83/fines-error.png
>
> On Tue, May 30, 2023 at 12:39 PM MASTeR Library <
> mamcet.librar...@gmail.com> wrote:
>
>> Katrin Fischer
>> Thank you for your reply,
>> I have run the fines.pl, following error?
>> Use of uninitialized value in string eq at
>> /usr/share/koha/lib/C4/Overdues.pm line 612.
>>
>> On Mon, May 29, 2023 at 5:44 PM Katrin Fischer 
>> wrote:
>>
>>> Hi,
>>>
>>> the error you posted looks like it's from the overdues.pl script. It
>>> complains about a missing letter ODUE. So you might want to check your
>>> notices and overdue notice triggers. But this won't affect fine
>>> calculation.
>>>
>>> Fines are calculated independently of the letters via the fines.pl
>>> cronjob.
>>>
>>> If you run fines.pl, is there any error?
>>>
>>> Fines not calculating can have a lot of reasons. Are you using a
>>> CurrencyFormat other than US?
>>>
>>> Hope this helps,
>>>
>>> Katrin
>>>
>>> On 20.05.23 15:25, MASTeR Library wrote:
>>> > Hi, friends using koha 22.11.5 version please reply to me with the
>>> above
>>> > question.
>>> >
>>> > On Sat, May 20, 2023 at 10:39 AM MASTeR Library <
>>> mamcet.librar...@gmail.com>
>>> > wrote:
>>> >
>>> >> Hi Koha Community Members,
>>> >> I just updated my Koha from 22.11.3 to 22.11.5 when I upgraded the
>>> server
>>> >> from Ubuntu MATE 22.11. patrons' account book overdrive fine is not
>>> >> calculated, only the date shown on the red colour fine amount is not
>>> >> displayed.
>>> >>
>>> >> I try to manually fine script commands. cd /etc/cron.daily/
>>> ./koha-common
>>> >>
>>> >> Get the following error/warning:
>>> >>
>>> >> No circulation ODUE letter transported by print at
>>> >> /usr/share/koha/lib/C4/Letters.pm line 585.
>>> >>
>>> >> Use of uninitialized value in string eq at
>>> >> /usr/share/koha/lib/C4/Overdues.pm line 612.
>>> >>
>>> >> I Enclosed the Error Screen message:
>>> https://i.ibb.co/W5DkRbk/Fine.png
>>> >>
>>> >> Can anybody tell me what this means? Is it a big problem?
>>> >>
>>> >>
>>> >> --
>>> >>   Thanking you..
>>> >>
>>> >> Librarian,
>>> >> MAMCET <http://mamcet.com/>
>>> >> Trichy-Chennai Trunk Road,
>>> >> Siruganur, Tiruchirappalli-621 105.
>>> >>
>>> >>
>>> ___
>>>
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>>
>> --
>>  Thanking you..
>>
>> Librarian,
>> MAMCET <http://mamcet.com/>
>> Trichy-Chennai Trunk Road,
>> Siruganur, Tiruchirappalli-621 105.
>>
>>
>
> --
>  Thanking you..
>
> Librarian,
> MAMCET <http://mamcet.com/>
> Trichy-Chennai Trunk Road,
> Siruganur, Tiruchirappalli-621 105.
>
>
___

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

Re: [Koha] Koha 22.11.5v Fine amount did not Calculate

[MASTeR Library]

Katrin Fischer sir,
I have Enclosed fines.pl error Screen link.
https://i.ibb.co/K2Qzy83/fines-error.png

On Tue, May 30, 2023 at 12:39 PM MASTeR Library 
wrote:

> Katrin Fischer
> Thank you for your reply,
> I have run the fines.pl, following error?
> Use of uninitialized value in string eq at
> /usr/share/koha/lib/C4/Overdues.pm line 612.
>
> On Mon, May 29, 2023 at 5:44 PM Katrin Fischer 
> wrote:
>
>> Hi,
>>
>> the error you posted looks like it's from the overdues.pl script. It
>> complains about a missing letter ODUE. So you might want to check your
>> notices and overdue notice triggers. But this won't affect fine
>> calculation.
>>
>> Fines are calculated independently of the letters via the fines.pl
>> cronjob.
>>
>> If you run fines.pl, is there any error?
>>
>> Fines not calculating can have a lot of reasons. Are you using a
>> CurrencyFormat other than US?
>>
>> Hope this helps,
>>
>> Katrin
>>
>> On 20.05.23 15:25, MASTeR Library wrote:
>> > Hi, friends using koha 22.11.5 version please reply to me with the above
>> > question.
>> >
>> > On Sat, May 20, 2023 at 10:39 AM MASTeR Library <
>> mamcet.librar...@gmail.com>
>> > wrote:
>> >
>> >> Hi Koha Community Members,
>> >> I just updated my Koha from 22.11.3 to 22.11.5 when I upgraded the
>> server
>> >> from Ubuntu MATE 22.11. patrons' account book overdrive fine is not
>> >> calculated, only the date shown on the red colour fine amount is not
>> >> displayed.
>> >>
>> >> I try to manually fine script commands. cd /etc/cron.daily/
>> ./koha-common
>> >>
>> >> Get the following error/warning:
>> >>
>> >> No circulation ODUE letter transported by print at
>> >> /usr/share/koha/lib/C4/Letters.pm line 585.
>> >>
>> >> Use of uninitialized value in string eq at
>> >> /usr/share/koha/lib/C4/Overdues.pm line 612.
>> >>
>> >> I Enclosed the Error Screen message: https://i.ibb.co/W5DkRbk/Fine.png
>> >>
>> >> Can anybody tell me what this means? Is it a big problem?
>> >>
>> >>
>> >> --
>> >>   Thanking you..
>> >>
>> >> Librarian,
>> >> MAMCET <http://mamcet.com/>
>> >> Trichy-Chennai Trunk Road,
>> >> Siruganur, Tiruchirappalli-621 105.
>> >>
>> >>
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
> --
>  Thanking you..
>
> Librarian,
> MAMCET <http://mamcet.com/>
> Trichy-Chennai Trunk Road,
> Siruganur, Tiruchirappalli-621 105.
>
>

-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] Koha 22.11.5v Fine amount did not Calculate

[MASTeR Library]

Katrin Fischer
Thank you for your reply,
I have run the fines.pl, following error?
Use of uninitialized value in string eq at
/usr/share/koha/lib/C4/Overdues.pm line 612.

On Mon, May 29, 2023 at 5:44 PM Katrin Fischer 
wrote:

> Hi,
>
> the error you posted looks like it's from the overdues.pl script. It
> complains about a missing letter ODUE. So you might want to check your
> notices and overdue notice triggers. But this won't affect fine
> calculation.
>
> Fines are calculated independently of the letters via the fines.pl
> cronjob.
>
> If you run fines.pl, is there any error?
>
> Fines not calculating can have a lot of reasons. Are you using a
> CurrencyFormat other than US?
>
> Hope this helps,
>
> Katrin
>
> On 20.05.23 15:25, MASTeR Library wrote:
> > Hi, friends using koha 22.11.5 version please reply to me with the above
> > question.
> >
> > On Sat, May 20, 2023 at 10:39 AM MASTeR Library <
> mamcet.librar...@gmail.com>
> > wrote:
> >
> >> Hi Koha Community Members,
> >> I just updated my Koha from 22.11.3 to 22.11.5 when I upgraded the
> server
> >> from Ubuntu MATE 22.11. patrons' account book overdrive fine is not
> >> calculated, only the date shown on the red colour fine amount is not
> >> displayed.
> >>
> >> I try to manually fine script commands. cd /etc/cron.daily/
> ./koha-common
> >>
> >> Get the following error/warning:
> >>
> >> No circulation ODUE letter transported by print at
> >> /usr/share/koha/lib/C4/Letters.pm line 585.
> >>
> >> Use of uninitialized value in string eq at
> >> /usr/share/koha/lib/C4/Overdues.pm line 612.
> >>
> >> I Enclosed the Error Screen message: https://i.ibb.co/W5DkRbk/Fine.png
> >>
> >> Can anybody tell me what this means? Is it a big problem?
> >>
> >>
> >> --
> >>   Thanking you..
> >>
> >> Librarian,
> >> MAMCET <http://mamcet.com/>
> >> Trichy-Chennai Trunk Road,
> >> Siruganur, Tiruchirappalli-621 105.
> >>
> >>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] Koha 22.11.5v Fine amount did not Calculate

[MASTeR Library]

Hi, friends using koha 22.11.5 version please reply to me with the above
question.

On Sat, May 20, 2023 at 10:39 AM MASTeR Library 
wrote:

> Hi Koha Community Members,
> I just updated my Koha from 22.11.3 to 22.11.5 when I upgraded the server
> from Ubuntu MATE 22.11. patrons' account book overdrive fine is not
> calculated, only the date shown on the red colour fine amount is not
> displayed.
>
> I try to manually fine script commands. cd /etc/cron.daily/ ./koha-common
>
> Get the following error/warning:
>
> No circulation ODUE letter transported by print at
> /usr/share/koha/lib/C4/Letters.pm line 585.
>
> Use of uninitialized value in string eq at
> /usr/share/koha/lib/C4/Overdues.pm line 612.
>
> I Enclosed the Error Screen message: https://i.ibb.co/W5DkRbk/Fine.png
>
> Can anybody tell me what this means? Is it a big problem?
>
>
> --
>  Thanking you..
>
> Librarian,
> MAMCET <http://mamcet.com/>
> Trichy-Chennai Trunk Road,
> Siruganur, Tiruchirappalli-621 105.
>
>

-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] Koha 22.11.5v Fine amount did not Calculate

[MASTeR Library]

Hi Koha Community Members,
I just updated my Koha from 22.11.3 to 22.11.5 when I upgraded the server
from Ubuntu MATE 22.11. patrons' account book overdrive fine is not
calculated, only the date shown on the red colour fine amount is not
displayed.

I try to manually fine script commands. cd /etc/cron.daily/ ./koha-common

Get the following error/warning:

No circulation ODUE letter transported by print at
/usr/share/koha/lib/C4/Letters.pm line 585.

Use of uninitialized value in string eq at
/usr/share/koha/lib/C4/Overdues.pm line 612.

I Enclosed the Error Screen message: https://i.ibb.co/W5DkRbk/Fine.png

Can anybody tell me what this means? Is it a big problem?


-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] Koha v 22.11.5 top quick search menu options not working.

[MASTeR Library]

Thank you so much Katrin Fischer sir,
I have removed the entries in the "IntranetUserJs" system preference. my
problems are solved and working well.

On Mon, May 8, 2023 at 12:14 PM MASTeR Library 
wrote:

> Thank you for your reply.
> Yes, there are entries in IntranetUserJs system preference.
>
> On Mon, May 8, 2023 at 12:01 PM Katrin Fischer 
> wrote:
>
>> Hi,
>>
>> are there any JavaScript errors on the page maybe? You should be able to
>> check if you press F12 and then check the Console tab in the developer
>> tools in your browser.
>>
>> Are there any entries in IntranetUserJs system preference?
>>
>> Hope this helps,
>>
>> Katrin
>>
>> On 06.05.23 07:18, MASTeR Library wrote:
>> > Hi Koha Community Members,
>> > If I click on the quick menu options in Koha 22.11.5, the options do not
>> > change, for example, check-in, renew, search patrons, search the
>> catalogue,
>> > etc., if I click the Check-in option, but the search box does not change
>> > the above options. I have enclosed the screenshot link kind your
>> reference.
>> > I waiting for your's valuable reply.
>> >
>> > Screenshot Link:
>> https://i.ibb.co/tQMkBJp/Screenshot-2023-05-06-09-59-46.png
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
> --
>  Thanking you..
>
> Librarian,
> MAMCET <http://mamcet.com/>
> Trichy-Chennai Trunk Road,
> Siruganur, Tiruchirappalli-621 105.
>
>

-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] Koha v 22.11.5 top quick search menu options not working.

[MASTeR Library]

Thank you for your reply.
Yes, there are entries in IntranetUserJs system preference.

On Mon, May 8, 2023 at 12:01 PM Katrin Fischer 
wrote:

> Hi,
>
> are there any JavaScript errors on the page maybe? You should be able to
> check if you press F12 and then check the Console tab in the developer
> tools in your browser.
>
> Are there any entries in IntranetUserJs system preference?
>
> Hope this helps,
>
> Katrin
>
> On 06.05.23 07:18, MASTeR Library wrote:
> > Hi Koha Community Members,
> > If I click on the quick menu options in Koha 22.11.5, the options do not
> > change, for example, check-in, renew, search patrons, search the
> catalogue,
> > etc., if I click the Check-in option, but the search box does not change
> > the above options. I have enclosed the screenshot link kind your
> reference.
> > I waiting for your's valuable reply.
> >
> > Screenshot Link:
> https://i.ibb.co/tQMkBJp/Screenshot-2023-05-06-09-59-46.png
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] Koha v 22.11.5 top quick search menu options not working.

[MASTeR Library]

Hi friends using koha 22.11.5 version please reply to me. The quick link in
koha is not working for the above links check-in, search patrons, and etc,
and the same thing koha about the option and item types "choose an icon"
options links are not working. I have enclosed the screenshot link kind
your reference. I waiting for your's valuable reply.

Check-in, Search Patrons, Search catalogu,  Screenshot Link:
https://i.ibb.co/tQMkBJp/Screenshot-2023-05-06-09-59-46.png
About Koha  Screenshot Link:
https://i.ibb.co/rvkqkD1/Koha-About-link-nit-work.gif

Thank you.


On Sat, May 6, 2023 at 10:48 AM MASTeR Library 
wrote:

> Hi Koha Community Members,
> If I click on the quick menu options in Koha 22.11.5, the options do not
> change, for example, check-in, renew, search patrons, search the catalogue,
> etc., if I click the Check-in option, but the search box does not change
> the above options. I have enclosed the screenshot link kind your reference.
> I waiting for your's valuable reply.
>
> Screenshot Link:
> https://i.ibb.co/tQMkBJp/Screenshot-2023-05-06-09-59-46.png
> --
>  Thanking you.
>
> Librarian,
> MAMCET <http://mamcet.com/>
> Trichy-Chennai Trunk Road,
> Siruganur, Tiruchirappalli-621 105.
>
>

-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] Koha v 22.11.5 top quick search menu options not working.

[MASTeR Library]

Hi Koha Community Members,
If I click on the quick menu options in Koha 22.11.5, the options do not
change, for example, check-in, renew, search patrons, search the catalogue,
etc., if I click the Check-in option, but the search box does not change
the above options. I have enclosed the screenshot link kind your reference.
I waiting for your's valuable reply.

Screenshot Link: https://i.ibb.co/tQMkBJp/Screenshot-2023-05-06-09-59-46.png
-- 
 Thanking you.

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] How To Add OCLC in Koha Z39.50 Server.

[MASTeR Library]

Dear Michael Kuhn Sir,
Dear, I changed the settings as you said but it says book search result not
found. I have attached the modified Z30.50 screenshot link below please
reply.

Z30.50 Screenshot link: https://i.ibb.co/vwrx0rZ/Z39-50-Server.png
Book Search Result: https://i.ibb.co/KFtGJCG/Capture-result.png



On Fri, May 5, 2023 at 4:31 PM Mark Alexander  wrote:

> I'm not an expert on this, but it appears that zcat.oclc.org requires
> you to provide your OCLC user name and password, as mentioned in the
> message mentioned previously:
>
> https://www.mail-archive.com/koha@lists.katipo.co.nz/msg25554.html
>
> Here is what happened when I tried to connect using yaz-client without
> username/password:
>
> % yaz-client zcat.oclc.org:210/OLUCWorldCat
> Connecting...OK.
> Sent initrequest.
> Connection rejected by v3 target.
> UserInformationfield:
> {
>   OID: 1 2 840 10003 10 1000 17 1
>   {
> ANY (len=29)
>   }
> }
> OCLC UserInformation:
> {
>   failReason TRUE
>   text 'Invalid Autho/password'
> }
> Options: search present delSet triggerResourceCtrl scan sort
> extendedServices namedResultSets
> Elapsed: 0.193017
>
> --
> Fundamentally, there may be no basis for anything. --Ashleigh Brilliant
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] How To Add OCLC in Koha Z39.50 Server.

[MASTeR Library]

I Successfully Configuration to Z39.50 but the catalogue title search
result  "Connection failed to zcat.oclc.org"

Z39.50 Server Configuration Details Link Enclosed Please check and reply to
me.

https://i.ibb.co/CWxwZ56/Screenshot-2023-05-05-16-06-01.png

On Fri, May 5, 2023 at 3:54 PM Michael Kuhn  wrote:

> Hi MAMCET Library
>
> You wrote:
>
>  >   How to Add OCLC  WORLD Catalogue in Koha Z39.50 Server.
>  > http://classify.oclc.org/classify2/
>
> The following post by Heather Siemoin may help you:
>
> https://www.mail-archive.com/koha@lists.katipo.co.nz/msg25554.html
>
> Also the following page by OCLC:
>
>
> https://help.oclc.org/Metadata_Services/Z3950_Cataloging/Get_started/Configuration_guide_for_OCLC_Z39.50_Cataloging
>
> Best wishes: Michael Kuhn
> --
> 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
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] How To Add OCLC in Koha Z39.50 Server.

[MASTeR Library]

Hi Koha Community Members,
 How to Add OCLC  WORLD Catalogue in Koha Z39.50 Server.
http://classify.oclc.org/classify2/

-- 
 Thanking you.

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] How to get sql report on patron additional attributes.

[MASTeR Library]

Dear Team,
how to get the sql report on Patron additional attributes for example
Department, Student Roll number, blood group and etc?

Sample SQL Code.
SELECT ROW_NUMBER() OVER (ORDER BY LPAD(borrowers.cardnumber,100,' ') ASC)
 AS 'S.No',
borrowers.cardnumber AS "Lib Membership
No",borrowers.borrowernumber,borrowers.surname AS "
Name",borrowers.title,borrowers.sex,borrowers.dateofbirth AS " Date of
Birth",borrowers.contactname AS "Guardian Name", borrowers.relationship,
borrowers.phone,borrowers.email,borrowers.address,borrowers.categorycode,borrowers.dateenrolled,borrowers.dateexpiry,borrowers.userid
FROM borrowers WHERE branchcode=<> AND
categorycode LIKE <>
-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] Koha 22.05 OPAC Autocomplete Search Feature not working.

[MASTeR Library]

Dear Team,
The autocomplete search function in the Koha OPAC search box is not working
in Wikipedia Java Code, The Koha 22.05 latest version, please provide any
suggestions.
Reference.
https://libpowertech.blogspot.com/2021/03/how-to-adding-to-opac-autocomplete.html
https://en.wikipedia.org/w/api.php
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25532#c15
-- 
 Thanking you.

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] Dispaly of OPAC Holdings on Mobile Devices

[Rosewood Farm Library]

Dear all,

We are using Koha 22.05.06.

When displaying OPAC holdings on a mobile device, they are in column (or
table) format (like showing on a desktop computer).  In earlier versions,
they were not displayed in such a format.

How can I change this to a non-column (or table) format, so information are
more readable?

Kind regards,

Iming Chan

*Rosewood Farm Library*


*ROSEWOOD FARM GROUP PTY. LTD.*
ACN 621 676 711 | ATF Bullas Chan Trust (ABN 95 696 171 924)
20 Research Road (PO Box 363), Lara, Victoria, 3212, Australia
(03) 5275 2939 | https://rosewoodfarm.com.au <http://rosewoodfarm.com.au>

Cat Boarding | Secured Storage | Canine Fitness
___

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

Re: [Koha] Modify Patron Transaction Invoices and Fee Receipts

[MASTeR Library]

Account payment invoice
https://libpowertech.blogspot.com/2022/03/how-to-create-email-receipt-template.html?m=1

On Wed, 1 Mar 2023, 11:26 am Ms. Naveen Ali,  wrote:

> Hi Caroline,
>
> Thanks a lot for the information.
>
> I was looking for them in Tools->Notices and slips but was not able to map
> the receipts and invoices.
>
> The link you mentioned is great.
>
> I tried using Help on the Koha interface. It took me to this link
>
>
> https://koha-community.org/manual//22.05/en/html/tools.html#existing-notices-and-slips
>
> where i did not find ACCOUNT_DEBIT and CREDIT you mentioned.
>
> I believe the manual needs to be updated.
>
> Thanks a lot for your help and kind support.
>
> With best regards,
>
> Naveen Ali
>
> ITM-JE (EAKL)
> Inst Representative for
> HEC Digital Library Resources.
> NEDUET, Karachi.
>
>
> - Original Message -
> From: "Caroline Cyr La Rose" 
> To: koha@lists.katipo.co.nz
> Sent: Tuesday, 28 February, 2023 7:20:50 PM
> Subject: Re: [Koha] Modify Patron Transaction Invoices and Fee Receipts
>
> Hi Naveen,
>
> Transaction invoice = ACCOUNT_DEBIT
>
> Transaction receipt = ACCOUNT_CREDIT
>
> Summary is not customizable...
> (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11340)
>
> Slip = ISSUESLIP
>
> Quick slip = ISSUEQSLIP
>
> Overdues = OVERDUES_SLIP
>
> Checkin slip = CHECKINSLIP
>
> Can I ask where you checked? I know most of them are described in the
> manual
>
> https://koha-community.org/manual/latest/en/html/tools.html#existing-notices-and-slips
> but it might be missing in crucial places where people would check
> first... So I'd like to add it there.
>
> Thanks!
>
> Caroline
>
>
> On 2023-02-27 23:33, Ms. Naveen Ali wrote:
> > Dear members,
> >
> > I'd like to modify the Patron Transaction Invoices and Fee Receipts.
> > In fact all the print options available on the Patron Screen (Summary,
> Slip, Quick Slip, Overdues, Check In Slip)
> > I can't identify them in the Notices and Slips Tool
> > Please provide support.
> >
> > With best regards,
> >
> > Naveen Ali
> >
> > ITM-JE (EAKL)
> > Inst Representative for
> > HEC Digital Library Resources.
> > NEDUET, Karachi.
> >
> >
> > ___
> >
> > Koha mailing listhttp://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> --
> Logo inLibro <https://inLibro.com>  Caroline Cyr-La-Rose
> Bibliothécaire | Responsable de produit
>
> T 833-INLIBRO (465-4276) , poste 221
> C caroline.cyr-la-r...@inlibro.com
>
> www.inLibro.com <https://inLibro.com>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Upgrade from - 17.11.02

[MASTeR Library]

Koha Upgrade the old stable version.
https://libpowertech.blogspot.com/2019/11/how-to-upgrade-koha.html
https://wiki.koha-community.org/wiki/Koha_on_Debian

On Mon, Feb 13, 2023 at 1:21 PM Laxmi Lal Menaria 
wrote:

> Good Morning All!
>
> We have installed koha - 17.11.02, and would like to upgrade to the latest
> version. Please let me know the steps I need to use.
>
> Is there any help link where I can see the steps? Please help me.
>
> Thanks in advance.
> --
>
> Thanks,
> Laxmilal Menaria | +91 982 955 3793 | http://cloud-computing.solutions/
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] Fine calculation on over dues books

[MASTeR Library]

Visit the Link:
https://libpowertech.blogspot.com/2019/08/koha-not-calculating-in-fine-amount.html

On Wed, Jan 18, 2023 at 2:57 AM Katrin Fischer 
wrote:

> Hi,
>
> please make sure that your fines.pl cronjob is set up correctly and
> running. If you don't have server access, you can activate the
> CronjobLog system preference. Then you can use the log viewer to verify
> that the script did run overnight. You could also try running it
> manually with -v to get more information and to check if the fines then
> get calculated.
>
> Hope this helps,
>
> Katrin
>
>
> On 17.01.23 08:24, Banesh Hiremath wrote:
> > Hi,
> > I'm using the KOHA 21.05.02.000 version.
> > In this version, the fine does not appear on overdue items, but it
> appears
> > after the book is returned.
> > When students access the OPAC, the fine does not appear.
> >
> > Please assist us in resolving the above issue.
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] KOHA not getting install old or new version

[MASTeR Library]

koha install latest  stable version
https://libpowertech.blogspot.com/2021/03/how-to-install-koha-on-ubuntu-mate-2004.html

On Tue, Nov 8, 2022 at 12:43 PM Laxmi Lal Menaria 
wrote:

> Look these basic cleanup steps too here
>
> http://cloud-computing.solutions/how-to-install-koha-a-library-software-on-ubuntu/
>
>
> On Tue, Nov 8, 2022 at 12:37 PM Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> wrote:
>
> > Hello,
> >
> > > and followed all the process
> > What did you follow exactly?
> > If you are trying to install Koha on debian you should follow this
> > documentation: https://wiki.koha-community.org/wiki/Koha_on_Debian
> >
> > Regards,
> > Jonathan
> >
> > Le mar. 8 nov. 2022 à 01:28, shailendra arora
> >  a écrit :
> > >
> > > I have formatted the pc and installed ubuntu  and followed all the
> > process
> > > but koha is not getting installed, not even creating a koha directory.
> > >
> > > I somehow installed koha on vm on laptop after lots of trying but now I
> > am
> > > trying to install a fully formatted system PC but it is not happening.
> > >
> > > some perl file showing  issue but perl is installed and updated too.
> > >
> > > Thank's & Regards
> > >
> > > Shailendra Arora
> > >  *( 3D Artist ,Modeler, 3D Animator , Designer,Instructor, PhotoGrapher
> > )*
> > >
> > > e-mail:-  *shailendraaror...@gmail.com *
> > > Mobile :- *9887503892*
> > > ___
> > >
> > > Koha mailing list  http://koha-community.org
> > > Koha@lists.katipo.co.nz
> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
> --
>
> Thanks,
> Laxmilal Menaria | +91 982 955 3793 | http://cloud-computing.solutions/
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] OPAC CUSTOMIZATION ON KOHA 21.11.12

[MASTeR Library]

OPAC customisation visit
https://youtu.be/SPVIW3y86J4

On Tue, 25 Oct 2022, 2:17 am Katrin Fischer, 
wrote:

> Hi Murphy,
>
> in 21.11 the news and HTML/OPAC customizations are different tools. Go
> to Tools > HTML customizations.
>
> Hope this helps,
>
> Katrin
>
> On 24.10.22 16:28, Igbudu Tersoo wrote:
> > Hello,
> > I just installed koha 21.11.12 running on ubuntu 20.04. i want to
> customize
> > the koha OPAC. on the news section, I can't see opacheader to position my
> > header. i can only see Librarian and OPAC interfaces, Librarian
> Interface,
> > OPAC and slip.
> >
> > How do i position my header now?
> >
> > Murphy Igbudu
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Error in creating instance

[MASTeR Library]

MSQL Password Error (Access Denied for User 'root'@'localhost' (using
password: YES) - No Privileges?)
https://libpowertech.blogspot.com/2022/09/msql-password-error-access-denied-for.html?m=1

On Thu, 22 Sep 2022, 10:43 am Mumanyi, Bravismore,  wrote:

> Hi Kumar
>
> I advise you re-check MySQL access credentials.
>
> Those parameters are wrong. You are trying to access MySQL with username
> root without a password.
>
> #mysql -u root -p
>
> If you set a password, then set the correct password in KOHA config file.
>
> There are also ways to reset MySQL password, in case you forgot.
>
> Hope this helps
>
> Regards
> 
> From: Koha  on behalf of Rishav Kumar
> Gond 
> Sent: 22 September 2022 07:00
> To: koha@lists.katipo.co.nz 
> Subject: [Koha] Error in creating instance
>
> Hi all,
>
> I have created an instance 'library' but soon after creating it when i am
> applying the command
>  "sudo koha-create --create-db library1"
> It is showing
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
>
> Kindly help
>
> Warm regards
> Rishav
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> CAUTION -EXTERNAL SENDER: Please be careful when opening links and
> attachments. UNAM Directorate: Information & Communication Technology
> Services (DICTS)
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

[Koha] Upgrade

[KARE- LIBRARY]

Hi,
I am using the version 19.05 and would like to upgrade to the higher
versions. May I know the step by step procedures for the upgrade?
with thanks,
D.Gnanasekaran

-- 
With thanks,
Dr. D. Gnanasekaran
University Librarian
Kalasalingam Academy of Research and Education
(Deemed to be University)
Krishnankoil - 626 126
Virudhunagar District
Tamil Nadu
Ph: 9710906899
___

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

[Koha] Catalog Error 500

[MASTeR Library]

*Good Morning All**started getting an error when selecting a title. If
I search the catalog** and then select the title link I get the
following error:
**An Error has Occurred!*

* Error 500*

*Error attaching this link. *https://i.ibb.co/PhLwVm7/Capture.png

 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] Koha 21.11.10 version, New Patrons email notice sending problem.

[MASTeR Library]

Good morning, I'm looking for tips to solve a New patron email notice
sending problem. I noticed that Koha 21.11.10 version, New Patrons email
notice only does not send, But book check-in, check-out, book renewal
notification etc are working properly.
-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] to import bulk book details - please advise

[MASTeR Library]

How to Book Bibliography Data Convert Excel to MARC format
https://www.youtube.com/watch?v=92bdWN054R0

On Tue, Jul 12, 2022 at 7:13 PM Bruns, Anke  wrote:

> Hi Edward,
>
> could you please explain your request a bit more?
>
> Do you explicitly want to import 5000 title records as duplicates of 5000
> existing records, so as a result there are 1 records? Or did you mean
> import the same data with deduplication in the process, so that the 5000
> existing records are overwritten?
>
> What exactly would you like to know about Excel import?
>
> Best regards,
> Anke
>
>
> > -Ursprüngliche Nachricht-
> > Von: Koha  Im Auftrag von edward durai
> > Gesendet: Dienstag, 12. Juli 2022 13:27
> > An: koha@lists.katipo.co.nz
> > Betreff: [Koha] to import bulk book details - please advise
> >
> > Hi Koha Team,
> > We Organization has 5000 books. I just wanted to import duplicate entry
> for
> > 5000 books using import excel.
> >
> > is it possible? so that we can edit and update whenever we have time.
> >
> > is there any other possibility to enter 5000 books quickly?
> >
> > thanks,
> > edward
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] Koha Sql Report Help

[MASTeR Library]

Fine Paid for Library Patrons (Koha SQL Reports Queries) Koha v 18 and
above
https://libpowertech.blogspot.com/2019/05/fine-paid-for-library-patrons-sql.html?m=1

On Sun, 26 Jun 2022, 7:36 am Shafrizan Affendi,  wrote:

> Hi,
>
> Recently I upgraded my Koha from ver 18 to 22.05. Some of my sql report are
> not working anymore. For example to show a fine collection by staff id.
> Here is my previous sql.
>
> SELECT
>  @rownum:=@rownum+1 No,
>   student.borrowernumber,
>   student.cardnumber AS Student_ID,
>   student.surname AS Student_Name,
>   format(db.amount,2) As Amount,
>   accounttype,
>   date(db.timestamp) as Date,
>   time(db.timestamp) As Time,
>   db.manager_id AS Staff_ID,
>   staff.surname  AS Staff_Name,
>   db.note As Nota
> FROM
>   (SELECT @rownum:=0) r,
>   action_logs a, accountlines db
> INNER JOIN borrowers student ON db.borrowernumber =
> student.borrowernumber
> INNER JOIN borrowers staff ON db.manager_id =
> staff.borrowernumber
> WHERE
>date(db.timestamp)  BETWEEN <> AND
> <>
>AND module='fines' AND accounttype='pay'
> GROUP BY
> db.timestamp
> ORDER BY
>   db.timestamp
>
> I did read about the changes regarding table accountype but still not quite
> understand. Anyone can help me to correct this sql?
>
> Really appreciate your help
>
> Thanks in advance
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

[Koha] koha gmail sending problem (Google no longer supports the use of third-party apps or devices )

[MASTeR Library]

Hello Team,
Due to the below reason koha gmail getting problem (Problem in sending mail
kindly rectify the problem as soon as possible, If it is getting late to
solve the problem as soon as possible. Aiter some other solutions for koha
sending mail )
Less secure apps & your Google Account

To help keep your account secure, from May 30, 2022, Google no longer
supports the use of third-party apps or devices which ask you to sign in to
your Google Account using only your username and password.

Important: This deadline does not apply to Google Workspace or Google Cloud
Identity customers. The enforcement date for these customers will be
announced on the Workspace blog at a later date.


-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] How to upload Bulk local cover images of books.

[MASTeR Library]

Hi
Is it possible to  bulk upload  local cover images of books in koha. or
any plugins tool available bulk local book cover image upload.

-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] How to Create Top 10 Circulation book with ISBN report

[MASTeR Library]

Thanks a lot.

On Tue, 26 Apr 2022, 9:09 pm Josh Barnes, 
wrote:

> Hello!
>
> You're on the right track with adding the bi.isbn. The extra part you
> missed is to tell your query which table the isbn is coming from. You can
> do that by using another left join to add the biblioitems table. Try
> something like this:
>
> SELECT count(s.datetime) AS circs, b.title, b.author, i.ccode, bi.isbn
> FROM statistics s
> JOIN items i ON (i.itemnumber=s.itemnumber)
> LEFT JOIN biblio b ON (b.biblionumber=i.biblionumber)
> LEFT JOIN biblioitems bi on (i.biblionumber=bi.biblionumber)
> WHERE DATE(s.datetime) > DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH) AND
> DATE(s.datetime)<=CURRENT_DATE() AND s.itemnumber IS NOT NULL AND s.type IN
> ('issue','renew')
> GROUP BY b.biblionumber
> ORDER BY circs DESC
> LIMIT 10
>
> Cheers!
> Josh Barnes
> Portneuf Library
>
> On Tue, Apr 26, 2022 at 3:07 AM MASTeR Library 
> wrote:
>
>> Hi
>> Is it possible to Create  Top 10 Circulation book  with ISBN  number in
>> SQL
>> report,
>> it is Available for Top Circulation book  report:
>>
>> https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Top_10_Circulating_Books
>> , but ISBN number missing.
>>
>> How to Add the ISBN Number in the report. i try to "bi.isbn" but not
>> working
>>
>> SELECT count(s.datetime) AS circs, b.title, b.author,
>>i.ccode FROM statistics sJOIN items i ON
>> (i.itemnumber=s.itemnumber) LEFT JOIN biblio b ON
>> (b.biblionumber=i.biblionumber) WHERE DATE(s.datetime) >
>> DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH)
>>   AND DATE(s.datetime)<=CURRENT_DATE() AND
>>   s.itemnumber IS NOT NULL AND s.type IN ('issue','renew')GROUP BY
>> b.biblionumber ORDER BY circs DESC LIMIT 10
>>
>>
>>
>> --
>>  Thanking you..
>>
>> Librarian,
>> MAMCET <http://mamcet.com/>
>> Trichy-Chennai Trunk Road,
>> Siruganur, Tiruchirappalli-621 105.
>> ___
>>
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
___

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

[Koha] How to Create Top 10 Circulation book with ISBN report

[MASTeR Library]

Hi
Is it possible to Create  Top 10 Circulation book  with ISBN  number in SQL
report,
it is Available for Top Circulation book  report:
https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Top_10_Circulating_Books
, but ISBN number missing.

How to Add the ISBN Number in the report. i try to "bi.isbn" but not working

SELECT count(s.datetime) AS circs, b.title, b.author,
   i.ccode FROM statistics sJOIN items i ON
(i.itemnumber=s.itemnumber) LEFT JOIN biblio b ON
(b.biblionumber=i.biblionumber) WHERE DATE(s.datetime) >
DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH)
  AND DATE(s.datetime)<=CURRENT_DATE() AND
  s.itemnumber IS NOT NULL AND s.type IN ('issue','renew')GROUP BY
b.biblionumber ORDER BY circs DESC LIMIT 10



-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] Koha online bill copy format

[MASTeR Library]

How to Create an Email Receipt Template for Payment in Koha (Online Bill
Copy)
https://youtu.be/ARFcSJ_l76I
https://libpowertech.blogspot.com/2022/03/how-to-create-email-receipt-template.html?m=1
-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] Koha OPAC Login to gmail ID (API)

[MASTeR Library]

Dear all koha fans.

Anybody know how we can use email address, add password as opac userid and
p/w in koha ( eg- opac userid-( ***@gmail.com p/w
gmail account pw).

-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] Importing encrypted patron passwords

[MASTeR Library]

https://libpowertech.blogspot.com/2022/02/installing-multiple-instances-of-koha.html

On Sun, 6 Feb 2022, 7:26 am Tomas Cohen Arazi,  wrote:

> You will create a new instance, say 'name' like this:
>
> $ koha-create --create-db name
>
> You will then load your backup on the empty db that was created:
>
> $ koha-mysql name < backup.sql
>
> About step 3, you just need to try. It should work, and we can help with
> the data errors.
>
> Looking forward to your comments.
>
>
>
> El sáb., 5 feb. 2022 22:13, Mark Alexander  escribió:
>
> > Excerpts from Alvaro Cornejo's message of 2022-02-05 19:40:08 -0500:
> > > I'll however suggest you do the backup load/upgrade before configuring
> > the
> > > server since some of the data uses DB indexes to be identified.
> >
> > Let me see if I understand this.  Is this the order of steps you're
> > recommending?
> >
> > 0. install Debian 10 on new server
> > 1. apt-get install koha-common
> > 2. copy database from the old server (mysqldump args >dump.sql)
> >and load it on new server (mysql args  > 3. run updatedatabase.pl
> > 4. run Koha's web installer
> >
> > I worry about step 3 because I don't understand how updatedatabase.pl
> > knows how to access the old database.  In the 3.16 installation I'm
> > working on, the database is called "koha", but in the latest Koha, the
> > database is normally called "koha_INSTANCE".  Is this a problem, and if
> so,
> > what do I do about?
> >
> > --
> > I work very hard.  Please don't expect me
> > to think as well. --Ashleigh Brilliant
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

[Koha] Koha Staff Login Issue Please help me.

[MASTeR Library]

I am encountered with error " Autolocation is switched on and you are
logging in with an IP address that doesn't match your library". If any body
knows the trouble shoot please help me.
Enclosed Errr: https://i.ibb.co/YyDBnrB/koha-loing.png

1. Login into your staff client using a superlibrarian account.

2. Go to Home -> Koha Administration -> Global system preferences

3. Search for the system preference "AutoLocation"  and set it to
"Yes/No" (I changed this option.)

4. Save the change and logout and then login back in.  face the
problem anymore. Please hope this helps.

-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] Changing status of item

[TS Library]

Hi everyone

When I change the lost or damaged status of an item the changes are not
saved. Can anyone suggest why this is?

*Jo Atkinson*

*Senior Librarian*

Geoffrey Hodson Library

Theosophical Society in New Zealand Inc

18 Belvedere Street, Epsom, Auckland



*e:* *libr...@theosophy.org.nz *
*p: 09 523 1797*
*m: 021 250 1675*
*w:* *theosophy.nz <http://theosophy.nz/>*
___

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

[Koha] How to bulk change in item type

[MASTeR Library]

Hi
How to change bulk item types in koha. for example item type for Book and
change to Book bank  item.

-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

Re: [Koha] KOHA INTERGRATION

[MASTeR Library]

KOHA ALL SQL REPORTS Visit: https://youtu.be/scuXS7wVFdM

On Mon, 1 Nov 2021, 10:36 pm Lennon Mazonde,  wrote:

> Hi Steve,
>
> Koha has two fields where you can store an item's value - 952$g
> (purchase price) and 952$v (replacement price). You can create an SQL
> report in the reports module to total the value of these fields, which
> would give you the total value of your collection (assuming that you
> added the required field data to all of your items). Here's an SQL
> statement you could try - you can modify it better suit your needs (I
> recommend using the Guided Reports module unless you're comfortable with
> writing SQL statements):
>
> SELECT sum(items.replacementprice),sum(items.price),
>
> items.itemnumber,items.barcode,items.itemcallnumber,biblioitems.isbn,biblio.title,items.replacementprice,items.price
>
>
> FROM items LEFT JOIN biblioitems on
> (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN
> biblio on (biblioitems.biblionumber=biblio.biblionumber)
>
> GROUP BY items.replacementprice,items.price
>
> ORDER BY biblio.title asc
>
> Now, the more difficult question is what to do with your board? I don't
> have any magic answers for that but perhaps you could start by creating
> a list of pros/cons for/against Koha or integrated school management
> system (it would be helpful to know the name). It may even turn out that
> the board is right  - I have my doubts, in my experience bundled systems
> tend to be Jacks of all trades and masters of none, but it's better if
> you do the research.
>
> I hope this helps and all the best with your board!
>
> Lennon Mazonde
> www.kohasupport.com
> len...@kohasupport.com
> WhatsApp @ (+1) 717.489.0195
>
> On 11/1/21 5:27 PM, Steve Austin wrote:
> > Hi team..
> >
> > I am having a challenge. Am in a school library using KOHA but the
> > directors want to have an integrated school management system including a
> > library module. They are specifically concerned with being able to know
> the
> > total value of the resources in the library.
> >
> > Is there a way I can defend myself and still have KOHA give them the
> > opportunity to view to total value of library collection integrated into
> > their school managememt system?
> >
> > Or are there ways of generating reports giving the total value of our
> > library collection?
> >
> > Regards
> > Steve.
> > ___
> >
> > Koha mailing listhttp://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Unable to login in Web Installer 21.5

[MASTeR Library]

Koha installation
https://libpowertech.blogspot.com/2021/03/how-to-install-koha-on-ubuntu-mate-2004.html?m=1

On Tue, 14 Sep 2021, 12:52 pm Sebastian Krieg, <
sebastian.kr...@tuz-eisenach.de> wrote:

> Hello Sanjay,
>
> there are two ways:
>
> 1. Please login in a shell at your koha server, change to the superuser
> 'root' and execute 'koha-passwd [libraryname]' where [libraryname] is the
> given instance name during the installation. You will get the database
> password for the instance user. Note, that the command will make a 'clear'
> with next click.
>
> 2. Look into the file '/etc/koha/sites/[libraryname]/koha-conf.xml'. You
> will get the informations about the instance user in line 270 and the
> password in line 271.
>
> These are the login informations.
>
> Greets
>
> Sebastian
>
>
>
> ---
> mailto: sebastian.kr...@tuz-eisenach.de
>
> 13. September 2021 19:06, "Sanjay Uchcharia" 
> schrieb:
>
> > Sir,
> >
> > I've installed Koha on Ubuntu 20.04 but I'm unable to login in Web
> > Installer 21.5 with the username & password.
> > ___
> >
> > Koha mailing list http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] [EXTERNAL] install koha

[MASTeR Library]

Visit the link Koha Full tutorial.  basic koha installation and koha
customization etc..
https://www.youtube.com/c/LibPowerTech

On Wed, Sep 8, 2021 at 8:48 PM King, Fred  wrote:

> This won't tell you everything you need to know, but I did a video that
> takes you from the Ubuntu command line through a complete Koha system,
> ready to go, in half an hour. See https://youtu.be/plzFqqy1iPs. I'm
> working on part 2, where I set up the library, item types, OPAC home page,
> etc., which I hope to have ready in time for the koha-US conference,
> starting on September 21st. Free registration if you attend online! See
> https://koha-us.org/.
>
> As for koha-sites.conf, I'd recommend setting intraport to 8080 and
> opacport to 80. Then you can get to your staff interface as
> 123.123.123.123:8080 (assuming your IP address is 123.123.123.123) and
> the catalog as 123.123.123.123. You don't need an actual domain name for
> Koha, though it does make things easier.
>
> NOTE: Some of you might be rather alarmed at my barebones approach to
> setting up Koha. No, my directions don't produce something pretty looking.
> My intended audience is libraries that don't have a lot of money to hire
> someone to design and set up their ILS. You'll end up with something that
> works, but look like something designed in somebody's basement.
>
> And if you find any errors in my video, please tell me!
>
> Fred King, MSLS, AHIP
> Medical Librarian, MedStar Washington Hospital Center
> fred.k...@medstar.net
> 202-877-6670
> ORCID -0001-5266-0279
> MedStar Authors Catalog: http://medstarauthors.org
>
> All right, but apart from sanitation, medicine, education, wine, public
> order, irrigation, roads, the fresh water system and public health, what
> have the Romans ever done for us?
> --John Cleese
>
> -Original Message-
> From: Koha  On Behalf Of stefan
> Sent: Wednesday, September 08, 2021 10:55 AM
> To: koha 
> Subject: [EXTERNAL] [Koha] install koha
>
>
>
> **ATTENTION: This email originated from outside the MedStar Health network.
>  ** DO NOT CLICK links or attachments unless you recognize the sender and
> know the content is safe.
>
>
>
> Hi,
>
> I'm from Romania, I'm a librarian and I want to install koha on the
> library computer. I tried using the instructions at
> https://urldefense.com/v3/__https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages*Install_Ubuntu__;Iw!!D7IIWT94AA!r8Im6_gLUsp-6SdXI2zDtDwSvLDj2no5iuW9d1zDfvYQB-zL1TCtaBcbg4EROE1Dlw$
> but without success.
>
>   On the computer i have ubuntu 20.04.3.
>
> I want to install koha and then get in the system all the books in the
> library and all the students that come to the library. I want to get koha
> up and running individually on this local computer.
>
> I don't have a system admin at the school.
>
> The computer is connected to the internet.
>
> Can somebody explain to me how i configure /etc/koha/koha-sites.conf?
> Also, what is the difference between web install and IP install. What
> would be best form me? I don't know about domain names and INTRAPORT AND
> OPACPORT...
>
> ___
>
> Koha mailing list
> https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94AA!r8Im6_gLUsp-6SdXI2zDtDwSvLDj2no5iuW9d1zDfvYQB-zL1TCtaBcbg4FEEZLGOg$
> Koha@lists.katipo.co.nz
> Unsubscribe:
> https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koha__;!!D7IIWT94AA!r8Im6_gLUsp-6SdXI2zDtDwSvLDj2no5iuW9d1zDfvYQB-zL1TCtaBcbg4FV8B4UYg$
>
> --
> MedStar Health is a not-for-profit, integrated healthcare delivery system,
> the largest in Maryland and the Washington, D.C., region. Nationally
> recognized for clinical quality in heart, orthopedics, cancer and GI.
>
> IMPORTANT: This e-mail (including any attachments) may contain information
> that is private, confidential, or protected by attorney-client or other
> privilege. If you received this e-mail in error, please delete it from your
> system without copying it and notify sender by reply e-mail, so that our
> records can be corrected... Thank you.
>
> Help conserve valuable resources - only print this email if necessary.
>
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] barcode woes

[library]

use Modern::Perl;
use Koha::Biblios;
use Koha::Items;

my $biblios = Koha::Biblios->search;
my $branchcode='ppa';
while ( my $biblio=$biblios->next){

Koha::Item->new(
{   

biblionumber => $biblio->biblionumber,
homebranch   => $branchcode,
holdingbranch =>$branchcode,
barcode =>barcode_.$biblio->biblionumber,
itype   =>$biblio->biblioitem->itemtype,
}
)->store;
}

___

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

[Koha] Barcode's continued part three

[library]

When I tried to run barcode.pl


use Modern::Perl;
use Koha::Biblios;
use Koha::Items;

my $biblios = Koha::Biblios->search;
my $branchcode='ppa';
while (my $biblio=$biblios->next) {

Koha::Item->new(
  {
biblionumber  =>$biblio->biblionumber,
homebranch=>$branchcode,
holdingbranch =>$branchcode,
barcode =>'barcode_'.$biblio->biblionumber,
itype =>$biblio->biblioitem->itemtype,
  }
)->store;

}





This is the error messages that I got:

No method biblioitem! at barcode.pl line 8

Can't call method "itemtype" on an undefined value at barcode.pl line 10

Any help will be nice.


___

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

Re: [Koha] Barcode's continued part two

[library]

I removed those """ at the beginning and end then got this message:

Cant locate koha/Biblios.pm in @INC

Quoting Ere Maijala :

If you have those """ at the beginning and end of the file, remove  
them. So the first line would be:


use Modern::Perl;

--Ere

libr...@princeofpeaceabbey.org kirjoitti 19.2.2021 klo 15.05:


Trying to run this:

"""

use Modern::Perl;
use Koha::Biblios;
use Koha::Items;

my $biblios = Koha::Biblios->search;
my $branchcode='ppa';
while ( my $biblio=$biblios->next) {


    Koha::Item->new(
  {
    biblionumber => $biblio->biblionumber,
    homebranch   => $branchcode,
    holdingbranch =>$branchcode,
    barcode    =>"barcode_".$biblio->biblionumber,
    itype =>$biblio->biblioitem->itemtype,
  }
    )->store;
}

"""

But get this instead:

String found where operator expected at barcode.pl line 22, near “””
(Might be a runaway multi-line “” string starting on line 1)
    (Missing semicolon on previous line?)
syntax error at barcode.pl line 22, near “””
execution of barcode.pl aborted due to compilation errors.

As you can tell I do not know Perl. So any help will be nice.

Raphael


___

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


--
Ere Maijala
Kansalliskirjasto / The National Library of Finland
___

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




___

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

Re: [Koha] Barcode's continued part two

[library]

Removed the quotes but still got the same error message.

how to you get koha-shell ppa to work?


Quoting Jonathan Druart :


Don't include the quotes, it was to delimit the code.

Le ven. 19 févr. 2021 à 14:05,  a écrit :



Trying to run this:

"""

use Modern::Perl;
use Koha::Biblios;
use Koha::Items;

my $biblios = Koha::Biblios->search;
my $branchcode='ppa';
while ( my $biblio=$biblios->next) {


Koha::Item->new(
  {
biblionumber => $biblio->biblionumber,
homebranch   => $branchcode,
holdingbranch =>$branchcode,
barcode =>"barcode_".$biblio->biblionumber,
itype =>$biblio->biblioitem->itemtype,
  }
)->store;
}

"""

But get this instead:

String found where operator expected at barcode.pl line 22, near “””
(Might be a runaway multi-line “” string starting on line 1)
(Missing semicolon on previous line?)
syntax error at barcode.pl line 22, near “””
execution of barcode.pl aborted due to compilation errors.

As you can tell I do not know Perl. So any help will be nice.

Raphael


___

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




___

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

[Koha] Barcode's continued part two

[library]

Trying to run this:

"""

use Modern::Perl;
use Koha::Biblios;
use Koha::Items;

my $biblios = Koha::Biblios->search;
my $branchcode='ppa';
while ( my $biblio=$biblios->next) {


Koha::Item->new(
  {
biblionumber => $biblio->biblionumber,
homebranch   => $branchcode,
holdingbranch =>$branchcode,
barcode =>"barcode_".$biblio->biblionumber,
itype =>$biblio->biblioitem->itemtype,
  }
)->store;
}

"""

But get this instead:

String found where operator expected at barcode.pl line 22, near “””
(Might be a runaway multi-line “” string starting on line 1)
(Missing semicolon on previous line?)
syntax error at barcode.pl line 22, near “””
execution of barcode.pl aborted due to compilation errors.

As you can tell I do not know Perl. So any help will be nice.

Raphael


___

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

Re: [Koha] Barcode's continued

[library]

Thanks for seeing my typos. Now it is giving me this message:

String found where operator expected at barcode.pl line 22, near “””
(Might be a runaaway multi-line “” string starting on line 1)
(Missing semicolon on previous line?)
syntax error at barcode.pl line 22, near “””
execution of barcode.pl aborted due to compilation errors.


Quoting Mark Alexander :


Excerpts from library's message of 2021-02-18 10:22:59 -0600:

I tried the perl that Jonathan sent but the Internet did not give good
advise on how to run the perl. Here is what I typed:


When I compare Jonathon's script with yours, I see some typos in yours:

holingbranch =>$branchcode,

This should be holdingbranch.

barccode=>"barcode_'.$biblio->biblionumber,

The single quote ' should be a double quote ".

)-store;

There should be a > after the -, i.e. ->

To run this script, first use this command to set up the proper environment:

   koha-shell INSTANCE

where INSTANCE is your Koha instance name (it appears to be ppa in  
your case).


Then you can run the script using this:

  perl scriptname.pl

--
To any truly impartial person, it would be obvious
that I'm always right. --Ashleigh Brilliant
___

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




___

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

[Koha] Barcode's continued

[library]

I tried the perl that Jonathan sent but the Internet did not give good  
advise on how to run the perl. Here is what I typed:


"""

use Modern::Perl;
use Koha::Biblios;
use Koha::Items;

my $biblios = Koha::Biblios->search;
my $branchcode='ppa';
while ( my $biblio=$biblios->next) {


Koha::Item->new(
{

biblionumber => $biblio->biblionumber,
homebranch   => $branchcode,
holingbranch =>$branchcode,
barccode
=>"barcode_'.$biblio->biblionumber,
itype   =>$biblio->biblioitem->itemtype,
}
)-store;
}
"""

My test machine has a mind of its own. On Monday because it was a  
Federal holiday it did not want to work. It is a 32 bit machine with  
ubuntu 14.04 and Koha 16.05.05.
When I tried to run barodes.pl all it did was make Koha think it was  
just installed. I am doing something wrong but have no idea what it is.


Anything that works on that machine will work on my 64 bit machine  
with Ubuntu 20.04.1 with Koha 20.11.02.


Br Raphael



___

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

Re: [Koha] Br Raphael

[library]

Ian,

The answer to you questions is true. I just need to have the right  
syntax for mysql to add books to the items. I have the means of making  
the whole collection get barcodes within a few minutes. The only  
problem is that the barcode thing only does those items that are  
connected to a record.


I just need to make all the items connect to a record.

Br Raphael


Quoting Ian Bays :


Hello

Am I right in guessing that the majority of the books (titles) only  
have a single copy?  Also am I right in thinking most of the actual  
books (items) have no computer-readable numbers such as barcodes?


If both the above are true and if you have access to the  
command-line to run some SQL, then we could come up with a simple  
SQL command to add a single item for each title.  These items would  
have no barcodes to identify them.  They would have to have a branch  
and an item type (and usually a location but that is optional).


If many titles have multiple items or the items do have identifying  
numbers then is this information held in a spreadsheet somewhere?   
If so there may be better ways to get the items created.


Can I ask why you want to add the items?  Is it so that the books  
can be issued to borrowers?  If so I think they may need an  
identifying number.


Can you say what version of Koha you have as that might determine  
what tools are available for some of the other options.


One is never too old to learn!  I'm sure you will get help from the  
community.


Best regards.
Ian

On 14/02/2021 14:07, libr...@princeofpeaceabbey.org wrote:


I am Br Raphael of Prince of Peace Abbey. I have been learning Koha  
for the past year. I have become the librarian of the Abbey along  
with a few other jobs. The library has about 40K volumes. I also  
have four other libraries to merge into the main.


I have to thank all who have helped in the past. Now my biggest  
problem is that the librarian before me, God rest his soul, did not  
attach Items to those 40K books. Beside doing it the hard way. That  
is one by one. I hope there is a faster way to do that. I am not a  
programmer so I need step by step instructions. I think I am doing  
good with me being 74 years of age. I might be the oldest librarian  
using Koha.




___

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




--
Ian Bays
Director, PTFS Europe Limited
Content Management and Library Solutions

___

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




___

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

[Koha] Br Raphael

[library]

I am Br Raphael of Prince of Peace Abbey. I have been learning Koha  
for the past year. I have become the librarian of the Abbey along with  
a few other jobs. The library has about 40K volumes. I also have four  
other libraries to merge into the main.


I have to thank all who have helped in the past. Now my biggest  
problem is that the librarian before me, God rest his soul, did not  
attach Items to those 40K books. Beside doing it the hard way. That is  
one by one. I hope there is a faster way to do that. I am not a  
programmer so I need step by step instructions. I think I am doing  
good with me being 74 years of age. I might be the oldest librarian  
using Koha.




___

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

[Koha] Coverflow not working koha 20.05

[MAMCET Library]

Hi
I have did all the setup and everything seems to be ok also but coverflow
does not load on the OPAC page of Koha, Please suggest. I am using ubuntu
MATE 20.4 LTS and Koha 20.05.
___

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

[Koha] SQL Report Coding need.

[MAMCET Library]

Dear all good morning
 Please send the SQL Patrons Fine payment date wise report coding.
Koha version 20.5

-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] Cataloging book data entry not save for koha 20.05

[MAMCET Library]

Good Morning
After updating to 20.05 this error appeared when cataloging trying to save
a record.

Can't open /var/log/koha/mamcet/z3950-error.log (Permission denied) at
/usr/share/perl5/Log/Log4perl/Appender/File.pm line 151.


-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

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

[Koha] Multiple Instances of Koha

[MAMCET Library]

Dear all
I installed koha 20.10 and ubuntu Mate 20.4 successfully.
I created the Multiple Instances of Koha following error please help me.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
___

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

[Koha] How to Installing Multiple Instances of Koha

[MAMCET Library]

Hi,
I have install koha 18.11.4 live DVD successfully installed. I want
to create three database in one KOHA sever because we have three college
librarys in same campus. Is it possible to do that?

The Live DVD almost Infield one database, " Database name 'library' port 80
OPAC and 8080 staff client.
How to create More than tow database.

Kindly tell & do needful.
___

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

[Koha] Birthday Wishes email to patron any option from koha?

[MAMCET Library]

Dear all
Nowadays clients send Birthday Wishes through SMS/email alerts from Banks or
other organizations on their Birthday.
So how can we make this possible to send birthday wishes from Koha?
___

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

[Koha] How to connect Koha 19.11 with OverDrive ?

[Sultan Qaboos Cultural Center Library]

Dear all,

- Is there a way to connect the Koha patrons' accounts with OverDrive
accounts ?
- What protocol does Koha use to link the patrons' accounts ?
- What is the easiest way to know the port number used for this process ?

Best regards,
Walid



-- 
*Sultan Qaboos Cultural Center Library*
1100 16th St, NW
Washington, DC 20036
libr...@sqcc.org
202-677-3967, x104
___

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

[Koha] Please remove us from your list

[Rasuwa Community Library]

Please remove us from your list

Rasuwa Community Library
Jibajibe, Kalika-5, Rasuwa, Nepal

Sent from Mail for Windows 10

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

[Koha] Spine label printing

[TS Library]

I have recently purchased a Dymo LabelWriter 450 Turbo to print spine
labels individually rather than in batches.

I have set SpineLabelAutoPrint to 'do' and set SpineLabelFormat to

This was following advice I received from a list member.

When I click on the link to print spine label next to an item the print
dialogue box comes up and displays the Dymo label writer at the top but
nothing is displayed in the print preview – just the little blue dots going
round in a circle – and if I click on print nothing happens. If I change
the printer name to Epson which is my main printer the label is displayed
in the print preview and I can print it.
Can anyone suggest what I am doing wrong?

Jo Atkinson
Theosophical Society in New Zealand
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Software error: Can't use an undefined value as an ARRAY reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081

[Library Online]

*Hi all,
*>>* I need some urgent help on this following error:
*>>* Software error: Can't use an undefined value as an ARRAY
reference at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 2081*>>*
I was trying to look for a vendor in Acquisitions, and the above error
*>* showed up.  Please help.
*>>


* Thanks!Dinehs Kumar*






*Thanks*
 * Dinesh Kumar*
Mobile Numebr-9616146991
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Printing individual spine labels

[TSNZ Library]

I am new to this list and have recently taken over management of a small
library using Koha. I would like to be able to print individual spine labels
rather than batch printing. I read on the Bywater site that Dymo LabelWriter
450 twin Turbo will do this and is compatible with Koha. Can anyone confirm
this or suggest an alternative? 

 

Jo Atkinson

Senior Librarian

Theosophical Society in New Zealand Inc

18 Belvedere Street, Epsom, Auckland

 

  

 

 

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

Re: [Koha] Can't connect to SIP2 and port 6001 closed

[library]

Hi all,
It's fixed and running successfully. I have misspelled one word in 
institution. Our team have checked and fixed it.

The services is upped and running.

Thanks all.





On 2019-09-10 19:41, Karam Qubsi wrote:

Hello CHE PAKRUL,


4 - root@UKOHA:/etc/koha/sites/ulibrary# koha-shell ulibrary
ulibrary-koha@UKOHA:/etc/koha/sites/ulibrary$ perl
/usr/share/koha/lib/C4/SIP/SIPServer.pm
/etc/koha/sites/ulibrary/SIPconfig.xml
mismatched tag at line 144, column 6, byte 5675 at
/usr/lib/x86_64-linux-gnu/perl5/5.20/XML/Parser.pm line 187.
ulibrary-koha@UKOHA:/etc/koha/sites/ulibrary$


Can you double check your /etc/koha/sites/ulibrary/SIPconfig.xml file.
I think you may have syntax error inside it.

You may share it here if you wish, but make sure to remove any
credentials inside it.

Regards.

On Tue, Sep 10, 2019 at 11:30 AM  wrote:


Hi all,
I need your help . I've tried to connect the self check to Koha
Server.
But the SIP2 services can't be upped and the 6001 is closed.

From log:

1 - root@UKOHA:/var/log/koha/ulibrary# ps -ef | grep SIP
umplibr+ 769 1 0 Sep06 ? 00:00:16 daemon --name=ulibrary-koha-sip
--errlog=/var/log/koha/ulibrary/sip-error.log
--stdout=/var/log/koha/ulibrary/sip.log
--output=/var/log/koha/ulibrary/sip-output.log --verbose=1 --respawn

--delay=30 --pidfiles=/var/run/koha/ulibrary
--user=ulibrary-koha.ulibrary-koha -- perl
/usr/share/koha/lib/C4/SIP/SIPServer.pm
/etc/koha/sites/ulibrary/SIPconfig.xml
root 92687 92586 0 19:39 pts/3 00:00:00 grep SIP

2 - root@UKOHA:/var/log/koha/ulibrary# nmap -p 6001 110.119.120.118

Starting Nmap 6.47 ( http://nmap.org ) at 2019-09-09 19:39 PDT
Nmap scan report for 110.119.120.118
Host is up (0.69s latency).
PORT STATE SERVICE
6001/tcp closed X11:1

Nmap done: 1 IP address (1 host up) scanned in 1.15 seconds

3 - SIP-error.log
20190905 21:19:21 ulibrary-koha-sip: client (pid 2907) exited with
255
status
20190905 21:19:22 ulibrary-koha-sip: client (pid 2908) exited with
255
status
20190905 21:19:22 ulibrary-koha-sip: client (pid 2909) exited with
255
status
20190905 21:19:23 ulibrary-koha-sip: client (pid 2910) exited with
255
status
20190905 21:19:24 ulibrary-koha-sip: client (pid 2911) exited with
255
status
20190905 21:19:24 ulibrary-koha-sip: terminating too quickly,
waiting 30
secon
ds

4 - root@UKOHA:/etc/koha/sites/ulibrary# koha-shell ulibrary
ulibrary-koha@UKOHA:/etc/koha/sites/ulibrary$ perl
/usr/share/koha/lib/C4/SIP/SIPServer.pm
/etc/koha/sites/ulibrary/SIPconfig.xml

mismatched tag at line 144, column 6, byte 5675 at
/usr/lib/x86_64-linux-gnu/perl5/5.20/XML/Parser.pm line 187.
ulibrary-koha@UKOHA:/etc/koha/sites/ulibrary$

Thanks.

Best Regards,

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


--

_Karam Qubsi_

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

[Koha] Can't connect to SIP2 and port 6001 closed

[library]

Hi all,
I need your help . I've tried to connect the self check to Koha Server. 
But the SIP2 services can't be upped and the 6001 is closed.


From log:

1 - root@UKOHA:/var/log/koha/ulibrary# ps -ef | grep SIP
umplibr+ 769 1 0 Sep06 ? 00:00:16 daemon --name=ulibrary-koha-sip 
--errlog=/var/log/koha/ulibrary/sip-error.log 
--stdout=/var/log/koha/ulibrary/sip.log 
--output=/var/log/koha/ulibrary/sip-output.log --verbose=1 --respawn 
--delay=30 --pidfiles=/var/run/koha/ulibrary 
--user=ulibrary-koha.ulibrary-koha -- perl 
/usr/share/koha/lib/C4/SIP/SIPServer.pm 
/etc/koha/sites/ulibrary/SIPconfig.xml

root 92687 92586 0 19:39 pts/3 00:00:00 grep SIP


2 - root@UKOHA:/var/log/koha/ulibrary# nmap -p 6001 110.119.120.118

Starting Nmap 6.47 ( http://nmap.org ) at 2019-09-09 19:39 PDT
Nmap scan report for 110.119.120.118
Host is up (0.69s latency).
PORT STATE SERVICE
6001/tcp closed X11:1

Nmap done: 1 IP address (1 host up) scanned in 1.15 seconds


3 - SIP-error.log
20190905 21:19:21 ulibrary-koha-sip: client (pid 2907) exited with 255 
status
20190905 21:19:22 ulibrary-koha-sip: client (pid 2908) exited with 255 
status
20190905 21:19:22 ulibrary-koha-sip: client (pid 2909) exited with 255 
status
20190905 21:19:23 ulibrary-koha-sip: client (pid 2910) exited with 255 
status
20190905 21:19:24 ulibrary-koha-sip: client (pid 2911) exited with 255 
status
20190905 21:19:24 ulibrary-koha-sip: terminating too quickly, waiting 30 
secon

ds

4 - root@UKOHA:/etc/koha/sites/ulibrary# koha-shell ulibrary
ulibrary-koha@UKOHA:/etc/koha/sites/ulibrary$ perl 
/usr/share/koha/lib/C4/SIP/SIPServer.pm 
/etc/koha/sites/ulibrary/SIPconfig.xml


mismatched tag at line 144, column 6, byte 5675 at 
/usr/lib/x86_64-linux-gnu/perl5/5.20/XML/Parser.pm line 187.

ulibrary-koha@UKOHA:/etc/koha/sites/ulibrary$

Thanks.

Best Regards,

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

[Koha] Issue with email configuration_not able to send email to patron

[Library biet]

Hi,
This is Shashikiran M working as Asst Librarian, I installed KOHA live DVD
on my new system and then it was updated to KOHA 19.05 at that time i'm
able to send email to patron, after that I took backup from my old system
and restored into the new system (PC) after restoring the database into the
new system I'm not able to send email to Patron. Can you please help me out.

Thanks and regards
Shashikiran M
Asst Librarian
BIET
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha upgrade from 3.20.00.000 (2015) to any latest and stable version

[Sultan Qaboos Cultural Center Library]

Thank you for your quick response.

Another thing, what are the Koha 18.11 new features comparing with the Koha
3.20.00 ?

Best,
Walid

On Mon, Aug 26, 2019 at 10:23 AM Tomas Cohen Arazi 
wrote:

> You should be able to upgrade directly into the latest 18.11 version.
> I suggest you follow the instructions in the Wiki [1].
>
> I suggest you do it on a clean server, and take notes on possible errors
> you might get in the process. Deal with those, and then proceed to a final
> migration.
>
> Kind regards
>
> El lun., 26 ago. 2019 a las 11:10, Sultan Qaboos Cultural Center Library (<
> libr...@sqcc.org>) escribió:
>
>> Hello,
>>
>> Our library is planning to upgrade Koha from the version 3.20.00.000 to
>> any
>> Koha latest and stable version.
>>
>> - What Koha version do you recommend us ?
>>
>> - Could you please give us a complete tutorial, system requirements, and
>> the things we have to do (backup ?, etc,) before starting the upgrade ?
>>
>> - Is it possible to upgrade directly from 3.20 (2015) to the latest
>> version
>> ? or we have to upgrade to lower versions before?
>>
>> Given that almost all Koha modules are up-to-date.
>>
>> Best regards,
>> Walid
>>
>> --
>> *Sultan Qaboos Cultural Center Library*
>> 1100 16th St, NW
>> Washington, DC 20036
>> libr...@sqcc.org
>> 202-677-3967, x104
>> ___
>> 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 (http://theke.io)
> ✆ +54 9351 3513384
> GPG: B2F3C15F
>


-- 
*Sultan Qaboos Cultural Center Library*
1100 16th St, NW
Washington, DC 20036
libr...@sqcc.org
202-677-3967, x104
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha upgrade from 3.20.00.000 (2015) to any latest and stable version

[Sultan Qaboos Cultural Center Library]

Hello,

Our library is planning to upgrade Koha from the version 3.20.00.000 to any
Koha latest and stable version.

- What Koha version do you recommend us ?

- Could you please give us a complete tutorial, system requirements, and
the things we have to do (backup ?, etc,) before starting the upgrade ?

- Is it possible to upgrade directly from 3.20 (2015) to the latest version
? or we have to upgrade to lower versions before?

Given that almost all Koha modules are up-to-date.

Best regards,
Walid

-- 
*Sultan Qaboos Cultural Center Library*
1100 16th St, NW
Washington, DC 20036
libr...@sqcc.org
202-677-3967, x104
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha upgrade from 3.2 to 19.05

[Sultan Qaboos Cultural Center Library]

UP !

On Thu, Aug 22, 2019 at 9:59 AM Sultan Qaboos Cultural Center Library <
libr...@sqcc.org> wrote:

> Dear Joel,
>
> Thank you for your quick answer ! Do you have any tutorials/links to
> suggest me to make the upgrade successful ?
>
> Best,
> Walid
>
> On Thu, Aug 22, 2019 at 9:52 AM Coehoorn, Joel  wrote:
>
>> 3.2 is **very** old now... going back to at least 2012 if not further.
>>
>> Koha is designed to be updated in place, in smaller increments at a time.
>> You will find this larger jump exceedingly difficult. It will almost
>> certainly break things for you, but going back that far it's impossible for
>> me to say what.
>>
>> If you're using the debian packages, you **might** be able to slow this
>> down by carefully controlling the debian apt repository targets, such that
>> you only do a version or two at a time. Then you could check through things
>> at a each jump and take a backup before moving to the next. That will take
>> much longer, but it should at least be safer and a little more reliable. If
>> that's even still possible.
>>
>> To avoid this situation in the future, it's much better to upgrade **at
>> least** once every other year.
>>
>> Joel Coehoorn
>> Director of Information Technology
>> 402.363.5603
>> *jcoeho...@york.edu *
>>
>> *Please contact helpd...@york.edu  for technical
>> assistance.*
>>
>>
>> The mission of York College is to transform lives through
>> Christ-centered education and to equip students for lifelong service to
>> God, family, and society
>>
>>
>> On Thu, Aug 22, 2019 at 8:46 AM Sultan Qaboos Cultural Center Library <
>> libr...@sqcc.org> wrote:
>>
>>> Hello,
>>>
>>> Our library is planning to upgrade Koha from the version 3.2 to 19.05
>>> (latest).
>>>
>>> Could you please give us a complete tutorial, system requirements, and
>>> the
>>> things we have to do (backup ?, etc,) before starting the upgrade.
>>>
>>> Is it possible to upgrade directly from 3.2 to 19.05 ? or we have to
>>> upgrade to lower versions before?
>>>
>>> Best regards,
>>> Walid
>>>
>>>
>>> --
>>> *Sultan Qaboos Cultural Center Library*
>>> 1100 16th St, NW
>>> Washington, DC 20036
>>> libr...@sqcc.org
>>> 202-677-3967, x104
>>> ___
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>
> --
> *Sultan Qaboos Cultural Center Library*
> 1100 16th St, NW
> Washington, DC 20036
> libr...@sqcc.org
> 202-677-3967, x104
>


-- 
*Sultan Qaboos Cultural Center Library*
1100 16th St, NW
Washington, DC 20036
libr...@sqcc.org
202-677-3967, x104
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha upgrade from 3.2 to 19.05

[Sultan Qaboos Cultural Center Library]

Dear Joel,

Thank you for your quick answer ! Do you have any tutorials/links to
suggest me to make the upgrade successful ?

Best,
Walid

On Thu, Aug 22, 2019 at 9:52 AM Coehoorn, Joel  wrote:

> 3.2 is **very** old now... going back to at least 2012 if not further.
>
> Koha is designed to be updated in place, in smaller increments at a time.
> You will find this larger jump exceedingly difficult. It will almost
> certainly break things for you, but going back that far it's impossible for
> me to say what.
>
> If you're using the debian packages, you **might** be able to slow this
> down by carefully controlling the debian apt repository targets, such that
> you only do a version or two at a time. Then you could check through things
> at a each jump and take a backup before moving to the next. That will take
> much longer, but it should at least be safer and a little more reliable. If
> that's even still possible.
>
> To avoid this situation in the future, it's much better to upgrade **at
> least** once every other year.
>
> Joel Coehoorn
> Director of Information Technology
> 402.363.5603
> *jcoeho...@york.edu *
>
> *Please contact helpd...@york.edu  for technical
> assistance.*
>
>
> The mission of York College is to transform lives through
> Christ-centered education and to equip students for lifelong service to
> God, family, and society
>
>
> On Thu, Aug 22, 2019 at 8:46 AM Sultan Qaboos Cultural Center Library <
> libr...@sqcc.org> wrote:
>
>> Hello,
>>
>> Our library is planning to upgrade Koha from the version 3.2 to 19.05
>> (latest).
>>
>> Could you please give us a complete tutorial, system requirements, and the
>> things we have to do (backup ?, etc,) before starting the upgrade.
>>
>> Is it possible to upgrade directly from 3.2 to 19.05 ? or we have to
>> upgrade to lower versions before?
>>
>> Best regards,
>> Walid
>>
>>
>> --
>> *Sultan Qaboos Cultural Center Library*
>> 1100 16th St, NW
>> Washington, DC 20036
>> libr...@sqcc.org
>> 202-677-3967, x104
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>

-- 
*Sultan Qaboos Cultural Center Library*
1100 16th St, NW
Washington, DC 20036
libr...@sqcc.org
202-677-3967, x104
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha upgrade from 3.2 to 19.05

[Sultan Qaboos Cultural Center Library]

Version 3.20

On Thu, Aug 22, 2019 at 9:53 AM Indranil Das Gupta 
wrote:

> Hi,
>
> On Thu 22 Aug, 2019, 7:16 PM Sultan Qaboos Cultural Center Library, <
> libr...@sqcc.org> wrote:
>
>> Hello,
>>
>> Our library is planning to upgrade Koha from the version 3.2 to 19.05
>> (latest).
>>
>
> Just a quick query : 3.02 or 3.20 ?
>
> Cheers
> Indranil Das Gupta
> L2C2 Technologies
>


-- 
*Sultan Qaboos Cultural Center Library*
1100 16th St, NW
Washington, DC 20036
libr...@sqcc.org
202-677-3967, x104
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha upgrade from 3.2 to 19.05

[Sultan Qaboos Cultural Center Library]

Hello,

Our library is planning to upgrade Koha from the version 3.2 to 19.05
(latest).

Could you please give us a complete tutorial, system requirements, and the
things we have to do (backup ?, etc,) before starting the upgrade.

Is it possible to upgrade directly from 3.2 to 19.05 ? or we have to
upgrade to lower versions before?

Best regards,
Walid


-- 
*Sultan Qaboos Cultural Center Library*
1100 16th St, NW
Washington, DC 20036
libr...@sqcc.org
202-677-3967, x104
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha tutorials

[MAMCET Library]

Dear sir / Madam
  Hope you enjoy the koha tutorials video. Subscribe this
channel to receive more similar content. You will learn for software
knowledge and implement in your library.

https://www.youtube.com/channel/UC3wql6wxktbjRCdPMo9SXoA?sub_confirmation=1

1.How to Add a Patron category and create a Super Librarian :
https://youtu.be/y59GQavOpLc



2.How to Create New Library in Koha Simple Method:
https://youtu.be/c04zIKLWJLk



3.How to Create koha SQL Report and 15 Library Important Customize Reports:
https://youtu.be/scuXS7wVFdM



4.How to Add an Item types in koha Library: https://youtu.be/OmVYVZfq5p0



5.How to Setting Circulation and Fine Rules in Koha:
https://youtu.be/GClcoI7L5EY



6.How to Create and Edit MARC Framework in koha and Download Customized
MARC Frame: https://youtu.be/zEy7_o7F4hM



7.How to Koha Patrons Unwanted Field Delete in staff client and Koha OPAC
client: https://youtu.be/J5iP6GhkorY



8.How to Bulk Patrons photos Upload in koha: https://youtu.be/PhhwnO7aLpo



9.How to Bulk Patron Details Upload in Koha: https://youtu.be/NJvCrM677XY



10.How to Koha Login Page Designing and Change Logo:
https://youtu.be/Fqk901kjd6Y



11.How to add Koha Item Type Image: https://youtu.be/tIPUiD9UY-k



12.How to Koha Auto Backup in Dropbox: https://youtu.be/5Q0ZFofBfg8



13.How to Enable Koha Plugins: https://youtu.be/9LJb7X0NXGo



14.How to Configure of AskALibrarian Plugin in Koha (Chatting with
Librarian): https://youtu.be/8d2cAOz0Q5Y



15.How to koha OPAC New Arrivals Books Display (Koha CoverFlow plugin):
https://youtu.be/rB36I8lG9uk



16.How to Enable Barcode or Accession Number Search in OPAC:
https://youtu.be/HD8wHCgby8Y



17.How to Enable Intranet Catalog Search Pulldown menu in Koha Staff
Client: https://youtu.be/Ht8YKvBvt5Q



18.How to Create Collection or Department wise Books in koha and Generate
Collections wise Report: https://youtu.be/07B4oNmRtQQ



19. Bulk Import Quotes and Beautify Quotes of the day in Koha OPAC:
https://youtu.be/ksdqcgrXJzs



20. Adding a Link to the Last Patron Accessed in the koha Staff Client:
https://youtu.be/Fu0KipAbyr4



21. How to install Koha In Out Management System:
https://youtu.be/Jge3ps7T4Sw
-- 
 Thanking you..

Koha Power Tech
<https://www.youtube.com/channel/UC3wql6wxktbjRCdPMo9SXoA?sub_confirmation=1>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] How to koha OPAC New Arrivals Books Display (Koha CoverFlow plugin)

[MAMCET Library]

https://youtu.be/rB36I8lG9uk

https://youtu.be/9LJb7X0NXGo
-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] How to Koha coverflow feature enable 18.11.3

[MAMCET Library]

Dear Koha Community

How to Koha coverflow feature which will display in OPAC the new arrivals
book cover page.
Step by step procedure to create koha-plugin-coverflow.
I am using koha version: 18.11.03 coverflow feature is not supported.

-- 
 Thanking you..

Adhisivam Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] How to find a great number of visitors in the library on mysql report.

[MAMCET Library]

Dear sir/Madam
 How to find a great number of visitors in the
library. How to prepare the mysql Report. please help me.

-- 
 Thanking you..

Librarian,
MAMCET <http://mamcet.com/>
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] KOHA IN OUT Management

[MAMCET Library]

Hi
In out management system is web based application koha Team members any
thing develop.

-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Removal from list

[RCDC Library]

Please remove Raffles College Library form the mailing list as we are
closing down

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

[Koha] Free KOHA OPAC Mobile App from LIS Academy

[PDIT Library]

Dear Professionals,

Happy to share with you all,   One of our innovative product - Koha
Opac Mobile App has been released from LIS  Academy. It is totally
free of cost. Any library using KOHA can use this App to reach their
users remotely through their Android Mobiles.

This Android based Mobile App is an exclusive mobile app designed and
developed for the libraries using KOHA LMS for automating their
library system. This app acts as a plug-in and fetches the content
from existing KOHA LMS and user can use OPAC login credentials to log
in through the mobile app.

It is freely available on google play store to download. Presently 12
institutions and 800+ patrons using app..

https://play.google.com/store/apps/details?id=com.lisacademy.org.kohaopac

Demo credintials of KOHA OPAC:

College Code: LISA
Card Number: Librarian
Password: Librarian

How to register Libraries to KOHA OPAC:

College Code: admin
Card Number: library
Password: librarian

Reach us for any assistance lisacademyorg at gmail.com
<http://ncsi.iisc.ernet.in/mailman/listinfo/lis-forum>

Thanks & Regards,
Dr. P. V. Konnur
President - LIS Academy, Bangalore
Former LIS Professor,
Fulbright Scholar - (UIUC, USA)
Chairman - State Level Book Selection Committee, Karnataka
Adviser - VTU Consortium,
Visvesvaraya Technological University, Belagavi - 590 018,
Member of Syndicate, KUVEMPU University, Shivamogga,
Karnataka, India
Mobile : 09449679737
E-Mail : pvkonnur at gmail.com
<http://ncsi.iisc.ernet.in/mailman/listinfo/lis-forum>
Website: www.lisacademy.org


-- 

*LIBRARIAN*

*Proudhadevaraya Institute of Technology*

*TB Dam, **HOSAPETE-583 225*

*Ballari District, **Karnataka, India.*


*Web http://pdit.ac.in <http://pdit.ac.in/>*

*Email**librar...@pdit.ac.in *

*Phone: 08394 259505*

*Phone +91-8394 259505 *
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] notices overhaul RFC - updated

[Library]

Hi all

Thanks to those who have responded to this RFC via Bugzilla. My original email 
to the main list got blocked because of my email signature, and I've made some 
updates to the RFC following initial feedback, so I'm sending this through 
again. Please check it out here: 
https://wiki.koha-community.org/wiki/Notices_Overhaul_RFC

Provide feedback and suggestions by Monday 9 July (AEST) either in the Bugzilla 
bug, or via email to libr...@brimbank.vic.gov.au

Don't send it direct to me, because today is my last day at Brimbank :-)

cheers


Hugh Rundle
Library Systems & Resource Coordinator
Community Learning & Participation

Brimbank City Council
Brimbank Community and Civic Centre - 301 Hampshire Road, Sunshine

T +61 3 9249 4170
M +61 437 734 108
F +61 3 9249 4351

www.brimbank.vic.gov.au

This e-mail and any files transmitted with it are confidential and are intended 
solely for the use of the individual or entity to whom it is addressed. If you 
are not the intended recipient or the person responsible for delivering the 
e-mail to the intended recipient, please be advised that you have received this 
email in error and that any use, dissemination, forwarding, printing, or 
copying of this e-mail and any file attachments is strictly prohibited. If you 
have received this e-mail in error, please immediately notify Brimbank City 
Council on +61 3 9249 4000 or by reply e-mail to the sender. Please delete the 
original transmission and its contents.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] 8. Introducing In - Out Management System based on KOHA ILS (Omkar Kakeru)

[PDIT Library]

Thank you for a fantastic work. It is a good look at a great program.

Thank you for developing this interface. I sincerely appreciate your
work. This feature is an addon advantage for Koha users This is very
much needed by Indian academic Libraries as NAAC and MBA needs these
reports. I installed this in my library. When patron enters into the
library by swiping the card, Patron photo and details displayed. This
gate register interface is helpful to get statistics of library
visitors. Earlier one developed by Sri A J Thomson was also good but
it doesn’t contain exit system. This plug-in contains both entry and
exit. Reports are also very good and easy to generate. This will help
to library staff in collecting statistics of how much time students
spend in library

Again, thank you Omkar Kakeru so much for your help. I greatly appreciate
the assistance provided by Omkar Kakeru during installation.

Best Regards,



> Message: 8
> Date: Wed, 28 Feb 2018 20:58:30 +0530
> From: Omkar Kakeru <omkar.kak...@gmail.com>
> To: koha@lists.katipo.co.nz
> Subject: [Koha] Introducing In - Out Management System based on KOHA
> ILS
> Message-ID:
> 

[Koha] doubt regarding serial numbering pattern

[pariyaram central library]

Hello

I am a fresher in koha and now carrying out the serial section and I have a
doubt regarding the serial planning. Now I am doing a journal LANCET which
is a weekly having 51 issues and the vol changes with 25th issue but the
issue no is continuous up to 51. my problem is the issue no has got 5
digits and in the prediction pattern while giving 10064 in BEGINS WITH
column OF ISSUE NO and while going to the test prediction pattern, it will
begin with 10064 but the next issue will be numbered 1 next issue will be
numbered 2 and so on. The actual pattern in which the journal arrives is
mentioned below.ie

1.vol no 389 iss no 10064
2.vol no 389 iss no 10065
3.vol no 389 iss no 10066
4.vol no 389 iss no 10067
5.vol no 389 iss no 10068
.
.
.
.
.
25.vol no 390 iss no 10089
.
.
.
.
51.vol no 390 iss no 10115

KINDLY HELP




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

[Koha] Early morning KOHA problem

[Jezzine Library]

Greetings

My small library has been happily using KOHA for about 6 months now, but
one problem has persisted.  First ting is the morning the contents of the
catalogue are 'undiscoverable'.  They remain so until our IT Guru resets
something in the back of the program (which takes about 5 seconds, & one
day, he says, even *I* will be able to do it.)  I would much rather
have a solution!

Even items I catalogue before the reset are undiscoverable once I hit save,
even though they turn up quite happily once the reset is done.

Our IT Guru is professionally trained and has worked internationally for
recognised organisations and this is driving him crazy as he set up KOHA
for me is about 30 seconds flat with this as his only problem.  He is more
than willing to 'talk tech' to anyone who thinks they can help.

I have tried logging out properly, not logging out at all, changing
username and password, turning the whole machine off and on.

Cheers
-- 
Anne Laguna
Librarian
Army Museum North Queensland, Jezzine Barracks
jezzinelibrarya...@gmail.com

Tuesday  9am - 12pm
Friday 9am - 12pm
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Add me to lists

[Librarian at the Library of the Society of Jesus in South Africa]

Hi,

Kindly add me to your koha lists.

Regards,

-- 
[image: Inline image]

*Mr Francis Zvigo*
*Librarian*
Library of the Society of Jesus in South Africa
Mobile: +27 (74) 029-8901 | E-mail: sa-reglibr...@sj.org.za
Post: St Ignatius House, 15 Molesey Avenue, Auckland Park, Johannesburg,
2092, South Africa
Web: http://library.sj.org.za/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Error adding new records

[Blake Library]

Hi all. I'm using Koha version 3.11.00.008

When I go into cataloguing and "Add new record" everything looks ok, but
when I search for the record after saving I cannot find the data I entered.
I can edit and delete items but there seems to be a problem with the
records.

Any ideas about where the problem might be - server, MySQL, Koha version
bug?

Have lots of books waiting to be added.

Cheers


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

[Koha] Outstanding order (only one order per subscription is allowed)

[library]

Hi

I am having a problem entering serials information in the Acquisitions
module. I keep getting the message

"Outstanding order (only one order per subscription is allowed)"

when I try to enter a subscription into the new basket for the vendor.

I don't really understand the relationship between renewing a subscription
in the Serials module and entering budget information in the Acquisitions
Module.

Can anyone direct me to more information than is in the Manual.

I am using 3.20.4

Thanks

Ann

Ann Murphy
Librarian
Katikati College
Beach Road, Katikati, 3129
New Zealand

0064 7 5490434

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

[Koha] opac reading history

[Celtic Studies Library]

Hi

We are unable to see parton's reading history. We can only see what they 
currently have on loan.

opac privacy and opac reading history are set to ALLOW.
Is there something we are missing?

Many thanks

Margaret


--
School of Celtic Studies
Dublin Institute for Advanced Studies
10 Burlington Road
Dublin 4

+353 1 6140182

www.celt.dias.ie/library
@SCSLIbrary
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha