Overview

Overview

You can control the system using the features provided by the System library.

Create and delete files, run and close files, create, copy, paste, and delete directories, and create linkages to the database to control the system operation.

The features provided by the System library are as follows:

• File control: CreateFile, ExecuteFile, CloseFile, CopyFile, DeleteFile, IsFileExist, GetFileList, MoveFile, RenameFile, Zip, UnZip, IsFileLock, WaitFileUnlock, WaitFileCreation, WaitFileDelete

• Directory control: CreateDirectory, IsDirectoryExist, CopyDirectory, DelectDirectory, GetDirectoryList, GetSpecialFolder

• Text file control: ReadTextFile, WriteTextFile

• Input box and message box display: InputBox, MessageBox

• Editing features: GetClipboard, SetClipboard, ClipboardToFile, Screenshot(Alt+PrtSc), Copy(Ctrl+C), Cut(Ctrl+X), Paste(Ctrl+V), SelectAll(Ctrl+A)

• Program execution: ExecuteCmd

• Calculation of elapsed time: TimeStamp

• Registry-related features: GetRegistryValue, SetRegistryValue

• DB-related features: DBConnection, GetDBData, UpdateDBData, SendDBCommand

Common Properties

Common Properties

COMMAND

• Configure settings related to commands.

MORE OPTIONS

DESCRIPTION

CreateFile

CreateFile

Overview

This activity card creates a file in the specified path.

Application procedures

1. In the Path field, enter the path and file name to create a file.

2. Set the OverWrite property to select whether to overwrite any existing file with the same name in the path.

Card properties

Example of utilization

Create a Notepad file named “IPA Test.txt” in the specified path and delete it.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_CreateFile_Test

Used variables

• None

Used properties

• Path = 'C:\\IPA Test.txt'

• OverWrite = On

Related/Similar activities

DeleteFile, IsFileExist

ExecuteFile

ExecuteFile

Overview

This activity card executes the specified file.

Application procedures

1. in the [Output] Output field, enter the variable to store the PID of the launched app.

2. In the Timeout field, enter the delay time until the target file is opened.

3. In the Path field, enter the path and file name to run a file.

Card properties

Example of utilization

Create a Notepad file named “IPA Test.txt” in the specified path and open it.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_ExecuteFile_Test

Used variables

• None

Used properties

• Timeout(Sec) = 10

• Path = 'C:\\IPA Test.txt'

Related/Similar activities

DeleteFile, IsFileExist

CloseFile

CloseFile

Overview

This activity card closes a file that is currently executed.

Application procedures

In the [Input] PID field, enter the PID of the file to close.

Card properties

Example of utilization

Create a Notepad file named “IPA Test.txt” in the specified path, open it, and close it.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_CloseFile_Test

Used variables

• createFile = Variable to assign the executed Notepad file.

Used properties

• [Input] PID = this.createFile

Related/Similar activities

CreateFile, ExecuteFile

CopyFile

CopyFile

Overview

This activity card copies the specified file.

Application procedures

1. In the SrcFilePath field, enter the path and file name of the source file to copy.

2. In the DescFilePath field, enter the new path and file name to save the copied file.

3. Set the Overwrite property to select whether to overwrite any existing file with the same name in the path.

Card properties

Example of utilization

Create a Notepad file named “IPA Test.txt” in the specified path. Then, copy it and save it in the newly specified path as “IPA Test_Copy.txt.”

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_CopyFile_Test

Used variables

• None

Used properties

• SrcFilePath = 'C:\\IPA Test.txt'

• DescFilePath = 'C:\\IPA Test_Copy.txt'

Related/Similar activities

CreateFile, CloseFile, DeleteFile

DeleteFile

DeleteFile

Overview

This activity card deletes the specified file.

Application procedures

In the Path field, enter the path and file name to delete.

Card properties

Example of utilization

Delete the Notepad file named “IPA Test.txt” in the specified path.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_DeleteFile_Test

Used variables

• None

Used properties

• Path = 'C:\\IPA Test.txt'

Related/Similar activities

CreateFile, CloseFile, CopyFile

IsFileExist

IsFileExist

Overview

This activity card checks whether the specified file exists.

Application procedures

1. In the [Output] Output field, enter the variable to store the value of a verification result.

2. In the Path field, enter the path and file name of the Excel document to verify the existence.

Card properties

Example of utilization

Verify if the Notepad file, “IPA Test.txt,” exists and output the verification result in a message box.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_IsFileExist_Test

Used variables

• isExist = Variable to store the verification result

Used properties

• [Output] Output = this.isExist

• Path = 'C:\\IPA Test.txt'

Related/Similar activities

IsDirectoryExist

ReadTextFile

ReadTextFile

Overview

This activity card reads a text file and fetches the text string.

Application procedures

1. In the [Output] Output field, enter the variable to store the read text.

2. Set the Encoding property to select the text encoding type.

3. In the Path field, enter the path and file name to read.

Card properties

Example of utilization

Read the text in the Notepad file, “IPA Test.txt,” and save it to the “readTextFile” variable. The text read from the file can be utilized for subsequent processes.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_ReadTextFile_Test

Used variables

• readTextFile = Variable to store the read value

Used properties

• [Output] Output = this.readTextFile

• Encoding = Default

• Path = 'C:\\IPA Test.txt'

Related/Similar activities

WriteTextFile

WriteTextFile

WriteTextFile

Overview

This activity card writes a text string in a text file and saves it.

Application procedures

1. Set the Encoding property to select the text encoding type.

2. In the Text field, enter the text string to write.

3. In the Path field, enter the path and file name of the file to write the text string in.

4. Set the Overwrite property to select whether to overwrite any existing file with the same name in the path.

Card properties

Example of utilization

Create a Notepad file named “IPA Test.txt” in the specified path and open it. Then, enter the text, “WriteTextFile Test,” in the file and close the file. The text written in the file can be utilized for subsequent processes.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_WriteTextFile_Test

Used variables

• None

Used properties

• Encoding = Default

• Text = 'WriteTextFile Test'

• Path = 'C:\\IPA Test.txt'

• Overwrite = On

Related/Similar activities

ReadTextFile

CreateDirectory

CreateDirectory

Overview

This activity card creates a new directory in the specified path.

Application procedures

In the Path field, enter the path to create a new directory.

Card properties

Example of utilization

Create a new directory, “C:\\IPA Test.”

Sample file

• Menu > Help > Sample > Sample > System > Manage Directory > P_CreateDirectory_Test

Used variables

• None

Used properties

• Path = 'C:\\IPA Test'

Related/Similar activities

DeleteDirectory

IsDirectoryExist

IsDirectoryExist

Overview

This activity card verifies whether the specified directory exists.

Application procedures

1. In the [Output] Output field, enter the variable to store the value of a verification result.

2. In the Path field, enter the path to verify the existence.

Card properties

Example of utilization

Verify if the “C:\\IPA Test” directory exists and output the verification result in a message box. If the directory exists, it can be utilized for subsequent processes.

Sample file

• Menu > Help > Sample > Sample > System > Manage Directory > P_IsDirectoryExist_Test

Used variables

• isDirExist = Variable to store the verification result

Used properties

• Output = this.isDirExist

• Path = 'C:\\IPA Test'

Related/Similar activities

IsFileExist

CopyDirectory

CopyDirectory

Overview

This activity card copies the specified directory.

Application procedures

1. In the SrcDirPath field, enter the path for the source directory to copy.

2. In the DescDirPath field, enter a new path to save the copied directory.

3. Set the Overwrite property to select whether to overwrite any existing directory with the same name in the specified path.

Card properties

Example of utilization

Copy a directory created in the specified path and save it to the new path.

Sample file

• Menu > Help > Sample > Sample > System > Manage Directory > P_CopyDirectory_Test

Used variables

• None

Used properties

• SrcFilePath = 'C:\\IPA Test\\CopyDir_Test1' (First CopyDirectory)

• DescFilePath = 'C:\\IPA Test\\CopyDir_Test2' (First CopyDirectory)

• SrcFilePath = 'C:\\IPA Test\\CopyDir_Test1\\' (Second CopyDirectory)

• DescFilePath = 'C:\\IPA Test\\CopyDir_Test2' (Second CopyDirectory)

Related/Similar activities

CreateFile, CloseFile, DeleteFile

DeleteDirectory

DeleteDirectory

Overview

This activity card deletes the specified directory.

Application procedures

1. In the Path field, enter the path for the directory to delete.

Card properties

Example of utilization

Delete the specified directory, “C:\\IPA Test\\DeleteDir_Test2.”

Sample file

• Menu > Help > Sample > Sample > System > Manage Directory > P_DeleteDirectory_Test

Used variables

• None

Used properties

• Path = 'C:\\IPA Test\\DeleteDir_Test2'

Related/Similar activities

CreateDirectory, CopyDirectory

GetFileList

GetFileList

Overview

This activity card fetches the file list of a specified directory.

Application procedures

1. In the [Output] Output field, enter the variable to store the fetched file list.

2. In the Path field, enter the path for the directory to fetch the file list.

Card output properties

Card input properties

Example of utilization

Fetch the list of files in the “C:\\” directory and output it in a message box.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_GetFileList_Test

Used variables

• getFileList = Variable to store the fetched file list

Used properties

• [Output] Output = this.getFileList

• Path = 'C:\\'

Related/Similar activities

GetDirectoryList

GetDirectoryList

GetDirectoryList

Overview

This activity card fetches the sub-directory list of a specified directory.

