How to import/export conversations in rtcom-eventlogger/SQLite on N900?
 

I know that on the N900 conversations are stored in ~/.rtcom-eventlogger/el.db but I'm wondering how to export and import via the SQLite shell.
(Asking because a friend of mine accidentially deleted her Conversations thread with me and would like to have it back.)

Anybody having an idea?

Re: How to import/export conversations in rtcom-eventlogger/SQLite on N900?
 

After the initial Events table dump, there are a few problems that can be solved by an awk script. First off, you'll have to generate unique integers that won't conflict with her primary key 'id' field. Secondly, all the 'local' and 'remote' values need to be swapped.

On your n900:

sqlite3 ~/.rtcom-eventlogger/el-v1.db
.mode insert
.output ~/.rtcom-eventlogger/friend.txt
select * from Events where remote_uid == '<friend remote_uid>';
<ctrl-d>
sed -i 's/ table / "Events" /' ~/.rtcom-eventlogger/friend.txt

Apply awk script to friend.txt

On her n900:

sqlite3 ~/.rtcom-eventlogger/el-v1.db
.read friend.txt
<ctrl-d>
killall rtcom-messaging-ui


EDIT: see above in red

Re: How to import/export conversations in rtcom-eventlogger/SQLite on N900?
 

Oops, for some reason the insert mode didn't properly dump the table name. See above for the edit.