E72 firmware upgrade 0.51.018 problem (No Sms tone and vibration) Solution

Upgrade my Nokia E72 to new firmware upgrade 0.51.018, because i didn't care to read before upgrading, im having an issue, sms receive without tone alert and vibration, after several Hard reset and head banging to the wall, i come with solution below :

1. Install PC Suite

1.1 Export SMS as CSV file or u can drag and drop all sms in a folder

1.2 Export MMS as MMS file by drag and drop

1.3 Export Contact as CSV

2. Open Folder Using Explorer (Basicly copy and paste whatever folder that u want)

2.1 Copy and Paste Image Folder

2.2 Copy and Paste Music Folder

2.3 Copy and Paste Video Folder

3. Format my SD Card using Phone

4. Enter *#7370# to Hard Reset

5. Done everything and test sms yourself and receive tone and vibrate

6. Manually restore every backup that u done

7. Test smsing urself again

8. Yes i know phone setting is diffrent and application need to be install one by one, but hey atleast u manage to restore your contact,sms,mms and few more folder with all function running

p/s: sms can only be restore to My Folder, incase u want to restore to inbox, do it by selecting them via phone

Hope this help

SPSS Workshop

Attending 2 SPSS Workshop on 18 November 2010 at IBM Innovation Centre

Sales Enablement Workshop for morning session and Technical Enablement Workshop for afternoon session

What is SPSS ?
im not going to describe what spss in detail
for further details please go to SPSS at wiki

There is 4 Main Categories in SPSS




(i) Statistics
- SPSS Statistics
(ii) Modeling
- SPSS Modeler
- SPSS Text Analytics
(iii) Deployment
- SPSS Decision Management
- SPSS Collaboration & Deployment Services
(iv) Data Collection
- SPSS Data Collection

Below are Document of product information on the two major core products :

i)IBM SPSS Statistics Base - full modules v19.0
ii)Modeler Premium

Download here IBM SPSS Document

any further info please proceed to www.spss.com

Think Outside the Box

Before You Think Outside the Box, Think Inside of It

"We've gotten so accustomed to thinking that ideas need to come about in new and exciting ways that we often neglect the utility of established paradigms. When crafting your ideas, first think inside the box before you look outside" - Adam Dachis

Most who think seriously about creativity agree that it entails not only novelty (that outside the box stuff) but also utility, and in order to be useful, it has to go above-and-beyond what is already known (that inside the box stuff).

"If you never venture outside the box, you will probably not be creative. But if you never get inside the box, you will certainly be stupid" - Christopher Peterson

First, Think Inside the Box [Psychology Today]

p/s: I love the article and copy paste it here to make a note for myself, this is not my writing

Previous Month Query

We always encounter this issue, how to query previous month data in sql statement
and as always we will get an easy idea, just subtract 1 from current date

example :
month(curdate())- 1

yes this is one easy way to do it, but we will encounter 1 big problem with this statement,current date month is January 2010 and the statement result for the previous month will be 0, that means your query will query month = 0 and your query will give you a null result

solution :
use interval in your query

month(curdate() - interval 1 month)
by using interval the query result is 12 when the current date month is January

this solution also apply to previous year
year(curdate() - interval 1 year)

interval unit available is
FRAC_SECOND (microseconds), SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR

this is just the basic of it, how to implement it to your query its up to you
but hey this is just my opinion, if there is any other better way please respond in comment area ^^