Re: [Koha] Backup of Patron Images

[Indranil Das Gupta]

Hi Rupinder,

Koha stores uploaded patron images as MEDIUMBLOB data in the patronimage
table in the Koha database. These are not stored separately in the
filesystem.

For more details :
https://schema.koha-community.org/23_05/tables/patronimage.html

Hope this helps.

Indranil Das Gupta
L2C2 Technologies.



On Fri, Oct 27, 2023, 12:20 Rupinder Singh  wrote:

> Hi,
> When I migrated my koha from one server to another by migrating the MySQL
> database, I was able to see the complete data (Bibliography, Circulation,
> patron, etc) in the new server. However, I could not see the patron images
> on their profile page, which were earlier uploaded on the old server.
> I suppose when I migrated the SQL database, it just migrated the data to a
> new server, but the jpg files were stored in a folder in the koha
> installation, which is why the photos are not appearing in the new koha
> installation.
> Can anyone please help me with migrating the patron images as well?
> What is the folder location where koha stores the patron images uploaded
> for each patron?
>
> 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] Clearing of users

[Indranil Das Gupta]

Hi Tom,

A couple ways:

1) Soft delete the patron records so that they are moved from borrowers
table to deletedborrowers table.

There are both pros and cons to this. Biggest advantage being your patron
related queries will speed up. And you call still pull up the details of
your soft deleted borrowers using SQL queries.

The con being that you can't directly access a soft deleted record from the
Koha staff client UI (except via custom SQL reports).

2) By using the "discharge"
 feature in Koha which will restrict the user account for an indefinite
period. See
https://koha-community.org/manual/21.11/en/html/patrons.html#patron-discharges

There is one catch though, it requires you to discharge one patron at
a time, iirc, you can't do bulk discharge. However, on the plus side you
can still see the full patron record from within Koha's staff client UI.

Hope this helps,
Indranil Das Gupta
L2C2 Technologies


On Tue, Aug 1, 2023, 22:23 Tom Obrien  wrote:

> Hi all,
> I work in an academic Library. I would like to put a provision for clearing
> users who have completed their studies without deleting their account.  How
> do I deactivate their accounts  so that one can use the account to borrow
> books.
> Looking forward for your advice.
> Thank you.
>
> Tom
> ___
>
> 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] ChatGPT

[Indranil Das Gupta]

Hi Igor:

No, not lying actually. It's exactly doing what it is designed to do. It is
generative AI. Pulling up from what it already knows and tries to come up
with an answer it may not know. What it expects is the user to give it
feedback to correct the incorrect assumptions which it then tries to learn
for the next time someone asks the question.

You can see the fun if you try to use ChatGPT to generate SQL reports. it
will succeed with very simple ones. For complex ones it often makes up the
db schema. Pointing out the actual schema will train it.

Cheers,
Indranil Das Gupta

On Tue, Jul 25, 2023, 11:05 Сычев Игорь Алексеевич  wrote:

> Hello!
> Asked a question in ChatGPT:
> How to set up an inventory number generator in ILS Koha?
> Received a response:
> To set up an inventory number generator in ILS Koha, you will need to
> follow these steps:
>
> Log in to ILS Koha with administrator credentials.
>
> Go to "Admin" and select "Local Administration".
>
> In the "Items and Bibliographic Records" section, select "Item Types".
>
> Select the instance type you need or add a new one by clicking on the
> "New" button.
>
> In the "Generation Rule" section, select a specific rule or create a new
> one by clicking on the "New" button.
>
> Enter the necessary settings for generating an inventory number, such as
> prefix, number template, and other parameters.
>
> Save your changes.
>
> Your inventory number generator is now set up in ILS Koha. Each time you
> create a new instance, the system will automatically generate an inventory
> number according to the settings you have specified.
>
> I don't see "Generation Rule". Lying?
>
> 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

Re: [Koha] email notice sending

[Indranil Das Gupta]

Hi,

You need to either provide the PERL5LIBS env var manually OR do this:

sudo koha-shell 

and then run the command.


--
Indranil Das Gupta
L2C2 Technologies

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

On Thu, Apr 20, 2023 at 1:27 PM zen zenitram  wrote:
>
> here another problem when i run 
> /usr/share/koha/bin/cronjobs/process_message_queue.pl
>
> Can't locate Koha/Script.pm in @INC (you may need to install the Koha::Script 
> module) (@INC contains: /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/process_message_queue.pl line 23.
> BEGIN failed--compilation aborted at 
> /usr/share/koha/bin/cronjobs/process_message_queue.pl line 23.
>
>
>
> On Thu, Apr 20, 2023 at 3:36 PM Indranil Das Gupta  wrote:
>>
>> Hi
>>
>> You will need to check intranet-error.log.
>>
>> Also you can see the error in details by running
>> /usr/share/koha/bin/cronjobs/process_message_queue.pl with the
>> increased verbosity option
>>
>> hope this helps
>>
>> --
>> Indranil Das Gupta
>> L2C2 Technologies
>>
>> Phone : +91-98300-20971
>> WWW  : http://www.l2c2.co.in
>> Blog: http://blog.l2c2.co.in
>> IRC : indradg on irc://irc.freenode.net
>> Twitter : indradg
>>
>> On Thu, Apr 20, 2023 at 12:21 PM zen zenitram  wrote:
>> >
>> > hello
>> > KOHA v22.11
>> >
>> > How to check for errors in my SMTP and Overdue notice/status triggers
>> > <http://172.16.35.130:15000/cgi-bin/koha/tools/overduerules.pl>. because
>> > everytime i tried to checkout books for client this error appear
>> > (  Unhandled email failure, check the logs for further details)
>> >
>> > which log should i check?
>> >
>> > Thank you!
>> > ___
>> >
>> > 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] email notice sending

[Indranil Das Gupta]

Hi

You will need to check intranet-error.log.

Also you can see the error in details by running
/usr/share/koha/bin/cronjobs/process_message_queue.pl with the
increased verbosity option

hope this helps

--
Indranil Das Gupta
L2C2 Technologies

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

On Thu, Apr 20, 2023 at 12:21 PM zen zenitram  wrote:
>
> hello
> KOHA v22.11
>
> How to check for errors in my SMTP and Overdue notice/status triggers
> <http://172.16.35.130:15000/cgi-bin/koha/tools/overduerules.pl>. because
> everytime i tried to checkout books for client this error appear
> (  Unhandled email failure, check the logs for further details)
>
> which log should i check?
>
> Thank you!
> ___
>
> 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] Indexing for indic-arabic scripts in koha

[Indranil Das Gupta]

Hi,

See https://wiki.koha-community.org/wiki/Correcting_Search_of_Arabic_records

Hope this helps

-Indranil Das Gupta
L2C2 Technologies

On Tue, Apr 18, 2023, 10:21 Rupinder Singh  wrote:

> Hi everyone,
> I am using Koha which hosts books in multiple languages other than English,
> including, Hindi, Punjabi, Bengali, Assamese and Urdu, The Bibliographic
> records for such books are multilingual (with Non-Roman characters in 880
> fields). The system retrieves accurate results for English records, but for
> non-English books like Hindi, and Punjabi the results are not precise.
> I read somewhere that there is a specific command for zebra indexes that
> enables non-indic scripts more accurately retrievable.
> Could you guys help me out here, please?
>
>
> 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] Need Department and Designatation info for Patrons

[Indranil Das Gupta]

Hi Rupinder,

You have a couple of options:

1) Use sort1 and sort2 fields for the purpose (provided you are not already
using them for something else)

2) Use extended patron attributes

NOTE: if you use the second option, IIRC, you may not br able use the data
stored in these fields directly in your patron cards unless you build
workarounds for that, which is entirely doable because of the opensource
code of Koha.

FWIW, we typically use option #1 for our client-partners.

Hope this helps

-idg

On Mon, Mar 20, 2023, 10:26 Rupinder Singh  wrote:

> Hi,
> So, I've been working on koha for the last few years now. Koha is a
> wonderful software and works well with all kinds of libraries, But what I
> observed is, it is mostly being used in organizations, Colleges,
> and Universities where patrons/users are structured in defined hierarchies.
> Every user, be it Faculty, Non-Teaching Staff, or students, everyone has
> their own designation and a Department which they are affiliated with. That
> is how library people recognize them. But Koha does not have any field in
> patron records for this crucial information.
> My question is, Where do I enter, the name of the department and the
> designation of each of my library members? Please advise.
>
> Thank You
> Rupinder Singh
> Assistant Librarian
> Central University of Punjab
> ___
>
> 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] Give patron permission to export database

[Indranil Das Gupta]

Hi Isabel:

You colleague probably does not have superlibrarian permissions which you
obviously have. The DB dump export is available only to user(s) with
superlibrarian permission.

For more details:
https://git.koha-community.org/Koha-community/Koha/commit/bbcb1d784b38d129a5fa41aa9f3dc7b798c25c9c

Cheers
-indranil

On Mon, Dec 5, 2022, 19:09 Isabel Pineda  wrote:

> Hi.
>
> I have got enabled the Export Database Tab for the tool "Export data" and
> I would like to give my colleague access to this tool too. Although I give
> her patron permissions for all tools, the tab does not appear for her. Does
> anybody know how to give a patron the permissions to access the database
> export?
>
> Thank you
> Isabel Pineda
>
> ___
>
> 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.00.04: location

[Indranil Das Gupta]

Hi Sebastian:

952$c on this Koha wiki page
https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) is probably
what you need.

Cheers
-indranil


On Mon, Dec 5, 2022, 20:46 Sebastian Krieg 
wrote:

> Hello community,
>
> any idea wher I can manage the content of the field items.items_location
> as a part of the biblioitems record? I didn't find a configuration entry in
> "tools" or "administration" and I can't remember who I configure it because
> you get a list of suggested values.
>
> This list I configured in the past, but also the
> https://schema.koha-community.org/22_11/index.html can't help me.
> Thanks
>
> Sebastian
> ---
> mailto: sebastian.kr...@tuz-eisenach.de (mailto:
> sebastian.kr...@tuz-eisenach.de)
> ___
>
> 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] HTML coding

[Indranil Das Gupta]

Hi Erlanda,

No, it is not a bug. HTML markup / system is *NOT* supposed to be
embedded in the actual MARC21 record data.

The reason why the ISBD view is OK with the markup is something this
based on very old (by Koha's timeline) design decisions which the koha
community has been in discussion about a complete overhaul /
replacement (see
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20406)

Your desired display may be possible with a customization of the
MARC21slim2intranetDetail.xsl file in conjunction with jquery and css
via Intranetuserjs and intranetusercss system preferences.

cheers
-indranil

--
Indranil Das Gupta
L2C2 Technologies

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

On Mon, Dec 5, 2022 at 2:54 PM  wrote:
>
> Dear List,
> we are using Koha 21.05.
> For the fields 504, 520, 563 we are using HTML coding.
> In the "Normal view" html tags are seen, which is not normal, but in the ISBD 
> view HTML tags are suppressed and the display of the records is normal.
> Is this a bug?
> How can we correct the display?
> For more details on HTML display, please see:  
> https://vmc.sci.am/cgi-bin/koha/opac-detail.pl?biblionumber=165
>
>
> https://vmc.sci.am/cgi-bin/koha/opac-ISBDdetail.pl?biblionumber=165
> Thanks in advance,
> Erlanda
> ___
>
> 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-devel] Some very sad news.

[Indranil Das Gupta]

Hi Paul:

On Fri, Nov 18, 2022, 20:49 Paul Poulain  wrote

>
> @community : May I suggest that we name the next release "Koha 22.11
> Rosalie" ?
>

I was thinking of the same.  So, fwiw, it's an "aye" from me.

Regards
-indranil
___

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

Re: [Koha] [Koha-devel] Koha 22.05.04: Can't locate Koha/Script.pm in @INC

[Indranil Das Gupta]

Hi Michael

From the snippet shared by you, it seems that you are missing:

export PERL5LIB="/usr/share/koha/lib"

cheers
-idg


On Fri, Oct 28, 2022, 16:32 Michael Kuhn  wrote:

> Hi
>
> I am running a fresh installation of Koha 22.05.04 on Debian 11.
>
> I am trying to load some data using "bulkmarcimport.pl":
>
> # export KOHA_CONF=/etc/koha/sites/library/koha-conf.xml
> # /usr/share/koha/bin/migration_tools/bulkmarcimport.pl -b -m marcxml
> -framework=ABC -file TITEL.marcxml -v 2
> Can't locate Koha/Script.pm in @INC (you may need to install the
> Koha::Script module) (@INC contains: /etc/perl
> /usr/local/lib/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1
> /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5
> /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.32
> /usr/share/perl/5.32 /usr/local/lib/site_perl) at
> /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 13.
> BEGIN failed--compilation aborted at
> /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 13.
>
> "Script.pm" seems to be there:
>
> # ls -al /usr/share/koha/lib/Koha/Script.pm
> -rw-r--r-- 1 root root 4129 24. Aug 07:51
> /usr/share/koha/lib/Koha/Script.pm
>
> How can I get script "bulkmarcimport.pl" to actually run?
>
> Best wishes: Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>
___

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

Re: [Koha] sql query to include Tag 650 data in the report

[Indranil Das Gupta]

Hi Mahesh,

See https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC

hope this helps
Indranil Das Gupta
L2C2 Technologies

On Tue, 4 Oct, 2022, 11:09 am Mahesh Angadi,  wrote:

> Hi, I am using Koha 3.20,
>
> In report generation, I am able to get details like title, author, year,
> publisher, call number, etc, But I am not able to get data related to Tag
> 650 - Subject. I couldn't find the relevant field in guided wizard of
> report also.
>
> I am sharing my sql query. Kindly suggest the additions to sql query with
> which I can also get data related to Tag 650 - Subject.
>
> I have stored all Tag 650 data in one column only (its not a repeatable
> field, in our case. Eg. one subject name is added for all titles, for eg,
> Economics)
> =650  \\$aEconomics
>
> Our Report SQL Query is as follows:-
>
> SELECT
>
>  
> items.barcode,biblio.title,biblio.author,biblioitems.publishercode,biblio.copyrightdate,items.itemcallnumber,biblioitems.isbn
> FROM items LEFT JOIN biblioitems on
> (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on
> (biblioitems.biblionumber=biblio.biblionumber)   WHERE
> items.itype=<> ORDER BY items.barcode asc
>
>
>
> --
> Mr. Mahesh Angadi,
> ___
>
> 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-docs] Additional page text editing request - Koha

[Indranil Das Gupta]

Hi David,

Koha-docs isn't the right mailing list for this query. The right one is
koha@lists.katipo.co.nz :-)

What you have encountered is
https://wiki.koha-community.org/wiki/Koha_as_a_CMS (warning: the page
hasn't been updated in quite a while, so the line no. references are
unlikely to be accurate)

The content which you are looking to edit should be under Administration ->
System Preferences -> Local use

once there, look for entry where the variable looks like "page_dlibraries"

Hope this helps
Indranil Das Gupta
L2C2 Technologies


On Mon, 3 Oct, 2022, 7:02 pm David Demetrashvili, 
wrote:

> Dear Team,
> Let me kindly ask you, how can I change additional page text?
> http://library.gipa.ge/pages.pl?p=dlibraries
> I tried to find the answer but nothing is for that.
> Could you help me?
> Thank you!
> --
> Best Regards,
> *David Demetrashvili*
> Head of IT Department
>
>
> 9, Ietim Gurji
> Tbilisi, 0114, Georgia
> T: (995 32) 249 74 75
> M: (995) 551 68 20 20
> E-mail: d.demetrashv...@gipa.ge
> www.gipa.ge
> ___
> Koha-docs mailing list
> koha-d...@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-docs
>
___

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

Re: [Koha] [Koha-devel] Excess fields in Koha 22.05 file "patron_import.csv"

[Indranil Das Gupta]

Hi Michael,

Their mapping as follows

For patron_attributes -
https://schema.koha-community.org/22_05/tables/borrower_attributes.html

For "guarantor_relationship" and "guarantor_id" -
https://schema.koha-community.org/22_05/tables/borrower_relationships.html

hope this helps

Indranil Das Gupta
L2C2 Technologies

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

