How to access SMS database in Sailfish?
I am trying to find a way to import my SMS'es from my N9 to my new Jolla device. By looking around the device I see that it's got a tracker DB just like N9 has, in /home/nemo/.cache/tracker/
Hence, I'd believe SMS'es are stored in tracker the same way that N9 handles them. Now, on N9 I can get my SMS'es via tracker query: tracker-sparql -q "select nie:plainTextContent(?d) where {?d a nmo:SMSMessage}" The same thing on Jolla device, however, returns nothing: [nemo@localhost ~]$ tracker-sparql -q "select nie:plainTextContent(?d) where {?d a nmo:SMSMessage}" On N9 when I grep SMS from the used classes I get the hit for it: ~ $ And on Jolla it seems to be unused: [nemo@localhost ~]$ Now, how would I get to my messages on Jolla? |
Re: How to access SMS database in Sailfish?
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 EDIT: since not everyone has a working scratchbox installation, here's a built binary: http://cdnm.at/~christian/Harmattan-SMS-Boat/smsExport (use save link as) |
Re: How to access SMS database in Sailfish?
Quote:
Code:
[sbox-HARMATTAN_ARMEL: ~/Harmattan-SMS-Boat/n9Export] > qmake |
Re: How to access SMS database in Sailfish?
Quote:
|
Re: How to access SMS database in Sailfish?
Nice Merlin1991,
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. :) |
Re: How to access SMS database in Sailfish?
I maintain the messaging stack for Jolla, so there are some pointers I can give here..
Quote:
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. Quote:
|
Re: How to access SMS database in Sailfish?
Quote:
But apart from a wikipedia entry which tells me that vMessage is specified by IrDA and that the format is most likely in their IrMC standards set I've found nothing about the format. And as usual one gets the standard only for a fee, which is 100$ in this case, so not an option for me. |
Re: How to access SMS database in Sailfish?
Quote:
I'd stick with the CSV for now - no reason to make it complicated. Although if you ever get bored and want to implement vmsg import/export in libcommhistory.. :p |
Re: How to access SMS database in Sailfish?
What would be good (but quite more complex than just import/export) is to synchronize SMS with an email account.
There is an app for Android that does that on gmail and even if it is google-only, the principle is good. SMS could just be exported/imported to an IMAP folder. MMS could also with multimedia content as attachment. |
Re: How to access SMS database in Sailfish?
Quote:
Nowdays I would not worry about the ML overhead, trying to squeeze data into too little containers is pointless on the age of memory abundance we are living :D |
All times are GMT. The time now is 05:10. |
vBulletin® Version 3.8.8