FPT Software is part of FPT Corporation (FPT – HoSE) – the global leading technology and IT services group headquartered in Vietnam with nearly US$1.2 billion in revenue and 28,000 employees. Qualified with CMMI Level 5 & ISO 27001:2013, ASPICE LEVEL 3, FPT Software delivers world-class services in Smart factory, Digital platform, RPA, AI, IoT, Enterprise Mobilization, Cloud, AR/VR, Embedded System, Managed service, Testing, Platform modernization, Business Applications, Application Service, BPO and more services globally from delivery centers across the United States, Japan, Europe, Australia, Vietnam and the Asia Pacific.

03d12680-8cf7-4189-a0ea-fd7e29d72ec9.jpg

RPA Innovation Department Manager

Input: 

*   dtInputData (DataTable variable)

Output: 

*   dicSelectionData (Dictionary(Of String, String() ) variable) with keys is the data of the first row in DataTable. And the value is the data from the 2nd row of the DataTable.
*   Options of the first select box are the keys of dictionary variable.
*   Options of the second select box are the values of the dictionary with key and the value of the first select box.

This snippet helps to create a dependent selection with a DataTable variable

Input:

*   dtInputData (DataTable 変数)

Output:

*   dicSelectionData (Dictionary(Of String, String() ) 変数): キーは DataTable の１番目行、データは２番目行以降のデータとなる。
*   １番目のセレクトボックスの選択肢は Dictionary のキー。
*   ２番目のセレクトボックスに１番目から選択したデータをキーとしてDictionaryのデータを表示する。

Datatable の変数データから依存選択を作成するスニペットです。

Unlike the default input dialog activity, this activity allows you to select multiple inputs via the multiple checkbox.

With only 3 simple inputs including lable of the form field, title of the input dialog and string array, you can display as an input dialog with many different options.

The result is that all checkbox values are selected by the user in the input dialog.

This package contains the custom input dialog with multiple checkbox activities. All components can be configured easily and are very user friendly

**Input:** 

*   Excel file that stores the settings for data transfer
*   Excel files that stores the source transfer data

**Output:**

*   Excel data was transfered and saved in the destination Excel file

**Assumption example:**

*   Transfer data from multiple Excel files to multiple output Excel files

This component can easily transfer multiple Excel data

**Converting Measurement Unit** 

  
 - After receiving Unit value and type, Conversion Anything will calculate and provide values of equivalent units in the same category within a short time.     
 - This package is able to provide 10 different categories of measurements.

  

**Converting Currencies**  
 - After receiving base currency, Conversion Anything will access European Central Bank’s server and return the lastest exchange rates for all available currencies.     
 - In case the bot requires Conversion Anything to provide exchange rates in a specific date, Conversion Anything will follow the requirement and return the exact historical rates that are needed.     
 - At the moment, this package can exchange among 30 strongest currencies in the world.

This package will calculate and provide values of equivalent units in the same category within a short time

**Input:**

*   Excel file store the query setting data.

**Output:**

*   The query to filter target DataTable in String format.

This snippet helps to build the query to filter DataTable variable by Linq

WebhookによるCURLで情報を送信するため、ロボットはWebサイトインターフェイス使用なしでTocaroにメッセージを送信できます

TocaroはWebブラウザやスマートフォンアプリを使用して、プロジェクトメンバー間でのグループチャットや1対1でのチャットを簡単に行うことができるビジネス向けコミュニケーションサービスです。 プロジェクトやチームでリアルタイムにタスクの進捗情報の共有が可能です このカスタマイズアクティビティで自動通知や報告などのためのプロセスを簡易に作成できる

This component uses VB.Net to open an Excel file then remove the filters.

  

There are many ways to do the same operation but VB.Net is more stable than using hotkey or Click activity to work with Excel application.

  

*   \`\`\`\`In argument:

1.  in\_FilePath (String): Excel file path
2.  in\_SheetName (String): Excel file name
3.  in\_Mode (String): there are 2 modes:

         - KeepAutoFilter: Remove all filter conditions but keep filter function on.

         - RemoveAutoFilter: Remove filter function

This component is used to remove the filters from an Excel file

This snippet does not create a draft mail in the draft folder in Outlook. It creates a .msg file with the full name passed in the argument.

  

**Input:**

*   Mail body: arg\_strMailBody (String)
*   Mail subject: arg\_strMailSubject (String)
*   Mail To: arg\_arrMailTo (Array Of String)
*   Mail Cc: arg\_arrMailCC (Array Of String)
*   Mail Bcc: arg\_arrMailBCC (Array Of String)
*   Mail Attachments: arg\_arrAttachFiles (Array Of String)
*   Draft Mail File Name: arg\_strDraftMailFile (String). If Empty, the draft file will be saved to the source code folder (yyyyMMdd HHmmss.msg).

**Output**

*   Success Flag: arg\_booSuccess (Boolean)

This snippet helps to create Outlook draft mail and save it as .msg file

This customized activity can be used to delete file system by using the options described below:

  

**\- Before Date**: Delete files that have the modified date after a specified date.

**\- After Date**: Delete the files with the modified date before the specified date.

**\- Per day**: Delete a file with modified date separated by a specified number of days from the current date.

**\- Delete SubFolder**: Search for files to delete in all subfolders.

**\- Delete Emply Folder**: After deleting all files, also delete that folder.

**\- File Type**: Finds and deletes only the files with specified types.

**\- File Name**: Find and delete only the files with specified names.

A customized activity used to delete file system with options