CDR Tickets

Issue Number 3660
Summary [Genetics Directory] List of Current GPs with E-mails
Created 2013-09-09 14:28:43
Issue Type Task
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2013-09-10 16:48:34
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.112966
Description

We received a request from a colleague at NCI to receive a list of all of the professionals currently in the genetics directory with their e-mail addresses. Could you please generate a spreadsheet with the following information?

-CDR ID
-Name
-E-mail

I think you will want to look at all person records and then limit to those with GeneticsProfessionalDetails blocks and Include In Dir? values of "Include". The e-mail will be in the "Other Practice Location" block. (If more than one practice location is listed, please include only the first e-mail that you come across.)

Thanks!

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

Here's the requested report.

Comment entered 2013-09-10 16:48:34 by Kline, Bob (NIH/NCI) [C]

Done.

Comment entered 2013-09-10 17:25:36 by Juthe, Robin (NIH/NCI) [E]

Great, thanks!

I checked a few of the names at the bottom of the list (I was puzzled by three that didn't have e-mails) and found that they do have e-mails in the CDR but the records have not been published. I plan to remove those (and two others right above them that haven't been published) before sharing the list. William, you might want to take a look at the last few on the list just to be sure their e-mails are stored correctly.

Comment entered 2013-09-11 09:36:44 by Osei-Poku, William (NIH/NCI) [C]

All five records you mentioned above are new applications which are being processed. That is why they are in their current states. They will all be QAed before they are published.

Attachments
File Name Posted User
ocecdr-3660.xls 2013-09-10 16:48:20

Elapsed: 0:00:00.001640