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&nbsp;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.

RPA Developer

To run this snippet just assign the path of the CSV file and the component will read and convert it to Excel and add the headers.Input:<ul><li>in_StrFilePath - Assign the folder path where the CSV file will be read.</li></ul>Output:<ul><li>out_ExcelOutPut - Assign the Excel file path.</li></ul>

This snippet converts a CSV file to Excel and adds headers

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

.NEt Developer / RPA Developer

Simple yet useful Snippet. Thank you, Patty.

Assign the Excel File and the component will read all the values and convert it to a CSV File:Inputs:<ul><li>In_FileExcelStr - Assign the value of the Excel File Path.</li><li>In_FileCSVStr- Assign the value of the CSV File Path .</li></ul>Variables:<ul><li>DtExcelOutPut- The output of the Excel value that was read and convert it to Data Table.</li><li>isPathExist - Check if the Excel file path exists or not.</li></ul>

Reads the Excel file and converts it to a CSV File

Simple yet useful...Thanks for sharing :)

It has two (2) inputs:<ul><li>in_DestinationFolder - Full path of the destination folder. It is of type String.</li><li>in_FileList - List of files to be moved to the destination folder. It is of type String[].</li></ul>The files can be on different directories.

This component will move multiple files at once.

RPA Senior RPA Developer/Technical Lead

Easy to integrate - This is a useful one. I do not need to create a component like this in my next projects because it is already here in Go!


Nicely done component - I never knew that the code for moving multiple files is as short and clean as this one.
Nice technique and logic. Compared to other 'move files' components, this component can handle files from different directories.
Awesome job!


List of ComputerInfo options below:<ul><li>AvailablePhysicalMemory - Gets the total amount of free physical memory for the computer.</li><li>AvailableVirtualMemory - Gets the total amount of the computer's free virtual address space.</li><li>InstalledUICulture - Gets the current UI culture installed with the operating system.</li><li>OSFullName - Gets the full operating system name.</li><li>OSPlatform - Gets the platform identifier for the operating system of the computer.</li><li>OSVersion - Gets the version of the computer's operating system.</li><li>TotalPhysicalMemory - Gets the total amount of physical memory for the computer.</li><li>TotalVirtualMemory - Gets the total amount of virtual address space available for the computer.</li></ul>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.

System information - I've tried it just because it sounded pretty cool and I've seen that it works. I can see how it could be useful though, in case you need to get the specs of the current machine and see if you can run the process (e.g: for compute intensive machine learning models). Curious to see you expanding it to other connected devices (such as the GPU details etc).


Nice and easy way to access system info - Works perfectly.. Simple and easy to use. It also captures a whole bunch of information which is great. Could be useful in many scenarios.. I'm already using it to get some of my things done.. Great work!!!


The details are listed below:<ul><li>Computer Name</li><li>Operating System</li><li>Locale</li><li>Current Time Zone</li><li>Offset from UTC</li><li>DST In Effect</li><li>CPU</li><li>Physical Memory</li><li>Video Card</li><li>Network Adapter</li><li>MAC Address</li><li>DHCP Enabled</li><li>IP Address</li><li>Subnet Mask</li><li>Default Gateway</li><li>DHCP Servers</li><li>DNS Server</li><li>WINS Primary Server</li><li>WINS Secondary Server</li><li>Computer</li><li>BIOS Version</li><li>UUID</li></ul>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

Cool Snippet, Easy and Performant - This snippet does a SHA1 encrypten operation. It is easy to integrate and to understand and it is performant. Thanks for this snippet.


(1) Create a JsonFile and save it to the directory folder and read the components.Inputs:<ul><li>in_filePath - Get the directory path of the jsonFile</li></ul>Output:<ul><li>out_hasErrors- If any error is detected by the components, the value will be set to True</li><li>out_jsonObject- It will return the JsonObject</li></ul>

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.

Do we have the required length of the string ?

When creating workflows, you can use this as the blueprint so that there is uniformity in all project workflows.

A simple component template which you can use as blueprint 

Very user friendly and really useful for auditing - It's one of the best workflow templates I have ever seen. It provides great deal of information in audit logs which makes it really easy to track what is happening during the execution. All the information captured really helps in debugging issues because most of the information is already available in the logs.
Additionally, this structure is the best for a workflow. If we can use this in every workflow in our projects, it really makes a difference in the coding standard. I also have to mention that it is quite user friendly and with couple of simple configurations, you are ready to plug and play..
Its some awesome work Despi... Glad to see such a solution. It helps me a lot to make my projects standardized.
Looking forward to see more from you


Very useful workflow! - Nicely done! keep up the great work! 


Very Useful for beginners - Its very usefulfor us and especially for beginners. By using this, we can easily understand the process which is developed by others as we are clearly specifying Pre and post condition for every activity and also we are writing annotations.


very useful for beginners - Its very useful, especially for beginners. I specially liked
check Out argument
sequence because many guys do such type of mistake frequently.
great work Despi ...keep it up


Useful component especially when we would like to have a uniform code across our organization

Really helpful template. Awesome work here Despi. :) 

About Us

Essilor - Convert CSV to Excel with Headers…

Essilor - Convert Excel to CSV…

Essilor - Move Multiple Files…

Essilor - Get Computer Information…

Essilor - Get Computer/System Details…

Essilor - SHA1 Encrypt String…

Essilor - Read Json File…

Essilor - RoboTalk…

Essilor - Reusable Component Template…

Help

How To