Hexaware is a global leader and the fastest growing next-generation provider of IT, BPO and consulting services. We are a team of seasoned IT practitioners, distinguished engineers and ‘Automateers’ (our employees with a deep-rooted passion for automation), striving as the customers’ trusted partner and delivering the best possible solutions using digital technologies.

Sr software Engineer

Amazon Simple Queue Service (SQS) is a fully managed message queuing service that enables you to decouple and scale microservices, distributed systems and serverless applications. 

SQS eliminates the complexity and overhead associated with managing and operating message oriented middleware, and empowers developers to focus on differentiating work. Using SQS, you can send, store, and receive messages between software components at any volume, without losing messages or requiring other services to be available.

AWS SQS Queue Creation Steps : https://docs.aws.amazon.com/AWSSimpleQueueService/latest/SQSDeveloperGuide/sqs-create-queue.html

Amazon SQS UiPath Integration Activities are developed to access AWS SQS queue via UiPath

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.

Senior Developer

This workflow has a major impact on the different automation processes, which all users - even visually impaired people - utilize in their daily work.

We are representing the idea of the Alexa device feature to our Windows systems with the help of speech recognition technology, by which the end user just has to command our device by speech and the rest will be taken care of by the automation feature present in UiPath.

  Automating processes with the help of Speech recognition

RPA Developer

RabbitMQ is a simple/traditional publish-subscribe message broker. It is usually used as middleman, where a system simply needs to notify another part of the system to start to work on a task, like ordering handling in a webshop (order placed, update order status, send order, payment, etc.). Another main use case is for long-running tasks or when you want to perfome reliable background jobs.

It can be used when web servers need to quickly respond to requests. This eliminates the need to perform resource-intensive activities while the user waits for a result. RabbitMQ is also used to convey a message to various recipients for consumption or to share loads between workers under high load (20K+ messages/second)

In current version the exchange type is default and the queue name is considerd the routing Key.

1) Publisher -  This activity can be used to publish a message to a queue.

	b) PortNumer: Port Number on which your server is listing (By Default it is 5672)

	e) Queue Name: Queue name in which message is to be pushed (It will create a new queue if a queue does not exist)

	f) Durable Queue: If you need or have a durable queue set its value to True

	g) Message: Message needs to be sent to Queue

2) Consumer -  This activity can be used to consume message from a queue.

	e) Queue Name: Queue name from which the message is to be consumed (It will create a new queue if a queue does not exist)

	g) Wait Until: Time in Milliseconds activity will check for message in queue

	h) Acknowledgement: true to send acknowledgement of message

	a) Message : Message consumed from the Queue

NOTE: This is the first version, later updates will cover more features like exchange, routing key.

Activities to publish and consume messages from Rabbit MQ

is there any option to add Vhost param to both activities,

I am having a problem create conn with the Rabbit

Thankyou Shubham this is really useful. We are using it to publish messages and consume messages from our Rabbit exchange which enables our RPA Automations to feed into our enterprise systems such as Centralised Logging, Data Lake and passing work to other systems from our Automations when can then process them as part of their task set. It has enabled our automations to enrich the existing microservices architecture that we have.

Thankyou

1. Apply Formula OnSheet - Applies given formula on given sheet, but does not save the sheet, neither closes sheet.

2. Auto Fit Excel Sheet - Auto fit all Excel data as per given range, applies vertical align, horizontal align and wrap text property as per inputs, but does not save the sheet, neither closes sheet.

3. Clear Data From Excel - As per inputs, clears data of entire row from Excel, but does not save the sheet, neither closes sheet.

4. Clear Data From Excel Cell - As per inputs, clears data from Excel for given range of cells, but does not save the sheet, neither closes sheet.

5. Close Macro Based Excel - Closes Excel without saving.

6. Delete Cell Data From Excel - As per inputs, Deletes data for given range of cells from Excel, but does not save the sheet, neither closes sheet.

This component contains all activities required for Excel

System analyst

Visual Basic

The bot opens the browser to visit NSE website and downloads Nifty50 data which contains stock details like last closing rate, latest opening rate and percent change.

By taking as input the percentage change, the Stock Indicator custom activity decides which shares should be considered for trading and which shares should avoid trading for that day or keep an eye on those shares. 


This activity checks for stock market details

Reusable code to calculate the date after certain working days starting with the current date.While calculating the date, the process ignores the following:1) Week OFF "Saturday and Sunday" (or day of week pass as input argument "in_strWeekOffDays" )2) Holiday Dates passes in "MM/dd" format as comma separated String to input argument "in_strHolidayDates"Note: if Holiday dates are year specific then please pass date in string as "MM/dd/yyyy" formatInput Arguments:1) in_intWokingDaysCount (int) - input of no. of day's date needed2) in_strWeekOffDays (String) - comma separated values of days of week which are to be considered as non-working days eg: "Saturday,Sunday"3) in_strHolidayDates (String) - comma separated values of Date's which are to be considered as to be holiday eg: "07/04,08/15,01/18/2018"4) out_dateAfterWorkingDays (String) - Date in "MM/dd/yyyy" format after "x" working days from current date

Calculate and get a working date from current date

 - good sample. I used it in my automation and do well.


 - This is a convenient snippet that can help in many business scenarios. Good job!
As a suggestion, it would probably be easier to use if the instructions were also written down as an annotation of the snippet. Also, since it's distributed as a single XAML file, maybe a name other than Main.xaml would be more clear.


This is a Logging Activity which helps to maintain logs locally in a file.This Activitie will help to create and store logs locally in an Excel or a CSV file, as some use cases require to log process data in a file and later on use it for fetching required information.For now it logs only three fields:1) Current Time Stamp2) Log Level(Custom)3) Log Message

Hi. Very useful this snipet. Is it possible to access the source code?

I wanted to put all the logs generated in a execution into excel. So, is that I need to invoke this flow everytime I want log to be captured? or is there anyway where I invoke this once and the logs of the entire execution will be captured.

Useful - Simple and to the point! Would like to see in the next versions more possibilities for customizing the logging (maybe more file format options, more info and so on).


1.1     This framework can be used to do code review for complete projects, for specific xaml’s and for any specific folder.

1.2     On completion of Code review, this framework generates the final code review report to a specified location. 

1.3     It gives details about SQL tables, stored procedures, views, table value functions, scalar value functions triggers, Sequence name, Log Message Template activity, Catch Block, Nested If, Finally block, Execute Query, use of network Credentials.

1.4     It offers details about all screenshots, files, arguments/variables, activities (Write line, Custom input, Message box, Input dialog, Comment out and Log message) used/not used in project.

Review the code for projects developed in UiPath and SQL database

How can I update the workflow so that I can change the rules like the naming convention based on our company's best practices? Thank you

it seems "in_strDataTypeDataExcelPath" this parameters is not there any more ? so i had to read this excel and pass the datatable to the new parameter "in_DT_datatype".  but the screen shots shown here is not updated

 - It took a bit of time to get the configurations ready, but the report was successfully generated and it contains interesting information about the project.
As a suggestion, maybe including some samples of the DataTypeData Excel file could make it faster to setup.
Good job!


About Us

Amazon SQS UiPath Integration Activities…

Hexaware - Personal Assistant Bob …

Hexaware - Rabbit MQ Integration Activities…

Hexaware - Excel Activities…

Hexaware - Stock Indicator…

Hexaware - Get Working Date…

Hexaware - Log to File…

Hexaware - Code Review Activity…

Help

How To