Please confirm @Jequinlan - does this solution only work on PCs running Windoze?

PS:

In order to save the output in the same folder as the exe I had to specify .\output.csv as the file name

Ought to be in the readme (as a programmer I guessed that might be the case)

If I add my username and password into the settings json file I get

OvoData.exe -f 01/01/2020 -t 04/02/2020 -o .\OvoData.csv
Unable to login - 401 - Unauthorized
   at OvoData.OvoLiveRepository.OvoConnect.GetLoginCookieAsync(String userName, String password)
   at OvoData.OvoOrchestrator.ExportData()
   at OvoData.Program.EntryPoint.Run()

Hmm, i would think so I am afraid  but i will see if i can make a docker version for mac or linux users.

Oh! Erm, please just use commandline then  no idea why that didnt work! (You kept the "" right?)

@Tim_OVO Given that some of Ovo’s customers have been asking for this and more for many years, I think @Jequinlan deserves a big round of applause for sharing his code. I agree that without the backing of Ovo, it should be used with a degree of caution. It could just stop working one day, when Ovo next change their api? interface, as happened in the Hive community recently. 

Yes, if the api changes it could stop, but also the apis are soft coded in the config file so if a trivial change the config will just need updating. The risk of any 3rd party integration exists if any 1st party changes an apinin any situation.

If ovo want to see the code , then i am happy to discuss.

@Jequinlanwrote:

i will see if i can make a docker version for mac or linux users.

Linux would be great :)

Raspberry-Pi or Arduino would be better still because we can then make our own IHDs  

Is the program open or closed source?

Yep, I kept the quotes to make sure it’s still valid json string.

Warning: This only protects the user if the API end-point changes, not when the format of data it fetches changes.

Hi All,

I have just written a PowerShell script to fetch all of my readings from January 2017 to present-day a month at a time.

You can find it on GitHub at

https://github.com/MikeWilliams-UK/Bulk-Fetch-Ovo-Readings

Have fun

Examining the downloaded csv file

1. The following columns are always empty
   MeterPointIdentifier, CostCurrencyUnit
2. YearColumn is always same as MonthOfYear column
3. CostAmmount is always zero
4. IntervalStart and IntervalEnd columns do not require fractions of a second
   2018-12-01T04:30:00.0000000 → 2018-12-01T04:30:00 please.

Not sure if these are your columns, but the output could do with tidying up.

As a programmer I can help with this.

At the moment I am discussing if I should open source it or if OVO themselves may be interested to make it or a basis of it integrated as a supported offering.

Would be good if it were made open source, then the community could help to fix any issues.

There’s another issue to consider if OVO were to take this on. I believe that their new Billing System is being developed such that it can be licensed to 3rd parties. Such an arrangement means that they would need to secure some rights over any externally-sourced code within the suite and be able to provide rapid support if an element of that code were to fail or require upgrading.

That’s a legal minefield.

And let’s remember that it was the failure of a 3rd party software provider to resolve issues with parts of their billing system which caused OVO to embark on creating their own in the first place. It didn’t help that Ofgem clobbered them with a hefty fine for the failed usage-estimation provisions in that software.

You will understand that there would be a significant level of reluctance for OVO to become embroiled in such a scenario again.

Sorry for another spamming comment but I’m keen to hear if others have checked out this work done by @Jequinlan this week? 

@Gary @GarethMarlow @rgphilpott @atilagiant @Deanohol @Peter_Mat @didge05 @sam_cat @jmontalvo @adec @Pramsbottom @ryck @CeeJayCee @alexbaulch @Random @maccordingley @sfgreenwood @johnk @jadam @Fordy @Steveo67 @Siggy0 @CerebralDigits @deanjames @ChrisB @jadam @DaveJenYearsley @ErTnEc @Marshcroft @jordanharper @Simonfea @obiwanzamora @AdamJ @dorinho @Ross2411 @Chrherms  @blakedrayson @TerryE @VibroAxe @jdenver @maurorappa @adec @100903609 @Riscy @r3m0dul8 @MyZoe.Uk @Ajk @AlanN51 @CloudCircus @r3m0dul8 @technogeoff @resoai @Fuzzysteve @mattc @andsee @uvarvu  @g-de 

On a side note, a v2 with fixed year field coming next week.

In the same boat without an account now,

So not unless it’s open-sourced, especially when they managed to make it almost 100mb in size. I’d say no to running that
 

Gave up when I saw the file extension, was hoping for something written that I could run on my Pi.   I tried to decompile it using Visual Studio but didn’t get far.

Looks like C++ I’m guessing it’s using a large library for the http requests and that’s taking up the size, but haven’t had too deep a look myself

Tim, I haven’t had any WinX devices for over 10 years so Poweshell is useless to me.  My Python script continues to work fine for me. Thanks.

After looking at the data I can see that my half hourly readings for gas have stopped from August 20th 2020.

I am sure that it’s NOT a fault of the utility as I see the same in the web portal.

There’s another very active discussion about missing data on Online Graphs which you should have a look at, @MikeWilliams .