SQL - Request for change in shelving location
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 --
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
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
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
--
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
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
--
Hi Satish, On Fri, Apr 1, 2016 at 12:55 PM, SATISH <lis4satish@gmail.com> wrote:
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' <snipped>
You are approaching the issue from a more difficult and IMHO a *bad* angle, especially since you are not adept at SQL and you are trying to directly edit the database, which should be avoided as far as possible. What you *should* be using in this case is follow http://manual.koha-community.org/3.22/en/batchmodifyitems.html I'm assuming you are using the latest Koha i.e. 3.22 series. cheers -Indranil -- Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 IRC : indradg on irc://irc.freenode.net Twitter : indradg Facebook : https://www.facebook.com/l2c2technologies/ -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org
Hi Indranil, What an amazing and powerful tool, super!! big thanks for directing me there, It worked for me ( I still use 3.16) and it's saved lot of time by just a single click. Thanks again Satish Librarian GEC Hassan. On Fri, Apr 1, 2016 at 2:16 PM, Indranil Das Gupta <indradg@gmail.com> wrote:
Hi Satish,
On Fri, Apr 1, 2016 at 12:55 PM, SATISH <lis4satish@gmail.com> wrote:
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' <snipped>
You are approaching the issue from a more difficult and IMHO a *bad* angle, especially since you are not adept at SQL and you are trying to directly edit the database, which should be avoided as far as possible.
What you *should* be using in this case is follow http://manual.koha-community.org/3.22/en/batchmodifyitems.html
I'm assuming you are using the latest Koha i.e. 3.22 series.
cheers -Indranil
-- Indranil Das Gupta L2C2 Technologies
Phone : +91-98300-20971 IRC : indradg on irc://irc.freenode.net Twitter : indradg Facebook : https://www.facebook.com/l2c2technologies/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards.
For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org
--
In batch modification of items, as indicated in previous mail It works only in one direction, I can modify items from "undefined/empty" to "Not for Loan" but the reverse is not working! I selected few barcodes and tried to undo the "Not for loan" to "undefined/empty" Any ideas!
Hi Satish, On Fri, Apr 1, 2016 at 7:14 PM, SATISH <lis4satish@gmail.com> wrote:
In batch modification of items, as indicated in previous mail It works only in one direction, I can modify items from "undefined/empty" to "Not for Loan" but the reverse is not working! I selected few barcodes and tried to undo the "Not for loan" to "undefined/empty" Any ideas!
Yes! It is because you =are using a version of Koha that is way old (3.16 series). You just got hit by this https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13500 The fix for this was released in Koha 3.18.2. Basically, you need to upgrade your Koha. cheers, -- Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org
participants (4)
-
Coehoorn, Joel -
Indranil Das Gupta -
SATISH -
Suzon Das