Open sckott opened 2 years ago
Hi Scott. I think the best bet is to implement #34 and then set the value manually. I'm working on 34 right now but am having some trouble upgrading the database with that new column. But I will keep at it and let you know when it's done.
Okay, sounds good.
Ok the new field is available and the update script is running right now. It will run through all of the journals once per day. Scientific American is set manually to a recent date: https://api.journalsdb.org/journals/0036-8733. The script only updates the date if it is newer then the current saved date. I will check on this in a few hours to see how many journals have dates populated.
As an update 88,909 journals have a date_last_doi set out of 102,446 that are in the database.
Thanks! This is great. I'll update things on our side to use the new field.
Heard from crossref contact - the update is that there's no update from Springer
Our data https://api.journalsdb.org/journals/0036-8733 indicates that Scientific American is no longer publishing - 2018 is the last year with DOIs
They clearly are still publishing https://www.scientificamerican.com/
I've talked with Crossref, and it appears it's a problem with the publisher screwing up DOIs somehow. I haven't heard when a fix is coming yet.
Can we get a temporary fix for this? For now, I don't know how we would do this since in Unsub we currently look at
dois_by_issued_year
to determine if a journal is still publishing, and we don't have #34 yet (but maybe it's close to being ready? in which case we could just set this field manually?).Any ideas?