Posts

Showing posts from November, 2010

Exporting messages and contact from Nokia Ovi Suite

With earlier Nokia PC suite versions it was easy to export your contacts or messages to an excel file, but this functionality was removed from recent Ovi Suite versions.

After some research I have found a way to export this information. I have tried it for the SMS messages, but did not do it for the contacts, that should work the same way.

First you have to syncronize the data you want to export with Ovi suite. When you do this Ovi suite is storing this data to MDataStore.db3 file which is stored in the Users\yourlogin\AppData\Local\Nokia\Nokia Data directory. This file is a SQLite 3 database and you can download a command line program from www.sqlite.org to handle it.

You start the program by sqlite3.exe nameOfYourDatabase and you get a sqlite> prompt.

The following commands will help you:

.tables - list the tables in the database
.schema tablename - list the fields in a database
.output filemane - to redirect results to a file in your computer
select * from MessageEX - to list your s…