
Orchestration centralizes bot management in a single place, improving scalability, monitoring, and reliability of automations. Bot City Maestro provides the platform to address these challenges and streamline RPA implementations.
Install and run MySQL using Aragon's portable edition, unzip the folder, launch the executable, and start MySQL to create and manage databases.
Bot developed on the module available for download on the lesson resources!
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 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.
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.
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.
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.
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.
Welcome to "RPA with Python and BotCity - Build and Manage Automations" course, your gateway to mastering Robotic Process Automation (RPA) using Python and BotCity. Whether you're a beginner or looking to upgrade your automation skills, this course it's made for you.
We'll start by understanding what is BotCity and its main features. Next, we'll setup our environment to have every it's needed to follow the course and be able to develop and run Python scripts and BotCity. Then, we will learn how to use the BotCity framework for automation development and create our very first bot. After create our first bot, we will learn how to develop bots across different scenarios like desktop automation, web automation, develop advanced web crawler, interact with Excel, API's and database. Later, we will focus on BotCity Maestro and learn how we manage automations/bots from there, start tasks, schedule automation execution, use datapools for efficient batch processing, use execution logs for monitoring or create automation metrics, raise alerts, manage credentials securely and much more!
The topics covered will be as follows:
Introduction to BotCity: Dive into the essentials of BotCity, understanding its core features and capabilities.
Setting Up Your Environment: We'll guide you through setting up the ideal environment to seamlessly follow along with the course.
BotCity Development Framework: Gain in-depth knowledge of the BotCity framework and how it integrates with Python for RPA.
XPath and CSS Selectors: Learn to efficiently locate elements using XPath and CSS selectors - a vital skill for UI automation.
Web Automation Mastery: Master the techniques of automating web-based tasks and processes.
Desktop Automation: Learn how to automate desktop applications with precision and ease.
Advanced Data Scraping: Develop skills to create sophisticated web crawlers for data scraping.
Excel, API, and Database Automation: Explore automation in various domains including Excel, APIs, and databases.
BotCity Maestro: Master BotCity Maestro for effective automation management.
Debugging and Datapools: Learn advanced debugging techniques and how to use datapools for efficient batch processing.
Scheduling Automations: Acquire the ability to program and schedule automatic task executions.
Use BotCity Plugins: Boost development productivity with BotCity plugins
Hands-on Practice: Engage in practical exercises throughout the course to solidify your learning.
..and much more!
By the end of this course, you'll not only be able to develop and manage RPA solutions using Python and BotCity.