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@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@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@york.edu <jcoehoorn@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@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
--