-- 
Indranil Das Gupta
L2C2 Technologies

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


On Fri, 30 Sept 2022 at 22:23, Michael Kuhn  wrote:
>
> Hi
>
> When unloading the field names of Koha 22.05 table "borrowers" I get 79
> field names (plus "borrowernumber").
>
> But when in Koha 22.05 menu "Tools > Import patrons" I click the link
> "Starter CSV file" the unloaded file "patron_import.csv" does include 82
> fields.
>
> When comparing the two outputs I see there are three more fields in file
> "patron_import.csv" than in table "borrowers":
>
>   patron_attributes
>   guarantor_relationship
>   guarantor_id
>
> These three fields aren't included in
> https://schema.koha-community.org/22_05/tables/borrowers.html
>
> What is the explanation for these excess fields?
>
> Best wishes: Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
___

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

Re: [Koha] Koha Software- Data migration- To remove leading zero digit from Barcode/accession number

[Indranil Das Gupta]

Hi Manoj,

If you have already imported the data into Koha, then:

UPDATE items SET barcode = TRIM(LEADING '0' FROM barcode)

Followed by memcached restart and a Zebra reindex

hope this helps

Indranil Das Gupta
L2C2 Technologies


On Fri, 30 Sep, 2022, 12:14 pm Manoj Kumar,  wrote:

> Dear Team Koha,
>
> How can I remove a leading zero in the barcode entry in the case of a data
> migrated (from another software) environment?
> Can i do it in bulk of around 27000 biblio records
>
> Expert advice needed
>
>
> --
> manoj
> ___
>
> 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] How to use Log Viewer search fields

[Indranil Das Gupta]

Hi Christopher,

Actually the wiki does in fact document the points which you are
looking for an answer. However it is not a separate article and nor is
it probably located at the most obvious of places :-)

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

There is also a nifty ByWater Solution Monday Minutes episode on the
topic here - https://bywatersolutions.com/education/to-log-or-not-to-log

Hope this helps :-)

Indranil Das Gupta
L2C2 Technologies

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

On Wed, Sep 28, 2022 at 12:04 AM Christopher Davis  wrote:
>
> Dear Collective Wisdom,
>
> I am trying to find descriptions of how to use the "object:" and "info:" 
> search fields in the Log Viewer of Koha 21.11.10 because the Koha manual does 
> not provide any, the wiki does not have an article on the log viewer, and my 
> institution's internet connection is on the fritz right now, so I cannot 
> access . Will any of you please provide descriptions or point me 
> to a resource?
>
> Thank you much,
>
> Christopher Davis
> Digital Services Specialist
> Jackson County Library Services
> 541-734-3990
> jcls.org<https://jcls.org/>
>
> Jackson County Library Services acknowledges that its libraries are located 
> within the traditional lands of the Cow Creek Band of Umpqua Tribe of 
> Indians, and the Modoc Nation; as well as the Shasta, Takelma, and Latgawa 
> people, whose descendants are now identified as members of the Confederated 
> Tribes of Siletz Indians and the Confederated Tribes of Grand Ronde. JCLS is 
> committed to fostering understanding, deep respect, and honor for Indigenous 
> people, and we encourage you to learn more about the land you reside on. For 
> more information, go to 
> jcls.org/land<https://jcls.org/about/land-acknowledgement/>.
> ___
>
> 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] Display Koha Saved Reports on OPAC for library patrons

[Indranil Das Gupta]

Hi,

1) make sure these reports are configured as  "public"

2) That your OPACBaseURL syspref is set

3) these reports will provide the output in JSON format

4) create the necessary jQuery snippet in OpacUserJS system preference to
fetch the json and generate your required display.

Hope this helps,
-idg

On Fri, 9 Sep, 2022, 11:13 am Ms. Naveen Ali,  wrote:

> Dear All,
>
> I have created and saved some reports in Koha, which I would like to
> display as Links on OPAC for patrons.
>
> How can I do this?
>
> With best regards,
>
> Naveen Ali
>
> ITM-JE (EAKL)
> Inst Representative for
> HEC Digital Library Resources.
> NEDUET, Karachi.
>
>
> ___
>
> 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] Trying to install

[Indranil Das Gupta]

Hi Jason,

The community supported canonical information for package based
installation are available here -
https://wiki.koha-community.org/wiki/Koha_on_Debian

hope this helps,
--
Indranil Das Gupta
L2C2 Technologies

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

On Wed, Sep 7, 2022 at 9:34 PM Maintenance  wrote:
>
> I'm following install instruction from here
> https://www.youtube.com/watch?v=FYDuHGQ20Eo=1313s
>
> and getting stuck ... the web page opens to log in and I try to log in
> and the screen goes blank...
>
> Not sure what I missed
>
> Any Ideas?
>
> thanks
> jason
> ___
>
> 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 Catalogue and incorporating electronic journals and databases within the catalogue

[Indranil Das Gupta]

Hi Lizelle,

In your post you have CCed LibLime. Are you using Koha ILS released by the
global Koha community or that abominable proprietary fork by LibLime?

FWIW, LibLime is *not* a part of the global Koha community for nearly the
past 12 years.

If you are using Koha as released by Koha community the answer to your
question would be "Yes! absolutely!" as long as you have MARC21 records
available (or can prepare) for your electronic journals and other resources.

(Depending on your use-case, you might want to integrate an ERM software
like CORAL with your Koha)

Btw, its "Koha" and not "KOHA" - a proper noun and not an acronym :-)

Hope that helps,

Indranil Das Gupta
L2C2 Technologies


On Wed, 7 Sep, 2022, 3:21 pm L. Smith,  wrote:

> Good morning All,
>
> Would you be able to assist please?
>
> We would like to take the next step to incorporate our electronic journals
> and databases within our KOHA Catalogue to make it easier for our users to
> search content. Basically one search box for all content.
>
> You support would be much appreciated.
>
> Best wishes,
>
>
>
> Lizelle Smith
>
> BA, AdvDipTour, DipLib, AALIA DCP
>
> Director of Library and Information Services
>
>
>
>
>
>
>
> 1/10 Nash Street Perth 6000
>
> PO Box D178 Perth BC 6849
>
> T 08 6222 4222
> E [ mailto:gdav...@sheridan.edu.au | lsm...@sheridan.edu.au ] W [
> https://mail.sheridan.edu.au/http//:sheridan.edu.au | sheridan.edu.au ]
>
> [ https://www.linkedin.com/in/lizelle-smith-aalia-dcp-75a797166 |
> www.linkedin.com/lizelle-smith ]
>
>
>
>
>
>
> This email and any attachments may be confidential. If you are not the
> intended recipient, please inform the sender by reply email and delete all
> copies of this message.
> ___
>
> 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] SMTP on Office 365 Email

[Indranil Das Gupta]

Hi Ashok,

One of our client-partners has been using Office365 email with their
Koha for the last 3 years. Their current config in the koha-conf.xml
(on 21.11) is :

 
smtp.office365.com
587
120
starttls
EMAIL
PASSWORD
0
 

NOTE: replace EMAIL and PASSWORD with the actual information for the
account sending out the email

hope this helps

--
Indranil Das Gupta
L2C2 Technologies

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

On Fri, Aug 26, 2022 at 2:57 PM Ashok Francis
 wrote:
>
> Dear Koha Team,
> Is office 365 Email working with KOHA SMTP settings? I have tried my email
> by adding an SMTP server. But it's not working. I have enabled koha-email
> and written the email address also. Can you help me with this? Here is the
> input I had given. I appreciate your help. Thank you.
> Ashok.
>
>1. Name: Required
>
>
>1. Host: Required
>2. Port: Required
>3. Timeout (seconds):
>4. SSL:Disabled SSL
>   STARTTLS
>5. User name:
>6. Password:
>7. Debug mode:Enabled
>Disabled
>8.
> ___
>
> 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] /server-status?auto

[Indranil Das Gupta]

Hi Mason,

Sounds like he prolly has mod_status enabled on his Apache

Cheers
Indranil

On Sat, 30 Jul, 2022, 9:25 am Mason James,  wrote:

> On 29/07/22 2:05 pm, Keith Sorbo wrote:
> > My server is getting hit once a second from 127.0.0.1 on the url
> > /server-status?auto
> >
> > What is hitting the server? It is clearly internal.
>
> hi Keith
>
> i'm not sure what is hitting your server, but it is not koha
>
> you possibly have a local monitoring tool that's causing the requests, and
> is not identifying itself
> ___
>
> 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] Problem in creating new authority types

[Indranil Das Gupta]

Hi,

First (a request), try not to cross post, especially when the question does
not have a developer / coding related context.

Second, traditionally name and place of publication are *not* authority
controlled in MARC21. However, it may be your local decision.

That said, have you already explored and found that Koha's Authorised
values not doing what you want? Authorised values for 260$a and 260$ may be
a better fit and you will also benefit from automatic filtering of the
values as your cataloguers do their work.

However, if you still want to use MARC21 authority control for 260$a and
260$b, you really DO NOT need to create new authority types as mentioned in
the wiki page you have referred to.

The place of publication can work as a Geographic Name authority and the
publisher can work as a Corporate name authority as per Koha's standard
authority frameworks.

Stepping outside these perimeters will mean you will have to have to get
your hands dirty with CCL queries, debugging zebra indexes and Koha's
search internals.

All the best going ahead.

By the way, "Koha" is a proper noun and not and acronym, and thus it is
incorrect to uppercase it as KOHA :-)

Cheers
-idg




On Mon, 30 May, 2022, 12:51 pm Ms. Naveen Ali,  wrote:

> Dear All,
> I am trying to create new authority types in KOHA 21.11 on Ubuntu 20.04.
> I am following this documentation Create new authority type - Koha Wiki (
> https://wiki.koha-community.org/wiki/Create_new_authority_type )
> In the section on Zebra,
>
>
> * I cannot understand how the att numbers are defined
> * I cannot follow the next two steps, which require record.abs file. I
> cannot find the file. Neither the one in biblios nor in authorities folder.
> I need to create two authorities, namely, publisher and place of
> publication to accommodate my existing data which I will be migrating to
> KOHA.
>
> Support will be greatly appreciated
>
>
> With best regards,
>
> Naveen Ali
>
> ITM-JE (EAKL)
> Inst Representative for
> HEC Digital Library Resources.
> NEDUET, Karachi.
>
>
> ___
>
> 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] Question / UX defect

[Indranil Das Gupta]

Hi,

You can do it by binding the 020$a input field with a js keydown / keyup
event to throw that alert / hint on the UI

Although tbh, this is something that a professional cataloger is supposed
to know, which i understand you are not (appreciate your effort to learn
though :-).

Cheers
Indranil.



On Sat, 21 May, 2022, 4:01 pm C.S. Hayward, 
wrote:

> Thank you for clarifying!
>
> I no longer think that hyphens should be accepted and ignored, but putting
> some message like a good UX password field's "Caps lock is on" would help
> people like me realize that I'm not supposed to enter hyphens.
>
> Br. C.S. Hayward, c-s-hayward.com
>
>
> --- Original Message ---
> On Friday, May 20th, 2022 at 11:44 AM, Hernandez, Heather H <
> heather_hernan...@nps.gov> wrote:
>
>
> > Hi, C.S.!
> > Hyphens are never entered into the 020 ISBN field of a MARC record--they
> are specifically prohibited, actually--c.f.:MARC 21 Format for
> Bibliographic Data: 020: International Standard Book Number (Network
> Development and MARC Standards Office, Library of Congress) (loc.gov)
> >
> > So all library systems, including Koha, are designed to deal with them
> without hyphens, and the MARC format instructs that hyphens may be
> generated for display.  The hyphens are only for humans, dividing the ISBN
> into its components of country of publication, publisher, then publication
> number.
> > So since the MARC Format instructs we humans to omit the hyphens, I
> would argue that there's no UX enhancement needed to instruct the software
> to ignore the hyphens--that's the way the software is supposed to be
> designed.  And if a human does include the hyphens and the search fails
> because of the hyphens, perhaps we should be improving the instructions to
> humans to omit the hyphens?
> > Cheerio!h2
> >
> > ~~~
> >
> > Ms. Heather Hernandez (she, her, hers)
> > Technical Services Librarian
> > Library catalog:  https://keys.bywatersolutions.com/
> > San Francisco Maritime National Historical Park Research Center
> > 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
> > 415-561-7032 (office generally M-W, telecommuting Th-F)
> > heather_hernan...@nps.gov
> ___
>
> 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] How to keep leading zeros when converting excel to marc

[Indranil Das Gupta]

Hi

Format the numbers as text OR precede the number with a single quote mark

hope this helps
Indranil

On Thu, 28 Apr, 2022, 12:55 pm Tom Obrien,  wrote:

> Dear all,
> I am migrating records which are in excel to koha using marcedit. However
> when I upload to koha, the leading zeros are missing.
> Kindly help me so that i can keep the leading zeros.
> I am using koha 21 version.
> Regards
> Tom
> ___
>
> 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] Alternate Graphic Representation (880 Tag) Information Details stored in which Koha Database Tables?

[Indranil Das Gupta]

Hi Sambhunath,

Table is biblio_metadata

With regards
-idg

On Mon, 7 Mar, 2022, 3:12 pm Sambhunath Sahoo,  wrote:

> Hello,
> I want to create a Koha report which includes *Alternate Graphic
> Representation (880 Tag)* Information Details stored in its Database
> Tables. I checked all 222 database tables of Koha (Version 21.05)
> like biblio, biblioitems, etc. but was not able to identify where the above
> said information (Title, subtitle in other language, and Statement of
> Responsibility in other language) are stored. Please guide me which Koha
> DatabaseTable stores the information of 880 Tags (880$a, 880$b, 880$c)?
>
> Regards,
> Dr. Sambhunath Sahoo / डॉ सम्भुनाथ साहु
> Assistant Librarian / सहायक पुस्तकालयाध्यक्ष,
> Central Library / केन्द्रीय पुस्तकालय,
> 4th Floor, Administrative Building / चौथा मंजिल, प्रशासनिक भवन
> Indian Institute of Technology Bhubaneswar / भारतीय प्रौद्योगिकी संस्थान
> भुवनेश्वर
> Argul, Khurda, Odisha /  आरगुल, खुर्दा, ओड़िशा,
> 752050 (India)
> Mobile: 7978949882
> Phone: +91-674-713-8756 (O)
> E-Mail: sam...@iitbbs.ac.in
>sambhum...@gmail.com
> *ORCID ID:* -0001-9162-879X
> *Researcher ID:* K-4446-2018
> *Scopus ID:* 57222542160
> ___
>
> 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] no search results after upgrade from 17.11 to 20.11

[Indranil Das Gupta]

Hi,

I moved a 17.11.03 db (Debian 9) to 20.11.09 (Debian 10).

I've done the following:

