The Open Funder Registry Reconciliation Service is designed to help members (or anybody) more easily clean-up their funder data and map it to the Open Funder Registry. It is built on Open Refine and Funding Data Search.
If you are impatient and want to see it working, then skip to the short 15-minute video tutorial.
Or read on…
Some of our members have been collecting data related to the funding of publications for years. Ideally, we would like them to submit Open Funder Registry identifiers for their backfiles into the Crossref system. However, we realize that there are at least two major barriers to doing this:
We have created the Open Funder Reconciliation Service to work with The Open Refine desktop application. The Open Refine application provides a number of powerful tools that allow one to clean-up messy metadata and the Open Funder Reconciliation Service will allow one to take that cleaned-up data and semi-automatically map it to the latest version of the Open Funder Registry.
Basically, you start with a tab-delimited text file which includes every funder name you have recorded along with whatever *internal identifier* you use for that funder. For example:
publisher_id name 1000001 University of Oxford 1000002 Oxford University 1000003 Welcome Trust 1000004 US Department of Transportation 1000005 National Aeronautics and Space Administration 1000006 National Institutes of Health 1000007 U.S. Department of Transportation 1000008 US Department of Transport 1000009 NASA 1000010 Wellcome Trust 1000011 Sloan Foundation 1000012 National Institute of Health 1000013 All Souls College, University of Oxford 1000014 Rinky Dink Foundation
Once you load that text file into Open Refine and process it, you will be left with a file that looks like this:
publisher_id name fundref_funder_id 1000001 University Of Oxford http://0-dx.doi.org.libus.csd.mu.edu/10.13039/501100000769 1000002 University Of Oxford http://0-dx.doi.org.libus.csd.mu.edu/10.13039/501100000769 1000003 Wellcome Trust http://0-dx.doi.org.libus.csd.mu.edu/10.13039/100004440 1000004 U.S. Department of Transportation http://0-dx.doi.org.libus.csd.mu.edu/10.13039/100000140 1000005 National Aeronautics and Space Administration http://0-dx.doi.org.libus.csd.mu.edu/10.13039/100000104 1000006 National Institutes of Health http://0-dx.doi.org.libus.csd.mu.edu/10.13039/100000002 1000007 U.S. Department of Transportation http://0-dx.doi.org.libus.csd.mu.edu/10.13039/100000140 1000008 U.S. Department of Transportation http://0-dx.doi.org.libus.csd.mu.edu/10.13039/100000140 1000009 National Aeronautics and Space Administration http://0-dx.doi.org.libus.csd.mu.edu/10.13039/100000104 1000010 Wellcome Trust http://0-dx.doi.org.libus.csd.mu.edu/10.13039/100004440 1000011 Alfred P. Sloan Foundation http://0-dx.doi.org.libus.csd.mu.edu/10.13039/100000879 1000012 National Institutes of Health http://0-dx.doi.org.libus.csd.mu.edu/10.13039/100000002 1000013 All Souls College, University of Oxford http://0-dx.doi.org.libus.csd.mu.edu/10.13039/501100000524 1000014 Rinky Dink Foundation
You can then use this latter file to convert all of your internal funder names and identifiers into Opne FUnder-compatible names and identifiers.
You can see a complete demo of how the system works by watching this 15-minute video tutorial. The Open Refine website also has some more general tutorials on using the tool that you may find helpful.
Once you have watched the video, you can practice with the tool yourself. Simply download the Open Refine application (runs of OSX, Windows and Linux) and our short, sample file of publisher funder data. Two key pieces of information you may may not want to re-type are:
The URL for the Open Funder Reconciliation Service
The “Refine Expression Language” command for creating a new column of Open Funder Identifiers:
Obviously, we welcome your feedback. Send comments/questions/gripes to: