[Koha] Koha login error

2024-01-31 Thread 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


Re: [Koha] SQL report for URL

2023-07-20 Thread 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

2023-07-05 Thread 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

2023-06-21 Thread 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

2023-06-20 Thread 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

2023-06-20 Thread 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

2023-06-07 Thread 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

2023-06-06 Thread 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.

2023-06-05 Thread 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

2023-05-31 Thread 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 
> Koha   |  Aspen Discovery
> 
> Phone:(888)900-8944 <(888)%20900-8944>
> Follow us:
> 
> 
> 
> 
>
> 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]
>  >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

2023-05-30 Thread 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

2023-05-30 Thread 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

2023-05-30 Thread 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

2023-05-20 Thread 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

2023-05-19 Thread 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.

2023-05-08 Thread 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.

2023-05-08 Thread 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.

2023-05-07 Thread 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.

2023-05-05 Thread 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.

2023-05-05 Thread 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.

2023-05-05 Thread 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 
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.

2023-05-05 Thread 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.

2023-03-15 Thread 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.

2023-03-13 Thread 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


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

2023-02-28 Thread 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   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 
> ___
>
> 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

2023-02-13 Thread 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

2023-01-17 Thread 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

2022-11-08 Thread 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 
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

2022-10-29 Thread 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

2022-09-22 Thread 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] Catalog Error 500

2022-08-30 Thread 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.

2022-08-11 Thread 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

2022-07-12 Thread 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

2022-06-25 Thread 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 )

2022-06-16 Thread 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.

2022-04-27 Thread 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

2022-04-26 Thread 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

2022-04-26 Thread 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

2022-03-17 Thread 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)

2022-03-10 Thread 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

2022-02-06 Thread 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.

2022-01-31 Thread 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 
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 bulk change in item type

2021-11-21 Thread 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

2021-11-01 Thread 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

2021-09-14 Thread 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

2021-09-08 Thread 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 
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