[Koha] Checkout limit by household

[Mark Alexander]

Our library (running Mandarin currently) has a limit of two DVDs
per household.  Mandarin doesn't enforce this limit; the librarian
knows pretty much everybody in this little town and has the data
in her head.  But we volunteers don't have that brainpower.

I have been working on a Koha upgrade for our library for some months,
and am pretty close to having everything working.  But this household
limit has me a bit stumped.  For one thing, our patron database is a
bit inconsistent, so if we define "household" as being "all borrowers
with the same address", we're in trouble because the same address
might be spelled several different ways.  (For example, Route can be
RT or RTE or Rte. or Rt. or Rt)

But leaving aside the consistency problem, Koha doesn't seem to have
a way to do this kind of check.  I can cobble together some SQL that
looks like this:

  select count(issue_id) from issues
left join borrowers on issues.borrowernumber = borrowers.borrowernumber
left join items on issues.itemnumber = items.itemnumber
where borrowers.address = '123 Main Street'
and city = 'Podunk'
and state = 'VT'
and items.itype = 'DVD';

and then check this result against configurable checkout limits for
particular item types.  This sounds like a fair amount of work in the
Koha codebase itself, so I was wondering if anybody else had looked
into this and had other ideas.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Unknown column 'me.lastseen' in 'field list' in KOHA

[Luis Moises Rojas]

hi,
i ran the upgrade_schema and nothing happens.
The version es 16.11

I made a backup from the previous version 16 (the one we are using) and try
to restore, then run the _schema andnothing happen


On Thu, Jan 19, 2017 at 9:24 AM, Luis Moises Rojas 
wrote:

> No, i am not using plack.
> Everything is mess, 'cos koha does not want to start now.
> I will let you know after rebuild the schema.
>
> On Thu, Jan 19, 2017 at 4:25 AM, Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> wrote:
>
>> An upgrade to which version? 16.11?
>> That column is added by bug 16276 and is only in 16.11, so I guess it is
>> the one.
>> Everything looks fine for me.
>> If you are using Plack you should restart it.
>>
>> "Everything is mess"
>> What else is a mess?
>>
>>
>> On Thu, 19 Jan 2017 at 02:28 Luis Moises Rojas 
>> wrote:
>>
>>> Koha 3.16
>>> Everything was working ok,
>>> Yes, an upgrade, after: everything is a mess.
>>>
>>> On Wed, Jan 18, 2017 at 4:48 PM, Katrin 
>>> wrote:
>>>
>>> > Hi,
>>> >
>>> > I don't know have an answer, but some questions that might help others
>>> to
>>> > see where the problem is:
>>> >
>>> > Which version of Koha are you running?
>>> > How was it installed?
>>> > Did you recently update or do some other maintenance that might be
>>> related
>>> > to the error?
>>> >
>>> > Hope this helps,
>>> >
>>> > Katrin
>>> >
>>> > On 18.01.2017 21:40, Luis Moises Rojas wrote:
>>> >
>>> >> My Koha was working, but without any reason we are having this error
>>> and
>>> >> we
>>> >> do not why: DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
>>> >> 'me.lastseen' in 'field list'
>>> >>
>>> >> Any idea, pls?
>>> >> Thanks a lot
>>> >>
>>> >
>>> > ___
>>> > Koha mailing list  http://koha-community.org
>>> > Koha@lists.katipo.co.nz
>>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>>> >
>>>
>>>
>>>
>>> --
>>> *Luis Moisés Rojas P.*
>>> ___
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>
>
>
> --
> *Luis Moisés Rojas P.*
>
>


-- 
*Luis Moisés Rojas P.*
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Erase or hide all records with itemtype "on order"

[Hugo Agud]

Good morning

Depending on the version of koha you're using, in tools you have the batch
item deletion, you just need to set up a report that looks for barcodess
for those items that have on order,, copy and paste into batch item
deletion.

It sounds easy ;)

2017-01-20 10:10 GMT+01:00 :

> Hello,
>
>
>
> We have a quite big problem in our catalog.
>
> Every time we buy books and import records through Z39.50 from national
> catalog we get like from 2 up to 30 records.
>
> All of them have got object attached "on order" automatically.
>
> At the moment we have around double the number of records comparing to
> actual number of items.
>
> Is any way to erase them? Is it possible for librarian to do it or must be
> the IT who can do such a work?
>
>
>
>
> Med vänlig hälsning
> Lukasz Mesek
> Vuxenbibliotekarie
> Alingsås bibliotek
> lukasz.me...@alingsas.se
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 

*Hugo Agud - Orex Digital *

*www.orex.es *


[image: www.orex.es/koha] 
   [image: www.orex.es/vufind] 



Director

Calle Sant Joaquin,117, 2º-3ª · 08922 Santa Coloma de Gramanet - Tel: 933
856 138   ha...@orex.es · http://www.orex.es/



No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
implica la tala de 15 árboles y el consumo de 250.000 litros de agua.



Aviso de confidencialidad
Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
está autorizado a recibirlo por el remitente), no está autorizado a copiar,
reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Erase or hide all records with itemtype "on order"

[lukasz . mesek]

Hello,



We have a quite big problem in our catalog.

Every time we buy books and import records through Z39.50 from national catalog 
we get like from 2 up to 30 records.

All of them have got object attached "on order" automatically.

At the moment we have around double the number of records comparing to actual 
number of items.

Is any way to erase them? Is it possible for librarian to do it or must be the 
IT who can do such a work?




Med vänlig hälsning
Lukasz Mesek
Vuxenbibliotekarie
Alingsås bibliotek
lukasz.me...@alingsas.se
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha