Solved

Best Windows Automation Software

Posted on 2003-11-21
8
196 Views
Last Modified: 2010-04-14
I would like to get some advice on what Windows Automation software to purchase for my company.  Preferably it should be something that can be purchased from a "real" company rather than shareware.

It has to be able to do the following:
1) Simulate a person interacting with a web form/application through Internet Explorer.  Including entering data into fields, selecting from lists, and clicking on buttons.
2) Needs to have some sort of file that can store the data to enter into the fields.  This way we can have it loop and interact with the web app over and over again with different inputs.
3) Needs to support cutting-and-pasting of web result pages into Excel or another application.

Basically we are trying to deal with a limited web front-end to a database.  We would like to construct complex queries that return all the data we need in one-fell-swoop, but this is not allowed.  So now we have to get the data bit by bit and paste it all together in Excel.  This takes way too much time and is subject to user error.

So if we can "queue" all our queries in a file that is executed against the web form by some Windows automation software, then we get all the data by just pressing one button.

Any ideas/recommendations?
0
Comment
Question by:dastrw
  • 4
  • 4
8 Comments
 
LVL 19

Expert Comment

by:Dexstar
ID: 9798335
@dastrw:

> So if we can "queue" all our queries in a file that is executed against the
> web form by some Windows automation software, then we get all the data by just
> pressing one button.

I don't know how handy you are with Excel, but Excel can directly open web pages and import their contents.  It also has a huge macro interface that you could use to automate the process.  Maybe put all the parameters for your queries in one sheet, and then have a macro that opens up each query and saves the data.  Just a thought.

Hope That Helps,
Dex*
0
 
LVL 2

Author Comment

by:dastrw
ID: 9798800
How do I get Excel to enter data from the spreadsheet into web form fields?  And how do I get Excel to click on the web form's "Submit" button?
0
 
LVL 19

Expert Comment

by:Dexstar
ID: 9798890
Okay, well, if that's the case, then it might be easier to write a macro to automate Internet Explorer.  What you want to do is entirely possible, I'm just not sure how much effort you want to put into it.  It isn't going to be something you just whip out in a few hours.

Dex*
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 2

Author Comment

by:dastrw
ID: 9798940
That's the point of Windows Automation software (e.g. WinBatch).  It basically lets you record macros within the entire Windows system rather than just in Excel or just in IE.  I have extensive experience writing VB macros in Excel and Access, but I don't want to have to write that odd Microsoft code to call out of one application into another and worry about handles, etc.  I'd like something that lets me write understandable code that spans all of the applications in Windows.

WinBatch claims to do this, but their web page hasn't been updated in over a year and I'd like to get some ideas on other products before settling for this one.
0
 
LVL 19

Accepted Solution

by:
Dexstar earned 500 total points
ID: 9799010
Okay... Well, I asked around, and my one friend swears by http://www.unisyn.com/automate/  but my other friend tells me that http://www.pitrinec.com/toolsworks.htm is the way to go.  So, check those out.

Dex*
0
 
LVL 2

Author Comment

by:dastrw
ID: 9799317
I had found those two as well on an earlier search.  It is good to hear that others think well of them.

Has anyone you know used them for what we're looking to do?  Most of the user testimonials talk about automating sys admin tasks and similar.  I don't see where people are using them to simulate web application execution.
0
 
LVL 19

Expert Comment

by:Dexstar
ID: 9799381
Yeah, the guy who uses AutoMate does stuff with the Web and Word, which is similiar to your Web/Excel application.

Dex*
0
 
LVL 2

Author Comment

by:dastrw
ID: 9799409
Thanks for your help.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Print Server: How to Create it? 1 768
Windows Foriegn Disk 3 137
Video card with drivers for Windows 2000 8 149
Can’t delete a file 14 180
Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question