Sending Data from Prop to Google Spreadsheets on an android powered phone.
francis_L_H
Posts: 10
Hello all,
I have been working on a project for some time now. For the sake of simplicity, there is two main sides to this project.
1) Data acquisition from a sensor to the propeller (serial data)
2) Taking the data from step 1 and inserting it to the "cloud" via a smartphone.
I have managed to conquer step 1 already, so I really need help with step 2. I have had several ideas, but what I would really like to do is use blue tooth to send the data from the propeller to the phone and have it inserted into Google Docs, in particular a spreadsheet. (I have read a post on another site that someone did a similar task with an Arduino, but for some reason they had to use Google forms to transfer the data, and it was done with a PC via ethernet, not a phone.) It does not necessarily have to be a google spreadsheet, but something similar where I can set up my own template to log the data and do calculations.
I am wondering if anyone has any experience with something similar or if you think it is possible.
I realize this is a very brief description to what I want to accomplish, so if you would like more details to understand just let me know.
Thanks,
FH
I have been working on a project for some time now. For the sake of simplicity, there is two main sides to this project.
1) Data acquisition from a sensor to the propeller (serial data)
2) Taking the data from step 1 and inserting it to the "cloud" via a smartphone.
I have managed to conquer step 1 already, so I really need help with step 2. I have had several ideas, but what I would really like to do is use blue tooth to send the data from the propeller to the phone and have it inserted into Google Docs, in particular a spreadsheet. (I have read a post on another site that someone did a similar task with an Arduino, but for some reason they had to use Google forms to transfer the data, and it was done with a PC via ethernet, not a phone.) It does not necessarily have to be a google spreadsheet, but something similar where I can set up my own template to log the data and do calculations.
I am wondering if anyone has any experience with something similar or if you think it is possible.
I realize this is a very brief description to what I want to accomplish, so if you would like more details to understand just let me know.
Thanks,
FH
Comments
I'm just getting started with android programming. The device I am using for development (Archos 28) does not have bluetooth, but I have used WiFi to communicate with the spinneret module http://forums.parallax.com/showthread.php?133584 .
Someday (soon) I want to get a device with Bluetooth, but what I'm really waiting for (with bated breath) is the new Parallax WiFi module.
If you have (or are willing to use) the spinneret, I could probably write a program to receive data from the Spinneret to an android device and log it in a text file. I have no idea how you would get the data inserted into a spreadsheet though. Let me know if you are interested in this. I'm sure others would benefit from it as well.
Bean
Bean,
I may consider that. I guess it does not need to be blue tooth necessarily, but some means to transfer the data wirelessly. I need to do a little research on the spinneret as I am not familiar with it. This will be used in a location that has 3G access, but that is the only means of accessing the internet. I am not for sure if a txt file would suffice, but I would imagine we could format it in such a way that it could be imported easily into a spreadsheet that would work for the end user. I know from a PC you can simply import into a google spreadsheet, but I don't know if that capability exists on an Android phone.
Cluso,
Thanks for the info regarding Microchips product. That looks very handy, especially when trying to debug products in the field. It also may give me a whole other perspective on what I am trying to accomplish.
I'll bet there is a long avenue we can pursue here...
OBC