[Koha] SQL - Request for change in shelving location

[Coehoorn, Joel]

The sql part is not all that hard, but I'm not sure that will do the whole
job. I might be mistaken about this, but something tells me you'd end up
creating a disconnect between the koha database and stored marc data.



Joel Coehoorn
Director of Information Technology
402.363.5603
*jcoehoorn at york.edu <jcoehoorn at york.edu>*

The mission of York College is to transform lives through
Christ-centered education and to equip students for lifelong service to
God, family, and society

On Wed, Mar 30, 2016 at 1:16 AM, SATISH <lis4satish at gmail.com> wrote:

> Hi,
>
> My Koha (3.16) has been installed from packages method on ubuntu 12.4 LTS
> Desktop.
>
>
> I have to set huge number of items (various barcode) among many Records
> into Shelving location called = Reference Section.
>
> I mean, I have pick specified barcode (item) from each record to a location
> called "Reference section".  Previously, While entering bibliographic
> details, I did not set specific barcode(item) into location =referece
> section, and
> now doing manually one by one will consume huge time, therefore, I request,
>
>
> Using SQL
> how to set following two specific conditions for the specified barcode
> (item) having barcode numbers from "1, 2, 3..to 100" set to:
>
> 1) 7- Not for Loan to  "Not for Loan" (Previously this field is empty)
> 2) c-Shelving Location to " Reference section" (Previously this field was
> set to shelving location called "General Stock"
>
> Can koha community, please help me to save my time for doing this job using
> "sql" ??
>
> thank you in advance,
> Satish MV
> Librarian
> Govt. Engineering College,
> Hassan, Karnataka.
> INDIA
> --
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>