Monday, May 11, 2015

Investment opportunity in TravelCenters of America (NYSE:TA)

Some background information provided by the company to its investors:

TravelCenters of America (NYSE:TA) is the largest publicly-traded operator/franchisor of full-service highway Refuel-Replenish-Refresh (RRR) travel centers in the United States.

As of 31 March 2015, the Company's business included 251 travel centers, 175 of which were operated under the "TA" brand name and 76 of which were operated under the "Petro Stopping Centers" brand name located in 43 states.

TA and Petro Stopping Centers have the largest sites on average, with full-service offerings that include diesel and gasoline fuel, truck maintenance and repair, full-service and fast food restaurants, large convenience stores, car and truck parking and other services dedicated to serving professional truck drivers and highway motorists.

As of 31 March 2015, TravelCenters of America also operated 60 convenience stores with retail gasoline stations, primarily under the "Minit Mart" brand name.

When the US market opened on Thursay 7 May 2015, TA share price hit a 52-weeks record high of US$18.10 right after it announced its first quarter result. Surprisingly, right after the stock price hit this 52-weeks high, it slumped down all the way to close at US$14.98 on Friday 8 May 2015, wiping out more than one month previous price gain since its rally from March 2015 onwards.

Graph snapshotted from Google Finance

What's going on? I think The Specialist has written a nice article to explain about the situation in Seeking Alpha website titled "Oops, TravelCenters Of America Did It Again - Buy Time?" and I am pretty agreeable with his view. I'm not going to repeat the content in his article here, you can click the link and read his report if you are interested.

The diagrams about TA below are taken from NASDAQ Stock Market website.


The chart above shows that TA's revenue (US$1.407 billion) dropped a lot in first quarter of fiscal year 2015, compared with previous years in 2014 and 2013.

However, its EPS (US$0.41) recorded in the quarter increased a lot compared with previous years in 2014 and 2013. This means its profit margin actually jacked up a lot, which is the key argument point of The Specialist in his article.

When we look further to more older data...


we'll find out that TA actually used to make lost in first quarter almost every year, and its earning has a cyclical pattern which is normally weak during the 4th and 1st quarter, and will turn strong during the 2nd and 3rd quarter.

From here, we observed that:
  • TA's result in Q1-2015 is actually very impressive. It is a hefty 40 fold from previous year, not to mention traditionally it is "suppose" to make lost during this quarter.
  • Barring unforeseen circumstances, we expect TA's result in Q2 and Q3 will be better than Q1, as that is its cyclical trend for years.
In fact, we can see the institutional investors have more buying than selling of TA during this price drop after it hit 52-weeks high.


One month ago, Zacks Equity Research has written a report explaining the 3 Reasons Value Stock Investors Will Love TA, and I believe the points are still intact as of today.

So, is this really a great investment opportunity given by its price drop? You can continue to find out more facts and figures about it.


Disclaimer: This article is intended for sharing of point of view only. It is not an advice or recommendation to buy or sell any of the mentioned stock counters. You should do your own homework before trading in the stock market.

Sunday, May 10, 2015

Disabling customized ringtone in Whatsapp message notification

Recently, whenever a person in my Android phone's contact who I have set a customized ringtone sends a Whatsapp text message to me, my phone will play the ringtone as if the person is voice calling me.

This is very annoying and not a Whatsapp "feature" I want. Firstly, it really confused me as I always tought the person is calling me instead of sending Whatsapp message to me. Secondly, the ringtone MP3 is quite long to play. Imagine how frustrating to wait for it to stop everytime it plays just because a new Whatsapp message is received.

Luckily, I found the place to disable this annoyance.

To disable it in Whatsapp, go to Settings > Notifications and untick the checkbox of Contact Ringtone under Message Notifications.


This is another Contact Ringtone for Whatsapp calls which you can see when you scroll down the above screen, and I am OK with that.

If Whatsapp really want to put a feature for customized message tone, they should make use of the SMS tone instead of the call ringtone. I consider this as an annoying bug, and ought to be fixed in their next version release.

Thursday, May 7, 2015

Updated my Samsung Galaxy Tab (GT-P1000) to Storm CyanogenMod 11 with Android 4.4.4 (Kitkat) from stock firmware of Android 2.3.3 (Gingerbread)

My first generation 7" Samsung Galaxy Tab (GT-P1000) is aged, but is tough and still functioning well.

Although it only has a single core CPU, 512MB RAM and 16GB internal storage, it is still capable to handle most of the task as an Android tablet, especially with the newer firmware of Android Kitkat and above.

However, its official firmware by Samsung is stuck at the last generation Android version 2.3.3 (Gingerbread), last updated a few years ago.

Luckily, there are supporters and developers who keep working on its latest unofficial firmware. One of them is Storm31 who makes customized version of Cyanogenmod Android OS for this Samsung Galaxy Tab.

With this unofficial firmware using Android Kitkat, the Samsung Galaxy Tab runs even smoother,  more powerful and more feature rich than its latest stock Gingerbread firmware.

I have successfully updated my GT-P1000 from stock Android 2.3.3 to Storm CM11 Android 4.4.4, and I'll share with you how to do it.

First of all, backup all the data in your tab that you want to save to your PC or to its external SD card. Warning: this upgrade will wipe out everything and no user data will left behind in the tab. You better save all the data you want to save now.

Then, remove the external SD card from the tab. If you keep the SD card in the tab, the data in it might be wiped out too.

Download the following files:

GB-Stock-Safe-v5.zip contains the latest official stock firmware for GT-P1000. You'll need this in case you bricked your tab along the upgrading process. This will restore your tab back to its original state with stock firmware of Android 2.3.3 (but without any user data).

Inside it you'll also find Samsung USB driver for Windows which you need to connect your computer to your tab in order to perform the upgrade. If you have already installed the Samsung USB driver in your computer before, then you don't need to install it again.

Inside it you can also find Odin 1.7, the firmware flashing tool to flash the firmware file(s) from your computer to your tab using the USB cable.

