[Koha] Help regarding 'items.itemcallnumber' (re-sent message)

Joseph Coelho SJ joecoelhosj at gmail.com
Sun Aug 28 01:24:12 NZST 2005


_I am re-sending this message since I sent it from the wrong email address:_

Hello.

I am running Koha 2.2.3 on Windows 98. About 2,800 (out of the over 
40,000) books of our library have already been entered into the 
database. The small hitches have been sorted out and things as of now 
are going on well. The 'Circulation' part has not yet been used (though 
it has been tested).

However, I have one problem which I am not able to solve.

The field 'biblioitems.classification' is mapped to the MARC tag 942 $a 
(Institution Code)
I would like to also store this value in the field 
'items.itemcallnumber' for every item of the particular biblio.

I could not find any way out and, therefore, now run this script in 
MySQL after the day's data entry is done:
use blank223
update items,biblioitems set 
items.itemcallnumber=biblioitems.classification where 
items.biblionumber=biblioitems.biblionumber;
quit

I tried peeking into the code in additems.pl but could not understand 
where I can tweak to get any change done.

I will be grateful if anyone can tell me what is the code I should 
include and where. I guess it may just be a line or two. (I am not a 
Perl programmer!)

Thanks in anticipation.

Good wishes
Joe Coelho, SJ
Pune, India.

-- 
Joseph Coelho SJ (KHM)
De Nobili College, Nagar Road, Ramwadi
Post Box 3007
Pune 411014. INDIA

(020) 2703-4401/4737
joecoelhosj at jesuits.net
joecoelhosj at gmail.com




-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.10.13/78 - Release Date: 8/19/05

_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha



More information about the Koha mailing list