Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 April 2021

Top 3 Topics with Most Views

Yoichi 1000th Solution Flag Celebration made by @ppr with 51 views.

Enter password without get credentials made by @Sakshi_Jain with 36 views.

32bit版端末でUiPathの動作確認・運用をしたい made by @I.S with 33 views.

Top 3 Topics with Most Replies

Yoichi 1000th Solution Flag Celebration made by @ppr with 24 replies.

Extract data using regex made by @ashishmani with 16 replies.

Assign value from One datatable to another made by @MLT with 13 replies.

Top 3 Users Who Posted The Most

@prasath_S made 27 posts!

@ppr made 24 posts!

@Yoichi made 15 posts!

Top 3 Most Liked Posts

This post made by @ppr received 14 likes!

Yoichi 1000th Solution Flag Celebration

@Yoichi Congrats to your 1000th Solution Flag. Many thanks for your support to the community and the valuable help. Let’s celebrate this event with you and the community.

This post made by @Yoichi received 10 likes!

Yoichi 1000th Solution Flag Celebration

@ppr @prasath17 Thank you for your kind messages. I’m happy to be able to contribute even a little to this great community. Let’s continue to do our best. Best regards, Yoichi

This post made by @prasath17 received 6 likes!

Yoichi 1000th Solution Flag Celebration

Congrats @Yoichi … Let’s Celebrate I have bookmarked lot of your solutions and used in my various projects…thank you so much for your continued support…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

データテーブルのフィルター方法

