Re: [Koha] Bulk items modification

Hi Katrin I'd like to try it. Is it by updating the items table- n itemlost_on field? You said earlier the datatype is date time. If you can or anyone else, kindly give me a query that would set the date to a date like 1st May 2020. I have access to the terminal. Thanks in advance. James On

Re: [Koha] [koha] SQL Report for withdrawn books.

Hi, Thanks Katrina and Alvaro for your time and effort. Katrin's suggestion solved my problem. If you have an idea on my string on batch editing dates for withdrawn/lost items to set an earlier one I would be more than happy Thank you all Regards James On Sat, Nov 28, 2020 at 12:39 PM Katrin

Re: [Koha] Different rules for borrowers from different libraries based on library

Hi, I haven't tried to set up something like this yet, but maybe one of these preferences will help: CircControl, HomeOrHoldingBranch, ReservesControlBranch. Hope this helps, Katrin On 27.11.20 03:38, Carlos Lopez wrote: Hi folks We're exploring setting up circulation rules for different

Re: [Koha] Managing replacement price during orders and receiving

Hi Sonia, could it be the format (price with decimal comma) that causes the issue? Otherwise it sounds like a bug. Hope you are well! Katrin On 23.11.20 17:41, BOUIS Sonia wrote: Hi, I'm searching a way to keep the information of the replacement price during all the order process (order

Re: [Koha] [koha] SQL Report for withdrawn books.

Hi, when using the |date, use the datepicker to set the date. Koha will automatically convert it to the correct format for the database in your query. I think the issue is that items.itemlost_on is a datetime. So use DATE() to get better results and use the datepicker to enter the dates! AND

Re: [Koha] Koha 20.11.00 released

Bravo!!! Obtener Outlook para iOS De: Koha en nombre de Amit Gupta Enviado: Saturday, November 28, 2020 10:35:23 AM Para: Tomas Cohen Arazi Cc: koha Asunto: Re: [Koha] Koha 20.11.00 released Congrats.. On Fri, 27 Nov 2020, 11:32 pm

Re: [Koha] Koha 20.11.00 released

Congrats.. On Fri, 27 Nov 2020, 11:32 pm Tomas Cohen Arazi, wrote: > Congrats! > > El vie, 27 nov 2020 a las 13:42, Jonathan Druart (< > jonathan.dru...@bugs.koha-community.org>) escribió: > > > Hello everybody, > > > > It is with great pleasure that the Koha community announces the > > release

Re: [Koha] Bulk items modification

Hi James, currently it's not possible to change the date from within Koha. It's automatically set to the date the status was changed to withdrawn. I think it can only be changed with SQL and database access. Katrin On 27.11.20 08:07, muiru james wrote: Hi, I marked some items as withdrawn