Differences

This shows you the differences between two versions of the page.

--- sfx_fulltext_not_found [2011/04/26 20:15]
lmatson
+++ sfx_fulltext_not_found [2019/02/13 20:35]
cknapp
@@ Line 1: / Line 1: @@
 ====== 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: =====
+**As of 2016, Full Text Found reports are no longer reviewed.**
-  * Go to the admin directory (da).
+Query 12 aka the SFX Fulltext not Found report counts the unfilled requests to SFX. It is run monthly on the previous month's data in the offline table, all requests listed.
-  * 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. [[SFX_statistics_archives_files|We maintain a list of filenames.]]
-===== From the web admin interface, go to the Statistics module: =====
+Top 100 or so most requested items are reviewed for:
+    a. Correct activation in SFX / linking or threshold problems
+    b. Desirability of addition to our collection if open access
+    c. Possibility of move to online if we have a print subscription
+Notations are made to speed lookup of subsequent occurrences of the title in following months and make easy identification of publisher.
-  * Choose “Statistics Queries”.
+Query 12 is also run at the end of fiscal and calendar years to gather those ranges of dates. This summary report is reviewed as above.
-  * Choose “Journals Requested but have no full-text”.
+Pricing is added for the top / most desired titles and the report sent to Selectors with requested Desiderata additions.
-  * 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: =====
+All reports are stored on the W drive at \Departmental_Folders\Acquisitions\SFX_Project\[YR]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.
-===== Compiling monthly data to .xlsx for fiscal year: =====
-  -   Paste each month's data into a single worksheet. Notes may be omitted.
-  -  Sort resulting worksheet by ISSN/title column to group each title's data together.
-  -  Using the Excel subtotal function, insert subtotals for each title.
-  -  Copy the sheet data [Ctrl-C]. Use Excel's "paste-special" function to Paste as Values into a new sheet.
-  -  Using the Excel filter function [Text filter on Column A], filter to show only lines with the word "Total" in them.
-  -  Copy the displayed Total lines only by:
-     *  Edit tab> Find & Select> Go to Special> Visible Cells Only
-     *  Then copy [Ctrl-C]
-  - 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."
-  - Sort the result by requests. Add notes as needed.