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
Next revision Both sides next revision
ebsco_regular_tasks [2019/06/21 15:11]
jmulvaney [Elsevier HLM Holdings]
ebsco_regular_tasks [2019/12/06 16:19]
jmulvaney [SCUA Location Lookup Tables]
Line 23: Line 23:
 ==== SCUA Location Lookup Tables ==== ==== SCUA Location Lookup Tables ====
 Twice a year, the SCUA location lookup table (for limiting by collection in the advanced search window) needs to be updated to catch new collections and resources added to Credo. Twice a year, the SCUA location lookup table (for limiting by collection in the advanced search window) needs to be updated to catch new collections and resources added to Credo.
-  * Go to the URL Aaron created to access the AOP (check the Working Documentit's attached as a note to a cell)+  * Go to the URL Aaron created to access the OAI endpoint. ​(Search in email for SCUA OAIemail is from April 2019.)
       * Save (right click) as an XML file       * Save (right click) as an XML file
-      * Go to the save location and convert ​the file  to an Excel Spreadsheet. +      * Open a blank Excel File 
-  * Allow Excel to open the file as an XML table, and to create its own Schema. (Click OK twice.)+      * Open the XML File (not through ​the data tab, but underl File > Open) 
 +      * Allow Excel to open the file as an XML table, and to create its own Schema. (Click OK twice.) 
 +  * Copy and paste the data into a new tab to sever the link with the XML File
   * Open the credo_lookup_table document.   * Open the credo_lookup_table document.
-      * DRMS Drive>​EDS>​Institutional Repository and Catalog>​SCUA Lookup Table Updates Folder+      * DRMS Drive > EDS > Institutional Repository and Catalog > SCUA Lookup Table Updates Folder
           * The documents inside are the ones sent to EBSCO. Find the latest.           * The documents inside are the ones sent to EBSCO. Find the latest.
-          * **If the number of rows match betwn the two worksheets (new and old) you don't have to continuee.**+          * **If the number of rows match between ​the two worksheets (new and old) you don't have to continue.**
   * Remove the first three columns and the final column from the new data   * Remove the first three columns and the final column from the new data
       * These are identifiers and descriptions that are not needed for EDS.       * These are identifiers and descriptions that are not needed for EDS.
-  * Steal the First line for formatting ​the document ​to send to Support +  * Set up the headers ​for the file to send to EBSCO (Steal it from the old document) 
-      * Name in Data matches to ns1:​setSpec +      * ns1:​setSpec ​: Name in Data 
-      * Facet Display: **INSERT BLANK COLUMN** +      * Insert Blank Column: ​Facet Display 
-      * Full Displayns1:setName+      * ns1:setName : Full Display 
 +      * ns1:​setName ​: Limiter
       * Limiter: ns1:setName (Copy the entire column)       * Limiter: ns1:setName (Copy the entire column)
   * The Second Column (Facet Display) needs to be created manually   * The Second Column (Facet Display) needs to be created manually
       * Copy the column from the old document send to EBSCO       * Copy the column from the old document send to EBSCO
-      * Find the places where the changes happened.+      * Find the places where the changes happened. ​(//For Dec. 2019 the new additions were all at the bottom of the file//
           * Insert a Cell and create a new Facet Display Name           * Insert a Cell and create a new Facet Display Name
-      * **SAVE THE DOCUMENT** ​as a .txt tab delimited ​file to the same folder. +      * Save the Excel spreadsheet and then save it as a .txt file 
-  * Email the document to Support ​or use the Supportal ​to submit it. +  * Email the document to Support to submit it. 
-      * Ask for the table to be added to "UMass SCUA Digital Collections (ir01012a)"​+      * "​Hello,​ Could the attached file be used to update the location lookup table for UMAAH ir01012a ​(Credo UMass Amherst)? Thanks! Jack"
 ===== LCL Collection Updates ===== ===== LCL Collection Updates =====
 These are to update specific LCL collections created for linking to full text in EDS. These are to update specific LCL collections created for linking to full text in EDS.
Line 66: Line 69:
 The Elsevier update is to make sure our holdings are reflected correctly in HLM, to facilitate the Exact Match placard and SmartPlus Linking in EDS. The Elsevier update is to make sure our holdings are reflected correctly in HLM, to facilitate the Exact Match placard and SmartPlus Linking in EDS.
 ===== Regular Updates ===== ===== Regular Updates =====
 +Other than renewals, there are relatively few recurring actions that need to be made in EDS or HLM.
 ==== CustomLinks added to Profile ==== ==== CustomLinks added to Profile ====
 Twice a year in the Spring and Summer after renewals are over, all the CustomLinks in the "​Modify"​ screen should be checked to make sure they have been added to the profile (ranked) or that anything that does not belong there has been removed. Anything that isn't in CORAL should be put in or evaluated for deletion. Twice a year in the Spring and Summer after renewals are over, all the CustomLinks in the "​Modify"​ screen should be checked to make sure they have been added to the profile (ranked) or that anything that does not belong there has been removed. Anything that isn't in CORAL should be put in or evaluated for deletion.
[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