RPA with Python and BotCity - Build and Manage Automations

Install Python from python.org by downloading the latest version (3.7+) and adding it to path, then verify the installation with the py command in the terminal.

Download chrome driver for chrome web automation by verifying your chrome version, selecting the correct driver, downloading for Windows 64-bit, extracting, and saving its path for later development.

Download and install Accessibility Insights for Windows, verify the installation, and use it to inspect desktop element attributes for desktop automation.

Install Visual Studio Code as the code editor and add the Python extension; follow the installer steps, then prepare to install MySQL for database automation.

Install and run MySQL using Aragon's portable edition, unzip the folder, launch the executable, and start MySQL to create and manage databases.

Discover desktop automation by learning to start an application, fill input fields, click buttons, and select an option from a dropdown using a simple app.

Learn to navigate application tabs in a BotCity automation by identifying unique attributes like title and name, then select tabs such as company and other to verify navigation.

Learn how to click buttons in a BotCity automation, using accessible insights to locate elements by automation id, assign save_btn and browse_btn, and perform click actions across tabs.

Develop a bot to perform web data entry by reading data from an Excel file, opening a browser form, filling each row’s fields, and submitting the form.

Create a Bot City web automation project, install pandas, and read data from an Excel file with read_excel to form a data frame for browser automation.

Define Chrome as the browser, initialize the WebDriver, and open the web form URL from the lesson resources to begin automating the form by reading Excel data.

Learn to find browser elements with XPath by inspecting the web form, using the type attribute and text to uniquely target inputs, clear form, and the submit button.

learn to automate submitting a web form by locating the submit button with XPath, clicking to submit, and iterating through rows from an Excel file with BotCity.

Learn to set up a Bot City http workflow, install the http plugin, and perform get and post requests to simulate API interactions, including login and registration with token handling.

Parse Json data from Http responses in Python using the BotCity plugin, converting the text response with get as Json and accessing keys like token and id.

Learn web data scraping with the BotCity plugin by building a bot that extracts each book's title and price from a multi-page fictional bookstore and exports the data to Excel.

Extract book titles and prices from paginated pages using a loop over page numbers. Implement a while loop with a page counter and f-strings, prepping data for export to Excel.

Learn to export scraped book data to Excel by building a pandas data frame with title and price, iterating over items, and saving the results to an Excel file.

Create a cursor from the connection, run SQL queries like select all from users, fetch results, filter with a where clause for the RPA developer, and prepare inserts and updates.

Insert a new record into the users table with name, age, and job, then commit; update existing records with set and where, then commit, preparing you for Bot City Maestro.

Deploy automation to Bot City Bistro using Easy Deploy, name the automation, select Python bot 1.0 in the default repository, upload as zip, choose a machine, and confirm deployment.

Demonstrates starting the Bot City runner, linking to Bot City Maestro, and launching a new task with priority and parameters, then monitoring the render status and task execution.

Create and manage schedules to automate BotCity tasks with cron expressions, including selecting an automation, defining the cron string, and enabling or disabling the schedule.