Data Export/Import on MPM

[beesaferoot]

Overview

MPM needs a unified way to move data in and out of MPM into other platforms and also different versions of MPM.

The challenge posed here is how to represent a data import/export layer as a flexible API that can satisfy the following requirements;

• Ease of moving data from and into other CRM platforms ie. Upya, Angasa etc. Flexibility is a key component to make this smoother than it would normally be otherwise
• Ease of moving data from into two separate instances of MPM
• Unified data view from an API perspective.

Public Data Model (external data transfer i.e Upya, Angaza)

• Clusters i.e Site, Mini-grid, Village.
• Devices ie. Meters, Solar Home Systems, Ebikes.
• Customers i.e Address, customer type, customer group.
• Transactions i.e Provider
• Appliance i.e Appliance type, Appliance SKUs, Payment Plan (Rates) (units)

MPM instance Data Model

• Users i.e Permisions, Admin.
• MPM settings
• All Public Data Models

Data format

JSON (used strictly for MPM to MPM migration)
CSV
excel