get paid to paste

Tweaks so far:

in collectTweets: 

var targetsheet=ss.getSheetByName("Archive");
...
setArchiveRowsData(targetsheet, data);// write results to Archive sheet



New function:
function setArchiveRowsData(sheet, objects) {
  var headersRange = sheet.getRange(1, 1, 1, sheet.getMaxColumns());
  var firstDataRowIndex = sheet.getLastRow() + 1;
  var headers = normalizeHeaders(headersRange.getValues()[0]);
  var data = [];
  var itemCount=0
  //add things to the archive sheet in chronological order
  for (var i = objects.length-1; i > 0; i--) {
    var values = []
    //we need logic here:
    //if the newly found tweet id is greater than id of last tweet (or timestamp greater?) in archive, add row
    if (true){
      itemCount++;
      for (j = 0; j < headers.length; ++j) {
        var header = headers[j];
        values.push(header.length > 0 && objects[i][header] ? objects[i][header] : "");
      }
      data.push(values);
    }
  }
  if (itemCount>0){
    var destinationRange = sheet.getRange(firstDataRowIndex, headersRange.getColumnIndex(), 
                                        itemCount, headers.length);
    destinationRange.setValues(data);
  }
}

Pasted: Apr 28, 2011, 2:46:16 pm
Views: 22