View Single Post
daperl's Avatar
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.
 

The Following 5 Users Say Thank You to daperl For This Useful Post: