CSV Export Options

Emporia Energy Community Product Ideas CSV Export Options

Viewing 0 reply threads
  • Author
    Posts
    • #7868 Report Abuse
      kpnobvious
      Member

      I’ve seen this come up a few times in the API discussion and thought it deserved it’s own topic.  I’m not sure how well the forum search works if this is a dupe.

      Q.  I want to download my total data to compare to my electric bill

      A. Several was to do this, explained below:

      1. Keep using the export button from the app and pick the date range.  If you want a larger screen to use the app, you can install an Android emulator, like BlueStacks.  Sign into Google Play and install the Emporia App.  Sign into the Emporia App.  When you run an export and look at the data, if you sum the two mains (i.e columns B\C in the downloaded report) for the range of your billing period should total your utility bill in kWh

      2. Leverage the compiled Helgew java app to either import into an influxdb or print out usage, i.e daily usage for last 3 weeks.  This only requires Java.  Helgew is on this forum as well https://github.com/helgew/emporia-downloader

      3. Leverage the PyEmVue project on github.  https://github.com/magico13/PyEmVue  This requires python installed.  He also has a code sample to pull the last 7 days (total by day) on his page that you can expand as needed.  I can share some python code to get the start\end of the month and use that for dates, i have it set to run monthly to create a CSV file if there is interest.

      From one of Marty’s posts about 15 months ago, retention limits on what you can pull are as follows:

      1 second data is retained for 3 hours.
      1 min data is retained for 7 days.
      1 hour / 1 day / 1 week / 1 month / 1 year data has unlimited retention.

Viewing 0 reply threads
  • You must be logged in to reply to this topic.