This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
ebsco_regular_tasks [2020/06/12 15:37] jmulvaney [SCUA Location Lookup Tables] |
ebsco_regular_tasks [2020/06/12 15:38] jmulvaney [SCUA Location Lookup Tables] |
||
---|---|---|---|
Line 12: | Line 12: | ||
**This isn't working with newer versions of excel** | **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. (It is stored in JGMs calendar invite.) |
* Save (right click) as an XML file | * Save (right click) as an XML file | ||
* Open a blank Excel File | * Open a blank Excel File | ||
Line 39: | Line 39: | ||
**Workaround** | **Workaround** | ||
- | * 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. (It is stored in JGMs calendar invite.) |
- | * Scroll to the bottom | + | * Scroll to the bottom of the XML Tree |
* Compare the final collection to the most recent file sent to EBSCO (As of 20200612 it is Silvio O. Conte) | * Compare the final collection to the most recent file sent to EBSCO (As of 20200612 it is Silvio O. Conte) | ||
- | * Check DRMS Drive | + | * Check DRMS Drive or EBSCO Connect |
* If they match, no new collections have been added | * If they match, no new collections have been added | ||
* If they don't, use the formatting mentioned above and create a new lookup table with additional collections appended to the older version. Send to EBSCO as outlined above. | * If they don't, use the formatting mentioned above and create a new lookup table with additional collections appended to the older version. Send to EBSCO as outlined above. |