AutoMate URC Sample Tasks & Workflows

This sample task will demonstrate the following: - Decode JSON string into structure/array - Loop structure/array and display values - Encode structure/array into JSON string (raw or formatted)

The VB round() function, by default rounds to the nearest whole number based on the following: 10.00 through 10.50 = 10 10.51 through 10.99 = 11 There are scenarios where you want to round up all decimal values to the nearest whole number. Based on the above criteria, adding 0.5 to any numeric value with a decimal will cause the round() function to round up. For example: 10.00 + .50 = 10 round(10.5) 10.10 + .50 = 11 round(10.6) 10.90 + .50 = 11 round(11.4) The attached tasks will demonstrate the round() function usage to round up numeric values.

This sample task will allow you to use Automate and Intermapper to restart a service.

The attached task demonstrates DDE Execute, DDE Poke and DDE Request. The task assumes that Excel is running with a worksheet named Sheet1. DDE Execute: Maximizes the Excel spreadsheet. DDE Poke: Will write the number 7 in row 1 column 1 of Sheet1. DDE Request: Will grab the value from row 1 column 1 of Sheet1 and populate variable varTest.

This sample demonstrates how a workflow loops through a shared dataset using the evaluation object and NO loops within the tasks.

This sample demonstrates how to pad a string inline with leading or trailing spaces.

A task has a name of 'abc_123.txt' I would like the folder name to be the prefix of the filename prior to the "_" delimiter 'C:\abc'. File 123.txt will then be placed inside C:\abc\123.txt

I have a *.txt or *.csv containing column headers and X rows of data. Using RegEx the task simply counts the number of rows based on carriage returns. Great for csv files that have X amount of records and you simply need a total count of rows minus the headers.

How do I create a CSV file from a dataset without using Interactivity actions inside MS Excel, ie, 'File Save As.'? Here's how to create a CSV file in one step using a dataset with our 'Excel - Set cells' activity.

How do I create a CSV file from a dataset without Microsoft Excel being present on my machine? Here's how to create a CSV file in one step using a dataset with our new 'ODS (OpenDocument Spreadsheet) - Set cells' activity.