This is an old revision of the document!


SFX Statistics Query 12: Full-Text Not Found Report

The “Journals Requested but have no full-text” report is run on the offline table.

Each month login to the UNIX server to move the online table data to the offline table:

  • Go to the admin directory (da).
  • Run the script to call the utilities menu: ./server_admin_util
  • From main menu choose #5 for statistics.
  • Within statistics, choose #1 to move data from online to offline if there is room in the table (see Note).
  • Note: While logged in to the unix server, check status of the offline table under #5 – Statistics and #4 – Show stats tables monitor information. Online and offline tables should not exceed 200k requests (row count). When it’s close, move offline data to archive. The Archive is located at /exlibris/sfx_ver/sfx4_1/umass3/archive/filename. We maintain a list of filenames.

From the web admin interface, go to the Statistics module:

  • Choose “Statistics Queries”.
  • Choose “Journals Requested but have no full-text”.
  • Select parameter to show All.
  • Set date range for month you want.
  • Select format for plain-text and delivery for email.
  • Open new .xls, import plain-text file and save to W:\DEPARTMENTAL_FOLDERS\Acquisitions\SFX_Project\20xx Statistics.

In Notes column add the following information:

  • Full-text holdings we may have activated. Get this from SFX object threshold field. If active in aggregator or package, note name and any embargo.
  • If not active in SFX, check Aleph Acq module to see if online order is pending.
  • If print subscription in Aleph, check EbscoNet to make sure we don't also have included online access.
  • If title is open access, investigate quality and quantity and make activation decision.
  • Resolve any linking or title change issues.

Compiling monthly data to .xlsx for fiscal year:

  1. Paste each month's data into a single worksheet. Notes may be omitted. Paste consecutive months at the bottom of previous month.
  2. Select all and sort resulting worksheet by ISSN/title column to group each title's data together.
  3. Using the Excel subtotal function [Data tab→Subtotal], insert subtotals for each title [use defaults, function=SUM, check 2nd column, summary below].
  4. Copy the sheet data [Ctrl-C]. To remove functions from column 2, use Excel's “paste-special” function to Paste as Values into a new sheet.
  5. Using the Excel filter function [Text filter on Column A], filter to show only lines with the word “Total” in them. [Home>Sort&Filter>Filter, then use drop-down on column>Textfilter>Contains “ Total”.]
  6. Copy the displayed Total lines only by:
    • Edit tab> Find & Select> Go to Special> Visible Cells Only
    • Then copy [Ctrl-C].
  7. Then paste into a fresh worksheet. n.b. Excel seems to give bizarre error messages if you try to copy over about 3K lines. You may have to copy and paste in “chunks.”
  8. Sort the result by requests. Add notes as needed.

Primary contact: Christine Turner

sfx_fulltext_not_found.1308157742.txt.gz · Last modified: 2019/01/07 17:20 (external edit)
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0