This is just a little note related to my last blog about Jolla. I wrote that I’m pretty fine with messaging application although I don’t have many SMS yet in my phone. Well, I fixed that 🙂 I imported all my SMS messages from the backup of my Andriod phone.
I searched around and I found really interesting thread on talk.maemo.org that describes how to import SMS from n900. As they are doing it via csv, it was easy to put together a simple one-liner that would produce the csv from my SMS database. Now how to do it…
My database used to be at /data/data/com.android.providers.telephony/databases/mmssms.db. You can get it from your phone to your PC for example with
adb pull \ /data/data/com.android.providers.telephony/databases/mmssms.db
Now download the script and get your csv
curl http://susepaste.org/view/raw/49179811 > sms_export sh ./sms_export mmssms.db > sms.csv
What is left is to fix all the extra newlines in SMS. But without fixing them, the import program just imports messages without newlines which was good enough for me as most people don’t use new lines in SMS.
Now time to play with Jolla and that part is simple thanks to Merlin1991 who wrote importer application. I will assume that your are sshed on your Jolla and and you copied your csv file over to the current directory. Now what is left on device is following:
curl http://cdnm.at/~christian/Harmattan-SMS-Boat/jollaImport \ > jollaImport chmod a+rx jollaImport ./jollaImport -s sms.csv
And SMSes are transfered from Android to Jolla 🙂 Many thanks to Merlin1991.