DataLoad Community

emanuel · Joined: 01 Feb 2010 Posts: 5 Location: mumbai

HI

Please let me know how to identy the Mouse Clicks when I am preparing Data Loader sheets for Loading in Oracle Forms

Rgds

DataLoad · Posted: Tue Sep 13, 2011 4:04 pm Post subject:

Hi,

Use the *ML() command to send a mouse click. Details of how to use this can be found at the bottom of the following web page:

http://www.dataload.com/help/macro/commands.htm

Thanks and regards,

Jonathan

emanuel · Joined: 01 Feb 2010 Posts: 5 Location: mumbai

I had tried doing the following

1. Opened the Data Loader sheet

2. Inserted*ML( in the sheet and got the message as “Click OK to turn on the mouse recorder………”

3. Clicked ok on the message

4. Alt tabbed to Oracle form and clicked on the desired TAB

5. Alt tabbed to Data Foader file again and got the *ML(…….) number in the bracket

6. But why I get the different number again if I choose the same TAB ??

Please let me know if I need to follow the same steps or are there is any other steps ?

DataLoad · Posted: Wed Sep 14, 2011 9:30 pm Post subject:

Those steps are correct. It would be unusual if you got exactly the same numbers each time you perform these steps because they specify an exact point on screen and you will probably click a slightly different screen location each time. Remember that the numbers specify 1 of approximately 1 million points on your PC screen rather than just relating to an Oracle tab. Regardless that the numbers are slightly different each time you go through this process, the *ML() command will still work as long as the Oracle window is the same size and in the same location when you run your load compared to when you identified the *ML() coordinates. To help ensure the mouse click always works it is a good idea to always have the Oracle window maximized.

Jonathan