Tag Archives: scripting

scripting

Google Apps Script – annotations – part 039.

This is a simple example with Google Apps Script and geocode feature.

JavaScript
1
2
3
4
5
6
7
8
9
10
11
12
13
14
function geoCodeAddress(address){
/*
https://developers.google.com/apps-script/reference/maps/geocoder#geocode(String)
*/
  var address = "Fălticeni";
  if(address !== ""){
  var response = Maps.newGeocoder().geocode(address);
    for (var i = 0; i < response.results.length; i++) {
      var result = response.results[i];
    }
  }
  Logger.log(result.geometry.location.lat + "," +result.geometry.location.lng)
return result.geometry.location.lat + "," +result.geometry.location.lng;
}

The result is this:

1
2
3
12:46:19 AM Notice Execution started
12:46:19 AM Info 47.4615626,26.3015288
12:46:19 AM Notice Execution completed

PowerShell tips – part 019.

This is a simple script that lets you get the name of the video card.

PowerShell
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
30
Add-Type -AssemblyName System.Windows.Forms
[System.Windows.Forms.Application]::EnableVisualStyles()
 
$Form = New-Object system.Windows.Forms.Form
$Form.ClientSize        = New-Object System.Drawing.Point(640,480)
$Form.text     = "Get system information ..."
$Form.TopMost  = $false
 
$Button1       = New-Object system.Windows.Forms.Button
$Button1.text  = "Video Card"
$Button1.width = 76
$Button1.height= 33
$Button1.location       = New-Object System.Drawing.Point(16,11)
$Button1.Font  = New-Object System.Drawing.Font('Microsoft Sans Serif',10)
 
$Label1        = New-Object system.Windows.Forms.Label
$Label1.text   = ""
$Label1.AutoSize        = $true
$Label1.width  = 25
$Label1.height = 8
$Label1.location        = New-Object System.Drawing.Point(20,70)
$Label1.Font   = New-Object System.Drawing.Font('Microsoft Sans Serif',10)
 
$Form.controls.AddRange(@($Button1,$Label1))
 
$Button1.Add_Click({ run })
 
function run { $Label1.text = wmic path win32_VideoController get name}
 
[void]$Form.ShowDialog()

PowerShell tips – part 018.

You can start a PowerShell or command shell with these commands:

1
2
Start-Process cmd
Start-Process powershell

You can start an admin PowerShell or command shell with these commands:

1
2
Start-Process powershell -Verb RunAs
Start-Process cmd -Verb RunAs

Also, you can specify the working directory:

1
2
3
4
Start-Process powershell -Verb RunAs -WorkingDirectory C:\
C:\WINDOWS\system32
Start-Process powershell -WorkingDirectory C:\
C:\

 

Lua – first steps – part 001.

The name Lua comes from Portuguese meaning moon and is a lightweight, high-level, multi-paradigm programming language designed primarily for embedded use in applications. Lua was originally designed in 1993 as a language for extending software applications to meet the increasing demand for customization at the time. Lua is cross-platform since the interpreter of compiled bytecode… Read More »

Google Apps Script – annotations – part 037.

In brief: JSDoc is a markup language used to annotate JavaScript source code files. Using comments containing JSDoc, programmers can add documentation describing the application programming interface of the code they’re creating. This is then processed, by various tools, to produce documentation in accessible formats like HTML and Rich Text Format. The JSDoc specification is… Read More »

Google Apps Script – send mail with map address – part 036.

Open a Spreadsheet and rename the Sheet to test001. Use the next source code:

1
2
3
4
5
6
7
function sendMap() {
  //var sheet = SpreadsheetApp.getActiveSheet();
  var sheet = SpreadsheetApp.getActive().getSheetByName('test001')
  var address = sheet.getRange('A1').getValue();
  var map = Maps.newStaticMap().addMarker(address);
  GmailApp.sendEmail('catafest@yahoo.com', 'Map', 'See below.', {attachments:[map]});
}

This will send a mail to my email address with a map from the address in column A1.