Application procedures

1. In the [Output] Output field, enter the variable to store the fetched directory list.

2. In the Path field, enter the path for the parent directory to fetch the directory list.

Card output properties

Card input properties

Example of utilization

Fetch the list of subordinate directories under the “C:\\” directory and output it in a message box.

Sample file

• Menu > Help > Sample > Sample > System > Manage Directory > P_GetDirectoryList_Test

Used variables

• getDirectoryList = Variable to store the fetched subordinate directory list

Used properties

• [Output] Output = this.getDirectoryList

• Path = 'C:\\'

Related/Similar activities

GetFileList

InputBox

InputBox

Overview

This activity card displays an input box on the screen for a user input.

Application procedures

1. In the [Output] Variable field, enter the variable to store the input value.

2. In the DefaultValue field, enter the value to display in the input box.

Card properties

Example of utilization

Create a Notepad file named “IPA Test.txt” in the specified path and store the text input by the user in the “this.inputBox” variable. On Designer, this activity card receives text input by the user to utilize it for subsequent processes.

Sample file

• Menu > Help > Sample > Sample > System > Other Samples > P_InputBox_Test

Used variables

• inputBox = Variable that stores the value that will be displayed in the input field of the input box (Default: 'inputBox_Test')

Used properties

• [Output] Variable = this.inputBox

• DefaultValue = this.inputBox

Remarks

Related/Similar activities

MessageBox

MessageBox

MessageBox

Overview

This activity card displays a message box on the screen.

Application procedures

In the Arguments field, enter the value to display in the message box.

Card properties

Example of utilization

Output the text string (variable) input received with the InputBox activity card in a message box.

Sample file

• Menu > Help > Sample > Sample > System > Other Samples > P_MessageBox_Test

Used variables

• inputBox = Variable that stores the value that will be displayed in the input field of the input box (Default: null)

Used properties

• Arguments = this.inputBox

Remarks

Related/Similar activities

MessageBox

GetClipboard

GetClipboard

Overview

This activity card fetches the value saved in the system clipboard.

Application procedures

In the [Output] Output field, enter the variable to store the value fetched from the clipboard.

Card properties

Example of utilization

On the Google website, fetch the specific boundary data of the Google logo image obtained by utilizing the GetImageBounds activity card and save it on the clipboard. This activity card fetches the value stored on the clipboard for subsequent processes.

Sample file

• Menu > Help > Sample > Sample > System > Utilize Clipboard > P_GetClipboard_Test

Used variables

• browser_id = Variable to assign the launched browser

• setClip = Variable to assign the fetched boundary data

• getClip = Variable to store the value read from the clipboard

Used properties

• [Output] Output = this.getClip

Related/Similar activities

SetClipboard

SetClipboard

SetClipboard

Overview

This activity card saves the input value to the system clipboard.

Application procedures

1. In the Input field, enter the value to store on the clipboard.

Card properties

Example of utilization

Copy the text on the specific location of the Paint app screen on the clipboard, and then paste it in Notepad. This activity card fetches the value stored on the clipboard for subsequent processes.

Sample file

• Menu > Help > Sample > Sample > System > Utilize Clipboard > P_SetClipboard_Test

Used variables

• setClip = Variable to store the fetched text value

• paint_id = Variable to assign the launched Painter app

• notepad_id = Variable to specify the launched Notepad app

Used properties

• Input = this.setClip

Related/Similar activities

GetClipboard

ClipboardToFile

ClipboardToFile

Overview

This activity card saves the image or text content on the clipboard as a file.

Application procedures

1. In the DataFormat field, select the data type to store on the clipboard.

2. In the Path field, enter the path and file name to save the content on the clipboard.

Card properties

Example of utilization

Store the content of the Notepad app screen on the clipboard and save it in the specified file format.

Sample file

• Menu > Help > Sample > Sample > System > Utilize Clipboard > P_ClipboardToFile_Test

Used variables

• process_id = Variable to specify the launched Notepad app

• getClip = Variable to store the value read from the clipboard

• setClip = Variable to store the fetched text

• filename = Variable that stores the path input to save the content on the clipboard 'C:\\IPATest_ClipboardToFile.txt')

Used properties

• DataFormat = TXT

• Path = this.filename

Related/Similar activities

GetClipboard, SetClipboard

GetSpecialFolder

GetSpecialFolder

Overview

This activity card fetches the paths for the default system folders provided by Windows.

Application procedures

1. In the [Output] Output field, enter the variable to store the fetched path for the system folder.

2. Set the FolderType property to select the system folder type.

Card output properties

Card input properties

Example of utilization

Read a system folder path and return it as the value for the “RESULT” variable. Then, save the content on the clipboard as a file (RESULT+test_RPA.txt) in the specified path.

Sample file

