CDR Tickets

Issue Number 3568
Summary Modify Mapping Gaps Page
Created 2012-11-29 15:24:50
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2012-12-07 14:46:29
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107896
Description

BZISSUE::5266
BZDATETIME::2012-11-29 15:24:50
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku

As we discussed in this afternoon's meeting, there has been an increase in the number orgs on the CTRP mapping gaps page because of the increase in cooperative group trials transfers and this causes the page to take a long time to load. Currently, there are 278 trials on the mapping gaps page and we expect that to continue to increase.

It is also difficult for more than one person to work on the page because you need to refresh the page often to see what has already been mapped by the other person. I am wondering if it is possible to have the page divided up into multiple pages so that there will be fewer trials on each page and also for each user to work on a page until we clear the entire backlog.

The suggested approach of showing only a limited number of trials at a time will work but will not be helpful in the case of new trials or active trials. We want to be able to prioritize active and new trials but with this approach, we probably won't know that there is a new trial until the gaps for the current trials have been completed.

Any other approach to that will make the work more manageable is welcome :-).

Comment entered 2012-11-30 11:47:20 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-11-30 11:47:20
BZCOMMENTOR::Bob Kline
BZCOMMENT::1

There is a new version of the program on Bach which only shows the first 5 trials with mapping gaps. I can adjust that limit if that would be helpful.

In addition, there is a link at the top which lets you skip to the next 5 trials (assuming you haven't gone past the end of all the trials). It isn't possible to implement a mechanism which allows you to specify a page number directly so you can (for example) skip forward (or backward) 10 pages, unless you're willing to have the program revert to taking as long as it used to, because until it analyzes each trial it can't tell which ones still have mapping gaps, and I assume you don't want to pay that penalty.

Once you have moved past the first page, you'll see that the URL has a new parameter embedded in it named "minid"; for example:

http://bach..../ctrp-mapping-gaps.py?minid=NCI-2009-00303&Session=...

For users that aren't squeamish about editing URLs in the address bar, it's possible to edit the value of that "minid" parameter, setting it to the lowest CTRP ID you'd like to have displayed in your set of 5 trials, causing the program to skip past all the trials with lower IDs. Substrings work, too, so you could use ...minid=NCI-2011&Session=... to skip all the NCI-2009 and NCI-2010 trials.

One way you could use this URL editing trick would be to take the complete list of trials and divide it up into blocks of roughly equal size, and have each person working on the mapping take a block, putting the first CTRP ID in his or her block in the minid parameter of the URL. I have attached the list of trials queued for import in case you want to try this approach. In addition, I have created an ad-hoc query ("CTRP Trials Queued For Import") which you can use to refresh this list.

Hope this helps solve your problems.

Comment entered 2012-11-30 11:47:20 by Kline, Bob (NIH/NCI) [C]

Attachment ctrp-import-queue.txt has been added with description: Trials queued for import

Comment entered 2012-12-05 10:13:57 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-12-05 10:13:57
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

(In reply to comment #1)
> Created attachment 2285 [details]
> Trials queued for import
>
>
> Hope this helps solve your problems.

Yes. It does. Thank you! We may decided to increase the number of trials per page later but for now, it is perfect.

Comment entered 2012-12-07 14:46:29 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-12-07 14:46:29
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3

Closing issue. Thank you!

Attachments
File Name Posted User
ctrp-import-queue.txt 2012-11-30 11:47:20

Elapsed: 0:00:00.000663