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. How to generate report of unique active SFX titles

    How to generate report of unique active SFX titles

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: SFX
    • Product Version: 4

    Desired Outcome Goal:
    Generate a file containing unique, deduplicated list of all active items in SFX KnowledgeBase (both serials and monographs)

    Procedure:
    1) In SFX Admin's Export Tool, create a basic query of all active portfolios
    2) Open the resulting export file in Excel, using the "text" format
    3) Place Object IDs in the first column. Select ALL of the worksheet, and sort by Object IDs
    4) Insert a new Column to the left of the Object IDs column.
    5) Insert a formula into the newly created column (Column A): =IF(B1=B2,1,0)
    6) Drag the formula down into all the cells in Column A that correspond with Object IDs in Column B.
    There should appear a 1 in Column A next to each duplicate Object ID in Column B and a 0 next to all the rest of the Object IDs
    7) 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.
    8) Select ALL of the worksheet and sort by Column A. All the 1s should appear at the bottom of the column.
    9) Delete all the 1s from Column A and the corresponding duplicate Object IDs from column B.
    10) Delete column A

    Category: KBTools - Export (SFX)

    Subject: SFX


    • Article last edited: 10/17/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • How to extract SFX holdings to load into Primo
      • How to increase timeout?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      SFX
    2. Tags
      1. 4
      2. contype:kba
      3. KBTools - Export (SFX)
      4. Prod:SFX
      5. Review Needed
      6. sfx
      7. 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