How to deactivate UiPath license locally

Here's how you can deactivate your UiPath license yourself so you can use the license key on another machine. Granted, you still have access to the local machine where UiPath is installed. Otherwise, get in touch with UiPath support for a deactivation request.

Alright...

1. Login to the machine where UiPath is insalled
2. Open the command line and run the following:

"C:\Program Files (x86)\UiPath\Studio\UiPath.LicenseTool.exe" deactivation-request

Make sure the location of UiPath.LicenseTool.exe is correct

3. Copy the resulting Deactivation Token
4. Navigate to https://activate.uipath.com and paste the deactivation request token on the text area

5. Click the Deactivate License button and you're done

Now you can use the same license key on another machine. If it doesn't work automatically right after you deactivated the license key, try the manual activation option instead. 

Read More

How to create a "run as different user" shortcut for SQL Server

Problem: I always need to open SQL Server using my admin account but I don't want to keep on doing right click + run as different user, then type my admin username and super long admin password.

My solution? I created a shortcut that launches SQL Server using a different user. Now all I have to do Run "sqlserver" and the app will automatically open using my admin account. That's a major reduction in keystroke yknow! Hahaha

How:

Create a shortcut with the following target and place it in your user folder.

C:\Windows\System32\runas.exe /savecred /user:domain\surfandperf-admin "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"

In detail:

1. Navigate to where your SQL Server executable file is.
   Usually it's inside C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\ as ssms.exe
2. Right click ssms.exe >> Send to >> Desktop (create shortcut)
3. On your desktop >> right click the SQL Server shortcut created >> go to Properties >> update the target to this:
   
   C:\Windows\System32\runas.exe /savecred /user:domain\surfandperf-admin "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"
   
   Basically I just prepended the target with the red text, making sure to replace the /user part with the username I want to login with.
   
   I used /savecred to save the password for future launches
   
   
   

   
   
4. Move to the shortcut to your user folder and rename it with whatever you want the shortcut name to be
   
   
   
5. Now you can launch it using the run dialog.
   
   

   

On first launch it will ask for a password.

Hope it works! I really just want fewer clicks and keystrokes for everything hehe.

Read More

OC with my PC

Note to self for whenever I have to setup a new PC. Urgh. I hope every time they send us new machines at work they'd load it with whatever our previous settings/apps/files were. Anyway...

Photo from Pexels

What settings to uhm, set...
Turn regular account to admin:
- Login using regular account
- Connect to VPN
- Switch user to adm
- Log off regular account
- Connect to VPN
- compmgmt.msc
- Local users and groups >> Groups >> Administrators
- Add
- Locations: nearest group
- Add object

Copy todo.txt to Yan
- Open in npp

Create off.bat
- Copy YanNotes to H
- move bat to Yan

Install UiPath Web Automation Chrome extension
URL: https://chrome.google.com/webstore/detail/dkgencfabioofgdmhhjljpkbbchbikbh

What to install...
Notepad++
Chrome
Firefox
Opera
WinWord
WinRAR
WinMerge
ScreenHunter
Photoshop
SQL Server
SQL Server Management Studio
Viber
UiPath
VLC

What shortcuts to make...
YanNotes
YanH
Yan
io | inetcpl.cpl
bt | bthprops.cpl
ps | photoshop
uipath
uisb | uipath sandbox
jabber
sqlserver
vpn

What shortcuts to update...
word
paint
mail
ie

This is it for now, will add more to this later on hehe

Read More

How to extract nupgk files using WinRAR

Did you know that the package file of your UiPath workflow contains the entire workflow file? So if you wanted to backup your script you just need to get the nupkg file and extract the contents. And in order to do that, you can use WinRAR. How?

1. Open WinRAR
2. Go to Options >> Settings (or hit Ctrl+S)
3. Go to Integrations tab
4. Under "User defined archive extensions", type "nupgk", then click OK

That should do it! :)

Read More

How to add programs on Windows Startup

Because I always forget where to put my screensaver app so that it launches upon startup, here's a note to self:

On the run dialog, enter "shell:startup"

OR

Open %AppData% >> Roaming\Microsoft\Windows\Start Menu\Programs\Startup

Yup, that's it. :)

Read More

[PHP] Special characters being replaced with black diamonds with question mark �

If you ever come across this issue where special characters in your PHP wep add like aprostrophe's and ñ's are being replaced by this weird symbol, �, it could be a char-set thing.

I tried a couple of solutions but none of them worked, until I looked into my php.ini for anything related to setting the character encoding, and I found that the default_charset is set to UTF-8.

I simply changed it to ISO-8859-1, restarted the IIS server, and refreshed the page.

And it worked!

Php.ini can be found on your PHP installation folder, in my case: 

C:\Program Files (x86)\PHP\php-7.4.8\php.ini

Set default_charset to ISO-8859-1 and enable it by removing the ; in front

default_charset = "iso-8859-1"

Read More

[SQL Server] How to export table data as insert statements

In case you want to export all the rows in a table as insert statements, here's how to do it:

1. Open MS SQL Server Management studio and login to your desired database server
2. Right click database >> Tasks >> Generate Scripts
   
   
3. Choose Objects: Select specific database objects >> Select the table you want to export
4. Set scripting options: Select Save to file then click Advanced
5. Under advanced >> General Options >> Types of data to script - choose Data only >> Click OK
   

   

   
   
6. Proceed to next steps until table is successfully scripted, the click on Finish

And you're done, you've now exported table data as insert statements.

Read More