Forum Engagement Daily Reports

[system]

Daily Forum Report | 09 January 2023

Top 3 Topics with Most Views

Invoke Python Method goes into errors! made by @Re_Walter with 60 views.

Add multiple datatable in for each loop made by @arina with 55 views.

How can I add to the collection? made by @rudgns99 with 48 views.

Top 3 Topics with Most Replies

Read excel content certain words and email made by @koolrc812 with 22 replies.

Erro Could not find a part of the path ...'\1.0.7\content\project.json' made by @guilherme.dias with 15 replies.

Project Notebookを最前面に出さない方法 made by @11159 with 13 replies.

Top 3 Users Who Posted The Most

@Anil_G made 65 posts!

@Kaviyarasu_N made 36 posts!

@supermanPunch made 18 posts!

Top 3 Most Liked Posts

This post made by @postwick received 2 likes!

How to Convert string 1234567890 to 123,45,67,890.00 this format

You want to use ToString(“#,#.##”) The 00 in your format will always explicitly put two 0s, not two decimal places.

This post made by @Anil_G received 2 likes!

Read excel content certain words and email

@koolrc812 Did you change the type argument in for loop properties to string? Change that and it should solve that issue…hope this helps Cheers

This post made by @Jacqui_M received 1 likes!

Copy Excel data with all colors and all format

Hey @Merlin_Joseph, welcome to the forum. I would highly suggest installing the BalaReva.Excel.Activities, as mentioned by @balupad14 further up: Copy Excel data with all colors and all format - #8 by balupad14 It works really well and I think it may solve your issue.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

How to Convert string 1234567890 to 123,45,67,890.00 this format

Hi @Anil_Potekar , Could you Check with the below Expression : CDbl("1234567890").ToString("#,###.00") or CDbl("1234567890").ToString("N",new CultureInfo("hi-IN")) Let us know if this doesn’t work

This solution provided by @supermanPunch received 1 likes!

How to format specific cell in Excel

Hi @nmjvk , Could you try changing the Cell to Range and Check if it works ? Excel.Sheet("Ark1").Range(UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(j+252)+(i+1).ToString+":"+UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(j+252)+(i+1).ToString) If the above works, I would suggest to assign the value to a variable, so as to ease the repeated use of the same value.

This solution provided by @supermanPunch received 1 likes!

How can i convert dd/mm/yyyy to get the day name?

Hi @Rowley101 , Could you Check with the below Expression : DateTime.ParseExact("09/01/2023","dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).DayOfWeek.ToString

---

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.

[system]

Daily Forum Report | 10 January 2023

Top 3 Topics with Most Views

How to find the specific value count in excel using LINQ made by @Raja.G with 62 views.

Get latest email from gmail made by @swapnil.soni with 60 views.

Excel cell value to email body made by @koolrc812 with 50 views.

Top 3 Topics with Most Replies

How to find the specific value count in excel using LINQ made by @Raja.G with 24 replies.

Excel cell value to email body made by @koolrc812 with 23 replies.

For start-up company: how to buy in order to resell UiPath licenses for 1st company client? made by @IPIX with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 80 posts!

@Yoichi made 25 posts!

@sangeethaneelavannan1 made 23 posts!

Top 3 Most Liked Posts

This post made by @Kyleb91 received 3 likes!

Package Download not containing .Xaml files

Hi @sangeethaneelavannan1 yes, now there is a _rels folder and file, a content folder with the project minus the xaml files, lib folder with .dll extension files, and package with metadata. Along with a [Content_Types] XML Doc file and Process NUSPEC File…

This post made by @Hiba_B received 2 likes!

Table extraction is now available in Studio Web

Hi @gheorghestan ! I will add another comment tonight to give feedback on its use with a concrete use case, but here is the first feedback on the launch of extract table: It would be great if all the extracting tools (for studio web but also studio) would use and be compatible with already installed extensions Example: I have the extension 22.4 thanks to UiPath Studio Enterprise, and Studio web wants me to use 22.5. Is it because of technical limits and thus studio web absolutely needs…

This post made by @supermanPunch received 2 likes!

S100:S101 Excel Automation Data Size Limitation

Hi @Harsha_S1 , Could you Check on the below clarification provided : [image] Yes, We should be able to work with Queues without using RE-Framework as well. However, we would need to implement the same logic or transitions as done in an RE-Framework to handle the different scenarios. Also, We could do the operations without using Queues as well, It all depends on whether the Process is well suited for the Queue Design or the normal way of looping data in a Datatable/List/Collection and pro…

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 2 likes!

S100:S101 Excel Automation Data Size Limitation

Hi @Harsha_S1 , Could you Check on the below clarification provided : [image] Yes, We should be able to work with Queues without using RE-Framework as well. However, we would need to implement the same logic or transitions as done in an RE-Framework to handle the different scenarios. Also, We could do the operations without using Queues as well, It all depends on whether the Process is well suited for the Queue Design or the normal way of looping data in a Datatable/List/Collection and pro…

This solution provided by @Kyleb91 received 1 likes!

Package Download not containing .Xaml files

Hey! Found the solution, must tick Include Source Files in the Publish Options when publishing the package!

This solution provided by @Yoichi received 1 likes!

Empty space problem

Hi, Can you try the following expression? Variable.split({","},stringsplitoptions.RemoveEmptyEntries).Select(Function(s) s.Trim()).ToArray() 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.

[system]

Daily Forum Report | 11 January 2023

Top 3 Topics with Most Views

Extract from https response made by @langsem with 61 views.

Skipping Ads on YouTube made by @URK20RA1037_SAM_ASHWIN with 55 views.

Converting Pdf table to excel made by @Amit_Kumar_Charde with 50 views.

Top 3 Topics with Most Replies

How to read tag from api response made by @Sandhya_Gajare with 23 replies.

Converting Pdf table to excel made by @Amit_Kumar_Charde with 21 replies.

How Can I Read Tag from XML response made by @Sandhya_Gajare with 19 replies.

Top 3 Users Who Posted The Most

@Anil_G made 54 posts!

@Kaviyarasu_N made 36 posts!

@Sandhya_Gajare made 29 posts!

Top 3 Most Liked Posts

This post made by @jeevith received 3 likes!

How to identify Openforwork people in LinkedIn search

Hi @rathishseng, I have to agree with @Parth_Doshi, try not to get yourself black listed from crawling using UI automation on Linkedin especially, if you are using your own Linkedin credentials. Linkedin can track your public IP and in the worstcase block your entire public IP from accessing linkedin. Just an heads up, it may not happen, but it can happen Do read which bot agents are allowed and which arent. Almost all websites with personal data have strict crawling requirement…

This post made by @Dawid_Nguyen received 2 likes!

Get latest email from gmail

to make this easier. You can create special label in your Gmail that will automatically store all emails from that specific person. Then you can make robot to fetch email from that Label only.

This post made by @charliefik received 2 likes!

Best Practice for interacting with Databases (opening and closing DB connection)

Thanks Anil and Vish. I’ll go with the open in init and close in end process (if using framework)

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 2 likes!

How to update the Robot Credentials using API for Modern Folders

You can try this approach: Robots Requests [1]

This solution provided by @Piotr_Gajewski received 1 likes!

SQL Run query - Missing provider Error

Hi, so I installed Oracle drivers and also .Net 4.8 drivers but that did not solve the issue, the “Bad IL format” error still exists, however I was experimenting with Connection String and finally I found out that this was a problem! I have used below pattern and it’s worked: “Data Source=IpAddress\optima,PortNumber;Initial Catalog=master;User ID=varDataUser;Password=varDataPassword;Trust Server Certificate=true” where: IpAddress is like: 192.xyz.x.xyz PortNumber is like: 12345 varDataUser:…

This solution provided by @BogdanTod received 1 likes!

How to identify Openforwork people in LinkedIn search

Hi @rathishseng, I found out there is part of the selector that makes difference between the profile pictures that are framed and the ones that are not. This is the selector attribute “url” of regular profile picture: [image] This is the one that has a frame (“Open To Work”): [image] You just need to build appropriate selector to target the ones which have “profile-framedphoto-shrink” word in the src. Regards, Bogdan

---

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.

[system]

Daily Forum Report | 12 January 2023

Top 3 Topics with Most Views

How to get file using uipath apps? made by @Vanitha_VS with 44 views.

Flow Decision - Step by step Debug Run - Visual Issue made by @hans.gunnoo with 42 views.

Delete Rows: Exception from HRESULT: 0x800A03EC made by @WICAKSONO_Hanif with 42 views.

Top 3 Topics with Most Replies

How to get the IMAP Gmail port made by @krishna_priya1 with 13 replies.

Use Application/Browser Output made by @prerna.gupta with 13 replies.

Delete Rows: Exception from HRESULT: 0x800A03EC made by @WICAKSONO_Hanif with 13 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 43 posts!

@Yoichi made 27 posts!

@Gokul001 made 22 posts!

Top 3 Most Liked Posts

This post made by @StefanPrajica received 2 likes!

Select one button/row in ALV grid fails

Hello Laura, I managed to reproduce the scenario and I have the following suggestion for creating the selector to automate this kind of checkboxes (the selector text is in English due to locales but the structure should be the same). I have tried anchoring the checkbox to the Text cell next to it but it does not work since for the checkbox we only have the tableRow attribute exposed. The only reliable working scenario seems to be this: First you should use a Get Attribute activity and indica…

This post made by @private_matter received 2 likes!

Ability To Generate Number Of Cases In Switch Activity

I would like to suggest a useful feature request in the switch activity if we can generate any number of cases for any variable type. I had more than 300 key cases in my project and I literally enter each number manually which took me a lot of time. It would be better if we can set a number and have the cases autogenerated quickly. Thanks for the consideration.

This post made by @nino.dy received 2 likes!

Modern Design: Use Excel File loads very slow

Hello everybody, I am reaching out to the community since I am stuck with this problem: I got several projects which have loading issues when using the ‘Use Excel File’ scope. It takes about 1,5 Minutes to open the Excel Files each time. I don’t understand what is taking Studio so long to open the files. In rare cases it will only take seconds, but mostly it is 1,5 minutes. The problems occur on Version 2021.4 and 2022.x (I would need to check the exact version, but it is not the newest rele…

Top 3 Most Liked Solutions

This solution provided by @StefanPrajica received 2 likes!

Select one button/row in ALV grid fails

Hello Laura, I managed to reproduce the scenario and I have the following suggestion for creating the selector to automate this kind of checkboxes (the selector text is in English due to locales but the structure should be the same). I have tried anchoring the checkbox to the Text cell next to it but it does not work since for the checkbox we only have the tableRow attribute exposed. The only reliable working scenario seems to be this: First you should use a Get Attribute activity and indica…

This solution provided by @marian.platonov received 1 likes!

Not able to see the xaml file from the extracted .nupkg file

It seems that when you published the process from Studio to Orchestrator you didn’t choose the Source files option. [image] Republish the project and then check again. Note: Include Sources - select this option to package all .xaml sources within the published package, including workflows that were previously made private. For Windows - Legacy libraries, the files are saved in the generated assembly file and in the lib\net45 folder in the .nupkg file. For Windows and cross-platform librar…

This solution provided by @Yoichi received 1 likes!

Variable type error

Hi, Can you try the following expression? ID = CInt(CurrentRow("id")) 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.

[system]

Daily Forum Report | 13 January 2023

Top 3 Topics with Most Views

Reading an Excel file issue made by @vinjam_likitha with 45 views.

Anyone having solution of my problem made by @Shubham_Bidwai with 44 views.

Error entering email address - 'End of expression expected.' made by @gerry.d.hayes with 42 views.

Top 3 Topics with Most Replies

Folder path can’t be accessed made by @wija with 22 replies.

Reading an Excel file issue made by @vinjam_likitha with 17 replies.

Anyone having solution of my problem made by @Shubham_Bidwai with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 37 posts!

@Yoichi made 27 posts!

@Sudharsan_Ka made 24 posts!

Top 3 Most Liked Posts

This post made by @laura.groeger received 2 likes!

Select one button/row in ALV grid fails

Hi Stefan, perfect - thanks a lot for the fast solution! Your way of handling it worked for me Have a great day/weekend! Laura

This post made by @mahmoud.zaky received 2 likes!

How to Run the Project on the Other System without having Uipath installed

Hi @Akbar_Badhusa, all you need is to install UiPath Assistant on this machine and connect it to your orcastrator 1- Need to publish your project to Orcastrator. 2- Install UiPath Assistant on your machine Windows or MAC. 3- Connect UiPath Assistant to your Orcastrator. 4- Run your process from Assistant. find below URL will help also to do above steps:

This post made by @miwa_yamamoto received 2 likes!

Conversion from string "-" to type 'Integer' is not valid

Yoichi様 お陰様でエラーを抜けることができました。 いつも本当にありがとうございます。

Top 3 Most Liked Solutions

This solution provided by @BCod received 2 likes!

Windows compatibility issues with Windows-Legacy

UPDATE: My problem was solved here: This underscores the importance of having an all-inclusive post that is easy for customers to find. The update from Windows-Legacy to Windows is not a smooth process by any means.

This solution provided by @Yoichi received 1 likes!

Conversion from string "-" to type 'Integer' is not valid

こんにちは 列Column1に不正なデータ：おそらく"-"だけのデータが含まれていると思いますので まずはデータをチェックしてみてください。

This solution provided by @Anil_G received 1 likes!

Skip activity when retry same transaction

@Sathish_Kumar_S You can create condition using it…And that would be available only when you use queues. cheers

---

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.

[system]

Daily Forum Report | 14 January 2023

Top 3 Topics with Most Views

How to find matching values in two excel sheet made by @Raja.G with 38 views.

2 mins time delay made by @Omkar_Shete1 with 33 views.

Function and methods related to Datatable made by @_Anish with 30 views.

Top 3 Topics with Most Replies

2 mins time delay made by @Omkar_Shete1 with 9 replies.

Variable string array not working in Invoke Workflow made by @private_matter with 8 replies.

LINQ Query for matching row from another Excel column and update the Result made by @Shubham_Arora1 with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@wija made 11 posts!

@supermanPunch made 9 posts!

Top 3 Most Liked Posts

This post made by @supermanPunch received 1 likes!

Regex results to a 1 column datatable

Hi @Sc100 , Have you tried executing with that settings/Regex Expression ? It does not necessarily indicate always the capturing of all the lines. Check by executing first and let us know if you are still not able to get the results.

This post made by @Sc100 received 1 likes!

Regex results to a 1 column datatable

Hey, that did it. Thank you for the tip! Also, big shout out to Steve for stepping in with the regex pattern! You both helped a ton.

This post made by @Yogesh1 received 1 likes!

How to Run the Project on the Other System without having Uipath installed

You cannot run without UiPath assistant or studio and yes it is available in mac.

Top 3 Most Liked Solutions

This solution provided by @supermanPunch received 1 likes!

Regex results to a 1 column datatable

Hi @Sc100 , Have you tried executing with that settings/Regex Expression ? It does not necessarily indicate always the capturing of all the lines. Check by executing first and let us know if you are still not able to get the results.

This solution provided by @wija received 1 likes!

Folder path can’t be accessed

@Yogitha_S1 never mind, because i already have my solution.

---

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.

[system]

Daily Forum Report | 15 January 2023

Top 3 Topics with Most Views

PDF to Excel Table Extraction made by @Hardik_Durgam with 35 views.

How to find header data in excel made by @Mohammed_Nawazuddin with 29 views.

How many languages are Re:Infer support? made by @donghai with 26 views.

Top 3 Topics with Most Replies

"Run Spreadsheet Macro" saying that I Cannot run the macro made by @Thomas.Dettmer with 6 replies.

How to find header data in excel made by @Mohammed_Nawazuddin with 6 replies.

PDF to Excel Table Extraction made by @Hardik_Durgam with 4 replies.

Top 3 Users Who Posted The Most

@Anil_G made 25 posts!

@supermanPunch made 5 posts!

@Thomas.Dettmer made 4 posts!

Top 3 Most Liked Posts

This post made by @Thomas.Dettmer received 2 likes!

"Run Spreadsheet Macro" saying that I Cannot run the macro

Hi Anil, I figured it out! I had saved my macros under a certain spreadsheet as opposed to putting them in a Module. I guess I wasn’t being detailed enough with my descriptions. So I should have originally listed my macro as “Sheet1.A_ImportTemplateAndClearOutOldData” instead of “A_ImportTemplateAndClearOutOldData”. for anyone else out there with this issue, if you switch the option to “All open workbooks” like in the screenshot below, you’ll get the proper name you should put into the UiPath…

This post made by @Hiba_B received 1 likes!

"Run Spreadsheet Macro" saying that I Cannot run the macro

That’s great to know: thank you for the tips ! Don’t forget to mention your answer as the solution, so the thread closes and thus helps other users

This post made by @supermanPunch received 1 likes!

PDF to Excel Table Extraction

Hi @Hardik_Durgam , Could you check if the workflow provided in the below post works for your case ?

Top 3 Most Liked Solutions

This solution provided by @Thomas.Dettmer received 2 likes!

"Run Spreadsheet Macro" saying that I Cannot run the macro

Hi Anil, I figured it out! I had saved my macros under a certain spreadsheet as opposed to putting them in a Module. I guess I wasn’t being detailed enough with my descriptions. So I should have originally listed my macro as “Sheet1.A_ImportTemplateAndClearOutOldData” instead of “A_ImportTemplateAndClearOutOldData”. for anyone else out there with this issue, if you switch the option to “All open workbooks” like in the screenshot below, you’ll get the proper name you should put into the UiPath…

This solution provided by @Anil_G received 1 likes!

How to set "Timeout" For email Trigger Activity

@Karam_Abulawi Then why do you need email trigger? You just need to do get emails when needed and check if any email is received….and in properties you have only unread can check it…and when you read the email…check mark as read or move to a different inbox Hope this helps Cheers

---

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.

[system]

Daily Forum Report | 16 January 2023

Top 3 Topics with Most Views

How to write full month name from a date? made by @makboga with 45 views.

同じデータで実行しても、不規則にエラーが出る made by @nagahama-digital with 44 views.

7時30分の表記を「7:30」⇒「7.50」に変更する方法はあるでしょうか。 made by @T_Hirao1 with 41 views.

Top 3 Topics with Most Replies

Office 365 email multiple attachments made by @sairama.deepthi with 19 replies.

複数の宛名のメール送信について made by @a.kmni with 17 replies.

Save for later Option made by @YUGAN_NITHISH_KUMAR with 11 replies.

Top 3 Users Who Posted The Most

@ppr made 21 posts!

@Yoichi made 20 posts!

@Anil_G made 20 posts!

Top 3 Most Liked Posts

This post made by @s.bruce received 5 likes!

Jira activites vs. WebAPI activities, RestSharp mismatch

Continuing the discussion from Method not found: 'Void RestSharp.Parameter…ctor(System.String, System.Object, RestSharp.ParameterType)': Staying on WebAPI 1.9.2 is not a suitable solution in our case, as it prevent us from using essential functionality in the later versions (eg. reponse content output). Upgrading WebAPI breaks every one of our Jira scopes on version 2.4.1 of the Jira activities package, rendering our automated ticketing solution useless. Will the Jira package ever be updated t…

This post made by @Niwa received 2 likes!

UiPathアカデミーにログインしようとするとRaven360にリダイレクトされる

先ほど改めてログインしたところ、問題なくマイページに遷移できました。 [image] 実は月初も同じ症状が起きていて、しばらくすると自動的に解消するようになった経緯があります。 UiPathテクニカルサポートにも確認してみます。 @Anil_G Thank you for your comment! @cheez_RPA 岩崎さん、ご回答ありがとうございました。

This post made by @shesherao.patil received 1 likes!

Add data row error lambda expression

yes this is working.

Top 3 Most Liked Solutions

This solution provided by @cheez_RPA received 1 likes!

Manifestのバージョンが上がらない

お使いの端末が組織によってコントロールされているケースでは、個々人の対応のみではアップデートされないケースがあります。 具体的には、グループポリシーによってChrome/Edgeに導入される拡張機能が固定されている可能性があります。情報システムの管理部門等へお問い合わせいただくことをおすすめします。

This solution provided by @Yoichi received 1 likes!

Excelを作成したい

こんにちは 例えば以下になると思います。 [image] 以下の式で会社名の重複のない一覧を文字列配列で作成していますが、繰り返しアクティビティ等で 置き換えることもできます。 companies = dt.AsEnumerable.Select(Function(r) r("会社名").ToString).Distinct.ToArray Sample20230116-2L.zip (16.1 KB)

This solution provided by @Yoichi received 1 likes!

Error BC32017, BC30035, BC30516

Hi, Can you try either of the following? hqnosw.Replace(" "+hqnosw.Split(" "c).Last,"") OR hqnosw.Replace(" "&(hqnosw.Split(" "c).Last),"") 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.

[system]

Daily Forum Report | 17 January 2023

Top 3 Topics with Most Views

Hi i want solution made by @Shubham_Bidwai with 59 views.

FilePicker control doesnt return full path made by @corinna.robertson with 47 views.

Regex Extractor and new line made by @jjes with 44 views.

Top 3 Topics with Most Replies

Hi i want solution made by @Shubham_Bidwai with 49 replies.

How to click on specific part of an application without worrying about UI element made by @nmjvk with 20 replies.

Regex Extractor and new line made by @jjes with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 50 posts!

@supermanPunch made 34 posts!

@Shubham_Bidwai made 31 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How can I extract some data from a JSON file?

validating the access path: [grafik] retrievals: [grafik]

This post made by @ppr received 2 likes!

Multiple addresses in the config file

the activity expects the following: [grafik] A string Array which would be similar as hardcoded: {"xyz@gmail.coml","xyz2@gmail.com"} As you mentioned the Config file: we would assume e.g. the config as we are using in REF So we store there a string, seperated with a well known delimiter char, and split it later, to get back the string array: [grafik] e.g.: YourConfigVar("YourKey").toString.Split("|"c)

This post made by @Marius_Stan received 1 likes!

UiPath Chrome Manifest V3 Extension Released with 2022.4 Update

Hello @sishiramishra ! Indeed, Chrome has pushed back the deadline for the MV2 cutoff. What this means for you is that you are no longer forced by Chrome to upgrade to an UiPath version that has MV3 extensions for Chrome/Edge. But eventually Chrome/Edge will force the transition to MV3. And UiPath is prepared for that - all existing and future versions of UiPath will install MV3 extensions for Chrome/Edge.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How can I extract some data from a JSON file?

validating the access path: [grafik] retrievals: [grafik]

This solution provided by @ppr received 2 likes!

Multiple addresses in the config file

the activity expects the following: [grafik] A string Array which would be similar as hardcoded: {"xyz@gmail.coml","xyz2@gmail.com"} As you mentioned the Config file: we would assume e.g. the config as we are using in REF So we store there a string, seperated with a well known delimiter char, and split it later, to get back the string array: [grafik] e.g.: YourConfigVar("YourKey").toString.Split("|"c)

This solution provided by @Yoichi received 1 likes!

Vlookup Modern Activity

Hi, Do you have any error? I think it’s not necessary to indicate Range and Column Index should be 2, as the following [image] Sample20230117-3L.zip (9.1 KB) 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.

[system]

Daily Forum Report | 18 January 2023

Top 3 Topics with Most Views

How to Add Products on Home Page? made by @Vaishnav_Tej with 42 views.

Excel: Execution is very slow made by @pushkar.singh with 41 views.

The given key was not present in the dictionary in process transaction uipath made by @Manoj_sreekanth with 39 views.

Top 3 Topics with Most Replies

The given key was not present in the dictionary in process transaction uipath made by @Manoj_sreekanth with 20 replies.

Regex email from pdf issues made by @MikeC with 14 replies.

Excel: Execution is very slow made by @pushkar.singh with 14 replies.

Top 3 Users Who Posted The Most

@Sudharsan_Ka made 37 posts!

@sangeethaneelavannan1 made 27 posts!

@Anil_G made 26 posts!

Top 3 Most Liked Posts

This post made by @vishnuvarthanp received 3 likes!

Macro excel background

Hi @DimitriLYR it is possible to execute the macro without opening . please use execute macro activity inside excel application scope and provide the macro name in the activity . You need to use the macro name and not the button name. [image]

This post made by @ppr received 3 likes!

New Activity Idea - Comment with Image Data / Informative Screenshot

Idea: extend the comment activity on also storing an image or have an alternate activity Background For several reasons (documentation, knowledge transfer to team members) an illustrating screenshot would help. Extending the comment activity for defining screenshots or offering an additional activity could serve for it. Similar to other activities following functionalities should be offered for manually execution: Take informative screenshot Show Informative screenshot remove Informative s…

This post made by @indra received 2 likes!

Regex email from pdf issues

@MikeC Try this Regex [image]

Top 3 Most Liked Solutions

This solution provided by @vishnuvarthanp received 3 likes!

Macro excel background

Hi @DimitriLYR it is possible to execute the macro without opening . please use execute macro activity inside excel application scope and provide the macro name in the activity . You need to use the macro name and not the button name. [image]

This solution provided by @indra received 2 likes!

Regex email from pdf issues

@MikeC Try this Regex [image]

This solution provided by @indra received 1 likes!

Cannot create cultureinfo variable in Windows mode

@alvaro.nobre If there is any double quotes means remove and add double quotes

---

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.

[system]

Daily Forum Report | 19 January 2023

Top 3 Topics with Most Views

How to get the difference in years based on current date made by @Kunal_Jain with 45 views.

I want to loop only one row from excel in flowchart is there any way I can do that just passing number to iterate? made by @Bhushan_Nagaonkar with 39 views.

String to Double Datatable LinQ made by @DimitriLYR with 38 views.

Top 3 Topics with Most Replies

For join data table made by @Shubham_Bidwai with 19 replies.

I want to loop only one row from excel in flowchart is there any way I can do that just passing number to iterate? made by @Bhushan_Nagaonkar with 15 replies.

How to get the difference in years based on current date made by @Kunal_Jain with 14 replies.

Top 3 Users Who Posted The Most

@Anil_G made 57 posts!

@indra made 18 posts!

@sangeethaneelavannan1 made 17 posts!

Top 3 Most Liked Posts

This post made by @Sushma_Ganapatisa received 2 likes!

You successfully published a package from UiPath Studio to Orchestrator. You did not make any changes to the work, and then published it a second time successfully. When you go into Orchestrator, what will have happened?

Hello Team, Scenario: You successfully published a package from UiPath Studio to Orchestrator. You did not make any changes to the work, and then published it a second time successfully. When you go into Orchestrator, what will have happened? Options are : The package will generate an alert that no changes were made in Orchestrator A new version of the project is sent to Orchestrator only if the Release Notes for the second publish were populated A new version of the project is sent t…

This post made by @vishnuvarthanp received 2 likes!

I want to loop only one row from excel in flowchart is there any way I can do that just passing number to iterate?

Hi @Bhushan_Nagaonkar Please check the below ss: [image]

This post made by @Manoj_sreekanth received 1 likes!

Get only todays files from folder

Facing Error: ‘FileInfo’ is a type and ‘IO’ cannot be used as an expression

Top 3 Most Liked Solutions

This solution provided by @indra received 1 likes!

Check if in string there are 18 digits

@camaro123 You can use regex.ismatch so it will give Boolean result System.Text.RegularExpressions.Regex.IsMatch(str_PdfResult,“(\d{18})”).ToString [image]

This solution provided by @Anil_G received 1 likes!

Unable to Downgrade Package Windows Version Studio

@Kyleb91 This means aome activity needs this specific version of activity to function properly… So first remove the dependecy and then downgrade Cheers

This solution provided by @Anil_G received 1 likes!

SAP-FIORI data table

@dinesh.s1 Use ui explorer and check for static parts in selector Cheers

---

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.

[system]

Daily Forum Report | 20 January 2023

Top 3 Topics with Most Views

How to insert variable in open browser link made by @Riya_Bansal with 43 views.

How to split an address to a new life if it is too long? made by @NervousTuber with 42 views.

How to check if a click element is enabled or disabled made by @krishna_r with 41 views.

Top 3 Topics with Most Replies

I have one question and can ane one help me for the solution made by @Shubham_Bidwai with 18 replies.

How to insert variable in open browser link made by @Riya_Bansal with 13 replies.

Where can I find published projects made by @Povilas_Jonikas with 12 replies.

Top 3 Users Who Posted The Most

@Anil_G made 66 posts!

@Yoichi made 23 posts!

@Sudharsan_Ka made 12 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

How to Extract the fields from pdf using Regex

HI, Can you try the following sample? [image] mc = System.Text.RegularExpressions.Regex.Matches(strData,"^(?<INVREF>\S+)\s+(?<POSTDATE>\d{2}/\d{2}/\d{4}).*?(?<INVDATE>\d{2}/\d{2}/\d{4})\s+(?<GROSSAMOUNT>[-\d.,]+)\s+(?<TDS>[-\d.,]+)\s+(?<AMOUNT>[-\d.,]+)",System.Text.RegularExpressions.RegexOptions.Multiline) Then, set the following at ArrayRow {m.Groups("INVREF").Value,DateTime.ParseExact(m.Groups("POSTDATE").Value,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture),DateTime.Pa…

This post made by @fernando_zuluaga received 2 likes!

How to focus on next tab after click

Hey After clicking that button, use another attach browser activity or use application/browser activity to capture the next page, and then perform your process inside that activity

This post made by @J0ska received 2 likes!

Documentation of uipath

Dear @nora_ziani @ppr wrote you polite and relevant response. In case you want to use such offensive tone pls leave this community. Cheers

Top 3 Most Liked Solutions

This solution provided by @Kalpesh_Chaudhari received 2 likes!

Object reference not set to an instance of object in getText

if still error persists, then try to initialize the variable at start and assign empty string to it.

This solution provided by @Yoichi received 1 likes!

How to split an address to a new life if it is too long?

Hi, Is it no problem if length of 2nd line is greater than 20? If yes, the following regex will work [image] System.Text.RegularExpressions.Regex.Replace(yourString,"^(.{0,20}) ","$1"+vbcrlf) Regards,

This solution provided by @Yoichi received 1 likes!

How to Extract the fields from pdf using Regex

HI, It seems difficult to identify which string should be added to INV.REF string in the previous line. [image] If string to be added always consists of numeric characters at the beginning of the line, the following will work. (However, i suppose it may not work as there are various cases…) [image] Sample20230120-3Lv2.zip (4.6 KB) 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.

[system]

Daily Forum Report | 21 January 2023

Top 3 Topics with Most Views

Work with pending items in queue made by @Rajshri_Potekar with 40 views.

Loop through invoke workflow activities in flowchart made by @Bhushan_Nagaonkar with 37 views.

Can Check App state be run in background? made by @adrianab.98 with 32 views.

Top 3 Topics with Most Replies

Loop through invoke workflow activities in flowchart made by @Bhushan_Nagaonkar with 12 replies.

Issue running bot after moving the project to a different system made by @Ranjit_Nayak1 with 12 replies.

I want to compare two excels and update the data in third sheet in excel where each sheet contains 100k line items made by @Ranganathan_M with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 36 posts!

@sunilch made 9 posts!

@Bhushan_Nagaonkar made 7 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 1 likes!

Manage Packages Marketplace Error: No compatible version with windows projects

@Atakan_Genc On the old computer I believe you created the project in windows - Legacy…and not windows compatible You can change it when you create a new project …with the name you can also select windows,windows-legacy or cross platform Even here if you select windows-Legacy then it will show you the packages [image] Cheers

This post made by @Atakan_Genc received 1 likes!

Manage Packages Marketplace Error: No compatible version with windows projects

Thanks a lot.

This post made by @Anil_G received 1 likes!

Loop through invoke workflow activities in flowchart

@Bhushan_Nagaonkar Use read cell to read the value of the count into a variable… Now use a while loop with max iteration value as the value read from the cell… So the loop would continue for those many times Cheers

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 1 likes!

Manage Packages Marketplace Error: No compatible version with windows projects

@Atakan_Genc On the old computer I believe you created the project in windows - Legacy…and not windows compatible You can change it when you create a new project …with the name you can also select windows,windows-legacy or cross platform Even here if you select windows-Legacy then it will show you the packages [image] Cheers

This solution provided by @Anil_G received 1 likes!

Loop through invoke workflow activities in flowchart

@Bhushan_Nagaonkar This is how it looks…condition will be true means it will loop till max iteration value…which you will read from excel using read data [image] Hope this helps cheers

---

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.

[system]

Daily Forum Report | 22 January 2023

Top 3 Topics with Most Views

Separate the name made by @Muneer_Alrashdan with 44 views.

Regex Matches with Anchors made by @Beere_Plays with 40 views.

Http Request unknown host Error made by @Man_Kay_So with 35 views.

Top 3 Topics with Most Replies

RESULT からの例外:0x800706BE made by @miwa_yamamoto with 16 replies.

Unable to define solution approach for multiple attachments made by @rds0511 with 7 replies.

Cannot anchor PDF file data made by @Isabel_Chau with 5 replies.

Top 3 Users Who Posted The Most

@Anil_G made 23 posts!

@rds0511 made 8 posts!

@fernando_zuluaga made 7 posts!

Top 3 Most Liked Posts

This post made by @Anil_G received 2 likes!

Array of Strings - Compiler error BC 30311: value of type '(string, string)' cannot be converted to 'string()'

@cellery Welcome to the community For adding array you have to use flower/curly brackets not round.please try this {"John","Don"} Hope this helps Cheers

This post made by @Yoichi received 1 likes!

Can not assign 'Convert.ToDouble(row("Amount").ToString)

Hi, Which do you need to handle “24.28-”, as positive or negative? If positive Convert.ToDouble(row("Amount").ToString.TrimEnd("-"c)) +dbSumAmount If negative Convert.ToDouble(System.Text.RegularExpressions.Regex.Replace(row("Amount").ToString,"^([.,\d]+)(-)?$","$2$1")) +dbSumAmount Hope the above helps you. Regards,

This post made by @Comet received 1 likes!

Leap year

Thank you very much! This again solved my problem.

Top 3 Most Liked Solutions

This solution provided by @fernando_zuluaga received 1 likes!

What is the ideal way of creating libraries?

in every project that we develop, remove the unused dependecies will be a good practice to apply, no matters if the projects is a sequence or library etc, we should remove all of them and just keep the used dependencies. Library won’t affect the project perfomance, just remember to publish then in the orchestrator if you will move to production environment For example if you run the analyze file it will retrieve you a warning in case that you dont delete the unused depencies [image] Regards! …

This solution provided by @Yoichi received 1 likes!

Call cell from data table with Variables

Hi, Which type of variables do you use : in_dtItems, RowCount and ColumnCount? If in_dtItems is DataTable and RowCount and ColumnCount are String type and store index value of row or column, the following will work. in_dtItems( CInt(RowCount))( CInt(ColumnCount)).ToString or in_dtItems.Rows(CInt(RowCount))( CInt(ColumnCount)).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.

[system]

Daily Forum Report | 23 January 2023

Top 3 Topics with Most Views

How to pass the assign value as an argument(datatable) so that I can add the value to "add data row" activity made by @Bhushan_Nagaonkar with 64 views.

One environment per tenant? made by @jaime.salazar with 48 views.

Reframework - Add key/value pair:Column'Value' does not belong to table datatable made by @ldiaz with 47 views.

Top 3 Topics with Most Replies

(I am a beginner) . I was trying to change the variable type but it's not allowing me. I can only keep the default (string) made by @akheelahmad with 19 replies.

Cv computer click is not clickable when text is not visible made by @nora_ziani with 11 replies.

Datatable convert automatically from General Number to Date made by @IPIX with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 24 posts!

@Yoichi made 18 posts!

@sangeethaneelavannan1 made 14 posts!

Top 3 Most Liked Posts

This post made by @kakoozavian received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello here, I am Kakooza Vianey from East Africa, Kampala Uganda, currently doing the RPA Foundations with Ui Path, I have been working with automation using python and thats how I landed on Ui Path. Hope to have a great interaction here. Thank you

This post made by @jaime.salazar received 2 likes!

One environment per tenant?

I should have mentioned that I’m talking about Orchestrator Cloud (and not on-prem) because that appears to make a big difference. With the Cloud version, it seems like the multi-tenant approach is good enough, as explained by @Anil_G. On the other hand, with the on-prem version, multiple Orchestrator instances is probably best, as explained by @vishnuvarthanp. Since my case is the former, I suppose Anil’s solution is the most relevant, although I appreciate Vishnu’s as well.

This post made by @Gokul_Jayakumar received 2 likes!

I try to save excel file in today date in one specific folder

Hello @krishna_priya1 Try this "Yourpath\Samplefile_"+Datetime.now.tostring("dd_MM_yyyy")+".xlsx" If you need to save in Project loaction Environment.currentdirectory+("\Samplefile_"+Datetime.now.tostring("dd_MM_yyyy")+".xlsx").tostring

Top 3 Most Liked Solutions

This solution provided by @Gokul_Jayakumar received 2 likes!

I try to save excel file in today date in one specific folder

Hello @krishna_priya1 Try this "Yourpath\Samplefile_"+Datetime.now.tostring("dd_MM_yyyy")+".xlsx" If you need to save in Project loaction Environment.currentdirectory+("\Samplefile_"+Datetime.now.tostring("dd_MM_yyyy")+".xlsx").tostring

This solution provided by @Anil_G received 1 likes!

One environment per tenant?

@jaime.salazar So …to answer your question let me give ypu scenarios… When using on prem people prefer multiple orchestrators as it would be easier for upgrade of different environment… But when coming to automation cloud the upgrades and load balancing is not taken care by us…which is much smoother…so a multi tenant would be good as per the licensing cost and the ease of access Hope this helps Cheers

This solution provided by @marian.platonov received 1 likes!

Upgrade studio pro 2020.4 to the latest enterprise edition 2022.10.4

Here you can find the latest Enterprise UiPath Studio 2022.10.4 https://download.uipath.com/versions/22.10.4/UiPathStudio.msi

---

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.

[system]

Daily Forum Report | 24 January 2023

Top 3 Topics with Most Views

Project build: Generating synthetic test data (project) Add data row error made by @bruce.switzer with 77 views.

Need to Change Date Format from string to Date made by @manojmanu.rpa with 50 views.

How to compare the 2 excel sheets made by @Manoj_sreekanth with 46 views.

Top 3 Topics with Most Replies

PDF fields not recognizing made by @pravin_bindage with 19 replies.

How to get Excel window to foreground to send key strokes? made by @Prabin_Chand with 18 replies.

ダウンロード待機アクティビティに、『 次の拡張子の一時ファイルを無視:』が表示されない made by @masaaki.kasahara with 18 replies.

Top 3 Users Who Posted The Most

@Anil_G made 41 posts!

@Yoichi made 32 posts!

@rohin_Kumar made 19 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

Need to Change Date Format from string to Date

In addition to: In general we would recommend to use ParseExact for converting the string into a dateTime Afterwards we can reformat as needed DateTime.ParseExact(YourInputString, YourFormat, System.Globalization.CultureInfo.InvariantCulture) Format parts (in/out) are as: [grafik] [grafik] Still we would recommend to check if the Time part is really breaking Month / year in the Position Kindly note: Friday 20th Jan 2022 does not exist, it was a Thursday so parsing this date will fail […

This post made by @Anil_G received 2 likes!

S108 Exception Based Query

@Harsha_S1 Please search for the activity for each row in Datatable… else change the type argument to datarow in the current for each… or write dt_ReadRange.AsEnumerable and give type argument as datarow hope this helps cheers

This post made by @Steyn_Muller1 received 2 likes!

Assign Data Service Entities separately to text fields in UiPath Apps

Thank you so much! It works!

Top 3 Most Liked Solutions

This solution provided by @Anil_G received 2 likes!

S108 Exception Based Query

@Harsha_S1 Please search for the activity for each row in Datatable… else change the type argument to datarow in the current for each… or write dt_ReadRange.AsEnumerable and give type argument as datarow hope this helps cheers

This solution provided by @indra received 1 likes!

Regex extractor not working with alternative anchors (word a OR word b)

@NielsF Welcome to UiPath community You can use this Regex Refer this to use regex in assign activity

This solution provided by @prasadprathmeshambika received 1 likes!

ERROR - The given key was not present in the dictionary

This kind of error mostly occurred when ,key value not present in config file and you r trying to call from workflow. eg. Config(“XYZ”).To String but XYZ key not present in config file.

---

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.

[system]

Daily Forum Report | 25 January 2023

Top 3 Topics with Most Views

SQL CREATE issue made by @gpftr with 51 views.

What is the Regex for extract the total row? made by @Gopi_Krishna_Reddy1 with 50 views.

There is problem, why it occur? in split and append activity made by @sssim4567 with 45 views.

Top 3 Topics with Most Replies

あいまい検索について made by @a.kmni with 28 replies.

Group by and send email made by @rayz1503 with 20 replies.

What is the Regex for extract the total row? made by @Gopi_Krishna_Reddy1 with 15 replies.

Top 3 Users Who Posted The Most

@Anil_G made 76 posts!

@Yoichi made 36 posts!

@Sudharsan_Ka made 14 posts!

Top 3 Most Liked Posts

This post made by @evan.cohen received 2 likes!

'Process could not be started' error

To simplify management I created two roles. One that I assigned at the Tenant level: [image] And another for the folder level: [image] Then I made sure to assign the role for the Public App for the folder where my unattended automation was published: [image] What that looks like on the actual assignment screen: [image] You can validate that you’ve assigned these roles properly by checking the roles for your app under ‘Manage Access’ in Orchestrator: [image] pro-tip: when searching …

This post made by @huzaifa_sheikh received 1 likes!

UiPath Dev Dives - 2023 webinar series for developers

Excited to join this webinar.

This post made by @marian.platonov received 1 likes!

How can I open Outlook as a system admin in UiPath?

What may be the cause? The issue is due to that the target application which you are automating needs a higher privilege to interact with it. How may I overcome this behavior? You may have a couple of solutions in this case: Run the target application in a non-elevated mode or low Integrity level after which the UiPath Robot will be able to identify the application elements. Automatically start UiPath Executor as admin (Robot user should have administrator access) suitable configurations sh…

Top 3 Most Liked Solutions

This solution provided by @Ahmed_Loirdi received 1 likes!

Read Range Workbook returns me error "Implement it based on poi 4.2 in the future"

Thank you for your support, I had already had that settings. Apparently that’s an error message that pops up when a file could be encrypted. I used that workaround: Give up Read Range Workbook activity Use (inside Excel Process Scope and Use Excel Files activities) a For each Sheet in Excel Then add an If with the following condition: CurrentSheet.Name.Contains([KEYWORDS]) Finally add a Read Range from Excel package. This solution is slower but works fine

This solution provided by @rohin_Kumar received 1 likes!

Value of string cannot be converted to UI element

Hi @Bhushan_Nagaonkar, In modern design, You can delete the innertext and add the variable, Its working for me [Capture]

This solution provided by @Anil_G received 1 likes!

Uipath Support Engineer

@Harsha_S1 Might not be same everywhere but most of it would include but not limited to the following Monitor the daily jobs Raise/Fix any issues for the bots Perform enhancements and migration activities Maintain the Robot machines on a weekly basis mostly If using any ticketing system then close them as needed cheers

---

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.

[system]

Daily Forum Report | 26 January 2023

Top 3 Topics with Most Views

Trouble adding Color Detector Package to Project Dependencies made by @beatorres2 with 52 views.

Filtering dates in Excel / CSV made by @Henson_Ibon with 45 views.

Excelに記載している日付表示を変更したい made by @miwa_yamamoto with 42 views.

Top 3 Topics with Most Replies

"Column name" is not set or is invalid ? Need help fixing this made by @Ryhan_Ahmed with 19 replies.

Excelに記載している日付表示を変更したい made by @miwa_yamamoto with 17 replies.

How NOT to change separator inside quotes made by @Matheus_Dallasta with 11 replies.

Top 3 Users Who Posted The Most

@Yoichi made 48 posts!

@Anil_G made 29 posts!

@ppr made 19 posts!

Top 3 Most Liked Posts

This post made by @Diana_Tufan received 3 likes!

UiPath products now available in Traditional Chinese!

We’re happy to announce that starting with this month almost all UiPath GA products support a new language - Traditional Chinese. The new language will be supported in all products via Automation Suite starting with 2023.4. We trust this language release will enable our users from Traditional Chinese speaking markets to navigate our products easier in their own language. Please refer to this page for a full product localization overview and don’t hesitate to get in touch vi…

This post made by @supermanPunch received 2 likes!

Datatable Manipulation To Converge Specific Rows of a Specific Column

@FilipeChiou , I believe this could be done by @Yoichi 's Implementation provided above, You would just require to perform the Operation of Deciding if it is OK or not OK inside the For Each Loop and then maybe use an If Condition and decide if it is OK or NOK using an Assign Activity. As the logic of Deciding OK or NOK is still not exposed to us, we could only maybe suggest you the approach. Let us know if you were not able to understand the above approach suggested.

This post made by @FilipeChiou received 2 likes!

Datatable Manipulation To Converge Specific Rows of a Specific Column

Hi @Yoichi, I would like to apoligize, I shouldve understood your reply and think about it further rather than respond immediately (I am a beginner in UiPath), yes you are absolutely right, I dont need to create an dt_aux since I can just put an if in the for each to run only on NULL rows. I am sorry for wasting your time, I should read and understood your reply more carefully. Lesson Learned Thank you @Yoichi and @supermanPunch for your time and help, its solved now!

Top 3 Most Liked Solutions

This solution provided by @Joe_Matuch received 2 likes!

Compilation Error in Process but not in Library: "Expression Activity type 'VisualBasicValue`1' requires compilation in order to run. Please ensure that the workflow has been compiled."

Hi, everyone. This issue is most likely due to 1 or more package misalignments. Specifically, the library is using UiPath.System.Activities 22.4.5, but the process that is using that library is on 22.10.3. Furthermore, our Studio is version 22.4. Still working on confirming that this is the issue, but it is more likely than not the cause. Word for the wise: keep your versions aligned! UPDATE: Confirmed that having the 22.10.3 version in the process interf…

This solution provided by @Ranjit_Nayak1 received 2 likes!

Issue running bot after moving the project to a different system

After long time spent, found that issue was because of Check Activity, I have used this for radio buttons, check boxes. I have changed the activity based on version and this worked fine.

This solution provided by @Yoichi received 1 likes!

How do you read date from excel and compare?

Hi, It’s excel serial value. Can you try the following condition? [image] fecha_doc=DateTime.FromOADate(CDbl(fecha_SBS)).ToString("yyyy.MM.dd") 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.

[system]

Daily Forum Report | 27 January 2023

Top 3 Topics with Most Views

How to stop the bot, without Orchestrator made by @AaronMark with 44 views.

Can I have chatGPT in automated email? made by @Amy_Miller with 40 views.

[Solved] Downloading and Moving File (Couldn't read Variable and report error) made by @Jack_Tsang with 40 views.

Top 3 Topics with Most Replies

How to obtain the result of a formula with 2 decimals made by @Andreea_Nistor with 10 replies.

[Solved] Downloading and Moving File (Couldn't read Variable and report error) made by @Jack_Tsang with 9 replies.

Get-Text and TypeInto made by @Staccato with 9 replies.

Top 3 Users Who Posted The Most

@supermanPunch made 28 posts!

@Yoichi made 17 posts!

@Anil_G made 14 posts!

Top 3 Most Liked Posts

This post made by @oraganti931 received 2 likes!

System exception at initialization: Failed setting the current sheet to: Sheet1 in workbook:

Thank you everyone for your quick response @Anil_G @Ashish_Saxena @Sudharsan_Ka . The issue has been resolved. The issue because of excel application itself. Due to some alerts i have got that error. Once i have clicked ok for all of that then it has been resolved. Thank you Aravind

This post made by @madepablo received 1 likes!

[HowTo] - Find Duplicate / NonDuplicate rows - checking all columns - without explicit listing the colnames/index

Many thanks, it solves me a big problem

This post made by @mortoman received 1 likes!

Attaching to Chromium API protocol failed. To use Chromium API on this page, please close any extension pop-up using a different input method

Nice, this fixed it for me because I had LastPass enabled. Thank you sir

Top 3 Most Liked Solutions

This solution provided by @jack.chan received 1 likes!

How can I get the screenshot file name which is auto created using "Verify" activities?

@jadhavsiddh use this to get latest file of the screenshots folder, this will give you the file name you need new DirectoryInfo("screenshotFolderPath").GetFiles().OrderByDescending(Function(f) f.LastWriteTime).First().ToString

This solution provided by @Sudharsan_Ka received 1 likes!

Regular Expressions available in StudioX?

Hi @bibalesecret Yes you can use Regular Expression in StudioX System.Text.RegularExpressions.Regex.Match("YourString","Your Pattern").Tostring If you want to use activities Go to Activities panel-> Filter-> Click on Show Developer You can find Matches and Is match Activity [image] [image] Regards Sudharsan

This solution provided by @Yoichi received 1 likes!

Split the String into even and odd values

Hi, The above expression also works. [image] 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.

[system]

Daily Forum Report | 28 January 2023

Top 3 Topics with Most Views

I could not able add data into table made by @Manju_Reddy_Kanughula with 58 views.

Running SQL Query in unattended mode made by @ASRG with 41 views.

How to Store the three string value in datable which is coming from the cv get text made by @Neha_Aggarwal1 with 38 views.

Top 3 Topics with Most Replies

How to Store the three string value in datable which is coming from the cv get text made by @Neha_Aggarwal1 with 14 replies.

Comparing Dates and than Year to find out if the difference is of 5years or 10 years or 15 years or more made by @Kunal_Jain with 8 replies.

Download an excel, read its range, filter date, copy them into another excel made by @Jack_Tsang with 7 replies.

Top 3 Users Who Posted The Most

@Anil_G made 17 posts!

@Neha_Aggarwal1 made 8 posts!

@sangeethaneelavannan1 made 8 posts!

Top 3 Most Liked Posts

This post made by @Sanjit_Pal received 1 likes!

Rounding to two decimal places, to the nearest 0.05

Hey @Muneer_Alrashdan , You can use the below method double value = 3.14159; double roundedValue = Math.Round(value / 0.05) * 0.05; where value is the number which you want to do Round off Thanks, Sanjit

This post made by @Anil_G received 1 likes!

I need to scrape a data table from a webpage but the items has kind of different places in page

@Darius_Blaga Use a for each ui element activity and indicate the whole card as one item… [image] Inside that use get children activity to get the children and now use loop inside it and then use get text inside loop…and identify the required dates if present get …them else nove on Cheers

This post made by @Farah_halawani received 1 likes!

Send Windows Hotkey

[d(ctrl)]n[u(ctrl)] works Thank you

Top 3 Most Liked Solutions

This solution provided by @Sanjit_Pal received 1 likes!

Rounding to two decimal places, to the nearest 0.05

Hey @Muneer_Alrashdan , You can use the below method double value = 3.14159; double roundedValue = Math.Round(value / 0.05) * 0.05; where value is the number which you want to do Round off Thanks, Sanjit

---

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.