[Koha] SQL - Request for change in shelving location

[SATISH]

Hi Suzon,
Thank you for the reply,
Yes, I have  root access to MySql and Koha,
Yes, I understood, altering or updating is dangerous, but
it is very much required to save the time, and I will not touch other sql
tables!!
Please provide the solution!!

with thanks
Satish

On Thu, Mar 31, 2016 at 11:41 PM, Suzon Das <suzonduislm52 at gmail.com> wrote:

> Your requested Sql may be helpful but also dangerous. BTW, If you want
> I may help you. Do you have access to Mysql database of Koha_library?
>
> On 3/31/16, Coehoorn, Joel <jcoehoorn at york.edu> wrote:
> > 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
> >>
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
> --
>
> *Suzon Das*
> B.A., M.A. (DU) in Information Sc. and Library Management,
> .NET and Android Developer
>
> Project Manager in
> SBAU Library
>



--