loginerror
(Maciej Kuźmicz)
February 25, 2021, 1:44pm
1
Daily Forum Reports
This is a topic driven by a friendly automation that gives a shout-out to different Forum activities from the last 24 hours.
Although the topic is closed for replies to keep it tidy, please share your ideas in the dedicated feedback topic . We will be add more things to the report based on your ideas.
7 Likes
system
(system)
February 25, 2021, 3:32pm
3
Daily Forum Report | 24 February 2021
Top 3 Topics with Most Views
Document Understanding : How to Extract Invoice Fields not Supported by Builtin ML Model made by @Tooba_Faroki with 57 views.
AIFabric_Demo made by @Varun_Dharni with 34 views.
Copy sheet error UIPath made by @AhmedKutraphali with 32 views.
Top 3 Topics with Most Replies
AIFabric_Demo made by @Varun_Dharni with 26 replies.
Unable to get credentials from orchestrator made by @Reuben_Kekana with 19 replies.
Resetting Excel Sheet to blank page at the end of each for loop made by @seongchan_cho with 18 replies.
Top 3 Users Who Posted The Most
@Srini84 made 25 posts!
@Varun_Dharni made 24 posts!
@Cristian_Negulescu made 19 posts!
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 .
1 Like
system
(system)
February 26, 2021, 9:01am
5
Daily Forum Report | 25 February 2021
Top 3 Topics with Most Views
How to filter excel? made by @fairymemay with 30 views.
English text classification dataset made by @Varun_Dharni with 29 views.
プロセスを強制終了でPDFファイルを閉じたい made by @Tatsu.H with 28 views.
Top 3 Topics with Most Replies
My Robot appears as "Disconnected" made by @APEXRPAROBOT with 23 replies.
랜덤으로 발생하는 레이어 팝업을 닫고 싶습니다 made by @Moolog with 22 replies.
English text classification dataset made by @Varun_Dharni with 21 replies.
Top 3 Users Who Posted The Most
@prasath17 made 20 posts!
@Varun_Dharni made 20 posts!
@NIVED_NAMBIAR made 17 posts!
Top 3 Most Liked Posts
This post made by @enriquediaz received 4 likes!
Let me announce you the release in the WPFInteractive of a new feature called Light Browser. It’s an embedded IE that supports all Internet Explorer versions from 7 to 11, you can choose which one to use.
[image]
This Light Browser adds the feature of a real hidden and non-intefering browser window navigation if all your navigation can be made via Simulate or Send Windows Messages.
We have seen in some of our customers that the normal IE with the property Hidden set to true can be interfered …
This post made by @Yoichi received 3 likes!
This post made by @ptrobot received 3 likes!
If your target control works with Type Into, you can also use Enumerable.Repeat().
String.Join("", Enumerable.Repeat("[k(down)]", 160))
[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 .
1 Like
system
(system)
February 27, 2021, 9:00am
6
Daily Forum Report | 26 February 2021
Top 3 Topics with Most Views
If activity and check box made by @Tanu.Sharma with 35 views.
ERROR: Training Job failed, error: Expecting value: line 1 column 1 (char 0) made by @Maciej_Adamczyk with 33 views.
How to copy 10 rows from one column? made by @rsr.chandu with 27 views.
Top 3 Topics with Most Replies
If activity and check box made by @Tanu.Sharma with 27 replies.
How to copy 10 rows from one column? made by @rsr.chandu with 8 replies.
How to send hotkey to an excel file for decreasing decimal button for specific columns made by @Alperen_Tac with 7 replies.
Top 3 Users Who Posted The Most
@Hwang made 12 posts!
@Tanu.Sharma made 12 posts!
@NIVED_NAMBIAR made 11 posts!
Top 3 Most Liked Posts
This post made by @StefanSchnell received 3 likes!
This post made by @Yoichi received 3 likes!
Hi,
Can you try the following expression?
listA.Skip(listA.Count-3).ToList
Regards,
This post made by @gheorghestan received 2 likes!
Hi @StefanSchnell .
The documentation writing is in progress, planned to be released with 21.4 FTS, thus we don’t have anything formal as of now.
However, I can provide some more information on these two new features:
Shadow DOM is a virtual DOM created under the regular html page’s DOM, technique used by some of the newest web technologies like Angular or React, to apply their own styles, completely isolated from the original DOM.
Example: [image]
The UIAutomation driver is able now, to …
Top 3 Most Liked Solutions
This solution provided by @kwoxer received 2 likes!
Interesting but absolutely confusing. So maybe give the possibility to change those settings on the OR object would solve any issue and everyone is happy.
WDYT?
This solution provided by @Manish540 received 2 likes!
Check this below code, @7387023380
TotalDays = 1 + ((Cdate(“02/14/2021”) - Cdate(“02/01/2021”)).TotalDays * 5 - (CDate(“02/01/2021”).DayOfWeek - Cdate(“02/14/2021”).DayOfWeek) * 2) / 7.
And code is in the form of,
TotalDays = 1 + (EndDate - StartDate).TotalDays * 5 - (StartDate.DayOfWeek - EndDate .DayOfWeek) * 2) / 7.
EndDate and StartDate should be in - “MM/dd/yyyy” format
This will give you the total days excluding the Saturday and Sunday.
Hope this may help you
This solution provided by @jeevith received 1 likes!
@Cormac ,
Could you share / paste the contents of the json file? It makes it easier to debug
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 .
1 Like
system
(system)
February 28, 2021, 9:00am
7
Daily Forum Report | 27 February 2021
Top 3 Topics with Most Views
Academy Videos 504 Gateway Time-out made by @eboolean with 43 views.
Use Regex to remove items made by @Sana_Afreen with 28 views.
Updating a Data Table - output from an Excel file made by @Rachita_Chauhan with 28 views.
Top 3 Topics with Most Replies
Academy Videos 504 Gateway Time-out made by @eboolean with 14 replies.
REFramework without Queue or without data table made by @AhmedKutraphali with 10 replies.
Invoke GetAppcredentials workflow: Object reference not set to an instance of an object made by @Dinesh_Babu_S with 9 replies.
Top 3 Users Who Posted The Most
@NIVED_NAMBIAR made 10 posts!
@jeevith made 6 posts!
@Dinesh_Babu_S made 5 posts!
Top 3 Most Liked Posts
This post made by @StefanSchnell received 4 likes!
In many discussions and posts it is very often assumed that PDF files, exported from Excel, store the table data they contain as structured data. Just as often, posts describes solutions for turning tables, stored in PDF, back into structured data. You can find excellent examples here
Regex to extract data from @prasath17
How to Extract Table from PDF from @Cristian_Negulescu
In all these cases the text of the PDF is restructured into a table.
This shows us a key insight: PDF files sto…
This post made by @rtimani received 1 likes!
The same thing with me 504 Gateway Time-out
This post made by @rkelchuri received 1 likes!
Team,
Please find this post on solving ReCaptcha.
[image]
Top 3 Most Liked Solutions
This solution provided by @rkelchuri received 1 likes!
@Anjali_Rani ,
Solving Captcha is a possible with API key. But it is a paid third party service.
If you are just trying to experiment then try with Free Captcha Solving APIs from google search.
If you are working for an application of a client then you need to buy license AntiCaptcha and include AntiCaptcha API code in your Robot Workflow.
Please watch this video from LinkedIn.
Please find AntiCaptcha site as follows:
https://anti-captcha.com/mainpage
Hope my inputs are useful.
This solution provided by @jeevith received 1 likes!
Hi @Dinesh_Babu_S
The reason can be
Your arguments value sent to GetAppCredemtials.xaml file in invoke workflow activity is empty
The orchestrator, I am assuming your cloud orchestrator has a different name for the credentials asset you are trying to poll.
You have spaces in your arguments string
Your orchestrator asset is empty or asset is in a different Tennant
Try and check these possible reasons.
The error essentially occurs in many uipath activities when a required input to…
This solution provided by @jeevith received 1 likes!
Hi @Dinesh_Babu_S ,
I tested the get credentials workflow and the place where you invoke it (Initialization) where the asset name is polled from in_Config(“credentials”).ToString
In both cases, I do get the Credentials from my cloud Orchestrator as below:
[image]
[image]
Your config.xlsx file has the correct value (“ACMELogin”) for the “credentials” key without extra spaces. So in_Config("credentials").ToString is going to work fine. But in the future you can also use in_Config("credential…
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
(system)
March 1, 2021, 9:01am
8
Daily Forum Report | 28 February 2021
Top 3 Topics with Most Views
Uipath Academy videos are not playing made by @melvincjoy1 with 29 views.
MessageBox value will store on Excel sheet made by @Anjali_Rani with 28 views.
Sort column within an open application in chrome made by @joshua.reynolds with 23 views.
Top 3 Topics with Most Replies
Unable to Read PDf Files due o pdf viewer made by @Karan28 with 11 replies.
Filter Datatable by current date made by @Muthulakshmi_Thangamuthu with 8 replies.
MessageBox value will store on Excel sheet made by @Anjali_Rani with 8 replies.
Top 3 Users Who Posted The Most
@Cristian_Negulescu made 24 posts!
@NIVED_NAMBIAR made 18 posts!
@Anjali_Rani made 6 posts!
Top 3 Most Liked Posts
This post made by @cosminSimion received 5 likes!
Hey everyone,
The problem has been flagged.
Our video streaming services is down.
We should get this back ASAP.
More details to follow.
Thanks
This post made by @ayesha.siddiqa received 3 likes!
Now available! Thanks Team!!
This post made by @ugki received 2 likes!
still error 504. Damn it’s now week-end the only moment I have to study. Please fix it asap thanks!
Top 3 Most Liked Solutions
This solution provided by @NIVED_NAMBIAR received 2 likes!
Hi @Muthulakshmi_Thangamuthu
U can filter the excel by date as follows
dt1 = dt1.AsEnumerable().Where(Function(row) row(“Initiared On”).ToString.Contains(Now.ToString(“yyyy-MMM-dd”)).CopyToDataTable
where the dt1 is the datatable obtained by read range
Or u can use filter datatable activity to filter the column
“Initiared On” Contains CDate(Now.ToString(“yyyy-MMM-dd”))
(while read range (Check the preserve format option))
Regards
Nived N
Happy Automation
This solution provided by @NIVED_NAMBIAR received 1 likes!
오케 스트레이터의 일정 옵션을 사용하여 특정 날짜 범위까지 프로세스를 예약 할 수 있습니다.
@jhwoo
This solution provided by @ppr received 1 likes!
use the other field:
[grafik]
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 .
1 Like
system
(system)
March 2, 2021, 9:01am
9
Daily Forum Report | 01 March 2021
Top 3 Topics with Most Views
A new way of governing: UiPath Automation Ops is now available in Public Preview! made by @Paul_Boulescu with 81 views.
MailList内の受信日時をを古い順から取得し、書き出したい made by @11159 with 29 views.
How to generate invoice number made by @copy_writes with 28 views.
Top 3 Topics with Most Replies
How to perform Sort (not using Asc or Desc) made by @caduque with 24 replies.
How to compare and find not matching item in two data tables? made by @AnnaDewitt with 14 replies.
Outlook - Filter emails based on subject date made by @Dinesh_Babu_S with 12 replies.
Top 3 Users Who Posted The Most
@ppr made 25 posts!
@Cristian_Negulescu made 17 posts!
@Yoichi made 14 posts!
Top 3 Most Liked Posts
This post made by @Paul_Boulescu received 8 likes!
UiPath Automation Ops is now available in Public Preview!
As automations became more engrained in a company’s day to day operations, we received more and more signs from our customers about the need to properly govern and manage their flows, to set up rules and frameworks in which all the people contributing to the automation process can safely develop and publish their work.
Where 3 years ago we had 2-3 people in one department developing in Studio, we now have hundreds of RPA developers and…
This post made by @Yoichi received 3 likes!
Hi,
MailMessage.CC property returns MailAddressCollection class.
So we need to handle it as the following.
[img20210301-1]
Note: item is MailMessage type and cc is MailAdress type.
Regards,
This post made by @Yoichi received 2 likes!
Hi,
How about the following?
yourString.Replace("Select one:,","")
or
System.Text.RegularExpressions.Regex.Replace(yourString,"^[^,]*,","")
Regards,
Top 3 Most Liked Solutions
This solution provided by @Yoichi received 3 likes!
Hi,
MailMessage.CC property returns MailAddressCollection class.
So we need to handle it as the following.
[img20210301-1]
Note: item is MailMessage type and cc is MailAdress type.
Regards,
This solution provided by @Yoichi received 2 likes!
Hi,
How about the following?
yourString.Replace("Select one:,","")
or
System.Text.RegularExpressions.Regex.Replace(yourString,"^[^,]*,","")
Regards,
This solution provided by @Manish540 received 2 likes!
Check this below code, @Tharusha_Fernando
String.Join(“;”, EmailListVariable) - Pass this to the “To” part of the Send Outlook Mail activity.
Hope this may help you
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
(system)
March 3, 2021, 9:01am
10
Daily Forum Report | 02 March 2021
Top 3 Topics with Most Views
実行環境からOrchestratorにパブリッシュする方法 made by @1117 with 32 views.
セレクタの属性によって安定感が異なる? made by @196006 with 26 views.
Studio doesn't work properly since a few days made by @FautVoir with 25 views.
Top 3 Topics with Most Replies
For each loop, run item & path at the same time in For each loop made by @Nightowl_music with 9 replies.
セレクタの属性によって安定感が異なる? made by @196006 with 9 replies.
Expression Doesn't Produce a Value made by @Shaik.Yezdani with 9 replies.
Top 3 Users Who Posted The Most
@NIVED_NAMBIAR made 23 posts!
@Yoichi made 20 posts!
@ppr made 16 posts!
Top 3 Most Liked Posts
This post made by @alexandru received 4 likes!
@StefanSchnell even if Studio is 64-bit the runtime is flexible:
Runtime 32-bit: Studio supports x86 runtime for .NET Framework based activities and workflows.
Runtime 64-bit: Studio will support x64 runtime for .NET Core based activities and workflows in a future version.
Please let me know if this answers your concers.
This post made by @gjs received 3 likes!
Hello,
I am a researcher in digital innovation at Stockholm University Sweden. Trying to learn more about RPA in general and hyperautomation more specifically.
Gustaf
This post made by @Pooja_Jain received 2 likes!
Hi,
Thank you for informative training. I just started from yesterday and joined rpa developer role. i started with basic introduction. as i see video quality cannot be changed when i was viewing video on phone urls and other stuff is clearly visible but information is enough to understand concepts.
other than that very thankful
Top 3 Most Liked Solutions
This solution provided by @Sachin_Jadhav received 1 likes!
Thank you solution worked.
This solution provided by @tkiran received 1 likes!
File extract.xaml (18.7 KB)
Can you pls correct in this if possible or send me your above code in uipath screenshot.
This solution provided by @tkiran received 1 likes!
WOW… Superb… thank you so much it works perfectly…
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
(system)
March 4, 2021, 9:01am
11
Daily Forum Report | 03 March 2021
Top 3 Topics with Most Views
Oulook made by @Swetha_V with 36 views.
Calculate the average price using Original Price in the excel file made by @Anggara_Rahmadhani with 30 views.
[UiPath Live] Learn how AI and RPA can unlock unlimited potential for your work 🚀 made by @judylee with 27 views.
Top 3 Topics with Most Replies
Oulook made by @Swetha_V with 21 replies.
How to add row value in the specific column made by @Vrushali_Gave with 13 replies.
Copying files from one folder and moving to another folder made by @shekhawat.arjun1307 with 11 replies.
Top 3 Users Who Posted The Most
@prasath17 made 26 posts!
@NIVED_NAMBIAR made 19 posts!
@Liji made 18 posts!
Top 3 Most Liked Posts
This post made by @judylee received 3 likes!
Hello UiPath Community
Imagine a world in which all your back-office tasks are invisible.
Imagine a world where work is more fulfilling, valuable, and strategic.
It is possible.
Join us on March 24th for the first UiPath Live of 2021!
Sign up now and we’ll show you how UiPath can bring AI into every facet of your work and unlock human creativity and ingenuity. Learn from and interact with industry experts, and get educated on the four key pillars that define the fully…
This post made by @ppr received 3 likes!
@Nani_Kumar
as you requested a case insensitive matching go for following (RegEx)
[grafik]
System.Text.RegularExpressions.Regex.Replace(YourStringVar,“ABC”,“BCD”,RegexOptions.IgnoreCase)
Help for Regex have a look here:
This post made by @NIVED_NAMBIAR received 2 likes!
Hi @Nani_Kumar try this code using assign activitiy
Assuming u had stored ur string in input varaible
Then use the below code
input = System.Text.RegularExpressions.Regex.Replace(input,“ABC”,“BCD”)
Regards
Nived N
Happy Automation
Top 3 Most Liked Solutions
This solution provided by @aalaghbari received 1 likes!
Hi @Nithinkrishna
I found the solution var = var.TrimStart({","c})
Thanks a lot.
This solution provided by @poke received 1 likes!
こんにちは。
Wordのテキストを読み込み
replaceでvbtabをカンマに変換
データテーブルを生成
Excelに書き込みしました。
データテーブルを生成ってこういう時に使うんですね。勉強になりました。
This solution provided by @LevKushnir 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 .
1 Like
system
(system)
March 5, 2021, 9:08am
12
Daily Forum Report | 04 March 2021
Top 3 Topics with Most Views
Announcing the 2021 UiPath MVPs! made by @Luiza with 1440 views.
Element Exists Else Skip made by @Andrew_Callaghan with 62 views.
Uipath send hotkey based on number made by @AhmedKutraphali with 48 views.
Top 3 Topics with Most Replies
Announcing the 2021 UiPath MVPs! made by @Luiza with 50 replies.
Element Exists Else Skip made by @Andrew_Callaghan with 19 replies.
RE frame work made by @prashanth_reddy with 17 replies.
Top 3 Users Who Posted The Most
@NIVED_NAMBIAR made 17 posts!
@prasath17 made 15 posts!
@supermanPunch made 15 posts!
Top 3 Most Liked Posts
This post made by @Luiza received 61 likes!
UiPath Community, please welcome the UiPath 2021 Most Valuable Professionals!
We are beyond excited to announce our 62 top automation professionals who have been continuously making outstanding contributions to the UiPath Community with relentless passion, creativity, and drive!
Throughout 2020 they have demonstrated:
Strong Product expertise
track record of engagement with the community
innovation, leadership and RPA knowledge sh…
This post made by @NIVED_NAMBIAR received 10 likes!
This post made by @FrankSchikora received 10 likes!
Congratulations to the new and returning MVP’s! Amazing to see all the new faces!
Top 3 Most Liked Solutions
This solution provided by @prasath17 received 2 likes!
Hi @AhmedKutraphali - I have used the keyword “Yes” from your text…
[image]
If Yes will not present always please let me know, I will change the pattern
This solution provided by @prasath17 received 1 likes!
@Macklin_J - Please check this post…(if you feel preserve format will slow down your process)
This solution provided by @ppr received 1 likes!
As mentioned by @supermanPunch
a datacolumn from one datatable cannot be used for an direct addition to another datatable.
And this is the reason why the error is shown.
As an alternate you can do (Create Datacol, and transfer settings from other datacolumn)
Variables
[grafik]
Flow:
[grafik]
[grafik]
it also depends on your scenario details. We get also compact flows we clone datatable and a further datacolumn structre modification
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 .
2 Likes
system
(system)
March 6, 2021, 9:01am
13
Daily Forum Report | 05 March 2021
Top 3 Topics with Most Views
UiPathが頻繁に立ち上がらなくなる made by @nagumo with 31 views.
Excel fetch values made by @sruthesanju with 30 views.
Strin型の変数をdatetime型に変換できない made by @rkym123456 with 29 views.
Top 3 Topics with Most Replies
UiPathが頻繁に立ち上がらなくなる made by @nagumo with 9 replies.
Can't add an unattended robot made by @PeruT with 9 replies.
Regex to extract amount after a code pattern made by @AhmedKutraphali with 8 replies.
Top 3 Users Who Posted The Most
@Srini84 made 17 posts!
@PeruT made 9 posts!
@prasath17 made 9 posts!
Top 3 Most Liked Posts
This post made by @octechnologist received 3 likes!
So happy to be included again this year! Hoping to help many people discover and maximize the power of UiPath.
This post made by @Lahiru.Fernando received 3 likes!
Congratulations to all the amazing minds!!! Looking forward to connecting with all of you soon!!
This post made by @jack.chan received 3 likes!
Updated to version 1.1, see latest post below
=========
Hi everyone, i’d like to share my new workflow template. Feel free to use it and ask any questions. This is a generic template that can be used with any process and you can build it on top of your own frameworks. This is just a basic template and you can add your own steps if your own process requires it, but i want to share this because adding another framework on top of my REFramework has really saved me a lot of time when developing mu…
Top 3 Most Liked Solutions
This solution provided by @supermanPunch received 1 likes!
@Prinal_C Does this newDT supposed to have the same columns as that of the MyDT ?
If so, instead of initialising the newDT, you can clone the MyDT and assign it to the newDT in the below way :
newDT = MyDT.Clone
I believe then the problem should be solved, If not please explain what errors do you get and what changes have you done.
This solution provided by @prasath17 received 1 likes!
@arunasan - Filter should be in Regex format…Since your attachment does not have Approval nothing fetched.
[image]
So, if you are looking for the word Approval or approval. please try like “(Approval|approval)” it should work. I just tested it. please see below…
Before Filter
[image]
After Filter
[image]
[image]
This solution provided by @prasath17 received 1 likes!
@AhmedKutraphali - Please wait, when i tested the above pattern, it is not giving the proper results…
Update: Please check this…
YourRegexVariaoble(0).Groups(1).tostring
That’s it for now, see you tomorrow for a new report!
Don’t forget to share ideas for other fun stuff we should add to the reports here .
1 Like
system
(system)
March 8, 2021, 9:04am
14
Daily Forum Report | 06 March 2021
Top 3 Topics with Most Views
How to add values to an already existing key in dictionary made by @franrua02 with 30 views.
For each row loop return row number made by @hughabbott with 25 views.
Table Extraction, half records Image URL, and half is not! made by @AmarBouz with 24 views.
Top 3 Topics with Most Replies
For each row loop return row number made by @hughabbott with 14 replies.
Help required to change date format made by @Anwar_Mirza with 11 replies.
マクロの呼び出しでセルがdd/mm/yyyyになる made by @katsuta with 10 replies.
Top 3 Users Who Posted The Most
@NIVED_NAMBIAR made 9 posts!
@Srini84 made 9 posts!
@hughabbott made 7 posts!
Top 3 Most Liked Posts
This post made by @msanthakumara received 3 likes!
Congratulations to all the MVP
This post made by @Sahil_Garg1 received 3 likes!
Congratulations to all MVP’s , great work guys.
This post made by @AMRITANShlal received 2 likes!
Hey @Akaza
You can do it conventional way.
Assign a variable of type Array of string i.e., (String) and lets name it listFile. Then use following expression System.IO.Directory.getFiles(“Your Path”,“test”)
It’ll pick only those item which contain ‘test’
Inside ForEach use ‘Move File’ activity and pass target path and path that you’ll get from above expression.
I believe that’ll work.
Top 3 Most Liked Solutions
This solution provided by @prasath17 received 2 likes!
@Muthulakshmi_Thangamuthu -
Read Range - call the datable as Dt Say.
Assign IntRowcount = Dt.rows.count.tostring. This will give 3…
So inorder to write in the first empty row…you have to “A” + (Introwcount+2).tostring or “B” + (Introwcount+2).tostring
This solution provided by @ChrisPals received 1 likes!
Thank You for the responses
I changed my encoding to utf-8 which resolved the issue.
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
(system)
March 8, 2021, 9:25am
15
Daily Forum Report | 07 March 2021
Top 3 Topics with Most Views
I can't find the robot icon at UIpath orchestrator at the classic folder made by @Jarrod_Stewart with 23 views.
Https://docs.uipath.com/developer/docs/robot-api made by @notLuyanda with 21 views.
My First Custom Activities Package made by @Ahmed_ELShubaky with 21 views.
Top 3 Topics with Most Replies
I can't find the robot icon at UIpath orchestrator at the classic folder made by @Jarrod_Stewart with 8 replies.
Scraping website made by @ngateno_eno with 8 replies.
Get Outlook mail message filtering issue with received time made by @Ewout with 8 replies.
Top 3 Users Who Posted The Most
@Pravin_Patil1 made 10 posts!
@NIVED_NAMBIAR made 9 posts!
@Vrushali_Gave made 8 posts!
Top 3 Most Liked Posts
This post made by @seanrockvz13 received 3 likes!
Congratulations Everyone!
This post made by @Vrushali_Gave received 3 likes!
Congratulations to all MVP’s
This post made by @Anmol_Yadav received 2 likes!
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 .
1 Like
system
(system)
March 9, 2021, 9:00am
16
Daily Forum Report | 08 March 2021
Top 3 Topics with Most Views
Email Extractioin with out using Regex made by @saritha with 33 views.
StudiXでCSVデータをexcelシートに張付け made by @lunaluna with 31 views.
Getting connection error though uipath assistant any suggestion about that? made by @Biswabhusan_Mohapatra with 30 views.
Top 3 Topics with Most Replies
Write cell the regex output made by @AhmedKutraphali with 20 replies.
StudiXでCSVデータをexcelシートに張付け made by @lunaluna with 18 replies.
Element Exist Looping made by @m0e91 with 14 replies.
Top 3 Users Who Posted The Most
@NIVED_NAMBIAR made 25 posts!
@Yoichi made 21 posts!
@ppr made 18 posts!
Top 3 Most Liked Posts
This post made by @rajaneesh received 4 likes!
Many thanks to UiPath and the entire UiPath Community for selecting me again as an MVP! Congratulation to all MVP’s 2021 !
Looking forward for another great year!!
Warm Regards,
Raj
UiPath MVP
Sydney, Australia
This post made by @nisargkadam23 received 3 likes!
So happy to be included in the List of MVP 2021.
Congratulations to all the MVP’s.
This post made by @alexandru received 2 likes!
Thank you for reporting this. It will be fixed soon.
Top 3 Most Liked Solutions
This solution provided by @Ewout received 2 likes!
@NIVED_NAMBIAR with some further trial and error i resolved it. Get outlook mail message accepted it in this format: dd/MM/yyyy HH:mm . For everyone encountering this issue: Exclude seconds from your time format to get it to work!
Credits to Nived
This solution provided by @ppr received 2 likes!
its already included:
[grafik]
you can test / develop regex e.g. with regex101.com
Also have a look here:
This solution provided by @thayane.ribeiro received 2 likes!
Thanks, everyone! I changed my file extension to CSV and now it’s reading in less than one minute!
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 .
1 Like
system
(system)
March 10, 2021, 9:00am
17
Daily Forum Report | 09 March 2021
Top 3 Topics with Most Views
Check for downloading file extension using Regex made by @Sahil_Garg1 with 32 views.
Regex to remove entire lines between 2 specifc identifiers made by @DewanjeeS with 26 views.
Click Activity doesn't work in web application made by @Gugu_Khoza_Lubanzi_ICT_Co with 26 views.
Top 3 Topics with Most Replies
Check for downloading file extension using Regex made by @Sahil_Garg1 with 18 replies.
New column in a data table by concatenating to existing columns made by @shrayud with 16 replies.
Write empty fields in Excel made by @crazyronny with 14 replies.
Top 3 Users Who Posted The Most
@Pravin_Patil1 made 23 posts!
@NIVED_NAMBIAR made 23 posts!
@songoel made 18 posts!
Top 3 Most Liked Posts
This post made by @Yoichi received 3 likes!
こんにちは
文字を入力(Type Into)のデフォルトモードやSendWindowMessagesは状況によっては
周囲の影響を受けやすいため、このようなケースは
1.「入力をシミュレート」モードを試す。
2.1がNGの場合は、一度クリップボードに文字列を移してから、Ctrl+vで貼り付ける。
等で対処します。
また文字列が正確に入力できたかを確認し、誤りがある場合は再入力を行う等の手法もよくとられます。
This post made by @Yoichi received 3 likes!
Hi,
Hope the following helps you.
dict = "abcdab".GroupBy(Function(c) c).ToDictionary(Function(g) g.Key,Function(g) g.Count)
Note: dict is Dictionary<Char, Int32> type.
[img20210310-1]
This post made by @BasiReddy received 2 likes!
Congratulations Everyone
Top 3 Most Liked Solutions
This solution provided by @Yoichi received 3 likes!
こんにちは
文字を入力(Type Into)のデフォルトモードやSendWindowMessagesは状況によっては
周囲の影響を受けやすいため、このようなケースは
1.「入力をシミュレート」モードを試す。
2.1がNGの場合は、一度クリップボードに文字列を移してから、Ctrl+vで貼り付ける。
等で対処します。
また文字列が正確に入力できたかを確認し、誤りがある場合は再入力を行う等の手法もよくとられます。
This solution provided by @NIVED_NAMBIAR received 2 likes!
Hi @dywan219
welcome to forum
You can try like to add values to the col3
After adding col3 column , you can use the following query in invoke code with datatable argument dt1 as In/out
dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“col3”)= row(“col1”).ToString)
Hope it helps you
Mark it as solution if it works
Regards,
Nived N
Happy Automation
This solution provided by @ptrobot received 2 likes!
Thanks for the explanation but Regex can’t find '#end and go up. What it does is to find ); and then go down until it finds '#end. If we don’t want xx in between we need to use (?!xx) to tell it not to match xx.
I hope it’s right this time:
\);((?!\);)[\s\S])*?'#end
[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 .
1 Like
system
(system)
March 11, 2021, 9:00am
18
Daily Forum Report | 10 March 2021
Top 3 Topics with Most Views
How to filter datatable from linq query made by @Gopikrishna with 32 views.
[Gsuite]既存スプレッドシートへのシート追加方法 made by @Akattyan with 26 views.
Orchestrator logging report is empty - no logging visible made by @gjm with 25 views.
Top 3 Topics with Most Replies
Problem when copying formula in excel cell made by @Nestor_Escobar_SIS with 15 replies.
How to sort IEnumerable <match>? made by @Jay_Chacko with 14 replies.
How to filter datatable from linq query made by @Gopikrishna with 13 replies.
Top 3 Users Who Posted The Most
@NIVED_NAMBIAR made 22 posts!
@prasath17 made 17 posts!
@Pravin_Patil1 made 13 posts!
Top 3 Most Liked Posts
This post made by @Bill_Richardson received 2 likes!
Is there any update on this issue? I am using 20.10.6 and notice that the argument values must be edited in Assistant before they “take” are and get used when you run the automation. This is confusing to users as we must explain to all Assistant users that they need to go edit the displayed value of the argument (add a space at the end, or whatever) before it will actually be used when they run the automation.
This post made by @Yoichi received 2 likes!
こんにちは
既に解決済みですが、直接の原因は、名前空間の設定状況により、DirectoryがMicrosoft.Graph以下のものなのか、System.IO以下のものなのかが判別できない状態になっていることにあります。
最新版CEですと名前空間の設定の削除ができますので、Microsoft.Graph上で右クリックして削除してみてください。
[img20210310-3]
少し前のバージョンですと、Studioから削除できなかったかと思うので、その場合は、非保証の
方法になりますが、xamlファイルをメモ帳等で開き、
TextExpression.NamespacesForImplementation要素の中のMicrosoft.Graphの記述の
ある行を削除してみてください。
[img20210310-2]
This post made by @Yoichi received 2 likes!
こんにちは
ファイルを作成アクティビティは単に空のファイルを作成するだけですので、この場合は使う必要はありません。
単に書き込みたいファイル名でエクセルアプリケーションスコープ(ファイルが無いときは新規作成オプションをオン)を配置しその中で範囲書き込み、またはシステム-ファイル-ワークブック以下の範囲書き込みを用いると、自動的に中身のあるファイルを生成してくれます。
Top 3 Most Liked Solutions
This solution provided by @ppr received 1 likes!
with selectmany we flattens the grp.toList (A list of datatrows) into one sequence.
Happy to hear about that it is working. May we ask you on flagging the solving post as solution after you have done with the final testings. Thanks
This solution provided by @LevKushnir received 1 likes!
HI @josesgar
The solution is here.
SAP behaves differently (human-being vs automation) for some windows, to resolve this problem please use Dialog (modal) display options
Best regards, Lev
@loginerror thanks for bringing this topic to my attention. No need for support ticket in this case
This solution provided by @ppr received 1 likes!
@Gopikrishna
give a try on following LINQ
(From d in dtData.AsEnumerable
Group d by k=d("Username").toString into grp=Group
let check = grp.Select(Function (x) x("Last_Name").toString.Trim & x("First_Name").toString.Trim).Distinct().Count
Where check > 1
Select grp.toList).SelectMany(Function (s) s).CopyToDataTable
We can assume that also an empty result will be returned. So apply following pattern for handling this as well:
[grafik]
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
(system)
March 12, 2021, 9:00am
19
Daily Forum Report | 11 March 2021
Top 3 Topics with Most Views
【UiPathアカデミー】UiPath StudioX 開発系のコースが新しくなりました! made by @Taeko_UiPath with 62 views.
Outlook メールメッセージファイルの読み込み made by @Z15 with 61 views.
アクティビティ内でホットキーを検索しても出てきません。 made by @111817 with 51 views.
Top 3 Topics with Most Replies
How to click calendar from text made by @fairymemay with 17 replies.
How does read range works on date columns in excel? made by @Robotman with 12 replies.
Chrome: Automate "Close all tabs to the right" made by @herman with 12 replies.
Top 3 Users Who Posted The Most
@prasath17 made 15 posts!
@Yoichi made 12 posts!
@fairymemay made 11 posts!
Top 3 Most Liked Posts
This post made by @Raviteja_N received 4 likes!
many wishes to all the MVP’s
This post made by @Taeko_UiPath received 4 likes!
This post made by @tainan.ramos received 3 likes!
Hi @praveen_sonkusare
You can try to do it using regular expression.
Follow the example.
Variabel
texto = "EmployeeID:E102 ManagerID:E088 From Date:25/01/2021 To Date: 20/02/2021"
Regular Expression
System.Text.RegularExpressions.Regex.Match(texto,"(?<=EmployeeID:)\w+")
System.Text.RegularExpressions.Regex.Match(texto,"(?<=ManagerID:)\w+")
System.Text.RegularExpressions.Regex.Match(texto,"(?<=From Date:)\w+\/\w+\/\w+")
System.Text.RegularExpressions.Regex.Match(texto,"(?<=To Date: )\w+\/\w…
Top 3 Most Liked Solutions
This solution provided by @gheorghestan received 1 likes!
@Marcelo_Vina , UIAutomation.Activities 21.2-preview comes with support for scraping SAP ALV Grid tables. Please give it a try and let me know your feedback!
Thanks.
Gheorghe
This solution provided by @songoel received 1 likes!
See, for each would contain a sequence of steps that you are performing (in a loop) during which at any point in time the pop up may appear.
Incase the sequence of steps is not iterative and it occurs just once, you can use a simple Try - Catch. Use the element exists in catch block and handle it there.
Other major steps you can mention in the Finally block.
If you have a set of items for which you are performing the actions specified in the for each loop, then go for the loop.
In the parall…
This solution provided by @Z15 received 1 likes!
shinji様
本件とは別のエラーにも返信頂き、誠にありがとうございました。
勉強になりました。感謝致します。
また、本件のメール情報の取得、以下の通り(今回は、本文のみ取得)
本文を「メールメッセージ送信」の本文へ変数(Arg_HTMLBODY)を与えてメール送信ができることが確認できました。
誠にありがとうございました!
[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
(system)
March 13, 2021, 9:00am
20
Daily Forum Report | 12 March 2021
Top 3 Topics with Most Views
Make your package compatible with Studio 21.4 made by @Sophia_Salo with 80 views.
Merging 3 datatable into one with different column name made by @Sumit_D with 35 views.
Extraction in Invoice Problem made by @badal_patel with 34 views.
Top 3 Topics with Most Replies
Extraction in Invoice Problem made by @badal_patel with 24 replies.
Please Help me made by @vjsolomons with 9 replies.
How to move files with the same format from a folder to another one? I got the problem with the Expressionwith made by @Nguy_n_Th_y with 8 replies.
Top 3 Users Who Posted The Most
@prasath17 made 21 posts!
@badal_patel made 11 posts!
@Yoichi made 9 posts!
Top 3 Most Liked Posts
This post made by @Sophia_Salo received 7 likes!
We would like to inform you about the latest Studio changes as our purpose is to make sure your activities will continue to work smoothly with our latest 21.2 Community Preview release and the upcoming 21.4 FTS release.
Starting from 21.2 Community Preview edition of UiPath Studio, there might be compatibility issues between existing activity packages and upcoming Studio versions. This is because Studio 21.2 (or higher) is multi-process as opposed to single-process. For instructions on how to u…
This post made by @badal_patel received 3 likes!
Beneficiary Account, Amount, Payment Date, Remarks
This post made by @StefanSchnell received 2 likes!
@LevKushnir
Excellent presentation Lev
SAP with StudioX is great, this makes it even easier for business experts to automate SAP.
Top 3 Most Liked Solutions
This solution provided by @StefanSchnell received 2 likes!
@Haretoke
Hello Haretoke,
you installed .NET Connector 3.0 for .NET 2.0 x64,
but it is necessary to install .NET Connector 3.0 for .NET 4.0 x86.
Best regards
Stefan
This solution provided by @NIVED_NAMBIAR received 2 likes!
Hi @Aditya_Nugroho
Welcome to forum
First u can a intialise a counter variable with intial value of 2
Then use for each row to loop through each row of the datatable
Inside the loop, do the following:
Use write cell activitiy with cell value as "A"+counter.ToString
Then increment the counter by one using assign activitiy
counter=counter+1
Regards
Nived N
Happy Automation
This solution provided by @anon54029271 received 2 likes!
I’ve just received an e-mail from the sales team.
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
(system)
March 14, 2021, 9:00am
21
Daily Forum Report | 13 March 2021
Top 3 Topics with Most Views
Email attachments are not saving to local folder made by @Deepika_Ajith with 25 views.
Pivot and write excel made by @fairymemay with 24 views.
Pause Automation on a slow website made by @shrayud with 22 views.
Top 3 Topics with Most Replies
Appending data into Data table made by @shekhawat.arjun1307 with 16 replies.
StudioX - Calculate using spreadsheet issue made by @Prinal_C with 15 replies.
I need to identify the value of text in text document but that text occur multiple time made by @Puneet_Singh1 with 9 replies.
Top 3 Users Who Posted The Most
@NIVED_NAMBIAR made 11 posts!
@prasath17 made 11 posts!
@Srini84 made 10 posts!
Top 3 Most Liked Posts
This post made by @ppr received 3 likes!
This post made by @moenk received 2 likes!
Sounds as if you like to use this activity:
This post made by @Marius_Puscasu received 2 likes!
Top 3 Most Liked Solutions
This solution provided by @Marius_Puscasu received 2 likes!
This solution provided by @prasath17 received 2 likes!
@Prinal_C - Here you go…
[image]
Idea I have used here is : First trying to find the last row of any columns…which gives me the output: 4
[image]
Using this value, i can set my range for the column F…
Say : F2: F4
Excel.Sheet(“Sheet1”).Range(“F2:F” + Saved.Values(Of Int32)(“Last Data Row”).ToString)
Here: Saved.Values(Of Int32)(“Last Data Row”).ToString) ==> has the value of 4…
In the what to write = I am giving the formula as E2*2.5
That’s it here is my output
[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
(system)
March 15, 2021, 9:00am
22
Daily Forum Report | 14 March 2021
Top 3 Topics with Most Views
Input a data or parameter to uipath from other softwares made by @Mingyu_Yan with 25 views.
Generic Value: Cannot add System.Int32 to System.String made by @Anggara_Rahmadhani with 22 views.
Dynamic selector for diffrent user made by @ashishmani with 21 views.
Top 3 Topics with Most Replies
Incrementing count of a column in excel based on value of other table made by @shekhawat.arjun1307 with 11 replies.
Data Service Entities got deleted after reactivating Enterprise Trial license made by @jamesjacobsydney with 8 replies.
Compare in a database made by @IOrlando with 7 replies.
Top 3 Users Who Posted The Most
@Sahil_Garg1 made 10 posts!
@shekhawat.arjun1307 made 10 posts!
@RPAForEveryone made 6 posts!
Top 3 Most Liked Posts
This post made by @wasea received 3 likes!
This post made by @ppr received 2 likes!
@Markus3003
define the variables (both of datatype string)
strFirstDayLMOnth
strLastDayLMonth
use an assign for setting the values e.g.
strFirstDayLMOnth = new DateTime(now.Year,now.Month, 1).AddMonths(-1).toString("dd.MM.yyyy")
strLastDayLMonth = new DateTime(now.Year,now.Month, 1).AddDays(-1).toString("dd.MM.yyyy")
for setting the dates in SAP giva try on using a Type Into activity along writing the corresponding variable e.g. strFirstDayLMOnth
This post made by @Sharal_DCosta1 received 1 likes!
Congratulations everyone!
Top 3 Most Liked Solutions
This solution provided by @wasea received 3 likes!
This solution provided by @ken_infield received 1 likes!
This solution provided by @Nadia_GHOUFA 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 .
1 Like