Solved

Best Windows Automation Software

Posted on 2003-11-21
8
198 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

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…
A big percent of today’s marketing activity is performed through the online environment. The marketing strategies that have existed a decade ago no longer relate to what’s happening today. We’re currently facing a revolutionary era, called the digit…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Suggested Courses

734 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