[Koha] Top 10 Circulating Books

(s.datetime) > DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH) AND DATE(s.datetime)<=CURRENT_DATE() AND s.itemnumber IS NOT NULL AND s.type IN ('issue','renew')GROUP BY b.biblionumber ORDER BY circs DESC LIMIT 10 How can we add date range and branch filter? Thank you.

[Koha] Circulation by Call Number

> I tried adding biblio.title in many places but it always ending up in error. I'm not a programmer that is why I'm struggling with this. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Circulation by Call Number

.datetime) BETWEEN < AND < AND statistics.branch = < AND items.location = < AND statistics.itemtype = < type|itemtypes > GROUP BY items.itemcallnumber , biblio.biblionumber > ORD

[Koha] On-site check out

Hi. Is there a way to make the "On-site check out" checked by default? We have patrons with on-site check out only privilege. It is kind of troublesome to repeatedly ticked the box and often it is forgotten. Thanks. Ma. Victoria H. Silva-Manuel Registered Libra

[Koha] Guarantor Information

Good day. How to delete guarantor information fields when adding a patron? I checked the database columns but when I placed "guarantorid" in the BorrowerUnwantedField, the guarantor information still shows. ___ Koha mailing list http://koha-community.o

[Koha] Loan Period

Hi. I set the loan period to 7 days but when we check out books, the due date it gives is the following day. Hope someone can help. Thank you. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/li

[Koha] Loan Period

Hi. Our loan period is fixed at 7 hours, even if I changed the "loan period" and "unit" in the "Circulation and Fine Rules". Please help. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___

[Koha] Mapping Authority & Bibliographic Records

Hi. We are using Cutter-Sanborn and place it in authority 082$b. I wanted to map it to biblio 082$b. Is this possible and how? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org

[Koha] Click Tracker

icked by all users but does not show the names of logged in users. Is there a way to create a report that will show links clicked by all users and show the names if the users are logged in? Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

[Koha] Circulation Restriction

Hi. Can we set the circulation restrictions by collection code, not by item type? ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Arranging subjects shown in OPAC

Hi. The default arrangement of subjects is by their MARC tags. Is there a way that I can customize the subjects' arrangement? For Example, if I have three subject added entries: 600, 650 & 651 but I want 651 to appear first. -- Ma. Victoria H. Silva-Manuel Registered Librar

[Koha] On-site check out report

Hi. How to create a separate report for books borrowed for home use and on-site check out? We want to have different statistics for books taken outside the library and books that are used inside the library. Hope someone can help us. Thanks. -- Ma. Victoria H. Silva-Manuel Registered

[Koha] Click Tracker

; GROUP BY url But I'm getting the following error: *The following error was encountered:* The database returned the following error: Unknown column 'i.itype' in 'where clause' Please check the log for further details. What am I doing wrong? -- Ma. Victoria H. Sil

[Koha] Fast cataloging

Hi. "Fast cataloging" option is not showing up when I tried to check out uncatalog book. How to activate this feature? Thanks. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listin

[Koha] Overdue Notice

Hi. How to send overdue notice every day until the item is returned to us? Thanks. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Overdue Fine Reports

Hi. How to create reports for the following: a. Total collected fines by date range with patron's name, name of staff collected the fine & filtered branch library b. Total write off fines by date range with patron's name, name of staff wrote off the fine & filtered branch library I found these ki

[Koha] Uploading files

I successfully uploaded a file in tag 856$u but when I checked it out in OPAC, I'm getting Error 404 (Sorry, the requested page is not available). I already choose "upload.pl" in plugin in the bibliographic framework. What should I do? Thanks. ___ Koh

Re: [Koha] [EXTERNAL] Uploading files

library)/koha-conf.xml (towards the bottom of the > screen), and that Koha gives the file a 32-character hash tag. After that, > I got horribly lost, which is why I figured out a different way. > > > > Good luck! > > > > Fred King, MSLS, AHIP > > Medical Librarian

[Koha] Click Tracker

#x27; > Please check the log for further details. What should I do? -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Click Tracker

ways / Recicla siempre / Recyclez toujours > P Print only if absolutely necessary / Imprime solo si es necesario / > Imprimez seulement si nécessaire > > > Le lun. 27 mars 2023 à 00:31, Ma. Victoria H. Silva-Manuel < > mavicsi...@gmail.com> a écrit : > >> I am us

Re: [Koha] Click Tracker

gt; JOIN items USING (biblionumber) > WHERE date(timeclicked) BETWEEN <> AND > <> AND items.itype=<> > > Hope that helps! > Andrew > -- > *From:* Koha on behalf of Ma. Victoria > H. Silva-Manuel > *Sent:* Monday, March 27, 2023

