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 <[email protected]> wrote: > Hi Satish, > > On Fri, Apr 1, 2016 at 12:55 PM, SATISH <[email protected]> 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' WHERE barcode = '1', '253' > <snipped> > > > You are approaching the issue from a more difficult and IMHO a *bad* > angle, especially since you are not adept at SQL and you are trying to > directly edit the database, which should be avoided as far as > possible. > > What you *should* be using in this case is follow > http://manual.koha-community.org/3.22/en/batchmodifyitems.html > > I'm assuming you are using the latest Koha i.e. 3.22 series. > > cheers > -Indranil > > > -- > Indranil Das Gupta > L2C2 Technologies > > Phone : +91-98300-20971 > IRC : indradg on irc://irc.freenode.net > Twitter : indradg > Facebook : https://www.facebook.com/l2c2technologies/ > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- > Please exchange editable Office documents only in ODF Format. No other > format is acceptable. Support Open Standards. > > For a free editor supporting ODF, please visit LibreOffice - > http://www.documentfoundation.org > -- _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
