Google Apps Script – extract text from PDF file – part 012.

This tutorial has two parts. The first part refers to a book about javascript in different formats. The second part is about processing PDF files with Google Apps Script. Let’s start with the first part. The book is at this web address. The author comes with this brief introduction: Eloquent JavaScript 3rd edition This is… Read More »

Google Apps Script – the CLASP tool – part 011.

This tutorial is about CLASP. You can use locally this tool that lets you to create, edit, and deploy Apps Script projects. The clasp requires Node.js >= v4.7.4 to be installed.

Shell
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
C:\nodejs>npm i @google/clasp -g
C:\Users\catafest\AppData\Roaming\npm\clasp -> C:\Users\your_account\AppData\Roaming
\npm\node_modules\@google\clasp\src\index.js
+ @google/clasp@1.6.3
added 278 packages from 159 contributors in 161.263s
 
C:\nodejs>clasp
Usage:  <command> [options]
 
clasp - The Apps Script CLI
 
Options:
  -h, --help                                       output usage information
 
Commands:
  login [options]                                  Log in to script.google.com
  logout                                           Log out
  create [options] [scriptTitle] [scriptParentId]  Create a script
  clone [scriptId] [versionNumber]                 Clone a project
  pull [options]                                   Fetch a remote project
  push [options]                                   Update the remote project
  status [options]                                 Lists files that will be push
ed by clasp
  open [options] [scriptId]                        Open a script
  deployments                                      List deployment ids of a scri
pt
  deploy [version] [description]                   Deploy a project
  undeploy <deploymentId>                          Undeploy a deployment of a pr
oject
  redeploy <deploymentId> <version> <description>  Update a deployment
  versions                                         List versions of a script
  version [description]                            Creates an immutable version
of the script
  list                                             List App Scripts projects
  logs [options]                                   Shows the StackDriver logs
  run [options] <functionName>                     Run a function in your Apps S
cripts project
  apis                                             List, enable, or disable apis
  help                                             Display help
  *                                                Any other command is not supp
orted
 
C:\nodejs>clasp login
No credentials given, continuing with default...
?  Authorize clasp by visiting this url:
https://accounts.google.com/o/oauth2/v2/auth?access_type=offline&scope=https...

This will open a webpage to authenticate with your Google account. Next step: create your project folder and use it with Google Apps… Read More »

PowerShell tips – part 012.

From Azure documentation we can read this: The Azure support we are going to use requires PowerShell version 5.0 or higher.

Shell
1
2
3
4
5
6
7
8
9
C:\WINDOWS\system32>powershell
Windows PowerShell
Copyright (C) 2014 Microsoft Corporation. All rights reserved.
 
PS C:\WINDOWS\system32> $PSVersionTable.PSVersion
 
Major  Minor  Build  Revision
-----  -----  -----  --------
4      0      -1     -1

The update of PowerShell can be found here, see the table: Windows PS 3.0 PS 4.0 PS 5.0 PS 5.1 Windows 10 (see Note1) Windows Server 2016 – – – installed Windows 8.1… Read More »

How a antivirus can help you…

This article has a character that shows that a PC administrator can not access a file it created. In this case, the antivirus installation mapped the file called clear.bat and banned access to it.

Shell
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
C:\WINDOWS\system32>icacls clean.bat
clean.bat NT AUTHORITY\SYSTEM:(I)(F)
          BUILTIN\Administrators:(I)(F)
          BUILTIN\Users:(I)(RX)
          APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(RX)
 
Successfully processed 1 files; Failed processing 0 files
 
C:\WINDOWS\system32>clean.bat
Access is denied.
 
C:\WINDOWS\system32>icacls.exe clean.bat /RESET
processed file: clean.bat
Successfully processed 1 files; Failed processing 0 files
 
C:\WINDOWS\system32>icacls clean.bat
clean.bat NT AUTHORITY\SYSTEM:(I)(F)
          BUILTIN\Administrators:(I)(F)
          BUILTIN\Users:(I)(RX)
          APPLICATION PACKAGE AUTHORITY\ALL APPLICATION PACKAGES:(I)(RX)
 
Successfully processed 1 files; Failed processing 0 files
 
C:\WINDOWS\system32>clean.bat
Access is denied.
 
C:\WINDOWS\system32>takeown.exe /f clean.bat
 
SUCCESS: The file (or folder): "C:\WINDOWS\system32\clean.bat" now owned by user
"VAIO\catafest".