Easiest way to get data as a file compatible with excel

Hello everybody,

i´m looking for an easy way (i absolutly have no programming experience, as well as linux :-() to get data from the Flukso. isn´t there any windows ready program to read the data?

I´m in the same Network and have fully access to the fluxso.

I just want da an data output to work with in excel.

Please help me :-) (be sure, i read the forum for hours without success)

Thank you in advance!

simon/Germany

simonse's picture

Thanks for the answer.

i think my problem starts much earlier... is there anywhere an FAQ or something like that?

e.g. how do i Implement a code to the fm?
what do i exactly need? ->SERVER; MYSQL...
why is it not possible to download data from the Dash? or direktly from the fm?

sorry but my time runs away....

damn :-)

thx in advance

simon

FabRim's picture

I agree w/ Simonse, for non programers, the abilty to easily export csv files is and absolute must.

Halsey's picture

Agree - would take some of you guys 10 seconds to set up an export to CSV function on the flukso website, rather than having poor noobs resort to hacking together API calls scripts etc

Halsey's picture

Ah cool, so with TMPO encoding you could download the whole flukso DB as a single (small) file. Well theoretically you could do that now (another post on here by Bart says flukso stores 12 months of data at various resolutions depending on the age of the data) using multiple API calls with different request ranges. But yeah getting the whole thing as a single text file in a browser would be awesome.

icarus75's picture

Actually, all you need for obtaining a csv file with Flukso readings is to have curl installed and a decent shell:

  1. icarus75@cirrus:~ $ curl -k -o file.csv -X GET -H "Accept: text/csv" -H "X-Version: 1.0" -H "X-Token: b371402dc767cc83e41bc294b63f9586" "https://api.flukso.net/sensor/fed676021dacaaf6a12a8dda7685be34?interval=hour&unit=watt"

This command will redirect the output of the curl command (which fetches the power readings in watt of the last hour in minute resolution for sensor fed676021dacaaf6a12a8dda7685be34 with token b371402dc767cc83e41bc294b63f9586 in csv format) to the file 'file.csv'.

Tmpo is currently undergoing beta testing. Have a look at the Python bindings for tmpo to see what's possible with the new storage format. In short: once tmpo has been enabled on your FLM, all readings will be kept at the highest resolution (no subsampling) and will be available for download through a dedicated tmpo REST API. Tmpo-py takes care of all this under the hood and stores the tmpo blocks in a SQLite DB on your computer.

Fluc's picture

Good work Bart, thanks :-)

KennyBuntinx's picture

Hi - With the new 2019 digital meter and "prosumenten" tarif , I am trying to figure out a way to see how I can benefit with a battery system. To do that , I have my data from my inverters producing electricity and I am now trying to find an easy way ( non developer ) to get my fluksodata on consumption.

How to extract on an easy way the consumption per fase on a daily base (kW) / per month /per year ?

Any help is appreciated

Kenny