This is an old revision of the document!


SFX Statistics and Archives Files

As of 12/2017, SFX statistics will be automatically archived 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.

As of 3/2016, SFX statistics will be automatically archived from the offline file by ExLibris. ExLibris will leave the previous year, meaning that by Dec31 there can be up to 18 months of statistics remaining. We should be able to upload archived statistics via ./server.admin.util but may need to request file name from EL support. (7/1/2015-6/30/16 was archived 10/22/17)

As of 2016 we are running SFX Queries 2,3,4,5,6,8,10,11,12 by cron monthly, adding 14 and 19 for calendar and fiscal year stats.

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, sending files to Catherine's email. Statistics reports can be rescheduled through SFX Admin>Statistics>Queries>(Query#)>Schedule. Previously 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.

  • Aug 2005 archive is stats.20051109-161917.saf
  • Sept-Nov 2005 archive file is called stats.20060105-173540.saf
  • December 2005 stats archive file is called stats.20060202-12:56:28.saf
  • Jan-April 2006 file is called stats.20060601-12:06:44.saf
  • May 2006 file is called stats.20060601-14:08:46.saf
  • Summer (June-Aug) 2006 file is called stats.20060901-14:23:18.saf
  • Fall 2006 (Sept – Dec) is called stats.20070104-10:43:08.saf
  • Spring 2007 (Jan – May 07) is called stats.20070620-10:52:51.saf
  • Summer 2007 (June – Aug 07) is called stats.20070904-13:16:18.saf Note that due to two table crashes, clickthrough data is missing.
  • Sept – Nov 07 is called stats.20080110-15:06:42.saf
  • December 07 is called stats.20080102-15:50:34.saf
  • Jan – Feb 08 is called stats.20080523-10:51:04.saf
  • March – April 08 is called stats.20080522-13:49:49.saf
  • May – July 08 is called stats.20080902-09:52:58.saf
  • Aug – Sept 08 is called stats.20081104-14:20:55.saf
  • Oct – Nov 08 is called stats.20090901-12:49:37.saf
  • December 08 - February 09 is stats.20090402-12:33:28.saf
  • March - April 2009 is stats.20090601-11:21:42.saf
  • May - July 2009 is stats.20090820-09:59:38.saf
  • August 2009 is stats.20091001-12:46:16.saf
  • Sept - Oct 2009 = stats.20091201-08:57:45.saf
  • November - December 2009 = stats.20100201-08:43:50.saf
  • Jan - Feb 2010 = stats.20100407-11:57:53.saf
  • March 2010 = stats.20100504-15:35:33.saf
  • April - May 2010 = stats.20100701-08:30:50.saf
  • June - August 2010 = stats.20101004-11:00:15.saf
  • August 2010 = stats.20110425-12:42:01.saf
  • September 2010 = stats.20101101-11:15:45.saf
  • October 2010 = stats.20101201-07:07:07.saf
  • November 2010 = stats.20110105-09:48:18.saf
  • December 2010 = stats.20110207-09:13:37.saf
  • January 2011 = stats.20110308-07:27:35.saf
  • February 2011 = stats.20110404-06:46:18.saf
  • March 2011 = stats.20110425-09:05:15.saf
  • April 2011 = stats.20110912-07:07:07.saf
  • May-July 2011 = stats.20110801-12:56:55.saf
  • Aug-Oct 2011 = stats.20111205-07:19:43.saf
  • Nov-Dec 2011 = stats.20120206-06:55:22.saf
  • Jan-Jun 2012 = stats.20130123-07:16:13.saf
  • July-Dec 2012 = stats.20130715-06:51:32.saf
  • Jan-Jun 2013 = stats.20140128-06:58:22.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
  • 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_from2015-07-01_00:04:53_to2015-12-31_23:51:34.saf
    • compressed = stats.20170620-07:15:20_from2015-07-01_00:04:53_to2015-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.

Archived files are located in “/exlibris/sfx_ver/sfx4_1/umass3/archive/” subdirectory.

Primary contact: Christine Turner

sfx_statistics_archives_files.1512405705.txt.gz · Last modified: 2019/01/07 17:20 (external edit)
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