We have moved to a new Sailfish OS Forum. Please start new discussions there.

SMS : ability to copy / store them to an excel, csv, file

asked 2014-02-09 18:56:36 +0300

spw gravatar image

updated 2015-01-23 14:12:50 +0300

eric gravatar image

Would be nice to have an ability, on the "jolla pc/mac suite" that allows you to copy all the messages to one file from the phone, easily, and effectively. For some, this would be an awesome and already missing ability from other phones, and because I tend to save or store them on my hard drive to transfer them automatically to my excel is just perfect.

Please add this option, if possible!

UPDATE: I remember old NOkia suites having a program inside of it where you could easily export all the data to a CSV file. All the numbers, and text in different columns.

edit retag flag offensive close delete

1 Answer

Sort by » oldest newest most voted

answered 2014-02-11 22:20:20 +0300

Martijn gravatar image

updated 2014-02-11 22:45:08 +0300

At the moment you can do an export yourself by accessing the communication history database.

You can find the commhistory database in /home/nemo/.local/share/commhistory.

You can then use sqlite3 commhistory.db to export all events with the following commands:

sqlite> .headers on
sqlite> .mode csv
sqlite> .output SMS.csv
sqlite> select * from events;
sqlite> .output stdout

You can add "where type=2" to filter all SMS messages.

I hope this is off some help for now.

edit flag offensive delete publish link more


This definitely is helpful, thanks a lot for this. :)

spw ( 2014-02-12 06:42:47 +0300 )edit

To filter SMS messages to the output:

sqlite> select * from events where type=2;

To filter MMS messages to the output:

sqlite> select * from events where type=6;

To quit:

sqlite> .quit
jovirkku ( 2014-12-08 17:42:44 +0300 )edit
Login/Signup to Answer

Question tools



Asked: 2014-02-09 18:56:36 +0300

Seen: 2,522 times

Last updated: Feb 11 '14