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

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

    • 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