automation

How do I automatically compact and repair an Access 2007 database?

I have a site that uses classic ASP and a database in Access 2007 format (.accdb). It is encrypted with a password and is about 300 MiB in file size. The site works fine by itself but every now and then the database gets corrupted (the error is "unrecognized database format"). It can be fixed easily by opening the database in MS Access,...

R: Forecast package: Automatic algorithm for composite model involving ETS and AR

Hey, I would like to write a code involving automatic selection of a best composite model using ETS as well as autoregressive models. What is the criteria I should base my selection on? Also if I'm using the auto.arima function for deducing number of AR terms and corresponding coefficients from the forecast package in R, does my input ...

How to pass string indexes for OleVariant

Hi I'm converting the following example code to Delphi: http://msdn.microsoft.com/en-us/library/bb176406%28v=office.12%29.aspx My code is something like: var vTable, vRow: OleVariant; begin .... while vTable.EndOfTable = False do begin vRow := vTable.GetNextRow; sEmail := vRow['Email1Address']; ShowMessage(sEmail)...

How to make an action in an application whenever a certain text appears in it.

I have an application and I would like to debug its input/output behaviour the same way I can do in a Web environment with Selenium. Do you know any easy to use application for this matter? ...

How can I automate checking the menus for integrity in a C++ app?

In my C++ solution there are two projects : a SDI app and a MDI app. Both have quite a lot of menus, and I often make changes (add / delete / replace menus). Instead of checking for correctness myself (I'm error-prone, you know), I would love to have an automation for this. Ideally it would warn me for either not having a handler for s...

Plotting in F# using Excel

Having been able to add data to an Excel spreadsheet from F# using the answer at http://stackoverflow.com/questions/1214130/f-and-excel-integration-for-net-4-0-visual-studio-2010-beta-1 I find myself unable to figure out how to use the data inserted to create a chart (programmatically in Excel using F#). How can this be done? I am usi...

Invoke a MOUSE CLICK on a certain coordinate outside of my application

Hi all, I am using an application (a game actually) that requires me to join a "ROOM" to start a game. The application is a C++ application (I suppose) running on Windows. When a room is full, you need to wait 5 seconds to join again. I would like to automate this by writing a C# application that will invoke a MOUSE CLICK on a certain ...

Bookmarklet to open user defined link and make user defined form drop-down box selections

I've written a bookmarlet to open a user defined web link, in this specific case a specific genomic location in the UCSC genome broswer. javascript:d=%22%22+(window.getSelection?window.getSelection():document.getSelection?document.getSelection():document.selection.createRange().text);d=d.replace(/%5Cr%5Cn%7C%5Cr%7C%5Cn/g,%22%20,%22);if(...

Adding files to redmine via command line

We have an automatic build system that spits out packages, regression-tested & wrapped into a neat installer, ready for end-users to d/l & deploy. We do tracking of end user support requests/bug reports via redmine. So far we uploaded the packages manually to the resp. 'Files' section of the redmine project, via the web interface. What ...

Can I add an msbuild import element with DTE.Project?

I'm working on a VS plugin for handling a new test type. One of the things we want to do is add an MSBuild import to the project file when one of our tests is in the test project, to run our custom build tasks. I can add the import element by using Microsoft.Build.BuildEngine.Project.Imports, but if I save the project file via the Buil...

Java tools to create enterprise application documentation

This question is a bit vague but I'd like to know if there's a Java tool that can run through my code and document it in a functional way. Is JavaDoc the only way to go, or are there alternatives? ...

new gwt interface automation testing

So our front end GUI is getting a large overhaul to a new GWT based application. I have been working on creating the automation scripts for the old front end using cURL in some tcl/expect scripts. As I have looking at the new app I am starting to realize more and more that cURL is out of the question for performing these web interactions...

Windows UI Automation

Hello, I was testing the follow sample code and somehow whenever I tried running it, I will have an error shown below. However, the calc.exe process was executed successfull, so how is it possible that the handle be null or zero? I hope you understand what I am trying to put across. Thanks! The code sample is from http://www.mathpirate....

Free tool for automating GUI testing of a Windows Forms application and a Web application

Is there a way to automate GUI testing of a Windows Forms application and a web application (HTML) using free tools? For example, Ruby + Rspec + Watir work great for web UI testing. IronRuby + Rspec can work for winforms apps. Does anybody know a tool that can do both, WinForms and Web? ...

How to reduce the processing time ?

In my office we have a computer that is connected to some hardware and a program in the computer (NI TestStand) runs a test on the hardware and it takes around 10 to 12 hours to complete the test and to produce final report. Is there any way to minimize this time ? You suggestions ? Thanks in advance. ...

Watir - Logging outside of a method

I'm still fairly new in using Watir for automation testing and I've hit another possibly insanely easy problem that I need to reach out to the community for a little bump in the right direction. I'm trying to use logger in Watir, which I can get to work fine if I keep everything within methods. If I don't have a method defined, for ins...

MS Word/ ODF Automation in Qt

Hi All, How can I perform automation of MS Word documents (.doc) or ODF documents (.odt) in Qt 4.5? I know using the QAxWidget, QAxObject. I have data (QString) and few images as well. I have to add them into the document. I googled but I couldn't find any commands for MS- Word/ ODF. But I want the specific commands that should be pas...

Delphi - register a com server in the ROT

Hi guys, I've created a very small automation object (using delphi 7). It works at all, but I have problem to register it in the running object table so that I can use getActiveOleObject function to retrieve a running instance of the server. The problem is that the Initialize and Destroy events doensn't fire. EDIT: I've just noted tha...

Invalid Class String Using Excel 2010

Hi all, I have a third-party legacy software that uses Automation to control MS Excel (using MFC/C++). The code is straightforward: _ApplicationPtr xl; HRESULT hr = xl.CreateInstance("Excel.Application"); This worked perfectly since Excel 2000, 2002 (XP), 2003 and 2007; however, after installing Office 2010, the CreateInstance call ...

Delphi - Use an existing automation object in a new application

Hello, I've got an existing application which has an an automation object. I have to rewrite this application, and I would like to use the existing automation object in the new application. Is this possible somehowm, or do I have to create a new automation object in the new application and copy-paste the functions from the old one? Th...