丁丁的blog

A couple of days ago, I just re-install Windows 7 on IBM X60 based on the flash drive, now the new buy Sandisk Ultra USB flash drive is no use now, so during the National Holiday, I just install a Live-CD type Linux on it so I can play something different with MS stuff latter.

I choose Knoppix largely because of it's size: Knoppix has the largest size among other Linux distribution like puppy/Slax as well as it's popularity, you can Get Knoppix via a BT client like µTorrent. After you get the 3.68GB DVD ISO downloaded, the step to custom Knoppix to fit your needs will be quite simple (yes simple, but it must be consider in the Linux standard):

1. Write ISO Image to flash drive, using UltraISO (I use method USB-ZIP+) or Universl USB Installer.
2. Boot it and make a persistent store, I choose AES256 crypted and size 3627MB, you should be quite to input the number as at boot time, the screen has time counting.
3. Setup the network by click the right corner of desktop applet: NetworkManager, it is quite easier to setup whether you use wirelss or wire network.
4. Due to GFW in Chinese, you have to edit the /etc/hosts by some degree and add OpenDNS (208.67.222.222) if needed. You can running Chromium to verify the internet is OK now and download a copy of host to reference/replace your version.
5. Install some additional components which can not deploy by Knoppix due to license limit: Start->Perferences->install components. (Flash and MS font, two package currently), Running Chromium again to verify the flash is install OK, before that you have to change Preference in Chromium first via chrome://settings/content, to enable Plug-ins and JavaScript first.
6. Install Chinese input method via Synapitc Package Manager (Start->Perference->Synapitc...) or via apt-get command in Accesories->Root Terminal (you may want to change background to semi trans as by default it is totally transpanrency via Edit->Perferences->Backgroud->Opacity at this moment): apt-get install scim-pinyin
7. The above command will download ttf-arphic-ukai & ttf-arphic-uming as well as scim-pinyin depend on it, to Switch to use scim input method now, you need running Start->Perference->Input Methods Switcher to "Use SCIM via IM_MODULE"

After above 7 steps, you can in fact to use Knoppix now, but you may also want to install additional software like WinRAR (very popular but not free):  you can first extract to home folder ~/, run make in ~/rar folder and put rarreg.key to /etc/ if you have a license.

I also need to use PyCharm 1.5.4 to do some Google App Engine programming, so still need manually install: (in Root Terminal running)

apt-get install sun-java6-jre

Because PyCharm say it must run Sun Java Runtime instead of Open Java Runtime, so it is need to install it first. You may also want to install some other program like qtm (blogging client) or scribes (a new text editor) at this time with similar apt-get install command.

Download the GAE SDK, current writing, I use version 1.5.4, extract to home folder first, then move to /usr/local if you want in root, you may refer to that folder after install PyCharm, but it is another topic I think.

You may also have to edit your /etc/profile to export an environment to ensure PyCharm can find the correct java run time after line 24:

PYCHARM_JDK=/usr/lib/jvm/java-6-sun/jre

export PYCHARM_JDK

Now we can download the PyCharm 1.5.4 and extract & move to /usr/local also. after that you can  run /usr/local/pycharm-1.5.4/bin/pycharm.sh to test if every thing is OK, after run that script once, you can run PyCharm by run charm directly in Start->Run dialog.

I done to setup the Knoppix by above sequence and hoping you also go smooth with this blog while setting up your personal Knoppix USB flash drive.

Many people know when drag the small black square in the lower right-hand corner of the cell in Excel, Excel will auto fill the value, fewer people know drag the small black square in right mouse-key will pop-up the context menu and let you select Copy Cells, Fill Series, or other options like below picture:

But I think the most helpful tip to fill large number of same value by Excel is double click: just double click the black square, you immediately done to fill thousands and hundreds of same value in below cells in the table!

IBM X60 is very legacy PC, very light and have active hard-driver protection but due to the hard driver AHCI mode and no CD-ROM in X60, it is really a nightmare when you plan to re-install the windows.

In fact, you can use the USB disk to install the Windows 7 very easily and fast (there is no driver problem in windows 7 for X60), so the key problem for install the Windows 7 on X60 because how to build a bootable Windows 7 installation

media on USB disk and how to successfully boot it in the X60.

First problem: you can use the UltraISO version 9.3+ version, select Bootable->Write Disk Image from the menu, using write method USB-ZIP+ to build a bootable and workable Windows 7 installation media.

Second problem: press ThinkAdvantage blue key to enter the BIOS setup UI, Config->Hard Driver->switch to ACHI interface and using enable –USB-HDD boot item in the startup menu, save and exit.

Then you will enjoy the most up-to-date Windows 7 experience on the 6 years IBM X60 now, there is no drivers installation headache in win7.

In Windows platform, most quickly way to building up the Google App Engine SDK is install ActiveStates Python 2.5.6.10 and the MSI version of GoogleAppEngine 1.5.3.

But after you finish installation and get ready to deploy your first application, you will got the very annoy error which require SSL module for python, it is very hard to find such SSL module in internet as most of the links is source code code and require you build SSL by yourself in a C++ VS2003/MingW environment.

So I just upload a version in 115 disk / local for you download. (yes, binary version so you have to trust me there is no problem)

I would like to thank XuMing and his Micolog, it’s very small blog program on GAE but functional is quite complete. Micolog is a good reference source code if you are newly to Google App Engine. There is also someone who write a article about how to upgrade the exist Micolog from Django 0.96 to Django 1.2, the article is download is broken and still have some problem about template safe notation modify here and there.

So I would like to contribute a modified version of Micolog v7.412 source code, which I spend quite several days to debug and merge the change both in the new github.com and old SVN on Google Code code repository, I also change/enhanced the feature as below:

• Update tinymce editor to version 3.9.4
• Fix IE6 can not comment bug
• Fix sys_plugin can no load error
• Minor change Pixel theme css
• Add IE9 pin site feature in Pixel
• Do some python code standard layout and import optimize
• Allow suppress logo and other not needed copyright in admin page
• Fix email notify in sys_plugin after upgrade to 1.2
• Add replay via comments
• New paging facility

The source code is also used in this blog and seems quite stable and I hope you will like it.