How to Make an Ejectable Internal Hard Disk Drive (SCSI device) Unejectable

My PC is built with Asrock Z68 Extreme4 gen3 which has a Marvell SATA3 (6G) chipset, and it has a problem that even though I disabled the SATA ports hot-swap in the BIOS, still it shows my internal hard drives in the tray as ejectable devices.

Checking/unchecking the 'Enable safely remove disk' option in the 'Policies' tab of Marvell SATA driver dialog from Device Manager also never worked.

Google and the respectful pre-path-walkers told me the followings:


1. How to Make an Ejectable Internal Hard Disk Drive Unejectable

Check out user12459's answer in the link above.

This no.1 solution works  greatly for the hard drives that are shown as a SATA drive, but it doesn't work for the ones which are shown as a SCSI device.

It's little annoying to create a batch file and the shortcut in the Startup folder, not a elegant way

2. How to Make an Ejectable Internal Hard Disk Drive which looks as a SCSI device in the tray Unejectable

Focus on the next line which appears in the linked page no.2 above.

reg.exe add "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\PCI\VEN_1000&DEV_0054&SUBSYS_197615AD&REV_01\4&1f16fef7&0&00A8" /v Capabilities /t REG_DWORD /d 2 /f

Making the code above as an .bat file and put create a shortcut of the file, and then cut and paste it in the folder that you can open with clicking 'Start' button -> All Programs ->  Startup', right-click on it and choose 'Open all users.'

However, you need to tweak some parts of the code above to make it work with your hard drive.

Run 'regedit.exe' and go to 'HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\IDE\' and find the hard drive which your Windows system recognize as SCSI device.

In my case, it was 'DiskWDC_WD6400AAKS-00H2B0___________________07.04C07' (yes, WesternDigital 640GB HDD) and under it, there was '5&1599dfff&0&2.0.0' that seems like it is kinda ID of the hard drive.

You have to replace the bolded three parts, 'PCI', 'VEN_1000&DEV_...', '4&1f...'
 to your information is matched respectively, so with my computer,

• 'PCI' to 'IDE'
• 'VEN_1000&DEV_0054&SUBSYS_197615AD&REV_01' to 'DiskWDC_WD6400AAKS-00H2B0___________________07.04C07'
• '4&1f16fef7&0&00A8' to '5&1599dfff&0&2.0.0'

Don't miss the backslash between three of those.

P.S. No.2 way is not perfect because Windows refreshes the list of removable devices at a boot time and also when some external device like a USB memory is connected or disconnected.

 
한글로 쓰려니... 일할 시간도 없고 너무 귀찮... 죄송합니다만 영어로 보세요.


'장치 안전하게 제거하기 내장 하드디스크' '트레이 내장 하드 장치 제거 안 보이게 하는 방법'

LG G Pro F240K (Korean Model) Unrooting and Software Update

LG 지 프로 KT, 언루팅 & 소프트웨어 업데이트

한글 요약: 루팅이 되었기에 OTA 소프트웨어 업데이트를 할 수 없던 젤리빈 LG G Pro(KT버전)를 아래 Way 3에 소개된 방법으로 킷캣으로 업그레이드 할 수 있었다.

Situation: Trying s/w update (4.4.2 Kitkat) on a rooted LG G Pro (F240K) of 4.1.2 Jellybean

Why: Abnormally slowed response recently and needs of unrooted phone

Problem: LG blocked s/w update on a rooted phone

Way 1.
Trying to unroot with keeping 4.1.2
Failed: Couldn't find the unrooting tool which is related to my previous rooting tool.

Way 2.
Using LG Mobile Support Tool
Failed: The program keeps saying the battery is low even though it's fully charged.

Way 3.
Using LG Flash Tool 2014 with the Jellybean KDZ file for F240K
Succeeded: Hurray!

Preparation: LG Mobile Support Tool (B2CAppSetup.exe), LG Flash Tool 2014 (.zip), KDZ file for F240K (.kdz)

1. Run LGFlashTool2014.exe as an administrator
2. Select Type: CDMA
3. PhoneMode: EMERGENCY
4. Select KDZ file
5. Click [CSE Flash]
6. Click [Start]

Then it will run LG Mobile Support Tool and start firmware update.

I don't know why, but in my case, it stopped at 4% and showed some instructions of rebooting the phone and there was a [Retry] button. Instead of following the sentences I just click the [Retry] button and it proceeded greatly up to 95%, and then the phone was rebooted.

The initial setting steps were begun with the greeting Droid image, but the proceeding bar was 95% still so I was waiting and finally it became 100% without any change on the phone screen. I unplugged the USB cable and checked the s/w version which was changed to Jellybean, of course not rooted.

After 6 times of trials of s/w update from Jellybean to Kitkat, the phone works finely awesome! It responses as a quad-core device. I had to select and install 78 apps manually from my previously installed app list of the Google Play Store but it was a chance for me to organize the unused apps, so no problem.

Big thanks to all xda devs and the uploaders of tools and kdz files. You're super!

Microsoft Word 2013 - How to Underline with Spaces

