automation

Can someone suggest a good SQA automation tool that has screen capture facility?

It is a Java Swing application and I need the ability to take screen shots after certain steps in the test. ...

WatiN Timeouts in Windows Server 2008 IE8

I've created some automated tests using WatiN and MBunit and they run fine on my machine (running Windows 7 and VS 2010). However, when I try running them on a virtual machine which is running Windows Server R2 2008 and IE8 my tests consistently timeout unless I am clicking into the window periodically. IE is not in protected mode. A...

vbscript: convert unicode string to array of bytes

I have unicode string passed to vbscript procedure (not visual basic 6, but vbscript). I want to iterate unicode string char by char, get code for every symbol, truncate code to byte range [0..255] and create array of bytes. This way new array of bytes should be twice smaller in memory compared to original unicode string. I am going sa...

How to Correctly Specify ATP 2.0 XIRR Function Call in Access-to-Excel Automation

If someone can help, I need some in properly defining some call parameters in an Access 2003 to Excel 2003 VBA problem. I'm trying to use the XIRR function in the ATP 2.0 Type Library from Access. I have referenced the ATP 2.0 Type Library in my Access project. Here is the relevant VBA code (with a little pseudocode) I'm using behind a f...

Batch file to change all network shares on computer

I need to change all shares of //foo to //bar in a batch file. Say i have R: //foo/foo and Z: //foo/bar I need to have a batch script that makes them R: //bar/foo and Z: //bar/bar Anyone have any idea how to do this? I'm thinking of looping through somehow with net use but that's as far as I've come. Will be researching myself as well ...

How to detect when Firefox has finished loading a page using Python?

Is it possible to use Python to detect when a web page has finished loading in the Firefox browser? I'm trying to automate some browser tasks using Python and this is the major stumbling block for me. Note that this is for small-scale personal use, not a server farm or anything like that. The Firefox browser is in an open window, so I c...

is there a way to automate changing filenames in <link> , <script> tags

when we use Expires header for text files like js, css, contents are cached in the browser, to get new content we need to change in the html file the new names in the link and script tag. When we add changes. How can we automate it. In a Windows Box, I may have some bunch of html files in multiple folders also in subdirectories. There ...

automating .NET applications

Hi I'm trying to automate a hidden .NET application, with another .NET application (written in c#) using the easiest way possible. It's NOT for testing purposes, it's a way to fulfill the lack of scripting for this application. I already tried white framework, but there is one major problems with it: the way it's working. It's slow and...

MS Word OLE - How to access ActiveDocument without raising an exception?

Hi, In Word automation through OLE, when accessing the ActiveDocument property an exception will be raised if currently no visible document is available (at least in Delphi), so, my goal is to do some test like IsActiveDocumentValid, how to do that without raising an exception? Thank you! ...

C# Automation Framework for DirectX

What should I use for automating DirectX applications from C# code? I'd like to send key and mouse messages to a DirectX game, from within a C# application. I've tried the pInvoke solutions to no avail, having code like INPUT[] InputData = new INPUT[1]; InputData[0].type = (UInt32)InputType.KEYBOARD; InputData[0].ki.wScan = (ushort)0x...

How can I write a Perl script to automatically take screenshots?

I want a platform independent utility to take screenshots (not just within the browser). The utility would be able to take screenshots after fixed intervals of time and be easily configurable by the user in terms of time between successive shots, the format the shots are stored, till when (time, event) should the script run, etc Sin...

IE Automation - Calling a client JavaScript **method** from server-side C#

Given the following C# code: public object CallJavaScriptFunction(string functionName, params object[] args) { object script = Document.Script; var result = script.GetType().InvokeMember(functionName, BindingFlags.InvokeMethod, null, script, args); return result; } And the following client-side Jav...

How to automate XCode project alterations?

I have a tedious task that I need to repeat every time I build my iPhone project for sending to non-programmer colleagues: all libraries and headers that I reference outside the project's folder need to be copied into the project folder or a subfolder thereof, so I can zip up the source and pass it on. I'm aware that you can automate XC...

How to make a bot to navigate a site?

Given a product id, associates have to navigate a vendors website, log in, perform a search, in order to get details on a product for a customer. My employers want a program that can use the product id, and navigate the vendors website, and perform the search and everything to get the information thus saving the associate from having to...

Advice and tools to help normalize a database

I have 7 MySQL tables that contain partly overlapping and redundant data in approximately 17000 rows. All tables contain names and addresses of schools. Sometimes the same school is duplicated in a table with a slightly different name, and sometimes the same school appears in multiple tables, again, with small differences in its name or ...

win32: moving mouse with SetCursorPos vs. mouse_event

Is there any difference between moving the mouse in windows using the following two techniques? win32api.SetCursorPos((x,y)) vs: nx = x*65535/win32api.GetSystemMetrics(0) ny = y*65535/win32api.GetSystemMetrics(1) win32api.mouse_event(win32con.MOUSEEVENTF_ABSOLUTE|win32con.MOUSEEVENTF_MOVE,nx,ny) Does anything happen differently in ...

win32: simulate a click without simulating mouse movement?

I'm trying to simulate a mouse click on a window. I currently have success doing this as follows (I'm using Python, but it should apply to general win32): win32api.SetCursorPos((x,y)) win32api.mouse_event(win32con.MOUSEEVENTF_LEFTDOWN,0,0) win32api.mouse_event(win32con.MOUSEEVENTF_LEFTUP,0,0) This works fine. However, if the click hap...

Using MS Word to directly query a db for mail merge

Currently, I'm using Excel 2002 with a ODBC connection to query an Oracle DB by User ID # and to return a set of parameters such as Name, Address, etc. to fill a mail merge form in Word 2003. I wanted to know where I could automate this process to the point that I would open up Word, be prompted for the User ID and being able to have the...

Robot Java class XP vs. Vista Win7

The following Java code when run on Windows XP will lock the desktop, however when run on Vista or Windows 7 it doesn't lock the desktop. I'd appreciate it if someone could show me how to get this to work in Vista and Windows 7 using Java only. import java.awt.AWTException; import java.awt.Robot; import java.awt.event.KeyEvent; public ...

Approach to automatically upload updated assets to ftp

Say I need to track about 10 big files (each over 1G) over the the LAN shared folder, and if the files get modified/updated/overwritten, I need to upload those new files to ftp, and do some sort of notification like email. But I don't need to version control for older files, so it won't inflate the repository. How could be an easy app...