Thread
:
How to import/export conversations in rtcom-eventlogger/SQLite on N900?
View Single Post
daperl
2010-10-22 , 18:58
Posts: 2,427 | Thanked: 2,986 times | Joined on Dec 2007
#
2
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
__________________
N9: Go white or go
home
Last edited by daperl; 2010-10-22 at
19:24
.
Quote & Reply
|
The Following 5 Users Say Thank You to daperl For This Useful Post:
Andre Klapper
,
Helmuth
,
misterc
,
noobmonkey
,
thp
daperl
View Public Profile
Send a private message to daperl
Find all posts by daperl