Data Storage Location

Hi again,
Newbie here :grin:

Just wondering where the data is stored, what is the file format (tx, csv, tab, ???), can the data be downloaded to a personal computer?

Tx again
Ray

Data is stored on the SDcard at:

/iotawatt/iotalog.log (5 second samples)
/iotawatt/histlog.log (1 minute samples)

It is not any standard file format. Moreover, most of the data is in little-endian format where a PC is big-endian.

Sure. Use the query API.

Hi Ray,
If you’re looking for a way to permanently save data, without much ongoing intervention, also consider configuring a Data Uploader. IotaWatt can talk to InfluxDB version1 or version2, and others. From time to time you’ll need to check Status of your Uploader(s), or configure an alert in InfluxDB etc. if there’s been a lack of activity for any reason.
Note 1: an upload history date can be “back dated” so you can start the upload with older data that’s on your SD card, but from then it only goes forward in time.
Note 2: plan to tweak your CT configs and measurements early, and try to arrive at a stable or extensible config (names, tags etc) even before your uploading gets going, to avoid inconsistencies in the target database.
Note 3: if data layout or “schema” changes significantly, you can delete the uploader, make a new target database, and build the uploader again. Never delete your old DB, just in case your SD card goes loopy.

FYI at this moment my Current Log goes back 1 year, 1.5GB
and the History Log goes back 1.5 years 193 MB

Once I got this going, and InfluxDB was sending data to Grafana (dashboard/visualization), I got a lot of great insights. Good luck!

Thanks so much Andy… Really appreciate the help and wisdom…

Do you know if there is a cost for either version of Influx?

Tx again
Ray

You can pay InfluxData to host InfluxDB for you, at their inscrutable pricing found here. Or you can host the community/open source version on your own hardware. Downloads here.

Version 1.x is probably better for new deployments as InfluxData has been promising a 3.x release “very soon” for maybe a year at this point. 3.x goes back to SQL based query language, so any time spent learning FluxQL used in 2.x is wasted.

1 Like

Thanks very much for the assistance, very much appreciated :+1:

Perhaps this is TMI but to confirm, I use the query API to pull data and insert into a SQL Server. Have a batch job that does this every 5 mins. query API works smoothly! I’m a big fan :slight_smile:

1 Like