Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    How can I clean up duplicate titles from a manually uploaded 360 Counter report?

    • Product: 360 Counter



    A red validation error appears after uploading my report and I see the following message on the Counter Report Data page:


    This report contains multiple entries for the same journal. All duplicates must be removed or merged


    How can I clean up duplicate titles from a manually uploaded 360 Counter report?


    When 360 Counter detects exact duplicates (title and identifier match) the duplicates must be merged or deleted before usage can consolidate.


    Use the following steps to merge duplicates:


    1. After uploading the report, click the 'paper' icon under the Data column.

    2. Wait for the report to load.

    3. Set the filter in the Title column to "Records with Errors" to display duplicates. 


    Merge Duplicate Records.png







    4. Click on the red/blue merge arrows to merge each pair of duplicates.


    Merge Arrows.png



    5. After merging duplicates, click on the "Save Changes" button to save the results. You will be redirected to the 360 Counter landing page and should see the hourglass icon (indicating that the data is consolidating) rather than the error icon for the report. 


    Additional Information
    • - If you would rather delete one of the duplicates click on the red "X" next to the title you wish to delete.
    • - This merge functionality works for multiple pairs of duplicates. If you have multiple occurrences in your report where there are two of the same item, you can merge all of them by continuing to click the merge arrows until all duplicates have been merged.
    • - Note that if there are an odd number of duplicates the merge arrows may not work as expected and the duplicates will need to be handled in the actual report file using Excel or a similar program.
    • - Steps for cleaning up duplicate titles in an Excel file can be found in: 360 Counter and Intota: Finding Duplicate Titles in Usage-Data Reports to be Uploaded.


    • Article last edited: 24-May-2017