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
Email: [log in to unmask]