0

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.
Please be positive and constructive with your questions and comments.

Import from Excel / .csv ??

by iainw on Sat Oct 17, 2015 3:48 pm

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

iainw
 
Posts: 3
Joined: Fri Feb 01, 2013 6:32 pm

Re: Import from Excel / .csv ??

by jwcooper on Tue Nov 03, 2015 11:56 pm

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

jwcooper
 
Posts: 788
Joined: Tue May 01, 2012 9:08 pm

Re: Import from Excel / .csv ??

by iainw on Fri Nov 06, 2015 6:31 pm

Thanks, i will take a look

iainw
 
Posts: 3
Joined: Fri Feb 01, 2013 6:32 pm

Re: Import from Excel / .csv ??

by daddyoh on Sat Nov 07, 2015 7:32 am

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.

daddyoh
 
Posts: 8
Joined: Wed Oct 03, 2012 3:53 am

Please be positive and constructive with your questions and comments.