Marcus' Macro Blog

Tips and News on Macro Recording and Automating Windows with Macro Scheduler
May 21st, 2015 by Marcus Tettmar

Allow me to tell you about a fun new technology called Chirp created by some good friends of ours.

Chirp is an exciting new technology that shares information between devices using sound and you can try it out for yourself.

Chirp

Chirp works by using little more than your device’s speaker and microphone. Data is encoded into a sound which is then “chirped” over the speaker. Another device or devices within earshot will “hear” that sound and decode it.

The beauty of this is that it removes all technical obstacles to sharing data (no need for infrared, or setting up bluetooth etc) and makes it possible for the most basic devices (think Arduino boards, toys, TVs, games etc) to chirp without any special hardware. And it means that one device can very easily share data with multiple listening devices.

You can share URLs, notes, images and video between devices – and now from your desktop web browser. College lecturers and presenters find it very useful for sharing links to websites, slides and presentations to their delegates, without having to collect email addresses or use any special infrastructure.

You can download the free Chirp app from the Apple Store or Google Play to see it in action. It’s great fun! There’s also a Chrome Plugin which makes it a breeze to share links from your web browser to your phone/tablet.

And if you want to make your own apps chirp there’s an SDK you can get your hands on too. I had some fun not long back making a Lego EV3 Robot chirp. Why not!? Anyone for a Macro Scheduler -> Chirp Interface?

And if you like what you see why not get in on the action – Team Chirp are currently crowd funding to raise money to take Chirp to the next level and are exploring commercial opportunities – so you can even make a little investment.

May 7th, 2015 by Marcus Tettmar

Did you know that since Macro Scheduler 14.2 the Macro Recorder can store snapshots of windows and objects that you click on as you are recording?

This feature makes it easier to work out which bit of code does what as you can see the screenshots inside the script:

Note the thumbnail images in the script. To view a full sized version – as in the example above – double click on a thumbnail.

This feature is on by default but can be switched off before you record a macro by toggling the “Take Window Snapshot Images” option on the macro recorder settings dialog.

May 7th, 2015 by Marcus Tettmar

“It can’t be done.”

We’re always meeting people who have been told by consultants and technical folk that moving data from one application to another can’t be done.

We prove them wrong every time.

One of the most popular uses for Macro Scheduler within corporations is automated data entry. Time and again we learn about projects where systems are replaced and renewed but gaps still exist which need to be bridged by manual “rekeying”.

In an ideal world there will be an API, database access, or an interface to export/import data files. But the reality is we still don’t live in an ideal world.

Surprisingly often, especially with older legacy systems, none of these things exist. More often than not they are technically possible, but for various reasons just don’t get implemented. It might cost too much, system vendors may not be willing to open up their technology, IT staff may be too busy on other projects.

And quite often it seems that IT departments are busy working on the “big picture” and consider these “rekeying” jobs too small to worry about.

Taken in isolation the fact that one person in one department might be rekeying patient records, or invoices once a month for three hours might seem a trivial problem. But it’s not just one person in one department. In our experience every team throughout an organisation has someone doing something like that. Added up the total time wasted by the organisation is huge. More often than not these people are being taken away from more productive work.

As an example consider a hospital we are currently helping.

Hospitals are huge organisations, with hundreds of departments and all kinds of systems where for all kinds of reasons people are keying data into one system that was extracted from another.

In a few days we’ve already helped four departments remove the need for monthly manual data entry jobs. In total this must be saving at least 2 man-days per month. In actual fact what it really means is that the clinicians who once had to do this work can now treat two or three more patients a month each.

And this is just the tip of the iceberg.

It may seem like small gains. But we have only just got started and I’m quite sure that every department has at least one person doing manual work that they don’t need to do. In this age of austerity and cost cutting it is fantastic to see the hospital making lots of small efficiency gains that together make a big improvement.

The trouble is that most people don’t realise that what they are doing can be automated.

Most of our customers are an exception, and the IT guy at the hospital thought outside the box and found a solution.

But most people are told “it isn’t possible” so carry on tapping away at the keyboard.

Most IT people, bless them, sometimes think too technically. It’s understandable. So you ask IT “can we automate this data entry procedure” or “can we connect these systems” and words and abbreviations like API, SOAP, XML, SQL will fill their heads, and they’ll come back and say “No sorry, can’t be done”. If you’re lucky someone will contact the system vendor who will naturally want payment for building a custom interface and then it will turn out that the vendor of the other system needs to be involved, or a new module needs purchasing, or someone needs to go on a training course, and all of a sudden it’s looking far too expensive and going to take far too long, to make it justified. So the conclusion is it isn’t possible.

But if you’re reading this blog you know there IS another way to do it.

We CAN automate data entry at the user interface level. And it CAN be made reliable and robust.

Is it the most ideal solution? Some would say not. But are we living in an ideal world? No.

We can demonstrate, our customers can demonstrate that it works. It allows the process to get automated quickly, without specialist technical resource, without reliance on the system vendors or even the IT department and without a large investment. For a relatively tiny outlay the invoice clerk’s life can be transformed, the human resources department can avoid rekeying appraisal data every month and clinicians can stop doing tedious tasks and get back to doing what they love, what they’re best at and serving the community.

I heard about a project in another public sector body near here the other day which has cost a fortune. New systems were brought in and inevitably there was some part of it that would have to remain manual. Consultants were brought in at great cost to look for a solution and after several months and lots of money their conclusion was that while they might be able to improve it a bit there will still be the need for some manual “rekeying”.

