AWS S3 How to Find Files with by Keyword

open cmd
run command :

aws s3api list-objects --bucket BUCKETNAME --prefix FOLDERNAME1/FOLDERNAME2/ --output json --query "Contents[?contains(Key, `SearchKeyword`)]"

---

How to sum :

aws s3api list-objects --bucket BUCKETNAME --prefix FOLDERNAME1/FOLDERNAME2/ --output json --query "[sum(Contents[?contains(Key, `SearchKeyword`)].Size), length(Contents[?contains(Key, `SearchKeyword`)])]"

AWS S3 How to Count Folder Size

open cmd
run command :

aws s3api list-objects --bucket BUCKETNAME --prefix FOLDERNAME1/FOLDERNAME2/ --output json --query "[sum(Contents[].Size), length(Contents[])]"

AWS cannot login RDP - Must change password before log in

AWS cannot login RDP - Must change password before log in

Error : "You must change your password before logging on the first time"

1. Open RDP
2. Connection Setting : click "Save As"
3. Save *.rdp file
4. Edit *.rdp file : add : enablecredsspsupport:i:0
5. Open RDP
6. Change password (with password policy)

How to delete files in folder using powershell

How to delete files in folder using powershell
Open Powershell
Run Command : Remove-Item –path c:\testfolder\* –recurse

* means any

How to using Windiff as External Diff in SourceTree

How to using Windiff as External Diff in SourceTree

1. Open SourceTree
2. Tools - Options
3. Diff - External Diff Tool : Custom
Diff command : C:\PathToWindiff\WinDiff.Exe
Argument :   $LOCAL $REMOTE

*note: put <space> in First letter in Argument
example in command prompt : WinDiff.Exe $LOCAL $REMOTE

How to compare file using Command Prompt and Visual Studio 2015

How to compare file using Command Prompt and Visual Studio 2015
1. open command prompt
2. go to visual studio path : "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE"
3. example :

.\devenv.exe /diff “C:\b.txt” “C:\a.txt” “SOURCE” “TARGET”

Copy Multi Folders using Robocopy for "Infinite Folders"

Intro dulu ya ....
gw lagi coding php, pake php designer 8. trus gw coba-coba toolsnya. ada export, eh pas gw coba, kok ga beres2 copynya?? trus gw cancel. pas gw liat, eh ternyata ngebuat folder yg banyak bgt.
gw coba cek pake software2, ada sekitar 475 folders (dibaca: tak terbatas a.k. infinity / infinite).
foldernya ampe ga bisa dibuka.
trus gw googling2.
- pake cmd , pake cara buat remove autorun.inf nya SMADAV seperti rmdir, rd, del, erase.
- install winUtilities, Unlocker, pake power shell, dsb.
- trus gw coba robocopy. pake cmd jg. setelah menggila lama , akhirnya nemu juga caranya. yaitu
robocopy [source] [dest] /purge /s /mov
contoh :  robocopy c:\hapus\a\ c:\delete\a\ /purge /s /mov

beres deh...

So, ini kesimpulannya :
Pakai Robocopy (using cmd)
command : 
robocopy [source] [dest] /purge /s /mov
contoh :  robocopy c:\hapus\a\ c:\delete\a\ /purge /s /mov

**dipublish setelah gw liat ini as draft (udah 4 tahun sepertinya...)

using Entity Framework or EF to copy an Object.

using Entity Framework or EF to copy an Object.
This can be used to avoid Error : PK cannot be modified :
"The property 'MyPrimaryKey' is part of the object's key information and cannot be modified. "
we can use this query :

var item = _context.MyTableName.First(z => z.Name == "Ardi");
var newItem = (MyTableName)_context.Entry(item).GetDatabaseValues().ToObject();
newItem.MyPrimaryKey = "Generated_" + DateTime.Now.ToString();
_context.SaveChanges();

How to import Huge SQL Script on mysql

open xampp Control Panel
click / open : shell

on shell type this commands:

1. command : "MYSQL -U USERNAME -H LOCALHOST -P PASSWORD"
USERNAME : your database username
PASSWORD : your database password
(if no password, then don't use "-P PASSWORD")

2. command : "USE NAME_OF_DATABASE"
 NAME_OF_DATABASE : name of your database

3. command : "SOURCE PATH_TO_SQL_FILE"
PATH_TO_SQL_FILE : location to script.sql
(ex. "source d:/myscript.sql")

4. done

Firefox Text Bold Problem

I got my Firefox Text get Bold. This problem caused by regular Arial Font is missing. So, Arial Black is used.
To fix this, I got arial.ttf from http://www.fontsupply.com/fonts/A/Arial.html .
After you download, open arial.zip then open arial.ttf. Click install.
Your arial font will installed.
Problem done.