Re: [Koha] Koha Inventory tool 3.14.4

2014-11-25 Thread library
Thank you for your reply. In the end I was being optimistic as there is no 'date last seen' field to change. However our tech support came through and upgraded us to 3.16. Regards Ann Murphy On Tue, Nov 25, 2014 at 6:49 PM, Karam Qubsi wrote: > Hi , > If you can change them in a batch 'the date

Re: [Koha] Checkout time in logs is wrong

2014-11-25 Thread Tomas Cohen Arazi
Please fill a bug report with the precise steps to reproduce the problem. El mar, nov 25, 2014 09:59 AM, Evan Lloyd escribió: > I have this same problem running Koha 3.16.04 on a virtual machine. I have > checked the time zone of the host machine, the time zone of guest machine, > as well as the

Re: [Koha] Checkout time in logs is wrong

2014-11-25 Thread Evan Lloyd
I have this same problem running Koha 3.16.04 on a virtual machine. I have checked the time zone of the host machine, the time zone of guest machine, as well as the time zone stored in MySQL. They are all the same (in my case GMT +9), however the time that is created for checkouts is obviously in a

[Koha] Checkout time in logs is wrong

2014-11-25 Thread Ketan Kulkarni
Hello Koha people, We have a strange problem. One of the koha installations shows wrong checkout time in checkout history. We have checked server timezone. It's correct. The check-in times are correct, surprizingly. Any help in understanding what is going wrong is appreciated. Thank you. Ketan

Re: [Koha] Catalogue - SQL Report Help

2014-11-25 Thread SATISH
Koha 3.16.00.000 installed via packages method, on ubuntu desktop. On Tue, Nov 25, 2014 at 4:22 PM, vikram zadgaonkar < vikramczadgaon...@gmail.com> wrote: > Ok. Let me check. I will mail you SQL query. > Which koha version you are using? > > Vikram Zadgaonkar > > On Tue, Nov 25, 2014 at 4:20 PM,

Re: [Koha] Catalogue - SQL Report Help

2014-11-25 Thread vikram zadgaonkar
Ok. Let me check. I will mail you SQL query. Which koha version you are using? Vikram Zadgaonkar On Tue, Nov 25, 2014 at 4:20 PM, SATISH wrote: > The same is not available over there. > Many examples in the website, fetches for whole items in the library. > I need to have report on List of Uniq

Re: [Koha] Catalogue - SQL Report Help

2014-11-25 Thread SATISH
The same is not available over there. Many examples in the website, fetches for whole items in the library. I need to have report on List of Unique titles available in the library ( i.e., Records) and Total Number of books (i.e.,Items). report should include list of {title,author,publisher,edition,

[Koha] Circulation rule in two/branced libraries

2014-11-25 Thread Vinod Kumar Mishra
Dear All, Is it possible to make circulation rules for the same user/group of patrons in two different libraries if created on same koha instance? for example if a user is having facility to avail some books from central library and some from departmental/branch library. Any Tips? Thanking You

Re: [Koha] Catalogue - SQL Report Help

2014-11-25 Thread vikram zadgaonkar
Hi, You can try following link http://wiki.koha-community.org/wiki/SQL_Reports_Library Vikram Zadgaonkar On Tue, Nov 25, 2014 at 1:33 PM, satishamv wrote: > Dear Friends, > I am looking for a report which has list of all unique titles(biblio > records) in a home library AND also by collection c

[Koha] Catalogue - SQL Report Help

2014-11-25 Thread satishamv
Dear Friends, I am looking for a report which has list of all unique titles(biblio records) in a home library AND also by collection code. In my case, new record is created for - change in edition or change in item type. with thanks. Satish MV Librarian Govt. Engineering College, Hassan. Karna