• Menu > Help > Sample > Sample > System > Other Samples > P_GetSpecialFolder_Test

Used variables

• getClip = Variable to store the value read from the clipboard

• setClip = Variable to store the fetched text

Used properties

• FolderType = Desktop

Remarks

Related/Similar activities

GetFileList, GetDirectoryList, GetClipboard, GetRegistryValue

Screenshot(Alt+PrtSc)

Screenshot(Alt+PrtSc)

Overview

This activity card captures the screen that is currently focused on.

Application procedures

1. Use other activity cards (OpenApp, ChromeOpen, etc.) to compose a screen to capture.

2. In the BeforeDelay(ms) and AfterDelay(ms) fields, enter the delay time before and after the screen capture event.

3. In the Path field, enter the path and file name to save the captured screen.

4. Set the FullScreen property to specify whether to capture the entire screen.

Card properties

Example of utilization

Capture the launched Notepad app screen (Screenshot / Alt+PrtSc) and save the captured image as “C:\IPA ScreenShotTest.png.”

Sample file

• Menu > Help > Sample > Sample > System > Other Samples > P_ScreenShot_Test

Used variables

• RESULT = Variable to assign the launched Notepad app

Used properties

• BeforeDelay(ms) = 1000

• AfterDelay(ms) = 2000

• Path = 'C:\\IPA ScreenShotTest.png'

• FullScreen = On

Related/Similar activities

ExecuteFile

Copy(Ctrl+C)

Copy(Ctrl+C)

Overview

This activity card copies the specified file. This feature works identically to the “Ctrl+C” shortcut combination on the keyboard.

Application procedures

1. On the screen set the focus on specific text or files.

2. In the BeforeDelay(ms) and AfterDelay(ms) fields, enter the delay time before and after the “copy” event.

Card properties

Example of utilization

Open a new Notepad document and enter “Ctrl+C Test.” Then, copy the text (Ctrl+C) and paste it (Ctrl+V) on the app screen.

Sample file

• Menu > Help > Sample > Sample > System > Other Samples > P_Copy_Ctrl_C_Test

Used variables

• exefile = Variable to assign the launched Notepad app

Used properties

• BeforeDelay(ms) = 0

• AfterDelay(ms) = 0

Related/Similar activities

SelectAll(CTRL+A), Paste(CTRL+V), Cut(CTRL+X)

Cut(Ctrl+X)

Cut(Ctrl+X)

Overview

This activity card cuts the target text or files that are currently focused on. This feature works identically to the “Ctrl+X” shortcut combination on the keyboard.

Application procedures

1. On the screen, set the focus on specific text or files.

2. In the BeforeDelay(ms) and AfterDelay(ms) fields, enter the delay time before and after the “cut” event.

Card properties

Example of utilization

Open a new Notepad document and enter “Ctrl+X Test.” Then, select all text (Ctrl+A), cut the selection (Ctrl+X), and paste it (Ctrl+V) on the app screen.

Sample file

• Menu > Help > Sample > Sample > System > Other Samples > P_Cut_Ctrl_X_Test

Used variables

• exefile = Variable to assign the launched Notepad app

Used properties

• BeforeDelay(ms) = 0

• AfterDelay(ms) = 0

Related/Similar activities

SelectAll(CTRL+A), Paste(CTRL+V), Cut(CTRL+C)

Paste(Ctrl+V)

Paste(Ctrl+V)

Overview

This activity card pastes the data to a window that is currently focused on. This feature works identically to the “Ctrl+V” shortcut combination on the keyboard.

Application procedures

1. Set the focus on the target window.

2. In the BeforeDelay(ms) and AfterDelay(ms) fields, enter the delay time before and after the “paste” event.

Card properties

Example of utilization

Open a new Notepad document and enter “Ctrl+V Test.” Then, select all text (Ctrl+A), cut the selection (Ctrl+X), and paste it (Ctrl+V) on the app screen.

Sample file

• Menu > Help > Sample > Sample > System > Other Samples > P_Paste_Ctrl_V_Test

Used variables

• None

Used properties

• BeforeDelay(ms) = 0

• AfterDelay(ms) = 0

Related/Similar activities

SelectAll(CTRL+A), Copy(CTRL+C), Cut(CTRL+X)

SelectAll(Ctrl+A)

SelectAll(Ctrl+A)

Overview

This activity selects all entries in a window that is currently focused on. This feature works identically to the “Ctrl+A” shortcut combination on the keyboard.

Application procedures

1. Set the focus on the target window.

2. In the BeforeDelay(ms) and AfterDelay(ms) fields, enter the delay time before and after the “select all” event.

Card properties

Example of utilization

Open a new Notepad document and enter “Ctrl+V Test.” Then, select all text (Ctrl+A), cut the selection (Ctrl+X), and paste it (Ctrl+V) on the app screen.

Sample file

