RPA World of AUTOMATION

Monday, 21 November 2022

Script to clear history, cookies, temp files on browser

Save below lines as .bat file:

@echo off

del /s /f /q %windir%\temp\*.*

rd /s /q %windir%\temp

del /s /f /q %windir%\Prefetch\*.*

rd /s /q %windir%\Prefetch

del /s /f /q %windir%\system32\dllcache\*.*

rd /s /q %windir%\system32\dllcache

del /s /f /q "%SysteDrive%\Temp"\*.*

rd /s /q "%SysteDrive%\Temp"

del /s /f /q %temp%\*.*

rd /s /q %temp%

del /s /f /q "%USERPROFILE%\Local Settings\History"\*.*

rd /s /q "%USERPROFILE%\Local Settings\History"

del /s /f /q "%USERPROFILE%\Local Settings\Temporary Internet Files"\*.*

rd /s /q "%USERPROFILE%\Local Settings\Temporary Internet Files"

del /s /f /q "%USERPROFILE%\Local Settings\Temp"\*.*

rd /s /q "%USERPROFILE%\Local Settings\Temp"

del /s /f /q "%USERPROFILE%\Recent"\*.*

rd /s /q "%USERPROFILE%\Recent"

del /s /f /q "%USERPROFILE%\Cookies"\*.*

rd /s /q "%USERPROFILE%\Cookies"

Wednesday, 6 April 2022

VM Minimizing or Disconnectivity Issue while using Automation Anywhere

Place the below data in to one text file and save it as .bat file and place this file on Desktop of our VM/machine and double click on it to sign-out from the VM and to let the BOT run with out having any issue.

Save below lines as .bat file:

for /f "skip=1 tokens=3" %%s in ('query user %USERNAME%') do (

%windir%\System32\tscon.exe %%s /dest:console

)

shutdown -l -f

Connecting Excel as Db/Database in Automation Anywhere (A2019/A360)

Below are the steps to connect excel as Db in A360:

prerequisite: Open the link and download the MS access DB (32/ 64 bit based on your system configuration) https://www.microsoft.com/en-us/download/details.aspx?id=13255

1. Open Database connect action/command

2. Give a session name

3. Select Default in the connection mode

4. Use the below connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<FilePath>;Extended Properties="Excel 12.0 Xml;HDR=YES;";

Replace the <FilePath> from the above connection string with the excel file path as below:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=‪C:\Users\Mahendra.Latchireddy\*****\Desktop\EmployeeData.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;";

5. Now you will be able to connect to the excel as Database. Below are the queries with syntaxes you can use:

For selecting the data, use Read from action with following query - Select * from [SheetName$$]