1) cleared cache
2) restarted memcached
3) invoked koha-zebra --restart instance
4) did a full reindex (which is showing me the correct number of
records being exported.

and for good measure have even restarted the box

and yet "no cheese" :-(

the Debian 10 box  is a multi-tenant and the other instances are running
correctly

Any clue what I may be missing?

--
Indranil Das Gupta
L2C2 Technologies

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

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

Re: [Koha] Blood group field

[Indranil Das Gupta]

Sagar,

The ***only*** thing that is *MUST* on a library card are the name of
library branch and the member id.

Everything else is extra and poses a tremendous risk and liability (for the
issuing authority) if a lost / stolen card is used for identity theft.

The global trend and standard is to keep as little identifying information
as possible on a library access card OR information that only makes sense
when used within the system of the card issuing library / library network.

The real reason why library cards in India used to pile on so much data on
the member card was because most of our systems were manual OR not online
and the card carried most of the crucial identifying information.

You are free to make any suggestion, but it is unlikely that Koha
developers would work on including blood group as a borrower information
field.

-idg

On Sat, 23 Oct, 2021, 4:17 pm Sagar Londhe, 
wrote:

> Respected Gupta sir,
> Thank you for your suggestion. I think we shall recommend developers to
> add the blood group field for patrons in the next koha version. Blood group
> field is must for patron card.
>
> Regards,
> Sagar
>
> On Sat, Oct 23, 2021 at 4:12 PM Indranil Das Gupta 
> wrote:
>
>> Hi Sagar,
>>
>> Koha DOES NOT provide any field for blood group of the borrower. If your
>> koha installation is providing it as part of the borrowers table, it is a
>> local customization and you will need to ask whoever has customised your
>> Koha.
>>
>> People who need to use custom fields for their patrons usually following
>> one of two ways
>>
>> (a) use a patron extended attribute (recommended)
>>
>> (b) repurpose an unused borrowers table field.
>>
>> hth,
>> Indranil Das Gupta
>> L2C2 Technologies
>>
>>
>> On Sat, 23 Oct, 2021, 4:03 pm Sagar Londhe, 
>> wrote:
>>
>>> Dear all,
>>>
>>> Greetings !!!
>>>
>>> I am working on patron card and would like to add the blood group of the
>>> patron on the card. please guide me about the exact SQL name for the
>>> blood
>>> group field.
>>>
>>> Regards,
>>>
>>> --
>>> Mr.Sagar B. Londhe
>>> (BBA, M.Lib.I.Sc)
>>> Thane 400602,
>>> Mumbai,
>>> Maharashtra,
>>> India.
>>> Mo. No.: 9049164508
>>> ___
>>>
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>
> --
> Mr.Sagar B. Londhe
> (BBA, M.Lib.I.Sc)
> Thane 400602,
> Mumbai,
> Maharashtra,
> India.
> Mo. No.: 9049164508
>
___

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

Re: [Koha] Blood group field

[Indranil Das Gupta]

Hi Sagar,

Koha DOES NOT provide any field for blood group of the borrower. If your
koha installation is providing it as part of the borrowers table, it is a
local customization and you will need to ask whoever has customised your
Koha.

People who need to use custom fields for their patrons usually following
one of two ways

(a) use a patron extended attribute (recommended)

(b) repurpose an unused borrowers table field.

hth,
Indranil Das Gupta
L2C2 Technologies


On Sat, 23 Oct, 2021, 4:03 pm Sagar Londhe, 
wrote:

> Dear all,
>
> Greetings !!!
>
> I am working on patron card and would like to add the blood group of the
> patron on the card. please guide me about the exact SQL name for the blood
> group field.
>
> Regards,
>
> --
> Mr.Sagar B. Londhe
> (BBA, M.Lib.I.Sc)
> Thane 400602,
> Mumbai,
> Maharashtra,
> India.
> Mo. No.: 9049164508
> ___
>
> 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] Reason to define Koha item type in 942

[Indranil Das Gupta]

Katrin++

The koha encyclopaedia has spoken!

Thanks @cait

On Mon, 18 Oct, 2021, 2:23 am Katrin Fischer, 
wrote:

> Hi Caroline and all,
>
> to add to the list of things:
>
> - 942$c is used as the pre-selected item type when adding new items.
> - 942$c will be used for record level article requests to determine
> which circulation rule applies.
> - I also believe that 942$c plays a role in record level hold requests,
> but I couldn't quite pinpoint that. I seem to remember that it was used
> for the max number of possible record level holds for an item type.
>
> Hope that helps,
>
> Katrin
>
> On 15.10.21 16:22, Caroline Cyr-La-Rose wrote:
> > Hello!
> >
> > I'd like to add to Indranil's explanation.
> >
> > 952$y is mandatory for circulation IF item-level_itypes is set to
> > "specific item". Otherwise, 942$c is used as the item type for
> > circulation.
> >
> > Another thing that I have observed about 942$c is that it is indexed
> > for the search in the same way as 952$y. So if you have records
> > without items (for journal articles, websites or ebooks for example),
> > these will still be searchable through the item type filter.
> >
> > Also, if 942$c and 952$y are not the same in one record (for example,
> > 942$c is Book and 952$y is Reference), they will show in the results
> > of a search for either type.
> >
> > I'm making a note to compile all our comments to add into the manual,
> > since that's where you searched for the information first.
> > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29252
> >
> > Best regards,
> >
> > Caroline
> >
> > On 2021-10-15 10 h 02, Indranil Das Gupta wrote:
> >> Hi Tasha,
> >>
> >> 942$c - defines the type of material the bibliographic record
> >> represents,
> >> sort of like it's GMD (general material description). Has no bearing on
> >> circulation of material. Stored as marcxml in biblio_metadata.
> >>
> >> 952$y - defines the item-level item, and is used mandatorily for Koha's
> >> circulation rules which work as a permutation of (a) branchcodes (b)
> >> patron
> >> categories and (c) item-level item types. Stored as itype column in
> >> items
> >> table.
> >>
> >> Hope this helps
> >> Indranil
> >>
> >> On Fri, 15 Oct, 2021, 12:44 am Bales (US), Tasha R, <
> >> tasha.r.ba...@boeing.com> wrote:
> >>
> >>> Good afternoon,
> >>>
> >>> I recall reading (in the Koha manual?) the explanation for why it is
> >>> advantageous to define Koha item type in the bib 942 field.  I
> >>> believe it
> >>> has to do with exporting records, or the scope of records that is
> >>> included
> >>> when doing some type of report?  I'm trying to locate that information
> >>> again, but can't find it for the life of me.
> >>>
> >>> Does this seem familiar to anyone?  Thanks.
> >>>
> >>>
> >>> Tasha Bales
> >>> Enterprise Services
> >>> http://isesi.web.boeing.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
> > Caroline Cyr La Rose, M.S.I.
> > Bibliothécaire | Responsable de produit
> >
> > Tél. : 1-833-465-4276, poste 221
> > caroline.cyr-la-r...@inlibro.com
> > <mailto:caroline.cyr-la-r...@inlibro.com>
> >
> > INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com
> > <http://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] Reason to define Koha item type in 942

[Indranil Das Gupta]

Hi Tasha,

942$c - defines the type of material the bibliographic record represents,
sort of like it's GMD (general material description). Has no bearing on
circulation of material. Stored as marcxml in biblio_metadata.

952$y - defines the item-level item, and is used mandatorily for Koha's
circulation rules which work as a permutation of (a) branchcodes (b) patron
categories and (c) item-level item types. Stored as itype column in items
table.

Hope this helps
Indranil

On Fri, 15 Oct, 2021, 12:44 am Bales (US), Tasha R, <
tasha.r.ba...@boeing.com> wrote:

> Good afternoon,
>
> I recall reading (in the Koha manual?) the explanation for why it is
> advantageous to define Koha item type in the bib 942 field.  I believe it
> has to do with exporting records, or the scope of records that is included
> when doing some type of report?  I'm trying to locate that information
> again, but can't find it for the life of me.
>
> Does this seem familiar to anyone?  Thanks.
>
>
> Tasha Bales
> Enterprise Services
> http://isesi.web.boeing.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

Re: [Koha] How can I temporarily disable the visibility of an OPAC Library?

[Indranil Das Gupta]

Hi,

On Tue, 31 Aug, 2021, 10:34 pm Victor Barroso Oliveira, 
wrote:

> I don't want to enable login and password to access opac.
> I just want to temporarily disable access to a library in OPAC.
>

In that case:

https://koha-community.org/manual/18.11/en/html/systempreferences.html#opacmaintenance

Regards,
Indranil Das Gupta
L2C2 Technologies.

>
>
___

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

Re: [Koha] How can I temporarily disable the visibility of an OPAC Library?

[Indranil Das Gupta]

Hi Victor,

Easy way: Setting OpacPublic system preference. That will set the OPAC as
password protected.

More technically complex way: uncomment the disable segment in the shared
opac apache config of your Koha instance.

Hope this helps

Indranil Das Gupta
L2C2 Technologies




On Tue, 31 Aug, 2021, 10:13 pm Victor Barroso Oliveira, 
wrote:

> Good afternoon,
> I have a Koha installation with multiple libraries.
> How can I temporarily disable the visibility of an OPAC Library?
> ___
>
> 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] account lines table truncated by mistake

[Indranil Das Gupta]

Hi,

On Fri, 27 Aug, 2021, 4:29 pm Arunkumar Sampath, 
wrote:

> Hello all,
> without current backup mistakenly truncated accountlines table, therefore
> lost all fine data,
> is it possible to populate fine information for existing issued items.
>

Yes, using the fines.pl cron job

See https://koha-community.org/manual/21.05/en/html/cron_jobs.html#fines

You should

1. backup your current database for safety

2. switch to your koha instance system account using koha-shell

3. Run the fines.pl cron job

Caveat: check the status of your account offsets table before and after,
it's linked to the accountlines table.

Regards
Indranil Das Gupta
L2C2 Technologies


> Thanks in advance
> --
>
> *with regards *
>
> *S.ARUNKUMAR*
> ___
>
> 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: Your IP has changed. Please login again

[Indranil Das Gupta]

Hi Victor,

As a security measure Koha by default has the system preference
"SessionRestrictedByIP" set to "Yes". Changing it to "No" should work for
you.

With regards,

Indranil Das Gupta
L2C2 Technologies

On Thu, 12 Aug, 2021, 11:09 pm Victor Barroso Oliveira, 
wrote:

> Good afternoon
> On koha 21.05.02, he is logging out frequently.
> "Error: Your IP has changed. Please login again"
> What are the possible causes for this error?
> Thanks,
> Victor
> ___
>
> 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] Location of tag 245$c in koha database

[Indranil Das Gupta]

Hi Satish,

On Fri, 30 Jul, 2021, 1:37 pm SATISH,  wrote:

> Hi Indranil,
>
> Is it the same location in Koha18.11 for the tag 245$c ?
>

ExtractValue(biblio_metadata.metadata,
'//datafield[@tag="245"]/subfield[@code="c"]'))

There has been a change in the table name and field name.

Cheers
-idg

>
___

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

Re: [Koha] using koha in school

[Indranil Das Gupta]

Hi Thies,

On Wed, 28 Jul, 2021, 6:15 pm Thies,  wrote:

a) is it possible to generate a list of patreons that are too late
> giving back books?
>

Take a look at this report :

Overdues w/ Contact Info

https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Overdues_w.2F_Contact_Info

b) is it even possible to first generate class-lists and than sort
> patreons after class names (like 9a, 9b, 10a, 10b)
>

You have two choices :

a) use ExtendedPatronAttributes to add a custom field that will hold your
class / section information

https://koha-community.org/manual/20.11/en/html/administration.html#patron-attribute-types-label

b) Use the Sort 1 or Sort 2 fields in your patron record

Look up sort1 on the page
https://koha-community.org/manual/20.11/en/html/patrons.html

Hope this helps.

Indranil Das Gupta
L2C2 Technologies
___

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

Re: [Koha] Hold policy and settings

[Indranil Das Gupta]

Hi Nalisha,

Check if you have a default circ / hold policy in place.

Hth
-indranil

On Tue, 6 Jul, 2021, 10:24 am Nalisha Tamang,  wrote:

> Dear all,
> Please help me to set a hold policy settings from all the starting till the
> end. I tried to place a hold and it says ' There are no items that can be
> placed on hold. i have not done any settings or hold fee or any cron jobs
> .please help me out
> thank you
> nalisha
> ___
>
> 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] Batch record modification of Biblio items such as 650 subject tag!

[Indranil Das Gupta]

Hi,

What you are trying to achieve can't be done by the way you are approaching
the problem.

However, all is not lost.

OPTION A: If you haven't done any circ transactions so far, easiest way
would be reverse the marc import. Update your marc file with the subject
headings using MarcEdit and importing the new file into Koha.

OPTION B: If you have circ txns in Koha, then export the bibs from Koha as
a marc file taking care that the records have the marc field 999$c
(KohaBiblio). Update the file using MarcEdit adding in the missing 650s.
The import the updated file back into Koha with the following caveat - you
will have to match on 999$c and replace existing record with incoming
record.

NOTE: before you try anything, remember to take a full db backup first in
case things go sideways and you need to get back to whatever was there
before.

Hope this helps
Indranil Das Gupta
L2C2 Technologies





On Tue, 20 Apr, 2021, 12:03 pm Kuppu Swamy,  wrote:

> Thanks, I'll check them out.
> The solution that I am looking for is as follows:
> 1.I have already uploaded  Bibliographic records using MARCEDIT without
> subject headings under the MARC tag 650.Now I want to update the Biblos
> with the Tag 650.Each record has unique headings.When I use Marc template
> to update 650 tag i found that all records are replaced with the same
> subject heading which
>  is wrong.
> Please forward any video to solve the above specific problem
> Regards
> Kuppuswamy
> 20-4-21
> Kuppuswamy
>
> On Mon, Apr 19, 2021 at 9:21 PM Eric Phetteplace 
> wrote:
>
> > Hi Kuppuswamy,
> >
> > Sure, ByWater has a blog post for that:
> >
> https://bywatersolutions.com/education/monday-minutes-marc-modification-templates
> >
> > For future reference, I just googled "bywater marc modification
> templates"
> > and this was the first result. When you already know exactly what you
> want
> > like that, it's easy to find.
> >
> > I also found a recent (≈6 months ago) PTFS Europe video that might be a
> > bit more in-depth: https://www.youtube.com/watch?v=8UItQHclmP4
> >
> > Best,
> >
> > ERIC PHETTEPLACE Systems Librarian, Libraries (he/him)
> >
> > ephettepl...@cca.edu | o 510.594.3660 (cca)
> >
> > 5212 Broadway | Oakland, CA | 94618
> >
> > CCA is situated on the traditional unceded lands of the Ohlone peoples.
> >
> > Black-owned bookstores in Oakland: Ashay by the Bay
> > <https://ashaybythebay.com/>, Marcus Books
> > <https://www.facebook.com/marcus.books/>
> >
> > :(){ :|: & };:
> >
> >
> > On Sun, Apr 18, 2021 at 10:55 PM Kuppu Swamy 
> > wrote:
> >
> >> Hi,
> >> Namaskaar!
> >> I would like to seek help regarding Modification of Batch records using
> >> Tools Menu Option : Batch record Modification, and modifying the
> record(s)
> >> with the help of MARC Modification template.
> >> Kindly provide me a link to By watersolution video on the above subject
> >> or
> >> any other proven solution to understand and fix the above problem.
> >> Thanks
> >> With regards
> >> Kuppuswamy
> >> Librarian  IIAEM
> >> Jain University,
> >> ___
> >>
> >> 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 Item Number File Creation

[Indranil Das Gupta]

Hi Charles,



> are three ways to identify the target items: (1) scan or type each barcode
> number into the textbox; (2) identify the compiled file of compiled
> barcodes of the targeted items; and (3) use the file of compiled item
> numbers.
>
> I have sought information for compiling item record files, but I have
> been unsuccessful. How are such files compiled?
>

Most often - using a saved sql report from Koha's report module.

Hope this helps,

Indranil Das Gupta
L2C2 Technologies
___

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

Re: [Koha] Patron Emailer Plugin - Help

[Indranil Das Gupta]

Satish: pls be careful which using this plugin. Send only in small batches
of 20 - 30 emails at each time. During the 2020 covid lockdown one of my
clients had attempted to email their readers (approx 830+) about new
on-line resources they could access from home. The client was using a gmail
email account. Google's anti-spam AI filters marked the emails as spaming
activity and permanently disabled that email address. Thankfully it was a
new email created for that purpose, imagine the mess if it was their
library's regular gmail acct!!!

Regards
-idg

On Sat, 17 Apr, 2021, 12:31 pm SATISH,  wrote:

> Hi,
>
> Wih Koha 18.11.09, I am planning to use
> Koha Patron Emailer plugin - bywatersolutions
> (
>
> https://github.com/bywatersolutions/koha-plugin-patron-emailer/releases/tag/v2.1.29
> )
> for generating (letter)- No Dues Certificate to patron's Inbox.
> After performing "run rool", this Plugin says, it has sent email to
> respective patrons uploaded using CSV.  But, when I cross check Patron
> notices Tab - Type is set to "Print"  instead of "email" and status is
> always pending instead of "sent". (checkin, checkout, overdue notices are
> functioning).
>
> Any help would be appreciated and very helpful for me to avoid manual work
> of writing no-due certificates in each semester end.
>
> --
> *Satish MV*
> Librarian - Govt. Engineering College
> Opp. Dairy Circle, B.M.Road, Hassan 573 201
> Karnataka, INDIA
> Mobile: +91 9449765737
> Personal Email: lis4sat...@gmail.com
> College Website: www.gechassan.ac.in
> Library OPAC: http://library.gechassan.ac.in
> Library Portal :  https://librarygechassan.wixsite.com/library
> ___
>
> 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) BACKUP KOHA VIA TOOLS

