EBSCO Ebooks Update

1. Overview and Context

This procedure updates the EBSCO_ebook table in the SQL Database.

2. Triggers

The execution of this procedure is usually triggered by

• Metrics

3. Steps to Be Performed

3.1 Download

The data from EBSCO are prepared once a year and need to be requested by email. Be explicit you want them separated out per month. Email Amy Powers: apowers@EBSCO.COM.

3.2 Clean

• The data comes in basically useless form and needs to be fully reformatted in order to be ingested into our MySQL database. See the example from the 2023–2024 data in the folder.

3.3 Upload

• Navigate to phpMyAdmin table "EBSCO_ebook"
  
• select Import tab;
• select file
• click "Go."
• archive files under Punctum Admin > Metrics > EBSCO

4. Additional Information

5. Document Control