Differences

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

--- sfx_statistics_archives_files [2015/02/04 16:33] – cknapp
+++ sfx_statistics_archives_files [2019/03/29 15:28] (current) – jmulvaney
@@ Line 1: / Line 1: @@
 ====== 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 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.
+**UPDATE 2/2019**: Kat decided to maintain all current statistics until FOLIO is in place. After 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
   * Sept-Nov 2005 archive file is called stats.20060105-173540.saf
@@ Line 47: / Line 51: @@
   * 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_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.