|
2011-07-26
, 09:47
|
Posts: 908 |
Thanked: 501 times |
Joined on Sep 2010
@ West Sussex, England
|
#22
|
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.
|
2011-07-26
, 12:21
|
Posts: 73 |
Thanked: 9 times |
Joined on May 2010
@ London
|
#23
|
/home/user/.rtcom-eventlogger/el-v1.db
|
2011-07-26
, 12:29
|
Posts: 908 |
Thanked: 501 times |
Joined on Sep 2010
@ West Sussex, England
|
#24
|
The messages database for N900 is located here
I have used SQLite Expert in the past to read from Events table in the database which holds calls and messages records.Code:/home/user/.rtcom-eventlogger/el-v1.db
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.
|
2011-07-26
, 12:42
|
Posts: 249 |
Thanked: 277 times |
Joined on May 2010
@ Brighton, UK
|
#25
|
|
2011-07-26
, 12:54
|
Posts: 908 |
Thanked: 501 times |
Joined on Sep 2010
@ West Sussex, England
|
#26
|
|
2011-07-26
, 16:41
|
Posts: 908 |
Thanked: 501 times |
Joined on Sep 2010
@ West Sussex, England
|
#27
|
|
2011-07-27
, 07:50
|
Posts: 908 |
Thanked: 501 times |
Joined on Sep 2010
@ West Sussex, England
|
#28
|
|
2011-07-27
, 11:24
|
Posts: 73 |
Thanked: 9 times |
Joined on May 2010
@ London
|
#29
|
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.
The Following User Says Thank You to t4ure4n For This Useful Post: | ||
|
2011-07-27
, 14:21
|
Posts: 908 |
Thanked: 501 times |
Joined on Sep 2010
@ West Sussex, England
|
#30
|
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.
Graphic and Calligraphy Designer
check out my site www.afaqali.com