EBMS Tickets

Issue Number 812
Summary Excel Spreadsheet of Outstanding S&P Articles
Created 2024-02-01 14:36:53
Issue Type Task
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Juthe, Robin (NIH/NCI) [E]
Status Resolved
Resolved 2024-02-05 12:58:45
Resolution Fixed
Path /home/bkline/backups/jira/oceebms/issue.390299
Description

I'd like to create a spreadsheet of S&P articles that are currently in the Abstract queue without a decision from review cycles October 2023 or earlier.

Please include the following information in the report:

Article Information - first 5 lines of the bibliographic information on the Full Citation page (with link to Full Citation page from article title)

Review Cycle

Import Date (for the initial import into the EBMS)

Summary Topic(s) - showing S&P topics only - all topics can live in a single cell either on separate lines within the cell or with a comma between them (whatever is easiest)

 

Please let me know if you have questions. Thank you!

Comment entered 2024-02-01 16:03:33 by Kline, Bob (NIH/NCI) [C]

Screening and Prevention or Supportive and Palliative care?

Comment entered 2024-02-01 16:05:54 by Kline, Bob (NIH/NCI) [C]

Or both?

Comment entered 2024-02-02 14:18:52 by Juthe, Robin (NIH/NCI) [E]

Screening and Prevention. Thank you!

Comment entered 2024-02-05 12:58:45 by Kline, Bob (NIH/NCI) [C]

I tried linking from the article titles to the full article pages, but Excel complained that the resulting workbook was corrupted (though it wouldn't say why it thought so). So I moved the link to the EBMS ID column's cells, and Excel was happy.

Attachments
File Name Posted User
oceebms-812-a.xlsx 2024-02-05 12:55:47 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.000177