File Upload Integrations

File Upload Integrations

The Odyssey platform offers multiple ways to integrate mini-grid and solar home system electricity payment data depending on the data source.  Integrating this data makes it available for the following purposes:

  1.  Enabling the remote verification of connections required by some results-based financing programs.
    1.  To learn more about submitting connections and using remote verification, please refer to the Odyssey user guide.
  2. Enable analytics and visualizations of the data via Odyssey’s Analytics platform; providing insights into the operations across your mini-grid sites or solar home system installations; and joined with other data on the Odyssey platform.
  3. Sharing operating data with other users of the Odyssey platform, such as investors or financing program administrators.
    1. When you share, what you share, and who you share with, is entirely up to you and controllable via the Odyssey Project Sharing User Interface. 

File Upload Integration 

Integration Set-Up
  1. Notify Odyssey Support team of your intention to set up this Integration. You need to be participating in a financing program live on Odyssey
  2.  You will then be provided with the required files to fill out
  3. Upload the file on the Odyssey Platform. To do this;

      • Navigate to Operate > Data Integrations

      • On the File Data Integrations tab

      • Click on Upload button

      • Select whether the file will be applied to a single project or multiple projects Enter the following details:

      1. Dataset Name: The name of your project “01_2024_Site Name”

      2. Project: Select the project (s) the data applies to

      3. Dataset Type: Select your data set type from the drop down options

      4. Data Provider: Select 'User'

      5. File: Choose the file you would like to upload

      6. Verify your connections


Note that the Integration will not run daily and you will be required to upload a new file when the data is available

File formarting

Once you receive the file template, follow these guidelines to ensure your data us uploaded and ingested correctly

  1. The file must be a .csv file and the name of file must be ELECTRICITY_PAYMENT.csv

  2. The headers must match exactly the sample file attached. Do not add any spaces before or after the header names

  3. Required fields will be described within the user guide of the financing program you are applying for. For example ID (Payments ID) , PAYMENT_AMOUNT (Payments Amount), METER_ID (Payments Account ID), TIMESTAMP(Payments Effective Utc Time)

  4. Other fields: You can use the "Source" column to capture payment type, You can use the "external_id" column to capture serial number

  5. The timestamp must be in UTC format: '2020-12-10T17:10:28'

  6. Only CRM provider can have access to google sheet

Electricity Payments File Definition

Field Name
Description
Notes
TIMESTAMP
Datetime for the reading

Required
Format: YYYY-MM-DD HH24:MI:SS+00:00
Assumes UTC, use the timezone specification to adjust.
ID
Unique ID for the payment
Required
METER_ID
Unique ID for the meter
Required – For remote verification, this must match the external_id value entered in the connections section of the project. Learn more about verification here: https://help.odysseyenergysolutions.com/portal/en/kb/articles/submit-remote-verifie#Complete_Remote_Verification
UTILITY_ID
Unique serial number of the Inverter system
CUSTOMER_ID
Unique for the customer
Required
CUSTOMER NAME
Name of payer
Required
TRANSACTION CHARGES
 
PAYMENT_SOURCE
 
 
REFERENCE_ID
Payment reference ID
PAYMENT_AMOUNT
 
Required
ACCOUNT_TYPE
 
 
STATUS
 
 
NOTES


LOCATION




    • Related Articles

    • 8760 File Upload

      The 8760 upload allows you to upload a load value (kW) for every hour of the year. You can upload an Excel document detailing load profiles for multiple customer types within a given project. The 8760 values can be determined from a generator readout ...

    • 8760 File Upload

      The 8760 upload allows you to upload a load value (kW) for every hour of the year. You can upload an Excel document detailing load profiles for multiple customer types within a given project. The 8760 values can be determined from a generator readout ...

    • 8760 File Upload

      The 8760 upload allows you to upload a load value (kW) for every hour of the year. You can upload an Excel document detailing load profiles for multiple customer types within a given project. The 8760 values can be determined from a generator readout ...

    • 8760 File Upload

      The 8760 upload allows you to upload a load value (kW) for every hour of the year. You can upload an Excel document detailing load profiles for multiple customer types within a given project. The 8760 values can be determined from a generator readout ...

    • File Management

      You can manage your files throughout the Odyssey platform in the File Manager section. Any files you upload throughout the Odyssey platform (projects, portfolios, programs) will also be accessible in this section for management. Multi-file actions ...