Google Books Update

1. Overview and Context

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

Google Books usage data are available via the OAPEN-DashboardGoogle Play Books Partner Center.

provides

aGo downloadto formenu allitem countriesReports in> CSVCustom format.Reports. Select Report Type "Google Books Traffic Report," Organize by "Book," and select date range.

3.2 Clean

• WhenDelete importing switch off space/semicolon as delimiterheader
  
• DeleteAppend all1 columns from H upcolumn to present month

Delete the Fundersleft, columnadd Reformatdate column G toin YYYY-MM-01 format
Deletesave headeras XLS re-export as CSV

3.3 Upload

• Upload into phpMyAdmin table "OAPEN2"GoogleBooks"
  

4. Additional Information

5. Document Control

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