Samsung_GT-P1000_CyanogenMod_install_all_in_one.zip contains the ClockworkMod (CwM) Recovery, the CM 9.1 firmware, and a later version of Odin 1.85.

Note that you cannot upgrade your firmware from stock Android 2.3.3 directly to CM 11. You need to replace the stock firmware with CM 9.1 first, then update it to CM 10.2, then only to the latest CM 11 or upcoming CM 12.

You need to replace the stock Recovery in the tab's ROM with ClockworkMod Recovery in order to flash the CM firmware from the SD card (either internal or external) into the tab.

cm-10.2-20131104-UNOFFICIAL-p1.zip is the firmware flash file of CM 10.2.

cm-11-20150428-UNOFFICIAL-p1.zip is the firmware flash file of CM 11. If there is a newer version than this, you can use the newer version instead of this one.

CyanogenMod Android does not come with Google Play Store and Google Play Service, that's why you need pa-gapps-modular-pico-4.4.4-20150308-signed.zip to flash the Google Play Store and Google Play Service into your tab. Once you have the Google Play Store (previously known as Market) in your tab, you can use it to install more Google apps and Android apps into it.

After you have done backup of all the data you want to save from the tab to your PC, removed the SD card from the tab, charged the tab to at least 90% battery level, and installed the Samsung USB driver, you are ready to start this upgrade process.

Step 1: Unzip GB-Stock-Safe-v5.zip in your PC.

Step 2: Power off your tab. Then hold down its Volumn Down button, at the same time, long press the Power button. Your tab will go into Download mode with screen looks like below:


Step 3: Execute Odin3 v1.7.exe inside the Odin3_v1.7 folder.

Step 4: Connect your tab to your computer using its USB cable. You should see the first box in Odin's ID:COM section turns yellow.

Step 5: Click the PIT button and select the file gt-p1000_mr.pit.

Step 6: Click the PDA button and select the file GB_Stock_Safe_v5.tar.

Step 7: Click the PHONE button. If your tab is GSM-based (Asia/Europe/Middle East/Oceania/Africa/Rest of the world...), select modem.bin inside the folder JPZ Modem. If you are an American T-Mobile user, select modem.bin inside the folder T-Mobile Modem. If you are AT&T (USA), TelCel (Mexico) or Telstra (Australia) user, select modem.bin inside JK3 Modem instead.

Step 8: Click the Start button. The flashing process will begin. Let it run until you see a green PASS! box. Do not power off your PC or your tab, or disconnect the USB cable before you see the green PASS!.

In any event you bricked your tab, you can come here and perform Step 2 to Step 8 above to bring your tab to live again.

Step 9: Your tab should reboot. If not, reboot it. The Android initial setup screen will appear, don't bother to fill in any information, just tap on Next or Skip until you reach the home screen.

Step 10: Turn off your tab. Disconnect its USB cable from PC, and put it into Download mode again (Volumn Down + Power).

Step 11: Unzip Samsung_GT-P1000_CyanogenMod_install_all_in_one.zip in your PC.

Step 12: Now you can execute the newer Odin3 v1.85.exe inside the Samsung Odin3 v1.85 folder.

Step 13: Connect your tab to your computer using its USB cable.

Step 14: Click the PDA button and select the file CF-Root-TAB7_XX_OXA_JQ1-v3.3-CWM3RFS.tar inside ClockworkMod Recovery folder.

Step 15: Click the Start button to flash ClockworkMod Recovery into your tab.

Step 16: Power off your tab. Now you can plug back the external SD card to the tab if you want.

Step 17: Reboot your tab until you get back the Android home screen.

Step 18: Set your tab USB connection to Mass Storage Mode.

Step 19: Transfer the file cm-9.1.0-p1.zip inside CyanogenMod v9.1 for Galaxy Tab GT-P1000 folder to the tab's SD card (internal/external).

Step 20: Turn off your tab. Go into Recovery mode by holding Volumn Up button and at the same time long press the Power button.

Step 21: From the Recovery menu, select Install ZIP then Choose ZIP from SD Card. Locate and select the cm-9.1.0-p1.zip file, then confirm the selection. CM 9.1 will be flashed into your tab and replace the stock firmware. Wait for the process to finish. If there is any error, repeat this step again to reflash CM 9.1.

Step 22: Reboot your tab. The Android initial setup screen will appear, don't bother to fill in any information, just tap on Next or Skip until you reach the home screen.

Step 23: Repeat Step 18 until Step 21 for CM 10.2. The file to flash this round is cm-10.2-20131104-UNOFFICIAL-p1.zip. Note that updating from CM 9.1 to CM 10.2 might not be so smooth and might need to repeat Step 21 a few times before a final success.

Step 24: Reboot your tab. The Android initial setup screen will appear. This time, you can fill in your information, and connect to your local WiFi, until you reach the home screen.

Step 25: Repeat Step 18 until Step 21 again for CM 11. The file to flash this round is cm-11-20150428-UNOFFICIAL-p1.zip.

Step 26: Finally, flash the minimal Google apps. Repeat Step 18 until Step 21 again. The file to flash this round is pa-gapps-modular-pico-4.4.4-20150308-signed.zip.

Step 27: Reboot your tab. You will find the Google Play Store appears in your home screen.

Step 28: The keyboard that comes with CyanogenMod might be too basic and primitive. I replaced it with iFlytek Voice Input for Pad which you can install from Google Play Store.

Now, you can enjoy your GT-P1000 tab with new generation of Android and the CyanogenMod experience.



Saturday, May 2, 2015

Updated the BIOS of my Lenovo Yoga 2 Pro to Version 76CN43WW

It was just shortly about a month Lenovo last released the BIOS security update Version 76CN42WW for the Yoga 2 Pro ultrabook laptop, now there is another new BIOS update Version 76CN43WW.

Lenovo informed that this BIOS for Yoga 2 Pro Version 76CN43WW release on 29 April 2015 will increase the stability of DRAM.

You can click here to go to the download page of the latest BIOS update utility for Lenovo Yoga 2 Pro.

