If you have the right version of MySQL you can use the MarcExtract in your query to grab the 050 - some tips here: http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC
Nicole On Tue, Jul 19, 2011 at 10:22 AM, Yohannes Mulugeta <yohannesm...@gmail.com> wrote: > Dear folks, > > I'm using Koha ver 3.2. I want to extract the Title, Author, > itemcallnumber, (LC call no.), barcode, holdingbranch directly from > mySQL tables. But the itemcallnumber field is empty. The call number > is available in the marcxml and marc field in biblioitems table. > > After migrating the bibliographic records from verion 2.4 to the Koha > 2.9 and then Koha 3.2, the classification field which we used to store > our call number is not available in the current biblioitems table. > > So, is there a way to select the call number data (tag 050) only from > marcxml or marc field in the biblioitem table. Becuase most of our > call number were stored in the older version of Koha, > classification.biblioitems, are not available in Koha version 3.2. As > a result the itemcallnumber field is almost empty. > > Any help please. > > Yohannes Mulugeta > Addis Ababa University Libraries > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha