Hi Everyone, I have a question.
I am downloading a mail and then openning that mail and reading a data table from that mail, I am using the extract data table activity. Now some time this activity fails because selector are not found, but when I go to “edit the selector” option of that extract data table activity and use highlight option, it always highlights the correct area even though the activity failed just a few seconds ago. Do you think if I add a delay before reading the data table it will be solved as it will give proper time for all the element to settle in place ?
can you elaborate more on this, thanks
When mail is a mailmessage / return from an get Mail XXX output we would also check to extract the datatable directly from the content
Why don’t you try it? Note that static delays can in most cases be replaced with dynamic ones, by using Check App State / Element Exists. Some apps load all the elements even if they are not shown so a visibility check might help in your case.
How to extract data table directly from the mail. It is basically a tracker with name, DOB, etc. when I read that mail from mail.body syntax it is giving each cell value in a row in one line. How can I extract it in the correct data table format ?
Columns name in the data table may change , can I still apply element exists if I am not sure what will be the name of the first column ?
Hi @Iamsaurabh
If the problem based on delay only , then U can try with
wait for Page load as “Complete”
Thanks
VP
You might be able to create a dynamic enough selector. But as others have pointed out, it could be better to parse the table from the email text.
when mail is html.body and table a web table (HTML Tag table)
- we can use some packages from UiPath Marketplace (Unfortunately the Compatibility: Windows availability is not given by a lot of packages)
- we can quickly write our own extractor by using https://html-agility-pack.net/
When email is text and table is a csv table
- we can try grabbing the table with a regex and using it later CSV Parsing (e.g. generate Table Activity)
just to mention a few options
- Read the mail.htmlbody
- Save that as .html using write text file
- Open the save files using use application/browser
- Use extract table activity…as there would be only one table
<webctrl tag='table' />
should give the table
Cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.