Excellent video Mukesh! Thank you for explaining the content in a simple yet detailed way. After watching this video, everyone will get a complete understanding about File and Folder Automation.
Hi Mukesh explained amazingly!! I need help in uipath related to delete folders This is the task : Need to create a utility workflow to delete older files and folders: Input is a spreadsheet with 2 columns: FolderLocation and NumberOfDays Robot has to iterate through each of the row in the spreadsheet and delete all the files and folders inside the 'FolderLocation' value which were created before the 'NumberOfDays' value. For example, if "FolderLocation' value is D:\Sample Folder\2022\ and NumberOfDays' is 10, robot should delete all files and folders inside D:\Sample Folder\2022 which are created on or before May 8 (today's date: May 18 - 10= May 8) Can I get an explanation regarding this usecase please 🥺
1. Read the Data in the DataTable Say DT - This would have 2 Columns , Col1 with Folder Name and Column 2 will Days. 2. Loop Through the Datatable using a For each. 3. Inside the for each - Get the Current Date in a variable and substract the Column2 Values - Using dt.Now.AddDays(- No of Days). Date - This will give you the Date you require 4. Now Use Directory.getFiles and Read all the Files whose created date is less that the Date from step3 - Store this in array [String]. 5. For each Array - String - USe Delete File Activity
To create the multiple Folder : 1. you can keep all the folder paths in some list/ array 2. then run list for each loop - 3. Take a Activity called - Folder Exist 4. Pass the Folder name , it will give true and False if folder is available or not 5. If not - drag a create folder activity and pass the folder path
Use open application/browser activity to open the folder by robot , if you want to open it manually- use the open folder activity To take screenshots: use take screenshot activity To send mail : send mail / send outlook depending on what mail you want to use - you can refer the email automation playlist th-cam.com/play/PLEYSwx3duQ2DszZgOhhsX2ikmAD9B9BP3.html&si=GuMW3KS76LdFUyJO
Every file and folder has some properties which we can check to make sure that the file is pasted … it can as simple as the count of files in the folder …
@@MukeshKala String.Join(" ",Directory.GetFiles(str_Folder, "*.xlsx").OrderByDescending(Function(a)New FileInfo(a).CreationTime).Take (2)) this code is right?
Hi Bro. i am getting this error when trying to delete the folder. RemoteException wrapping System.IO.IOException: The process cannot access the file 'C:\Automation\UIPath' because it is being used by another process. Please help me ASAP
C:\Automation\UIPath' because it is being used by another process. This means that there are some files from the folder which are open ... and because the files are open from the Folder ,,, The Automation is not able to delete them
i am getting this error bro. while trying to delete the folder - Delete Folder: The process cannot access the file 'C:\Automation\UIPath' because it is being used by another process.
Excellent video Mukesh! Thank you for explaining the content in a simple yet detailed way. After watching this video, everyone will get a complete understanding about File and Folder Automation.
Thank you For your Comment 😊
Thank you for great videos and sharing knowledge. God bless you!!
Glad it was helpful 😃
Hi Mukesh explained amazingly!!
I need help in uipath related to delete folders
This is the task :
Need to create a utility workflow to delete older files and folders: Input is a spreadsheet with 2 columns: FolderLocation and NumberOfDays Robot has to iterate through each of the row in the spreadsheet and delete all the files and folders inside the 'FolderLocation' value which were created before the 'NumberOfDays' value.
For example, if "FolderLocation' value is D:\Sample Folder\2022\ and NumberOfDays' is 10, robot should delete all files and folders inside D:\Sample Folder\2022 which are created on or before May 8 (today's date: May 18 - 10= May 8)
Can I get an explanation regarding this usecase please 🥺
1. Read the Data in the DataTable Say DT - This would have 2 Columns , Col1 with Folder Name and Column 2 will Days.
2. Loop Through the Datatable using a For each.
3. Inside the for each - Get the Current Date in a variable and substract the Column2 Values - Using dt.Now.AddDays(- No of Days). Date - This will give you the Date you require
4. Now Use Directory.getFiles and Read all the Files whose created date is less that the Date from step3 - Store this in array [String].
5. For each Array - String - USe Delete File Activity
@@MukeshKala Thankyou so much!!!
But can I get vedio explanation on this please
@@aishwaryakl6566 will try to upload
@@MukeshKala Thank you 🥺
Means a lot
Newbie here in UIPath may I know how can I create multiple Folder and check if exist or not exist then create folder needed
To create the multiple Folder :
1. you can keep all the folder paths in some list/ array
2. then run list for each loop -
3. Take a Activity called - Folder Exist
4. Pass the Folder name , it will give true and False if folder is available or not
5. If not - drag a create folder activity and pass the folder path
WHAT IS THE ACTIVITY TO OPEN A FOLDER AND TAKE A SCREEN SHOT AND PASTE IT TO MAIL BODY
KINDLY ADISE BRO
Use open application/browser activity to open the folder by robot , if you want to open it manually- use the open folder activity
To take screenshots: use take screenshot activity
To send mail : send mail / send outlook depending on what mail you want to use - you can refer the email automation playlist th-cam.com/play/PLEYSwx3duQ2DszZgOhhsX2ikmAD9B9BP3.html&si=GuMW3KS76LdFUyJO
what to do in a scenario where we want to move file and wait until its available. ?
Every file and folder has some properties which we can check to make sure that the file is pasted … it can as simple as the count of files in the folder …
Great tutorial.
Thank you! Cheers!
How to find the latest two file from the folder
Sort All the files order by Descending Order and Take top 2
@@MukeshKala String.Join(" ",Directory.GetFiles(str_Folder, "*.xlsx").OrderByDescending(Function(a)New FileInfo(a).CreationTime).Take (2))
this code is right?
Hi Bro. i am getting this error when trying to delete the folder.
RemoteException wrapping System.IO.IOException: The process cannot access the file 'C:\Automation\UIPath' because it is being used by another process.
Please help me ASAP
C:\Automation\UIPath' because it is being used by another process. This means that there are some files from the folder which are open ... and because the files are open from the Folder ,,, The Automation is not able to delete them
i am getting this error bro. while trying to delete the folder - Delete Folder: The process cannot access the file 'C:\Automation\UIPath' because it is being used by another process.
This simply means there are some files from the folder which are open … may be some program or if it’s a shared drive may be by someone else
Looking for ward to attend the session
I am Sure - You will have good Idea of File and Folder Automation at the end of this .
Great explanation Mukesh. Thanks for the session.
Thank you 😊
This really helped. Thanks for always sharing
Glad it was helpful!
New concepts
Thank You 😌