Some Pubmed publications have grant support numbers. These grant support numbers are required on some publications, and it would be nice if us Biblio users can track our publications based on specific grant numbers by having this data pulled in automatically with the Pubmed ID number.

Is anyone else interested in this?

Comments

rjerome’s picture

rjerome commented

Are these "grant numbers" in the PubMed data? If so it should be pretty trivial to pick them out if you point me at PMID which has such a number.

earwax’s picture

earwax commented

Here is an example of a Pubmed article entry with grant numbers.

http://www.ncbi.nlm.nih.gov/pubmed/22871870

Expand the "Publication Types, MeSH Terms, and Grant Support"

Is there anyway you can easily integrate this? Anything I can do to help?

rjerome’s picture

rjerome commented

OK, I didn't expect that many "grant numbers" for each publication, but that's not a big deal. So I'm guessing that many publications could share one or more of the same grant numbers? And your goal is to enter a grant number and pull out all the corresponding pubs? It would require an extra DB table to hold the grant info.

earwax’s picture

earwax commented

And your goal is to enter a grant number and pull out all the corresponding pubs?

Yes, exactly! It would be for reporting purposes. Does this look trivial to implement?

rjerome’s picture

rjerome commented

Semi-trivial, depends on how you want to do the reporting. Views?

earwax’s picture

earwax commented

Views integration would be nice. Any method of doing it the "Drupal way" is okay with me. Worst case, I could always write my SQL query in a module and do it myself, but I would prefer not going this route and making it as user friendly as possible by using Views.

rjerome’s picture

rjerome commented

Views is probably the easiest way to go.

rjerome’s picture

rjerome commented

This is now in the -dev branch... http://drupalcode.org/project/biblio.git/commit/e44931a

earwax’s picture

earwax commented

Thank you! I was successfully able to update Biblio with this development version (add table and alter column in MySQL). The grant information are getting pulled in from Pubmed, and I was able to create a custom view and have the field filters I need.