Differences
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. | ||
