Miclotr Posted November 30, 2018 Share Posted November 30, 2018 Hi, I'm fairly new to the AutoIt world, but seem to be fair enough in Powershell Scripting. Hence I do have to automate SQL Developper Gui... 1. creation of a new Dbase Connection 2.Opening that connection. Normally I use the "Finder Tool" or the recorder to perform the basic window and parameter catching, but the developers of the tool have chosen to write this as a "SunAwtFrame" , so the only thing I got working is to open the tool .... (Fair enough for a beginner... but not what is expected of me ...) Can someone help me out with this ???? Thanks in advance! Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted November 30, 2018 Moderators Share Posted November 30, 2018 Moved to the appropriate forum, as the Developer General Discussion forum very clearly states: Quote General development and scripting discussions. If it's super geeky and you don't know where to put it - it's probably here. Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums. Moderation Team Miclotr 1 "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
Nine Posted November 30, 2018 Share Posted November 30, 2018 First, use Au2Info.exe tool to see if you got access to the controls of the SQL GUI (dont forget to unfreeze the tool !) If that doesnt work, look at IUIAutomation UDF. Good luck ! “They did not know it was impossible, so they did it” ― Mark Twain Spoiler Block all input without UAC Save/Retrieve Images to/from Text Monitor Management (VCP commands) Tool to search in text (au3) files Date Range Picker Virtual Desktop Manager Sudoku Game 2020 Overlapped Named Pipe IPC HotString 2.0 - Hot keys with string x64 Bitwise Operations Multi-keyboards HotKeySet Recursive Array Display Fast and simple WCD IPC Multiple Folders Selector Printer Manager GIF Animation (cached) Screen Scraping Multi-Threading Made Easy Link to comment Share on other sites More sharing options...
Earthshine Posted November 30, 2018 Share Posted November 30, 2018 (edited) it's written in java. See FAQ 31 Edited November 30, 2018 by Earthshine My resources are limited. You must ask the right questions Link to comment Share on other sites More sharing options...
Miclotr Posted November 30, 2018 Author Share Posted November 30, 2018 Thanks Nine, But that option I did try allready ... Fact is that if you use Au2Info, ensured that the tool was left unfrozen and you run the finder mechanism, that will give you the exact same parameters for the whole tool.... See screenshot I added. It is a real Pain in the @.... If some other gentle wizard has any option, enlighten me... Thx Link to comment Share on other sites More sharing options...
Earthshine Posted November 30, 2018 Share Posted November 30, 2018 (edited) i told you already. read my post. it's java. go look at FAQ 31, standard autoit isn't going to help you much. there is a java spy tool, and also IUIAutomation mentioned previously. Edited November 30, 2018 by Earthshine My resources are limited. You must ask the right questions Link to comment Share on other sites More sharing options...
Miclotr Posted November 30, 2018 Author Share Posted November 30, 2018 10 minutes ago, Earthshine said: it's written in java. See FAQ 31 Thx Earhtshine, But that FAQ is way out of my league, could you advise me a bit more on this ? Link to comment Share on other sites More sharing options...
Miclotr Posted November 30, 2018 Author Share Posted November 30, 2018 found some more info on that spy thing in a topic junkew commented on Link to comment Share on other sites More sharing options...
Nine Posted November 30, 2018 Share Posted November 30, 2018 If you don't feel confortable with FAQ 31, you could try using easy function like mouseclick, send, etc. It is not the best solution, but it can get you started... “They did not know it was impossible, so they did it” ― Mark Twain Spoiler Block all input without UAC Save/Retrieve Images to/from Text Monitor Management (VCP commands) Tool to search in text (au3) files Date Range Picker Virtual Desktop Manager Sudoku Game 2020 Overlapped Named Pipe IPC HotString 2.0 - Hot keys with string x64 Bitwise Operations Multi-keyboards HotKeySet Recursive Array Display Fast and simple WCD IPC Multiple Folders Selector Printer Manager GIF Animation (cached) Screen Scraping Multi-Threading Made Easy Link to comment Share on other sites More sharing options...
Earthshine Posted November 30, 2018 Share Posted November 30, 2018 (edited) it's not that bad, and the IUI tool creates usable code. extract the udf and work through the examples is your best bet. yes, junkew wrote that stuff, the jab spy as mentioned above, you can send simple keystrokes and such as well to keep it real simple there are also other java automation products that cost money such as Squish for automating java stuff https://www.froglogic.com/squish/editions/automated-java-gui-testing/ Edited November 30, 2018 by Earthshine My resources are limited. You must ask the right questions Link to comment Share on other sites More sharing options...
Miclotr Posted November 30, 2018 Author Share Posted November 30, 2018 Well to be honest ... it is one of my first automations i do have to deliver... Directly Whoops ... Darn .... grrrrr ( think you all see what I am doing now .... tearing hair and such) The other things were like... open the finder tool ... or the recorder tool .... play a little and ... fixed .... This is for me ready for the league of extraordinary gentleman ;-) Link to comment Share on other sites More sharing options...
Earthshine Posted November 30, 2018 Share Posted November 30, 2018 what exactly are you trying to do? create databases on client machines or something? you should be able to run sql to do this stuff. My resources are limited. You must ask the right questions Link to comment Share on other sites More sharing options...
Miclotr Posted November 30, 2018 Author Share Posted November 30, 2018 no I work as a CyberSecurity person... We have a suite that performs connections to applications .... logging on with users (and their password) to a tool in a kind of Kiosk mode (streamed session on a jumphost kind of thing) Therefor we sometimes use AutoIt , to create those automatic logons.... A team doing Oracle needs SQLplus, sometimes toad, but also SQL Developer...... that is why I also need to make this work, Link to comment Share on other sites More sharing options...
Earthshine Posted November 30, 2018 Share Posted November 30, 2018 (edited) well, you haven't told me much of anything that you need to do. it looks like you have some learning to do. I would try the IUIAutomation, run simplespy.au3 and do what it tells you, you will end up with usable code you can learn from Edited November 30, 2018 by Earthshine Miclotr 1 My resources are limited. You must ask the right questions Link to comment Share on other sites More sharing options...
Miclotr Posted November 30, 2018 Author Share Posted November 30, 2018 The need ... just make it open SQL developer and make a connection to a Database or instance .... The rest is not needed Link to comment Share on other sites More sharing options...
Earthshine Posted November 30, 2018 Share Posted November 30, 2018 (edited) IUIAutomation should work dude. Play with simplespy.au3, run it in the scite editor, then put your mouse over the java app and controls you want, hit Ctrl-W and go copy the usable code and start playing around. It should work you need to be bigger than yourself and learn something new. it isn't always an easy task handed down to us. Edited November 30, 2018 by Earthshine My resources are limited. You must ask the right questions Link to comment Share on other sites More sharing options...
Juvigy Posted December 3, 2018 Share Posted December 3, 2018 You can create ODBC or Data connections without anything ,then you just need to open it in SQL Dev. Earthshine 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now