CORE of Automation Anywhere 2019 (BE INSTANTLY PRODUCTIVE)

Robotic process automation defines a self-directed sequence of events with minimal human intervention, illustrated by banknote counting and coffee vending machines, delivering time savings, reduced costs, and improved accuracy.

Compare Automation Anywhere 2019 cloud-based architecture with Blue Prism and other tools to automate desktop, back-office, and email-driven processes in business workflows.

Register to receive your Automation Anywhere community edition credentials, then install the agent and connect your local device to the cloud to complete the A2019 installation.

Learn to create and manage Automation Anywhere variables, including user input, output, constants, credential, list, external object, and table variables, plus date and time with time zone and form inputs.

Discover session management in Automation Anywhere, where each action ties to a session name for reading and closing files. Use the same session name consistently to avoid errors and confusion.

Understand the folder structure for lead automation and implement a final consolidated folder with a naming convention that records the marketing company, customer name, mobile number, and a five-point rating.

Learn variable creation in automation anywhere, using dictionary variables and built-in keys to read multiple files from a folder and extract file names and extensions.

Learn to read data from multiple CSP files, store it in a table variable, and append it to a consolidated file using local file selection and parameter setup.

Dynamically determine the marketing company name from incoming inquiries and populate a custom column by applying string checks, conditional branches, and file-iteration logic.

Create an intermediate consolidated excel file from CSV by opening an Excel session, checking file existence, and writing data from a data table into a sheet, then closing the file.

Learn to modify an Excel sheet by inserting and deleting rows and columns, specify positions, and set cell values for fields like name and phone number to update the workbook.

Migrate the consolidated Excel data to the school server database by reading each row and inserting into the database via an insert statement inside a loop.

Execute a stored procedure to calculate and update the final rating by averaging rating one, two, and three, and apply the results to the table.

Explore calling a stored procedure with input and output parameters in Automation Anywhere, fetch lead records for a marketing company with rating three or higher, and export results via email.

Automate sending emails to the sales team with attachments based on business rules, configuring recipients, subject, and message, and ensuring secure connections and authentication.

Learn to upload a consolidated file to a centralized server using the FPP package, including setting destination folders, file type filters, and verifying the successful upload.

Learn to call a sub bot from a parent bot and exchange values by defining input and output variables, passing data from parent to child, and returning results.

Enable front office capability for lead automation by introducing flexible, interactive runs with prompts for landing folder selection, yes/no file upload prompts, and conditionals to control steps.

Group actions with the step feature to create logical, reusable blocks for lead automation, and organize front office and back office tasks with structured steps.

Learn troubleshooting techniques for first-time connection to SQL Server, configure SQL Server to listen on IP via SQL Server Configuration Manager, enable TCP/IP, start SQL Server Browser and related services.

Troubleshoot signing into Gmail with Automation Anywhere, addressing credential errors and the sign-in block. Review account activity and enable Google's security check to allow external app access.

Enable two-step verification for your Google account, verify with text messages, and generate an app password to sign in to non-Google applications.

Master the credential and locker facility in Automation Anywhere 2019 to securely store usernames and passwords for FTB server, email, and databases, with owner, manager, and participant permissions.

Learn how to manage credentials within a locker using user defined attributes, including adding credentials and handling credential requests, email notifications, and user-supplied values for secure passwords.

Explore the mail automation package, using actions to send, reply, delete, and move emails, while reading a single message and storing subject and sender as variables.

Discover how to connect to email servers (Outlook, IMAP or POP3) using Automation Anywhere, configure credentials, securely send, read, filter, and reply to emails within loops, including attachments.

Explore the fpp protocol for transferring files between machines, covering ftb server types, anonymous versus username login, binary and ascii transfer, and line ending handling.

Demonstrate configuring the FPP package in Automation Anywhere 2019, including anonymous and secure login, transfer types, and file uploads via a demo site.

Explore creating a folder on a server, uploading and renaming files, then downloading to a local machine. Demonstrate selecting folders and using modified-date filters to verify transfers.

Understand web service concepts through practical examples, distinguish restful and soap-based web services, and learn how data formats and security impact financial transactions.

Demonstrates how to configure and call RESTful web services in Automation Anywhere, including authentication, headers, and parsing responses to fetch holidays and currency data.

this lecture demonstrates a rest web service workflow, sending a request, receiving a json response, handling content types, and storing the output to illustrate end-to-end web service integration.

Explore a soap web service demonstration that contrasts restful web services and shows how a service performs add, subtract, multiply, and divide with request and response parameters.

Connect to a soap web service, configure authentication and certificates, and pass parameters to perform a calculator operation, then view complete or partial responses from the service.

Demonstrates how a soap web service passes its output to another service, enabling automation such as onboarding employees by creating database entries and updating active directory.