[Koha] SQL - Request for change in shelving location

[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 <indradg at gmail.com>
wrote:

> Hi Satish,
>
> On Fri, Apr 1, 2016 at 12:55 PM, SATISH <lis4satish at 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
>



--