koha@lists.katipo.co.nz

2021-03-15 Thread Suresh Kumar Tejomurtula
hich Koha version are you seeing this in? > > Katrin > > On 12.03.21 14:03, Suresh Kumar Tejomurtula wrote: > > Dear all, > > > > When I download a report from koha reports, if any title or any other > > field having "&" in the field, the CSV will

koha@lists.katipo.co.nz

2021-03-12 Thread Suresh Kumar Tejomurtula
Dear all, When I download a report from koha reports, if any title or any other field having "&" in the field, the CSV will have "&" in the output instead of "&". I generally manually edit the exported data and correct "&" to "&". Is there any way to overcome this issue automatically? - Regards

[Koha] Help regarding display of title field based in condition

2021-01-08 Thread Suresh Kumar Tejomurtula
Hi Based on language field of 008-35-37, do we have workaround to display 246$a in the place of '245$a' as a display field in OPAC results and also on record retrieved? Thanks in advance. Regards T suresh kumar ___ Koha mailing list http://koha-comm

[Koha] Regarding additional content types in advanced search

2020-11-01 Thread Suresh Kumar Tejomurtula
Hi, In the opac/intranet advanced search there is an option to search for additional content types. In that additional format type standards/specifications(008 - 24(u) - Standards/Specifications) is missing. How to add this additional format type to advance search. Please guide me. -- Regards T

[Koha] Request guidance regarding serial control

2020-10-04 Thread Suresh Kumar Tejomurtula
Dear all, Need guidance / best practice to the below issue:- I'm using serial control module in Koha. In our organization we have subscriptions to multilingual periodicals with the same title eg: India Today which is being published in Hindi and English. I have created entries for the title with

Re: [Koha] Regarding marc framework - extra subfields

2019-06-13 Thread Suresh Kumar Tejomurtula
; celular y Nextel > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS > y GPRS online > Visitenos en www.perusms.com > > > Le jeu. 13 juin 2019 à 05:59, Suresh Kumar Tejomurtula < > tejosku...@gmail.com> a écrit : > >> Hi,

[Koha] Regarding marc framework - extra subfields

2019-06-13 Thread Suresh Kumar Tejomurtula
Hi, Having a query related to marc framework. Currently we are using 16.05(This is old version, but due to unavailability of internet we had to use this). For our serial control, I added few extra subfields in marc framework for 952 tag and they are added to "more_subfields_xml" coloumn in the it

[Koha] Regarding analytical entries

2019-05-23 Thread Suresh Kumar Tejomurtula
Hi, This is regarding analytical records, some of the bibliographic fields are auto populated like title biblionumber, itemnumber etc in 773 field. Now I wanted to generate few other fields into the 773 field automatically. Is this possible? If so pls let me know the steps to achieve this. Than

[Koha] Regarding koha offline circulation - windows

2019-02-19 Thread Suresh Kumar Tejomurtula
Hi, IAM using koha 17.11 on Ubuntu 16.04. When I ran cronjob of running offline db(create_koc_db.pl), IAM getting error that I do not have sqlite Perl module installed and I will not be able to install it as IAM unable to connect my server to internet. Now is there any way with which I can creat

Re: [Koha] Regarding SQL query for Analytical entries

2019-01-23 Thread Suresh Kumar Tejomurtula
me built in functions for handling marc data that should make > pretty quick work of the problem. I think that once I write my first report > plugin, many more will follow, but it's one of those things that's easy > when you know how, but difficult to see your way to when

[Koha] Regarding SQL query for Analytical entries

2019-01-21 Thread Suresh Kumar Tejomurtula
Hi, we have analytical entries created for conference papers purchased in our library. We generated a report using the below query. But, unable to get the report the way I need. I wanted a separator between the subject entries that are repeated. But the separator is not getting added and all the s

[Koha] Regarding duplicate overdue notices

2018-12-13 Thread Suresh Kumar Tejomurtula
Hi I have a query related to duplicate overdue notices. I deleted all my DUE notices slips in default and have DUE notices only in our branch. My triggers are like 1, 10 and 30 days intervel and assigned DUE, DUE2, and DUE3 notices respectively. But unable to understand how duplicate overdue not

[Koha] Software errror - Can't call biblio on an undefined value

2018-08-09 Thread Suresh Kumar Tejomurtula
Hi Ian getting the below error when I open a member record and it is happening only for few records; Software error: Can't call biblio on an undefined value at /use/share/koha/lib/c4/members.pm line 767 Koha version 17.11 on Ubuntu mariadb. This error is not there in koha 16.05 for the same rec

Re: [Koha] Indexing not working after upgrade

