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

Question

14

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

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

spw
722 ●8 ●11 ●12

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

eric

12967 ●88 ●133 ●123

https://twitter.com/erkki...

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

Accepted Answer

11

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

Martijn

260 ●6 ●8 ●12

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

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

Comments

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

spw ( 2014-02-12 06:42:47 +0200 )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 +0200 )edit

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

1 Answer

Comments

Question tools

Stats

Related questions

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

1 Answer

Comments

Question tools

Public thread

Stats

Related questions