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$$]


Sunday, 24 September 2017

What is Robotic Process of Automation??????

                                                   

Welcomes you to the new world of AUTOMATION

Really do you have interest in RPA? then follow my blog ....

      Recently we are hearing more about RPA and AI right?........yes exactly,

  • what is this RPA ?
  • Why RPA?
  • Where it suits(For which industries)?
  • How it will be beneficial for us(both employ & employee )?

  • What is Future of this RPA?
  • Can we choose our career as employ & employee in RPA ?
  • Detailed info about RPA
  • How it will work?
  • What are the vendors of RPA softwares?
  • Future of RPA with AI?
  • Security 
  • Effect  of RPA on present employment.
  • Current Opportunities in RPA?(Get daily news about RPA openings)