CSV download app

Bob's Blog
1

I’ve started to work on a new component of the local application to download CSV files. I’ve got a prototype working. It looks as if I can download large files without knowing the ultimate length using HTML chunking, so I’m optimistic that this can be a useful tool to do do long term data analysis with spreadsheets.

Consider this a comment period if you have a particular need for something like that. This won’t be anything too flashy, but should be able to download what you see in graphs over longer periods of time with resonable granularity. I hope to be able to produce files several Mb in size if all goes well.

3 Likes
2

No particular comments to add in terms of my needs but I will absolutely make use of this functionality.

3

This project has expanded in scope and is coming along nicely. I’ve started to formalize a basic query functionality that I’ll be able to publish as an API. Without getting into a lot of details, the new query will:

  1. Allow generation of both Json and CSV formatted data.
  2. Have optional headers to identify the data “columns”.
  3. Have various methods of expressing time (unix, string, UTC, local)
  4. Have the ability to request a time series in terms of:
    • absolute UTC time
    • standard date time string (2019-04-01T08:24:00)
    • relative date time (last hour, last 24 hours, this week to date, last week, yesterday, etc.)
  8. group by seconds minute, hour, day, week, month, year
  9. specify decimal positions for output

I’ve got this working in a fork. It’s downloading CSV files and also supplying the local graph program. There’s a lot left to do to clean it up and exploit the new functionality, but very promising.

1 Like
4

That was the one thing I thought of recently when pondering this so thank you for sharing.

1 Like
5

Sounds great !!! Just what I need now that I’m trying to do a 9 month analysis. Actually I searched the forum before adding a new topic and found this.

Any updates? I only need to download CSV files, even if in several parts, of all the defined outputs.

Thanks!

6

This has stalled a bit. The API in the IoTaWatt is done, but I’m got bogged down in JavaScript modifying the graph app. I got it working great in a Firefox browser, but there are issues, particularly with safari.

I still need to design and code an app to request the download. So it’s not coming anytime soon.

Sorry for the delay. You should be able to download from influx in the interim.emphasized text

1 Like
7

OK. Thanks for all the work. I guess I’ll use Influx.