- Koha - lists.katipo.co.nz

Staff monitoring (catalogue)
by Yatheesh lis 02 May '19

02 May '19

Dear all, Suppose I have five staff member doing catalogue very day. One of these doing mistakes how to identify person who uploading records. They have different login id Is there any opinion record upload by ........

3 3

Koha Community Newsletter: April 2019
by kohanews 02 May '19

02 May '19

The Koha Community Newsletter for April 2019 is here: https://koha-community.org/koha-community-newsletter-april-2019/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Fwd: Problem with Koha
by Liz Rea 02 May '19

02 May '19

---------- Forwarded message --------- From:Facundo Gallego <gonzalitofacu14(a)gmail.com> Date: Wed., 1 May 2019, 8:34 am Subject: Problem with Koha To: <wizzyrea+kcweb(a)gmail.com> Good Morning! I want to report the problem I'm having with Koha. Everytime I want to enter on the page biblioteca.com.ar (my library page) an error runs: Software error: DBIx::Class::Storage::DBI::catch {...} (): DBI Connection failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1492. at /usr/share/koha/lib/Koha/Database.pm line 100 For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. I really need to get this solved, please. I'm begging for your help. Thank You!

2 1

Call for Presentation Proposals
by Vicepresident koha-US 01 May '19

01 May '19

Hello, Koha-US would like to invite you to propose a presentation for our annual conference, held in September 2019. Proposals will be due the 31st of May 2019. Please plan for a 45 minute long session with 5 minutes of questions after. The koha-US 2019 Conference will be held in Pueblo Colorado September 18th-21st 2019. You can submit proposals here. <https://docs.google.com/forms/d/e/1FAIpQLSfUyOAowsiGoOwAI_jj_YIiMRbIlbZgvSk…> Our theme for the 2019 conference will be: *Patron Power – Enable Your Users* It will be hosted by Pueblo City/County Library District (map.) <https://www.google.com/maps/dir/Pueblo+City-County+Library+District+-+Rawli…> The cost for the conference will by $35.00 for members and $55.00 for non-members. *Due to low registration fees, registration for presenters will not be waived. Please e-mail info(a)koha-us.org if you have any questions. Lisette Scheer Vice President koha-US

1 0

Re: [Koha] Subject Wise Report
by Owen Leonard 01 May '19

01 May '19

Please reply to the mailing list so that others can participate. On Wed, Apr 17, 2019 at 12:25 AM Rizwan Majeed <rizwanmajeed(a)ue.edu.pk> wrote: > > this is the query > > SELECT * > FROM(SELECT > items.dateaccessioned, > items.barcode, > items.itemcallnumber, > biblio.title, > biblio.author, > biblioitems.publishercode, > (SELECT ExtractValue(biblioitems.marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]')) > AS Subject > FROM items > LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) > LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) > WHERE items.dateaccessioned BETWEEN <<Between (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>) AS t > WHERE Subject LIKE concat('%',<<Subject>>,'%') > ORDER BY dateaccessioned DESC >

4 4

Fine Calculation Settings
by Rizwan Majeed 30 Apr '19

30 Apr '19

Dear All In our university, the fine calculation rule is as under: - after due date, Rs.10/- per day will be charged upto seven days - Rs.50/- per day will be charged after seven days Does anybody know about the settings to calculate the fine as mentioned above? I shall be thankful. Regards! Rizwan

3 2

Re: [Koha] Relator Term
by Ma. Victoria H. Silva-Manuel 30 Apr '19

30 Apr '19

Hi. Thank you for replying. I compared the two frameworks and no authorized value is linked to $4 in both frameworks. They also have the same subfields and visibility setting. Is there another way to fix this? Thank you. On Mon, Apr 29, 2019 at 4:54 PM Katrin Fischer <Katrin.Fischer.83(a)web.de> wrote: > > Hi, > > compare your frameworks and check if an authorised value is linked to $4 > in one of them. Koha can pull the relator terms from an authorised value > and replace the codes with the descriptions if you link them. I'd also > check if you have the same subfiels and visibility settings in both. > > Hope this helps, > > Katrin > > > *Gesendet:* Montag, 29. April 2019 um 10:44 Uhr > *Von:* "Ma. Victoria H. Silva-Manuel" <mavicsilva(a)gmail.com> > *An:* koha <koha(a)lists.katipo.co.nz> > *Betreff:* [Koha] Relator Term > Hi. > In our Koha, relator terms from Book MARC Framework and Kit MARC Framework > show in OPAC differently. > > In Book Framework: > > Gonzalez, Fernando Rosal [author] > > > While in Kit Framework: > > Gonzalez, Fernando Rosal, author > > > How can we edit this? We prefer the one in Kit Framework. > > Hope someone can help us. > > Thank you. > Ma. Victoria H. Silva-Manuel > Registered Librarian, 3892 > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

2 1

Creation of separate OPAC for each library in Library group
by Habib Jaffri 29 Apr '19

29 Apr '19

Dear community members Kindly help us to develop the separate OPAC interface for each library in on library group Syed Habib Akhter Jaffri Sent from Mail for Windows 10 --- This email has been checked for viruses by AVG. https://www.avg.com

1 0

Creating a Report to List Books published with a Date Range
by Njideaka Tobechukwu 29 Apr '19

29 Apr '19

Hi All, Please, I am trying to create a report of my KOHA database to list books published within 2016-2019, in a tabular form having just the book title, author, and date of publication. However, I do not know how to go about creating this report. Please, can someone help with steps to follow to create such a report., OR an SQL Schema for such a report. Thank you -- *Tobechukwu Njideaka* *Knowledge/Information Management Specialist*

3 2

SQL for Auto Increment verification
by Tom Hanstra 29 Apr '19

29 Apr '19

Based upon a blog post from a couple of versions back, we regularly run some SQL on our databases to ensure that auto increment is working properly on a number of tables. We have had some problems with this, however, in version 17.11 with database locks on table updates which have resulted in downtime for Koha. My question is whether this code is still necessary in 17.11 and beyond or if this is now obsolete. If I don't need to run this, I will stop doing so. And the second question would be, if it is necessary, have others run into similar issues and how might it be cleared up? Thanks in advance for any guidance you can provide, Tom -- *Tom Hanstra* *Sr. Systems Administrator* hanstra(a)nd.edu <http://library.nd.edu/>

3 3