Wiley issues

[sckott]

@caseydm As I mentioned in the Sage and T&F issues I'd be opening an issue about Wiley. I've spot checked a bunch of ISSNs that are missing from a consortium's Unsub dashboards to make sure they are missing for correct reasons.

Here's the Wiley spreadsheet

https://docs.google.com/spreadsheets/d/1y30cYEYYPakLsP4hXKuK6_hNSpFU0UGFaT_Y0xfi-qY/edit#gid=0

See the "notes" column of the above spreadsheet for the comments. I've filtered it to the journalsdb column == 1, but you can look at the other rows if you want to.

• There's a bunch that I think should be changed to Wiley - where Wiley publishes the title on behalf of some society publisher
• There's a bunch where publisher is currently null in journalsdb - suggested publisher for those
• for issn 0142-0356: there's two entries with the same exact title https://api.journalsdb.org/journals/0142-0356 https://api.journalsdb.org/journals/0268-2575 . Curious if there should be different entries in journalsdb?
• there's a bunch of titles that are part of a Wiley-Hindawi partnership, e.g., 0730-6679, and in journalsdb and crossref the publisher is listed as Hindawi. It's not super clear who the publisher is - journal content can be found on both Wiley and Hindawi websites - but they're all OA anyway so for Unsub it doesn't matter as we would exclude them anyway from user dashboards. Maybe nothing to do here

[caseydm]

Hi @sckott all of the changes are made for Wiley.

• For journals that needed to be merged, I merged them together, such as the one you mentioned: https://api.journalsdb.org/journals/0268-2575
• I improved the sample DOI script, similar to what we did with date_last_doi. So if sample DOIs are not found for the issn_l, the script tries to use one of the other associated issns. That fixed all the ones on your spreadsheet and added a lot more sample DOIs to the database.
• I agree there is nothing to do with those Hindawi journals. I don't think it makes sense to change the publisher name since they are still hosted on Hindawi. So I left them alone.

[sckott]

Thanks @caseydm

• Thanks for all the fixes!
• That's great about more sample dois. those help get me to the publisher page quickly to sort out any issues.
• Sounds good on Hindawi