This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
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 ====== | ====== 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 | * 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 47: | Line 51: | ||
* 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. |