arduino data logger

http://www.open-electronics.org/how-send-data-from-arduino-to-google-docs-spreadsheet/

your welcome

you can store sensor readings in text file, and seperate them with commar. then change file extension to csv, and most spreadsheet apps will recognize it.

thanks peter sir but in that project how to identify the form key...i

am using atmega2560 and ethernet sheild..i cant save the txt file i tried with the cardinfo pgm but the car info hasnot retrived..

/*

  SD card test

This example shows how use the utility libraries on which the'

SD library is based in order to get info about your SD card.

Very useful for testing a card when you're not sure whether its working or not.

The circuit:

  * SD card attached to SPI bus as follows:

** MOSI - pin 11 on Arduino Uno/Duemilanove/Diecimila

** MISO - pin 12 on Arduino Uno/Duemilanove/Diecimila

** CLK - pin 13 on Arduino Uno/Duemilanove/Diecimila

** CS - depends on your SD card shield or module.

  Pin 4 used here for consistency with other Arduino examples

created  28 Mar 2011

by Limor Fried

modified 9 Apr 2012

by Tom Igoe

*/

// include the SD library:

#include <SPI.h>

#include <SD.h>

// set up variables using the SD utility library functions:

Sd2Card card;

SdVolume volume;

SdFile root;

// change this to match your SD shield or module;

// Arduino Ethernet shield: pin 4

// Adafruit SD shields and modules: pin 10

// Sparkfun SD shield: pin 8

const int chipSelect = 4;

void setup()

{

  // Open serial communications and wait for port to open:

  Serial.begin(9600);

  while (!Serial) {

    ; // wait for serial port to connect. Needed for Leonardo only

  }

  Serial.print("\nInitializing SD card...");

  // On the Ethernet Shield, CS is pin 4. It's set as an output by default.

  // Note that even if it's not used as the CS pin, the hardware SS pin

  // (10 on most Arduino boards, 53 on the Mega) must be left as an output

  // or the SD library functions will not work

  pinMode(chipSelect, OUTPUT);

  pinMode(10,OUTPUT);

  pinMode(53, OUTPUT);     // change this to 53 on a mega

  // we'll use the initialization code from the utility libraries

  // since we're just testing if the card is working!

  if (!card.init(SPI_HALF_SPEED, chipSelect)) {

    Serial.println("initialization failed. Things to check:");

    Serial.println("* is a card is inserted?");

    Serial.println("* Is your wiring correct?");

    Serial.println("* did you change the chipSelect pin to match your shield or module?");

    return;

  } else {

    Serial.println("Wiring is correct and a card is present.");

  }

  // print the type of card

  Serial.print("\nCard type: ");

  switch (card.type()) {

    case SD_CARD_TYPE_SD1:

      Serial.println("SD1");

      break;

    case SD_CARD_TYPE_SD2:

      Serial.println("SD2");

      break;

    case SD_CARD_TYPE_SDHC:

      Serial.println("SDHC");

      break;

    default:

      Serial.println("Unknown");

  }

  // Now we will try to open the 'volume'/'partition' - it should be FAT16 or FAT32

  if (!volume.init(card)) {

    Serial.println("Could not find FAT16/FAT32 partition.\nMake sure you've formatted the card");

    return;

  }

  // print the type and size of the first FAT-type volume

  uint32_t volumesize;

  Serial.print("\nVolume type is FAT");

  Serial.println(volume.fatType(), DEC);

  Serial.println();

  volumesize = volume.blocksPerCluster();    // clusters are collections of blocks

  volumesize *= volume.clusterCount();       // we'll have a lot of clusters

  volumesize *= 512;                            // SD card blocks are always 512 bytes

  Serial.print("Volume size (bytes): ");

  Serial.println(volumesize);

  Serial.print("Volume size (Kbytes): ");

  volumesize /= 1024;

  Serial.println(volumesize);

  Serial.print("Volume size (Mbytes): ");

  volumesize /= 1024;

  Serial.println(volumesize);

  Serial.println("\nFiles found on the card (name, date and size in bytes): ");

  root.openRoot(volume);

  // list all files in the card with date and size

  root.ls(LS_R | LS_DATE | LS_SIZE);

}

void loop(void) {

}

this is the code...

is this working for you, I do not see any attempt to write to the card here, only read

Did you figure out the Google ID thing, if not I can have a look over the week end

Peter

Hi Indira,

Would you prefer to implement real-time data acquisition directly from your arduino into Excel - where every data point sent by the arduino immediately gets placed in a new cell in the spreadsheet; or do you prefer to store data from your arduino to the cloud and import it later into Excel?

How far apart (physically) are the arduino and the Excel computer?

I just did a bit of investigating and it looks like Google may not be supporting  un secure channel with Docs now, you need SSL and the use of their APIs (Beyond Arduino Viability or atleast the MEGA range of chips as they do not have enough resources to handle SSL / Encryption. A bigger board may be possible to do this like the Due or Yun.

here is a link to what I found and also my searching through Google info https://productforums.google.com/forum/#!msg/docs/f4hJKF1OQOw/877WUgNHsUcJ

I will still figure the code for using the SD card locally and how to get it to a computer on the local network. The above link does describe a workaround but you need to subscribe to a third party service and presumably give them some of your credentials to access the forms..

Peter

sir i have to access the data through internet from a remomte location..one end pc and anther end seensor with arduino..

Sounds like you need an Ethernet shield and leverage the SD card on it for data logging

now using a simple browser of other client you can reach out to the device and download the logs

do you have an internet connection available where the arduino is going to be located ? (Silly me, of course you do, otherwise Google+ would not be an option)

Peter

ye i have sir..my requirement is i need to store the sensor data in a pc which is located in a remote location..to store it in a sequence like excel sheet...