[Indranil Das Gupta]

That is what it is supposed to do. Check under /var/spool/koha/instance if
files have been created.


On Wed, 10 Mar, 2021, 6:37 pm muiru james,  wrote:

> Nothing seems to happen on running the command - sudo koha-run-backups
>
> It just returns to the user home path immediately
>
> Regards
> James
>
>
> On Wed, Mar 10, 2021 at 3:11 PM Indranil Das Gupta 
> wrote:
>
>> Ummm... could be a permissions issue. Try to run the command:
>>
>> sudo koha-run-backups
>>
>> from the terminal and see if it works.
>>
>> On Wed, 10 Mar, 2021, 5:23 pm muiru james,  wrote:
>>
>> > Hi
>> >
>> > The config file is enabled.
>> >
>> > Could it be that the installation was not done as root? Because when I
>> > tried opening the config file using leafpad, I got a warning that the
>> file
>> > is not owned by root.
>> >
>> > Regards
>> > James
>> >
>> >
>> >
>> >
>> > On Wed, 10 Mar 2021, 11:41 Indranil Das Gupta, 
>> wrote:
>> >
>> >> The option to download the database from the Tools menu depends on two
>> >> things:
>> >>
>> >> a) the koha-run-backups script needs to run via the daily cron job to
>> >> generate the file under /var/spool/koha/
>> >>
>> >> b) the relevant config option needs to be enabled in koha-conf.xml
>> >>
>> >> You need to check if a) koha-run-backups is actually generating the
>> backup
>> >> by ruining it manually from the command line, b) check if the cron job
>> is
>> >> running correctly.
>> >>
>> >> Hope this helps
>> >> Indranil Das Gupta
>> >> L2C2 Technologies.
>> >>
>> >> On Wed, 10 Mar, 2021, 1:49 pm muiru james, 
>> wrote:
>> >>
>> >> > Hello team,
>> >> >
>> >> > I have a system that has no backups to download at the export data,
>> >> backups
>> >> > in the tools module. The config file is well edited to allow for the
>> >> > backups via tools.
>> >> >
>> >> > What could be the problem?
>> >> >
>> >> > Koha version is 19.05
>> >> > Ubuntu 16.04
>> >> >
>> >> > Please help
>> >> >
>> >> > Warm Regards
>> >> > James
>> >> > ___
>> >> >
>> >> > 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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] (koha) BACKUP KOHA VIA TOOLS

[Indranil Das Gupta]

Ummm... could be a permissions issue. Try to run the command:

sudo koha-run-backups

from the terminal and see if it works.

On Wed, 10 Mar, 2021, 5:23 pm muiru james,  wrote:

> Hi
>
> The config file is enabled.
>
> Could it be that the installation was not done as root? Because when I
> tried opening the config file using leafpad, I got a warning that the file
> is not owned by root.
>
> Regards
> James
>
>
>
>
> On Wed, 10 Mar 2021, 11:41 Indranil Das Gupta,  wrote:
>
>> The option to download the database from the Tools menu depends on two
>> things:
>>
>> a) the koha-run-backups script needs to run via the daily cron job to
>> generate the file under /var/spool/koha/
>>
>> b) the relevant config option needs to be enabled in koha-conf.xml
>>
>> You need to check if a) koha-run-backups is actually generating the backup
>> by ruining it manually from the command line, b) check if the cron job is
>> running correctly.
>>
>> Hope this helps
>> Indranil Das Gupta
>> L2C2 Technologies.
>>
>> On Wed, 10 Mar, 2021, 1:49 pm muiru james,  wrote:
>>
>> > Hello team,
>> >
>> > I have a system that has no backups to download at the export data,
>> backups
>> > in the tools module. The config file is well edited to allow for the
>> > backups via tools.
>> >
>> > What could be the problem?
>> >
>> > Koha version is 19.05
>> > Ubuntu 16.04
>> >
>> > Please help
>> >
>> > Warm Regards
>> > James
>> > ___
>> >
>> > 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) BACKUP KOHA VIA TOOLS

[Indranil Das Gupta]

The option to download the database from the Tools menu depends on two
things:

a) the koha-run-backups script needs to run via the daily cron job to
generate the file under /var/spool/koha/

b) the relevant config option needs to be enabled in koha-conf.xml

You need to check if a) koha-run-backups is actually generating the backup
by ruining it manually from the command line, b) check if the cron job is
running correctly.

Hope this helps
Indranil Das Gupta
L2C2 Technologies.

On Wed, 10 Mar, 2021, 1:49 pm muiru james,  wrote:

> Hello team,
>
> I have a system that has no backups to download at the export data, backups
> in the tools module. The config file is well edited to allow for the
> backups via tools.
>
> What could be the problem?
>
> Koha version is 19.05
> Ubuntu 16.04
>
> Please help
>
> Warm Regards
> James
> ___
>
> 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 API List - https://demo.bibkat.no/api/v1/.html

[Indranil Das Gupta]

Hi Ravikumar,

On Wed, 30 Dec, 2020, 2:47 am ravikumar c,  wrote:

> Thanks Tomas, Having API's for all basic functionalities will definitely
> help. I am looking for more details about each available API as of now
> Below URL - https://wiki.koha-community.org/wiki/Using_the_Koha_REST_API
> says below sentence.
>
> The REST API is self documenting, so you can view documentation describing
> the actual version you will be working with at the following URL:
> https://example.com/api/v1/.html
>
>
> https://example.com/api/v1/.html  is just example domain and I can't find
> any documentation. Am I missing

something?
>

Yes. You missed https://demo.bibkat.no/api/v1/.html#op-get-checkouts

"example.com" is simply a placeholder for the FQDN of your instance. You
are expected to replace it with your specific details.


Hope this helps,
-idg


>
___

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 Installing Multiple Instances of Koha

[Indranil Das Gupta]

Hi Joel,

Actually, in the indian academic accreditation workflow, the multiple
branch / with or without IndependentBranches setup does not work very well
as they *must* show __separate__ databases, with separate OPACs (without
logging in)

Cheers
-idg

On Mon, 30 Nov, 2020, 9:19 pm Coehoorn, Joel,  wrote:

> Rather than three completely separate koha instances/databases, Koha can
> support multiple **branches** in the same database and installation. You'll
> likely find this MUCH easier to deal with.
>
> Joel Coehoorn
> Director of Information Technology
> York College of Nebraska
>
>
> On Mon, Nov 30, 2020 at 7:04 AM Indranil Das Gupta 
> wrote:
>
>> Hi,
>>
>> Live DVDs of Koha are not supported by the Koha community. That said, you
>> can setup separate instances of Koha for each of your campuses using
>> separate port numbers. See the Koha Wiki for details in the article Koha
>> on
>> Ubuntu
>>
>> Cheers
>> -idg
>>
>>
>>
>> On Mon, 30 Nov, 2020, 5:51 pm MAMCET Library, > >
>> wrote:
>>
>> > 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 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] How to Installing Multiple Instances of Koha

[Indranil Das Gupta]

Hi,

Live DVDs of Koha are not supported by the Koha community. That said, you
can setup separate instances of Koha for each of your campuses using
separate port numbers. See the Koha Wiki for details in the article Koha on
Ubuntu

Cheers
-idg



On Mon, 30 Nov, 2020, 5:51 pm MAMCET Library, 
wrote:

> 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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SUPPORT NEEDED: Barcode not printing on patron cards at all

[Indranil Das Gupta]

Hi Hasanah,

The one thing that comes to my mind is that your patron card number might
be using characters that aren't supported by your selected barcode
symbology e.g. if you have used Code39 and your barcode string has a lower
case character, then your barcode image won't be generated. Or for that
matter anything non ASCII.

Cheers
Indranil

On Thu, 19 Nov, 2020, 8:53 pm Hasanah Hajee,  wrote:

> This is my KOHA VERSION: 17.11.04.000
>
> Hi,
>
> Whenever I create a patron card, the barcode never ever appears on the
> template. i have copied and tried many templates now and on all of them the
> barcodes just don't appear. so i figured it isn't that i'm scaling them
> wrong, it must be something wrong within the settings of koha and i just
> can't figure it out.
> I have looked at MANY tutorials online too! and none of them seem to have
> the solution. i have even followed them step by step and the barcode still
> does not appear for me and it appears for them.
>
> i have attached the image below (but obviously i scribbled out the patron
> names for GDPR reasons).
>
> If someone could please help me with this!!!
>
> Kind regards,
> HH
>
> --
> Noorul Uloom (formerly Markaz Uloom Girls) Park Lee Rd, Blackburn, BB2 3NY
>
>
>
> Main Office: 01254 581569
>
> General enquiries: i...@mugirls.org.uk
> 
>
> Noorul Uloom is *an independent school
> registered with the Department for Education (DfE No. 889/6016, Ofsted
> URN:
> **147604**)*
>
> Noorul Uloom operates under Markazul Uloom (Trust), which is
> a registered charity in England and Wales (Charity No. 1090525)
> ___
>
> 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] Re: Username and Password Missing after Logoff and Shutdown?

[Indranil Das Gupta]

On Wed, 18 Nov, 2020, 4:13 am Charles Kelley,  wrote

Yes, of course. I was just wondering what would happen to the current
> superduper.
>

Nothing. Stays dormant. Usually what most of my users do is to create a new
superlibrarian acct, log in using the new account, change the old
superlibrarian password, log out and log in back with the earlier account
with its reset password.

Hope this helps
Indranil


> > *Actually, you don't need a red cape.
> >
>
> We budgeted for a few. I think we'll get one.
>
> --
>
> 気を付けて。 /ki wo tukete/ = Take care.
>
> -- Charles.
>
> Charles Kelley, MLS
> PSC 704 Box 1029
> APO AP 96338
>
> Charles Kelley
> Tsukimino 1-Chome 5-2
> Tsukimino Gaadenia #210
> Yamato-shi, Kanagawa-ken
> 〒242-0002 JAPAN
>
> +1-301-741-7122 [US cell]
> +81-80-4356-2178 [JPN cell]
>
> mnogoja...@aol.com [h]
> cmkelley...@gmail.com [p]
>
> linkedin.com/in/cmkelleymls 
> Meeting Your Information Needs. Virtually.
> ___
>
> 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] Regarding KOHA reports

[Indranil Das Gupta]

Hi Anju,

Here you go https://wiki.koha-community.org/wiki/SQL_Reports_Library

Best wishes

Indranil Das Gupta
L2C2 Technologies

On Fri, 6 Nov, 2020, 10:35 am ANJU SAINI,  wrote:

> Hello everyone
> I just installed KOHA software . Anyone send me SQL for all reports . Any
> help would be very much appreciated!
> ___
>
> 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] Downgrade to 19 from 20

[Indranil Das Gupta]

No such Downgrading HOWTO exists AFAIK.

The standard technique would be as follows:

1) Keep a copy of 19.XX database handy. And note down your Koha instance
name with sudo koha-list.

NB if you have more than one instance, pls ensure you note down the correct
instance name.

2) Format your system and install Koha after setting apt to point either at
oldstable (for 19.11) or oldoldstable (for 19.05) .

3) Run koha-create --create-db  where instancename is your
old koha instance name from step #1

4) import the old database into the newly created instance.

5) either run the koha-upgrade-schema script from the terminal OR let the
Koha web installer do is magic.

If you have successfully completed steps 1 to 5 above, you will be back
with your old version of 19.XX.


Hope this helps

Indranil Das Gupta
L2C2 Technologies


On Fri, 6 Nov, 2020, 8:39 am Father Vlasie,  wrote:

> Hello all,
>
> Is there an official guide for downgrading Koha to the previous version?
>
> I am having some serious trouble with my 20.05.05.000 install and I would
> like to go back to 19. Are there any database changes between these two
> versions?
>
> Thank you!
>
> FV
>
> ___
>
> 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] Zebra printers and workflow

[Indranil Das Gupta]

Hi Chad,

Have used quite a few Zebra and TSC label printers with both polyester and
paper label stocks with Koha. Just needed to design the template as per
size of the label.

cheers
Indrani

On Tue, 27 Oct, 2020, 11:07 pm Chad Roseburg,  wrote:

> Hello fellow Koha-ites ~
>
> We have been using dot matrix printers for labels since time beyond the
> memory of any human now living. Supplies for these will be discontinued in
> 2021.
>
> We plan to migrate to Zebra/Thermal printers and I'm wondering what models
> you've had great success with and what your software/workflow looks like.
>
> Thank you!!!
>
> Chad
>
> --
> Chad Roseburg
> Assoc. Director / IT
> Automation Dept.
> North Central Regional Library
> ___
>
> 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] [koha] Koha and opac not loading

[Indranil Das Gupta]

Hi James,

Individually check and ascertain whether apache, mysql / mariadb, memcached
services are working ok. Also check if plack is working if you have it
enabled.

Once you have made sure these are working, I would suggest the you check
the logs.

The opac and intranet error logs should have something useful in them, if
you are trying to hit them and getting  nothing in response.

I would also check the iptables rules in place as well as any firewall you
may have at your place.

Hope this helps
Indranil.

On Thu, 15 Oct, 2020, 10:33 pm King, Fred,  wrote:

