Winston,

  This is perfect, thank you.

  Side note:  The other suggestion I just got was to grab the ISSN-L table located at (http://www.issn.org/2-22637-What-is-an-ISSN-L.php).  Will mess around with both, but between the two I'm sure we'll get a solution online shortly.  Thanks again.

David K. Uspal
Technology Development Specialist
Falvey Memorial Library
Phone: 610-519-8954
Email: [log in to unmask]




-----Original Message-----
From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of Harris,Winston
Sent: Friday, May 04, 2012 4:05 PM
To: [log in to unmask]
Subject: Re: [CODE4LIB] Matching Print ISSNs to Electronic ISSNs.

The WorldCat xISSN service may do what you want.  You can feed it your original ISSN and it will return the ISSNs for all of the other forms.  There are different components, but the GetForms service could give you what you're looking for.

getForms

This service returns a list of ISSNs and its production form information in same group as the requested ISSN.

 http://xissn.worldcat.org/webservices/xid/issn/0036-8075?method=getForms&format=xml

The response is an XML formatted message similar to this example.

    	<?xml version="1.0" encoding="UTF-8"?> 
	<rsp xmlns="http://worldcat.org/xid/issn/" stat="ok">
	  <group  rel="this" >
	    <issn  form="JD">1095-9203</issn>
	    <issn  form="JB" >0036-8075</issn>
	  </group>
	</rsp>
  
In this example, JB is the ISSN of the print serial and JD is the ISSN of the Electronic serial.

Winston Harris
DBA, Chief Software Analyst
Library Information Technology
University of Florida
PO Box 117006, Gainesville, FL 32611

-----Original Message-----
From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of David Uspal
Sent: Friday, May 04, 2012 3:56 PM
To: [log in to unmask]
Subject: [CODE4LIB] Matching Print ISSNs to Electronic ISSNs.

All,

   I've hit a bit of a problem recently and I'm hoping someone on the list has seen this themselves and can offer advice/assistance.  

   I'm attempting to generate usage reports for the electronic materials in our library.  To do this, we generate two separate tables, then need to merge the results into one final document.  A fairly easy task normally, except for one glaring issue -- the unique key for these tables, the ISSNs, don't match.

  Apparently, the source of one of our reports is exporting print ISSNs wherein our internal listing use the electronic ISSNs.  To rectify this, we have two options -- either we can hand edit one of the sources to use the other type of ISSN (a HUGE undertaking), or (and hopefully) if there existed some resource that mapped print ISSNs to electronic ISSNs (ala an OCLC Authority database but for ISSNs), we could use this to map between the ISSN types.  Obviously, we prefer the latter.

    Has anyone else run into this issue?  How did they overcome this?  And is there a resource out there that will map between print ISSNs and electronic ISSN?  Thanks.

David K. Uspal
Technology Development Specialist
Falvey Memorial Library
Phone: 610-519-8954
Email: [log in to unmask]