This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
ebsco_regular_tasks [2019/12/06 16:19] jmulvaney [SCUA Location Lookup Tables] |
ebsco_regular_tasks [2020/04/07 16:34] jmulvaney |
||
---|---|---|---|
Line 7: | Line 7: | ||
==== FCC Location Lookup Tables ==== | ==== FCC Location Lookup Tables ==== | ||
The location lookup table for the physical spaces of the Five Colleges need to be updated periodically based on changes to Aleph collection codes and SubLibraries. | The location lookup table for the physical spaces of the Five Colleges need to be updated periodically based on changes to Aleph collection codes and SubLibraries. | ||
- | * **Figure out with Kat how to get the data in the first place, either by ticket or through an ARC Query** | + | * This is something coordinated through Five College discovery. When new collections or locations are created or deleted, let DRMS know and we can work to update them with EBSCO. |
- | * Copy the new data from Aleph into a Spreadsheet | + | |
- | * Open the most recent version of the Location Lookup Table | + | |
- | * DRMS Drive>EDS>Institutional Repository and Catalog>Location Table versions for Aleph..... | + | |
- | * Set up the headers for the new document: | + | |
- | * Location_Code, Copy_Display, Facet_Display, Limiter_Display | + | |
- | * Match Location Code to the correct Column | + | |
- | * Match SubLibrary to the Copy_Display Column | + | |
- | * Use the old document to match the Facet Displays to the Copy Displays | + | |
- | * When you find changes, match them to existing Facet_Displays | + | |
- | * Duplicate the Facet_Display column in the Limiter_Display column | + | |
- | * Save the file in the same location as the previous file. | + | |
- | * Submit the file to Support | + | |
- | * **Ask for them to update the Locations for all Five College Institutions.** | + | |
==== SCUA Location Lookup Tables ==== | ==== SCUA Location Lookup Tables ==== | ||
+ | **This isn't working with newer versions of excel** | ||
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 OAI endpoint. (Search in email for SCUA OAI, email is from April 2019.) | * Go to the URL Aaron created to access the OAI endpoint. (Search in email for SCUA OAI, email is from April 2019.) | ||
Line 47: | Line 36: | ||
* Save the Excel spreadsheet and then save it as a .txt file | * Save the Excel spreadsheet and then save it as a .txt file | ||
* Email the document to Support to submit it. | * Email the document to Support to submit it. | ||
- | * "Hello, Could the attached file be used to update the location lookup table for UMAAH ir01012a (Credo UMass Amherst)? Thanks! Jack" | + | * "Hello, Could the attached file be used to update the location lookup table for UMAAH ir01012a (UMass SCUA Digital Collections)? 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. |