CDR Tickets

Issue Number 3607
Summary [CTGov] Remove IDs from duplicates file
Created 2013-05-16 11:42:18
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2013-05-22 10:13:20
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107935
Description

BZISSUE::5306
BZDATETIME::2013-05-16 11:42:18
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku

Please remove the following trials from the ctgov duplicates file:

NCT00040729
NCT00039585
NCT00039611
NCT00042861
NCT00060021

Comment entered 2013-05-16 11:42:59 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2013-05-16 11:42:59
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::1

Adding Margaret as CC.

Comment entered 2013-05-16 11:46:49 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2013-05-16 11:46:49
BZCOMMENTOR::Bob Kline
BZCOMMENT::2

Done.

Comment entered 2013-05-20 16:01:48 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2013-05-20 16:01:48
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3

(In reply to comment #2)
> Done.

I can see all of them on the report. They have not been removed yet.

I made corrections to title

Comment entered 2013-05-20 16:10:23 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2013-05-20 16:10:23
BZCOMMENTOR::Bob Kline
BZCOMMENT::4

Perhaps I've misunderstood what you're after. Here is the current version of the file in d:\cdr\Utilities, which is where the production version of the duplicates file lives. I don't see the IDs in that file. We are talking about Bach, right?

Comment entered 2013-05-20 16:10:23 by Kline, Bob (NIH/NCI) [C]

Attachment ctgov-dups.txt has been added with description: Current version of ctgov-dups.txt file on Bach

Comment entered 2013-05-20 16:23:34 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2013-05-20 16:23:34
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::5

Yes I was referring to Bach. Here is a link to the report:

http://bach.nci.nih.gov/cgi-bin/cdr/CTGovDupReport.py?Session=519A6F64-A3F142-153-MHY2F5SHD5ZW

The report is called "Records Marked as Duplicates". That is where I verify the removal.

CIAT/OCCM Staff>CTGov Protocols >Records Marked as Duplicates

They can be found on the part of the report titled "Trials marked as duplicates prior to CTGOV imports"

Comment entered 2013-05-20 16:27:10 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2013-05-20 16:27:10
BZCOMMENTOR::Bob Kline
BZCOMMENT::6

That report uses a database table, not the ctgov duplicates file (which is used by the CT.gov download program).

Comment entered 2013-05-20 16:40:57 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2013-05-20 16:40:57
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::7

I am sorry about that.In a previous OCECDR-3392 you had referred to a report as 'ctgov-dups.txt' so I was under the impression that it was file.

Comment entered 2013-05-20 16:43:33 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2013-05-20 16:43:33
BZCOMMENTOR::Bob Kline
BZCOMMENT::8

Have you done the "force download" step referred to in that issue?

Comment entered 2013-05-20 17:02:15 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2013-05-20 17:02:15
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::9

(In reply to comment #8)
> Have you done the "force download" step referred to in that issue?

Not yet. We'll be doing it soon. Hopefully, that will resolve the issue.

Comment entered 2013-05-22 10:13:20 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2013-05-22 10:13:20
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::10

We were able to force download all the trials. Thanks!

Attachments
File Name Posted User
ctgov-dups.txt 2013-05-20 16:10:23

Elapsed: 0:00:00.000617