> Well, over on MEDLIB-L (the medical librarians’ listserv) we’d probably
> blame it on a squirrel. I’m afraid I’m out of ideas.
>
> Esteemed colleagues, any ideas?
>
> 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
>
> Suddenly virologists are cool. This is a bad sign.
> --Paul Offit
>
> From: muiru james 
> Sent: Thursday, October 15, 2020 12:52 PM
> To: King, Fred 
> Cc: koha 
> Subject: Re: [EXTERNAL] [Koha] [koha] Koha and opac not loading
>
> ** 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.
> Hey King Fred,
>
> I have tried afew things like rebooting the server and restarting apache
> which have not worked.
>
> I can ping the server and log in directly and access other sites. I'll try
> the ncdu. I wonder if its space issues with my 1TB internal storage showing
> its 35GB full.
>
> Any other pointers towards a solution will be most appreciated.
>
> Regards
> James
>
>
> On Thu, Oct 15, 2020, 17:38 King, Fred  fred.k...@medstar.net>> wrote:
> You've probably tried all this and I'm explaining the obvious and this is
> all based on Ubuntu, but...:
>
> Can you ping the server? (command is "ping" plus the ip address or domain
> name. Hit CTRL-C to stop) . No response means the server can't be reached.
> Reboot the server. That works more often than one might think.
> Can you log into the server directly?
> Has the server filled up with logs and other files? If you can get to the
> server's command line, try going to the root directory and typing "ncdu".
> (You may have to install it with "sudo apt install ncdu" which won't work
> if there's no space left at all.) NCDU tells you the space used in each
> directory. It's not always accurate, but it's a start.
>
> Clearly I suspect the server, but can you connect to sites other than your
> Koha instance with your computer? Maybe a mouse chewed through your network
> cable. I hear they're yummy!
>
> Good luck!
>
> 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<
> https://urldefense.proofpoint.com/v2/url?u=http-3A__medstarauthors.org=DwMFaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=JGKGivsAGDJdj3uLDfl91JnE3J47a17Y-nZ-OZBJD98=MxZXgAiYhNuGIJmjc7nWOwDlD_FxWKs1zA1EywkawUE=
> >
>
> Suddenly virologists are cool. This is a bad sign.
> --Paul Offit
>
> -Original Message-
> From: Koha  koha-boun...@lists.katipo.co.nz>> On Behalf Of muiru james
> Sent: Thursday, October 15, 2020 6:46 AM
> To: koha mailto:koha@lists.katipo.co.nz>>
> Subject: [EXTERNAL] [Koha] [koha] Koha and opac not loading
>
>  ** 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.
>
> Hello team,
>
> My koha instance and opac are not loading. The page tries loading for
> awhile then shows unable to connect message.
>
> What could be wrong?
>
> The server has been on but we have been closed since March so nothing has
> been tampered with. We intend to resume operations come monday so this is
> very critical
>
> Please assist
>
> Warm regards
> James
> ___
>
> Koha mailing list
> https://urldefense.proofpoint.com/v2/url?u=http-3A__koha-2Dcommunity.org=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=aAb8fYlcPuUaugYCRkWvG6hIOzgAVRijy62HPmRK7Pk=AdPanDAlbq9CKEI7wiXYXfTj1S_xPzh3j0wVJf3zBAY=
> Koha@lists.katipo.co.nz
> Unsubscribe:
> https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.katipo.co.nz_mailman_listinfo_koha=DwIGaQ=RvBXVp2Kc-itN3g6r3sN0QK_zL4whPpndVxj8-bJ04M=vKh6XwOmjyC51IkP1OfsdjQZoWT2vpi6VZl8El8EPRI=aAb8fYlcPuUaugYCRkWvG6hIOzgAVRijy62HPmRK7Pk=kF0-ZfCtT0trNnFL_CX12x19DG0D3aDeQQ361mrEmWU=
>
> --
> MedStar Health is a not-for-profit, integrated healthcare delivery system,
> the largest 

Re: [Koha] Where are subtitles stored?

[Indranil Das Gupta]

Hi Randy,

the subtitle aka 245$b is being populated front the actual marcxml record
stored for each bib in the biblio_metadata table.

Thus, in order to fetch the subtitle in your SQL report, you will need to
pull it out of the marcxml data using the ExtractValue XML function in
MySQL / MariaDB.

If case you are not familiar with the syntax to use, the Koha SQL Reports
library on the koha wiki has several examples of this.

Cheers,
Indranil

On Fri, 2 Oct, 2020, 3:53 am Randy Wright,  wrote:

> We migrated to Koha two years ago by importing MARC records from our old
> system. Recently I was asked to do a report which included both titles and
> subtitles. According to my mapping, this should be 245$a and 245$b mapped
> to biblio.title and biblio.subtitle, respectively. I find that there is
> nothing in any of the biblio.subtitle fields of the imported records. There
> is data in biblio.subtitle for the items we have added from within Koha
> after the import. I have checked the MARC records file we imported, and
> 245$a and 245$b are populated correctly. What puzzles me is that the OPAC
> shows the subtitles correctly for everything. Where would it be getting the
> data, if not from biblio.subtitle?
>
> Randy Wright
>
> Information Resource Steward
> Santa Barbara Botanic Garden Blaksley Library
> 1212 Mission Canyon Road
> Santa Barbara CA 93105
>
> 805-682-4726 x107
>
> www.sbbg.org
> www.sbbgphotos.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] SQL help

[Indranil Das Gupta]

You didn't mention your koha version. That's kinda necessary info if you
are trying to extract from marcxml

-indranil

On Wed, 19 Aug, 2020, 7:42 pm Patricia Dowling, <
patricia.dowl...@oireachtas.ie> wrote:

>
> I wonder if anyone in the community can steer me on this basic SQL query?
> I am a very novice SQL user so apologies in advance!
>
> I want to get a list of bibnumbers for all records with a value of “Irish
> Office pamphlets” in the 440a tag (series) with title, author and
> publication date so that I can export this list to excel as a csv file.
>
> I have had a look around the Reports Library but got bogged down between
> the various tables biblio, items, marcxml etc.)
>
> Thanks in advance!
> Patricia
>
>
>
> Patricia Dowling,
> Research Librarian,
> Oireachtas Library & Research Service,
> Leinster House,
> Dublin 2,
> Ireland
> patricia.dowl...@oireachtas.ie
> tel: (01) 6184311
> Central Enquiry Desk: Tel. 00 353 1 6184701
> Email library.and.resea...@oireachtas.ie library.and.resea...@oireachtas.ie>
>
>
>
>
>
>
>
>
>
>
>
>
> 
>
> Oireachtas email policy and disclaimer.
> http://www.oireachtas.ie/parliament/about/oireachtasemailpolicyanddisclaimer/
>
>
> Beartas ríomhphoist an Oireachtais agus séanadh.
> http://www.oireachtas.ie/parliament/ga/eolas/beartasriomhphoistanoireachtaisagusseanadh/
> ___
>
> 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] Quarantine / Cart problem with 18.11.04 version.

[Indranil Das Gupta]

Hi Raymund

The cron job that Stephen mentions does a blind move i.e. the document
might still be physically in the cart but will be shown as available on
shelf as the cron job had ran.

Last year I wrote a small plugin where the library staff had to physically
scan the books once before moving them from cart to shelf and only then the
update was done. You can find it here
https://github.com/l2c2technologies/carttoshelf

There is also a video tutorial https://youtu.be/DJM3AuNWio4

You might find it useful.

Cheers
Indranil

On Mon, 10 Aug, 2020, 5:39 pm Raymund Delahunty, 
wrote:

> We are testing using the Cart functionality as we prepare to open the
> libraries again (looking to use a 72 hour quarantine) and are puzzled that
> only sometimes does the location change back from Cart to the former
> location which should be temporarily stored in the permanent_location
> field. Sometimes the reversion happens, sometimes the items stay at Cart,
> and sometimes (mostly!) the location left after the cart_to_shelf script
> runs is  and the data field is left empty. Anyone else finding
> this? (Every item in our database has the location data field populated.)
> Ray Delahunty
> University of the Arts London
>
>
>
> .
> This email and any attachments are intended solely for the addressee and
> may contain confidential information. If you are not the intended recipient
> of this email and/or its attachments you must not take any action based
> upon them and you must not copy or show them to anyone. Please send the
> email back to us and immediately and permanently delete it and its
> attachments. Where this email is unrelated to the business of University of
> the Arts London or of any of its group companies the opinions expressed in
> it are the opinions of the sender and do not necessarily constitute those
> of University of the Arts London (or the relevant group company). Where the
> sender's signature indicates that the email is sent on behalf of UAL Short
> Courses Limited the following also applies: UAL Short Courses Limited is a
> company registered in England and Wales under company number 02361261.
> Registered Office: University of the Arts London, 272 High Holborn, London
> WC1V 7EY
> ___
>
> 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] Sending message to Users using Send List Options in lists Menu!

[Indranil Das Gupta]

Hi Swamy,

Koha mailing list does not allow attachments.

Pls upload the images on a publicly accessible site e.g. imagebin and share
the link

Cheers
-idg

On Sat 14 Mar, 2020, 3:37 PM Kuppu Swamy,  wrote:

> Dear Sir,
> I am providing regular keyword search services to my users by using " KOHA
> search the Catalogue Option" and stored the search results in separate
> files in Lists menu.I have a problem of disseminating this information  by
> sending E-Mail to the respective students/faculty of our University
> I have encountered with an error message while Sending message to Users
> using Send List Options in lists Menu.
> The respective screen shots are enclosed for your reference,help and
> advice.
> With regards
> S.Kuppuswamy,
> *Librarian*
> *Jain University - International Institute for Aerospace Engineering &
> Management  ,Bangalore,INDIA*
>
> *E-Mail :kuppu.ii...@gmail.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

Re: [Koha] Installation problem in Debian vps

[Indranil Das Gupta]

As per the Koha wiki Debian 10 support is a work-in-progress. Debian 9 is
the recommended supported version.

Hope this helps
Indranil Das Gupta
L2C2 Technologies

On Sat 14 Mar, 2020, 8:58 AM seatry1999,  wrote:

> Hi guys, I have an installation problem in * Debian GNU/Linux 10* vps.
> So, I have followed the instructions in
> https://wiki.koha-community.org/wiki/Koha_on_Debian.
> After entering *$ sudo apt-get install koha-common*, there are a lot of
> errors about BDB::mysql,
> mostly about X table doesnt found.
>
> Here is a clip of the error:
>
> Upgrading database schema for testlibrary
> DBD::mysql::db do failed: Table 'koha_testlibrary.systempreferences'
> doesn't
> exist [for Statement "
> SELECT * FROM systempreferences WHERE 1 = 0 "] at
> /usr/share/koha/lib/Koha/Database.pm
>  line 114.
>
> What can I do to eliminate the error and install and configure Koha in my
> vps? Thanks for your attention
>
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
>
> 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] problem Loading of checkout books for circulation

[Indranil Das Gupta]

Hi,

It's most likely due to a DataTables error. Check your browser's JavaScript
console for errors.

A similar issue has been described here
http://blog.l2c2.co.in/index.php/2019/12/29/datatables-debugging/

Hope this helps,

Indranil Das Gupta
L2C2 Technologies.

On Sun 26 Jan, 2020, 9:42 AM Nur Ahammad,  wrote:

> Hi all,
> When I do the circulation of books, my koha showing " Loading ... You may
> continue scanning" but showing the circulation books.  Please see the
> following link
>
> https://drive.google.com/file/d/0B7hpDgEcnVrVUWw4LThtR0s4QXdzN1ZqUTNqVklpd3pqZ1Yw/view?usp=sharing
> --
> Nur Ahammad
> Senior Assistant Librarian
> +8801816188851
> Daffodil International University
>
>
> *Read to Know. Read to Learn. Read to Lead*
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [koha] Edited barcodes not saving

[Indranil Das Gupta]

Hi

The intranet error logs are available under /var/log/koha//
as intranet-error.log

Often the usual technique is to tail the file while executing the steps
that are known to trigger the error.

hope this helps

Indranil Das Gupta
L2C2 Technologies

On Mon 4 Nov, 2019, 10:00 AM muirunyeri,  wrote:

> Hello Owen,
> Thanks for getting back to me on my query and sorry for not replying
> sooner.
> We are using version 17.05.
> There are no upgrades to koha, Mysql or the server. There are no changes
> whatsoever and no one has accessed the server.
> Kindly guide me on how to access the error logs and I will do so.
> Am very grateful for any assistance
> Thank you
>
> Sent from my Samsung Galaxy smartphone. Original message
> From: Owen Leonard  Date: 31/10/2019  14:43
> (GMT+03:00) To: muiru james  Cc: koha <
> koha@lists.katipo.co.nz> Subject: Re: [Koha] [koha] Edited barcodes not
> saving
> >  Over the last few days, the new barcode is not saving  i.e. after
> > saving the old number is still showing instead of the new one.
>
> What version of Koha are you using? Has anything changed which might
> be linked to this problem? A server upgrade, Koha upgrade, MySQL
> upgrade?
>
> Do you have access to Koha's error logs?
>
>  -- Owen
>
> --
> Web Developer
> Athens County Public Libraries
> (740) 737-6006
> https://www.myacpl.org
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Deny staff patrons permission to check in items issued to them.

[Indranil Das Gupta]

Hi James

Circulation in koha (more specifically checkout aka issue) is controlled
via a combination of 3 parameters: the branch, the borrower category and
the itemtype.

Library staff level operational granularity is not a function of Koha at
the moment.

Hope this helps

Indranil Das Gupta
L2C2 Technologies


On Fri 25 Oct, 2019, 9:48 AM muirunyeri,  wrote:

>
> Hello team,
> Our library staff are allowed to borrow upto 5 items. Either junior books
> or adult books.
>  We are looking for setting in koha that only allows the chief librarian
>  ability to checkin or checkout items to the staff patrons and deny any
> other staff from doing it. We also want to ensure that  staff donot checkin
> items issued to them.
> We also are in the process of introducing a new item type- Laptops and
> tablets and would like them issued by a particular staff e.g. I.T. clerk.
> How can we set this in koha?.
> We are using koha version 17.05
> Someone please help.
> Warm regards.
> James
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha installation woes

[Indranil Das Gupta]

Hi Carlos,

On Mon 21 Oct, 2019, 10:33 AM Carlos Lopez,  wrote:



(so we're configuring for IP address access),
>
> Can anyone point us to where we've gone wrong?
>

Did you setup the following lines in /etc/apache2/ports.conf:

Listen 8080
Listen 80

And restart Apache2 service?

Cheers
Indranil Das Gupta
L2C2 Technologies
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Bill Number and Bill date

[Indranil Das Gupta]

Hi

Unless you are using the acq module, you might want to use the item
holdings non-public note sub-field - 952$x.

Hope this helps

-Indranil Das Gupta
L2C2 Technologies

On Tue 15 Oct, 2019, 1:51 PM Yatheesh lis,  wrote:

> Hi
>
> Can anyone suggest where we have enter this details in koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] too many items

[Indranil Das Gupta]

Hi

Use MarcEdit to merge the individual 952 subfields of a holding record into
a single field. The key subfields are 952 $a, $b, $o, $p and $y (plus
anything else you may have)

In MarcEdit Editor it should look like

=952 \\$a$b
$o$p$y

instead of like:

=952  \\$a
=952  \\$b
=952  \\$o
=952  \\$p
=952  \\$y

Hope this helps

-idg

On Sat 12 Oct, 2019, 2:46 PM ICTPROJEKT PAWEL NIEDZWIADEK, <
pa...@ictprojekt.pl> wrote:

> Hi everyone,
>
> I imported MARC records prepared in MarcEdit into my Koha. Almost
> everything is ok. But there is a problem with items. When I see
> bibliographic record, there are 3 items connected with this record: one
> with price, one with callnumber and third with barcode. I would like to
> have only one 
>
> Any suggestions?
>
> Best regards
>
> Paweł Niedźwiadek
> pa...@ictprojekt.pl
> Poland
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Auto Reminder Through Email

[Indranil Das Gupta]

Hi,

On Sat 12 Oct, 2019, 1:18 PM rizwan qureshi, 
wrote:

> Hi Dear,
>
> I am working in University Library and using KOHA software for library
> material management. There is a problem regarding over dues books, I want
>

First, the name is 'Koha'. It's a proper noun and not an acronym. It's
wrong to write it capitalised as "KOHA" in a sentence.

Second, the correct way to request for help on the list is to inform the
*exact* version of Koha and operating system you are running at the moment
where you are facing issues.

to send patron over due or long due library material's reminder via email
> generated by KOHA software.
>

Third, regarding your question:

(a) Have you enabled email for your Koha instance?

(b) If your answer to "a" above is 'Yes', then do you have a MTA aka mail
server (e.g. Postfix) running?

(c) if the mail server is running is it able to deliver other mails e.g.
test mails, apart from Koha emails correctly?

(d) if your answer to "a", "b" and "c" are YES, then are only the ODUE and
long overdue mails not getting sent OR is it that no email from Koha is
being sent out?

Based on your answers to the above, the problem can be isolated and
identified.

cheers
-idg

>
> In this regards I need some help from your side.
>
> Best
>
> Sunny.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Unable to Access Koha # Critical

[Indranil Das Gupta]

Satish,

Just a hunch... Pls check free diskspace

Regards
-indranil

On Tue 3 Sep, 2019, 12:12 PM SATISH,  wrote:

