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 <jcoeho...@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 > *jcoeho...@york.edu <jcoeho...@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 <lis4sat...@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@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
