I don't know if what I'm looking for is something already available and I'm just not finding it, or if no one has made anything like this.
My use case: I have a lot of reports that I must download from a specific website. This entails signing onto a single-sign on landing page, entering my username and password, clicking the tile for a specific web application, and when in the application click though various links and change various settings. Then submit and once the task runs take the resulting data and download it as a text file. And, yes, I have to do it this way. The third-party site will not generate and send me these files, or drop them to an FTP site that I can access and download them from.
I would need to do this for something in the neighborhood of twenty reports, sometimes more depending on the time of the year. The number of reports changes when done quarterly, semi-annually, and annually.
So what I'm basically looking for is a tool that will watch me go trough this process in a browser, recording the back and forth web interactions, generate a script from that, and then create a script application that will replay the whole thing. So in the end all I would need to do is double-click the application and it will run and drop the file(s) into a folder, just by double-clicking the application icon.
Now to be clear. I do not want to have it script the GUI, like an Applescript that controls a browser, where you have to keep your hands off the computer for fear of interrupting the various keyboard entries and mouse movements and clicks while it runs. I would like this to be like a bash script running in the terminal, while I could be doing other things on the computer while this runs.
Anyone know of such an application? My web developing skills are anemic. I'm basically a database programmer (Oracle) and spend all my time writing SQL, and one of my tasks is to run said reports and load the data into our various databases. I'd like to automate this whole process.
My use case: I have a lot of reports that I must download from a specific website. This entails signing onto a single-sign on landing page, entering my username and password, clicking the tile for a specific web application, and when in the application click though various links and change various settings. Then submit and once the task runs take the resulting data and download it as a text file. And, yes, I have to do it this way. The third-party site will not generate and send me these files, or drop them to an FTP site that I can access and download them from.
I would need to do this for something in the neighborhood of twenty reports, sometimes more depending on the time of the year. The number of reports changes when done quarterly, semi-annually, and annually.
So what I'm basically looking for is a tool that will watch me go trough this process in a browser, recording the back and forth web interactions, generate a script from that, and then create a script application that will replay the whole thing. So in the end all I would need to do is double-click the application and it will run and drop the file(s) into a folder, just by double-clicking the application icon.
Now to be clear. I do not want to have it script the GUI, like an Applescript that controls a browser, where you have to keep your hands off the computer for fear of interrupting the various keyboard entries and mouse movements and clicks while it runs. I would like this to be like a bash script running in the terminal, while I could be doing other things on the computer while this runs.
Anyone know of such an application? My web developing skills are anemic. I'm basically a database programmer (Oracle) and spend all my time writing SQL, and one of my tasks is to run said reports and load the data into our various databases. I'd like to automate this whole process.
