Importing SMS from Android to Jolla

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.