The BIOS update is pretty straightforward. Make sure that the battery level of the laptop is at least 80%, and it is plugged on to the AC power supply. Then, run the downloaded BIOS Update Utility.

The new BIOS will be flashed with the InsydeFlash utility from Windows 8.1. After that, the system will reboot itself, and the BIOS update will be performed.
After the BIOS update completed, the laptop will reboot itself again and back to the Windows login screen.

There is no data lost for this BIOS update. Even the BIOS settings and passwords remain after the update.

Monday, April 27, 2015

Change Google Now cards temperature display from Fahrenheit to Celsius

If you have an Android smartphone with Google Now, and you would like to change the temperature display in your Google Now cards showing weather information of your favourite place from Fahrenheit to Celsius, or vice versa, I'll show you how I did it in my HTC One M8 running on Android Lollipop version 5.0.1.


Firstly, locate the 3 little dots on the top right corner of the weather card. Tap on it.

You will be asked 3 questions. The first question is whether you are interested in weather updates for the location, answer Yes, then swipe left to answer the second question.

The second question "what temperature units do you prefer?" is exactly the place for you to tell Google Now to display the temperature in Celsius or Fahrenheit.



Make your choice and then swipe left again for the third question.

Answer Yes to "continue to get weather updates". Then tap on the "X" on the right hand side of the question to return to Google Now cards screen.

Once you have answered these questions, you can find them in Google Now customize setting. To locate it, tap on the three bars on the left of Google to open the Google Now menu.


Then, tap on Customize.
Lastly, tap on "Everything Else".


You will be able to change your preference on temperature units here too.

Tuesday, April 21, 2015

Vote your survey choice for the 4 EPF proposals

The Employees Provident Fund (EPF, a.k.a. Kumpulan Wang Simpanan Pekerja, KWSP) has put up an online survey in their website at http://www.kwsp.gov.my for its members to vote for their preference to the 4 proposals they've put up.

The online survey starts from 21 April 2015 until 5 May 2015. You need to login to their i-Akaun system in order to participate in this important survey.

The 4 EPF proposals are as follow:

Proposal 1:  To raise the age for full withdrawal from current 55 to 60.

  • Option 1: To increase the minimum age for full withdrawal gradually from 55 to 60 in stages, over a 15-year period starting 2016 until 2031. The minimum age for full withdrawal to increase by 1 for every 3 years.
  • Option 2: To continue to allow for full withdrawal at the age of 55, but if you are still working and still contributing to EPF after 55, all subsequent contributions are locked in the fund until the age of retirement of 60.
What is the impact?

For option 1, your EPF money will be locked down and cannot be fully withdrawn for a longer period of time. If EPF performs badly and pays lousy dividend, you have no choice but to just accept it. Currently, you are able to make a full withdrawal of EPF at the age of 55, and you have your own choice to get a better fund manager to manage your fund, or to self manage your fund with your own investment.

For option 2, your EPF money can be set free at 55, and then zerorized and reaccumulates from 55 to 60.

Proposal 2: To collect EPF contributions from both employee and employer at the minimum amount based on the declared minimum wage. The minimum wage is currently RM900 for Peninsular Malaysia and RM800 for East Malaysia.

What is the impact?

If you are having a basic salary below the minimum wage, but total monthly income above the minimum wage after commission, your monthly EPF contributions will increase.

This means your monthly disposable income will decrease, but your total actual income will increase as your boss need to contribute more into your EPF account.

This proposal will not affect you if your basic salary is already above the level of minimum wage.

Proposal 3: To continue to pay dividend to your EPF account until the age of 100, if you don't make a full withdrawal after your age of retirement.

What is the impact?

Currently, EPF will continue to pay dividend to your EPF account until the age of 75 if your account is still active after the age of retirement.

This will be good for you if you trust EPF with your retirement fund until you die.

This will be bad for all other EPF members, as your dividend will be diluted by old folks with active EPF account.

Proposal 4: To introduce option for fully Syariah-compliant fund in addition to the existing EPF retirement scheme.

What is the impact?

The performance of the existing scheme and the new Syariah-compliant scheme might not be the same, and the effort of EPF fund managers on the 2 schemes might not be equal.

Are the members allowed to switch from one scheme to another from time to time?

If you are an EPF member, it is important to vote for your choice in this online survey, as the final decision made and enforced will have long term impact on you, your family, your children, and all subsequent generations.


Monday, April 6, 2015

Comparison table for Samsung UHD, Smart, LED and Plasma TVs

Samsung produces quite a lot of flat panel TV models, which can be categorized as the 4000, 5000, 6000, 7000, 8000, and 9000 series.

Normally, the higher the number, the more features, the better in visual and audio quality, and the higher in price too.

It is still quite difficult to compare among them, without putting them together in a same table for side-by-side comparison.

Well, I found the table below (click it to enlarge) in a booklet published by Samsung called 2014 TV Collection. Perhaps the 2015 edition will be available later in the year.


This table does not provide the full set of feature comparison, but better than none.

For normal consumer, we would probably look into whether the TV model has the following or not:
  • 3D movie support
  • Resolution (HD = 1280x720, full HD 1080p = 1920x1080, 4k UHD = 3840x2160)
  • Screen panel (normal or Ultra Clear)
  • Number of built-in HDMI ports
  • Number of USB ports
  • Built-in wireless LAN support
  • Multi-link screen (screen can split into 2: one side is the TV, another side is web browsing or app. Some models can split into 4.)
  • Sound output (standard = 2x10W, enhanced = 2x10W + woofer)
  • Dynamic dimming technology
  • Flat panel or curved panel
  • Instant on (need very short time to turn on)
  • Soccer mode
  • Voice control
  • Built-in camera and motion control
  • Smart Evolution / future ready (can be upgraded by attaching an Evolution Kit)
I think the 7000 series is a good balance between features and price.

Saturday, April 4, 2015

How to check if a merchant in Malaysia is eligible to collect GST from you

A merchant in Malaysia can only collect the goods and services tax (GST) from its customers after it has registered with the Royal Malaysian Customs Department as GST taxpayer and obtained a unique GST ID.

The merchant need to print out its company name, company full address, and GST ID on its tax invoice with serial number to its customers. The tax invoice could be a full tax invoice with customer's name and address, or a simplified tax invoice without the customer's name and address (i.e. cash sales).

If the merchant did not registered with the Royal Malaysian Customs Department as GST taxpayer, or does not issue tax invoice (either full or simplified) in valid format to its customers, it is not eligible to collect GST from the customers.

We can check for the registration detail of a GST ID in the website https://gst.customs.gov.my/TAP/_/ to ensure that the GST ID is valid and the registered merchant name belongs to the right supplier which we purchased the goods/services from.

You need to click on the "Lookup GST Status" link after you reached the screen as below:


Beside checking using GST ID, we can also check for the GST registration detail by using the merchant's business registration number or company name.

You need to click on one of the 3 radio buttons to select checking by which criteria.

Then, key in the search item and hit Enter. The result will be shown below.

I found that there are a lot of rooms of improvement for this online GST registration checking system, including:
  • This website is not mobile friendly. It lacks a mobile user interface when accessed by handphone or tablet.
  • We cannot access to the lookup screen directly, and must go through the main page and click the "Lookup GST Status" link. The system should have a direct link to reduce one step of using it.
  • Suggest to have a mobile app beside this website. The mobile app should have OCR function for us to scan for the GST ID / company name / company registration number from the tax invoice using the phone's camera, so that we don't need to manually key-in the information to perform the search.

Tuesday, March 31, 2015

Check for Malaysia goods/services price reasonability with MyKira GST app

Just before Malaysia implement Goods and Services Tax (GST) on 1 April 2015, the Ministry of Domestic Trade, Co-Operatives and Consumerism Malaysia (a.k.a. Kementerian Perdagangan Dalam Negeri, Koperasi Dan Kepenggunaan, KPDNKK) has released an Android app called MyKira GST which enable us to check for the price reasonability of over 10,000 products and services in Malaysia.

The price is checked from the online database of KPDNKK and based on the location (parliament area) of selling.

To do the checking, you need to provide the name of the product/service, which has autocomplete search while key-in.


Then, specify the weight/size/packaging information, which is also having autocomplete search during key-in.


After that, key-in the price you see, and optionally its price before GST (old price) if you remember.

Then provide the information of the shop (premise) and area (parliament). There is a map showing your current location, which can help you in identifying the area you are in.

After that, tap on the submit button to do the checking. It will show you whether the price is within reasonable range, or too expensive (out of range) accordingly.


If the price is found to be out of range, you can tap on the e-Aduan button and immediately file a complaint to KPDNKK.


You can click here to download and install the MyKira GST app from Google Play Store to your Android phone or tablet.

Monday, March 30, 2015

DIY write your own will in Malaysia for free with template download

Have you written your will? If not, are you deterred by the charges of will writing and maintenance services?

Well, the good news is, under the Malaysian Wills Act 1959, you are empowered to write your own will which is recognised as legal document, even without the need of a lawyer or professional will service provider.

So, if you believe that your will is quite unlikely to be challenged, and is very simple and straightforward, you can try DIY your own will. Otherwise, you should think about getting the professional to help you in will writing to avoid any unexpected trouble after you die.

Why you should write a will, be it DIY or drafted by professional will writer? With a valid will, when you pass away someday, you are said to die testate and your will and testament will be executed accordingly. You will be able to inform about:

  • Who should execute your will? (the executor)
  • Who shall inherit your wealth (a.k.a. estate) and what portion they will get? (the beneficiaries)
  • Who you entrust to distribute your asset? (the trustee) Before the actual distribution to beneficiaries, your asset might need to temporary parked under this name to facilitate the distribution process.
  • If both your spouse and yourself die together, who will take care of your minor children? (the guardian)
  • Do you want to donate certain portion to charity, NGO, etc.? (the special bequests)
  • How you want your funeral to be? (burial, cremation, ...) Done under ceremony of what religion? (the additional request)
  • Any last words you want to speak to your family members?
After you die testate, your executor will need to perform the following duties:
  • Locate your Will
  • Make funeral arrangement
  • Apply for a Grant of Probate (GP)
  • Call in assets
  • Pay remaining debts
  • Prepare Statement of Accounts
  • Distribute assets according to your Will
  • Carry out your wishes mentioned in your Will
 
If you die intestate without a valid will, your family members will need to:
The possible problems due to die intestate could be (and not limited to):
  • Taking longer time to process.
  • The LA is generally more expensive than the GP.
  • Might need legal services, accountants, tax consultants and other professionals arises, which could end up more costly.
  • One asset being distributed out to too many beneficiaries, which might cause problem for them to sell the asset later, as all signatures are needed when disposing the asset.
  • The guardian of your minor children is not appointed when they become orphan.
  • Your funeral might not be carried out in your preferred manner.
What do you need to write a will?
  • Yourself as the testator, who is above 18 years old, be of sound minded. If your will is written when you are sick, you might want to get your doctor to sign and certify that you are of sound minded the moment when you write your will.
  • At least 2 witnesses, who are above 18 years old. The witnesses cannot be any one from your beneficiaries.
  • Have your will hand-written or computer printed on paper, and the testator and all witnesses to sign on it.
When you die, all your loans and debts need to be settled first, before the remaining to be distributed to your beneficiaries.

If your loans and debts are unable to be settled by your assets, then your estate is insolvent, and there is nothing left to distribute to your beneficiaries. Your beneficiaries will get nothing from you, but they also need not taking care of your remaining debt.

If you are able to clear off all your financial obligations and have a solvent estate, then your beneficiaries will inherit your estate accordingly.

Now you are pretty clear about the requirement and knowledge of writing your own will. You can download this template courtesy of Struan Inc. Sdn Bhd, fill in the necessary, and get it fully signed by all of your witnesses and yourself.

Note that under the Malaysian Inheritance (Family Provision) Act 1971, your surviving spouse and/or children might be able to challenge your will if they are not agreeable with it, regardless they are stated as beneficiaries or not. If you wish to make your will unchallengeable, you should better engage the service of professional will writer to assist in your will writing.

