datadryad / dryad-product-roadmap

Repository of issues for Dryad project boards
https://github.com/orgs/datadryad/projects
8 stars 0 forks source link

Infill journal ISSNs (stash_engine_journal_issns) #2578

Open ryscher opened 1 year ago

ryscher commented 1 year ago

Many older datasets have ISSNs that don't match the ISSNs listed for current journals. This can cause Identifier.journal to give unexpected results. To fix, we need to update older journals to have multiple ISSNs.

To identify the ISSNs that are missing:

ii = StashEngine::Identifier.where(pub_state: 'published')
ii.each do |i|
    if i.journal.blank? && i.publication_issn.present?
        print "#{i.identifier} -- #{i.publication_issn}\n"
    end
end
sfisher commented 1 year ago

This post at https://community.crossref.org/t/how-do-i-find-all-issns-assigned-to-a-journal-title-in-crossref/3447 suggests downloading the titles or titles.csv file and just matching on title to get all the ISSNs. Not sure if that helps.