Thread: [Fremantle Maemo5] [Announce] Yappari - New maintainership and new features!
View Single Post
sicelo is offline sicelo
2015-01-27 , 14:20
Community Council | Posts: 680 | Thanked: 1,227 times | Joined on Sep 2010 @ Mbabane
#271
Originally Posted by Armando View Post
Would you share your db-queries with us?
In /home/user/.yappari/logs there are the different logs (sqlite databases) for each and every number you've chatted with before.

So all you need is to run the following to export a conversation to a text file:

Code:
sqlite3 /home/user/.yappari/logs/NUMBER.dblog
.output /home/user/MyDocs/ChatLog_NUMBER.txt
select data from log;
This just extracts the text, without indicating who said what (but for my needs this is enough). The different punctuation is important. For fancy queries, you will need to use
Code:
.schema log
in sqlite3 to see the different fields that are in the database.
 

The Following 4 Users Say Thank You to sicelo For This Useful Post: