Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 April 2021

Top 3 Topics with Most Views

"Navigate Browser" not working made by @Khrystyna_Sarakhman with 34 views.

How to Remove the space in between the lines made by @anbarasu.k with 30 views.

特定の文字列を含むファイルを削除したい made by @nagumo with 25 views.

Top 3 Topics with Most Replies

"Navigate Browser" not working made by @Khrystyna_Sarakhman with 10 replies.

How to Remove the space in between the lines made by @anbarasu.k with 7 replies.

How to pick specific row value in next iteration made by @rsr.chandu with 5 replies.

Top 3 Users Who Posted The Most

@Yoichi made 10 posts!

@sangL made 10 posts!

@Hiba_B made 9 posts!

Top 3 Most Liked Posts

This post made by @chris.hill2000 received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, My name is Chris. Im currently in Canberra. I have about 20 years IT experience and 5 of those in Automation and Monitoring using different products. I am now associated with designing and developing IT solutions fit for Automation - for Accounting and Tax firms/businesses. I am new the the UiPath products but really enjoy its capabilities for this field (Accounting/ Bookkeeping/Tax). Im looking forward to leaning as much as I can! Happy Automating

This post made by @nagumo received 2 likes!

特定の文字列を含むファイルを削除したい

途中のパスに”確認”が含まれておりました・・ 気付かなかったです。。 無事に解決出来ました！ ありがとうございました！

This post made by @JiYeon received 2 likes!

Citrix VDI환경에서의 Unattended Robot 원격실행 팁

안녕하세요. Citrix VDI에서 Unattended Robot 원격실행에 대한 경험을 공유합니다. 윈도우에는 Console 세션과 RDP 세션이 있습니다. [ Console 세션 ] 아래와 같이 설정한 경우 Robot과 사람이 함께 화면을 볼 수 있습니다. Robot 실행 중에 Console을 열어도 Robot을 끊지 않고 작업이 수행되는 것을 볼 수 있습니다. [image] Login to Console이 disable 인 경우(기본 설정) Robot이 실행 중일 때 사람이 원격 화면을 열면 Robot 이 끊깁니다. 일반적으로 Desktop has been disconnected 에러가 발생합니다. [ RDP 세션 ] Unattended Robot을 연결한 경우 기본 설정은 아래와 같이 되어 있습니다. 아래를 변경하지 않고도 일반적으로 Robot은 원격 실행이 잘됩니다. 다만, 사람과 Robot이 함께 화면을 봐야 한다면 위의 설명된 설정(Login to …

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

特定の文字列を含むファイルを削除したい

こんにちは 上記ですべてのファイルが消えてしまうということは、途中のパス名に「確認」という文字が 含まれているからではないでしょうか？ もしそうであれば条件分岐の条件欄は System.IO.Path.GetFileNameWithoutExtension(item.ToString).Contains("確認") とすると、ファイル名の部分のみを評価してくれます。

This solution provided by @anokhiraaz received 1 likes!

Duplicate Values Count increment - HELP

Hi,Anjali You can also use this Approach.This is suitable if there is large amount of data. By using Generic.dictionary key,value pair You can solve this. Try this…Hope this will work for you. Mark this as Solution , if it works. Main.xaml (15.3 KB) output:- [image]

This solution provided by @prasath17 received 1 likes!

How to create Multiple folders with last moth dates

@balaji.S - Please try like this… [image] startDate = Convert.ToDateTime(New DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month-1, 1)) endDate = Convert.ToDateTime(New DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month-1, System.DateTime.DaysInMonth(System.DateTime.Now.Year, System.DateTime.Now.Month-1))) Here startDate and EndDate are of variable type “DateTime” For Each [image] Create Folder "LastMonthFolders" + item.ToString(“dd-MM-yyyy”) My Outp…

---

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

Top 3 Topics with Most Views

Run a Normal Process and a Background Process at same time made by @murat.karasoy with 25 views.

アウトプットexcelファイルの処理結果書き込みについて made by @R_Y with 21 views.

PowerShellを呼び出し made by @atuoko8694 with 20 views.

Top 3 Topics with Most Replies

Select query for column name with space or "&" or "/" made by @ranjani with 5 replies.

Run a Normal Process and a Background Process at same time made by @murat.karasoy with 4 replies.

End Processing After X Number of the Same Error made by @Tyler294 with 4 replies.

Top 3 Users Who Posted The Most

@ppr made 7 posts!

@AndyMenon made 3 posts!

@Aleem_Khan made 3 posts!

Top 3 Most Liked Posts

This post made by @balaji.S received 1 likes!

How to create Multiple folders with last moth dates

@prasath17 many thanks for your efforts , this is absolutely working fine.

This post made by @ppr received 1 likes!

How to fix this package error

@Tharusha_Fernando issue is related to UiPath.System.Activities and/or its dependended packages [grafik] ensure the feed is activated and the network is not blocking the feeds

This post made by @sebastien.raimbault received 1 likes!

Since 21.4 robot with "studio pro" is refusing connection with error "authentication required"

More info on issue faced, I confirm this is proxy related. Laptop with fresh install 21.4, but at home “without coporate VPN connected”, open’s Studio OK immediately and get’s my named licence studio pro (floating) from tenant in Orchestrator cloud, at first trial. @Lim_Leng, I’ve found your recent post on proxy issue for you too, related to last release 2021.4. Very interested in reading next step on this.

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

