Thread: How to access SMS database in Sailfish?
View Single Post
jbrooks is offline jbrooks
2013-12-02 , 20:24
Posts: 4 | Thanked: 45 times | Joined on Dec 2013
#6
I maintain the messaging stack for Jolla, so there are some pointers I can give here..

Originally Posted by merlin1991 View Post
The access layer for messages isn't tracker but libcommhistory, tracker just happens to be the storage engine on the N9

libcommhistory is part of the nemo middleware layer so it can be used on Sailfish aswell, see https://github.com/nemomobile/libcommhistory/

I've started working on an Harmattan exporter (to CSV) and Sailfish importer, the exporter is finished, but the importer isn't there yet.
The code lives on github: https://github.com/merlin1991/Harmattan-SMS-Boat
Correct. Nemo and Sailfish use libcommhistory (as did the N9), but we use a sqlite database instead of tracker. libcommhistory has an import/export tool for backup, but I would strongly recommend not using that between a N9 and Jolla. Things will break. I'd love to get some good text-based import/export tools in there instead. VMessage support would be especially interesting.

Your CSV exporter looks like a great start. For importing, use /org/freedesktop/Telepathy/Account/ring/tel/account0 as the localUid. Use a GroupModel to create one group per unique phone number, and then an EventModel to create events. Make sure to set the right groupId on events.

I wouldn't recommend trying to import IM messages from the N9.

Originally Posted by miqu
Back in the day, I actually transferred all my messages from my N900 to my N9. So now there are well over 20000 messages on my N9. I think this time I will not import them as the database gets a bit large because of that import.

Unless some of you guys tells me to put Jolla to the test.
Please don't - Performance will get really bad right now. There are changes going into the next update(s) that make it fast for several hundred thousand messages, but right now it's pretty bad.
 

The Following 28 Users Say Thank You to jbrooks For This Useful Post: