This is my first attempt at mapping the fields returned from the WoS API to LOM – hopefully this can form the basis of an appropriate XSLT transformation.
As my template I’ve used the first record from Mike’s full query to the API which happens to be a book review. It might have been better to start with a journal article but we’ll obviously need to look at the full range of records (N.B. Will we actually be able to return <doctype> when API restrictions are applied?)
Metadata | WoS API field[s] | LOM field[s] |
Record unique identifier | <ut>ISI UT identifier</ut> | <lom:identifier><lom:entry>ISI UT identifier</lom:entry></lom:identifier> |
<ns0:bibliographicCitation xmlns:imsmd=”http://www.imsglobal.org/xsd/imsmd_v1p2″> | ||
Source title | <source_title>TITLE</source_title> | <ns0:title><ns0:string >TITLE</ns0:string></ns0:title> |
Volume/issue/pages/Date (month/year) | <bib_id>31 (7): 1116-1117 NOV 2009</bib_id> | <ns0:volume>31</ns0:volume><ns0:issue>7</ns0:issue><ns0:date>NOV 2009</ns0:date> |
Pages | <bib_pages begin=”1116” end=”1117” pages=”2“>1116-1117</bib_pages> | <ns0:spage>1116</ns0:spage><ns0:epage>1117</ns0:epage> |
</ns0:bibliographicCitation> | ||
Date(year)/volume | <bib_issue year=”2009” vol=”31” /> | <ns0:volume>31</ns0:volume><ns0:date>NOV 2009</ns0:date> |
Item title | <item_title>ITEM TITLE</item_title> | <lom:title><lom:string >ITEM TITLE</lom:string></lom:title> |
Author(role/name) | <authors count=”1“><primaryauthor>Robertson, S</primaryauthor><fullauthorname> <AuRole>Author, Reprint Author</AuRole> <AuLastName>Robertson</AuLastName> <AuFirstName> Steve</AuFirstName> <address number=”1“>Leeds Metropolitan Univ, Ctr Mens Hlth, Leeds LS1 3HE, W Yorkshire, England</address> <AuCollectiveName> Robertson, Steve</AuCollectiveName> </fullauthorname></authors> | <lom:lifeCycle><lom:contribute><lom:role><lom:source>LOMv1.0</lom:source><lom:value>author</lom:value></lom:role><lom:entity>BEGIN:vcard
FN:Steve Robertson
END:vcard</lom:entity></lom:contribute>
</lom:lifeCycle> |
The XML for the record is reproduced below with relevant fields emphasise in red/bold:
<REC inst_id="0" recid="184349093" hot="yes" sortkey="3067387552" timescited="0" sharedrefs="0" inpi="false">
<item issue="184349006" recid="184349093" coverdate="200911" sortkey="3067387552" refkey="5892051" dbyear="2009">
<ut>000271043700017</ut>
<i_ckey>ROBE1116090031SS</i_ckey>
<i_cid>0130983640</i_cid>
<source_title>SOCIOLOGY OF HEALTH & ILLNESS</source_title>
<source_abbrev>SOCIOL HEALTH ILL</source_abbrev>
<item_title>Men’s Health: Body, Identity and Social Context</item_title>
<sq>06031J0</sq>
<bib_id>31 (7): 1116-1117 NOV 2009</bib_id>
<bib_pages begin="1116" end="1117" pages="2">1116-1117</bib_pages>
<bib_issue year="2009" vol="31"/>
<doctype code="B">Book Review</doctype>
<editions full="SSCI"/>
<languages count="1">
<primarylang code="EN">English</primarylang>
</languages>
<reviewed_work>
<rw_langs count="1">
<rw_lang code="EN">English</rw_lang>
</rw_langs>
<rw_authors count="2">
<rw_author>Broom, A</rw_author>
<rw_author>Tovey, P</rw_author>
</rw_authors>
<rw_year>2009</rw_year>
</reviewed_work>
<authors count="1">
<primaryauthor>Robertson, S</primaryauthor>
<fullauthorname>
<AuRole>Author, Reprint Author</AuRole>
<AuLastName>Robertson</AuLastName>
<AuFirstName>Steve</AuFirstName>
<address number="1">
Leeds Metropolitan Univ, Ctr Mens Hlth, Leeds LS1 3HE, W Yorkshire, England
</address>
<AuCollectiveName>Robertson, Steve</AuCollectiveName>
</fullauthorname>
</authors>
<reprint>
<rp_author>Robertson, S</rp_author>
<rp_address>Leeds Metropolitan Univ, Ctr Mens Hlth, Leeds LS1 3HE, W Yorkshire, England</rp_address>
<rp_organization>Leeds Metropolitan Univ</rp_organization>
<rp_suborganizations count="1">
<rp_suborganization>Ctr Mens Hlth</rp_suborganization>
</rp_suborganizations>
<rp_city>Leeds</rp_city>
<rp_state>W Yorkshire</rp_state>
<rp_country>England</rp_country>
<rp_zips count="1">
<rp_zip location="AC">LS1 3HE</rp_zip>
</rp_zips>
</reprint>
<research_addrs count="1">
<research>
<rs_address number="1">Leeds Metropolitan Univ, Ctr Mens Hlth, Leeds LS1 3HE, W Yorkshire, England</rs_address>
<rs_organization>Leeds Metropolitan Univ</rs_organization>
<rs_suborganizations count="1">
<rs_suborganization>Ctr Mens Hlth</rs_suborganization>
</rs_suborganizations>
<rs_city>Leeds</rs_city>
<rs_state>W Yorkshire</rs_state>
<rs_country>England</rs_country>
<rs_zips count="1">
<rs_zip location="AC">LS1 3HE</rs_zip>
</rs_zips>
</research>
</research_addrs>
<abstract avail="N"/>
<refs count="1">
<ref>184349094</ref>
</refs>
</item>
</REC>
As Mike points out, we should bear in mind that there are variations in the fields that come back from the WoS API, for example: bib_id – depends on what bib data has been entered into WoS; authors – The level of detail varies here too, sometimes there is no full author name and so on….all of which will impact on the sophistication we require from the XSLT.