CDR Tickets

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
Description

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.

Comment entered 2011-11-08 15:37:59 by Osei-Poku, William (NIH/NCI) [C]

Attachment NCT ID SWAPS110811.xls has been added with description: NCT ID SWAPS

Comment entered 2011-11-10 15:58:04 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2011-11-10 15:58:04
BZCOMMENTOR::Bob Kline
BZCOMMENT::1

Requested interface implemented on Franck and installed in Admin menus; please test.

Comment entered 2011-11-11 12:25:23 by Osei-Poku, William (NIH/NCI) [C]

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?

Comment entered 2011-11-11 12:49:55 by Kline, Bob (NIH/NCI) [C]

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.

Comment entered 2011-11-15 13:12:00 by Osei-Poku, William (NIH/NCI) [C]

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.

Comment entered 2011-11-15 16:58:17 by Kline, Bob (NIH/NCI) [C]

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.

Comment entered 2011-11-17 11:49:41 by Osei-Poku, William (NIH/NCI) [C]

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.

Comment entered 2011-11-18 10:56:46 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-11-18 10:56:46
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::7

Verified on Bach. Thank you!

Closing issue.

Attachments
File Name Posted User
NCT ID SWAPS110811.xls 2011-11-08 15:37:59 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.001465