SFX Statistics Query 12: Full-Text Not Found Report

The “Journals Requested but have no full-text” report is run on 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.

• 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.

• 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.

1. Paste each month's data into a single worksheet. Notes may be omitted.
2. Sort resulting worksheet by ISSN/title column to group each title's data together.
3. Using the Excel subtotal function, insert subtotals for each title.
4. Copy the whole resulting sheet.
5. Using Excel's Paste-Special function, paste into a new sheet as values
6. Using the Excel filter function, filter to show lines with the word Total in them.
7. Copy the resulting total lines only display.
8. Sort the result by requests. Add notes as needed.

— Primary contact: Christine Turner