Essilor Shared Services Philippines, Inc. (ESSPI) is a Global IT and Finance Shared Services organization located in the Philippines in Southeast Asia (Philippines, known as one of the matured shared services hub in the world). We are CMMI level 3-certified for both Development and Services, supporting global locations on a 24/7 capability (ITIL based discipline). We were established in 2003, serving the Essilor Group around the world. We are capable in handling quick ramp-up to support additional services.

aa1ed20f-e4a9-44c0-bb81-204a939692b7.jpg

RPA Developer

RPA Senior RPA Developer/Technical Lead

It has two (2) inputs:

*   **in\_DestinationFolder** - Full path of the destination folder. It is of type String.
*   **in\_FileList** - List of files to be moved to the destination folder. It is of type String\[\].

The files can be on different directories.

This component will move multiple files at once.

List of ComputerInfo options below:

*   **AvailablePhysicalMemory -** Gets the total amount of free physical memory for the computer.
*   **AvailableVirtualMemory -** Gets the total amount of the computer's free virtual address space.
*   **InstalledUICulture -** Gets the current UI culture installed with the operating system.
*   **OSFullName -** Gets the full operating system name.
*   **OSPlatform -** Gets the platform identifier for the operating system of the computer.
*   **OSVersion -** Gets the version of the computer's operating system.
*   **TotalPhysicalMemory -** Gets the total amount of physical memory for the computer.
*   **TotalVirtualMemory -** Gets the total amount of virtual address space available for the computer.

The component will return a Dictionary variable containing all the computer properties above.

This snippet provides properties for getting information about the computer's memory, loaded assemblies, name, and operating system.

The details are listed below:

*   **Computer Name**
*   **Operating System**
*   **Locale**
*   **Current Time Zone**
*   **Offset from UTC**
*   **DST In Effect**
*   **CPU**
*   **Physical Memory**
*   **Video Card**
*   **Network Adapter**
*   **MAC Address**
*   **DHCP Enabled**
*   **IP Address**
*   **Subnet Mask**
*   **Default Gateway**
*   **DHCP Servers**
*   **DNS Server**
*   **WINS Primary Server**
*   **WINS Secondary Server**
*   **Computer**
*   **BIOS Version**
*   **UUID**

All the above information in Bold are the inputs that can be used.

**Disclaimer**: It can happen that some of the information cannot be extracted from your system.

The component will return a Dictionary (String, String) containing all the information above.

The user should check if the Dictionary contains the key first in order to make sure that an error is not thrown.

This component helps you extract your computer's system details

This snippet will help you encrypt strings, converting them to SHA1.

This component will encrypt your String to a SHA1

.NEt Developer / RPA Developer

(1) Create a JsonFile and save it to the directory folder and read the components.

Inputs:

*   **in\_filePath** - Get the directory path of the jsonFile

Output:

*   **out\_hasErrors**\- If any error is detected by the components, the value will be set to True
*   **out\_jsonObject**\- It will return the JsonObject

Read the Json file and return it as Object

**This component allows your robot to talk.**

It only requires one In argument:

In\_StrSpeech: Type String. The string that you want your robot to say.

The snippet is designed for English language only.

It requires 5 In arguments:

1\. **ExcelFilePath** - Excel file path that will be used.

2\. **SheetName** - Sheet name of the Excel file to be used. 

3\. **SearchColumn** - Column where the search/lookup will be executed.

4\. **ResultColumn** - Column where the Lookup result will be extracted.

5\. **LookupValue** - Value to be searched in SearchColumn.

It has 2 Out arguments:

1\. **LookupResult** - The result of the component. Default value is Nothing.

2\. **IsFound** - Boolean. True if LookupResult is not Nothing. Default value is False.

This component acts the same way as the Excel VLookup function

There are two options:

**(1) Copy all files from a directory to another**

Inputs:

*   **in\_TerminalFolder -** Full path of the terminal folder. It is of type String. It will be used to get all file paths inside it.
*   **in\_DestinationFolder** - Full path of the destination folder. It is of type String.
*   **in\_BoolOverwrite** - Option if you want to overwrite files or not. It is of type Boolean.
*   **in\_FileList** \- Should not be set. If set, it will be overwritten by files from in\_TerminalFolder.

**(2) Copy files from different directories to a destination folder**

Inputs:

*   **in\_FileList** - List of files to be moved to the destination folder. It is of type String\[\].
*   **in\_DestinationFolder** - Full path of the destination folder. It is of type String.
*   **in\_BoolOverwrite** - Option if you want to overwrite files or not. It is of type Boolean.
*   **in\_TerminalFolder -** Should not be set. If set, option 1 will be executed.

Assign the desired path of the file and the output of the desired destination.

**Input:**

*   in\_StrFilePath -Set the desired file path.

**Outputs:**

*   out\_GetFileName - Get the file name;
*   out\_GetFileType - Get the filet type;
*   out\_GetDirectoryName - Get the directory name of the file;
*   out\_GetFullPath- Get the full path of the file;
*   out\_GetFileSize - Get the file size;
*   out\_CsvFile - Save the details of the file.

**Benefits:** 

*   Easily reads the details of the file and saves it to a text file.