Thoth CDN Update

1. Overview and Context

This procedure updates the Thoth_CDN 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 CDN operated by Thoth provides access to our PDF files (books.punctumbooks.com). The CDN also generates usage metrics. They are provided on a quarterly basis by Javi from Thoth Open Metadata until an automated system is developed.

3.2 Clean

• delete the column event_uri
• in work_uri, remove the DOI prefixes and .1.00 at the end such that only the PBN remains (make sure the format is set to "Text" to preserve the initial zero)
• double check that all PBNs are correct (with initial zero)
• delete the rows with the other publishers
  

3.3 Upload

• Navigate to the phpMyAdmin table "Thoth_CDN"
  
• select Import tab;
• select file
• click "Go."
• archive files under Punctum Admin > Metrics > Thoth CDN

4. Additional Information

5. Document Control