aboutsummaryrefslogtreecommitdiff
path: root/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet
diff options
context:
space:
mode:
authorFederico Fissore <f.fissore@arduino.cc>2013-07-03 09:02:59 +0200
committerFederico Fissore <f.fissore@arduino.cc>2013-07-03 09:03:17 +0200
commit14d5bec55903eb69352b812235052966090cbdb2 (patch)
treefdbc3d1bac42368dd8b4a71b60228dbfb8540d23 /libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet
parenta1f48d22ac570f0ded6db46c0d4eef0c7216a028 (diff)
updated temboo examples
Diffstat (limited to 'libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet')
-rw-r--r--libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino36
-rw-r--r--libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/TembooAccount.h5
2 files changed, 25 insertions, 16 deletions
diff --git a/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino b/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino
index 9698d81..3c513de 100644
--- a/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino
+++ b/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/SendDataToGoogleSpreadsheet.ino
@@ -20,9 +20,8 @@
work properly. It doesn't matter what the column labels actually are,
but there must be text in the first row of each column. This example
assumes there are two columns. The first column is the time (in milliseconds)
- that the row was appended, and the second column is a sensor value
- (simulated in this example via a random number). In other words, your spreadsheet
- should look like:
+ that the row was appended, and the second column is a sensor value.
+ In other words, your spreadsheet should look like:
Time | Sensor Value |
------+-----------------
@@ -48,13 +47,18 @@
/*** SUBSTITUTE YOUR VALUES BELOW: ***/
+// Note that for additional security and reusability, you could
+// use #define statements to specify these values in a .h file.
+
const String GOOGLE_USERNAME = "your-google-username";
const String GOOGLE_PASSWORD = "your-google-password";
// the title of the spreadsheet you want to send data to
+// (Note that this must actually be the title of a Google spreadsheet
+// that exists in your Google Drive/Docs account, and is configured
+// as described above.)
const String SPREADSHEET_TITLE = "your-spreadsheet-title";
-
const unsigned long RUN_INTERVAL_MILLIS = 60000; // how often to run the Choreo (in milliseconds)
// the last time we ran the Choreo
@@ -137,18 +141,19 @@ void loop()
AppendRowChoreo.addParameter("RowData:" + rowData);
// run the Choreo and wait for the results
- // The return code (rc) will indicate success or failure
- unsigned int rc = AppendRowChoreo.run();
+ // The return code (returnCode) will indicate success or failure
+ unsigned int returnCode = AppendRowChoreo.run();
// return code of zero (0) means success
- if (rc == 0) {
+ if (returnCode == 0) {
Serial.println("Success! Appended " + rowData);
Serial.println("");
} else {
// return code of anything other than zero means failure
// read and display any error messages
while (AppendRowChoreo.available()) {
- Serial.print((char)AppendRowChoreo.read());
+ char c = AppendRowChoreo.read();
+ Serial.print(c);
}
}
@@ -157,28 +162,27 @@ void loop()
}
// this function simulates reading the value of a sensor
-// in this example, we're generating a random number
unsigned long getSensorValue() {
- return (unsigned long)random(0, 256);
+ return analogRead(A0);
}
/*
IMPORTANT NOTE: TembooAccount.h:
- TembooAccount.h is a file referenced by this sketch that contains your Temboo account information.
- You need to create this file. To do so, make a new tab in Arduino, call it TembooAccount.h, and
- include the following variables and constants:
+ TembooAccount.h is a file referenced by this sketch that contains your Temboo account information.
+ You'll need to edit the placeholder version of TembooAccount.h included with this example sketch,
+ by inserting your own Temboo account name and app key information. The contents of the file should
+ look like:
#define TEMBOO_ACCOUNT "myTembooAccountName" // your Temboo account name
#define TEMBOO_APP_KEY_NAME "myFirstApp" // your Temboo app key name
#define TEMBOO_APP_KEY "xxx-xxx-xxx-xx-xxx" // your Temboo app key
- The same TembooAccount.h file settings can be used for all Temboo SDK sketches.
-
You can find your Temboo App Key information on the Temboo website,
under My Account > Application Keys
+ The same TembooAccount.h file settings can be used for all Temboo SDK sketches.
+
Keeping your account information in a separate file means you can save it once,
then just distribute the main .ino file without worrying that you forgot to delete your credentials.
*/
-
diff --git a/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/TembooAccount.h b/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/TembooAccount.h
new file mode 100644
index 0000000..8d7dcfb
--- /dev/null
+++ b/libraries/Bridge/examples/Temboo/SendDataToGoogleSpreadsheet/TembooAccount.h
@@ -0,0 +1,5 @@
+#define TEMBOO_ACCOUNT "myTembooAccountName" // your Temboo account name
+#define TEMBOO_APP_KEY_NAME "myFirstApp" // your Temboo app key name
+#define TEMBOO_APP_KEY "xxx-xxx-xxx-xx-xxx" // your Temboo app key
+
+