Macro Scheduler could have saved them – and the taxpayer – thousands. But it never occurred to them that there was another way.

So my challenge, our challenge, is to reach out to these people, reach out to ordinary people and tell them “it IS possible”. We can simplify your work, we can automate those repetitive tasks, don’t believe everything consultants might tell you – they can’t help thinking traditionally or too technically.

There IS a way.

If you use Macro Scheduler to simplify your own processes, reach out and tell people in other departments, tell your colleagues, tell your friends. There will be someone in other departments with similar problems who could also benefit.

Spread the word. We have a duty to save people time, make people more productive, make companies more profitable, and in the case of the public sector – save our tax money!

March 20th, 2015 by Marcus Tettmar

We managed to get a few glimpses of the solar eclipse today. In fact the light cloud here in Dorset probably made it safer and easier to see and photograph. Friends in London and the South East were less lucky as the cloud cover was too thick to see anything.

Here are a couple of photos I managed to take:

And a close up as the moon passes out the other side:

March 17th, 2015 by Marcus Tettmar

Regular readers and users know there’s very little you can’t do with Macro Scheduler. We see it being used for all kinds of applications and interfaces. The list is endless. Most solutions we see are unique to the customer’s specific scenario. But here’s something which almost every company could benefit from: Single Sign-on.

Single sign-on (SSO) is a property of access control of multiple related, but independent software systems. With this property a user logs in once and gains access to all systems without being prompted to log in again at each of them.

http://en.wikipedia.org/wiki/Single_sign-on

In many organisations users work with a multitude of disparate systems. A lot of time is wasted logging in and out of these systems.

At one of our clients we’re working on a Single Sign-on pilot driven by Macro Scheduler. This is an interesting and exciting use of Macro Scheduler which will benefit a large number of users across the organisation.

We also aim to have Macro Scheduler maintain the context between the different systems as logging in is only part of the problem. Usually users need to pull up records for the same customer, or order (for example) in each of those systems. If the single sign-on solution does that for them – and monitors when the context changes and mirrors that in the other systems, an awful lot of time can be saved, and chances for error are eliminated.

Macro Scheduler can handle LDAP lookup, access user information from databases, perform WEB/SOAP/COM interactions and, of course, can simulate user input for web and desktop applications which offer no alternative.

Macro Scheduler is an inexpensive and flexible solution which can work with any type of user interface, making it ideal for providing a single sign-on solution.

If you have done something similar with Macro Scheduler I’d be interested to hear from you. Comment below or drop us a line.

March 16th, 2015 by Marcus Tettmar

We have today released Macro Scheduler 14.2.03. This is a minor maintenance release addressing a few small bugs and improvements.

For full details please see the history list here.

Registered Users | New Licenses | Trial Downloads

February 12th, 2015 by Marcus Tettmar

February 6th, 2015 by Marcus Tettmar

We received this email today and I just had to share it …

Macro Scheduler image recognition just saved me 6 hours of mind numbing work and my program took me about 15 minutes to write, test, and start using. Such an AWESOME solution you provide.

Richard A. San Jose, CA USA

For more info on how to use Image Recognition see:
http://help.mjtnet.com/article/39-how-to-use-macro-schedulers-image-recognition-functions

January 23rd, 2015 by Marcus Tettmar

Electric cars and hybrids are becoming more common and it’s great to see more and more of them on the road. My next car, due next month, will be a plug-in hybrid.

I see the industry moving rapidly. Advancements in battery technology and range are happening all the time. If I didn’t have a large family I’d be happy with a small pure-EV with a range of over 200 miles. But I don’t think it will be long before larger family sized cars can do the same. In fact Tesla recently revealed a prototype 7 seater – the Model-X – which promises a range of 270 miles. Right now it’s a bit pricey, but it won’t be long before other manufacturers catch up. I can’t wait.

The same technology is now being tried in other forms of transport. Near my home town of Harwich this month the first battery powered train was tested. Much of our train network has been or is being electrified. But inevitably there are gaps which at present must be filled by diesel engines. A battery powered solution would allow trains to continue to work on electricity through the gaps and recharge when back on overhead power.

Recently I read about a battery powered electric chain ferry in Norway. It has now been sailing for over a year. Great stuff. There’s a chain ferry near us in Poole Harbour. I hope they look to similar technology.

Of course we also need to make sure the electricity used to charge these batteries is not being made by burning coal. But it’s good to see this kind of progress towards a reduction on our dependence on oil, which is sorely needed:

A third of the world’s oil, half of its gas, and 80 percent of its coal reserves must remain unused if we are to have a good chance of avoiding potentially devastating climate change.

January 16th, 2015 by Marcus Tettmar

Well, it’s a new year and with that comes new years resolutions. For MJT Net Ltd I decided we needed to do more to lessen our impact on the environment.

We’ve already made some changes:

Our web sites, mjtnet.com and clipmagic.com, are now hosted in a data center which runs directly on 100% renewable generated electricity.

Web servers run 24/7. So I think switching to green data centers is an important move.

null

For our office electricity we have recently switched to ecotricity who generate all their electricity using renewable sources – the wind, sun and sea. We’re also planning to install our own solar panels this year.

Where possible we will source second hand/reconditioned IT hardware.

We’re not a large company, so these changes may seem minuscule in the grand scheme of things. But it all helps and if everyone did this it will help much more.

      Archives

  • Categories