Forum Engagement Daily Reports

[system]

Daily Forum Report | 24 September 2021

Top 3 Topics with Most Views

How to use group by and get sum? made by @aapostol with 40 views.

How to join the string in every 3 rows and make and write in one cell? made by @Ru_eL with 40 views.

How to perform Conditional Format using Uipath made by @HeartCatcher with 37 views.

Top 3 Topics with Most Replies

Excel Formula adding @ at the beginning made by @fabio.r.mendes with 19 replies.

How to perform Conditional Format using Uipath made by @HeartCatcher with 12 replies.

How to use only two digits after . in decimal made by @copy_writes with 11 replies.

Top 3 Users Who Posted The Most

@lakshman made 23 posts!

@Yoichi made 20 posts!

@Soudios made 17 posts!

Top 3 Most Liked Posts

This post made by @FranciscoAraujo received 4 likes!

Workflow Analyzer - Access to project folder path

Hello! I want to drop a question related to the “Workflow Analyzer - Build Custom Rules”. Is it possible to get the folder path of the project that is being analyzed? In this case, I want to validate some info in the Config file and get the project name from .json file. Any help? [image] MessageBox 1: [image] MessageBox 2: [image] MessageBox 3: [image] Thanks! Francisco

This post made by @NIVED_NAMBIAR received 3 likes!

How to use only two digits after . in decimal

Hi @copy_writes Try like this Math.Round(CDBl(taxval),2).ToString Or Math.Round(Convert.ToDecimal("12.000"),2).ToString Just adding one more way as well

This post made by @Yohann_Marmonier received 2 likes!

Tutorial : Start a job via the Orchestrator API on Microsoft SQL Server

Hello community ! In this tutorial I’ll explain how to start jobs on SQL under MSSQL but you can easily adapt the code to perform any kind of Orchestrator api requests from MSSQL. This tutorial with a detailed wiki (soon for wiki) is available here too. You’ll need two steps : Register an external app on Orchestrator Run the SQL Code At the end, you’ll be able to start a job with only this type of commands : EXEC [RPA_OrchestratorAPI_StartJob] @processName = N'YOUR_PROCESS_NAME', …

Top 3 Most Liked Solutions

This solution provided by @codemonkee received 2 likes!

Unable to integrate Minio "HTTPS" with Orchestrator. Package publish failed

After some trial and error, I dug through UiPath’s Minio DLL files (UiPath.Storage.Minio.dll and Minio.dll) I searched for properties/text such as “Secure”, “SSL”, “Https” and after trying a few properties from Minio.dll such as ;Secure as this is the property that sets the HTTPS flag in the Client (but failed), ended up locating a Boolean SslEnabled in the UiPath.Storage.Minio MinioStorageClientOptions [image] Updating the Storage.Location connection string with SslEnabled=true<add key="St…

This solution provided by @masatomix received 1 likes!

Orchestrator APIを用いたジョブの実行ログ取得ついて

こんにちは。 たしか、上限1000件だったような気がします。 Swaggerで取得してみましたが、 { "@odata.context": "https://[OCサーバ名]/odata/$metadata#Jobs", "@odata.count": 1307, "value": [ {.... と返ってきつつ、実際のJSON配列は1000件でした。 Swagger(https://[OCサーバ名]/swagger) を見てみると、$topのパラメタ説明も Limits the number of items returned from a collection. The maximum value is 1000. となっていますし、コレを1001とかにしたらエラーになりましたし、多分上限1000件ではないかと。それ以上を取得したい場合は、他のパラメタ $skip などでオフセットしながら何回かに分けて取ることになると思います 期間については、SQLサーバにデータが入っている限り、取得可能だと思います。 よろしくお願いします。

This solution provided by @prasath_S received 1 likes!

Invoke code: Exception has been thrown by the target of an invocation / 2-digits-after-the-decimal-point

Hi @Soudios Please try this, dt.asenumerable.Where(function(row) not String.IsNullOrEmpty(row("Somme de Ratio").ToString)).ToList().ForEach(Sub(row) row(“Somme de Ratio”)= Math.round(cdbl(row(“Somme de Ratio”)),2)) It is similar to this one, Thanks

---

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.