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

[Vimal Kumar]

Dear Daniel,

I applied the SQL query in Tools > Reports > Guided Reports Wizard > Create
from SQL.
I saved the csv file.
But CSV file contain the following message,


     <h1>Koha error</h1>  <p>The following fatal error has
occurred:</p>  <pre><code>Can't use an undefined value as an ARRAY
reference at
/usr/share/koha/intranet/cgi-bin/reports/guided_reports.pl line 461.
</code></pre>  <table>


Can you check what the problem happened while generating report?

Following is the SQL query for the reference of other community members who
have  interest in this topic,

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


I request other community members attention to this topic.

Regards
-- 
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100512/2e87a233/attachment.htm