Issue Number | 3447 |
---|---|
Summary | [CTGov] Update NCT IDs |
Created | 2011-11-08 15:37:59 |
Issue Type | Improvement |
Submitted By | Osei-Poku, William (NIH/NCI) [C] |
Assigned To | Kline, Bob (NIH/NCI) [C] |
Status | Closed |
Resolved | 2011-11-18 10:56:46 |
Resolution | Fixed |
Path | /home/bkline/backups/jira/ocecdr/issue.107775 |
BZISSUE::5141
BZDATETIME::2011-11-08 15:37:59
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku
NLM swapped the NCT IDs for the following trials and we need to do same in order to receive updates for the trials listed below:
CDR ID Active NCT ID (Make Active) NCT ALIAS (Make Alias)
CDR0000586042 NCT01372813 NCT00608114
CDR0000700896 NCT01381874 NCT01355770
Also, I am wondering if you could build an interface for us to do the swapping of IDs each month. Every month, we review the orphaned records to determine why we no longer receive updates from NLM and send you the list trials to swap the IDs. Since this has become a regular maintenance task, an interface for us to do it would be good.
Attachment NCT ID SWAPS110811.xls has been added with description: NCT ID SWAPS
BZDATETIME::2011-11-10 15:58:04
BZCOMMENTOR::Bob Kline
BZCOMMENT::1
Requested interface implemented on Franck and installed in Admin menus; please test.
BZDATETIME::2011-11-11 12:25:23
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2
(In reply to comment #1)
> Requested interface implemented on Franck and installed in Admin
menus; please
> test.
I tested with the two requests above. The documents appear to have been successfully queued for import. Do you need to manually run the import job? Also, could you please create a group for this new tool so that we can control user access?
BZDATETIME::2011-11-11 12:49:55
BZCOMMENTOR::Bob Kline
BZCOMMENT::3
(In reply to comment #2)
> Do you need to manually run the import job?
On Franck I do, since it's only scheduled for nightly runs on Bach. I just ran the job.
> Also, could you please create a group for this new tool so that
we can control
> user access?
I'll do that when we install it on Bach.
BZDATETIME::2011-11-15 13:12:00
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4
Please promote to Bach. I reviewed the documents and they have the correct NCT IDs on Franck.
BZDATETIME::2011-11-15 16:58:17
BZCOMMENTOR::Bob Kline
BZCOMMENT::5
Promoted to Bach. I created the group "NCT ID Remappers" as you requested (though it's possible that using one of the existing groups would have been appropriate, assigning the permission "SWAP NCT IDS"). Assign whoever you want to be in the new group.
BZDATETIME::2011-11-17 11:49:41
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6
I have successfully swapped the NCT IDs for the two documents in the original post. I will be checking the documents tomorrow morning and will close this issue if they are okay.
BZDATETIME::2011-11-18 10:56:46
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::7
Verified on Bach. Thank you!
Closing issue.
File Name | Posted | User |
---|---|---|
NCT ID SWAPS110811.xls | 2011-11-08 15:37:59 | Osei-Poku, William (NIH/NCI) [C] |
Elapsed: 0:00:00.001362