![]() |
2010-05-01
, 08:28
|
Posts: 33 |
Thanked: 10 times |
Joined on Feb 2010
|
#22
|
![]() |
2010-05-01
, 08:42
|
Posts: 104 |
Thanked: 2 times |
Joined on Feb 2010
|
#23
|
![]() |
2010-05-01
, 10:24
|
Posts: 66 |
Thanked: 30 times |
Joined on Feb 2010
|
#24
|
![]() |
2010-05-04
, 10:52
|
Posts: 16 |
Thanked: 8 times |
Joined on Jan 2010
|
#25
|
![]() |
2010-05-05
, 10:32
|
Posts: 66 |
Thanked: 30 times |
Joined on Feb 2010
|
#26
|
![]() |
2010-05-09
, 12:13
|
Posts: 276 |
Thanked: 109 times |
Joined on Dec 2009
@ Vancouver,Canada / Dubai,UAE
|
#27
|
![]() |
2010-08-02
, 02:16
|
Posts: 4 |
Thanked: 0 times |
Joined on May 2010
|
#28
|
Hi,
Maybe this helps.
Note: Make backups first. I will not take any responsibility if you brick your device. It's your own responsibility.
1. Open terminal
2. give following command:
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='xxxxxxxxxxxx' order by start_time DESC;" > output.html
3. xxxxxxxxxxxx in above command is the phone number of the contact. For example you want to save conversations with the person that phone number is 1234567890 the command would be:
sqlite3 -html /home/user/.rtcom-eventlogger/el.db "SELECT service_id,event_type_id,free_text, remote_uid FROM Events WHERE remote_uid='1234567890' order by start_time DESC;" > output.html
Now you should have output.html file that has conversation in HTML format. Now you just need to transfer that file to your computer via USB for example.
You can see additional output modes by giving following command in terminal and replacing -html with something else like -csv or -column for example.
sqlite3 --help
Hope it helps.
Regards,
Jarkko
![]() |
2010-08-02
, 04:04
|
|
Posts: 3,159 |
Thanked: 2,023 times |
Joined on Feb 2008
@ Finland
|
#29
|
![]() |
2010-08-03
, 18:23
|
Posts: 4 |
Thanked: 0 times |
Joined on May 2010
|
#30
|
now how can I merge 2 files and import it again from the pc excel sheet to my n900.
I want to merge 2 messages backup in 1 and import it again to my n900. please help