Thank you Suzon, but I have a range or list of specific barcodes identified to be kept in reference, ex: 1, 253, 588 etc, it is random. In this case, in SQL, should I write. UPDATE items SET notforloan =1, location = 'REF' WHERE barcode = '1', '253' with thanks Satish On Fri, Apr 1, 2016 at 11:58 AM, Suzon Das <suzonduislm52@gmail.com> wrote:
Here is the code to Set what you requested :
UPDATE items SET notforloan =1, location = 'REF' WHERE barcode BETWEEN 1 AND 100
**FYI, this can not be run from Koha Intranet Interface's SQL. Use Command line from Terminal (Alt + Ctrl + T) then login to Mysql->koha_library database. Consider before affecting the original.
On 4/1/16, SATISH <lis4satish@gmail.com> wrote:
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
--
--
*Suzon Das* B.A., M.A. (DU) in Information Sc. and Library Management, .NET and Android Developer
Project Manager in SBAU Library
--