Google Apps Script – calendar example – part 007.

The result of parsing calendar with Google Apps Script tool can be show in this screenshot: To import a google calendar in your drive google spreadsheet, just create a spreadsheet document file use Google Apps Script. Open Google Apps Script from Tool – Script Editor. Use this script with your google calendar:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
function myFunction() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  //In between the quotations paste your calendar ID
  var cal = CalendarApp.getCalendarById('j7gov1cmnqr9tvg14k621j7t5c@group.calendar.google.com');
 
  //Change the dates in between the quotations
  var start = new Date('August 27, 2016');
  var end = new Date('September 3, 2019');
  //Do not touch any of this stuff
  var events = cal.getEvents(start, end);
  Logger.log(events.length);
  var num = events.length;
  
  ss.insertSheet(0);
  
  var sheet = ss.getSheets()[0];
  
  for(var i=0; i<num; i++){
    sheet.getRange(i+1, 4).setValue(events[i].getStartTime());
    sheet.getRange(i+1, 1).setValue(events[i].getTitle());
    sheet.getRange(i+1, 3).setValue(events[i].getLocation());
    sheet.getRange(i+1, 2).setValue(events[i].getDescription());
    sheet.getRange(i+1, 5).setValue(events[i].getEndTime());
  
  }
  
}

You can… Read More »

About YouTube thumbnails.

Each YouTube video has four generated images from the youtube video known as thumbnails. For example if your video has this URL:

1
https://www.youtube.com/watch?v=YOUR_VIDEO

You can see and change the URL to see this thumbnails:

1
2
3
4
https://img.youtube.com/vi/YOUR_VIDEO/0.jpg
https://img.youtube.com/vi/YOUR_VIDEO/1.jpg
https://img.youtube.com/vi/YOUR_VIDEO/2.jpg
https://img.youtube.com/vi/YOUR_VIDEO/3.jpg

News: Events google reveals .

Events organized by Google are still ongoing and reveals the degree of involvement and desire to assimilate new people.. Take a look at google events page. Another way to get involved is I/O Extended events.

Create MacOS, Windows and Linux cross-platform applications with Electron packager.

I will use the example from my tutorial. Install electron-packager:

Shell
1
\nodejs\electronapp>npm install electron-packager --save-dev

You need to add and modify the scripts below into your package.json:

Shell
1
2
3
4
5
6
7
"electron-packager": "^8.1.0"
},
"scripts": {
"package-mac": "electron-packager . --overwrite --platform=darwin --arch=x64 --icon=assets/icons/mac/icon.icns --prune=true --out=release-builds",
"package-win": "electron-packager . electron-tutorial-app --overwrite --asar=true --platform=win32 --arch=ia32 --icon=assets/icons/win/icon.ico --prune=true --out=release-builds --version-string.CompanyName=CE --version-string.FileDescription=CE --version-string.ProductName=\"TutorialApp\"",    
"package-linux": "electron-packager . electron-tutorial-app --overwrite --asar=true --platform=linux --arch=x64 --icon=assets/icons/png/1024x1024.png --prune=true --out=release-builds"
}

You can create this folders assets, icons, win, mac and png, see:

Shell
1
2
3
4
5
6
7
\nodejs\electronapp>mkdir assets
\nodejs\electronapp>cd assets
\nodejs\electronapp\assets>mkdir icons
\nodejs\electronapp\assets>cd icons
\nodejs\electronapp\assets\icons>mkdir win
\nodejs\electronapp\assets\icons>mkdir mac
\nodejs\electronapp\assets\icons>mkdir png

You need one icon file with this extension .png , .ico and .icns for each folder. You can… Read More »