{"id":456,"date":"2015-02-27T17:52:03","date_gmt":"2015-02-27T16:52:03","guid":{"rendered":"http:\/\/hamsterhirn.de\/?p=456"},"modified":"2015-02-27T17:56:16","modified_gmt":"2015-02-27T16:56:16","slug":"how-to-import-your-sms-from-android-to-jolla","status":"publish","type":"post","link":"https:\/\/hamsterhirn.de\/index.php\/2015\/02\/how-to-import-your-sms-from-android-to-jolla\/","title":{"rendered":"How to import your SMS from Android to Jolla"},"content":{"rendered":"<p>I found a quite <a href=\"http:\/\/michal.hrusecky.net\/2014\/01\/importing-sms-from-android-to-jolla\" target=\"_blank\">nice tutorial online<\/a> that explains all the steps you have to take to do the job.<br \/>\nI couldn&#8217;t copy the mmssms.db database like he was doing it.<br \/>\nI had to change to a root shell on my android and copy it to somewhere else on the filesystem and give it other permissions to get it to my machine.<br \/>\nThe only thing I &#8222;improved&#8220; is the shell one liner (see below) export from the sqlite mmssms.db that marks the newlines in sms the correct way so the tool <a href=\"https:\/\/github.com\/merlin1991\/Harmattan-SMS-Boat\" target=\"_blank\">Harmattan-SMS-Boat<\/a> can make its job just fine.<br \/>\n<pre><code class=\"preserve-code-formatting\">\n#!\/bin\/sh\nsqlite3 &quot;$1&quot; \\\n&quot;select address,type,datetime(date\/1000, &#039;unixepoch&#039;,&#039;localtime&#039;),datetime(date\/1000, &#039;unixepoch&#039;,&#039;localtime&#039;),body from sms;&quot; | \\\nsed -e &#039;s;^\\([^|]\\+\\)|1|\\(.*\\);\\1|IN|\\2;&#039; -e &#039;s;^\\([^|]\\+\\)|2|\\(.*\\);\\1|OUT|\\2;&#039; -e &#039;\/^[A-Za-z0-9+]*|[IN|OUT]\/! s;^; ;&#039; | \\\nsed &#039;s\/|\/;\/g&#039;\n<\/code><\/pre><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I found a quite nice tutorial online that explains all the steps you have to take to do the job. I couldn&#8217;t copy the mmssms.db database like he was doing it. I had to change to a root shell on my android and copy it to somewhere else on the filesystem and give it other [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[234,239,235,231,232,238,236,237,233],"class_list":["post-456","post","type-post","status-publish","format-standard","hentry","category-it","tag-android","tag-export","tag-import","tag-jolla","tag-phone","tag-sed","tag-sms","tag-sqlite","tag-telefon"],"_links":{"self":[{"href":"https:\/\/hamsterhirn.de\/index.php\/wp-json\/wp\/v2\/posts\/456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hamsterhirn.de\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hamsterhirn.de\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hamsterhirn.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hamsterhirn.de\/index.php\/wp-json\/wp\/v2\/comments?post=456"}],"version-history":[{"count":5,"href":"https:\/\/hamsterhirn.de\/index.php\/wp-json\/wp\/v2\/posts\/456\/revisions"}],"predecessor-version":[{"id":461,"href":"https:\/\/hamsterhirn.de\/index.php\/wp-json\/wp\/v2\/posts\/456\/revisions\/461"}],"wp:attachment":[{"href":"https:\/\/hamsterhirn.de\/index.php\/wp-json\/wp\/v2\/media?parent=456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hamsterhirn.de\/index.php\/wp-json\/wp\/v2\/categories?post=456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hamsterhirn.de\/index.php\/wp-json\/wp\/v2\/tags?post=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}