Enphase consumption data has stopped graphing

Problems Fixed
#28

Just tested my API V4 interface, it returns perfect production data, but for consumption it returns nothing. Meta data suggest there is a meter issue… Also when downloading data from some time ago, the consumption data is empty, with a meter issue…This data was perfect before.
I noticed that Enphase servers where down for maintenance at the time the issue arose.
My guess a privilege access problem @Enphase, since the Enphase app shows correct data: the consumption data is uploaded, there is no meter issue…

1 Like
#29

Thanks for looking into it!

I run my own script to pull data from the Envoy locally and push it to ChargeHQ so I know the data is there and it appears in Enlighten as well. Had to be an API issue and given it started when they had planned maintenance it had to be a change on their end. Hopefully they respond to you quickly.

#30

The problem is in the API for API V4 users. It is an Enphase problem! Obviously the response is not based on knowledge of their own API existing and possible problems there. My guess, access privilege problem for API users after server maintenance…

#31

Enphase support have confirmed it is an issue on their end and are working on a solution.

5 Likes
#32

Thanks! You must have a hotline at API support. Not yet got an answer to my mail about this problem (and other mails). You deserve your hotline by all means.

#33

my consumption monitoring is back!

#34

Yes, back here as well.

I’ve manually updated PV Output for the data missing from the 20th until 25th from the Enlighten data but all data from midnight to now 4 am on the 26th is current.

@bankstownbloke thank you for the quick contact with Enpahse and getting this fixed up for us.

#35

@quozl Could you or someone else walk us through how to backfill the consumption data for the last several days? I’ve tried exporting the recent consumption data from Enphase to a CSV file and importing that data in daily blocks to https://pvoutput.org/loadlive.jsp, but that wants 5-minutes intervals while the Enphase data is in 15-minute intervals.
What should we do? Thanks!

#36

Thanks to everyone who assisted - consumption data now working here as well - I’m also keen to hear best practices for backdating/filling in the consumption data gap.

#37

Thanks very much for following up and forcing Enphase to double check their systems. Looks like a complacent attitude from Enphase, considering at least one member contacted them to bring the problem to their attention, yet they thought they knew better. Show professionalism Enphase and listen to your customers.

#38

Thanks BB all is up and running now.

@solardave I completely agree with you though I doubt Enphase have social media monitors and probably not here. I think part of the issue too is that only one of us appears to have contacted them rather than a number of us. I know I didn’t. So next time this happens we should all log a ticket with Enphase.

#39

@tycho0 To update the data in PVOutput for the missing days I went to the Daily section in PVOutput and clicked on Edit for the day I wanted to update, then entered the data from Enphase Enlighten Energy section for the corresponding day and filled in the fields that matched in PVOutput.

For example I added to PVOutput on the 21st the following data in Watt Hours

Energy Exported = Exported data from Enpahse Enlighten Energy Section for that day
Energy Used = Consumed data from Enpahse Enlighten Energy Section for that day
Import Peak = Imported data from Enpahse Enlighten Energy Section for that day

Then in the PVoutput edit page for that day I clicked on Recalculate under the Import Peak section and clicked Save.

If you have different rates for different times of the day you’ll have to enter the data in the corresponding fields for those times. I have a flat rate so don’t have to do that and just put the import data in Import Peak
FYI make sure you enter the data in Watt Hours not kWh e.g. 4125 for 4.125kWh

Hope this helps, I’m no expert so if I’ve stuffed anything up I’m sure someone will let me know in this thread.

Cheers QuozL

#40

@quozl Thanks for the update! So it looks like you’re updating the totals for the day, which is going to be my fallback.

I’d like to find out if there’s a way to fill in with Enphase’s 15 minute interval data, so that the days have 5 minute interval data like they would originally have had, not just the total for the day.

I feel like https://pvoutput.org/loadlive.jsp is the right tool, I just don’t know how to translate the 15 minute interval data into 5 minute intervals. Just fill in 0 W for the X:05, X:10, X:20, X:25, X:35, X:40, X:50, X:55 times?

#41

For amusement now; my ticket at Enphase is still being updated and telling me that there was never an issue; and that “The data from the Enphase Consumption meters would only be visible on the Enphase Enlighten App/Website portal.” despite having mentioned consumption API multiple times in all my responses. They even typed a lesson up for me on how to read the enlighten app (Which was never broken) - I suspect if anyone else has logged a general support ticket with enphase they would have been given a similiar runaround.

Nigel

#42

Anyone have any suggestions on how to backfill the live Enphase consumption data? Thx!

#43

To convert 15 minute intervals to 5 minutes

  • For energy (Wh), divided the 15 minute energy by 3 for each 5 minute interval. i.e. 1:15 - 150Wh, then 1:05, 1:10 and 1:15 should be 50Wh
  • For power (W), all three 5 minute values should be the same as the 15 minute. i.e. 1:15 - 100W, then 1:05 and 1:10 is also 100W.

Power shouldn’t be required as Enphase only gives energy, PVOuput will calculate power from energy.

#44

My setup : KB-Oost has missing consumption for some dates. KB-Oost is aggregated with KB-West (only production) in KB-Oost-West.
My idea: Upload missing energy consumption data to KB-Oost with the live-upload functionality.
My hope: The aggregate KB-Oost-West will be updated (by miracle…)
Are my idea and hope correct and justified? Or is something else needed.

#45

Thanks for getting back to me! So when I exported the consumption data from Enphase Enlighten as a CSV, it was giving me power (W) not energy (Wh).

So I did what you said. I generated a file with 288 lines, from 00:00 to 23:55, in 5 minute increments. Then I took Enphase’s CSV file with 96 lines, stripped out the date and time, and used sed -n '{p;p;p;}' [file] to take each line and triplicate it, giving me a file with 288 lines of power.

Then I used BBEdit to paste the power after its corresponding time, separated by a comma, giving me a CSV file with times and power. Then I pasted it into https://pvoutput.org/loadlive.jsp for 10/20 and voila, a fixed date! Then rinse and repeat all that for 10/21-10/24.

Took me about 2 hours to do all this, but everything looks correct! Hopefully we won’t have to do this again anytime soon… :blush: Thanks!

2 Likes
#46

ditto, fixed, used excel vlookup to chop the 15mins table from enphase into 5 min segments (by creating a 5 minute table and using vlookup against the 15min table)

couple of formulas to note

  1. =Cell+5/1440 (will add 5 minutes to the time in “Cell”)
  2. =Cell+15/1440 (will add 15 minutes to the time in “Cell”)
  3. = vlookup (5mincell,tableof15mindata,columnx) will find the best 15 minute value in columnx to fill in the 5 min value (basically the same as copying down by sed in the previous comment)

the copy the table into https://pvoutput.org/loadlive.jsp with tab as the seperator

1 Like
#47

The magic of PVoutput is there. The consumption data I created with API V4 for a subsystem, results in a correct aggregation after upload. The Enphase server problem is now corrected for me. Many thanks for this beautiful, versatile system.

1 Like