This is an old revision of the document!
EBSCO Regular Tasks
There are some regular maintenance things that need to be done to make sure that EDS and HLM are up to date.
Also See
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.
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.
Go to the
URL Aaron created to access the OAI endpoint. (Search in email for SCUA OAI, email is from April 2019.)
Save (right click) as an XML file
Open a blank Excel File
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.
Remove the first three columns and the final column from the new data
Set up the headers for the file to send to EBSCO (Steal it from the old document)
ns1:setSpec : Name in Data
Insert Blank Column: Facet Display
ns1:setName : Full Display
ns1:setName : Limiter
Limiter: ns1:setName (Copy the entire column)
The Second Column (Facet Display) needs to be created manually
Copy the column from the old document send to EBSCO
Find the places where the changes happened. (For Dec. 2019 the new additions were all at the bottom of the file
Save the Excel spreadsheet and then save it as a .txt file
Email the document to Support to submit it.
Workaround
Go to the
URL Aaron created to access the OAI endpoint. (Search in email for SCUA OAI, email is from April 2019.)
Scroll to the bottom
Compare the final collection to the most recent file sent to EBSCO
If they match, no new collections have been added
LCL Collection Updates
These are to update specific LCL collections created for linking to full text in EDS.
Literature Criticism Online
Once a year after Spring renewals the LCL collection created for the Literature Criticism Online CustomLink should be updated. Visit the Resource page and click on “What's Inside” under the basic search bar. Export the title list for our databases.
Remove everything but the ISBN and the Title
Save the entire export as a Tab Delimited .txt document
Go to EBSCOAdmin and then the Local Collections Tab
To overwrite the existing local collection, choose upload local titles at the top of the screen.
Make sure the Collection ID is correct (2019LitCri)
Make sure the Column Identifiers are correct.
Make sure the radio button for “Replace is selected”
Upload the file
Submit
Elsevier HLM Holdings
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
Other than renewals, there are relatively few recurring actions that need to be made in EDS or HLM.
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.
— Primary contact: Jack Mulvaney