2018-07-11 Thread Suresh Kumar Tejomurtula
re check the Koha >> > framework, for a testing purpouses move all records framework to default >> > and try to reindex again >> > >&

Re: [Koha] Indexing not working after upgrade

2018-07-11 Thread Suresh Kumar Tejomurtula
ork, for a testing purpouses move all records framework to default > and try to reindex again > > I guess you know how to assing all records to default framework right? > > reindex again > > 2018-07-11 15:40 GMT+02:00 Suresh Kumar Tejomurtula > : > >> Dear all, &

[Koha] Indexing not working after upgrade

2018-07-11 Thread Suresh Kumar Tejomurtula
Dear all, Could any one help me on how to solve the below issue with my database: -- I installed koha 17.11 in a fresh PC as per the instructions at - https://wiki.koha-community.org/wiki/

Re: [Koha] Fwd: Koha indexing error after importing data

2018-07-11 Thread Suresh Kumar Tejomurtula
Hi Michael, Thank you for your reply. It did not worked after this. After upgrade I noticed that the table biblio_metadata is empty. Is this any reason for indexing not running. Please guide me on how to update the table if this is an issue in my database. Regards Suresh On Mon 9 Jul, 2018,

[Koha] Fwd: Koha indexing error after importing data

2018-07-09 Thread Suresh Kumar Tejomurtula
. -- Forwarded message - From: Suresh Kumar Tejomurtula Date: Sun 8 Jul, 2018, 21:09 Subject: Koha indexing error after importing data To: koha Hi, I installed koha 17.11 in a fresh PC as per the instructions at - https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages and

[Koha] Koha indexing error after importing data

