OAPEN Update
1. Overview and Context
This procedure updates the OAPEN2 table in the SQL Database.
2. Triggers
The execution of this procedure is usually triggered by
3. Steps to Be Performed
3.1 Download
OAPEN-Dashboard provides a download for all countries in CSV format.
3.2 Clean
- When importing switch off space/semicolon as delimiter
- Delete all columns from H up to present month
- Delete the Funders column
- Reformat column G to YYYY-MM-01 format
- Delete header
3.3 Upload
- Upload into phpMyAdmin table "OAPEN2"
- select Import tab;
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 |