Note: The above only applies to non-Muslim in Malaysia. There are separate laws and treatment for Muslim will writing.

Saturday, March 28, 2015

BIOS security update for Lenovo Yoga 2 Pro and Yoga 3 Pro laptops

On 27 March 2015, Lenovo has released the latest BIOS update (version 76CN42WW) for Lenovo Yoga 2 Pro ultrabook laptop.

On the same day, Lenovo has also released the latest BIOS update (version A6CN49WW) for Lenovo Yoga 3 Pro ultrabook laptop.

This latest version BIOS for Yoga 2 Pro and Yoga 3 Pro respectively fixed all merged issues from previous, and also fixed the security issues in the Intel UEFI (Unified Extensible Firmware Interface) module.

You can click here to go to the download page of the latest BIOS update utility for Lenovo Yoga 2 Pro, and click here to go to the download page of the latest BIOS update utility for Lenovo Yoga 3 Pro.

The BIOS update is pretty straightforward. Make sure that the battery level of the laptop is at least 80%, and it is plugged on to the AC power supply. Then, run the downloaded BIOS Update Utility.


The new BIOS will be flashed with the InsydeFlash utility from Windows 8.1. After that, the system will reboot itself, and the BIOS update will be performed.
After the BIOS update completed, the laptop will reboot itself again and back to the Windows login screen.

There is no data lost for this BIOS update. Even the BIOS settings and passwords remain after the update.

Thursday, March 26, 2015

Using SQLite Expert to develop and administer SQLite3 databases

SQLite is today's de facto database for mobile development, particularly as the local database used in Android and iOS apps. It is also widely used to handle data storage in embedded system.

In fact, SQLite is also a good choice for lightweight database to handle data storage and query for Windows / Linux / Mac applications. It is released in the public domain and free for use (compared with other non-free alternative such as MS Access database). It is serverless and doesn't need installation nor configuration of database system (compared with alternative such as MySQL, PostgreSQL, etc.)

Now come to the big question: how to create, develop and maintain the SQLite databases?

There are quite a number of tools available, some are free and some are non-free. I have chosen SQLite Expert for use in Windows development environment.

SQLite Expert comes in 2 editions: the free Personal Edition (free for both personal and commercial use), and the non-free Professional Edition with additional features. You can click here to find out the feature differences between the 2 SQLite Expert editions. The Personal Edition should be good enough for most SQLite application developers.

SQLite Expert is able to handle Unicode data, Views and Virtual Tables.

SQLite Expert has a nice and easy to use GUI. It even comes with Hex Editor (to edit fields with binary data) and Image Editor (to edit fields with image data).


It has a powerful visual editor for database table creation, restructuring and maintenance, which able to handle columns, indexes, foreign keys, triggers, unique and check constraints.


It also has a handy Data Definition Language (DDL) viewer to show the DDL of tables.


For the Professional Edition, you will also get a Visual SQL Query Builder, able to import and export data, Lua / Pascal scripting support, etc.

If you are in search for a good database tool for SQLite3, I strongly recommend this one to you.

Monday, March 9, 2015

Opened a CIMB AirAsia Savers Account

I am switching over my traditional CIMB savings account to a new CIMB AirAsia Savers Account for better interest rate and additional benefits that come with this online savings account.

CIMB AirAsia Savers Account is an online savings account in partnership with AirAsia. It is paperless, and you won't get any passbook nor paper monthly statement. Transaction details and online statements are available in the CIMB Clicks website.

 So, what's the big deal about this CIMB AirAsia Savers Account?

  • It offers an interest rate from 0.15% up to 1.00%. No big deal as some other banks are giving higher rate than this, but this rate is also higher than the traditional CIMB savings account or CIMB basic savings account.
  • If you maintain an average monthly balance of above RM5,000, and there is no over-the-counter transaction in that month, you will get a monthly RM5 cash rebate. Consider you are keeping RM5,000 in the account, that will translate into 5/5000 x 12 = 1.2% additional interest rate.
  • If you maintain an average quarterly balance of above RM3,000, you will get automatic entries into a Quarterly Contest to win holiday packages, complimentary flights, E-Gift Vouchers and other prizes. Every average quarterly balance of RM3,000 entitles you to one automatic entry.
  • If you maintain an average quarterly balance of above RM1,500, you will earn 250 AirAsia BIG Points quarterly. In my experience, the AirAsia BIG Points are very difficult to collect through buying air tickets from AirAsia, this seems to be a faster way to collect more points easily.
  • If you maintain an average monthly balance of above RM3,000, you will get E-Gift Voucher on your birthday month.
  • You will have priority booking benefit to grab the best deals during AirAsia sales one day before the general public.
If you already have a CIMB savings or current account, and you already have access to CIMB Clicks online banking facility, you don't even need to visit to CIMB branch in order to open a new CIMB AirAsia Savers Account, as you can do it inside CIMB Clicks. That's how I did it, and my new CIMB AirAsia Savers Account was opened instantly after I clicked the Confirm button.

To open a new CIMB AirAsia Savers Account from CIMB Clicks, just drop down the Apply For menu and select Savings Account. Then, select "CIMB Bank AirAsia Savers Account" under Product Type.


To link your CIMB AirAsia Savers Account with your AirAsia BIG Shot ID, click here.


If you need to lookup your AirAsia BIG Shot ID number, you can click here.


Click here to get more detail about CIMB AirAsia Savers Account from CIMB website.

Friday, March 6, 2015

Boost WiFi coverage with TP-Link TL-WA860RE 300Mbps WiFi range extender with AC passthrough

My TP-Link TL-WDR3600 N600 wireless dual band gigabit router is located upstairs near the center of the house, and my HiMedia Q5II Android 3D smart TV + media player box is located downstairs.

There is no problem for the HiMedia Q5II box to connect wirelessly to the TP-Link wireless router, until one day, when I streamed a 1080P full HD movie stored in my Transcend StoreJet 25A3 USB 3.0 1TB external harddisk which connected to the TP-Link wireless router with USB cable, over the air through WiFi to my HiMedia Q5II box which connected to my TV with HDMI cable. The movie didn't play smoothly on the TV.

