Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
sfx_fulltext_not_found [2011/06/15 16:57]
cknapp
sfx_fulltext_not_found [2019/04/09 14:17] (current)
jmulvaney
Line 1: Line 1:
 ====== SFX Statistics Query 12: Full-Text Not Found Report ====== ====== 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 SFXIt 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 datesThis 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. Paste consecutive months at the bottom of previous month. 
-  -  Select all and sort resulting worksheet by ISSN/title column to group each title'​s data together.  ​ 
-  -  Using the Excel subtotal function [Data tab->​Subtotal],​ insert subtotals for each title [use defaults, function=SUM,​ check 2nd column, summary below]. 
-  -  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. 
-  -  Using the Excel filter function [Text filter on Column A], filter to show only lines with the word "​Total"​ in them. [Edit>​Sort&​Filter>​Filter,​ then use drop-down on column>​Textfilter>​Contains " Total"​.] 
-  -  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. 
  
  
Line 44: Line 22:
  
  
- --- //[[cturner@library.umass.edu|Primary contact: ​Christine Turner]]// + --- //[[jmulvaney@library.umass.edu|Primary contact: ​Jack Mulvaney]]//
  
sfx_fulltext_not_found.1308157033.txt.gz · Last modified: 2019/01/07 17:20 (external edit)
[unknown link type]Back to top
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