automation

How do you generate classes in C# from a SQL Server Schema?

I have a sql database and I want to create a class for each table. I think a tool exists that allows me to extract information from a sql database and transform it into classes like "DataTable" or "DataRow". Afterwards, I could use those object in dataset. ...

Linking MS Excel to MS Access queries

I have an Access database that I use to to run a bunch of aggregate TOP 5 queries. The end game of this particular function is ppt presentations with charts. So to automate this a bit, I created an excel spreadsheet with a bunch of pre-made charts in it. The I linked/data imported the query results into the excel spreadsheet, and set the...

How to automatically store data from Oracle in SQL Server (according to a schedule)

Hello, I'm new here, so sorry, if my question is too basic. However, maybe you have some advice, example, links, which could help me... I'm trying to find something helpfull for few days, but no results as for now. I'm working in a distributed environment. I have a Oracle server hundreds of miles away and a MS SQL server close to me. I'...

Can JScript.NET be used to script a .NET application?

Since MS appears to have killed Managed JavaScript in the latest DLR for both server-side (ASP.NET Futures) and client-side (Silverlight), has anyone successfully used non-obsolete APIs to allow scripting of their application objects with JScript.NET and/or can explain how to do so? A Mono/JScript solution might also be acceptable, if i...

reusing Internet Explorer COM Automation Object

I am using VBScript macros to utilize the InternetExplorer.Application COM automation object and I am struggling with reusing an existing instance of this object. From what I have read, I should be able to use the GetObject() method in vbscript to grab a hold of an existing instance of this object. When I execute the following code I g...

What's the Right Tool for automating refresh+scrub of a page behind a login?

A friend just asked me if I could help him in automating something that is taking up a lot of his time. He grades essays online so basically there is a website that he logs into and sits on a page refreshing it until some data appears (new essays to be graded). Instead of doing this he would like to simply be notified when there are ne...

How to give input to a windows application programmatically?

Hi Gurus, This is with reference to the below question http://stackoverflow.com/questions/924289/how-to-read-output-and-give-input-to-a-program-from-c-program I found the answer to the above question very usefull. In the same way can I do it for windows applications. Like can I give input into a windows form(like .net, C# applications...

is there an option for testing java applications from the outside like we do with the web applications?

I would like some suggestions if your project has some java application elements as well as web then is there an option for testing java applications from the outside like we do with the web applications ...

Using a Script to automate data entry to an OpenOffice Calc Spreadsheet

I would like to be able to automate creating spreadsheets and adding data to an OpenOffice spreadsheet using a script (any scripting language is acceptable - PowerShell, Python, or even JavaScript). What is a suitable library or tutorial? ...

Read/Parse/Modify MS Word document in Delphi without Word Automation

Hi, Does anyone know any good library (free or commercial) for Delphi that can read/parse/modify MS Word documents (preferably with Word 2007 support) without MS Word OLE Automation? I've found some for .Net, but none for Delphi. For example, here are two .Net/Java libraries - Aspose, Word.net I don't want to add .Net dependencies in m...

COM Interop, isolation and excluding duplicate references

We are using a COM DLL provided by Microsoft (dsofile.dll) in a C# dll written by us (Assembly A). In order to avoid having to register the COM dll, I have switched the Isolated property on the reference to dsofile.dll to true. This means that when we compile our dll, visual studio copies dsofile.dll, Interop.DSOfile.dll and Native man...

Convert MathML to MathType in MS Word

Hi, I am writing a converter from XML&MathML to MS Word document. I'm using MFC and Word automation, so there's no problem in writing text like this: _Application app; COleVariant vtOpt(DISP_E_PARAMNOTFOUND, VT_ERROR), vtTrue((short)TRUE), vtFalse((short)FALSE); app.CreateDispatch("Word.Application",NULL); Documents docs = app...

Is there a tool for automated user interface testing java mobile apps?

I'm looking for some sort of framework to automate user interface testing of a java mobile app. We're developing in netbeans ide for the most part, and I've found various articles related to unit testing, but what I'm really looking for is some way to simulate a user clicking through the various menus and dialogs. Does such a thing exis...

Programmatically add trusted sites to Internet Explorer

I'm doing an IE automation project using WatiN. When a file to be downloaded is clicked, I get the following in the Internet Explorer Information bar: To help protect your security, Internet Explorer has blocked this site from downloading files to you computer. In order to download the report, I can manually add the site to...

How to Generate an E-mail Message in Microsoft Outlook Outbox in VB6?

I need to send e-mails from my application. But, instead of sending the e-mails directly from through SMTP, I'd like to send it through Microsoft Outlook. So... How to Generate an E-mail Message in Microsoft Outlook Outbox in VB6? ...

How to crawl through a website and take screenshots of each page?

My task is to take screenshots of a set of webpages for legal purposes. I'm currently accomplishing this by using Webshot and running through its batch operation using a list of URLs I compiled myself. I also have to take screenshots of a rotating Flash banner which is done by using IECapt and its delay function. Each page has a series ...

Automating WebTrends analysis

Every week I access server logs processed by WebTrends (for about 7 profiles) and copy ad clickthrough and visitor information into Excel spreadsheets. A lot of it is just accessing certain sections and finding the right title and then copying the unique visitor information. I tried using WebTrends' built-in query tool but that is real...

Automatically generate C++ Source and Header (and update vice versa on changes) files

Is there some tool (hopefully emacs) that can update and add the correct function definitions and other things to keep the source (.cpp) and the header (.h) files synchronized. For example if I start doing this file: aaa.h Class AAA { int b; public: void func(); }; something that will automatically create and add file: aaa.c...

Sending Automated SMS Messages

First, we use .net & sql server. I have a client that is interested in a system that will send SMS messages at scheduled times. I have never done anything like this except for sending an sms through an email gateway, like [email protected]. But, I don't think that is an option for this as, our database will store the phone number an...

How Do I 'Restore' MS Word's Document Window Using Automation

I would like to be able to 'restore' MS Word's document window using Automation. I already have the application object and I have tried calling App.Activate. Activate will bring the window to the top of the Window stack but not if Word is minimized. I can set the WindowState to Maximized, Minimized and Normal but what I really need to d...