As a result, I decided to boost my home WiFi coverage with a TP-Link TL-WA860RE 300Mbps WiFi range extender. The price of this WiFi range extender is just slightly below RM100.


I place this TP-Link TL-WA860RE downstairs near the center of the house, so that it can connect wirelessly with the TL-WDR3600 upstairs, and act as WiFi repeater to boost up the WiFi signal downstairs.


Now my HiMedia Q5II TV box is able to play 1080P full HD movie streamed from my Transcend external harddisk without problem.

Beside able to act as WiFi repeater to expand the WiFi coverage and boost up the WiFi signal, this TP-Link TL-WA860RE has one 10/100Mbps Ethernet LAN Port at its bottom, enabling it to become a WiFi bridge to wiredly connect to its network client using a LAN cable.

It also comes with an AC power passthrough socket in front, so that the power socket it plugged into is not wasted, and can still connect to electrical device up to 13 Amperes.

This TP-Link TL-WA860RE WiFi range extender is able to connect with the WiFi AP/router in either Universal or WDS mode.

The Universal mode can work with almost any kind of WiFi AP/router running at 2.4GHz frequency range. However, it might not be compatible with certain applications running in the WiFi clients.

The WDS mode is compatible with same TP-Link brand of wireless AP/router that also support WDS. It does not work with WiFi AP/router that doesn't support WDS, and it might not work well with other brand of WiFi AP/router even WDS is supported. It will not have applications compatibility issue with the WiFi clients.

Theoretically, passing of network packets in the range extender is more efficient with the WDS mode.

In order to enable WDS mode of connection, wee need to enable WDS bridging in the host AP/router and inform it about the range extender's SSID, MAC address and encryption method.


You can access to the web-based admin page of the TP-Link TL-WA860RE WiFi range extender by pointing your web browser's URL to http://tplinkrepeater.net/ or http://192.168.0.254 .

You must also provide the SSID and MAC address of the host AP/router information to the range extender.



When the SSID of the range extender is set to be the same with the WiFi AP/router, your mobile devices will automatically switch over to the WiFi provider with the stronger signal at its location. However, you might face problem of the mobile device keeps on connecting and disconnecting, switching from one WiFi provider to another, at the area where their signal are about equal strength.

You can also set the SSID of the range extender to be different from the WiFi AP/router. This will give you easier control over your mobile device to manually decide which WiFi provider it should connect to. Your mobile device is still able to automatically switch over to SSID with stronger signal when its WiFi connection with current connected provider is too weak to maintain the link and transmit data.

The wireless security setting must pair with the same setting in the host AP/router.



The TP-Link TL-WA860RE WiFi range extender also has a WPS button to pair with the host WiFi AP/router easily. However, this will connect it to its upstream AP/router using the universal mode instead of WDS mode.

One drawback of using WiFi range extender is that, its wireless connection is designed to work in half-duplex mode. This mean it cannot "talk" with the host AP/router and the wireless client at the same time. To relay the data over the air, it first talk with the transmitting wireless device, and then talk with the target device to pass the data on. Therefore, although the TP-Link TL-WA860RE supports wireless throughput of up to 300Mbps, when working in wireless repeater mode, the bandwidth is shared between the data sending and target devices, so each of them will get a throughput of around 150Mbps only.

On the other hand, when the TL-WA860RE is working in wireless bridge mode whereby one of the device is connected wirelessly and another device is connected through LAN port, the device connected wirelessly will get the maximum throughput of 300Mbps, while the one connected with LAN cable will get a maximum throughput of 100Mbps. The effective maximum connection bandwidth will be limited to 100Mbps, which is the highest at its Ethernet LAN port.

