In my work, I often think, "I want a script that automates this because it's too much work to do it all at once," but I don't know where to start and can't make it happen. How can I make one?

https://jp.quora.com/%E4%BB%95%E4%BA%8B%E3%82%92%E3%81%97%E3%81%A6%E3%81%84%E3%81%A6-%E3%81%93%E3%82%8C%E3%82%92%E3%81%84%E3%81%A1%E3%81%84%E3%81%A1%E3%82%84%E3%82%8B%E3%81%AE%E3%81%8C%E9%9D%A2%E5%80%92%E3%81%84%E3%81%8B%E3%82%89-

I've shared this.

Toyokawa Issei

, former cook, high school graduate, programmer

Answered on May 21, 2020

a2a

I don't know much about Mac, so I'll answer on the premise of automating processes in Windows.

First of all, the basis of automation is shell scripts.

In the case of Windows, it is a black screen called a command prompt (called a console or terminal) where you type in commands.

However, typing a lot of commands on the console screen is very tedious, and it is not automated at all.

So, write several commands together in a text editor (like Notepad) and save them with the .bat extension.

This file is called a batch file, and if you execute the batch file at a certain time (using a task scheduler, for example), the instructions written in the file will be executed automatically at once. This is called batch processing.

This batch processing is the basis of automation.

In addition to this, Widnows also has a shell script called PowerShell, which is a powerful tool that can work with .

NET Framework, and files written in PowerShell are saved with the .ps1 extension. PowerShell is a shell script developed by Microsoft, but I have not seen it actively used.

Of course, both .bat and .ps1 use IF and FOR statements for conditional branching and... (Read more)

Takaaki Naganoya

, Chief Executive Orikousan (2014-present)

Updated on June 4, 2020

↑Click above to enlarge.

This is what it looks like (↑).

For example, for e-mails, automatic sending and sorting into folders after receipt is the first thing to do. Changing the background color of the list of selected e-mails makes it very easy to read, which was also achieved with a script.

A script that calculates the total amount of products sold on an online site by looking at the body of the selected email in the list of emails is also useful.

Email threads, which have become difficult to see due to the increase in the number of exchanges, are displayed in a tree view, with the colors changed in order of the number of statements. I also use a script every day that displays the actual email when you click on the box that shows the title and sender.

It seems that the type of work that I would like to leave to others, but whose know-how is too impersonal to be entrusted to others, will also be subject to automation.

For now, I've made a script to get a list of the article titles and the number of views of the answers I've written on Quora, and I'm having it process them in various ways.

(This is also generated by a script (AppleScript).

The one at the beginning of this article (up) was also created with a script (AppleScript), and the data can be transferred to the iPhone via AirDrop and exported to Adobe Illustrator. This is also internally controlled by Illustrator to create data on the fly at high speed.

How to learn... (more...)

2 comments from Makoto Sasaki and others

Furukawa Isao's profile photo

Furukawa Isao

, Works for an IT company

Answered on May 20, 2020

I think it's a good idea to write a flowchart of the job. Even if you have it memorized in your body, when you are asked to write it on a chart, it must be quite difficult because there are some minor exceptions and you may discover that you were thinking appropriately.

In the process of writing the chart, you will be able to sort out what data you need and what decisions you need to make. Once all the necessary data has been digitized and there is no ambiguity in the decisions, scripting is just around the corner.

Translated with www.DeepL.com/Translator (free version)