VisualCron is an automation engine for Windows, providing the ability to run tasks based on times or events. Client/server architecture provides centralized management. Below, I review how well VisualCron interacts with cloud-based and web-based services. Specifically, I'll cover transferring files into Azure and using a web macro to automate interacting with a web page.

Travis Roberts

Travis Roberts is a Cloud Infrastructure Architect at a Minnesota based consulting firm. Travis has 20 years of IT experience in the legal, pharmaceutical and marketing industries, and has worked with IT hardware manufacturers and managed service providers. Travis has held numerous technical certifications over the span of his career from Microsoft, VMware, Citrix and Cisco.

Automating repetitive tasks is one of the hallmarks of an efficient IT team. However, automation tools native to Windows only provide basic functionality. With no central management or reporting, task sprawl can spread quickly with little or no control over where automations are running. Keeping tabs on tasks becomes a manual process of checking the status of jobs one at a time.

VisualCron can help here. I installed VisualCron, both Server and Client, on Server 2019. Installation was simple and the setup was quick. I had a couple of questions while setting up the examples below. The response I got from VisualCron was fast and helpful. Overall, setup and interacting with the program was easy.

Azure File Transfer ^

The following example shows how to configure VisualCron to copy files automatically from a directory to Azure blob storage. VisualCron requires configuring a connection before it can send files to Microsoft Azure. VisualCron uses Azure storage access keys to connect to the storage account. After setting up the storage account in Azure, go to Access keys under Settings. You need two pieces of information to set up the connection: the Storage account name and one of the two keys.

Storage account and access keys

Storage account and access keys

Next, move on to creating the storage account connection in VisualCron. Go to Connections and select Add to create a new connection.

Add a storage connection

Add a storage connection

Set the Protocol type to Microsoft Azure and give it a name in the Main settings tab.

Storage account main settings

Storage account main settings

Go to the Authentication tab next. Set the Authentication type to Password. Enter the storage account name in the Account name field and one of the two storage account keys in the Account key field. Click OK to finish setting up the connection, and close out of the Manage Connections window.

Storage account authentication

Storage account authentication

This example uses the directory C:\Source on the VisualCron server as the source for file uploads. This will upload any file placed in this directory to the storage account set up in the previous step. Create the job by selecting Add Job at the top of the application. Give the job a name in the Main settings tab and select the Put job in queue checkbox. This prevents skipping new files if VisualCron is actively uploading a file.

New upload job

New upload job

The next step is to add a trigger that will start the job. Go to the Triggers section and select Add > Event Trigger > File. This creates a file-based trigger. Go to the File tab and select the source folder in Folder path. In this example, VisualCron will monitor the C:\Source directory. Click OK to close the trigger window.

Add a file trigger

Add a file trigger

Finally, go to the Task tab and select Add > Cloud transfer > Upload file(s). Go to the Upload file(s) tab and select the connection previously set up. Search for the destination blob container that files will upload to. This example uses the upload container as shown below. Click OK twice to exit out of the setup.

Cloud upload destination

Cloud upload destination

To test it, place a file in the source directory.

Source file

Source file

The file will upload to the blob storage container selected as the destination.

Destination file

Destination file

Keep in mind this is not a synchronization operation. If you want to remove files at the destination when they are removed at the local source, that requires setting up a job that triggers when the local file is deleted with a Cloud transfer, Delete item(s) task.

Upload and delete jobs

Upload and delete jobs

Web macros ^

Web macros in VisualCron provide the ability to interact with web data by recording steps in a web interface. Web macros facilitate automating data uploads and downloads; they extract data, screenshots, and scrape web preform pages. The interface uses a familiar Chrome engine in a multi-tab interface.

The example test I ran was to automate downloading the VisualCron install file. I started by going to Add Job and giving the job a name. Then I went to the Triggers tab, added a Timed trigger, and selected Interval. I gave that a name and went to the Interval tab. I set the interval frequency and Start time, like below, and clicked OK.

Set time trigger

Set time trigger

After setting that, go to the Tasks tab and select Add > Net > Web macro. Go to the Web macro tab. This tab has several options to modify the web browser behavior. For example, you can select not loading images to speed up processing, block pop-ups, or change the language value.

Web macro settings

Web macro settings

Next, click the Record button. This will start the macro creation process by recording the interaction with the web browser. For this example, I'm going to the site www.visualcron.com. Once that loads, go to the Download page. Notice it records the steps taken on the right side of the window.

Web macro steps

Web macro steps

Click on the installer Download button to start the download. A Download window opens with options for the download. In the Folder field, browse to the download location. In this example, I selected the same C:\Source directory. Click OK in the Download window and Stop in the Web macro window. It will ask to save the steps; click Yes and then OK twice to get back to the job grid.

Download location

Download location

This task will run every day and download the file to a specific folder, all without writing a line of code. This example may not be the most compelling because I don't need to download this installer every day. There is a lot of potential, however. We could use similar steps to download backup configurations for a web-based appliance or data updated daily from a website. We can automate just about any interaction with a website with this tool.

Putting it together ^

In the web macro example, we downloaded a file to the C:\Source directory. This action will trigger a file upload to the Azure storage account due to the file transfer automation setup earlier. This illustrates how multiple automations can run together to create a seamless, end-to-end task flow.

We could also integrate these examples with a multitude of other triggers, conditions, and tasks. VisualCron provides the capability to interact with both cloud and on-premises services such as email, Amazon Web Services (AWS), Google, social media, SQL Server, Windows services, IIS, and the list goes on. There are virtually endless opportunities to automate processes in any environment.

Summary ^

There are plenty of options for process automation, including free tools and tools native to an OS. The problem with this approach is "task sprawl"—automation tasks set up on multiple hosts with no central management. These tasks get forgotten, or they fail without notifications, and managing them quickly detracts from the value they are supposed to add.

The advantage of VisualCron is its central management point along with the ability to automate on-premises and cloud tasks. Add that to a very affordable entry price, and the product becomes even more appealing. With its simple interface and multitude of interaction points, VisualCron is a good option for businesses starting out or businesses in need of advanced, cross-platform automation support.

Are you an IT pro? Apply for membership!

Your question was not answered? Ask in the forum!

1+

Users who have LIKED this post:

  • avatar
Share
0 Comments

Leave a reply

Your email address will not be published. Required fields are marked *

*

© 4sysops 2006 - 2019

CONTACT US

Please ask IT administration questions in the forums. Any other messages are welcome.

Sending

Log in with your credentials

or    

Forgot your details?

Create Account