Bear in mind that the actual connection speed depends on the lowest supported connection speed of the 2 connected devices. Over the air, the wireless connection speed is further reduced over distance, physical blockage and signal interference with other wireless devices (such as neighbours' WiFi, cordless phone, Bluetooth devices, etc.) around the area.

Wednesday, March 4, 2015

Foto-Cheatcard: simple chart explained the photographing effect of F-number, Shutter Speed and ISO settings

This is an amazing diagram that can let everybody instantly understand the photographing effect of the various F-number (aperture ratio), Shutter Speed and ISO settings.


These 3 settings are the basic of photography. With this Cheatcard and some practices with the camera, new learners can soon master the trick of using their DSLR.

This Foto-Cheatcard is from a German photography blog called Hamburger Fotospots. You can click here to download its latest version in both PDF and JPG format.


Friday, February 27, 2015

Make your Windows PC into WiFi hotspot with open source Virtual Router

Have you been to a place (such as hotel room, meeting room, training room, etc.) where no WiFi service is available, and instead LAN connection is available for Internet access, and you need to connect a number of your gadgets (such as handphone, tablet, etc.) to the Internet?

With the Virtual WiFi and Wireless Hosted Network features introduced in MS Windows 7 (also available in its successor Windows 8 as well), you are able to make your laptop or PC with wireless network card into a WiFi hotspot to share its Internet access with other WiFi connected devices (computer, handphone, tablet, printer, camera, etc.)

Virtual Router by Chris Pietschmann is a small Windows application that make use of this Virtual WiFi and Wireless Hosted Network features in Windows 7 and above, to provide a very simple and fool proof way for you to make your laptop (or PC with wireless network card) to be the WiFi hotspot. It is open source and free for download and use under Microsoft Public License (Ms-PL).

With Virtual Router, you can wirelessly share any Internet connection (WiFi, LAN, Cable Modem, Dial-up, Cellular, etc.) of your computer with any WiFi device (Laptop, Smart Phone, iPod Touch, iPhone, Android Phone, Zune, Netbook, wireless printer, etc.) These devices connect to Virtual Router just like any other WiFi access point, and the connection is secured using WPA2 encryption.

This small application is so easy to use that, you just need to define your desired SSID and password, and select the network interface to share the Internet access, then click the Start Virtual Router button.


Connected devices will be shown in the Peers Connected panel.

The device will be connected with WPA2 data encryption, and get a DHCP assigned IP address.


Click here to go to the download webpage of Virtual Router.

Wednesday, February 25, 2015

10 things you should never say during presentations

Mr. Boris Veldhuijzen van Zanten shared in his blog about the 10 things you should never say during presentations, which I found is very inspiring.

Here are the 10 no-no, and I believe most of us had said some or all of such sentences in our presentations before. Watch out!

  • I’m very jet-lagged / tired / hungover
  • I’ll get back to that later
  • Can you hear me? Yes you can!
  • I can’t see you because the lights are too bright
  • Can you read this?
  • Let me read this out loud for you
  • Shut off your phone / laptop / tablet
  • No need to write anything down or take photos, the presentation will be online later
  • Let me answer that question right away
  • I’ll keep it short
Why Boris thinks that those sentence shouldn't be said during presentation? Click here to read the source article in his blog to find out more.

Thursday, February 12, 2015

Win a Samsung Galaxy S6 or HTC One M9 or LG G Flex 2 in Choose Your Own Next Gen Android Giveaway

Pocketnow is currently holding The Choose Your Own Next Gen Android Giveaway for you to win a next generation Android smartphone.

 The winner gets to choose whichever of the following phones they want:

  • Samsung Galaxy S6
  • HTC One M9
  • LG G Flex 2
It only takes one step to win: submit your email address in the giveaway website. Click here to enter The Choose Your Own Next Gen Android Giveaway website.

Official Giveaway End Date: 20 March 2015 11:59pm (PST)

Sunday, February 8, 2015

EPF declared 6.75% dividend for 2014

The Employees Provident Fund (EPF, a.k.a. Kumpulan Wang Simpanan Pekerja, KWSP) Board, with the approval of the Minister of Finance, has just announced a dividend rate of 6.75% and RM39.08 billion gross investment income for financial year ended 31 December 2014, which is an increase of 11.66% compared with RM35.00 billion in 2013.

The 6.75% dividend amounted to a total payout of RM36.66 billion where RM5.41 billion was required to pay every one per cent of dividend rate for 2014. This was 10.53% higher compared with RM4.91 billion paid for every one per cent dividend rate for 2013, in tandem with the rise in contributors’ savings.
 
EPF global investments, forming 23% of total assets, had contributed 33% towards their total income for 2014.
 
The 2014 gross investment income was mainly driven by Equities in the domestic and global markets covering both emerging and developed countries. The asset class recorded an investment income of RM22.91 billion in 2014, up 17.37% compared with RM19.52 billion in 2013, and contributed 58.63% to the total gross investment income in 2014. Almost half of the income of the equity investment is derived from EPF’s global portfolios.

Majority of the EPF’s investment assets were placed in low risk fixed income instruments as this asset class provided a stable stream of income in the long run.
 
Loans and Bonds contributed RM7.57 billion in income, compared with RM7.51 billion in 2013. This rise was attributed to the performance of the global portfolios by both internal and external fund managers. Malaysian Government Securities and Equivalents recorded RM6.59 billion in income, registering a rise of 6.14%, compared with 2013. Meanwhile, Money Market Instruments posted an income of RM619.65 million.
 
Real Estate and Infrastructure contributed RM1.39 billion in investment income in 2014. This inflation-linked asset class, which the EPF has started invested in since 2010, has over the years been showing encouraging performance and is a 22.31% increase from 2013.
 
As at 31 December 2014, the EPF’s total investment assets stood at RM636.53 billion, up 7.91% from RM589.87 billion in 2013.
 
 

Monday, January 26, 2015

Updated the BIOS of my Lenovo Yoga 2 Pro laptop to Version 41

Lenovo has just released a new BIOS update for Lenovo Yoga 2 Pro laptop (version 76CN41WW) on 20 January 2015.

I have just updated the BIOS of my Lenovo Yoga 2 Pro laptop from Version 38 to this latest Version 41.

You can download the latest BIOS update utility of Lenovo Yoga 2 Pro from their support website here.

The Lenovo BIOS Update Utility requires the laptop to be plugged on to the AC power supply before it proceed with the BIOS updating action.

The new BIOS will be flashed with the InsydeFlash utility from Windows 8.1. After that, the system will reboot itself, and the BIOS update will be performed.

After the BIOS update completed, the laptop will reboot itself again and back to the Windows login screen. This is much better than the previous Version 38 update which ended in a blank screen with keyboard backlit on.

There is no data lost for this BIOS update. Even the BIOS settings and passwords remain after the update.

Wednesday, January 21, 2015

The most effective way to contact with Maybank customer service is Facebook

If you want to contact with Maybank customer service to get help regarding your banking enquiry or problem with them, what would you do?

Go to the Customer Service page of Maybank2u website and fill in the form? You are very likely to end up with an error message after you clicked the Submit button, and your message is not sent.

Make a phone call to their customer service hotline number? You are very likely to be kept waiting for a long period of time, and need to be extremely patient to wait for somebody to pick up your call.

Email to them? I couldn't find any official customer service email published in their current Maybank2u website.

I finally found the most effective way, which is to write message to their official Facebook account. You can do so by sending private message to Maybank with this link: https://www.facebook.com/messages/Maybank

I got their Facebook PM reply within 15 minutes after I sent my message to them, and they also responded to each subsequent interaction within 15 minutes too. I got my problem solved after a few message sending and reply. The problem solved within 1 hour from my 1st message to them.

Well, if you are not still attended after PM to them, you can try leaving a comment in their Facebook page. The URL is: https://www.facebook.com/Maybank

Friday, January 16, 2015

Fixed Samsung Galaxy Note 8 battery fast draining problem

My Samsung Galaxy Note 8 is using Digi data plan to access the Internet.

Since last week, its battery was draining very fast. Battery Monitor Widget Pro showed that even when it is idle and not in use, it lost battery charge at the rate of around 3.5% per hour. Within half a day, 50% of its battery drained off from fully charged, even when not in use!


The Statistics screen in Battery Monitor Widget Pro told me that it was the Android System that drained a lot of battery, but I need more detail to nail down the root cause.

I finally found the culprit with Better Battery Stats. In its Kernel Wakelock screen, I discovered the ril-fd wakelock was keeping my tablet awake most of the time, and it hardly gone into Deep Sleep mode.

A search in the Internet told me this ril-fd wakelock is related to a feature called Fast Dormancy, and it seems that some sort of flaw in Digi base station network has caused this Fast Dormancy feature to drain off battery in my tablet.

Finally, I managed to turn Fast Dormancy off by using FastDormancy Toggle for i9300. Yes, my Samsung Galaxy Note 8 is N5100, but this app seems to work well with other Samsung mobile devices running on Android 4.x as well.

In order to use FastDormancy Toggle for i9300, your Samsung mobile device need to be rooted. After toggling the Fast Dormancy on/off, you need to restart the device and charge the battery up to 100%.

Now, My Samsung Galaxy Note 8 is back to normal, draining battery at the rate of around 0.27% per hour when not in use.


I am running on stock ROM with build number KOT49H.N5100XXDNJ2 (Android version 4.4.2). It is rooted, as I need to gain back full access to its SD card. Now, the root access also enables me to toggle the Fast Dormancy feature to get rid of battery draining problem.

Thursday, January 15, 2015

Malaysian International Passport renewal fee reduced

There is news that effective 15 January 2015, the renewal fee for Malaysian International Passport has been reduced to as follow:

  • Citizen of age between 13-59: RM200 (old rate: RM300)
  • Children below the age of 12: RM100 (old rate: RM150)
  • Senior citizen above the age of 60: RM100 (old rate: RM150)
  • Student below 21 years old with proof to study abroad: RM100 (old rate: RM150)
  • Handicapped or disabled citizen: Exempted (was also exempted)
The Malaysian International Passport is valid for 5 years from the date of issue. There will be no new issuance of Malaysian International Passport with 2 years validity.

Friday, January 9, 2015

Auspicious dates for housewarming, open house, party, gathering, etc. in 2015

Here is the list of auspicious dates in 2015 for organizing and hosting meet-up with friends and/or relatives (会友), which is produced based on the Chinese almanac Tong Shu.

The dates are applicable for housewarming, open house, home party, gathering, potluck, and any other similar functions to meet up with friends and/or relatives. (Click the image to enlarge)


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Auspicious dates for baby first haircut (Mundan) in 2015

In many culture, religion and/or tradition, the first haircut of a baby is considered an important milestone for his/her life. The day is known as Mundan, Chadakarana, Halaqah, Upsherin, etc.

Here is the list of auspicious dates for baby first haircut in year 2015, which is produced based on the Chinese almanac Tong Shu. (Click the image to enlarge)


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Auspicious dates in 2015 for getting a baby

Here is the list of auspicious dates in 2015 for getting a baby (求嗣), which is produced based on the Chinese almanac Tong Shu.

The dates have good element(s) to embro/faetus. Traditionally, the dates are referred for conception planning (making love and expecting a baby to the family). Nowadays, people also make reference to them for Caesarian delivery of new born.


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Thursday, January 8, 2015

Auspicious dates for opening business in 2015

Here is the list of auspicious dates for opening business in year 2015, which is produced based on the Chinese almanac Tong Shu. It can be applied to new business opening, or reopening of business after a break/holiday. (Click the image to enlarge)


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Auspicious dates for signing contract, register for marriage, etc. in 2015

Here is the list of auspicious dates in year 2015 for signing contract, signing offer letter, register for marriage, receiving religious baptism, and other similar agreement-related activities. It is produced based on the Chinese almanac Tong Shu.


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Auspicious dates for starting new job / post / assignment in 2015

For employees, especially those in leading/managing position, here is a list of auspicious dates  in 2015 for starting new job/post/assignment, including joining new company, which is produced based on the Chinese almanac Tong Shu.

It can be applied to first day reporting to new company/department/office/position, go for the post to lead/manage a new business unit/team/project/programme. It can also be applied to assuming new job position after promotion/restructuring/relocation exercise.

Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Using Winmail Opener to open attachment in winmail.dat file

If somebody sent you email with attachment using the old MS Outlook 97 or 2000, the attachment might probably appear in your email client as a winmail.dat file.

You can use the free Winmail Opener utility to extract the email attachment from this winmail.dat file.

The process is pretty simple. Just drag-and-drop the winmail.dat file into Winmail Opener's window, its content will be shown. Alternatively, you can also click the "Open file..." link in Winmail Opener and select the winmail.dat file.



Then, just drag-and-drop the attachment from Winmail Opener to your Desktop.

Click here to download and install the free Winmail Opener utility. It is freeware for both commercial and personal use.



Wednesday, January 7, 2015

Auspicious dates for marriage proposal or engagement in 2015

Before becoming the life partner, marriage is proposed by lover and engagement is made.

Here is the list of auspicious dates for marriage proposal or engagement in year 2015 (year of Goat), which is produced based on the Chinese almanac Tong Shu. (Click the image to enlarge)



Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

Good luck in getting your right life partner.

Auspicious dates for moving to new house/office in 2015

Here is the list of auspicious dates for moving to new house/office in year 2015, which is produced based on the Chinese almanac Tong Shu. (Click the image to enlarge)



Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

If you are going to move to a new home, don't forget to visit the "home idea" section of my blog to find out my sharing on mortgage, renovation, furnitures, electrical appliances, pest control, etc.

Auspicious dates for renovation in 2015

Here is the list of auspicious dates for renovation in year 2015, which is produced based on the Chinese almanac Tong Shu. (Click the image to enlarge)


Bear in mind that although the Tong Shu is a compilation of Chinese astrology and calendaring studies gathering wisdom of thousands of years, we should use it wisely and rationally, but not be too superstitious on it.

If you are going to renovate your house, don't forget to visit the "home idea" section of my blog to find out some of my sharing there.

Hint: Click on the "Older Posts" link to continue reading, or click here for a listing of all my past 3 months articles.