Re: [Koha] SQL - Request for change in shelving location

2016-04-01 Thread SATISH
Thank you Suzon, but I have a range or list of specific barcodes identified to be kept in reference, ex: 1, 253, 588 etc, it is random. In this case, in SQL, should I write. UPDATE items SET notforloan =1, location = 'REF' WHERE barcode = '1', '253' with thanks Satish On Fri, Apr 1, 2016 at 11:

[Koha] How to use Item Type ?

2016-04-01 Thread satishamv
Hi, I have a basic question regarding Item Type. Item Type is required for Circulation Policy settings and Report generation, etc. For a Single Bibliographic RECORD (book) having 2 copies (ITEM), Say example, Item Type 1 = "Book" meant for Circulation and Item Type 2 ="Reference Book" meant on

Re: [Koha] SQL - Request for change in shelving location

2016-04-01 Thread Indranil Das Gupta
Hi Satish, On Fri, Apr 1, 2016 at 12:55 PM, SATISH wrote: > Thank you Suzon, but I have a range or list of specific barcodes > identified to be kept in reference, > ex: 1, 253, 588 etc, it is random. > In this case, in SQL, > should I write. > > UPDATE items SET notforloan =1, > location = 'REF'

Re: [Koha] SQL - Request for change in shelving location

2016-04-01 Thread SATISH
Hi Indranil, What an amazing and powerful tool, super!! big thanks for directing me there, It worked for me ( I still use 3.16) and it's saved lot of time by just a single click. Thanks again Satish Librarian GEC Hassan. On Fri, Apr 1, 2016 at 2:16 PM, Indranil Das Gupta wrote: > Hi Satish, >

Re: [Koha] How to use Item Type ?

2016-04-01 Thread Joy Nelson
Satish- Yes you can use multiple itemtypes on one bibliographic record. Both of the options you list would work in your situation. The benefit of having two itemtypes is that it may be more clear to your users that one is REFERENCE and the other is a 'normal' BOOK. Joy On Fri, Apr 1, 2016 at 2:

Re: [Koha] How to use Item Type ?

2016-04-01 Thread Indranil Das Gupta
On Apr 1, 2016 7:03 PM, "Joy Nelson" wrote: > > Satish- > The benefit of having > two itemtypes is that it may be more clear to your users that one is > REFERENCE and the other is a 'normal' BOOK. +1 > Joy > ___ Koha mailing list http://koha-community

Re: [Koha] How to use Item Type ?

2016-04-01 Thread vikram zadgaonkar
+1 On 01-Apr-2016 7:07 PM, "Indranil Das Gupta" wrote: > On Apr 1, 2016 7:03 PM, "Joy Nelson" wrote: > > > > Satish- > > The benefit of having > > two itemtypes is that it may be more clear to your users that one is > > REFERENCE and the other is a 'normal' BOOK. > > +1 > > > Joy > > > _

Re: [Koha] SQL - Request for change in shelving location

2016-04-01 Thread SATISH
In batch modification of items, as indicated in previous mail It works only in one direction, I can modify items from "undefined/empty" to "Not for Loan" but the reverse is not working! I selected few barcodes and tried to undo the "Not for loan" to "undefined/empty" Any ideas! ___

Re: [Koha] Bug 9021 does not work in India and needs to be mentioned as such in the docs

2016-04-01 Thread Christopher Davis
Indranil, Thank you for the information. Take care, Christopher Davis, MLS Systems & E-Services Librarian Uintah County Library cgda...@uintah.utah.gov (435) 789-0091 ext.261 uintahlibrary.org basinlibraries.org facebook.com/uintahcountylibrary On Thu, Mar 31, 2016 at 11:19 PM, Indranil Das Gu

Re: [Koha] SQL - Request for change in shelving location

2016-04-01 Thread Indranil Das Gupta
Hi Satish, On Fri, Apr 1, 2016 at 7:14 PM, SATISH wrote: > In batch modification of items, as indicated in previous mail > It works only in one direction, I can modify items from "undefined/empty" to > "Not for Loan" > but the reverse is not working! > I selected few barcodes and tried to undo th

[Koha] Fwd: No results found!

2016-04-01 Thread regina kivuyo
i have installed koha ubuntu 12.04 though git-core git-email root@library-HP-Pro-3400-Series-MT:/usr/share/koha# service koha-index-daemon st art * Starting Koha indexing daemon (koha) /etc/init.d/koha-index-daemon: 60: /etc/init.d/koha-index-daem

Re: [Koha] Fwd: No results found!

2016-04-01 Thread Paul A
At 07:03 PM 4/1/2016 +0300, regina kivuyo wrote: [snip] when trying to run this sudo -u koha misc/migration_tools/rebuild_zebra.pl -z -b -a sudo: misc/migration_tools/rebuild_zebra.pl: command not found Please do not try that as root and/or sudo. Try su koha (or whatever username you chose dur