こんにちは 複雑な条件の場合、フィルターデーターテーブルアクティビティでは実現が難しいと思います。 保持したいのであれば newDt = dt.AsEnumerable.Where(Function(r) r("Column1").ToString.StartsWith("t") AndAlso r("Column2").ToString.StartsWith("h") AndAlso System.Text.RegularExpressions.Regex.IsMatch(r("Column3").ToString,"^00\d99/..\d\d$")).CopyToDataTable 例は削除したいようなので、削除したいのであれば newDt = dt.AsEnumerable.Where(Function(r) not (r("Column1").ToString.StartsWith("t") AndAlso r("Column2").ToString.StartsWith("h") AndAlso System.Text.RegularExpressions.…

This solution provided by @prasath17 received 1 likes!

How to get value in mail body outlook

@LucastoH - If you are having same pattern in all the email, then you can use Regex and write the results in the datatable inside the for each … [image] Regex pattern Link. Hope this helps…

This solution provided by @cheez_RPA received 1 likes!

32bit版端末でUiPathの動作確認・運用をしたい

Windows 7 を利用して開発/実行したい場合、現状、エンタープライズ版のうち 2019.10 シリーズのみ利用可能です。2019.10 シリーズは 32 bit に対応していることが、ドキュメントに記載されております。 なお 2019.10 シリーズのサポート終了は 2022年11月 に予定されています。 ご存知のことと思いますが、Windows 7はサポートが終了しています（エンタープライズ向けに延長サポートを購入することは出来ますが）。UiPath以外のソフトウェアもサポートが終了しているか、または今後サポートを終了していくことが考えられますので、まずはWindows 7での運用環境を見直していただくのが良いかと思います。

---

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 April 2021

Top 3 Topics with Most Views

I get the error in the App data, The UiPath Assistant is required to complete this action made by @copy_writes with 45 views.

Tip: How to Detect SAP Server Side Scripting Settings made by @StefanSchnell with 44 views.

UiPath Integrations Meetup Series made by @Vibhor.Shrivastava with 43 views.

Top 3 Topics with Most Replies

I get the error in the App data, The UiPath Assistant is required to complete this action made by @copy_writes with 23 replies.

Find digit made by @rsr with 17 replies.

Extraction from UI Element made by @Yudhisteer_Chintaram1 with 14 replies.

Top 3 Users Who Posted The Most

@prasath_S made 23 posts!

@Yoichi made 23 posts!

@copy_writes made 22 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 6 likes!

UiPath Integrations Meetup Series

[UiPath-LinkedIn-20Apr21_Meetups_on_Integrations (1)] We are happy to announce the meetup series on UiPath Integrations Join these meetups to simplify process automation for industry-leading enterprise software with officially supported API Integrations from UiPath. Auto-deploy UiPath on AWS and Automate Critical AWS Operations 2021-05-13T12:00:00Z (UTC) → 2021-05-13T13:30:00Z (UTC) This session is for RPA developers and IT DevOps Engineers who want to levera…

This post made by @Yoichi received 4 likes!

Yoichi 1000th Solution Flag Celebration

Thanks @Yuki_Uzuki

This post made by @TonyNudd received 4 likes!

Is it possible to connect Uipath with IOT projects

Hi, Thanks for the plug @NIVED_NAMBIAR Typically IoT solutions need to handle Event-Driven data. The best way to do this is in production for example, is to connect UiPath Orchestrator to Node-RED … See the link below. I have also created some personal IoT projects with Arduino and Raspberry-PI … I used the UiPath Custom Activity Builder to attach robots to a Bluetooth connection… not recommended for mission critical but allows home IoT projects controlled by RPA to be created. The overview …

Top 3 Most Liked Solutions

This solution provided by @TonyNudd received 4 likes!

Is it possible to connect Uipath with IOT projects

Hi, Thanks for the plug @NIVED_NAMBIAR Typically IoT solutions need to handle Event-Driven data. The best way to do this is in production for example, is to connect UiPath Orchestrator to Node-RED … See the link below. I have also created some personal IoT projects with Arduino and Raspberry-PI … I used the UiPath Custom Activity Builder to attach robots to a Bluetooth connection… not recommended for mission critical but allows home IoT projects controlled by RPA to be created. The overview …

This solution provided by @Yoichi received 1 likes!

「image exists」がアクティビティの一覧にない

こんにちは モダンデザインになっているのではないでしょうか？ アクティビティパネルのフィルターを開いてクラシックを表示の欄があれば これをチェックしてみてください。 [img20210420-4] あるいはStudioXプロファイルになっている可能性もあるかもですが… （緑色ベースの画面ならこちらの可能性があります）

This solution provided by @cornelius.nowald received 1 likes!

Get Modern Folder FullyQualifiedName as Index in Log Target

Hi @rdgagp, I think I found a way which might work using some srcipts the query the Orchestrator API for the folder FQNs and sanitizes them using ES index aliases . Based on this folder structure [image] I create index aliases using the ES API (manually sanitizing the names for this test) PUT /default-1-33*/_alias/logtestfolder PUT /default-1-34*/_alias/logtestfolder_logtestfolderson PUT /default-1-35*/_alias/logtestfolder_logtestfolderson_logtestfoldergrandson then queried to check inf t…

---

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 April 2021

Top 3 Topics with Most Views

How do i solve length cannot be less than zero? made by @SIM_JUN_HUI_BERTRAM_CSOD with 38 views.

Robot Master Badge Request made by @Bala_Ashokan with 36 views.

How to convert variable value into date made by @Reddy_1 with 35 views.

Top 3 Topics with Most Replies

EMERGENCY! I cannot get into any of my Orchestrator Tenants in the cloud. Help! made by @AndyMenon with 15 replies.

Click on Button Selector made by @Sahil_Garg1 with 15 replies.

Click Checkbox in a table based on dynamic values made by @tilarapiyush with 15 replies.

Top 3 Users Who Posted The Most

@prasath_S made 33 posts!

@ppr made 18 posts!

@Yoichi made 18 posts!

Top 3 Most Liked Posts

This post made by @apurba2samanta received 2 likes!

Our new look for Orchestrator is here!

Welcome to the UiPath community @Alexandra_Gurita! It’s great that UiPath modifies its products frequently and this version of Orchestrator looks very nice. Thanks & Regards, Apurba Samanta

This post made by @pthfs1 received 2 likes!

要素が配列の連想配列の初期化について

できました！ 調べても情報がなく途方に暮れてました。 誠にありがとうございます。

This post made by @Yoichi received 2 likes!

要素が配列の連想配列の初期化について

こんにちは 以下お試しください。 New Dictionary(Of String,String())

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

要素が配列の連想配列の初期化について

こんにちは 以下お試しください。 New Dictionary(Of String,String())

This solution provided by @flavius received 2 likes!

Error - Cannot Open Item

Seems a problem with the Nuget cache. Could you please try deleting the Packages folder in the %USERPROFILE%/.nuget folder? And, after this, try to create a new project in StudioX again? [image]

This solution provided by @vignesh.ks received 2 likes!

How to choose folder and file from date as string?

Hi @fairymemay For this scenario, do the below steps: Split the date with “/” and assign the arrayofstring to variable. Check whether the folder was exists. If yes, then just write the excel or else, create the folder with year and write the excel. Attached screen shot for your reference. [image] In WriteRange activity, give path like this: your2020FolderPath+"\"+splitingString(2)+"\Report "+splitingString(1)+"."+splitingString(2)+".xlsx" Feel free to reach us at any time if you have do…

---

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 April 2021

Top 3 Topics with Most Views

Separate File path from File name made by @Latif with 42 views.

How to get the value for each row made by @Tharusha_Fernando with 36 views.

Datatableで特定の行の特定の値の取得方法 made by @zuka with 29 views.

Top 3 Topics with Most Replies

How to print output as a string made by @Sharma_Sania with 24 replies.

Separate File path from File name made by @Latif with 16 replies.

How to show a message with the total of lines and with a specific column that was extracted made by @Gabriel_Mascarenhas with 15 replies.

Top 3 Users Who Posted The Most

@prasath_S made 26 posts!

@ppr made 19 posts!

@Yoichi made 16 posts!

Top 3 Most Liked Posts

This post made by @ppr received 4 likes!

How to get the value for each row

@Tharusha_Fernando give a try on following prepare a result datatable e.g. dtResult = dtOrigVar.Clone Add a column Total to dtResult with add datacolumn activity use an assign activity: left side: dtResult right side: (From d in dtOrigVar.AsEnumerable Let t = {"car loan","housing loan","food", "transport"}.Sum(Function (x) Convert.ToInt32("0" & d(x).toString.Trim)) Let ra = d.ItemArray.Append(t).toArray Select dtResult.Rows.Add(ra)).CopyToDataTable

This post made by @Rohan_Goswami received 3 likes!

Do you tried the Ui path Forum Progressive Web App

Hey folks, Do you noticed that Ui path forum website has the option to download the website as a PWA. I noticed it today, this is a pretty cool feature try it if you haven’t. [1112]

This post made by @ppr received 2 likes!

How to divide a number and get results with decimals

find some basics: [grafik] [grafik] and give a try on: [grafik]

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

配列をDatatableに格納したい

こんにちは おそらくオーソドックスなのは @Eric_Wong_Test さんが提示した方法になります。 ただし、この方法はBuildDataTableやReadRange等で事前にDataTableを構成しておかねばなりません。 一方Generate DataTableを使った方法は上記の制限がありますので、これらご注意ください。

This solution provided by @ppr received 1 likes!

How to get the value for each row

lets assume you want to sum up all columns: Let t = d.ItemArray.Sum(Function (x) Convert.ToInt32(“0” & x.toString.Trim)) Lets assume you want to sum up not all columns but all with the name 1,2,3…30 Let t = Enumerable.Range(1,30).Sum(Function (x) Convert.ToInt32("0" & d(x.toString).toString.Trim))

This solution provided by @raheelferoze received 1 likes!

Data Manager not opening

Hi @Pablito it sounds weird but the Data manager was working on Incognito but not on browser. and yes I cleared the cookies and it worked fine in normal browser

---

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 April 2021

Top 3 Topics with Most Views

Csvのテーブルから別のテーブルに行追加したい made by @zuka with 73 views.

Get spesific row item made by @Aditya_Nugroho with 62 views.

Data to the last row in excel but not the last row made by @CoolRobot with 51 views.

Top 3 Topics with Most Replies

Get spesific row item made by @Aditya_Nugroho with 14 replies.

Csvのテーブルから別のテーブルに行追加したい made by @zuka with 13 replies.

How to maximize the excel file that i open? made by @SIM_JUN_HUI_BERTRAM_CSOD with 12 replies.

Top 3 Users Who Posted The Most

@prasath_S made 12 posts!

@Yoichi made 11 posts!

@prasath17 made 10 posts!

Top 3 Most Liked Posts

This post made by @Vibhor.Shrivastava received 5 likes!

HyperHack - Automation for Good challenge!

Hello, #uipath community, Hope you are all progressing well with your Hackathon solution, busy building team, or brainstorming ideas. If you are willing to participate and still looking for some ideas. Here are some needs and problem statements you can consider and help NGOs / associations we closely work with. We want to be transparent with all the participants hence sharing details here and help connect interested folks to the contact person for further discussion. Few important points: We…

This post made by @sishiramishra received 2 likes!

HyperHack - Automation for Good challenge!

@Vibhor, Our team name is BOT-Factory, we would be interested in part of: #The Social Incubator (Use case 1) Our Team: @sishiramishra @lovely.sinha , (One more user yet to confirm)!!

This post made by @Anmol_Yadav received 2 likes!

HyperHack - Automation for Good challenge!

Hi Vibhor. We (RPA Kriegers) confirm the topic 1 and 4 of NGO Teach for Romania. One more team member will also be joining us. Thanks, Anmol

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 2 likes!

Regex to select word in the next line of a string

@VB_Tech_pro - here you go… [image] (?<=SGD AMOUNT\s+\r?\n?\d+\s+)\S+ Assumption: SGDAmount always present in the previous line… Hope this helps…

This solution provided by @amitbhatt55 received 1 likes!

What is the maximum page limit of OCR Engines embedded with UiPath Studio

Hi @loginerror, This is resolved long back. UiPath Studio embedded OCR Engines are not having any page limit.

This solution provided by @Yoichi received 1 likes!

Csvのテーブルから別のテーブルに行追加したい

こんにちは 現在のインデックスプロパティにInt32型変数としてiを定義しておいてください。 [img20210423-9]

---

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 April 2021

Top 3 Topics with Most Views

Filter some data in excel file made by @maroua301 with 26 views.

PDF content in to in to excel table made by @srilakshmi_Tippireddy with 24 views.

Loop through application until data table is null? made by @Tristan_Stumpf with 24 views.

Top 3 Topics with Most Replies

Need help with data scraping from sub links made by @tabbyd with 8 replies.

PDF content in to in to excel table made by @srilakshmi_Tippireddy with 7 replies.

How to get latest downloaded file in a workflow or sequence? made by @Vishal_Singh1 with 5 replies.

Top 3 Users Who Posted The Most

@wasea made 9 posts!

@Mikolaj_Zielinski made 7 posts!

@Shraddha_Gore made 6 posts!

Top 3 Most Liked Posts

This post made by @prasath17 received 3 likes!

PDF content in to in to excel table

@srilakshmi_Tippireddy - I will try my best to provide the patterns by looking at the pic… TO: (?<=TO\s?:).*(?=\sINVOICE) For the above use…Regexvar(0).value.trim… INVOICE NUMBER = (?<=ISSUE DATE\r\n\s+)\w+ ISSUE DATE = (?<=ISSUE DATE\r\n\s+\w+\s+)\w+ CUSTOMER CODE = (?<=DUE DATE\r\n.*)\S+(?=\s+\d{2}\w{3}\d{4}) INR = (?<=GRAND TOTAL AMOUNT IN\s?)\w{3} AMOUNT = (?<=GRAND TOTAL AMOUNT IN.*)[\d.]+ Hope this helps…

This post made by @prasath17 received 2 likes!

Move various files with the same extension type

Hi @Cruz_Becerril_Alliso - Please try this… Directory.GetFiles(Environment.ExpandEnvironmentVariables("%USERPROFILE%\Downloads\"),"*.xml") [image] For Each "Type Argument’ is string. Hope this helps…

This post made by @Shriharsha_H_N received 1 likes!

Uipath Marketplace ! BalaReva Word Activities

Thanks @balupad14 its working now i updated the package

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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 April 2021

Top 3 Topics with Most Views

How to access the offcial and connet packages? made by @fightblue with 29 views.

How to delete a last row in excel file when the data is dynamic? made by @Vishal_Singh1 with 28 views.

https://forum.uipath.com/t/310189 made by @fairymemay with 28 views.

Top 3 Topics with Most Replies

How to resolve 'Copy Sheet' error in excel? made by @Dorothy_lee with 15 replies.

Not able to maximize the window from taskbar made by @Vishal_Singh1 with 15 replies.

Condition always true! made by @Mohammed_Bakr with 6 replies.

Top 3 Users Who Posted The Most

@wasea made 13 posts!

@prasath_S made 7 posts!

@Vishal_Singh1 made 6 posts!

Top 3 Most Liked Posts

This post made by @prasath_S received 2 likes!

Invoke Vb.NET Code dictionary error

Hi @Hara_Gopal In UiPath you have to create a new dictionary variable inside invoke code and assign that dictionary to your output dictionary variable. Try this, Dim dict As New Dictionary (Of String, String) Dim item, key, val As String Try For Each item In lst 'lst is a list passed as input key = item.Split(CChar(":"))(0).ToString.Trim val = item.Split(CChar(":"))(1).ToString.Trim dict.Add(key, val) Next emailDict = dict Catch e As Exception console.WriteLine(e) console.WriteLin…

This post made by @NIVED_NAMBIAR received 2 likes!

Invoke Vb.NET Code dictionary error

Hi @Hara_Gopal I think u had forget to declare the dictionary Can u try this code Dim dictionary As New Dictionary (Of String, String) Dim item, key, val As String Try For Each item In lst 'lst is a list passed as input key = item.Split(CChar(":"))(0).ToString.Trim val = item.Split(CChar(":"))(1).ToString.Trim emailDict.Add(key, val) Next Catch e As Exception console.WriteLine(e) console.WriteLine(e.Message) console.WriteLine(e.Source) End Try Regards Nived N …

This post made by @pat_lee received 1 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi Everyone, I am Patrick. I have been a software consultant for more than 25 yrs, My Job is to train people in accounting software and management reporting. With uipath I hope I can intergrade Uipath to the software to make its more easier to generate report.

Top 3 Most Liked Solutions

This solution provided by @wasea received 1 likes!

Download file from web to a specific folder

hello @Brennan_Montoni , You can use the Wait for download activity to do this. try and let us know if works. Vasile.

---

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 April 2021

Top 3 Topics with Most Views

What's new in Action Center 21.4? made by @Liji with 37 views.

Save Attachment - Length cannot be less than zero made by @Louis_liu with 36 views.

Splitting Excel in various columns made by @Yudhisteer_Chintaram1 with 34 views.

Top 3 Topics with Most Replies

Delete rows in excel if value in a column is "D" made by @Brennan_Montoni with 19 replies.

Splitting Excel in various columns made by @Yudhisteer_Chintaram1 with 17 replies.

How to pull out all files with modified date less than seven days in a folder? made by @Kelsey_Dane with 17 replies.

Top 3 Users Who Posted The Most

@Jayesh_678 made 26 posts!

@Pankaj.Patil made 19 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @Liji received 6 likes!

What's new in Action Center 21.4?

Since our last updates in 20.10 where we released a dedicated Action Center portal for business users, we have been focusing on enabling our customers to scale operations using Action Center based automations by on-boarding more business users as well as by broadening the scenarios being automated. What’s new in business user experience and Actions handling ? Multi-user handling of Form Actions by forwarding Actions to other Users [ForwardActions] Action summary panel to keep track of th…

This post made by @alvaro.j.nobre received 2 likes!

UIPath Studio freezes when I right click on project

That solved it. Thank you for your quick and effective response.

This post made by @Yoichi received 2 likes!

携帯電話にSMSを送信したい

こんにちは UiPathからの直接のSMS送信は難しいので、Twilio等のサービスを経由して行う場合が多いかと思います。

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

携帯電話にSMSを送信したい

こんにちは UiPathからの直接のSMS送信は難しいので、Twilio等のサービスを経由して行う場合が多いかと思います。

This solution provided by @Srini84 received 1 likes!

Error: Object invoked has disconnected from its client?

@SIM_JUN_HUI_BERTRAM_CSOD can you share your screenshot of workflow? Also tell us is it causing due to looping into many files? Thanks

This solution provided by @Yoichi received 1 likes!

範囲を読み込みが途中で終わってしまう

こんにちは Localsパネルのビューアーはすべての情報を出力するわけではないので、今回のケースの確認方法と してはあまりよくないと思います。 WriteLineやLogMessageあるいは、ブレイクポイントで実行を停止しているなら Immediateパネルで dt.Rows.Countの様にDataTableの行数を確認してみると 良いように思います。 [img20210426-6]

---

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 April 2021

Top 3 Topics with Most Views

🚀 Registration for UiPath DevCon is closing soon! Join us for FREE June 15-16 made by @teresa with 60 views.

Object Detection Virtual Event - Discussion made by @Radu_Buciu with 36 views.

How to find month before today 3 days (working day)? made by @fairymemay with 28 views.

Top 3 Topics with Most Replies

データテーブルの値を配列に変換したい made by @zuka with 14 replies.

How to take cc from excel sheet while sending mail in uipath made by @Sudha_Jha with 13 replies.

Excel Update - Help made by @Anjali_Rani with 12 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 26 posts!

@prasath17 made 18 posts!

@Yoichi made 17 posts!

Top 3 Most Liked Posts

This post made by @teresa received 10 likes!

Registration for UiPath DevCon is closing soon! Join us for FREE June 15-16

Registration for UiPath DevCon is closing soon! Join us for FREE June 15-16. We’re excited to share that UiPath DevCon is BACK for 2021! Read more below or register right away! Our annual conference by developers, for developers is coming up this June 15-16, 2021. This virtual event brings together our technical community around the world for two days of learning, building, and connecting. We’re covering topics like Inter-process Communication, Object Repository, an…

This post made by @Radu_Buciu received 6 likes!

Object Detection Virtual Event - Discussion

Hi! I’m Radu from Neurolabs. We have created this topic to discuss about object detection in the UiPath workflows. We encourage you to share your thoughts, challenges, use cases or any ideas related to this topic. Let’s extend the current RPA capabilities beyond the screen by identifying objects in images or videos! What will follow is a webinar 2021-04-28T11:30:00Z (UTC). You can join it here:

This post made by @Geoff received 2 likes!

New enterprise-scale features now live!

With today’s regular update of Automation Cloud, we’re excited to announce that the following new enterprise-scale features have moved out of preview to be fully available (some today, some last week). These features focus on lowering your total cost of ownership for automation and making your automation environment easier to manage with better compliance. Automation Cloud for Enterprise customers can now exclusively take advantage of: Azure AD Integration : Customers with an Azure AD get aut…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Get specific tags from an XML document

Hi, Do you want to extract “ClaveProdServ” attribute and “Importe” attribute? If so, the following helps you. [img20210427-1] Sample20210427-1.zip (5.3 KB) Regards,

This solution provided by @Rome received 1 likes!

Uipath Studio shows blank

Hi All, Issue resolved. From my end we are suspecting some license issue connecting to orchestartor. What we did is we updated via Home>Setting>License and Profile>Change Local License. We select acquire license to orchestrator then auto restart the uipath studio. open again the studio select the workflow and you will encounter the same as per screenshot above. But when you click NEW…in the background the workflow appear. see screenshot below. [uipath]

This solution provided by @NIVED_NAMBIAR received 1 likes!

How to find month before today 3 days (working day)?

Hi @fairymemay I had updated the workflow check this Main.xaml (13.2 KB) the output i got [image] Regards, Nived N Happy Automation

---

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 April 2021

Top 3 Topics with Most Views

UiPath Marketplace - Automation Ideas Board made by @Andreea_Stroe with 53 views.

Dynamic folder creation made by @Nivetha_R with 33 views.

How to tackle with overlapping text in a Document? made by @raheelferoze with 32 views.

Top 3 Topics with Most Replies

Dynamic folder creation made by @Nivetha_R with 10 replies.

Filter Data Table activity deletes cells made by @achalisma with 8 replies.

How to read a different date format and write the output in a different format? made by @lmoham with 8 replies.

Top 3 Users Who Posted The Most

@ppr made 24 posts!

@Hiba_B made 18 posts!

@Techpriest made 11 posts!

Top 3 Most Liked Posts

This post made by @Andreea_Stroe received 9 likes!

UiPath Marketplace - Automation Ideas Board

Hello, We are very excited to share with you the latest news from UiPath Marketplace! We know how enthusiastic the RPA Community is when it comes to automation and we want to help you in your efforts! Today we have released a public Trello board containing automation ideas that we believe are not touched upon yet and would make an impact on everyone’s way of work. This comes as a result of a massive content review - we wanted to spot the gaps and allow everybody who wants to…

This post made by @DeaTo received 3 likes!

Object Detection Virtual Event - Discussion

You’ll be able to find the recording in the event page :See How to Detect Objects in Images & Videos using UiPath Robots at UiPath EMEA&APAC Virtual Events

This post made by @ppr received 2 likes!

Keep string after a certain word

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

データテーブルの値を配列に変換したい

こんにちは DataTable 側がnullなのではないでしょうか？

This solution provided by @HANACCHI received 1 likes!

Datediff関数の戻り値について

[image] こんな感じです。ご参考まで。

This solution provided by @Hiba_B received 1 likes!

Need to have XML activity for Uipath 2019.10.6

No because it’s not in .nupkg format (as would be an activity in UiPath terms). It’s in xaml format, so if you want to call it as a package you will need to open the xaml file of Paramatrix, create as a library from it (basically copy/paste the code + argument): [image] Then you will be able to publish it from library options, then you will be able to call the package from Manage packages at a local level [image]

---

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 | 29 April 2021

Top 3 Topics with Most Views

https://forum.uipath.com/t/311215 made by @SIM_JUN_HUI_BERTRAM_CSOD with 43 views.

Convert MMMM to MM made by @fairymemay with 36 views.

Convert UI element to 1 Decimal Place made by @Yudhisteer_Chintaram1 with 35 views.

Top 3 Topics with Most Replies

https://forum.uipath.com/t/311215 made by @SIM_JUN_HUI_BERTRAM_CSOD with 14 replies.

Using list values in a "add data row "activity made by @Dhouha_Cherif with 10 replies.

Convert UI element to 1 Decimal Place made by @Yudhisteer_Chintaram1 with 9 replies.

Top 3 Users Who Posted The Most

@prasath_S made 23 posts!

@ppr made 14 posts!

@Hiba_B made 13 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 2 likes!

Tip: How to Build Your Own SAP Accelerator

Since a few month are very interesting Accelerators for SAP at UiPath Marketplace available. In my opinion is the approach of mapping technical interfaces into Excel spreadsheets extremely interesting. That is why I have extended my RFM code generator so that it can also generate a corresponding Excel workbook from the interface description of an remote enabled function module, aka RFC. This provides an easy way to create a frame for SAP API automation. And precisely this aspect I would like to …

This post made by @Hiba_B received 2 likes!

Download UiPath Remote Runtime on standalone studio enterprise edition

Great ! Then don’t forget to mark your topic as solved so people that have the same problem find your topic as the solved one ^^ Thanks Pablito

This post made by @wasea received 2 likes!

UIpath Remote Runtime Download

Hello @alvaro.j.nobre , You can download the file from cloud platform. You have the option to download the correct version of it. Go to : https://cloud.uipath.com/ Click on HELP (left down) [image] The resource center page will open In the right side, you have the options to download the executables that you want. [image] Install the msi. I hope it helps. Vasile.

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Combining Two IEnumerables of UiElements into a Single DataTable with LINQ

@ashwin.ashok lets assume both Lists have reliable same count of items the datatable col structure is 2 cols (name,adress) and an empty datatable is available - dtFinal Give a try on (From i in Enumerable.Range (0, ListName.Count) Let ra = {ListName,ListAddr}.Select(Function (x) x(i).Get(“innertext”)).toArray Select dtFinal.Rows.Add(ra)).CopyToDataTable ListName = your List_UIElement of the names

This solution provided by @prasath17 received 1 likes!

Convert UI element to 1 Decimal Place

@Yudhisteer_Chintaram1 - Please try this… Math.round(cdbl(Item),2).ToString(“N1”)) [image] Hope this helps…Actually clue was in your previous post, i have posted the reference link from Microsoft docs too… [image]

This solution provided by @pavanh003 received 1 likes!

In abbyy flexicapture setup station, how can I check for a checkbox value by c# script?

Hi, if (this.Field(“F1”).Value == true){ this.Field(“F1”).Value = this.Field(“F2”).Value } I have writtien it using javascript in abbyy rule section for the field. I am getting the expected result. Try this way, may be it will help. Let me know if not. Regards, pavan H

---

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 | 30 April 2021

Top 3 Topics with Most Views

Delete multiple CSV or Excel columns and column range made by @markosc with 31 views.

Extract working date made by @Amin with 31 views.

ジョブを実行する際にロボットを選択できない。 made by @smochidolphine with 31 views.

Top 3 Topics with Most Replies

Copy Range Keeping Formulas made by @sereganator with 10 replies.

Today's Date Coming Wrong Suddenly(Project Notebook -> Date Sheet ) made by @ayewale with 10 replies.

Start Process activity, how to best wait for completion made by @rogerfries with 9 replies.

Top 3 Users Who Posted The Most

@alexandretperez made 14 posts!

@ppr made 11 posts!

@prasath17 made 11 posts!

Top 3 Most Liked Posts

This post made by @MBSHansen received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello, my name is Mikkel and I joined as I am currently going through the UiPath RPA Associate Certification Training, and have a few questions to optimize the way i build my workflows. I am looking forward to learning with all of you.

This post made by @wasea received 2 likes!

Chrome Save As

Hi @Minol_Pamosha , If it’s related to the file path, you can put it in the file name and it will save the file at the new path. Not needed to change the path from the upper address bar. Something like this: [image] Just an idea. Vasile.

This post made by @SIM_JUN_HUI_BERTRAM_CSOD received 2 likes!
https://forum.uipath.com/t/311365/6

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Excel splitting a column value to multiple columns

@bhishaj Welcome to the forum give a try on doing the extraction with the help of regex e.g. [grafik] [grafik] [grafik] [grafik] etc. Also have a look here:

This solution provided by @prasath17 received 1 likes!

Convert excel column to 2 decimal places

@Yudhisteer_Chintaram1 - After using “MidpointRounding.AwayFromZero” issue has fixed… Math.Round(cdbl(row("NW Elasthane")),2,MidpointRounding.AwayFromZero).ToString("N2")) Please see the ouput below: [image]

This solution provided by @prasath_S received 1 likes!

Delete multiple CSV or Excel columns and column range

You can use invoke VBA activity for this, Do this one time on excel, In order for this activity to work, Trust Access to the VBA project object model must be enabled from Excel (File > Options > Trust Center > Trust Center Settings > Macro Settings > Select the Trust Access to the VBA project object model check box). Put the code on text file, Sub macro() Range(“AC1”).entirecolumn.delete Range(“CM1”).entirecolumn.delete Range(“CO1”).entirecolumn.delete Range(“CQ1”).entirecolumn.delete R…

---

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 | 01 May 2021

Top 3 Topics with Most Views

Reading pdf with regex. how to continue when he's not finding the object? made by @Nightowl_music with 28 views.

Introducing UiPath Insights Cloud made by @Michelle_Yurovsky with 26 views.

アクティビティ「要素が出現したとき」の結果の出力について made by @111131 with 26 views.

Top 3 Topics with Most Replies

Reading pdf with regex. how to continue when he's not finding the object? made by @Nightowl_music with 6 replies.

The current limit for the length of lists is Int32 i.e a max of 256 elements can be kept in it. How do I increase it or make it dynamic so that I can keep unlimited number of elements in the list? made by @Jaideep with 5 replies.

System rule exception and business re made by @airwaveexporter with 4 replies.

Top 3 Users Who Posted The Most

@Sakshi_Jain made 12 posts!

@wasea made 12 posts!

@ayewale made 7 posts!

Top 3 Most Liked Posts

This post made by @Michelle_Yurovsky received 3 likes!

Introducing UiPath Insights Cloud

Introducing UiPath Insights Cloud We are so excited to introduce you to the newest member of the UiPath Automation Cloud family, Insights Cloud ! A purpose-built analytics solution now available for Automation Cloud Enterprise customers, Insights Cloud helps you track, measure and report on the performance and business impact of your RPA operations. Gain operational awareness with a library of pre-built dashboard templates, customizable with any combination of widgets…

This post made by @wasea received 1 likes!

UI path overwriting .pdf attachments with same name while downloading from outlook

Hello @Beatriz_Eugenia_Duqu , Interesting thig from my check is if you’re using the UiPath Studio with C# project, the attachment files with the same name will be saved with an appended number (_1,_2,_3…). I have also a project created in VB. To avoid the overwrite issue, I pass in the filter, the attachment name [image] I hope it helps. Vasile.

This post made by @cheez_RPA received 1 likes!

アクティビティ「要素が出現したとき」の結果の出力について

この動作であれば、「要素の有無を判定」（Element Exists）アクティビティをお使いいただくのが良いかと思います。 こちらのアクティビティは、出力に指定したBoolean型の変数に下記のとおりに保存します。 要素が存在する場合には True 要素が存在しない場合には False

Top 3 Most Liked Solutions

No solutions received a like yesterday
Please like some solutions to fill this space .

---

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 | 02 May 2021

Top 3 Topics with Most Views

Array Error made by @Dorothy_lee with 25 views.

Can not open Uipath these day. Help,I don't know what happened? made by @233214496 with 24 views.

Splitting one excel file to multiple excel files made by @adarsh_kotagiri with 23 views.

Top 3 Topics with Most Replies

If Cell format = "dd/MM/yy" then Situation 1 otherwise 2 made by @Soudios with 8 replies.

Can not open Uipath these day. Help,I don't know what happened? made by @233214496 with 7 replies.

Add New Column Values To A Datatable using existing Column Values And Change Format Of The Entire Column Values to Number (Using Linq - Both The Case) made by @Ashish6541 with 5 replies.

Top 3 Users Who Posted The Most

@josephatomwanzia made 9 posts!

@wasea made 9 posts!

@Soudios made 8 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

IENumerable<Match> Regex Group fast way to Datatable

lets assume the datatable has only 1 col then give a try: create an empty datatable with the column - dtResult use an assign activity left side: dtResult right side (from m in IENumerable.Cast(of Match) Select dtResult.Rows.Add(m.Groups(1).toString)).CopyToDataTable

This post made by @Adrian_Star received 1 likes!

How to convert date format(mm/dd/yyyy) to (dd/mm/yyyy) and also how to change string into date format

Hi, new_date = DateTime.ParseExact(string_date.ToString,"DD-MMM-YY", Globalization.CultureInfo.InvariantCulture).ToString("DD/MM/YYYY")

This post made by @wasea received 1 likes!

UI path overwriting .pdf attachments with same name while downloading from outlook

Like this: [image]

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

IENumerable<Match> Regex Group fast way to Datatable

lets assume the datatable has only 1 col then give a try: create an empty datatable with the column - dtResult use an assign activity left side: dtResult right side (from m in IENumerable.Cast(of Match) Select dtResult.Rows.Add(m.Groups(1).toString)).CopyToDataTable

This solution provided by @Yoichi received 1 likes!

How to use the updated kill process

Hi, Can you try the following? [img20210502-3] Regards,

This solution provided by @Yoichi received 1 likes!

XML Deserialize won't work because of xmlns attribute

Hi, xmlns="http://tempuri.org/" means default XML namespace. So can you try the following? [img20210502-2] 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 | 03 May 2021

Top 3 Topics with Most Views

Type into - Date Field made by @Nelson.R with 42 views.

Get date from email:{subject, body, attachments} made by @Sakshi_Jain with 36 views.

Excel after header A and B write a formula made by @CoolRobot with 29 views.

Top 3 Topics with Most Replies

Type into - Date Field made by @Nelson.R with 15 replies.

How to give reply to same mail chain through outlook by adding today's date in the subject? made by @anjasing with 9 replies.

Click activity not click made by @fairymemay with 7 replies.

Top 3 Users Who Posted The Most

@Pankaj.Patil made 16 posts!

@NIVED_NAMBIAR made 10 posts!

@fairymemay made 8 posts!

Top 3 Most Liked Posts

This post made by @CoolRobot received 2 likes!

Excel after header A and B write a formula

Thanks you is working perfectly

This post made by @Pankaj.Patil received 2 likes!

Excel after header A and B write a formula

@CoolRobot, Take two write cell activities and provide formula into value property =Text(C1203, ““MMM””) Second one, write as it is, no change in it

This post made by @NIVED_NAMBIAR received 2 likes!

To calculate birth year automatically?

Hi @vaigunth_rey welcome to forum use this in message box to get the age CInt(birthday)-CInt(year) Regards, Nived N Happy Automation

Top 3 Most Liked Solutions

This solution provided by @Pankaj.Patil received 2 likes!

Excel after header A and B write a formula

@CoolRobot, Take two write cell activities and provide formula into value property =Text(C1203, ““MMM””) Second one, write as it is, no change in it

This solution provided by @NIVED_NAMBIAR received 2 likes!

To calculate birth year automatically?

Hi @vaigunth_rey welcome to forum use this in message box to get the age CInt(birthday)-CInt(year) Regards, Nived N Happy Automation

This solution provided by @markosc received 1 likes!

Sort Datatable by two columns

(From x In datatable.AsEnumerable() Order By convert.ToInt32(x(“Column2”)), convert.ToString(x(“Column11”)) Select x).CopyToDataTable

---

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 | 04 May 2021

Top 3 Topics with Most Views

Need solution on blank columnsIf made by @pravin.shigwan with 35 views.

Extracting URL from single string made by @Basak_Demirel with 32 views.

Excel Regex Extract Date made by @Yudhisteer_Chintaram1 with 31 views.

Top 3 Topics with Most Replies

Excel Cell values not being checked correctly due to containing special characters? made by @struggling_student with 13 replies.

Extracting URL from single string made by @Basak_Demirel with 10 replies.

PDF to XML made by @Mohammed_Junaid with 10 replies.

Top 3 Users Who Posted The Most

@ppr made 23 posts!

@josephatomwanzia made 15 posts!

@struggling_student made 10 posts!

Top 3 Most Liked Posts

This post made by @iamwiliamb received 3 likes!

Orchestrator with Apollo Design System is here!

Hey all, Just wanted to announce everyone that starting today, the new look for Orchestrator using our new Apollo Design System is now available in Community! We hope you’ll like Orchestrator even more now and that you will get to love our new look and feel! You can find more details about what changed here: Our new look for Orchestrator is here! If there’s anything that you don’t like or would like us to change, suggest it here and we’ll get in touch with you! Thanks and have a fabulous Tue…

This post made by @sarathi125 received 2 likes!

How to insert Tab delimeter in Text file

@adarsh_kotagiri, Try with this workflow, it may help you. It needs an input excel from your desktop named as “Data.xlsx” with sheet1. Tab_Delimiter.xaml (9.3 KB)

This post made by @ppr received 2 likes!

How to insert Tab delimeter in Text file

@adarsh_kotagiri we can do like following: read range - readin excel write CSV - configured wit delimiter to tab https://docs.uipath.com/activities/docs/write-csv-file

Top 3 Most Liked Solutions

This solution provided by @sarathi125 received 2 likes!

How to insert Tab delimeter in Text file

@adarsh_kotagiri, Try with this workflow, it may help you. It needs an input excel from your desktop named as “Data.xlsx” with sheet1. Tab_Delimiter.xaml (9.3 KB)

This solution provided by @prasath_S received 2 likes!

Excel Regex Extract Date

Hi @Yudhisteer_Chintaram1 Please try this Main.xaml (9.2 KB) In Invoke Code dt1.AsEnumerable().ToList().foreach(sub(row) row(“Date”) = System.Text.RegularExpressions.Regex.Matches(row(“INV Date / BL Date”).ToString,“\d{1,2}/\d{1,2}/\d{1,4}”,RegexOptions.RightToLeft)(0)) Pass you datatable as in/out argument [image] Use write range to check if values are correct Thanks

This solution provided by @Nelson.R received 1 likes!

Type into - Date Field

Found what I was looking for: Get the System Date Format - #5 by Kabeer So for my case the only solution I could think of is to read a text file that has the system date format written in it.

---

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 | 05 May 2021

Top 3 Topics with Most Views

Write full Date Format in Excel column made by @Yudhisteer_Chintaram1 with 35 views.

Filter table by 2 Columns made by @markosc with 35 views.

Retrieving Conversation ID from mail box made by @rakshitha.shetty with 34 views.

Top 3 Topics with Most Replies

Publish error: Regex.Match non declared made by @Danny_Gi with 18 replies.

Move PDFs based on Name in specific Folders made by @Yudhisteer_Chintaram1 with 17 replies.

Write full Date Format in Excel column made by @Yudhisteer_Chintaram1 with 12 replies.

Top 3 Users Who Posted The Most

@Yudhisteer_Chintaram1 made 19 posts!

@josephatomwanzia made 17 posts!

@Adrian_Star made 16 posts!

Top 3 Most Liked Posts

This post made by @AndersJensen received 3 likes!

Filter data By Strikethrough In Excel?

Hey @Aaron_Ko For sure. I’ve created a simple VBA script for you, which does the job (checks if there is a Strikethrough). If yes, write “1” in the next column. We invoke it with an “Invoke VBA” activity inside an “Excel Application Scope” activity. Everything is attached. The simple Excel dataset (attached as Book1.xlsx) [image] The VBA code to invoke (attached as StrikeThrough.txt) Sub StrikeThrough() For n = 1 To Rows.Count If Range("A" + CStr(n)).Font.StrikeThrough Then Range("B…

This post made by @Steven_McKeering received 3 likes!

Regex for date

Hi A full list of your expected date formats is needed to build a robust Regex pattern. In the meantime, try this pattern:

This post made by @ppr received 2 likes!

Manually creating a TransactionItem/QueueItem w/o an Orchestrator queue

the prepared Dictionary has to be assigned on YourTransactionItemVar.SpecificContent Property

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

Linq Query, Please Help!

@kantheshm give a try on following prepare an empty datatable with build datatable reflecting the target datacolumn strucutre: Col1 – Col2 - Col3 Variable: dtResult then use an assign activity left side: dtResult right side: (From d in dtData.AsEnumerable Group d by k1=d(“Col3”).toString.Trim,k2=d(“Col4”).toString.Trim into grp=Group Let s = grp.Sum(Function (x) CInt(x(“Col2”).toString.Trim)) Ler ra = new Object(){k1,s,k2} Select dtResult.Rows.Add(ra)).CopyToDataTable Also have a loo…

This solution provided by @AndersJensen received 1 likes!

Difficulty with modern folders

Hey @tainan.ramos Creating unattended robots in the new Modern Folder Orchestrator environment was the question I got the single-most. I’ve created this “get started” guide Feedback is very welcome. [🤖 Unattended Robots in Uipath Orchestrator (Full Tutorial)]

This solution provided by @Hiba_B received 1 likes!

Write full Date Format in Excel column

Hi @Yudhisteer_Chintaram1 ! Here is a suggestion: Date_conversion.xaml (9.7 KB) Beware, there is a strange date format at the end. I took care of it in the code through Try Catch but I wanted to let you know if it’s a forbidden/forgotten date format: [image]

---

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 | 06 May 2021

Top 3 Topics with Most Views

Document Understanding - Data Manager Public Preview in Automation Cloud made by @alexcabuz with 56 views.

【UiPathアカデミー】新規コースリリース＆【UiPath 認定資格】日本語版バウチャーストアリリース made by @Taeko_UiPath with 52 views.

Help in HTML pls made by @evan.joy.celino with 38 views.

Top 3 Topics with Most Replies

Help in HTML pls made by @evan.joy.celino with 26 replies.

How to Append file excel 2 sheet? made by @fairymemay with 25 replies.

Data type for combination of text and numbers made by @evan.joy.celino with 17 replies.

Top 3 Users Who Posted The Most

@Yoichi made 26 posts!

@prasath17 made 19 posts!

@evan.joy.celino made 18 posts!

Top 3 Most Liked Posts

This post made by @Taeko_UiPath received 5 likes!

【UiPathアカデミー】新規コースリリース＆【UiPath 認定資格】日本語版バウチャーストアリリース

平素より、UiPathアカデミーをご愛顧いただき誠にありがとうございます この度新たに2つのコースをリリースいたしました UI操作を伴わない処理の自動化 コース 個人用ワークスペースの活用 コース UiPath 製品に関する知識の拡充にお役に立てればと思います ぜひご活用くださいませ また、UiPath認定資格 日本語版受験チケット用バウチャーストアがリリースされました 受験チケットをまとめてご購入が可能となるため、 複数人や団体でのご受験の計画・管理する際にお役立ていただけます ※試験言語（日本語または英語）により購入ページが異なります 英語版にて受験をご希望される方は、こちらよりご購入いただけます 引き続きUiPath をよろしくお願いいたします

This post made by @alexcabuz received 5 likes!

Document Understanding - Data Manager Public Preview in Automation Cloud

We are happy to announce the public preview release of the Document Understanding Data Manager version for Automation Cloud! Data Manager is the key tool used to build datasets for training Document Understanding ML Models in AI Center, but it was only publicly available on premises until now. Starting today, we have brought the convenience and ease of use of Automation Cloud to Data Manager. If you have AI Center in the Cloud, then you have Data Manager! The vers…

This post made by @Eric_Wong_Test received 2 likes!

Selector issue with Outlook

Esign*

Top 3 Most Liked Solutions

This solution provided by @Eric_Wong_Test received 2 likes!

Selector issue with Outlook

Esign*

This solution provided by @ppr received 2 likes!

ForEach Segment RowSets

we assume that you are meaning: 19 - Rows Count, 250 Segment Size it is working withour error: [grafik] Maybe you can share some more details on your implementation. Especially on the part where the Random is used. Thanks

This solution provided by @tlano received 1 likes!

Box Integration Activities - Now in Public Preview!

Thanks! Very helpful

---

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 | 07 May 2021

Top 3 Topics with Most Views

指定文字数未満の行を削除したい made by @miwa_yamamoto with 37 views.

How to add watermark to word automatically to word file using uipath made by @Gowtham_Srinivasan with 31 views.

How To Select a TAB in Forms Based on Certain Condition? made by @hsendel with 30 views.

Top 3 Topics with Most Replies

How To Select a TAB in Forms Based on Certain Condition? made by @hsendel with 12 replies.

Using Regex With Different Text Format made by @Sahil_J_Patel with 11 replies.

Data scaping only in 1 page made by @Tharusha_Fernando with 10 replies.

Top 3 Users Who Posted The Most

@prasath17 made 17 posts!

@Yoichi made 17 posts!

@Hiba_B made 14 posts!

Top 3 Most Liked Posts

This post made by @Zrinko_Zalik received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello. Thank you for the warm welcome. I’m sort of new in UiPath, I had some experience in it about a year and a half ago but starting this monday I’m a full time RPA DevOp so going trough the academy and finding solutions here on the forum helps a lot. I hope that I will contribute to the community.

This post made by @prasath17 received 2 likes!

Match file name and move

Hi @Beatriz_Eugenia_Duqu - Below one line copy all the .pdf and .xml files to the destination [image] array.ForEach(Directory.GetFiles("DeleteFiles\", “*”, SearchOption.AllDirectories).Where(Function(s) s.EndsWith(".pdf") Or s.EndsWith(".xml")).ToArray,Sub(x) File.Copy(x,"MoveFiles\"+ Path.GetFileName(x))) Above code copy the files from DeleteFiles folder to MoveFiles folder…

This post made by @Yoichi received 2 likes!

Can't get value when using Matches activities

Hi, Can you try the following sample? Sample20210507-2.zip (2.9 KB) The pattern will be (?<name>.*)\r?\n\r?\n(?<Role>.*)\r?\n\r?\nDOB:\s+(?<DOB>\d{2}-\w{3}-\d{4})\r?\n\r?\nEmail:\s+(?<Email>.*)\r?\n\r?\nMattermost:\s+(?<Mattermost>.*)\r?\n\r?\nSkype:\s+(?<Skype>.*) Regards,

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

Can't get value when using Matches activities

Hi, Can you try the following sample? Sample20210507-2.zip (2.9 KB) The pattern will be (?<name>.*)\r?\n\r?\n(?<Role>.*)\r?\n\r?\nDOB:\s+(?<DOB>\d{2}-\w{3}-\d{4})\r?\n\r?\nEmail:\s+(?<Email>.*)\r?\n\r?\nMattermost:\s+(?<Mattermost>.*)\r?\n\r?\nSkype:\s+(?<Skype>.*) Regards,

This solution provided by @JayakumarSanthanam received 2 likes!

Data scaping only in 1 page

There is chance that there’s difference in page 2 element layouts. Try making another scraping selector for page 2 onwards and test if it works going forward. If this works, you need to first identify page 2 before proceeding to the specific scraping Thanks

This solution provided by @jvanmarion received 1 likes!

How we can schedule the task by using Orchestrator

You can use triggers for that. Take a look here.

---

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 | 08 May 2021

Top 3 Topics with Most Views

Copy data from one excel sheet to Another made by @abhide with 27 views.

Scraping linkedin post from a certain profile made by @Basak_Demirel with 26 views.

How can I extract an embedded PDF from an XML file? made by @Reginald with 26 views.

Top 3 Topics with Most Replies

How to convert feedback input into equivalent grade (number) made by @raymond_barlis with 6 replies.

Copy data from one excel sheet to Another made by @abhide with 5 replies.

How can I extract an embedded PDF from an XML file? made by @Reginald with 5 replies.

Top 3 Users Who Posted The Most

@wasea made 18 posts!

@Mikolaj_Zielinski made 5 posts!

@sunny_singh made 5 posts!

Top 3 Most Liked Posts

This post made by @kchang received 1 likes!

Problem with unattended robot and browser

On the UIPath forum I’ve seen a post regarding using tscon to disconnect from an RDP session but leave the GUI active. UiRobot run in Remote desktop I’ve see a similar post here for different use case Disconnecting From Remote Desktop While Running Automated Tests | TestComplete Documentation What I tried was from cmd as administrator, I ran “query session” to get my Session Name. Then ran " %windir%\System32\tscon.exe RDP-Tcp# NNN /dest:console" substituting my Session Name for “RDP-Tcp#NNN”…

This post made by @Gayathri_Ramanathan received 1 likes!
https://forum.uipath.com/t/312905/4

This post made by @StefanSchnell received 1 likes!

How to use Java Selenium in Combination with UiPath

Based on my approach about the using of JShell (Java REPL) here, an integration scenario of Java source code into UiPath, now an use case to integrate Java Selenium regression automation tests. Selenium is a portable framework for testing web applications. In business exists many sources which uses Selenium client and web driver language bindings in Java language. With this approach the existing automations can be used furthermore. Preparation Besides the OpenJDK I built two other packages. T…

Top 3 Most Liked Solutions

This solution provided by @Shraddha_Gore received 1 likes!

Copy data from one excel sheet to Another

Hi, use Merge Data Activity to get expected output. Your final Data Table will have following columns : ID, Import, Export, WW10, WW11, WW12, WW13, WW14, WW15, Unnamed Column. Remove Unnamed Column. Then write this final Data Table to excel sheet.

---

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.