| Issue Number | 4157 |
|---|---|
| Summary | Report for Invalid PMID Clean-up |
| Created | 2016-09-22 13:34:15 |
| Issue Type | Improvement |
| Submitted By | Juthe, Robin (NIH/NCI) [E] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2016-09-29 13:42:15 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.194691 |
We should consider developing a report to search for citations in the CDR that have invalid PMIDs, so that we can go back and import the citations with correct PMIDs and add links in the summaries. This needs more discussion before such a report is developed, but we agreed to put the issue in as a placeholder for now.
Bob will start by implementing a proof of concept report, limited to citations which are linked from documents which are not blocked.
As a first step, although I think I recall someone saying in last Thursday's meeting that the only active documents linking to citations are summaries, that's not quite true. Here are the counts of unique citations (not individual links) linked from active documents of various types:
Document Type |
Unique Citations Linked |
|---|---|
CTGovProtocol |
43 |
MiscellaneousDocument |
17 |
Summary |
22954 |
Organization |
3 |
Citation |
883 |
Media |
18 |
DrugInformationSummary |
17 |
Doesn't look as if there's much to worry about. NLM still has all of the Pubmed IDs for the citations to which we link. The report originally had one missing PMID, but that was because our citation document (CDR62863) has some superfluous leading zeros in the PMID element (0010675377 instead of 10675377).
That's good news!
That CDR ID is for the Genetics of CRC summary. Did you mean to put a different CDR ID for the citation document?
Sorry! I swapped the IDs for the linker/linked docs. It's CDR62863 (Summary) linking to CDR51389 (Citation "Celecoxib trials under Way").
Since there are no lost PMIDs at this point, we decided to close this issue for now, and perhaps periodically request a manual run from time to time. It's possible when we do our next release we'll include a task to plug the report into the admin menus.
Elapsed: 0:00:00.001355