{{tag>category:"OpenInsight 32-bit" author:"cmeyer" author:"bob carten" author:"Donald Bakke"}}

[[https://www.revelation.com/the-works|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]]


==== OI keyboard Macro (OpenInsight 32-bit) ====
=== At 30 AUG 2020 09:18:41AM cmeyer wrote: ===
 
 
<QUOTE>
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
</QUOTE>
----

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

<QUOTE>

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+

[url=https://learn.onemonth.com/automate-web-forms-with-python/]https://learn.onemonth.com/automate-web-forms-with-python/[/url]





</QUOTE>

----

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

<QUOTE>
<QUOTE>

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+

[url=https://learn.onemonth.com/automate-web-forms-with-python/]https://learn.onemonth.com/automate-web-forms-with-python/[/url]



</QUOTE>



This [url=https://blog.srpcs.com/displaying-content-in-internet-explorer/]blog article[/url] 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.



[url=mailto:dbakke@srpcs.com]Don Bakke[/url]

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=233C3A7C9CD0C14E868E2C292F6EE865|View this thread on the Works forum...]]