Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Export Metadata Subfield Funding References #805

Closed
Meowcenary opened this issue Dec 18, 2020 · 6 comments
Closed

Export Metadata Subfield Funding References #805

Meowcenary opened this issue Dec 18, 2020 · 6 comments
Assignees
Labels
invenioRDM Migration/switch related work

Comments

@Meowcenary
Copy link
Collaborator

Meowcenary commented Dec 18, 2020

Export the Metadata subfield Funding References

@Meowcenary Meowcenary changed the title Export Metadata Subfield References Export Metadata Subfield Funding References Dec 18, 2020
@sharpattack sharpattack added the invenioRDM Migration/switch related work label Dec 18, 2020
@Meowcenary Meowcenary self-assigned this Jan 15, 2021
@Meowcenary
Copy link
Collaborator Author

Started looking at this since it seemed like it might be a little complicated compared to formats which I had initially started looking at. From what I can tell there is a field for grants and funding on the GenericFile model (GenericFile#grants_and_funding), but I'm having trouble actually accessing the field on the model within the console. I also tried to find it on production and stage DigitalHub, but I wasn't able to.

@Meowcenary
Copy link
Collaborator Author

Alright, I'm going to look into this again. I think I figured out the problems I was having with the console so hopefully I can get some examples.

@Meowcenary
Copy link
Collaborator Author

Below are all the values from the grants_and_funding field on production DigitalHub. There's definitely a way to programmatically find the values we need for some of these, but we'll need to do another mapping similar to what was done in #812 with the known_organizations module..

"F37 LM009568 NIH",
"F37 LM009568 NIH",
"K01LM011973-01 (NLM)",
"Clinical and Translational Science Award (CTSA) award UL1RR025741",
"Supported by grants from the Swiss National Foundation for Scientific Research (3200B0-108261) and the Mach-Gaensslen Foundation, Switzerland.",
"These studies were supported by United States Public Health Services grants HE 07057 and HE 10573, by the Otho S. A. Sprague Foundation, and by the Ernest S. Bazley Trust.",
"This research was supported in part by an appointment to the NLM Associate Fellowship Program sponsored by the National Library of Medicine and administered by the Oak Ridge Institute for Science and Education. ",
"Justin Smith was supported by National Center for Chronic Disease Prevention and Health Promotion of the Centers of Disease Control and Prevention grant DP006255, awarded to Justin Smith and Cady Berkel, and National Institute on Drug Abuse grant DA027828, awarded to C. Hendricks Brown. Zorash Montao was supported by minority fellowship SM60563-40 from the Department of Health and Human Services. Seed funding from the College of Liberal Arts and Sciences at Arizona State University awarded to Thomas Dishion supported Justin Smith and Zorash Montao.",
"2P30DA027828-07",
"K01LM011973-01 (NLM)",
"Clinical and Translational Science Award (CTSA) award UL1TR001422",
"UL1TR001422",
"This report was made possible with help from the Third Coast Center for AIDS Research (CFAR), an NIH funded center (P30 AI117943), including funding from an administrative supplement to that grant.",
"NCATS grant U24TR002306 (CD2H) ",
"NCATS grant UL1TR001422 (NUCATS)",
"We gratefully acknowledge support for this work by the National Institutes of Health's National Center for Advancing Translational Sciences, Grant Number UL1TR001422",
"UL1TR001422 ",
"This work was supported by the Center for Reproductive Health After Disease (P50HD076188) from the National Institutes of Health National Center for Translational Research in Reproduction and Infertility (NCTRI).",
"This work was supported by the Center for Reproductive Health After Disease (P50HD076188) from the National Institutes of Health National Center for Translational Research in Reproduction and Infertility (NCTRI).",
"This work was supported by the Center for Reproductive Health After Disease (P50HD076188) from the National Institutes of Health National Center for Translational Research in Reproduction and Infertility (NCTRI).",
"This work was supported by the Center for Reproductive Health After Disease (P50HD076188) from the National Institutes of Health National Center for Translational Research in Reproduction and Infertility (NCTRI).",
"This work was supported by the Center for Reproductive Health After Disease (P50HD076188) from the National Institutes of Health National Center for Translational Research in Reproduction and Infertility (NCTRI).",
"This work was supported by the Center for Reproductive Health After Disease (P50HD076188) from the National Institutes of Health National Center for Translational Research in Reproduction and Infertility (NCTRI).",
"This work was supported by the Center for Reproductive Health After Disease (P50HD076188) from the National Institutes of Health National Center for Translational Research in Reproduction and Infertility (NCTRI).",
"U24TR002306",
"UL1TR001422 (NCATS), U54CA202995, U54CA202997, and U54CA203000 (NCI), G08LM012688 (NLM), U24TR002306 (NCATS)",
"U24TR002306 (NCATS)",
"UL1TR001422 (NCATS)",
"U54CA202995 (NCI)",
"U54CA202997 (NCI)",
"U54CA203000 (NCI)",
"P30AR072579 (NIAMS)",
"G08LM012688 (NLM)",
"NCATS U24TR002306",
"NCATS UL1TR001422",
"NIH: U24TR002306 (NCATS)",
"NIH: UL1TR001422 (NCATS)",
"NIH: U54CA202995, U54CA202997, U54CA203000 (NCI)",
"NIH: P30AR072579 (NIAMS)",
"NIH: G08LM012688 (NLM)",
"U24TR002306",
"UL1TR001",
"HBNU Fogarty Global Health Fellows Program; Northwestern University Stamler Fellowship",
"Research reported in this publication was supported by the Fogarty International Center of the National Institutes of Health under Award Number D43TW009575 (RLM and LH) and U54CA221205 (LH and RLM), AASLD Clinical and Translational Research Award in Liver Diseases (RAH), and R01DK110024 and R01AA027179 (KDR). The content is solely the responsibility of the authors and does not necessarily represent the official views of the National Institutes of Health.",
"CTS Personas is a project of the CTSA Program National Center for Data to Health, Grant U24TR002306",
"IGH ",
"See content of this document: PRO Planning Toolkit Overview",
"See PRO Planning Tools Overview",
"See PRO Planning Tools Overview",
"See PRO Planning Tools Overview",
"NIH/NHLBI R01HL115828",
"NIH/NHLBI R01HL133504",
"NIH/NHLBI K25HL119608",
"NIH/NHLBI F30HL145995",
"NIH - National Institute of Diabetes and Digestive and Kidney Diseases",
"This project is funded in part with Federal funds from the National Institute on Aging under grant number U2CAG057441, and The Environmental Influences on Child Health Outcomes (ECHO) program, Office of the Director, NIH, under award number U24OD023319."

Supported schemes with links to how the schemes are structured

An example of some of the supported identifiers: Screen Shot 2021-01-19 at 3 12 14 PM

@Meowcenary
Copy link
Collaborator Author

I'm going to take a break from this. I'm getting the impression that some of the numbers listed in funding are not actually in the formats listed above, but rather in some other format. Through the NIH reporting tool I was able to match some of the numbers to projects. Unfortunately I don't see any numbers that are obviously in a format we can use for invenio within that search result.

@Meowcenary
Copy link
Collaborator Author

The grants.gov search tool may be helpful too. I have not had much luck with it yet myself, but never hurts to have more resources.

@Meowcenary
Copy link
Collaborator Author

I'm going to generate a CSV for @carsonicator who has offered to help out with figuring out the necessary information for these files (thanks!). It will take a bit to run, but I've got the process down at this point.

Meowcenary added a commit that referenced this issue Mar 1, 2021
Add script to convert CSV of funding data into ruby hash stored within
text file. Use function to read file and extract funding data.
Meowcenary added a commit that referenced this issue Mar 1, 2021
Add script to convert CSV of funding data into ruby hash stored within
text file. Use function to read file and extract funding data.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
invenioRDM Migration/switch related work
Projects
None yet
Development

No branches or pull requests

2 participants