Novigo Solutions is an end-to-end IT Solutions provider, specialized in full cycle IT Services and platform solutions

e6653b86-6191-494c-b705-57f8d49ea57c.png

Project Manager

SOFTWARE ENGINEER

This Snippet requires the following five arguments:

  

1\. in\_FilePath (String): The Input Excel File Path. **Required**

2\. in\_SheetName (String): The Sheet Name that needs to be read. **Required**

3\. in\_NewColumnNames (String\[\]): The New Column Names that need to be replaced with the Old Column Names or Duplicate Names. **Optional**

4\. out\_OutputDatatable (Datatable): The Output Datatable after performing the operation. **Required**

5\. out\_DuplicateColumns (Dictionary(Of String,Int)): The Duplicate Column Name as the Key, the number of Dplicates as the Value. **Optional**

This Snippet provides the feature of reading an Excel file with duplicate headers and renaming it with user specified header names

54117f40-be35-4a23-881f-08f14d2c1e63.png

This Snippet requires five arguments to be supplied:

  

**1\. in\_ArrayOfElements (Object \[\]):** The Array of Values to find the element which has the maximum occurrence. **Required.**

**2\. in\_Value (Object):** The element whose number of occurrences needs to be found. **Optional.**

**3\. out\_MaxOccurredElement (Object):** The element which has the maximum occurrence. **Required.**

**4\. out\_ElementCount (Dictionary(String,Integer)):** Output Dictionary which has each element in the list as a Key, and its number of occurrences as its value. **Required.**

**5\. out\_ValueOccurrence (Integer):** The number of occurrences of the argument **in\_Value** in the list**. Optional.**

This activity is used to find the element which has the highest number of occurrences in a list of elements.

98ef97e9-d598-4711-816a-61ad17186a8c.png

This Snippet requires the following three arguments:

  

Input Arguments:

**1\. in\_SourceFolderPath (String):** The Input folder path where the files are present and need to be segregated into separate folders. **Required.**

**2\. in\_DestinationFolderPath (String):** The destination folder path where the files need to be segregated to different sub folders. **Required.**

**3\. in\_IsOperationCopy (Boolean):** Indicates the operation that needs to be performed. True for Copy operation and False for Move operation. By default the operation is Move. **Optional.**

This Snippet is used to divide/segregate different types of files of present in a folder into separate folders based on their type

This Snippet requires the following three arguments:

  

Input Arguments:

**1\. in\_InputDictionary (Dictionary(Of Object,Object)):** The input argument is the Dictionary which needs to be Converted into a HTML Form in String Format . **Required.**

**2\. in\_FormHeader (String):** This argument is used to provide a Heading to the Form. By Default it has the Heading as ‘FormData’. **Optional.**

  

Output Arguments:

**1\. out\_HtmlForm (String):** This is the output argument which provides the Dictionary key and values as String in HTML Form format. **Required.**

  

**Note :** 

The HTML Form format used is taken from www.w3Schools.com.

This Snippet converts a Dictionary Key Value Data into a HTML Form in a String Format

Developer

The component has two input arguments and one output argument. 

  

The input arguments are:

*    **in\_DataTable**: A datatable, the one which is to be converted into HTML table.
*   **in\_NeedBorder**: A boolean variable to decide if a border is needed for the HTML table or not.

Output:

*   **out\_HtmlTable**: The resulting output string will be a HTML table with or without borders as per the input boolean variable.

The component will convert a .NET datatable object in to a HTML table

This Snippet requires the following six arguments:

  

Input Arguments:

  

**1.** **in\_FolderPath (String):** The Folder Path which contains the CSV files that need to be converted. **Optional.**

**2.** **in\_CsvFilePaths (String \[\]):** This Input argument can be used when the CSV files that need to be converted are in different locations. The Array of file paths can be provided. If the **in\_FolderPath** argument is provided then this argument is ignored. **Optional.**

**3.** **in\_SheetName (String):** The sheet name that needs to be provided for the converted output xlsx or xls file. **Optional.**

**4.** **in\_DeleteCsv (Boolean):** This argument specifies if the original CSV files need to be deleted or not. **Optiona**l.

**5.** **in\_Extension (String):** This argument specifies the file format needed. It can either be xlsx or xls. **Required.**

**6.** **in\_OutputFolderPath (String):** This argument specifies the folder path where the Converted Output xlsx or xls files needs to be created**. Required.**

  

Note:

The **in\_Extension** argument should be either xls or xlsx. If other extensions are provided, then the output file might be Invalid.

This Snippet is used to convert CSV files into Xlsx or Xls

This activity is capable of converting a data column with inconsistent date formats into a consistent or uniform format.

  

**Inputs:**

  

1\. DataTable: The data table variable which consists of a column having inconsistent date formatting (Doesn’t follow a uniform date formatting).

2\. ColumnName (of String): The name or index of the column to be standardized as a string.

3\. DateFormats: All the available string formats followed by the column have to be listed as an array of string.

4\. RequiredFormat: The uniform date format to which the column is to be converted.

  

**Outputs :**

  

1\. OutputTable: The output data table with the formatted output (The output datatable should preserve the schema of the input datatable).

  

2\. FormattingFailedIndexes: The row indexes for which the formatting has failed since a matching input date format was not found for those dates.

  

Please check the video URL attached with this upload if you have any doubts.

The activity finds a solution to the problem of DataTables with multiple date formats in the same column (of type string), by converting them to the same format

**Automated Customer Complaint Ticket Generation** Process makes the employee's job of data entry into multiple CRM systems faster and has an improved quality.

  

The process helps to fetch the previous complaint details of the given customer ID.

  

The employee can input the details to solve the complaint as to what is the solution recommended and as to the time it takes to solve it.

  

The employees can also edit or update the changes made with confirmation messages, so as to confirm the change of data.

  

The Error Handling is also ensured when the user enters an irrelevant data that cannot be processed.

The Process takes input from the user and updates the data into an Excel sheet (database) and Google forms, and sends a confirmation mail to the user

Pratice Head

The component is useful for checking the feasibility of template data extraction from a big set of vendor/supplier invoices using UiPath DU-Invoice ML offering.

The Endpoint [https://invoices.uipath.com](https://invoices.uipath.com/) has been used for extraction.

It can process invoices with maximum 2 pages per invoice and file size of max 4MB. (Public Preview used for development)

The component extracts all the pre-configured invoice fields from invoice files using UiPath DU Invoice ML Model to output Excel