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_statistics_archives_files [2015/02/04 16:32]
cknapp
sfx_statistics_archives_files [2019/03/29 15:28] (current)
jmulvaney
Line 1: Line 1:
 ====== SFX Statistics and Archives Files ====== ====== SFX Statistics and Archives Files ======
-As of 2012, SFX statistics are run on calendar and fiscal year batches and archived in six month segments (see below). 
  
-SFX statistic queries are set up as cron jobs, running on the 14th of the following month, 6:00-7:15 a.m. Central/​Chicago timesending files to Catherine'​s email. Statistics reports can be rescheduled through SFX Admin>​Statistics>​Queries>​(Query#)>​SchedulePreviously scheduled reports need to be removed UNIX side (da>"​crontab -l" ​to list jobs, -e to edit). Stat reports are manually opened from email, checked, and stored at W:​\DEPARTMENTAL_FOLDERS\Acquisitions\SFX_Project\2013 Statistics+**UPDATE 2/2019**Kat decided to maintain all current statistics until FOLIO is in placeAfter that we might consider running only #2,4,8,​12,​19 ​(top 100 only for 12 & 19). Another consideration is which statistics might be relevant ​to collection development.
  
 +Except for fiscal and calendar year reports, SFX statistic queries are set up as cron jobs, running on the 14th of the following month, 6:00-7:15 a.m. Central/​Chicago time. Crons send files to DRMS email or files can be found in SFX Admin>​UNIX File Manager>​dbs/​scratch. Statistics reports crons can be rescheduled through SFX Admin>​Statistics>​Queries>​(Query#​)>​Schedule. Crons can be removed UNIX side (da>"​crontab -l" to list jobs, "​crontab -e" to edit). SFX statistics are automatically archived by ExLibris each month, leaving 12 months in the file for running year and FY stats. Archived files may be retrieved through server_admin_util -> 5 -> 3. To avoid re-instating archived files, do fiscal and calendar stats soon after January and July 1.
 +
 +**MONTHLY AND YEARLY:** SFX Queries 2,​3,​4,​5,​6,​8,​10,​11,​12 are run by cron monthly, adding 14 and 19 for calendar and fiscal year stats. Calendar and fiscal year stats are done manually. ​ **RUN TOP 100 ONLY** for queries 2,​10,​11,​12,​14,​19. Stat reports are manually opened from email file, checked, and stored at Q:/​DRMS/​SFX/​SFX_statistics. ​
 +
 +Here is a historical list of statistics files when we archived manually.
   * Aug 2005 archive is stats.20051109-161917.saf   * Aug 2005 archive is stats.20051109-161917.saf
   * Sept-Nov 2005 archive file is called stats.20060105-173540.saf   * Sept-Nov 2005 archive file is called stats.20060105-173540.saf
Line 46: Line 50:
   * Jan-Jun 2013 = stats.20140128-06:​58:​22.saf   * Jan-Jun 2013 = stats.20140128-06:​58:​22.saf
   * July-Dec 2013 = stats.20140728-07:​05:​48.saf   * July-Dec 2013 = stats.20140728-07:​05:​48.saf
-  * Jan-Jun 2014 = stats.20150204-06:​58:​43_from__2014-06-02_06:​42:​53_to__2014-01-27_07:​52:​53.saf+  * Jan-Jun 2014 = stats.20150204-06:​58:​43_from_2014-06-02_06:​42:​53_to_2014-01-27_07:​52:​53.saf 
 +  * Jun-Dec 2014 = (Archived by EL) 
 +  * Jan-Jun 2015 = (Archived by EL) 
 +  * July-Dec 2015 (see wiki edit screen for actual text) = stats.20170620-07:​15:​20_from__2015-07-01_00:​04:​53_to__2015-12-31_23:​51:​34.saf 
 +    * compressed =  stats.20170620-07:​15:​20_from__2015-07-01_00:​04:​53_to__2015-12-31_23:​51:​34_sfx_compress.saf.gz 
 +  * Archived by ExLibris support....
  
 To restore an archived file to the offline table for analysis, remember to empty the offline table first. To restore an archived file to the offline table for analysis, remember to empty the offline table first.
sfx_statistics_archives_files.1423067557.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