samedi 28 février 2015

Google script get data from forum


How to get data from forum url. I need to copy post count. I think i managed somehow to make the script but i dont know how to connect it with google spreadsheet.


It should go account by account in column B till last and update the column A with count.


The script doesn't report me any errors with this code



function msg(message){
Browser.msgBox(message);
}

function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu("Update")
.addItem('Update Table', 'updatePosts')
.addToUi();
}

function getPostCount(profileUrl){
var html = UrlFetchApp.fetch(profileUrl).getContentText();
var sliced = html.slice(0,html.search('Posts Per Day'));
sliced = sliced.slice(sliced.search('<dt>Total Posts</dt>'),sliced.length);
postCount = sliced.slice(sliced.search("<dd> ")+"<dd> ".length,sliced.search("</dd>"));

return postCount;
}

function updatePosts(){

if(arguments[0]===false){
showAlert = false;
} else {
showAlert=true;
}

var spreadSheet = SpreadsheetApp.getActiveSpreadsheet();
var accountSheet = spreadSheet.getSheetByName("account-stats");
var statsLastCol = statsSheet.getLastColumn();
var accountCount = accountSheet.getLastRow();
var newValue = 0;
var oldValue = 0;
var totalNewPosts = 0;
for (var i=2; i<=accountCount; i++){
newValue = parseInt(getPostCount(accountSheet.getRange(i, 9).getValue()));
oldValue = parseInt(accountSheet.getRange(i, 7).getValue());
totalNewPosts = totalNewPosts + newValue - oldValue;
accountSheet.getRange(i, 7).setValue(newValue);
statsSheet.getRange(i,statsLastCol).setValue(newValue-todaysValue);

}
if(showAlert==false){
return 0;
}
msg(totalNewPosts+" new post found!");
}


function valinar(needle, haystack){
haystack = haystack[0];
for (var i in haystack){

if(haystack[i]==needle){
return true;
}
}


return false;
}


Assuming this is the first time im doing something similar and working by the example from other site i really stuck.


I have one more question. In function getPostCount i send the function profileurl. Where i declare that ??





Aucun commentaire:

Enregistrer un commentaire