Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    SFX

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. SFX
    3. Knowledge Articles
    4. Count of all unique journals / active portfolios with ISSN de-duplication

    Count of all unique journals / active portfolios with ISSN de-duplication

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: SFX
    • Product Version: 2

    Description:
    Is there an automated way in the Export Tool to generate an active full-text portfolio count (where target and service are also active) that deduplicates ISSNs - to produce a simple count of how many unique full-text porfolios are currently enabled in the KB?

    Resolution:
    If you make an Export Tool query in TXT format you can use Excel to achieve this. Open the resulting export file in Excel and follow the steps below:

    1) Place ISSNs in the first column. Select ALL of the worksheet, and sort by ISSN

    2) Insert a new Coulmn to the left of the ISSN column.

    3). Insert a formula into the newly created column (Column A):

    =IF(B1=B2,1,0)

    4) Drag the formula down into all the cells in Column A that correspond with ISSNs in Column B.

    There should appear a 1 in Column A next to each duplicate ISSN in Column B and a 0 next to all the rest of the ISSNs

    5) Replace the formulas in Column A with values by selecting the column, pressing ctrl+c, selecting "paste special" from "edit", and clicking on "values" radio button.

    6) Select ALL of the worksheet and sort by Column A. All the 1s should appear at the bottom of the column.

    7) Delete all the 1s from Column A and the corresponding duplicate ISSNs from column B.

    8) Delete column A

     

    Additional Information

    If you have SSH access to your SFX instance, another way to get the unique journal count is by checking the SFX A-Z logs for the number of AZ Titles Loaded:

    • For each instance, go to the following directory:   /exlibris/sfx_ver/sfx4_1/<instance_name>/logs
    • To find recent logs at the bottom of a list, type:    ls -lrt
    • To see the summary section of a recent A-Z log, enter the command:  tail -f {az_index_builder log file name}
                 Example:  tail -f az_index_builder.20170919072356.log

    The log will display details on the # of active objects processed, # failed objects, and AZ Titles Loaded - see example below:

    2017/09/19 07:59:25   * Active objects processed: 107713
    2017/09/19 07:59:25   * Failed objects (see log for details): 0
    2017/09/19 07:59:25   * AZ Titles loaded: 107713

    • The "Active Objects Processed" and the "AZ Titles Loaded" represent the unique journal title count.


    Please note that if you have configured SFX to exclude Targets from displaying in the A-Z list, you may get a lower number of unique journal titles than the export/dedup method described at the top of this Article. 

     


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Copy-DB process cannot be executed via cron
      • Create Primo thumbnails from the jpegs (access files) not the preservation master files.
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      SFX
    2. Tags
      1. 2
      2. active
      3. contype:kba
      4. count
      5. DeDup
      6. excel
      7. export
      8. issn
      9. portfolios
      10. Prod:SFX
      11. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved