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, Robert (NIH/NCI) [C]

Screening and Prevention or Supportive and Palliative care?

Comment entered 2024-02-01 16:05:54 by Kline, Robert (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, Robert (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.

Comment entered 2025-04-08 14:25:36 by Juthe, Robin (NIH/NCI) [E]

Hi   - I'm finally getting back to this report in the parking lot. I'd like to add a new state of "No further action" to the listed summary topics that are associated with each of these articles, thereby removing them from the review queue. We had previously discussed doing this manually (and Bonnie is happy to help) but given that there are >1500 articles I wanted to see what would be involved to do this programmatically. Can we discuss on Thursday? thanks.

Comment entered 2025-04-10 10:41:36 by Kline, Robert (NIH/NCI) [C]

Script tested on QA (refreshed from PROD). For example:

Comment entered 2025-04-10 11:07:12 by Kline, Robert (NIH/NCI) [C]

Attached log from test run on QA. Note that there are only 1,334 entries in the log, compared to the 1,502 states reported in the Excel workbook (these are counts of article topic states, not articles—some articles have multiple topics matching the query). I presume this is because users have added different states to some of the article/topic combinations since the report was originally generated.

Comment entered 2025-04-14 11:39:30 by Juthe, Robin (NIH/NCI) [E]

Hi   - this looks great to me. I spot checked several articles on QA. I could be missing it, but I don't see the log file? Could you please try reposting that or putting the link directly in a comment? Thanks!

Comment entered 2025-04-14 11:47:09 by Kline, Robert (NIH/NCI) [C]

Not sure what happened: either I thought I had attached it when I hadn't, or I did attach it but JIRA tossed it. I've tried again. Let me know if you see it now.

Comment entered 2025-04-14 15:12:30 by Juthe, Robin (NIH/NCI) [E]

I see it now, thanks. Again I spot-checked a few of the articles in the log and all looked fine. Is this next step to run this on PROD?

Comment entered 2025-04-16 17:02:25 by Kline, Robert (NIH/NCI) [C]

The script has been run on EBMS PROD. The log file is identical to the one we got from the run on QA. Please review the articles, and if everything looks as it should, you can close the ticket.

Attachments
File Name Posted User
oceebms-812.log 2025-04-14 11:45:27 Kline, Robert (NIH/NCI) [C]
oceebms-812.png 2025-04-10 10:40:12 Kline, Robert (NIH/NCI) [C]
oceebms-812-a.xlsx 2024-02-05 12:55:47 Kline, Robert (NIH/NCI) [C]

Elapsed: 0:00:00.000314