Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
TAGS v6.0 Client Code
// Copyright 2014 Martin Hawksey. All Rights Reserved.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.
var VERSION = "6.0";
TAGS.setTwtrService(TwtrService);
/**
* Performs the data collection and write
*/
function getTweets(){
var doc = SpreadsheetApp.getActiveSpreadsheet();
var advParams = {};
//var advParams = {"geocode": "40.714353,-74.005973,30mi"};
TAGS.collectTweets(doc, advParams);
}
/**
* On open sheet
*/
function onOpen() {
var doc = SpreadsheetApp.getActiveSpreadsheet();
var menuItems = TAGS.setMenu();
menuItems.push(null); // line separator
menuItems.push({name: getTriggerStatus_(), functionName: "toggleTrigger_"});
doc.addMenu("TAGS", menuItems);
// set latest archive types
TAGS.setArchiveTypesList(doc);
}
/**
* Test rates available from Twitter
*/
function testRate(){
TAGS.testRate();
}
/**
* Wipes the archive sheet apart from header row
*/
function wipeArchive(){
var result = Browser.msgBox("Warning!",
"You are about to wipe the Archive sheet\\n\\nDo you want to continue?",
Browser.Buttons.YES_NO);
// Process the user's response.
if (result == 'yes') {
var doc = SpreadsheetApp.getActiveSpreadsheet();
var sheet = doc.getSheetByName("Archive");
sheet.deleteRows(2, sheet.getLastRow()-1);
}
}
/**
* Launches key/secret and auth flow
*/
function setup() {
Logger.log("Starting auth");
if (TwtrService.isUserConnectedToTwitter()){
var result = Browser.msgBox("Twitter Authorisation",
"You appear to already be connected to Twitter.\\n\\nWould you like to run the setup again?",
Browser.Buttons.YES_NO);
// Process the user's response.
if (result == 'yes') {
// User clicked "Yes".
TwtrService.showTwitterKeySecret(SpreadsheetApp);
}
} else {
TwtrService.showTwitterKeySecret(SpreadsheetApp);
}
}
/**
* Used as part of setup() to process form data
*/
function processForm(formObject) {
TwtrService.setUserKeySecret(formObject);
TwtrService.showTwitterLogin(SpreadsheetApp);
}
/**
* Add summary sheet to current spreadsheet
*/
function addSummarySheet() {
TAGS.addSheet(SpreadsheetApp.getActiveSpreadsheet(), "Summary");
}
/**
* Add summary sheet to current spreadsheet
*/
function addDashboardSheet() {
TAGS.addSheet(SpreadsheetApp.getActiveSpreadsheet(), "Dashboard");
}
/**
* Removes all user data from TwtrService
*/
function disconnectTwitter() {
var result = Browser.msgBox("Warning!",
"Disconnecting Twitter will remove the connection for all of your TAGS sheets.\\n\\nDo you still want to continue?",
Browser.Buttons.YES_NO);
// Process the user's response.
if (result == 'yes') {
TwtrService.disconnectTwitter();
}
}
/**
* Deletes duplicates from the archive
*/
function deleteDuplicates(){
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Archive");
TAGS.deleteDuplicates(sheet);
}
/**
* Toggles the script trigger to refresh archive
*/
function toggleTrigger_(){
if (getTriggerID_() == "none" || getTriggerID_() == null){ // add trigger
var dailyTrigger = ScriptApp.newTrigger("getTweets")
.timeBased()
.everyHours(1)
.create();
setTriggerID_(dailyTrigger.getUniqueId());
onOpen();
} else {
var triggers = ScriptApp.getScriptTriggers();
for (var i = 0; i < triggers.length; i++) {
if (triggers[i].getUniqueId() == getTriggerID_()){
ScriptApp.deleteTrigger(triggers[i]);
setTriggerID_("none");
onOpen();
break;
}
}
}
}
/**
* Gets trigger menu option text
* @return {String} Stats text for menu.
*/
function getTriggerStatus_(){
if (getTriggerID_() == "none" || getTriggerID_() == null) return "Update archive every hour";
return "Stop updating archive every hour"
}
/**
* @param {String} set a trigger id.
*/
function setTriggerID_(id){
PropertiesService.getScriptProperties().setProperty("triggerID", id);
}
/**
* @return {String} get a trigger id.
*/
function getTriggerID_(){
return PropertiesService.getScriptProperties().getProperty("triggerID");
}
/**
* Get the url for GA-Beacon tracking
*/
function getGABeacon(tid){
var id = SpreadsheetApp.getActiveSpreadsheet().getId();
var locale = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetLocale();
return 'https://ga-beacon.appspot.com/'+tid+'/TAGS/'+VERSION+'/'+id+'/'+locale;
}
/**
* Gets the spreadsheet id for TAGSExplorer
*/
function getSheetKey(){
return SpreadsheetApp.getActiveSpreadsheet().getId();
}
function getSheetGID(optSheetName) {
var sheetName = optSheetName || "Archive";
return SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName).getSheetId();
}
/**
* Gets a filtered list of RTs (used in Dashboard sheet)
*/
function filterUnique(tweets){
return TAGS.filterUnique(tweets);
}
@piersoft

This comment has been minimized.

Copy link

commented Jan 18, 2015

hi, how can i do 2 different coloumn with lat and long coordinates, instead only one?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.