Tag Archives: scripting

scripting

SELinux – Change context.

Processes and files are labeled with an SELinux context that contains additional information, such as an SELinux user, role, type, and, optionally, a level. When running SELinux, all of this information is used to make access control decisions. Let’s test this with httpd sercice and index.html file. You need to start this service on Fedora.… Read More »

Google Apps Script – get tasks – part 025.

This simple example uses Advanced Google Services with Task API version 1. You can enable this API from menu Resurces – Advanced Google Services into your Google Apps Script project. The script is simple, takes title and id of your tasks and put on logs system. You can view the output from the menu: View… Read More »

Google Apps Script – set colors – part 024.

This tutorial will show you how to alternate the colors by row. The first part will select by variables the active Spreadsheet, the sheet named Sheet1 and the range area. The for loop will parse all rows by modulo and set a variable named range_input. The color are changed by the setBackgrounds.

// set alternate colors by Row
function alternate_Colors_byRow() {
  var spread_active = SpreadsheetApp.getActiveSpreadsheet(); 
  var sheet = spread_active.getSheetByName("Sheet1"); 
  var range_input = spread_active.getRange("A1:B50").getValues();
  for(var i=0; i<range_input.length; i++){
    if(i%2==0){
      for(var k=0;k<range_input[0].length;k++){
        range_input[i][k]='#ffffff'
      }
    }    
    else{
      for(var k=0;k<range_input[0].length;k++){
        range_input[i][k]='#0076b0'
      }
    }   
  }
  sheet.getRange('A1:B50').setBackgrounds(range_input);
}

// set alternate colors by Row

function alternate_Colors_byRow() {

var spread_active = SpreadsheetApp.getActiveSpreadsheet();

var sheet = spread_active.getSheetByName("Sheet1");

var range_input = spread_active.getRange("A1:B50").getValues();

for(var i=0; i<range_input.length; i++){

if(i%2==0){

for(var k=0;k<range_input[0].length;k++){

range_input[i][k]='#ffffff'

}

else{

for(var k=0;k<range_input[0].length;k++){

range_input[i][k]='#0076b0'

}

sheet.getRange('A1:B50').setBackgrounds(range_input);

}

This is… Read More »

Google Apps Script – search videos by channel – part 023.

This Google Apps Script tutorial will show you how to search for videos from YouTube. First, you need to run this script with and YouTube Data A.P.I. and one Spreadsheet. The script will get the title and id of the first 50 videos info and the result is put into the Shee1. This is the… Read More »

Google Apps Script – calendar example – part 022.

This is another example with Google Apps Script and Calendar A.P.I. The A.P.I. reference calendar can be found at the official webpage. This simple example gets all your calendars and put into Logger.

function get_calendars() {
  var calendars = CalendarApp.getAllCalendars();
  for (var i = 0; i < calendars.length; i++) {
    var calendar = calendars[i];
    Logger.log(calendar.getName());
  }
}

function get_calendars() {

var calendars = CalendarApp.getAllCalendars();

for (var i = 0; i < calendars.length; i++) {

var calendar = calendars[i];

Logger.log(calendar.getName());

}

The output can be seen on Logger from the main menu of script.google.com with View – Logs or pressing Ctrl +… Read More »