I’m looking for a way to convert an unstructured web page with configuration settings into a data table. The attached image shows a sample of the web page and this image shows a sample of the table I’m trying to get. I tried using the Extract Table Data screen scraping activity, but that doesn’t work well for two reasons. The major problem is that I have not been able to figure out how to specify which elements of the configuration page should be arranged in table columns, and which should be table rows. A more minor problem is that I don’t know how to extract the value of the toggle elements, such as the one under “restrict external file elements”. Values of checkboxes are extracted by screen scraping, but the toggles are ignored. The current result of screen scraping is a jumble of text. Any suggestions on how to make it look more like the spreadsheet would be greatly appreciated.
Extract everything using separate get attribute or get text activities and then write into table as you need
Cheers
Thank you Anil. I should’ve mentioned in the post that I can’t use get text activities because items in the page may change without warning. The only properties I can go by are the relative locations of the settings labels, and their values. Is there a way to arrange items on the page into a table without specifying in advance what text I’m looking for?
Get text will not have a point if we know the text we want to extract…get text is used when we have kind of an anchor or the field is constant but the values change…so please use the same…
Make sure in selector you use other attributes than innertext or the actual value
Cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.