automation

Excel automation. Need to select multiple items from a Range

I have code that lets me select a single item in arange: COleVariant vItems = cstrAddr; hr = AutoWrap( DISPATCH_PROPERTYGET, &vCell, irange, L"Item", 2, COleVariant((short)(1)), COleVariant((short)(1))); if (FAILED(hr)) return hr; // Use the dispatch interface to select ...

JIRA SOAP API documenation?

I'm building some custom tools to work against a JIRA install, and the exposed SOAP API is great, except that none of the arguments are named. For example, the prototype for getIssue is: RemoteIssue getIssue (string in0, string in1); All of the SOAP RPC methods follow this convention, so without documentation I'm pretty hardpressed t...

Enumerating Windows/Controls of another application from .Net

I'm developing a small utility application that needs to detect whether another one has one of its MDI child windows open (it's an off-the-shelf Win32 business application over which I have neither source code nor control). From my app, I would like to be able to poll or detect when a particular MDI Child window is open. In .Net, it's ...

Accelerator key for a date stamp

Hello all, Here's an open ended question. I work on a lot of mssql files, and I like to have a date stamp on each. This is so I can know just by looking at the source of a stored procedure whether it's up to date or not. I'd like to have a shortcut autocomplete key, that, if i type say, d-tab-tab, I get the current date printed to the ...

Passing a paramter/object to a ruby unit/test before running it using TestRunner

I'm building a tool that automates a process then runs some tests on it's own results then goes to do some other stuff. In trying to clean up my code I have created a separate file that just has the test cases class. Now before I can run these tests, I have to pass the class a couple of parameters/objects before they can be run. Now the...

How to create automatic a list of items used in a LaTeX-document?

I want to add items in a LaTeX-document. Say for example, that I want add hints to the document. I create a command, so I can call something similar to this: \hint{foocareful}{Be careful with foo!}{foo is a very precious item and can easily be broken. Be careful, especially don't throw foo.} This will be formatted in special way, to m...

How to automate the tasks for releasing open-source-software?

Everyone managing open-source-software runs into the problem, that with the time the process of releasing a new version gets more and more work. You have to tag the release in your version-control, create the distributions (that should be easy with automated builds), upload them to your website and/or open-source-hoster. You have to anno...

Word Automation in C#- Creating Tables in Word

Hi all, I have a C# application which will open a word document and then replace some of the predefined bookmarks with the data which i have like Name,Class etc.. It is all are just string values .Now I want to render a Table with dynamic number of rows to the word document.I want the table in a particular place in the document. Can...

Excel 2007 VBA and WMI - Current DOMAIN\USER

...

How do I set up a build server on the cheap/free?

Currently I'm tasked with doing the daily build. We have an ASP.NET 2005 website with a SQL Server 2005 backend. Our current source control is Visual Source Safe 2005. At this point, I use the brute-force method of daily builds. Get Latest version of source code Get Latest version of Database release script Backup old website files ...

Natural language automation?

I remember reading about an automation program for windows that would accept a list of commands like this: press the ok button put "hello world" into the text control press the add button etc etc. Can anyone name this program? A thousand thankyous. ...

Mail merge in C# with n copies

I just want to create a C# program which will read a word template and create n number of copies of it with mail merge feature.The data to replace is Name and Address the rest of the things in the template should remains the same. Can any one tell me how to do this ? ...

JMeter - successfull HTTPS recording?

Greetings, I'm utilizing Jmeter 2.3, which now supports "attempt HTTPS spoofing" under the Proxy Server element. I've tried on several different servers, and have had no success. Has anyone been able to successfully record from an HTTPS source with this setting? Or barring successfully recording, can anyone share a work-around? When...

How do you open an InfoPath 2007 file programmatically from a service?

I am trying to open an InfoPath 2007 file programmatically from a Windows service, but I get the following error: System.Runtime.InteropServices.COMException (0x80043000): InfoPath cannot open the following file: C:\path\datafile.xml. Not enough storage is available to complete this operation. This file opens correctly in ...

hibernate auto-discovery and generation of of database mappings to POJOs

Are there any tools that auto-generate the hibernate POJOs by gathering information from the database? I made a perl script to do this after the schema got changed for the third or fourth time in a project i'm working with and just wondered if there is any established tool that will do this for me as my script is rather crude and needs ...

What is a workflow system?

How can I differentiate a Workflow system from a normal application that automates some work? Are there any specific feature a system must have to be categorized as a workflow system? ...

Timed Tasks (cron-like) in PHP

Is there a full featured, job scheduling package available for PHP? I'm looking for the PHP equivalent to Java's Quartz. I'm fine having things triggered externally from cron to drive the system. The functionality I'd be looking for: Ability to register task (class/method) to be called at given intervals. Ability to specify whether a g...

How to fill DataTable from an in-memory Excel Worksheet

Our client gets Excel files in Excel's HTML format.(That's the way it arrives; nobody has any control over that.) We then need to run a report based on the data in the file. Using ADO.NET (OleDbReader) results in a "External file not in expected format" exception. If the data is converted to regular Excel format it gets read in OK. Howe...

Rules for using update sites in Eclipse?

Do you know any documentation about the rules of using update sites? I have managed the last 2 and a half years the update site of our company, and these are the problems I have to address: Not all projects use the same eclipse version. We had projects that used eclipse 2.1 (WSAD), eclipse 3.0 (RAD 6), eclipse 3.2 (RAD 7), eclipse 3.3 ...

writing to a program into input stream

I am using oracle wallet to store the oracle database passwords, the batch file to create the wallet asks for password when you run it. is there any way to modify the batch file , and provide the password before hand so that i can avoid inputtting the password every time i run that. so to generalize the problem, is there any way i can...