Advanced UiPath Course- 5 Real time Projects by Amit & Minal

Read a pdf form, extract account, amount, and duration, then upload the extracted data to the UiPath orchestrator queue for fixed deposit processing.

Improve bug fixing by enhancing quality control, setting a default zero sequence, and logging which meal is processed to improve traceability and readability in the process.

Configure the RE framework in UiPath for real-time transaction processing, integrating the database, orchestrator data, and inputs for account, amount, and duration to create and manage transactions.

Learn to build a UiPath sequence that checks a fixed deposit amount against an account balance, retrieving values from a transaction item, using multiple assign, and comparing with database check.

Learn to connect to a fixed deposit database in UiPath, fetch the balance with a query, compare it to an amount, and raise a business exception if insufficient.

Create a fixed deposit by building a new UiPath sequence, configuring an executable, inputting account numbers, amount, and duration, and handling escrow arguments and a business rule exception.

Define and pass arguments, declare account, amount, and duration variables, use drag-and-drop to compile the process XAML file, call the process, and display numbers in the queue.

Display the fixed deposit number in orchestrator output by passing it via a process argument and revealing it within the transaction block output.

Adapt the Robotic Enterprise Framework to read customer data from an Excel file, adjust transaction items across process blocks, and manage queue status for reliable customer creation.

Automate closing a customer creation website by driving a browser, logging into the invoice site, signing out, and managing delays to ensure secure closure.

Open the customer creation website with UiPath and automate login by entering user id and password, storing credentials, and handling login state with element checks and clicks.

Install applications, open the browser, and log in to the invoice website. Create a new book flow and reuse the same login across the initial applications.

Create a UiPath sequence to navigate to customer tab, interact with an invoice website using drag-and-drop, validate elements with 'element exists', and conditionally leave the page based on a flag.

Extract customer data from an input Excel file using a Get Transaction Data XAML workflow, reading the Excel sheet named 'customer creation' and handling transaction indexing.

Create a new customer in UiPath by building a sequence, selecting business or individual, and populating fields like first name, last name, email, phone, and website.

This lecture demonstrates building a UiPath sequence to automate entering customer details across a web form, including looping five times, using keys, data from Excel, conditional logic, and image-based selectors.

Build a UiPath sequence to fill three customer contact person profiles, capturing salutation, first name, last name, and mobile, with conditional fills and a final send action.

Create a sequence to verify customer creation, check the first name with a get attribute, and use an if statement to handle errors and send an email notification.

Practice end-to-end automation by validating transaction status, display name, and customer creation in UiPath with positive and negative test cases, delayed checks, Orchestrator credentials, and email verification.

Create an invoice processing workflow by fetching credentials from orchestrator assets, storing username and password, and using them to log into the target website.

Automate website login with UiPath by entering the username and password. Drag and drop elements to complete the login and access the Zoho invoice website.

Process invoice files by creating folders, collecting input, looping through each file to create and email invoices, and moving files to processed or error folders, with exception handling.

Create an invoice by building a new sequence and outlining the outer structure for the website, including customer handling, due date, items, and terms.

Learn how to read an invoice excel file in uipath, extract customer details, terms, and line items into variables and a data table, then prepare for invoicing on a website.

Learn to automate customer search for invoice creation by clicking search, entering a customer name, selecting the first result via Google, and handling load times with deliberate delays.

Handle invoice creation when a customer is not found by using element exists checks, a boolean found flag, and raising a business exception to close the window.

Automate invoice creation by filling the invoice date and due date through reliable element selectors, scrolling, and precise input actions within UiPath.

Shows how to automate filling invoice item details in UiPath by attaching the browser, creating a sequence, looping through data, and populating item description and quantity in the grid.

Automate creating an invoice by filling discount, notes, and terms using reliable element selectors, repeating actions (three times) and completing save and send steps in UiPath.

Design a UiPath sequence to send an email, using find element, if contains checks, delays, logging, and moving files to processed folders for reliable email delivery.

Learn to orchestrate invoice processing by calling multiple xaml files, including invoice data retrieval and create invoice steps, manage email integration, and ensure consistent naming and successful or failed outcomes.

Demonstrates building a UiPath sequence named close applications that signs out from a browser, uses image and selector-based clicks, verifies sign-out, and closes all related processes.

Fix four bugs in the project by installing the credentials package, using generic values for invoice variables, converting dates to strings, and uncommenting the email field.

Run an automated invoice processing project in UiPath, handling negative and positive test cases, sending invoices by email, and organizing results in digital files and process folders.

Create and name a new UiPath project, build a sequential main business process, and implement logging and exception handling. Fetch assets from orchestrator, configure variables, and download data.

Learn to download an Excel file via a rest API in UiPath by configuring endpoints, parameters, and Orchestrator integration to save the file to a data folder.

Read records from an Excel file with UiPath, using the Excel activity to read column values and delete specific data, then load the data into a database.

Create and populate a memory data table and associated database structure by defining a five-column schema, loading from Excel, and using a for each loop to insert records.

Use VB.NET code in an Invoke Code activity to create a new data row in a data table loaded from Excel by passing the table and arguments and updating schema.

Learn how to use UiPath database activities to delete all records from a table and then insert new data via the execute non query activity.

Explore using if-else logic and the set aside activity in UiPath to prevent redundant database updates by checking the last updated value in orchestrator before inserting records.

Fetch excel data, load rows into memory, and insert updates into the database using orchestrator connections and last updated values, completing the final rebinding of the project.

Fixing bugs in UiPath real-time projects by validating default values, tweaking the invoke download activity, correcting space-delimited Excel column names, configuring connections and tokens manually, and preparing the database workflow.

Execute the UiPath project end-to-end by clearing the database, running the vote workflow, and verifying orchestrator logs to confirm the records are inserted and the run completed.

Amit and Minal guide you through setting up a UiPath project with a main sequence, try catch, and log messages, then fetch connection strings and credentials from orchestrator.

Create a customer input form with the forms activity, design fields for name, date of birth, and passport number, and store results in an output variable.

Learn how to read data from json format, map it into a data table with a json format activity, and design a form to search customer records for suspicious activity.

Learn to search customer records in a local database with UiPath by building a search activity, configuring SQL Server connections, executing parameterized queries, and handling results and exceptions.

Learn how to set parameters for search queries and store results in UiPath by managing variables, messages, and customer records across automated flows.

Process KYC results and send emails with attachments using UiPath. Create an Excel file of missing customers and attach it to the email.

Execute real-time UiPath projects by running the workflow, validating fields such as passport number and date of birth, handling blanks with warnings, and sending email results with attached files.

Begin the advanced UiPath course by Amit and Minal, introducing five real-time projects and essential automation concepts to build practical UiPath expertise.

Set up the Google Cloud Platform for Google Vision Apps, access the console and dashboard, use the library for assets, and obtain credentials for calling the CPA in Ubud Studio.

Install the Google Vision package in UiPath Studio, configure API keys, and call Google Cloud Vision to analyze images with input and output arguments for adult, medical, and violent content.

Download and organize project images into the images folder for analysis. Search Google with keywords like medical violence and nudity, then download the results for the next step.

Open images one by one with a for loop and invocation activity, type item to string from an index variable, then delay 40 seconds, show a message box, and close.

Display the result of image analysis by configuring variables in scope, then show the results in a self-closing alert message box with a 2000 milliseconds timeout.

Automate emailing the admin with damages results using a proof-of-concept workflow, including a message box to confirm sending. Configure Outlook with subject, body, and attachments for the email.