Retuning a GMail script to prevent "Exceeded maximum execution time" -

-

i use gmail account receive status updates devices have listed in google spreadsheet user , serial number. status update email have serial number of device in it's email subject , sent once week per device. due number of devices (600+), pretty constant influx of status updates various devices every day. i'm trying setup script search inbox , create list of devices haven't received status update email prompt me figure out why device isn't reporting in.

i've modified script found online at: http://forums.mozillazine.org/viewtopic.php?f=46&t=2740775. works obtaining device serial number listed in spreadsheet , searching inbox email subject serial number sent within past 15 days. script works fine when spreadsheet has 200 items, beyond start getting "exceeded maximum execution time" error , need 600+ items , more time goes on. had add utilities.sleep(1000) line avoid "service invoked many times in short time: gmail ratemax" error. there better way write script avoid these errors?

function searchemail() {  var sheet = spreadsheetapp.getactivesheet();  var data = sheet.getdatarange().getvalues();   var waittime = 15;  var emailto = "temp@email.com";  var emailsubject = "no email in " + waittime + " days following devices";  var emailtext = "";    (var = 1; < data.length; i++) {     utilities.sleep(1000);     var j = + 1;     var gsearch = "in:inbox subject:(" + data[i][1] + ") newer_than:" + waittime + "d";     var threads = gmailapp.search(gsearch, 0, 1);     if (threads.length == 0) {       var emailtext = emailtext + j + " device: " + data[i][1] + "  user: " + data[i][0] + "\n";     }   }   mailapp.sendemail(emailto, emailsubject, emailtext); }

i'd suggest see problem point of view.

could find common string emails report sending ? "device status" in subject or in body...

this way search inbox string, put label on avoid rechecking them , use simple function check in spreadsheet if number in list.

function checklist(device){  var sheet = spreadsheetapp.getactivesheet();  var data = sheet.getdatarange().getvalues();   for(var n=0;n<data.length;n++){     if(data[n][0]==device){ return true};// assuming number in column   }   return false; }

then send mail if(checklist(device)!=true){

this far more efficient think.


Comments

Post a Comment

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

-
i want add external library guillotinemenu-android in application. followed steps given in upvoted answer existing question how add library project android studio? facing error when try build project after step 6 i.e. when added dependency in app/build.gradle compile project(":guillotinemenu") . tried stackoverflow links related error not working out. have made folder named libs in app directory , copied project folder guillotine menu there. here build.gradle(module:app) file apply plugin: 'com.android.application' android { compilesdkversion 22 buildtoolsversion "22.0.1" defaultconfig { applicationid "com.sunshine.bbreaker.appet_i" minsdkversion 14 targetsdkversion 22 versioncode 1 versionname "1.0" } buildtypes { release { minifyenabled false proguardfiles getdefaultproguardfile('proguard-android.txt'), 'proguard-rules.p...
Read more

StringGrid issue in Delphi XE8 firemonkey mobile app -

-
i'm using delphi xe8 developing mobile application , i'm facing of problem in tstringgrid. i have written following code in stringgridselectcell event. showmessage(stringgrid.cells[0, arow]); and shows proper value of selected row @ first time. when have tried click again selected row, event not getting fired. , cant able unselect particular row. so, have tried write message in onclick event. var irowind: integer; begin irowind := stringgrid1.selected; showmessage(stringgrid.cells[0, irowind]); end; and not working @ first time of click , when clicked second time works properly. issue in android mobile , not in windows. later, have kept both event code , faced issue. when i'm scrolling grid, firing onclick event. so, displaying selected row value. please provide me solution. , in advance. let's onclick event: procedure tfmmain.stringgrid1click(sender: tobject); begin caption := 'selected row id: ' + stringgrid1.select...
Read more

html - jQuery UI Sortable - Remove placeholder after item is dropped -

-
i'm trying nested sortable , i'm kind'a succeeding, there's 1 small little inconvenience bugs me. i want placeholder disappear after i've dropped dragged item (on mouseup) , can't quite figure out how it. i want because when sort downwards, deletion of placeholder affects parent's height, in turn creates small bug, check jsfiddle here. html <div class="container"> <h1>menu</h1> <ul class="list-group striped nest"> <li class="list-group-item">home <ul class="list-group striped nest"></ul></li> <li class="list-group-item">about <ul class="list-group striped nest"></ul></li> <li class="list-group-item"> services <ul class="list-group striped nest"> <li class="list-group-item">design <ul class=...
Read more