A360 Real Time Project | Active Loans Bot for DNA Website using Automation Anywhere A360
Вставка
- Опубліковано 13 жов 2024
- In this step-by-step video, we'll guide you through the process of building an Active Loans Bot for DNA website using Automation Anywhere A360. The Active Loans Bot automates the process of tracking loan statuses and sending alerts to customers with active loans. We'll start by designing the workflow and creating the necessary tasks, and then move on to testing and deployment. You'll learn how to use Automation Anywhere A360 to extract data, manipulate Excel spreadsheets, and send email alerts, all while building a real-time automation project. This video is perfect for anyone looking to learn how to build bots using Automation Anywhere A360, and for those interested in automating loan tracking and alerts for their business.
Strong practical knowledge will help all the learners to clear interviews. I am creating this Automation Anywhere series having intention to build strong practical knowledge for Interview. I hope this series is going to help the community!
Please Contact for any help :
Telegram : t.me/+04iV7x2p...
Gmail : ai.brahmabusiness@gmail.com
WhatsApp : wa.me/message/...
LinkedIn : / ai-brahmaai
I have completed this project and this is good use case. Thanks for sharing this tutorial to me. And If possible please upload more videos of different case studies for us. We would like to watch it and like it.
Thanks Ganesh for your wonderful effort.
Those who are done this script, if your excel output is filled with empty rows in between.
Here is the reason - We have assigned and increment(counter+1) counter values in inner loop (that means Botsdna website table).
Instead, in the outer loop (That means 'Each row in worksheet') before the loop started - assign Counter variable with 1 (because excel having header) and after loop started assign "conter+1 = Counter" to write the data from 2nd row in excel.
It works as expected.
Reason for empty rows after 5th line and so on:
Because if you compare first 5 account numbers in excel sheet with website table it will match (till the Union bank of India - 7541). but the 6th row it is not matching (Indian bank -5174). Hence the counter keeps increment until it finds excel match with next website match that means (ICICI - 1514) So generating empty rows that many times in between.
Thanks
I have completed this project and this is good use case. Thanks for sharing this tutorial to me. And If possible can you please share Automation Anywhere architecture also with some example or use case.
It is very useful in Real time projects, I completed this usecase by seeing this video. Here i think Number Increment will come under first loop.
Hey have you tried this? I have also tried it is working well till 6th row and then it is leaving some of the rows
good job
hey thanks for the content man i like your way of explaining
i have a video request for you
how to setup automation anywhere ??
what do i need to install ? like for engineering projects we install sdks,dependencies , etc what do i need to install to create and run a bot
Wow😍
Nice bro
Why don’t you use log file to get the status of the bot and kind of stuff
Because in every real time project in company they used to add log file
So can you please make a video regarding that..
Hopefully you can add that log file action in the upcoming videos also..
Thank you
And by the way the way of teaching is super bro..
Hats off to your teaching..
Yes . Not having time to cover in video. Only logic i can explain
We must use
1. Log CSV/text
2. Config (business config and system configuration)(XML/xlsx/json)
3. Database log
4. Correlation id
5. Email notification
6. Error handling
7. Clear application.
8. Maintain Folder structure
give correct code data is inserting after some blank rows from 5th row
Use of data-table and set value in Excel
Is takeout from this video👍
Sir i have tried but it is working well for some rows and then it is leaving the other rows and moving forward
Step logic
Take the couter variable after the if condition
Those who are done this script, if your excel output is filled with empty rows in between.
Here is the reason - We have assigned and increment(counter+1) counter values in inner loop (that means Botsdna website table).
Instead, in the outer loop (That means 'Each row in worksheet') before the loop started - assign Counter variable with 1 (because excel having header) and after loop started assign "conter+1 = Counter" to write the data from 2nd row in excel.
It works as expected.
Reason for empty rows after 5th line and so on:
Because if you compare first 5 account numbers in excel sheet with website table it will match (till the Union bank of India - 7541). but the 6th row it is not matching (Indian bank -5174). Hence the counter keeps increment until it finds excel match with next website match that means (ICICI - 1514) So generating empty rows that many times in between.
Thanks
why its started from 9th row after the 5th row execution ? Anybody help me to this
for me also same issue
@@gvinodreddi do not copy his code try to execute on debug mode U can easily catch the error
Those who are done this script, if your excel output is filled with empty rows in between.
Here is the reason - We have assigned and increment(counter+1) counter values in inner loop (that means Botsdna website table).
Instead, in the outer loop (That means 'Each row in worksheet') before the loop started - assign Counter variable with 1 (because excel having header) and after loop started assign "conter+1 = Counter" to write the data from 2nd row in excel.
It works as expected.
Reason for empty rows after 5th line and so on:
Because if you compare first 5 account numbers in excel sheet with website table it will match (till the Union bank of India - 7541). but the 6th row it is not matching (Indian bank -5174). Hence the counter keeps increment until it finds excel match with next website match that means (ICICI - 1514) So generating empty rows that many times in between.
Thanks
Some logics are not in proper way