Archive: February 2010

And The Winner Is …

February 17, 2010 by Marcus Tettmar in Uncategorized

Thanks to everyone who entered our T-Shirt design competition. I’ve really enjoyed seeing all the entries and it has been very difficult to pick a winner. All entries are excellent in their own right and there are some great slogans, creative designs and novel concepts. I have a number of favourite designs and, personally, I […]

Read more »

Seeking Industry Partners

February 16, 2010 by Marcus Tettmar in General

Are you a contractor, consultant, freelancer or value added reseller who knows and uses Macro Scheduler and works in a specific industry, like Health Care, Education or Manufacturing? If you are I’d like to hear from you. I’m looking at opportunities for Macro Scheduler in vertical markets and would like to find people with industry […]

Read more »

FTP Uploader – Upload Files From Explorer

February 5, 2010 by Marcus Tettmar in Announcements, General

Phil Pendlebury has written a really handy little tool for quickly uploading files from Windows Explorer, and he’s built it using Macro Scheduler. With his FTP Uploader tool installed you can right click on any file and select Send To->FTP Uploader to quickly upload it to any FTP site. It will remember the FTP server […]

Read more »

Force DBQuery to Read CSV Columns as Text

January 28, 2010 by Marcus Tettmar in Scripting

In More on Reading and Writing CSV Files and various other posts I have demonstrated how CSV data can be read via a SQL SELECT statement using DBQuery. In order to do this we used an ADO connection string in the DBConnect line: Let>ConStr=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\My Documents;Extended Properties=’text;HDR=NO;FMT=Delimited’ DBConnect>ConStr,dbH “Proper” CSV files use the double quote […]

Read more »

Why Does My Script “Hang” and Never Continue?

January 27, 2010 by Marcus Tettmar in Automation

This is a variation of a question we get regularly. Usually it turns out that the script is waiting on a WaitWindowOpen line because of a typo in the window title. WaitWindowOpen, given a window title, will cause the script to wait until a window with that title exists. If you misspell the window title […]

Read more »

Get Auto-Generated ID Created By INSERT SQL

January 26, 2010 by Marcus Tettmar in Scripting

If you have a database table with an auto-generated numerical index field, you may need to retrieve the value of this field after an INSERT statement. In Microsoft Access such a field uses an “AutoNumber” data type. In MySQL it’s known as an “auto_increment” field. We often see these types of fields where a relationship […]

Read more »

WebRecorder 2.2 Update

January 15, 2010 by Marcus Tettmar in Announcements

WebRecorder has been updated to version 2.2 with the following changes: – If a form element has no NAME attribute WebRecorder will use the ID element if it has one. WebRecorder and IEAuto.DLL have been updated accordingly. This allows more forms to be recorded and played back. Registered Downloads/Upgrades | Evaluation Downloads | New License […]

Read more »