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 [text filter “contains”] 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