2018-07-08 Thread Suresh Kumar Tejomurtula
Hi, I installed koha 17.11 in a fresh PC as per the instructions at - https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages and successfully installed. When I try to index it is working after creating few test records. Iam able to import data from koha version 16.05(Installed on 14.04 ub

[Koha] SQL query on number of days to get a book

2018-05-28 Thread Suresh Kumar Tejomurtula
Hi, Query on orders(books) which are received in library and an email is triggered to members. This report may be useful in calculating number of days we are taking to get a suggested book. Here iam considering mail sent to a member as a value for calculating the number of days taken to get a book

[Koha] MySQL query for serials late issues

2018-05-28 Thread Suresh Kumar Tejomurtula
Hi, Below is my updated version of serials query for finding late issues based on the already existing query in koha sql reports library. Hope is it useful for other members. SELECT @kp:=@kp+1 as S_No,serial.serialseq, DATE_FORMAT(serial.planneddate, "%d %b %Y" ) as Planneddate, DATE_FORMAT(subsc

[Koha] Regarding statistics and logs

2018-01-26 Thread Suresh Kumar Tejomurtula
Hi I would like to know the reason behind the below: Why the userid field is not added to the statistics table and instead a new record is generated in logs table to know who did the transaction. In the above case, a duplicate record is getting created in logs and also in statistics. If userid

[Koha] Regarding change the case of text to proper case

2017-11-06 Thread Suresh Kumar Tejomurtula
Hi, Our koha database is having data completely all text with upper case. We wanted to change the case of the text. We wanted to change the case of text to proper case. I searched for how to go about, was able to do in mysql by exporting data and re-importing after changing the text by exporting

Re: [Koha] Koha Digest, Vol 143, Issue 18

2017-09-14 Thread Suresh Kumar Tejomurtula
Hi, As suggested already you can use, but I noticed that sort1 and sort2 are there in acquisition also. Hence if you rename anything here, it will reflect in acquisition module too I used unused fields in borrower table and renamed them as per my need in opac and intranet using jquery statem

[Koha] koha password recovery

2017-07-25 Thread Suresh Kumar Tejomurtula
Hi, In koha password recovery, it asks for Login:, Email:. I want our members to enter only loginid and they should get email to the members registered email id their password without asking for entering their email. Is this option possible? -- Regards T. Suresh Kumar _

[Koha] How to change labels on opac member entry screen

2017-07-14 Thread Suresh Kumar Tejomurtula
Hi How can I change the labels of opac patron entry screen. For eg. I wanted to make address as Dept. Number. I am able to change lable in staff screen. Similarly wanted to know how I can change in opac screen. Regards Suresh ___ Koha mailing list ht

[Koha] Regarding sql query for analytical records

2017-05-31 Thread Suresh Kumar Tejomurtula
HI, Thanks for the correction. I updated my query and modified as below. I wanted to link the barcode in the marc tag(773 / 0) to the items serial barcode for getting the serial publication date and serial planned date. In the below query all fields are having correct values except the serial pla

[Koha] Regarding sql report for analytical records created

2017-05-30 Thread Suresh Kumar Tejomurtula
Hi, I would like to get a report on analytical records created in koha. The below is the query I tried, but getting a blank output. Iam very new to sql reports. I tried looking in the sql reports library, but could not get any. SELECT biblio.biblionumber, biblio.title, biblio.author, ExtractVa

Re: [Koha] Help - Email lookup while using lists

2017-05-03 Thread Suresh Kumar Tejomurtula
31 Mar 2017 14:44:57 + > From: Jonathan Druart > To: koha > Subject: Re: [Koha] Help - Email lookup while using lists > Message-ID: > mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hello, > > No this is not implemented, but co

[Koha] Help - Email lookup while using lists

2017-03-31 Thread Suresh Kumar Tejomurtula
Dear all, Is there any option to lookup for sending emails using lists or cart in koha opac. What iam looking is if I type a name when trying to send email, will it look for similar names or emails. Iam looking for an option like that of lookup used in check-out. -- Regards T. Suresh Kumar ___

[Koha] Step by step procedure to create koha-plugin-coverflow

2017-03-15 Thread Suresh Kumar Tejomurtula
Hi, Step by step procedure for creating koha coverflow images for the OPAC which useful for the basic koha users is below. http://blogssuresh.blogspot.in/2017/03/step-by-step- procedure-to-create-koha_15.html I did this on a 14.04 and koha 16.11 version. Source for doing the procedure is: http:

[Koha] Help regarding fine calculation report

2016-07-07 Thread Suresh Kumar Tejomurtula
Hi, Need help in refining the below query which is based on the query from SQL reports library. I need to add the following also to the query: 1. Using the below report Iam able to generate fine report for only returned items. I need to generate fine even for the items that are renewed and fine i

[Koha] Regarding uploading files in koha (not related to bibliographic records)

2016-06-13 Thread Suresh Kumar Tejomurtula
Hi, Iam interested to know how we can upload files in koha. Iam already aware of the process to attach files to a bibliographic records / attaching files to a member / and in aqusition - http://kohageek.blogspot.in/2015/12/attaching-files-to-catalog-records.html . What Iam looking is uploading an

[Koha] Regarding Checkouts - not displaying - 16.05.00

2016-06-10 Thread Suresh Kumar Tejomurtula
Dear team, I've installated 16.05.00.000, and noticed the below issues while checkout: 1. If a fine is there, there is a blank box coming and not displaying message that member have fine and cannot borrow. 2. Checkout items not displaying and a message iam getting when clicked on Always show che

[Koha] SQL reports - Fine generating with itemtype filter

2016-06-07 Thread Suresh Kumar Tejomurtula
Dear all, I need help in generating a report related to fines. Using the below report iam able to generate the fines. I would like to add a filter to this report "itemtype" for fine report as our circulation rules are slightly different for books and journals and the complete fine reports sometim

[Koha] Best practices for koha - journal migration using marcedit

2016-04-28 Thread Suresh Kumar Tejomurtula
Dear team, I would like to know how to covert excel data of journals especially with large number of issues(having more than 600 issues) for each journal. Tried using marcedit and it is giving error - 501 when trying to covert mrk to mrc format. Is there any other way how I can covert this data t

Re: [Koha] Help regarding Import batch into the catalog

2016-03-14 Thread Suresh Kumar Tejomurtula
03/2016, Suresh Kumar Tejomurtula wrote: > > Dear team, > > > > While importing the batch into the catalog in 3.22.4, I noticed it is > > taking more time for 3 records. In 3.20 it used to take only less > than > > 30 minutes for both upload marc records and impor

[Koha] Help regarding Import batch into the catalog

2016-03-14 Thread Suresh Kumar Tejomurtula
Dear team, While importing the batch into the catalog in 3.22.4, I noticed it is taking more time for 3 records. In 3.20 it used to take only less than 30 minutes for both upload marc records and importing batch into the catalog. Is this issue with any of our koha settings? Please guide me if

Re: [Koha] Poblishercode - entries in koha

2016-03-03 Thread Suresh Kumar Tejomurtula
Thank you very much for your reply. Will try it out today and will share my feed back. Regards T. Suresh Kumar On Mar 2, 2016 21:47, "Indranil Das Gupta" wrote: > Hi Suresh, > > On Wed, Mar 2, 2016 at 9:10 PM, Suresh Kumar Tejomurtula > wrote: > > Dear all, > >

[Koha] Poblishercode - entries in koha

2016-03-02 Thread Suresh Kumar Tejomurtula
Dear all, I would like to know how the publishercode is entered in KOHA. If there is a table like that of vendors for publishers it would be very useful and the entries will be uniform thoughout the records. I found in serials, vendor entry is very good option. I could not get any info. of genera