CrossRef Event Update

1. Overview and Context

This procedure updates the Crossref_Event 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

CrossRef event data are plucked directly from their Query API. There are two DOI prefixes punctum uses, so we need records for both. Just fill in the correct start and end dates:

https://api.eventdata.crossref.org/v1/events?mailto=vincent@punctumbooks.com&obj-id.prefix=10.53288&from-occurred-date=2023-07-01&until-occurred-date=2023-07-31

https://api.eventdata.crossref.org/v1/events?mailto=vincent@punctumbooks.com&obj-id.prefix=10.21983&from-occurred-date=2023-07-01&until-occurred-date=2023-07-31

You can use Postman as a useful API GUI.

3.2 Clean

• You get a JSON file that needs to be converted to CSV.
• Clean up the occurred_at column by replacing "T" and "Z" with a space, and set data format to timestamp.
• Make sure all columns line up, and all columns have at least one cell filled (even with a dummy)
  
• Delete header row

3.3 Upload

• Navigate to phpMyAdmin table "Crossref_Event"
  
• select Import tab;
• select file
• click "Go."
• archive files under Punctum Admin > Metrics > Crossref Event Data

4. Additional Information

5. Document Control