[Koha] In House Use

ORDER BY items.itemcallnumber asc The original SQL only shows the count, I added the call number and filtered it by library and location successfully but I cannot add the title. I am always getting an error. What should I do? -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

Re: [Koha] In House Use

t; statistics.branch=<> and > items.location=<> > GROUP BY items.itemcallnumber, biblio.title > ORDER BY items.itemcallnumber asc > > Hope that helps! > --Josh Barnes > > On Tue, Mar 28, 2023 at 9:39 PM Ma. Victoria H. Silva-Manuel < > mavicsi

[Koha] Total Fine Paid

on as library sections and we want to determine the paid fines per library section. Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Open access

Hi. Is it possible to add open access logo to a record and visible in OPAC? Thanks. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Nature of Contents

Hi. How to make "Nature of Contents" field in 008 mandatory? Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Who created records

Hi. How to know or to show who created records in cataloging module? There are records that I need to find out who created them. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org

Re: [Koha] New record not appear in search

in my experience, it takes few minutes before new records to become searchable. Ma. Victoria S. Manuel, RL PRC No. 3892 On Oct 18, 2017 2:51 PM, "Mutasem Al Shami" wrote: Hi every one, I'm insert new record in koha, but when search on the this record not appear . Best, Mutasem Alshami -- -

[Koha] OPAC Search Report

Hi. How to generate a report on keywords used in OPAC search? Thank you. Ma. Victoria S. Manuel, RL PRC No. 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Book Cover

hi. is there a way to show only one book cover per record? i enable amazon and local cover images and in my opac search i can see the cover from amazon and "no cover image available" hope someone can help. thanks. -- Ma. Victoria H. Silva-Manuel Registered Libra

[Koha] Not for Loan

hi. we just recently upgraded to version 17 from 3 and i noticed that in item field "Not for loan" there is no more blank option that when you choose will make the item available. how do i make an item with "Not for loan" status available? thanks. -- Ma. Victoria H. Sil

[Koha] MARC Tag 264

Hi. In OPAC normal view, the field name for tag 264 does not appear. How to show the tag's name in OPAC? We are using Koha 17.05. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-communit

[Koha] Biblios in reservoir

Hi. How do you delete biblios in reservoir? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] (no subject)

Hi. I'm getting this message: software error No biblionumber tag for framework /usr/share/koha/lib/C4/Biblio.pm line 3013. I edited some fields in 900s. What field should I restore to solve this problem. Thanks -- Ma. Victoria H. Silva-Manuel Registered Librarian,

[Koha] Software error

Hi. I'm getting this message: software error No biblionumber tag for framework /usr/share/koha/lib/C4/Biblio.pm line 3013. I edited some fields in 900s. What field should I restore to solve this problem. Thanks -- Ma. Victoria H. Silva-Manuel Registered Librarian,

[Koha] (no subject)

Hi. I suddenly getting this message when importing records "Connection failed to Z3950.LOC.GOV." Does anyone know how to solve this? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list h

[Koha] Book Cover

Hi. Is there a way to show one cover image only. I mean, if I had uploaded a local image, the image from Amazon or Google won't show anymore for a particular book/record. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___

[Koha] DNS for OPAC

and our website is being host by web host provider. Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Library Attendance Monitoring

Hi. Can Koha be used as library attendance monitoring? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Specific Material Designation

Hi. In OPAC, it only shows material type like "Maps". Is it possible to also show the specific material designation? For example, "Maps : Atlas" and how to do it? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892

[Koha] On-site Checkout

Hi. When we use the on-site checkout, the status of the item checked out in OPAC is still available. Can it be changed to "On-site use" or something like that? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Ko

[Koha] On-Site Checkout

Hi. When we use the on-site checkout, the status of the item checked out in OPAC is still available. Can it be changed to "On-site use" or something like that? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Ko

Re: [Koha] On-Site Checkout

ut, so it will appear on > the users's account. Can you explain your question/use case a bit more? > > Katrin > > > *Gesendet:* Montag, 02. Juli 2018 um 15:49 Uhr > *Von:* "Ma. Victoria H. Silva-Manuel" > *An:* "Katrin Fischer" > *Betreff:* Re: [

Re: [Koha] On-Site Checkout

's account. Can you explain your question/use case a bit more? > > Katrin > > > *Gesendet:* Montag, 02. Juli 2018 um 15:49 Uhr > *Von:* "Ma. Victoria H. Silva-Manuel" > *An:* "Katrin Fischer" > *Betreff:* Re: [Koha] On-Site Checkout > hi. > sor

Re: [Koha] On-Site Checkout

