Hi,
I'd like to import a bunch of data from another site I have been using for logging temperature readings from an ESP8266 board.
I can download the data into Excel.
Is there any existing way to upload bulk .csv data into .io ? or should i code my own?
Best wishes, Iain
Import from Excel / .csv ??
Moderators: adafruit_support_bill, adafruit
Forum rules
If you're posting code, please make sure your code does not include your Adafruit IO Active Key or WiFi network credentials.
If you're posting code, please make sure your code does not include your Adafruit IO Active Key or WiFi network credentials.
- jwcooper
- Posts: 1004
- Joined: Tue May 01, 2012 9:08 pm
Re: Import from Excel / .csv ??
Hi, as of now you'd need to create your own bulk uploader script. It should be fairly easy with any of the client libraries.
We do have an open issue to support bulk uploading of data, at least within a client library.
Our most advanced library right now is the node library, if you're looking for a place to start:
https://github.com/adafruit/adafruit-io-node
We do have an open issue to support bulk uploading of data, at least within a client library.
Our most advanced library right now is the node library, if you're looking for a place to start:
https://github.com/adafruit/adafruit-io-node
-
- Posts: 3
- Joined: Fri Feb 01, 2013 6:32 pm
Re: Import from Excel / .csv ??
Thanks, i will take a look
- daddyoh
- Posts: 8
- Joined: Wed Oct 03, 2012 3:53 am
Re: Import from Excel / .csv ??
If you know Java or Python there are great libraries to read excel spreadsheets directly. I would probably start with python because it is very easy. Or even export to csv and use python to iterate over the data and use the IO api to insert into the IO system.
Forum rules
If you're posting code, please make sure your code does not include your Adafruit IO Active Key or WiFi network credentials.
If you're posting code, please make sure your code does not include your Adafruit IO Active Key or WiFi network credentials.