> Hi,
>
> With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with
> MySQL -  mysql Ver 14.14 Distrib 5.5.57
>
> I am not able to access to Koha Server. however, I can connect to System
> (from SSH, putty).
> I am unable to connect to mysql database. I am not sure about any reason,
> because, it was running successfully and only during weekend (sunday),
> system was not accessed.
> but, when I tried to access Koha for Checkout and Checkin today, I am
> facing problem
> It is very critical for me to get this fixed, as it is  a busy day for
> users and for me.
> Kindly help to fix this error. I am looking forward to hearing from you.
>
>  #Critical Problem #Priority 1
>
> So for I tried to know the status of MySQL: (as 'root' user)
>
> 1) mysql login
> 
> mysql -u root -p
> Enter password:
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (2)
>
> 2) Mysql Status
> ---
> service mysql start
> start: Job failed to start
>
>
> 3) System Log Verification
> 
>  tail -f syslog
> Sep  3 11:07:42 gechlibrary bluetoothd[786]: Failed to init time plugin
> Sep  3 11:07:42 gechlibrary kernel: [0.00] Linux version
> 3.13.0-91-generic (buildd@lgw01-35) (gcc version 4.8.4 (Ubuntu
> 4.8.4-2ubuntu1~14.04.3) ) #138-Ubuntu SMP Fri Jun 24 15:58:13 UTC 2016
> (Ubuntu 3.13.0-91.138-generic 3.13.11-ckt39)
> Sep  3 11:07:42 gechlibrary kernel: [0.00] KERNEL supported cpus:
> Sep  3 11:07:42 gechlibrary bluetoothd[786]: Failed to init alert plugin
> Sep  3 11:07:42 gechlibrary kernel: [0.00]   Intel GenuineIntel
> Sep  3 11:07:42 gechlibrary bluetoothd[786]: Failed to init thermometer
> plugin
> Sep  3 11:07:42 gechlibrary kernel: [0.00]   AMD AuthenticAMD
> Sep  3 11:07:42 gechlibrary bluetoothd[786]: Failed to init gatt_example
> plugin
> Sep  3 11:07:42 gechlibrary kernel: [0.00]   NSC Geode by NSC
> Sep  3 11:07:42 gechlibrary bluetoothd[786]: Bl
>
> 4) PID
> ps aux | grep mysqld
> root  3603  0.0  0.0   4688   832 pts/2S+   11:19   0:00 grep
> --color=auto mysqld
>
> 5) MySQL log
> -
> /var/log/mysql/error.log
> is empty
>
>
> 6) MySQL Status
> --
> # mysqld status
> 190903 11:30:48 [Warning] Using unique option prefix key_buffer instead of
> key_buffer_size is deprecated and will be removed in a future release.
> Please use the full name instead.
> 190903 11:30:48 [Warning] The syntax '--log-slow-queries' is deprecated and
> will be removed in a future release. Please use
> '--slow-query-log'/'--slow-query-log-file' instead.
> 190903 11:30:48 [Warning] Can't create test file
> /var/lib/mysql/gechlibrary.lower-test
> 190903 11:30:48 [Note] mysqld (mysqld 5.5.57-0ubuntu0.14.04.1-log) starting
> as process 4036 ...
> 190903 11:30:48 [Warning] Can't create test file
> /var/lib/mysql/gechlibrary.lower-test
> 190903 11:30:48 [Warning] Can't create test file
> /var/lib/mysql/gechlibrary.lower-test
> 190903 11:30:48 [Warning] Using unique option prefix myisam-recover instead
> of myisam-recover-options is deprecated and will be removed in a future
> release. Please use the full name instead.
> 190903 11:30:48 [Note] Plugin 'FEDERATED' is disabled.
> 190903 11:30:48 InnoDB: The InnoDB memory heap is disabled
> 190903 11:30:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 190903 11:30:48 InnoDB: Compressed tables use zlib 1.2.8
> 190903 11:30:48 InnoDB: Using Linux native AIO
> mysqld: Can't create/write to file '/tmp/ibg0My0n' (Errcode: 30)
> 190903 11:30:48  InnoDB: Error: unable to create temporary file; errno: 30
> 190903 11:30:48 [ERROR] Plugin 'InnoDB' init function returned error.
> 190903 11:30:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
> failed.
> mysqld: Too many arguments (first extra is 'status').
> Use --verbose --help to get a list of available options
> 190903 11:30:48 [ERROR] Aborting
>
> 190903 11:30:48 [Note] mysqld: Shutdown complete
>
> --
> *Satish MV*
> Librarian - Govt. Engineering College
> Opp. Dairy Circle, B.M.Road, Hassan 573 201
> Karnataka, INDIA
> Mobile: +91 9449765737
> Personal Email: lis4sat...@gmail.com
> College Website: www.gechassan.ac.in
> Library OPAC: http://library.gechassan.ac.in
> Library Portal :  https://librarygechassan.wixsite.com/library
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha upgrade from 3.2 to 19.05

[Indranil Das Gupta]

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
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to add more text fields in the patron card creator tool

[Indranil Das Gupta]

Hi Larisa

The patron card creator tool picks up fields from the borrowers table. So
what ever fields are in the borrowers table you can add them.

Hope this helps
Indranil

On Sat 22 Jun, 2019, 3:03 PM Larisa Snabi,  wrote:

> Hello everyone,
> I would like to know if we can add more text fields in the patron card
> creator tool under the layout options.
> Thank you
> Snabi
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Expiring in-transit holds

[Indranil Das Gupta]

+1

On Fri 21 Jun, 2019, 3:34 PM Nick Clemens, 
wrote:

> Hi All,
>
> I filed bug 21181 with the following scenario:
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21181
> 1 - Patron places a hold, sets 'not needed after' to July 1
> 2 - Hold is put in transit
> 3 - Time passes, it is now July 2
> 4 - Cancel expired holds cron does not cancel hold - found='W'
> 5 - Hold arrives at destination on July 3
> 6 - Hold is trapped, patron is notified
>
> Does everyone agree this hold should be cancelled?
>
> Thanks,
> Nick
>
> --
> Nick Clemens
> ByWater Solutions
> bywatersolutions.com
> Phone: (888) 900-8944
> Pronouns: (he/him/his)
> Timezone: Eastern
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha backup vs -SQL backup

[Indranil Das Gupta]

On Thu 20 Jun, 2019, 8:13 PM Yatheesh lis,  wrote:

> Hi
>
> 1) what is deferencece B/w Koha backup vs -SQL backup.
>

None. It's the same MySQL database if you are talking about the database
backup generated by koha-run-backups script. However, the defaults used may
be different, for example whether syntaxes like "CREATE IF NOT EXIST" are
incorporated OR not in the backup etc.

2) I have taken backup through koha and imported other system but it shows
> only biblio records with out any item details why?
>

Most likely case, that somehow the branchcode (s) defined are different
from the backup.

In case you are talking about *MARC* backup rather than a full db backup,
then either (a) your branchcodes are not same between the instances OR (b)
you have only exported the bibs and *not* the items.


3) to import -SQL backup should I know database name?
>

Yes.

Cheers

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

Re: [Koha] Data migration from SOUL 1 to Koha (Overdue List)

[Indranil Das Gupta]

Dixson,

The answer to that depends on what you are trying to achieve - (a) just get
the currently checked out items into Koha's issues table or (b) "a" +
generate account lines entries for outstanding fines as well.

No direct scripts per se is bundled with Koha. But using a .koc file is an
option.

In our case, we have developed custom perl scripts that calls on Koha's
circ sub-routine libs to do the heavy lifting for us. The prime benefit
being that all FK referential integrity gets taken care of.

cheers
Indranil.

On Sat 15 Jun, 2019, 10:21 AM Dixson Rodriges, 
wrote:

> Hi Good Morning,
>
> Sub:Data migration from soul
>
> Is there any option to upload the overdue list into koha ?. or any script
> for back-end to upload the due list.
>
> Regards,
> Dixson
>
> On Mon, 2019-06-03 at 19:56 +0530, Indranil Das Gupta wrote:
>
> Hi Dixson,
>
> Based on last several years of experience of migrating plenty of both SOUL
> v1 and v2 data to Koha, I would suggest that the cleanest way to do it is
> to use the SQL Server database of SOUL v1 to extract the data a table at a
> time, clean it up, then use joins to create the actual data set we need to
> put through MarcEdit.
>
> Just 2 weeks back, migrated a v1 db to Koha. The above processes took
> about 15 hours.
>
> Hope this helps
>
> Indranil Das Gupta
> L2C2 Technologies
>
> On Mon 3 Jun, 2019, 6:46 PM Dixson Rodriges, 
> wrote:
>
> Hi,
>
>
> Is there any option to export the data from SOUL 1 to Koha ? How to
> export bulk CCF format data from soul 1.
>
>
> Regards,
> Dixson
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Using Koha for school textbook loan scheme

[Indranil Das Gupta]

Yes. This is fairly standard stuff. Here in India we often have semester
long loan of a fixed number of books for students coming from economically
backward strata. Books thus lent usually use a custom item type typically
called as Book Bank (and therefore with an item type code of BBK). These
students are also allowed to borrow other books (same as rest of the
students) aside from the BBK item type material.

Hope this helps
Indranil Das Gupta
L2C2 Technologies

On Tue 11 Jun, 2019, 4:06 PM doheochai,  wrote:

> Hi -
>
> I am the IT coordinator in a school in Ireland (by coordinator it doesn't
> mean that I know anything about IT).
>
> Our school intends to implement a school textbook loan scheme in order to
> reduce the cost of providing school textbooks for parents. I search for
> information but the only thing I could find went back to 2009.
>
> We have between 90-130 students per year group and each student would be
> receiving approx 15 different textbooks. The students would be entitled to
> retain the books for 1-3 years depending on their course cycle. Our
> intention is to barcode each copy of the textbook and scan it as it is
> issued to each student. We need to be able to generate year group
> lists/reports for each textbook and lists of which books are outstanding
> and
> to which student at the end of each course cycle.
>
> Simple question - I hope - is it possible to use Koha in this way?
>
> Thanking any responses in advance - I would really appreciate some help
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Data migration from SOUL 1 to Koha

[Indranil Das Gupta]

Hi Dixson,

Based on last several years of experience of migrating plenty of both SOUL
v1 and v2 data to Koha, I would suggest that the cleanest way to do it is
to use the SQL Server database of SOUL v1 to extract the data a table at a
time, clean it up, then use joins to create the actual data set we need to
put through MarcEdit.

Just 2 weeks back, migrated a v1 db to Koha. The above processes took about
15 hours.

Hope this helps

Indranil Das Gupta
L2C2 Technologies

On Mon 3 Jun, 2019, 6:46 PM Dixson Rodriges, 
wrote:

> Hi,
>
>
> Is there any option to export the data from SOUL 1 to Koha ? How to
> export bulk CCF format data from soul 1.
>
>
> Regards,
> Dixson
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Problem in fine calculation in Koha LMS Release 16.11

[Indranil Das Gupta]

Hi

What is the setting of "finesmode" system preference?

Cheers
Indranil Das Gupta
L2C2 Technologies

On Fri 10 May, 2019, 4:37 PM Dr. SK Gupta,  wrote:

> Sir/Madam
>
> we are facing problem with fine calculation in Koha LMS. Even though all
> the information is filled in circulation and fine parameters, Koha is not
> calculating fine for patrons. Kindly help in resolving the issue
>
> Thanks & Regards
>
> --
> *C**e**ntral Library*
> *SKUAST-Jammu*
> *Main Campus, Chatha-180009*
> *e-mail: clskua...@gmail.com *
> *Telefax: 0191-2262037*
>
>
> *Confidentiality Notice: *T*his electronic message transmission, including
> any attachment(s), may contain confidential, proprietary, or privileged
> information from the sender on behalf of  Sher-e-Kashmir University of
> Agricultural Sciences and Technology of Jammu . If you are not the intended
> recipient, be advised that any dissemination, copying, distribution,
> printing or use of the contents of the information contained in this
> electronic message is strictly prohibited. If you have received this
> electronic message by error, please destroy all copies of the message and
> contact the sender immediately by either replying to this message or
> calling 91-191-2262037/9419277711.*
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Book cover display from Amazon india koha 18.5

[Indranil Das Gupta]

Try koha 18.11 for Amazon India support.

Images are mapped to ISBNs. So having the image on the Amazon website is
not a guarantee on display unless your ISBN matches exactly.

On a side note, you can always use the LocalImages facility for situations
like this.

Cheers
Indranil Das Gupta
L2C2 Technologies



On Fri 10 May, 2019, 4:21 PM Yatheesh lis,  wrote:

> Dear all,
>
> Koha 18.5  unable show few Book cover even these cover available on Amazon
> website special indian books.
>
> There is no option available (Amazon india)
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Problem with upgrading Koha from 17.11 to 18.11

[Indranil Das Gupta]

Keep the browser console on while you reload the page and see what errors
show up.



On Fri 22 Mar, 2019, 11:17 PM Daniel Owens,  wrote:

> Thank you Indranil and Beda for the suggestion to clear my browser
> cache. I did clear the browser, but the page still has no styling.
>
> Any other ideas?
>
> Daniel
>
>
> On 3/22/19 10:40 AM, Indranil Das Gupta wrote:
> > Hi Daniel,
> >
> > Did you do *the* one mandatory step after every major version upgrade
> > - clear your browser cache?
> >
> > Hope this helps
> > Indranil Das Gupta
> > L2C2 Technologies
> >
> > On Fri 22 Mar, 2019, 8:59 PM Daniel Owens,  > <mailto:dcowen...@gmail.com>> wrote:
> >
> > I just upgraded from 17.11 to 18.11. Afterward, both the staff client
> > and OPAC display very basic HTML, with no styling. The staff client
> > login looks like this:
> >
> >
> >   Koha <http://koha-community.org/>
> >
> > Username:
> >
> > Password:
> >
> > Library:
> >
> >   * English
> >   * Tiếng Việt
> >
> > <
> http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN
> >
> >
> > I can log in to the staff client, and I can run searches in OPAC, but
> > the pages are not displaying correctly. It is almost as if
> > stylesheets
> > were not included in the upgrade.
> >
> > Can anyone suggest how I can troubleshoot this problem?
> >
> > Daniel
> > ___
> > Koha mailing list http://koha-community.org
> > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Problem with upgrading Koha from 17.11 to 18.11

[Indranil Das Gupta]

Hi Daniel,

Did you do *the* one mandatory step after every major version upgrade -
clear your browser cache?

Hope this helps
Indranil Das Gupta
L2C2 Technologies

On Fri 22 Mar, 2019, 8:59 PM Daniel Owens,  wrote:

> I just upgraded from 17.11 to 18.11. Afterward, both the staff client
> and OPAC display very basic HTML, with no styling. The staff client
> login looks like this:
>
>
>   Koha <http://koha-community.org/>
>
> Username:
>
> Password:
>
> Library:
>
>   * English
>   * Tiếng Việt
> <
> http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN
> >
>
> I can log in to the staff client, and I can run searches in OPAC, but
> the pages are not displaying correctly. It is almost as if stylesheets
> were not included in the upgrade.
>
> Can anyone suggest how I can troubleshoot this problem?
>
> Daniel
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Plugins disabled!

[Indranil Das Gupta]

Did you restart plack and memcached?

Just a thought.

On Thu 14 Mar, 2019, 5:02 PM ikbar,  wrote:

> i do what you tolgd me but the result is still same
>
> i do Change 0 to
> 1 in your koha-conf.xml file
>
> and restart web
>
> and do change setting at koha systme preference that to enable plugin.
>
> pls help me
>
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Suggest stable release of koha

[Indranil Das Gupta]

Short answer: 18.11

Long answer: Koha versions are numbered in YY.MM format (since May 2016).
There are two major version releases every year - in May (05) and November
(11).

So anytime you need to know the answer to this question, take a look at the
calendar.

The other part of your question - "bug free" - there is absolutely NO
software in the world ever that can claim that status. The best one can
describe it is "no known bugs".

Hope this helps
Indranil Das Gupta
L2C2 Technologies

On Wed 13 Mar, 2019, 11:51 PM vijay kumar,  wrote:

> Dear all,
> We want to install koha latest bug free release for our library.
> Please suggest latest stable release.
>
> With regards
> Vijay
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to import multiple copies?

[Indranil Das Gupta]

Hi Myriam,

The 952 field needs to be repeated for the same title.

If all your marc records have ISBN, you can use it to de-duplicate on that
using MarcEdit.

If you do not know how to do that you may want to read this -
http://blog.l2c2.co.in/index.php/2016/08/03/marcedit-quicktip-3-getting-your-952-items-holdings-data-field-in-place-for-import-into-koha/

Hope this helps
-indranil

On Mon 11 Mar, 2019, 8:54 PM Myriam Torres, 
wrote:

