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