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

AVP & Head- RPA and QA

RPA Solution Architect UiPath

This is the plug-n-play workflow to verify whether internet connection is available on the system running the Bot. This will be useful before performing any activities that require internet connections i.e. Web/Online transactions. This is a commonly used component to avoid exception handling after opening up the browser or directly performing the online transaction/operation without checking the internet connectivity. It saves time and adds to a proactive check.

Workflow for Quick Internet Connectivity Check before Starting the Web Operations

This is the plug-n-play workflow to verify whether particular date is work day or weekend. This will be useful when you want to do certain operations in business process that need to be done on a working day or any particular day of week. This workflow will provide day information about the particular date, additionally it will also validate whether the entered date is valid date or not.

Workflow for checking whether particular date is work day or weekend

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:**

*   Rows limited to 16,777,216.

**DataSet limitations:**

*   A maximum number of 2 billion rows.
*   The maximum number of columns allowed in a DataSet, across all its tables, is 16,000 columns.
*   According to MSDN DataTable Class "The maximum number of rows that a DataTable can store is 16,777,216"

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**

*   Give File location (.csv /.txt) as string format
*   Give Column number's as int32

**Output**

*   Snippets give Data-set as output with Column names like (1,2,3,.......)

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