Subscribe to Blog Posts by: Jonathan Chan via RSS
Subscribe to Blog Posts by: Jonathan Chan via RSS
Blog Posts by: Jonathan Chan

Using AutoMate to Facilitate SQL Bulk Inserts

4/15/13 • by Jonathan Chan, in Tech Talk 5 comments
Image for blog post

Here's how you can use AutoMate to easily and rapidly load information from a Comma Separated Value (CSV) file into a SQL Server Database.

Read More

FAQ: Moving Old Files in AutoMate

3/18/13 • by Jonathan Chan, in Ask an ASE 2 comments
Image for blog post

One question we often get asked is how to move or copy files based off a certain time criteria, say copying files that are older than 24 hours into an archive folder. With AutoMate, this is done by using the File System Action.

Read More

AutoMate Sessions for Excel and FTP

2/6/13 • by Jonathan Chan, in Automation Strategy 0 comments
Image for blog post

The AutoMate Task Builder interface is built around the idea of sessions. Derived from computer science, a session is a semi-permanent, interactive exchange of information between two or more entities. In this post, you will learn the basics of sessions and how they apply to the AutoMate environment.

Read More

How To AutoMate VMware

10/29/12 • by Jonathan Chan, in Ask an ASE 0 comments
Image for blog post

In this short video, learn multiple ways to automate VMware, such as, powering off all virtual machines, and transferring a file from a local machine to a virtual machine.

Read More

How To AutoMate Amazon Web Services (AWS)

9/25/12 • by Jonathan Chan, in Ask an ASE 0 comments
Image for blog post

For the Mars Exploration Rover Mission, NASA went with an AWS implementation instead of building another data center. In this example and short video, learn how earthlings are able to AutoMate AWS for their IT and business needs when their projects are a little closer to home.

Read More

How To AutoMate PowerShell Scripts

7/31/12 • by Jonathan Chan, in Ask an ASE 0 comments
Image for blog post

Watch this short How-To video covering AutoMate's PowerShell functionalities, and its ability to embed and run PowerShell scripts.

Read More

How To Automate Web Services

6/28/12 • by Jonathan Chan, in Ask an ASE 1 comment
Image for blog post

Watch this short video for a better understanding of how to automate Web Services.

Read More

Walkthrough: Email Integration and Automation in Customer Relationship Management

5/31/12 • by Jonathan Chan, in Ask an ASE 0 comments
Image for blog post

In last months post we examined the usage of AutoMate to streamline customer interaction—specifically using Microsoft Dynamics CRM and Exchange. Today we are going to take a look at how to actually implement the task.

Read More

Email Integration and Automation in Customer Relationship Management

4/18/12 • by Jonathan Chan, in Ask an ASE 1 comment
Image for blog post

Dynamics CRM delivers an enterprise level of contact record keeping and activity logging that produces excellent sales productivity results. But depending on the amount of email inquiries a company gets per day, they might need to look at outside automation tools to speed up those otherwise manual processes.

Read More

AutoMate™ Web Scraping — A Solution for Murphy's Law of Data Extraction

3/26/12 • by Jonathan Chan, in Data Extraction 2 comments
Image for blog post

In this step-by-step walkthrough of the Web Interactivity Task, learn how to pull all of the information from an HTML table (for this example we will be using Yahoo! Finance), and then write the data into Excel for the evaluation of particular fields.

Read More

Automating Stored Procedures

1/5/12 • by Jonathan Chan, in Ask an ASE 0 comments
Image for blog post

In a database management system (DBMS), a stored procedure is a set of Structured Query Language (SQL) statements with an assigned name. It is stored in the database in complied form so that it can be easily shared by a number of programs. There are numerous advantages to using Stored Procedures...

Read More

Search the URC

Subscribe to Version History via RSS
Subscribe to Version History via RSS
Version Watcher

11.0.1 changelog
11.0.1 changelog
other versions downloads

Contribute

Subscribe to Latest Resources via RSS
Subscribe to Latest Resources via RSS
Latest Resources

show filter options

Subscribe to Forum Posts via RSS
Subscribe to Forum Posts via RSS
Forum Posts