RPA Developer

This will accept in_FromDate and in_ToDate as input arguments and provide a out_DateRangeArray as output argument.Input arguments in_FromDate and in_ToDate should be entered in yyyy-MM-dd format.

This component will generate a list of dates for a given scope.

Foxit’s PhantomPDF empowers knowledge workers to build superior PDF documents by providing a full solution that allows users to create better documents and then manage them after publishing. This solution is available in an affordable and easy to use desktop application.

e5cb883b-11bc-40e8-989b-d685d00d75f4.png

Product Strategy Manager

This snippet is intended to redact, i.e. cover up, a given input string in a given PDF file. Optionally, the redacted text can be covered with overlay text (i.e. to justify the reason for the redaction). All of this is handled in the Foxit PhantomPDF Business software.Arguments<ul><li>selectedFile: Path to the file to be redacted</li><li>redactString: String to be redacted</li><li>overlay_text (Optional): String to be used as overlay on redacted text</li></ul>This sequence will automatically save the redacted file and close PhantomPDF after completion. Please note that redacted text cannot be recovered under any circumstances! So make sure that this is what you want, or that you have a separate unredacted copy of the file.

Activity for redacting a given string and optionally adding overlay text for PDF files using Foxit PhantomPDF Business

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.

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

RPA Senior RPA Developer/Technical Lead

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.

RPA Project Manager

It will wait until the command is completed even if it takes more time.This activity runs in the background and will not affect other running command-line process; thus, it can also be used for multithreaded implementation as it can optimize their efficiency.Arguments:<ul><li>in_CommandDirectory (String) - current directory of the command line.</li><li>in_CommandString (String) - a string of command for running. e.g. "ipconfig".</li><li>out_OutputString (String) - output from command line.</li></ul>

This workflow will run a code in the command line and return its output.

Software Development Engineer

The input argument is the folder path, ext. The two output arguments provide the total files count and the files list available in the given folder.You can just input the file, enter the file type as *.txt for example and add the folder path. The result is the list of text files available in the imputed folder path and the total number of files.Arguments:In Type<ul><li>in_FolderPath - The input path as a string</li><li>in_FilesType - Type of file or document i.e., .xlsx, .doc, .pdf, etc.</li></ul>Syntax for in_FilesType:<ul><li>single type files {"*.txt"}</li><li>multiple type files {"*.txt","*.xlsx"}</li></ul>Out Type<ul><li>out_FilesCount - Gives the number of files</li><li>out_FileNames - Gives the list of files</li></ul>Please note that the Search pattern must stick to the following rule:{"*.xlsx", "*.doc", "*.pdf"}etc. otherwise, the snippet will return no result.

Get the file list and the total count of files available in the input folder.

There are two options:(1) Copy all files from a directory to anotherInputs:<ul><li>in_TerminalFolder - Full path of the terminal folder. It is of type String. It will be used to get all file paths inside it.</li><li>in_DestinationFolder&nbsp;- Full path of the destination folder. It is of type String.</li><li>in_BoolOverwrite - Option if you want to overwrite files or not. It is of type Boolean.</li><li>in_FileList - Should not be set. If set, it will be overwritten by files from in_TerminalFolder.</li></ul>(2) Copy files from different directories to a destination folderInputs:<ul><li>in_FileList&nbsp;- List of files to be moved to the destination folder. It is of type String[].</li><li>in_DestinationFolder&nbsp;- Full path of the destination folder. It is of type String.</li><li>in_BoolOverwrite - Option if you want to overwrite files or not. It is of type Boolean.</li><li>in_TerminalFolder - Should not be set. If set, option 1 will be executed.</li></ul>

.NEt Developer / RPA Developer

Assign the desired path of the file and the output of the desired destination.Input:<ul><li>in_StrFilePath -Set the desired file path.</li></ul>Outputs:<ul><li>out_GetFileName - Get the file name;</li><li>out_GetFileType - Get the filet type;</li><li>out_GetDirectoryName - Get the directory name of the file;</li><li>out_GetFullPath- Get the full path of the file;</li><li>out_GetFileSize - Get the file size;</li><li>out_CsvFile - Save the details of the file.</li></ul>Benefits:&nbsp;<ul><li>Easily reads the details of the file and saves it to a text file.</li></ul>

Visionet is a premier technology solutions and business process management company. We provide strategic business value to an extensive and impressive list of marquee customers across a variety of industries. Visionet delivers high-impact strategies, techniques, and technologies that help our clients compete, win, and sustain growth in a hyper-competitive, digitally disruptive market. The success of our clients and delivering value to the parties they serve is our number-one goal.

478b67df-f0a1-421e-92d0-20d3525c39fb.png

Automation Engineer

