Archive: November 2009

How to Sort a CSV File

November 5, 2009 by Marcus Tettmar in Automation, Scripting

This morning, forum user hip asked how a script could sort a CSV file. Seems CSV files, sorting and Excel has become a bit of a hot topic here lately. Since Excel can read and save to CSV and also has a Sort function we might as well make use of it. Here’s a little […]

Read more »

Macro Scheduler 11.1.16 Update

November 2, 2009 by Marcus Tettmar in Announcements

Macro Scheduler 11.1.16 is now available with the following fixes: Fixed: Escape characters were not stripped from Telnet response Fixed: Crash caused by 3rd consecutive showing of reminder screen in trial version Registered Downloads/Upgrades | Evaluation Downloads | New License Sales

Read more »

Convert XML to CSV

October 30, 2009 by Marcus Tettmar in Automation, Scripting

Earlier this month I wrote about how you can read and write data from/to CSV files as if they were database tables using DBQuery. Andrew asked if I knew of a way that XML files could be treated as database tables in the same way. I did find a couple of references to some ODBC […]

Read more »

Quick Sort Routine

October 29, 2009 by Marcus Tettmar in Uncategorized

Back in 2006 I posted an example of a Bubble Sort or Insert Sort algorithm. In this more recent forum post, azzkicker_9002 asks for help creating a Quicksort function which is faster for longer lists. So I took the example found here on the alogorithmist website and converted it to MacroScript. I tried to post […]

Read more »

Randomly Shuffle an Array

October 28, 2009 by Marcus Tettmar in Scripting

I was recently asked how to get a list of files from a folder, and then randomly shuffle that list. The following code retrieves the list of files to an array using GetFileList and Separate and then loops through the array shuffling it randomly: GetFileList>c:\docs\*.*,file_list Separate>file_list,;,files_array If>files_array_count>0 //randomize the array Let>k=0 Repeat>k Let>k=k+1 Random>{%files_array_count%-1},random_index Let>random_index=random_index+1 […]

Read more »

I am not Clairvoyant and I don’t have a Crystal Ball

October 27, 2009 by Marcus Tettmar in General

Honestly, I keep trying to buy a Crystal Ball and I’ve asked all our preferred suppliers, but no one seems to have one. Printers, mice, monitors, disk drives, and SATA II RAID controllers are no problem. But no one sells a Crystal Ball. One would make my life easier. I could then answer those support […]

Read more »

Windows 7 is Here, So Long XP!

October 22, 2009 by Marcus Tettmar in General, Windows 7

So, unless you’ve been sleeping under a rock you’ll probably be aware that today is the day that Windows Vista gets it’s official upgrade in the form of Windows 7. We got our hands on a beta copy as soon as it became available to MSDN subscribers and back in January I was able to […]

Read more »

Introducing Macro Scheduler Lite – With 10% Discount

October 9, 2009 by Marcus Tettmar in Announcements, Macro Recorder

Today we have released a new entry-level edition of Macro Scheduler called Macro Scheduler Lite. Over the last 12 years, Macro Scheduler has gone from strength to strength and grown in power and flexibility to become the fullest featured, most capable automation solution on the market today. But we want to bring Macro Scheduler to […]

Read more »

T-Shirt Winners for September

October 8, 2009 by Marcus Tettmar in Announcements

After a short hiatus where we had no new names emerging in the winners list I’m pleased to say that the following two forum users will be receiving a flashy new MJT Net logo T-shirt each for points rewarded in September: gpulawski: 20 points received Waldo: 5 points received Thanks to both of you for […]

Read more »

Macro Scheduler 11.1.15 Update

October 6, 2009 by Marcus Tettmar in Announcements

Macro Scheduler 11.1.15 is now available with the following changes: Fixed: Compiled macros with -NOSTOPKEY option running slower Fixed: CompareBitmaps not correctly comparing full image Fixed: Text added by Command Locator cannot be undone Fixed: New line not added when text added by command locator Registered Downloads/Upgrades | Evaluation Downloads | New License Sales

Read more »