ADROSONIC is an innovative, business-focused Digital consulting firm/solution provider which focuses on developing advanced technological solutions and has emerged as a trusted partner for both service and product-based companies. Possessing competencies in the fields of Robotic Process Automation, Data Analytics, CRM services, Application Services, Digital Quality Assurance and Software Testing, ADROSONIC strives to pave the Digital Roadmap for traditional business organisations and emerging start-ups. Catering to domestic as well as overseas clients in the UK, USA, UAE and Singapore, ADROSONIC marks a global presence with its offices in India and UK.

b0e51f2b-413d-4dfd-803e-c9b0fe3e542d.png

RPA Lead Engineer

These custom Audit Logging activities have been developed with the view of being event listeners for every process that’s developed. This will help in making sure that the audit logs developed can be used for Auditing and compliance.Also, the logs, because of being in XML and JSON formats can be further uploaded or used by BI tools for analysis.It will create a log file in 2 formats – XML or JSON which is decided by the User in the dropdown provided for each activity.There are 2 activities in the Package:Append Audit Log Activity:<ul><li>This will append the Audit Log Message in an existing Audit Log File.</li><li>If the Audit Log file is not present, it will create a new one.</li></ul>Input Parameters:<ul><li>AuditLogType (select) – XML / JSON</li><li>FilePath (freetext) – Path at which the Audit Log will be stored.</li><li>Message Description (freetext) – Description of the Audit Log</li><li>Message Type (freetext) – Info / Warning / Error</li></ul>End Audit Log Activity:<ul><li>Only to be used if Log Type used for the project is in XML Format.</li><li>This audit log activity will close the Audit log XML.</li></ul>Input Parameters:<ul><li>FilePath (freetext) – Path at which the Audit Log will be stored.</li></ul>

Creating a Custom Audit Log in XML/JSON format and store it at a user specified location

Since 1993, we’ve relied on our Engineering DNA to underpin our work with clients, leading to major innovations, digital transformations and business results. In that time, we’ve expanded geographically, as well as extended our core engineering capabilities to include business consulting, design and physical product development. We’ve been at the forefront of some of the most exciting technology-led transformations in the industry, and our story continues into today’s modern age of agile delivery, big data, machine learning and AI.

90168eb1-f908-443f-916f-835c38dbf7a0.png

Delivery Manager

Activities for interacting with EPAM TelescopeAI platform via REST API. The main purpose is retrieving the data about organization’s projects and employees aggregated from various sources.

Cognizant (NASDAQ-100: CTSH) is one of the world’s leading professional services companies, transforming clients’ business, operating and technology models for the digital era.

9648b4f4-c1b4-4a06-ac7d-78a759cc6e99.jpg

An application connector workflow that helps to connect UiPath & Cognizant® Automation Center through web API’s to securely post output of an UiPath workflow to a Cognizant® Automation Center activity

We are a Digital Process Automation Company with Specialized expertise in Healthcare. Our primary forte is building Industry standard solutions which can be used by clients with no or minimal customization.

519f4e3c-e8e0-4f50-a895-57946afc341d.png

Automated Healthcare Provider Roster Processing Solution

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

Includes the following sequences for use with Foxit's PhantomPDF PDF creation and editing software.<ul><li>Redact a specific string from a directory of PDF documents</li><li>Redact strings matching one or more regular expressions from a directory of PDF documents</li><li>Convert PDF files from a directory into another format (PhantomPDF supports 10+ formats)</li><li>Batch import many sources of form data to a single PDF form</li><li>Apply a password to multiple PDF documents in a directory (attended, user enters each password)</li><li>Apply a password to multiple PDF documents in a directory (unattended, password is a variable in the sequence)</li><li>Search and replace text in multiple PDF documents in a directory</li><li>Batch add or remove web links to PDF documents in a directory</li></ul>Coming soon:<ul><li>Extract data from a flattened/scanned document using a PDF form as an example</li><li>Sign multiple pages of a document that have the same initial/signature prompt</li></ul>Contact us for more information on any of these sequences.

Various sequences to integrate Foxit PhantomPDF software with RPA workflows

This component is about building an automation for verifying the background details of a Business Entity Registered in the State of Florida, SunBiz, such as:<ul><li>Status</li><li>Registered Contact</li><li>Address</li><li>Name</li><li>Expiration Date</li><li>Registration Number</li></ul>

a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

Solution Development Consultant

株式会社オービックビジネスコンサルタントが提供する「勘定奉行クラウド」上での処理を、UiPath で自動化するための共通部品です。

The world we live in is changing at a rapid pace and this change, in turn, is creating huge demands for better technology solutions using the second machine age era of technologies such as Robotic Process Automation, Artificial Intelligence, OCR, IoT, etc.

Feat systems offer world-class end-to-end automation

solutions and services to give your business a significant boost and help you forge ahead in a highly competitive world.

Our experts use diverse technologies to create agile, responsive, feature-rich, and interactive automation solutions, helping you boost efficiencies and increase productivity along with enhancing your image.

2023cf66-699e-4440-9447-c47df47da0de.png

The activity calculates different basic physics formulas, such as:o&nbsp;&nbsp;&nbsp;Force - In physics, a force is any interaction that, when unopposed, will change the motion of an object.o&nbsp;&nbsp;&nbsp;Velocity - The velocity of an object is the rate of change of its position with respect to a frame of reference, and is a function of time.o&nbsp;&nbsp;&nbsp;Power - In physics, power is the rate of doing work or of transferring heat, i.e. the amount of energy transferred or converted per unit time.o&nbsp;&nbsp;&nbsp;Frequency - Frequency, in physics, the number of waves that pass a fixed point in unit time; also, the number of cycles or vibrations undergone during one unit of time by a body in periodic motion.o&nbsp;&nbsp;&nbsp;Angular frequency - Angular frequency (ω), also known as radial or circular frequency, measures angular displacement per unit time.o&nbsp;&nbsp;&nbsp;Weight - Weight as the force exerted on a body by gravity.o&nbsp;&nbsp;&nbsp;Density - Density is defined as the mass per unit volume.o&nbsp;&nbsp;&nbsp;Efficiency - Efficiency is a measure of how much work or energy is conserved in a process.o&nbsp;&nbsp;&nbsp;Speed - The speed of an object is the magnitude of its velocityo&nbsp;&nbsp;&nbsp;Pressure - Pressure is the force applied perpendicular to the surface of an object per unit area over which that force is distributed.

This activity is used in physics related calculations like Force, Velocity, Power, Frequency, Angular frequency, Weight, Density, Efficiency, Speed and Pressure

BOT mantra is a boutique Technology Services Firm focusing on Robotic Process Automation Technologies.

6d81c49f-2cd7-4405-80f5-20851d7e5158.jpg

CEO and Founder