This component is very useful when parsing single or multiple USA address entries into individual fields by following the steps:Check for any special mailing addresses containing PO Boxes, Rural Routes, Apartments, or Suites.Using a Regex pattern, it validates these and stores the values for the current address.Checks if a name is associated with the address.If so, it will retrieve and move it to the final step.Retrieve the Street, State, City, and Zip Code.At the end of the current address being parsed, the following outputs will be available:<ul><li>Name</li><li>Street</li><li>State</li><li>Zip</li><li>Po-box</li><li>Suite</li><li>Apt</li><li>Rural Route</li></ul>Known Inputs:This component can parse common addresses like Street, Avenue, Boulevard, Way, Road, and Drive while also being able to parse addresses with Drachman, Dragram, and addresses with no street available.Examples:<ul><li>90 Park Ave 20th floor, New York, NY 10016, USA</li><li>10900 NE 8th St Floor 4, Bellevue, WA 98004</li><li>PO Box 453 RR66 Olathe KS 66061</li><li>Mini Mart Express 435 E Drachman Tuscon AZ 58747-8756</li><li>John Smith 300 Boylston Ave E Seattle WA 98102</li></ul>Arguments:In/Out: inOut_fullAddressOut:<ul><li>out_street</li><li>out_city</li><li>out_state</li><li>out_zip</li><li>out_pobox</li><li>out_suite</li><li>out_apt</li><li>out_RR</li><li>out_name</li></ul>

A workflow that processes USA addresses regardless if they contain names and parses/splits them into individual fields.

Tools & Automation Technologist

This solution provides the step by step process to establish a connection between UiPath Studio and Oracle Database. It includes a onetime driver setup and the explanation that facilitates your connection with the database and develop queries.

Oracle Database and UiPath Studio integration solution

CFGI is a unique and highly specialized financial consulting firm that is strategically positioned to help companies through a range of routine and complex business scenarios. As an extension of your corporate finance team, CFGI works alongside your internal staff, serving in a variety of roles – from technical accounting advisor to M&amp;A support to Controller or CFO – and delivering seamless support services.

9fb70348-8a13-4fe6-b2f1-b620cfc3ce02.JPG

Lead RPA Developer

This workflow extracts text between two specified values (characters, words, etc.) from an input string.You will be able to specify which occurrence from the input string you want to extract (1st, 2nd, etc.)

This snippet uses RegEx to extract text between two specified values in a string.

Senior Software Engineer

Renaming an Excel Sheet is one of the most common functionalities that we come across in most RPA implementations. This Snippet allows you to do this without using hotkeys.<ul><li>It uses vb.net code via invoke code activity.</li><li>It can be integrated easily with any project across different customers without any modification.</li><li>It works very well without any change in code.</li><li>It can be run standalone or it can be integrated with any project.</li></ul>

Developing and implementing advanced AI-enabled automation. We bring together the catalytic forces of advanced machine learning and technology, along with subject matter expertise and executional capabilities, to progressively transform organizations and unlock enormous financial and business value.

3ccb2431-7bc8-4bd9-9c78-7e7032924f8e.PNG

Afterwards, emails the extracted text to the team and executes the processing Python code which calculates the total number of words, lines, characters and most common words.

Takes PDFs files as input, extracts text from these files and applies cutting edge analytics

Software Consultant

Calculate the Sum of Excel colored cells in any given range

クラウド技術活用を主としたコンサルティング及びソリューションサービス事業

b3ba5508-bad8-4be1-9c8d-dab8a0e027b2.png

一般社員

＜はじめに＞セルの操作を行う Excel VBA マクロ集 (10 本) は以下のことができます。【書式の操作】<ul><li>範囲に罫線をひく</li><li>範囲に背景色をつける</li><li>範囲の文字色をかえる</li><li>範囲を太文字にする</li><li>範囲を斜体にする</li><li>列に縞模様をつける</li><li>行に縞模様をつける</li></ul>【結合と分割】<ul><li>範囲を結合する</li><li>結合したセルを分割する</li></ul>【行の挿入】<ul><li>一行づつ空白行を挿入する</li></ul>※この他にも Excel VBA マクロで「こんなことがしたい！」というご要望があれば教えて下さい。追加いたします。※ご利用にあたってはワークフロー内に記載してあります。

UiPath 既存のアクティビティではできない、Excel のセル操作を VBA マクロを読むだけで自動化できます。

業務プロセスコンサルティング、システム企画・開発、システム運用・保守、&nbsp;パッケージソフト導入及び保守運用、インフラ設計構築、クラウドサービス、&nbsp;ICTアウトソーシング、エネルギーアウトソーシング、セールスアウトソーシング、&nbsp;WEBアナリティクスサービス、バックオフィス支援、カスタマーサポート支援&nbsp;

ffd960f8-51e3-4bb6-b813-0581b89d4fb2.png

1868年（明治1年）から 2038年（令和20年）に対応する西暦を和暦に変換できます。契約日や生年月日などの変換に使用することができます。

西暦を和暦に変換することができます。和暦「令和」にも対応しています。

Generate Dates Range…

Foxit - PhantomPDF Redaction - Unattended…

Essilor - RoboTalk…

Get Output from Command Line…

Get a List of Multiple File Types…

Essilor - Copy Files…

Essilor - Get File Details…

Visionet - USA Address Parser…

Oracle Database Connectivity with UiPath…

RegEx - Extract Text Between Values…

Rename Worksheet…

Zenon - Analytics Wizard…

Calculate Sum of Colored Cells in Excel Sheet…

ARI - セルの操作を行う Excel VBA マクロ集 (10 本) と実行スニペット…

パーソルのRPA - (西暦→和暦)令和への変換も可能！和暦への変換パーツ…

Help

How To