[Koha] SQL - Request for change in shelving location

[Suzon Das]

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