EBMS Tickets

Issue Number 569
Summary [Reports] New Journals Report
Created 2020-07-15 13:59:13
Issue Type Improvement
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2023-07-07 13:43:54
Resolution Fixed
Path /home/bkline/backups/jira/oceebms/issue.266317
Description

We would like to generate a report of newly added journals (i.e., journals for which an article was imported for a selected Board for the first time) for a given time period. We would use this report to identify journals to add to our NOT list in a periodic fashion. 

 

It may make more sense to run this as an ad-hoc report periodically, as we do with the other journal report used for NOT list maintenance. Let's discuss.

Comment entered 2020-07-15 14:08:46 by Kline, Bob (NIH/NCI) [C]

LOE will be estimated when requirements have been nailed down.

Comment entered 2021-07-01 14:18:33 by Kline, Bob (NIH/NCI) [C]

We've decided to go with the approach of requesting ad-hoc reports as needed for now, and Robin and Victoria will meet tomorrow to discuss the particulars of what should be in the report.

Comment entered 2021-08-05 14:04:31 by Kline, Bob (NIH/NCI) [C]

Those discussions are still ongoing.

Comment entered 2023-05-31 13:44:01 by Boggess, Cynthia (NIH/NCI) [C]

Here are some possible requirements we can discuss:

  1. Report for each board.

  2. Journal must not already be on a board's NOT journal list.

  3. Journal must have at least one citation in EBMS.

  4. All citations for journal must have been imported after a specified date.

  5. Journal must have 0 citations in EBMS prior to specified date.

Comment entered 2023-06-02 09:42:11 by Boggess, Cynthia (NIH/NCI) [C]

Another approach that might work would be to run the same journal report as we have run in the past and compare it to the last one run, then pulling out the journals that appear on the new report that were not on the report the last time it was run. This would only work if we have a copy of the last journal report that was run.

Comment entered 2023-06-22 14:25:19 by Juthe, Robin (NIH/NCI) [E]

Adding related ticket describing the ad-hoc journal report ran previously.

Comment entered 2023-06-22 16:53:43 by Kline, Bob (NIH/NCI) [C]

So, just confirming the plan: I am to run the OCEEBMS-301 report code (adjusted to use the new table structures), attach it to this ticket, and you will compare it with the report most recently attached to that ticket, right?

Comment entered 2023-06-22 16:58:37 by Kline, Bob (NIH/NCI) [C]

Also, what start/end dates would you like to use for this run?

Comment entered 2023-07-03 15:04:01 by Kline, Bob (NIH/NCI) [C]

 

Just a reminder that there are still open questions for this ticket.

Comment entered 2023-07-06 15:41:06 by Shields, Victoria (NIH/NCI) [E]

Yes, we will compare this to the last report.

Please run the report for the time frame of Aug 6, 2021 to June 30, 2023.

Thanks!

Comment entered 2023-07-07 13:43:54 by Kline, Bob (NIH/NCI) [C]

Workbooks attached.

Comment entered 2023-07-07 14:46:56 by Shields, Victoria (NIH/NCI) [E]

Thank you! We're looking forward to digging into these and whittling down our journal lists!

Attachments
File Name Posted User
not_listed.xlsx 2023-07-07 13:43:29 Kline, Bob (NIH/NCI) [C]
not_not_listed.xlsx 2023-07-07 13:43:29 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.000507