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

[Daniel Grobani]

Vimal emailed me off-list with the data he needs to extract. This should do
it:

SELECT
extractValue(marcxml,"collection/record/datafield[@tag='952'][1]/subfield[@code='p']"),
	
extractValue(marcxml,"collection/record/datafield[@tag='024'][1]/subfield[@code='a']"),
	
extractValue(marcxml,"collection/record/datafield[@tag='020'][1]/subfield[@code='a']"),
	
extractValue(marcxml,"collection/record/datafield[@tag='100'][1]/subfield[@code='a']"),
	
extractValue(marcxml,"collection/record/datafield[@tag='245'][1]/subfield[@code='a']"),
	
extractValue(marcxml,"collection/record/datafield[@tag='650'][1]/subfield[@code='a']"),
	
extractValue(marcxml,"collection/record/datafield[@tag='500'][1]/subfield[@code='a]"),
	
extractValue(marcxml,"collection/record/datafield[@tag='520'][1]/subfield[@code='a']"),
	
extractValue(marcxml,"collection/record/datafield[@tag='650'][1]/subfield[@code='a']")
FROM	biblioitems

Cheers,
Daniel




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