EJP Hum Reports

Reports should be sent to hum on the first day each month using the following procedure.
Note: Once EJP is configured to disallow the same email for different authors the query send should be automated.

How to de-dupe emails when needed. Emails can be duplicated as long as they are for the same EJP user and are in the report for different submissions. 

Set the run date to the previous month. e.g., on Dec 1st, the report should be run for Nov 1-Nov 30. 

Run the report and download the excel file.

• Sort on email

• Conditional format on email address column to highlight dupes

• Conditional format on EJP ID column to highlight dupes using the same color as you did for email. This will make or an easy visual scan,

• Look for matching emails and ensure that the PIDs are also matching. 

  • If they match, leave them as they are for the same person for different submissions

  • If they don't match, and the authors are contributing authors, simply delete the rows. 

  • If they don't match because the corresponding author has duplicate accounts, merge the accounts in EJP, keeping the newer account. Note the PID that is retained, and update the discarded one with the retained one.