Location: Member Products : SFX : secure : Counting Titles in SFX
Counting Serial Titles through SFX

To get a count, for ACRL reporting or other purposes, of the number of serial titles available to your users, you may use the following procedure:

  1. If your SFX instance is linked to CARLI's shared SFX instance, then:
    1. Right click on shared_instance_objects.txt.zip , download and save the file to your workstation.
    2. Unzip the file.

If your SFX instance is not linked to CARLI's shared SFX instance, simply proceed to step B.

  1. In SFXAdmin (https://sfx.carli.illinois.edu/sfxadmin/sfx*** , where *** is the three-letter code for your library), complete the form at Export Tool -> Advanced Export Queries:
    1. Select Aleph Sequential.
    2. Check Serials.
    3. If your SFX instance is linked to CARLI's shared SFX instance, then click the Browse button in row 3. Locate the shared_instance_objects_[date].txt file you downloaded from the CARLI web site and unzipped in step A. Click "Open."
      SFX Admin Center
      If your SFX instance is not linked to CARLI's shared SFX instance, leave row 3 blank.
    4. Check getFullTxt. If you have loaded your print holdings into SFX, also check getHolding.
    5. Select Export from ALL in row 5.
    6. Rows 6-9 may all be left blank. Click "Submit."
  2. Leave your browser window open while the report runs. When it has finished, click "Download" to save the export file to your workstation.
  3. The downloaded export file will be too big to open in Excel, but may be opened in a text editor such as Wordpad or BBEdit. Scroll to the bottom of the file. The last number in the leftmost column is the count of objects in SFX for which there is one or more active object portfolio. In other words, this is the count of titles that are available to you, at any target, via SFX. Titles that are available at more than one target (whether the target is activated in your local instance of SFX or activated for you in the shared instance of SFX) are counted only once.