[Koha] How to extract tag 050 data only in marcxml field from biblioitems table

[Nicole Engard]

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
<yohannesmulu at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>