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 <[email protected]> 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 <[email protected]> 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 > > *[email protected] <[email protected]>* > > > > 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 <[email protected]> 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 > >> [email protected] > >> https://lists.katipo.co.nz/mailman/listinfo/koha > >> > > _______________________________________________ > > Koha mailing list http://koha-community.org > > [email protected] > > 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 [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
