Active Topics
-
Porting apps to Leste (29)
to Maemo 7 / Leste by Arno_11 - 5 days, 18 hrs ago -
Install Fonts in N900 (68)
to Maemo 5 / Fremantle by teroyk - 6 days, 21 hrs ago - more...
 |
|
2010-02-26
, 23:10
|
|
Posts: 28 |
Thanked: 58 times |
Joined on Jan 2010
|
#2
|
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
Last edited by jvesiluoma; 2010-02-26 at 23:11. Reason: ...
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
Last edited by jvesiluoma; 2010-02-26 at 23:11. Reason: ...
|
|
2010-04-01
, 10:18
|
|
Posts: 70 |
Thanked: 6 times |
Joined on Dec 2009
|
#3
|
Hi,
does it work with Chat also?
does it work with Chat also?
|
|
2010-04-03
, 16:45
|
|
Posts: 197 |
Thanked: 25 times |
Joined on Apr 2010
@ Europe
|
#4
|
Hmm wondering why it isn't possible to download the SMS via Bluetooth.
I would like to use tools like BluephoneElite :-/
I would like to use tools like BluephoneElite :-/
|
|
2010-04-21
, 04:58
|
|
Posts: 3 |
Thanked: 0 times |
Joined on Apr 2010
|
#5
|
Originally Posted by jvesiluoma
Hi, Jarkko!
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
I did it; I'm unable to find the output.html file
Pls help me to find it.
Regards,
|
|
2010-04-21
, 05:16
|
|
Posts: 328 |
Thanked: 101 times |
Joined on Dec 2009
|
#6
|
Originally Posted by avazkhan
Never know this command, but I will assume the command works, you need to type at the end
Hi, Jarkko!
I did it; I'm unable to find the output.html file
Pls help me to find it.
Regards,
sqlite ....... > /home/user/output.html
then for sure you could find the output.html under /home/user
|
|
2010-04-21
, 05:48
|
|
Posts: 104 |
Thanked: 2 times |
Joined on Feb 2010
|
#7
|
Sorry I did the above but i received this in X Terminal:" sh: sqlite:not found"
please help
please help
|
|
2010-04-21
, 05:53
|
|
Posts: 3 |
Thanked: 0 times |
Joined on Apr 2010
|
#8
|
Dear Ali,
You have to concern about white spaces.
Specially I think you have typed "sqlite" while it is "sqlite3".
You have to concern about white spaces.
Specially I think you have typed "sqlite" while it is "sqlite3".
|
|
2010-04-21
, 05:56
|
|
Posts: 66 |
Thanked: 30 times |
Joined on Feb 2010
|
#9
|
there is an app in extras that will export the database to csv format. I believe it is called glogarchive.
|
|
2010-04-21
, 06:01
|
|
Posts: 3 |
Thanked: 0 times |
Joined on Apr 2010
|
#10
|
Dear tirtawn;
I found it in file:///home/user!
thanks
I found it in file:///home/user!
thanks
Any ideas how to export or save the files to my computer will be greatly appreciated !!!