Re: [Koha] Email notices

2014-11-12 Thread Jonathan Druart
Hello Paul, If I am not wrong, the DUEDGST (and DUE) is used when you set advanced notices to 0 day, otherwise it's PREDUEDGST (and PREDUE). To loop on items, you should use the item tag. The default messaging preferences will only affect new patrons. But you can use

[Koha] Zebra indexing error

2014-11-12 Thread Araik Manukyan
Hi List! We have upgraded our koha from 3.14 to 3.16 ,then removed zebra index. When we want to rebuild zebra using ./rebuild_zebra.pl -b -a -r -v , it brings such errors Please, help to solve this problem. Best regards, Araik

Re: [Koha] How to know Table name used with column names where user login passwords are stored in KOHA.

2014-11-12 Thread Sebastian Krieg
Hello Abdullah, you will find all informations in the table 'borrowers', the fieldnames describes the information. The user password in the field 'password' is encrypted. I hope this is usefull for you. Greetings Sebastian Am Dienstag, 11. November 2014, 23:18:48 schrieb Abdullah

Re: [Koha] Restrict Patron just to the library the Item is from

2014-11-12 Thread anjoze
vikram zadgaonkar-2 wrote That's what . If a patron is has damaged or lost a book from library A how can you allow him to borrow from other branch. On 24-Oct-2014 9:30 PM, anjoze lt; joseanjos@ gt; wrote: Sorry I mean: Restrict just to Library A and let him borrow on libraries B and C?

Re: [Koha] (Hour) Fine charging interval..

2014-11-12 Thread Kathy Hines
Go to Admin-system preferences-check in policy it's the first one calculate fines on return Checkin Policy Preference Value BlockReturnOfWithdrawnItems returning of items that have been withdrawn. CalculateFinesOnReturn calculate and update overdue charges when an item is returned.

Re: [Koha] Restrict Patron just to the library the Item is from

2014-11-12 Thread Chris Cormack
On 13/11/2014 4:08 am, anjoze josean...@gmail.com wrote: vikram zadgaonkar-2 wrote That's what . If a patron is has damaged or lost a book from library A how can you allow him to borrow from other branch. On 24-Oct-2014 9:30 PM, anjoze lt; joseanjos@ gt; wrote: Sorry I mean:

Re: [Koha] How to know Table name used with column names where user login passwords are stored in KOHA.

2014-11-12 Thread Robin Sheat
Abdullah Al-Modabber schreef op di 11-11-2014 om 23:18 [-0800]: Table name used with column names where user login passwords are stored. This is needed to configure Ezproxy authentication through Koha It's not very likely that ezproxy can handle Koha's encrypted password storage directly,

Re: [Koha] How to know Table name used with column names where user login passwords are stored in KOHA.

2014-11-12 Thread Galen Charlton
Hi, On Wed, Nov 12, 2014 at 2:28 PM, Robin Sheat ro...@catalyst.net.nz wrote: I think ezproxy can authenticate by SIP2 though, perhaps that should be used instead. Indeed, it can use SIP2. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source

[Koha] Adding a field to an existing record

2014-11-12 Thread Stacy Pober
We're using Koha version 3.16.04.000. Sometimes we want to edit a MARC record in Koha and add a field that is not already in the record - for example, a 910 field. The 910 field is listed in the framework set up for that record type, but when we go to the editing interface the field is not

[Koha] How can I extract a list of vendors?

2014-11-12 Thread Elaine Bradtke
We're running 3.16 and a colleague would like a list of the vendors we use. I don't see any way to do this through the staff interface, or via a report. Is it possible to do it otherwise? If so could you give me enough info so I can pass it on to my IT person? Thanks -- Elaine Bradtke Data

Re: [Koha] How can I extract a list of vendors?

