[Koha] How to extract data from marcxml.biblioitmes ?

[Daniel Grobani]

Hi,

I did some work recently extracting data from the marcxml field. 

These resources gave me a general idea about the relevant MySQL functions
and about XPath, the notation used to extract data from the marcxml field:

http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html
http://dev.mysql.com/tech-resources/articles/mysql-5.1-xml.html
http://www.w3schools.com/xpath/xpath_syntax.asp

If you specify exactly which MARC tags & subfields you want, I'll see if I
can help with a query.

Cheers,

Daniel Grobani
System Administrator
John A. Graziano Memorial Library
Samuel Merritt University
http://www.samuelmerritt.edu/library



Vimal Kumar-3 wrote:
> 
> Dear Friends,
> I would like to prepare a report from "marcxml" field in "biblioitems"
> table.
> The report should include author, title, subject and abstract.
> I got some hint from koha wiki page,
> http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC
> 
> But I failed to  wrote an SQL query for the purpose.
> I am not familiar with writing query to extract data from XML part in
> MySQL.
> Can you help me to prepare a report from "marcxml" ?
> 
> If anybody from developers or users give guideline with examples, that
> will
> be a good contribution to Koha community.
> 
> -- 
> Vimal Kumar V.
> Asst. Librarian
> Asian School of Business
> Technopark, Trivandrum-695 581
> Web: www.vimalkumar.co.nr
> Blog: http://vimalkumar.oksociety.in
> 
> OK Society Volunteer. http://oksociety.in
> ---------------------------------------------------------------------------
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> 
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> 
> 

-- 
View this message in context: http://old.nabble.com/How-to-extract-data-from-marcxml.biblioitmes---tp28514170p28517451.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.