> Hello,
>
> Do you know how can I import multiple copies from a Marc File into Koha?
> This is an example of my .mrc file, as you can see all the information is
> the same except the bar code:
>
> =LDR  01362nam a2200289Ia 45e0
> =005  $020190221144117
> =008  $0070215s2008miua\b001\0\eng
> =008  190311sxx000\0\und\d
> =020  \\$a9780310274407
> =040  \\$aDLC
> =040  \\$beng
> =040  \\$cDLC
> =040  \\$dDLC
> =082  \\$22nd ed
> =100  \\$aVyhmeister, Nancy J.
> =245  \0$aQuality research papers for students of religion and theology
> =245  \0$cNancy Jean Vyhmeister
> =260  \\$aGrand Rapids, Mich
> =260  \\$bZondervan
> =260  \\$cc2008
> =300  \\$axii, 264 p
> =300  \\$c23 cm
> =650  \\$aMusic appreciation.
> =942  \\$2ddc
> =942  \\$cBK
> =952  \\$2ddc$aAKL$bAKL$o200.72$p0018019$yBK
>
> =LDR  01243nam a2200229Ia 45e0
> =005  $020190221144117
> =008  $0070215s2008miua\b001\0\eng
> =008  190311sxx000\0\und\d
> =020  \\$a9780310274407
> =040  \\$aDLC
> =040  \\$cDLC
> =040  \\$dDLC
> =082  \\$22nd ed
> =100  \\$aVyhmeister, Nancy J.
> =245  \0$aQuality research papers for students of religion and theology
> =245  \0$cNancy Jean Vyhmeister
> =260  \\$aGrand Rapids, Mich
> =260  \\$bZondervan
> =260  \\$cc2008
> =300  \\$axii, 264 p
> =300  \\$c23 cm
> =650  \\$aMusic appreciation.
> =942  \\$2ddc
> =942  \\$cBK
> =952  \\$2ddc$aAKL$bAKL$o200.72$p29621$yBK
>
> Thank you
> --
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to define that library loan X copies are only for students enrolled in the X Library school.

[Indranil Das Gupta]

Hi Victor

Look up IndependentBranches system preference in the manual.

Hope this helps
-indranil

On Mon 11 Mar, 2019, 12:57 AM Victor Barroso Oliveira, 
wrote:

> Good afternoon,
> Considering Koha in a Bible Network.
> How to define that library loan X copies are only for students enrolled in
> the X Library school.
> When selecting a student enrolled in a Library the system is allowing to
> borrow from copies registered in other libraries that the student is not
> linked.
> How can I solve this?
> Thank you,
> Victor
>
> <
> https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail
> >
> Livre
> de vírus. www.avast.com
> <
> https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail
> >.
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [EXTERNAL] Serial numbering pattern for MMM dd, YYYY possible?

[Indranil Das Gupta]

Hi Heather,

Thanks! That's exactly what I did in the end. :-)

Thanks again for confirming that I wasn't alone in that fix and that I
route I finally took was a something even a seasoned Librarian would take
(I'm from tech).

FWIW I did put up a small video here - https://youtu.be/BTYzQ1NklcY

Cheers
Indranil

On Thu 7 Mar, 2019, 11:07 PM Hernandez, Heather, 
wrote:

> Hi, Indranil--
>
> We haven't had much luck with weekly pattern projection such as this--all
> our weekly serials have number-based volume and/or number "numbering," so
> we just project that numbering and then we manually add the date upon
> check-in.
>
> You might be able to use week numbering (based on there being 52 weeks a
> year) and then edit it upon check-in?  E.g., have it project "12" for the
> issue expected in the 12th week of the year (Mar. 18, 2019) and then when
> it arrives have the staff change the "12" to "Mar. 18, 2019?"  Kinda
> clunky, but it might work?
>
> I'd love to hear of a better solution, if one is out there!
>
> Cheerio!
> h2
> ~~
> Heather Hernandez (she, her, hers)
> Technical Services Librarian
> San Francisco Maritime National Historical Park Research Center
> 2 Marina Blvd., Bldg. E, 3rd floor, San Francisco, CA  94123-1284
> 415-561-7032, heather_hernan...@nps.gov
> Library catalog: http://keys.bywatersolutions.com/
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Serial numbering pattern for MMM dd, YYYY possible?

[Indranil Das Gupta]

Hi serials control gurus,

I'm trying to enter the subscription for a magazine - India Today. It is
(1/week), published on every Monday. The issues are numbered as "MMM dd,
"

I'm trying to generate a numbering pattern for it and is failing
miserably.. Is such a numbering even possible within the current serials
framework of Koha?

thanks in advance

Indranil Das Gupta
L2C2 Technologies

Phone : +91-98300-20971
WWW : http://www.l2c2.co.in
Blog: http://blog.l2c2.co.in
IRC : indradg on irc://irc.freenode.net
Twitter : indradg
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Contribute with plugin for frameworks

[Indranil Das Gupta]

Hi,

Usually Koha plugins (.kpz) are usually not a released as part of the Koha
codebase.

Contributors who write plugins, usually release these under Koha compatible
licence (GPL V3+) on GitHub etc.

Also you can submit your plugin to this list on koha wiki
https://wiki.koha-community.org/wiki/Koha_plugins

Hope this helps

Indranil Das Gupta
L2C2 Technologies


On Mon 18 Feb, 2019, 8:32 PM Italo Brasileiro, <
italo.barbosa.brasile...@gmail.com> wrote:

> Hello everyone,
>
> Can anyone tell me the procedure to contribute with plugins for frameworks
> in Koha? I recently developed a plugin for autocompletion of the Cutter
> field, using the author's name and/or title, using the Cutter-Sanborn
> table. How is the procedure to submit this plugin for evaluation and, if
> possible, include later in Koha?
>
> Thanks!
>
> --
> Ítalo Barbosa Brasileiro
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

[Indranil Das Gupta]

Hi

Please see the reference SQL reports listed here
https://wiki.koha-community.org/wiki/SQL_Reports_Circulation

You should be able to set up one to your requirements using these as reference.

regards
Indranil Das Gupta
L2C2 Technologies
--
Indranil Das Gupta
L2C2 Technologies

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

On Wed, Jan 23, 2019 at 10:17 AM MAMCET Library
 wrote:
>
> How to find a Books highest readers  in mysql   report.
>
> On Wed, Jan 23, 2019 at 9:45 AM Indranil Das Gupta  wrote:
>>
>> You cant do this using only Koha. You need to use an Analytics tools like 
>> PiWik / Matamo or an analytics service like Google Analytics. Or you wish to 
>> do it the old school way then you need to use a tool like AWstats.
>>
>> Hope this helps
>>
>> Indranil Das Gupta
>> L2C2 Technologies
>>
>> On Wed 23 Jan, 2019, 9:22 AM MAMCET Library,  
>> wrote:
>>>
>>> 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
>
>
>
> --
>  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

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

[Indranil Das Gupta]

You cant do this using only Koha. You need to use an Analytics tools like
PiWik / Matamo or an analytics service like Google Analytics. Or you wish
to do it the old school way then you need to use a tool like AWstats.

Hope this helps

Indranil Das Gupta
L2C2 Technologies

On Wed 23 Jan, 2019, 9:22 AM MAMCET Library, 
wrote:

> 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 mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Course Reserve information from customized report

[Indranil Das Gupta]

Hi Peter,

Koha's database schema is documented here version wise -
http://schema.koha-community.org/

hope this helps

Indranil Das Gupta
L2C2 Technologies

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

On Mon, Jan 21, 2019 at 6:57 AM Peter Lau  wrote:
>
> Dear Caroline,
>
>
>
> Great it works.
>
>
>
> May I know where I can find a list of dictionary or fields for the SQL?
>
> Thanks & regards,
>
> *Peter Lau*
>
> Librarian
>
> Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 23384320
>
>  [image:
> https://docs.google.com/uc?export=download=1wiYZQsqhNTJZjyNbLJx-6ODZyoYE5NNu=0BzpPRj4UE0XeT1R2WUt2dnhmTFBBeEpVR3dqcU5QbnF6NVg4PQ]
>
> 2 Tin Wan Hill Road, Tin Wan, Aberdeen
>
> *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk
>
>
>
> *From:* Caroline Cyr La Rose [mailto:caroline.cyr-la-r...@inlibro.com]
> *Sent:* Sunday, 20 January 2019 3:49 AM
> *To:* koha list ; Peter Lau <
> peter@yccece.edu.hk>
> *Subject:* Re: [Koha] Course Reserve information from customized report
>
>
>
> Hi Peter,
>
>
>
> Try this
>
>
>
> SELECT
>
> courses.course_number AS "Course code",
>
> courses.course_name AS "Course",
>
> CONCAT(borrowers.surname, ', ', borrowers.firstname, ' (',
> borrowers.cardnumber, ')') AS "Course teacher",
>
> biblio.title AS "Title",
>
> biblio.author AS "Author",
>
> biblioitems.isbn AS "ISBN",
>
> items.itype AS "Item type",
>
> items.itemcallnumber AS "Item callnumber",
>
> items.barcode AS "Item barcode"
>
> FROM course_items
>
> LEFT JOIN items USING (itemnumber)
>
> LEFT JOIN biblio USING (biblionumber)
>
> LEFT JOIN biblioitems USING (biblionumber)
>
> LEFT JOIN course_reserves USING (ci_id)
>
> LEFT JOIN courses USING (course_id)
>
> LEFT JOIN course_instructors USING (course_id)
>
> LEFT JOIN borrowers USING (borrowernumber)
>
>
>
> Adapted from
> https://wiki.koha-community.org/wiki/SQL_Reports_Library#All_course_reserve_items
>
>
>
> --
> Caroline Cyr La Rose, M.L.I.S
>
> Librarian | Product Manager, inLibro
>
>
>
> Le 19 janvier 2019 à 01:19:40, Peter Lau (peter@yccece.edu.hk) a écrit:
>
> I would like to draw a list of all items cataloged under Course Reserve
> including the Course Code, Course teacher (if input), Bib title, Bib
> author, ISBN etc.
>
> I don't know how to draw them easily from the report function.
>
> Thanks and regards,
>
> *Peter Lau*
>
> Librarian
>
> Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk
>  | Fax: (852) 23384320
>
>
>
> 2 Tin Wan Hill Road, Tin Wan, Aberdeen
>
> *YCCECE, Here We Grow Our Future | *www.yccece.edu.hk
> ___
> Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] OPAC detail

[Indranil Das Gupta]

Hi Jenny,

On Tue, Jan 15, 2019 at 3:16 PM Jenny Wolf  wrote:

> in the library of the memorial site "Haus der Wannsee-Konferenz" we have been 
> unsing Koha (17.11) for almost a year. Our collection includes about 100.000 
> records. We are planning an update to the current version (18.11) in the 
> beginning of 2019. Currently we are customizing the OPAC detail view for our 
> users. This includes for example renaming labels in the XSLT files. Changes 
> like these of course can cause problems. Updates may be more difficult, 
> because the changes we make are not part of the Koha standard.

Did you / your team directly edit the file MARC21slim2OPACDetail.xsl?

OR

did you make a copy of it and edited that and then set up Koha to use
it via the OPACXSLTDetailsDisplay system preference?

>
> Two things are be important to us in the (normal) OPAC detail view:
>
> / variable order of the labels
> The order of the labels should be configurable. (See attached picture or 
> HERE<https://www.dropbox.com/s/dxnupl4keig5oet/OPAC-detail-variable-order-of-the-labels.jpg?dl=0%20>
>  )

Order of labels to be based on what?

> / presentation of the labels in a table (spreadsheet)
> There should be two columns. The first column should display the label, the 
> second column shows the content. (See attached picture or 
> HERE<https://www.dropbox.com/s/rzwlqo1f99ou0hy/OPAC-detail-presentation-of-the-labels-in-a-table.png?dl=0>
>  )

This seems more like a case for CSS rather than anything specific to Koha.

And at best a new theme for the OPAC with the default bootstrap theme
being the fallback (developing a new theme is non-trivial but not
exactly rocket science :-)

cheers
Indranil Das Gupta
L2C2 Technologies
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] 2 koha web and 1 database

[Indranil Das Gupta]

Hi,

On Mon 7 Jan, 2019, 6:46 PM Shafendi,  wrote:

I only know how to install koha and database on 1 server..
>

Multi server + remote DB setups are several order of magnitude more
complex. Given what you mentioned about your current level of comfort, I
would say you might find it useful to work with a koha service provider to
help you out.

That said, many of us here are running multi server setups like the one you
describe. Often with load balancers and round robin DNS factored in to
ensure business continuity.

Search the archives of this list for - "koha on remote db."

Regards
Indranil Das Gupta
L2C2 Technologies.





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

Re: [Koha] upgrading from koha 3.0/debian lenny to koha 18/ubuntu 16

[Indranil Das Gupta]

Hi Tanzeem,

With that ancient version of Koha (3.0), your best bet is to separately
export your existing data - bibliographic, patron and circulation
information and re-import them into a clean latest stable / oldstable
install.

Technically an in-situ upgrade from such an ancient version to the latest
while not impossible, is a technically non-trivial task and will require
you to study both db schema and code to override the many errors it will
throw up.

Just my 2p.

Cheers
Indranil Das Gupta


On Thu 13 Dec, 2018, 2:56 PM Tanzeem M.B,  wrote:

> Hi
>
> I am upgrading from koha 3.0.2 to a latest supported version.
> My present koha installation is koha version 3.0 installed in Debian Lenny
> In the new installation on another machine I have loaded ubuntu 16
> and installed the latest version of koha 18.
> I took the backup of koha from debian.
> Restored the database in the new installation of koha 18 in ubuntu16.
> Then upgraded the database schema
> and run zebra-rebuld indexing.
> which run successfully. I rebooted the system and loaded the installed koha
> in the browser with url
> http://.:8080
> and the web-installer got run again and after the update database step I
> got the following error
> ```Updating database structure
>
> Update report :
>
>- Status: 500
>- Content-type: text/html
>-
>- Software error:
>- DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
>'me.weight' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line
> 110
>- 
>- 
>- For help, please send mail to the webmaster (mailto:[no
>address given]">[no address given]), giving this error message
>- and the time and date of the error.
>-
>- 
>
> Update errors :
>
>- [Thu Dec 13 14:28:24 2018] updatedatabase.pl: DBD::mysql::st execute
>failed: Unknown column 'me.weight' in 'field list' [for Statement
> "SELECT
>`me`.`id`, `me`.`name`, `me`.`label`, `me`.`type`, `me`.`weight` FROM
>`search_field` `me` WHERE ( `me`.`name` = ? )" with ParamValues:
> 0='ta'] at
>/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834.
>- [Thu Dec 13 14:28:24 2018] updatedatabase.pl:
>DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.weight' in
>'field list' at /usr/share/koha/lib/Koha/Objects.pm line 110
>
> ```
> Please help to move further.
>
> With Thanks & Regards
>
> Mr. Tanzeem M B
> +91 9446705956
>
> Thiruvananthapuram
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Loading of remote hosted XSLT failing for both http / https

[Indranil Das Gupta]

Hi all,

