Asterism Books Update

1. Overview and Context

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

UsageAsterism provides monthly order data arevia directlytheir extractedbackend usingas CSV.

In the Internetleft Archivemenu, usagego datato API.Home WeSelect havethe writtenpertinent adate scriptrange thatClick extracts"Export theseOrder dataData" automatically and generates a CSV file, organized by Thoth workId and country per timeframe (usually a month).

In order to generate the data, make sure all workIds of recently published books are added, and select the correct timeframe.

3.2 Clean

• ImportAppend as1 encodedcolumn asto UTF-8the left, add date in YYYY-MM-01 format
• Delete headerall rows up to the list of ISBNs
  

3.3 Upload

• Upload intoto phpMyAdmin table "InternetArchive"Asterism"
  

4. Additional Information

5. Document Control

Document ID	PRO-041
Document Owner	Vincent
Version	1.0
Last Date of Change	March 26, 2026
Next Review Due Date
Version & Change Tracking