topic Re: Need to open and extract data from downloaded htm file in Product Forum

Need to open and extract data from downloaded htm file

Anonymous — Wed, 12 Jul 2023 08:11:31 GMT

Hi,
I have downloaded a file from SAP in htm format. Now I need to extract data from the htm file. So, I tried to run Microsoft Edge using Application Modeler. Then I used navigate stage to launch Edge where I specified the path of htm file. Unfortunately, it doesn't work for me. Can anyone provide a suitable solution?

Re: Need to open and extract data from downloaded htm file

PvD_SE — Wed, 12 Jul 2023 11:33:42 GMT

Hi Ekram,

When you say you want to read from the downloaded htm file, do you mean you want it to open in a browser and then read the content of the browser, OR do you want to open the saved file in Notepad as you would any .txt file and read through the rows of data?

Happy Coding!
----------------
Paul
Sweden

Re: Need to open and extract data from downloaded htm file

Anonymous — Wed, 12 Jul 2023 11:51:51 GMT

Hi @Paul,

I have in mind to open the saved htm file in the browser so that I can use the Xpath to extract data.

Idea about opening the htm file in notepad and extracting the data is also interesting. Both concepts (Browser and Notepad) are new to me. It would be great if you could share both concepts.

Regards,

Ekram

Re: Need to open and extract data from downloaded htm file

PvD_SE — Wed, 12 Jul 2023 12:11:47 GMT

Hi Ekram,

In your shoes, I'd open the file in Notepad and see what the data looks like. Then open the same file in a browser and compare the results to what you see in Notepad. Then I'd chose whatever seems simplest to access. My guess would be Notepad.

Alternatively, there's also a BP native object called 'Utility - File Management' that contains an action 'Read All Text rom File'. It seems to be able to handle whatever flat file data you want to read. So you might want to give this a try. Perhaps this would be the easiest choice.

Happy Coding!
----------------
Paul
Sweden

Re: Need to open and extract data from downloaded htm file

Anonymous — Wed, 12 Jul 2023 13:05:18 GMT

Hi Paul,

Thank you for the info. I will try your solution.... 🙂

Regards,

Ekram

Re: Need to open and extract data from downloaded htm file

Anonymous — Thu, 13 Jul 2023 06:22:03 GMT

Hi Paul,

I tried your solution "Read all text from file". Unfortunately I don't get the exact data. In my case I think it is better to open htm file with brwoser. Then extract data with XPath.

Regards,

Ekram

Re: Need to open and extract data from downloaded htm file

shashank.kumar280 — Thu, 13 Jul 2023 06:46:20 GMT

Hi Ekram,

Try launching as below.

Note that space is encoded as %20 in params

If above works then you may refer https://community.blueprism.com/discussion/browser-mode-not-responding-for-a-webpage-with-html-extension if you have issues with spying

Re: Need to open and extract data from downloaded htm file

Anonymous — Thu, 13 Jul 2023 08:36:57 GMT

Thanks @shashank.kumar280