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 <indradg@gmail.com> wrote:
Hi Satish,
On Fri, Apr 1, 2016 at 12:55 PM, SATISH <lis4satish@gmail.com> 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
--