Cannot call Google Script API Functions from Web App (TypeError: Cannot read property 'run' of undefined) -


i had google apps script working fine months , stopped working. i'm wondering if google deprecated part of code or something.

this link file: click here view google spreadsheet file

the google script code apparently failing when trying call google script function html file. line of code fails.

google.script.run.importcsvdata(id);

the lines fails , catches following error:

typeerror: cannot read property 'run' of undefined

like said, had code working fine months , stopped working.

(fyi... purpose of code upload csv file tab "archivo plano adn". run code, 1 must select "importar archivo csv" --> "importar archivo..." upper menu. when prompted select file, select .csv file. csv file must separated ;)

my google spreadsheet file has 3 code files ("code.gs", "codeimport.gs" , "picker.html")

let me give code of each:

code.gs:

function onopen() {    var me = session.geteffectiveuser();   if (me.getemail() == "alejandro.sardi@crusardi.net") {     var ui = spreadsheetapp.getui();     ui.createmenu('protected ranges')     .additem('remove protection', 'menuitem1')     .additem('copy protected ranges sheet', 'menuitem2')     .additem('copy sm protected ranges sa sheets', 'menuitem3')     .addtoui();      ui.createmenu('importar archivo csv')       .additem('importar archivo...', 'showpicker')       .addtoui();      ui.cre   } else {     spreadsheetapp.getui() // or documentapp or formapp.       .createmenu('importar archivo csv')       .additem('importar archivo...', 'showpicker')       .addtoui();   }  }

codeimport.gs:

function importcsvdata(id) { try {       var file = driveapp.getfilebyid(id);     var csvdata = utilities.parsecsv(file.getblob().getdataasstring("iso-8859-1"),";");     var sheet = spreadsheetapp.getactivespreadsheet().getsheetbyname("archivo plano adn");     sheet.getrange("a:u").clear();     sheet.getrange("g:g").setnumberformat('@string@');     logger.log("yes");      sheet.getrange(1, 1, csvdata.length, csvdata[0].length).setvalues(csvdata);      file.settrashed(true);      spreadsheetapp.getui().alert("archivo importado con éxito");    } catch (e) {     mailapp.sendemail(session.geteffectiveuser().getemail(), "error report jaja - sonríele la vida!",        "\r\nmessage: " + e.message       + "\r\nfile: " + e.filename       + "\r\nline: " + e.linenumber);   } }  function showpicker() {   var html = htmlservice.createhtmloutputfromfile('picker.html')       .setwidth(600)       .setheight(425)       .setsandboxmode(htmlservice.sandboxmode.iframe);   spreadsheetapp.getui().showmodaldialog(html, 'select file'); }  function getoauthtoken() {   driveapp.getrootfolder();   return scriptapp.getoauthtoken(); }  function finishedimport() {   spreadsheetapp.getui().alert("archivo importado exitosamente"); }   function senderror(e) {    mailapp.sendemail(session.geteffectiveuser().getemail(), "error report jaja - sonríele la vida!",        "\r\nmessage: " + e.message       + "\r\nfile: " + e.filename       + "\r\nline: " + e.linenumber);  }

and finally, picker.html file:

<!doctype html> <html> <head>   <link rel="stylesheet" href="https://ssl.gstatic.com/docs/script/css/add-ons.css">   <script type="text/javascript">     var dialog_dimensions = {         width: 600,         height: 425     };     var pickerapiloaded = false;      function onapiload() {         gapi.load('picker', {             'callback': function() {                 pickerapiloaded = true;             }         });         google.script.run.withsuccesshandler(createpicker)             .withfailurehandler(showerror).getoauthtoken();     }      function createpicker(token) {          if (pickerapiloaded && token) {              //var docsview = new google.picker.docsview()                 //.setincludefolders(true)                 //.setmimetypes('application/vnd.google-apps.folder')                 //.setselectfolderenabled(true);              var uploaddocsview = new google.picker.docsuploadview()                 .setincludefolders(true)                 //.setmimetypes('application/vnd.google-apps.folder')                 //.setselectfolderenabled(true);              var picker = new google.picker.pickerbuilder()                 //.addview(docsview)                 .addview(uploaddocsview)                 //.setappid("aizasyczda4jkkiov2af3qyrg8dnvoxmz27054o")                 .enablefeature(google.picker.feature.nav_hidden)                 .hidetitlebar()                 .setsize(dialog_dimensions.width - 2, dialog_dimensions.height - 2)                 .setoauthtoken(token)                 .setcallback(pickercallback)                 .setorigin('https://docs.google.com')                 .build();              picker.setvisible(true);          } else {             showerror('unable load file picker.');         }     }      /**      * callback function extracts chosen document's metadata      * response object. details on response object, see      * https://developers.google.com/picker/docs/result      *      * @param {object} data response object.      */     function pickercallback(data) {     try {         var action = data[google.picker.response.action];         if (action == google.picker.action.picked) {             var doc = data[google.picker.response.documents][0];             var id = doc[google.picker.document.id];             // show id of google drive folder             //document.getelementbyid('result').innerhtml = id;             document.getelementbyid('result').innerhtml = "importando..."             google.script.run.importcsvdata(id);             //google.script.run.deleteimportedfile(id);             google.script.host.close();         } else if (action == google.picker.action.cancel) {         //document.getelementbyid('result').innerhtml = "cerrando1..."            google.script.host.close();         //document.getelementbyid('result').innerhtml = "cerrando2..."          }         } catch (e) {           document.getelementbyid('result').innerhtml = e;           google.script.run.senderror(e);         }     }      function showerror(message) {         document.getelementbyid('result').innerhtml = 'error: ' + message;     }   </script> </head>  <body>     <div>         <p id='result'></p>     </div>     <script type="text/javascript" src="https://apis.google.com/js/api.js?onload=onapiload"></script> </body> </html>

you need load google file picker using google api loader library.

replace:

<script type="text/javascript" src="https://apis.google.com/js/api.js?onload=onapiload"></script>

with:

<script type="text/javascript" src="https://www.google.com/jsapi"></script> <script>google.load("picker", "1", {callback:function(){pickerapiloaded =!0}});</script>

remember publish new version of web app after making change.

update: erik google apps script team says " cause of problem when picker api loads google.picker, overwriting google.script, google.script.run() calls start failing."

they have posted alternate solution - manually preserve , restore google.script when loading picker api:

window.script = google.script; gapi.load('picker', '1', {callback: function() {   google.script = window.script;   // ... }});

Comments

Post a Comment

Popular posts from this blog

Command prompt result in label. Python 2.7 -

i want put result(output) of shell command label. command works, label shows "0", however, in command prompt, result shown correctly, need showed in label. doing ubuntu. myg1 = button(root, text="rodyti informacija", command=lambda: gauti()) myg1.pack(side=bottom) def gauti(): imti = tekstas.get("1.0", "end-1c") info = subprocess.call("id '{imti}' ".format(imti=imti), shell=true) w = label(root, text= info) w.pack(side = bottom) subprocess.call() returns exit code of process created (in case 0 success). if want text output of process, should instead call subprocess.check_output() .
Read more

javascript - How do I use URL parameters to change link href on page? -

i change href value of link using url parameters. example: default <a id="dlink" href="link-1">link</a> but, when user goes https://url.com/?dlink=link-2 it swaps out link new link <a id="dlink" href="link-2">link</a> first need value url. if you're not using javascript framework can create function using jquery. please check get url parameter jquery or how query string values in js it. after that, element "a" id , set value there. $("#dlink").attr("href", hreffromparam);
Read more

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -

so have domain nameservers pointed aws route 53. site hosted on ec2 instance , reachable resolves site.com, if input www.site.com. i'm curious how site resolve www.site.com. have under route53 domains hosted zone 2 additional record sets outside of ns , soa: a site.com ec2 elastic ip cname www.site.com ec2 public dns i can reach site using both site.com , www.site.com, resolve site.com. there way make if enter either, resolves www.site.com? at first, both should record set. a site.com ec2 elastic ip www.site.com ec2 elastic ip and need redirect setting in web server (nginx, apache, ..) following. (source: how redirect www non-www nginx on centos 7 ) redirect non-www www if want redirect users plain, non-www domain www domain, add server block: server { server_name example.com; return 301 $scheme://www.example.com$request_uri; } save , exit. configures nginx redirect requests "example.com" "www.example.com". not...
Read more