• Menu > Help > Sample > Sample > System > Other Samples > P_SelectAll_Ctrl_A_Test

Used variables

• None

Used properties

• BeforeDelay(ms) = 0

• AfterDelay(ms) = 0

Related/Similar activities

Paste(CTRL+V), Copy(CTRL+C), Cut(CTRL+X)

ExecuteCmd

ExecuteCmd

Overview

This activity card executes a program command in the background and returns the execution result. This feature will not be visible when it is executed.

Application procedures

1. In the [Output] Output field, enter the variable to store the execution result of the target program.

2. In the Command field, enter the command to execute.

Card properties

Example of utilization

Execute the "dir” command in the background. Then, return the result to the “cmdVar1” variable and output it in a message box. The returned value becomes the standard output string generated when carrying out a command.

Sample file

• Menu > Help > Sample > Sample > System > Other Samples > P_ExecuteCmd_Test

Used variables

• cmdVar1 = Variable to store the execution result of the command

Used properties

• [Output] Output = this.cmdVar1

• Command = 'cmd'

• Arguments = '/c dir'

Remarks

Related/Similar activities

ExecuteFile

TimeStamp

TimeStamp

Overview

This activity card returns the elapsed time from the specified time to the current time in milliseconds.

Application procedures

1. In the [Output] Output field, enter the variable to store the elapsed time.

2. In the BaseTime field, enter the time to start calculating the elapsed time.

Card output properties

Card input properties

Example of utilization

Open the Notepad app and perform text input and cut and paste the text. Then, output the elapsed time in a message box. This feature can be used to process elapsed time.

Sample file

• Menu > Help > Sample > Sample > System > Other Samples > P_TimeStamp_Test

Used variables

• openApp1 = Variable to assign the launched Notepad app

• baseTime = Variable that stores the start time to calculate the elapsed time (Default: 0)

• elapsedTime = Variable to store the elapsed time

Used properties

• [Output] Output = this.elapsedTime

• BaseTime = this.startTime

Related/Similar activities

MessageBox

GetRegistryValue

GetRegistryValue

Overview

This activity card fetches the key value of the specified registry path.

Application procedures

1. In the [Output] Output field, enter the variable to store the registry key value.

2. Set the BaseKey property to select the registry root key.

3. In the KeyName field, enter the registry name.

4. In the ValueName field, enter the registry key value.

Card output properties

Card input properties

Example of utilization

Read the registry value at the specified path, return it to the “getRegistryValue” variable, and then output it in a message box.

Sample file

• Menu > Help > Sample > Sample > System > Edit Registry > P_GetRegistryValue_Test

Used variables

• getRegistryValue = Variable to store the fetched registry key value

Used properties

• [Output] Output = this.getRegistryValue

• BaseKey = CurrentConfig

• KeyName = 'Software\\Fonts'

• ValueName = 'Path'

Related/Similar activities

SetRegistryValue

SetRegistryValue

SetRegistryValue

Overview

This activity card enters a key value in the specified registry path.

Application procedures

1. Set the BaseKey property to select the registry root key.

2. Set the ValueKind property to select the registry key type.

3. In the KeyName field, enter the registry name.

4. In the ValueName field, enter the registry key value.

5. In the Value field, enter the registry data value.

Card properties

Example of utilization

Enter the registry key value in the specified registry path.

Sample file

• Menu > Help > Sample > Sample > System > Edit Registry > P_SetRegistryValue_Test

Used variables

• None

Used properties

• BaseKey = CurrentConfig

• ValueKind = String

• KeyName = 'Software\\Fonts'

• ValueName = 'Path'

• Value = 'C:\\Program Files\\7-Zip\\123\\'

Related/Similar activities

GetRegistryValue

MoveFile

MoveFile

Overview

This activity card moves a file to another directory.

Application procedures

1. In the SrcFilePath field, enter the path and file name of the source file to move.

2. In the DescFilePath field, enter a new path to save the moved file.

3. Set the Overwrite property to select whether to overwrite any existing file with the same name in the path.

Card properties

Example of utilization

Create a folder and a file, move the file to the specified folder, and delete the source folder.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_MoveFile_Test

Used variables

• None

Used properties

• SrcFilePath = 'C:\\IPA Test.txt'

• DescFilePath = 'C:\\MoveFileDesc\\IPA Test.txt'

• Overwrite = True

Related/Similar activities

CopyFile, DeleteFile, CloseFile

RenameFile

RenameFile

Overview

This activity card renames the specified file.

Application procedures

1. In the NewName field, enter the new name for the file.

2. In the SrcFilePath field, enter the path and file name of the target file to rename.

Card properties

Example of utilization

Create a new file and rename the file.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_Rename_Test

Used variables

• None

Used properties

• NewName = 'IPA Test_Rename.txt'

