Forum Engagement Daily Reports

[system]

Daily Forum Report | 23 July 2021

Top 3 Topics with Most Views

UiPath Automation Awards 2021 for CEE & Turkey made by @cristina.vidu with 38 views.

How to refresh my excel file with Uipath ? made by @Nightowl_music with 34 views.

Extract number from string made by @Bhageswar_Yadav with 32 views.

Top 3 Topics with Most Replies

How to extract the address number(store no) using regex made by @copy_writes with 16 replies.

How to refresh my excel file with Uipath ? made by @Nightowl_music with 15 replies.

An Empty file gets downloaded inbetween data extraction made by @kaavya with 14 replies.

Top 3 Users Who Posted The Most

@ermanoj3101 made 65 posts!

@ppr made 21 posts!

@prasath17 made 19 posts!

Top 3 Most Liked Posts

This post made by @Ishmeet_Bindra received 3 likes!

UiPath Cloud Masters

Get ready for Azure Challenge. Here is the guide you can follow for your learning/Implementation purpose- Why Cloud? - https://www.youtube.com/watch?v=dsKIpLKo8AE Azure Basics - https://www.youtube.com/watch?v=xNbVUMvqtt8 Azure Database Service - https://www.javatpoint.com/azure-database-service Azure DevOps - https://www.youtube.com/watch?v=1xyBUj72Uh4 Azure AI - https://www.youtube.com/watch?v=qJGRd34Hnl0 and https://www.youtube.com/watch?v=gRQtyfP3sTw Azure Storage - https://www.youtube…

This post made by @jeevith received 3 likes!

Dispatcher + Performer, How to organize Execution on Orchestrator, Please Advise

Hi @Hurmet_Noka, Here I am assuming your perfomer takes no longer than 3 hours and 45 minutes Lets take the Dispatcher first. If your queue items are added quite quickly you can schedule your performer to run after a static time delay. Say if your dispatcher starts at 10:00 am and takes 10 minutes, your perform can be scheduled to run at 10:15 with a 5 minute buffer. Dispatcher runs again at 14:00 and Performer at 14:15 and this can continue. You can use cron expression on both the dispatch…

This post made by @cristina.vidu received 2 likes!

UiPath Automation Awards 2021 for CEE & Turkey

UiPath Automation Awards 2021 for CEE & Turkey Under Vargha Moayed’s leadership, the UiPath Automation Awards are created to support the development of innovative business ideas, to foster the capacity to scale of brilliant teams and entrepreneurs in the Central, Eastern Europe & Turkey region and to enrich the automation ecosystem we play in. Winners of the awards will receive financial, sales and marketing support and the deadline for applications is 1 Sept. Are you one of those innovative …

Top 3 Most Liked Solutions

This solution provided by @jeevith received 3 likes!

Dispatcher + Performer, How to organize Execution on Orchestrator, Please Advise

Hi @Hurmet_Noka, Here I am assuming your perfomer takes no longer than 3 hours and 45 minutes Lets take the Dispatcher first. If your queue items are added quite quickly you can schedule your performer to run after a static time delay. Say if your dispatcher starts at 10:00 am and takes 10 minutes, your perform can be scheduled to run at 10:15 with a 5 minute buffer. Dispatcher runs again at 14:00 and Performer at 14:15 and this can continue. You can use cron expression on both the dispatch…

This solution provided by @ppr received 2 likes!

Needed Explanation

Its a LINQ within Method syntax: dtExported.Rows.Cast(Of DataRow)() Similar to dtExported.asEnumerable - makes the datarows available for the LINQ .Where - filtering (Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(“”) Filter expression: All Column Values from the looped datarow are not blank )).CopyToDataTable()** us the datarows passed the filter and copy it to a datatable Rewritten to Query Syntax: (From d in dtExported.AsEnumerable Where d…

This solution provided by @Yoichi received 2 likes!

XOR Operation not working

Hi, Xor operator evaluates both expressions. So, in the above condition, String.IsNullOrEmpty(Array2items(2).ToString) is always evaluated even if the number of items is 2 or less. Perhaps you should use short-circuiting logical operator as the following. Array2Items.Count<3 OrElse String.IsNullOrEmpty(Array2Items(2).ToString) Regards,

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.