Top 3 Topics with Most Views

LINE WORKS というアプリが全画面表示できません made by @nagumo with 27 views.

Data Manager에서 직접 지원하지 않는 OCR 엔진을 사용하여 레이블링하는 방법 made by @Minoh_Kang with 23 views.

表抽出ウィザードがでてこない made by @Xiao1 with 23 views.

Top 3 Topics with Most Replies

Could not add Robot manually made by @Sakshi_Gupta with 14 replies.

Web formunu excel verileriyle doldurun ve excel'e aktarın made by @ridvanucok with 10 replies.

LINE WORKS というアプリが全画面表示できません made by @nagumo with 8 replies.

Top 3 Users Who Posted The Most

@Dorothy_lee made 5 posts!

@NIVED_NAMBIAR made 5 posts!

@Pravin_Patil1 made 5 posts!

Top 3 Most Liked Posts

This post made by @Karuna received 1 likes!

"idx" value of the Website is changing randomly and couldn't find out the pattern and also the selectors to be used to fetch the target

@Nimesh_Bc Try some workarounds Use Get Attribute" activity —> Retrives the value of a specified attribute of UI element —> Specify, Attribute = Innertext Use “Anchore Base” activity —> This should be used when reliable selector is not availble.

This post made by @kumar.varun2 received 1 likes!

UiPath email regex explaination?

