The Guide shows how to DISPLAY multiple feeds as a csv listing which can be scrolled thru’.
How do you export this?
Is copy & paste the only option?
Thx
pb66
29 July 2018 10:19
2
Currently, I believe so.
I do, however, think a “download CSV file” button would be a great addition. Do you have a “copy to clipboard” button?
I raised an issue some time back suggesting a “copy to clipboard” button was added
opened 09:54AM - 22 Jun 18 UTC
closed 03:38PM - 15 Jul 18 UTC
enhancement
I think it would be a useful feature to have a "copy to clipboard" button (like … for the server information on the emoncms/admin page) for the CSV output, perhaps placed at the end of the line for show/hide and other CSV options.
I currently use crtl-a ctrl-c without an issue but a button would be a nice improvement.
I haven’t kept up to speed and whilst there are some commits and the issue closed, I do not know if/how this is implemented, I haven’t been updating, it’s not reached emoncms.org yet (just checked) and there has been no announcement. So I’m unsure if you have it or not (also depends on what versions you are running too).
I have opened an issue requesting a “download CSV” button feature and some additional related functionality too.
opened 10:16AM - 29 Jul 18 UTC
closed 04:35PM - 16 Apr 19 UTC
enhancement
Following on from #22 and ref forum thread https://community.openenergymonitor.o… rg/t/exporting-multiple-feeds-to-csv/8084?u=pb66
It would also be a great addition to be able to download the CSV output from the graphs page to a CSV file, I know it is possible to copy'n'paste (or use the new "copy to clipboard" button I assume?) and create your own local csv file, but it would be nicer to have emoncms do it for you.
What would also be of great use would be to make that download a user accessible api eg
>https://emoncms.org/graph/download.csv?id=12345&apikey=1234abcd
or by graph name
>https://emoncms.org/graph/download.csv?name=mygraph&apikey=1234abcd
that way an automated download of a certain set of data feeds and dates can be set up by simply creating and saving a graph.
(It may need an optional "userid" in the request to allow public downloads without an apikey.)
The emoncms/graph/readme.md's [changelog](https://github.com/emoncms/graph#change-log) does actually say V1 will
>Export data as CSV, select time format and whether to show, remove or use the last value when data is missing.
but I suspect that may mean in-directly using copy'n'paste as I can't recall seeing download button.
The "cherry" in this feature request would be an optional "download" button displayed with the embedded graph control buttons so that users can download what they see as a csv file direct from emoncms dashboards. (showing or not showing the download button should be a graph setting like the show tags or show legend etc)
[edit] Essentially the "download" api call in graph would provide a sort of pre-defined multiple feeds download to a (potentially) set timespan eg last month's solar and use, whilst also giving it a short name ie using the graph name rather than recalling all the feedids start time and end time etc etc to create a full feed request api.
Whilst I prefer CSV and that is partially already implemented, it might be worth considering a "download JSON" api too perhaps in time?
>https://emoncms.org/graph/download.json?id=12345&apikey=1234abcd
which replies with a list of feed name:values for each listed timestamp.