Originally Posted by afaq

N900 stores it in an SQL database. It will then need to be converted into a format Android reads.

I believe Android can import .xml files. So it's a task to convert SQL to XML with all the structure corrected.

Before you dig any more into - just saw this

http://vinodmishra.com/2009/09/how-t...droid-devices/

This is quite long winded and not sure how realistic for the no. of mssgs you have.

Originally Posted by t4ure4n

The messages database for N900 is located here

Code:

/home/user/.rtcom-eventlogger/el-v1.db

I have used SQLite Expert in the past to read from Events table in the database which holds calls and messages records.

I have also successfully exported the data from the table to CSV and Excel files.

I have asked in previous posts if anyone can give me the structure of target XML file I can write a program to do the conversion.

Originally Posted by mr_jrt

Sorry, what I meant was that you can ignore the Symbian side of it as you've already got the VMG files on the PC.

Originally Posted by richwhite

Anyone got any ideas?

protocol – Protocol used by the message, its mostly 0 in case of SMS messages.

address – The phone number of the sender/recipient.

date – The Java date representation (including millisecond) of the time when the message was sent/received. Check out www.epochconverter.com for information on how to do the conversion from other languages to Java.

type – Sent = 2, Received = 1.

subject – Subject of the message, its always null in case of SMS messages.

body – The content of the message.

toa – n/a, default to null.

sc_toa – n/a, default to null.

service_center – The service center for the received message, null in case of sent messages.

read – Read Message = 1, Unread Message = 0.

status – None = -1, Complete = 0, Pending = 32, Failed = 64.

readable_date – Optional field that has the date in a human readable format.

contact_name – Optional field that has the name of the contact.

Originally Posted by t4ure4n

I have found some information about the Android own Backup and restore + XML file format...

Fields in the XML File:

Here is some description of the fields:



hope this can be helpful