CDR Tickets

Issue Number 3492
Summary Remove trials from duplicate list
Created 2012-03-27 14:15:23
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2012-04-03 14:58:10
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107820
Description

BZISSUE::5187
BZDATETIME::2012-03-27 14:15:23
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::Margaret Beckwith

Please remove the following trials from the duplicate list so that we can force download the CTGov versions. We tried using the tool on Bach to do this but it didn't work because they are on the list that Lakshmi gave you (bottom of the duplicate list).
NCT00052962
NCT00054665
NCT00062933

Comment entered 2012-03-27 14:20:34 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-03-27 14:20:34
BZCOMMENTOR::Bob Kline
BZCOMMENT::1

Done.

Comment entered 2012-03-30 11:28:04 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-03-30 11:28:04
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

Only one them (NCT00052962) was imported after doing the force download. The other two failed to import.

Comment entered 2012-03-30 11:52:45 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-03-30 11:52:45
BZCOMMENTOR::Bob Kline
BZCOMMENT::3

Have they used the 'Mark/Remove Protocols as Duplicates' admin interface to back the trials out of the duplicate state?

Comment entered 2012-03-30 12:25:19 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-03-30 12:25:19
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4

(In reply to comment #3)
> Have they used the 'Mark/Remove Protocols as Duplicates' admin interface to
> back the trials out of the duplicate state?

Yes. It has been used twice now and Yesterday's produced the “already marked for forced download” message.

Comment entered 2012-03-30 12:44:18 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-03-30 12:44:18
BZCOMMENTOR::Bob Kline
BZCOMMENT::5

(In reply to comment #4)
> (In reply to comment #3)
> > Have they used the 'Mark/Remove Protocols as Duplicates' admin interface to
> > back the trials out of the duplicate state?
>
> Yes. It has been used twice now and Yesterday's produced the “already marked
> for forced download” message.

Hmm. I suspect they have their admin interfaces confused. I just examined the code for the two scripts and only the "Force Download of a Trial" page puts out that message, not the "Mark/Remove Protocols as Duplicates" page. Could you ask them to that interface again?

Comment entered 2012-03-30 12:57:39 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-03-30 12:57:39
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6

(In reply to comment #5)
> (In reply to comment #4)
> > (In reply to comment #3)
> > > Have they used the 'Mark/Remove Protocols as Duplicates' admin interface to
> > > back the trials out of the duplicate state?
> >
> > Yes. It has been used twice now and Yesterday's produced the “already marked
> > for forced download” message.
>
> Hmm. I suspect they have their admin interfaces confused. I just examined the
> code for the two scripts and only the "Force Download of a Trial" page puts out
> that message, not the "Mark/Remove Protocols as Duplicates" page. Could you
> ask them to that interface again?

You're right. Only the Force Download tool was used because they thought you had already removed it from the duplicate list. Should the Mark/Remove tool be used for the remaining two? Perhaps what is puzzling about this is that the Mark/Remove tool may not have been used for the one that came through.

Comment entered 2012-03-30 13:22:28 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-03-30 13:22:28
BZCOMMENTOR::Bob Kline
BZCOMMENT::7

(In reply to comment #6)

> You're right. Only the Force Download tool was used because they thought you
> had already removed it from the duplicate list.

I removed it from Lakshmi's list, but that doesn't do anything to the ctgov_import table.

> Should the Mark/Remove tool be used for the remaining two?

Yes.

Comment entered 2012-04-03 14:58:10 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-04-03 14:58:10
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::8

(In reply to comment #7)
> (In reply to comment #6)
>
> > You're right. Only the Force Download tool was used because they thought you
> > had already removed it from the duplicate list.
>
> I removed it from Lakshmi's list, but that doesn't do anything to the
> ctgov_import table.
>
> > Should the Mark/Remove tool be used for the remaining two?
>
> Yes.

It worked and the trials have been imported. Thank you!
Issue closed.

Elapsed: 0:00:00.001489