Data Collection for Impact Observatory[edit | edit source]

Strapi & MinIO Video Tutorial[edit | edit source]

Bellow a short video tutorial explaining how to use Strapi and MinIO tools for the data collection of indicators.

Data Collection Methodology[edit | edit source]

Two ways for collecting the data were implemented for the Impact Observatory. In the automatic path, users simply upload CSV files to our MinIO object-storage service; from there, a suite of Pentaho jobs automatically ingests, transforms, and loads the data into our Datalake, ensuring updated metrics with zero manual intervention. In the manual path, UINTA offices log into our Strapi CMS and complete pre‐built indicator forms (e.g., entering dates, numeric values, and descriptions). Once submitted, each entry is stored in our PostgreSQL database, tracked with metadata (timestamps, author, version), and immediately available for reporting. This dual approach guarantees both high volume automation and flexible, data entry, so all the indicators stay accurate and updated.

Strapi Manual Data Injection Steps[edit | edit source]

Enter to the Strapi CMS.
Click on the button "Open the administration".
Enter your credentials and click on Login.
Click on Content Manager.
Select the indicator entry form to fulfill.
Under the “COLLECTION TYPES” panel the respective forms will be displayed according to the user roles. We defined three user roles with different permissions:
- a) UNITAOffice
- b) TaskLeader
- c) ProjectManager
Once you select the form entry to fulfill. Click on “Create new entry”.
Enter the required data manually.
Click on Save, double check that the information is correct and then click on Publish.
Click on Back to see all the published entries.
See how the status of the entry changed. Click on Unpublish if you want to revert it.
Now you can see all the entries that have been saved and published.
In this section you can edit, duplicate or delete the entry.
Once the entry has been published, it is saved on our database with its metadata.

MinIO Automatic Data Injection Steps[edit | edit source]

Enter to the MinIO site.
Enter your credentials and click on Login.
Click on Object Browser on the left panel.
Select the folder “bucket” of the indicator you want to upload the file.
To upload a file click on Upload and select the file from your machine.
Once you select a file, you can Download, Share or Delete it.