Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 30 AUG 2020 09:18:41AM cmeyer wrote:

Hi All,

More and more are my clients having to fill in web data (via a browser) on behalf of service providers, government organisations etc. This data was previously supplied via email or documentation. These service providers do not provide an API to interface with their system.

I was wondering if there is a way to create some sort of keyboard macro that can be used to enter data on a web site using OI data. If this were possible this would save many hours per day.

Any advice would be grateful.

Chris


At 31 AUG 2020 08:58AM bob carten wrote:

You might be able to make a form with an Olecontrol using Shell.explorer,

on the Create event call oleCallMethod(@window:'.OLE_1', 'Navigate2', myurl)

then you can try using OlePutProperty or OleSendMessage with GetElementbyID to set the form elements.

You would need to open the form in a regular browser in developer mods and use inspect to find all the element ids

Here is an example in python, to show you the general idea. I'll see if I have a snippet in Basic+

https://learn.onemonth.com/automate-web-forms-with-python/


At 31 AUG 2020 09:33AM Donald Bakke wrote:

You might be able to make a form with an Olecontrol using Shell.explorer,

on the Create event call oleCallMethod(@window:'.OLE_1', 'Navigate2', myurl)

then you can try using OlePutProperty or OleSendMessage with GetElementbyID to set the form elements.

You would need to open the form in a regular browser in developer mods and use inspect to find all the element ids

Here is an example in python, to show you the general idea. I'll see if I have a snippet in Basic+

https://learn.onemonth.com/automate-web-forms-with-python/

This blog article is a bit old and might not be ideally suited to this use case, but it might help lay a foundation for solving the problem using Bob's suggestion.

Don Bakke

SRP Computer Solutions, Inc.

View this thread on the Works forum...

  • third_party_content/community/commentary/forums_works/233c3a7c9cd0c14e868e2c292f6ee865.txt
  • Last modified: 2023/12/30 11:57
  • by 127.0.0.1