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@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---tp28514... Sent from the Koha - Discuss mailing list archive at Nabble.com.