2014-11-12 Thread Liz Rea
Hi Elaine, Try this: SELECT name FROM aqbooksellers Cheers, Liz On 13/11/14 13:39, Elaine Bradtke wrote: We're running 3.16 and a colleague would like a list of the vendors we use. I don't see any way to do this through the staff interface, or via a report. Is it possible to do it otherwise?

Re: [Koha] Adding a field to an existing record

2014-11-12 Thread Liz Rea
Hi Stacy, Try this: Go to More - Administration - MARC Bibliographic Framework Click MARC Structure next to the framework you'd like to edit Search for 910 in the Search for Tag box Click Subfields next to the 910 Click Edit next to subfield a (or whichever subfield you are wanting to show in

Re: [Koha] How can I extract a list of vendors?

2014-11-12 Thread Elaine Bradtke
That's a good start, but I also need the contact info. I'll see if I can expand on that. On Thu, Nov 13, 2014 at 12:46 AM, Liz Rea l...@catalyst.net.nz wrote: Hi Elaine, Try this: SELECT name FROM aqbooksellers Cheers, Liz On 13/11/14 13:39, Elaine Bradtke wrote: We're running 3.16

Re: [Koha] How can I extract a list of vendors?

2014-11-12 Thread Liz Rea
http://schema.koha-community.org/tables/aqbooksellers.html may help. :) Liz On 13/11/14 14:09, Elaine Bradtke wrote: That's a good start, but I also need the contact info. I'll see if I can expand on that. On Thu, Nov 13, 2014 at 12:46 AM, Liz Rea l...@catalyst.net.nz wrote: Hi Elaine,

Re: [Koha] How can I extract a list of vendors?

2014-11-12 Thread Elaine Bradtke
Thanks, I've got it now. SELECT name, postal, contemail FROM aqbooksellers On Thu, Nov 13, 2014 at 1:11 AM, Liz Rea l...@catalyst.net.nz wrote: http://schema.koha-community.org/tables/aqbooksellers.html may help. :) Liz On 13/11/14 14:09, Elaine Bradtke wrote: That's a good start, but I

Re: [Koha] (Hour) Fine charging interval..

2014-11-12 Thread Jerwyn Fernandez
Hi Kathy, Yes all those are set. My concern is how do I set it, that it will charge/fine every one (1) hour? If I am not mistaken its under *Fine charging interval.* Regards, On Thu, Nov 13, 2014 at 12:46 AM, Kathy Hines khi...@cityof.lawton.ok.us wrote: Go to Admin-system

[Koha] Report filtered by item type fails

2014-11-12 Thread Elaine Bradtke
Koha 3.16 According to my statistical report, we have 848 biblios that are continuing resources (BIBITEMTYPE CR) But when I try to build a report that limits the output to these records I get only a handful of records (these uniquely have items attached, 99% of our CR records do not, so this

Re: [Koha] Adding a field to an existing record

2014-11-12 Thread Stacy Pober
Worked like a charm. Thanks so much! Stacy Date: Thu, 13 Nov 2014 13:49:35 +1300 From: Liz Rea l...@catalyst.net.nz To: koha@lists.katipo.co.nz Subject: Re: [Koha] Adding a field to an existing record Message-ID: 5464001f.4060...@catalyst.net.nz Content-Type: text/plain;

Re: [Koha] Report filtered by item type fails

2014-11-12 Thread Liz Rea
Hi Elaine, What happens if you try SELECT itemtype, biblionumber FROM biblioitems WHERE itemtype = 'CR' - are your results any different? Cheers, Liz On 13/11/14 14:43, Elaine Bradtke wrote: Koha 3.16 According to my statistical report, we have 848 biblios that are continuing resources

Re: [Koha] Report filtered by item type fails

2014-11-12 Thread Elaine Bradtke
What happens if you try SELECT itemtype, biblionumber FROM biblioitems WHERE itemtype = 'CR' - are your results any different? I get a list of biblionumbers with itemtype CR - the correct number of them. (848) But when I run this: SELECT