lly? Thank you. Ma. Victoria S. Manuel, RL PRC No. 3892 On Tue, Jul 3, 2018, 8:21 AM Ma. Victoria H. Silva-Manuel < mavicsi...@gmail.com> wrote: > Hi. > > Some of our users have on-site checkout privilege only. In the Circulation > page, we have to click the "On-site checkou

Re: [Koha] On-Site Checkout

you want to allow for. > > Now when you forget to check the checkbox, there should be a message to > remember you. > > Maybe checking the checkbox automatically for a certain patron category > could be achieved using jQuery. > > Hope this helps, > > Katrin > | > On 04.

[Koha] eBook MARC Framework

Hi. Is there a site where we can download customize MARC frameworks for ebooks & other type of materials? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.c

[Koha] Relator Term

to edit this the way we want it to be shown in OPAC? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Some records are not searchable

Hi. We transferred our Koha to a new server. After the transfer, records created from November 2017 to August 28, 2018 are not searchable anymore. However, records created after the transfer are searchable. Any idea how to fix this problem. Thank you. -- Ma. Victoria H. Silva-Manuel

Re: [Koha] ISBN display

___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list htt

Re: [Koha] ISBN display

; 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 > -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Barcode

with different lengths we need to add extra zeros at the beginning of the barcode numbers. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https

[Koha] Shelf Management

Hi. Does Koha have shelf management tool? Where we can determine if the books are placed correctly on the shelf. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha

Re: [Koha] Shelf Management

t; Via Angelo Masina 5 > 00153 Rome > Italy > > T: +39 06 5846 417 > F: +39 06 5810 788 > > > On Thu, Oct 11, 2018 at 2:19 AM Ma. Victoria H. Silva-Manuel < > mavicsi...@gmail.com> wrote: > >> Hi. >> >> Does Koha have shelf management tool? Wh

[Koha] Not for Loan

as encountered:* The database returned the following error: Unknown column 'bi.marcxml' in 'field list' Please check the log for further details. Return to previous page <http://192.168.1.18:8080/cgi-bin/koha/reports/guided_reports.pl?reports=23&phase=Run%20this%20repo

Re: [Koha] Not for Loan

We are using 17.11.10. I followed your instructions but i'm still getting the same error message. On Tue, Oct 23, 2018 at 3:43 PM Bob Birchall wrote: > On 23/10/18 6:16 pm, Ma. Victoria H. Silva-Manuel wrote: > > Hi. > > > > I copied this SQL report >

Re: [Koha] Not for Loan

Yes, it worked like magic. Thank you so much for your help. On Tue, Oct 23, 2018 at 4:19 PM Bob Birchall wrote: > Ah yes, sorry. > Replace each occurrence of marcxml with metadata > > That should do it. > Bob > > On 23/10/18 6:51 pm, Ma. Victoria H. Silva-Manuel wrote: >

[Koha] Koha for Windows

Hi. Is there a guide about installing koha to windows? Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Cannot open OPAC

. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Apache default page

appreciated. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Apache default page

Hi. Yes, I did restart apache. I also stopped it & started it again but still no luck. Ma. Victoria S. Manuel, RL PRC No. 3892 On Fri, Dec 14, 2018, 8:36 PM Magnus Enger Hi! > > On Thu, 13 Dec 2018 at 07:50, Ma. Victoria H. Silva-Manuel > wrote: > > I installed Koha 18.11

[Koha] Cover Image from Amazon

Hi. I noticed that some of the book cover images from Amazon are not appearing in some records. Is it a bug or something? -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha

[Koha] Relator Term

help us. Thank you. Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Relator Term

ngs in both. > > Hope this helps, > > Katrin > > > *Gesendet:* Montag, 29. April 2019 um 10:44 Uhr > *Von:* "Ma. Victoria H. Silva-Manuel" > *An:* koha > *Betreff:* [Koha] Relator Term > Hi. > In our Koha, relator terms from Book MARC Framework

[Koha] Title/Subtitle List Report

marcxml' in 'field list' Please check the log for further details. Return to previous page Does anyone knows what went wrong? Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Title/Subtitle List Report

gt; and biblio_metadata > > Regards, > > Alvaro > > > > |-| > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > celular y Nextel > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS > y GPRS online > Visiten

[Koha] Staff activity report

Hi. I would like to know how to generate a report that includes each staff activities for certain dates. Thank you. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 0003892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz

[Koha] Kit as Default Material Type

I'm creating different frameworks for each material type (e.g. kit, thesis, audio-visual). Is there a way to change the default material type of each frameworks? ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo

[Koha] Change Item Status of All Items

Is there a way to edit "7 - Not for Loan" in field for all items encoded in Koha? -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.