RPA Code Insight is a proprietary solution from BOT mantra which enables auto-code reviews through its inbuilt review framework, providing detailed insights with suggestions to accomplish robust, efficient, maintainable and secured BOTs. This solution is meant to introspect the UiPath code itself and evaluate it on different aspects like readability, configurability, reliability, performance, and security.Characteristics:<ul><li>Both online and offline mode</li><li>In-built 50+ rules</li><li>Detailed report – both offline and online</li><li>On-premise deployment options available</li><li>RPA product-agnostic is currently released for UiPath</li></ul>Due to the lack of an automated code review approach, most of the enterprises are dependent on manual reviews. This often poses enterprise-level risks, longer stabilization time, impact on support cost, expected efficiency gains and finally impact on customer satisfaction. Insight Categories<ul><li>READABILITY - Ease of understanding the code by having elements like naming convention standards &amp; compliance, zero usage of junk code, adequate componentization, and simplified logic.</li><li>CONFIGURABILITY - Ease of managing changes and BOT calibration by including configurable parameters like performance parameters, URLs, Files &amp; folder paths, email Ids, credentials, business rule threshold parameters, log messages, email formats, etc. and generic design.</li><li>RELIABILITY – Accuracy degree with minimal exception rate through elements like exception handling, usage of interaction technique, memory leakage avoidance, and appropriately designed auto-recovery and auto-healing mechanisms.</li><li>SECURITY - Known and unknown threats are handled through policies and authorization &amp; authentication mechanism, credential management, business data storage, and sharing.</li><li>PERFORMANCE - Low average handling time by using efficient delay management, parallel execution, usage of optimal interaction technique, efficient memory management and efficient business logic configuration.</li></ul> Compliance Score - the code compliance level against each rule on a scale of 0 to 10, where 10 is the best score. While it provides us the quantitative measure of the code, it also helps us to define the severity of the observation on any rule. For each rule with a score of less than 10, an observation containing the following information provided:<ul><li>Observation message;</li><li>Observation severity;</li><li>Suggestions;</li><li>Corresponding non-compliant data.</li></ul>Raw Data is primarily used to validate the technical design and to conduct some qualitative checks on the code (if needed). These include:<ul><li>Workflow interaction diagram;</li><li>List of all variables;</li><li>List of all arguments;</li><li>List of all log messages;</li><li>List of all selectors.</li></ul>

Bring insights from various RPA product scripts to have Robust, Reliable and Standardised BOTs

Arria NLG is the global leader in the field of Natural Language Generation (NLG), a form of artificial intelligence specializing in extracting insights from complex data sources and communicating that information in easily understood natural language. The company owns, develops and licenses its technology through its Arria NLG Studio Platform. Based on advanced computational linguistics and algorithms, it ingests vast quantities of data, analysis it, draws conclusions, and instantly turns it into written (or spoken) words as if written by a human subject matter expert. The written reports, explanations and summaries it creates are custom tailored to the specific readers of the narratives. Combining Arria NLG’s platform with UiPath’s RPA automation bridges the communication gap between robots and humans, and streamlines the automation of knowledge processes. Now you can easily automate repetitive, time-consuming reports and analysis previously written by a human with the NLG activity for UiPath Studio.

21f623a0-89e4-44b3-8541-e1f91fc0e44a.png

Arria’s&nbsp;integration with&nbsp;UiPath&nbsp;makes it easy for&nbsp;UiPath&nbsp;Studio developers to add automated natural-language descriptions and reports to any workflow.&nbsp;For&nbsp;UiPath&nbsp;developers who want to leverage NLG in their automation tasks,&nbsp;Arria’s&nbsp;activities make it easy and straightforward.&nbsp;Arria’s&nbsp;activities are designed to accept either tabular data or JSON data, obtained from an upstream process, into Arria’s&nbsp;NLG Studio.&nbsp;Arria’s&nbsp;activities allow you to make HTTP requests to a published Studio project, which then returns a narrative to be consumed by the next&nbsp;UiPath&nbsp;activity.&nbsp;See the <a href="https://samples.arria.com/v1-uipath-rns/" target="_blank">Release Notes</a> for what’s new in version 1.2.0, and our&nbsp;<a href="https://samples.arria.com/v1-uipath/" target="_blank">documentation</a>&nbsp;for detailed information and guidance.

Arria Connect custom activities allow you to leverage Natural Language Generation (NLG) in your automation to generate written (or spoken) text, summaries or reports from the data in your workflow

TISは独立系のシステムインテグレーターとして、お客様の立場で最適なRPA製品の選定から導入、定着化サポートまでトータルにご支援いたします。また、幅広い業界・業務知識や大規模システム構築プロジェクトでの推進ナレッジをベースに、RPA導入によるお客様の目的達成に向けて、プロジェクトを成功に導きます。TISは、Orchestratorの販売実績が認められAwardを受賞したダイヤモンドパートナーです。

af9a7b55-85e3-4ca5-87ae-8b3a038e738f.png

AI-OCR 製品 (Tegaki) への API リクエスト実行から結果を Excel 出力するところまでを実装したワークフローです。

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

Senior Software Engineer

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

