Extract data table - uipath-html-title value

[Sathish_Kumar_S]

Using Extract data table to extract the values from website.

While hover on auto return in “Next automated action” column the created date is available.

While extracting the table … we are getting only " Auto Return" value in “Next automated action” column.

How to get the text available in hover using table extraction.

Used Get attribute and the required data is available “UiPath-html-title” tag.

How to use this “UiPath-html-title” inside table extract data activity.

Here is the Extract Meta Data

[Anil_G (Anil Gorthi)]

@Sathish_Kumar_S

Please check this on how to edit meta data

badically try to navigate to the required tag and give that in metadata

How to write ExtractMetaData(In Input) of "Extract Structured Data" Activity

Well, During data scraping the meta data that gets generated. Take a small table (if you want t extract structured data) and scrape it using the wizard and see the pattern in which it is generated and you can mess around with the idx attribute if same parent nodes contain the data that you extract are multiples ones. I can give you an example of acme-test.uipath.com work items data scraping. In the below example _ we have these work items to be scraped [image] Fromt he image you start the …

cheers

[Sathish_Kumar_S]

I couldn’t understand what exactly i need to change in meta data to get the Title instead of aaname value … here is the output of inspect in browser

[ppr (Peter Preuss)]

[HowTo] Data Scraping - Advanced Configuration - Text Field, Image Source, Url, CSS Classname, Hover text

This HowTo introduces on how Data scraping can be configured to retrieve also on non standard information from a web table. After indicating the different data columns with the wizard the extract data definition was post edited and changed to the relevant attributes e.g. value (Text field), src ( Image Source), class (CSS Class Name), tite (Hover Text), href (Url). Introduction Following web table is to use for data scraping and also the non text information should be retrieved. [grafik] We…

we would assume that all UiPath-XXX atributes are injected for the selector grabbing, but would recommend using the origin offered tags and attributes

[Anil_G (Anil Gorthi)]

@Sathish_Kumar_S

instead of fulltext try with text or title in attr field

also if it is one tag below then include that tag as after column tag <webctrl tag='a' />

cheers

[Sathish_Kumar_S]

Changing fulltext try with text or title is not giving expected value

if we Add <webctrl tag='a' /> next to column tag…then output is blank

[Anil_G (Anil Gorthi)]

@Sathish_Kumar_S

That is not how you add…in the next line you need to add it

<column name='nameof column' attr='title' >
<webctrl tag='a' />
</column>

Cheers

[Sathish_Kumar_S]

@Sathish_Kumar_S

UiPath-html-title

No values … just blank

[Anil_G (Anil Gorthi)]

@Sathish_Kumar_S

column end tag is missing please change it properly as per mentioned details

cheers

[Sathish_Kumar_S]

@Anil_G

</column>

If i add end tag then there is no data at all in the extracted data table output

[Anil_G (Anil Gorthi)]

@Sathish_Kumar_S

did you remove the slash from the above tag after adding end tag?

is a tag below the column you need?

cheers

[Sathish_Kumar_S]

I have extracted only one column and skipped extracting other columns and changed the attr to title , Now i am getting the required values.

How to use below sample working meta code :

Attribute is Title for only one column
Remaining column attr is FULLTEXT

Below the meta data of working code :

<extract>
	<column exact='1' name='Column0' attr='title'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='10' />
		<webctrl tag='span' idx='1' />
		<webctrl tag='span' idx='1' />
		<webctrl tag='a' idx='1' />
	</column>
</extract>

[Anil_G (Anil Gorthi)]

@Sathish_Kumar_S

add this part to the remaining columsn meta data that you have initially

<column exact='1' name='ColumnName as You need' attr='title'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='10' />
		<webctrl tag='span' idx='1' />
		<webctrl tag='span' idx='1' />
		<webctrl tag='a' idx='1' />
	</column>

cheers

[Sathish_Kumar_S]

Here is the Meta code of all the columns :

So we need title as attr for

and remaining columns attr is fulltext

SyntaxEditor Code Snippet

<extract-table get_columns_name='1' get_empty_columns='1' columns_name_source='Longest'> <column name='Column-0' attr='fulltext' /> <column name='Request Id' attr='fulltext' /> <column name='Vendor Code' attr='fulltext' /> <column name='Request Type' attr='fulltext' /> <column name='Status' attr='fulltext' /> <column name='Requested Quantity' attr='fulltext' /> <column name='Approved Quantity' attr='fulltext' /> <column name='Requested Refund per Unit' attr='fulltext' /> <column name='Approved Refund per Unit' attr='fulltext' /> <column name='Next Automated Action' attr='fulltext' /> <column name='Warehouse' attr='fulltext' /> <column name='Authorisation ID' attr='fulltext' /> </extract-table>

[Anil_G (Anil Gorthi)]

@Sathish_Kumar_S

this is how it looks

<extract-table get_columns_name='1' get_empty_columns='1' columns_name_source='Longest'> 
<column name='Column-0' attr='fulltext' /> 
<column name='Request Id' attr='fulltext' /> 
<column name='Vendor Code' attr='fulltext' /> 
<column name='Request Type' attr='fulltext' /> 
<column name='Status' attr='fulltext' /> 
<column name='Requested Quantity' attr='fulltext' /> 
<column name='Approved Quantity' attr='fulltext' /> 
<column name='Requested Refund per Unit' attr='fulltext' /> 
<column name='Approved Refund per Unit' attr='fulltext' /> 
<column exact='1' name='ColumnName as You need' attr='title'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='10' />
		<webctrl tag='span' idx='1' />
		<webctrl tag='span' idx='1' />
		<webctrl tag='a' idx='1' />
</column>
<column name='Warehouse' attr='fulltext' /> <column name='Authorisation ID' attr='fulltext' /> 
</extract-table>

[Sathish_Kumar_S]

@Sathish_Kumar_S

Next Automated Action

Yes added like below … but the value is empty for that particular column

[Anil_G (Anil Gorthi)]

@Sathish_Kumar_S

is it possible to provide the site please

cheers

[Sathish_Kumar_S]

It is a internal site and requires credential

[Sathish_Kumar_S]

I guess i found the way to extract the required data…Let me test it and update you