• SrcFilePath = 'C:\\IPA Test.txt'

Related/Similar activities

CreateFile

DBConnection

DBConnection

Overview

This activity card creates a connection to a database, such as MsSQL or Oracle.

Application procedures

1. In the [Output] DataSource field, enter the variable to store the data source information.

2. In the [Output] Connection field, enter the variable to store the connection information.

3. Set the DSN property to select a DSN to connect.

4. Set the SourceType property to select the data source type.

5. Set the Source property to select the data source.

Card properties

Example of utilization

Connect to a database and store the connection information and the data source information in variables.

Sample file

• Menu > Help > Sample > Sample > System > DBLibrary > MSSQL

Used variables

• sourceinfo = Variable to store the data source information

• connection = Variable to store the connection information

Used properties

• [Output] DataSource = this.sourceinfo

• [Output] Connection = this.connection

• DSN = MS Access Database

• UID = 'ibscity'

• PWD = ****** (Secure)

• SourceType = TABLE

Related/Similar activities

GetDBData, UpdateDBData, SendDBCommand

GetDBData

GetDBData

Overview

This activity card fetches data within the specific field of the connected DB.

Application procedures

1. In the [Output] Output field, enter the variable to store the fetched field data.

2. In the [Input] Connection field, enter the variable for the connection information of the database to connect.

3. In the [Input] DataSource field, enter the variable for the data source of the connected database.

4. Set the UseSource property to specify whether to use the data source.

Card properties

Example of utilization

Fetch the data in the specific field of the connected DB and store it in a variable.

Sample file

• Menu > Help > Sample > Sample > System > DBLibrary > MSSQL

Used variables

• data = Variable to store the fetched field data

• sourceinfo = Variable that stores the data source information

• connection = Variable that stores the connection information

Used properties

• [Output] Output = this.data

• [Input] Connection = this.connection

• [Output] DataSource = this.sourceinfo

• UseSource = On

Related/Similar activities

DBConnection, UpdateDBData, SendDBCommand

UpdateDBData

UpdateDBData

Overview

This activity card updates specific field of the connected DB.

Application procedures

1. In the [Output] Output field, enter the variable to store the result of the data update.

2. In the [Input] Input field, enter the target field to update.

3. In the [Input] Connection field, enter the variable for the connection information of the database to update.

4. In the [Input] DataSource field, enter the variable for the data source of the database to update.

Card properties

Example of utilization

Update the specific field of the connected database with new data.

Sample file

• Menu > Help > Sample > Sample > System > DBLibrary > MSSQL

Used variables

• data = Variable that stores the field data

• connection = Variable that stores the connection information

• sourceinfo = Variable that stores the data source information

• data2 = Variable to store the result of field data update

Used properties

• [Output] Output = this.data2

• [Input] DataSource = this.sourceinfo

• [Input] Connection = this.connection

• [Input] Input = this.data

Related/Similar activities

DBConnection, GetDBData, SendDBCommand

SendDBCommand

SendDBCommand

Overview

This activity card executes a specific query on the connected database.

Application procedures

1. In the [Output] Output field, enter the variable to store the result of the executed query.

2. In the [Input] Connection field, enter the variable for the database to connect.

3. In the Command field, enter the query command that will be executed on the connected database.

Card properties

Example of utilization

Execute a query to view the table information on the connected database. Then, store the searched result in the “data3” and output it in a message box.

Sample file

• Menu > Help > Sample > Sample > System > DBLibrary > MSSQL

Used variables

• data = Variable that stores the field data

• connection = Variable that stores the connection information

• sourceinfo = Variable that stores the data source information

• data3 = Variable to store the result of executed query

Used properties

• [Output] Output = this.data3

• [Input] Connection = this.connection

• Command = 'SELECT*FROM AA'

Related/Similar activities

DBConnection, GetDBData, UpdateDBData

Zip

Zip

Overview

This activity card compresses a specified folder or file.

Application procedures

1. In the SrcFilePath field, enter the path of the file to compress.

2. In the SrcDirPath field, enter the source folder to compress.

3. In the DestDirPath field, enter the path to save the compressed file.

4. Set the DirectoryOrFile property whether the compressed target is a folder or a file

5. If the compression target is a file, set whether to include the parent directory name in the IncludeDirectoryPath property

6. Set the MaxMegaBytes property to specify the size limit for the file compression.

Card properties

Example of utilization

Compress the “C:\\IPA_SAMPLE” folder.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_ZipUnZip_Test

Used variables

• None

Used properties

• [Folder Compression]

• SrcDirPath = 'C\\IPA_SAMPLE'

• DestDirPath = 'C:\\'

• MaxMegaBytes = 100

• DirectoryOrFile = Directory

• Overwrite = On

• [File Compression]

• SrcFilePath = 'C\\SampleTest.pdf'

• DestDirPath = 'C:\\'