弊社 Cogent LabsはAIで生活の質を上げる未来を作ることをビジョンに、世界中から日本に集まったエキスパートが画像・文字認識、自然言語処理、時系列データ予測の3つの領域を中心に人工知能の研究開発を進め、それぞれの領域でプロダクトを提供しています。特に AI-OCR Tegakiは業界最高水準の手書き認識精度と豊富な導入実績を誇るサービスです。

2f911b96-e999-4db0-bae2-5ffde8d6465e.png

アライアンス営業部長

手書き帳票の読み取りを自動化する AI-OCR Tegaki の API 処理を UiPathで自動化できる標準コンポーネントです。

Software Consultant

Calculate the Sum of Excel colored cells in any given range

CIGNEX Datamatics, a subsidiary of Datamatics Global Services Ltd., is a Michigan based global consulting company offering solutions, services and platforms in Open Source, Cloud and Automation. Since 2000, CIGNEX Datamatics has been delivering enterprise class solutions based using leading platforms and tools that integrate with existing systems to achieve unparalleled results. By leveraging multiple delivery models, we help organizations around the world to increase revenue, achieve business goals, gain competitive advantage, and maximize customer satisfaction while significantly reducing the cost of doing business.In 2011, CIGNEX Technologies became a part of Datamatics Global Services, a publicly listed company on the Indian stock market. The merger provides clients with a wider set of offerings and enables us to undertake significantly larger engagements in providing end-to-end IT solutions.CIGNEX Datamatics’ process infrastructure covers a quality management system (assessed and appraised at CMMi ® Ver 1.3 Level 3) and information security management system (ISO 27001:2013 and ISO 20000:2011 certified).

3c579c7f-efd0-42d9-8827-8b28756e90d8.png

RPA Developer

DataSet is a local copy of your DataTable that gets populated in the client’s PC. It is independent of the Data Source and, because it’s saved in the local system, it makes the application faster and more reliable. Accessing a remote DataBase each time for updating or retrieving details is time-consuming so the DataSet helps you to keep DataBase tables local, on your PC.DataTable is a data object represented as an in-memory, tabular cache of rows, columns, and constraints. The DataTable class is used to perform any disconnected data access. It is a central object in the ADO.NET library.Other objects that use the DataTable include the DataSet and the DataView.DataTable limitation:<ul><li>Rows limited to 16,777,216.</li></ul>DataSet limitations:<ul><li>A maximum number of 2 billion rows.</li><li>The maximum number of columns allowed in a DataSet, across all its tables, is 16,000 columns.</li><li>According to MSDN DataTable Class "The maximum number of rows that a DataTable can store is 16,777,216"</li></ul>There is no limit of DataTables that can be added in DataSets.The user can use DataSets as DataBase in UiPath by referring Dt1, Dt2, Dt3, etc, as Table1 ,Table2, Table3.Check your hardware also. If you have 10GB or 20 GB CSV data, then your hardware needs to have a minimum of 25 to 32 GB RAM.Mandatory<ul><li>Give File location (.csv /.txt) as string format</li><li>Give Column number's as int32</li></ul>Output<ul><li>Snippets give Data-set as output with Column names like (1,2,3,.......)</li></ul>

Insert Large File data(.csv/.txt) and add DataTables to DataSet

ADROSONIC - Custom Audit Logs…

Epam - TelescopeAI Activities for UiPath…

UiPath – Cognizant® Automation Center Connector…

RPA Health - Provider Roster Automation…

PhantomPDF Integration Sequences…

RPAHealth - FL Business Entity Automation…

Workflow for 勘定奉行クラウド…

Feat Systems - Basic Physics…

Bot mantra - RPA Code Insight…

Arria Connect…

TIS 株式会社 - AI-OCR 連携ワークフロー…

Zenon - Analytics Wizard…

コージェントラボ - AI-OCR Tegaki 連携コネクター…

Calculate Sum of Colored Cells in Excel Sheet…

Large Data and DataTable to DataSet…

Help

How To