Does Delay activity helps Ui Selector?

Help Activities
, , , , , ,
1

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 ?

2

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

3

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.

4

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 ?

5

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 ?

6

@Iamsaurabh

7

Hi @Iamsaurabh
If the problem based on delay only , then U can try with
wait for Page load as “Complete”

image
image547×537 18 KB

Thanks
VP

8

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.

9

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

10

@Iamsaurabh

  1. Read the mail.htmlbody
  2. Save that as .html using write text file
  3. Open the save files using use application/browser
  4. Use extract table activity…as there would be only one table <webctrl tag='table' /> should give the table

Cheers

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.