• MaxMegaBytes = 100

• DirectoryOrFile = File

• IncludeDirectoryPath = Off

• Overwrite = On

Related/Similar activities

UnZip

UnZip

UnZip

Overview

This activity card decompresses the specific compressed file.

Application procedures

1. In the SrcDirPath field, enter the path for the compressed file to decompress.

2. In the DestDirPath field, enter the target path to decompress the compressed file.

Card properties

Example of utilization

Decompress the “IPA_SAMPLE.zip” file in the “C:\\” directory into the “C:\\IPA_SAMPLE” directory.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_ZipUnZip_Test

Used variables

• None

Used properties

• SrcDirPath = 'C\\IPA_SAMPLE.zip'

• DestDirPath = 'C:\\IPA_SAMPLE'

• Overwrite = True

• MakeDirectory = True

Related/Similar activities

Zip

IsFileLock

IsFileLock

Overview

This activity card verifies whether the specified file is currently locked after being executed in another process.

Application procedures

1. In the [Output] Output field, enter the variable to store the result of the lock status verification.

2. In the Path field, enter the path for the file to verify the lock (execution) status.

Card properties

Example of utilization

Create a new Excel file, verify if the file is currently being executed, and then output the verification result in a message box.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > IsFileLock_Test

Used variables

• hExcel = Variable to assign the opened Excel document

Used properties

• [Output] Output = RESULT

• Path = 'C:\\1.xlsx'

Related/Similar activities

IsFileExist, WaitFileUnlock

WaitFileUnLock

WaitFileUnLock

Overview

This activity card waits for the specified, currently running file to close.

Application procedures

1. In the Timeout(Sec) field, enter the delay time to wait.

2. In the Path field, enter the path and name of the file to wait for the closing.

Card properties

Example of utilization

Create a new Excel file, and open the file, and wait for the specified time until the file is closed. Then, verify if the file has been closed and output the result in a message box.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_WaitFileUnlock_Test

Used variables

• excel: Variable to assign the opened Excel document

Used properties

• [Output] Output = RESULT

• Timeout(Sec) = 10

• Path = 'C:\\BrityWorksTestExcel.xlsx'

Related/Similar activities

WaitFileCreation, WaitFileDelete

WaitFileCreation

WaitFileCreation

Overview

This activity card waits until the specified file is created.

Application procedures

1. In the Timeout(Sec) field, enter the delay time to wait.

2. In the Path field, enter the path and name of the file to wait for the creation.

Card properties

Example of utilization

Wait for the specified time until the new Excel file is created. Then, verify if the file has been created and output the result in a message box.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_WaitFileCreation_Test

Used variables

• excel: Variable to assign the opened Excel document

Used properties

• [Output] Output = RESULT

• Timeout(Sec) = 5

• File Size(KB) = 0

• Path = 'C:\\BrityWorksTestExcel.xlsx'

Related/Similar activities

WaitFileUnlock, WaitFileDelete

WaitFileDelete

WaitFileDelete

Overview

This activity card waits until the specified file is deleted.

Application procedures

1. In the Timeout(Sec) field, enter the delay time to wait.

2. In the Path field, enter the path and name of the file to wait for the deletion.

Card properties

Example of utilization

Wait for the specified time until the new Excel file is deleted. Then, verify if the file has been deleted and output the result in a message box.

Sample file

• Menu > Help > Sample > Sample > System > Manage File > P_WaitFileDelete_Test

Used variables

• None

Used properties

• Timeout(Sec) = 10

• Path = 'C:\\BrityWorksTestExcel.xlsx'

Related/Similar activities

WaitFileCreation, WaitFileUnLock

GetWindowsCredential

GetWindowsCredential

Overview

This activity card gets the Windows generic credentials.

Application procedures

1. In the Target Credential field, enter the name of your Windows common credentials.

2. In the Property Name field, select the property name for the target credential on.

Card properties

Example of utilization

Reads the email with the specified Windows credential information (user name, password) and prints the result to the message box.

Sample file

• 메뉴 > 도움말 > 샘플 > Sample > System > Credential > P_GetWindowsCredential_Test

Used variables

• username : Windows 일반 자격 증명의 사용자명을 저장할 변수

• pwd : Windows 일반 자격 증명의 암호를 저장할 변수

Used properties

• Target Credential = 'MyMail'

• Property Name = Username

Related/Similar activities

IsWindowsCredentialExist, SetWindowsCredential, GetWindowsCredential, RemoveWindowsCredential

SetWindowsCredential

SetWindowsCredential

Overview

This activity card registers windows common credentials.

Application procedures

1. In the Target Credential field, enter the name of your Windows common credential.

2. In the Username field, enter the username for the target identity.

3. In the Password field, enter the password for the target credential.

Card properties

Example of utilization

