You could send them a request perhaps to go in and delete a row . Maybe there is a PHANT command that will delete a row .Have you looked into that at all ?

It sounds like there might be an issue with the libraries being installed correctly. Double check your libraries and if you are still having problems email techsupport@sparkfun.com with a copy of your code and a screenshot of the error and they should be able to help you.

commenting out the progmem.h allows it to compile, but i still can't get a connection to Sparks (see other comment)

I finally got a stream up and working . It took a bit but its for the first Ethernet shield here using the DHT library which covers 3 or 4 different types of sensors (see inside the library). Mine is the white plastic housed one RHT03 and it seems to be getting it right . Ill attach the code here too which is a bit messy and needs refining but works out of the box on that sensor.

include <SPI.h> // Required to use Ethernet

include <Ethernet.h> // The Ethernet library includes the client

include <Progmem.h> // Allows us to sacrifice flash for DRAM

include <DHT.h>

include <stdio.h>

define DHT_PIN 2

DHT dht(DHT_PIN,DHT22);//DHT22 for my sensorRHT03-others in library

define TIMEOUT 3000 //10 second timout

define SPARKFUN_UPDATE_TIME 60000 //Update SparkFun data server every 60000 ms (1 minute).

unsigned long timer1 = 0; unsigned long timer2 = 0;

byte mac[] = {0x00, 0x1D, 0x09, 0x22, 0x75, 0x69}; char server[] = "data.sparkfun.com"; // name address for data.sparkFun (using DNS) // Set the static IP address to use if the DHCP fails to assign IPAddress ip(192,168,0,177); EthernetClient client;

const String publicKey = "RMzp9ANyqzfjw4drzNnZ"; const String privateKey = "lzrnDbjBprioBgD6Mlvd"; const byte NUM_FIELDS = 2; const String fieldNames[NUM_FIELDS] = {"humidity", "temp"}; String fieldData[NUM_FIELDS]; const int triggerPin = 3; const int lightPin = A0; const int switchPin = 5; String name = "Ether-anon"; boolean newName = true;

//Character array to hold results char s[4]; //const int requestInterval = 20000; long lastAttemptTime = 0; float humidity; float temp;

void setup() { Serial.begin(115200);

setupEthernet();

// Setup Input Pins: pinMode(triggerPin, INPUT_PULLUP); pinMode(switchPin, INPUT_PULLUP); pinMode(lightPin, INPUT_PULLUP);

Serial.println(F("=========== Ready to Stream ===========")); Serial.println(F("Press the button (D3) to send an update")); Serial.println(F("Type your name (no spaces!), followed by '!' to update name")); }

void loop() {//Update sparkfun data server every 60 seconds. // Convert each value to a string for our request to App Engine humidity = dht.readHumidity();

temp = dht.readTemperature(); //temp = (temp9/5) + 32 - 1; //To Farenheight calibrate here String temp_string = dtostrf(temp100, 4, 0, s); String humidity_string = dtostrf(humidity*100, 4, 0, s); delay(200); if(millis() > timer1 + SPARKFUN_UPDATE_TIME) { timer1 = millis(); //Update timer1 with the current time in miliseconds since startup. // Gather data: fieldData[0] = String(humidity); delay(100); fieldData[1] = String(temp); //fieldData[2] = name; delay(100); Serial.println("Posting by timer !"); postData(); //Send data to sparkfun data server. Serial.println("Just after timer1\n"); delay(200); }

// If the trigger pin (3) goes low, send the data.

if (!digitalRead(triggerPin)) { // Gather data: fieldData[0] = String(humidity); fieldData[1] = String(temp); //fieldData[2] = name;

Serial.println("Posting by Trigger pin!");
postData(); // the postData() function does all the work, 
            // check it out below.
Serial.println("Just after trigger\n");
delay(200);

}

// Check for a new name input: if (Serial.available()) { char c = Serial.read(); if (c == '!') { newName = true; Serial.print("Your name is "); Serial.println(name); } else if (newName) { newName = false; name = ""; name += c; } else { name += c; } } }

void postData() { // Make a TCP connection to remote host if (client.connect(server, 80)) { // Post the data! Request should look a little something like: // GET /input/publicKey?private_key=privateKey&light=1024&switch=0&name=Jim HTTP/1.1\n // Host: data.sparkfun.com\n // Connection: close\n // \n client.print("GET /input/"); client.print(publicKey); client.print("?private_key="); client.print(privateKey); for (int i=0; i<NUM_FIELDS; i++) { client.print("&"); client.print(fieldNames[i]); client.print("="); client.print(fieldData[i]); } client.println(" HTTP/1.1"); client.print("Host: "); client.println(server); client.println("Connection: close"); client.println(); //Serial.println( fieldNames[],fieldData[]);

        }

else { Serial.println(F("Connection failed")); }

// Check for a response from the server, and route it // out the serial port. /* delay(2000); timer2 = millis();// while((client.available() == 0)&&(millis() < timer2 + TIMEOUT)); //Wait here until server respond or timer2 expires.

  // if there are incoming bytes available
  // from the server, read them and print them:
  while(client.available() > 0)
  {
    char inData = client.read();

    Serial.print(inData);
  }      
  Serial.print("\n");
  Serial.println("Response should be above");
  Serial.println("Disconnected now");
  client.stop(); //Disconnect the client from server.  

*/

while (client.connected()) { if ( client.available() ) { char c = client.read(); Serial.print(c); }
} Serial.println(); client.stop(); }

void setupEthernet() { Serial.println("Setting up Ethernet..."); // start the Ethernet connection: if (Ethernet.begin(mac) == 0) { Serial.println(F("Failed to configure Ethernet using DHCP")); // no point in carrying on, so do nothing forevermore: // try to congifure using IP address instead of DHCP: Ethernet.begin(mac, ip); } Serial.print("My IP address: "); Serial.println(Ethernet.localIP()); // give the Ethernet shield a second to initialize: delay(1000); }

Ok so clearly it was a library problem.

What i did was take all the libraries in the Utility folder and move them into the top folder. After doing this i got a bunch more library errors and moved the libraries back into the utility folder if they were mentioned in the error.

Problem was progmem.h wasn't the title of any libraries in the SFE_CC3000 master file so it made it hard to trouble shoot for me.

Ultimately i moved the following out of the utility folder into one folder above it: cc3000_common.cpp cc3000_common.h host_driver_version.h security.c security.h

That worked for me, but i can't tell you why. Also can't tell you if that will have negative implications moving forward.

Todd could you pick up the pieces on these library moves

You can create a .env config file using your favorite plain text editor in the directory where you launch the server. Here's an example of one: https://gist.github.com/toddtreece/b49b2de4e5f12251dfe5

Just copy the contents of that gist and change the port numbers to match your needs.