Wirelessly Transferring CSV File From SD Card in Data Logging Shield

So I'm currently building a 20 channel temperature data logger for a project. The code is complete and the device is running how it should, logging the temperatures of the sensors every 5 minutes to a Comma Separated Value file with a new file being created every 24 hours.

Now the issue I'm facing is these data loggers will be mounted on a pole 20feet off the ground thus making it a chore to get up to them to copy the data files off the SD card. What I'm hoping to do is figure out a way to wirelessly access the files from the card. The dataloggers should be in proximity of available WiFi so I was looking into the CC3000 WiFi Shield but I have no idea how I would go about interfacing it.

An ideal solution from most ideal to least would either be to:

  • get the arduino each day to email the last data file created (~40KB)
  • find a way to wirelessly connect a PC to the arduino while standing below it to download the files off the SD card
  • send the sensor data over the internet as it's being logged in a way that would allow me to easily create a CSV/Excel file from the streamed data.

Looking forward to any ideas you have

so I was looking into the CC3000 WiFi Shield

it can connect to an access point but it cannot be an access point.

So, what existing network is your shield going to connect to?

aameghoo:
An ideal solution from most ideal to least would either be to:

  • get the arduino each day to email the last data file created (~40KB)
  • find a way to wirelessly connect a PC to the arduino while standing below it to download the files off the SD card
  • send the sensor data over the internet as it's being logged in a way that would allow me to easily create a CSV/Excel file from the streamed data.

Looking forward to any ideas you have

I don't think you can copy the files, but getting the data out of the files is simple enough. This is easily and very cheaply done with bluetooth, either to a laptop or a phone, in reponse to an "MMDD" command. You can download several days onto one bluetooth terminal log file.

You can also send the data to an internet of things outfit like xively and download the data file from there.

PaulS:
So, what existing network is your shield going to connect to?

My school WiFi that covers all of campus, the loggers will be located on campus. It's for a research project for my university so I should be able to get the mac address added to their system to allow it to connect without needing to go through their login page.

Nick_Pyner:
I don't think you can copy the files, but getting the data out of the files is simple enough. This is easily and very cheaply done with bluetooth, either to a laptop or a phone, in reponse to an "MMDD" command. You can download several days onto one bluetooth terminal log file.

You can also send the data to an internet of things outfit like xively and download the data file from there.

That would be awesome using the bluetooth, I'll have to look that up. Any suggestions for a starting point?

You might find the following background notes useful

http://homepages.ihug.com.au/~npyner/Arduino/GUIDE_2BT.pdf
http://homepages.ihug.com.au/~npyner/Arduino/BT_2_WAY.ino

an example therein is doing much the same as you propose.