How to retrieve structured data from winforms

Help
1

Hi,
I need to retrieve multiple fields data from winform (Windows stand alone application) to excel , i tried data scrapping & screen scrapping, not successful. Can anyone give ideas to handling such kind of task.

1 Like
2

Any other clues :slightly_smiling_face:

1 Like
3

@cschevuri Can you share the screenshot of the page that you want to scrap

4

Capture
Capture869×236 12.6 KB

5

@cschevuri Have you tried with get text activity

6

Get text retrieves for one field , but, i need to extract all fields data (35 fields) in the winform and write into excel form.
Do we have any other way ?

7

@cschevuri Try with computer vision activites.

8

@cschevuri If the Fields to fetch are constant then you can Do Screen scraping to Get the String and Do Some String Manipulations and get them in Key Value Pairs

9

Thank you, trying to install package and API license, will let you know if i face any issues…

1 Like
10

@cschevuri

In your scenario Try to use Find children activity it will get the list of items.use for each and get the attribute by using Get attribute activity and store it in a variable then use add data row to add the variable to data table.

Regards,
A Manohar

11

Hi @WhenCutEsh, i succeeded till screen scraping and retrieve those values, can you please elaborate more on string manipulation and paring. Thank you…

12

Thank you @Manohar1, checking your suggestion.

13

@cschevuri Like The Left Side labels will be constant right you can get a sub string between two labels
Eg: Get Index Of "Item# : ", Then Get Index of Motor HP/KW :, then subtract these two string you will get
1100 Recalc, then Replace Recalc with String.Empty

14

@cschevuri

I just seen your screen shot ,in your scenario this method will not work for html tables it will work.

Regards,
A Manohar