Can anyone explain this regex used to get the email address? It is given in the ‘Matches’ activity. (?>[a-zA-Z\d!#$%&'*+\-\/=?^_`{|}~]+\x20*|"((?=[\x01-\x7f])[^"\\]|\\[\x01-\x7f])*"\x20*)*(?<angle><))?((?!\.)(?>\.?[a-zA-Z\d!#$%&'*+\-\/=?^_`{|}~]+)+|"((?=[\x01-\x7f])[^"\\]|\\[\x01-\x7f])*")@(((?!-)[a-zA-Z\d\-]+(?<!-)\.)+[a-zA-Z]{2,}|\[(((?(?<!\[)\.)(25[0-5]|2[0-4]\d|[01]?\d?\d)){4}|[a-zA-Z\d\-]*[a-zA-Z\d]:((?=[\x01-\x7f])[^\\\[\]]|\\[\x01-\x7f])+)\])(?(angle)>)

This post made by @nagumo received 1 likes!

LINE WORKS というアプリが全画面表示できません

UiPath初心者です LINE WORKS というアプリを使用したロボットを作成したのですが、LINE WORKS のアップデート後から全画面表示が出来なくなりました。 ①「プロセスを開始」でLINE WORKS を開いて、 ②「ウィンドウにアタッチ」でLINE WORKS を開いているウィンドウを指定して、 ③「ウィンドウを最大化」という流れです。 上記の方法以外でウィンドウを最大化させる方法はございませんでしょうか？ よろしくお願いいたします。

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

Top 3 Topics with Most Views

Changes of the SAP GUI Scripting made by @StefanSchnell with 96 views.

How to Use Regex or Split Method made by @Reddy_1 with 38 views.

How to count amount by status? made by @fairymemay with 34 views.

Top 3 Topics with Most Replies

Excel印刷設定方法 made by @miwa_yamamoto with 17 replies.

Search for a list of filenames from the excel in a directory made by @NSharma05 with 9 replies.

Error to Write Formula in Excel made by @lourena.coutinho with 8 replies.

Top 3 Users Who Posted The Most

@Srini84 made 18 posts!

@prasath17 made 11 posts!

@HANACCHI made 10 posts!

Top 3 Most Liked Posts

This post made by @StefanSchnell received 5 likes!

Changes of the SAP GUI Scripting

For all of you who work with the SAP GUI Scripting API here a list of all changes in release 7.60 and 7.70 in the last two years. Having this information at a glance is very interesting. Document history: 7.70 PL 1 - Published 05.04.2021 7.70 PL 2 - Published 24.06.2021 7.70 PL 3 - Published 05.08.2021 7.70 PL 4 - Published 03.11.2021 7.70 PL 5 - Published 21.01.2022 7.70 PL 6 - Published 31.03.2022 7.70 PL 7 - Published 24.06.2022 7.70 PL 8 - Published 04.08.2022 7.70 PL 9 - Published…

This post made by @NIVED_NAMBIAR received 5 likes!

How to write status success in the cell hear am using LINQ

Hi @copy_writes Use invoke code with dt1 variable as In/Out dt1.AsEnumerable.Where(Function(r) String.IsNullOrWhiteSpace(r(“Status”).ToString.Trim)).ToList().ForEach(Sub(row) row(“Status”) =“Success”) Here i am updating status with Sucess for demnstration, but u can add status according to yours After the invoke code, use write range to write the dt1 to the excel file Regards, Nived N Happy Automation

This post made by @voineacristian90 received 3 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi everyone, My name is Cristian Voinea and I am really excited to join this community. I got here through a friend that recommended the Reboot Your Skills program but also wanted to get to meet the members of this community and perhaps even contribute to it soon. Wish you all a wonderfull week!

Top 3 Most Liked Solutions

This solution provided by @NIVED_NAMBIAR received 5 likes!

How to write status success in the cell hear am using LINQ

Hi @copy_writes Use invoke code with dt1 variable as In/Out dt1.AsEnumerable.Where(Function(r) String.IsNullOrWhiteSpace(r(“Status”).ToString.Trim)).ToList().ForEach(Sub(row) row(“Status”) =“Success”) Here i am updating status with Sucess for demnstration, but u can add status according to yours After the invoke code, use write range to write the dt1 to the excel file Regards, Nived N Happy Automation

This solution provided by @Mr_Meeseeks received 3 likes!

Remove empty lines from .txt file

@LZlz Can Do! First Do a Read Text activity then an Assign activity (Use .TrimEnd) Finally do a Write Text activity [image] Before [image] After [image]

This solution provided by @prasath17 received 2 likes!

Error to Write Formula in Excel

@lourena.coutinho - Please check this… [image] In Excel… [image] Hope this helps… Note: Since you have double quotes, you have to use ““Attention!”” like this , if not write cell will show an error.

---

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

Top 3 Topics with Most Views

Take the survey: The State of the RPA Developer 2021 made by @teresa with 83 views.

Excel操作 made by @Jel with 82 views.

How to count the number of rows in the each group? made by @anonymous3 with 67 views.

Top 3 Topics with Most Replies

Concatenate 2 Column into 1 Column made by @Anggara_Rahmadhani with 19 replies.

I'm new to UiPath, can't get a regex to work made by @Gabriel_Wisniewski with 12 replies.

Data scraping remains in the same web page made by @hamdan.hadeel with 12 replies.

Top 3 Users Who Posted The Most

@Srini84 made 28 posts!

@prasath_S made 21 posts!

@NIVED_NAMBIAR made 12 posts!

Top 3 Most Liked Posts

This post made by @danielasstavares received 5 likes!

Reboot Your Skills Program - Introduce Yourself!

Hi, I’m Daniela, join from Portugal! I’m a student. I hope being able to learn more about RPA.

This post made by @teresa received 5 likes!

Take the survey: The State of the RPA Developer 2021

Hey everyone, The survey for the State of the RPA Developer 2021 is here! You might recall that we ran this industry survey last year for the first time to capture the current experience of RPA developers. (Read last year’s report: The State of the RPA Developer 2020.) Over 1,500 of you responded last year, and we got such great feedback that we’re doing it again. We’ve added in some new questions to get some fresh insights—and we’ll explore year over year trends. And for students? We’…

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

Reboot Your Skills Program - Introduce Yourself!

Hi All, My name is Vibhor Shrivastava and I am a Community Manager, APAC at UiPath. I am responsible to drive various programs for the UiPath Community such as meetups, hackathons, and all sorts of community engagement activities. I am based in the Silicon Valley of India which is Bangalore. I am learning automation so that I can address and help #uipathcommunity queries and guide them in the best possible ways. I would love to automate a process that can help me capture details of all-new vide…

Top 3 Most Liked Solutions

This solution provided by @yukino received 2 likes!

日付として値が存在するか判定したい

和暦は説明も実装も面倒くさいんや・・・（苦笑） こんな感じになりますが、ちょっと読んでみてもらえます？ Main.xaml (7.4 キロバイト)

This solution provided by @Pravin_Patil1 received 1 likes!

How can I download StudioX?

@julie.t.duncan Welcome to Community! Follow the below steps to get Studio X Go to setting of UiPath studio when it open Go to the License and profile option Go to view or change profile Select Studio X then it will ask you to restart studio click yes. Refer below. [image] [image] Note: Follow the same step to get back to Studio from Studio X

This solution provided by @HANACCHI received 1 likes!

Excel印刷設定方法

"Sheet1"が対象となるはず。。。 改造してみました。エントリメソッドのパラメタに、対象シート名を{}で括って指定してみてください（例ではSheet3を対象とした） PrintSet.txt (714 バイト) [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 | 07 April 2021

Top 3 Topics with Most Views

テキストファイルをデータテーブルに made by @111884 with 34 views.

Getting unicorn name to be the email signature made by @jeremy.lim with 31 views.

Got error when open week1 video made by @ron.liu with 29 views.

Top 3 Topics with Most Replies

No compiled code to run made by @Jenni_K with 13 replies.

Calculate Client Security Hash - Result 0/100 made by @mustak.rased with 12 replies.

Getting actors age from web and writing down in excel made by @xyzxyz_123 with 12 replies.

Top 3 Users Who Posted The Most

@Hiba_B made 24 posts!

@prasath_S made 18 posts!

@nashrahkhan made 13 posts!

Top 3 Most Liked Posts

This post made by @cosminSimion received 3 likes!

Week1 Build your first automation project is not changing status

Hey @Victor_Villa_MM-JZ, congrats for completing your first milestone. If your progress is not updated yet, please try the following steps: Open “Welcome to Week 1” module again [Screenshot 2021-04-07 at 09.38.46] Scroll all the way down and select “Exit Page” [Screenshot 2021-04-07 at 09.40.18] Refresh your Course Page This should update your progress status. However, if this doesn’t work, please go here, and complete the contact details. You should select Academy for “What i…

This post made by @jane.rowe received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi There, My name is Jane Rowe and I am an administrator at La Trobe University in Melbourne, Australia. I have joined other uni members to learn RPA so am taking the Reboot Your Skills course. Looking forward to a new experience. Cheers Jane

This post made by @rkym123456 received 2 likes!

日付として値が存在するか判定したい

回答ありがとうございます。 パラメータ内の順番が違っており、修正したところ上手くいきました。 大変ありがとうございました。

Top 3 Most Liked Solutions

This solution provided by @cosminSimion received 3 likes!

Week1 Build your first automation project is not changing status

Hey @Victor_Villa_MM-JZ, congrats for completing your first milestone. If your progress is not updated yet, please try the following steps: Open “Welcome to Week 1” module again [Screenshot 2021-04-07 at 09.38.46] Scroll all the way down and select “Exit Page” [Screenshot 2021-04-07 at 09.40.18] Refresh your Course Page This should update your progress status. However, if this doesn’t work, please go here, and complete the contact details. You should select Academy for “What i…

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

Could not load file or assembly 'ClosedXML, Version=0.87.0.0' How to remove the reference of this version from the project

Okay, Please update the dependencies mentioned below, UiPath.Excel.Activities UiPath.MicrosoftOffice365.Activities Update the package and try running the process. Thanks Happy Automation

This solution provided by @melanie.p received 1 likes!

Runtime Execution Error: Unexpected PDF structure - Exception Type: BitMiracle.Docotic.pdf.UnexpectedStructureException

Hi @GreenTea thanks a lot for answering. I looked into it a bit more because Copy File Activity was not an option, because many users in the department will use it and its kinda “unsexy” to copy it to everyones local path to use the process. I found out that there was a hidden file named Thumbs.db in the folder which was the first file that would be read. I now did configure the Directory.GetFiles() to get just PDF or Word Files, so the Thumb.db will be ignored. The process is now working agai…

---

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

Top 3 Topics with Most Views

【UiPathアカデミー】UiPath Orchestrator のコースが新しくなりました！ made by @Taeko_UiPath with 90 views.

Kill process issue made by @mannu.1996.08 with 31 views.

I am not able to download Ui Path from the link provided.....the page is not being loaded inspite of good internet connection, pls help made by @Garima_Soni with 27 views.

Top 3 Topics with Most Replies

Kill process issue made by @mannu.1996.08 with 19 replies.

Excel merge cell and delete empty row made by @Shiva_Kumar1 with 17 replies.

Write cell : Root Element is Missing made by @Ganesh_S1 with 15 replies.

Top 3 Users Who Posted The Most

@Srini84 made 20 posts!

@ppr made 20 posts!

@mannu.1996.08 made 14 posts!

Top 3 Most Liked Posts

This post made by @tseidler received 3 likes!

Milestone 5 - Automating Word

There was a minor inconvenience with using the template word doc: I had Office 365 on auto-save, while in StudioX the word resource was set to not save changes. The Office 365 option takes precendence it seems Other than that it was a fun excercise!

This post made by @LisaBoneta received 2 likes!

Announcing the 2021 UiPath MVPs!

Congrats to all the MVPs! Amazing work

This post made by @Taeko_UiPath received 2 likes!

【UiPathアカデミー】UiPath Orchestrator のコースが新しくなりました！

平素より、UiPathアカデミーをご利用くださいまして誠にありがとうございます この度、下記の3つのコースを、新たにリリースいたしました UiPath Orchestrator 入門コース ⇒ 受講対象者：どなたでも UiPath Orchestrator 基礎コース ⇒ 受講対象者：RPAデベロッパー向け UiPath Orchestrator 管理コース ⇒ 受講対象者：Orchestrator管理者向け Orchestrator バージョンについて Orchestrator モダンフォルダーを前提としたコースにて、 最新の Automation Cloud 2021.4 から、オンプレミスにてご利用の方まで、広く対応しております カリキュラム再構成の背景について 入門コースは、より多くの方に Orchestrator の魅力が伝わる構成となり、 管理コースは、モダンフォルダー内のリソース管理方法に焦点をあて、 各リリースの概念が理解できるように構成しました （旧）UiPath Orchestratorコースをご受講済みの方へ 名称は、「UiPath…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

スプレットシートをクリップボードにコピー

こんにちは @Kah_Liang さんの記述内容とほぼ同じですが Excel application scopeの 出力-ブック または 既存のブックを使用－既存のブック に DataTableの変数をセットしているのではないでしょうか？ もしそうなら、これらを削除してみてください。

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

Switch : object reference not set to an instance of an object

Hi @Mohamad_Izudin_Bin_Abdul Before switch activity, kindly print all the variables used in switch condition and check whether the variables contains value or not. Thanks.

This solution provided by @irahmat received 1 likes!

Studio has Robot Error Status

Hi Alex, I solved the issue by add exception IP address in the proxy [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 | 09 April 2021

Top 3 Topics with Most Views

Fill missing data in excel - Replace "?" made by @Yudhisteer_Chintaram with 28 views.

How to Convert time to text string in excel? made by @Welcoming with 27 views.

Connection with UiPath Excel-Add-In keeps failing made by @anotherulrich with 27 views.

Top 3 Topics with Most Replies

How to split the equation(string type),if A1-A2 then var1=A1, var2=- , var3=A2 made by @eimon with 20 replies.

Question on Number type made by @Prinal_C with 12 replies.

https://forum.uipath.com/t/305355 made by @SIM_JUN_HUI_BERTRAM_CSOD with 12 replies.

Top 3 Users Who Posted The Most

@prasath_S made 37 posts!

@Hiba_B made 24 posts!

@prasath17 made 16 posts!

Top 3 Most Liked Posts

This post made by @Hiba_B received 2 likes!

Data extraction from text to excel

Hi @sayali_rokade ! A way is to use regex, @prasath17 masters it: would you mind helping us ?

This post made by @sangL received 2 likes!

How pass datatable as checkbox or selectboxes in Form.Activities

Hi @lojyehuang - thanks for the inquiry. We will check this internally to see if we can resolve and follow up with you. Thanks.

This post made by @Eric_Wong_Test received 2 likes!

How to split the equation(string type),if A1-A2 then var1=A1, var2=- , var3=A2

You can use this [image]

Top 3 Most Liked Solutions

This solution provided by @wood.raymond79 received 2 likes!

Activities Pane Remains above Main Window

Problem solved. I was able to resize the pane by dragging it out from the side. It popped out of the centre and I was able to move it back to its home.

This solution provided by @prasath_S received 1 likes!

Delete text in SAP

Hi @Markus3003 Use type into activity and set empty field propery ticked, it will clear the text field and type whatever text you given in the input field of the activity. In properties panel of type into activity, [image]

This solution provided by @Eric_Wong_Test received 1 likes!

How to split the equation(string type),if A1-A2 then var1=A1, var2=- , var3=A2

match.xaml (6.0 KB)

---

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

Top 3 Topics with Most Views

Take screenshot and Send mail made by @mtalha.shafiq with 26 views.

Sign-in error in UiPath Studio made by @daniel.popescu1985 with 25 views.

Structure of Loops - 2.0 with Queues made by @Yudhisteer_Chintaram1 with 22 views.

Top 3 Topics with Most Replies

Sign-in error in UiPath Studio made by @daniel.popescu1985 with 9 replies.

Take screenshot and Send mail made by @mtalha.shafiq with 9 replies.

Close specific excel without all excel documents closed made by @ting801215 with 7 replies.

Top 3 Users Who Posted The Most

@afe.araromi made 10 posts!

@prasath17 made 7 posts!

@JayakumarSanthanam made 4 posts!

Top 3 Most Liked Posts

This post made by @phee_beng_ying received 2 likes!

Milestone 1 - Build your first Automation

Sending quarterly reminders to colleagues to update their documents. Attaching the correct documents to the correct group of colleagues for their review and amendment. Sending monthly user verification reports.

This post made by @prasath17 received 1 likes!

How to store particular array elements of an array into another array

@rahulsharma - please take a look here…

This post made by @rahulsharma received 1 likes!

How to store particular array elements of an array into another array

Thanks @prasath17 that was helpful.

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

Top 3 Topics with Most Views

Split Text of character made by @Poorani_Ramachandran with 20 views.

Excel: How do you calculate sum dynamica made by @Prinal_C with 19 views.

Linq Query to Filter Datatable column as same date with 2 hrs time.? Pls made by @Aravinthan with 18 views.

Top 3 Topics with Most Replies

データテーブルの項目キー毎の件数を取得後、希望順に並べ替えたい made by @miwa_yamamoto with 11 replies.

Update Status in Excel made by @Yudhisteer_Chintaram1 with 10 replies.

How to create a .zip file made by @Bobae_Lee with 9 replies.

Top 3 Users Who Posted The Most

@prasath_S made 25 posts!

@Tamilselvan made 16 posts!

@prasath17 made 12 posts!

Top 3 Most Liked Posts

This post made by @daniel.popescu1985 received 3 likes!

Sign-in error in UiPath Studio

I marked that post as the solution, but I don’t find the checkbox for Solved.

This post made by @pranam.gangadhar received 3 likes!

Milestone 4 - Tools for Building Automation

I used Write Text File actions. It directly saves the password from clipboard and saves the .txt file in a prescribed folder with a file name of your choice.

This post made by @StefanSchnell received 1 likes!

Code Generator for the Invoke Code Activity to use SAP RFC Function Modules Easily

After the global event about SAP API Automation with the help of UiPath I had a lot of discussions about the most common API use case in relation with SAP. It seems to be reading data from tables. Therefore I decided to extend the RFM Code Generator to support this possibility in a simple way. The current release of the RFM Code Generator contains the possibility to generate code for the RFM RFC_READ_TABLE. In the tab ReadTable it is possible to select an SAP transparent table or an SAP view to…

Top 3 Most Liked Solutions

This solution provided by @prasath17 received 1 likes!

Regex to fetch specific items from string

Hi @DewanjeeS - Please try like this… [image]

This solution provided by @prasath_S received 1 likes!

Close specific excel without all excel documents closed

I have tested the workflow and and its closing only the workbook we needed to close, [image] [image] [image] It you cant find the input for close workbook activty then you dont have to create a variable and assign it.

This solution provided by @Yoichi received 1 likes!

データテーブルの項目キー毎の件数を取得後、希望順に並べ替えたい

こんにちは 以下トピックが参考になると思います。

---

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

Top 3 Topics with Most Views

Add header in DT made by @Jesmine with 35 views.

Is studio have a robot? made by @halis with 32 views.

How to view specific folders in a directory made by @Serik_Tashenov with 30 views.

Top 3 Topics with Most Replies

How to view specific folders in a directory made by @Serik_Tashenov with 22 replies.

Is there any idea to append column in excel? made by @Ganesh_S1 with 19 replies.

Add header in DT made by @Jesmine with 13 replies.

Top 3 Users Who Posted The Most

@NIVED_NAMBIAR made 26 posts!

@prasath_S made 24 posts!

@Hiba_B made 20 posts!

Top 3 Most Liked Posts

This post made by @andres.perez received 3 likes!

Milestone 1 - Working with Decisions, Iterations and Scenarios

Hey! It seems the link to download the zip which contains the material for this practice is wrong. [image] You can copy them from the solution though! Have a nice week!

This post made by @kumar.varun2 received 2 likes!

Announcing the 2021 UiPath MVPs!

Congratulations to all.

This post made by @Zoul_BZ received 2 likes!

Milestone 1 - Working with Decisions, Iterations and Scenarios

Hi! Echoing andres, the zip file is the same as Week 1 practice.

Top 3 Most Liked Solutions

This solution provided by @anotherulrich received 2 likes!

Connection with UiPath Excel-Add-In keeps failing

I followed this: Excel Plugin Not Getting Installed - #3 by AndrewHall and this solved the issue. Nothing to do with Admin rights… Regards, Ulrich

This solution provided by @NIVED_NAMBIAR received 1 likes!

Remove particular Data columns by using Wildcards

Hi @he.cao u can try this way Read the excel file and store in dt1 now use below assign activity to get only column name starting with Column- data_array = (From dc In dt.Columns.Cast(Of DataColumn) Where dc.ColumnName.StartsWith(“Column-”) Select dc.ColumnName).ToArray() Now use for each loop to loop through each element in data_array [ datatype of data_array is String ] Iniside the loop use Remove Data Column Activity to remove the column from the datacolumn by specifying the name of c…

This solution provided by @Yoichi received 1 likes!

How to read string regardless of Uppercase, Lowercase or mixed using Regex

Hi, Can you try System.Text.RegularExpressions.RegexOptions.IgnoreCase option as the following? System.Text.RegularExpressions.Regex.Match(strVar,"(?<=(Person Address)).*",System.Text.RegularExpressions.RegexOptions.IgnoreCase).Value 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 April 2021

Top 3 Topics with Most Views

How to convert String to Integer made by @Z_Z with 27 views.

REplacing Values in a column of datatable made by @Username95 with 25 views.

How to add or concatenate double quotes with String Variables? made by @wdescalsota with 25 views.

Top 3 Topics with Most Replies

How to add or concatenate double quotes with String Variables? made by @wdescalsota with 26 replies.

EXCEL Write Cell / Auto Fill made by @CoolRobot with 14 replies.

Error: Input Dialog: TypeConverter cannot convert from System.String made by @Yu_Winni with 10 replies.

Top 3 Users Who Posted The Most

@prasath_S made 39 posts!

@Pravin_Patil1 made 35 posts!

@prasath17 made 17 posts!

Top 3 Most Liked Posts

This post made by @Alison_Evans received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi all, I am an entrepreneurial accountant in New Zealand, working alongside a large number of business managers to improve business and accounting systems. I believe that RPA is the next tool for me to learn, and I am very much at the beginning, but have a background in database management which helps a lot. I want to first understand it for my own business, but then be able to offer it as a setup service to clients. I love learning it, and wish I had more time to devote to it, but ultimately …

This post made by @SushilSharma received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hi, my name is Sushil. I am based in Noida, India. I manage IT-Infra team for Cyient Noida (India) location. I am here to see the capability of StudioX and learn to utilize it to increase my and my team’s productivity in day to day routine tasks.

This post made by @veaceslav_costetchi received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hello to everyone! I’m new to UiPath, looking to learn new skills here.

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 2 likes!

Another reason why Filter datatable activity in my logic always return zero

Hi @eimon I think it should be a number type in excel please use convert.toint32(variable1.tostring.trim) in filter datatable Or cint(variable1.tostring.trim) Or give variable1 datatype as integer in UiPath and just past the value in the filter datatable

This solution provided by @Hiba_B received 1 likes!

TYPE="DATE" problem!

Ok indeed I just tried it with the activity that you have (from the modern experience bucket), it does not work. I don’t know why and how you could use this activity to make it work, but I suggest you to do the following: go to activities, then filter, then check the Show Classic tool [image] Once you’ve done it, you can drag and drop the type into version that I have: [image] That way you have the following sequence at the end: [image]

This solution provided by @HANACCHI received 1 likes!

データテーブルをマージできない

データテーブルのマージは、ソースに指定したDataTableを、保存先に指定したDataTableにマージします。 例えば、DataTableとして指定した変数が実は引数にも指定されていたとか、EXCELで読み取ったDataTableが実は空であったとか。。。

---

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

Top 3 Topics with Most Views

Unzip File from Download Folder made by @Elena_Scha with 109 views.

I need to extract the data from the image made by @copy_writes with 81 views.

データテーブルから条件指定の値を取得したい made by @miwa_yamamoto with 67 views.

Top 3 Topics with Most Replies

In ServiceNow, i need to proceed based on short description made by @Swetha_V with 21 replies.

Split one excel into 2 with a condition and write cell after cell made by @Dragonici_Victor with 20 replies.

データテーブルから条件指定の値を取得したい made by @miwa_yamamoto with 19 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 38 posts!

@Srini84 made 32 posts!

@prasath_S made 26 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

Last 5 days of current month

it looks like you are interested in a series/Collection of the last 5 days fro current month (so e.g. in Feb: 24,25,26,27,28) Variables: [grafik] Assign: [grafik] Enumerable.Range(-4,5).Select(Function (x) LastMonthDate.AddDays(x)).toList Result: [grafik]

This post made by @CosminV received 2 likes!

UiPathOrchestrator_Log File (.ldf) is getting larger

Maintaining the transaction log file is usually the job of a DBA, so make sure you get the help of one if it’s a production system. If it’s not, here’s an article with what you can do to reduce its size: SQL Server Transaction Log Backup, Truncate and Shrink Operations

This post made by @VB_Tech_pro received 2 likes!

How to give a excel cell value as input range to split pdf as range

Hi @prasath17 Now Iam able split pages adding some sequence of balareva.pdfspliter to FindPDFPageNo.zip . I will provide the size comparison screenshoots

Top 3 Most Liked Solutions

This solution provided by @ppr received 3 likes!

Last 5 days of current month

it looks like you are interested in a series/Collection of the last 5 days fro current month (so e.g. in Feb: 24,25,26,27,28) Variables: [grafik] Assign: [grafik] Enumerable.Range(-4,5).Select(Function (x) LastMonthDate.AddDays(x)).toList Result: [grafik]

This solution provided by @Camille361 received 1 likes!

Improve a process' speed

@ppr @Hiba_B Thank you very much for your help ! I actually found something else to make my process faster. In fact my process was just a sequence of clicks et types on a website so it already was not that long but I wanted to make it even more faster ! And this morning I found an option “SimulateClick” and “SimulateType” that makes it much more faster. Thank you once again ! @Hiba_B Ravie de rejoindre la communauté ! A bientôt peut être pour mes futures questions ! …

This solution provided by @Pravin_Patil1 received 1 likes!

I get error in regex in pattern panel (Error ERROR Validation Error Compiler error(s) encountered processing expression ""(?<=ocr_text":")(\d+\.\d+).*(?="}])"". End of expression expected. Image Extraction.xaml)

@copy_writes Try like below "(?<=ocr_text"+"""+:+"""+")\d+.\d+"

---

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

Top 3 Topics with Most Views

How extract only last index data from the excel made by @copy_writes with 30 views.

整数または自然数の取得について made by @pthfs1 with 29 views.

Unknown space in text made by @Username95 with 28 views.

Top 3 Topics with Most Replies

Time out reached for unattended bot made by @Naveed_Hakim1 with 21 replies.

Invoke code returns error made by @ranjani with 13 replies.

Unusal double quote made by @Radap with 12 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 30 posts!

@Srini84 made 21 posts!

@postwick made 20 posts!

Top 3 Most Liked Posts

This post made by @teresa received 2 likes!

Take the survey: The State of the RPA Developer 2021

Sorry! We had so many questions for you guys!

This post made by @seanrockvz13 received 2 likes!

Studio Type Bot triggered from orchestrator?

Hi @loginerror, looping you in.

This post made by @prasath_S received 2 likes!

How to create new excel file every day uniquely

Hi @chaithanya_kumar_M Use write range activity and in file path give as “Yourpath\Filename_Prefix” + now.tostring(“ddMMyyyy hhmm”) + “.xlsx” it will craete a new file with creent datetime.

Top 3 Most Liked Solutions

This solution provided by @prasath_S received 2 likes!

How to create new excel file every day uniquely

Hi @chaithanya_kumar_M Use write range activity and in file path give as “Yourpath\Filename_Prefix” + now.tostring(“ddMMyyyy hhmm”) + “.xlsx” it will craete a new file with creent datetime.

This solution provided by @Dragos_Bobolea received 1 likes!

Question about Computer Vision

Hi, yes, that’s one of the biggest advantages of CV over find image. As long as the anchor-target pairs don’t change relative positions, it will work just fine

This solution provided by @prasath17 received 1 likes!

A value between

@Gabriel_Wisniewski - As an Alternate… [image] (?<=ICMS\s+\S+\s+)[\d.,]+ Note: I have also included . in my pattern and this can grab any values…you can test 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 | 16 April 2021

Top 3 Topics with Most Views

📢 HyperHack - Automation for Good challenge! made by @Vibhor.Shrivastava with 104 views.

Our new look for Orchestrator is here! made by @Alexandra_Gurita with 41 views.

Schedule is not working from Orchestrator made by @Ziarul_Haque with 35 views.

Top 3 Topics with Most Replies

How to add Saved Value to file name made by @jessica.matthess with 17 replies.

Scheduled Jobs not running on time - delayed for about 45 mins made by @rpa_automation with 11 replies.

File: Conversion from string to double made by @AhmedKutraphali with 10 replies.

Top 3 Users Who Posted The Most

@Pravin_Patil1 made 16 posts!

@prasath17 made 12 posts!

@AhmedKutraphali made 12 posts!

Top 3 Most Liked Posts

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

HyperHack - Automation for Good challenge!

[LinkedIn_Twitter_hyperhack21_1200x627_1] Join the #AutomationForGood challenge! Every year we turn our attention, our skills, and resources to the world around us, we listen, and we relentlessly try to explore the societal impact of automation. This year, we invite you, the global UiPath community, to join forces with us for the #automationforgood Hackathon. It’s time for all of us to connect to the world outside our daily tasks. It’s time to dive into our local communities, find and solve t…

This post made by @Alexandra_Gurita received 13 likes!

Our new look for Orchestrator is here!

Introducing Apollo design system Over the past couple of years, we’ve seen the number of products from UiPath grow from 3 to over 20! With this rapid growth, we realized that our customers would benefit from a design system to keep our experiences simple to use and easier to develop. The Apollo design system is a collection of objects (controls in many cases) that allow us to provide UiPath customers with the best possible experience across all of our products. Guided by clear standards, we as…

This post made by @Hiba_B received 3 likes!

HyperHack - Automation for Good challenge!

That’s greaaaaaat !! Are some french people interested ? Don’t mind to do it alone, but the more merrier

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 3 likes!

Click activity - How to read asterisk *?

Hi, Can you try regex selector as the following? <webctrl aaname='Consumer Max-500-2\.5-2\.5\*' matching:aaname='regex' /> Regards,

This solution provided by @Yoichi received 2 likes!

Regex not accepted by UiPath

Hi, Can you try the following pattern? [\d*.\d*,\d*]+(?=\r?\n\r?\nVALOR LIQUIDO DA NOTA) Regards,

This solution provided by @Tamilselvan received 2 likes!

How to Pass a Variable in the Label of UiPath Forms?

@Haroon_Patel Form Dynamic Labels for Textfield.zip (43.1 KB) Please find the sample workflow for dynamic labels in textfield. Regarding your above query, you dont necessarily add “redrawOn” at line #7. you can add it at the end of the json. in your example, you can add it after line #10. Please try the attached workflow and let us know. Thanks

---

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

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

[system]

Daily Forum Report | 17 April 2021

Top 3 Topics with Most Views

PDF Data extraction for clientid made by @sayali_rokade with 26 views.

How to Split the string after '-' made by @Rahul_Jawahirani with 25 views.

How can I fill these PDF made by @oscar.cuevas.jimenez with 24 views.

Top 3 Topics with Most Replies

User License Management and Unattended robots in 21.4 made by @JithinKP with 7 replies.

How to create mulitipication on 2*1=2 while using do while in UiPath made by @Ashrof_ali with 7 replies.

How to Split the string after '-' made by @Rahul_Jawahirani with 5 replies.

Top 3 Users Who Posted The Most

@airwaveexporter made 8 posts!

@AKM_Robinuzzaman made 8 posts!

@vignesh.ks made 7 posts!

Top 3 Most Liked Posts

This post made by @prasath_S received 3 likes!

Click Input returns multiple results

Hi @mpathan If the output of get text is strText Use if activity and in condition give strText.tostring.trim.toupper = “NO RECORDS FOUND” In else do your logic

This post made by @NIVED_NAMBIAR received 3 likes!

Click Input returns multiple results

In addition to what @prasath_S has said, you can try with element exists to check whether the element No records Found is there or not. based on boolean value you can extend your logic on it. Regards, Nived N Happy Automation

This post made by @jenyshirly received 2 likes!

Welcome to our Forum! Please introduce yourself to our Community

Hai… hello all…Myself Jeny…I am working with RPA automation for the past two years…I am really interested on how this automation works and makes things around us…

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 1 likes!

Tesseract OCR 日本語対応できない問題

こんにちは CE最新版ではどうやら以下にtessdataフォルダを作成しなければならないような感じです。 一度お試しください。 C:\Users\[ユーザー名]\AppData\Local\UiPath\app-xx.xx.xx\net461

This solution provided by @Zing received 1 likes!

Draft email does not show up in Outlook's Outbox

Hello @ovidiuponoran, thanks for following up! I have uninstalled and re-installed the outlook desktop application, and re-installed the chrome and excel add-ins for uipath, and it is working as intended. Not sure what was wrong before, but so happy that its working!

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

Copie, paste data Excel

Hi @E.E You can use “Remove DataRow” activity before “append range” activity. In “Remove DataRow” activity properties provide the DataTable variable and RowIndex as ‘0’. So it will remove the header and append the rest of the data’s. Note: Uncheck ‘Add Headers’ in read range(DataTable which you need to append) activity properties. Thanks.

---

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

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

[system]

Daily Forum Report | 18 April 2021

Top 3 Topics with Most Views

UIPath Enterprise Studio with Cloud Community issue made by @Mohammed_Shehata with 30 views.

Find row value with specific made by @Prinal_C with 26 views.

Preprocess Excel Column made by @Yudhisteer_Chintaram1 with 22 views.

Top 3 Topics with Most Replies

UIPath Enterprise Studio with Cloud Community issue made by @Mohammed_Shehata with 9 replies.

Filter remove lenght made by @sedayngl_sedayngl33 with 8 replies.

Find row value with specific made by @Prinal_C with 6 replies.

Top 3 Users Who Posted The Most

@prasath_S made 9 posts!

@Mohammed_Shehata made 7 posts!

@AhmedKutraphali made 6 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Repeating the same character multiple times in a string

Hi, Another solution: new String("-"C,225) Regards,

This post made by @ppr received 2 likes!

Merging 3 excel files with non continuous records into 1 excel with continuous records

Looks Like an issue with the datatypes. Can you Check if the typeargument for the for each Activity ist Set to datatable

This post made by @cornelius.nowald received 1 likes!

Get Modern Folder FullyQualifiedName as Index in Log Target

Hi @rdgagp , I tried few more things to fetch the folder name (not just folder-ID) and directly apply to the index name, but I think without UiPath including the FQN as event property this will not work. I also created a very cumbersome workaround, but in comparison to this I think managing access to indices by mapping folder-IDs to users is going to be easier. I manually created a sperate target for each folder (paying attention to the ES index-naming-convention) [image] and a separate lo…

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 | 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.