Can you recommend an open source workload automation (job scheduling) tool?
I need a workload automation tool, similar to BMC Control-M or CA Autosys which is open source and preferably written in Java. What do you recommend? ...
automation
Excel Range describes a group of adjacent cells. When several groups of non-contiguous cells are selected, how do you get them all from Worksheet.Selected (range)?
My app needs to build a buffer from all the selected cells on a worksheet. I have it working correctly when the selected cells are all one contiguous group, but if the user selects a group of cells, then holds down the control key and selects other cells that are not contiguous to the first set of cells, the Worksheet's Selected range o...
Ui automation testing right click menus
I am trying to automate testing for wpf application using ui automation. I have problems simulating right mouse click and selecting different option in right click menu. Any suggestions? I also have problems with running other test written using ui automation. Because they just don't wanna start if I don't have UISpy opened and all prog...
Masking the navigation sounds in IE using AutoIT?
I wrote a program using AutoIT to fetch information from a number of websites using Internet Explorer. AutoIT is capable of hiding the window so that it is not visible, however when I navigate to a new website on that hidden window I still get the IE navigation sounds (button click sound, etc.). How can I disable the sounds from playing...
NUnit with night build, how to get errors easily?
We have a lot of unit tests but they aren't run every night. I have setup some batch files that compile all the code from the SVN repository and I would like to run NUnit. This is not a big problem because I can call it from the batch file after the compilation BUT the output is stored in the network drive and I need to open it every mor...
Is there a way to programmatically concatenate excel files?
The scenario: we have a web system that automatically generates office 2003 excel files "on the fly" (using the 2003 XML file format, not the binary format.) These files do get kept on the web server for various things. Now, we're in a situation where the client would really like us to take the xls files generated by this process and g...
How to simulate keybard input to a remote desktop session?
Found my own answer. If someone could copy/paste it into an answer so i can mark it as the answer, and answer this question, to take it off the unanswered list - i would appreciate it. i'm trying to send fake keyboard input to an application that's running in a Remote Desktop session. i'm using: Byte key = Ord("A"); keybd_event(key,...
Visual studio - is there a way to select multiple files and wrap a namespace around each of them?
Is there a way to select all classes within a folder and assign a namespace to each of them in visual studio? If there is no tool to do it, is there a regex pattern that will match everything before the class declatarion, but after the imports? ...
Best way to test command line tools?
I have a large collection of command line utilities that are we write ourselves and use frequently. At the moment testing them is very cumbersome and consequently we don't do as much testing as we aught to. I am wondering if anyone can suggest good techniques or tools for doing a good job of this kind of thing. Edit: to clarify this is...
VS 2008 Open Word Document - Memory Error
I am executing the following code that worked fine in a vs2003(1.1) but seems to have decided otherwise now that I'm using vs2008(2.0/3.5): Dim wordApp As Microsoft.Office.Interop.Word.Application Dim wordDoc As Microsoft.Office.Interop.Word.Document missing = System.Reflection.Missing.Value wordApp = New Microsoft.Office.Interop.Word....
Printing HUGE PDF batches in order
Sorry if this is a little off-topic for regular stackoverflow questions, but we're tearing our hair out on this one. We've got a batch of about 3500 3-page PDFs to print (all ok so far) the problem we've got is that it's vital they print in a specific order (ascending by filename). Our spooler seems to randomize the printrun. Any ideas...
CVS Automation: How do I detect a local file has been deleted so as to trigger a cvs remove?
I'm looking to automate the backup of a Windows XP file structure (a wiki) into CVS. Through repeated calls to cvs commit and cvs add I can identify and commit changed files and newly added files, but I can't see a cvs command that would let me know a local file has been deleted. One possibility would be to update a parallel file stru...
Adding an SSL certificate to IE without user interaction.
A while ago, I set up my company's local (non-internet) client database on my domain server, using Apache and PHP/MySQL. I recently decided to set it up to use an SSL connection rather than a standard HTTP connection. (I know, I should have from the beginning, but that's another matter). I've set up my server and my certificate success...
automated testing with Watir (or WatiN or similar): Disambiguating Select Elements
Problem: I am looking for a way to run a test that is able to disambiguate between select controls that have the same value in more than one place. Example: I am trying to choose the third "monday" from a select control ie.select_list( :id , 'choose-day' ).set( '-monday' ); where the select control has a kind of "outline" format in...
.NET Interop: Find All instances of of a running COM object with C#
Background I am automating some Office application (Word and PowerPoint) via command-line tool. One thing my tool needs to do is locate all the running instances of Word. I know how to get a reference to one of the instances... Object running_obj = null; { running_obj = System.Runtime.InteropServices.Marshal.GetActiveObject(progi...
Does DDE still matter? Which are the alternatives?
I'm working on a stock exchange information platform and we are thinking in provide a link between our platform and home-made Excel files. The financial market is still bound to the old DDE server approach, now does it still matter today? Which are the alternatives to make automatic online data updates on Excel files, OLE DB queries? I ...
Workflow automation: Makefile vs. Ant
Whenever I notice that something in my workflow is a repeating task, I try to automate it. For example the steps necessary to deploy something on a server. It's often a build, followed by a scp and finally some remote setup scripts: mvn package scp target/foobar.jar server: ssh server install-foobar ssh server './bin/foobar restart' ...
creating unit tests (semi-)automatically?
Is there a framework that supports generating some standard unit tests from annotations? An example of what I have in mind would be: @HasPublicDefaultConstructor public class Foo { } This would obviously be used to automatically generate a unit test that checks whether Foo has a default constructor. Am I the only person who thought o...
How to make the Java.awt.Robot type unicode characters? (Is it possible?)
We have a user provided string that may contain unicode characters, and we want the robot to type that string. How do you convert a string into keyCodes that the robot will use? How do you do it so it is also java version independant (1.3 -> 1.6)? What we have working for "ascii" chars is //char c = nextChar(); //char c = 'a'; // this...
How do I recognize a drag-select with autoit
I'm writing an automation script with autoit: http://www.autoitscript.com/autoit3/index.shtml. In the process I need to take a screenshot of a user selected area. How can I recognize the mouse-drag select operation with Autoit 3? I basically need some way to get the coordinates of the selected rectangle... ...