The ESG data in excel file can be integrated into Envizi using this Integration Hub.
Here is the architecture of the Hub.
Here is the list of available Excel Mappings and it can be opened and executed.
The new, open, clone and delete operations are available from here.
Here is detailed info about a Excel Mapping.
The Excel Mapping edit contains the following sections.
- Meta Info : Name, description and type of the template.
- Data Ingestion to Envizi : To upload your source esg data file to do mapping and ingest into Envizi.
- Data Generated : Before you ingest the data into Envizi (by tranforming the upload excel into Envizi format based on the given mapping) you can view the geneated data here.
- Validation Errors : If any validation error found during the convertion process then they are highlighted here.
- Data Mapping : Actual Data mapping between the uploaded excel and Envizi Data format can be done here.
TODO: But you can refer the mapping here for now.
The S3 configuration related to this is available here.