WinSCP and Task Scheduler Automation in Windows server; Scripts

 https://docs.google.com/document/d/1qpyuGJ5-VE-z4BJCVQZ73NOB3IEk7j6b/edit?usp=sharing&ouid=108428966501894711148&rtpof=true&sd=true

Move files from one server location to another with batch script. Windows PC.

Use Case Repositories; UiPath

 https://forum.uipath.com/t/announcing-use-cases-repository-on-our-forum/314982

https://forum.uipath.com/c/learn/use-cases/206

JavaScript basic commands;

<blockquote class="twitter-tweet"><p lang="en" dir="ltr">I made a cheatsheet of JavaScript basics 😆<br>Enjoy!! <a href="https://t.co/70YIFtSzn2">pic.twitter.com/70YIFtSzn2</a></p>&mdash; yuri 유리 🇰🇷 (@codingyuri) <a href="https://twitter.com/codingyuri/status/1470708645717426179?ref_src=twsrc%5Etfw">December 14, 2021</a></blockquote> <script async src="https://platform.twitter.com/widgets.js" charset="utf-8"></script> 

Steps to run the Cognos SDK code; csharp .NET

 Steps to run the Cognos SDK code:

1. Build the code; Make sure the references are in for all dlls (similar to jar files in java)
2. Next go ahead to click on build.bat file to open up the window (screenshot1)
3. Screenshot 2:
4. Checkout the readme file.

Screenshot 1:

Screenshot 2:

Readme file:

Refresh formulas in an excel sheet; Microsoft Excel

 

Please use control+shift+alt+F9 to refresh formulas in the sheet.

https://answers.microsoft.com/en-us/msoffice/forum/all/f9-function-key-does-not-seem-to-be-working-in/826f460a-9810-4bee-adab-5cd318b968d0

Command to search file in a Linux folder; Show timestamp of file UNIX/LINUX

$ find /appName/jython2.7.0/bin/ArchivedFiles/ -name  "*INC*MAR-21*.csv" -printf '%Tc %p\n'

 Example:

[appNameqa@serveraddress base_domain]$ find /appName/jython2.7.0/bin/ArchivedFiles/ -name  "*MAR-21*.csv" -printf '%Tc %p\n'

Sample output:

Tue 14 Sep 2021 02:20:59 PM EDT /appName/jython2.7.0/bin/ArchivedFiles/fineNAme-corrections.csv

Mon 27 Sep 2021 12:22:25 PM EDT /appName/jython2.7.0/bin/ArchivedFiles/fineNAme-delta.csv

Thu 17 Jun 2021 09:53:20 AM EDT /appName/jython2.7.0/bin/ArchivedFiles/fineNAme-20210616033652.csv

Fri 24 Sep 2021 03:17:08 PM EDT /appName/jython2.7.0/bin/ArchivedFiles/fineNAme-full_submission.csv

Remove lines numbers from code; Helpful link

 https://remove-line-numbers.ruurtjan.com/

Copying data from SVN browser would include line numbers;

https://remove-line-numbers.ruurtjan.com/ website removes the Line numbers instantly: