I have list of 200 desktops IP address in the Excel sheet and I want to connect all of the desktops to perform temp cleanup in the local drives of each desktops in my domain network , How can archive uipath ?
Hi buddy @nibu
Welcome to UiPath community buddy…
Great
Kindly follow the below steps that could help you to resolve your issue
- Open excel application scope activity to open the Excel
- Use read range activity to read the data in excel and save it to a variable name of out_dt
- Use a for each Row loop to iterate through each row that is each value in the ipaddress column…pass the out_dt variable to this loop as input and use a assign activity to get the ipaddress like this
Out_ipaddress = row(“ipaddresscolname”). Tostring - Now u can use this as a variable and pass as input to the process involved in clearing temp files…kindly refer this url to do that…
Remove temporary files in your system
Hope this would help you buddy
Cheers… kindly let know if this works or not…
@nibu
@nibu,
There are at least two ways I have in my mind to achieve this. By doing what @Palaniyappan said you need to have all IP kept in DataTable. Then you need to loop through each IP and you can do:
-
Invoke Power Shell
where you can use “Enter-PSSession ” and do all stuf from PS.
This method however requires to have PS Scripting enabled for all servers. - By using
Click
andType Into
activity navigate to “Run” then type “\<rest of path>”
and do next click etc. to remove/do cleanup of paths.
Thank you Palaniyappan. However could not understand the looping out ip address
Example my Excel contain ip address only , now where do I link Excel data to loop desktop ip address [\192.168.1.1\d$\foldername ?
Buddy its very simple you are almost done
- see once you get the value from for each row loop assigned to a variable like
Out_ipaddress = row(“ipaddresscolname”). Tostring - Now again use a assign activity like this to concetanate
“["+“Out_ipaddress”+”\d$\foldername" to get like this
[\192.168.1.1\d$\foldername where Out_ipaddress = “192.168.1.1” obtained from for each row loop
3 Then you can pass this as input to type into activity to enter that or pass anywhere youwant
Thats all buddy kindly try this and let know whether this works or not
Cheers @nibu
DltRemoteDesktop.xaml (6.6 KB)
Hello Palaniyappan, many thanks. I stuck on point 1 and 2.This what I accomplish so far !
here is xaml buddy… @nibu
Kindly try and let know buddy
DltRemoteDesktop.xaml (12.3 KB)
Cheers
Many thank for all the help you provide to me Palaniyappan .
The only problem is that when I run the file excel file in message box to test it shows the variable name instead of \192.168.1.1\d$\foldername ! how can I change to show the correct data like \192.168.1.1\d$\foldername ?
No worries buddy @nibu
Can i have the xaml again with project.json file and the xaml you have both zipped together
sorry that there is some problem with the studio opening the file
Cheers @nibu
DeleteNetworkDesktopfiles.zip (12.5 KB)
Sorry for asking to many question Palaniyappan. Here is the file
Buddy you were actually done buddy @nibu
but the issue was the variable been used as a string
see here buddy
Out_ipaddress is a variable
but we have placed as string between quotes down the next activity
so remove that quotes and just put as Out_ipaddress alone buddy @nibu
That would work buddy
Cheers
Palaniyappan,
It work perfectly thank you so much and now I can continue adding other activity
Fantastic buddy @nibu
Cheers keep going
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.