brucemcpherson

initial

brucemcpherson

initial

brucemcpherson

brucemcpherson

function doPost(e) {
  // some defaults for standalone testing
  e = e || {postData:{contents:"<a>a</a>"}};
  e.queryString = e.queryString || "convert=xmltojson" ;  
  var type = e.queryString.toLowerCase().split("=");
 
  // convert xml to json
  var results = {status:"bad", error:"no errors"};
  try {

brucemcpherson

license: gpl-3.0
height: 400
scrolling: no
border: no

brucemcpherson

function doGet(e) {
  var template = HtmlService.createTemplateFromFile('ht');
  // Build and return HTML in IFRAME sandbox mode.
  return template.evaluate();
}


function getThreads(options) {
  

brucemcpherson

Option Explicit
' v1.0
' this one manages interaction with dbAbstraction on Google Apps Script
Private pDbId As String
Private pSiloId As String
Private pResult As cDbAbResult
Private poAuth2 As cOauth2
Private pEndPoint As String
Private pDbName As String
Private pBrowser As cBrowser

brucemcpherson

' use like this =displayAnOldDate(makeAnOldDate(1891,1,2))

Option Explicit
Public Function makeAnOldDate(y As Long, m As Long, d As Long) As Double
    makeAnOldDate = DateSerial(y, m, d)
End Function
Public Function displayAnOldDate(oldDate As Double) As String
    displayAnOldDate = Format(oldDate, "dd-mmm-yyyy")
End Function

brucemcpherson

Option Explicit
' this is how to use Google Apps Script dbabstration web app from Excel.
' version 0.2
' http://ramblings.mcpher.com/Home/excelquirks/dbabstraction
' http://ramblings.mcpher.com/Home/excelquirks/googleoauth2 for how to set up yor pc for oauth2

Public Sub demoDBAccess()
    Dim data As cJobject
    Dim siloId As String, places As cJobject, place As cJobject, result As cJobject, _
        sheetId, driveFolder As String, fusionId As String

brucemcpherson

function cCustomMapping(options) {

    // customize one of these for specific behavior during map usage
    // the functions below must do at least as shown in this skeleton - add your own in addition.

    var self = this;
    var pOptions = options,
        pData, pMap, pParams, pDb;
    self.getOptions = function () {
        return pOptions;