Registers the specified Windows credential information (user name, password) to the system.

Sample file

• Menu > Help > Sample > Sample > System > Credential > P_SetWindowsCredential_Test

Used variables

• target: A variable to store the name of a Windows common credential

• username: A variable to store the user name of the Windows normal credential

Used properties

• Target Credential = this.target

• Username = this.username

• Password = 'xxxxxx'

Related/Similar activities

RemoveWindowsCredential, IsWindowsCredentialExist, GetWindowsCredentialList, GetWindowsCredential

IsWindowsCredentialExist

IsWindowsCredentialExist

Overview

This activity card verifies that windows common credentials exists.

Application procedures

1. In the [Output] field, enter the variable that stores whether Windows credential information exists in Output.

2. In the Target Credential field, enter the name of your Windows common credential.

Card properties

Example of utilization

Reads whether the specified Windows credentials exist on the system and outputs them to a message box.

Sample file

• Menu > Help > Sample > Sample > System > Credential > P_IsWindowsCredentialExist_Test

Used variables

• RESULT: A variable that stores whether Windows credentials exist or not

Used properties

• Output = RESULT

• Target Credential = 'test'

Related/Similar activities

GetWindowsCredentialList, RemoveWindowsCredential, GetWindowsCredential, SetWindowsCredential

GetWindowsCredentialList

GetWindowsCredentialList

Overview

This activity card gets a list of Windows common credentials.

Application procedures

1. In the Output field, enter a variable to store the list of Windows credentials.

Card properties

Example of utilization

Read the list of Windows credential information and output it to the message box.

Sample file

• Menu > Help > Sample > Sample > System > Credential > P_GetWindowsCredentialList_Test

Used variables

• RESULT: Variable to store the list of Windows generic credentials

Used properties

• Output = RESULT

Related/Similar activities

GetWindowsCredential, RemoveWindowsCredential, SetWindowsCredential

RemoveWindowsCredential

RemoveWindowsCredential

Overview

This activity card deletes the Windows Common Credentials.

Application procedures

1. In the Target Credential field, enter the name of the Windows credential you want to delete.

Card properties

Example of utilization

Registers the two specified Windows credentials and prints the list to a message box. Delete one of the two registered Windows credentials, Hannah, and then print the list to the message box.

Sample file

• Menu > Help > Sample > Sample > System > Credential > P_RemoveWindowsCredential_Test

Used properties

• Target Credential = 'test2'

Related/Similar activities

GetWindowsCredentialList, SetWindowsCredential, IsWindowsCredentialExist

Encrypt

Encrypt

Overview

Encrypt a plain string or file. If it is already encrypted, no further encryption is performed. Encrypting a file can take several minutes or more, depending on the size of the file.

Application procedures

1. In the DataType field, select the type of data you want to encrypt.

2. In the Crypto Password field, enter the password you want to use for encryption. You must use the same password for decryption.

3. In the String field, enter a generic string you want to encrypt. Use when DataType is String.

4. In the FilePath field, enter the path to the original file you want to encrypt. Use when DataType is File.

5. Enter the destination file path in the Target FilePath field to save the encrypted result. Use when DataType is File.

Encryption rules

Card properties

Example of utilization

Encrypts the specified generic string and general file and displays the result as a user message box.

Sample file

• Menu > Learning > Running Samples > Samples > System > System_Crypto

Used variables

• encrypted: Variables to store encrypted results

• decrypted: Variables to store decrypted results

Used properties

• DataType = 'String' or 'File'

• String = 'hello'

• FilePath = 'c:\\normal.txt'

• Target FilePath = 'c:\\normal.txt.e'

연관/유사 액티비티

Decrypt

Decrypt

Decrypt

Overview

Decrypt an encrypted string or file. If it has already been decrypted, no further decryption is performed. Decrypting a file can take several minutes or more, depending on the file size.

Application procedures

1. In the DataType field, select the type of data you want to decrypt

2. In the Crypto Password field, enter the password you want to use for decryption. You must use the same password for encryption.

3. In the String field, enter a regular string you want to decrypt. Use when DataType is String.

4. In the FilePath field, enter the path to the original file you want to decrypt. Use when DataType is File.

5. Enter the target file path to save the decrypted result in the Target FilePath field. Use when DataType is File.

복호화 규칙

Card properties

Example of utilization

Decrypts the specified encrypted string and file, and displays the result as a user message box.

Sample file

• 메뉴 > 학습 > 샘플 실행하기 > samples > System > System_Crypto

Used variables

• encrypted : 암호화 된 결과를 저장할 변수

• decrypted : 복호화 된 결과를 저장할 변수

Used properties

• DataType = 'String' or 'File'

• String = this.encrypted

• FilePath = this.encrypted

• Target FilePath = 'c:\\normal.d.txt'

연관/유사 액티비티

Encrypt