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...
SQL Server
SQL Server Management Studio

What shortcuts to make...
io | inetcpl.cpl
bt | bthprops.cpl
ps | photoshop
uisb | uipath sandbox

What shortcuts to update...

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


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! :)


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"


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

Yup, that's it. :)


[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"

[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.

[PowerShell] Monitor active log files in Windows using type -wait command

Oh this is super handy. Say you have an active log file you want to monitor in real-time, simply run this command in Windows Powershell and see your logs update live on the terminal.

To demonstrate, in the screenshot above, I simply created a script that logs the current timestamp every two seconds on a logfile located at the Desktop. Then I used Powershell to monitor the updates on the terminal.

To do so, simply open Windows PowerShell on your machine and run the following command:

type -wait "logfile.txt"


[UiPath] How to setup config file and read variables

Updated December 2019
I just figured there's something wrong with my implementation of the config file, specifically its file location. The path needs to be absolute otherwise the robot package will refer to the config file inside the nupkg file and you would need to re-publish the workflow every time you update the config file.


Setting up a config file for your workflows is an efficient way to configure the initial settings of your workflow environment. Variables that refer to path locations, URLs, and other config information that you need to setup when moving your workflow from one environment to another are better placed inside a config file. Think of it as not having to go inside UiPath studio to update your variables every now and then. Instead, you can just create a config file in Ms Excel, and read it in your workflow.

Here's how:

1. Create your config file

In this example, I named the config file as FileConfig.xlsx.
You can place it anywhere actually, just take note of its absolute path. It's the only path you'll put inside your workflow.

2. Set your variables using two columns

Variable names on Column A, then values on Column B.

3. Read your config file and store it in a DataTable

Use the Read Range (Workbook) activity to read the config file and store it in a DataTable.

4. Access your config variables using the DataTable.Select method

var config_var = DataTable.Select("[Column Name]='variable name'")(0)(1).ToString

Use the select method to return the row that matches the variable name in the Var column of your config file, and (0)(1) index to refer to the second column of the first matched row. 

That's it!

If you need to add more config variables on the excel file, you should likewise add another Assign activity in your workflow to fetch the new variable.

Hope this helps!