Creating a regular project
Automating simple inputs
This section explains how to automatically populate configurations.
You can manually enter configuration values for various activity card properties.
You can utilize variables to reuse the input values for other activity cards.
You can imitate keyboard operations for making inputs.
Entering “Hello! RPA World” in Notepad
To implement a simple automation for running Notepad, by entering “Hello! RPA World” and closing Notepad, complete the following steps:
No. | Scenario | Activity |
---|---|---|
1 | Running Notepad | [App] OpenApp |
2 | Entering “Hello! RPA World” | [App] TextInput |
3 | Closing Notepad | [App] Click |
Running Notepad
In the Library window, drag the OpenApp activity card in the App library and drop it on the flow chart.
In the Command field of the Properties window, enter 'notepad.exe'.
Right-click the activity card to display the context menu and click Run. You can also press the F5 key or click Run on the toolbar.
When the activity is run, Notepad will be opened.
Entering “Hello! RPA World”
Drag the TextInput activity card in the App library and drop it on the flow chart. Double-click the right section of the activity and set the target for the text input. When the target object is identified, a border will be displayed in amber.
In the Library window, drag the TextInput activity card in the App library and drop it on the flow chart.
Double-click No Target on the activity card, hover the pointer over the text input field of the opened Notepad window, and then click to assign the text input field as the target after a red border has been displayed around it.
A pop-up window will be displayed to ask you whether to index the target. Click NO because we will be running only one app in this scenario.
In the Input Text field of the TextInput property, enter 'Hello! RPA World'.
Closing Notepad
In the Library window, drag the CloseApp activity card in the App library and drop it on the flow chart.
In the Properties window, enter the PID or name of the app to close in the [Input] PID field. For the PID of the app to close, refer to the [Output] PID field of the OpenApp activity card properties.(Ex.: “RESULT”)
The completed flow chart of the automated process to run Notepad, enter “Hello! RPA World,” and close Notepad is as follows:
Utilizing a variable
After running Notepad and entering “Hello! RPA World,” store the input value in a variable, and then, enter the value stored in the variable after opening another Notepad. To implement an automation scenario utilizing a variable, complete the following steps:
No. | Scenario | Activity |
---|---|---|
1 | Running Notepad | [App] OpenApp |
2 | Entering “Hello! RPA World” | [App] TextInput |
3 | Defining a variable to store input value | - |
4 | Storing the input value in the variable | [App] GetText |
5 | Running a new Notepad | [App] OpenApp |
6 | Entering the value stored in variable in the new Notepad. | [App] SetText |
7 | Closing all open Notepad apps. | [App] CloseAll |
Running Notepad
Entering “Hello! RPA World” in Notepad > Running Notepad.
Entering “Hello! RPA World”
Entering “Hello! RPA World” in Notepad > Entering “Hello! RPA World”.
Defining a variable to store input value
In the Variables tab at the bottom of the Designer screen, define an Any type, Normal variable to store the input value.
Storing the input value in the variable
In the Library window, drag the GetText activity card in the App library and drop it on the flow chart. Then, in the Properties window, enter the variable name, 'this.lv_greeting'
in the [Output] Result field. When the GetText activity card is executed, the result is stored in the variable named “lv_greeting.”
Running a new Notepad
In the Library window, drag the OpenApp activity card in the App library and drop it on the flow chart.
In the Command field of the Properties window, enter "notepad."
Right-click the OpenApp activity card to display a context menu and click Run to here. Then, ensure that first through the current activity cards are operated properly.
Entering the value stored in variable in the new Notepad.
In the Library window, drag the SetText activity card in the App library and drop it on the flow chart.
In the Properties window, enter the value for the “lv_greeting” variable in the Input Text field. (Input value:
this.lv_greeting
)
When you run the process by clicking Run on the toolbar, two Notepad apps will be open and the first input value will be stored to the variable for the next input.
Closing all open Notepad apps.
In the Library window, drag the CloseAll activity card in the App library and drop it on the flow chart.
In the Properties window, enter the PID or name of the app to close in the Application field.
When the flow chart becomes too long horizontally, you can arrange the activity cards vertically as follows.
Making an input by imitating keyboard operation
Refer to the following instructions to create an automation scenario to open Notepad, input “ABCDEFG,” copy and paste the input value using the “Ctrl+A” (select all), “Ctrl+C” (copy), and “Ctrl+V” (paste) key operations, and then close Notepad.
No. | Scenario | Activity |
---|---|---|
1 | Running Notepad | [App] OpenApp |
2 | Entering “ABCDEFG” and making a line break. | [App] KeyInput |
3 | Selecting all, copying, and pasting | [App] KeyInput |
4 | Closing Notepad | [App] CloseApp |
Running Notepad
Entering “Hello! RPA World” in Notepad > Running Notepad.
Entering “ABCDEFG” and making a line break.
In the Library window, drag the KeyInput activity card in the App library and drop it on the flow chart.
In the Properties window, click (REC button) next to the Key Events field. The button turns gray when the recording begins.
Enter letters “A,” “B,” “C,” “D,” “E,” “F,” and “G”, and then press “Enter” to break the line.
Selecting all, copying, and pasting
In the Library window, drag the KeyInput activity card in the App library and drop it on the flow chart.
In the Properties window, tap on the option Click here to add new item, fill in the KeyCode and Type fields, and then enter the keyboard events in order.
Shortcut | Keyboard operation | KeyCode | Type |
---|---|---|---|
Select all (Ctrl+A) | Press left Ctrl | LControlKey | Down |
Press “A” | A | Press | |
Release left Ctrl | LControlKey | Up | |
Copy (Ctrl+C) | Press left Ctrl | LControlKey | Down |
Press “C” | C | Press | |
Release left Ctrl | LControlKey | Up | |
Paste (Ctrl+V) | Press left Ctrl | LControlKey | Down |
Press “V” | V | Press | |
Release left Ctrl | LControlKey | Up |
When you run the process up to this point, the following input will be made in Notepad.
Closing Notepad
In the Library window, drag the CloseApp activity card in the App library and drop it on the flow chart.
In the Properties window, enter the PID or name of the app to close in the [Input] PID field.
Set the Force property to select whether to forcibly close the app. If you enable this feature, the app will be forcibly closed regardless of the saving status.
Automating mailing
This section explains how to automatically send mail.
Sending mail through Google mail (Gmail)
Log in to your Google account, enter the recipient, subject, content, and then send email.
No. | Scenario | Activity |
---|---|---|
1 | Opening the Google page | Open Internet Explorer or Chrome using one of the following ways: 1. [Net] OpenBrowser 2. [Chrome] ChromeOpen 3. [App] OpenApp (Command='iexplore') |
2 | Logging In | [App] Click [App] TextInput |
3 | Accessing the COMPOSE page. | [App] Click |
4 | Writing email | [App] TextInput |
5 | Sending email | [App] Click |
Opening the Google page
Open the Chrome browser and access “google.com.”
Logging In
Enter the ID, password and log in to your account.
Because the password is encrypted data, select Secure as the Input Text type in the Properties window.
Accessing the Compose page
Click Gmail > Compose to open the “New Message” window.
Writing email
Enter the recipient’s email address, message subject, and content.
Sending email
After completing the composition, click Send to send the email message.
Automating data editing
You can automate data editing features, such as data input, data copy, and data filtering on Microsoft Excel.
Editing data on Microsoft Excel
On Excel, edit data with the data input, data copy, worksheet creation, and filtering features and save the edited data.
No. | Scenario | Activity |
---|---|---|
1 | Creating and opening an Excel file | [Excel] CreateExcel |
[Excel] OpenExcel | ||
2 | Entering and copying data | [Excel] WriteRange |
[Excel] CopyRange | ||
3 | Pasting data in a new worksheet | [Excel] CreateWorkSheet |
[Excel] PasteRange | ||
4 | Applying filters and saving the file | [Excel] SetFilter |
[Excel] SaveExcel |
To create, edit, and save an Excel file, complete the following steps:
Creating and opening an Excel file
In the Library window, drag the CreateExcel activity card in the Excel library and drop it on the flow chart to create a new Excel file.
In the Path field of the Properties window, specify the path to save the newly created file, including the file name and file extension (Ex.: ‘K:\\My files\\RPAExample.xlsx')
In the Library window, drag the OpenExcel activity card in the Excel library and drop it on the flow chart. Then, in the Path field of the Properties window, enter the path specified for the CreateExcel activity card.
Entering and copying data
In the Library window, drag the WriteRange activity card in the Excel library and drop it on the flow chart. Then, enter data in the DataArray field of the Properties window.
You can click to open the "DataArray Property Value Editor" pop-up window and enter table-type (Array2D Type) data.
In the Library window, drag the CopyRange activity card in the Excel library and drop it on the flow chart to copy the data in the selected range.
In the SheetName field of the Properties window, enter the name of worksheet that contains the data to be copied. Then, in the Range field, enter the range of cells to be copied.
Pasting data in a new worksheet
In the Library window, drag the CreateWorkSheet activity card in the Excel library and drop it on the flow chart. Then, in the SheetName field of the Properties window, enter the name of the new worksheet.
In the Library window, drag the PasteRange activity card in the Excel library and drop it on the flow chart to paste the value copied with the CopyRange activity card.
In the SheetName field of the Properties window, enter the name of the worksheet newly created with the CreateWorkSheet activity card. Then, in the Rang field, enter the range specified for the CopyRange activity card.
Applying filters and saving the file
In the Library window, drag the SetFilter activity card in the Excel library and drop it on the flow chart. Then, set specific filtering conditions.
Ex.: For cell 'A1’ on the 'NewSheet’ worksheet, apply a filter for ‘4’
In the FilterQuery field, enter ‘4’ as the filtering condition, and in the SheetName and FilterCell fields, specify the target worksheet name and the cell to apply the filter, respectively.
In the Library window, drag the SaveExcel activity card in the Excel library and drop it on the flow chart to save the Excel file.
When you run the process, you can see that an automated data editing is operated with an Excel file as follows:
You can click the following link to download the sample file. However, to run the sample file, you may need to adjust the property settings including the file path according to your PC environment. Download sample file
Creating a process flow
A process flow is a combination of multiple existing processes to define the order and flow of processing. You can compose a process flow with processes that have been distributed to the server. For more information about distributing a newly created process to the server, see Distributing to the server. A process flow cannot be run directly on a PC. You must distribute it to the server before you can assign it to a bot and run it. For more information, see Process flow.
Automating mailing
Prerequisite conditions for creating an automated process flow
Before you can add processes to a process flow, the process to add must be distributed to the server and approved by the administrator in advance.
Designer login is required first to add a remote process.
To create a process flow for automated mailing, complete the following steps:
Create a new process flow.
Search for the process to add, right-click it, and then click Add Process.
Two processes have been added in the following example. (MyProcess, GoogleNews_Process)
Use the CallProcess activity card to run the first process.
After defining the first process, add the WaitForMultipleEvents activity card to specify the event (process) to wait for.
Distribute the completed process to the server and assign it to a bot for execution.
After the bot has successfully executed the process flow for automated mailing, you can see that an automated email has been received as follows.
Creating a Headless Project
A headless project is used to run an automated process in the background without occupying the screen. A headless project can process up to 10 tasks in parallel without occupying the screen, and is capable of processing a massive amount of data. For more information, see Headless project.
Automating data editing
You can use the example project previously created in Automating data editing to convert it into a headless project.
On Excel, edit data with the data input, data copy, worksheet creation, and filtering features, and save the edited data.
No. | Scenario | Activity |
---|---|---|
1 | Creating and opening an Excel file | [Excel] CreateExcel |
[Excel] HeadlessOpenExcel | ||
2 | Entering and copying data | [Excel] WriteRange |
[Excel] CopyRange | ||
3 | Pasting data in a new worksheet | [Excel] CreateWorkSheet |
[Excel] PasteRange | ||
4 | Applying filters and saving the file | [Excel] SetFilter |
[Excel] SaveExcel | ||
[Excel] CloseExcel |
In the menu, you can click New > New Headless Project to create a new headless project.
Compose the project.
The automation processes and property setting procedures are identical to those for the regular project. For more information, see Creating a regular project.
Complete process creation and click Run. The automated process will be run in the background.
The automated process will continue to run while you perform other tasks on your PC.
When the automated process is complete, "Run Result : PASS” will be will be displayed on the “Output” tab.
Check to ensure that the Excel file has been created in the specified folder, and that the data editing has been properly performed.
You can click the following link to download the sample file. However, to run the sample file, you may need to adjust the property settings including the file path according to your PC environment. Download sample file