Scopus <> ROR mapping

[N. Veenstra]

Hi all, 

I am working on a process automation that loads new publications to Pure (Elsevier's CRIS/RIM system). The main issue is the handling of what Elsevier calls "external organizations", the affilations of external authors on a publication. 

The data quality of these external organizations in our Pure is lacking. We had around 200K of them, there should be only around 30K. The rest is all duplicates. We aim to replace as many organizations as possible with a ROR variant, in order to have richer metadata for future matchin. I managed to clean up 100K by finding the matching doi and author in OpenAlex, and fetch the ROR from there. 

The remaining half is a bit more challenging. I used the ROR api to match them, but even some of the 100% matches are not correct unfortunately. A mapping between scopus and ROR id would improve things considerably. I am guessing there are more people out there matching ROR's into Pure, and that would mean that scattered over these Pure systems, there are now mappings between Scopus and ROR ids. If we could pool the ones that have been matched correctly, we could create a universal mapping table from Scopus to ROR, which could then be implemented in automation pipelines like the one I'm building. 

I couldn't find any Scopus discussions here, is this something the ROR organization is looking at or could be interested in?

Best regards, 

Nick

[Amanda French]

Hi Nick,

I'd definitely love to talk to someone specifically at Scopus about including mappings to ROR within the system. Elsevier has a central organization database that feeds organization information to a lot of its products, including Scopus, and they've said before that they're interested in including ROR mappings in that central upstream DB. However, it hasn't yet come to pass, for whatever reason. Will have to try again. 

Are Scopus affiliation IDs proprietary? I imagine so, correct? 

Regarding matching ROR IDs into Pure, did you see this video from last fall, Nick? https://www.youtube.com/watch?v=xwRrMSXtypo It shows Søren Vidmar from Aalborg University using the ROR API and OpenAlex to clean up external organizations in Pure. I've very recently been talking with some people at Pure about using ROR to solve that problem by implementing the ROR matching API and I'm cautiously optimistic that they're open to it, but it's early days yet. 

Amanda

[N. Veenstra]

Hi Amanda, 

I have raised these questions in the Pure community. The Pure import tool I am building needs a solid mapper from Scopus to ROR. I have noticed that if we hold off on importing new records for a month, they will have appeared in both Scopus and OpenAlex. I guess I could then also do an on the fly lookup from Scopus to OpenAlex, fetch the relevant ROR and store that in Pure with the Scopus ID attached. But in any case, if Elsevier is hesitant to start supporting this, we should set up automated crowdsourcing.

Nick