Trying to load a remote XSLT via XSLTResultsDisplay syspref as given in
18.05 user manual. Neither http nor https works (FWIW, I'm aware of the FQA
status of bug #12758)

With https i'm hitting line 310 of XSLT_Handler.pm and with http it is line
320.

Enviroment:  Debian 8.10 / Koha 18.05.06; plack enabled, memcached enabled,
site on LE cert with perm re-direct to https.

Does this work?

tia

-- 
Indranil Das Gupta
L2C2 Technologies

Phone : +91-98300-20971
WWW : http://www.l2c2.co.in
Blog: http://blog.l2c2.co.in
IRC : indradg on irc://irc.freenode.net
Twitter : indradg
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Change in card number

[Indranil Das Gupta]

Koha internally tracks patrons using the borrowernumber. Card number can be
changed at any point of time.

Hope this helps
-idg

On Thu 6 Dec, 2018, 9:55 PM takan bhatt,  wrote:

> Hi Friends,
> As our university assigning enrollment numbers after 3 months of actual
> admission. Meanwhile, we have to create patron card number either temporary
> or using other scheme. Can I change card number later ?
>
> Is it effect history of old issue return record ?
>
> Pls guide me.
>
>
> Rajesh Bhatt
> Librarian,
> GRIMS Vapi
> India
> WhatsApp #+919824925609
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Opac 18.11.00 Font

[Indranil Das Gupta]

Quick query: did you clear your browser cache after the upgrade?

Indranil Das Gupta
L2C2 Technologies

On Thu 29 Nov, 2018, 12:52 PM drojup,  wrote:

> Hi there,
>
> I just upgraded to 18.11 and I would like to ask where I can change the
> font. Because I have two languages (English + Greek) and the Greek doesn't
> seem ok with the new font.
>
> Thank you and congratulations.
>
>
>
> --
> Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Remove from mailing list

[Indranil Das Gupta]

Hi

Pls visit the URL (https://lists.katipo.co.nz/mailman/listinfo/koha) also
given in the footer of this email and unsubscribe yourself.

HTH
Indranil.

On Fri 2 Nov, 2018, 1:46 PM Ngendahimana Oraive,  wrote:

> Hello,
> Can you help me and remove me from this mailing list?
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Customizing Koha facets

[Indranil Das Gupta]

Thanks Bharat! Perhaps my question was not clear enough to you.

It is not about adding authors to marc21 framework. Rather it is about
changing how the facets loop code work in Koha at present.

Regards
-idg



On Mon 22 Oct, 2018, 6:59 AM Bharat Chaudhari,  wrote:

> The details for adding other corporate body author is given in marc21 form
> your just refer and configure. That would be proper
>
> Bharat
>
> On 22-Oct-2018 4:22 AM, "Indranil Das Gupta"  wrote:
>
>> Dear colleagues,
>>
>> Recently I've been playing around with movie related metadata. One of the
>> challenges I now face is that of search facets. For MARC21, Koha combines
>> 100a, 110a, 700a as the "Author" facet. In my data, I've defined their
>> role
>> / relator term (700$e) as "Film producer" / "Art director" /
>> "Cinematographer"/ "Actor" etc.
>>
>> Is there a way to segment the data into similar facets based on their
>> relator code / term? Short of re-writing the getFacets sub-routine in
>> lib/C4/Koha.pm after creating custom idx in Zebra?
>>
>> Does that even sound feasible? I could sure use some clue here :-)
>>
>> TIA
>>
>> indranil
>>
>>
>> Indranil Das Gupta
>> L2C2 Technologies
>>
>> Phone : +91-98300-20971
>> WWW : http://www.l2c2.co.in
>> Blog: http://blog.l2c2.co.in
>> IRC : indradg on irc://irc.freenode.net
>> Twitter : indradg
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Customizing Koha facets

[Indranil Das Gupta]

Dear colleagues,

Recently I've been playing around with movie related metadata. One of the
challenges I now face is that of search facets. For MARC21, Koha combines
100a, 110a, 700a as the "Author" facet. In my data, I've defined their role
/ relator term (700$e) as "Film producer" / "Art director" /
"Cinematographer"/ "Actor" etc.

Is there a way to segment the data into similar facets based on their
relator code / term? Short of re-writing the getFacets sub-routine in
lib/C4/Koha.pm after creating custom idx in Zebra?

Does that even sound feasible? I could sure use some clue here :-)

TIA

indranil


Indranil Das Gupta
L2C2 Technologies

Phone : +91-98300-20971
WWW : http://www.l2c2.co.in
Blog: http://blog.l2c2.co.in
IRC : indradg on irc://irc.freenode.net
Twitter : indradg
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Install goes fine, but I can only access maintenance mode

[Indranil Das Gupta]

Also is your DNS serving the library-opac.meu.edu.lb and
library-intra.meu.edu.lb hostnames?

If not using DNS, are you using the hosts file to resolve the hostnames?

-idg

On Fri 19 Oct, 2018, 8:35 PM Indranil Das Gupta,  wrote:

> Hi Ron,
>
> Does opening
>
> http://library-opac.meu.edu.lb/
>
> and
>
> http://library-intra.meu.edu.lb/
>
> give the same result?
>
> Cheers
> Indranil
>
>
>
> On Fri 19 Oct, 2018, 8:19 PM Ronald Vyhmeister, <
> ronald.vyhmeis...@meu.edu.lb> wrote:
>
>> Thanks for the quick reply…
>>
>>
>>
>> I’m running Ubuntu 16.04 LTS, fresh install… the Koha version is whatever
>> it got from the packages as per the install instructions.
>>
>>
>>
>> For koha-sites.conf, here are the uncommented lines:
>>
>>
>>
>> DOMAIN="meu.edu.lb"
>>
>> INTRAPORT="80"
>>
>> INTRAPREFIX=""
>>
>> INTRASUFFIX="-intra"
>>
>> OPACPORT="80"
>>
>> OPACPREFIX=""
>>
>> OPACSUFFIX=""
>>
>> DEFAULTSQL=""
>>
>> ZEBRA_MARC_FORMAT="marc21"
>>
>> ZEBRA_LANGUAGE="en"
>>
>> BIBLIOS_INDEXING_MODE="dom"
>>
>> AUTHORITIES_INDEXING_MODE="dom"
>>
>> USE_MEMCACHED="yes"
>>
>> MEMCACHED_SERVERS="127.0.0.1:11211"
>>
>> MEMCACHED_PREFIX="koha_"
>>
>>
>>
>> For sudo apache2ctl -S
>>
>>
>>
>> AH00558: apache2: Could not reliably determine the server's fully
>> qualified domain name, using 127.0.1.1. Set the 'ServerName' directive
>> globally to suppress this message
>>
>> VirtualHost configuration:
>>
>> *:80   is a NameVirtualHost
>>
>>  default server library-opac.meu.edu.lb
>> (/etc/apache2/sites-enabled/library.conf:4)
>>
>>  port 80 namevhost library-opac.meu.edu.lb
>> (/etc/apache2/sites-enabled/library.conf:4)
>>
>>  port 80 namevhost library-intra.meu.edu.lb
>> (/etc/apache2/sites-enabled/library.conf:23)
>>
>> ServerRoot: "/etc/apache2"
>>
>> Main DocumentRoot: "/var/www/html"
>>
>> Main ErrorLog: "/var/log/apache2/error.log"
>>
>> Mutex default: dir="/var/lock/apache2" mechanism=fcntl
>>
>> Mutex mpm-accept: using_defaults
>>
>> Mutex watchdog-callback: using_defaults
>>
>> Mutex rewrite-map: using_defaults
>>
>> PidFile: "/var/run/apache2/apache2.pid"
>>
>> Define: DUMP_VHOSTS
>>
>> Define: DUMP_RUN_CFG
>>
>> Define: ENABLE_USR_LIB_CGI_BIN
>>
>> Define: instance=library
>>
>> User: name="www-data" id=33
>>
>> Group: name="www-data" id=33
>>
>>
>>
>> Thanks for any assistance.
>>
>>
>>
>> Ron
>>
>>
>> -
>>
>> Ronald Vyhmeister, PhD
>>
>> Academic Dean
>>
>> IT Manager
>>
>> Middle East University
>>
>> Beirut, Lebanon
>>
>> ronald.vyhmeis...@meu.edu.lb
>>
>> Mobile:+961-81767015
>>
>> Technology is dominated by two kinds of people:
>> Those who manage what they do not understand
>> and those who understand that which they do not manage.
>>
>>
>>
>> *From:* Indranil Das Gupta 
>> *Sent:* Friday, October 19, 2018 5:40 PM
>> *To:* Ronald Vyhmeister 
>> *Cc:* koha 
>> *Subject:* Re: [Koha] Install goes fine, but I can only access
>> maintenance mode
>>
>>
>>
>> Hi Ronald,
>>
>>
>>
>> Can you pls share the version of Koha, OS you are installing on?
>>
>>
>>
>> Are you using Name based virtual hosting or using IP:port based virtual
>> hosting?
>>
>>
>>
>> Can you share the settings of your
>>
>>
>>
>> (a) /etc/koha/koha-sites.conf
>>
>>
>>
>> (b) the output of : sudo apache2ctl -S
>>
>>
>>
>> Cheers
>>
>> Indranil Das Gupta
>>
>> L2C2 Technologies.
>>
>>
>>
>>
>>
>> On Fri 19 Oct, 2018, 7:59 PM Ronald Vyhmeister, <
>> ronald.vyhmeis...@meu.edu.lb> wrote:
>>
>> I completed the install of Koha (followed
>> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages).
>>
>>
>>
>> In order to get to Koha I had to also run this:
>>
>>
>>
>> sudo a2dissite 000-default
>>
>>
>>
>> or I would get the apache page…
>>
>>
>>
>> But now, with or without the –intra suffix, it send me straight to the
>> maintenance page… Any ideas?
>>
>>
>>
>> Thanks in advance!
>>
>>
>>
>> Ron
>>
>>
>>
>>
>> -
>>
>> Ronald Vyhmeister, PhD
>>
>> Academic Dean
>>
>> IT Manager
>>
>> Middle East University
>>
>> Beirut, Lebanon
>>
>> ronald.vyhmeis...@meu.edu.lb
>>
>> Mobile:+961-81767015
>>
>> Technology is dominated by two kinds of people:
>> Those who manage what they do not understand
>> and those who understand that which they do not manage.
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Install goes fine, but I can only access maintenance mode

[Indranil Das Gupta]

Hi Ron,

Does opening

http://library-opac.meu.edu.lb/

and

http://library-intra.meu.edu.lb/

give the same result?

Cheers
Indranil



On Fri 19 Oct, 2018, 8:19 PM Ronald Vyhmeister, <
ronald.vyhmeis...@meu.edu.lb> wrote:

> Thanks for the quick reply…
>
>
>
> I’m running Ubuntu 16.04 LTS, fresh install… the Koha version is whatever
> it got from the packages as per the install instructions.
>
>
>
> For koha-sites.conf, here are the uncommented lines:
>
>
>
> DOMAIN="meu.edu.lb"
>
> INTRAPORT="80"
>
> INTRAPREFIX=""
>
> INTRASUFFIX="-intra"
>
> OPACPORT="80"
>
> OPACPREFIX=""
>
> OPACSUFFIX=""
>
> DEFAULTSQL=""
>
> ZEBRA_MARC_FORMAT="marc21"
>
> ZEBRA_LANGUAGE="en"
>
> BIBLIOS_INDEXING_MODE="dom"
>
> AUTHORITIES_INDEXING_MODE="dom"
>
> USE_MEMCACHED="yes"
>
> MEMCACHED_SERVERS="127.0.0.1:11211"
>
> MEMCACHED_PREFIX="koha_"
>
>
>
> For sudo apache2ctl -S
>
>
>
> AH00558: apache2: Could not reliably determine the server's fully
> qualified domain name, using 127.0.1.1. Set the 'ServerName' directive
> globally to suppress this message
>
> VirtualHost configuration:
>
> *:80   is a NameVirtualHost
>
>  default server library-opac.meu.edu.lb
> (/etc/apache2/sites-enabled/library.conf:4)
>
>  port 80 namevhost library-opac.meu.edu.lb
> (/etc/apache2/sites-enabled/library.conf:4)
>
>  port 80 namevhost library-intra.meu.edu.lb
> (/etc/apache2/sites-enabled/library.conf:23)
>
> ServerRoot: "/etc/apache2"
>
> Main DocumentRoot: "/var/www/html"
>
> Main ErrorLog: "/var/log/apache2/error.log"
>
> Mutex default: dir="/var/lock/apache2" mechanism=fcntl
>
> Mutex mpm-accept: using_defaults
>
> Mutex watchdog-callback: using_defaults
>
> Mutex rewrite-map: using_defaults
>
> PidFile: "/var/run/apache2/apache2.pid"
>
> Define: DUMP_VHOSTS
>
> Define: DUMP_RUN_CFG
>
> Define: ENABLE_USR_LIB_CGI_BIN
>
> Define: instance=library
>
> User: name="www-data" id=33
>
> Group: name="www-data" id=33
>
>
>
> Thanks for any assistance.
>
>
>
> Ron
>
>
> -
>
> Ronald Vyhmeister, PhD
>
> Academic Dean
>
> IT Manager
>
> Middle East University
>
> Beirut, Lebanon
>
> ronald.vyhmeis...@meu.edu.lb
>
> Mobile:+961-81767015
>
> Technology is dominated by two kinds of people:
> Those who manage what they do not understand
> and those who understand that which they do not manage.
>
>
>
> *From:* Indranil Das Gupta 
> *Sent:* Friday, October 19, 2018 5:40 PM
> *To:* Ronald Vyhmeister 
> *Cc:* koha 
> *Subject:* Re: [Koha] Install goes fine, but I can only access
> maintenance mode
>
>
>
> Hi Ronald,
>
>
>
> Can you pls share the version of Koha, OS you are installing on?
>
>
>
> Are you using Name based virtual hosting or using IP:port based virtual
> hosting?
>
>
>
> Can you share the settings of your
>
>
>
> (a) /etc/koha/koha-sites.conf
>
>
>
> (b) the output of : sudo apache2ctl -S
>
>
>
> Cheers
>
> Indranil Das Gupta
>
> L2C2 Technologies.
>
>
>
>
>
> On Fri 19 Oct, 2018, 7:59 PM Ronald Vyhmeister, <
> ronald.vyhmeis...@meu.edu.lb> wrote:
>
> I completed the install of Koha (followed
> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages).
>
>
>
> In order to get to Koha I had to also run this:
>
>
>
> sudo a2dissite 000-default
>
>
>
> or I would get the apache page…
>
>
>
> But now, with or without the –intra suffix, it send me straight to the
> maintenance page… Any ideas?
>
>
>
> Thanks in advance!
>
>
>
> Ron
>
>
>
>
> -
>
> Ronald Vyhmeister, PhD
>
> Academic Dean
>
> IT Manager
>
> Middle East University
>
> Beirut, Lebanon
>
> ronald.vyhmeis...@meu.edu.lb
>
> Mobile:+961-81767015
>
> Technology is dominated by two kinds of people:
> Those who manage what they do not understand
> and those who understand that which they do not manage.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Install goes fine, but I can only access maintenance mode

[Indranil Das Gupta]

Hi Ronald,

Can you pls share the version of Koha, OS you are installing on?

Are you using Name based virtual hosting or using IP:port based virtual
hosting?

Can you share the settings of your

(a) /etc/koha/koha-sites.conf

(b) the output of : sudo apache2ctl -S

Cheers
Indranil Das Gupta
L2C2 Technologies.



On Fri 19 Oct, 2018, 7:59 PM Ronald Vyhmeister, <
ronald.vyhmeis...@meu.edu.lb> wrote:

> I completed the install of Koha (followed
> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages).
>
>
>
> In order to get to Koha I had to also run this:
>
>
>
> sudo a2dissite 000-default
>
>
>
> or I would get the apache page…
>
>
>
> But now, with or without the –intra suffix, it send me straight to the
> maintenance page… Any ideas?
>
>
>
> Thanks in advance!
>
>
>
> Ron
>
>
>
>
> -
>
> Ronald Vyhmeister, PhD
>
> Academic Dean
>
> IT Manager
>
> Middle East University
>
> Beirut, Lebanon
>
> ronald.vyhmeis...@meu.edu.lb
>
> Mobile:+961-81767015
>
> Technology is dominated by two kinds of people:
> Those who manage what they do not understand
> and those who understand that which they do not manage.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Request For CATALOGING TAG NO

[Indranil Das Gupta]

Adding to what Caroline said:

On Mon 15 Oct, 2018, 7:28 PM Caroline Cyr-La-Rose, <
caroline.cyr-la-r...@inlibro.com> wrote:

Bill no.: I don't think this information is cataloged in the record or
> the item. You'd have to go through the acquisitions module to add the
> bill number. However, there are always local note fields that you can
> add, 59X
>

Bill no and date are typical requests from our Indian Koha clients, who
typically often do not use the ACQ module.

What we suggest them is to establish a local practise to store the data
into the 952 non-public note using standardised mnemonics and delimiter for
their library so that SQL reports can be used later to parse / search them
(typically using the sql CASE statements).

So at some of our clients, this would be typical entry:

952  \\$xBN:LIB/PUR/129/18-19|BD:2018-10-10|

Where BN: marks the start of Bill No and goes on until the delimiter "|" is
reached, similarly BD: denotes Bill Date.

The reason I mentioned 'establishing a local practise' is because these two
"fields" are always to be input first into 952$x, anything else would come
after the delimiter after BD:. And we also insist that the bill date be
stored only in ISO 8601 (-MM-DD) format, not withstanding what is the
dateformat syspref is set to in their Koha instance.

Hope this helps,

Indranil Das Gupta
L2C2 Technologies.

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