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_routine_maintenance [2019/07/02 13:13]
jmulvaney
sfx_routine_maintenance [2020/11/02 13:51] (current)
jmulvaney [Autoload Instructions]
Line 36: Line 36:
            * Currently we are getting around this by keeping several older journals targets activated with display logic.            * Currently we are getting around this by keeping several older journals targets activated with display logic.
            * Books are not affected since they don't have title changes.            * Books are not affected since they don't have title changes.
 +
 +**Re-Running Autoload**
 +  * Load the Unix Server and log In
 +  * da
 +  * ./​server_admin_util
 +  * 8 Import/​Export (not by sfxglb41)
 +  * 4/6/7 (depending on Elsevier or Springer)
 +  * Run the Autoloader
 +  * Choose "​Y"​
 +  * Choose "​B"​
 +  * Leave institution name empty for default
 +  * Choose "​Y"​
 +  * Let run and check for success. Manually running the autoload will not trigger an email.
  
 ==== A-Z Journal Search Notes ==== ==== A-Z Journal Search Notes ====
Line 241: Line 254:
   * Check sample changes on SFX menus.   * Check sample changes on SFX menus.
  
-==== Autoload Instructions ​====+==== Statistics ​==== 
 +The chrons run on the 14th to capture the previous months statistics, although the day of the month has no bearing on the stats. Jack from SFX says “SFX Statistics Queries are run against the '​Offline'​ tables, so the 'Min date' and 'Max date' for the Offline Stats table will give you the current range of available statistics date.” 
 +  * ex. on 20xx-07-02, the Stats saved are for 20xx-06-29 to 20xx-07-01 
 +  * Check the instructions for monitoring the stats table at the [[sfx_update_procedures|Weekly Update]] page
  
 +As of Fall 2018 we run Queries 2,​3,​4,​5,​6,​8,​10,​11,​12 on the 14th of every month, and add in 14 & 19 for Calendar and FY stats. The stats for the calendar and fiscal year should be run as close to the first of the month as possible as there is a moving wall of one year which archives older statistics
 +  * To manually run the statistics, navigate to the SFX Admin > Queries > and begin selecting queries.
 +      * Always total by Year
 +      * When available, choose Top 100
 +      * #5 & 11: Choose all Sources
 +      * #10: Choose all Targets
 +      * Change to Specific date range of 1/​1/​20xx-12/​31/​20xx OR 7/​1/​20xx-7/​1/​20xx
 +      * Leave the defaults for the third row of choices
 +      * Change format to plain text and delivery to email, and enter the DRMS email
 +          * Click out of the open text box and then click “Submit Query”
 +
 +Click submit query. A second window will open that will cycle for a while and then let you know that the email sent successfully. You can close out this window without affecting the query and move on to the other chrons. You cannot submit a new chron until after the previous results are delivered.
 +  * Take the data and format it in the same way as the monthly stats files and save them to the DRMS drive under SFX > SFX_Statistics > 20xx Statistics
 ==== Support Cases, Content and Enhancement Requests ​ ==== ==== Support Cases, Content and Enhancement Requests ​ ====
 Send support cases to [[https://​exlidp.exlibrisgroup.com | Salesforce.]] ​ Send support cases to [[https://​exlidp.exlibrisgroup.com | Salesforce.]] ​
Line 290: Line 319:
    * On SFX menu, use right-click,​ "View Page Source"​ to see OpenURL. This OpenURL incorporates metadata sent from source to SFX and, through the SFX parser, creates SFX menu.     * On SFX menu, use right-click,​ "View Page Source"​ to see OpenURL. This OpenURL incorporates metadata sent from source to SFX and, through the SFX parser, creates SFX menu. 
    * To view the URL sent by SFX to the target landing page, set up Debugging first. Go to SFX Admin > Troubleshooting > Debugging. Use "​Debugging in TARGET SCREEN"​ and after entering ONLY YOUR IP ADDRESS, click to "​on"​. Click target on SFX menu and find the URL at the bottom of resulting page. Remember to restore Debugging to "​off"​.    * To view the URL sent by SFX to the target landing page, set up Debugging first. Go to SFX Admin > Troubleshooting > Debugging. Use "​Debugging in TARGET SCREEN"​ and after entering ONLY YOUR IP ADDRESS, click to "​on"​. Click target on SFX menu and find the URL at the bottom of resulting page. Remember to restore Debugging to "​off"​.
 +
 +===== SFX Archived Maintenance =====
 +Everything below is no longer managed manually by UMass.
 +
 +==== Monthly: UNIX side bX Statistics file cleanout ====
 +Chron Job set up for cleanup of files from the OAI Repository table Monday mornings
 +       * After notification that a successful harvest has occurred or every month or two, clean the OAI_REPOSITORY table.
 +          * q (if continuing from above)
 +          * da
 +          * ./​server_admin_util
 +          * 5 (Statistics)
 +          * 9 (Clean OAI_REPOSITORY table)
 +          * 1 (Delete all OAI_REPOSITORY table records)
 +          * y (erase all records in table OAI_REPOSITORY)
 +          * q
 +          * exit 
 +
 +==== Monthly: Scratch directory cleanout: ====
 +ExLibris is doing this now, appears to only hold 1 week of files.
 +       * Web side: SFX Admin>​Administration>​UNIX File Manager>​dbs>​scratch
 +       ​* ​ DO NOT DELETE: Sessions Directory! Recent e_collection and MARCit files! Institutional holdings file (Google Scholar/​WorldCat holdings)! ​
 +           * Leave several months in scratch folder.
 +
 +==== Monthly: Export directory cleanout: ====
 +This seems to be automatically cleaned out as of 2016.
 +       * Web side: SFX Admin > Administration > UNIX File Manager > Export
 +
 +
  
  --- //​[[jmulvaney@library.umass.edu|Primary contact: Jack Mulvaney]]//​  --- //​[[jmulvaney@library.umass.edu|Primary contact: Jack Mulvaney]]//​
sfx_routine_maintenance.1562073186.txt.gz · Last modified: 2019/07/02 13:13 by jmulvaney
[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