CODEWITHSUNDEEP
automationuipathrpa
ramki
ramki

Reputation: 92

Uipath automation

I want to take the report of last one download details from the mysql database and sent to my project manager on every monday through the email so the process remains same only date would be change dynamically so, I would like to automate this process using RPA UIpath.

Anyone could you help me to achieve this process.

Thanks

Upvotes: 1

Views: 2421

Answers (3)

Er.Imran Shaikh
Er.Imran Shaikh

Reputation: 349

First step Take the data using database activity

Create an automation in UiPath to attach and send to your respective email

Schedule it own orchestrator.

Though not exactly but atleast sending a mail by taking credential from Orchestrator is shown in this article

https://www.c-sharpcorner.com/article/create-a-sequence-project-for-sending-a-mail-using-smtp-activity-by-taking-crede/

Upvotes: 2

Ilya Kochetov
Ilya Kochetov

Reputation: 18463

There will be some extra steps like transforming data as necessary etc, but the basic outline of this process is as follows

  1. Download MySQL ODBC Drivers MySQL site
  2. Control Panel -> Setup ODBC Data Sources (32-bit) setup User or System DSN, make sure to test your connection to see if it works OK (it's similar to how you set it up in MySQL Workbench or read about it here)
  3. In your UiPath Studio Package Manager, add Database Activities Pack.
  4. Get your data using UiPath.Database.Activities.ExecuteQuery activity to a DataTable
  5. Write your data to an Excel file using Write Range activity
  6. Send your mail through SMTP using UiPath.Mail.SMTP.Activities.SendMail including freshly created Excel file as attachment

Upvotes: 4

Farhan Abdul Salam
Farhan Abdul Salam

Reputation: 118

Use 'Database' package to connect to sql db and and run the query. Schedule the program to run every Monday using Orchestrator. Create the report with current date using DateTime function

Upvotes: 4

Related Questions