| Issue Number | 3388 |
|---|---|
| Summary | [CTGOV] Update NCT IDs |
| Created | 2011-07-06 16:24:35 |
| Issue Type | Improvement |
| Submitted By | Osei-Poku, William (NIH/NCI) [C] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2011-08-25 08:11:57 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107716 |
BZISSUE::5081
BZDATETIME::2011-07-06 16:24:35
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku
NLM has either swapped or changed NCT IDs for the following trials. Please update the NCT IDs.
CDR ID NCT ID (Make Active) NCT ALIAS (Make Alias)
583208 NCT00629109 NCT00955019
664071 NCT00687102 NCT00571857
653496 NCT00620087 NCT00963014
661638 NCT01044966 NCT01026168
666469 NCT01077739 NCT01069679
681728 NCT01323933 NCT01158872
635564 NCT00859118 NCT00839215
694983 NCT01316393 NCT01288118
I am attaching the spreadsheet. In all cases, the NCT IDs in column 'B' should be made the active NCT IDs and the IDs in column 'C' should be made aliases.
Attachment swapped - changed NCT IDs.xls has been added with description: swapped or changed NCT IDs
BZDATETIME::2011-07-18 15:43:05
BZCOMMENTOR::Bob Kline
BZCOMMENT::1
Script failed. NLM is no longer sending us NCT00629109 (or it never was).
BZDATETIME::2011-08-03 20:26:28
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2
(In reply to comment #1)
> Script failed. NLM is no longer sending us NCT00629109 (or it never
was).
Please run the script without NCT00629109. It appears to be OK. I will investigate further. I re-checked a few on the list and I did not see that they have the same problem as NCT00629109.
BZDATETIME::2011-08-08 16:18:06
BZCOMMENTOR::Bob Kline
BZCOMMENT::3
Dropped the first trial from the list and the job ran successfully.
BZDATETIME::2011-08-09 14:04:48
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4
(In reply to comment #3)
> Dropped the first trial from the list and the job ran
successfully.
The following two trials appear to have not been updated. The rest were successfully updated.
664071 NCT00687102 NCT00571857
653496 NCT00620087 NCT00963014
BZDATETIME::2011-08-09 14:48:12
BZCOMMENTOR::Bob Kline
BZCOMMENT::5
(In reply to comment #4)
> (In reply to comment #3)
> > Dropped the first trial from the list and the job ran
successfully.
>
> The following two trials appear to have not been updated. The rest
were
> successfully updated.
>
> 664071 NCT00687102 NCT00571857
> 653496 NCT00620087 NCT00963014
Looks like you'll need to force those two: NCT00687102 has a status of "Completed," and NCT00620087 has a status of "Enrolling by invitation."
BZDATETIME::2011-08-11 17:31:44
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6
(In reply to comment #5)
> >
> > 664071 NCT00687102 NCT00571857
> > 653496 NCT00620087 NCT00963014
>
> Looks like you'll need to force those two: NCT00687102 has a status
of
> "Completed," and NCT00620087 has a status of "Enrolling by
invitation."
It turned out that we did a force download yesterday using the 2 old/existing NCT ids and they brought in 2 new records with the old NCT IDs. Should we have used the new NCT ids?
BZDATETIME::2011-08-23 08:59:16
BZCOMMENTOR::Bob Kline
BZCOMMENT::7
I set the force flag on the correct rows in the table and ran the import job by hand. The two trials are now imported.
BZDATETIME::2011-08-25 08:11:57
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::8
(In reply to comment #7)
> I set the force flag on the correct rows in the table and ran the
import job by
> hand. The two trials are now imported.
Verified. Closing issue. Thank you!
| File Name | Posted | User |
|---|---|---|
| swapped - changed NCT IDs.xls | 2011-07-06 16:24:35 | Osei-Poku, William (NIH/NCI) [C] |
Elapsed: 0:00:00.001769