Thread: How to access SMS database in Sailfish?
View Single Post
jamar is offline jamar
2014-01-10 , 15:37
Posts: 53 | Thanked: 104 times | Joined on Jan 2011 @ Veska, Czech Rep.
#48
Originally Posted by toner_cloud View Post
...
The n900export program uses standard rtcom-eventlogger api to access SMS messages. It then replaces semicolons with colons in SMS text so it does not interfere with CSV separator, and newline with newline and space, so new lines in SMS text allways starts with space. This is required by Merlin's jollaImport to identify that these lines belongs to the same SMS message.

The Eventlogger's database is located at /home/user/.rtcom-eventlogger/el-v1.db, it's a SQLite database file, so you can just copy it to your PC and manipulate it as you like.

On Linux, you can open the database with sqlite program:
Code:
$ sqlite3 el-v1.db
And then you can print all SMS messages with query like:
Code:
sqlite> SELECT outgoing, datetime(start_time, 'unixepoch'), datetime(storage_time, 'unixepoch'), remote_uid, free_text FROM Events WHERE service_id = '3';