Octopus Energy - My energy insights missing zeros on CSV files

Qyburn

UncleK said:

Well Lordy Lordy. The CSV file on 30th August is back to the way it was, complete with zero values!

Mine is fixed back 1st August if not earlier. Was it 20th July it started?

Seems to have broken Octoprice data checker which now says ..

"Cannot set properties of undefined (setting '1')

Sorry, something went wrong!

Try again"

UncleK

For me, it was 20th August to 29th August when the zeros were missing on import (i.e. consumption) only. And now it's fixed itself. No clue why it started or why it stopped.

Qyburn

Yes I was misremembering, 20th to 29th August. I had an email from Octopus asking if it was fixed, but a new download yesterday still has zeroes missing. Import only.

double_dutchy

I regularly download usage data for both gas and electric from the Octopus website and plug it in to my spreadsheet.

Last time I did that was about 10 days ago. When I do it now I see the format has changed.

Main changes are that the electric now has an extra "estimated cost" column (but the gas doesn't) while the gas consumption data, rather than being in cubic meters as before now seem to be in Kwh

UncleK

This is getting weirder! I'm back to where I was, whereas Qyburn is still getting CSV files without zeros and double_duchy is getting another column. How come we are getting different treatment? Odd.

mmmmikey

UncleK said:

This is getting weirder! I'm back to where I was, whereas Qyburn is still getting CSV files without zeros and double_duchy is getting another column. How come we are getting different treatment? Odd.

Maybe depends on exactly how you are accessing the data? e.g. are you downloading an Octopus spreadsheet using the link in the web browser, accessing the API directly or using a third party system to get to the data. And if you are using the API which one are you using - there are 2 (that I know of).

I suspect the underlying data is there much the same as it always has been and the issue is the way it's presented when it's accessed.

UncleK

I use https://octopus.energy/dashboard/new/accounts/(my account number)/consumption/home and then bottom right where it says "Get your geek on" I use the pink button that says "Download your smart data" and that downloads a CSV file which consists of three columns -  

Consumption (kWh)

Start

End

And it says consumption even if it's export.
I have always been using that method - and the CSV file definitely changed for those ten days to exclude zeros. I respectfully suggest it wasn't me!

Qyburn

UncleK said:

I use https://octopus.energy/dashboard/new/accounts/(my account number)/consumption/home and then bottom right where it says "Get your geek on" I use the pink button that says "Download your smart data" and that downloads a CSV file which consists of three columns -  

Consumption (kWh)

Start

End

That's how I've been downloading. It's changed in the last couple of days.  Downloaded on 4th September, a snippet showing missing data on 25th between 10:00 and 12:00. (I'd renamed the CSV)

Qyburn

Downloaded today, extra columns, zeroes shown, and file downloads as "download.csv". 

double_dutchy

Qyburn said:

It's changed in the last couple of days.  

Yes, the default has changed, but now I notice at the bottom of the page there is an option to "Take me back to the old consumption page". If I do that I can download the files in the old format.

How long access to the "old consumption page" will last I don't know so I'm probably going to alter my setup to cater for the newly formatted files