In MS Word 2013, you cannot see any underlined spaces when type space bar on your keyboard with underlined font style. I didn't know that it was like this in Word 2007 or 2003 but it is in 2013 and makes users confusing because it doesn't work as it is expected.

It would be like this with just typing Space... So bothering!

We have to type Ctrl+Shift+Space (none-breaking space, what is that... why isn't the default space for underlining...) to see those underlines like the following.

It would be like this with typing Ctrl+Shift+Space.


Simple, but needed an extra effort to find out.

MS Office, very unkind.

MS Excel 2013 - How to apply a function to multiple cells & Excel shares its undo/redo history with all opened documents (workbooks, windows, worksheets whatever)

How to apply a function to multiple cells at once

You have one column (A) that have many cells filled with different values, and you want use a same function with that values and fill the results in the cells of a different column (B), probably next column.

Apply your function in B1 with using A1 as its parameter, got the result in B1? Then drag the right-bottom corner of B1 cell and drop it on BX which is the next cell of the A column's cell that has the last value you want to use as a parameter of your funciton.


How to add/subtract/multiply/divide in multiple cells at once
or
How to copy only Formulas/Values/Formats

The answer is ...

'Paste Special'

You have different values in A1:A20, and you want to do adding/subtracting/multiplying/dividing with a certain value but separately into/for all of A1:A20 values.

For example, you want to add '100' to A1:A20 independently, then type in 100 in any cell you wouldn't use in the future, and copy the cell, and then select A1:A20, right-click on the selection and expand the menu 'Paste Special' and click 'Paste Special' at the bottom again. (how poor this interface is ...)

Choose 'add' on the dialog and 'OK'. Done.

You can copy only functions, formats with this special paste without copying any values, or only values.


By the way, I found a terrible truth (in most case) that opened multiple Excel documents (or workbooks, or windows) share one undo/redo history, which is not convenient at all in many cases. Because the opened documents are managed by Excel application's one 'instance'; a computer term indicates one unit of processing, a.k.a 'process'. (One visible application may consist of one process or more processes. One process may have one thread or more threads.)

You can open a document as a new instance that has a independent undo/redo history by holding 'Alt' key before clicking the Excel icon on your Start menu or Taskbar (in Windows 7) and keep holding until you see a dialog asks about starting a new instance of Excel.

There should be a reason of that MS made Excel or other office applications like this, but as a light user, I couldn't find any benefit so far. Because of OneDrive cloud service?

How to configure Sublime Text 2 (서브라임 텍스트2 설정하기)

Open user-setting files on the menu like below.

Preferences - Settings-User
Preferences - Key Bindings-User

Add a rule that you want to add or change by referring 'Preferences - Settings-Default' and 'Preferences - Key Bindings-Default'. Here is my settings code.

Settings-User:
{
"color_scheme": "Packages/Color Scheme - Default/Sunburst.tmTheme",
"font_face": "Bitstream Vera Sans Mono",
"font_size": 8
}

Key Bindings-User:

[

{ "keys": ["ctrl+5"], "command": "toggle_minimap" },

{ "keys": ["ctrl+6"], "command": "toggle_setting", "args": {"setting": "word_wrap"} }

]

The full paths of the user-setting files are like the followings.

C:\Users\NAME\AppData\Roaming\Sublime Text 2\Packages\User\Preferences.sublime-settings

C:\Users\NAME\AppData\Roaming\Sublime Text 2\Packages\User\Default (Windows).sublime-keymap

So if you want to keep your own settings after re-installing Windows or something like that, copy the 'C:\Users\NAME\AppData\Roaming\Sublime Text 2\Packages\User' folder and overwrite it after installing Sublime Text 2.

FileZilla FTP Client - Connected to the server, but does't list a directory? (파일질라 서버 연결은 됐는데 폴더, 디렉토리 목록 조회가 안 될 때)

- Set 'Transfer Settings - Transfer mode: Active'

- Add your 'FTP port' or 'FTP Client program' onto the list of Inbound rules of Windows Firewall

- 전송 모드를 Default나 Passive가 아닌 Active로 바꿈

- 윈도우즈 방화벽의 인바운드에 접속 포트를 추가, 혹은 FTP Client를 추가

Cool!

공인인증서 또는 ISP 인증서 저장 위치

1) 공인 인증서(범용, 은행/보험용) 파일 저장 위치
   - Windows XP/Vista
     C:\Program Files\NPKI

   - Windows 7(64bit)
     C:\Users\[사용자 아이디]\AppData\LocalLow\NPKI

  * 위의 폴더 하위에

       증권용은 SignKorea 폴더, 은행용은 Yessign 폴더, 기관용은 CrossCert 폴더 등의 아래에 User 폴더에 존재

2) ISP 인증서(BC카드 등) 파일 저장 위치
   - Windows XP
     C:\Windows\Application Data\VCard

   - Windows Vista/Windows 7(64bit)
     C:\Users\[사용자 아이디]\AppData\LocalLow\KVP\Application Data\Vcard

3) USB 저장 장치의 경우, 해당 드라이브 루트(최상위 폴더)에 위치
   - USB드라이브명:\NPKI
   - USB드라이브명:\Vcard


출처: 잡다한 세상 블로그 (http://experience.so/9)