Best Windows macro recording software?
March 12, 2005 12:39 PM Subscribe
I've taken on a little mini project and I think the best way to get the job done will be to use one of those little bits of software which can copy and then simulate mouse movements etc.
posted by uk_giffo to computers & internet (14 answers total)
Some background details -
My boss wants me to find a solution to this problem: There's this ancient Facilities Management system that's used where I work. Essentially it records hourly water and air temperature readings from hundreds of individual sensors placed within the water system. I don't know what kind of database this data is stored in (it looks like an ancient proprietary database that's just been built upon over the years) before it gets retrieved via the Windows frontend app, but using this app only allows you to look at readings from up to 10 sensors at a time (I don't know whether this is due to enforced restrictions within the frontend or the database, or both). My boss wants me to find a way for him to be able to automatically see periodic readings from all the sensors at once, or at least all the sensors from a certain building, and not through the frontend.
The way I wanted to approach this was to access the database in which the values are stored, and circumvent using this restrictive frontend - I was hoping it would be an SQL db or something like that. But because I frankly don't understand the implemented technologies quite enough I concluded the only way to get at the data automatically and periodically is through one of those mouse recording and playback programs - this would then open up an excel spreadsheet, import the data into it 10 sensor readings at a time and finally I'd do something with VBA to make it more presentable, maybe run off regular reports etc
My only doubts about this approach come from the fact that the frontend (which the recorded mouse macro will be using) is unlikely to stay static - things may be added fairly regularly to the frontend screen which could mess up my mouse macro e.g. if I record the mouse moving to the sixth file in a view of directories (or at point x,y) and selecting it and then if a file gets added to the beginning of this view my previous file is now the seventh one, so any mouse recording software would need to be fairly "intelligent" or at least have pretty decent scripting abilities.
Wow, having just read that back to myself and realised it's nowhere near as clear and concise as it should be I hope you can get understand what I need to get done. If anyone has any comments on the approach I've decided to take and the best mouse macro software I should use they'd be much appreciated.