Thursday, August 20, 2020

Shell script to spwan sftp process; cronjob; UNIX

Below script can be scheduled to run every 5 mins to fetch files remote to local server.

Crantab -e would allow you to schedule jobs on LINUX servers. 


#!/bin/bash

/usr/bin/expect << EOF
spawn sftp USERNAME@host
expect "Connecting to 127.0.0.1..."
expect "password:"
send "Enter Credential\r"
expect "sftp>"
send "cd Test\r"
expect "sftp>"
send "lcd /home/username/App-Files\r"
expect "sftp>"
send "mget * \r"
expect "sftp>"
send "rm * \r"
expect "sftp>"
send "quit \r"
EOF

Friday, August 14, 2020

Automated script to do file transfer; WinSCP

 


winSCP script commands :

 "synchronize -nopreservetime -criteria=none remote C:\Users\Username\Desktop\Test_Folder           /dropbox/Test_Folder" ^


 "synchronize -nopreservetime -criteria=none remote <Source> <Destination>" ^


-nopreservetime -criteria=none  -> these parameters are required to ignore below error 


 2020-09-15 09:33:39.678 If the problem persists, turn off setting permissions or preserving timestamp. Alternatively you can turn on 'Ignore permission errors' option. ("Permission denied.
. 2020-09-15 09:33:39.678 Error code: 3
. 2020-09-15 09:33:39.678 Error message from server: Permission denied")
< 2020-09-15 09:33:39.678 Script: Upload of file 'New Text Document (2).txt' was successful, but error occurred while setting the permissions and/or timestamp.
< 2020-09-15 09:33:39.678 If the problem persists, turn off setting permissions or preserving timestamp. Alternatively you can turn on 'Ignore permission errors' option.


WinSCP Commands ; Get file from server to Local machine


     "cd /dropbox/Test_Folder"^
    "lcd C:\Users\VJ\Desktop\Test_Folder\"^
    "get  -transfer=automatic New*Text*Document.txt"^
     "exit"


Put File on remote server: batch script code:

   "cd /dropbox/Test_Folder"^
    "lcd C:\Users\VJ\Desktop\Test_Folder\"^
    "put  -nopreservetime  -nopermissions -transfer=automatic New*Text*Document.txt"^
    "exit"

Tuesday, August 4, 2020

Chrome Extension UiPath RPA; UiPath.Core.BrowserOperationException: Cannot communicate with the browser Error

https://chrome.google.com/webstore/detail/uipath-web-automation/dkgencfabioofgdmhhjljpkbbchbikbh




UiPath.Core.BrowserOperationException: Cannot communicate with the browser, please check the UiPath extension. ---> System.Runtime.InteropServices.COMException: Cannot communicate with the browser, please check the UiPath extension.


Make sure you enabled Chrome bridge on UiPath